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
- Refund Annexure-B
- Nomination of Bank for refund in itr 2
- Section 56(2) of the Income tax Act 1961 , Gift to relative .
- Sale of Equity shares for Purchase of Residential Property
- Liable to deduct tds and 44ADA
- TDS PROCEDURE ON SALE OF IMMOVABLE PROPERTY BY NRI
- Gstr7 vs Gstr3b 2026
- Gst return - cess
- Subscription paid to foreign customer
- Is Interest applicable for payment made through credit ledger vide DRC03 for FY 2020-21 & 2021-22
- CCFS 2026 Schemed
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
