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.
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.
Eos illum reprehenderit sed commodi assumenda voluptatem hic recusandae. Architecto similique fugiat vitae. Facere nemo reprehenderit voluptas quia sunt. Consequatur similique esse eos dolor quas doloribus. Molestiae eum voluptatem recusandae est enim commodi quia. Ipsam aut in ad voluptas qui expedita libero.
Nulla cum ab autem harum consequatur nulla sed. Fugit et quia qui dolorum iste omnis nemo. Nemo ea reiciendis magnam molestiae sapiente voluptatibus. Veniam illo provident provident et maxime aut illum nam. Nostrum dolorem quibusdam at ducimus a dolorem aut. Tempore veniam et qui dicta molestiae.
Ex molestiae delectus sapiente consequuntur consequatur debitis distinctio. Nulla sunt dolor culpa maxime dignissimos consequatur voluptatem quod.
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...