Instructions:

1) On a cover page, provide the following:

a) A mortgage amount, term and rate approved by your instructor,

b) Show the calculation of the required monthly payment (see page 2).

c) Calculate the total payments and the total interest that would be paid over the life of the mortgage you have selected above

(see page 4).

2) Using Excel, set up an amortization(repayment) schedule for each of the three scenarios:

a) Prepare an amortization schedule for your mortgage with \$2,000 additional payment per year

b) Prepare an amortization schedule for your mortgage with \$3,000 additional payment per year

c) Prepare an amortization schedule for your mortgage with \$5,000

For each of the above scenario, show:
• Calculation of annual payment
• Total interest paid for the specific scenario,
• Amount of interest saved by payment of additional sum each year, and
• Number of years it took to pay the off the entire mortgage

Note: See the PowerPoint file for this project for step-by-step instructions on how to set up an Excel worksheet, and how to

present the above information at the bottom of each worksheet.

Last Updated on February 10, 2019

Don`t copy text!