Problem #1 (30 points) You have an outstanding student loan with required payments of $400 per month for the next 5 years (the next payment is due in 1 month's time). The interest rate on the loan is 6% APR (monthly). To help reduce the amount of interest you are going to pay, and to shorten the lifetime of the loan, you are planning on making a $1,000 payment today (i.e., you will pay an extra $1,000 that you are not required to pay). If you are required to make payments of $400 per month until the loan is paid off, how long will it take to repay the loan if you make the extra $1,000 payment, and what is the final payment amount? Hint: You will make several $400 payments and then will have 1 final payment that is equal to, or less than $400. 1. Using excel, show your analysis (24 marks). 2. Provide a basic amortization schedule to double check your work (4 marks). 3. Provide a written conclusion that outlines the number of $400 payments, and the amount of the final payment that is required to fully extinguish the loan (2 marks). Problem #1 (30 points) You have an outstanding student loan with required payments of $400 per month for the next 5 years (the next payment is due in 1 month's time). The interest rate on the loan is 6% APR (monthly). To help reduce the amount of interest you are going to pay, and to shorten the lifetime of the loan, you are planning on making a $1,000 payment today (i.e., you will pay an extra $1,000 that you are not required to pay). If you are required to make payments of $400 per month until the loan is paid off, how long will it take to repay the loan if you make the extra $1,000 payment, and what is the final payment amount? Hint: You will make several $400 payments and then will have 1 final payment that is equal to, or less than $400. 1. Using excel, show your analysis (24 marks). 2. Provide a basic amortization schedule to double check your work (4 marks). 3. Provide a written conclusion that outlines the number of $400 payments, and the amount of the final payment that is required to fully extinguish the loan (2 marks)