dcf-model

Generate institutional-quality DCF valuation models in Excel with openpyxl.

Updated Jun 25, 2026

Search Tags:#finance #excel #modeling #valuation #dcf #investment-banking

Ready to run

npx skills add https://github.com/Rheasilvia/hermes-desktop --skill dcf-model-rheasilvia

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/Rheasilvia/hermes-desktop/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/Rheasilvia/hermes-desktop --skill dcf-model-rheasilvia

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill solves the complexity and inconsistency of building financial valuation models by automating the creation of institutional-quality Discounted Cash Flow (DCF) workbooks in Excel.

Core Features & Use Cases

Automated Modeling: Generates structured DCF models including historical analysis, revenue projections, and FCF schedules.
Sensitivity Analysis: Programmatically builds 5x5 or 7x7 sensitivity tables to stress-test valuation assumptions.
Use Case: An analyst can use this to quickly build a three-scenario (Bear/Base/Bull) valuation model for a target company, ensuring all formulas are linked correctly and sensitivity tables are fully populated without manual Excel work.

Quick Start

Use the dcf-model skill to build a five-year discounted cash flow valuation for the company with ticker symbol AAPL.

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 discounted cash flow valuation model in Excel without manual formula linking?▼

To build a discounted cash flow (DCF) model in Excel, this tool programmatically generates structured workbooks with historical analysis, revenue projections, and FCF schedules. It ensures all formulas are linked correctly and populates sensitivity tables automatically without manual work.

What is the best way to generate DCF sensitivity tables in Excel?▼

The best way to generate DCF sensitivity tables is using programmatic formula creation, which builds 5x5 or 7x7 tables to stress-test valuation assumptions. This approach ensures tables are fully populated and linked correctly, adhering to strict investment banking standards.

Can I create multi-scenario financial forecasting models for equity valuation?▼

Yes, you can create multi-scenario financial forecasting models for equity valuation. The tool supports building three-scenario (Bear/Base/Bull) models, calculating the cost of capital, and automating sensitivity analysis to evaluate target companies.

Does openpyxl support institutional-grade Excel financial modeling?▼

Yes, openpyxl supports institutional-grade Excel financial modeling by enabling programmatic spreadsheet manipulation. It allows the creation of complex DCF workbooks with strict formula integrity and documentation required for investment banking standards.

How do I calculate cost of capital for a DCF model?▼

To calculate cost of capital for a DCF model, the tool uses programmatic formula generation within Excel. It structures the cost of capital calculation alongside revenue projections and FCF schedules to ensure accurate equity valuation.

Why does my Excel DCF model have broken formula links and how can I prevent it?▼

Broken formula links in Excel DCF models often result from manual entry errors. Using programmatic formula generation prevents this by ensuring all formulas are linked correctly and sensitivity tables are fully populated, maintaining institutional-quality standards.