skills.rest
vivekgoquest
vivekgoquestCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Build discounted cash flow valuation workbooks in Excel with openpyxl.

Updated Aug 22, 2026
Search Tags:#financial modeling#Excel#openpyxl#valuation#DCF#sensitivity analysis#WACC
One-click install
npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill dcf-model-vivekgoquest
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/vivekgoquest/hermes-agent-stable/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill dcf-model-vivekgoquest

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, requests, and includes scripts (resource) components.

What problem does it solve? Building an institutional-quality DCF valuation model in Excel is slow and error-prone: formulas break when rows shift, sensitivity tables get left as placeholders, and hardcoded values replace live formulas. This Skill produces a complete, formula-driven DCF workbook with scenario analysis and sensitivity tables that recalculate correctly. ## Core Features & Use Cases - Full DCF workflow: Guides data retrieval, historical analysis, revenue projections, FCF build, WACC via CAPM, terminal value, and the enterprise-to-equity bridge, with user confirmation at each stage. - Scenario and sensitivity analysis: Creates Bear/Base/Bull assumption blocks with a case selector, plus three 5x5 sensitivity tables (WACC vs terminal growth, revenue growth vs EBIT margin, beta vs risk-free rate) populated with full recalculation formulas. - Validation and recalculation: Ships a validate_dcf.py script that checks formula errors, terminal growth vs WACC, WACC range, and terminal value proportion, and integrates with the excel-author recalc.py script. - Use Case: Ask for a DCF model of a public company ticker and receive an .xlsx file with live formulas, sourced cell comments, scenario switching, and sensitivity grids ready for investment review. ## Quick Start Build a DCF valuation model in Excel for ticker AAPL using consensus growth estimates and a 5-year projection period.

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 in Excel with Python?▼

Use openpyxl to write live Excel formulas for revenue projections, FCF, WACC discounting, and terminal value rather than computed numbers. This Skill structures the workbook into DCF and WACC sheets, then recalculates with LibreOffice via recalc.py to verify zero formula errors.

How to create sensitivity tables in Excel without Data Tables?▼

Write regular formulas into each cell of a 5x5 grid programmatically with openpyxl, substituting the row and column assumption values into a full DCF recalculation. Use odd dimensions so the center cell equals the base case, and highlight it for visibility.

Does the DCF model support multiple scenarios like bear and bull cases?▼

Yes, the model creates separate Bear, Base, and Bull assumption blocks with a case selector cell. A consolidation column uses INDEX formulas to pull assumptions from the selected block, so switching the selector updates all projections.

Why does my DCF model show #REF! or #DIV/0! errors?▼

#REF! errors usually come from inserting headers after writing formulas, which shifts row references; lock the layout first. #DIV/0! errors come from empty divisors; wrap divisions in IF checks. Run validate_dcf.py to locate all error cells.

What is a valid terminal growth rate compared to WACC?▼

Terminal growth must be strictly less than WACC, otherwise the perpetuity formula produces infinite value. Typical terminal growth is 2.0-3.5%, anchored to long-term GDP growth, while WACC typically ranges from 7-15% depending on company risk.

Related Skills

Explore More Finance & Accounting Skills→
xu1713xu1713

3-statement-model

Builds integrated three-statement financial models in Excel with openpyxl formulas and validation checks.

Community
Advanced
xpert-aixpert-ai
8

comps-valuation

Generate comparable-company valuation reports and Excel workbooks for public equities.

Official
Advanced
erphqerphq
2

valuation-dcf-comps

Value public companies using DCF and comparables with bear, base, and bull scenarios.

Official
Advanced
open-nekoopen-neko
11

lbo-model

Build formula-driven LBO models in Excel with openpyxl.

Official
Advanced