Login
Password

Forgot your password?

Mortgage Calculator: Create Your Own

By Edited May 17, 2014 0 2

A mortgage calculator is a handy thing. With a little knowledge of excel and the right link you can have your own fully customizable mortgage calculator on your own desktop ... whenever and wherever you want it.

Stop waiting for an answer from refinancing mortgage brokers or real estate agents. Figure out your own refinancing mortgage, calculate your own mortgage payment.

Things You Will Need

A free excel amortization table downloaded.

Step 1

GET A FREE AMORTIZATION TABLE ONLINE

Simply type in free amortization table excel into a web browser and find one to download for free. Make sure it is able to be edited so that you can customize it.

Step 2

CREATE EXTRA CELLS FOR ESCROW CONTRIBUTIONS

Most people forget escrow expenses. They include property taxes, home insurance, and private mortgage insurance (PMI). Create one cell for each item. When you research a house you can find each of these figures relatively easily if you know the site to check. You can also include a cell for HOA fees if applicable.

Step 3

ADD A CALCULATION FOR MONTHLY TAXES.

This cell will be the first in a column of cells just underneath your amortization table's calculated mortgage payment. The formula in the cell can be easily created with a small amount of excel knowledge. The cell should start with an equal sign (=). While in the cell edit with the cursor just past the = click on the cell for the yearly tax amount. The cell's number should appear. Type the / symbol and then the number 12.

It should look like this: =E7/12 where E7=Yearly Taxes

Step 4

CREATE A CELL TO TOTAL ALL MONTHLY PAYMENTS FOR YOUR MORTGAGE CALCULATOR.

Make the formula this way: Start with an equals sign (=). Type in the word SUM( leaving the parentheses open. Click and drag the entire column from the mortgage payment down through the last monthly expense. Release the click, and type in the final parenthesis. It should look like this: SUM(E1:E10) or something like it.
PLAY WITH YOUR MORTGAGE CALCULATOR TO SEE WHAT IT CAN DO.

You can change the number of months for 30 year mortgages (360) to 15 year mortgage (180) or any other amount of months. You should be able to change the percentage of the mortgage rate, the month the payments will begin, and any other particular of your mortgage calculation.

Tips & Warnings

Array
Advertisement

Comments

Aug 28, 2009 1:28pm
edieness
Wow, pretty impressive article on creating a mortage calculator. Will save many looking to purchase mortage or get a mortage quote some time.
Nov 28, 2009 11:39am
LANWANMAN
Great information about finding and using online mortgage calculators.
Add a new comment - No HTML
You must be logged in and verified to post a comment. Please log in or sign up to comment.

Explore InfoBarrel

Auto Business & Money Entertainment Environment Health History Home & Garden InfoBarrel University Lifestyle Sports Technology Travel & Places
© Copyright 2008 - 2016 by Hinzie Media Inc. Terms of Service Privacy Policy XML Sitemap

Follow IB Technology