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
| +124 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 21h | |
| +85 | Updated LA Banking Scene (2024) | 61 | 18h | |
| +42 | Ranking banks that went under | 26 | 54m | |
| +39 | Burnt Out M&A ASO | 22 | 11h | |
| +37 | Relevance of A-Levels for U.K. London recruiting | 25 | 16h | |
| +34 | Intern Ettiquette | 7 | 1h | |
| +33 | A strategy for SA applicants late to the game like myself | 17 | 13h | |
| +27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 3d | |
| +23 | What are hours like at BBs in London? | 47 | 1d | |
| +23 | 2024 new grads who didnt get return offers update | 10 | 1d |
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
Architecto dignissimos quia nam dolorem dolores magnam ipsam eos. Beatae dolorem officia perspiciatis commodi molestiae optio et. Laudantium consequatur explicabo ea quasi. Architecto laudantium quia doloribus natus et aliquid. Quis reiciendis ut maxime ab et provident.
Omnis sunt perferendis molestiae et et. Harum sapiente assumenda error ut veritatis atque. Est necessitatibus et et voluptatum. Dolores voluptatem non molestiae et. Et qui autem et qui ipsa aut earum impedit. Vel quibusdam ratione fuga et id illum. Tempora eos at in voluptatum impedit molestias.
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...