We have already updated the depreciation calculation sheet for fy 2015-16 but to bring more clarity in calculation, we are hereby publishing revised excel depreciation calculator.
Depreciation for F.Y. 2015-16 and onwards is much easier to calculate compared to last year. Last year proper working was required to change the WDV rate, asset whose life was over had to be treated properly transferring balancing amount to reserves taking into account Deferred Tax. But this year, everything is simple. Rate of Depreciation for existing assets will remain the same and for new assets, we have provided the relevant formula.
In the below attached depreciation calculation sheet, green fields are formula and not required to be changed. Data is to be entered in white columns only. Full explanation is attached in the sheet for ready reference.