Fixed Asset Depreciation Register
A full multi-year depreciation schedule per asset, plus a Disposals sheet with a real gain/loss-on-disposal calculation.
No sign-up or email required. Real Excel formulas, not a screenshot.
What this template does
- ✓Calculates straight-line annual depreciation and closing WDV for each asset.
- ✓Projects the full 10-year depreciation schedule per asset, correctly pro-rating partial years.
- ✓Computes real gain/(loss) on disposal by comparing net book value at disposal to actual proceeds.
What’s inside
Fixed Asset Register
Live straight-line formulas: AnnualCharge, Year1Charge and ClosingWDVYear1 for each asset.
Depreciation Schedule
The full year-by-year charge for every asset across 10 years — correctly pro-rating the first and final years and stopping at zero once fully written off — with a yearly Total row.
Disposals
Looks up each disposed asset's cost and accumulated depreciation to derive net book value at disposal, then compares it to actual proceeds for a real gain/(loss) figure.
Read Me
The workbook's own documentation and a link back to the full guide.
How to use it
Replace the sample assets and disposals with your own. Every formula recalculates automatically across all three sheets.
Want the full walkthrough?
The guide explains every formula in this workbook step by step, with a worked example.
Go deeper
Advanced Audit & Assurance
This template is one piece of a bigger workflow. The course builds the whole thing with real datasets, step by step, with a graded assessment and a verifiable certificate.