I need help with the formulas. please show the formulas in the answer

Instructions This ment requires working with the development of thes and PMT . In regards to this assignment, it may be necessary for you to use many areas of the book to solve . First, you will need to set up a "TABLE" indicating percentages in reference to cost and associated interest rates You will need to insert the PMT function to complete the . I ask that you select a vehide of your choice offerent from what provided thereby changing provided numbers, and strated in the TABLES with that of your section Date function your choice at the bottom of your spreadsheet Attachments A WA light Crain's Sales Team - All of staff needs a NEW CAR Loan Amount $20,000.00 Annual interest Rate Pr.Period mental Number of Periode Payment Amount: 547420 Total Payments $22,74625 Total interest SE E PALES 100E MOSE VOSE Payment Amount Total Payment Totes 600 6.SON SOON 5040 506.7054700 SA 02 SU SE265452.90 522,746-35 22.535.3 22.706 22 571.211.75 5230 ST $2,1 2,545,632.765.5 2117 116415 NOS TO WE DON SON $10 GOON WE CUS WEES 4110 3406 E SEUS 54141 543430 60 511,000.00 5.25 $13,000.00 542273 $1.000.00 54 $20,000.00 S. $21.000.00 Se SIS 5426 SAS 94303 5454 TES SA10 SAS 3507 34 73.2 SO SY es $51242 Se 5176 302 YOUR NAME Instructions This assignment requires working with the development of Tables and PMT In regards to this migment, it may be necessary for you to use many areas of the book to solve. . First, you will need to set up a TABLE' indicating percentages in reference to cost and associated interest rates . You will need to insert the PMT function to complete this assignment Task that you select a vehicle of your choice different from what I provided thereby changing my provided numbers, and illustrated in the TABLES with that of your own selection, Date function your choice at the bottom of your spreadsheet Attachments Crain's Sales Team - All of staff needs a NEW CAR Loan Amount: Annual Interest Rate: Pmt. Period (months): Number of Periods: $20,000.00 6.50% 1 48 Payment Amount: Total Payments: Total Interest: $474.30 $22.766.35 $2,766.35 Payment Amount: Total Payments: Total Interest: $474.30 $22,766.35 $2,766.35 6.00% 6.50% 7.00% 7.50% 8.00% 8.50% $469.70 $474.30 $478.92 $483.58 $488.26 $492.97 $22,545.63 $22,766.35 $22,988.39 $23,211.75 $23,436.41 $23,662.37 $2,545.63 $2,766.35 $2,988.39 $3,211.75 $3,436.41 $3,662.37 $474.30 $17,000.00 $18,000.00 $19,000.00 $20,000.00 $21,000.00 6.00% $399.25 $422.73 $446.22 $469.70 $493.19 6.50% $403.15 $426.87 $450.58 $474.30 $498.01 7.00% $407.09 $431,03 $454.98 $478.92 $502.87 7.50% $411.04 $435.22 $459.40 $483.58 $507.76 8.00% $415.02 $439.43 $463.85 $488.26 $512.67 8.50% $419.02 $443.67 $468.32 $492.97 $517.61 9.00% $423.05 $447.93 $472.82 $497.70 $S22.59 YOUR NAME Date Function