Skip to content

Depreciation calculator with a full depreciation schedule

Equipment, vehicles, computers and furniture lose value as they are used, and accounts spread their cost over the years they serve. This depreciation calculator builds the year-by-year depreciation schedule for an asset from its cost, residual value and useful life, by the four methods taught in accounting courses: straight-line, declining balance (double or a rate you choose), sum-of-the-years’-digits and units of production. Each row shows the opening book value, the depreciation for the year, the accumulated depreciation and the closing book value, and the whole schedule downloads as a CSV file for Excel or your accounting software.

Quick answer

Straight-line depreciation is (cost − residual value) ÷ useful life. An asset costing 10,000 with a residual value of 1,000 and a 5-year life depreciates by 1,800 a year. Double declining balance charges 2 ÷ life (40% for 5 years) of the opening book value each year: 4,000, then 2,400, then 1,440, never going below the residual value.

Based on IFRS Foundation: Clarification of Acceptable Methods of Depreciation and Amortisation (IAS 16 and IAS 38) · Page updated 17 October 2026

The same amount every year: (cost − residual value) ÷ useful life.

What you expect to get for the asset at the end of its useful life. Leave empty for 0.

Enter the cost and useful life to see the depreciation schedule.

How to use the Depreciation Calculator

  1. Choose a method and enter the asset cost, its residual value and its useful life in whole years.
  2. For declining balance, choose double declining or enter your own rate, and decide whether to switch to straight-line near the end.
  3. For units of production, enter the expected total units and the units for each year.
  4. Read the schedule table and download it as a CSV file.

The four depreciation methods

Straight-line charges the same amount every year and suits assets that give the same service each year, such as office furniture. Declining balance charges a fixed percentage of the remaining book value, so most of the cost is expensed early; double declining uses twice the straight-line rate. Sum-of-the-years’-digits also front-loads the charge: for a 5-year life the years add up to 15, so year 1 takes 5/15 of the depreciable amount, year 2 takes 4/15 and so on. Units of production ties the charge to use, such as machine hours, units made or kilometres driven, so a busy year carries more depreciation.

Choosing a method

Under IFRS (IAS 16), depreciation should follow the expected pattern in which the asset’s future economic benefits are used up. In May 2014 the International Accounting Standards Board clarified, in amendments to IAS 16 and IAS 38 effective from 1 January 2016, that revenue-based methods are not appropriate for property, plant and equipment, because the revenue from an activity generally reflects factors other than the use of the asset. The methods on this page follow time or physical use. Which one fits your asset, and the useful life and residual value to use, is a judgement for your business and its accountant or auditor; the calculator only does the arithmetic.

Residual value, useful life and rounding

The depreciable amount is the cost minus the residual value, the amount you expect to get for the asset at the end of its life. No method takes the book value below the residual value: the last charge is cut to stop exactly there. Straight-line and sum-of-the-years’-digits always end on the residual value, and the schedule rounds each year to two decimals with the last year absorbing the rounding, so the total equals the depreciable amount. The calculator works in whole years from the start of use; if the asset was bought part-way through a year, many businesses charge a part-year in the first and last years, which you can apply to the yearly figures.

Declining balance and the switch to straight-line

A pure declining balance never reaches the residual value, because each year takes only a percentage of what is left. That is why it is common to switch to straight-line once spreading the remaining amount evenly over the remaining years gives a higher charge. With the switch ticked, the schedule makes that change automatically, marks the year it happens and ends on the residual value. Without it, the last row shows the book value still above the residual value, which you may write off when the asset is sold or scrapped.

Accounting and tax depreciation

The figures here are for book-keeping, budgeting and study. Tax rules on depreciation are set by each country’s tax law and may allow different rates, lives or methods from the ones in your accounts, so this calculator does not apply any tax rules. Ask your accountant or check your tax authority’s guidance before using a schedule in a tax return.

Frequently asked questions

How does a depreciation calculator work out straight-line depreciation?

It subtracts the residual value from the cost and divides by the useful life. 10,000 cost, 1,000 residual and 5 years give 1,800 a year, and the book value falls to 1,000 at the end.

What is double declining balance depreciation?

A method that charges twice the straight-line rate on the opening book value each year. For a 5-year life the rate is 40%, so 10,000 gives 4,000, then 2,400, then 1,440, and so on down to the residual value.

How is sum-of-the-years'-digits depreciation calculated?

Add the years of the life (1 + 2 + 3 + 4 + 5 = 15 for five years). Year 1 takes 5/15 of the depreciable amount, year 2 takes 4/15, down to 1/15 in the last year.

When should I use units of production depreciation?

When an asset wears out with use rather than with time, such as a machine measured in hours or a vehicle in kilometres. The charge is the depreciable amount divided by the total expected units, times the units used each year.

Can I use this depreciation schedule for my tax return?

Not without checking. Tax depreciation follows each country’s tax rules, which can differ from your accounts, and this calculator applies none of them. Ask your accountant or tax authority.