L3VLUP
← L3VLUP Labs
Free · no sign-up

Depreciation Waterfall

Depreciation is not a percentage of revenue and it is not a percentage of the asset base. It is every asset the company has ever bought, each wearing out on its own clock. A waterfall says that literally: one row per vintage, each spending its own cost over its own useful life, with the year’s charge as the column total.

Change the life, switch to an accelerated method, or type over a capex year, and watch which years move. The answers people get wrong are all here: the cliff when the existing base rolls off, the charge that keeps climbing after capex has peaked, and the difference between spending to grow and spending to stand still.

Assumptions

Three inputs drive the whole schedule. Change one and watch which years move.

Existing asset baseNet PP&E carried in
Useful economic life7 years
MethodStraight line
What the method does

The same charge every year of the asset’s life. What almost every reported set of accounts uses, and the default a model should start from.

The waterfall

One row per vintage. Each row spends its own cost over its own life, and the year’s depreciation is the column added up. This is why the charge keeps climbing after capex has already peaked: the layers stack.

Existing base in 2025: 19,798Capex 2025 in 2025: 6,626202526,425Existing base in 2026: 19,798Capex 2025 in 2026: 6,626Capex 2026 in 2026: 6,715202633,140Existing base in 2027: 19,798Capex 2025 in 2027: 6,626Capex 2026 in 2027: 6,715Capex 2027 in 2027: 6,167202739,307Existing base in 2028: 19,798Capex 2025 in 2028: 6,626Capex 2026 in 2028: 6,715Capex 2027 in 2028: 6,167Capex 2028 in 2028: 4,928202844,234Existing base in 2029: 19,798Capex 2025 in 2029: 6,626Capex 2026 in 2029: 6,715Capex 2027 in 2029: 6,167Capex 2028 in 2029: 4,928Capex 2029 in 2029: 3,076202947,310Existing base in 2030: 19,798Capex 2025 in 2030: 6,626Capex 2026 in 2030: 6,715Capex 2027 in 2030: 6,167Capex 2028 in 2030: 4,928Capex 2029 in 2030: 3,076Capex 2030 in 2030: 826203048,135Existing base in 2031: 19,798Capex 2025 in 2031: 6,626Capex 2026 in 2031: 6,715Capex 2027 in 2031: 6,167Capex 2028 in 2031: 4,928Capex 2029 in 2031: 3,076Capex 2030 in 2031: 826Capex 2031 in 2031: 826203148,961Capex 2026 in 2032: 6,715Capex 2027 in 2032: 6,167Capex 2028 in 2032: 4,928Capex 2029 in 2032: 3,076Capex 2030 in 2032: 826Capex 2031 in 2032: 826Capex 2032 in 2032: 826203223,362
VintageCost20252026202720282029203020312032
Existing asset base138,58919,79819,79819,79819,79819,79819,79819,798
Capex 20256,6266,6266,6266,6266,6266,6266,626
Capex 20266,7156,7156,7156,7156,7156,7156,715
Capex 20276,1676,1676,1676,1676,1676,167
Capex 20284,9284,9284,9284,9284,928
Capex 20293,0763,0763,0763,076
Capex 2030826826826
Capex 2031826826
Capex 2032826
Total depreciation26,42533,14039,30744,23447,31048,13548,96123,362

Capex figures are editable. Click one and type to see a single investment year ripple through every year that follows. Notice the existing base falling to nothing in 2032: that cliff is the single biggest reason a depreciation forecast built as a percentage of revenue goes wrong.

Maintenance, growth, and the multiple

Depreciation is roughly what it costs to stand still. Spend above it and you are buying capacity; spend below it and you are quietly consuming the business. The ratio of the two is the fastest read on which is happening.

Year20252026202720282029203020312032
Capex46,38347,00543,17134,49421,5295,7795,7795,779
Depreciation26,42533,14039,30744,23447,31048,13548,96123,362
Maintenance capexThe part that only replaces what wore out26,42533,14039,30734,49421,5295,7795,7795,779
Growth capexSpend above the depreciation charge19,95813,8653,864
Capex / depreciationAbove 1.0 the asset base grows; below 1.0 it shrinks1.76×1.42×1.10×0.78×0.46×0.12×0.12×0.25×

Watch the multiple fall through the forecast as capex tapers while the stacked layers keep the charge high. A business can be spending less than it depreciates for years before the asset base visibly ages, which is exactly the period in which the reported earnings look best.

Where it lands: the PP&E roll-forward

Depreciation is not only an expense, it is the thing that takes the asset back off the balance sheet. Opening net PP&E, plus capex, less depreciation, equals closing. That identity is the link between the schedule above and the balance sheet, and it has to hold in every year.

Year20252026202720282029203020312032
Opening net PP&E138,589158,547172,412176,276166,536140,75498,39855,215
Plus capex+46,383+47,005+43,171+34,494+21,529+5,779+5,779+5,779
Less depreciation−26,425−33,140−39,307−44,234−47,310−48,135−48,961−23,362
Closing net PP&E158,547172,412176,276166,536140,75498,39855,21537,632

Why you take D&A from the cash flow statement, not the income statement

Depreciation is an operating expense, so it is allocated to whichever line consumed the asset. The depreciation on a factory sits inside cost of sales. The depreciation on head-office fit-out and IT sits inside SG&A. Some filers show a separate D&A line and some do not, and a company can move between presentations without anything economic changing.

That makes the income statement an unreliable place to read the total. The cash flow statement is not: the whole non-cash charge has to be added back to reconcile net income to operating cash flow, so it appears there as one clean figure whatever the income statement did with it. Take D&A from the cash flow statement, and check it against the PP&E note, which gives the split between depreciation and amortisation and the asset lives you need for the schedule above.

This is also why EBITDA built by adding back the income statement’s visible D&A line can differ from EBITDA built off the cash flow statement. If a comparable set looks inconsistent, that difference is usually where it came from.

Now push a depreciation change through all three statements under interview conditions.

Open the three-statement drill