1. Compute the number of gallons each car uses to travel 100 miles on the highway and 100 miles in the city. Format as a number to 2 decimal places.
2. Compute the number of gallons each car uses to travel the miles given for highway and city. Format as a number to 1 decimal place.
3. Compute the total gallons used in a year for each car and the cost of the gas.
4. Compute the gas and maintenance savings per year if you buy the Prius, and the extra cost of buying the Prius.
5. Determine the number of years it will take to recoup the extra cost of buying the Prius. Format as a number to 2 decimal places.
6. Given how long it takes to recoup the extra money, change the price of gas to determine at what minimum price the years to recoup will be under 5 years (4.99 years). Format as accounting. Does increasing the number of miles you drive increase or decrease the time to recoup?

I'm having trouble coming up with the formulas in order to answer the questions above. Attached below is the snapshot of the excel document.

Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless directed otherwise, as you will not receive full cred for your answers. You are buying a car and wish to do a oostfbenet analysis on buying a more expensive Prius, which gets better millage, 50 cityf54 highway mpg [mila per gallon), than a las expensive Subaru Impreza, which gel: 23 cityfas highway mpg. The website, httpsiewsroom.aaa.com/auto[yourdrivingcosls[, also tells us the average annual maintenance cost and annual depreciation {amount the our loses in value each year). Parameters for how much you drive, the cost of the cars [15,000 highway and 7,500 city], and gas [$2.80 per gallon] have been entered. a.) Compute the number of gallons each car uses to travel 100 miles on the highway and 100 miles in the city. Format as a number to 2 decimal places. b.) Compute the number of gallons each tar uses to travel the miles given for highway and city. Format as a number to 1 decimal place. 1:.) Compute the total gallons used in a year for each car and the cost ofthe gas. IL} Compute the total gallons used in a year for each car and the cost of the gas. 11.] Compute the gas and maintenance savings peryear if you buy the Prius, and the extra costofbuying the Prius. e.) Determine the number o'Fyears it will take to recoup the extra cost of buying the Prius. Format as a number to 2 decimal places. f.] Given how long it takes to recoup the extra money, change the price of gas to determine at what minimum price the years to recoup will be under5 years (4.99 years]. Format as accounting. Does increasing the number of miles you drive increase or decrease the time to recoup