Free cash flow forecast
From enterprise value to share price
Where the value comes from
Share price sensitivity (US$)
Rows: WACC. Columns: terminal growth. Highlighted cell is your current case.
Change any assumption and the enterprise value, equity value and share price update instantly.
Rows: WACC. Columns: terminal growth. Highlighted cell is your current case.
This tool values a company with a discounted cash flow (DCF) model. It forecasts free cash flow to the firm (FCFF) for five years, adds a terminal value for all later years, and discounts everything at the weighted average cost of capital (WACC).
Sales(t) = Sales(t−1) × (1 + g_sales)
EBIT(t) = Sales(t) × EBIT margin
NOPAT(t) = EBIT(t) × (1 − tax rate)
FCFF(t) = NOPAT(t) + D&A(t) − CapEx(t) − ΔNWC(t)
D&A and CapEx are percentages of sales. ΔNWC = NWC % × (Sales(t) − Sales(t−1)), so working capital grows with sales.
PV(FCFF t) = FCFF(t) / (1 + WACC)^t
Cash flows are assumed to arrive at year end.
TV = FCFF(5) × (1 + g) / (WACC − g)
PV(TV) = TV / (1 + WACC)^5
The model requires WACC to be greater than g. Otherwise the formula has no finite value and the tool shows a warning.
Enterprise value = Σ PV(FCFF) + PV(TV)
Equity value = Enterprise value − Net debt
Share price = Equity value / Shares outstanding
Net debt is borrowings minus cash. Include other debt-like claims (for example minority interests) in it if they apply to your company.
Cost of equity = Rf + β × ERP
WACC = E/V × Ke + D/V × Kd × (1 − tax rate)
Built as an individual assignment. Valuation outputs are estimates that depend entirely on the assumptions entered.