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

20 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. This comment has been removed by the author.

    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
  10. Is it just the low paid and poor scholastic achievers who end up bankrupt or discovered blameworthy of extortion? What is happening? mortgage advice manchester

    ReplyDelete
  11. Math Calculator - Pre-Algebra, Algebra, Pre-Calculus, and Calculus solver with detailed steps, videos, and thousands of practice problems
    algebra solver

    ReplyDelete
  12. Shalom, Om swastiastu, Namo buddhaya, Salam kebajikan, pada artikel kali ini kami akan memberikan kepada kamu Panduan Cara Bet 2D Togel Klik4D Online yang tersedia di S128cash. Berhubung permainan togel adalah game legendaris di Indonesia, tahukah kamu kalau game togel sekarang bisa dimainkan secara online ? (Baca Selengkapnya Disini...)

    ReplyDelete
  13. I invite you to the page where you can read with interesting information on similar topics. 178 cm in feet

    ReplyDelete
  14. Weight estimates do vary, however a few palaeontologists have cautioned that this animal may want to have handed 2,000 kilogrammes in weight.What is Mosasaurus

    ReplyDelete
  15. This particular is usually apparently essential and moreover outstanding truth along with for sure fair-minded and moreover admittedly useful My business is looking to find in advance designed for this specific useful stuffs… algebra calculator with fractions

    ReplyDelete
  16. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work algebra calculator simplify

    ReplyDelete
  17. With the economy and job market in a deep hole, students (and their parents) are going back to school with a keen eye on costs. They can no longer get by with a pad of paper and a handful of pencils. Each year the list of supplies grows longer and the items increase in cost. Among the supplies that students would rate as budget busting is the graphing calculator, now required by many schools for math and science classes and almost a certain necessity for college bound high school kids planning on taking the SAT and other standardized tests. hours calculator week

    ReplyDelete
  18. The term 'global village' has been coined to aptly describe what technology (and information) has done to the world today. The manifestations of technology are too numerous to mention. Right now, we all breathe, eat, sleep, think and dream technology. It has thoroughly infused itself into our conscious self as well as our sub-conscious. The endless stream of information which it provides has illuminated our lives beyond comprehension. An attempt to understand technology leads to several riddles and enigmas. Simply put, most of technology's findings fill us with awe and are beyond understanding. An objective analysis of technology might be difficult because of individual differences. However, there has to be an attempt to answer this question. The million-dollar question that lingers on the minds of everybody. How has technology affected the modern man? offshore vps

    ReplyDelete
  19. This is the reason it really is greater you could important examination before creating. It will be possible to create better write-up like this. SLA uptime calculator

    ReplyDelete
  20. This strategy however was being used for an exceptionally extensive stretch, before long got old. how many minutes in a day

    ReplyDelete