2 Assignment #4 - Time Value of Money - This assignment includes two problems to be completed (each as a separate worksheet) and submitted as one Please provide only one submission per team. Reminder - all students on a team receive the same assignment Excel file (with two tabs). This assignment may be completed individually or in teams of two or three students. grade and the names of all team members must be included on the submission. Problem 1 The time value of money is a concept that not only applies to corporate finance but is also tremendously relevant to personal finance. A key example is developing a loan amortization schedule for a standard 30-year fixed rate mortgage. a - Prepare a loan amortization schedule using Excel for a 30-year, fixed rate $400,000 mortgage at a rate of 5.5% (payments will be monthly). Note your loan amortization schedule is to be developed by you and may NOT utilize loan amortization templates that may be found online. Since the entire amortization schedule will take 360 lines, hide the lines for payments #5 through #355 and prepare a schedule that shows payments 1 - 4, and 356 360. Also include totals after payment 360 for the total interest and total principal paid over the course of the loan. In setting up your Excel worksheet, be sure to show your input separately for the loan amount and mortgage rate so that we can do "what-if" scenarios by simply changing your input. - 2 Assignment #4 - Time Value of Money - This assignment includes two problems to be completed (each as a separate worksheet) and submitted as one Please provide only one submission per team. Reminder - all students on a team receive the same assignment Excel file (with two tabs). This assignment may be completed individually or in teams of two or three students. grade and the names of all team members must be included on the submission. Problem 1 The time value of money is a concept that not only applies to corporate finance but is also tremendously relevant to personal finance. A key example is developing a loan amortization schedule for a standard 30-year fixed rate mortgage. a - Prepare a loan amortization schedule using Excel for a 30-year, fixed rate $400,000 mortgage at a rate of 5.5% (payments will be monthly). Note your loan amortization schedule is to be developed by you and may NOT utilize loan amortization templates that may be found online. Since the entire amortization schedule will take 360 lines, hide the lines for payments #5 through #355 and prepare a schedule that shows payments 1 - 4, and 356 360. Also include totals after payment 360 for the total interest and total principal paid over the course of the loan. In setting up your Excel worksheet, be sure to show your input separately for the loan amount and mortgage rate so that we can do "what-if" scenarios by simply changing your input