2:16 PM Tue Mar 440N) F31314TVM-analysis using+EXCEL Home Insert Draw Formulas Data Review View QB2 @ Arial 12 BIUSO ili IA A fx L M Input area D You just bought a house by getting a $200,000 loan from a bank, the loan rate is 4% per year, but the payment must be made on a moothly basis. The loan term is 15 years, compute. 1. monthly annuity payment Loan amount Interest rate $ Loan torm $200,000 4% 15 2. total interest paid over 15 year period 7 Output area: you must use excel function in the cells below 8 monthly payment 9 10 1st month interest payment 12 total interest Paid 13 15 20 %18KONNE 26 28 29 30 31 32 33 Abc 123 + 11 Loan Amortization Name and Instructions B I V thank