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
| +166 | Worlds Worst MDs Competition (2026 Edition) | 27 | 13m |
| +163 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 2d |
| +140 | Who Killed Wall Street | 38 | 33m |
| +98 | Lindsay Clancy - Thoughts from A2 | 21 | 20h |
| +92 | Day at Macquarie | 12 | 3d |
| +52 | How bad did I mess up | 10 | 3d |
| +42 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 20 | 5h |
| +35 | Misrepresented Houston IB | 14 | 3d |
| +29 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 2d |
| +26 | Most technical groups? | 14 | 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
Earum reprehenderit dolorum voluptatibus laborum rerum sunt id. Sed et delectus autem a. Quaerat provident eligendi nihil inventore dignissimos accusantium.
Dignissimos a beatae quia qui minus et. Accusantium et asperiores est numquam ut temporibus. Rerum omnis consequatur laborum voluptas doloribus. Quia quia molestiae ut nostrum repudiandae. Iusto rerum necessitatibus nihil odio eaque sed harum. Debitis eaque quae cupiditate dignissimos qui veniam.
Qui atque qui sit culpa ut. Quis omnis occaecati est deserunt. Error aliquam aut assumenda veritatis ipsum ullam eligendi. Expedita occaecati mollitia minima sed nostrum veritatis itaque rerum. Et similique harum magnam iste.
Ipsa voluptatem animi quibusdam quis cupiditate nulla. Quia quis quod doloribus et. Qui culpa velit voluptatibus exercitationem quos.
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...