.: How To Build A Mortgage Calculator For Free in Microsoft Excel
By:Chris Le Roy
Category:Home / Computers / Software
One of the really cool parts aspects of Microsoft Excel is the functions Microsoft has created for you to use. This means that rather than have to develop a function from scratch you can use pre-built ones to do a plethora of tasks like Building your own Mortgage Calculator. The Mortgage Calculator or PMT function is just one of many Financial Functions available.
Okay, so how to build a mortgage calculator…
The first thing we have to do is to start by setting up a few basic headings. So lets begin by starting a new workbook and clicking in the first cell A1. Enter into cell address A1 the heading - Monthly Loan Repayments. Next off, enter into cell address A2 - Amount of Loan, cell address A3 - Interest Rate, cell address A4 - Length of Loan and then in A6 - Monthly Repayment.
In example mortgage calculator, we will take the Loan Amount, Interest Rate and Length of Loan and calculate your Monthly Repayment. Okay so in the corresponding field B1 enter the value of $200,000 and make sure you format the field as a currency. In cell B2 enter a value of 9.25% and format the field as a percentage and then finally enter in a value for the Length of the Loan as 25. The value you enter into the Length of the Loan field is in years.
Now its time to create the formula that will do your calculation for the Monthly Repayment. The function we will use for this calculation is called the PMT function. The PMT function always returns a negative number so one of the things we will need to do is to convert it into a positive number, but a little on that later.
There are three arguments we will use for this formula and they are -
= PMT(Monthly Interest Rate, Number of Payments, Amount Borrowed)
So to work out the Monthly Interest Rate we simply take the value in B3 and divide it by 12 - B3/12. The PMT function works on the basic of the number of payments you are going to make, so if we are going to make monthly payments on our mortgage we simply take the number of years in cell B4 and multiply it by 12 - B4 *12.
This means that to calculate the Monthly Repayment for our mortgage we need to enter the following formula -
= PMT(B3/12, B4*12, B2)
Now as I said before, the PMT function always returns a negative value, so to turn this into a positive value we simply type the PMT function with the Absolute Function encapsulating it as shown below -
= ABS(PMT(B3/12,B4*12,B2))
Simply type the formula above into the cell B6 and press the enter key. You must now format the cell address B6 as a currency and you can do that by simply pressing the Dollar Symbol on the Formatting Toolbar. As soon as you enter the formula and press enter you should get a result of $1712.76. If you do not get this answer, simply go back and make sure that you have entered the formula correctly.
The cool part about this Mortgage Calculator is that you can go back and change any one of the values in B2, B3 and B4 which are the Loan Amount, Interest Rate and Length of Loan to work out what your monthly mortgage repayments will be.
The cool part about this simple tool is that it tells you really quickly whether borrowing massive amounts from the bank is worth it and whether you can really afford that mortgage. Why not check out what your repayments will be if your interest rate went up by 2 or 3%, it can be really interesting to see the impact on your budget.
Simple tools like this can save you thousands of dollars and can also help you see what changes interest rates will have on your own budget. It is certainly worthwhile building yourself a Budgeting Spreadsheet and the mortgage calculator to work out just what you really can afford especially in these uncertain times.
Article keywords: excel mortgage calculation, excel mortgage calculator, mortgage calculator, free mortgage calculator
Article Source: http://www.articles32.com
Chris Le Roy has available Microsoft Excel 2003 Basic Cheat Sheet to help you with Microsoft Excel. To learn more about the mortgage calculator simply check our Chris's correspondence course where you can earn yourself Microsoft Excel Certificates issued by his company without even leaving home - www.1-on-1.biz/Products/MSEXCEL/">Microsoft Excel Spreadsheet Training . www.1-on-1.biz/tipsonmicrosoftexcel/tipsonMicrosoftExcel.asp">Tips on Microsoft Excel are also Available.
.: New Software Articles
1). What Your Spouse Might Not Want You To Know
Is your spouse or significant other extremely secretive about their computer habits?
2). Why Buy Anti Spyware Software When I Can Download it Free?
Many Spyware software packages are being sold on the Internet. Many other packages are listed for free. Why should you pay for something that might be free?
3). Free Spyware Adware Remover
Computers need routine maintenance as well as systems checks in order to be in good condition at all times. This can be done by getting the proper software or sending the unit to the shop.
4). Getting Free Internet Security for Your Computer
Surfing the Internet nowadays can be very dangerous. With all the viruses, spywares, adwares, identity thieves and hackers circulating for surfers to victimize, opening and downloading an attachment sent by your friend can be very scary.
5). What Are Your Children Doing Online?
In the Internet age, our children use the computer as much as or maybe more than their parents do. Kids use the Internet to do homework, play video games, converse with their friends and more.
6). Safe Guard Your Critial Business Documents
All types of commercial places, whether in the private, public or the government sector are now increasingly using computers for various possible functions.
7). How Folder Hider Software Works
Nowadays, a computer is being increasingly used in all types of settings, whether it is an office, a corporate house or domestic settings.
.: Top Software Articles
1). Track Your MySpace Profile Visitors
I know that everyone who is on MySpace has had the same burning questions that I’ve had. How can I see who has viewed my MySpace profile? Where can I find a MySpace Tracker? Since MySpace has become so popular, so have the MySpace profile stalkers. Could be your friends, neighbors, ex-boyfriends or ex-girlfriends, or even someone you don’t even know.
2). Discover Mozzila FireFox Browser -and How to Install Extensions
Discover Mozilla FireFox Extra Features – Extensions and How To Install Them
If you are still not using any other web browser then FireFox (no matter what OS you are using) you are endangering the security of your computer and missing out on a much richer surfing experience.
One of Mozilla FireFox browser most powerful feature is the possibility to install extensions.
3). PsP Software Downloads – Review for PsP Blender
PsP software downloads is a very good way to get new software for your psp hand held. You can get psp movies from many different websites. Most of these sites include psp music downloads, psp movie downloads and psp software downloads and of course PsP Games. Many of the databases are different from one site to another. Some sites offer a wide variety of different choices.
4). Tutorial - Enabling IIS 5.1 on Windows XP Pro
Windows XP Home Edition does not support IIS
1. You may need to put your Windows XP Pro CD into the PC.
2. Go to Control Panel, ‘Add Remove Programs’, then ‘Add/Remove Windows Components’. In the Windows Components window, place a check mark
beside ‘Internet Information Services (IIS)’, then click next, then click finish.
3. During installation, Windows creates a directory at C:inetpubwwwroot and places a few files there.
5). PsP Software – Review of Software Download Sites
PsP handhelds are one of the newest and most fun ways to play games, watch movies and listen to music. PsP software downloads are just some things that you can do to improve your psp. PsP software downloads are fun and easy.
There are many places on the net were one can find psp software downloads. Some sites have you pay per download and sometimes charge up to a couple dollars for each download.
6). What To Do When Windows Fail To Boot
Copyright 2006 Otis Cooper
When Windows fails to boot it is normally caused by you installing a program or device and it has caused a conflict with one or more other programs.
This will no doubt give you plenty of heartaches if you're not certain which program caused Windows to not boot up.
If you recently installed a program or application and know where it was installed,you may be in much better shape as for as correcting the error.
7). SQL Server 2000 Data Types
SQL Server requires that each variable and column in a table should be defined with respect to the type of data it will store. From a bit to a huge image and binary storage types, the allocation is supposed to help the user conform to the data required, and help the engine allocate space and processing speed efficiently.
Built-in data types
SQL.