The Aberdeen Development Corporation (ADC) is reconsidering the Aberdeen Resort Hotel project. It would be located on

Question:

The Aberdeen Development (ADC) is reconsidering the Aberdeen Resort Hotel project. It would be located on the picturesque banks of Grays Harbor and have its own championship-level golf course.
The cost to purchase the land would be $1 million, payable now. Construction costs would be approximately $2 million, payable at the end of the year 1. However, the construction costs are uncertain. These costs could be up to 20 percent higher or lower than the estimate of $2 million. Assume that the construction costs would follow a triangular is very uncertain about the annual operating profits (or losses) that would be generated once the hotel is constructed. Its best estimate for the annual operating profit that would be generated in years 2, 3, 4, and 5 is $700,000. Due to the great uncertainty, the estimate of the standard deviation of the annual operating profit in each year also is $700,00. Assume that the yearly profits are statistically independent and follow the normal year 5, ADC plans to sell the hotel. The selling price is likely to be somewhere between $4 and $8 million (assume a uniform ADC uses a 10 percent for calculating . (For purposes of this calculation, assume that each year’s profits are received at year end.) Use ASPE to perform 1,000 trials of a simulation of this project on a spreadsheet.
(a) What is the mean (NPV) of the project? (Hint: The NPV(rate, cash stream) function in Excel returns the NPV of a stream of cash flows assumed to start one year from now. For example, NPV(10%, C5:F5) returns the NPV at a 10 percent when C5 is a cash flow at the end of year 1, D5 at the end of year 2, E5 at the end of year 3, and F5 at the end of year 4.)
(b) What is the estimated probability that the project will yield an NPV greater than $2 million?
(c) ADC also is concerned about cash flow in years 2, 3, 4, and 5. Generate a forecast of the of the minimum annual operating profit (undiscounted) earned in any of the four years. What is the mean value of the minimum annual operating profit over the four years?
(d) What is the probability that the annual operating profit will be at least $0 in all four years of operation?
Net Present Value
What is NPV? The net present value is an important tool for capital budgeting decision to assess that an investment in a project is worthwhile or not? The net present value of a project is calculated before taking up the investment decision at... Corporation
A Corporation is a legal form of business that is separate from its owner. In other words, a corporation is a business or organization formed by a group of people, and its right and liabilities separate from those of the individuals involved. It may... Discount Rate
Depending upon the context, the discount rate has two different definitions and usages. First, the discount rate refers to the interest rate charged to the commercial banks and other financial institutions for the loans they take from the Federal... Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...