6.Using the Loan Calculator and the 1.9% APR offer, how much will Molly’s monthly payment be?

The complete question is found below:

Molly saw the following deal on the Jeep website and is interested in calculating what her monthly payments ... If Molly has a $2500 down payment saved for this purchase, and assuming the $1500 Cash Allowance will apply... Use the loan calculator to determine how much will Molly's monthly payment be?

Note that the price of the cash as seen in the attached is $25,495

Repayment is for 84 months

Molly's monthly payment is $273.49  

Explanation:

The amount of finance=car price-cash allowance-down payment

the amount of finance=$25,495-$1,500-$2,500=$21,495.00  

Monthly payment can be determined using excel pmt formula

=pmt(rate,nper,-pv,fv)

rate is rate per month 1.9%/12=0.001583333

nper is 84 months

pv is the amount of finance which is $21,495.00

fv is the total repayment which is unknown

=pmt(0.001583333 ,84,-21,495,0)=$273.49