You are borrowing $200,000and making payments at the end of each month. For an annual interest rate ranging from 5% through 10% and loan durations of 10, 15, 20, 25, and 30 years, determine thetotal interest paid on the loan.

Please show excel and show formulas used.