Declining Balance Depreciation Calculator
Depreciate an asset faster in its early years with double-declining (200%) or 150% declining balance.
First-year depreciation
480.00
- Rate
- 20%
- Book value at end of life
- 300.00
Depreciation schedule
| Year | Depreciation | Accumulated | Book value |
|---|---|---|---|
| 1 | 480.00 | 480.00 | 1,920.00 |
| 2 | 384.00 | 864.00 | 1,536.00 |
| 3 | 307.20 | 1,171.20 | 1,228.80 |
| 4 | 245.76 | 1,416.96 | 983.04 |
| 5 | 196.61 | 1,613.57 | 786.43 |
| 6 | 157.29 | 1,770.85 | 629.15 |
| 7 | 125.83 | 1,896.68 | 503.32 |
| 8 | 100.66 | 1,997.35 | 402.65 |
| 9 | 80.53 | 2,077.88 | 322.12 |
| 10 | 22.12 | 2,100.00 | 300.00 |
Show the work
Rate
rate = factor ÷ life × 100
2 ÷ 10 × 100 = 20%
First year: cost × rate, at most cost − salvage
min(cost × rate, cost − salvage)
min(2,400.00 × 20%, 2,400.00 − 300.00) = 480.00
Estimates for general information only — not financial advice.
How it works
Each year: depreciation = min(book value × factor ÷ life, book value − salvage) — Excel DDB; optional switch to straight-line when that is larger (Excel VDB)
Questions
- How does the declining balance depreciation calculator work?
- Each year: depreciation = min(book value × factor ÷ life, book value − salvage) — Excel DDB; optional switch to straight-line when that is larger (Excel VDB).
- What do I need to enter?
- Asset cost, Salvage value, Useful life, Method, Switch to straight-line. Optional fields can be left blank.
Related tools
- Sum-of-Years' Digits Depreciation CalculatorDepreciate an asset with the sum-of-the-years'-digits method, which front-loads depreciation.
- Units-of-Production Depreciation CalculatorDepreciate an asset by how much it is used — per unit produced, mile driven or hour run.
- Currency ConverterConvert 24 world currencies at live exchange rates, with historical charts.
- Loan Payment CalculatorWork out the regular payment, total cost and total interest of a fixed-rate loan.
- Mortgage CalculatorEstimate a monthly mortgage payment with optional property tax, insurance, PMI and HOA, plus a yearly amortization table.
- Amortization ScheduleSee every payment of a fixed-rate loan split into principal and interest, with the balance after each one.
Want this on your site? Embed the declining balance depreciation calculator.