About Me
Blog New Blog RSS
Books Updated Book Gold Asterisk
Book Reviews
Professional Book Calendar Gold Asterisk
EFCS Book Calendar Chat
Being Geek Book Calendar Open Source
Simple n Usable Book Colors Gold Asterisk
Lazy Project Mgr Book Chat
Pt. Ram Mate Marathi Music PDF
Dr. Veena Sahasrabuddhe New Gold Asterisk Music
HCM Primer Music PDF
Raga Info Information Marathi Music
Ringtones Gold Asterisk Music
DevaGandharva Book Music
Stotras Gold Asterisk Marathi Music
Recitals New Gold Asterisk Music
Notation New Gold Asterisk Music
Quora Q and A New Gold Asterisk Music
Foto Feature
Udaipur India Sunflower Travel
SERA Open Source Python
WERD Marathi Open Source
YaMA Popular Gold Asterisk Open Source
Almanac Updated Calendar Marathi Almanac
Pine and VIM
Colors Colors Light Open Source
URL Viewer Open Source
Timeline Script Open Source
EMI Calculator Popular Updated India
Me Says
Shivaji Popular Gold Asterisk PDF
Bonded Labour ? Chat
On the WWW Chat
Life's precious ! Chat Colors
Ekatech Lotus Marathi
Seeta Mai Lotus
Musical Interview Music
Oosa Marathi Sunflower
Kaakaskparsha Popular Marathi
Panshet Poor Popular Marathi
From the Collective
Pune Flood Fotos New Water
Career Tips Popular Calendar
More ...
Pics I Like
Ganesh Colors Marathi
Just Be Colors
Lotus Pond Lotus Nature
Word Power

send me email

Visit my older blogs :

When we exchange knowledge it is a discussion,and when we exchange ignorance it is an argument. -Dr. Subodh Khare see all quotes

EMI Calculator

EMI Calculator is the first of its kind in the world when released in March 2007, as far as Google Search tells !

LoanEMICalculator is a spreadsheet that can be used to calculate Equated Monthly Installments (EMI) for given Principal, Interest Rate and Period values. It calculates the total amount repayable, the total principal component and the total interest component over the period. It is a Tenure calculator for the loan according to disbursement and pre-payment parameters. You get to see the complete Amortization Table for your loan over the period.

The maximum period supported is 40 years. For every month, throughout the period, you get to see

  • the monthly EMI
  • the monthly principal component of EMI
  • the monthly interest component of EMI
  • the balance principal amount at the end of the month
If any part of principal is prepaid in a month, it is reflected following month onwards. Additionally, for every year, you can see the total payout in that year including the principal and interest parts.

For loans with variable interest rates, if changed rate is specified in a particular month, it is reflected for rest of the period, either till the end of the period, or till the next change is specified.

One can compare loans from different financial institutions to see which works out best. It is hoped that one can do what-if analysis through the entire period.

Click the links below to Download version 2.1 of EMI Calculator as an
Open Office document or an
Microsoft Excel file. Alternatively, Right-click (Windows) or Control-click (Mac OS) the above links. Choose the appropriate save or download option. The options vary depending on your browser: for Internet Explorer it is Save Target As, for Firefox it is Save Link As, for Safari it is Download Linked File.

If you require the older version for any reason, you can click the links below to download version 1.1 of EMI Calculator as an
Open Office document or an
Microsoft Excel file.

EMI Calculator is released under GPL. Your comments, suggestions are welcome. Your contributions will be acknowledged in the next version.

Support Wikipedia

Advertise with us

Message in
Public Interest

www.atulnene.com ©1998-2016 Atul Nene