logo for matrixlab-examples.com
leftimage for matrixlab-examples.com

Depreciation Calculator - online spreadsheet

Depreciation Rate and Amount


Economic depreciation involves two different but related ideas: the decline in value of assets, and the allocation of the cost of assets to periods in which the assets are used. The first concept affects values of businesses; the second concept affects income.

The depreciation calculator  below helps you study two common problems:


a) Depreciation Rate of an investment. You must provide the original price of the item, its resale price, and its age in years. 
The depreciation rate is calculated by the following formula: 

 calculate depreciation formula 1

where:

T = resale price
P = original price
Y = age 
D = depreciation rate


b) Depreciation Amount. You must provide the original price, the depreciation rate and the years of depreciation. The depreciation amount is claulated by the following formula:

 calculate depreciation formula 2

where:

D = depreciation amount
P = original price
i = depreciation rate
Y = year of depreciation 


Calculate Depreciation Rate

Let's imagine that happy Julie bought her car for $50,000 and sold it for only $24,325 three years later. What was the actual depreciation rate?

We use one of the possibilities of our calculator...

Depreciation Rate   
Original Price = 50,000.00
Resale Price = 24,325.00
Years = 3

and we can read the answer

Depreciation Rate =     21.35%

Calculate Depreciation Amount

If Julie's computer had an original price of $4,933.76. This particular high-tech laptop depreciates at an average annual rate of 21%. What amount has the laptop depreciated in the first two years?

We use now the other section of our calculator...

Depreciation Amount
Original Price =  4,933.76
Depreciation rate =  21.00
Year of depreciation = 1
   
an the first reading is

Depreciation this year = 1,036.09


We just change the year of depreciation in the spreadsheet

Year of depreciation = 2
   
and our second reading is

Depreciation this year = 818.51

You have to enable JavaScript codes on this site if you want to run the calculator, otherwise it won't work.

   

Enter the needed values (do not use commas)

Depreciation Amount in a specific year...

Original Price:
Depreciation Rate: %
Year of depreciation:

Depreciation this year:

Depreciation Rate

Original Price:
Resale Price:
Years:

Depreciation Rate: %



 From 'Depreciation Calculator' to home

 From 'Depreciation Calculator' to Free Online Calculators

Top

Calculate Depreciation code in Matlab





footer for depreciation calculator page