ExcelModelling Templates$50

Professional DCF Model Template

About this resource

Built to the standards expected in IB analyst interviews and take-home case studies. Includes separate tabs for assumptions, WACC calculation (cost of equity via CAPM, after-tax cost of debt), 5-year free cash flow build, DCF valuation with terminal value, and a sensitivity table varying WACC against terminal growth rate.

Sheets included

01Instructions

02Assumptions (revenue, margins, capex)

03WACC Calculator (CAPM, cost of debt)

04Free Cash Flow Build (5-year projection)

05DCF Valuation & Terminal Value

06Sensitivity Table (WACC vs growth rate)

What's included

Assumptions sheet with editable revenue, margin, and capex inputs

WACC calculator with CAPM-based cost of equity

5-year free cash flow projection with terminal value

Sensitivity table: WACC vs terminal growth rate

Clean formatting with instructions on every tab

DCFmodellingvaluationExcelfinancial model

Price

$50

Instant download after payment

Secure payment via Stripe

Lifetime access