Problem of calculating depreciation year on year is over now.

This attached excel wherein user needs to enter only below basic details of assets,

  • Name of Assets
  • Assets Category
  • Cost of assets
  • Residual Value
  • Date of Put in Place
  • Date of Retirement
  • Original useful Life of assets

Rest all Excel takes care. You can play with the data with just click of button to get Depreciation as per,

  • SLM
  • WDV
  • Monthly
  • Quarterly
  • Half yearly
  • Yearly
  • Summary as per Schedule III captured automatically for any selected year (Opening balance, addition, disposal, depreciation during the year, closing balance)

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

Author Bio

Qualification: CA in Job / Business
Company: Black Horse Excellence
Location: AHMEDABAD, Gujarat, IN
Member Since: 26 Feb 2019 | Total Posts: 2

My Published Posts

More Under Company Law

Leave a Comment

Your email address will not be published. Required fields are marked *