If its possible to show step by step on how to do each formula for each step.

Instructions This assignment requires working with the development of Tables 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 3 "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 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 5483.58 $488.26 $492.97 $22,545.63 $22,766.35 $22.988,39 523,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.32 $474 30 $17,000.00 $18,000.00 $19,000.00 $20,000.00 $21,000.00 6.00% $199.25 $422.73 5446 22 5469.70 $492.19 6.50W $403.15 $426,87 $450.58 $474,30 $498.01 7.00% $40709 $43103 $45498 $478 92 $50287 7.50N $411.04 $435.22 $459.40 $483.58 $50776 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 5522.59 YOUR Choice of car goes here 2 Loan Amount: YOUR COST 3 Annual Interest Rate: 4 Pmt. Period (months): 5 Number of Periods: 6 7 Payment Amount: 8 Total Payments: 9 Total Interest: 10 11 12 Payment Amount: 13 Total Payments: 14 Total Interest