skills.rest
matparang
matparangCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

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

3|Updated Mar 18, 2026
Search Tags:#modeling#valuation#sensitivity#dcf#equity#wacc
One-click install
npx skills add https://github.com/matparang/AutoJaga --skill dcf-model-matparang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/matparang/AutoJaga/tree/main/legacy/jagabot/skills/fa-dcf-model
Command: npx skills add https://github.com/matparang/AutoJaga --skill dcf-model-matparang

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Real-world businesses often struggle to value complex companies accurately using ad-hoc spreadsheets or generic models. This skill provides an end-to-end DCF framework that guides users from data consolidation to valuation conclusions, producing a ready-to-deliver Excel workbook with transparent assumptions and documented outputs.

Core Features & Use Cases

  • Robust five-year DCF projection with Bear/Base/Bull scenarios and a single consolidation cell for scenario selection.
  • CAPM-based cost of equity, after-tax cost of debt, WACC calculations, and an explicit terminal value calculation.
  • Sensitivity analysis via embedded 3x5 grids that explore WACC, terminal growth, revenue growth, and margins, with fully recomputed DCF results.

Quick Start

Input your company data and assumptions to generate a complete DCF model in Excel, including projections, sensitivity analyses, and an executive summary.

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 DCF model with Bear, Base, and Bull scenarios in Excel?▼

DCF valuation models consolidate Bear, Base, and Bull scenarios into a single selection cell, computing intrinsic equity value across 5-year projections. This generates an Excel workbook with automated formulas, WACC, and terminal value recalculations.

What is the best way to calculate WACC and terminal value for equity valuation?▼

Calculating WACC and terminal value for equity valuation requires applying CAPM for cost of equity, adjusting debt for taxes, and projecting perpetual growth. This produces an enterprise value that bridges to equity value with documented assumptions.

Can I run sensitivity analysis on WACC, terminal growth, and margins within a DCF projection?▼

Yes, DCF sensitivity analysis uses embedded 3x5 grids to explore WACC, terminal growth, revenue growth, and margin fluctuations. This recomputes intrinsic valuation results automatically to show how assumption changes impact equity value.

Does openpyxl support automated formula recalculation for DCF models?▼

Openpyxl supports automated formula recalculation in DCF models by writing live formulas for NOPAT, D&A, CapEx, and NWC into Excel. Validation scripts ensure the workbook recalculates projections and sensitivity grids correctly.

How do I create an enterprise value to equity value bridge in a 5-year financial projection?▼

Creating an EV to Equity bridge in a 5-year financial projection involves subtracting net debt from enterprise value. This DCF process calculates NOPAT, discounts free cash flows by WACC, and outputs the final equity valuation in Excel.

When do I need to include NWC and CapEx adjustments in a DCF valuation?▼

NWC and CapEx adjustments are needed in DCF valuations when computing unlevered free cash flow from NOPAT and D&A. Including these cash flow components ensures the intrinsic equity value reflects reinvestment requirements accurately.

Related Skills

Explore More Finance & Accounting Skills→
modelscopemodelscope
4.4k

Creating Financial Models

Build financial valuation models with DCF, sensitivity analysis, and Monte Carlo simulations in Excel.

Official
Advanced
kiryteokiryteo
1

dcf-model

Construct Discounted Cash Flow models from SEC filings and analyst reports.

Community
Advanced
severin-yeseverin-ye
3

Stock Valuation

Estimates intrinsic stock value using DCF, comparable analysis, EV/EBITDA, and residual income methods with explicit assumptions.

Community
Advanced
644408071-design644408071-design
1

valuation-model

Apply DCF, DDM, SOTP, and relative valuation techniques for company analysis.

Community
Advanced