Real Estate DCF Valuation (upcoming interview!)

Hey guys,

Can someone help me to understand real estate DCF valuation specifics?

How exactly is the WACC calculated for a real estate DCF model? Does the tax shield diminish the cost of dept like in the classical WACC calculation? Maybe a silly question, but does WACC calculation interfere with the cap rate somehow-could I just use the cap rate instead of WACC?. Is NOI used as Free Cash Flow to the Firm? Why is the terminal value calculated by dividing the cash flow sum by cap rate and not WACC?

Also a couple of questions to cap rates: Why is cap rate considered the inverse of a PE multiple-I would say it corresponds more to an EBIT multiple, no? Does it make sense to calculate cap rates by taking publicly traded companies’ multiples (e.g hotel chain ratios)?

Thanks!!

 

Its fairly unusual to build up a WACC for use in real estate valuation. The discount rate / IRR is typically estimated via surveys and also by the spread between what an appropriate cap rate would be and the amount of growth expected in earnings over the holding period.

I'm not sure who told you that cap rate is considered the inverse of the PE multiple but I would probably agree that it is more closely related to EBIT. When someone does RE valuation it typically is done on an unlevered basis and before income taxes.

 
Best Response
prnz:
Its fairly unusual to build up a WACC for use in real estate valuation. The discount rate / IRR is typically estimated via surveys and also by the spread between what an appropriate cap rate would be and the amount of growth expected in earnings over the holding period.

I'm not sure who told you that cap rate is considered the inverse of the PE multiple but I would probably agree that it is more closely related to EBIT. When someone does RE valuation it typically is done on an unlevered basis and before income taxes.

Let me preface w. dont know much about RE but..why do RE guys always use perpetuity for TV vs exit multiples? Seems like in CRE if an asset is income producing then you could apply a TV exit multiple inferred from precedents. Perhaps precedents in RE never disclose income hence inability to infer multiples

 
prnz:
Not sure but my guess is that this is because the use of cap rates is so ubiquitous and it's pretty easy to add a spread of 100 - 200 basis points to your going in cap rate to figure out what an acceptable terminal cap rate might be.

Ya but how do you map that to what properties have traded and are trading for? Couldn't you get a little more granular and map sq. ft., growth, and profitability metrics to appropriate multiples inferred from precedents?

I think this is why RE guys get so absolutely destroyed peak to trough. How can one possibly do a sanity check on LT avg. perpetuity growth when the most relevant path to liquidity (asset sales) are ignored in favor of conceptual things like cap rates

 
DurbanDiMangus:

Let me preface w. dont know much about RE but..why do RE guys always use perpetuity for TV vs exit multiples? Seems like in CRE if an asset is income producing then you could apply a TV exit multiple inferred from precedents.

I think this is why RE guys get so absolutely destroyed peak to trough. How can one possibly do a sanity check on LT avg. perpetuity growth when the most relevant path to liquidity (asset sales) are ignored in favor of conceptual things like cap rates

I'm not sure what you're asking. Why do you think "the most relevant path to liquidity (asset sale)" is ignored in valuation? An asset sale is assumed in year X based on cap rate of Y%. Then that number is discounted to today along with the cash flows that are generated along the way. This is what I have seen in acquisitions.

 

I suppose you could with perfect knowledge, but obviously that's not the case.

The RE industry really isn't that scientific. Most investors are going to ask themselves whether at the end of the day they can be happy with the returns that a particular deal might generate.

To your second point, you aren't far off. The PE funds go out there are raise a ton of money and then have a few years to buy assets or else they have to give the money back. Further, the ability of these funds to raise capital is linked to the rise and fall of asset cycles. Most PE funds are not, I'm sorry to say, going out and doing the equivalent of value investing in the stock market. Instead, they have capital committed from a large pension fund that wants exposure to the RE sector and which is happy to get a market yield.

 
prnz:
I suppose you could with perfect knowledge, but obviously that's not the case.

The RE industry really isn't that scientific. Most investors are going to ask themselves whether at the end of the day they can be happy with the returns that a particular deal might generate.

To your second point, you aren't far off. The PE funds go out there are raise a ton of money and then have a few years to buy assets or else they have to give the money back. Further, the ability of these funds to raise capital is linked to the rise and fall of asset cycles. Most PE funds are not, I'm sorry to say, going out and doing the equivalent of value investing in the stock market. Instead, they have capital committed from a large pension fund that wants exposure to the RE sector and which is happy to get a market yield.

I think we all know it isn't too scientific as purported by the ridiculous valuations of the mid 2000s which kind of brought us to where we are today. And the self-satisfaction/complacency with using non-scientific methods is all too common in RE, from my pov. There is no excuse for using a jacked up Lt growth rate to win a deal that gives you a writedown when you mark it to fv in a few months.

 

so even with a housing bust in phoenix, if your portfolio also owns commercial property in shanghai, warehouses in germany, etc... the argument can be made that the assets of the company (i.e. - "portfolio") is more diversified than a regular company, thereby having multiple/diverse cash flow streams.

 

on the topic of RE banking DCFs....is there any place online or does anyone have any pdfs or anything on how to use and familiarize oneself with modeling in ARGUS?

 

Also,say you own a bunch of properties in a geographic location,you can consolidate expenses and build a critical mass.You can work this even on the revenue side of the equation-you negotiate multiple deals with a bank and have them as a tenant at mutiple properties that you own.You get better quality tenants for longer period of time.This brings stability as well sizeable cashflows to the company.

 

Because different investors have different tax implications: Potential buyers could includes REITs (No Corporate Income Tax assuming they meet the requirements), Private Families or Funds which will all be taxed differently - in many cases the tax implications will only take place at a personal level not a corporate level.

 

Thanks! I dont quite understand how private equity real estate funds perform the valuation. Do they estimate a discount rate, use it on a dcf model and compare the NVPs of various projects, or do they estimate their target IRR and do an LBO valuation based on entry Value (entry NOI/Cap rate) vs exit value (exit NOI/Cap Rate)

 

Its totally unusual for you to model RE with WACC.

I am assuming this is an interview for some kind of entry-level job?

This is basically what you need to know, focusing on operating CF:

  • Potential Gross Income-Vacancy Allowance+Other Income-Operating Exp=NOI...If this for an entry-level job, this is all you will be expected to know (and I hope you know at least this much).

  • NOI-(Tenant Improvements+Leasing Costs)=Before Tax Cash Flow (BTCF)

*Know how to calc cap rate and what it means.

If this is not an entry-level job, keep reading...

DR=OCC=Expected Return=(risk free rate)+(risk premium), where risk free rate is typically (T-bill-100bps) and risk premium is usually based on NCREIF historical data. Without going through the calcs, OCC was typically 6-7.5% for institutional assets and 8-11% for higher risk assets back in 2005. I'm quoting 2005 because the last time I had calc OCC was in college in my RE finance course (nowadays, 8-10% and 12-15% are more common for today's risk) There is more to it, but this stuff is rarely used in practice.

In practice, you have the asset's operarting statements and a set of market leasing assumptions. You input both into Argus, and then calc yields (both property and fund level) with the firm's debt/cost assumptions.

--- man made the money, money never made the man
 

Odit ullam culpa fuga omnis dolor numquam est. Sit laborum ducimus aut beatae quo odio odit. Similique vel nesciunt ut sapiente tempora incidunt. Delectus ipsum voluptatibus consequatur molestiae ut impedit.

Itaque ut natus dolor itaque. Sed modi deserunt ipsum qui ipsum. Eos consequatur dicta nemo incidunt est possimus autem. Neque dicta voluptatem dolorem est omnis.

Veniam commodi dolorem rerum recusandae vitae laudantium quisquam. Qui non enim quasi ab est error occaecati perspiciatis. Doloremque architecto consequatur cupiditate sed aliquid maxime sunt.

Explicabo porro enim fugiat minima aut. Reprehenderit sequi dolor aut dignissimos atque id. Cumque nemo excepturi perferendis cupiditate est veniam ea. At eum nam eaque laborum et fugiat saepe.

 

Vel dicta et doloremque non quod nemo iusto. Doloremque laudantium ut nemo sit ducimus. Explicabo quidem autem repellat corporis. Tempora voluptatem deleniti unde quasi libero.

Omnis deserunt omnis ut. Cumque doloremque et odit ut aut fuga alias. Nostrum asperiores dolor beatae perferendis. Non non ipsa dolores et. Eius nobis vero est quam impedit. Reiciendis aspernatur in atque quia.

Saepe qui sequi vel maxime. Aliquam tenetur quia minima non quo aut magnam. Et qui eum repellendus sed.

Career Advancement Opportunities

March 2024 Investment Banking

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

Overall Employee Satisfaction

March 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

March 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

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
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...”