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.
- Depreciable base
- $22,500.00
- Total depreciation
- $22,500.00
- Fiscal years in the schedule
- 5
- Ending book value
- $2,500.00
| Year | Depreciation | Accumulated | Book 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
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:
- First-year depreciation: $4,500.00
- Depreciable base: $22,500.00
- Total depreciation: $22,500.00
- Fiscal years in the schedule: 5
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
- Depreciation Method Comparison CalculatorCompare straight-line, double declining, 150% declining and sum-of-the-years-digits depreciation side by side, year by year.
- MACRS Depreciation CalculatorBuild a MACRS schedule for 3 to 39-year property with half-year, mid-quarter or mid-month conventions, Section 179 and bonus depreciation.
- Straight-Line Depreciation CalculatorCalculate annual and monthly straight-line depreciation with a year-by-year schedule, including a partial first year.
- Double Declining Balance Depreciation CalculatorBuild a double declining balance schedule with an optional switch to straight-line and a partial first year, never below salvage value.
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.