please provide excel solution

Question 6 10 pts Problem 6. An eight-year loan for $10,000 is assumed with annual interest 10% compounded monthly. a) Calculate the amount to be paid monthly. b) Calculate the respective portions on each payment used to pay for interest in periods 30 and 37. Payment = $151.74; $68.72 and $55.51, respectively Payment = $151.74; $64.72 and $59.51, respectively O Payment = $151.74; $74.72 and $49.51, respectively Payment = $151.74; $164.72 and $179.51, respectively