Depreciation
This query is : Resolved
02 May 2015
Dear Sir/Mam,
Kindly tell me how to solve this formula using Excel and find n..
R={1-(s/c)^1/n}*100 where R=15%,s=5,c=100.
Thanks in advance
Kindly tell me how to solve this formula using Excel and find n..
R={1-(s/c)^1/n}*100 where R=15%,s=5,c=100.
Thanks in advance
03 May 2015
You can try calculating WDV rate of Depreciation yourself using below formula:
r = 1-(s/c)^(1/n)
Where,
r = rate of depreciation
s = scrap value
c = cost of assets
n = no. of year of life of assets
For example take Plant & Machinery:
r=1-(5/100)^(1/15)
=18.10%
Just put the above stated formula in excel and then only you can see the result.
Check out depreciation Rate Chart from link given below:
https://www.caclubindia.com/files0512/496179_59179_depreciation_rate_chart_companies_act_2013.pdf
r = 1-(s/c)^(1/n)
Where,
r = rate of depreciation
s = scrap value
c = cost of assets
n = no. of year of life of assets
For example take Plant & Machinery:
r=1-(5/100)^(1/15)
=18.10%
Just put the above stated formula in excel and then only you can see the result.
Check out depreciation Rate Chart from link given below:
https://www.caclubindia.com/files0512/496179_59179_depreciation_rate_chart_companies_act_2013.pdf
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CAPITAL GAIN BASE ON NOTIFICATION
- Taxable or Tax exempt
- Demand Outstanding AY 2013-14 TDS Deducted not shown in 26as
- TDS Deducted AY-2013-14 Not Reflected in 26as
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- ADVANCE PAYMENT OF ADVOCATE
- Eway bill not cancelled within 24 hous what can be due
- CREDIT NOTES WITHOUT GST
- Eway bill generation from place other than registeted
- TDS Return Q1 FY 2026-27
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
