Go AD-Free with CAclubindia Pro and Daily Mobile Updates. Subscribe Now!

Calculation of EMI

RM1983 (final student) (49 Points)

08 June 2011

how to calculate emi without using excel functions (pmt).

Reply
Follow
Share

4 Replies

CA Ravi Khandelwal (Business) (752 Points)
Replied 08 June 2011

using present value annutity factors

Vijay (Adamo Studio) (2112 Points)
Replied 08 June 2011

If u want ready made excel sheet see sheet name loan payment

Arvind Sharma (ACA) (1432 Points)
Replied 08 June 2011

very simple... :)

Let rate of Int is 10% (annual), term of repayment is 20 Years and Loan amount is Rs. 20Lacs.

Then, EMI will be computed as below:-

EMI = (Loan Amount - Down Payment)/sum of PVF for 20 Years

= (20,00,000 - Nil)/8.514 = 234907

Find attached file....

Attached File : 200449 735078 emi.xls downloaded: 285 times

Deepak Gupta (CA Student) (15922 Points)
Replied 08 June 2011

CALCULATING EQUATED MONTHLY INSTALLMENT (EMI)
.
In house finance, equated monthly installment (EMI) refers to the monthly payment towards interest and principal made by a borrower to a lender. EMI is calulated using a formula that considers loan amount, interest rate, and loan period as variables.
.
The formula for calculating EMI:
EMI = (L × I) × [(1 + I)^^N ÷ {(1 + I)^^N } -1]
.
Where
L = loan amount
l = interest rate per annum divided by 12
^ = to the power of
N = loan period in months
.
Assuming a loan of Rs. 1 lakh at 9 % per annum, repayable in 15 years, the EMI calculation using the formula will be:
EMI = (1,00,000 × 0.0075) × [(1 + 0.0075) ¹⁸⁰ ÷ {(1+0.0075) ¹⁸⁰} - 1]
        = 750 × [3.838 ÷ 2.838]
        = 750 × 1.35236
        = 1,014