revolver calc (with minimum cash balance)
Could someone give me a formula for a revolver paydown / drawdown that factors in a minimum cash balance?
Thanks, currently using a simple -min for the calculation, but it does not assure a minimum cash balance.
Thanks
do this:
fcf for debt service -min cash balance =net fcf debt service
calculate debt amortization payments
determine revolver (paydown)/borrowing +min cash balance =ending cash balance
This should work:
-min(beginning debt balance, beginning cash balance + FCF - min cash)
great, thanks guys
Nostrum architecto est nobis velit unde illo minus. Deleniti suscipit ut tenetur harum qui hic. Quibusdam iste quis quasi corrupti tenetur magnam placeat quisquam. Et aspernatur reiciendis sed. Porro quasi aut autem tempore ut cupiditate. Dolore iste asperiores totam.
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...