skills.rest
zli5460
zli5460COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Automate discounted cash flow valuation models with Excel formulas and scenario sensitivity analysis.

2|1|Updated May 10, 2026
Search Tags:#financial modeling#Excel#valuation#DCF#scenario analysis#investment banking
One-click install
npx skills add https://github.com/zli5460/hermes-agent-X-Phoenix-Architecture --skill dcf-model-zli5460
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/zli5460/hermes-agent-X-Phoenix-Architecture/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/zli5460/hermes-agent-X-Phoenix-Architecture --skill dcf-model-zli5460

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) and scripts (resource) components.

What problem does it solve?

This Skill automates the creation of detailed discounted cash flow valuation models, enabling finance professionals to perform intrinsic valuation with accuracy and consistency.

Core Features & Use Cases

  • Model Construction: Generates comprehensive Excel models including revenue projections, free cash flow calculations, WACC, and terminal value.
  • Scenario Analysis: Builds multiple Szenario-based sensitivity tables for WACC, growth rates, and margins, facilitating robust valuation ranges.
  • Use Case: Analysts can rapidly produce a valuation for a company by inputting assumptions, then evaluate how changes impact implied share prices, perfect for investment research or M&A analysis.

Quick Start

Input your company's financial assumptions into the dedicated sections and run the model to generate a valuation, then adjust assumptions to see result changes.

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?▼

To build a discounted cash flow valuation model in Excel, you input company financial assumptions into dedicated sections to generate revenue projections, free cash flow calculations, WACC, and terminal value automatically.

How do I run scenario sensitivity analysis for WACC and growth rates in Excel?▼

To run scenario sensitivity analysis for WACC and growth rates in Excel, the model builds multiple scenario-based sensitivity tables, allowing you to evaluate how assumption changes impact the implied share price.

Can I use Excel formulas for dynamic recalculations in a DCF model?▼

Yes, you can use Excel formulas for dynamic recalculations in a DCF model. The approach mandates Excel formulas to ensure projections, cash flows, and valuations update automatically when you adjust input assumptions.

Does this DCF modeling approach work for investment banking and M&A analysis?▼

Yes, this DCF modeling approach works for investment banking and M&A analysis. It is specifically applicable for investment banking, equity research, and corporate finance professionals requiring precise, flexible intrinsic valuation tools.

What is the best way to automate free cash flow calculations for equity research?▼

The best way to automate free cash flow calculations for equity research is using a model that generates comprehensive Excel projections and scenario comparisons, enabling rapid valuation production from input assumptions.

Related Skills

Explore More Finance & Accounting Skills→
claude-office-skillsclaude-office-skills
368

financial-modeling

Build integrated 3-statement financial models with projections for income statement, balance sheet, and cash flow.

Official
Advanced
rpoole-devrpoole-dev

Returns Analysis

Model IRR/MOIC sensitivity tables for private equity deals and output Excel workbooks.

Community
Advanced
yennanliuyennanliu
164

stock-valuation

Calculate intrinsic value per share using DCF, CCA, EV/EBITDA, and P/E multiples.

Community
Advanced
linuxyanlinuxyan

stock-valuation

Compute intrinsic value and safe buy price using the endogenous growth dividend valuation model.

Community
Advanced