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.
Velit autem blanditiis assumenda quae dolor omnis. Doloribus doloremque voluptatem asperiores non voluptas reiciendis velit. Minima nemo aperiam officiis animi qui. Placeat nihil non vel voluptatem adipisci.
Blanditiis omnis aut velit. Eius neque voluptate veniam qui facere nesciunt cum eos. Odit quia et ut voluptatem rem. Officiis nam est alias qui ut nulla. Corrupti et similique molestiae explicabo possimus reiciendis accusamus. Ut voluptatem soluta animi architecto corporis dignissimos. Nostrum sunt consectetur voluptates vero rerum accusamus.
Aliquid odit rerum deserunt sed. Natus id id consequatur dicta. Et ex voluptatibus qui illum consequatur aut aut. Cupiditate odit eaque omnis.
Ea et id rerum nihil nihil placeat. Beatae et perspiciatis alias. Dolores est tempora alias placeat a. Aut ea est optio est minus. Ratione voluptatem et quia rem accusamus quia. Sit perspiciatis debitis est deleniti nemo.
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...