Depreciation Calculator

This depreciation calculator produces a full year-by-year schedule for a fixed asset. Choose straight line, double declining balance, declining balance at a rate, sum of the years' digits, units of production or US MACRS, enter the cost, salvage value and life, and the months used in the first year, and it shows each year's charge, accumulated depreciation and book value, with a CSV export. Paste a fixed asset register to get every asset's charge and book value for a chosen year. It runs in your browser.

Cost 10,000, salvage 1,000, 5 years

YearStraight lineDDBSYD
11,8004,0003,000
21,8002,4002,400
31,8001,4401,800
41,8008641,200
51,800296600

When to use it

  1. Prepare a fixed asset schedule for year-end accounts.
  2. Compare straight line and accelerated methods.
  3. Work out reducing-balance tax depreciation.
  4. Check MACRS deductions for a US return.
  5. Roll forward a whole asset register.

How to Use

  1. Choose the method.
  2. Enter cost, salvage and life (or class, rate or units).
  3. Enter months used in the first year.
  4. Read the schedule; paste an asset register for a year's charges.

Features

  1. Six methods incl. MACRS
  2. Part-year first year
  3. Full schedule with CSV
  4. Switch to straight line in DDB
  5. Asset register batch
  6. 100% client-side

FAQs

How is straight-line depreciation calculated?

(Cost − salvage value) ÷ useful life. A 10,000 asset with 1,000 salvage over 5 years depreciates 1,800 a year.

What is double declining balance?

Twice the straight-line rate applied to book value: 40% a year for a 5-year asset, switching to straight line near the end and stopping at salvage.

How does a part year work?

The first year is charged for the months the asset was in use, which adds a short final year.

Which method should I use for tax?

Follow your tax authority's rules; many use reducing balance at set rates, and the US uses MACRS.

Is anything uploaded?

No. Everything runs in your browser.

Technical Details

Straight line = (cost − salvage) ÷ useful life each year. Double declining balance applies 2 ÷ life to the opening book value and switches to straight line over the remaining life when that is higher, never taking book value below salvage. Declining balance at a rate applies a fixed percentage to book value (as many tax codes do). Sum of the years' digits charges (remaining life ÷ (n(n+1)/2)) of the base. Units of production charges base × units ÷ total units. MACRS uses IRS Publication 946 Table A-1 (GDS, half-year). A part-year first year prorates by months in service. Batch mode gives a register's charge and book value for any year.

Finance & Tax Tools

Finance & Tax Tools

  • Financial Ratio Analyzer
  • Bank Reconciliation Matcher
  • Receivables Aging Report
  • Markup and Margin Converter
  • 12-Month Cash Flow Forecast
  • Withholding Tax Calculator (Pakistan)
  • Rental Yield and Cap Rate Calculator
  • Rent vs Buy Calculator