skills.rest
ldzhhxx
ldzhhxxCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Construct a DCF valuation model in Excel with user inputs for revenue growth, EBIT margin, and WACC.

1|1|Updated May 9, 2026
Search Tags:#financial modeling#Excel automation#equity analysis#valuation modeling#DCF valuation
One-click install
npx skills add https://github.com/ldzhhxx/Hermes_offline_v2 --skill dcf-model-ldzhhxx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/ldzhhxx/Hermes_offline_v2/tree/main/hermes-agent/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/ldzhhxx/Hermes_offline_v2 --skill dcf-model-ldzhhxx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the construction of institutional-grade DCF valuation models in Excel, eliminating the manual work involved and reducing the risk of human error in financial analysis.

Core Features & Use Cases

  • Automated Model Construction: Automatically creates a DCF model following investment banking standards, with sensitivity analysis included.
  • Customization: Allows for user-provided data, scenario-based assumptions, and WACC inputs.
  • Use Case: Imagine you need to analyze a company's valuation and provide an intrinsic value estimate. Use this Skill to build a detailed DCF model that considers different growth and margin scenarios.

Quick Start

Run the dcf-model skill with the following parameters: --company 'XYZ Inc.' --revenue_growth 12% --ebit_margin 20% --wacc 8% --terminal_growth 3%

Frequently Asked Questions about dcf-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate building a DCF valuation model in Excel?▼

Automate DCF valuation model construction in Excel by running the skill with parameters like revenue growth, EBIT margin, WACC, and terminal growth to populate an institutional-grade financial analysis file.

What inputs are required for Excel DCF valuation modeling automation?▼

DCF valuation modeling requires user inputs for revenue growth rate, EBIT margin, WACC, and terminal growth rate to calculate intrinsic value estimates and generate sensitivity analysis.

Does openpyxl support institutional-grade financial modeling with sensitivity analysis?▼

Openpyxl supports financial modeling by programmatically constructing and populating Excel files with DCF valuation structures, handling institutional-grade formatting and sensitivity analysis data manipulation.

Can I customize equity analysis assumptions for different growth scenarios in a DCF model?▼

Customize equity analysis assumptions by providing scenario-based revenue growth and EBIT margin parameters during DCF model construction to evaluate different valuation outcomes.

What is the best way to generate a valuation summary from financial modeling outputs?▼

Generate a valuation summary by running automated DCF modeling scripts that output both the final Excel model file and a summary of the calculated intrinsic value estimates for equity analysis.

Related Skills

Explore More Finance & Accounting Skills→
hvkshetryhvkshetry
15

dcf-model

Model revenue build-up, margin progression, WACC derivation, and terminal value for DCF valuations.

Community
Advanced
executiveusaexecutiveusa

dcf-model

Build Excel-ready DCF equity valuation models with live formulas and sensitivity grids.

Community
Advanced
SethyPagnaSethyPagna

dcf-model

Build institutional DCF valuation models with Excel formulas and scenario sensitivity tables.

Community
Advanced
xfs96192xfs96192

dcf-model

Build a DCF equity valuation model with Excel workbook output.

Community
Advanced