Home Insert Draw Page Layout Formulas Data Review View OV Calibri (Body) 11 A A %" 20 Paste BI U V Alignment Number D19 A fx B D 1 2 Scenario Analysis 3 Best Case Annual Miles 20,000 Percent City Price of Fuel 80% $ 3.00 4 Base Case 15,000 60% $ 2.50 5 Worst Case 10,000 40% $ 2.00 6 7 CFO C01 to C07 8 Best Case 9 Base Case 10 Worst Case 11 12 E F G Discount Rate 13 NPV IRR Payback Profitability Index 14 Best Case 1.1 15 Base Case 1.1 16 Worst Case 17 1.1 18 Sensitivity Analysis Change in NPV 19 Annual Miles -1000 20 Percent City -5% 21 Fuel Price-$1 22 23 24