Declining Balance Depreciation Calculator
Calculate declining balance depreciation for any asset and generate a full year by year schedule showing depreciation expense and book value.
| Item | Value |
|---|
| Year | Book value start | Depreciation rate | Depreciation expense | Accumulated depreciation | Book value end |
|---|
| Factor | Percent of straight line | Common name |
|---|---|---|
| 1 | 100% | Straight line equivalent rate |
| 1.25 | 125% | 125% declining balance |
| 1.5 | 150% | 150% declining balance |
| 1.75 | 175% | 175% declining balance |
| 2 | 200% | Double declining balance |
| 3 | 300% | 300% declining balance |
Declining balance depreciation explained simply
Declining balance depreciation is an accelerated method of spreading the cost of an asset over its useful life by applying a fixed percentage rate to the asset’s remaining book value each year, producing larger deductions early and smaller deductions later.
This calculator accepts the asset cost, salvage value, useful life, and a depreciation factor, then produces a complete year by year schedule showing the depreciation rate, expense, accumulated depreciation, and book value for every period.
Why use declining balance depreciation
Using declining balance depreciation matches many assets that lose value faster in early years, such as vehicles and equipment, and can provide larger tax deductions sooner compared with straight line depreciation.
How to calculate declining balance depreciation step by step
How to calculate declining balance depreciation begins with finding the straight line percentage, then applying the depreciation factor to determine the annual depreciation rate.
- Calculate the straight line depreciation percent by dividing 100 percent by the useful life in years.
- Multiply the straight line percent by the depreciation factor to get the depreciation rate.
- Multiply the depreciation rate by the book value at the start of each period to find that period’s depreciation expense.
- Subtract the depreciation expense from the starting book value to get the ending book value, which becomes the starting book value for the next period.
Example calculation with a 1.5 factor
For an asset costing 575000 dollars with a useful life of 10 years and a factor of 1.5, the straight line percent is 10 percent, so the depreciation rate becomes 15 percent. The first full year depreciation expense equals 15 percent multiplied by 575000, which is 86250 dollars.
Understanding the double declining balance method
Understanding the double declining balance method means recognizing that it is simply declining balance depreciation with a factor of 2, meaning the depreciation rate is exactly double the straight line rate.
For an asset with a 10 year useful life, the straight line rate is 10 percent, so the double declining balance rate becomes 20 percent applied to the remaining book value each year.
Partial year and salvage value considerations
Partial year and salvage value considerations affect the first and last years of the depreciation schedule when an asset is placed in service partway through a fiscal year.
- If the first year covers fewer than 12 months, the first year depreciation rate is adjusted proportionally based on the number of months in service.
- Declining balance depreciation does not directly subtract salvage value from each period’s calculation, but the final period is adjusted so the book value does not fall below the salvage value.
- The Excel DDB function performs the same calculation and can be used to verify results for a specific period.
Frequently asked questions
The declining balance depreciation method is an accelerated depreciation approach that applies a constant depreciation rate to the remaining book value of an asset each year, resulting in larger deductions in early years and smaller deductions later.
To calculate declining balance depreciation, divide 100 percent by the useful life to get the straight line rate, multiply that rate by the depreciation factor to get the depreciation rate, then multiply the depreciation rate by the book value at the start of each period.
The double declining balance method is a declining balance depreciation calculation that uses a depreciation factor of 2, meaning the depreciation rate is twice the straight line rate, resulting in faster depreciation in the early years of an asset’s life.
Declining balance depreciation does not directly use salvage value in each period’s calculation, but the final period may be adjusted so the book value does not fall below the salvage value at the end of the asset’s useful life.
The Excel equivalent for declining balance depreciation is the DDB function, written as DDB(cost, salvage, life, period, factor), which calculates the depreciation expense for a chosen period using a specified factor.
The depreciation factor controls how much faster than straight line depreciation an asset depreciates, with a factor of 1.5 representing 150 percent, a factor of 2 representing 200 percent or double declining balance, and a factor of 3 representing 300 percent.