Return on equity/cash on cash calc

I'm looking at a cash flow statement. What line items do you include in free cash flow, including a disposition, to arrive to your yearly and all in cash on cash return on investment. Do you include yearly fund level accounting in the cash yield? Broker sale cost? Prepayment on debt? etc... I've seen many opinions on what to include here, as well as what is included in IRR. Even spoke with a professor of finance who has 20+ years in PE, however his answer was very vague and can be summed up as 'be honest, know your partners, model everything yourself.'

thoughts?

 
Best Response

Having seen this being done by other RE funds I've worked with as well as being the person who does financial modelling for a REIT myself:

  • Cash yield /cash on cash return = Distributions (dividends+sub debt interest and principal repayments) i.e cash in hand for the end investor

Divided by

  • Cash contributed (equity + sub debt)

I mention sub debt because most real estate transactions I've seen are financed with sub debt (i.e debt subordinated to the senior debt) instead of pure equity, sub debt is usually "stapled" to share capital i.e if Investor 1 puts in 20% of the sub debt, they also put in/own 20% of the share capital.

Do not look at accounting costs for sub debt as that can often include rolled up interest: i.e interest accrues but isn't actually paid out. Also do not look at free cashflow on it's own as the definitions of that vary and it isn't necessarily what is paid out to the investors.

 

I see. Interesting. So you're saying you see a lot of sponsors or the REIT invest in a different part of the capital stack as a pref equity/participating debt, in addition to the equity?

Okay. So this is helpful. I spoke with a guy who wanted everything included in the calc, accounting fees, lawyers, sale costs, etc. If you include all items that occur during a sale, you take a huge hit to returns. My understanding was always cash = cash after operations, debt, and admin stuff below the line on the income statement, not items that occur during a transaction, which only occurs once (or twice if you refi.)

 
youngunner:
I see. Interesting. So you're saying you see a lot of sponsors or the REIT invest in a different part of the capital stack as a pref equity/participating debt, in addition to the equity?

Okay. So this is helpful. I spoke with a guy who wanted everything included in the calc, accounting fees, lawyers, sale costs, etc. If you include all items that occur during a sale, you take a huge hit to returns. My understanding was always cash = cash after operations, debt, and admin stuff below the line on the income statement, not items that occur during a transaction, which only occurs once (or twice if you refi.)

Yes, equity and sub debt are often interchangeable. Although this can vary, but I've not seen many transactions where the % sub debt owned by an investor differs from the % equity owned. For your cash on cash calc, it doesn't really matter as the mechanics are the same- cash received over cash contributed, regardless of where you sit in the capital structure.

Sub debt, depending on the tax rules in your country, can give a bit of a tax benefit as the cost of the coupon can be a (partially) deductible expense against taxable profits.

Yes, you have to factor in transaction costs to your returns. Take this example:

  • You're acquiring an asset that costs 90, plus you have to pay another 10 to lawyers/accountants/advisors. Your total cost is 100.

  • You finance with 50% senior debt and the rest is equity.

  • In year 1 you receive 5 of distributions. Your cash yield is 5/50 = 10%. It doesn't matter what your accounting profits were, it doesn't matter what cash from operations was, what matters is what you pocket. That is cash on cash.

AB84:
Cash-on-Cash and IRR are different.

I could be wrong, but annual C-o-C excludes capital events proceeds. It only looks at cash flow from operations over your equity contribution.

As far as IRR. The best way to think of it is this: model out every single dollar you invested and received and when you invested and received those dollars.

Well depending on assets, sales of assets or capital event proceeds can be a normal part of owning that portfolio. Therefore any money received from these is a part of your income. However yet again your C-o-C yield looks at what you distribute over what you contribute.

 

Okay. So proceeds from a sale are not 'distributions,' nor are fees taken out of sale proceeds (lawyers at exit for example, or broker sale cost at exit). I think that is what you are saying, which is what I have always thought...

The alternative would be to also count proceeds from sale, which would be a huge coc positive impact.

 

Cash-on-Cash and IRR are different.

I could be wrong, but annual C-o-C excludes capital events proceeds. It only looks at cash flow from operations over your equity contribution.

As far as IRR. The best way to think of it is this: model out every single dollar you invested and received and when you invested and received those dollars.

 

In general, yes, but it's always dependent on how the deal is structured. Assuming you have a preferred return to profit split structure, upon a capital event such as a refinance you would pay off the original debt on the property, then any accrued unpaid preferred return to the investors, then the rest would be a return of capital. You would take the return of capital amount and deduct it from your investor's initial equity amount, which now becomes your new COC denomintor.

 

In general, if you have to put additional capital into the deal, then your denominator (aka equity invested) will increase. As mentioned above, an extraordinary capital event (refinance, sell of 1 parcel of a multi-parcel deal, etc.) will reduce the demonstrator, and therefore increase your cash on cash going forward (given the calculation is now based on the equity outstanding, not your original amount).

As an FYI: if your model is set up monthly, then I would be cautious in what capital you add to your denominator. For example, if you are trying to calculate cash on cash for a stabilized office deal, odds are that on monthly calculations, you will have negative cash balances due to TI & LC payments. However, when looking at this on an annual basis, you very well could be cash flow positive (aka, you would be paying for these TI / LC payments from operational cash flow, NOT a capital call).

 

OK great thanks guys that is exactly what I was looking for - I assume the definition of a "capital event" will need to be defined as per the partnership agreement?

"Average people have great ideas. Legends have great execution"
 

Et et consequatur adipisci. Sunt laudantium accusantium beatae est minus pariatur voluptatem. Accusantium impedit et maiores fugiat.

Est blanditiis explicabo ut nihil recusandae. Nostrum autem temporibus qui laboriosam. Odit quae qui ab consequatur accusamus. Dignissimos magnam sed ex ullam esse. Numquam eligendi repudiandae nisi sunt sint rerum dolore.

Nesciunt dolores error earum et. Dolorem nulla quaerat non iste vel. Cumque consectetur exercitationem omnis veritatis fuga. Quas ea deleniti ipsam consequatur id necessitatibus reiciendis. Ut voluptatum eos in qui dolore. Earum eum eius minus laborum vel quas officia.

Optio ducimus veritatis et soluta. Sit ut est sed labore. Beatae dignissimos nisi sint. At at corrupti aliquam eligendi facilis quae cumque. Cupiditate exercitationem et minus quod necessitatibus iusto.

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 (85) $262
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (65) $168
  • 1st Year Analyst (198) $159
  • Intern/Summer Analyst (143) $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
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
kanon's picture
kanon
98.9
5
Secyh62's picture
Secyh62
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
DrApeman's picture
DrApeman
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...”