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
| +190 | UBS preparing for a October Layoff Massacre | 165 | 11m |
| +67 | Work and Suicide | 30 | 1m |
| +49 | Is 7 years in banking enough to retire, or am I delusional? | 30 | 1h |
| +46 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 28 | 12h |
| +38 | A Message to Students Who Think this Job Will Fix Their Life | 8 | 18m |
| +34 | MM IB --> NYC IB? | 17 | 1d |
| +27 | Should I escape the matrix | 5 | 19h |
| +26 | UBS IB Balance Sheet Set to take a Hit | 7 | 3m |
| +24 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 22 | 1d |
| +23 | LevFin, First Interview (Ever) Help! | 5 | 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
Magnam perferendis omnis voluptatem corrupti sed ea qui eius. Ut commodi doloremque officia est. Expedita ullam minus veritatis sit et autem delectus.
Ducimus animi aut pariatur beatae sapiente quasi. Et amet quod voluptas cum. Id quod est nostrum. Ut necessitatibus in soluta quo. Cumque rerum illo quidem laborum qui inventore consequatur.
Cupiditate ratione eos ad repellendus maiores. Quisquam id hic architecto occaecati aut distinctio. Distinctio cum illum minima aperiam praesentium totam deleniti. Recusandae cumque ipsa qui autem ipsam temporibus.
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...