Financial Analysis
Prompt Generator.

Produce a discounted cash flow (dcf) for investor (vc, pe, public).

COMPANY: a mid-stage private company (B2B SaaS)
TIMEFRAME: Last 3 fiscal years historical + 5-year forecast
NUMBERS PROVIDED: [numbers not provided — use placeholder inputs tagged [input needed]]
KEY ASSUMPTIONS: [no specific assumptions provided — use reasonable market defaults and flag all of them]

STRUCTURE:
1) Historical financials summary (revenue, gross margin, EBITDA, capex, working capital — 3 years).
2) Forecast drivers (revenue growth rate, gross margin trajectory, opex as % of revenue, tax rate).
3) Unlevered free cash flow build (EBIT × (1-tax) + D&A − capex − ΔNWC).
4) WACC calculation (cost of equity via CAPM, cost of debt after tax, capital structure weights).
5) Terminal value (Gordon growth OR exit multiple — show both).
6) Present value walk and enterprise value.
7) Equity value bridge (EV − net debt + minority interest adjustments).
8) Sanity checks vs. trading comps.
- Use ARR and NRR as primary revenue drivers (not GAAP revenue).

CONSTRAINTS:
- show all formulas and assumptions; flag every input that needs verification
- Every number must be either supported by a provided figure or tagged "[input needed]" / "[assumption — justify]".
- Show formulas, not just outputs.
- Flag any figure that requires external data (comps, betas, risk-free rate) as "[external data — source needed]".

Deliver the analysis only. No preamble.

Role: a senior FP&A or investment analyst known for discounted cash flow (dcf) work that survives scrutiny from investor (vc, pe, public).

COMPANY: a mid-stage private company (B2B SaaS)
TIMEFRAME: Last 3 fiscal years historical + 5-year forecast
NUMBERS: [numbers not provided — use placeholder inputs tagged [input needed]]
ASSUMPTIONS: [no specific assumptions provided — use reasonable market defaults and flag all of them]

REQUIRED STRUCTURE:
1) Historical financials summary (revenue, gross margin, EBITDA, capex, working capital — 3 years).
2) Forecast drivers (revenue growth rate, gross margin trajectory, opex as % of revenue, tax rate).
3) Unlevered free cash flow build (EBIT × (1-tax) + D&A − capex − ΔNWC).
4) WACC calculation (cost of equity via CAPM, cost of debt after tax, capital structure weights).
5) Terminal value (Gordon growth OR exit multiple — show both).
6) Present value walk and enterprise value.
7) Equity value bridge (EV − net debt + minority interest adjustments).
8) Sanity checks vs. trading comps.
- Use ARR and NRR as primary revenue drivers (not GAAP revenue).

PROCESS:
1. Produce the full analysis using the structure above.
2. Re-read as a skeptical investor (vc, pe, public) — which single output is most vulnerable to challenge?
3. Either strengthen that output (tighter logic, better source) or explicitly flag the weakness with a "this is the biggest open question" note.
4. Output only the final version.

CONSTRAINTS:
- show all formulas and assumptions; flag every input that needs verification
- All formulas visible.
- Inputs tagged "[input needed]" where real data is required.
- Market-default assumptions (WACC components, tax rates, terminal growth) must be specified and justified.

Role: a sharp-elbowed analyst producing a discounted cash flow (dcf) that a skeptical investor (vc, pe, public) will try to pick apart.

COMPANY: a mid-stage private company (B2B SaaS)
TIMEFRAME: Last 3 fiscal years historical + 5-year forecast
NUMBERS: [numbers not provided — use placeholder inputs tagged [input needed]]
ASSUMPTIONS: [no specific assumptions provided — use reasonable market defaults and flag all of them]

REQUIRED STRUCTURE:
1) Historical financials summary (revenue, gross margin, EBITDA, capex, working capital — 3 years).
2) Forecast drivers (revenue growth rate, gross margin trajectory, opex as % of revenue, tax rate).
3) Unlevered free cash flow build (EBIT × (1-tax) + D&A − capex − ΔNWC).
4) WACC calculation (cost of equity via CAPM, cost of debt after tax, capital structure weights).
5) Terminal value (Gordon growth OR exit multiple — show both).
6) Present value walk and enterprise value.
7) Equity value bridge (EV − net debt + minority interest adjustments).
8) Sanity checks vs. trading comps.
- Use ARR and NRR as primary revenue drivers (not GAAP revenue).

RULES OF THE HOUSE:
- show all formulas and assumptions; flag every input that needs verification
- Every formula visible. Every assumption justified or flagged.
- For any industry-default input (WACC components, tax rate, terminal growth rate, discount period conventions), state the convention you're using and why.
- Inputs you don't have must be tagged "[input needed]"; do not invent specific numbers.

DELIVERABLE:
1. The full analysis following the structure.
2. A "Top 3 swing factors" section — the 3 inputs that move the answer most, with their impact (e.g., "+100bps to WACC → −$42M EV").
3. A "Questions the reviewer will raise" section (3-5 questions) — the challenges a skeptical reviewer will bring, with your first-response strategy.
4. A "What I'd go back and verify" list — the inputs that, if I had more time, I'd double-check with source data.