Scenario Analysis Annual Miles Percent City Price of Fuel Best Case 20,000 80% $ 3.00 Base Case 15,000 60% $ 2.50 Worst Case 10,000 40% $ 2.00 CFO C01 to C07 Best Case Base Case Worst Case SSS $ 700 $ 990 $ 700 $ 521 $ 700 $ 226 Discount Rate 35.0% NPV IRR Payback Profitability Index Best Case $ 45.32 1550.0% 1.1 1.18 Base Case 1.1 Worst Case 1.1 Sensitivity Analysis Change in NPV Annual Miles -1000 Percent City -5% Fuel Price-$1
Scenario Analysis Annual Miles Percent City Price of Fuel Best Case 20,000 80% $ 3.00 Base Case 15,000 60% $ 2.50 Worst Case 10,000 40% $ 2.00 CFO C01 to C07 Best Case Base Case Worst Case SSS $ 700 $ 990 $ 700 $ 521 $ 700 $ 226 Discount Rate 35.0% NPV IRR Payback Profitability Index Best Case $ 45.32 1550.0% 1.1 1.18 Base Case 1.1 Worst Case 1.1 Sensitivity Analysis Change in NPV Annual Miles -1000 Percent City -5% Fuel Price-$1
Scenario Analysis Annual Miles Percent City Price of Fuel Best Case 20,000 80% $ 3.00 Base Case 15,000 60% $ 2.50 Worst Case 10,000 40% $ 2.00 CFO C01 to C07 Best Case Base Case Worst Case SSS $ 700 $ 990 $ 700 $ 521 $ 700 $ 226 Discount Rate 35.0% NPV IRR Payback Profitability Index Best Case $ 45.32 1550.0% 1.1 1.18 Base Case 1.1 Worst Case 1.1 Sensitivity Analysis Change in NPV Annual Miles -1000 Percent City -5% Fuel Price-$1
i need to find the NPV, IRR , Profitability Index and Change in NPV
Transcribed Image Text:Scenario Analysis
Annual Miles
Percent City
Price of Fuel
Best Case
20,000
80% $
3.00
Base Case
15,000
60% $
2.50
Worst Case
10,000
40% $
2.00
CFO
C01 to C07
Best Case
Base Case
Worst Case
SSS
$
700 $
990
$
700 $
521
$
700 $
226
Discount Rate
35.0%
NPV
IRR
Payback
Profitability Index
Best Case
$
45.32
1550.0%
1.1
1.18
Base Case
1.1
Worst Case
1.1
Sensitivity Analysis
Change in NPV
Annual Miles -1000
Percent City -5%
Fuel Price-$1
Definition Definition Discount rate of a project wherein its net present value equals zero. Internal rate of return equates the present value of future cash flows with the initial investments. Internal rate of return helps to determine nominal cash flows.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
