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.

Download Count52911
Category, ,
Size0.00 KB
Total Files1
Upload DateMarch 18, 2019
Last UpdatedMarch 19, 2019

    if the goods sold how to calculate depreciation (ex sold on 2.aug)

  2. shrabani routray says

    i want to know the depriciation percentage of a 12years school building.

  3. shrabani routray says


    i want to know the depriciation percentage of a 12 years old school building.

  4. Dev says

    I purchased furniture for PVT. Ltd . of 12000/- than how much dep should i deduct?

  5. Swapnil Modi says

    Great working sir, It’s of lot of help……..

    1. Raju Choudhary says

      Thanks Swapnil Modi for appreciation

  6. vinod says

    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?

    1. Raju Choudhary says

      Hi vinod

      I am check this file and This File s Not Protected and i am able to add Row Easily so Please try again to Add Row.

  7. Nikita jain says

    What Should be done in case where multiple assets of same block purchased in different years.

  8. yuvraj says

    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.


    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.


    1. Anirudh says

      Dear Rakesh, you are right, the residual value/ scrap value should be calculated on Original Cost and not on WDV, if you refer our notes on schedule II in eg 3 we have calculated the scrap value/residual value @5% on Original cost and not on WDV. Hope your query is resolved if not please let us know.Thanks check notes from following link

  10. Ramakrishna says

    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

    1. Anirudh says

      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.

  11. PVSA RAO says


    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


    1. Raju Choudhary says

      Dear PVSA RAO

      Please Check Following URL’s. After Visiting these URL’s Download Application Guide on the Provisions of the Schedule II or Download Schedule III by ICAI. I think These Files Solve Your Problem, If your Problem is not solve please revert back. we try to solve your problem

      1. Dillip says

        Hi Raju,

        i want to understand the WDV depreciation rate formula. Please help me for the same.

        Thanks & Regards
        Dillip Sahu

  12. Rama says

    Excel calc – depreciation chart

  13. Gaganpreet says

    You are doing nice job by updating us.

Leave A Reply

Your email address will not be published.