Calculator Inputs
Formula Used
Total Uses = Purchase Price + Transaction Fees + Refinanced Debt + Minimum Cash Needed
Estimated New Debt = Total Uses - Sponsor Equity - Rollover Equity - Other Funding Sources
Net Debt Proceeds = New Debt - Original Issue Discount - Financing Fees
Direct Interest = Interest Base × Annual Interest Rate
Monthly Compounded Interest = Beginning Debt × ((1 + Annual Rate / 12)12 - 1)
Scheduled Amortization = Original New Debt × Annual Amortization Percentage
Cash Sweep = Excess Cash After Interest And Amortization × Cash Sweep Percentage
Coverage Ratio = Free Cash Flow Before Debt Service / Total Debt Service
Leverage = Debt Balance / EBITDA
How To Use This Calculator
Enter the transaction uses first. Add purchase price, fees, refinanced debt, and required cash.
Enter funding sources next. Include sponsor equity, rollover equity, and other available sources.
Leave manual new debt as zero when you want the calculator to estimate debt from the funding gap.
Choose the interest method. Average debt balance is often useful for annual LBO schedules.
Add OID, financing fees, amortization, cash sweep, free cash flow, and EBITDA assumptions.
Press the calculate button. Review the result above the form. Export CSV or PDF when needed.
Example Data Table
| Input | Example Value | Purpose |
|---|---|---|
| Purchase Price | $250,000,000 | Acquisition value paid to sellers |
| Sponsor Equity | $95,000,000 | Main equity funding source |
| Rollover Equity | $15,000,000 | Seller or management reinvestment |
| Interest Rate | 10.50% | Annual cash interest cost |
| OID | 1.50% | Discount reducing net proceeds |
| Annual Amortization | 5.00% | Required principal repayment |
| Cash Sweep | 50.00% | Extra repayment from excess cash |
Interest Paid On New Debt In An LBO
Interest on new debt is a core line in every leveraged buyout model. It links purchase price, sponsor equity, lender structure, and expected repayment capacity. A small rate change can move net income, free cash flow, covenant headroom, and investor returns. This calculator gives analysts a fast way to test those moving parts before building a complete transaction model.
Debt Setup And Funding View
The tool can use an entered debt amount or estimate new borrowing from total uses less equity and rollover funding. This helps compare acquisition scenarios when the final commitment papers are not ready. Users can include original issue discount and financing fees, so the model separates gross debt from net proceeds. That distinction is important because fees reduce cash available at close, while interest is usually based on the funded debt balance.
Interest, Repayment, And Cash Sweep
The calculator supports simple annual interest, monthly compounding, and an average debt balance method. Scheduled amortization reduces principal over time. Optional cash sweep repayment can use excess cash flow after interest. This produces a practical view of debt service, ending debt, weighted average interest rate, and coverage. The result is not a replacement for a lender model, but it gives a solid first pass for screening.
Interpreting The Outputs
Focus on the year one burden first. Early periods often carry the highest leverage. If EBITDA growth is delayed, the same debt package can feel tight. Compare cash interest with mandatory amortization. Together they show the minimum cash needed to stay current. Also review the net proceeds gap created by upfront fees and discounts.
Using Results In Deal Review
Review the interest paid beside EBITDA, entry multiple, leverage, and sponsor equity. High interest may still be acceptable when cash flow is stable and repayment is strong. Low interest may still be risky if leverage is excessive or coverage is weak. The best use is sensitivity testing. Change the rate, term, sweep percentage, and amortization assumptions. Then export the results for an investment memo or quick internal comparison. Keep assumptions documented. Lenders and committees often ask why a rate, repayment path, or sweep level was chosen. Clear notes make every scenario easier to defend during review.
FAQs
What does this calculator estimate?
It estimates interest paid on new debt in a leveraged buyout. It also shows amortization, cash sweep repayment, ending debt, coverage, and leverage.
Can I enter debt manually?
Yes. Enter a manual new debt amount when you already know the financing size. Leave it at zero to estimate debt from sources and uses.
What is the average debt balance method?
It calculates interest using the average of beginning debt and debt after scheduled amortization. This is useful for simple annual debt schedules.
How is cash sweep calculated?
The calculator subtracts interest and scheduled amortization from free cash flow. Then it applies the selected sweep percentage to available excess cash.
Does OID reduce interest expense?
No. OID reduces net proceeds at closing. Interest is usually calculated on the funded debt balance, depending on the debt agreement.
What is debt service coverage?
Debt service coverage compares free cash flow before debt service with interest, amortization, and cash sweep. Higher coverage means more repayment capacity.
Can this replace a full LBO model?
No. It is a fast screening tool. A full model should include taxes, working capital, capital expenditures, exit valuation, and sponsor returns.
Why is ending debt important?
Ending debt affects exit equity value and sponsor returns. Lower ending debt can improve returns, but only if repayment does not strain operations.