Depreciation Calculator

  • Version
  • 5'284 Downloads
  • 20 KB File Size
  • January 4, 2022 Updated
  • 1 Number of comments
  • Rating
table of content

Depreciation is the reduction in the value of an asset due to usage, passage of time, wear and tear, technological outdating or obsolescence, depletion, inadequacy, rot, rust, decay or other such factors. That's the term you can find in Wikipedia or any accounting related sites. In real world, depreciation is useful to determine what is the value of any (usually new) item after being used for some period of time. And it is not the same for different item. For example the value of electronics equipment is degraded rapidly compare to vehicle. And event different brand of vehicle will have different depreciation value over some period of time.

That kind of differentiation leads to different depreciation calculation or methods. There are several depreciation methods used to calculate it, and fortunately microsoft excel already include some of those method in its build in function, so you can use it directly.

Depreciation Calculator

In this excel template, I used three most common depreciation methods, those are :

Straight Line

Straight-line depreciation is the simplest and most-often-used technique, in which the company estimates the salvage value of the asset at the end of the period during which it will be used to generate revenues (useful life) and will expense a portion of original cost in equal increments over that period.

Sum-of-Years Digit
Sum-of-Years' Digits is a depreciation method that results in a more accelerated write-off than straight line, but less than declining-balance method. Under this method annual depreciation is determined by multiplying the Depreciable Cost by a schedule of fractions.

Declining Balance
Many assets are most useful when they are new. This depreciation methods provide a higher depreciation charge in the first year of an asset's life and gradually decreasing charges in subsequent years. This may be a more realistic reflection of an asset's actual expected benefit from the use of the asset.

You can see how those depreciation calculated in table form. And as I mention before, all function already available in Excel, so I just use it. And I put a sample inside, but don't think the sample is real, because it is just dummy samples :-).

You can download the file here.

How useful was this template?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 509

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

Grocery Price Comparison Spreadsheet

38 KB / 26206 downloads
Extra Payment Calculator

248 KB / 11069 downloads
Payment Schedule Template

23 KB / 9451 downloads
Financial Ratio Calculator

302 KB / 18517 downloads
House Affordability Calculator

8 KB / 4992 downloads
Household Budget

113 KB / 31920 downloads
Annuity Calculator

14 KB / 5486 downloads
Household Expenses Tracker

66 KB / 25583 downloads
Balance Sheet Report

63 KB / 8483 downloads
View Comments