Calculator Form
Example Data Table
| Input | Example Value | Purpose |
|---|---|---|
| Reported debt | 1,000 | Base debt from statements |
| Annual lease payment | 120 | Used to estimate lease debt |
| Lease rate and term | 6% and 5 years | Used in present value calculation |
| Pension deficit | 80 | Debt-like retirement obligation |
| Hybrid amount and credit | 200 and 50% | Calculates debt portion of hybrid funding |
| Cash offset | 250 at 75% | Reduces adjusted debt by eligible cash |
Overview
S&P adjusted debt is a credit view of obligations. It starts with reported borrowings. It then adds debt like commitments that may not sit in the main debt line. Analysts use the figure to compare issuers on a consistent basis. This calculator gives a structured estimate, not an official rating model. It is useful for planning, internal reviews, lender packs, and scenario work.
Why Adjust Debt
Reported debt can miss important claims. Lease commitments may act like funding. Pension deficits can require future cash. Guarantees can move risk back to the sponsor. Receivables programs may also reduce flexibility. Hybrid instruments may receive only partial equity treatment. By adding these items, the tool shows a wider leverage picture. Cash offsets can also be applied when management keeps excess cash available for debt service.
Formula Used
The core formula is adjusted debt equals reported debt plus lease debt plus pension deficit plus postretirement deficit plus guarantees plus securitized or factored obligations plus the debt portion of hybrids plus joint venture debt, less eligible cash. Lease debt is estimated with a present value factor. The annual lease payment is discounted over the remaining lease term. Hybrid debt is calculated after reducing the amount by its equity credit.
How to Use This Calculator
Enter reported debt first. Add the annual lease payment, discount rate, and lease term. Then enter pension, guarantee, factoring, hybrid, and joint venture adjustments. Choose the equity credit for hybrids. Enter available cash and the percentage allowed as an offset. Add EBITDA, funds from operations, and equity if you want ratios. Press calculate to view the bridge, ratios, and export options.
Interpreting Results
A higher adjusted debt figure usually means more financial risk. The debt bridge explains the change from reported debt to adjusted debt. The leverage ratio shows debt compared with EBITDA. FFO to debt shows internal cash coverage. Debt to capital shows balance sheet pressure. These results should be reviewed with accounting notes, maturity schedules, liquidity sources, and rating methodology guidance. They support discussion, but they do not replace professional judgment. Use every output as an estimate. Test conservative and base cases. Keep notes on assumptions. Update inputs when lease, cash, or funding conditions change. Review sensitivity too.
FAQs
What is adjusted debt?
Adjusted debt is reported debt after adding debt-like obligations and subtracting eligible cash. It gives a broader view of financial commitments.
Is this an official S&P rating model?
No. It is an educational estimate. Actual rating analysis may use detailed methodology rules, analyst judgment, and issuer-specific adjustments.
Why are leases added?
Lease payments can behave like financing. The calculator estimates lease debt by discounting annual payments over the remaining lease term.
How is hybrid debt treated?
The tool subtracts the selected equity credit from the hybrid amount. The remaining amount is treated as debt in the bridge.
Can cash reduce adjusted debt?
Yes. Enter the cash balance and the allowed offset percentage. The calculator subtracts that eligible amount from adjusted debt.
What does adjusted debt to EBITDA show?
It shows how many years of EBITDA would match adjusted debt, before considering taxes, capital spending, interest, and working capital needs.
Why include pension deficits?
Pension deficits may require future funding. Some credit reviews treat them as debt-like claims because they can reduce financial flexibility.
Can I export the result?
Yes. Use the CSV button for spreadsheet data. After calculating, use the PDF button to save the bridge and ratios.