Calculate depreciation of assets in Excel

For example, I have a Printing Machine whose original cost is $75'000, useful life is 8 years and Salvage cost is $10'000. I would like to know the asset value and depreciation amount over its useful life using Declining Balance for calculations.

excel calculate depreciation of assets

To do it in Excel, here is the answer:

a) Enter the formula =DB($U$2,$U$4,$U$3,T8) for Depreciation Amount of first year.

The first argument is the Purchase Cost, second corresponds to Salvage Value, 3rd corresponds to Life Span in years.

Fourth argument is the period. Notice $ is not used before ROW / COLUMN reference so that the formula could be copied over to calculate Depreciation amount for other years.

Drag the formula for years 2 to 8.

Asset Value is the difference between previous period Asset Value and Depreciation amount. Hence formula in cell U9 =U8-V8. Drag the formula for years 2 to 8.

excel calculate depreciation of assets


You can find similar Excel Questions and Answer hereunder

1) How can I get row count of filtered data?

2) How to create Pivot table in excel VBA

3) What are the addins in the developer tab in Excel

4) Is there a way I can round the sales figure to the nearest 500?

5) What is the design mode in the developer Tab in Excel

6) Various important math functions in VBA (trigonometry, algebra, exponential, )

7) What is a methods. Methods are action that can be performed by an object

8) How to create charts in Excel VBA

9) How can I get the count of number of series in a Chart using VBA?

10) The name manager in Excel is very useful to keep an overview and manage all the variable names in Excel. Here how to use the name manager in VBA


Here the previous and next chapter