[How-To] Calculate Equated Monthly Installment using MS Excel

Excel is definitely a very powerful tool and i attribute the reason for its success to the fact that it was able to change the way people used to compute earlier. The fact that Excel was able to change the behavior of people is the real reason for its success. Therefore, it also holds a very key lesson, if we can create softwares which in turn lead to change the way people live/ work/ behave, those softwares shall certainly be big hits 🙂

In this post, i shall share with you the formula available in Excel to calculate Equated Monthly Installment.

Lets assume we need to calculate Equated Monthly Installment (EMI) for a principal of 1,00,000 for a period of 1 year (12 months) at a rate of 11%. In order to compute Monthly Installment using Microsoft Excel, follow the below mentioned steps.

1.) Go to Fx and select PMT from Financial.

Using PMT to compute EMI

2.) Enter Rate of Interest. Mention it as 0.11/12 [ 11% divided by 12]

PMT nper

3.) Enter value for “Nper” as 12 for our case of 1 year. [ number of years multiplied by 12]

4.) Enter 100000 as the value for Principal in the field called Pv.

5.) Press Ok to get the result as 8838.17.

Also read:

How-To: Create Basic Charts using Microsoft Excel

MS Office Fun: Excel Games

How-To: Copy Excel cells into a Word document
Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.Cheers

Vaibhav

Advertisements

5 Responses

  1. An interesting and useful post. XL definitely changed the way people managed numbers and calculations.

  2. […] [How-To] Calculate Equated Monthly Installment using MS Excel […]

  3. […] IT Knowledge Exchange has a huge variety of questions. Users get points and ratings to answer the questions. Its definitely worth a try for all your IT related doubts. Go ahead and give it a try, am sure you would like it. Also read: [How- To] Calculate Equated Monthly Installment using MS Excel […]

  4. […] The fact that Excel was able to change the behavior of people is the real reason for its suchttp://technofriends.in/2008/03/29/how-to-calculate-equated-monthly-installment-using-ms-excel/behaviorism – Definition from Merriam-Webster&39s Medical DictionaryDefinition of behaviorism from […]

  5. Please send me a chart giving detail bifurcation of Principal & interest components from EMI paid every month with variable can be changed as per requirement. i.e. floating rate of interest

    Thanks & regards

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: