In this section I present to you a program that calculates mortgages.
It calculates:
- Fees
- The down payment and interest for each month of the loan
- The capital outstanding for each month of the loan
- The cost of cancellation for each month of the loan
- The total cost of loan
Note: In order to see this program you have to download the file and then open it.
Although, the system uses macro, so if your macros are disabled then you will need to enable them. Open Excel, and in Tools/Security select either a medium or low level of security. If you chose medium then agree to using macros.
Calculate your mortgage