| ← Cover Page | ||||||
| 15. PRO FORMA DEBT SCHEDULE | ||||||
| ($ in millions) | ||||||
| FY2026E | FY2027E | FY2028E | FY2029E | FY2030E | ||
| TERM LOAN A | ||||||
| Beginning Balance | $2,000 | $1,900 | $1,800 | $1,700 | $1,600 | |
| Amortization | ($100) | ($100) | ($100) | ($100) | ($100) | |
| Ending Balance | $1,900 | $1,800 | $1,700 | $1,600 | $1,500 | |
| Interest Expense | ($107) | ($102) | ($96) | ($91) | ($85) | |
| TERM LOAN B | ||||||
| Beginning Balance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Amortization (Bullet - no amort.) | - | - | - | - | - | |
| Ending Balance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Interest Expense | ($98) | ($98) | ($98) | ($98) | ($98) | |
| TOTAL NEW DEBT SUMMARY | ||||||
| Total Beginning Debt | $3,500 | $3,400 | $3,300 | $3,200 | $3,100 | |
| Total Amortization | ($100) | ($100) | ($100) | ($100) | ($100) | |
| Total Ending Debt | $3,400 | $3,300 | $3,200 | $3,100 | $3,000 | |
| Total Interest Expense (New Debt) | ($205) | ($199) | ($194) | ($188) | ($183) | |
| CREDIT METRICS | ||||||
| Pro Forma EBITDA | $4,271 | $4,828 | $5,439 | $5,979 | $6,454 | |
| Total Debt / EBITDA | 1.5x | 1.3x | 1.1x | 1.0x | 0.9x | |
| Interest Coverage (EBITDA / Interest) | 20.9x | 24.2x | 28.1x | 31.8x | 35.3x | |
| Note: Term Loan A amortizes at 5% per year. Term Loan B is a bullet maturity (no amortization). Interest calculated on average balance. Source: Financing term sheet, indicative rates. | ||||||