I am very familiar with loan calculation, but I do not understand some of the terms that you include. I suspect they are added to throw you off; that is, irrelevant information to confuse you.

All that is financed is the "amount of the loan"; that is, $28,250.

The "negotiated cost", the "additional *(sic)* down payment", the sales tax, and the "total *(sic)* down payment" are irrelevant for the purpose of calculating the monthly payment.

Arguably, they might be relevant for the purpose of calculating the true APR.

But if the stated "APR" is not, in fact, the annual interest rate, you have not provided sufficient information to calculate the monthly payment.

(In US, the terms "APR" and "annual interest rate" are potentially different, even though "Annual Percentage Rate" sounds the same.)

Since this is an "assignment", I do not want to spoon-feed the solution to you. Instead, I'll pass along some tips that should help.

If you want to calculate a "periodic" payment (monthly, since there are 12 payments per year), you must convert the annual interest rate (presumably 3.25%) to a periodic rate. Typically (in the US), we do that by dividing the annual rate by the number of payments per year. Some other countries does it differently for some loans (mortgages).

Likewise, the loan term in years must be converted to the number of payments for the term of the loan. That is, multiply by the number of payments per year.

Finally, if you enter the loan amount as a positive number, PMT returns a negative number. If you want a positive result, simply negate the PMT result. In other words, =-PMT(...) instead of =PMT(...).

Alternatively, you can enter the loan amount as a negative number. In other words, -28250 instead 282500, or -B8 instead of B8.

The key is: Excel uses "signed cash flows" for most financial functions. (But not all, sadly.) That means: assign one sign (plus or minus) to inflows, and assign the opposite sign (minus or plus) to outflows.

It does not matter what you call an inflow or outflow; it depends on your point of view (lender v. borrower). It does not matter which sign you use for inflows; just be consistent.

I choose my signs so that functions return positive values. So, in this case, I would use -28250 (inflow for the borrower; outflow for the lender) so that the PMT result is positive (outflow for the borrower).