Valuation and returns · in 15 models

Discounting and terminal value

Discount factors, two terminal methods, reconciled.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: discounting and terminal value.Updated 30 September 2026

Part of project finance and infrastructure models, with the models, labs and guides around it.

Part of technology company financial models, with the models, labs and guides around it.

What it does

Where the forecast becomes a value. Each year’s free cash flow is discounted at the cost of capital; the years beyond the forecast are captured in a terminal value, computed either by growing the last cash flow in perpetuity or by applying an exit multiple to the last year’s earnings. A careful build restates each method as the other, so the two assumptions can be compared.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Discounted cash flow model
  • Assumptions, rows 23–27: Terminal growth rate, Return on new invested capital, terminal period, Terminal year basis, Exit multiple, EV / FY5E EBITDA…
  • Valuation, rows 6–11: Forecast year, Discount period (years), Discount factor, Unlevered free cash flow…
  • Valuation, rows 14–16: FY5E free cash flow x (1 + g), Reinvestment, % of NOPAT, implied, Return on new capital implied
  • Valuation, rows 19–28: Terminal-year NOPAT, Return on new invested capital (RONIC), Reinvestment rate, g / RONIC, Reinvestment…
  • Valuation, rows 31–36: Terminal value, perpetuity growth method, Discount factor at end of final year, Present value of terminal value, Enterprise value, perpetuity growth method…
  • Valuation, rows 39–44: Terminal value, exit multiple method, Present value of terminal value, Enterprise value, exit multiple method, Terminal value, % of enterprise value…
Regulated utility model: electricity network
  • Assumptions, rows 42–44: Cost of equity, Long-run rate base growth, Sector multiple, enterprise value / rate base
  • Valuation, rows 6–19: Dividend per share, Discount factor, Present value, Present value of FY1 to FY6 dividends…
Telecom tower model: tenancies per tower
  • Assumptions, rows 70–75: Discount rate (WACC), Terminal growth rate, Entry multiple, EV / FY0 EBITDAaL, Exit multiple, EV / FY8 EBITDAaL…
  • Valuation, rows 6–17: Unlevered free cash flow, Discount factor, Present value, Present value of FY1 to FY8 cash flows…
Mining model: copper-gold mine NAV
  • Assumptions, rows 68–71: Discount rate, real, Second discount rate, real, Shares outstanding, Share price, assumed
  • NAV, rows 6–8: Unlevered free cash flow, Discount factor, Present value
  • NAV, rows 11–19: Value of the mine, Less: net debt, FY0, Net asset value, NAV per share…
Container shipping model: liner company
  • Assumptions, rows 73–75: Discount rate (WACC), Through-the-cycle multiple, EV / average EBITDA, Shares outstanding
  • Valuation, rows 6–14: Unlevered free cash flow, Discount factor, Present value, Present value of FY1 to FY6 cash flows…
Airline operating and valuation model
  • Assumptions, row 103: Terminal growth rate
  • Valuation, rows 11–23: EBIT, Less tax on EBIT, Add depreciation and amortisation, Less capital spending…
Multi-store retail model
  • Assumptions, rows 84–86: Discount rate (WACC), Terminal growth, Shares in issue
  • Cash Flow, row 43: Unlevered free cash flow, after rent
  • Valuation, rows 5–13: Years from FY0 to FY5, Present value of FY1 to FY5 unlevered free cash flow, Terminal value at FY5, Present value of the terminal value…
  • Valuation, rows 16–20: Enterprise value / FY1 EBITDA before IFRS 16, Add: lease liability, FY0, Enterprise value including leases, Enterprise value including leases / FY1 EBITDA under IFRS 16…
Restaurant franchise roll-out model
  • Assumptions, rows 90–92: Discount rate (WACC), EV / EBITDA, company restaurants, EV / EBITDA, franchise royalties and fees
  • Cash Flow, rows 31–32: Tax on EBIT, Unlevered free cash flow
  • Valuation, rows 6–13: Company restaurants: margin less field management, Franchise: revenue less franchise support, Corporate costs, Company restaurants at their multiple…
  • Valuation, rows 16–27: Years from FY0 to FY5, Present value of FY1 to FY5 unlevered free cash flow, Terminal value at FY5, Present value of the terminal value…
  • Valuation, rows 30–31: Enterprise value, sum of the parts on FY1 EBITDA, Value per share on FY1 multiples
Payments processing and monetisation model
  • Assumptions, rows 87–92: Peer EV / FY1E net revenue, low, Peer EV / FY1E net revenue, mid, Peer EV / FY1E net revenue, high, Peer EV / FY1E EBITDA, low…
  • Assumptions, row 96: Terminal growth
  • Cash and Valuation, rows 12–21: EBITDA, Interest earned on the settlement float, Less tax, Less capital spending…
  • Cash and Valuation, rows 42–50: Discount factor, Present value of free cash flow, Sum of present values, FY1E to FY5E, Terminal value at the end of FY5E…
Telecom operator model: mobile and fibre
  • Assumptions, rows 90–92: Discount rate (WACC), Terminal growth rate, Peer multiple, EV / FY1 EBITDAaL
  • Valuation, rows 6–9: Unlevered free cash flow, Discount factor, Present value, Present value of FY1 to FY6 cash flows
  • Valuation, rows 12–25: Net connections a year in steady state: FY6 build x mature penetration, Cost of a new connection: connection capex and acquisition after tax, FY6 prices, Add back: FY6 connection costs above the steady state, Terminal-year free cash flow…
  • Valuation, rows 28–32: Perpetuity on the terminal-year free cash flow, Terminal value, Present value of the terminal value, Enterprise value…
  • Valuation, rows 40–45: Enterprise value / FY1 EBITDAaL, implied by the DCF, Enterprise value at the peer multiple, Equity value per share at the peer multiple, DCF value per share above or below the peer multiple’s…
Semiconductor foundry model
  • Assumptions, rows 20–24: Cost of capital (WACC), Terminal growth, EV / EBITDA for the cross-check, Net cash at the end of FY0A…
  • Profit and Cash Flow, rows 19–25: Add depreciation, Less capital spending, Net working capital, Less increase in working capital…
  • Valuation, rows 6–18: Unlevered free cash flow, Discount factor, Present value, Present value of FY1E to FY7E…
  • Valuation, rows 21–22: Enterprise value at the multiple, Value per share, EV / EBITDA
Duolingo operating model
  • Forecast, rows 56–58: Discount rate, Terminal growth, Terminal multiple, EV / adjusted EBITDA (cross-check)
  • Valuation, rows 6–10: Free cash flow less stock-based compensation, Less interest earned on cash, after tax, Free cash flow to value, Discount factor, end of year…
  • Valuation, rows 13–26: Sum of present values, FY2026E to FY2030E, Terminal value, perpetuity growth on the FY2030E cash flow to value, Terminal value, exit multiple on FY2030E adjusted EBITDA, Present value of the terminal value (perpetuity growth)…
  • Valuation, rows 29–31: Present value of forecast stock-based compensation, Stock-based compensation, Value per share if stock-based compensation were added back
Airbnb operating model
  • Forecast, rows 90–92: Discount rate (illustrative), Terminal growth (illustrative), Terminal multiple, EV / EBITDA after SBC (illustrative cross-check)
  • Valuation, rows 6–11: Free cash flow (Airbnb’s definition), Less stock-based compensation, Less interest income on company cash and customer funds, net of the notes’ interest, after cash tax, Free cash flow after SBC, before interest…
  • Valuation, rows 15–25: Sum of present values, FY2026E to FY2030E, FY2030E cash flow before the change in unearned fees, Terminal-year change in unearned fees, normalised: FY2030E unearned fees x terminal growth, Terminal cash flow, first year after FY2030E…
  • Valuation, rows 43–45: Interest on customer funds after cash tax, Present value of that interest, with a terminal value at the same growth, Memo: value per share of the interest on customer funds, left out of the value
  • Valuation, rows 48–49: Present value of forecast stock-based compensation, with its terminal value, Value per share if stock-based compensation were added back
Spotify operating model
  • Forecast, rows 73–75: Discount rate (editorial), Terminal growth (editorial), Exit multiple, EV / FY2030E EBITDA after SBC (cross-check, editorial)
  • Valuation, rows 6–11: Free cash flow less share-based compensation, Less interest earned on cash, after tax, Less lease payments, charged as a recurring cost, Free cash flow to value…
  • Valuation, rows 14–16: FY2030E working capital inflow, at FY2030E revenue growth, The same inflow at terminal growth, Terminal-year cash flow: FY2030E with working capital normalised
  • Valuation, rows 37–40: Terminal value, exit multiple on FY2030E EBITDA after SBC, Enterprise value on the exit multiple, Value per share on the exit multiple, EV / FY2030E EBITDA after SBC that the perpetuity terminal value implies
  • Valuation, rows 43–45: Share-based compensation, Present value of forecast share-based compensation, with its terminal value, Value per share if share-based compensation were added back
Adyen operating model
  • Forecast, rows 101–103: Discount rate (editorial), Terminal growth (editorial), Exit multiple, EV / FY2030E EBITDA (cross-check, editorial)
  • Valuation, rows 6–14: Income before net finance income and income taxes, Less tax on it, Add amortisation and depreciation, Less CapEx…
  • Valuation, rows 31–34: Interest on merchant balances, after tax, Present value, with a terminal value at the same growth, Memo: the interest on merchant balances, per share, Memo: value per share with that interest added
  • Valuation, rows 37–40: Terminal value, exit multiple on FY2030E EBITDA, Enterprise value on the exit multiple, Value per share on the exit multiple, EV / FY2030E EBITDA that the perpetuity terminal value implies
  • Valuation, rows 43–45: Share-based compensation, Present value of forecast share-based compensation after tax, with its terminal value, Value per share if share-based compensation were added back

What a reviewer looks for

  • Growing the final-year cash flow one more time under one method and not the other.
  • Discounting the terminal value by the wrong number of periods.
  • A terminal share of value quoted without the reader being told it.

Learn it, then build it

Vocabulary: DCF, Terminal Value.

Other valuation and returns