Calculation



0
Mukesh took a home loan for Rs. 10,00,000 for 10 years @ 10% p.a., what is the EMI for this loan?

How can we calculate this in Excel ?? Please let me know

2 Answer(s)


0

Hi,

EMI Formula: =PMT(rate,No.ofYrs,PV,FV,Type) or =PMT(r,n,pv,fv,type)
EMI =162,745.39 *=PMT(10%,10,1000000,0,)
r-10%
pv-1000000
n-10Yrs

Thanks,
Tapan

0

Thanks much Tapan.