# Workflow Execution ## Step 1: Identify the Relevant Industry **Analysis:** Naturgy Energy Group SA is a multi-utilities company based in Spain that operates in: - Electricity generation and distribution - Natural gas distribution and supply - Water utilities - Renewable energy The company operates primarily under regulated frameworks in Spain and other jurisdictions, with significant regulated utility operations. The methodology section identifies "Regulated Utilities" as the applicable framework for utilities providing electricity, gas, water, and related services. **Conclusion:** Apply the **Regulated Utilities** industry methodology from S&P guidelines. --- ## Step 2: Estimate Adjusted_EBITDA (2022 FY) **From the financial statements (2021-01-01 to 2022-01-01):** - EBITDA (Beneficio Bruto De Explotacion Ebitda): **3,529,000,000 EUR** - Amortization and impairment (Amortizacion Y Perdidas Por Deterioro): 1,462,000,000 EUR - Operating profit: 2,101,000,000 EUR **Adjustments per S&P Regulated Utilities methodology:** 1. **Lease Adjustments:** - Current lease liabilities (2022-01-01): 196,000,000 EUR - Non-current lease liabilities (2022-01-01): 1,325,000,000 EUR - Total lease obligations: 1,521,000,000 EUR - Operating lease rent adjustment (S&P converts operating leases to debt-like): ~80% of total leases for debt treatment = 1,217,000,000 EUR - Lease impact on EBITDA: ~100 basis points adjustment ≈ 35,290,000 EUR (conservative estimate of operating lease rental normalized) 2. **Non-recurring items:** - Gains on disposals of PP&E: 5,000,000 EUR (exclude from EBITDA) - Other gains/losses (2021-2022): 133,000,000 EUR (one-time favorable item) - Allowance for credit losses: -99,000,000 EUR (one-time unfavorable) Net non-recurring adjustment: -99,000,000 + 5,000,000 = -94,000,000 EUR (reduce EBITDA) 3. **Pension adjustments:** Not material based on disclosed deferred tax assets/liabilities (minimal pension volatility evident) 4. **Joint venture/associate proportional adjustments:** The company has associates (656,000,000 EUR investment) but these are relatively immaterial to total operations. **Calculated Adjusted_EBITDA (2022):** Adjusted_EBITDA = 3,529,000,000 + 35,290,000 - (-94,000,000) **Adjusted_EBITDA = 3,658,290,000 EUR** --- ## Step 3: Estimate FFO (2022 FY) **Components:** From cash flow statement (2021-01-01 to 2022-01-01): - Interest Paid (operating activities): 488,000,000 EUR - Income Taxes Paid (operating activities): 864,000,000 EUR - Cash from operating activities: 1,001,000,000 EUR **FFO Calculation:** FFO = Adjusted_EBITDA - Cash_Interest - Cash_Taxes FFO = 3,658,290,000 - 488,000,000 - 864,000,000 **FFO = 2,306,290,000 EUR** --- ## Step 4: Estimate Adjusted_Debt (2022 FY) **Components from Balance Sheet (2022-01-01):** 1. **Reported Debt:** - Long-term borrowings: 13,786,000,000 EUR - Current portion of borrowings: 1,493,000,000 EUR - Total financial debt: 15,279,000,000 EUR 2. **Lease Obligations (add back):** - Current lease liabilities: 196,000,000 EUR - Non-current lease liabilities: 1,325,000,000 EUR - Total operating lease liabilities: 1,521,000,000 EUR 3. **Pension Deficit:** - Deferred tax assets: 2,267,000,000 EUR (suggests some pension liabilities) - Deferred tax liabilities: 1,787,000,000 EUR - Net DTA indicates minor pension obligations, estimated at ~50,000,000 EUR 4. **Other debt-like items:** - Current derivative liabilities (Pasivo Derivados Corriente): 2,704,000,000 EUR - Non-current derivative liabilities: 730,000,000 EUR - S&P treatment: Derivatives embedded in debt contracts are often excluded, but material commodity hedges on revenues may add ~30-40% = ~1,088,000,000 EUR (conservative inclusion) 5. **Guarantees and Hybrid Debt:** None identified as material. 6. **Less: Eligible Cash:** - Cash and cash equivalents (2022-01-01): 3,965,000,000 EUR **Adjusted_Debt Calculation:** Adjusted_Debt = 15,279,000,000 + 1,521,000,000 + 50,000,000 + 1,088,000,000 - 3,965,000,000 **Adjusted_Debt = 13,973,000,000 EUR** --- ## Step 5: Calculate FFO / Adjusted_Debt Ratio **Ratio Calculation:** FFO / Adjusted_Debt = 2,306,290,000 / 13,973,000,000 FFO / Adjusted_Debt = **0.1650** --- 0.1650