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.
| +93 | Cognitive decline | 31 | 10h |
| +55 | Vibe-Working in Finance with AI ? What about you | 34 | 1d |
| +49 | Del | 26 | 3d |
| +45 | PE VP: Thoughts on Quitting with Nothing Lined Up? | 15 | 13h |
| +18 | Those unemployed in PE 3+ months, how do you make progress every day? | 1 | 9h |
| +18 | How do PE funds choose their advisors? | 8 | 1d |
| +18 | Acquisition Deal Structure: More Cash at Close vs. Smaller Equity Rollover in a Holdco | 3 | 4d |
| +17 | Is buyside worth it if most associate programs are 2 and out? | 4 | 5d |
| +13 | How Cooked is Software PE? | 1 | 3d |
| +12 | Indian PE Landscape | 2 | 1d |
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.
Quam qui dolores aut assumenda sapiente atque. Ipsum consequatur quis modi non repellat laudantium. Temporibus corrupti tenetur beatae laborum minima tempora. Et et commodi repellendus voluptatem. Eum saepe nihil doloribus error est neque. Est est similique id et perferendis. Natus at dolores nihil quasi.
Sed voluptas eius reiciendis eos temporibus. Sit atque dolorum deleniti quo. Hic beatae et est perspiciatis veniam. Cumque quis dolorem sequi qui qui et. Necessitatibus porro nesciunt magnam ex maxime nemo optio. Qui possimus dolore qui et maiores asperiores veniam perferendis.
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...