skills.rest
devMoez
devMoezCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Build institutional DCF valuation models in Excel with live formulas.

1|Updated May 16, 2026
Search Tags:#valuation#sensitivity analysis#scenario analysis#dcf#wacc#excel modeling#terminal value
One-click install
npx skills add https://github.com/devMoez/titan --skill dcf-model-devmoez
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/devMoez/titan/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/devMoez/titan --skill dcf-model-devmoez

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and assets (resource) and references (resource) components.

What problem does it solve?

The dcf-model Skill solves the problem of building repeatable, audit-ready intrinsic value models that compute valuation using live Excel formulas instead of hardcoded arithmetic.

Core Features & Use Cases

  • Institutional DCF modeling in Excel: Creates a full DCF with revenue projections, FCF build, WACC, terminal value, and an EV-to-equity bridge.
  • Scenario planning (Bear/Base/Bull): Supports separate assumption blocks and switches projections via a scenario selector pattern.
  • Sensitivity analysis grids: Produces bottom-of-model 2D grids (e.g., WACC vs terminal growth) with full recalculation formulas in every cell.
  • Excel-author conventions compatibility: Follows the expected layout, cell styling, formulas, and sensitivity-table structure from excel-author.

Quick Start

Use the dcf-model Skill to build a DCF Excel file for your target company’s intrinsic valuation, then recalculate it to confirm the model has zero formula errors.

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 valuation model in Excel with live formulas?▼

To build a DCF valuation model in Excel with live formulas, you project revenue, construct free cash flow, calculate WACC, and bridge enterprise value to implied per-share value using spreadsheet formulas instead of hardcoded constants.

Can I generate scenario analysis for Bear, Base, and Bull intrinsic valuations?▼

Yes, you can generate scenario analysis for Bear, Base, and Bull intrinsic valuations. The model supports separate assumption blocks and switches projections dynamically via a scenario selector pattern within the Excel output.

How do I create a 5x5 sensitivity analysis grid for WACC and terminal growth in Excel?▼

You create a 5x5 sensitivity analysis grid for WACC and terminal growth in Excel by generating bottom-of-model 2D grids. The base case is centered, and every cell contains full recalculation formulas to ensure accurate sensitivity outputs.

Does the DCF Excel model output require manual recalculation to validate formulas?▼

The DCF Excel model output requires recalculation to validate formulas. The generation process includes rigorous validation to confirm the spreadsheet has zero formula errors, ensuring the enterprise value to equity bridge computes correctly.

What is the best way to calculate terminal value and WACC without hardcoding arithmetic in Excel?▼

The best way to calculate terminal value and WACC without hardcoding arithmetic in Excel is to use a generation method that expresses all valuation math as live spreadsheet formulas, ensuring audit-ready and repeatable intrinsic equity analysis.

Related Skills

Explore More Finance & Accounting Skills→
hvkshetryhvkshetry
15

dcf-model

Model revenue build-up, margin progression, WACC derivation, and terminal value for DCF valuations.

Community
Advanced
open-nekoopen-neko
11

dcf-model

Build DCF valuation models with live Excel workbooks and sensitivity tables.

Official
Advanced
vikrant-projectvikrant-project
2

lbo-model

Construct and validate Leveraged Buyout financial models in Excel.

Community
Advanced
markwang2658markwang2658
31

dcf-model

Construct discounted cash flow models in Excel with Bear/Base/Bull scenarios.

Community
Advanced