Excel Depreciation Calculator FY 2016-17 Companies Act 2013 Download enabled

Author: | Posted in Calculators, Companies Act 86 Comments | 89,108 views

Excel Depreciation Calculator FY 2016-17 Companies Act 2013 as per Schedule-II Version 05.07.02

Excel Depreciation Calculator FY 201617 download

The maiden ABCAUS Excel Companies Act 2013 Depreciation Calculator was first launched in March, 2015. 

The ABCAUS calculator for FY 2016-17 is also formulated and styled the same way as its predecessor so that users find themselves familiar with it.

This calculator is meant for companies following April to March Financial year. Also the calculator is meant only for tangible assets. Like, in last year useful life of the assets purchased during the FY 2015-16 is taken in integers only.

Any error or suggestions may please be reported at info@abcaus.in

Alternatively, users may subscribe to ABCAUS Newsletter to know the coming updates. Click Here >>

Saving the file to your local computer disk
Please note that while downloading this utility save it as either Excel 97-2003 (xls) or Macro Enabled sheet in Excel 2007 or later versions (.xlsm) Only

save excel calculator 

How to use this calculator?
The calculator has been divided into five part as under:

(a) Assets
(b) Opening Details
(c) Additions
(d) Opening Deletions, and
(e) Depreciation Chart
In each part only “grey” fields are required to be filled.

Assets
Assets database should be created by providing names of the assets and by selecting the asset type as per schedule-II. Please note that no two names should be identical. If for example there are multiple computers, they should be written in different rows as computer1, computer2…and so on.

Since, you must be having the individual asset-wise list of closing wdv as on 31/03/2016 or the depreciated value of the asset as on 31/03/2014 (for SLM purposes), creating this database should not be a problem.

Please note that new assets purchased during FY 2016-17 should also be created in this database. Again, please bear in mind that they should also be unique and not bear an identical name to an existing asset.

For example: You have opening wdv of the block furniture individually for each asset (say, “furniture1”, “furniture2”, “furniture3”) and if during FY 2016-17 there is another addition to the block furniture, then a new nomenclature (say, “furniture4”) should be used in the asset sheet. In the “new addition sheet” this new furniture “Furniture4” is required to be selected for calculating depreciation on new additions.

Opening Balances:
Since the users must be having individual asset wise closing wdv as on 31/03/2016, the details required in the opening sheet should be filled using the wdv list as on 31/03/2016.

For SLM purposes, depreciated book value of the assets should be filled in column B.

In the Opening Sheet, the following particulars are required to be given:

  • Name of assets > fill as per closing wdv list of 2015-16
  • Depreciated value of asset as on 31/03/2014
  • WDV as on 01-04-2016 > as per closing wdv list of 2015-16

If useful life of the asset was zero as on 01/04/2014 it would be equal to the residual value.

  • Remaining useful life > as per useful life as on 01/04/2014 minus one year
  • If useful life zero as on 01/04/2014 > as per useful life as on 01/04/2014
  • If asset has been sold during FY 2016-17 > select Yes or No from drop down
  • Estimated residual value > as estimated during FY 2014-15
  • Depreciation Rate > The rate as calculated in FY 2014-15 should be filled
  • Rest of the values shall be calculated automatically
  • Date of format should be dd/mm/yyyy
  • No field should be left blank.

Additions made during the year

  • Date of format should be dd/mm/yyyy
  • For each new additions, first they should be created in ‘Assets” sheet.
  • For new additions made during the year, residual value has been taken @ 5% by default.
  • If any disposal has been made out of additions during the year, its details must be filled in columns ‘f” and “g” after selecting “Yes” in column “e”

Opening-Deletion

  • This sheet accounts for any deletion that has been made out of the opening assets, (i.e.; out of opening sheet)
  • Only those assets which have been disposed off during FY 2016-17 should be selected under assets name list.
  • If you have selected “yes” against any asset in column “f” in opening sheet, the same asset must be selected here
  • Date of format should be dd/mm/yyyy
  • Date of purchase of disposed asset should be available as per depreciation chart for FY 2015-16.
  • This sheet must be filled after completing the ‘Opening sheet”

Depreciation Chart It should be automatically calculated.

See Video Tutorial:

The calculator is meant to guide and help in calculating the depreciation, the disclosure requirements have to be separately taken care of.

Also the WDV written off should be charged either to reserves and surplus or profit and loss account.

Similarly, Profit or loss on the disposal of assets should be reflected in profit and loss account.

Excel Depreciation Calculator FY 201617 download

Excel Depreciation Calculator FY 2016-17 Companies Act 2013

Please note that by downloading the ABCAUS depreciation calculator, you agree to the terms of use that you do not have permission to modify, copy, edit, upload, reproduce, republish, distribute or transmit the utility except with the written prior approval. 

----------- Similar Posts: -----------

Comments
  1. Posted by Aarthi.P
    • Posted by administrator
      • Posted by SANJEEV SHUKLA
      • Posted by parwinder
    • Posted by RAJAN ASSOCIATES
  2. Posted by Kamlesh kumar
  3. Posted by ajay jethva
  4. Posted by Rajesh Pitalia
  5. Posted by administrator
    • Posted by rajes r pitalia
  6. Posted by administrator
  7. Posted by Janmesh Mehta
  8. Posted by Ravi Joshi
    • Posted by Parankush Tiwari
  9. Posted by OMPRAKASH SHUKLA
  10. Posted by administrator
  11. Posted by OMPRAKASH SHUKLA
  12. Posted by Paresh Soni
  13. Posted by ARJUN KUMAR
    • Posted by administrator
      • Posted by ARJUN KUMAR
        • Posted by vasu
  14. Posted by NILESH VYAS
  15. Posted by Bapuji
  16. Posted by administrator
    • Posted by s.sivashankar
  17. Posted by Jayakumar.M
  18. Posted by SANJEEV SHUKLA
  19. Posted by Vishal
  20. Posted by DEBJANI DAS
  21. Posted by Jayakumar
  22. Posted by RITESH GANDHI
  23. Posted by RITESH GANDHI
  24. Posted by Mansheet Singh
    • Posted by administrator
  25. Posted by ASIF DADANI
  26. Posted by ASIF DADANI
  27. Posted by Dhriti Jain
  28. Posted by Shubham
  29. Posted by SANJEEV SHUKLA
  30. Posted by ercan
  31. Posted by sovenjit sarkar
    • Posted by admin
  32. Posted by P.P.rajan
  33. Posted by SHUBHAM
  34. Posted by Sridevi
    • Posted by administrator
  35. Posted by Rounak
    • Posted by administrator
  36. Posted by Surya Shanker Mishra
  37. Posted by NAGESH
  38. Posted by shilpa
  39. Posted by Shiva Chandra
  40. Posted by Latha Nair
  41. Posted by K V VENKITARAMAN
  42. Posted by Bhadresh Sanghavi
  43. Posted by administrator
  44. Posted by SHARAD SINGHAL
    • Posted by administrator
  45. Posted by Vijay Kumar Sharma
  46. Posted by Madan Mohan
  47. Posted by Dipankar
    • Posted by administrator
  48. Posted by Rajesh Choudhary
    • Posted by administrator
  49. Posted by Latha
    • Posted by administrator
  50. Posted by Latha
  51. Posted by Madan Mohan
    • Posted by administrator
  52. Posted by Sandeep Mandal
  53. Posted by Anupama Srinivas
    • Posted by administrator
  54. Posted by Aditya Picha
    • Posted by administrator
      • Posted by Aditya Picha
  55. Posted by Aditya Picha
  56. Posted by Aditya Picha
  57. Posted by LATHA
  58. Posted by rajesh
  59. Posted by J Mohan
    • Posted by administrator
  60. Posted by Gopi Chand
  61. Posted by jagu
  62. Posted by JAYAKUMAR
  63. Posted by administrator

Add Your Comment

error: Content is protected ! Share the page link instead