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
https://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
- Fixe term employment
- Is any professional CA is here please reply
- Foreign lottery ticket bought online from India: legality, tax and consequences
- Experts need help
- Section 50-fixed asset-->building ceases to exist
- EXPORT BILL UNDER LUT FREIGHT CHARGE INCLUED IN INVOICE IT LIABLE TO TAX
- Putting a heading on received mail
- Gift Received from nonblood relative
- Tax Audit u/s 44AB for Transport Business A proprietorship is engaged in transportation business and
- Reprocessing of rectification order AY 2025-26
- Goods sold but invoice not issued
- 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
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
