Unlevered and Levered IRR for Real Estate
Hi guys, I have a modeling test for the RE team of a SWF coming up and I was wondering if someone could clear up something for me....I know it sounds very simple but I think there is just a gap in my knowledge. Could someone walk me through how one might find the levered and unlevered IRR of, say, an office acquisition? Of course one of them removes the effect of debt, but in a modeling context, how exactly does that work?
The internet is less than forthcoming so far so I thought I would float the question to you guys. Thanks in advance guys!
What is the Internal Rate of Return?
Internal Rate of Return or IRR is a financial metric used to discount capital budgeting and to make the net present value of all future cash flows equal to zero. For this reason, it is used alongside a Discounted Cash Flow analysis.
IRR is an estimate of the rate of return that an investment is expected to provide. Usually a higher IRR means a more profitable investment.
IRR Equation
Levered IRR for Real Estate
"RE Dev - Real Estate Developer"Levered IRR will be based on your levered cash flow (NOI less debt service). Levered initial investment will be the total equity put up for the project (total development cost less total debt).These both assume no capital expenditures or leasing commissions below-the-line. Both items would be subtracted from the cash flow figures above. Then it's just a standard IRR calculation for each one. These are all before-tax IRR calculations by the way.
Unlevered IRR in Real Estate
"RE Dev - Real Estate Developer"Unlevered IRR will be based on your unlevered cash flow (NOI). Unlevered initial investment will be total acquisition/development cost.
Why Should you Use Pre-Tax Cash Flows?
"CRE-Finance - Real Estate Analyst"You need to use pretax cash flows. Factoring in tax considerations will be unique to each company doing the analysis based on their ownership structure and other factors. It is best to look at pretax cash flows to compare investments.
Additonal IRR Topics to Consider
"International Pymp - Real Estate Vice President"In a modeling test context, you'll sometimes be asked to find the unlevered IRR when the levered IRR / rest of the model is already built in. In that case it's often easiest to work backwords from levered and simply take out all the financing cash flows. Also, one thing about doing this when modeling, the best check is to think logically... given what you know about the cost of debt and the return/cash flow dyanmics of the property, you should have a sense for how Accretive the debt is.... based on that you'll know if you're levered/unlevered delta seems right... which can give you some comfort when you find the actual answer (or tell you when you're wrong).
"DBI3171 - Real Estate Analyst"You might want to brush up on calculating equity multiples under levered and unlevered scenarios as well. Although EM's and IRR's are highly dependent on product type, market economics and investment time horizon, levering up with favorable a debt structure will tend to drive IRR's and and reduce EM's all else being equal. This is usually a good check to make sure your coding correctly.
Read More About IRR on WSO
- Calculating and Estimating Internal Rate of Return
- Is there an ideal spread between Unlevered and Levered IRRs?
Preparing for Private Equity Interviews?
Purchase the most comprehensive private equity interview guide consisting of 2,447 questions across 203 private equity funds. Crowdsourced from over 430,000 members. And trusted by over 1,000 aspiring private equity professionals just like you. The WSO Private Equity
Interview Prep Course has everything you’ll ever need to land the most coveted jobs on Wall Street.
Unlevered IRR will be based on your unlevered cash flow (NOI). Levered IRR will be based on your levered cash flow (NOI less debt service). These both assume no capital expenditures or leasing commissions below-the-line. Both items would be subtracted from the cash flow figures above.
Unlevered initial investment will be total acquisition/development cost. Levered initial investment will be the total equity put up for the project (total development cost less total debt). Then it's just a standard IRR calculation for each one. These are all before-tax IRR calculations by the way.
Thanks a lot for explaining the calculations. Just one quick question though - Shouldn't we be taking after tax cash flows? That is how one would calculate cash flows for IRR calculations. Please let me know what am I missing.
Many thanks!
@blackjack7" No, you need to use pretax cash flows. Factoring in tax considerations will be unique to each company doing the analysis based on their ownership structure and other factors. It is best to look at pretax cash flows to compare investments.
Unlev -Price CF1 CF2 CF3 + Property Sale Proceeds
Lev -Price+Loan Proceeds CF1-Debt Service-Fees CF2-Debt Service-Fees CF3+Property Sale Proceeds-Debt Service-Fees-Balloon
This is a nice easy explanation. In a modeling test context, you'll sometimes be asked to find the unlevered IRR when the levered IRR / rest of the model is already built in. In that case it's often easiest to work backwords from levered and simply take out all the financing cash flows. Also, one thing about doing this when modeling, the best check is to think logically... given what you know about the cost of debt and the return/cash flow dyanmics of the property, you should have a sense for how Accretive the debt is.... based on that you'll know if you're levered/unlevered delta seems right... which can give you some comfort when you find the actual answer (or tell you when you're wrong).
Good explanation, kmzz
Thanks guys, that's what I expected but I guess I started confusing myself by reading one to many articles that may have been incorrectly authored. Appreciate it! Is the main point of having the two side by side just to see a) how the debt/leverage affects the transaction and b) to drill down the specific effects of the transaction on the investor's equity (in the case of levered IRR)? Thanks again.
Just remember. Leverage does not create value. It simply provides higher returns with higher risk.
I am curious, how does this impact Stakeholders? Is there an impact? I am still learning about this in the Real Estate market.
Stakeholders? It depends on the structure and which partner, that is part of jobs to figure out or at least provide an opinion on. But any deal does not produce better returns by just placing debt on it without a corresponding increase in risk. M&M.
This post is now 8 years old. Leverage does not create value. It simply provides higher returns with higher risk.
Given the current market, specifically multifamily, does any sound CRE investor utilize the above phrase?
tubby - yeah those reasons make sense. I also always saw the unlevered as kind of the sanity check. it's the natural return you're expecting to get so you can compare it against other "unlevered" investments like bonds or whatever and see if the return is commensurate with the risk.
even though a lot of deals end up with leverage, it always helps to start off looking at the merits of the return profile without factoring in debt and then comparing to see how Accretive debt would be. otherwise you could just be juicing up a turd and calling it a good investment.
del
You might want to brush up on calculating equity multiples under levered and unlevered scenarios as well. Although EM's and IRR's are highly dependent on product type, market economics and investment time horizon, levering up with favorable a debt structure will tend to drive IRR's and and reduce EM's all else being equal. This is usually a good check to make sure your coding correctly.
May I know what is EM?
Equity Multiple. Essentially is the (total net profit + initial investment) / (initial Investment)
For example, if a certain project was an initial investment of $1m and threw off $50k of cash flow for 3 years and then was sold for $1.25m the equity multiple formula would be
Net Profit = Sum of Cash Flows - Equity Investment = ($50k + $50k + $50k + $1.25m) - $1m = $400k
($400k + $1m) / $1m = 1.4 equity multiple.
The reason why equity multiple is important is because it gives you an idea of the amount of profit (in dollars) you will receive relative to your equity investment. IRR on the other hand is simply a percentage and can be manipulated through timing of capital calls and distributions...
investREanalyst Why include CF0 in the numerator?
Well its actually supposed to be 'Total Equity Invested' but I made a simple example where there was only one capital call in the beginning (Often times there may be capital calls throughout the life of the project and the timings of these capital calls effect the IRR).
To answer your questions, its because you are using Total Net Profit which subtracts the equity investment so you need to add it back in to understand the actual cash flows delivered to the investor. The main reason for using this formula is to have an understanding of the actual amount of cash that will be delivered at the end of the day, and not just the IRR which does not tell you much in regards to dollar amount...
Is there any point in showing ROE and EM together as they are essentially the same (ROE = EM-1)?
Quia assumenda vero fuga nostrum aut id aut. Et et facilis aliquid hic. Consequatur aperiam assumenda rem et sunt. In et vitae qui voluptatibus ipsam repellat. Molestiae possimus omnis est rem. Aliquam exercitationem praesentium debitis saepe illo minus hic ab.
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...
Est rerum esse libero quas autem rerum ipsam aperiam. Minima officia amet dolor quis ut. Sit cupiditate dolores blanditiis quo.
Temporibus sint consequatur eos aut modi architecto perspiciatis. Labore qui voluptatem facilis dolorem qui aut. Dolore quia porro asperiores sit. Laboriosam neque aliquid rerum eum odio est. Quia cum adipisci similique sunt sapiente eveniet. Provident aspernatur et perferendis hic harum ut quia voluptas.
Quod placeat provident ut repellat sed facilis pariatur. Repellat omnis maiores natus minus sed. Eum ratione vel voluptas qui quia suscipit vitae. Et autem ex atque aut.
Iste dolorem veniam veniam qui vel tempore quia fugit. Animi ex ut deleniti ducimus porro nihil veritatis commodi. Unde qui aut quia eos distinctio. Error vero ab et non neque voluptate praesentium temporibus. Ducimus nihil voluptates commodi tempore aliquid ea.