Financial model review
Capex and depreciation checks in Excel
Review capex and depreciation in Excel with a worked asset schedule, useful-life and start-date checks, and links between cash, profit and asset balances.

To check a capital expenditure schedule, follow an asset from purchase and payment through its use, depreciation and closing balance. Then reconcile the schedule to cash flow, profit and the balance sheet. The purchase price, the cash paid and the depreciation expense can belong to different periods.
Use a review copy and agree the model's accounting and timing assumptions first. The invented straight-line examples below exclude taxes, leases, impairment, revaluation, disposals and financing costs unless explicitly mentioned. They are deliberately simpler than a complete fixed-asset register.
Separate the three questions
A useful schedule answers three distinct questions:
- What asset cost is recognized, and when?
- When does the business pay the supplier?
- How much depreciation is charged in each period?
The IFRS Foundation's IAS 16 overview describes recognition and measurement of property, plant and equipment, including depreciation. An expenditure label alone does not decide its treatment. Review the nature of the spending and the applicable policy before assuming every equipment-related payment creates a depreciable asset.
Give each project or asset group a clear source, cost, payment timetable, useful life and residual value. Record when it is ready for its intended use and how the model translates that date into a depreciation start. Do not let the payment date silently answer every timing question.
Recalculate one asset independently
Assume equipment costs EUR 120,000, has an estimated residual value of EUR 12,000 and a six-year useful life. For this exercise, use straight-line depreciation, equal monthly charges and a July 1 start with six charges in the first calendar year.
Depreciable amount = 120,000 - 12,000 = EUR 108,000
Annual depreciation = 108,000 / 6 = EUR 18,000
Monthly depreciation = 18,000 / 12 = EUR 1,500
First-year depreciation = 1,500 × 6 = EUR 9,000
First year-end carrying amount = 120,000 - 9,000
= EUR 111,000
Microsoft's SLN function documentation defines the cost, salvage value and useful-life inputs for straight-line depreciation. =SLN(120000,12000,6) gives the annual charge in this example because life is expressed in years. It does not independently choose an appropriate useful life or start date.
Follow a second year too. With twelve further monthly charges and no other movements, depreciation is EUR 18,000 and the carrying amount becomes EUR 93,000. Check that the schedule does not restart the asset's useful life in each annual column.
Test partial periods and the final charge
The July example uses an explicit monthly convention. A daily convention or a different approved policy can give a different first-year result. Document that choice rather than treating every difference from six months as an error.
In a review copy, move the assumed start from July 1 to August 1. Under the same convention, the first year has five charges: EUR 7,500 depreciation and EUR 112,500 carrying amount. A formula still producing EUR 9,000 may be disconnected from its start-date input.
Inspect the end of the schedule as carefully as the beginning. In this simplified example, total lifetime depreciation should be EUR 108,000 and the remaining carrying amount EUR 12,000. A copied formula must stop or adjust its final charge instead of continuing indefinitely. Other asset movements or revised estimates need their own treatment, rather than being hidden by a blanket zero floor.
Reconcile gross cost and accumulated depreciation
Gross cost is not the same as the net asset balance. Accumulated depreciation records the depreciation charged to date. A simple no-disposal bridge makes the distinction visible.
Suppose existing assets have opening gross cost of EUR 200,000 and accumulated depreciation of EUR 80,000, so their opening net balance is EUR 120,000. Add the new equipment above. Existing assets incur EUR 20,000 of depreciation during the year; the new equipment incurs EUR 9,000.
Closing gross cost = 200,000 + 120,000 = EUR 320,000
Closing accumulated depreciation = 80,000 + 20,000 + 9,000
= EUR 109,000
Closing net assets = 320,000 - 109,000 = EUR 211,000
Cross-check = 120,000 + 120,000 - 29,000 = EUR 211,000
Compare both routes with the balance-sheet asset line. Check for an addition counted in both a project subtotal and the detailed asset list. If assets are sold, remove the corresponding gross cost and accumulated depreciation and review any gain or loss separately; subtracting cash proceeds from gross cost is not a complete disposal bridge.
Trace payment timing without duplicating cash
Assume the EUR 120,000 equipment is paid through a EUR 24,000 deposit in March and EUR 96,000 final payment in June, before the July depreciation start used above. Those cash payments total EUR 120,000, while first-year depreciation remains EUR 9,000 under the stated assumptions.
Trace prepayments or supplier balances during the intervening periods. The asset schedule should not add another EUR 120,000 cash payment when the equipment starts depreciating. Likewise, a model should not treat the EUR 9,000 charge as an additional supplier payment.
In a simple indirect cash-flow bridge, depreciation already deducted in the starting profit measure is added back because it is noncash; capital expenditure payments are then included separately. Check the actual starting subtotal before adding anything back. The cash-flow checklist explains why mixing direct receipts and payments with profit adjustments can duplicate movements.
Check the links and retain the assumptions
Tie each period's depreciation to its intended profit or cost destination and the asset balance to the balance-sheet review. Make those destinations explicit so that a charge is neither omitted nor counted twice. Trace the final totals instead of assuming that matching row labels establish a working link.
FinModelCheck does not select accounting policies, calculate depreciation or reconcile fixed assets. It inspects supported saved Excel evidence and does not recalculate the workbook. An embedded life or rate can be a review Finding without proving that the assumption is wrong; see numbers inside formulas.
Use the checker as a supplementary step and see the example report. Online results contain the provisional score and counts by Finding type, with no detailed Findings. The complete PDF is free without registration in the current valid owning browser session.
Frequently asked questions
Should depreciation equal capital expenditure?
No. Capital expenditure adds assets, while depreciation allocates depreciable cost over useful periods. They may coincide by chance but should not be forced to match.
Is a negative asset balance always a formula error?
It needs investigation. Check signs, disposals, repeated depreciation and the asset definition before deciding the cause. Do not erase it with an unexplained balancing entry.
Can Excel's SLN function choose the correct accounting assumptions?
No. It calculates from supplied inputs. Useful life, residual value, method and timing require a separate assessment; a valid formula does not establish that those choices are appropriate.


