Please help me solve this problem. I also attached an example problem showing how to find the answer usingh excel.

You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 9% with interest paid monthly. What will be the monthly loan payment? What will be the loan's EAR? Do not round intermediate calculations. Round your answer for the monthly loan payment to the nearest cent and for EAR to two decimal places. Monthly loan payment: \$ EAR: % LOAN AMORTIZATION AND EAR You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 8% with interest paid monthly. What will be the monthly loan payment? What will be the loan's EAR