Capex and depreciation (PP&E roll-forward)
Opening, plus capex, less depreciation, closing.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: capex and depreciation (pp&e roll-forward).Updated 30 September 2026
Part of m&a and private equity models, with the models, labs and guides around it.
Part of project finance and infrastructure models, with the models, labs and guides around it.
Part of healthcare financial models, with the models, labs and guides around it.
Part of technology company financial models, with the models, labs and guides around it.
What it does
A roll-forward: opening net PP&E, plus capital expenditure, less depreciation, equals closing. Capex is usually a share of revenue; depreciation is a rate on the opening balance, or a vintage-by-vintage waterfall in a fuller model. Closing PP&E goes to the balance sheet, capex to investing cash flow, depreciation to the income statement and back in the cash flow.
Where it lives
The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.
- Assumptions, rows 36–37: Capital expenditure, % of revenue, Depreciation, % of opening net PP&E
- Cash Flow, rows 12–13: Capital expenditure, Cash from investing
- PP&E, rows 6–11: Opening net PP&E, Capital expenditure, Depreciation, Closing net PP&E…
- Assumptions, rows 9–10: Depreciation and amortisation, % of revenue, Capital expenditure, % of revenue
- Forecast, row 9: Depreciation and amortisation
- Forecast, row 16: Less capital expenditure
- Assumptions, rows 37–38: Depreciation and amortisation, % of revenue, Capital expenditure, % of revenue
- Operating Model, row 10: Depreciation and amortisation
- Operating Model, row 22: Less capital expenditure
- Assumptions, rows 56–61: Maintenance capital spending per site, FY0, Build-to-suit cost per ground tower, FY0, Build-to-suit cost per rooftop, FY0, Augmentation cost per new colocation tenancy, FY0…
- Capex, rows 6–13: Maintenance capital spending, Build-to-suit, Augmentation, Ground buy-outs…
- Capex, rows 16–18: Net book value, opening, Depreciation, Net book value, closing
- Assumptions, rows 49–51: Sustaining capital, Expansion capital, Net book value of the mine, FY0
- Capital, rows 6–8: Sustaining capital, Expansion capital, Capital spending
- Capital, rows 11–14: Opening net book value, Depletion rate, Depletion, Closing net book value
- Assumptions, rows 51–56: Net book value of owned vessels, FY0, Average age of the owned fleet, FY0, Useful life of a vessel, Scrap value…
- Vessels, rows 6–10: Vessels dry-docked, Dry-docking spend, Dry-docking amortisation, Dry-docking component, opening…
- Vessels, rows 13–19: Net book value, opening, Vessels delivered, Vessels scrapped, at scrap value, Depreciation, FY0 fleet…
- Vessels, rows 22–24: Depreciation and amortisation, Yard instalments, Capital spending
- P&L, row 9: Depreciation of leased systems
- Cash Flow, rows 6–8: Operating profit after tax, Add: depreciation of leased systems, Less: capitalised leased systems
- Cash Flow, rows 11–12: Free cash flow, Free cash flow conversion
- Assumptions, rows 58–61: Net PP&E, FY0, Depreciation, % of opening net PP&E, Maintenance capital spending, % of revenue, Capital cost per bed added
- Cash Flow, rows 6–10: Opening net PP&E, Maintenance capital spending, Growth capital spending, Depreciation and amortisation…
- Assumptions, rows 65–71: Narrowbody: price per aircraft delivered, Widebody: price per aircraft delivered, Useful life, aircraft delivered, Residual value, % of cost…
- Costs, rows 26–30: Aircraft delivered, Other capital spending, Depreciation, FY0A owned fleet, Depreciation, aircraft delivered since FY0A…
- Financials, rows 21–24: Opening net book value, Capital spending, Less depreciation and amortisation, Closing net book value
- Assumptions, rows 62–66: Fit-out cost per new store, Maintenance capital spending per trading store, Online and central capital spending, % of net online sales, Net PP&E, FY0…
- Cash Flow, rows 6–11: Opening net PP&E, New store fit-outs, Store maintenance, Online and central…
- Assumptions, rows 67–73: Build cost per new company restaurant, Maintenance and remodelling per company restaurant, Technology and corporate capital spending, Net PP&E, FY0…
- Cash Flow, rows 6–12: Opening net PP&E, New company restaurants, Maintenance and remodelling, Technology and corporate…
- Assumptions, rows 77–81: Capital spending, % of net revenue, Depreciation, % of opening PP&E, PP&E, end of FY0A, Accrued costs, days of cash costs…
- Cash and Valuation, rows 6–9: Capital spending, Depreciation and amortisation, PP&E, closing, Check: PP&E - (FY0A + capital spending - depreciation to date)
- Assumptions, rows 62–66: Maintenance capital spending, % of service revenue, Useful life of maintenance spending, Fibre, ducts and buildings, net book value FY0, Their remaining life at FY0…
- Capex & Spectrum, rows 6–11: Maintenance capital spending, Fibre build and connections, Capital spending, Maintenance, % of revenue…
- Capex & Spectrum, rows 14–20: Depreciation, maintenance spending, Depreciation, FY0 fibre, ducts and buildings, Fibre spending to date, from FY1, Depreciation, new fibre…
- Capex & Spectrum, row 33: Depreciation and amortisation
- Assumptions, row 8: Fab equipment depreciation life
- Capex, rows 17–33: Depreciation of FY-6A spending, Depreciation of FY-5A spending, Depreciation of FY-4A spending, Depreciation of FY-3A spending…
- Assumptions, rows 70–72: GPU useful life, Fit-out useful life, GPU value at the end of Y8, % of cost
- Capacity, rows 39–47: Cohort 1: GPUs and servers, Cohort 1: fit-out, Cohort 2: GPUs and servers, Cohort 2: fit-out…
- Capacity, rows 50–64: Cohort 1: GPU depreciation, Cohort 2: GPU depreciation, Cohort 3: GPU depreciation, GPU depreciation…
- Assumptions, rows 75–81: Inter-segment revenue eliminated, Depreciation and amortisation, Maintenance capex, Strategic capex…
- Cash Flow & Debt, rows 8–9: Less maintenance capex, Less strategic capex
- Reported, rows 98–124: Technology equipment, gross, Software, gross, Data centre equipment and leasehold improvements, gross, Furniture, fixtures and other, gross…
- Derived, rows 63–68: Software life, midpoint of the disclosed range, Furniture and other, midpoint of the disclosed range, Technology equipment at the year end / its six-year life: a year’s depreciation at that size, Depreciation run-rate on everything in service at 30 June 2026, at the disclosed lives…
- Forecast, rows 49–62: Capital spending per MW added, base (editorial), Capital spending per MW added, downside (editorial), Capital spending per MW added, upside (editorial), Capital spending per MW added, selected…
- Capacity, rows 13–16: Purchases of property and equipment, Of which modelled: the second half of 2026, then each year, Vintage placed in service: cost, Vintage in service from, years from 1 January 2026
- Capacity, rows 19–23: The June 2026 fleet was in service from, on average, years from 1 January 2026, June 2026 fleet: technology equipment, June 2026 fleet: data centre equipment, June 2026 fleet: software…
- Capacity, rows 26–32: FY2026 vintage: technology equipment, FY2027 vintage: technology equipment, FY2028 vintage: technology equipment, FY2029 vintage: technology equipment…
- Capacity, rows 35–43: Depreciation: technology equipment, Depreciation: data centre equipment, Depreciation: software, Depreciation of property and equipment, modelled…
What a reviewer looks for
- Depreciation charged on the closing balance, which is circular with capex in the same year.
- A capex line on the cash flow statement that does not equal the one in the roll-forward.
- Forgetting that depreciation added back in the cash flow has to be the same figure that was deducted.
Learn it, then build it
Build · Lab · ~10 min
Depreciation Waterfall
Forecast depreciation from a capex plan rather than a ratio, read a capex-to-depreciation multiple, and say which part of the spend is buying growth and which is only standing still.
Read · Guide · 15 min
How to Build a Three-Statement Model That Actually Balances
Vocabulary: The Three Financial Statements.