What is the most common housing pricing strategy

Assignment Help Other Subject
Reference no: EM131444745

Q1. The tab labeled "Problem 1" includes monthly price data on the S&P 500 (SPY) as well as on KB Home (KBH, a real estate development company) and on Camden Property Trust (CPT, an equity REIT specializes in apartment rentals). Using regression, calculate the Beta of each of these two real estate related companies for the full time period provided to you.

a. Display your calculated Betas in the cells highlighted in yellow. You may include your full regression results in two other separate tabs.

b. Which firm has a higher Beta? In one to two sentences explain why you did or didn't expect that firm to be associated with a higher Beta.

Q2. The tab labeled "Data" includes data on recent single family sales in Palm Beach County, FL. Using the data provided, follow the instructions and answer the questions listed below:

Filter and copy into the tab labeled "Filtered Data" the observations that meet the following criteria:

  • Only properties with SqFtLA (SQFT living area) of 1,500 to 4,000.
  • Only properties located in Boca (Boca Raton) or Delray
  • Only properties with reasonable Sale Price, number of bedrooms, full bathrooms and half bathrooms (#Beds, #FB and #HB). Please filter out all properties for which the #HB cell is blank.

In the same tab (Filtered Data) create the following variables.

  • Baths - A variable that combines #FB and #HB into the total number of bathrooms. For example, a property with 2 full baths and 1 half baths would be converted into 2.5 baths.
  • Age - A variable that uses the closing date (CD) and the year built (Yr Blt) in order to determine how old the property was (in years) when it was sold.
  • PoolDum - A pool dummy variable that is set to 1 if the property has a pool (Pool? is Y) and 0 otherwise.
  • BocaDum - A location dummy variable that is set to 1 if the property is located in Boca (CITY is BOCA) and 0 otherwise.
  • LnPrice - A variable that includes the natural log of the Sale Price.
  • Lnsqft - A variable that includes the natural log of SqFt LA.

Run the following two regressions and answer the questions below within the yellow cells included in the "Problem 2" tab:

(1) SalePrice = α + β1SqFtLA + β2#Beds + β3Baths + β4Age + β5Pool + β6Boca

(2) LnPrice = α + β1Lnsqft + β2#Beds + β3Baths + β4Age + β5Pool + β6Boca

a. What is the R^2 of regression (1) and regression (2)?

b. Why do you think that the R^2 on these regressions is lower than the R^2 of the examples we used in class? Is there a particular variable or factor that you think would increase the R^2 in a material way? Briefly explain.

c. On average, by how much (in dollars) one square foot would increase or decrease the property selling price?

d. On average, by how much (in percentage) a pool would increase or decrease the property selling price?

e. On average, by how much (in percentage) a property in Boca would sell in comparison to a property in Delray?

f. Is the coefficient of Age positive or negative? Briefly explain the reason behind this positive or negative coefficient.

Q3. Please refer to the paper titled "The Effect of Listing Price Strategy on Transaction Selling Prices" (file name "Beracha Seiler_JREFE 2013.pdf" under Meeting 2 on BlackBoard) and answer the following questions:

a. According to Table 2, what is the most common housing pricing strategy employed in the market? What is the second most common pricing strategy?

b. If every property would be marketed exactly at the price that equals its value, what would be the percentage associated with the "Thousands digit" 7 in Table 2? Briefly explain why.

c. According to Table 3, which housing price strategy is associated with the smaller price discount? Is this expected? Briefly explain why.

d. Briefly explain the main point that we can learn from the regression results presented in column (4) of Table 6.

e. Do the results presented in Table 6 conflict with the results presented in Table 3? Briefly explain.

Q4. Assume that you have a dataset that includes the following variables on each commercial real estate transaction that took place during the 2010-2016 time period in Omaha, NE and in Minneapolis, MN (yes, they do have commercial real estate in these cities.....)

- YR - The year the transaction took place.

- Price - The price associated with the transaction.

- SQFT - The size of the property transacted in sqft.

- Income - The total annual rent collected during the year before the transaction.

- Class - A value between 1 and 3 denoting the property class, where 1, 2 and 3 represent classes A, B, and C, respectively.

- Location - A value of 0 or 1 denoting the property location, where 0 and 1 represent Omaha and Minneapolis, respectively.

Assume that the following regression equation was applied on the data and answers the questions below:

Price = α + β1SQFT + β2YR + β3Income + β4Class + β5Lacation

a. The coefficient β3 is positive and statistically significant. Is that expected? In one sentence explain why.

b. The coefficient β2 is positive and statistically significant. Is that expected? In one sentence explain why.

c. Would you expect the β4 coefficient to be positive or negative? Would you expect it to be statistically significant? In one sentence explain why.

d. Would you expect the β5 coefficient to be positive or negative? Would you expect it to be statistically significant? In one sentence explain why.

e. The coefficient β1 is negative and statistically insignificant. Does it make sense? In one sentence explain why.

Q5. Referring to problem 4, if you could get any information you want about each property:

a. In a similar way to how the variables are defined in problem 4, define two other variables that you would have liked to have included in your regression in order to increase the estimation power of the regression.

b. For each of the variables you defined in part a, briefly explain the sign you would expect (negative, positive or ambiguous) from the coefficient of each of these variables.

Attachment:- Assignment Data.rar

Reference no: EM131444745

Questions Cloud

Factors that impact the management of a collegiate : Evaluation of three factors that impact the management of a collegiate, professional, and Olympic organization/institution- Comparison of the factors that impact the various organizations at the different levels of sports.
Define the law of iterated expectations : Suppose that ut follows the ARCH process.
Estimate chances to earn at least : We toss an unfair coin 100 times in a row. We play according to following rules: If tail: +$1 If head: -$1.45 P(head=0.4) Estimate chances to earn at least $3 at the end of this experiment.
Creating forensic system case file for analyzing evidence : Creating a Forensic System Case File for Analyzing Forensic Evidence - Create a new digital forensic case file using a forensic application and Document a new digital forensic case with digital evidence submitted to the newly created case file.
What is the most common housing pricing strategy : REE 6147 - Spring 2017 Course Exam. According to Table 2, what is the most common housing pricing strategy employed in the market? What is the second most common pricing strategy
Presidential candidates are popular in area : Suppose you are designing and conducting a poll to see which of the presidential candidates are popular in your area.
Evaluate the organizations productivity : In the Middleboro Physician Care Services, Inc. case, you are asked to examine the operations of an ambulatory, non-emergent care clinic which treats private and occupational health patients and provides services which do not include continuing o..
Provide a mechanism for repeating a block of code : CPS 150- Loops provide a mechanism for repeating a block of code called the loop body. We begin this lab by experimenting with while loops, the simplest form of loop code.
What is the cointegrating coefficient : One version of the expectations theory of the term structure of interest rates holds that a long-term rate equals the average of the expected values of short-term interest rates into the future, plus a term premium that is 1(0).

Reviews

len1444745

3/30/2017 3:19:56 AM

To complete this final examination you will need to answer the 5 questions listed below. The first two questions are to be answered in Excel using the associated tabs included in the “Final exam - REE6147 – Spring 17” file that is provided to you. Questions 3-5 are to be answered on a Word document in the order in which they appear. This final exam is due on or before 11:55 p.m. EST. By that time you should submit an electronic copy (via Blackboard) of your assignment. If you turn your assignment late, 10% will be deducted from your grade for every calendar-day delay. All the work on this final exam must be 100% your own work. You are not allowed to discuss the exam with any of your classmates or any other person prior to the deadline. A failing grade in the course will automatically be assigned to a student that helps or seeks help from another person while working on the exam. You are allowed, however, to use the textbook, classroom notes, review lectures and use any “non-interactive” websites while working on the exam.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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