Real Estate Private Equity Technical Qs

So I have been offered an interview with a top real estate private equity firm but don't know much about the technical side of it.

How do you calculate FCF when looking at real estate? I know the formula when analysing companies fcf =(1-t)EBIT+D&A- change in NWC -Capex.

As this is an internship straight out of undergrad , will I be expected to build an lbo model? I know the basic concept but can't actually do one. I've never studied real estate before.

 

What about Lone Star taking Home Properties private last year? Or a PE group looking at a topping bid for Post? I guarantee someone has built that model recently. Or BX and Brixmor? Those seem a lot like lbo situations to me. Not saying that this is a common thing at your average REPE firm, but if you have an interview at a shop that plays at that level, they're going to want to know if you can build that kind of model.

 
Best Response

If you even mention EBITDA, you may get the stink eye. Quick rundown: Asset Level Revenues - Asset Level Expenses = Net Operating Income. Net Operating Income (NOI) less Capital Expenditures (Purchase Price, Closing Costs, Tenant Improvements, Leasing Commissions, Capital Reserves) = Unleveraged Cash Flow. Add Financing (Debt Proceeds, Lender Fees, Debt Service Expenses, and Loan Payoff) to your Unleveraged CF and you arrive at Leveraged CF. Think of Unleveraged CF as cash flow available to all positions in the capital stack (debt and equity). Leveraged CF is therefore cash flow available to equity investors. I've seen technicals ranging from brain teasers to IB-esque accounting questions; "walk me through how -$10 depreciation affects all three of the financial statements". You won't be expected to build a model but I can tell you that a REPE model is less complex than a lbo model. RE valuation is determined by a cap rate (what you would think of as an EBITDA multiple). To determine your asset value, divide your F12 NOI Sum by your exit cap rate. Cap rates differ throughout the country by location and product type. Core markets (gateway cities such as SF, LA, NYC, Chicago) typically have lower cap rates due to perceived stability by equity capital whereas secondary cities (the next tier) and tertiary markets (that next tier beyond secondary) are perceived to be of greater risk due to 1) less jobs 2) less growth 3) less population (in no particular order). Buying a building is like buying a business, levering it up, determining your investment strategy (is it a core play aka long term fixed income investment with minimal required improvements; value-add play, aka capital improvements required via aesthetic enhancement to the interior/exterior or operation efficiency improvement; opportunistic aka ground up development or extreme repositioning..btw those are ordered from least risk to greatest risk and as you can guess this translates to lowest returns to highest returns in order), and finally exiting the investment. Buy low, sell high. If cap rates compress (decrease) during your hold period, you can make a lot of money. Going the other direction can potentially destroy you. This is why so much emphasis is placed on buying at the right time (aka when cap rates are highest in the cycle and asset values are lowest). Good luck man.

 

This is all correct, but I disagree with the idea that talking about EBITDA will get you the stinkeye or "pwn3d." It really depends what this REPE group does. For the overwhelming majority of shops, yeah, nobody cares about EBITDA because they are dealing with assets or portfolios of assets, not entire real estate operating companies.

If you are interviewing at a REPE firm that does have the size/scale to deal with real estate operating companies (hotel groups being a classic example) then you'll find that people do talk about EBITDA and it matters greatly. Why does it matter? Because corporate G&A is below NOI but captured in EBITDA. So if we are talking about a large operating company, you need to be considering that corp G&A.

This all said, there are only a few REPE groups in the world that have the scale to play on this level. And if you are lucky/good enough to be getting an interview with them, you damn well better be able to talk about EBITDA and do an LBO. They aren't asking you to do one as a thought exercise.

 
cpgame:

If you even mention EBITDA, you may get the stink eye. Quick rundown: Asset Level Revenues - Asset Level Expenses = Net Operating Income. Net Operating Income (NOI) less Capital Expenditures (Purchase Price, Closing Costs, Tenant Improvements, Leasing Commissions, Capital Reserves) = Unleveraged Cash Flow. Add Financing (Debt Proceeds, Lender Fees, Debt Service Expenses, and Loan Payoff) to your Unleveraged CF and you arrive at Leveraged CF. Think of Unleveraged CF as cash flow available to all positions in the capital stack (debt and equity). Leveraged CF is therefore cash flow available to equity investors. I've seen technicals ranging from brain teasers to IB-esque accounting questions; "walk me through how -$10 depreciation affects all three of the financial statements". You won't be expected to build a model but I can tell you that a REPE model is less complex than a lbo model. RE valuation is determined by a cap rate (what you would think of as an EBITDA multiple). To determine your asset value, divide your F12 NOI Sum by your exit cap rate. Cap rates differ throughout the country by location and product type. Core markets (gateway cities such as SF, LA, NYC, Chicago) typically have lower cap rates due to perceived stability by equity capital whereas secondary cities (the next tier) and tertiary markets (that next tier beyond secondary) are perceived to be of greater risk due to 1) less jobs 2) less growth 3) less population (in no particular order). Buying a building is like buying a business, levering it up, determining your investment strategy (is it a core play aka long term fixed income investment with minimal required improvements; value-add play, aka capital improvements required via aesthetic enhancement to the interior/exterior or operation efficiency improvement; opportunistic aka ground up development or extreme repositioning..btw those are ordered from least risk to greatest risk and as you can guess this translates to lowest returns to highest returns in order), and finally exiting the investment. Buy low, sell high. If cap rates compress (decrease) during your hold period, you can make a lot of money. Going the other direction can potentially destroy you. This is why so much emphasis is placed on buying at the right time (aka when cap rates are highest in the cycle and asset values are lowest). Good luck man.

This is hands down the single best explanation i've ever seen for real estate PE. Kudos.

 

It depends on the size/scale/sophistication of the shop. For most uses, yeah some analyst at HFF is going to be able to hit the ground running faster. I get it.

But if you are a large REPE firm, or a large REIT, or a large hotel operator, then you might think that analyst from HFF is just another fluffy-haired fuck from a SEC school with bad habits and subpar skills. You can get somebody from IB that knows general corporate finance better and teach them real estate. Real estate isn't hard. We all know this. There's a reason why it's common to go from general corporate finance to real estate but not vice-versa.

 

Hi, I had to do a few of those excel tests, so I will try to help you out. From my experience, REPE excel tests always require you to calculate one or several of the following return indicators:

  • unlevered /levered IRR (usually pre-tax) -> most important
  • Cash-on-Cash Return
  • Equity multiple

This requires you to:

1) Arrive at NOI and the cash flow before debt service and taxes (unlevered cash flow). Note that NOI is not the bottom line unlevered cash flow because it NORMALLY excludes leasing and capital costs (tenant improvements, leasing commissions and CAPEX).

To understand real estate cash flows, I recommend taking a look at "Commercial Real Estate: Analysis and Investments" by David Geltner (you will probably find this book online). However, don't waste too much time on cash flows because, most likely, you won’t have to set up a full blown cash flow statement.

2) Calculate the levered cash flow. It is helpful to know the formulas for debt financing (i.e. PMT, IPMT, PPMT) even though an interest only loan is most common in those test. Nevertheless, be able to apply the above excel formulas for non-interest only loans and for all cash flow intervals (monthly, quarterly semi-annually and yearly).

3) Calculate a terminal value by using an exit cap rate. When your holding period is 10 years, divide the year 11 NOI (HP+1year) by your exit cap rate. If no exit cap rate is given, just add 50 bps to 100 bps to your stabilized entry cap rate.

4) Finally calculate the above mentioned levered/unlevered return indicators.

A few more hints: -It is important that you know how to calculate all financing formulas and the IRR for various cash flow intervals. Under time pressure, trial and error isn’t an option.

-Difficult tests will ask you to calculate multi-tenant cash flows with various lease expiries, rent abatements and void periods. PM me if you want an example spread sheet.

-Some test also require you to extract some data from rent rolls. Important formulas are obviously sum product, sum if, subtotal, VLOOKUP index match etc.

-Know how to calculate the weighted avg. lease term (WALT)

Good luck!

 

If you're interviewing with a REPE debt fund and don't understand why the debt constant is higher than the interest rate, do everyone on this forum a favor and tell us who it is that you're interviewing with.

Jokes aside - most debt service is either structured in one of two ways: (1) Interest-Only, meaning the debt service is the stated interest rate for a stated period of time or (2) Amortizing, in which debt service is comprised of interest and principal. Learn the key differences of these two or so help me g-d, I'm selling out of all my RE investments stat.

 

Eligendi facilis mollitia nihil. Atque officia deserunt facilis impedit. Voluptatibus impedit voluptas sed pariatur ratione voluptas at omnis. Provident ex quae omnis natus. Non non perspiciatis autem dolores et amet sint. Eos et possimus ut voluptatem aut saepe perspiciatis dolor.

Harum veritatis magnam et. Tempore eos enim reprehenderit. Itaque veritatis consequatur consectetur sed. Delectus facilis assumenda et. Repudiandae assumenda soluta voluptas hic blanditiis magni cum.

Doloribus aliquam et sit aliquid. Dolor delectus esse consequatur aperiam voluptatem dolorum consectetur dolorem. Officia recusandae aut voluptatem magnam tempore fuga eligendi soluta.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
kanon's picture
kanon
98.9
9
bolo up's picture
bolo up
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”