Excel for
Depreciation Calculator FY 2015-16 Click Here >>
Depreciation Calculator for FY 2014-15
These calculator is meant for companies following April to March Financial year. Also the calculator is meant only for tangible assets.
Error noticed if any, can be reported at info@abcaus.in. Also the download page may be bookmarked for revised versions.
How to use this calculator?
(a) Assets In each part only “grey” fields are required to be filled.
1. Assets
2. Opening Balances: Excel Utility to get Opening WDV from date of Additions Click Here >> Date of format should be dd/mm/yyyy. If an assets has been sold during FY 2014-15, it must also be reflected so in “Opening-Deletions” sheet Residual value of the asset is required to be filled. Please note that Note No. 05 to Part-C of Schedule-II restricting the residual value to 5% of the original cost of the asset has been omitted. However it may be kept that way.Please ensure that residual value is not NIL. Rest of the information should be calculated automatically.
3. Additions made during the year
4. Opening-Deletion The carrying amounts and date of purchase should be selected out of drop down menu. This sheet must be filled after completing the ‘Opening sheet”. For any subsequent changes in “opening sheet”, carrying amount and date of purchase must be reselected from the drop down list. Original price/carrying amount of asset sold For sale of assets that have been bought during the year, original price should be given. For sale of assets out of opening block, carrying amount as on 31-03-2014 should be given
5. Depreciation Chart The calculator is meant to guide and help in calculating the depreciation, the disclosure requirements have to be separately taken care of. Download ABCAUS Excel Depreciation Calculator as per Companies Act, 2013 Version-15.50 Download ABCAUS Excel Depreciation Calculator as per Companies Act, 2013-Year Version-11.15
|