Data Tables & Goal Seek You just started you first job after graduating from college and you would like to purchase a used car. You have started shopping around and have realized that there are many options available for financing your vehicle. Step 1) Calculate the monthly payment using the PMT function. Use the following format: Interest Rate INPUT (use 5.0%) Term in Years INPUT (use 5) No. of payments per year INPUT (use 12) Amount of loan INPUT (use $12,000) Monthly Payment OUTPUT (use PMT function - interest compounded monthly) Total Interest Paid OUTPUT (mathematical) Step 2) You have checked around and notice that the interest rate for used car loan through your bank bank is lower than car dealership offered you. You also checked another car dealership and their rate was higher than both the bank and the other dealership. You are interested in seeing how much the interest rate impacts the monthly payment and total interest paid. Create a one-variable data table that shows the monthly payment and total interest paid for various interest rate levels (1.99% thru 9.99%, in one percent increments) Step 3) You are interested in seeing how both interest rate and loan term will impact your monthly payments. Create a two- variable data table that shows the Monthly Payment for various interest rate levels (1.99% thru 9.99%, in one percent increments) and various terms (3 years, 4 years, 5 years, and 6 years). Step 4): Using Goal seek, determine the number of years (to two decimal places) that it would take to pay off this car loan if the monthly payment was changed to $275 per month. (You will not use the data table for this...use the information from Step 1 along with the goal seek tool that we learned in class). In an open area of the worksheet, type a short statement that gives your answer (how many years) and explains how you arrived at that