Manage updates with the Download AppCNET Editors' review
Home Mortgage Calculator from Vertex42 is a free Excel spreadsheet template for calculating fixed and variable rate home mortgages. That sounds useful but not very exciting, which is a fairly good description of Excel spreadsheets in general. However, Home Mortgage Calculator is more than just a page full of tables. It incorporates many automated features and options, but better still, its clear explanations, numerous examples, and graphical displays make it easy not only to calculate mortgage rates but also get a better overview of your mortgage. To use Home Mortgage Calculator, you will need Microsoft Excel 2002 or above.
We extracted Home Mortgage Calculator's zipped download and opened it in Excel. The first thing we noticed was the numerous examples with caption boxes explaining each step in plain language. Each item had a small red triangle that called up additional information and instructions in a tiny pop-up when we hovered the cursor, and in clear, easy-to-understand terms, too. The spreadsheet has five main sections: Mortgage Information, Extra Payments, Balance, Summary, and Fixed-Rate ARM. The Extra Payments tool offered a graph plotting extra payments against balance year by year, while the interest rate tool includes a graph depicting Interest Rate History. Finally, the Payment Schedule tablet offered some 180 lines of calculations, similar to a tax table. The tool is extremely easy to use, yet it returned accurate calculations quickly. We merely had to enter our own values in each field and click Enter. Home Mortgage Calculator displayed everything from our monthly payment to how many years it would take to pay off our loan. Beyond its built-in features, it behaves just like any Excel template.
Since Home Mortgage Calculator is a spreadsheet template instead of a program, it doesn't have a typical Help file. However, it offers an impressive amount of assistance and plenty of explanations built right in. If you have Excel and want a home mortgage, get Home Mortgage Calculator first.
Publisher's Description
From Vertex42:
The Home Mortgage Calculator by Vertex42.com is much more than just a run-of-the-mill online mortgage calculator. It is a template for Microsoft Excel that gives you the flexibility of a spreadsheet in addition to providing a fairly comprehensive set of automated features and options. Analyze both fixed-rate and variable-rate loans and mortgages. View and print the amortization schedule. Compare monthly payments to biweekly payments. Analyze a new loan or set up the spreadsheet to analyze your existing mortgages. Run what-if scenarios and save each scenario by simply saving a copy of the spreadsheet. Calculate how much interest you can save by making scheduled or lump-sum extra payments. See how your tax deduction changes over time. Check what your balance will be at a specific year in the future. --- There is extensive help information embedded in the various cell comments. The spreadsheet is not password protected, so if you are an adventurous sort, you can see all the formulas used. The main type of mortgage that this spreadsheet is NOT designed for is a "simple interest mortgage" where the interest accrues daily (but you can find a spreadsheet for that on Vertex42.com as well).
More Products to Consider
-
Manage any mobile phone from the PC via Wi-Fi, Bluetooth, or ca...DownloadInstalled
Smart Install -
Create printable calendars with saved activities in MS Word and...DownloadInstalled
Smart Install -
Take notes and stick them to your desktop.DownloadInstalled
Smart Install -
Manage your email, time and calendar.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Create Post-it notes, bookmark websites, send/receive notes, se...DownloadInstalled
Smart Install -
Create amortization schedule in Excel for fixed-rate loan.DownloadInstalled
Smart Install -
Split and merge PDF documents.DownloadInstalled
Smart Install -
Build, save, share, and print arbitrary mind maps.DownloadInstalled
Smart Install -
Eliminate your credit card debt and consumer loans using popula...DownloadInstalled
Smart Install -
Schedule, plan, and remind yourself of important events.DownloadInstalled
Smart Install -
Create and manage various events and to-do list on your desktop...DownloadInstalled
Smart Install -
Transfer Phone Contacts, SMS, Photos, Call Log between Android,...DownloadInstalled
Smart Install -
Organize your schedule and provide reminders of upcoming events...DownloadInstalled
Smart Install -
Open over 100 different file extensions including DOCX, PPTX an...DownloadInstalled
Smart Install -
Catch up with your daily events and meeting schedules.DownloadInstalled
Smart Install -
Perform computationally intensive tasks in an interactive mathe...Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Join the search and discover one of the Mersenne prime numbers.DownloadThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install -
Manage your mobile phone through a PC.DownloadInstalled
Smart Install -
Edit your math equation.DownloadInstalled
Smart Install -
Join the search and discover one of the Mersenne prime numbers.DownloadThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install -
Incorporate images and formatted text into your daily diary.DownloadInstalled
Smart Install -
Provide a tool to analyze, manage, and view complex data.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Draw graphs of mathematical functions in a coordinate system.DownloadInstalled
Smart Install -
Provide a powerful equation plotter with numerical and calculus...DownloadInstalled
Smart Install
-
All versions:
4.7 starsout of 3 votes
-
Current version:
4.7 starsout of 3 votes
-
My rating:
Write review
Results 1-3 of 3
-
"Does all the basic things very well."
Version: Home Mortgage Calculator 2.0
Pros
Easy to use, very intuitive.
Cons
No glaring weaknesses.
-
"Best Mortgage Excel of its Kind"
Version: Home Mortgage Calculator 2.0
Pros
I could find my monthly repayment and total cost of a mortgage based on a rate and amount of borrowing.
Cons
Could not find any.
-
"Awesome! Great spreadsheet"
Version: Home Mortgage Calculator 2.0
Pros
The best feature, in my opinion, is that the spreadsheet allows you to see the long-term effect of occasional extra payments. Most online calculators will only allow you to figure recurring additional payments.
Cons
nothing so far
Summary
Fabulous tool! This is great for those who like to know how extra payments add up.
