Free calculator · for small businesses & bookkeepers

Spread an asset's cost across its life, correctly.

Depreciation matches the cost of equipment to the years it's used, not the year you bought it. Enter the cost, salvage, and life to see annual depreciation — then get the full schedule.

Done-for-you template

Depreciation Schedule

Year-by-year depreciation and book value for every asset.

  • Straight-line depreciation from cost, salvage, and useful life
  • Year-by-year schedule with running book value
  • Track multiple assets in one register
  • Monthly and annual depreciation figures
  • Assumptions-driven · Excel & Google Sheets · delivered instantly
$24one-time · instant download
↩ 7-day money-back guarantee

🔒 Secure checkout via Stripe · Excel & Google Sheets · instant delivery.

🔒 Secure checkout by StripeInstant download7-day money-back guaranteeExcel & Google Sheets

Questions

What is straight-line depreciation?

Straight-line is the simplest and most common method: you spread an asset's depreciable cost evenly across its useful life. Annual depreciation equals (cost minus salvage value) divided by useful life in years. A $30,000 asset with a $3,000 salvage value and a 5-year life depreciates $5,400 a year. The book value drops by that amount each year until it reaches the salvage value.

What is salvage value?

Salvage value (or residual value) is the amount you expect the asset to be worth at the end of its useful life — what you could sell it for as scrap or second-hand. It's subtracted from the cost before depreciating, because you only spread the portion of the cost you actually 'use up'. If you expect an asset to be worthless at the end, salvage value is zero and you depreciate the full cost.

What is in the paid schedule?

A ready-to-use spreadsheet (Excel & Google Sheets): straight-line annual and monthly depreciation, a year-by-year schedule with book value, and a multi-asset register — delivered instantly after checkout. AI-assisted, human-built; not tax or accounting advice.

More on buying & delivery · refund policy

Related tools

More bookkeeping & tax tools.

$24 one-time · instant
Get the template