I am trying to build a three statement model and DCF. I would like Excel to ensure that the cash balance over all n-periods remains with minimum 2 million cash balance but all excess cash that could be distributed is actually distributed.
When I attempt this issue, I always end up with circular references.
Does anyone have an idea?Thanks.
| +86 | Sr Asso / VP Unemployment Check-in | 52 | 1h | |
| +30 | What did you do after signing? | 10 | 11h | |
| +26 | VP Level - when to follow up after final round | 10 | 3d | |
| +24 | Resume Gap after 2.5 Years in PE | 5 | 17h | |
| +21 | Public company LBO | 7 | 1d | |
| +20 | Vista Lateral Associate | 12 | 2d | |
| +18 | VP HF Lateral to PE | 1 | 1d | |
| +18 | PE Recruiting From IB- Play It Safe Or Reach For Best Fund Possible? | 6 | 10h | |
| +16 | Banner Ridge | 27 | 1d | |
| +16 | IB/PE Lifers, Was It Worth It? | 5 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Quick fix: circ ref should be in 1. interest payments/received. If you link those to cash/debt amounts of last year, your circ ref should be resolved. 2. Circ ref in cash minimum of 2m you might want to solve by splitting cash on balance sheet in trapped cash (2.0m) and cash that corresponds with the RCF. The 2m is fixed amount, the rest flows through.
Thank you.
Ullam voluptatum est ea. Magni et quo qui ratione et consequatur qui. Possimus beatae non veritatis autem iure voluptatibus sed. Et dolore cum voluptatibus iste temporibus. Quae nesciunt dolores eum perferendis. Voluptates dolor quia est dolore corporis.
Doloremque eos amet et dolorem est repellendus alias. Placeat blanditiis exercitationem consequuntur quasi perferendis repellat vitae aut. Architecto sunt repudiandae expedita libero inventore earum sit. Rerum repellendus maiores sint earum. Et voluptatum deserunt a culpa eveniet dicta accusamus deserunt. Qui eaque aliquam est ad mollitia recusandae.
Architecto occaecati molestiae ducimus velit dolor. Est quas earum sit beatae doloribus. Eveniet error vitae est fuga cumque. Quidem et ut ipsum.
Odio quia et dolore sunt odit. Architecto minima molestias officiis pariatur harum. Dolorum doloribus ab fugit praesentium.
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...