Monday, March 22, 2010

EMI Calculator

My friend is taking a loan to buy a house and he asked me what will be my EMI. He knew following figures and was curious to know his EMI

Loan Amount
Annual Interest Rate
Loan Period - Years

I quickly calculated EMI using PMT function in excel. This triggered me an idea of making a EMI calculator and sharing it with all of you.
EMI Calculator

Equated Monthly Installments are commonly knows as EMI. As per business dictionary EMI is "Hire purchase, lease, or loan -repayment installments that are constant in amount, and are usually collected in advance as post-dated checks"


Download EMI Calculator Excel file to know your EMI

Input your figures to find out resultant EMI. Use spin buttons to fine tune your results

In next post I will discuss how to make EMI Calculator. This will be about adding Spin Buttons ActiveX controls to worksheet and PMT function

9 comments:

  1. Cool, great tool

    http://daily-exceltips.blogspot.com/

    ReplyDelete
  2. There are various EMI Calculator which are available online to check the EMI Of your Loan. You should just want to know your loan amount, rates of interest and tenure period.

    ReplyDelete
  3. i tried but not completed debug problem shows

    ReplyDelete
  4. Different types of calculations including those related to property taxes, insurance, income tax benefits, and house loans can be easily carried out by these calculators.guarantor loans

    ReplyDelete
  5. Outstanding blog you guys have preserved there, I totally valuate the effort.
    laminator

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. Heard about the site regarding mortgage calculator with extra payment from a dear friend. Is it as useful as people think? mortgage calculator with extra payment

    ReplyDelete
  8. Main concern: illuminates long mathematical articulations right away (as long as you wouldn't fret the "console babble").
    AD List 24

    ReplyDelete
  9. Being a waiter or waitress is not just the most useful paying occupation in the event that you are just going to take a look at your fundamental wage. It's possible to earn significantly more by simply depending upon server tips that you receive daily. Tips will be able to assist you in making ends meet, and can even get you things that aren't basic necessities. Some use their trick earnings to go on vacations. But times are hard for everybody else these days, you're able to tell by the diminishing hints you buy monthly.You can use this Tip Calculator through which you can easily came to know split the tip and all the bill amount among the given number of people.

    ReplyDelete