In this question, please refer to the spreadsheet for your individual-specific values of the question parameters and fill in the blank spaces in the question below. Please use these values for all calculations. The first three columns in the spreadsheet list the last three digits of the student numbers of all students in the class. Please identify the row that has the last three digits of your student number. Your parameters are in the same row.

[10 Points] You have purchased a home using a _______600,000_______ mortgage. The mortgage charges interest of ____7.8___% APR, which is compounded ______semiannually__________. You will be making monthly payments on your loan for ___20__ years.

[4 Points] Develop a spreadsheet in Excel that shows the amortization schedule of your loan. Please submit the schedule.

[6 Points] How would your amortization schedule change if interest were to be compounded _______semiannually_________ and the payments were ___________biweekly_________? Please submit the schedule.