escription: em, you will do a cost/benefit analysis on buying a more expensive car. You will also determine the minimum price at which it will take less also establish the relationship between the number of miles you drive and the time to recoup. eference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless directed Perform: Instructions Start Excel. Download and open the workbook named: Chapter_13-1_Car_Start In cell D13, calculate the number of gallons the Impreza uses to travel 100 miles on the highway if the highway MPG is in cell B13. Fill ce D13:E14 as Number with 2 decimal places In cell D17, calculate the number of gallons the Impreza uses to travel on the highway for the miles given in cell B17. Fill cell D17 down an with 1 decimal place Note: Be sure to use absolute and relative cell references. In cell D20, calculate the total gallons used in a year by the Impreza. Fill cell D20 across to cell E20. In cell D21, calculate the cost of the gas per year for the Impreza if the price per gallon is in cell B21. Fill cell D21 across to cell E21. In cell D25, calculate the gas savings per year if the Prius is bought. In cell D26, calculate the maintenance savings per year if the Prius is bought. In cell D27, calculate the extra cost of buying the Prius. Note: The extra cost is expected as a positive value. Ignore the depreciation values in your calculations. In cell D30, calculate the number of years required to recoup the extra cost of buying the Prius. Format cell D30 as Number with 2 decima In cell D32, determine the minimum price at which it will take less than 5 years to recoup the extra money. In cell B21, change the value o in cell D30 is equal to 4.99. Copy cell B21, and then paste only the value in cell D32. Format cell D32 as Accounting. Type the initial valu Note: In cell B21, type the required number with 2 digits after the decimal point. To paste only the value in a cell, click the right mouse but In cell D33, determine whether the increased number of miles driven increases or decreases the time to recoup