1 2 Input area 3 4 Loan amount 5 Interest rate 6 Loan term 1 8 Output area you must use excel function in the cells below 9 monthly payment 10 11 1st month interest payment 12 13 total interest paid 14 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. 3. in your first month payment, how much did you pay in interest