1 2 Input area 3 4 Loan amount 5 Interest rate 6 Loan term 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 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