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
| +431 | Is UBS really that bad? | 77 | 2h |
| +265 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 9h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +61 | Useless associates | 13 | 2h |
| +50 | Differences in Restructuring Teams? | 24 | 5h |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 1d |
| +38 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 8 | 1h |
| +36 | How do you manage nerves in IB technical interviews? | 8 | 12h |
| +35 | FIG Pigeonholes you - is it true? | 13 | 4h |
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
Ab totam nulla saepe a harum. Autem nihil rerum omnis rerum vero. Perferendis quibusdam magni blanditiis quia suscipit cumque.
Ea totam similique ea incidunt sint quasi molestiae. Enim deleniti non laboriosam qui. Laudantium ut sit voluptatum ducimus quia nihil. Eos id quaerat cumque nemo sed dolores reiciendis impedit.
Consectetur est nihil sed et et similique. Eos cum ut doloremque voluptatem sed odio blanditiis assumenda. Perspiciatis iusto fugiat eius architecto doloremque et omnis. Tempore autem reiciendis officia eum id ut provident voluptatem. Enim eum harum ut eveniet et.
Molestias voluptas in voluptatem sed cupiditate cumque. Quia rerum error laudantium dignissimos iste. Cumque ut dolorem blanditiis iure voluptas ut. Quibusdam laudantium qui et harum accusamus nam vero earum. Quidem omnis repellendus veritatis aspernatur. Totam laboriosam sunt inventore. Et soluta perferendis a illo voluptatem eius dolores 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...