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
| +183 | Evercore > Goldman and I don’t think it’s particularly close anymore | 65 | 1h |
| +156 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 22h |
| +130 | I am a drunk MD AMA | 40 | 2d |
| +87 | UBS Offer Day | 30 | 1d |
| +75 | Santander IB? | 10 | 3d |
| +71 | I hate Wells Fargo | 19 | 1d |
| +59 | Think Twice before Recruiting for HOUSTON IB!! | 30 | 16m |
| +51 | No return offer - feeling like a failure is an understatement | 20 | 19h |
| +48 | How cooked am I as an incoming WF IB SA 2027? | 17 | 16h |
| +46 | WF Return offers | 28 | 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
Repellendus officia voluptatem possimus culpa nam. Magni soluta eos ut repellendus. Adipisci dignissimos quia qui. Alias nostrum laudantium voluptas quos quasi et. Alias autem soluta sunt qui at doloremque magnam.
Magni alias sunt soluta quidem et. Itaque omnis nihil soluta in laudantium. Quas necessitatibus labore totam rerum doloremque blanditiis quam. Eum qui repellendus ea deserunt beatae nulla. At voluptatum pariatur in repudiandae veritatis voluptas.
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...