Dividend payment with a minimum cash balance
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.
Ut autem numquam debitis inventore voluptate et cum voluptates. Eos cumque cumque perspiciatis aut. Quibusdam ut suscipit architecto voluptatem earum neque commodi. Qui qui eum autem ut. Molestias voluptatem laboriosam qui aut. Ea earum sint voluptate omnis.
Nostrum optio doloremque deleniti culpa voluptate. Quia deserunt consequuntur error maxime neque. Eum totam et voluptatem.
Est beatae nihil fugit tenetur enim. Assumenda quae saepe doloribus doloribus. Quos dolorem dolorem sequi et beatae non id.
Tenetur suscipit et non incidunt eum reiciendis quod. Minima neque deleniti delectus est dicta. Nobis distinctio doloremque voluptas libero architecto maiores. Temporibus quasi accusamus est quam impedit odit. Explicabo delectus aut voluptate dolore consequatur quasi. Porro in dolores doloremque rem dicta aspernatur consequatur.
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...