Publisher's Description
From ReQuantify:
Mortgage Payment Calculator for Microsoft Excel lets you enter your loan amount and mortgage repayment terms (i.e. years, interest rate, etc) and it then calculates and displays your monthly payment amount and amortization schedule automatically.
What's new in this version: Minor updates to text in spreadsheets.
More Popular Spreadsheet Software downloads
- Tables
101 downloads
- Mortgage Payment Calculator for Microsoft Excel (Mac)
26 downloads
- XLSTAT
18 downloads
- Multiple Regression Analysis and Forecasting
14 downloads
- QI Macros SPC Software
10 downloads
-
All versions:
2.0 starsout of 2 votes
-
Current version:
0 stars Be the first to review this product -
My rating:
Write review
Results 1-2 of 2
-
"Does what it says it does"
Version: Mortgage Payment Calculator for Microsoft Excel (Mac) 1.0
Pros
Does exactly what it says (for most users.) Attractive interface.
Cons
Somewhat limited, Requires excel.
Summary
If you want to look at financing options, this is a good free tool.
-
"Too limited"
Version: Mortgage Payment Calculator for Microsoft Excel (Mac) 1.0
Pros
It will help to calculate your mortgage repayments if you pay monthly
Cons
It is no good if you pay your mortgage on any other basis such as fortnightly or even weekly. Also it needs facilities to accommodate the following:
interest rate adjustments
term adjustments
advance or lump sum payments during the mortgage.Summary
The program itself needs to have an option for monthly or fortnightly payments. I guess it has been written in the US and there it may be common for monthly payments but elsewhere, banks do offer alternative payment schedules such as fortnightly, resulting in 26 payments a year instead of just 12 (which makes quite a difference on the calculations).
As for variations caused by rate changes, term changes or voluntary repayments, the easiest solution might be to break the schedule at the last payment and begin the calculations all over again. Therefore a set of instructions how to do this within this spreadsheet may be useful.
After doing this, the program would possibly have a more universal application.
Add Your Review
Submit your reply
E-mail this review
Report offensive content
Previous Versions:
%20for%20Mac%20-%20CNET%20Download.com&srcUrl=http://download.cnet.com/Mortgage-Payment-Calculator-for-Microsoft-Excel-Mac/3000-2077_4-75317309.html&x_breadcrumb=20:2010:2077&x_arw_bkts=MAD:biz_tech_opt){kind=small}