🧠 Introduction - why PP&E is where three-statement models quietly fail
PP&E is one of the most common places a three statement model “looks right” but doesn’t tie. Why? Because capex is cash-based, depreciation is accrual-based, and the balance sheet is a stock measure, so small sign errors or timing assumptions compound quickly. The result is leadership seeing two different truths: a capex plan that feels reasonable and a cash runway that doesn’t.
A well-built roll-forward prevents that. It forces a single source of truth for capex timing, depreciation logic, and asset balances-so the 3 financial statements stay linked, period by period. If you’re still trying to manage PP&E with one-off formulas in the balance sheet tab, it’s usually a structure issue upstream, not a math issue.
🧭 Simple framework that you’ll use
A durable PP&E roll-forward follows a simple structure: stock (opening gross PP&E and accumulated depreciation), flow (additions, disposals, depreciation), and timing (when additions start depreciating). Then you add one mapping table that connects schedule outputs to the financial statements: capex → investing cash flow, depreciation → operating expenses (or COGS/opex), net PP&E → balance sheet.
This mapping table is what makes the model maintainable. It keeps your financial statement line items consistent, even when you add new capex categories or change the chart of accounts. And because PP&E interacts with working capital and cash timing, it’s worth aligning your schedule conventions with the rest of the model’s schedule layer.
Step-by-step implementation
Step 1: 🧱 Set up the PP&E “skeleton” with the exact outputs you need
Start by defining the outputs your 3 statement financial model must produce every period: (1) ending gross PP&E, (2) ending accumulated depreciation, (3) ending net PP&E, (4) depreciation expense (P&L), and (5) capex cash outflow (cash flow). Build the schedule so these outputs are explicit and easy to reference-no buried formulas.
Then create the roll-forward structure: Opening + Additions − Disposals = Ending (for gross PP&E), and Opening + Depreciation – Accumulated Depreciation on Disposals = Ending (for accumulated depreciation). Net PP&E is simply gross minus accumulated. If you want this to stay clean as the model grows, keep the schedule modular (one tab or one model block) and link it into the statements-don’t rebuild it inside the balance sheet.
Step 2: 🧮 model capex additions with categories and timing, you can explain
Next, model capex additions in a way that leadership can understand. At minimum, separate additions into meaningful categories (e.g., equipment, software, leasehold improvements) or into decision categories (maintenance vs growth). Your goal is not to be “perfect”-it’s to be consistent so changes in capex assumptions translate predictably into cash and depreciation.
Choose a timing convention: monthly (best), quarterly, or annual with a mid-year/half-year convention. If you’re forecasting weekly or monthly cash, don’t use annual-only capex timing; your cash flow will swing unrealistically. This is also the step where many teams introduce a silent mismatch: they forecast capex as a % of revenue in one place and as a fixed plan in another. Pick one approach and keep it consistent across your financial model.
Step 3: 🕰️ calculate depreciation with a method that matches how assets behave
Now define depreciation logic that’s stable, explainable, and aligned to how assets are used. The simplest approach is straight-line depreciation by category (each category has a useful life). Apply your timing convention to decide when depreciation starts. For example, with a mid-year convention, each year’s additions generate half a year of depreciation in year one.
If you need more accuracy, you can move to monthly depreciation (additions depreciate starting the month after purchase). The key is to avoid mixing conventions. A consistent method ensures the financial statements don’t drift over time and that your model behaves predictably when capex changes. If you’re working in a team environment, document the method right in the schedule so reviewers can validate it quickly instead of reverse-engineering formulas.
Step 4: 🔄 link the schedule into the three statements (and keep signs consistent)
Link outputs into the statements with clean sign conventions. Depreciation is a non-cash expense on the P&L (reduces profit). Capex is a cash outflow in investing cash flow (reduces cash). Ending net PP&E lands on the balance sheet. Disposals, if material, should be treated consistently: remove the disposed asset’s gross and accumulated depreciation, reflect any gain/loss if you model it, and ensure cash proceeds (if any) are captured.
This is where a lot of three-statement model work breaks: capex is accidentally treated as positive cash flow, or depreciation is double-counted in operating cash flow. Keep a single sign rule and apply it everywhere. If you’re using Model Reef, this is also a natural place to standardize the linking logic so analysts don’t “fix” mismatches by hardcoding numbers in the statements.
Step 5: ✅ add checks that catch PP&E drift before it hits leadership decks
Add lightweight checks directly under the schedule outputs. At minimum: (1) net PP&E equals gross minus accumulated, (2) capex in cash flow equals schedule capex, (3) depreciation in P&L equals schedule depreciation, and (4) net PP&E doesn’t go negative without a flagged reason.
Then add a reconciliation check that makes PP&E “cash proof”: change in net PP&E should be explainable by capex, depreciation, and disposals. You don’t need a complex audit system-just enough checks to prevent silent drift. If your team reviews the model weekly, these checks turn review time into decision time. For organizations that struggle with versioning (multiple people editing schedules), a governed workflow in Model Reef keeps the PP&E logic stable and reviewable across updates.
🏢 Examples and real-world use cases
A growth-stage operator plans a major infrastructure upgrade. Leadership cares about two things: “Can we fund the capex?” and “What does it do to margins?” The finance team builds a PP&E roll-forward inside the 3 statement financial model with category-level capex timing and straight-line depreciation. The schedule outputs depreciation to the P&L and capex to investing cash flow, so cash runway updates immediately when the capex plan changes.
The team then pairs it with a financing view (revolver availability and debt draws) to ensure the capex plan doesn’t create an accidental liquidity event. By keeping PP&E modular, they can run fast what-ifs without rewriting the financial statements each time.
🚀 Next steps
Build the PP&E roll-forward with explicit outputs, consistent timing, and lightweight checks. Then validate the links: capex → investing cash flow, depreciation → P&L, net PP&E → balance sheet. Once it ties, standardize the schedule so each forecast cycle is a refresh, not a rebuild.
If your capex plan is a real decision lever (not just an accounting line), pair PP&E with financing capacity and scenario-style toggles so leaders can see trade-offs quickly. Model Reef can support this by keeping the PP&E schedule and assumptions centralized, so you can test capex timing, funding options, and margin impact without copying spreadsheets across teams.
Back