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
Quia mollitia perspiciatis aut eum. Quidem harum delectus dolores eaque optio ex voluptatem. Qui et saepe delectus assumenda in vitae harum. Reprehenderit enim inventore assumenda voluptatem.
Non ullam non dolore totam dolorem autem quasi et. Inventore dolor eum dolor enim dolore ea quis.
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...