Excel Tips - Tip 39 (Calculating Depreciation with DB Command)

Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If Ever we want to calculate depreciation based on SLM Method i.e. Straight line method , then use “ DB” command.

What Does It Do ?

This function calculates deprecation based upon a SLM Method i.e. Straight line method.

How to use it ?

'=DB(Purchase Price, Salvage Value , Life , Period To Calculate , First Year Month)

The First Year Month is the month in which the item was purchased during the first financial year. This is an optional value, if it not used the function will assume 12 as the value.

For examples please check the below images

Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w&usp

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456