The statements · in 9 models

Tax

Tax on profit, and tax on operating profit.

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

On this subject: tax.Updated 30 September 2026

Part of m&a and private equity models, with the models, labs and guides around it.

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

In an operating model, tax is a rate applied to profit before tax. In an unlevered valuation it is applied to EBIT, because the cash flow being valued belongs to debt and equity together. The simple treatment floors tax at zero in a loss year; a fuller model carries a loss forward and offsets it, which is a schedule of its own.

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, row 13: Tax rate on operating profit
  • Forecast, row 11: Tax on EBIT
Leveraged buyout model
  • Assumptions, row 40: Tax rate
  • Operating Model, row 16: Tax
Merger model: accretion and dilution
  • Assumptions, row 12: Marginal tax rate
  • Pro Forma EPS, row 17: Tax on adjustments
Mining model: copper-gold mine NAV
  • Assumptions, rows 58–59: Tax rate, Tax losses brought forward, FY0
  • Cash Flow, rows 11–17: Taxable income before losses, Opening tax losses, Less: losses used, Add: loss for the year…
Airline operating and valuation model
  • Assumptions, row 85: Tax rate
  • Financials, row 6: EBIT
  • Financials, rows 9–11: Profit before tax, Tax, Net income
Payments processing and monetisation model
  • Assumptions, row 82: Tax rate
  • Income Statement, row 41: Tax
Spotify operating model
  • Reported, rows 36–51: Finance income, Of which interest income, Finance costs, Of which fair value movements on the Exchangeable Notes…
  • Derived, rows 56–67: Finance income/(costs) excluding the notes’ fair-value movements, Net income excluding the notes’ fair-value movements, before any tax effect, Interest income / opening cash and short term investments, Effective tax rate…
  • P&L & Cash Flow, rows 41–48: Opening cash and short term investments, Finance income/(costs), net, Income before tax, Income tax expense (book)…
Adyen operating model
  • Reported, rows 54–66: Finance income (interest on balances at central and commercial banks), Finance expense, Other financial results, Net finance income…
  • Derived, rows 126–130: Income taxes, % of income before tax, Net income over diluted weighted shares, Diluted weighted shares, growth, Dilutive effect of share plans…

What a reviewer looks for

  • Applying tax to EBITDA.
  • Letting a loss year produce a negative tax charge in a model with no loss carry-forward.
  • A statutory rate where the case calls for an effective one.

Learn it, then build it

Vocabulary: EBITDA.

Other the statements