Dcf Model — Build discounted cash flow valuation workbooks in Excel
Dcf Model — Build discounted cash flow valuation workbooks in Excel
Start with meaning, then move to detail.
This lesson explains Dcf Model — Build discounted cash flow valuation workbooks in Excel as part of extending Hermes and connecting external tools. You will learn what it does, when it matters, and the smallest safe test that proves it works.
If you are new, do not memorize names. Focus on three questions: what problem does this solve, what access does it need, and how can you verify the result?
For practice, inspect the first example, identify its effects, run it on test data, and compare the result with the source claim.
For advanced readers, inspect Skill metadata, Reference: full SKILL.md, Environment, then verify failure modes and version compatibility.
Complete installation and one successful task before adding new capabilities.
A clear outcome before you read.
- Understand Dcf Model — Build discounted cash flow valuation workbooks in Excel without assumed prior knowledge.
- Separate the source description from what still needs testing in your environment.
- Read the first command and identify its inputs and outputs before copying it.
Short definitions before the details.
- Provider
- The service that runs or provides access and authentication to a model.
- Skill
- An instruction bundle that teaches Hermes a repeatable workflow without necessarily adding an external service.
- Tool
- A structured action the agent can call to read or change something.
Build discounted cash flow valuation workbooks in Excel
What does the source say, and in what order?
- 01Skill metadata
Start here to understand the core idea or structure.
- 02Reference: full SKILL.md
Read this after the foundation, then connect it to the previous step.
- 03Environment
Read this after the foundation, then connect it to the previous step.
- 04Overview
Read this after the foundation, then connect it to the previous step.
- 05Tools
Read this after the foundation, then connect it to the previous step.
- 06Critical Constraints - Read These First
Read this after the foundation, then connect it to the previous step.
- 07DCF Process Workflow
Read this after the foundation, then connect it to the previous step.
- 08Step 1: Data Retrieval and Validation
Read this after the foundation, then connect it to the previous step.
- 09Step 2: Historical Analysis (3-5 years)
Read this after the foundation, then connect it to the previous step.
- 10Step 3: Build Revenue Projections
Finish here to verify the result and special cases.
Copy only after you understand the effect.
Historical Metrics (LTM):
Revenue: $X million
Revenue growth: X% CAGR
Gross margin: X%
EBIT margin: X%
D&A % of revenue: X%
CapEx % of revenue: X%
FCF margin: X%Bear Case: Conservative growth (e.g., 8-12%)
Base Case: Most likely scenario (e.g., 12-16%)
Bull Case: Optimistic growth (e.g., 16-20%)Current State → Target State (Year 5)
Gross Margin: X% → Y% (justify based on scale, efficiency)
EBIT Margin: X% → Y% (result of revenue growth + opex leverage)Read the first command and identify its inputs and outputs before copying it.
Match every command to your installed Hermes version, review the files and accounts it can reach, and use non-sensitive data for the first test. If this explanation differs from the source, the official source wins.