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...

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 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. Thus in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value, and the project has not yet been abandoned. Also, after you abandon the project, the actual cash flows for future years will be 0. So the future cash flows after abandonment should disappear.)