Investing & Markets5.0 · 0 ratings
DCF Valuation Walkthrough
Step through a transparent discounted-cash-flow model with stated assumptions, sensitivity, and a sanity check against multiples.
Role-BasedStep-by-StepStructured-Output
Prompt
ROLE: You are a valuation specialist teaching me how to build and stress-test a DCF for [COMPANY_NAME] ([TICKER]). INPUTS I PROVIDE: Last-FY revenue: [REVENUE]. EBIT margin: [MARGIN]. Tax rate: [TAX]. Capex %: [CAPEX_PCT]. Working-capital assumption: [WC]. Net debt: [NET_DEBT]. Shares outstanding: [SHARES]. My revenue growth path: [GROWTH_BY_YEAR]. Discount rate (WACC): [WACC]. Terminal growth: [TERMINAL_G]. TASK — reason step by step and show the arithmetic: 1. Project unlevered free cash flow for years 1-[N] from my inputs. 2. Discount each year's FCF to present value; show the discount factors. 3. Compute terminal value with both Gordon-growth and an exit-multiple method, and reconcile them. 4. Sum to enterprise value, bridge to equity value, then per-share value. 5. Run a sensitivity grid on WACC (+/-1%) and terminal growth (+/-0.5%). 6. Cross-check the implied EV/EBITDA and P/E against the peer range I give: [PEER_MULTIPLES]. OUTPUT FORMAT: A FCF projection table, a TV reconciliation, a 3x3 sensitivity matrix, and a one-line verdict: implied value vs current price [PRICE] with the margin of safety. CONSTRAINTS: State every assumption you carry forward. Flag where my inputs look internally inconsistent. This is an educational model, not investment advice.
Recommended models
claudegpt-4ogemini
More in Investing & Markets
Equity Investment Thesis Builder
Construct a rigorous bull-and-bear investment thesis for a single stock with explicit variant perception and falsifiable assumptions.
Read prompt
Earnings Call Transcript Decoder
Extract guidance changes, tone shifts, and evasive answers from an earnings call transcript into a structured signal sheet.
Read prompt
Portfolio Risk X-Ray
Diagnose hidden concentration, factor tilts, and correlation risk across a multi-position portfolio with concrete rebalancing options.
Read prompt
Macro Regime Diagnostic
Classify the current macro regime from growth and inflation signals and map asset-class implications with leading indicators to watch.
Read prompt