Problem of calculating depreciation year on year is over now.
This attached excel wherein user needs to enter only below basic details of assets,
Rest all Excel takes care. You can play with the data with just click of button to get Depreciation as per,
In case, where asset is sold, gain/(loss) is also computed by the excel.
Using this excel first time, you can enter opening balances (Gross Block, Accumulated depreciation) to make transition easier.
Depreciation can also be computed in case of revaluation of assets, receipt of subsidy with prospective effect, example is explained in excel file.
Download Schedule 2 Depreciation calculator as per Companies Act, 2013