Create table identifying the two complete cash flow streams

Assignment Help Financial Management

Reference no: EM131547810

D.J. AHOY has been very successful developing real estate in the market. The company has historically focused on the development of residential housing units. The CEO has recently become interested in commercial retail space and has identified a project that looks promising.

The retail space is for sale for $1,180,000. The land is valued at $210,000 and the building at $970,000. The building is currently leased to a quality tenant with a five-year lease at $51,000 per year. The building is located in an area that is becoming increasingly fashionable. The business broker you are working with expects that the property will be worth $1,700,000 in five years’ time (assume this sale 5 years from now).

The residential investments at D.J. AHOY are currently yielding a 13% return. You have been instructed to use a 13% rate of return in your analysis of this project. At the asking price, does an NPV analysis of this project indicate that it would be a good deal? What is the IRR on the development? The CEO is considering making an offer of $995,000. At this price would the property generate an IRR sufficient to meet D.J. AHOY’S return expectations?

You will present and explain your calculations comparing the $995,000 offer and the $1,180,000 asking, and your plan to the CEO. The CEO has also asked that you include the answers to the following questions in your analysis:

1. Prepare an Excel spreadsheet comparing the two options. Create a table identifying the two complete cash flow streams. Identify and show the present values of the benefits and the present values of the costs.

2. Without changing any of the cash flows, understanding this investment may be negotiated, what is the maximum amount D.J. AHOY should offer for this to remain beneficial? (compare this third amount in your Excel sheet)

3. Do NPV and IRR analysis always agree on whether a proposed investment creates value for the firm? What evidence do you have?

4. Are there other capital budgeting techniques that we might use to evaluate this project? What are the Pros and Cons of each?

Reference no: EM131547810

Questions Cloud

The spanish and french cultures : Discus how those differences manifest themselves in the treatment/interaction with the Native Americans they encountered.

The reverend hugh jones description of virginia slavery : In preparation for this discussion, read The Reverend Hugh Jones' description of Virginia slavery on page 231 in Kupperman.

Calculate the six ratios for both companies : Calculate the six ratios for both companies, clearly showing the ratio formula and figures - Discuss how this might be financed and any problems

In which colony would you prefer to live : Thinking about everything you have learned so far, if you were a slave during the 18th century, in which colony would you prefer to live?

Create table identifying the two complete cash flow streams : Prepare an Excel spreadsheet comparing the two options. Create a table identifying the two complete cash flow streams.

Discuss the phases of process improvement project : For this assignment select either your own organization (State Farm Insurance) or an organization about which you know enough to review the supply chain.

How to build teams in terms of designing the task : Think about how to build teams in terms of designing the task, selecting the people, and then, managing their relationships.

How has the status on women changed in the post 1945 world : How has the status on women changed in the post 1945 world? Discuss this issue in relation to at least two individual countries or regions.

Providing special events within an event : Examine what options you have in providing special events within an event. Show and explain the various potential special events.

User Account

All Pages