Property Mortgage Calculator
Originally published: 29/06/2016 08:36
Publication number: ELQ-73613-1
View all versions & Certificate

Property Mortgage Calculator

Model for calculating and tracking mortgage repayments

Calculates a comprehensive mortgage payment schedule, including:
- Payment number and date
- Interest payments
- Principal payments
- Monthly and yearly balances
- Cumulative interest.

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

This Best Practice includes
1 Excel Model

Amit Tandon offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

To calculate key elements of a propert yprovide a comprehensive payment schedule

Relevant for property mortgages.

Easily adaptable to a variety of mortgage arrangements, including:
- Periodical, annual and adhoc repayments
- Accelerated weekly/bi-weekly payments
- Fixed rate and adjustable rate mortgages.

4.7 / 5 (18 votes)

please wait...