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

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 Search - search engine tuning settings

In this blog, I am going to list the best tuning settings for ATG Search engine. The AESoapConfig.xml, AESoapWaspConfig.xml  and AEConfig.xml are the xmls referred below and you can find it @  <ATG_DIR>\<Searchx.x>\SearchEngine\<operating_system>\bin\ folder. (1)  Make sure that the AESoapConfig.xml's rwTimeout is less than or equal to routing's readTimeoutMs. You could find the routing's readTimeoutMs @ atg\search\routing\SearchEngineService component.               rwTimeout is the  length of time in seconds to wait before a read or write operation times out on an active connection. The number can be decreased to improve performance. However, a value that is too low could cause slow connections to be prematurely closed. (2)  Adjust the number of engine threads to match the number of CPUs available to the engine. Note that the minimal value for maxThreads and maxSpareThreads is 2, which applies to running with 1 CPU.  However, it is recommended to
Post a Comment
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

SOAP UI faster start up

If you feel like your SOAP UI is starting up very slowly, check whether this is due to any start up web page call. You can check this @ Preferences - UI Settings - Show Startup Page ==> Here you can deselect this option to improve the start-up time.
Post a Comment
Read more