CA Pawan Kumar Agarwal
Please 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)
Author Bio
unable to download the utility, kindly mail the same
unable to download the utility, kindly mail
Dear Sir/Madam
Kindly send us a mail on – madanlalassociates@gmail.com and we will mail the said file to you
Thanking You
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
Dear Mr Gupta
Kindly send us a mail on – madanlalassociates@gmail.com and we will mail the said file to you
Thanking You
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.
Dear Mr Gupta
Kindly send us an email on madanlalassociates@gmail.com and we will mail the file to you.
Thank u, Excell Very detailed, need to undertstand then can be adopted
Not able to download. Please send in mail.
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.
Thanks very useful and informative. Can you provide “modify salvage value” in your worksheet.
Yes, you can modify the salvage value in column J
thank you sir wall
Depreciation chart could not be downloaded, download failed after 4-5 attempts
Thank you very much,
the zip file is not been able to unzip/open.
Thank you so much. Hope the above solves are whole problems.
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.
Thank you.
Not able to download. Please send in mail.
Please provide the Depreciation calculator as per Companies Act, 2013.
regards
Team JKT
Thank you sir.