please help me fill in the missing values!

Input area 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 Loan amount Interest rate Loan term 2. total interest paid over 15 year period. you must use excel function in the cells below 3. In your first month payment, how much did you pay in interest Output area: monthly payment D 1 1st month interest payment 12 13 total interest paid 14 15 16 17 11 19 20 21 22 23 24