PE Fund Model - Circular Reference???
Building out a private equity fund model and for some reason or another hit a roadblock:
1 - Have to figure out the capital accounts (beg balance, end balance, changes) to calculate management fees, expenses, etc.
2 - The ending annual capital balance is based partly on any return of capital to the GPs or LPs.
3 - However, to calculate the return of capital (first step in the waterfall) you need to model out all the cash flows, fees and expenses).
I maxed out the iterations already but the formulas blow up when I increase the size of the fund (which of course flows through the entire model).
Anyway to get around this inherent circular reference...or am I just retarded?
Thanks for the help guys.
Turn off the automatic iteration, I believe you go to excel options and it's somewhere under calculations. Switch to manual calculation (F9), hope this helps.
What I do is use previous year's outstanding debt to calculate current year interest payment to get rid of the circular reference.
wiggityWACC - Did you ever find a solution for this? I am running into the same problem. So much of the income statement is based on the balance sheet (which also moves continuously), I feel that Excel is reaching it's circular reference / iteration limit. Or I might be retarded. Do you have any advice here? Thanks!
Dignissimos molestiae veniam assumenda expedita vero facere vitae pariatur. Ratione maxime temporibus quia aliquam aut et.
Vitae dolore aliquid qui numquam ad eius eos et. Soluta incidunt unde quia doloremque. Iure inventore maiores sit reiciendis. A ut molestiae atque et accusamus et atque. Dolor et voluptatem rerum. Mollitia aut ullam eum id iste blanditiis.
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...