Operating schedules · in 17 models

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.

Integrated three-statement model
  • 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…
Discounted cash flow model
  • 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
Leveraged buyout model
  • 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
Telecom tower model: tenancies per tower
  • 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
Mining model: copper-gold mine NAV
  • 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
Container shipping model: liner company
  • 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
Medtech installed-base and consumables model
  • 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
Healthcare services model: hospital operator
  • 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…
Airline operating and valuation model
  • 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
Multi-store retail model
  • 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…
Restaurant franchise roll-out model
  • 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…
Payments processing and monetisation model
  • 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)
Telecom operator model: mobile and fibre
  • 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
Semiconductor foundry model
  • 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…
GPU cloud infrastructure model
  • 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…
ICG management buyout model
  • 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
CoreWeave operating model
  • 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

Vocabulary: The Three Financial Statements.

Other operating schedules

Working capital scheduleAirline capacity and traffic: ASK, RPK and load factorAirline unit revenue and unit cost: RASK and CASKAirline fuel cost and hedgingType curves and production declineOil and gas reserves roll-forwardRealised prices and the field netbackUnits-of-production DD&AContainer fleet: owned, chartered, newbuilds and scrappingMine plan: from ore reserve to payable metalC1 cash cost and all-in sustaining costMine closure and rehabilitation provisionLiftings and freight rate: a liner’s revenueSystem sales and royalties: a franchisor’s units and volumesRestaurant unit economics: restaurant margin and new-unit returnsBunker fuel and the bunker adjustment factorRate base roll-forwardAllowed revenue: the building blocksRegulatory lag: earned against allowed returnHeadcount pyramid: hiring, attrition and promotionMobile subscriber roll-forward: gross adds, churn, net addsFibre build: homes passed, penetration and connectionsSpectrum licences: auction payments and amortisationTower site roll-forward: build-to-suit and decommissioningTenancy roll-forward: anchor, colocation and the tenancy ratioTower unit economics: yield on cost by tenantGround lease schedule: rent, escalators and buy-outsUtilisation and realisation: hours to fee revenueProfit per partner: pay, bonus pools and partnership profitStore estate roll-forward and cohortsRetail sales: density, like-for-like and onlineFour-wall EBITDA and new-store paybackStore leases under IFRS 16Driver-based budget: volume, price, heads and cost per headRolling forecast: actuals, reforecast and the outturnPrice-volume-mix: revenue and margin varianceCost variances: rate, volume, heads and cost per headEBITDA bridge: plan to actual and forecastCapacity cohorts: MW, GPUs, utilisation and revenueBacklog roll-forward: contracts to revenue to cashCapital roll-forwardRisk budgetTrading cost baseSponsorship revenue