Need help using a PMT Function

Smith's

Sales Team - All of staff needs a NEW CAR
Loan Amount:	$27,585.00
Annual Interest Rate:
Pmt. Period (months):
Number of Periods:
				YOUR Choice of car goes here
Payment Amount:
Total Payments:
Total Interest:
		Column2	Column1	6.00%	6.50%	7.00%	7.50%	8.00%	8.50%
	Payment Amount:
	Total Payments:
	Total Interest:
3/7/17
Note: replace my name with yours!