Depreciation Calculator
Straight-line, sum-of-years-digits, and declining-balance depreciation schedules with CSV export.
Educational estimate only — not investment, lending, or financial advice. Confirm figures with statements or a qualified professional before you act.
About this tool
Enter an asset's cost, salvage value and useful life, and choose a method. You get a year-by-year schedule showing depreciation, accumulated depreciation and book value, which you can download as CSV.
How to use
How it works
Straight line spreads cost minus salvage evenly. Sum-of-years' digits and declining balance front-load the expense. Declining balance multiplies the opening book value by factor ÷ life, but never takes book value below salvage. The crossover version switches to straight line over the remaining life once that gives a bigger charge.
SL = (cost − salvage) ÷ life SYD year k = (cost − salvage) × (life − k + 1) ÷ [life × (life + 1) ÷ 2] DB = opening book × factor ÷ life
Worked example
Cost 11,000, salvage 1,000, 5 years
- Input
- Cost 11,000; salvage 1,000; life 5; method straight line
- Output
- 2,000 a year; book value falls from 11,000 to 1,000
- Walkthrough
- (11,000 − 1,000) ÷ 5 = 2,000. Sum-of-years' digits gives 3,333.33 in year 1 (10,000 × 5 ÷ 15). Double-declining gives 11,000 × 40% = 4,400 in year 1, and a final-year charge limited to 425.60 so the book value stops at 1,000. Over 10 years, crossover takes 422.75 in year 9 where plain declining balance takes 369.10.
Limitations
- Whole years only, with no mid-year or monthly convention.
- Tax depreciation rules (such as MACRS) differ and are not modelled.
- Salvage must be below cost.
Questions
How do I calculate straight-line depreciation?
What is double-declining balance?
Why does declining balance stop short in the last year?
What does the crossover method do?
Features
- Four methods
- Year-by-year schedule
- CSV download
- Runs in your browser
Related resources
Guides and videos from around the web—opens on YouTube or the publisher’s site.
Introduction to interest
Khan Academy
Simple vs compound framing for NOM/EFF conversions.
Watch on YouTubeCompound interest introduction
Khan Academy
Core compounding behind TVM and ICONV tools.
Watch on YouTube
- Time value of money
Wikipedia
TVM equation background for financial calculator pages.
- Mortgage Formulas
Math is Fun
Amortization math behind loan schedule export.