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 57626
- Category CA, CA Final, Companies Act
- File Size 0.00 KB
- Total Files 1
- Upload Date March 18, 2019
- Last Updated March 19, 2019
if the goods sold how to calculate depreciation (ex sold on 2.aug)
hi
i want to know the depriciation percentage of a 12years school building.
hi,
i want to know the depriciation percentage of a 12 years old school building.
I purchased furniture for PVT. Ltd . of 12000/- than how much dep should i deduct?
Great working sir, It’s of lot of help……..
Thanks Swapnil Modi for appreciation
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?
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.
What Should be done in case where multiple assets of same block purchased in different years.
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.
THANKS
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 https://files.caknowledge.com/schedule-ii-complete-details-and-notes-with-examples/
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.
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
PVSA RAO
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
https://files.caknowledge.com/application-guide-on-the-provisions-of-the-schedule-ii/
https://files.caknowledge.com/download/download-schedule-iii-to-the-companies-act-2013/
Hi Raju,
i want to understand the WDV depreciation rate formula. Please help me for the same.
Thanks & Regards
Dillip Sahu
Excel calc – depreciation chart
You are doing nice job by updating us.