Articles

How much does the depreciation method change the value of a project in a DCF?

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.

The assumptions

One illustrative project
ItemValue
Cost of the asset, paid today1,000
Tax life, no salvage value5 years
EBITDA, each year for five years300
Tax rate25%
Discount rate9%

Step 1: three depreciation schedules

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.

Depreciation by year
YearStraight-lineDouble-decliningFull expensing
12004001,000
22002400
32001440
42001080
52001080
Total1,0001,0001,000

Step 2: the tax shield and its present value

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.

Step 3: what it does to project NPV

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.

Project value by method
MethodPV of tax shieldProject NPVGain over straight-line
Straight-line194.569.70.0
Double-declining206.781.912.2
Full expensing229.4104.534.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.

What if: the discount rate is 12%

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.

The common mistakes

Takeaway

Free Excel template: DCF terminal value template.

Questions readers ask

Does depreciation add cash to a DCF?

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.

Why does faster depreciation raise the value?

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.

Does the gap grow with the discount rate?

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 behind this article

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.

Open the companion files →

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

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