You are considering a 10-year investment project. At present, the expected cash flow each year is $1000.

Suppose, however, that each year’s cash flow is normally distributed with mean equal to last year’s actual cash flow and standard deviation $100. For example, suppose that the actual cash flow in year 1 is $1200.

Then year 2 cash flow is normal with mean $1200 and standard deviation $100. Also, at the end of year 1, your best guess is that each later year’s expected cash flow will be $1200.

a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year.

b. Now assume that the project has an abandonment option. At the end of each year, you can abandon the project for the value given in the file P12_51.xlsx. For example, suppose that year 1 cash flow is $400. Then at the end of year 1, you expect cash flow for each remaining year to be $400. This has an NPV of less than $6200, so you should abandon the project and collect $6200 at the end of year