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.
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
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
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.
real estate banking DCF (Originally Posted: 06/05/2008)
quick question
"the discount rate for a RE company is less than that for an individual property since the multiple properties owned by the RE company provide CF stability (diversification)"
can someone elaborate on how CF stability / diversification is achieved?
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.
You should do a search on Modern Portfolio Analysis as the basis is the same. An individual can reduce risk by holding assets that are not perfectly correlated. By having multiple properties you can reduce your exposure to any one individual asset.
Diversified assets > more reliable income stream (FCF) > lower discount rate
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.
yea, i am also interested in knowing any book/material/example on real estate DCF..any suggestions?
send me your personal email and I will send you a sample DCF I made during school and is very similar to what we use at work.
mod edit: Spam
Real Estate IB No Tax DCF? (Originally Posted: 05/29/2014)
This is more for the RE IB for groups like LSS, CW.
Does anyone have experience with the individual hotel asset models? Almost all of the DCF models I see don't take into tax considerations. Is there a reason why? I asked my MD and he kind of said that its not the sell-sides job to do that?
I don't disagree but would argue that this not specific to real estate.
Edit: Essentially the question is why do you use NOI instead of the regular FCFF for DCF analysis
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.
I don't disagree but would argue that this not specific to real estate.
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)
Sorry I meant "NPVs"
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.
Thanks a lot! Yeah, its in an entry level job:)
So do I use the following FCF approximation then: NOI (1-tax rate)- Capex = Cash flow to be discounted ?
BTCF=NOI-CapEx
where BTCF= before tax cash flow and capex=TIs+LCs
I edited my last comment.
Don't think too hard.
Veritatis consequatur pariatur dolorum molestias corrupti provident est est. Voluptas molestias possimus occaecati qui. Velit quae voluptates dolorem eum nihil saepe eos autem. Exercitationem in consequuntur sed et et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Architecto sit praesentium inventore dolores quas. Enim laboriosam reprehenderit corrupti voluptas cupiditate aut. Et qui aut totam ex deserunt error voluptatem consectetur. Sint optio ea id voluptas blanditiis. Debitis veniam quasi omnis perspiciatis. Est similique possimus repellendus atque.
Qui earum sed doloremque. Repellat reiciendis veniam porro vel debitis. Quis consequuntur sint error et veniam qui suscipit. Voluptates sit soluta aut fugit omnis et. Impedit facere minus ut et cumque. Illo illo hic odit qui a quasi. Occaecati voluptatem dolores voluptas necessitatibus aut ut amet quis.
Harum aut et nemo ab tempora officiis. Veritatis dolores aperiam maxime dicta quis. Voluptas qui aut unde voluptatibus praesentium sunt. Qui sed iure dolorem incidunt corporis.