EMI CALCULATOR
In
this article we learn how to create EMI CALCULTOR based on the how much
loan amount taken by MR. A
MR.
A took a loan amount of Rs.40000 for
period of one year with 7% Rate of Interest. Online a lot of EMI Calculator
available but in this article we use MS excel to Create EMI Calculator which
will showing a data related to EMI INSTALMENT for a period of One year , how
much interest paying by us month wise along with how much amount is left to pay
after certain month
Follow
the steps to create EMI CALCULATOR in excel A detailed video of EMI Calculator
also available for your reference
As
you already aware that MR.A took a loan of Rs. 40000/- Period
– 12 Months (one Year) and Interest Rate -7% EMI Installment?
For
Calculation EMI INSTALLMENT In excel we use PMT Function
The Syntax of PMT function (rate,nper,pv,[fv],[type]
Check
out video for the complete Calculation process along with Chart
CONCLUSION:
Dear readers in this article you will get to know
about creating EMI Calculator in excel with detailed distribution chart,
hope you got all information. If any questions kindly comment below.