Pick a vehicle that is offered as a hybrid and standard fuel model. You will collect the following data from FuelEconomy.gov 1. The price of both models 2. Gas mileage of both vehicles (Use the city, hwy or a weighted average based on your usage) 3. The mileage driven over the time (no less than 7 years and based on your usage) 4. The fuel savings (your forecast for the next 7 years) 5. A discount rate ( 4% is recommended) Determine the $ premium charged for the Hybrid option. Determine the $ savings generated through fuel savings. The hybrid will cost more but should save you money over time through fuel savings. Use the five measures above to evaluate the purchase of a hybrid. Complete a Scenario Analysis where your base case is your expected variables. The best case includes higher values that are the realistic high bounds that you might expect while the worst case includes lower values that may occur. \begin{tabular}{|l|l|l|} \hline 1 & & \\ \hline 2 & Scenario Analysis \\ \hline 3 & Best Case & \\ \hline 4 & Base Case & \\ \hline 5 & Worst Case & \\ \hline 6 & & \\ \hline 7 & CFO & CO1 to CO7 \\ \hline 8 & & \\ \hline 9 & & \\ \hline 10 & & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline Annual Milles & Percent City & Price of Fuel \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} 18 Sensitivity Analysis Change in NPV Annual Miles - 1000 Percent city - 5% Fuel Price-\$1 Hybrid Non-hybrid (1) 2022 Lexus RX 450h F Sport AWD 2022 Lexus RX 350 AWD F Sport 3.5L,6 cyl, Automatic (AV-S6), Premium 3.5 L, 6 cyl, Automatic (58), Regular Combined MPG 29 24 MSRP (i) The hybrid vehicle's MSRP is $1,400 more. Pick a vehicle that is offered as a hybrid and standard fuel model. You will collect the following data from FuelEconomy.gov 1. The price of both models 2. Gas mileage of both vehicles (Use the city, hwy or a weighted average based on your usage) 3. The mileage driven over the time (no less than 7 years and based on your usage) 4. The fuel savings (your forecast for the next 7 years) 5. A discount rate ( 4% is recommended) Determine the $ premium charged for the Hybrid option. Determine the $ savings generated through fuel savings. The hybrid will cost more but should save you money over time through fuel savings. Use the five measures above to evaluate the purchase of a hybrid. Complete a Scenario Analysis where your base case is your expected variables. The best case includes higher values that are the realistic high bounds that you might expect while the worst case includes lower values that may occur. \begin{tabular}{|l|l|l|} \hline 1 & & \\ \hline 2 & Scenario Analysis \\ \hline 3 & Best Case & \\ \hline 4 & Base Case & \\ \hline 5 & Worst Case & \\ \hline 6 & & \\ \hline 7 & CFO & CO1 to CO7 \\ \hline 8 & & \\ \hline 9 & & \\ \hline 10 & & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline Annual Milles & Percent City & Price of Fuel \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} 18 Sensitivity Analysis Change in NPV Annual Miles - 1000 Percent city - 5% Fuel Price-\$1 Hybrid Non-hybrid (1) 2022 Lexus RX 450h F Sport AWD 2022 Lexus RX 350 AWD F Sport 3.5L,6 cyl, Automatic (AV-S6), Premium 3.5 L, 6 cyl, Automatic (58), Regular Combined MPG 29 24 MSRP (i) The hybrid vehicle's MSRP is $1,400 more