• 

Send to a friend

• linkedin
• twitter
• facebook
• 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 178

17 reviews1,110 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

Reviews

• • 
    4.7 / 5 (17 votes)

    • 82%
    • 6%
    • 12%
    • -
    • -
  • Rate this Downloadable Best Practice
    

    Write a review

• Adib Basbous(last updated: 10/09/2020 07:54)
  
• Jill Sinclair(last updated: 04/12/2019 14:56)
  
• Vivek Kulshestha(last updated: 06/10/2019 19:09)
  
• Charles.HA. Chen(last updated: 26/09/2019 10:20)
  
• 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)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded