Meye Center - E 5. Tomat Cot 12 Conditional Format Neutral Formatting Table Calitation wood Check Cell It De Formal Rube Si B D H Input area E G 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 monthly basis. The loan term is 15 years.compute: 1. monthly annuity payment 2. total interest paid over 15 year period. 4 Loan amount 5 Interest rate 16 Loan term 2 B Output area you must use excel function in the cells belo 9 monthly payment 10 11 1st month interest payment 12 13 total interest paid 14 15 16 12 18 10 20 21 22 23 24 2