skills.rest
SriRamkunamsetty
SriRamkunamsettyCOMMUNITY
Explore all skills by this author →
𝕏@SriRam41258GitHub

dcf-model

Construct Excel DCF models with 5-year projections and sensitivity analysis.

Updated May 20, 2026
Search Tags:#excel#modeling#valuation#sensitivity#dcf#wacc#bear-base-bull
One-click install
npx skills add https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent --skill dcf-model-sriramkunamsetty
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent/tree/main/hermes-agent/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent --skill dcf-model-sriramkunamsetty

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

Builds institutional-quality DCF valuation models in Excel with live formulas, ensuring auditable outputs and repeatable workflows.

Core Features & Use Cases

  • Live Excel-based DCF model with 5-year projections, terminal value, and sensitivity analysis
  • Three-scenario Bear/Base/Bull framework with consolidation columns for clean auditing
  • Automated validation, clear documentation, and easy recalc using the included script

Quick Start

Open the DCF workbook, input the core assumptions (revenue growth, margins, WACC, and terminal growth), and let the model generate the valuation outputs.

Frequently Asked Questions about dcf-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a discounted cash flow model in Excel with Bear Base Bull scenarios?▼

Build a discounted cash flow model in Excel by inputting revenue growth, margins, WACC, and terminal growth to generate 5-year projections, terminal value, and automated Bear/Base/Bull valuations.

How does CAPM-based cost of equity integrate with WACC calculations in a DCF model?▼

CAPM-based cost of equity integrates with WACC calculations by enforcing strict modeling discipline, ensuring the terminal growth rate remains lower than the WACC for valid valuation outputs.

What is the best way to automate DCF valuation and sensitivity analysis in Excel?▼

Automate DCF valuation and sensitivity analysis in Excel using an included Python script with openpyxl, which enforces consistent tax treatment and recalculates institutional-grade outputs.

Can I use openpyxl to generate live formulas for terminal value calculations in Excel?▼

Yes, you can use openpyxl to generate live formulas for terminal value calculations, ensuring the DCF workbook maintains auditable outputs and repeatable recalculation workflows.

Does the DCF model support three-scenario consolidation for clean auditing?▼

The DCF model supports three-scenario consolidation by providing Bear/Base/Bull framework columns, ensuring clear documentation and clean auditing for institutional equity valuations.

Related Skills

Explore More Finance & Accounting Skills→
matparangmatparang

dcf-model

Construct a five-year DCF model with Bear/Base/Bull scenarios and generate an Excel output.

Community
Advanced
pynbj1001pynbj1001
4

dcf-model

Automate end-to-end equity valuation with DCF scenarios and Excel outputs.

Community
Advanced
ZardLi1115ZardLi1115
4

dcf-model

Generate Excel DCF valuation models with Bear/Base/Case and sensitivity tables.

Community
Advanced
sammyTIsammyTI

dcf-model

Build detailed DCF valuation models with financial projections and sensitivity analysis.

Community
Advanced