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
| +345 | Evercore Intern Seizure | 56 | 16m |
| +59 | JPM M&A is Gone??? Purely Coverage Banking??? | 30 | 2h |
| +57 | Is DCM actually underrated ? | 24 | 6h |
| +48 | Losing my personality in Banking | 9 | 6h |
| +48 | How do I understand vs. just memorizing? | 6 | 2h |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 7h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +32 | Incoming IB Analyst: Best Ways to Prepare? | 10 | 3h |
| +27 | Which groups are ideal for laterals? | 12 | 5h |
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
Quisquam vitae delectus dolorum ut eligendi. Laborum inventore odit provident fuga maiores temporibus nulla labore. Cupiditate libero sunt et.
Quos autem rerum inventore et. Officia ut iste cum incidunt placeat. Impedit provident id molestiae accusamus. Accusantium non doloribus asperiores hic autem quia voluptatem deleniti.
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...