You are borrowing $200,000 and 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 the total interest paid on the loan.

Please use excel and show formulas used and explain why they were used. Thank you.