XLSX + AI project kit · Capital Control

DCF valuation starter

Explore a five-year cash-flow forecast, connect model-implied enterprise value to equity value, and see sensitivity to the selected assumptions.

Download kit ↓Download workbook (XLSX) ↓

Preview of the fictional DCF workbook, showing enterprise value, equity value and five-year cash flows — Fictional worked example · Hypothetical values, not a forecast or recommendation · Open full-size preview ↗

What’s inside

An editable DCF workbook with five-year operating assumptions and free cash flow to the firm.
A terminal-value calculation and enterprise-to-equity bridge.
A sensitivity grid for discount rate and terminal growth.
A project guide and blank tables for evidence, assumptions, checks, and the final explanation.

Bring your own inputs

Company and valuation date; currency and units; sourced historical revenue and operating data; forecast drivers; taxes, reinvestment and working capital; discount rate and terminal assumptions; debt, cash, equity adjustments, and share count.

How to use it

Download and unzip the kit. Read README.md, then save a separate copy for your company.
Open the workbook in Excel or import a copy into Google Sheets. Replace fictional inputs with sourced assumptions.
Use the project instructions and evidence tables with your AI to document sources and complete the analysis.
Recalculate, inspect the checks and sensitivity, and review the written explanation alongside the numbers.

Review before relying on the result

The example is educational and does not value a real company. Use a consistent currency, unit, and valuation date. Review forecast and terminal economics, discount rate, equity adjustments, and sensitivity. Recheck formulas and formatting after importing into another spreadsheet application. Model-implied values are conditional examples, not price targets, predictions, or recommendations to buy, sell, or hold.

Folder layout

README.md
AGENTS.md / CLAUDE.md
Project brief & build playbook
01_sources/   Original evidence
02_inputs/    Blank CSV input tables
03_model/     Editable example workbook
04_review/    Checklist & findings
05_output/    Result & handoff template
REUSE.md      Copy and adaptation terms

Need help with your actual decision?

Start with the question behind the numbers.

A free assessment helps define fit. Custom analysis and a Decision Packet are separately scoped paid work.

Start the free assessment ↗