i would like the loan amount to be 48,000

Crain's Sales Team - All of staff needs a NEW CAR Loan Amount: Annual Interest Rate: Pmt. Period (months): Number of Periods: 520.000.00 6.50% 1 48 WWW 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 $174.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 521,000.00 6.00% $399,25 $422.73 $446.22 $469.70 $493.19 6.50% $403.15 542687 $450.58 5474.30 $498.01 7.00% $407.09 $431.03 $454.98 $478.92 $502.87 7.50% $111.01 $435.22 $459.40 $483.58 $507.76 8.00% $415.02 5439.43 $463.85 5488.26 5512.67 8.50% $419.02 $443.67 $468.32 $492.97 551761 9.00% $423.05 $117.93 $472.82 $497.70 $522.59 YOUR NAME Date Function . 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 a "TABLE* indicating percentages in reference to cost and associated interest rates. You will need to insert the PMT function to complete this assignment . I ask 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 . 1 Crain's Sales Team All of staff needs a NEW CAR YOUR Choice of cargoes here 2 Loan Amount: YOUR COST 3 Annual interest Rate: 4Pmt. 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: 15 16 17 16 19 20 21 23 24 YOUR NAME 25 Date Function