$1\mathrm{.}4$ Looking at your budget, you think you can afford $$250($cell C$15)$ a month for a payment. You would like to pay the car loan $($cell C$14)$ off in less than $60$ months if possible. The dealership is running a promotion with a local credit union that offers you a $4\mathrm{.}99\%$ interest rate $($cell C$16)$ if you pay off the car in $42$ months or less. Would you qualify for the promotion if you paid $$250$ a month for your car? Use the NPER function in cell C$18$ to calculate the number of payments you would make on your loan.