Question:

Home loans typically involve points, which are fees charged by the lender. Each point charged means that the borrower must pay 1% of the loan amount as a fee. For example, if the loan is for $120,000 and 2 points are charged, the loan repayment schedule is calculated on a $120,000 loan but the net amount the borrower receives is only $117,600. Assume the interest rate is 1.00% per month. What is the effective annual interest rate charged on such a loan, assuming loan repayment occurs over 216 months? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. (Use an Excel.) Effective annual interest rate

Please proper format in excel file and do not copy from Chegg. Otherwise I have to report the answer.