How to calculate emi plz help

For the given parameters EMI for 15 years would be Rs. 1074.61

Same can be calculated by using PPMT and IPMT formula in excel

Thanks

you can also use www.emicalculator.net

but sir , let me know how solve this ?

EMI calculator attached for your reference.

thanx sir but i want to solve this practicaly

without any formula in excel or without any software

EMI= Principal / Present value annuity Factor (r,n)

so here EMI=100000 / PVAF(10%,15y)=100000/7.6061=Rs 13,147

So emi is Rs 13147

Originally posted by : krishna teja
	EMI= Principal / Present value annuity Factor (r,n)   so here EMI=100000 / PVAF(10%,15y)=100000/7.6061=Rs 13,147   So emi is Rs 13147

The amount calculated above is called Equated Annual Installment (EAI) not Equated monthly Installment (EMI)

 

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

This is the formula to caluculate: E = P×r×(1 + r)n/((1 + r)n - 1). E is EMI. 

Car Audio

this is 12 X 100

Since EMI is monthly so annual rate is divided by 12

The Mathematical formula for calculating EMI = [P x R x (1+R) ^n] / [(1+R)^ n-1].

P is the principal loan amount,

R rate of interest per month and

N is the the number of monthly instalments.

Manual calculations are too complicated to perform accurately, which is why many borrowers are left confused after availing a loan. Understanding this pain-point led BankBazaar to develop one of the easiest and most user-friendly online Loan EMI Calculators.

I saw one of the best website here you just enter Loan amount, Tenure and Interest rate you will get how much you will monthly EMI.

Source: https://www.bankbazaar.com/finance-tools/emi-calculator.H T M L