dcf-model

Build end-to-end DCF valuation models with scenario analysis and Excel outputs.

1.6k|270|Updated Jan 18, 2026
One-click install
npx skills add https://github.com/ginlix-ai/LangAlpha --skill dcf-model
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/ginlix-ai/LangAlpha/tree/main/skills/dcf-model
Command: npx skills add https://github.com/ginlix-ai/LangAlpha --skill dcf-model

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates the construction of robust DCF valuation models, standardizing inputs, calculations, and outputs to support consistent equity analyses.

Core Features & Use Cases

  • End-to-end DCF model building with revenue, margins, tax, D&A, CapEx, NWC, and FCF
  • Scenario analysis (Bear/Base/Bull) with centralized assumptions and data validation
  • Auto-generated sensitivity analyses and Excel outputs aligned to corporate finance standards
  • Generates an auditable workbook with proper forecasting structure and alignment to investment banking practices
  • Use Case: a financial analyst prepares a 5-year valuation with terminal value, informs investment decisions, and shares a ready-to-deliver Excel model

Quick Start

Create a new DCF workbook for your target and input your historicals to generate projected FCF and valuation 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 valuation model with scenario analysis in Excel?

DCF valuation models with scenario analysis are built by standardizing centralized assumptions for Bear/Base/Bull cases, projecting 5-year revenues, margins, and FCF, and populating Excel formulas via OpenPyXL to generate an auditable workbook with WACC estimation, terminal value, and sensitivity analysis.

What is the best way to automate WACC estimation and terminal value calculations for equity analysis?

Automating WACC estimation and terminal value calculations involves creating a scalable workbook with centralized assumptions and data validation. The process populates 5-year projections using OpenPyXL formulas and runs a recalc script to validate outputs, ensuring consistent equity analysis for investment bankers and portfolio managers.

Can I generate sensitivity analysis across Bear, Base, and Bull scenarios for a 5-year financial projection?

Yes, sensitivity analysis across Bear, Base, and Bull scenarios is generated for 5-year financial projections by consolidating centralized assumptions into a scalable workbook. The model auto-generates sensitivity outputs aligned to corporate finance standards, validating projected FCF and valuation results through a recalc script.

Does automated DCF modeling require historical financial data to project free cash flow?

Automated DCF modeling requires historical financial data inputs to project free cash flow accurately. You input historicals for revenue, margins, tax, D&A, CapEx, and NWC into the generated workbook to calculate 5-year projected FCF and terminal value for investment decisions.

How does OpenPyXL formula population work for creating auditable financial modeling workbooks?

OpenPyXL formula population creates auditable financial modeling workbooks by programmatically writing calculation formulas directly into Excel cells for 5-year projections. This ensures proper forecasting structure and alignment with investment banking practices, followed by a recalc script to validate the populated valuation outputs.