EMI Calculation– An Example

I wrote about how EMI is calculated and how to calculate EMI using MS Excel. It is not a big surprise to me that these are often the most viewed posts on my blog. Some of the readers commented on giving an example along with the posts, so here is the post explaining EMI with an example:

Example 1:  Assume that you take a loan of Rs 100,000 at 8.75% per annum rate for a tenure of 10 years. How to calculate the EMI?
image  Open the excel sheet and click on fx.


image
Choose the Financial category and select the PMT function.




image
In the function arguments, enter the values. In our example, our interest rate is 8.75%, so enter “8.75%/12” The Nper is the tenure in terms of months, in our example it will be 120 months, the Pv is the Loan amount and keep Fv & Type to 0. Press OK.

image
When you press OK, you will see the result in the selected cell as shown. The EMI is Rs 1253.27 for our example.

What is the interest component of say 10th EMI?
Proceed as in above, but choose the IPMT function rather than the PMT function. The following inputs are required:
image
The only new input is the Per, which is the EMI for which you want to know interest component. In our example, we want to know the interest component for the 10th EMI, so input as 10. The result is Rs 693.75.
So, when you will pay the 10th EMI of Rs 1253.27, you are paying Rs 693.75 as interest component and remaining for reducing the principal.
What is the principal component of 10th EMI?
It works same as above except that you need to choose the PPMT function rather than PMT function.
If you want to know the principal and interest amount for each of your EMIs, then there are many calculators (excel sheets) available on internet. I like this advanced excel calculator since it takes into account any additional payment made.

5 comments:

  1. Hi,
    We have read few of your posts and your blog is very Informative. Thus we are leaving this comment.
    Blogjunta.com is hosting the first of its kind Best of Indian Blogopshere 2010 polls. Do particiapte in it.
    To know more visit www.blogjunta.com

    P.S: Sorry we were not able to locate your mail ID hence dropping a note here.
    Drop us a mail at blogjunta(at)gmail(dot)com


    Yours Bloggingly,
    Team Blogjunta

    ReplyDelete
  2. Thank you for your comments BlogJunta... I am visiting your website and will participate in the polls. Thanks

    ReplyDelete
  3. Uday Mane2:55 PM

    Hi

    This is Uday from Social Wavelength. Social Wavelength is a social media agency based in Mumbai. We work with some of India's largest brands and manage their social media communications. For more information please visit us at www.socialwavelength.com

    From time to time, we engage with bloggers / influencer's and share with them information about upcoming products and services, which could be of interest to their blog-visitors or their socially-connected community. From your profile, we see that you are very active on social media platforms.

    We would thus like to invite you to participate in our effort to create communication that could be of interest to your followers. From time to time, we will make available to you product samples, previews, invitation to attend events, brand-launches etc. It will entirely be your prerogative, to choose to participate in any activity that is of interest to you.

    Do drop in a line of confirmation expressing your interest in participating in these activities, along with any specific verticals, services or products that are of interest to you. This will enable me to revert to you as and when any suitable opportunity arises.

    --

    Regards,

    Uday Mane
    Mob: 09833 219929.
    Email: umane@socialwavelength.com
    Twitter: www.twitter.com/udaymane
    Facebook: www.facebook.com/udaymane
    Blog: www.theallegorist.wordpress.com

    ReplyDelete
  4. Very Interesting Example for calculating EMI. It is very easy to calculate you only need to memorize the formula. But i have visited various banks websites and they also provide this facility of calculating the EMI by the introduction of tool called EMI Calculator. I am using it, all you need to enter the loan amount and interest rate.The resultant EMI will be the approximate EMI.I have used EMI Calculator on Dialabank.com

    ReplyDelete
  5. Thanks for sharing this great information. Me and many people will be getting benefit to know how to invest in the Property Business.

    Dreamz GK Infra Reviews

    ReplyDelete