Net Present Value Under Base Case and Alternative Case
Not what you're looking for?
Scenario Analysis: Estimated Cash Flows for the Segway People Mover
BaseCase Year0 Year1-12 BicycleScenario Year0 Year1-12
Investment -5400 Investment -5400
Sales 16000 Sales
Variable Costs 13000 Variable Costs
Fixed Costs 2000 Fixed Costs
Depreciation 450 Depreciation
Pretax profit 550 Pretax profit
Taxes @40% 220 Taxes @40%
Profit after tax 330 Profit after tax
Operating cash flow 780 Operating cash flow
Net cash flow -5400 780 Net cash flow -5400
NPV(OCCof 9%): $185.37 NPV(OCCof 9%): --
Consider the scenario in which a competing form of transportation, the bicycle, causes sales to drop to 90% of expected sales from the base case.
a. Fill in the table on the right, including NPV
b. What is maximum opportunity cost of capital in both the Base Case and the Bicycle Scenario such that you should undertake the Segway People Mover Project?
In excel format.
Purchase this Solution
Solution Summary
This solution illustrates how to adjust revenues and expenses for alternative scenarios and how to compute the project's net present value under its base case and alternative scenario. It also illustrates how to compute the maximum opportunity cost of capital at which the company should undertake the project. All computations are done in Excel with Excel functions.
Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Introduction to Finance
This quiz test introductory finance topics.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.