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

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Telegram

taxguru on telegram GROUP LINK

Review us on Google

More Under Company Law

Leave a Comment

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

Search Posts by Date

June 2022
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930