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