1. Recreate the Vehicle v. Hybrid problem in Excel: Sensitivity Analysis Breakeven Analysis Miles 9% change $14,000 Alteration Current 16 mpg 10974 8779 -20% 25% change in gas price Hybrid (16,000.00) 11684 6% 25% change in interest rate 30178 175% 25% reduction in current vehicle sell 26 mpg 10.0% 13843 26% 25% change in length of analysis MARR Hint: change (Original Miles New Miles)/Original Miles Gas S2.00 S/gal 5 Years 10974 mi/yr miles current S (5,200.00) hybrid S (5,200.00) PW S Difference 1. Recreate the Vehicle v. Hybrid problem in Excel: Sensitivity Analysis Breakeven Analysis Miles 9% change $14,000 Alteration Current 16 mpg 10974 8779 -20% 25% change in gas price Hybrid (16,000.00) 11684 6% 25% change in interest rate 30178 175% 25% reduction in current vehicle sell 26 mpg 10.0% 13843 26% 25% change in length of analysis MARR Hint: change (Original Miles New Miles)/Original Miles Gas S2.00 S/gal 5 Years 10974 mi/yr miles current S (5,200.00) hybrid S (5,200.00) PW S Difference