PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND WANT TO LEARN EXCEL INPUTS.

Problem 7-18 Abandonment We are examining a new project. We expect to sell 6,300 units per year at $57 net cash flow apiece for the next 10 years. In other words, the annual operating cash flow is projected to be $57 6,300 = $359,100. The relevant discount rate is 12 percent, and the initial investment required is $1,740,000. After the first year, the project can be dismantled and sold for $1,610,000. Suppose you think it is likely that expected sales will be revised upward to 9,300 units if the first year is a success and revised downward to 4,900 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.)

A. NPV

B. Option Value