calculate depreciation of assets in Excel

Q98. In Excel, how can I calculate depreciation of assets using 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 excel calculate depreciation of assets


You can find similar Excel Questions and Answer hereunder

1) How do I get the 2nd highest number in a range of numbers?

2) I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option?

3) How can I add and link a Chart Title to a cell value?

4) How can I enter a text in a cell with subscript and superscript?

5) How can I find the last used cell in a Column in VBA?

6) I have a complex voluminous workbook with lot of formulas. Every time I make an update, the processing is slow. Any workarounds available?

7) Formula does not calculate in Excel

8) Can I assign a NAME to a constant (similar to declaring constants in coding environment like VBA)?

9) How can I extract file name from a full path including folder path and file name?

10) How can I remove display of Gridlines in my worksheet using VBA?

11) How do I calculate monthly payment given Loan amount, Rate of Interest and period?

12) How can I get input from user through a prompt and assign user's input to a cell?

13) How can I identify all cells with Data Validation in my WorkSheet?

14) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

15) How can I have text autocomplete by typing in a short code for the text?