Assignment 1: Create an amortization table that is populated automatically as the user enters the conditions of a loan. As a starting value, use the following information: A $200,000 30-year mortgage with 10% annual mortgage rate. Payments are paid at the beginning of each month. a. Must use named ranges (names in column E) b. No hard coding in TableAmort. c. Must use IPMT, PPMT, and CUMPRINC in the table. AmtBorrowed Years MortgageRate PmtType MonthlyPMT Month Payment