Last updated
Was this helpful?
This guide explains how to model capital expenditure (capex) and depreciation in Model Reef using Asset variables and timing rules. The goal is to connect investment plans to P&L, Balance Sheet and Cashflow.
Before you start
You should have:
A basic understanding of Asset variables.
A view of planned capital projects and maintenance capex.
A sense of appropriate useful lives for different asset classes.
If new to Assets, review:
Variable Type Specifications (Assets)
Build a Full Financial Model from Scratch
Asset variables representing capex for different asset classes or projects.
Depreciation schedules over the useful lives of assets.
A clear picture of capex in Cashflow and depreciation in P&L.
Asset balances over time in the Balance Sheet.
For each asset class or project:
Create an Asset variable, for example:
Capex - Manufacturing Equipment
Capex - New Store Fitout
Define:
Purchase amounts per period.
Timing of purchases.
Choose the depreciation method, for example:
Straight line.
Reducing balance.
Units of production.
Set the useful life in periods according to your accounting policy.
These Asset variables will automatically:
Increase Assets on purchase.
Trigger capex cash outflows.
Generate depreciation expense.
If the business already has existing assets:
Use the opening balance functionality to set starting Asset balances.
Provide any required offset entries to keep the Balance Sheet balanced, for example:
Retained earnings.
Equity.
Optionally create separate Asset variables for existing assets with:
Remaining useful life.
Depreciation from model start date onward.
This ensures the starting Balance Sheet is realistic.
In the Cashflow Statement:
Capex appears in Investing Cashflow as cash outflows.
In the Balance Sheet:
Asset balances reflect cumulative capex minus depreciation.
If you model disposals manually, Asset balances should reflect those too.
Use charts or custom series to track total Assets or capex by year for planning.
Although Model Reef does not enforce a specific split, it is often helpful to distinguish:
Maintenance capex:
Required to sustain current operations.
Growth capex:
Intended to expand capacity or reach.
You can represent this with separate Asset variables, for example:
Capex - Maintenance - Stores
Capex - Growth - New Stores
This allows you to see how much of total capex is driving incremental growth versus sustaining the base.
Create separate models, for example:
Model - Capex - Base Plan
Model - Capex - Expansion
Model - Capex - Deferred Investment
In each:
Adjust capex timing and amounts.
Observe effects on cash, leverage, and valuation.
This helps determine whether the returns justify the investment profile.
Asset variables correctly represent planned capex.
Depreciation schedules look reasonable and align with useful lives.
Cashflow captures capex in the correct periods.
Asset balances in the Balance Sheet are plausible and do not become negative.
Check useful lives, methods and whether you have double counted assets or opening balances.
Confirm purchase dates and that Asset variables are configured with the correct start periods.
Revisit opening balances and ensure offsetting entries are correct.
Last updated
Was this helpful?
Was this helpful?