Leveraged Buyout Debt Paydown Returns Calculator

Purpose and model boundary

This model builds a seven-year operating and four-tranche debt schedule, applies mandatory amortization with an optional cash sweep, and bridges entry sponsor equity to exit gross MOIC and IRR for the selected hold period. It is a synthetic screening model. It does not provide a valuation, financing commitment, credit opinion, solvency opinion, tax conclusion, or investment recommendation.

Inputs and units

All amounts use one user-consistent currency in millions. Entry enterprise value is selected from entry EBITDA and a multiple or entered directly. Exit enterprise value is selected from exit-year EBITDA and a multiple or entered directly. The sponsor hold period is three through seven years.

Operating assumptions are annual EBITDA growth, cash tax rate, depreciation and amortization as a fraction of EBITDA, capital expenditure as a fraction of EBITDA, and change in net working capital as a fraction of EBITDA. The debt-paydown route uses mandatory amortization only or mandatory amortization plus a cash sweep. The sweep allocation follows unique entered priorities or physical grid order.

The fixed grid contains exactly four debt tranches, each with a nonblank label, initial debt, cash interest rate, mandatory-amortization fraction, and sweep priority. It has no activation column, so rows cannot be added or removed in the page. Entry, exit, and sweep fields are shown only when their workbook-authored routes use them.

Governing relationships

Entry enterprise value is:

Entry EV = entry EBITDA × entry multiple

or the directly entered enterprise value. Initial debt is the sum of the four tranche balances.

Sponsor equity contribution = entry EV + transaction fees + retained minimum cash - initial debt

Annual EBITDA compounds from the prior year:

EBITDA_t = EBITDA_(t-1) × (1 + growth)

Depreciation and amortization, capital expenditure, and change in net working capital are their entered fractions times annual EBITDA. Cash interest is calculated on beginning annual tranche debt. Cash taxes apply the entered rate to positive EBIT after cash interest. Mandatory amortization is applied before any cash sweep and cannot reduce a tranche below zero.

When enabled, the sweep applies the entered percentage to available post-interest, post-tax, post-capital-expenditure, post-working-capital, and post-mandatory cash. It repays remaining debt by unique entered priority or by grid order. Each year's ending tranche balance becomes the next year's beginning balance.

Exit enterprise value is exit-year EBITDA times the selected exit multiple or the direct entered exit value.

Exit net debt = ending debt - retained minimum cash

Exit equity value = exit enterprise value - ending debt + retained minimum cash

Total debt paydown = initial debt - ending debt

Gross MOIC = exit equity value / sponsor equity contribution

Gross IRR = Gross MOIC^(1 / hold years) - 1

The IRR formula is appropriate here because this simplified model has one sponsor outflow at entry and one sponsor inflow at exit.

Calculation sequence

1. Validate deal routes, visible entry, exit, and sweep assumptions, operating assumptions, and all four debt rows with unique priorities.
2. Calculate entry enterprise value, total initial debt, sources and uses, and sponsor equity contribution.
3. Compound EBITDA through seven years and calculate annual D&A, EBIT, interest, cash taxes, capital expenditure, and working-capital investment.
4. Apply mandatory amortization and, when selected, the cash sweep to each tranche in the authored order.
5. Select the hold-year EBITDA and ending debt, then calculate exit enterprise and equity value.
6. Calculate debt paydown, MOIC, IRR, minimum interest coverage, the debt-balance chart, and status.

Outputs and interpretation

Primary results show entry enterprise value, initial debt, sponsor equity contribution, exit enterprise and equity value, total debt paydown, gross MOIC, and gross IRR. Supporting results show entry leverage, exit EBITDA and net debt, mandatory and sweep paydown, and minimum interest coverage. The chart displays total debt balance through the selected hold. Returns are gross and exclude interim sponsor cash flows and exit transaction costs.

Validation and status logic

The workbook evaluates status in this order:

There is no CHECK branch. Hidden entry, exit, allocation, and sweep inputs do not affect inactive routes.

Assumptions and limitations

• Entry EV is debt-free and cash-free for the simplified sources-and-uses bridge. Fees and retained minimum cash are additional uses.
• Cash interest uses beginning annual debt. Mandatory amortization precedes the cash sweep.
• Cash taxes use a simplified positive taxable-earnings convention and do not model losses, carryforwards, interest limits, or deferred taxes.
• No full financial statements, revolver, PIK interest, original-issue discount, fee amortization, floating-rate curve, covenant basket, tax attribute, or seasonal working-capital schedule is included.
• Gross returns assume no interim dividends, add-on acquisitions, refinancing proceeds, management rollover, option dilution, or exit fees.
• No leverage threshold, financing availability, repayment target, or credit conclusion is embedded.

Restrictions and non-computing states

The request must retain four complete debt rows. Initial balances cannot be negative, rates must remain within the published limits, and priorities must be the unique integers one through four. Entry EBITDA and the active entry multiple or amount must be positive. Annual EBITDA must remain positive. Sponsor equity contribution must be positive and finite. Unsupported debt roll-forwards, negative exit components, or non-finite return arithmetic do not compute a result.

Errors and warnings

Input checking can reject an unknown route, scalar outside its allowed range, or invalid grid before workbook calculation. Workbook NOT VALID distinguishes input, sources-and-uses, schedule, and exit-return failures. OK confirms internal arithmetic only. A service failure is not a zero return or a debt default state.

Leveraged-lending risk context follows OCC Bulletin 2025-44 and the OCC Comptroller's Handbook on Leveraged Lending. The zero-NPV return identity is also described in the GAO glossary of systems analysis and budgeting terms. No supervisory threshold, lender model, company forecast, transaction data, or source example is embedded.