Depreciation Calculator
CU-53Enter the cost, the salvage value and the useful life of an asset, pick a method and read the depreciation for each year with the book value left.
Runs in your browser. Nothing is uploaded.
Inputs
Result
| Year 1 depreciation | 1,800.00 |
|---|---|
| Total depreciation | 9,000.00 |
| Book value after year 5 | 1,000.00 |
| Depreciable amount (cost minus salvage) | 9,000.00 |
| Method | Straight line |
| Share of the depreciable amount each year | 20.00% |
Yearly schedule (CSV)
Year,Depreciation,Accumulated depreciation,Book value at year end 1,1800.00,1800.00,8200.00 2,1800.00,3600.00,6400.00 3,1800.00,5400.00,4600.00 4,1800.00,7200.00,2800.00 5,1800.00,9000.00,1000.00
How to use it
- Type the cost of the asset and its salvage value.
- Enter the useful life in whole years.
- Choose straight line, sum of the years' digits, double declining, 150 percent declining or fixed-rate declining balance.
- Read the schedule, then copy or download it as CSV.
The methods
Straight line charges (cost - salvage) / life each year. Sum of the years' digits charges (cost - salvage) x (remaining life) / (life x (life + 1) / 2). Declining balance charges the opening book value x factor / life: the factor is 2 for double declining and 1.5 for 150 percent. The fixed-rate version charges the opening book value x (1 - (salvage / cost)^(1 / life)) and ends at salvage. Each year is rounded to the cent, so the rows add up exactly.
A worked example
An asset costing 10,000 with salvage 1,000 and a life of 5 years: straight line gives 1,800 a year. Sum of the years' digits gives 3,000, 2,400, 1,800, 1,200 and 600. Double declining gives 4,000, 2,400, 1,440, 864 and 296, where the last charge is capped so the book value stops at 1,000. Fixed-rate declining gives 3,690.43 in year 1 and leaves a book value of 6,309.57.
Switching and limits
Declining balance methods can leave book value above salvage in the last year. The option on this page lets the schedule switch to straight line on the remaining book value in any year it charges more, which ends exactly at salvage. Choose the other option to stop at salvage without switching. There is no partial first year, and tax systems with their own tables are not applied.
Error messages and what to do
| Message | What it means | Fix |
|---|---|---|
Salvage value cannot be higher than the cost. | The salvage value you typed is above the cost. | Lower the salvage value or raise the cost. |
Useful life must be a whole number of years. | The life has decimals. | Enter whole years. |
Cost must be above 0. | The cost is zero. | Enter a cost above zero. |
Questions people ask
What is the difference between straight line and declining balance?
Straight line spreads the same charge over every year. Declining balance charges more in the early years and less later, because it applies a rate to the shrinking book value.
What is double declining balance?
It applies a rate of twice the straight line rate, 2 / life, to the opening book value each year. A 5 year asset uses 40 percent. It never takes the book value below salvage.
What is the sum of the years' digits method?
It adds up the digits 1 to the life, 15 for 5 years, and charges the fraction remaining life / 15 of the depreciable amount. Year 1 charges 5/15, year 2 4/15 and so on.
What salvage value should I use?
Use the amount you expect to get for the asset at the end of its life, which can be zero. The fixed-rate declining method needs a value above zero because of how its rate is defined.
Does this follow tax depreciation rules?
No. Tax systems often use their own tables and conventions, such as a half-year first year. This page shows the standard accounting methods only, so check your tax rules separately.
About this tool
Straight line: (cost - salvage) / life each year. Sum of the years digits: (cost - salvage) x remaining life / (life x (life + 1) / 2). Declining balance: opening book value x factor / life, with factor 2 for double declining and 1.5 for 150 percent. The fixed-rate version uses 1 - (salvage / cost) to the power of 1 / life and needs a salvage value above zero. Each year is rounded to the cent and the last year closes the schedule, so rows add up exactly. Whole years only: there is no part-year first year. Tax rules such as MACRS tables and tax limits are not applied.