This is no possible to buy or put in service assets every time on January 1, and therefore the depreciation of that asset cant be the same every time. That’s why MS Excel has a DB(cost, salvage, life, period, [month]) function to calculate this kind of depreciation of assets.
The Function requires 5 arguments;
- Cost: Cost of the asset
- Salvage: Cost of the asset after its life
- Life: Lifetime of the asset
- Period: For which depreciation is to be calculated
- Month(optional): In which the asset was put in to function. A value of 3 means it was put in to service in the month of October and 3 months depreciation is applied. If left blank 12(whole year) is applied
Remember that this formula applies to asset’s value+1 periods. Means if you have 5 years of asset life then it would be applied to 6 different periods. The formula in excel changes a bit for the first and the last period of this calculation.
Make a excel sheet like the one shown below and calculate your won schedule.
Mid-Year Depreciation Schedule