As a financial analyst, you must evaluate a proposed project to produce printer cartridges. The purchase price of the equipment, including installation, is $65,000, and the equipment will be fully depreciated at t = 0. Annual sales would be 4,000 units at a price of $50 per cartridge, and the project’s life would be 3 years. Current assets would increase by $5,000 and payables by $3,000. At the end of 3 years, the equipment could be sold for $10,000. Variable costs would be 70% of sales revenues, fixed costs would be $30,000 per year, the marginal tax rate is 25%, and the corporate WACC is 11%. The CFO asks you to do a scenario analysis using these inputs: Scenario Probability Unit Sales VC% Best case 25% 4,800 65% Base case 50 4,000 70 Worst case 25 3,200 75 Other variables are unchanged. What are the expected NPV, its standard deviation, and the coefficient of variation? (Hint: To do the scenario analysis, you must change unit sales and VC% to the values specified for each scenario, get the scenario cash flows, and then find each scenario’s NPV. Then you must calculate the project’s expected NPV, standard deviation (σ), and coefficient of variation (CV). NPV Best Case Scenario = $ . NPV Base Case Scenario = $ . NPV Worst-case Scenario = - $ . Expected NPV = $ Standard deviation of NPV = $ Coefficient of variation of NPV =
As a financial analyst, you must evaluate a proposed project to produce printer cartridges. The purchase price of the equipment, including installation, is $65,000, and the equipment will be fully
The CFO asks you to do a scenario analysis using these inputs:
Scenario | Probability | Unit Sales | VC% |
Best case | 25% | 4,800 | 65% |
Base case | 50 | 4,000 | 70 |
Worst case | 25 | 3,200 | 75 |
Other variables are unchanged.
What are the expected
- NPV Best Case Scenario = $ .
- NPV Base Case Scenario = $ .
- NPV Worst-case Scenario = - $ .
- Expected NPV = $
- Standard deviation of NPV = $
- Coefficient of variation of NPV =
Trending now
This is a popular solution!
Step by step
Solved in 2 steps