Question: please show me how to complete this problem on excel We are examining a new project. We expect to sell 7,400 units per year at
We are examining a new project. We expect to sell 7,400 units per year at $59 net cash flow apiece for the next 10 years. In other words, the annual cash flow is projected to be $597,400=$436,600. The relevant discount rate is 14 percent, and the initial investment required is $1,900,000. After the first year, the project can be dismantled and sold for $1,100,000. Suppose you think it is likely that expected sales will be revised upward to 11,400 units if the first year is a success and revised downward to 3,500 units if the first year is not a success. a. If success and failure are equally likely, what is the NPV of the project? Consider the possibility of abandonment in answering. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the value of the option to abandon? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
