# S&P FFO-to-Debt Ratio Analysis for REN ## Step 1: Identify the Relevant Industry REN - Redes Energéticas Nacionais is a Portuguese national company that operates energy transmission and distribution networks. Based on the company description and operations, REN falls under the **Regulated Utilities** sector, specifically operating as a multi-utility company with electricity and gas network operations in Portugal. Key indicators: - Operates regulated transmission and distribution networks - Essential infrastructure with limited substitutes - Subject to comprehensive regulation - Geographic focus: Portugal (single regulatory jurisdiction) ## Step 2: Estimate Adjusted_EBITDA **Reconstruct EBITDA from Income Statement (Year ended 2022-01-01 to 2023-01-01):** - Profit from Operating Activities: €239,721,000 - Add: Depreciation and Amortisation Expense: €249,276,000 - **EBITDA = €489,000,000** (approximately) **Adjustments per S&P Guidelines for Regulated Utilities:** 1. **Nonrecurring/One-time Items:** - Energy Sector Extraordinary Contribution: €28,019,000 (add back - tax/regulatory charge) - Changes in Other Provisions: -€2,230,000 (already in operating expenses) - Impairment Loss Reversal: €1,437,000 (add back - nonrecurring) 2. **Lease Adjustments:** - Payments of Lease Liabilities: €2,157,000 (minimal, adjust if material) - No major operating leases identified in the data 3. **Joint Venture/Associates:** - Share of Profit/Loss of Associates: €11,812,000 (already in operating profit, no adjustment needed as proportional consolidation applies) 4. **Pension/Other Items:** - Noncurrent Provisions for Employee Benefits decreased from €94,109,000 to €64,939,000 (favorable change) - This is reflected in operating expenses already **Adjusted_EBITDA Calculation:** ``` EBITDA (reconstructed) €489,000,000 Add: Extraordinary contribution €28,019,000 Add: Impairment reversal €1,437,000 Subtract: Provision changes -€2,230,000 Add: Lease expense (minimal) €2,157,000 ────────────────────────────────── Adjusted_EBITDA €518,383,000 ``` ## Step 3: Estimate FFO **Components:** 1. **Adjusted_EBITDA:** €518,383,000 2. **Cash Interest Paid:** - Interest Paid (Financing Activities): €40,545,000 - Payments of Lease Interests: €26,000 - **Total Cash Interest:** €40,571,000 3. **Cash Taxes Paid:** - Income Taxes Paid/Refund: €77,970,000 - Energy Sector Extraordinary Contribution: €28,019,000 - **Total Cash Taxes:** €105,989,000 **FFO Calculation:** ``` Adjusted_EBITDA €518,383,000 Less: Cash Interest Paid -€40,571,000 Less: Cash Taxes Paid -€105,989,000 ────────────────────────────────── FFO €371,823,000 ``` ## Step 4: Estimate Adjusted_Debt **Components as of 2023-01-01 (fiscal year end 2022):** 1. **Reported Debt:** - Longterm Borrowings: €2,390,852,000 - Current Borrowings: €375,221,000 - **Total Reported Debt:** €2,766,073,000 2. **Lease Obligations:** - Payments of Lease Liabilities (annual): €2,157,000 - Noncurrent lease obligations (estimated): €10,000,000 - **Lease Debt:** ~€12,000,000 3. **Pension Obligations:** - Noncurrent Provisions for Employee Benefits (2022-01-01): €94,109,000 - This represents unfunded/under-funded pension liabilities - **Pension Adjustment:** €94,109,000 4. **Other Debt-Like Items:** - No guarantees or hybrid debt evident - No significant contingent liabilities noted 5. **Less: Eligible Cash:** - Cash and Cash Equivalents (2022-01-01): €398,759,000 **Adjusted_Debt Calculation:** ``` Longterm Borrowings €2,390,852,000 Current Borrowings €375,221,000 Add: Lease Obligations €12,000,000 Add: Pension Deficit €94,109,000 Less: Cash & Equivalents -€398,759,000 ────────────────────────────────── Adjusted_Debt €2,473,423,000 ``` ## Step 5: Calculate FFO / Adjusted_Debt Ratio ``` FFO / Adjusted_Debt = €371,823,000 / €2,473,423,000 = 0.1503 ``` 0.1503