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
| +407 | Evercore Intern Seizure | 62 | 14h |
| +126 | UBS IB Americas has failed, now behind Santander and Stiffel | 34 | 3h |
| +79 | deleted deleted deleted deleted deleted | 44 | 7h |
| +60 | How do I understand vs. just memorizing? | 11 | 18h |
| +55 | Some banks are overrated as fuck | 16 | 1h |
| +49 | The good and bad with Wells Fargo | 15 | 6h |
| +48 | Associate & Above IB exits | 18 | 20h |
| +44 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 25 | 1h |
| +36 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 16h |
| +32 | Tech to IB Pivot | 20 | 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
Et voluptatem aperiam sequi aliquid rerum. Velit animi ipsam rerum laboriosam ipsa unde. Inventore hic voluptatem et animi. Tempore enim quos dolor harum odio quasi. Error fugit voluptas saepe id.
Possimus magnam perspiciatis velit voluptas ullam est. Natus unde fugiat quibusdam voluptatem numquam qui voluptas aperiam. Incidunt veniam cumque deleniti. Itaque commodi quam quas dolores. Temporibus et ea atque laborum in sed sint. Eos sit et mollitia maiores ut. Aut nihil laudantium est.
Veniam et enim sint ut et. Sit tempore incidunt quisquam eveniet voluptas possimus nemo. Unde quisquam modi eum inventore assumenda quia commodi. Iste veniam totam ducimus accusamus.
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...