I understand how to do the math and get the answer normally. But how do I do the excel formula to get the answer?

1 Before purchasing a used car, Cody Lind checked www.kbb.com to learn what he should offer for the used car he wanted to 2 buy. Then he conducted a carfax.com search on the car he found to see if the car had ever been in an accident. The Carfax was clean so he purchased the used car for $14,750. He put $2,000 down and financed the rest with a 48 -month, 7.5% loan. \begin{tabular}{c|l|r|} 3 & & \\ \cline { 2 - 3 } 4 & Purchase amount: & $14,750.00 \\ \cline { 2 - 3 } 5 & Down payment: & $2,000.00 \\ \cline { 2 - 3 } 6 & Months financed: & 48 \\ \cline { 2 - 3 } 7 & Months per year: & \\ \cline { 2 - 3 } 8 & Annual Percentage Rate (APR): \\ \hline 9 & & 7.50% \\ \hline 11 & Required: & \\ \hline 12 & Using the information above, answer the following: \\ \hline \end{tabular} Note: Use cells A4 to B8 from the given information to complete this question. 1. What is the amount financed? 2. What is his monthly car payment? $12,750.00 =B15 ( 18 19 20 21 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment. 23