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.
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 firstname.lastname@example.org)