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.
- Assumptions, row 13: Tax rate on operating profit
- Forecast, row 11: Tax on EBIT
- Assumptions, row 40: Tax rate
- Operating Model, row 16: Tax
- Assumptions, row 12: Marginal tax rate
- Pro Forma EPS, row 17: Tax on adjustments
- Earnings, row 15: Tax
- 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…
- Assumptions, row 85: Tax rate
- Financials, row 6: EBIT
- Financials, rows 9–11: Profit before tax, Tax, Net income
- Assumptions, row 82: Tax rate
- Income Statement, row 41: Tax
- 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)…
- 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
Read · Guide · 16 min
How to Build a DCF Model: From Operating Assumptions to a Defensible Valuation
Read · Guide · 15 min
How to Build a Three-Statement Model That Actually Balances
Vocabulary: EBITDA.