Question

1 Approved Answer

Posted on Oct 05, 2024

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

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 6.00% 6.SOX 7.00% 7.50% 8.00% 8.50% $469.70 $474.30 $478.92 $183.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 Payment Amount: $474.30 Total Payments: $22,766.35 Total Interest: $2,766.35 $474.30 6.00% $17,000.00 $399.25 $18,000.00 $422.73 $19,000.00 $446.22 $20,000.00 $469.70 $21,000.00 $493.19 6.50% $403.15 $42687 $450.58 $474.30 $49801 7.00% $407.09 $431.03 $154.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 $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. I 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 . . A B D E F G H 1 Crain's Sales Team - All of staff needs a NEW CAR 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: 15 16 17 18 19 20 21 22 23 24 YOUR NAME 25 Date Function 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 6.00% 6.SOX 7.00% 7.50% 8.00% 8.50% $469.70 $474.30 $478.92 $183.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 Payment Amount: $474.30 Total Payments: $22,766.35 Total Interest: $2,766.35 $474.30 6.00% $17,000.00 $399.25 $18,000.00 $422.73 $19,000.00 $446.22 $20,000.00 $469.70 $21,000.00 $493.19 6.50% $403.15 $42687 $450.58 $474.30 $49801 7.00% $407.09 $431.03 $154.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 $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. I 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 . . A B D E F G H 1 Crain's Sales Team - All of staff needs a NEW CAR 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: 15 16 17 18 19 20 21 22 23 24 YOUR NAME 25 Date Function