skills.rest
AlexZWANG1
AlexZWANG1COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Construct a DCF valuation model with WACC, terminal value, and scenario analysis in Excel.

Updated Mar 17, 2026
Search Tags:#excel#modeling#valuation#sensitivity#dcf#equity
One-click install
npx skills add https://github.com/AlexZWANG1/Prism --skill dcf-model-alexzwang1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/AlexZWANG1/Prism/tree/main/financial-services-plugins/financial-analysis/skills/dcf-model
Command: npx skills add https://github.com/AlexZWANG1/Prism --skill dcf-model-alexzwang1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Realistic end-to-end DCF valuation models that automate data sourcing, cash-flow projections, WACC calculations, terminal value, and an auditable equity value output in Excel.

Core Features & Use Cases

  • Data integration: pull historical financials and forward-looking estimates from SEC filings and recognized data feeds.
  • End-to-end modeling: build revenue projections, D&A, CapEx, working capital, FCF, discounting, and produce a valuation bridge in Excel.
  • Scenario and sensitivity: Bear/Base/Bull blocks with sensitivity tables and a clear audit trail.

Quick Start

Provide a company name or ticker and a validated data source, then instruct the assistant to generate a complete Excel DCF model with three scenarios and sensitivity analysis.

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 WACC and terminal value?▼

You build a DCF valuation model in Excel by projecting free cash flows, applying CAPM to estimate the cost of equity for WACC, calculating terminal value, and bridging enterprise value to per-share equity value.

What is the best way to automate DCF scenario analysis and sensitivity tables?▼

The best way to automate DCF scenario analysis is to generate a workbook containing Bear, Base, and Bull projections alongside sensitivity tables, ensuring a documented audit trail for the equity valuation.

Can I use SEC filings to source historical financials for a DCF model?▼

Yes, you can use SEC filings and recognized data feeds to source historical financials and forward-looking estimates, which feed directly into the cash flow projections and WACC calculations for your DCF model.

How do you calculate enterprise to equity value bridge in a discounted cash flow model?▼

To calculate the enterprise to equity value bridge in a discounted cash flow model, you discount projected free cash flows and terminal value to present value, then subtract net debt to derive the final per-share equity valuation.

Do I need a validated data provider to generate a complete DCF workbook?▼

Yes, you need a validated data provider or MCP server to supply reliable historical financials and forward-looking estimates before instructing the assistant to generate the complete Excel DCF model.

Related Skills

Explore More Finance & Accounting Skills→
mahyarmalekiimahyarmalekii

dcf-model

Automates DCF model creation from SEC filings and MCP servers.

Community
Advanced
carterwayneskhizeinecarterwayneskhizeine
19

dcf-model

Generate an Excel DCF valuation model with live formulas and sensitivity grids.

Community
Advanced
bdschi1bdschi1
1

dcf-model

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

Community
Advanced
pynbj1001pynbj1001
4

dcf-model

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

Community
Advanced