Depreciation Calculator as per Companies act 2013 in Excel

Depreciation Calculator as per Companies act 2013 in Excel Format. Download Depreciation calculator in Excel Format as per companies Act 2013. this excel file calculate depreciation as per WDV Method and as Per SLM Method. We also provide Depreciation rate chart as per companies act 2013. Now you can scroll down below and download Depreciation Calculator as per Companies act 2013 in Excel.

  • Version
  • Download Count 57660
  • Category , ,
  • File Size 0.00 KB
  • Total Files 1
  • Upload Date March 18, 2019
  • Last Updated March 19, 2019

Latest Comments

  1. How to add new row after completing of all the rows at down? i cant eable to add because it is protected, can u suggest any idea for this?

  2. Sir would u plz suggest me how to calculate depreciation
    for a company which is following WDV as per co act
    for more than 15 years,say nearly 20 years.

  3. You have done a good job. You are calculating residual value @5% of WDV as on 31.03.14, if I know the Original cost of purchase than We should calculate 5% of cost in place of WDV. IF IT IS DONE THAN DEPRECIATION RATE CHANGE OR REMAIN SAME AS PER WDV RESIDUAL VALE. PLEASE CLARIFY.


  4. Can you suggest how to compute depreciation in case in a company there are more than 1 shift?
    And very importantly your website is superb

    • For more than one shift (Additional dep is 50% and in case of triple shift Additional dep is 100%.) , refer our notes on Schedule II for further clarification.

  5. Sir,

    I am very thankful to you for giving us such an important material on depreciation as per Companies Act 2013. Pl let me know whether any guidance note is given by ICAI in this regard. If so, pl furnish me a copy of the same. Further, it is observed from the depreciation calculator as SLM basis, the rate of depreciation is shown as 19.96%. I think it would have been 2.38%. Please check.

    If retained earnings are not available, how to treat Item 3 of the depreciation table i.e. when balance days are negative. Can it be adjusted to General Reserve / Other Free Reserves

    Anticipating an early response from your end.

    Best Regards



Join the Discussion