Full discounted cash flow model built to investment banking standards. Includes a CAPM-based WACC build, 5-year FCF projection, Gordon Growth terminal value, and two sensitivity tables.

8 tabs included:

• README — Instructions, formula definitions

• Assumptions — Revenue growth, margins, CapEx, NWC, WACC inputs, terminal growth rate

• Revenue Build — Revenue & EBITDA projection with margin expansion

• FCF Projection — EBITDA → NOPAT → Unlevered FCF, mid-year discounting, PV of FCFs

• WACC — CAPM cost of equity, after-tax cost of debt, market value weights, blended WACC

• Valuation — PV of FCFs + Terminal Value → Enterprise Value → Implied Share Price

• Sensitivity — EV vs. WACC × TGR | Share Price vs. WACC × TGR (25 scenarios each)

• Output Summary — WACC summary, valuation output, implied price range

Built for: IB analysts, equity research associates, corporate development teams.

Use it to: Value a company, run a 25-scenario sensitivity analysis, or build the valuation section of a pitch book.

Color-coded to Wall Street standards. Print-ready output tab.

Built by an MBA candidate with PE investment analysis experience across institutional transactions.