skills.rest
pynbj1001
pynbj1001COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

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

4|1|Updated Mar 25, 2026
Search Tags:#modeling#valuation#sensitivity#dcf#cash-flow#equity#wacc
One-click install
npx skills add https://github.com/pynbj1001/alpha-sense --skill dcf-model-pynbj1001
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/pynbj1001/alpha-sense/tree/main/.github/skills/fsp-financial-analysis-dcf-model
Command: npx skills add https://github.com/pynbj1001/alpha-sense --skill dcf-model-pynbj1001

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides end-to-end, production-grade discounted cash flow (DCF) valuation models for equities, transforming raw financial inputs into a fully recalculating Excel workbook that supports scenario analysis and valuation outputs.

Core Features & Use Cases

  • Data retrieval from structured financial sources and user inputs to populate projections
  • Multi-scenario support (Bear/Base/Bull) with centralized consolidation and index-driven projections
  • Full DCF workflow: revenue projections, operating costs, FCF, WACC via CAPM, and terminal value
  • Built-in sensitivity analysis tables to illustrate valuation under varying assumptions
  • Output includes a professional Excel model with executive summaries and valuation bridge

Quick Start

Open the DCF model, enter the company data and assumptions, and generate a complete recalculating forecast with sensitivity results.

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

DCF models for equity valuation automate revenue projections, operating costs, FCF, WACC via CAPM, and terminal value calculations to support Bear, Base, and Bull scenario analysis.

What is the best way to calculate WACC and terminal value in a discounted cash flow framework?▼

In a discounted cash flow framework, WACC is calculated using CAPM, while terminal value is derived from structured projections, both integrated into a consolidated valuation output.

Can I generate an Excel workbook with sensitivity tables from company financial inputs?▼

Yes, processing structured financial inputs and user assumptions generates a complete recalculating Excel workbook containing built-in sensitivity analysis tables and an executive summary.

Do I need structured financial data to run multi-scenario DCF projections?▼

Yes, multi-scenario DCF projections require structured financial data retrieval and user inputs to populate centralized consolidation and index-driven Bear, Base, and Bull forecast blocks.

What limitations should I expect when automating equity valuation with a DCF framework?▼

DCF framework outputs depend heavily on the accuracy of inputted assumptions for WACC and revenue growth, meaning sensitivity analysis is required to assess valuation variance under changing conditions.

Related Skills

Explore More Finance & Accounting Skills→
519lab519lab
2

dcf-model

Automate DCF valuation model construction and analysis with financial calculations.

Official
Advanced
mahyarmalekiimahyarmalekii

dcf-model

Automates DCF model creation from SEC filings and MCP servers.

Community
Advanced
KaakatiKaakati
3

valuation

Perform multi-method business valuation using DCF, comparable companies, and precedent transactions.

Community
Advanced
644408071-design644408071-design
1

valuation-model

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

Community
Advanced