• 

Send to a friend

• linkedin
• twitter
• facebook
• google+
• code

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

by Amit Tandon
Excel & VBA, Promoter - ExcelAnytime.comFollow 151

13 reviews909 views|Start the discussion!|Bookmark

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

Reviews

• kdt156(last updated: 26/08/2019 18:51)
  
• Jeffrey McKinney(last updated: 15/08/2019 15:32)
  
• Research Folder(last updated: 03/05/2019 17:42)
  
• Mark Sanz(last updated: 10/03/2019 18:08)
  
• Mihai Axinte(last updated: 19/01/2019 15:10)
  
• Joseph Gasper(last updated: 04/01/2019 00:15)
  
• tantra(last updated: 03/01/2019 14:43)
  
• mubeen tariq(last updated: 21/12/2018 08:15)
  
• P Dimas(last updated: 16/11/2018 05:43)
  
• Abdul Ghafur BE, MCIOB, AClArb, CQS,610(last updated: 22/10/2018 08:06)
  
• Christopher M(last updated: 23/09/2018 07:47)
  
• RAJU G V V S(last updated: 08/08/2018 15:59)
  
• AlexSmith(last updated: 22/06/2018 07:43)
  

People using this Best Practice also downloaded