i need help with the excel functions with this problem

#9

do not charge me personally for this. i utalize chegg for a reason.

You want to buy a new sports coupe for $84.500, and the finance olfice at the dealership has quoted you an Aph of 4.7 percent for a 60 -month loan to buy the can. What will yoar monthly payments be? What is the effective annual rate on this loan? input area: (Use cells A5 to B9 from the ghen information to complete this question. Your poyment shou Output area Students The acratchipad anea is for you to do asy adeitionai work you need to solve this ques Nothing in this area will be graded, but it well be fubmitfut unith your assignment