Depreciation is not a cash cost, but it decides when tax is paid. The method moves value through timing alone, and the gain can be measured in three lines.
On a 1,000 asset written off over five years with a 25% tax rate and a 9% discount rate, the depreciation tax shield is worth 194.5 on straight-line, 206.7 on double-declining balance and 229.4 if the whole cost is expensed in year one. Project NPV moves from 69.7 to 81.9 and 104.5: 34.9 of value from timing alone, on identical operations and the same 250 of total tax relief.
A discounted cash flow does not value depreciation. It values the tax that depreciation changes. Two models with the same revenue, costs and asset can give different values only because one writes the asset off faster, and in a capital-heavy business that difference is not small.
| Item | Value |
|---|---|
| Cost of the asset, paid today | 1,000 |
| Tax life, no salvage value | 5 years |
| EBITDA, each year for five years | 300 |
| Tax rate | 25% |
| Discount rate | 9% |
Straight-line is 1,000 / 5 = 200 a year. Double-declining takes 2 / 5 = 40% of the opening book value each year and switches to straight-line over the remaining life once that is larger: year 1 is 1,000 × 40% = 400, year 2 is 600 × 40% = 240, year 3 is 360 × 40% = 144. In year 4 the book value is 216, the declining charge would be 86.4 and straight-line over the two years left gives 108, so the switch is made. Full expensing deducts everything in year one.
| Year | Straight-line | Double-declining | Full expensing |
|---|---|---|---|
| 1 | 200 | 400 | 1,000 |
| 2 | 200 | 240 | 0 |
| 3 | 200 | 144 | 0 |
| 4 | 200 | 108 | 0 |
| 5 | 200 | 108 | 0 |
| Total | 1,000 | 1,000 | 1,000 |
Tax shield in year t = depreciation in year t × tax rate
PV of shield = Σ shieldt / (1 + r)t
Excel: =NPV(r, shields)
Straight-line: 200 × 25% = 50 a year. The five-year annuity factor at 9% is 3.8897, so the present value is 50 × 3.8897 = 194.5. Double-declining gives shields of 100, 60, 36, 27, 27, worth 206.7. Full expensing gives 250 in year one: 250 / 1.09 = 229.4.
Each year’s cash flow is EBITDA less tax, and tax is (EBITDA − depreciation) × 25%. With straight-line, tax is (300 − 200) × 25% = 25 a year, so cash flow is 275 a year and NPV = −1,000 + 275 × 3.8897 = 69.7.
| Method | PV of tax shield | Project NPV | Gain over straight-line |
|---|---|---|---|
| Straight-line | 194.5 | 69.7 | 0.0 |
| Double-declining | 206.7 | 81.9 | 12.2 |
| Full expensing | 229.4 | 104.5 | 34.9 |
The NPV gain equals the gain in the PV of the shield exactly (12.2 and 34.9), because operations and total relief are identical. The project is worth 3.5% of its cost more with full expensing.
At 12% the shield on straight-line is worth 180.2, on double-declining 195.2 and with full expensing 223.2. The gain over straight-line is 15.0 for double-declining and 43.0 for full expensing, against 12.2 and 34.9 at 9%. Every shield is smaller at the higher rate, but the front-loaded ones shrink least.
=VDB(cost,0,life,start,end,2) gives double-declining with the switch to straight-line; =SLN(cost,0,life) gives straight-line.Free Excel template: DCF terminal value template.
Not by itself. It lowers taxable profit, so tax falls by depreciation times the tax rate. On a 1,000 asset at 25% the total relief is 250, whatever the method.
Because the same 250 of relief arrives sooner. Straight-line gives 50 a year for five years; double-declining gives 100 in year one, then 60, 36, 27 and 27.
Yes. At 9% double-declining beats straight-line by 12.2; at 12% by 15.0. A higher rate makes each year of delay cost more, so bringing relief forward is worth more.
The workbooks for this book build a model from first principles, with the discounting steps in live formulas. The three depreciation schedules in this article are a separate illustration and are not in them.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →