Rounding Robin

Home › Accounting › Depreciation Schedule Calculator

Depreciation Schedule Calculator

Enter the asset, pick a method and the month it went into service to get the full year-by-year schedule.

$
$
First-year depreciation$4,500.00
Depreciable base
$22,500.00
Total depreciation
$22,500.00
Fiscal years in the schedule
5
Ending book value
$2,500.00
YearDepreciationAccumulatedBook value
1$4,500.00$4,500.00$20,500.00
2$4,500.00$9,000.00$16,000.00
3$4,500.00$13,500.00$11,500.00
4$4,500.00$18,000.00$7,000.00
5$4,500.00$22,500.00$2,500.00

Formula

Straight-line: (Cost − Salvage) ÷ Life each year
Declining balance: Book value × (2 or 1.5 ÷ Life), never below salvage
Sum-of-the-years-digits: (Cost − Salvage) × Remaining life ÷ Sum of digits
Partial first year: full-year amount × Months in service ÷ 12

How it works

All four methods write off the same total, cost less salvage value. They differ in timing: straight-line is even, the others take more in the early years.

Choose the month the asset was placed in service. Any month after January gives a partial first year, counted in whole months, and the unused part falls into one extra year at the end. January gives full years.

For declining balance, the switch option moves to straight-line on the remaining balance in the year that gives a larger deduction, which is how the method is usually applied in practice. With the switch off, the final year takes whatever is left down to salvage value. This is book depreciation; US tax depreciation follows MACRS, which has its own calculator.

Worked example

Using the starting figures above (Asset cost: $25,000.00; Salvage value: $2,500.00; Useful life (years): 5; Method: Straight-line; Switch to straight-line: Yes, when it gives more; Month placed in service: January), the calculator returns:

Common questions

Which depreciation method should I use?

Straight-line suits assets that wear evenly and is the most common for financial statements. Accelerated methods suit assets that lose value or usefulness fastest when new, such as vehicles and technology. Whichever you choose, apply it consistently.

How is a mid-year purchase handled?

The first year is prorated by the months in service, and the schedule runs one fiscal year longer so the full depreciable base is still written off.

Related calculators

Something look wrong, or missing a calculator you need? Send feedback.

Results are estimates for general information. They are not financial, tax or legal advice. Check important figures with a qualified professional before acting on them.