skills.rest
markwang2658
markwang2658COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Construct discounted cash flow models in Excel with Bear/Base/Bull scenarios.

31|3|Updated May 7, 2026
Search Tags:#excel#valuation#financial-modeling#dcf#scenario-analysis#wacc#equity-valuation
One-click install
npx skills add https://github.com/markwang2658/hermes-windows-native --skill dcf-model-markwang2658
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/markwang2658/hermes-windows-native/tree/main/hermes-agent/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/markwang2658/hermes-windows-native --skill dcf-model-markwang2658

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill provides an end-to-end, Excel-based framework for building institutional-quality discounted cash flow models, enabling rigorous revenue projections, FCF construction, WACC calculations, terminal value, and scenario analyses with transparent, auditable outputs.

Core Features & Use Cases

  • Bear/Base/Bull scenario planning across a 5-year forecast with a terminal value, WACC computation, and equity value bridge.
  • Comprehensive 5x5 sensitivity analysis grids to explore how changes in growth, margins, and inputs affect intrinsic value.
  • Reproducible modeling approach that enforces live formulas, centralized scenario inputs, and thorough documentation for investment decision support.

Quick Start

Load your inputs and run the model to generate a full 5-year DCF valuation with sensitivity analysis.

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 model in Excel with scenario analysis?▼

To build a discounted cash flow model in Excel with scenario analysis, you construct Bear/Base/Bull projections over a 5-year horizon, calculate WACC, terminal value, and output an equity value bridge using centralized scenario inputs.

How does WACC calculation work in a 5-year DCF valuation?▼

WACC calculation in a 5-year DCF valuation works by applying centralized scenario inputs to discount projected free cash flows and terminal value, ultimately reconciling to an equity value bridge for intrinsic valuation.

Can I use openpyxl to generate Excel equity valuation models with live formulas?▼

Yes, you can use openpyxl to generate Excel equity valuation models with live formulas, ensuring reproducible and auditable outputs that enforce strict formula usage rather than hardcoded values.

What's the best way to run sensitivity analysis for financial modeling projections?▼

The best way to run sensitivity analysis for financial modeling projections is constructing 5x5 sensitivity grids that explore how changes in growth rates, margins, and WACC inputs affect the intrinsic equity value.

Does this DCF model support terminal value and equity value bridge calculations?▼

Yes, this DCF model supports terminal value and equity value bridge calculations across Bear/Base/Bull scenarios, delivering reproducible investment decision support with transparent, auditable outputs over a 5-year forecast.

Related Skills

Explore More Finance & Accounting Skills→
PriyanshKuniyalPriyanshKuniyal

startup-financial-modeling

Create 3-5 year startup financial projections with revenue, cost, and cash flow analysis.

Community
Advanced
auldsyababuaauldsyababua
6

Creating Financial Models

Build Excel financial models with DCF, sensitivity, Monte Carlo, and scenario analyses.

Community
Advanced
KaakatiKaakati
3

valuation

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

Community
Advanced
MarbleSodasMarbleSodas

dcf-model

Build institutional-quality DCF valuation models in Excel with live formulas.

Community
Advanced