EMI Calculation
This query is : Resolved
15 April 2011
Sir please give me a formula of EMI Caculation with interest
15 April 2011
Rs.100000 Loan 15% interest 20 months period.EMI is (100000*115%)/20 = 5750
Message likes :
1 times
15 April 2011
sir, when i calculate with loan calculator there is some difference in ur calculation
15 April 2011
http://www.deal4loans.com/Contents_Calculators.php
Please see above link.
Please see above link.
15 April 2011
Thanks sir but we r not calculate with calculator, i want a formula to calculate with calculator or excel formula
15 April 2011
This is the formula to calculate:
E = P×r×(1 + r)n/((1 + r)n - 1)
E is EMI
where P is Principal Loan Amount
r is rate of interest calculated in monthly basis it should be = Rate of Annual interest/12/100
if its 10% annual ,then its 10/12/100=0.00833
n is tenure in number of months
Eg: For 100000 at 10% annual interest for a period of 12 months
it comes to 100000*0.00833*(1 + 0.00833)12/((1 + 0.00833)12 - 1) = 8792
E = P×r×(1 + r)n/((1 + r)n - 1)
E is EMI
where P is Principal Loan Amount
r is rate of interest calculated in monthly basis it should be = Rate of Annual interest/12/100
if its 10% annual ,then its 10/12/100=0.00833
n is tenure in number of months
Eg: For 100000 at 10% annual interest for a period of 12 months
it comes to 100000*0.00833*(1 + 0.00833)12/((1 + 0.00833)12 - 1) = 8792
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
- Traces Portal
- U/s.234E late fee- balated filing the TDS returns
- Minor Aadhar card cancelled
- Capital Gain Incidents
- Applicability of corporate governance provisions as per the SEBI LODR
- Form 121 of income tax
- Cheque bounce intimation letter
- Minor - PPF Rules Doubt
- Unable to login
- Tax on selling redeveloped resi property
- Query regarding applicability of UDIN on MCA forms signed using DSC by a Chartered Accountant
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Spice form, ? mark comes in address
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
