Property Mortgage Calculator

Description
Property Mortgage Calculator:


- Comprehensive calculations of mortgage loan, interest (compounding options), payment schedule, specified year balance, ...
- Options of extra periodical, annual and adhoc repayments.
- Options of accelerated weekly/bi-weekly payments, fixed rate & adjustable rate mortgage (ARM), ...



Calculates a comprehensive mortgage payment schedule, including:


- Payment number and date
- Interest payments
- Principal payments
- Monthly and yearly balances
- Cumulative interest.


Components:
Basic Info - Loan Amount, Annual Interest Rate, Loan Period, Number of Payments Per Year, Compound Period, Payment Start Date, Scgeduled Monthly Payment, Scheduled No of Payments, Actual No of Payments, Years for Pay Back, Last Payment Date.
Extra Payments (Regular) - Extra Periodical Payment, Extra Annual Payment, Start with Payment No, Interest Saved.
ARM or Fixed Rate - Variable or Fixed Rate, If Variable Rate - Initial Years of Fixed Rate, Max Interest Rate, Min Interest Rate, No of Periods Between Rate Change, Interest Rate Change.
Total Payments and Interest - Total Payments, Total Extra & Adhoc Payments, Total Principal, Total Interest.
Specified Year Balance - Year No, Date, Balance Outstanding, Principal Paid, Interest Paid.

Though adequate care has been taken in developing this model, subject to comments inserted, we accept no responsibility for inaccuracy or errors in calcuations or presumptions made or for any loss which might arise on its use.


Note: You are welcome to report any errors or any suggestion for improvement. I will earnestly consider all your valuable inputs.