Rough mental return calculations?
Hi all,
I'm looking to improve my "deal sense" and am wondering about simple mental math calcs I can do to get a sense for returns when talk about deals?
For example: Entry cap+constant growth rate=IRR (assuming same exit cap). So buying at a 5 cap with 3% growth over the hold period and exiting at a 5 cap would earn an 8% IRR.
Are there are other calcs I can do to get a sense for how leverage would affect IRR? Or how IRR might change with exit cap expansion/compression? Or any other tricks generally to get a sense for how a deal might return?
Thanks!
Bump, interested in this as well.
Not exactly being a big help here but I told think that Cap + Growth = IRR formula holds true in most cases. I'm curious to hear what others have to say, however.
It's helpful if you're underwriting multifamily and can assume a constant growth rate. It's a pretty useless rule of thumb for commercial though because of inconsistent lease rollover timing and the variance in lease rates.
Bump, this seems like really great info
Can you expand on that IRR calculation?
Valuing a property with a cap rate is really just valuing a perpetual cash flow. V = NOI/Cap Rate. Perpetual cash flow is V = CF/(Discount Rate - Growth Rate). So Cap Rate = R - G.
Only caveat here is don't forget CAPEX. Including normalized CAPEX will result in a lower "real" cap rate and ultimately lower IRR. Also, this may be obvious, but want to point it out for others who may not already know, the other thing is this would only translate to unlevered IRR. Levered IRR's would (should) be higher since you should have positive leverage and will vary depending on amount of leverage and terms.
To expand on RE Dev's answer.
In a world without TIs/Capex, downtime, lease-up, structural vacancy, broker fees, DD costs, etc., the unlevered IRR should be: Unlevered IRR = Cap rate + G.
If you add leverage, the return should be higher (most cases), and can be approximated as follows: Levered IRR = Unlevered IRR + (Unlevered IRR - Financing cost) x Debt / Equity. The wider the spread between the unlevered returns and the financing cost, the more favorable leverage will be. As debt increases, the multiple gets more significant, but a higher LTV usually means higher financing cost. Keep in mind that this is the IRR before tax.
You can estimate the cash on cash return by using this formula: cap rate + (interest rate - cap rate) x leverage ratio. For example, if you buy an asset at 75% LTV at 4% interest and a 6 cap, your cash on cash is roughly 6% + (6-4) * (75/25) = 12%.
This is a good one too.
You're saying the same thing as above except its cap rate - int rate . Note the cap rate is the unlevered return of the asset assuming 0 growth. This is Modigliani Miller proposition II in its simplest form (without taking into account taxes and cost of financial distress as you increase leverage). Note this is a gross estimation since D/E is constantly changing with amortizing/term loans and is not static throughout the life of the holding period of the asset.
Just came up with another rather obvious one.
Debt yield = cap rate/LTV.
Just had an LP shitting on a deal with "5% debt yield" when cap rate is 6%. Not sure where he got that from.
He probably meant the levered Cash on Cash. I deal with this all the time. Some of the old guarde in RE are very frustrating to deal with since they don't use precision in these types of terms.
Cap rate / debt yield = LTV so if your debt yield is 5 and cap rate is 6 -> a LTV of of 120%
Likely an obvious one, but your talking cap rate + Growth = unlevered IRR (assuming same exit cap).
Growth = average annual contractual rent escalation (let’s say 3% per annum)?
Or
Growth = average annual rent growth?
Growth as in NOI growth. Rental rate growth can get muddy due to expenses. But if the expense ratio stays constant, rent growth would work too.
I've noticed that all of the big shotcaller principals I've dealt with in my career don't give two fucks about IRR (pre-disposition obviously) on development deals. Too many variables including exit cap-rate, hold period (when is stabilization and when is the right time to sell?), and debt service (if floating rate).
All they focus on is months to stabilization, development cost per pound (pu, psf, pb, etc...), and stabilized YoC. Having a strong YoC over all else gives you optionality on the exit whether that is disposition or refinance. Levering up to the hilt and trying to sell immediately with minimal development spread to engineer a high IRR is risky business that does not allow for uncertainty.
If it's condo sales then YoC doesn't apply right
Right - then you'd look at straight up margin on cost (i.e. profits / costs)
I'd agree with this in terms of vetting out deals for go forward - but those guys certainly care about IRR once it comes time to raise funds from investors.
Need to take all metrics together, you can't just look at one by itself.
Here is another one:
Change in equity based on change in yield: delta (EK) = (yield1 - yield2)/(EK% x yield2). So, if the yield is 5 % today and 4 % tomorrow (ie. drop of 20 %, increase in property value of 25 %) and your LTV is 60%, the equity increases with 62.5 % = (5 % - 4 %)/(40% x 4%).
Thanks! By EK% in the denominator, do you mean % of equity? Or something else?
Yes, sorry, % of equity (ie. (1-LTV)).
bump, this is a good thread, does anyone use any other mental calcs?
Bump loving the thread
Dolorum deleniti fugit debitis aperiam facilis ut. Quo sunt voluptas provident. Vel quia optio magnam assumenda nam nihil. Aut cumque ipsam sit facilis.
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...
Modi ipsam cum ea officia aut. Ullam amet labore et sed. Vero et tenetur repellat repellendus architecto.
Sit voluptatem quo eum eaque aut iste esse voluptatem. Repellat voluptas dolorem minus delectus consequatur aspernatur optio. Itaque enim ex ipsum qui et incidunt. Quis architecto id mollitia qui.
Qui autem accusantium vel unde. Repellendus rerum veritatis molestias. Mollitia voluptatem aut dignissimos a. Minus cum et et numquam iusto cupiditate. Sint consequatur temporibus et illo quis ipsa.