To estimate the Net Debt / EBITDA ratio for Hera S.p.A. for the year 2022 (period 2022-01-01 to 2023-01-01) using the S&P methodology, we need to calculate two components: Adjusted EBITDA and Net Debt. **1. Calculate Adjusted EBITDA** S&P Global Ratings typically defines EBITDA as Profit from Operating Activities plus Depreciation, Amortization, and Impairment. Sometimes it starts from Net Income and adds back Interest, Taxes, Depreciation, and Amortization. Given the data provided, we can derive EBITDA from the Operating Profit or by summing up the relevant expense items. * **Profit Loss From Operating Activities (EBIT):** 533,800,000 EUR * **Amortisation Depreciation And Provisions:** 667,100,000 EUR Standard EBITDA = EBIT + Depreciation & Amortization EBITDA = 533,800,000 + 667,100,000 = 1,200,900,000 EUR Let's verify this using the "Cash Flows From Used In Operations Before Changes In Working Capital" line item, which is often a close proxy for EBITDA adjusted for working capital movements and other non-cash items, but S&P usually starts with EBITDA defined as EBIT + D&A. Another check: Revenue: 20,082,000,000 Less: Raw Materials: 16,730,000,000 Less: Services Expense: 2,105,800,000 Less: Employee Benefits: 601,100,000 Less: Other Expense: 74,900,000 Add: Other Work Capitalised: 82,500,000 Add: Other Revenue: 548,200,000 Operating Profit before D&A = 20,082 + 548.2 + 82.5 - 16,730 - 2,105.8 - 601.1 - 74.9 = 1,200.9 million EUR. This matches the EBIT + D&A calculation (533.8 + 667.1 = 1,200.9). So, **EBITDA = 1,200,900,000 EUR**. *Note on S&P Adjustments:* S&P often adjusts EBITDA for non-recurring items, share-based compensation, etc. The provided data does not explicitly list significant non-recurring adjustments to strip out, so we will use the calculated EBITDA. The "Adjustments For Depreciation And Amortisation Expense..." in the cash flow statement is 478,600,000, which differs from the P&L D&A of 667,100,000. This difference is likely due to provisions included in the P&L line "Amortisation Depreciation And Provisions" but handled differently in cash flows, or capitalization differences. However, EBITDA is an earnings metric, so we use the P&L figure for D&A. The P&L line is "Amortisation Depreciation And Provisions". Usually, EBITDA adds back D&A. Provisions are non-cash but often excluded from EBITDA if they are considered operating expenses, or included if they are part of the standard add-back. S&P generally adds back depreciation and amortization. If "Provisions" are included in that 667.1M line, we should be careful. However, without a breakdown, the standard proxy is EBIT + D&A from the income statement. Let's stick with 1,200.9M. **2. Calculate Net Debt** S&P defines Net Debt as Total Debt minus Cash and Cash Equivalents (and sometimes short-term investments). Total Debt includes short-term and long-term interest-bearing debt. From the Balance Sheet (2023-01-01, which represents the end of the 2022 fiscal year): * **Debt Components:** * Noncurrent Financial Liabilities: 5,689,900,000 EUR * Noncurrent Lease Liabilities: 55,100,000 EUR * Current Financial Liabilities: 650,100,000 EUR * Current Lease Liabilities: 21,300,000 EUR *S&P Methodology on Leases:* S&P typically treats lease liabilities as debt. Therefore, we include both financial and lease liabilities. Total Debt = Noncurrent Financial Liab + Noncurrent Lease Liab + Current Financial Liab + Current Lease Liab Total Debt = 5,689,900,000 + 55,100,000 + 650,100,000 + 21,300,000 Total Debt = 6,416,400,000 EUR * **Cash and Equivalents:** * Cash And Cash Equivalents: 1,942,400,000 EUR *Note on Derivatives:* S&P may adjust net debt for cash flow hedges or derivative positions, but standard Net Debt is Gross Debt minus Cash. The "Current Derivative Financial Assets" and "Liabilities" are large (1.6B and 1.3B), but these are typically marked-to-market hedging instruments. Unless specified as part of debt, they are usually excluded from the core Net Debt calculation, or netted if they are integral to the debt structure. Given the standard definition, we exclude them from the debt principal but note that cash is just "Cash And Cash Equivalents". Net Debt = Total Debt - Cash and Cash Equivalents Net Debt = 6,416,400,000 - 1,942,400,000 Net Debt = 4,474,000,000 EUR **3. Calculate Ratio** Net Debt / EBITDA = 4,474,000,000 / 1,200,900,000 Calculation: 4,474 / 1,200.9 ≈ 3.7255 Let's double-check the components. Is "Other Current Liabilities" or "Trade Payables" considered debt? No, these are operating liabilities. Is "Noncurrent Provisions" debt? No. Are there any other debt-like items? "Current Financial Assets" (77.7M) could be netted against debt in some strict liquidity calculations, but S&P Net Debt usually just subtracts Cash & Equivalents. Sometimes short-term investments are included in the cash deduction. "Current Financial Assets" are likely short-term investments. If we deduct them as well: Adjusted Cash = 1,942.4 + 77.7 = 2,020.1 M Net Debt = 6,416.4 - 2,020.1 = 4,396.3 M Ratio = 4,396.3 / 1,200.9 ≈ 3.66 However, the most standard "Net Debt" definition is Interest Bearing Debt minus Cash and Cash Equivalents. Let's look at the "Financial Liabilities" lines again. Noncurrent Financial Liabilities: 5,689.9 Current Financial Liabilities: 650.1 Lease Liabilities (Noncurrent + Current): 55.1 + 21.3 = 76.4 Total Debt = 5,689.9 + 650.1 + 76.4 = 6,416.4 M. Cash = 1,942.4 M. Net Debt = 4,474.0 M. EBITDA = 1,200.9 M. Ratio = 4,474.0 / 1,200.9 = 3.7255... Rounding to two decimal places, this is 3.73. Let's consider if "Provisions" in the D&A line should be excluded from EBITDA add-back. The line is "Amortisation Depreciation And Provisions". If we assume the "Provisions" part is not D&A, EBITDA would be lower. However, in many utility reports, this line item is the standard add-back for EBITDA calculations provided by the company or analysts unless broken down. Without a breakdown, adding the full amount is the standard approach for this data set. Also, checking the Cash Flow statement: "Cash Flows From Used In Operations Before Changes In Working Capital" is 1,202.0 M. This figure is very close to our calculated EBITDA of 1,200.9 M. The difference (1.1 M) is negligible and likely due to minor adjustments like dividends received classified as operating (13.4 M) or finance income/costs paid. Actually, CFO before WC changes often equals EBITDA +/- changes in provisions/other non-cash. Given the proximity, 1,200.9 M is a robust EBITDA estimate. Let's re-verify the Debt. S&P often includes "hybrid" debt or other items. But based on the provided facts, we only have standard financial and lease liabilities. Total Debt = 6,416.4 M. Cash = 1,942.4 M. Net Debt = 4,474.0 M. Ratio = 4,474.0 / 1,200.9 = 3.7255. If we use the CFO before WC (1,202 M) as a proxy for EBITDA (which is sometimes done if D&A is not cleanly separable, though here it is): Ratio = 4,474.0 / 1,202.0 = 3.722. Both round to 3.72 or 3.73. 3.7255 rounds to 3.73. Let's check if there are any "Cash" items in "Current Financial Assets". If we include Current Financial Assets (77.7 M) as cash equivalents: Net Debt = 6,416.4 - (1,942.4 + 77.7) = 6,416.4 - 2,020.1 = 4,396.3 M. Ratio = 4,396.3 / 1,200.9 = 3.6608 -> 3.66. S&P methodology usually defines Cash and Cash Equivalents strictly. Short-term investments (Current Financial Assets) are often excluded from the cash deduction unless they are highly liquid and held for cash management purposes. In the absence of specific classification, "Cash And Cash Equivalents" is the safe bet. However, many analysts net all "financial assets" against "financial liabilities". Let's look at the magnitude. If we stick to the strict definition: Net Debt = Interest Bearing Debt - Cash & Equivalents. Debt = Financial Liabilities + Lease Liabilities. Cash = Cash & Equivalents. Result: 3.73. Let's consider if "Noncurrent Financial Assets" or "Equity Investments" should net against debt. Generally no, unless they are restricted cash or specific offsets. Let's consider if the EBITDA should be adjusted for the "Share Of Profit Loss Of Associates". EBITDA is usually pre-equity income. Our calculation started from Operating Profit (533.8 M). The Operating Profit usually excludes equity income (which is below the operating line or in a separate section). The item "Share Of Profit Loss Of Associates..." is listed after Operating Profit in the data sequence (though the order in the prompt is just a list). In standard income statements, Operating Profit is before Finance and Equity Income. The data shows: Profit Loss From Operating Activities: 533.8 M Share of Associates: 10.0 M Finance Income/Cost: -125.0 M Profit Before Tax: 408.8 M Check: 533.8 + 10.0 - 125.0 = 418.8. This does not match 408.8. Difference is 10 M. Perhaps the Operating Profit *includes* the share of associates? Or there are other items. 533.8 + 10 (associates) - 125 (finance) = 418.8. Reported PBT is 408.8. There is a 10 M discrepancy. Regardless, EBITDA is derived from Operating Profit. If Operating Profit includes equity income, we should subtract it to get core operating EBITDA. If Operating Profit is 533.8 and includes 10.0 from associates, Core EBIT = 523.8. Core EBITDA = 523.8 + 667.1 = 1,190.9 M. Ratio = 4,474.0 / 1,190.9 = 3.756 -> 3.76. However, "Profit Loss From Operating Activities" in IFRS (which Hera uses) typically *excludes* share of associates (which is usually a single line item after operating profit or before tax). The listing order in the prompt suggests they are separate. The discrepancy in the PBT reconciliation might be due to "Other" items not listed or rounding/classification differences in the prompt's extracted data. Standard practice: Use Reported Operating Profit + D&A. EBITDA = 1,200.9 M. Let's stick with the primary calculation. Net Debt: 4,474 M EBITDA: 1,200.9 M Ratio: 3.7255 3.73