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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

i need to find the NPV, IRR , Profitability Index and Change in NPV

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
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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education