Question

In: Statistics and Probability

Exploratory analysis: green buildings The case Over the past decade, both investors and the general public...

Exploratory analysis: green buildings

The case

Over the past decade, both investors and the general public have paid increasingly close attention to the benefits of environmentally conscious buildings. There are both ethical and economic forces at work here. In commercial real estate, issues of eco-friendliness are intimately tied up with ordinary decisions about how to allocate capital. In this context, the decision to invest in eco-friendly buildings could pay off in at least four ways.

Every building has the obvious list of recurring costs: water, climate control, lighting, waste disposal, and so forth. Almost by definition, these costs are lower in green buildings.

Green buildings are often associated with better indoor environments—the kind that are full of sunlight, natural materials, and various other humane touches. Such environments, in turn, might result in higher employee productivity and lower absenteeism, and might therefore be more coveted by potential tenants. The financial impact of this factor, however, is rather hard to quantify ex ante; you cannot simply ask an engineer in the same way that you could ask a question such as, “How much are these solar panels likely to save on the power bill?”

Green buildings make for good PR. They send a signal about social responsibility and ecological awareness, and might therefore command a premium from potential tenants who want their customers to associate them with these values. It is widely believed that a good corporate image may enable a firm to charge premium prices, to hire better talent, and to attract socially conscious investors.

Finally, sustainable buildings might have longer economically valuable lives. For one thing, they are expected to last longer, in a direct physical sense. (One of the core concepts of the green-building movement is “life-cycle analysis,” which accounts for the high front-end environmental impact of ac- quiring materials and constructing a new building in the first place.) Moreover, green buildings may also be less susceptible to market risk—in particular, the risk that energy prices will spike, driving away tenants into the arms of bolder, greener investors.

Of course, much of this is mere conjecture. At the end of the day, tenants may or may not be willing to pay a premium for rental space in green buildings. We can only find out by carefully examining data on the commercial real-estate market.

The file greenbuildings.csv contains data on 7,894 commercial rental properties from across the United States. Of these, 685 properties have been awarded either LEED or EnergyStar certification as a green building. You can easily find out more about these rating systems on the web, e.g. at www.usgbc.org. The basic idea is that a commercial property can receive a green certification if its energy efficiency, carbon footprint, site selection, and building materials meet certain environmental benchmarks, as certified by outside engineers.

A group of real estate economists constructed the data in the following way. Of the 1,360 green-certified buildings listed as of December 2007 on the LEED or EnergyStar websites, current information about building characteristics and monthly rents were available for 685 of them. In order to provide a control population, each of these 685 buildings was matched to a cluster of nearby commercial buildings in the CoStar database. Each small cluster contains one green-certified building, and all non-rated buildings within a quarter-mile radius of the certified building. On average, each of the 685 clusters contains roughly 12 buildings, for a total of 7,894 data points.

The columns of the data set are coded as follows:

CS.PropertyID: the building's unique identifier in the CoStar database.

cluster: an identifier for the building cluster, with each cluster containing one green-certified building and at least one other non-green-certified building within a quarter-mile radius of the cluster center.

size: the total square footage of available rental space in the building.

empl.gr: the year-on-year growth rate in employment in the building's geographic region.

Rent: the rent charged to tenants in the building, in dollars per square foot per calendar year.

leasing.rate: a measure of occupancy; the fraction of the building's available space currently under lease.

stories: the height of the building in stories.

age: the age of the building in years.

renovated: whether the building has undergone substantial renovations during its lifetime.

class.a, class.b: indicators for two classes of building quality (the third is Class C). These are relative classifications within a specific market. Class A buildings are generally the highest-quality properties in a given market. Class B buildings are a notch down, but still of reasonable quality. Class C buildings are the least desirable properties in a given market.

green.rating: an indicator for whether the building is either LEED- or EnergyStar-certified.

LEED, Energystar: indicators for the two specific kinds of green certifications.

net: an indicator as to whether the rent is quoted on a ``net contract'' basis. Tenants with net-rental contracts pay their own utility costs, which are otherwise included in the quoted rental price.

amenities: an indicator of whether at least one of the following amenities is available on-site: bank, convenience store, dry cleaner, restaurant, retail shops, fitness center.

cd.total.07: number of cooling degree days in the building's region in 2007. A degree day is a measure of demand for energy; higher values mean greater demand. Cooling degree days are measured relative to a baseline outdoor temperature, below which a building needs no cooling.

hd.total07: number of heating degree days in the building's region in 2007. Heating degree days are also measured relative to a baseline outdoor temperature, above which a building needs no heating.

total.dd.07: the total number of degree days (either heating or cooling) in the building's region in 2007.

Precipitation: annual precipitation in inches in the building's geographic region.

Gas.Costs: a measure of how much natural gas costs in the building's geographic region.

Electricity.Costs: a measure of how much electricity costs in the building's geographic region.

cluster.rent: a measure of average rent per square-foot per calendar year in the building's local market.

The assignment

An Austin real-estate developer is interested in the possible economic impact of "going green" in her latest project: a new 15-story mixed-use building on East Cesar Chavez, just across I-35 from downtown. Will investing in a green building be worth it, from an economic perspective? The baseline construction costs are $100 million, with a 5% expected premium for green certification.

The developer has had someone on her staff, who's been described to her as a "total Excel guru from his undergrad statistics course," run some numbers on this data set and make a preliminary recommendation. Here's how this person described his process.

I began by cleaning the data a little bit. In particular, I noticed that a handful of the buildings in the data set had very low occupancy rates (less than 10% of available space occupied). I decided to remove these buildings from consideration, on the theory that these buildings might have something weird going on with them, and could potentially distort the analysis. Once I scrubbed these low-occupancy buildings from the data set, I looked at the green buildings and non-green buildings separately. The median market rent in the non-green buildings was $25 per square foot per year, while the median market rent in the green buildings was $27.60 per square foot per year: about $2.60 more per square foot. (I used the median rather than the mean, because there were still some outliers in the data, and the median is a lot more robust to outliers.) Because our building would be 250,000 square feet, this would translate into an additional $250000 x 2.6 = $650000 of extra revenue per year if we build the green building.

Our expected baseline construction costs are $100 million, with a 5% expected premium for green certification. Thus we should expect to spend an extra $5 million on the green building. Based on the extra revenue we would make, we would recuperate these costs in $5000000/650000 = 7.7 years. Even if our occupancy rate were only 90%, we would still recuperate the costs in a little over 8 years. Thus from year 9 onwards, we would be making an extra $650,000 per year in profit. Since the building will be earning rents for 30 years or more, it seems like a good financial move to build the green building.

The developer listened to this recommendation, understood the analysis, and still felt unconvinced. She has therefore asked you to revisit the report, so that she can get a second opinion.

Do you agree with the conclusions of her on-staff stats guru? If so, point to evidence supporting his case. If not, explain specifically where and why the analysis goes wrong, and how it can be improved. (For example, do you see the possibility of confounding variables for the relationship between rent and green status?)

Note: this is intended mainly as an exercise in visual and numerical story-telling. Tell your story primarily in plots, and while you can run a regression model if you want, that's not the goal here. Keep it concise.

Solutions

Expert Solution

The analysis can be expected to work perfectly well if the non-rated buildings clustured with the green certified buildings are not very different from the green ones on other exploratory variables.

Picking up the building within a square mile of the green certified buildings can take care of some of the variables like employment growth, precipitation and most likely the gas and electricity costs. But variables like area, class of building and age need to be considered for the comparison of green certified and non-rated buildings as these can vary greatly within a geographical area.

The analysis can certainly be improved to get a more reliable comparison by including building quality variables along with the geographical location.

For example comparing the median rent for green buildings to the rent for non-rated buildings within certain area and having the same no. of stories, age and class of the building can give a better evidence supporting the investment in green-certified buildings.


Related Solutions

One of the most​ impressive, innovative advances in online fundraising over the past decade is the...
One of the most​ impressive, innovative advances in online fundraising over the past decade is the rise of​ crowd-funding websites. While features differ from site to​ site, crowd-funding sites are websites that allow you to set up an online fundraising campaign based around a fundraising​ page, and accept money directly from that page using the​ website's own credit card processor. A certain​ crowd-funding website reported that 127 of 347 technology​ crowd-funding projects were successfully launched in the past year and...
One of the most​ impressive, innovative advances in online fundraising over the past decade is the...
One of the most​ impressive, innovative advances in online fundraising over the past decade is the rise of​ crowd-funding websites. While features differ from site to​ site, crowd-funding sites are websites that allow you to set up an online fundraising campaign based around a fundraising​ page, and accept money directly from that page using the​ website's own credit card processor. A certain​ crowd-funding website reported that 127 of 347 technology​ crowd-funding projects were successfully launched in the past year and...
The rate of entrepreneurship has been growing steadily in the United States over the past decade....
The rate of entrepreneurship has been growing steadily in the United States over the past decade. The reasons behind this increase are varied. Most of the people starting a business seek a combination of greater financial success, independence, flexibility, and challenge. Owning a business holds appealing benefits for entrepreneurs like being their own boss, having control over their schedule, and facing new challenges. Almost every entrepreneur starts out as a small businessperson but not every small businessperson starts out as...
Over the past decade, the federal government has taken significant steps to encourage the development of...
Over the past decade, the federal government has taken significant steps to encourage the development of ethanol and other fuels made from plants as a partial replacement for gasoline. These actions have been undertaken by politicians in the midst of public concerns about the dependence on foreign oil, war in the Middle East, and global warming. The primary input for ethanol production is corn. In 2011, the 13.9 billion gallons of ethanol produced in the United States consumed over 20...
The healthcare industry is ever changing, but over the past decade, it has changed even more...
The healthcare industry is ever changing, but over the past decade, it has changed even more rapidly than we could have ever imagined, especially over the last few months.   Based on this, fill in the blanks in the grid, and summarize a minimum of two changes per category, discussing what changes have taken and may take place in the world and health care for the defined timeline. What changes have taken place (2015 through today) Speculate on possible future changes...
Some financial analysts claim that the rise of the US stock market over the past decade...
Some financial analysts claim that the rise of the US stock market over the past decade is largely due to the repurchase of common stocks by big corporations using debt financing, such as Boeing and Intel. Is this claim valid? Explain carefully. In your explanation, explain under what circumstances this assessment would be valid, and state and explain the important assumptions in your arguments. (15 pts)
Marketing research over the internet has increased significantly in the past decade. Outline the strengths and...
Marketing research over the internet has increased significantly in the past decade. Outline the strengths and weaknesses of marketing research conducted online
Personal Finance and New Technologies Over the past decade, financial technology — widely referred to as...
Personal Finance and New Technologies Over the past decade, financial technology — widely referred to as FinTech — has grown primarily due to growing Internet access worldwide and the emergence of smartphones and apps. Saudi Arabia is a pioneer when it comes to technology penetration in the region. The usage of technology in Saudi Arabia is advanced, whether in retail banking, cash management or corporate. Using financial technology improves the quality of the banking experience among clients. It influences the...
Which external condition has experienced the most rapid change over the past​ decade?
Which external condition has experienced the most rapid change over the past​ decade?
Question 2: Many dairy farms have experienced bankruptcy over the past decade as a result of...
Question 2: Many dairy farms have experienced bankruptcy over the past decade as a result of wild fluctuation in conventional milk prices. However, organic farms, those that do not treat cows with antibiotics or hormones and use only hay grown without chemicals, have remained solvent and expanded. In a random sample of 1400 New England dairy farms, 90 are certified as organic. a. Find a 88.58% confidence interval for the true proportion of the organic farms in New England. b....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT