DCF Valuation
Model
Income Statement · Cash Flow · Balance Sheet · WACC · Enterprise Value
Implied Price
—
Current:
—
Upside
—
Assumptions
Income Statement
Cash Flow
Balance Sheet
DCF & WACC
Sensitivity
✓
Discounted Cash Flow Modeling — Coursera Project Certificate
Completed by Manit Bhasin · Jan 30, 2026 · Grade: 80% · Authorized by Bekhrushbek Ochilov MCSI, FAGRC (Investment Banker)
Verify ↗
Base Year Inputs
Revenue ($M)
COGS (% Rev)
%
SG&A (% Rev)
%
R&D (% Rev)
%
D&A (% Rev)
%
Capex (% Rev)
%
Δ NWC (% Rev)
%
Tax Rate
%
Revenue Growth — 5-Year Projection
Year 1
12%
Year 2
11%
Year 3
10%
Year 4
9%
Year 5
8%
WACC & Valuation Inputs
Risk-Free Rate
%
Equity Risk Premium
%
Beta (β)
Cost of Debt
%
Debt Weight
%
Terminal Growth Rate
%
Net Debt ($M)
Shares Outstanding (M)
Current Share Price ($)
Revenue & EBITDA — Base + 5-Year Projection ($M)
FCF Projection ($M)
Gross Profit vs EBITDA vs Net Income ($M)
Margin Profile (%)
Income Statement ($M)
FCF Bridge — Base Year Components ($M)
FCF vs Capex — All Years ($M)
Free Cash Flow Statement ($M)
Assets Composition — Projected Years ($M)
Equity vs Debt ($M)
Balance Sheet ($M)
PV of FCFs vs Terminal Value ($M)
Valuation Bridge ($M)
WACC Build-Up (CAPM)
Discounted FCF by Year
Valuation Bridge
Terminal Value Composition
Implied Share Price — WACC vs Terminal Growth Rate
Implied Share Price — WACC vs Year 1 Revenue Growth