Compounding Pref Question

ChangedMyName's picture
Rank: Orangutan | 313

I have to build a waterfall with monthly periods the goes Pref->ROC->Split->Split. Normally this would be pretty straight forward but the splits have "hurdles" that are "x percentage of total distributions" to GP type of things. Anyways my question is about the Pref accrual calculation.

The LP agreement says 15% per annum compounded quarterly, computed for the actual number of days for which the preferred return is being determined.

I used -(FV((1+EFFECT(15%,4)^(1/365)-1),Current Period-Past Period,0,Beginning Balance)+Beginning Balance

My CFO seems to think this results in compounding monthly and quarterly. Basically doubling up. because the beginning balance is the previous months ending balance which is principal + accrued pref.

Am I doing this correctly? Thanks.

Comments (8)

Jun 28, 2019

Hey ChangedMyName, I'm the WSO Monkey Bot...do any of these help:

  • Answering Why Private Equity- 9 Key Answers land you the job, but the wrong answer will get you dinged. Why Private Equity Career? This section is ... to shed some light on private equity as a career. For information on answering the interview question ... who you are). Interview Question- Why do PE? First, know to keep it brief. Don't go over 45 ...
  • In all seriousness, why do people ask questions that have been answered 1,000 times? are good colleges to attend?" So... can someone provide a legitimate answer as to why people ask ... these same questions that have already been answered on this site or on any search engine at least 50 ... against those who ask redundant questions, i.e. "Is it hard to get a job in IB?" or "What ...
  • Learning Excel- Compounding ask my rookie question and have it answered and hopefully, lead me in the right direction and help me ... Compound Formula Excel ...
  • Answers to "why should we hire you?" question Hey guys, In a few interviews I've been asked "why should we hire you?" or ... "what distinguishes you from the other applicants?" They're tough questions but also pretty ... Obviously, answers will vary tremendously person-to-person, but I'm curious how other people have ...
  • Hedge Fund Guru Answering Inbox Questions Here. Thanks Mr. Pink Money skill sets and mentorship you get early on will materially compound your value over time. Question ... Some of these messages are very old but I'm going to answer them anyway b/c I'm in ... a helpful mood. Question: How would I know what the career path for [this particular hedge fund]? Every fund ...
  • Why Consulting- Answering the Interview Question came here looking for an answer to the interview question, "Why consulting?". First, what not ... operations, economics, and more? That question is of major significance, but it can be answered by looking at ... Why go into consulting instead of the clearly superior investment banking? Don't you travel ...
  • Why Investment Banking? 43 Sample Answers investment banking interview question. The Safe "Why Investment Banking?" Answers Of course, your ... answers and just go with what works. Here is a collection of the best standard responses to the "Why ... Detailed Why IB Answers? While cookie-cutter responses are safe, sometimes a little more substance is ...
  • Interview Question: Why Finance? Sample Answers bank or any other finance company. Why Finance: the best answer to this classic interview question ... 'classic' banking/ finance interview questions. I do have my reasons other than the money for why I want to ... interview questions. Educate yourself on more Finance Interview Questions and Answers Preparing for ...
  • More suggestions...

Hope that helps.

Jul 5, 2019

no, i don't think you're doubling up.

a quick check i always run, assuming you return the equity at some point, is to run a total line item that shows your equity contr plus all your pref months and then finally your ROE...mainly just to run an IRR check to make sure it's flowing correctly.

if your XIRR check = the EFFECT(15%,4) value, then you know your doing it correctly.

    • 1
Jul 5, 2019

Could you please share the entire waterfall structure? Id like to practice some different scenarios and this one sounds interesting.

Jul 8, 2019

dont have it on this desktop...but i posted it to the forum a while back. There were some minor bugs in it as it was posted very late on a weekday unfortunately. However, I think it will more than answer your question posted here.

    • 1
Jul 8, 2019

The one I just finished/am referring to is as follows

  1. 15% Pref on "New Equity"
  2. ROC of "New Equity"
  3. LP/GP 70/30 until LP receives 100% of "Buy-in Equity"
  4. 45%/55% until GP receives 42% of "All Equity Distributions"
  5. 58/42 thereafter

There are a couple other little funky things in there to account for land contributions and such but thats the high level.

Jul 12, 2019

Would love to see your final model excel if you don't mind PMing or posting. I didn't see it on another post.

I do something like this pref structure frequently, but 360 day year quarterly compounding. My LPA isn't clear about actual number of days pref is computed though.

I use the MOD formula to count number of days to say every 90 days, add the quarter of accrued interest to the capital account balance (for calculation, not the equity balance), if not just do simple daily interest method if last period is less than 90 days. Pretty sure I use the DAYS360 formula set to the European method in there somewhere too.

Jul 12, 2019

I don't think you're getting the right interest rate in this function. To get the interest rate, I think you'd just calculate the 15% effective rate at a quarterly compound and divide by 365.

(((1+15%/4)^4)-1)/365

When you raise to a fraction, it means you're discounting, if you go back to actuary formulas.

    • 1
Jul 12, 2019
Comment