In cell F12, use the PMT function to determine the periodic loan payment. Format the results to appear as a positive number.

=PMT(rate,nper, pv, [fv], [type])

AutoSave Bacon-explaringaC2-grader-m3 . Saved tn OnpDrivp Jared Bacon File Home r Draw Page Layout Formulas Data ReviewView Help Tell me what you want to do Share Comments Insert Calibri 11A A Percentage - Delete , Conditional Format as Cell Fermatting TableStylFormat Surt &Find & Filter Seledt ipboard. Alignment Eriting F16 Auto loan Calculator Inputs 4 Negotiated Cost of Vehicle 5 Additional Down Payment G Date ot First Payment 7 Credit Rati $ 35,000.00 $5,000.00 3/27/2019 Excellent Intermediate Calculations APR Based on Credit Rating Min Down Payment Required Sales Ta> 3.25% 1,750.00 1,750.00 5 9 Constants 10 Sales Tax Rate 11 Term of Loan In Years 12 ofPa 13 14 Credit Down Payment 15 Excellent 16 Good 17 Fair 18 Poor 19 20 21 S 6,750.00 S 28,250.00 5 1,076.04 29.17 S 1,105.21 5% Total Down Payment Amount of the Loan Monthly Paynent (P&I) Monthly Sales Tax Total Monthly Payment ts Per Year 12 5% 10% 15% 3.25% 3.50% 4.25% 5.25% 25 28 29 30 Payment E LL + 100 10:20 PM 0 Type here to search 327/2019