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%.
| Item | Value |
|---|---|
| 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 debt | 6.0% |
| Tax rate | 25% |
| Cash flow after tax | 100% 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.
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.
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.
| Year | Interest | EBT | Tax, correct | Tax on EBIT | Debt, correct | Debt, on EBIT |
|---|---|---|---|---|---|---|
| 1 | 36.0 | 114.0 | 28.5 | 37.5 | 514.5 | 523.5 |
| 2 | 30.9 | 119.1 | 29.8 | 37.5 | 425.2 | 442.4 |
| 3 | 25.5 | 124.5 | 31.1 | 37.5 | 331.8 | 356.5 |
| 4 | 19.9 | 130.1 | 32.5 | 37.5 | 234.2 | 265.3 |
| 5 | 14.1 | 135.9 | 34.0 | 37.5 | 132.3 | 168.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.
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.
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.
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.
Free Excel template: LBO 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).
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.
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%.
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 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.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →