When you buy a vehicle, a machine or a computer for your business, you usually spread its cost over the years you use it. That’s depreciation. This free calculator builds a full depreciation schedule with three common book methods, and you can export it to Excel or PDF for your records.
Depreciation calculator
Enter what the asset cost, what you expect it to be worth at the end (salvage value) and its useful life, then pick a method.
When you’re done, use the buttons under the result to print or save it as a PDF, download it for Excel, Word or CSV, copy a share link or email it. Your numbers stay in your browser.
Depreciation formulas
Straight-line (SL): (Cost - Salvage) / Life, every year
Double-declining (DDB): Book value at start of year x 2 / Life
(never below salvage value)
Sum-of-years' digits: (Cost - Salvage) x Remaining life / Sum of years
Sum of years for 5 years = 5+4+3+2+1 = 15
Worked example
A delivery van costs $30,000, is expected to be worth $5,000 after 5 years, and is placed in service in 2026. The depreciable base is $25,000.
| Year | Straight-line | Double-declining | Sum-of-years |
|---|---|---|---|
| 2026 | $5,000 | $12,000 | $8,333 |
| 2027 | $5,000 | $7,200 | $6,667 |
| 2028 | $5,000 | $4,320 | $5,000 |
| 2029 | $5,000 | $1,480 | $3,333 |
| 2030 | $5,000 | $0 | $1,667 |
| Total | $25,000 | $25,000 | $25,000 |
Every method writes off the same $25,000 in total. The difference is timing: declining balance and SYD put more of the cost in the early years, when an asset usually loses value fastest.
Book depreciation vs tax depreciation
This calculator shows book depreciation, the kind used in your financial statements. For your tax return, the IRS uses its own system, MACRS, with set recovery periods by asset class. Many small businesses can also deduct the full cost in the first year with Section 179 expensing or bonus depreciation. Those rules and limits change, so ask a tax professional which applies to your purchase.
How to record depreciation
Each year, record the depreciation as an expense (“Depreciation expense”) and add it to “Accumulated depreciation”, which reduces the asset’s book value on the balance sheet. No cash moves; the cash went out when you bought the asset.
Full depreciation schedules: one asset, three methods
Example: equipment costing $10,000, salvage value $1,000, useful life 5 years. Every method writes off the same $9,000 in total; only the timing changes.
Straight-line
| Year | Depreciation | Accumulated | Book value |
|---|---|---|---|
| 1 | $1,800 | $1,800 | $8,200 |
| 2 | $1,800 | $3,600 | $6,400 |
| 3 | $1,800 | $5,400 | $4,600 |
| 4 | $1,800 | $7,200 | $2,800 |
| 5 | $1,800 | $9,000 | $1,000 |
Double-declining balance
Double-declining applies twice the straight-line rate (40% here) to the remaining book value, and stops when book value reaches salvage value.
| Year | Depreciation | Accumulated | Book value |
|---|---|---|---|
| 1 | $4,000 | $4,000 | $6,000 |
| 2 | $2,400 | $6,400 | $3,600 |
| 3 | $1,440 | $7,840 | $2,160 |
| 4 | $864 | $8,704 | $1,296 |
| 5 | $296 | $9,000 | $1,000 |
Sum-of-the-years’-digits
| Year | Depreciation | Accumulated | Book value |
|---|---|---|---|
| 1 | $3,000 | $3,000 | $7,000 |
| 2 | $2,400 | $5,400 | $4,600 |
| 3 | $1,800 | $7,200 | $2,800 |
| 4 | $1,200 | $8,400 | $1,600 |
| 5 | $600 | $9,000 | $1,000 |
150% declining balance
150% declining balance uses 1.5 times the straight-line rate (30% here). It is slower than double-declining, so it switches to straight-line in year 4, when straight-line on the remaining value gives a bigger amount. Many depreciation calculators call this the switch to straight-line.
| Year | Depreciation | Accumulated | Book value |
|---|---|---|---|
| 1 | $3,000 | $3,000 | $7,000 |
| 2 | $2,100 | $5,100 | $4,900 |
| 3 | $1,470 | $6,570 | $3,430 |
| 4 (switch to SL) | $1,215 | $7,785 | $2,215 |
| 5 | $1,215 | $9,000 | $1,000 |
Tax depreciation for comparison: MACRS 5-year property
For US taxes, most business equipment uses MACRS instead of the book methods above. MACRS ignores salvage value. The IRS table for 5-year property under the half-year convention spreads the cost over six tax years:
| Tax year | MACRS rate | On a $10,000 asset |
|---|---|---|
| 1 | 20% | $2,000 |
| 2 | 32% | $3,200 |
| 3 | 19.2% | $1,920 |
| 4 | 11.52% | $1,152 |
| 5 | 11.52% | $1,152 |
| 6 | 5.76% | $576 |
Alternative depreciation system (ADS) calculator example
The alternative depreciation system (ADS) is the slower of the two MACRS systems. Under ADS you use the straight-line method over fixed ADS recovery periods, which are often longer than the regular (GDS) periods. Some of the ADS recovery periods in IRS Publication 946:
| Property | ADS recovery period |
|---|---|
| Cars and light trucks | 5 years |
| Computers and peripheral equipment | 5 years |
| Residential rental property (placed in service after 2017) | 30 years |
| Nonresidential real property | 40 years |
Example: a $10,000 computer system under ADS, 5 years, straight-line, half-year convention, compared with the regular MACRS (GDS) table above:
| Tax year | ADS (straight-line) | MACRS GDS | ADS total so far | GDS total so far |
|---|---|---|---|---|
| 1 | $1,000 | $2,000 | $1,000 | $2,000 |
| 2 | $2,000 | $3,200 | $3,000 | $5,200 |
| 3 | $2,000 | $1,920 | $5,000 | $7,120 |
| 4 | $2,000 | $1,152 | $7,000 | $8,272 |
| 5 | $2,000 | $1,152 | $9,000 | $9,424 |
| 6 | $1,000 | $576 | $10,000 | $10,000 |
To use the calculator above for ADS, pick straight-line, set salvage value to $0 and enter the ADS recovery period as the useful life. Remember that the tax rules add the half-year (or mid-quarter or mid-month) convention, so the first and last tax years get only part of a year. For a $300,000 residential rental building under ADS, a full year is $300,000 ÷ 30 = $10,000; the first and last years are smaller under the mid-month convention.
When ADS is required: for example, for listed property (like a car) used 50% or less for business, property used mostly outside the US, tax-exempt use property, and real property of a business that elected out of the business interest limit. You can also choose ADS. Ask a tax professional before you rely on ADS for your return.
Related calculators and templates
- Loan Calculator with Amortization Schedule
- Break-Even Calculator
- Free Small Business Bookkeeping Spreadsheet
- How to Do Bookkeeping in Excel
FAQ
What is salvage value?
It is the amount you expect to sell or trade the asset for at the end of its useful life. Use zero if you expect to use it until it is worthless.
Which depreciation method should I use?
Straight-line is simplest and most common. Accelerated methods (DDB, SYD) suit assets that lose value quickly, like vehicles and computers.
Can I depreciate land?
No. Land is not depreciated because it does not wear out. Buildings on the land can be depreciated.
Is depreciation a cash expense?
No. It spreads the cost of an asset you already paid for across its life, so it reduces profit without reducing cash.
Why does MACRS take six years for 5-year property?
The half-year convention treats the asset as placed in service in the middle of the first year, so half a year of depreciation falls into a sixth tax year.
Can I use a different method for books and taxes?
Yes. Many small businesses use straight-line on their books and MACRS or Section 179 on their tax return. Keep a schedule for each.
What is the difference between ADS and GDS depreciation?
Both are part of MACRS. GDS, the usual system, often uses faster declining-balance methods and shorter periods. ADS uses straight-line over fixed, often longer, recovery periods, so the yearly deduction is smaller at first. Over the full period both write off the same cost.
What is 150% declining balance depreciation?
It applies 1.5 times the straight-line rate to the remaining book value each year, then switches to straight-line when that gives a bigger deduction. On a 5-year asset the rate is 30% a year.
ADS recovery periods: IRS Publication 946. This calculator is for general information and planning. It isn’t tax, legal, accounting or financial advice. For your own situation, talk to a qualified professional.
Comments
2 responses to “Depreciation Calculator: Straight-Line, Declining Balance & SYD”
[…] Depreciation Calculator […]
[…] Truck Depreciation: MACRS & Alternative Depreciation System (ADS) Calculator […]