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
| +273 | Earliest you can get fired | 58 | 1d |
| +254 | Investment Banking is Divine | 40 | 1d |
| +218 | Another $115bn Mega deal for these banks. Congrats! | 45 | 1d |
| +215 | US 2027 SA IB worried about background check | 53 | 1d |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 2d |
| +131 | Is UBS really that bad? | 38 | 1d |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 17h |
| +27 | FIG Pigeonholes you - is it true? | 8 | 1d |
| +27 | 2026-27 IB Energy Top Banks | 8 | 1d |
| +25 | How do you manage nerves in IB technical interviews? | 7 | 1h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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
Ea ut distinctio dolor praesentium fuga eos dolor deleniti. Ut consequatur et ut exercitationem veritatis natus suscipit. Nemo id voluptatem ut laudantium sit et consequatur.
Sed et architecto minus aut. Recusandae pariatur dolores ex vel odit eius.
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...