Company Valuation (DCF) Model
89 views
Builds complete DCF models with sensitivity tables and football field valuations
Prompt
"Create a comprehensive DCF valuation for [Company]: 1) Project FCF for 5-10 years based on historical performance 2) Calculate WACC using current market data 3) Determine terminal value using both growth and exit multiple methods 4) Run sensitivity analysis on key assumptions 5) Create football field chart comparing DCF, comps, and precedent transactions. Include LBO analysis at various return thresholds."