dcf-model

Automates end-to-end DCF valuation modeling with Excel outputs.

1|Updated Jan 30, 2026
One-click install
npx skills add https://github.com/bdschi1/excel-model-eval --skill dcf-model-bdschi1
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/bdschi1/excel-model-eval/tree/main/references/fsp-skills/skills/dcf-model
Command: npx skills add https://github.com/bdschi1/excel-model-eval --skill dcf-model-bdschi1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Complex, end-to-end DCF valuation modeling is time-consuming and error-prone. This skill provides a disciplined framework to create institutional-quality cash flow models, compute WACC, run sensitivity analyses, and deliver consistent output for equity valuation.

Core Features & Use Cases

  • Automates the full DCF workflow from data retrieval and validation to projection, discounting, and terminal value calculation.
  • Generates sensitivity analyses and a client-ready Excel model with clear documentation and assumptions.
  • Use cases include equity research, investment banking prep, and intrinsic value assessments for M&A or portfolio decisions.

Quick Start

Install and run the DCF model builder against your input data to generate a fully populated valuation workbook.

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 for equity valuation?

DCF valuation requires projecting multi-year cash flows, computing a CAPM-based cost of equity and WACC, discounting projections, and calculating terminal value, which this skill automates into an Excel workbook.

What goes into calculating WACC for a discounted cash flow analysis?

WACC for a discounted cash flow requires applying the CAPM framework to determine the cost of equity and weighting it with the cost of debt, which this skill automates for your equity valuation.

Can I run sensitivity analysis on financial modeling assumptions in Excel?

Yes, you can run sensitivity analysis on financial modeling assumptions in Excel. This skill generates sensitivity tables alongside the DCF model to test how variable changes impact equity valuation.

How do I calculate terminal value when doing intrinsic value assessments for M&A?

Calculating terminal value for intrinsic value assessments in M&A involves capturing cash flows beyond the explicit projection period, which this skill computes automatically within the end-to-end DCF workflow.

Does this DCF model builder require historical financial data to run projections?

The DCF model builder requires input data to run projections. The workflow includes automated data retrieval and validation before applying multi-year projections and WACC-based discounting for equity valuation.