What year should the investor be pulling out of the market

Assignment Help Supply Chain Management
Reference no: EM13835827

You are a real estate investor trending the general direction of real estate prices for your client, a real estate developer.You have obtained data on housing prices, inflation, and total historical sales from the Case-Shiller Housing Prices 2000 through 2014, and inflation and related data from the U.S. Department of Labor Statistics, the U.S. Census, and the U.S. Department of Commerce.You have built a subsequent table below:

 

Year

Sold (Thousands)

Inflation

Nominal Price $USD

Real Price $ USD

Household Income $USD

2000

877

3.4%

138,914

188,925

41,990

2001

908

2.8%

148,197

197,958

42,228

2002

973

1.6%

162,358

212,504

42,409

2003

1,086

2.3%

178,294

228,409

43,318

2004

1,203

2.7%

202,619

251,203

44,344

2005

1,283

3.4%

229,996

275,321

46,326

2006

1,051

3.2%

233,992

274,665

48,201

2007

776

2.9%

221,389

249,636

50,233

2008

485

3.9%

194,855

216,999

50,303

2009

375

-0.3%

187,347

204,846

49,777

2010

323

1.6%

179,956

193,867

49,276

2011

306

3.2%

172,647

180,163

50,054

2012

368

2.1%

183,836

188,325

51,097

2013

429

1.5%

203,615

206,060

51,939

2014

438

0.8%

212,400

212,400

51,850

2015

 

 

 

 

 

2016

 

 

 

 

 

2017

 

 

 

 

 

2018

 

 

 

 

 

2019

 

 

 

 

 

 

Based on the information, you wish to determine the best time for your investor to begin investing again in new housing developments. Use Monte Carlo simulation to generate a series of scenarios for your client including the following:

 

1. Using a flat inflation of 3%, with the probability of 85% that incomes will not grow more than 3%, find the year that is best for the investor to begin new home construction.

2. If incomes remain flat (within 3% of 2014 figure), and inflation grows at 2.5% annually, what year should the investor be pulling out of the market in the 5 years noted?

3. Based on the data shown, what would be the expected number of housing units sold for the 5-year period with a uniform inflation rate of 3%?You can use either Monte Carlo or Crystal Ball for this portion of the response.

4. Using your simulation, graphically show the answers to the three questions above.Please show scenarios to compare for your investor, and briefly describe why you used the choice of simulation (Monte Carlo or Crystal Ball).

5. For the 5-year period that the simulation is intended to model, is investing in real estate a good idea, or should the investor seek other opportunities?Assume you are seeking a 5% return annually on the investment.Support your answer strictly based on your responses to questions 1-4 above.

6. Name the next likely sensitivity quantity that would provide you with a better result for your client, and explain why.

Reference no: EM13835827

Questions Cloud

Discuss the kpivs and kpovs for this business : An important part of a project is to identify the key process input variables ( KPIV) and key process output variables ( KPOV). Suppose that you are the owner/ manager of a small business that provides mailboxes, copy services, and mailing services. ..
What type of system was selected for network administrator : What type of system was selected for your computer administrator. What type of system was selected for your network administrator. What type of system was selected for yourself, as business manager
Created a demand for mobile or cloud computing : What changes in technology have created a demand for mobile or cloud computing within the industry you have chosen
Write down the set p : Write a closed form expression terms of n and simplify your expression - Write down the set P
What year should the investor be pulling out of the market : Using a flat inflation of 3%, with the probability of 85% that incomes will not grow more than 3%, find the year that is best for the investor to begin new home construction. If incomes remain flat (within 3% of 2014 figure), and inflation grows at 2..
What lessons nasa had learned from the challenger disaster : Determine what lessons NASA had or had not learned from the Challenger Disaster; changes they had implemented prior to the Columbia Disaster and discuss the appropriateness of those decisions.
Create a product for a market that already exists : Check out your potential competitors by visiting their sites and taking note of what they are doing to fill the demand. Then you can use what you have learned and create a product for a market that already exists - and do it better than the compe..
What is the relationship if any between these trends : Mass customisation and rapid product development were identified as current trends in modern manufacturing operations. What is the relationship, if any, between these trends? Can you cite any examples?
Write a report about developing country of your choice : Write a research report about developing country or related countries of your choice and discuss the cultural challenges that influence multinational operations - you should focus on both national and business culture.

Reviews

Write a Review

Supply Chain Management Questions & Answers

  Analyse how continuous process flow

LEAN THINKING Analyse how continuous process flow can help an organisation to reveal waste. What advantages do lean organisations hold over traditional organisations in terms of creating value for customers?

  Aggregate planning for a bottling company

Which production strategy should the production managers choose based on a total cost minimisation objective and what information about this aggregate plan should be shared with various supply chain partners and why?

  The organization''s supply chain characteristics

The organization's supply chain characteristics - type of supply chain, negotiations strategies, performance of the supply chain, and areas for improvement.

  What are three different types of e-business customers

What are three different types of e-business customers? How would your business strategy change depending on the type of customer you have

  What are the various systems in supply chain management

What are the various systems in supply chain management to reduce costs, speed delivery and boost productivity? Give 3-5 detailed examples.

  Advantages of a new e-procurement system

What are the barriers in perceived advantages of a new e-procurement system by the employees in an organization? How these risks could be mitigated?

  Importance of leadership in bringing about necessary changes

Assess importance of leadership in bringing about the necessary changes at Porsche. Describe answer with examples.

  Explain the thinking behind quick response logistics

Explain the thinking behind quick response (QR) logistics. How could QR help a retailer to plan and control product lines for a new fashion season? Document your sources.

  Adoption of trade promotion synergies

What is your opinion on the adoption of trade promotion synergies amongst companies in the same industry? Wordcount should be 300 Harvard referencing/citation and a minimum of three

  Excellent communication between customers and suppliers

Meeting the customer requirements (Oakland 2003) is a reasonable definition of quality and customer satisfaction means we can wrap up our projects more rapidly (Frame 2002, quoted in Reid 2013a)

  Discuss the marketing and supply chain risks

Describe at least two strategies that a firm can use to overcome the challenges associated with transportation infrastructure congestion and why does customer service not increase proportionately to increases in total cost when a logistical system i..

  Calculate the total cost using a one-month planning

Calculate the total cost using a one-month planning horizon and calculate the total cost using a three-month planning horizon.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd