Question: Please show answers in excel for practice Check my work 4 We are examining a new project. We expect to sell 5,600 units per year

Please show answers in excel for practice Check my work 4 WePlease show answers in excel for practice

Check my work 4 We are examining a new project. We expect to sell 5,600 units per year at $70 net cash flow apiece for the next 10 years. In other words, the annual operating cash flow is projected to be $70 x 5,600 = $392,000 The relevant discount rate is 13 percent, and the initial investment required is $1,550,000. After the first year, the project can be dismantled and sold for $1,270,000. Suppose you think it is likely that expected sales will be revised upward to 8,600 units if the first year is a success and revised downward to 4,200 units if the first year is not a success. 2 points a. If success and failure are equally likely, what is the NPV of the project? Consider the possibility of abandonment in answering. (Do eBooknot round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Print NPV $ References 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) Option value $

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!