To estimate the S&P-adjusted debt-to-EBITDA ratio for ERG S.p.A. for the fiscal year ended December 31, 2022, we follow the workflow outlined below. ### Step 1: Identify the Relevant Industry ERG S.p.A. is primarily engaged in the production of energy from renewable sources (wind, solar, hydro, etc.). According to the provided text, this falls under the **"Unregulated Power And Gas"** sector, specifically as a renewable generation company. The text states: "Unregulated power and gas companies, such as renewable generation companies, don't benefit from protective rate regulation... We assess competitive advantage in the unregulated power and gas sector..." Therefore, we apply the **Unregulated Power And Gas** methodology. Key considerations from this section include: * **Volatility Table:** Unless the company derives a significant proportion of cash flow from regulated activities or strongly protected unregulated revenue (meeting specific thresholds), the **standard volatility table** applies. ERG operates in multiple European markets with a mix of merchant and contracted revenues. Without specific evidence that >50% of cash flows are from regulated/strongly protected sources meeting the strict criteria (CICRA, etc.), we assume the standard baseline adjustments apply, focusing on the core definition of Debt and EBITDA. * **Adjustments:** The methodology mentions adjustments for long-term PPAs (similar to regulated utilities) but does not provide specific data to quantify off-balance-sheet PPA debt-like obligations in the provided facts. We will stick to the reported financials adjusted for standard S&P corporate methodology items (Leases, Cash, Non-recurring items). ### Step 2: Estimate Adjusted Debt The baseline formula is: `Adjusted_Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash` **1. Reported Debt:** We identify interest-bearing financial liabilities from the balance sheet items provided for 2022-01-01 (Start of period) and 2023-01-01 (End of period). S&P typically uses the average debt or the year-end debt depending on the specific rating context, but for a single year snapshot ratio, year-end is standard unless averaging is specified. However, looking at the cash flow statement, there was significant debt repayment. Let's look at the components at **2023-01-01** (which represents the balance sheet date for the fiscal year ended Dec 31, 2022). * `Noncurrent Financial Liabilities At Fair Value Through Profit Or Loss`: 0.0 EUR * `Other Noncurrent Financial Liabilities`: 1,751,255,000.0 EUR * `Noncurrent Lease Liabilities`: 150,955,000.0 EUR * `Current Financial Liabilities At Fair Value Through Profit Or Loss`: 76,644,000.0 EUR * `Other Current Financial Liabilities`: 389,716,000.0 EUR * `Current Lease Liabilities`: 6,362,000.0 EUR Total Reported Interest-Bearing Debt (Gross) = 1,751,255,000 + 150,955,000 + 76,644,000 + 389,716,000 + 6,362,000 = **2,374,932,000 EUR**. *Note: "Other Current Financial Liabilities" and "Other Noncurrent Financial Liabilities" typically contain bank loans, bonds, and other borrowings. We assume these are all debt-like.* **2. Leases:** S&P treats lease liabilities as debt. These are already included in the sum above (`Noncurrent Lease Liabilities` and `Current Lease Liabilities`). So, no additional add-back is needed if we sum all financial liabilities including leases. **3. Pension Deficit:** The balance sheet shows `Noncurrent Provisions For Employee Benefits` of 3,723,000 EUR. S&P adjusts for the underfunded status of defined benefit plans. The OCI shows `Gains Losses On Remeasurements Of Defined Benefit Plans` of 163,000 EUR (pre-tax). Without a detailed actuarial valuation, we often use the provision on the balance sheet as a proxy for the net liability or check if there's a specific "net pension liability" disclosed. Given the small magnitude relative to debt, and lacking specific "deficit" vs "asset" breakdown beyond the provision, we will treat the provision as the liability. However, standard S&P adjustment adds the *underfunded* amount. If the provision represents the recognized liability, and there are no plan assets netted against it in that line item, it is the deficit. Let's assume the provision of ~3.7M is the net liability. It is small. We will include it. Pension Deficit ≈ **3,723,000 EUR**. **4. Eligible Cash:** S&P deducts unrestricted cash and cash equivalents. `Cash And Cash Equivalents` (2023-01-01): **392,811,000 EUR**. There are also `Current Financial Assets At Fair Value Through Profit Or Loss` (141,568,000 EUR) and `Other Current Financial Assets` (211,136,000 EUR). S&P may deduct liquid marketable securities if they are unrestricted and not needed for operations. However, the strict baseline formula usually specifies "eligible cash". We will deduct Cash and Cash Equivalents. We will also check if the other financial assets are "cash-like". Given the volatility of FVTPL assets, they are often not fully deducted or only partially. To be conservative and stick to the standard "Cash" definition in the prompt's baseline formula, we deduct Cash and Cash Equivalents. Eligible Cash = **392,811,000 EUR**. **Calculation of Adjusted Debt:** Adjusted Debt = (Total Interest Bearing Debt + Pension Deficit) - Eligible Cash Total Interest Bearing Debt = 2,374,932,000 EUR Pension Deficit = 3,723,000 EUR Gross Adjusted Debt = 2,378,655,000 EUR Less Eligible Cash = 392,811,000 EUR **Adjusted Debt = 1,985,844,000 EUR** *(Self-Correction/Refinement: Sometimes S&P uses average debt. Let's check if the prompt implies average. It asks for the ratio for 2022. Usually, if not specified, year-end is used for the denominator's matching period or average for the balance sheet items against flow items. However, for simplicity and standard single-point estimation from annual reports without explicit instruction to average, year-end is common. Let's stick with Year-End 2022 (Jan 1, 2023 values).)* ### Step 3: Estimate Adjusted EBITDA The baseline formula is: `Adjusted_EBITDA = EBITDA + adjustment_leases + nonrecurring_losses - nonrecurring_gains ± other_normalization_adjustments` **1. Reported EBITDA:** The report provides `Profit Loss From Operating Activities Before Interest Taxes Depreciation And Amortisation Expense` for 2022. Value: **499,430,000 EUR**. This is the standard EBITDA. **2. Adjustments:** * **Leases:** Under IFRS 16, EBITDA is typically already adjusted because lease depreciation and interest are below the EBITDA line (or rather, the lease expense is split into depreciation and interest, so adding back D&A adds back the lease depreciation). The provided EBITDA figure is "Before Interest Taxes Depreciation and Amortisation". Since IFRS 16 lease costs are largely depreciation (and interest), this EBITDA figure effectively adds back the lease depreciation. No further add-back for leases is typically required for EBITDA itself unless there are operating lease expenses in "Services Expense" from pre-IFRS 16 logic, but ERG reports under IFRS. The `Rightofuse Assets` and `Lease Liabilities` confirm IFRS 16 application. The EBITDA provided is the standard starting point. * **Non-recurring Items:** We need to identify non-recurring gains/losses. * `Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss Intangible Assets And Property Plant And Equipment`: **43,185,000 EUR**. This is a gain (reversal of loss). It increased EBITDA (or rather, reduced the impairment expense, but wait: Impairment losses are typically *below* EBITDA or added back to get to EBITDA? * Standard EBITDA calculation: Operating Profit + Depreciation + Amortization + Impairment Losses - Impairment Reversals. * The line item is `Profit Loss From Operating Activities Before Interest Taxes Depreciation And Amortisation Expense`. Does this include impairment reversals? * Usually, "EBITDA" as reported by companies often adds back impairment losses. If the reported figure is strictly "Operating Profit before D&A", it might *include* the impact of impairments/reversals if they are considered operating. * Let's check the reconciliation. * Operating Profit (EBIT) = 220,814,000. * Depreciation = 176,689,000. * Amortization = 58,741,000. * Sum = 220,814,000 + 176,689,000 + 58,741,000 = 456,244,000. * The reported "Profit Loss From Operating Activities Before Interest Taxes Depreciation And Amortisation Expense" is **499,430,000**. * Difference = 499,430,000 - 456,244,000 = **43,186,000**. * This difference matches the `Impairment Loss Reversal...` of **43,185,000** (rounding diff). * This implies the reported EBITDA figure **includes** the benefit of the impairment reversal. * S&P methodology typically **excludes** non-recurring gains like impairment reversals from Adjusted EBITDA. Therefore, we must **subtract** this reversal. * `Impairment Loss Recognised In Profit Or Loss Trade Receivables`: 300,000 EUR. This is likely included in operating expenses above EBITDA? No, trade receivable impairments are usually operating expenses. If they are above EBITDA, they reduce EBITDA. Are they non-recurring? 300k is small and likely recurring/normal business risk. We will leave it. * `Share Of Profit Loss Of Associates...`: 2,294,000 EUR. This is equity income, typically below EBITDA. Not included in the EBITDA line provided. * `Profit Loss From Discontinued Operations`: 294,131,000 EUR. This is below Operating Profit. Not in EBITDA. * Are there other non-recurring items? * The cash flow statement shows `Other Adjustments For Noncash Items` of -198,570,000. This is large. Let's look at the components. * The large positive cash flow from discontinued operations suggests the sale of assets. * The `Impairment Loss Reversal` is the main identifiable non-recurring item embedded in the EBITDA line. * S&P also adjusts for "non-recurring losses". There are no significant non-recurring losses listed in the P&L items provided that are above the EBITDA line. The `Impairment Loss Recognised In Profit Or Loss Trade Receivables` is small. * What about the `Finance Income` of 75,622,000? This is below EBITDA. * What about the `Profit Loss From Discontinued Operations`? This is excluded from Continuing Operations EBITDA. The EBITDA figure provided (`Profit Loss From Operating Activities Before Interest Taxes Depreciation And Amortisation Expense`) is typically from Continuing Operations. The label doesn't explicitly say "Continuing", but "Operating Activities" usually aligns with continuing ops in this context, especially since Discontinued Ops are shown separately in Net Income. We assume the EBITDA figure relates to continuing operations. * **Adjustment for Impairment Reversal:** The reported EBITDA (499,430,000) includes a 43,185,000 gain from impairment reversal. Adjusted EBITDA = Reported EBITDA - Non-recurring Gains Adjusted EBITDA = 499,430,000 - 43,185,000 = **456,245,000 EUR**. * **Other Adjustments:** * **Pension:** S&P may adjust EBITDA for pension costs, replacing reported expense with a normalized service cost. The `Employee Benefits Expense` is 54,808,000. The `Adjustments For Increase Decrease In Employee Benefit Liabilities` in cash flow is 66,000. This is negligible. We will not make a significant pension adjustment to EBITDA without more data. * **Joint Ventures:** Share of profit is 2,294,000. S&P often adds back the proportionate EBITDA of JVs if they are equity accounted. However, the share of profit is net of tax and interest. We don't have the JV's EBITDA. Given the small amount (2.3M), the impact is minimal. We will ignore this proportional add-back due to lack of data, or assume it's immaterial. * **Discontinued Operations:** The EBITDA figure likely excludes discontinued ops. If it included them, we would subtract them. Given the label "Operating Activities", and the separate disclosure of Discontinued Ops profit, it is standard that the Operating Profit (and thus EBITDA) excludes discontinued ops. * **Final Adjusted EBITDA:** **456,245,000 EUR**. ### Step 4: Calculate the Ratio Adjusted Debt = 1,985,844,000 EUR Adjusted EBITDA = 456,245,000 EUR Ratio = Adjusted Debt / Adjusted EBITDA Ratio = 1,985,844,000 / 456,245,000 Ratio ≈ 4.3525 Let's double check the Debt calculation. Did we miss any debt? `Noncurrent Financial Liabilities At Fair Value Through Profit Or Loss`: 0 `Other Noncurrent Financial Liabilities`: 1,751,255,000 `Noncurrent Lease Liabilities`: 150,955,000 `Current Financial Liabilities At Fair Value Through Profit Or Loss`: 76,644,000 `Other Current Financial Liabilities`: 389,716,000 `Current Lease Liabilities`: 6,362,000 Sum = 1,751,255,000 + 150,955,000 + 76,644,000 + 389,716,000 + 6,362,000 = 2,374,932,000. Cash = 392,811,000. Net Debt = 2,374,932,000 - 392,811,000 = 1,982,121,000. Add Pension Deficit: 3,723,000. Total Adjusted Debt = 1,985,844,000. Let's double check the EBITDA calculation. Reported EBITDA: 499,430,000. Less Impairment Reversal (Non-recurring gain): 43,185,000. Adjusted EBITDA: 456,245,000. Ratio: 1,985,844,000 / 456,245,000 = 4.35258... Rounding to two decimal places: **4.35**. One consideration: Does S&P deduct *all* cash? "Eligible cash". Usually, unrestricted cash is deducted. There is no indication of restricted cash. Another consideration: Average Debt? If we used Average Debt: Debt 2021 (Jan 1, 2022): `Other Noncurrent Financial Liabilities`: 2,064,088,000 `Noncurrent Lease Liabilities`: 122,663,000 `Noncurrent Financial Liabilities FVTPL`: 44,763,000 `Current Financial Liabilities FVTPL`: 170,857,000 `Other Current Financial Liabilities`: 1,342,688,000 `Current Lease Liabilities`: 6,282,000 Total Debt 2021 = 2,064,088,000 + 122,663,000 + 44,763,000 + 170,857,000 + 1,342,688,000 + 6,282,000 = 3,751,341,000. Cash 2021 = 860,352,000. Net Debt 2021 = 3,751,341,000 - 860,352,000 + Pension (4,289,000) = 2,895,278,000. Average Debt = (1,985,844,000 + 2,895,278,000) / 2 = 2,440,561,000. Average Ratio = 2,440,561,000 / 456,245,000 = 5.35. However, standard "Debt-to-EBITDA" ratios in many contexts (and unless "Average" is specified) often use the year-end debt position for the most recent fiscal year to reflect the current leverage profile, especially after significant deleveraging events (like the debt repayment seen in 2022). The prompt asks to "estimate the... ratio for 2022". In S&P ratings, they often look at the current position. Given the significant drop in debt during 2022 (from ~3.75B to ~2.37B gross), the year-end figure is more representative of the ongoing capital structure. We will use the year-end figure. Final Check on EBITDA Adjustments: Are there any other non-recurring items? `Other Income`: 12,678,000. This is likely recurring. `Other Purchase Expense`: 15,188,000. Likely recurring. `Impairment Loss Recognised In Profit Or Loss Trade Receivables`: 300,000. Small, likely recurring. `Share Of Profit...`: 2,294,000. Below EBITDA. The impairment reversal of 43.185M is the key adjustment. Result: 4.35. 4.35