# S&P FFO-to-Debt Ratio Analysis for ERG S.P.A. (2022) ## Step 1: Identify the Relevant Industry ERG S.P.A. is an Italian energy company operating primarily in renewable energy generation (wind and solar power), along with some conventional generation assets. Based on the provided industry methodologies, ERG fits into the **"Unregulated Power and Gas"** sector. Key indicators: - Revenue of €713.8 million (2022) - Major EBITDA generation of €499.4 million (reported as "Profit Loss From Operating Activities Before Interest Taxes Depreciation And Amortisation Expense") - Operations across multiple European countries (Italy, France, Germany, UK, Poland, Romania, Bulgaria, Spain) - Renewable energy generation focus - Non-regulated utility operations ## Step 2: Estimate Adjusted_EBITDA **Reconstruct EBITDA from the reported data:** From the income statement for 2022-01-01 to 2023-01-01: - Profit Loss From Operating Activities Before Interest Taxes Depreciation And Amortisation Expense (EBITDA proxy) = €499,430,000 **Identify adjustments required:** 1. **Operating EBITDA (continuing operations):** - Reported EBITDA (continuing operations baseline): €499,430,000 2. **Impairment items:** - Impairment Loss Reversal of Impairment Loss (non-current assets): €43,185,000 (reversal - reduce EBITDA) 3. **Impairment of trade receivables:** - Impairment Loss on Trade Receivables: €300,000 (minor, reduce EBITDA) 4. **Non-recurring items from discontinued operations:** - The company reported significant gains from discontinued operations (€294,131,000) - These should be excluded from normalized EBITDA for credit analysis 5. **Other comprehensive income adjustments:** - Cash flow hedge gains (€360,828,000 pre-tax) are non-cash items already excluded from operating EBITDA - These are captured in fair value adjustments to financial liabilities **Normalized Adjusted_EBITDA:** For continuing operations (most relevant for credit analysis): - Base EBITDA (continuing operations): €499,430,000 - Less: Impairment reversal (non-cash benefit to be excluded): (€43,185,000) - Less: Trade receivable impairment: (€300,000) - **Adjusted_EBITDA = €499,430,000 - €43,185,000 - €300,000 = €455,945,000** Alternatively, using the operating profit approach: - Profit Loss From Operating Activities (continuing): €220,814,000 - Add: Depreciation: €176,689,000 - Add: Amortisation: €58,741,000 - Less: Impairment reversal: (€43,185,000) - Less: Trade receivable impairment: (€300,000) - **Adjusted_EBITDA = €220,814,000 + €176,689,000 + €58,741,000 - €43,185,000 - €300,000 = €412,759,000** **Reconciliation:** There's a difference due to how other income/expenses flow through. Using the more conservative approach that properly accounts for all operating items: **Final Adjusted_EBITDA = €455,945,000** (from continuing operations, normalized) ## Step 3: Estimate FFO (Funds From Operations) **Formula: FFO = Adjusted_EBITDA - Cash_Interest - Cash_Taxes** 1. **Adjusted_EBITDA:** €455,945,000 (from Step 2) 2. **Cash Interest Paid:** - From cash flow statement "Interest Paid Classified As Financing Activities": €29,146,000 - However, total Finance Costs from P&L: €112,195,000 - The difference likely includes non-cash interest accruals and amortization of debt costs - **Cash Interest = €29,146,000** (actual cash paid) 3. **Cash Taxes:** - Income Tax Expense from continuing operations: €97,569,000 - Income Taxes Paid (actual cash): €91,854,000 - **Cash Taxes = €91,854,000** (actual cash paid) **FFO Calculation:** - FFO = €455,945,000 - €29,146,000 - €91,854,000 - **FFO = €334,945,000** ## Step 4: Estimate Adjusted_Debt **Components of Adjusted Debt:** 1. **Reported Debt:** - Noncurrent Financial Liabilities (excluding fair value through P&L): €1,751,255,000 - Current Financial Liabilities (excluding fair value through P&L): €389,716,000 - Total reported debt: €2,140,971,000 2. **Lease Obligations (operating leases - IFRS 16):** - Noncurrent Lease Liabilities: €150,955,000 - Current Lease Liabilities: €6,362,000 - Total lease obligations: €157,317,000 3. **Cash and Cash Equivalents (eligible offsets):** - Cash and Cash Equivalents (2022-01-01): €860,352,000 4. **Fair value through P&L items (debt-like):** - Noncurrent Financial Liabilities at Fair Value Through P&L (2022-01-01): €44,763,000 - Current Financial Liabilities at Fair Value Through P&L (2022-01-01): €170,857,000 - Total: €215,620,000 5. **Pension deficit (if any):** - Noncurrent Provisions for Employee Benefits: €4,289,000 (minor) **Adjusted Debt Calculation:** - Gross Debt = €2,140,971,000 + €157,317,000 + €215,620,000 + €4,289,000 - Gross Debt = €2,518,197,000 - Less: Eligible Cash = (€860,352,000) - **Adjusted_Debt = €1,657,845,000** ## Step 5: Calculate FFO / Adjusted_Debt Ratio **FFO / Adjusted_Debt = €334,945,000 / €1,657,845,000** **FFO / Adjusted_Debt = 0.2020** 0.2020