Monthly loan payments are $530. The lender charges .93 percent per month interest. Hint: The interest rate is already monthly so you don't need to divide it by 12, just move the decimal two places to the left to place it in decimal form, for example 0.91% is .0091 in Excel. The payments are already monthly so don't mutiply them by 12. Since you've set it up monthly, the resulting number of periods that Excel calculates is the number of months. So you don't need to adjust that either.

Required:

If the loan amount is $14,750, how many months until the loan is repaid in full? (you need opposite signs on payments and present value) ( Round your answer to 2 decimal places (e.g., 32.16).)

Number of months