Case Study 1 Go to 5-18 in the textbook - Loan Amortization Schedule Suppose you borrowed $30,000 on a student loan at a rate of 8% and must repay it in 3-equal installments at the end of each of the next 3-years. How large would your payments be, how much of the first payment would represent interest, how much would be principal, and what would your ending balance be after the first year? Show all calculation (I need to see how you arrive at your answers. Use Excel formulas or functions to compute. Draw a Loan Amortization Schedule for this problem. Label each column and the number years