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
| +142 | Restructuring: Anti-climactic Experience | 38 | 32m |
| +111 | IB Net Worth / Savings Check | 51 | 14h |
| +98 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 25 | 12h |
| +79 | Stop sleeping on UBS - it’s pretty good | 29 | 10h |
| +71 | Hot take: I’d rather be at Desjardins than UBS for investment banking in 2026 | 13 | 5h |
| +56 | 2026 VAULT PRESTIGE RANKINGS | 30 | 1h |
| +39 | AI + Financial Modelling | 12 | 1d |
| +34 | Hardest interview experiences? | 20 | 8h |
| +28 | Summer before college | 18 | 4h |
| +26 | Current State of UBS in North America | 8 | 2d |
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
Nisi ad pariatur minima cupiditate cumque. Fuga repellat nam natus ut. Nemo sed amet non. Reiciendis tempora ab voluptatem vel consequuntur. A inventore quia magnam perspiciatis repellat sunt amet. Nobis ipsa maxime maiores aut nihil consequuntur 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...