Articles

How much does taxing EBIT instead of EBT cost an LBO model?

A balance sheet that balances does not prove the income statement is right. Tax on EBIT ignores the interest tax shield, and the error flows through cash and debt without breaking a single check.

In a leveraged buyout model with EBITDA of $200 million, depreciation of $50 million and $600 million of debt at 6.0%, year-one interest is $36 million and pre-tax profit $114 million. Tax at 25% on that is $28.5 million. Applied to EBIT of $150 million it is $37.5 million, $9.0 million too much. The balance sheet still balances. After five years of cash sweep the debt is $168.8 million instead of $132.3 million, and the equity IRR is 15.46% against 16.14%.

The assumptions

Illustrative buyout, $ million, flat operating profile
ItemValue
EBITDA, flat for five years$200
Depreciation and amortisation$50
Capital expenditure and increase in working capital$40 and $10 a year
Entry value, 6.0 times EBITDA$1,200: debt $600, equity $600
Interest rate on opening debt6.0%
Tax rate25%
Cash flow after tax100% swept to repay debt
Exit value, 7.0 times EBITDA$1,400

Interest is charged on the opening balance so that no circular reference is needed. The only difference between the two models is the base on which the tax rate is applied.

Step 1: the two tax formulas

Correct: tax = MAX(0, EBT) × t, where EBT = EBIT − interest

Wrong: tax = EBIT × t

Excel: =MAX(0,C10)*Tax against =C8*Tax

Year 1: EBIT = 200 − 50 = $150 million. Interest = 600 × 6.0% = $36 million. EBT = 150 − 36 = $114 million. Correct tax = 114 × 25% = $28.5 million. Wrong tax = 150 × 25% = $37.5 million. The difference is exactly the interest tax shield: 36 × 25% = $9.0 million. Net income is $85.5 million against $76.5 million.

Step 2: why every check still passes

A higher tax cuts net income and cash by the same amount. The cash sweep repays $76.5 million of debt instead of $85.5 million, and equity rises by net income of $76.5 million instead of $85.5 million. On the balance sheet, assets are unchanged (fixed assets fall by $10 million, working capital rises by $10 million), debt falls by $76.5 million and equity rises by $76.5 million: the two sides move together and the balance check reads zero. Sums, signs and links are all correct. The mistake is a wrong tax base, and no accounting identity tests for it.

Step 3: five years of debt

Tax and closing debt, $ million
YearInterestEBTTax, correctTax on EBITDebt, correctDebt, on EBIT
136.0114.028.537.5514.5523.5
230.9119.129.837.5425.2442.4
325.5124.531.137.5331.8356.5
419.9130.132.537.5234.2265.3
514.1135.934.037.5132.3168.8

The correct tax rises from $28.5 million to $34.0 million as interest falls with the debt. The EBIT-based tax stays at $37.5 million. After five years the debt is $132.3 million with correct tax and $168.8 million with tax on EBIT, a gap of $36.5 million. Cumulative tax is overstated by $31.6 million, and the other 4.9 is interest on debt that stayed higher. Debt to EBITDA at exit is 0.66 times against 0.84 times.

Step 4: the effect on the equity return

At exit, equity is $1,400 million less debt: $1,267.7 million against $1,231.2 million. On $600 million of equity the multiple is 2.11 times against 2.05 times, and the IRR over five years is (1,267.7 ÷ 600)1/5 − 1 = 16.14% against 15.46%. The error costs 68 basis points of IRR.

How to catch it

Add one check row: tax divided by EBT must equal the statutory rate every year. In the wrong model it reads 32.9%, 31.6%, 30.4%, 29.2%, 28.0% for years 1 to 5, when it should read 25.0%. The check costs one cell and catches this error and the related one of letting the tax fall when EBT is negative.

What if: the buyout uses $800 million of debt

With debt of $800 million, equity of $400 million and the same exit value, the larger interest bill makes the shield bigger and the error larger. Correct exit debt is $381.5 million against $436.4 million, and the equity IRR is 20.55% against 19.22%: 133 basis points, against 68 for the lower-leverage case.

The common mistakes

Takeaway

Free Excel template: LBO model.

Learn to build the whole model

Sixteen video lessons that build a complete LBO model in Excel on one case, from sources and uses to sponsor returns, with step files, exercises that check your answers, a 160-question quiz and the LBO Model, Pro Edition included ($149).

Watch lesson 1.1 and try ten quiz questions, free →

Questions readers ask

Why does a model with tax on EBIT still balance?

Because the extra tax lowers cash and equity by the same amount, so both sides of the balance sheet move together. A balance check tests the accounting identity, not whether the tax base is right.

How much does taxing EBIT instead of EBT cost an LBO?

In an illustrative buyout with $600 million of debt at 6.0% and a 25% tax rate, year-one tax is overstated by $9.0 million, exit debt is $36.5 million higher and the equity IRR falls from 16.14% to 15.46%.

What check catches the error?

Divide tax by pre-tax profit in every period and compare it with the statutory rate. With tax on EBIT the ratio reads 32.9% in year 1 and 28.0% in year 5, instead of 25.0%.

The workbooks behind this article

The free companion files for Financial Modeling from First Principles build a three-statement model, a debt schedule and a buyout from blank sheets, with the checks that catch a wrong base. The buyout in this article is invented and is not in them. No account and no email address.

Open the companion files →

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →