Please help me with the following problem:

Below is an EXAMPLE problem solved using excel method

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