Blog · Finance metrics and formulas · Finance and FP&A teams
An optimal leverage ratio depends on cash generation, downside conditions, and the company's own constraints. Use a worked spreadsheet example to compare a proposed debt balance with both earnings and cash-flow limits.
An optimal leverage ratio is a target your company's earnings and cash flow can support under stated conditions. There is no single debt-to-EBITDA multiple that settles the decision. Start with the proposed debt balance, test the downside cash requirements, and make the binding constraints visible before management selects a target.
For this method, leverage means gross funded debt divided by trailing or scenario annual EBITDA. Use the same debt categories and earnings adjustments throughout. The gross leverage ratio covers that measurement boundary; this page focuses on choosing a target from the resulting figures.
Bring a debt schedule with balances, interest terms, scheduled principal, and maturities. Add a scenario workbook containing EBITDA, cash taxes, capital expenditure, working capital investment, and minimum cash requirements. Keep assumptions separate from actual results and identify who approved them.
Earnings are not cash. The SEC's guide to financial statements distinguishes income-statement profit from cash generation and explains the operating, investing, and financing sections of a cash-flow statement. Reconcile the scenario's cash bridge to those records rather than treating EBITDA as spendable funds.
The goal here is a documented management comparison. A senior leverage ratio may use different debt and earnings definitions for an agreement test, so calculate that constraint separately.
Consider a US equipment distributor evaluating $15,000,000 of gross debt for the next annual planning period. Management supplies the assumptions below. The downside reduces EBITDA but keeps necessary investment and scheduled principal payments unchanged.
The simplified interest assumption is 8% of the proposed opening debt for the full year. Scheduled principal is paid at year end, so this convention does not reduce the annual interest calculation. No additional earnings-to-cash adjustments are assumed. Actual monthly balances, variable rates, fees, and maturity payments need a more detailed schedule.
| Spreadsheet row | Input or output | Base, column B | Downside, column C |
|---|---|---|---|
| 2 | EBITDA (USD) | 6,000,000 | 4,500,000 |
| 3 | Proposed opening debt (USD) | 15,000,000 | 15,000,000 |
| 4 | Annual cash interest rate | 8.0% | 8.0% |
| 5 | Cash interest (USD) | 1,200,000 | 1,200,000 |
| 6 | Cash taxes (USD) | 800,000 | 500,000 |
| 7 | Capital expenditure (USD) | 1,000,000 | 1,000,000 |
| 8 | Working capital investment (USD) | 500,000 | 500,000 |
| 9 | Scheduled principal (USD) | 1,000,000 | 1,000,000 |
| 10 | Required annual cash surplus (USD) | 500,000 | 500,000 |
| 11 | Internal opening leverage ceiling | 3.00x | 3.00x |
| 12 | Opening leverage | 2.50x | 3.33x |
| 13 | Cash surplus after debt service (USD) | 1,500,000 | 300,000 |
The 3.00x ceiling and $500,000 required surplus are illustrative management assumptions, not market benchmarks or lender terms. Opening cash is assumed to meet the company's separate minimum balance requirement. The surplus is additional cash generated during the year, not the ending bank balance.
In Excel or Google Sheets, enter these formulas in column B and copy across to C:
B5 = B3*B4
B12 = B3/B2
B13 = B2-SUM(B5:B9)
The downside EBITDA reduction is (6,000,000 - 4,500,000) / 6,000,000 = 25.0%. The cash calculation uses the actual downside values rather than applying that percentage to every outflow.
The proposed debt meets the internal leverage ceiling in the base case but exceeds it in the downside. It also leaves only $300,000 of downside surplus against the stated $500,000 requirement. That gives two separate reasons to revisit the proposed balance.
Debt capacity from leverage = EBITDA × Internal leverage ceiling
Debt capacity from annual cash = (EBITDA - Cash taxes - Capital expenditure - Working capital investment - Scheduled principal - Required surplus) / Cash interest rate
The cash formula holds the principal payment and other inputs fixed. It solves only for the opening debt whose annual interest the scenario can support under those assumptions.
| Capacity test | Base arithmetic (USD) | Base capacity (USD) | Downside capacity (USD) |
|---|---|---|---|
| Leverage | 6,000,000 × 3.00 | 18,000,000 | 4,500,000 × 3.00 = 13,500,000 |
| Cash | (6,000,000 - 800,000 - 1,000,000 - 500,000 - 1,000,000 - 500,000) / 8% | 27,500,000 | (4,500,000 - 500,000 - 1,000,000 - 500,000 - 1,000,000 - 500,000) / 8% = 12,500,000 |
| Lower of the two capacities | 18,000,000 | 12,500,000 |
Add rows 14 through 16 to the worksheet:
B14 = B2*B11
B15 = (B2-SUM(B6:B10))/B4
B16 = MIN(B14:B15)
Copy across. The lower capacity across both scenarios is =MIN(B16:C16), or $12,500,000. Cash is the binding downside constraint, even though the earnings-based calculation allows $13,500,000.
These formulas require a positive interest rate and EBITDA suitable for the comparison. If the cash numerator is negative, flag the scenario as having a cash deficit before interest instead of interpreting a negative capacity as a usable debt target.
Test $12,500,000 as a revised candidate while leaving the stated operating assumptions and scheduled principal unchanged.
| Check | Base | Downside |
|---|---|---|
| Interest: 12,500,000 × 8% (USD) | 1,000,000 | 1,000,000 |
| Opening debt / scenario EBITDA | 2.08x | 2.78x |
| Cash surplus after debt service (USD) | 1,700,000 | 500,000 |
| Required annual surplus (USD) | 500,000 | 500,000 |
The downside identity proves the cash constraint: $4,500,000 EBITDA equals $1,000,000 interest plus $500,000 taxes, $1,000,000 capital expenditure, $500,000 working capital, $1,000,000 principal, and $500,000 surplus. Multiples are rounded to two decimals; capacity calculations use unrounded inputs.
This candidate fits these assumed tests. Management must still assess monthly liquidity, maturities, covenants, and uncertainty before making a financing decision. The OCC and FDIC's December 2025 lending statement likewise emphasizes repayment capacity, projection assumptions, and refinancing risk when describing lenders' review of leveraged borrowers.
Use a clearly dated scenario set. Cadence and recency helps explain why the target should be revisited when actual cash generation or financing terms change.
Bring your financing schedule and scenario workbook to Covirage in a file or Google Sheet. Covirage maps the columns, its tools compute and check the supplied figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for FP&A reporting for the supporting planning workflow.
No. A workable target depends on cash conversion, earnings volatility, interest costs, repayment dates, investment needs, and financing terms. Two businesses with the same debt-to-EBITDA ratio can have very different cash available for debt service.
A covenant limit is a contractual boundary, while an operating target reflects management's chosen room for uncertainty and investment. Evaluate downside earnings and cash requirements before selecting that room. Passing one ratio does not establish compliance with every agreement condition.
EBITDA does not subtract interest, income taxes, capital spending, or working capital investment. These uses compete with principal payments. Build a separate cash bridge and reconcile its assumptions with actual cash-flow records before drawing a financing conclusion.
Treasury and FP&A can prepare the debt and scenario calculations, with accounting validating the inputs. The authorized finance leadership or board owns the decision under the company's governance process. Lenders and agreement reviewers assess the applicable contractual requirements separately.