What is the mean net present value of the project

Assignment Help Financial Management

Reference no: EM131579430

The Aberdeen Development Corporation (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 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 distribution.

ADC 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 tears 2, 3, 4, and 5 is $700,000. Due to the great uncertainty, the estimate for the standard deviation of the annual operating profit in each year is also $700,000. Assume that the yearly profits are statistically independent and follow the normal distribution.

After year 5, ADC plans to sell the hotel. The selling price is likely to be somewhere between $4 and $8 million (assume a uniform distribution). ADC uses a 10 percent discount rate for calculating net present value. (For purposes of this calculation, assume that each year’s profits are received at year-end) Use RSPE to perform 1,000 trials of a computer simulation on this project on a spreadsheet.

a) What is the mean net present value (NPV) of the project? (Hint: The NPV (Rate, cash stream) function in Excel returns the NPV of stream of cash flows assumed to start one year from now.For example, NPV (10% C5:F5) returns the NPV at a 10% discount rate 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.Use RSPE to estimate the distribution 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?

Reference no: EM131579430

Questions Cloud

Theorem on augmenting path wuth edge set : In Theorem is it true that if there is an augmenting path P with edge set E(P) for a matching M, then M?E(P) is a larger matching than M?

Hiring a senior financial analyst : What are ethical pros and cons of using credit checks while hiring a Senior Financial Analyst?

Recommendations to improve the prioritizing process : Read the case titled: "Prioritizing Projects at D. D. Williamson" found in Chapter 2.

Determine which practices related to work attitudes in us : Determine which practices related to work attitudes in U.S. organizations are most strongly affected by diversity and suggest a strategy to address the effects.

What is the mean net present value of the project : What is the mean net present value (NPV) of the project? What is the estimated probability that the project will yield an NPV greater than $2 million?

Analyze the impact of organizational culture : Identify ways in which an effective change agent can build a change-friendly organizational culture.

Explain how the objectives support management success : Did the student proper explain how the objectives support management success and the risks/challenges that may arise is these objectives

Forefront of creating the demand : How do you think industries, especially technology industries, can position themselves to be responsive to consumer demand

Write and essay on recycling : Write and essay On recycling. Must include pros and cons of recycling. Must include cost to government and tax payers.

User Account

All Pages