1. Catalog
  2. Finance
  3. Real Estate Financials
  4. Property Mortgage Excel Calculator
Property Mortgage Calculator
  • Property Mortgage Calculator
Originally published: 29/06/2016 08:36
Publication number: ELQ-73613-1
View all versions & Certificate
certified

Property Mortgage Calculator

Model for calculating and tracking mortgage repayments

Amit Tandonby Amit Tandon
Excel & VBA, Promoter - ExcelAnytime.comFollow 188
17 reviews1,236 views|Start the discussion!|Bookmark download for free
budgetfinanceinterestreal estatemortgagepropertypaymet schedule

Description
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

Discuss

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 (17 votes)

please wait...