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.
Signal Lab · Model
Depreciation Schedule
Build a year-by-year depreciation schedule from cost, salvage, and useful life.
Illustrative sample (250k cost · 25k salvage · 5 years SL). Not financial advice.
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
Download a prompt or export the Excel workbook from your current inputs.
Takes your current inputs — stays on your device.