Skip to main content
← Back to templates

DCF Valuation Walkthrough

Finance

Walk through a discounted cash flow valuation built on your own stated assumptions.

The specific numeric values (prices, ratios, scores) in this template are estimates generated by the model, not verified market data. Always verify with real sources before making any financial decision.

Role: You are a financial analyst specialized in discounted cash flow valuation, educational guidance only.

Context: Company/ticker: a hypothetical mid-cap SaaS company
Current price (if known): not provided
Known revenue/growth (if known): $200M revenue, 18% YoY growth
Assumptions: growth slows to 8% by year 5, 25% terminal FCF margin, 9% WACC

Task: 5-year revenue projection, margin estimates, FCF, WACC, terminal value (exit multiple + perpetuity), sensitivity table, comparison to price if given.

Constraints: Use only data provided — never claim real financials/consensus not supplied. Label all assumptions as illustrative.

Output Format: Assumptions stated -> FCF table -> WACC/terminal value -> sensitivity table -> implied range.

Expected output

A full DCF walkthrough built strictly on your stated assumptions and data — a 5-year projection, FCF table, terminal value under both methods, and a sensitivity table — with every assumption explicitly labeled illustrative, not real.

Usage tips

  • This works entirely from what you provide — supply real current financials yourself if you want the output grounded in them, it won't invent them.
  • Run the sensitivity table with a couple of different WACC/growth assumptions — that range is usually more informative than any single number.

Try it

Fill in the placeholders below and see the compiled prompt update live.

The company or ticker in question.

The current price, if known.

Known revenue or growth data.

The assumptions to use in the calculation.

84
Words
665
Characters
0/4
Placeholders filled
1 min
Reading time
Quality score11
  • Completeness0
  • Clarity0
  • Context0
  • Specificity0
  • Constraints0
  • Format0
  • Output0
  • Constraints note100
  • Success criteria0
  • Scope focus100
  • Verification step0
  • Negative example0
  • Confidence0
  • Placeholder syntax100
  • Markdown structure0
Suggestions
  • Fill in the remaining placeholders.
  • Expand your answers — a few words each isn't enough detail for the model to work with.
  • Add background context so the model understands the situation.
Role: You are a financial analyst specialized in discounted cash flow valuation, educational guidance only. Context: Company/ticker: {{COMPANY}} Current price (if known): {{CURRENT_PRICE}} Known revenue/growth (if known): {{REVENUE_DATA}} Assumptions: {{ASSUMPTIONS}} Task: 5-year revenue projection, margin estimates, FCF, WACC, terminal value (exit multiple + perpetuity), sensitivity table, comparison to price if given. Constraints: Use only data provided — never claim real financials/consensus not supplied. Label all assumptions as illustrative. Output Format: Assumptions stated -> FCF table -> WACC/terminal value -> sensitivity table -> implied range.
AI Assistant

Jump to a page…

Navigation