CA Pawan Kumar Agarwal

CA Pawan Kumar AgarwalPlease find attached herewith an utility/ Calculator  for calculation of Depreciation under Schedule II of Companies Act, 2013.

The Significant feature of the same utility/ Calculator are as follows :-

1. TENTATIVE DATE OF ADDITION OF ASSET CAN BE CALCULATED ON BASIS OF COST OF ASSET, WDV and Depreciation Rate.

2. Asset Wise Depreciation Calculation for about 1000 itemised assets at a time in a single sheet with few data to be fed by user.

3. PIVOT TABLE Option for instant preparation of summary of Fixed Assets Schedule.

4. Mini Calculator for instant calculation of Depreciation as per WDV or SLM Method

5. Instant preparation of figures of Depreciation, WDV, Salvage Value etc. till the remaining life of the asset.

Download Depreciation Calculator as per Companies Act, 2013 with Tentative date of Addition and Auditor’s Tool (ver 1.4)

1. Please Use Excel 2007 and above  2. Revised Version 1.4 was uploaded on 21.05.2014.

(In case of any inconsistency or clarification/ suggestions, kindly contact us at madanlalassociates@gmail.com)

More Under Company Law

0 Comments

  1. Shubhangi Goel says:

    Sir,

    I am not able to open the excel. I am trying to open the file in Excel 2007 but it shows files not responding every time we try to open.

    Please mail us the excel calculator.

    Thanks
    Shubhangi Goel

  2. CA Pawan Kumar Agarwal says:

    Dear Mr Chandak

    I would request you to go through the Instruction Manual, before using the utility.

    We are assured that you will find the same useful.

    May I request you to kindly share this link on Tax Guru with others since it is not possible for us to reach to one and all.

  3. CA Pawan Kumar Agarwal says:

    Updated Version 1.4 with some more features and add-on utilities along with Instruction Manual uploaded.Bugs/ inconsistency in Version 1.3 has been fixed and duly taken care of. Facility provided to users to modify various fields like salvage value,rounding offs of desired decimal points etc. etc. Instructions Manual vividly explains the procedure to easily run the utility.

  4. Anil says:

    Respected Sir,

    Thanks for providing this calculator.I want to ask that we can round down life and round upto two digit in case of rate of depreciation.

Cancel reply

Leave a Comment to CA. Sanjay Gupta

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