Revolver & Cash Sweep

As we covered in Step 6, if the borrower has excess cash and the terms of the debt provide for early repayment at the borrower’s option, the borrower may use excess cash to periodically repay debt ahead of schedule. This is called “cash sweep.” We calculate excess cash as total cash less any minimum cash balance required for operation of the business. The minimum cash balance is a guess, absent further diligence. Then, we compute the total cash available for debt service/repayment as:

  • the excess cash at the beginning of the period, plus
  • cash flow from operating activities in the period, plus
  • cash flow from investing activities in the period, plus
  • cash flow from financing activity related to preferred stock in the period.

From this total cash flow available for debt service we subtract scheduled debt repayment. If this difference is positive, we have more than enough cash to service the debt and can use the excess to pay down the revolver balance or optionally repay other debt early. If the difference is negative, meaning that we have insufficient cash to service the debt, we must draw down (i.e. borrow from) the revolver.

 

Build Financial Models in Minutes

Enterprise-Grade Financial Modeling used by 80,000+ professionals across Investment Banking, Private Equity, and Corporate Finance. Ensure consistency, accuracy, and efficiency across your entire organization.

Note that, as we have set up our formulas for optional debt repayment, senior debt would be repaid before junior debt. You may instead wish to repay more junior, higher cost debt first. Which you choose repay first is a judgment call.

Discover more topics

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more