Market Analysis. Presented by: Chris Macke, Senior Strategist, Americas Research

Market Analysis Presented by: Chris Macke, Senior Strategist, Americas Research November 27, 2012 Agenda I. Why Do Market Analysis II. Key Market...
Author: Aron Simmons
1 downloads 0 Views 1MB Size
Market Analysis Presented by: Chris Macke, Senior Strategist, Americas Research

November 27, 2012

Agenda I.

Why Do Market Analysis

II. Key Market Analysis Assumptions/Questions III. Applications Example – Market Supply/Demand for Inland Empire Industrial Acquisition IV. Market Analysis Drives The Property Pro Forma Example – 2008 Office Offering Memorandum

CBRE | Page 2

I. Why Do Market Analysis? • Owner/Investor reason #1 NOI’s (Fundamentals)

Value Cap Rates (Capital Markets)

CBRE | Page 3

I. Why Do Market Analysis? • Owner/Investor reason #2 NOI’s (Fundamentals)

Yield Value/ Purchase Price

CBRE | Page 4

II. Key Market Analysis Assumptions/Questions • Timeframe • Geography • Variables How determine?

Source: University of Chicago, Booth School of Business and Dr. Glenn Mueller CBRE | Page 5

II. Key Market Analysis Assumptions/Questions What question are you trying to answer? • Should I give the prospect 3 months free rent requesting? • Should I open a store in this submarket or that submarket? • How many units should I build this year? • When will I need to widen that ride? • What price should I pay for that building?

Source: University of Chicago, Booth School of Business and Dr. Glenn Mueller CBRE | Page 6

III. Application Where and what do I invest in?

“I’m starting to hear multifamily is overheating”

“Tech and energy markets are the only places to be”

“Nobody gets fired for buying multifamily”

“Is it safe to buy in Southern California?”

CBRE | Page 7

“Blackstone is buying Midwest office,”

“Only buy in gateway markets”

“Don’t buy retail “Gateway markets are whatever you do!” overpriced, Texas is the place to be”

III. Application Should I buy this building? At what price?

“What if my biggest tenant doesn’t renew?”

“Can our leasing team really get it to 90%?” “Where will cap rates be in 5 years?”

“It’s got some vacancy Is that an opportunity or risk?” “The price is back to 2007 levels. Am I overpaying?

“How long will it take to lease up the vacant space?”

CBRE | Page 8

“What is the historical market and property availability?”

“Will rents really grow that much?”

Example – Market Supply/Demand Leases Signed:

Bldg A

Bldg B

2005-2007

75%

25%

2008 – Current

25%

75%

Both assets listed at same cap rate – Should they be? Either Asset A is overpriced or Asset B is underpriced How much?

CBRE | Page 9

Peak-to-Current

% Decline

Submarket A

-7%

Submarket B

-17%

Submarket C

-27%

Example – Market Supply/Demand • Inland Empire Industrial

CBRE | Page 10

Example – Market Supply/Demand • Anything noteworthy? Market Fundamentals data as of Q1 2012

Year

Stock Completions (SF x 1000) (SF x 1000)

Availability Net Gross Net Rate Absorption Asking Rent Asking Rent (%) (SF x 1000) ($/SF) ($/SF)

2010.1

349,214

57

16.20

-1,220

5.36

4.19

2010.2

349,214

0

16.00

651

4.98

4.03

2010.3

349,214

0

15.40

2,002

5.11

4.02

2010.4

349,881

667

14.70

3,043

5.17

3.98

2011.1

350,441

560

13.10

5,962

5.15

3.95

2011.2

350,441

0

12.40

2,586

5.42

4.05

2011.3

350,441

0

11.80

2,173

5.38

4.09

2011.4

352,261

1,820

11.70

1,789

5.33

4.08

2012.1

352,953

692

12.10

-645

5.27

4.10

CBRE | Page 11

Example – Market Supply/Demand • Anything else? Market Fundamentals data as of Q1 2012

Year

Stock Completions (SF x 1000) (SF x 1000)

Availability Net Gross Net Rate Absorption Asking Rent Asking Rent (%) (SF x 1000) ($/SF) ($/SF)

2010.1

349,214

57

16.20

-1,220

5.36

4.19

2010.2

349,214

0

16.00

651

4.98

4.03

2010.3

349,214

0

15.40

2,002

5.11

4.02

2010.4

349,881

667

14.70

3,043

5.17

3.98

2011.1

350,441

560

13.10

5,962

5.15

3.95

2011.2

350,441

0

12.40

2,586

5.42

4.05

2011.3

350,441

0

11.80

2,173

5.38

4.09

2011.4

352,261

1,820

11.70

1,789

5.33

4.08

2012.1

352,953

692

12.10

-645

5.27

4.10

CBRE | Page 12

Example – Market Supply/Demand • What are the implications? Market Fundamentals data as of Q1 2012

Year

Stock Completions (SF x 1000) (SF x 1000)

Availability Net Gross Net Rate Absorption Asking Rent Asking Rent (%) (SF x 1000) ($/SF) ($/SF)

2010.1

349,214

57

16.20

-1,220

5.36

4.19

2010.2

349,214

0

16.00

651

4.98

4.03

2010.3

349,214

0

15.40

2,002

5.11

4.02

2010.4

349,881

667

14.70

3,043

5.17

3.98

2011.1

350,441

560

13.10

5,962

5.15

3.95

2011.2

350,441

0

12.40

2,586

5.42

4.05

2011.3

350,441

0

11.80

2,173

5.38

4.09

2011.4

352,261

1,820

11.70

1,789

5.33

4.08

2012.1

352,953

692

12.10

-645

5.27

4.10

CBRE | Page 13

Example – Market Supply/Demand • Future value? NOI’s (Fundamentals)

Value Cap Rates (Capital Markets)

CBRE | Page 14

Example – Market Supply/Demand • Future yields? NOI’s (Fundamentals)

Yield Value/ Purchase Price

CBRE | Page 15

Example – Market Supply/Demand Leases Signed:

Bldg A

Bldg B

2005-2007

75%

25%

2008 – Current

25%

75%

Both assets listed at same cap rate – Should they be? Either Asset A is overpriced or Asset B is underpriced How much?

CBRE | Page 16

Peak-to-Current

$ Decline

% Decline

Inland Empire

$-12.27

-13%

San Bernardino

$-4.81

-17%

Chino

$-5.24

-18.6%

IV. Market Analysis Drives The Property Pro Forma • Is this a good deal? SUMMARY: Year Sq. Ft. Price Debt Equity 1. INCOME: Rent/SF Rent G: Rate Vacancy Rate Residual Cap Rate Spread (Bps) Year Gross Rent Less: Vac: Net Rent Less: DS Operating Income 4. Returns CBRE | Page 17

100,000 $12,857,143 $9,000,000 $3,857,143 2. DEBT: $10LTV 2%Term 10%Amortization 0.01

0

70%Index 10 Spread (bps) 25Rate Mortgage Constant

1 2 $1,000,000 $1,020,000 -$100,000 -$102,000 $900,000 $918,000 -$749,598 -$749,598 ($3,857,143) $150,402 $168,402 Cash on Cash 4% 4% IRR 11%

3. PRICE: 3.30%Cap Rate: 3.50% 7.0% 6.80% 8.33%

3 4 $1,040,400$1,061,208 -$104,040 -$106,121 $936,360 $955,087 -$749,598 -$749,598 $186,762 $205,489 5%

5%

5 $1,082,432 -$108,243 $974,189 -$749,598 $224,5914. 6%

IV. Market Analysis Drives The Property Pro Forma • It depends 1st ….on the OM’s assumptions SUMMARY: Year Sq. Ft.

100,000

Price

$12,857,143

Debt

$9,000,000

Equity

$3,857,143

1. INCOME:

3. PRICE: 3.30%Cap Rate: 7.0% 3.50%

2. DEBT:

$10LTV 2%Term 10%Amortization

Rent/SF Rent G: Rate Vacancy Rate Residual Cap Rate

70%Index 10

Spread (bps)

25Rate

0.01

6.80%

Mortgage

Spread (Bps)

8.33%

Constant

0

1

2

3

4

5

Gross Rent

$1,000,000

$1,020,000

$1,040,400

$1,061,208

$1,082,432

Less: Vac:

-$100,000

-$102,000

-$104,040

-$106,121

-$108,243

Net Rent

$900,000

$918,000

$936,360

$955,087

$974,189

Less: DS

-$749,598

-$749,598

-$749,598

-$749,598

-$749,598

$150,402

$168,402

$186,762

$205,489

$224,5914.

4% 11%

4%

5%

5%

6%

Year

Operating Income

4. Returns CBRE | Page 18

($3,857,143)

Cash on Cash IRR

IV. Market Analysis Drives The Property Pro Forma • Adjust the OM’s assumptions

Variable

Rent G: Vacancy Absorption Probability to Renew ??? ??? ??? CBRE | Page 19

OM Assumptions

Mkt. History

Mkt. Forecast

Adjustment to OM Assumptions

IV. Market Analysis Drives The Property Pro Forma

SUMMARY: Year Sq. Ft.

100,000

Price

$12,857,143

Debt

$9,000,000

Equity

$3,857,143

1. INCOME:

3. PRICE:

2. DEBT:

Rent/SF Rent G: Rate Vacancy Rate

10%Amortization

Residual Cap Rate

0.01

$10LTV

70%Index

2%Term

10

3.30%Cap Rate:

Spread (bps)

3.50%

25Rate

6.80%

Mortgage

Spread (Bps)

7.0%

8.33%

Constant

0

1

2

3

4

5

Gross Rent

$1,000,000

$1,020,000

$1,040,400

$1,061,208

$1,082,432

Less: Vac:

-$100,000

-$102,000

-$104,040

-$106,121

-$108,243

Net Rent

$900,000

$918,000

$936,360

$955,087

$974,189

Less: DS

-$749,598

-$749,598

-$749,598

-$749,598

-$749,598

$150,402

$168,402

$186,762

$205,489

$224,5914.

4% 11%

4%

5%

5%

6%

Year

Operating Income

4. Returns CBRE | Page 20

($3,857,143)

Cash on Cash IRR

IV. Market Analysis Drives The Property Pro Forma • Adjust the OM’s assumptions

Variable

Rent G: Vacancy Absorption Probability to Renew

Value

CBRE | Page 21

OM Assumptions

Adjusted Assumptions

Delta

Why Adjusted/ Not Adjusted?

Example - 2008 Office OM

CBRE | Page 22

Example - 2008 Office OM  Leases • What percentage of income expires in next seven years? • What will vacancy rates being doing over next five years? • Where are my in place lease rates vs market rates? • The Argus run shows 3% rent growth for next ten years, is that realistic in this market? • The Argus runs show building occupancy reaching 95%, what is historical market occupancy? • The OM says no new buildings under construction, is that correct?

CBRE | Page 23

Example - 2008 Office OM  Leases • What percentage of income expires in next seven years? 6.5% • What will vacancy rates being doing over next five years? -680Bps • Where are my in place lease rates vs market rates? • The Argus run shows 3% rent growth for next ten years, is that realistic in this market? • The Argus runs show building occupancy reaching 95%, what is historical market occupancy? • The OM says no new buildings under construction, is that correct?

CBRE | Page 24

Example - 2008 Office OM  Leases • What percentage of income expires in next seven years? 6.5% • What will availability rates being doing over next five years? ? -680Bps

• Where are my in place lease rates vs market rates? • The Argus run shows 3% rent growth for next ten years, is that realistic in this market? • The Argus runs show building occupancy reaching 95%, what is historical market occupancy? • The OM says no new buildings under construction, is that correct?

 Acquisition & Exit • What is the market cap rate? • What is cap rate trend since the market bottom? • Where is pricing today compared to peak of the market – cap rates and prices PSF? CBRE | Page 25

Example - 2008 Office OM

In-Place Rents Are 7.1% higher than market rents

CBRE | Page 26

Example - 2008 Office OM  Leases • What percentage of income expires in next seven years? 6.5% • What will availability rates being doing over next five years? • Where are my in place lease rates vs market rates? 7.1% higher • The Argus run shows 3% rent growth for next ten years, is that realistic in this market? • The Argus runs show building occupancy reaching 95%, what is historical market occupancy? • The OM says no new buildings under construction, is that correct?

CBRE | Page 27

Example - 2008 Office OM

What is greatest amount that rents have ever gone up from peak-totrough in this submarket? How much are they projecting rents to go up from the “tech wreck” trough?

CBRE | Page 28

Example - 2008 Office OM

In-Place Rents Are 2.2% higher than competitive set rents CBRE | Page 29

Example - 2008 Office OM

CBRE | Page 30

Example - 2008 Office OM

CBRE | Page 31

Example - 2008 Office OM

Subject Property

CBRE | Page 32

2008 Office OM

CBRE | Page 33

2008 Office OM

CBRE | Page 34

2008 Office OM

A B C D

All the same building

All the same building

CBRE | Page 35

2008 Office OM

CBRE | Page 36

2008 Office OM

Building took everyone from

CBRE | Page 37

2008 Office OM

Building took everyone from

CBRE | Page 38

Example - 2008 Office OM

CBRE | Page 39

Christopher Macke Chris comes to CBRE with more than 20 years of real estate experience. His experience includes real estate development, financing, acquisitions and advising various regulatory agencies. He is a Senior Real Estate Strategist for the Investment Consulting group within the America’s Research team. Chris delivers investment opinions and insights to institutional investors with the aim of helping them develop a “house view.” Chris holds a B.A. in Political Science from the University of Southern California, where he specialized in political campaign strategy and finance. He earned a Masters of Business Administration from Indiana University’s Kelley School of Business specializing in Finance. [email protected]

CBRE | Page 40

Local Real Estate. Worldwide. Thank You www.cbre.com CBRE Global Research and Consulting 260 Franklin Street, Suite 400 Boston, MA 02110 Tel: 617.912.5200 Fax: 617.912.5240

Suggest Documents