Depreciation Calculator

  • Version
  • 5'940 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: 510

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

We are sorry 🙁

Help us improve!

How we can improve this template?

Debt Reduction Calculator

27 KB / 13575 downloads
Bill Payment Calendar

6.6 Mb / 106079 downloads
Debt to Income Ratio Calculator

18 KB / 23350 downloads
Fuel Consumption Calculator

14 KB / 24749 downloads
Electricity Consumption Calculator

44 KB / 23961 downloads
Grocery List Cost Estimator

38 KB / 5895 downloads
Event Budget

29 KB / 4501 downloads
Grocery Price Comparison Spreadsheet

38 KB / 27612 downloads
Extra Payment Calculator

248 KB / 11720 downloads
View Comments