Skip to main content

EMI calculator and Loan calculator : An xls attached to help you


This time I am attaching an xls file that will help you to find the EMIs of your loan and will help you to get an idea about how your bank is calculating the EMIs and how much principal repayment is done every month.  This will also help you to calculate the total interest and principal repayment for a financial year, that will help you to declare the Tax in case of Home Loans. This calculator is using the PMT excel formula to find the EMI.

Click the link to download the  EMI Calculator.

The xls file has two sheets :

  1. EMI Calculator –> This sheet will help you to calculate the EMIs if you enter the Loan amount, Loan tenure in years and Interest Rate.
  2. EquiDivided_Principal –> This sheet will help you to calculate the monthly payments if your bank is not following the EMI approach and is using the equi divided principal approach for the loan. Here also you need to enter the Loan amount, Loan tenure in years and Interest Rate to get the details.
To compare the home loan rates of different banks, got to the url : http://www.deal4loans.com/home-loans-interest-rates.php

screen shot 1: EMI Calculator sheet :



screen shot 2: EquiDivided principal calculator sheet :




Labels:

Comments

  1. Unknown4 January 2013 at 17:53

    The calculator you suggested is the offline calculator and need the MS Excel for calculations. What will a person do, who does not have MS Excel? Provide a good Online EMI calculator for them as an exception.

    ReplyDelete
  2. Sony Thomas5 July 2013 at 21:49

    go for open office or Lib office, which are FREE calculators... :-)

    ReplyDelete

Post a Comment

Popular posts from this blog

How to convert your Blogger Blog to PDF ?

You can use a website called "blogbooker" @  http://www.blogbooker.com/blogger.php   to convert your Blogger Blog to a PDF . Please find the steps below : 1. Save your blog as an xml using Blogger Settings - Other - Export Blog option 2. Go to the website " http://www.blogbooker.com/blogger.php " and select this XML , give your blog address and select the options like date range, page size, font, ... 3. Click the  "Create Your BlogBook" button to view and save your blog as PDF
4 comments
Read more

ATG License Files and Oracle Software Delivery Cloud

Oracle no longer generates license keys that are specific to your IP address(es). Oracle now provides generic license files that enable you to fully utilize all of the features for which you are licensed. Please find the ATG License files for different ATG versions @ http://www.oracle.com/us/support/licensecodes/atg/index. @ Oracle Software Delivery Cloud , you can find downloads for all licensable Oracle products –> https://edelivery.oracle.com/ Please find below a screen shot for ATG products download :
Post a Comment
Read more

Eclipse plug-in to create Class and Sequence diagrams

ModelGoon is an Eclipse plug-in avaiable for UML diagram generation from Java code. It can be used to generate Package Dependencies Diagram, Class Diagram, Interaction Diagram and Sequence Diagram. You coud get it from http://marketplace.eclipse.org/content/modelgoon-uml4java Read more about it and see some vedios about how to create the class and sequence diagram @ http://www.modelgoon.org/?tag=eclipse-plugin Find some snapshots below which gives an idea about the diagram generation.
8 comments
Read more

ATG Product Catalog schema ER diagram

Check out the O rder schema ER-Diagram @   http://tips4ufromsony.blogspot.in/2012/02/atg-order-schema-er-diagram.html Check out the User Profile  schema ER-Diagram @ http://tips4ufromsony.blogspot.in/2012/03/atg-user-profile-schema-er-diagram.html If you would like to know the relationship between different Product Catalog tables, please find below screen shots of  Product Catalog schema ER Diagrams.
3 comments
Read more

Eclipse plug-in : single java file compiler

At any point of time, you think about an Eclipse plug-in to compile a single java file in your Eclipse (as the Eclipse provide only the option for Build-All ) ? Here , I am giving the links to a plug-in, helping you to compile a single java file. Find the plug-in @ http://timealias.bplaced.net/eclipse2ant . Please find below some screen shots:
Post a Comment
Read more