AT&T 1:06 PM * 94%@ - Done Case 1-1.docx Create an amortization table in MS-Excel in the format shown below: Payment peniods Peniadc rate of atBeg Principa Balance ntst Paymnt 897 57 380 82 046 5940243 433 1906 ,380 02 046 59 5010 Scenario: 2 years ago Janice got a $100,000, 15-year mortgage with an annual interest rate of 6% and monthly payments. 1) What is her monthly payment? 2) How much does she owe today (after 24 payments)? ) How much will she owe in 3 years (after 60 payments)? 4) How much will she owe in 3 years (after 60 payments) if she makes an extra $200 payment every month starting today? Post to Canvas one MS-Excel file. Include your amortization table on one sheet (30 points) and your answers to the above 4 questions on a different sheet (20 points) within the same Excel file. Your amortization table should be set up so that if the assumptions change your table updates appropriately