Answer: (D) 5.90%
Explanation: David is going to buy a new car at $21,349.
The down payment is $3,000.
Loan amount (Present value) = $21,349 - $3,000
Loan amount (Present Value) = $18,349
Installment amount (pmt) = $352
As the payment is made monthly (12 months in a year),
Number of payments = 5 * 12
Number of payments = 60
Using the rate option in excel,
![=rate(nper,pmt,-pv,fv,type)](https://tex.z-dn.net/?f=%20%3Drate%28nper%2Cpmt%2C-pv%2Cfv%2Ctype%29%20%20)
Insert the variables into the option, we get
![=rate(60,352,-18349)](https://tex.z-dn.net/?f=%20%3Drate%2860%2C352%2C-18349%29%20)
By inserting the above formula in excel we get,
Rate = 0.47%
Rate of 0.47% is monthly, to get APR
![APR = (1+monthly rate)^12 - 1](https://tex.z-dn.net/?f=%20APR%20%3D%20%281%2Bmonthly%20rate%29%5E12%20-%201%20)
![APR = (1+0.0047)^12 - 1](https://tex.z-dn.net/?f=%20APR%20%3D%20%281%2B0.0047%29%5E12%20-%201%20)
![APR = (1.0047)^12 -1](https://tex.z-dn.net/?f=%20APR%20%3D%20%281.0047%29%5E12%20-1%20)
![APR = 1.0586 - 1](https://tex.z-dn.net/?f=%20APR%20%3D%201.0586%20-%201%20)
APR = 0.0586
APR = 5.86% or 5.90%
Therefore the correct option is 5.90%.