Depreciation Schedule
Build a year-by-year depreciation schedule from cost, salvage, and useful life.
Measures periodic depreciation expense and closing book value under SL or declining-balance.
Use it to sanity-check fixed-asset registers and CapEx planning.
Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.
Depreciation Schedule
Build a year-by-year depreciation schedule from cost, salvage, and useful life.
Sample figures (250k cost · 25k salvage · 5 years SL).
Asset inputs
Cost, salvage, useful life, and method. Declining-balance uses the DB rate you set (e.g. 200% = double-declining). Persist locally · Jump to results
Year schedule
Depreciation expense, accumulated depreciation, and closing book value by year.
Equations
- SL annual = (Cost − Salvage) ÷ Life
- DB annual = Opening BV × (DB% ÷ 100 ÷ Life), floored at salvage
| Year | Opening BV | Depreciation | Accum. dep. | Closing BV |
|---|
How this is calculated
- Straight-line spreads (cost − salvage) evenly over useful life
- Declining-balance applies DB% ÷ life to opening book value each year, never below salvage
- Final year pulls book value to salvage when needed
Illustrative — not financial advice. Pair with CapEx plans and fixed-asset registers.
Take it with you
Get the worked example workbook in Excel — type your own numbers into it.
The Excel is the worked example workbook — type your own numbers into it. Stays on your device.