**Step 1: Identify the relevant industry for "HERA S.P.A."** HERA S.P.A. is an Italian multi-utility company involved in the management of water, gas, electricity, waste, and environmental services. The provided text contains specific methodologies for "Regulated Utilities," "Oil And Gas Exploration And Production," "Unregulated Power And Gas," and "Transportation Infrastructure." Given that HERA operates primarily in water, gas distribution, and waste management (often subject to local regulation or concessions) and electricity distribution/generation, it fits best under the **Regulated Utilities** sector description, specifically the "Multi-utilities" subsector. The text states: "Companies that provide an essential or near-essential infrastructure product... subject to comprehensive regulation... Subsectors: Multi-utilities". **Step 2: Estimate "Adjusted_Debt"** According to the S&P guidelines for Regulated Utilities (and the general baseline provided), Adjusted Debt is calculated as: `Adjusted_Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash` From the balance sheet data for the fiscal year ended December 31, 2022 (values as of 2023-01-01 represent the end of the 2022 fiscal year): * **Reported Debt (Financial Liabilities):** * Noncurrent Financial Liabilities: 5,689,900,000 EUR * Current Financial Liabilities: 650,100,000 EUR * Total Financial Debt = 5,689,900,000 + 650,100,000 = 6,340,000,000 EUR * **Leases:** * Noncurrent Lease Liabilities: 55,100,000 EUR * Current Lease Liabilities: 21,300,000 EUR * Total Lease Liabilities = 55,100,000 + 21,300,000 = 76,400,000 EUR * **Pension Deficit:** * The balance sheet lists "Noncurrent Provisions For Employee Benefits" at 92,000,000 EUR. In the absence of specific pension asset/liability netting details in the notes, we treat the provision as a liability. However, standard S&P adjustment for pension deficit usually refers to the *underfunded* status (Deficit = Obligation - Assets). Without explicit pension asset data, we often look at the net provision or assume the provision reflects the net liability. For conservative estimation in utility contexts, if not specified as a deficit, we might exclude it or include the provision. Let's look for "Defined Benefit Plans" in OCI. There are gains/losses, but no explicit net deficit figure is provided in the summary facts other than the provision. Standard practice often adds the underfunded amount. If we assume the "Noncurrent Provisions For Employee Benefits" includes the pension liability, and lacking asset data, we will conservatively include this provision as a debt-like item or check if it's already in financial debt. It is listed separately from Financial Liabilities. Let's include the **Noncurrent Provisions For Employee Benefits** (92,000,000 EUR) as a debt-like item (pension obligation) as is common when specific deficit data isn't broken out further, or arguably zero if we assume it's fully funded or not a "deficit" in the strict sense. However, S&P typically adds the *unfunded* portion. Without asset data, we cannot calculate the deficit precisely. A common simplification in these exercises, if only the provision is given, is to treat the provision as the liability. Let's include **92,000,000 EUR**. *Correction*: Often, "Provisions for employee benefits" are treated as operating liabilities unless specified as underfunded pensions. S&P adds the *deficit*. If we don't know the assets, we can't know the deficit. However, looking at the OCI, there are remeasurements. Let's stick to the explicit debt and leases which are clear. If we exclude pension deficit due to lack of explicit "deficit" value (vs provision), we avoid double counting or guessing. Let's look at the "Other Debt Like Items". Derivatives? * Current Derivative Financial Liabilities: 1,347,600,000 EUR * Noncurrent Derivative Financial Liabilities: 6,300,000 EUR * Total Derivative Liabilities = 1,353,900,000 EUR. * *Note on Derivatives*: S&P typically includes the fair value of derivative liabilities in debt if they are hedging debt or if the company has a speculative profile, but for utilities, they are often operating hedges. However, the prompt asks to follow the baseline formula: `reported_debt + ... + other_debt_like_items`. Derivative liabilities are often considered debt-like in leverage calculations for rating agencies if they represent financing risks. But frequently, for utilities, only the *net* debt is considered, or derivatives are excluded if they are cash-flow hedges. Let's look at the cash. * *Eligible Cash*: Cash and Cash Equivalents = 1,942,400,000 EUR. * Current Derivative Financial Assets = 1,622,200,000 EUR. * Noncurrent Derivative Financial Assets = 1,000,000 EUR. Standard S&P Utility Adjustment: Debt = Financial Debt + Lease Liabilities. Cash = Cash and Cash Equivalents. Derivatives are usually netted against debt or excluded depending on hedge accounting. Given the large derivative positions (likely energy hedging), treating them as pure debt is aggressive. However, the baseline formula says `reported_debt`. Reported debt usually refers to interest-bearing financial liabilities. Derivatives are separate line items. I will exclude derivatives from "Debt" unless specified as "debt-like". In many utility ratings, derivative liabilities are not added to gross debt for the Debt/EBITDA ratio unless they are embedded derivatives in debt. I will stick to Financial Liabilities + Leases. Let's refine the Debt calculation: 1. **Financial Debt**: 6,340,000,000 EUR 2. **Lease Liabilities**: 76,400,000 EUR 3. **Pension Deficit**: Not explicitly provided as a net deficit figure. The provision is 92M. We will exclude it to be safe, or assume it's not a "deficit" requiring adjustment without asset data. 4. **Other Debt-like**: None explicitly identified as guarantees or hybrids. **Gross Adjusted Debt** = 6,340,000,000 + 76,400,000 = 6,416,400,000 EUR. **Less Eligible Cash**: Cash and Cash Equivalents = 1,942,400,000 EUR. **Net Adjusted Debt** = 6,416,400,000 - 1,942,400,000 = **4,474,000,000 EUR**. **Step 3: Estimate "Adjusted_EBITDA"** Formula: `Adjusted_EBITDA = EBITDA + adjustment_leases + nonrecurring_losses - nonrecurring_gains ...` First, calculate Reported EBITDA for 2022. We can reconstruct EBITDA from the Income Statement data: `EBITDA = Profit Loss From Operating Activities + Amortisation Depreciation And Provisions` *Note: "Profit Loss From Operating Activities" is effectively EBIT.* * Profit Loss From Operating Activities (2022): 533,800,000 EUR * Amortisation Depreciation And Provisions (2022): 667,100,000 EUR **Reported EBITDA** = 533,800,000 + 667,100,000 = **1,200,900,000 EUR**. *Alternative Check using Cash Flow from Operations:* Cash Flows From Operations Before Changes In Working Capital = 1,202,000,000 EUR. This figure is very close to our calculated EBITDA (1,200.9M). The difference (1.1M) is likely due to provisions/working capital adjustments included in the CFO bridge (e.g., "Allocation To Provisions" 188.5M is added back in CFO, but "Amortisation" 478.6M is added back. Wait, the CFO bridge starts with Profit/Loss? No, it says "Cash Flows From Used In Operations Before Changes In Working Capital". Let's trace the CFO bridge to ensure EBITDA accuracy. Usually: CFO before WC = Net Income + D&A + Interest + Tax + Other non-cash. Net Income (Profit Loss) = 305,300,000. Add: Income Tax = 103,500,000. Add: Finance Costs (Net) = 125,000,000 (since Finance Income Cost is -125M, meaning net expense). Add: D&A = 667,100,000? Or the adjustment "Adjustments For Depreciation..." = 478,600,000? The line "Amortisation Depreciation And Provisions" in the P&L is 667.1M. The line "Adjustments For Depreciation..." in CF is 478.6M. This discrepancy suggests some depreciation might be capitalized or included in inventory changes, or the P&L line includes provisions not in the CF add-back. However, EBITDA is an earnings metric. The standard definition is EBIT + D&A. EBIT (Operating Profit) = 533,800,000. D&A (from P&L) = 667,100,000. EBITDA = 1,200,900,000. Let's check if there are "Nonrecurring" items to adjust. The facts do not explicitly label any items as "nonrecurring" or "exceptional". In the absence of such labels, we assume the reported figures are the baseline. S&P Utilities methodology often uses "Funds From Operations (FFO)" or similar, but the prompt asks for Adjusted EBITDA. For Regulated Utilities, S&P often looks at "EBITDA" as a key profitability metric. Are there lease adjustments? The baseline formula says `+ adjustment_leases`. Under IFRS 16, lease interest and depreciation are in EBITDA? No, IFRS 16 moves operating lease rent to Depreciation and Interest. EBITDA under IFRS 16 includes the depreciation of the Right-of-Use asset but excludes the interest on the lease liability. To make EBITDA comparable to pre-IFRS 16 or to reflect cash flow, S&P sometimes adds back the interest portion of the lease payment? Or simply uses Reported EBITDA. The prompt formula: `Adjusted_EBITDA = EBITDA ... + adjustment_leases`. Usually, if EBITDA is reported under IFRS 16, it is already "adjusted" in the sense that rent is gone. However, S&P might define Adjusted EBITDA as EBITDA + Lease Interest (to approximate cash rent coverage) or simply use the reported EBITDA if it's considered standard. Given the "Regulated Utilities" section doesn't specify a complex EBITDA adjustment different from the baseline, and the baseline adds "adjustment_leases", this typically refers to adding back the *interest* component of leases if one wants a "Cash EBITDA" or if the starting point was EBIT. But here we start with EBITDA. Actually, a common S&P adjustment for leases in EBITDA calculation (if starting from EBIT) is to add back Depreciation on ROU assets. If we start from Reported EBITDA (which already has ROU Depreciation added back to EBIT), we don't add it again. However, sometimes "Adjusted EBITDA" for rating purposes adds back the *entire* lease cost (approximated by interest + principal repayment? No, that's debt service). Let's stick to the most standard interpretation: **Reported EBITDA** is the starting point. Without specific non-recurring items identified in the text, Adjusted EBITDA ≈ Reported EBITDA. Let's double check the "Share Of Profit Loss Of Associates". EBITDA usually excludes income from associates (which is below the operating line or included in operating profit depending on presentation). Here, "Profit Loss From Operating Activities" is 533.8M. The "Share Of Profit... Associates" is 10M. Is this included in Operating Profit? Usually, equity income is *below* operating profit in many formats, or included. In IFRS, it can be part of operating profit. If it is included in the 533.8M, should we exclude it? S&P often excludes equity income from EBITDA for leverage ratios if it's not cash-dividend yielding, or includes it if it's core. For utilities, associates are often core. We will leave it in. So, **Adjusted EBITDA** = **1,200,900,000 EUR**. **Step 4: Calculate the Ratio** Adjusted Debt = 4,474,000,000 EUR Adjusted EBITDA = 1,200,900,000 EUR Ratio = 4,474,000,000 / 1,200,900,000 Calculation: 4,474 / 1,200.9 ≈ 3.7255 Rounding to two decimal places: **3.73** Let's re-verify the Debt components. Did we miss any "Debt-like" items? "Current Derivative Financial Liabilities" (1.35B) and "Noncurrent" (6.3M). In the energy sector, derivatives are huge. If these are hedging instruments, S&P generally does *not* include the fair value of derivatives in Gross Debt for the Debt/EBITDA ratio, unless they are embedded in debt instruments. They are marked-to-market, creating volatility. Including them would distort the leverage ratio significantly. Standard practice is to exclude them from Debt. Did we miss "Pension Deficit"? If the 92M provision is a pension liability, and we assume no assets (worst case), Debt increases by 92M. New Debt = 4,474M + 92M = 4,566M. Ratio = 4,566 / 1,200.9 = 3.80. However, "Provisions for Employee Benefits" usually includes long-term incentives, severance, etc., not just pensions. And pensions are usually funded. Without explicit "Net Pension Deficit" data, adding the full provision is incorrect. S&P adds the *unfunded* deficit. Lacking that data, we assume 0 adjustment or that it's immaterial/not a deficit. Did we miss "Minority Interest" adjustments? No, Debt/EBITDA is usually at the consolidated group level. Did we use the correct Cash? "Cash And Cash Equivalents" 2023-01-01: 1,942,400,000. S&P allows netting cash against debt. Let's check the EBITDA reconstruction again. Revenue: 20,082,000,000 Raw Materials: (16,730,000,000) Services: (2,105,800,000) Employee Benefits: (601,100,000) Other Expense: (74,900,000) Other Work Capitalised: +82,500,000 Depreciation: (667,100,000) -- This is an expense in P&L? The line "Amortisation Depreciation And Provisions" is 667,100,000. Operating Profit = Revenue - Expenses + Capitalized Work - Depreciation? Let's sum the expenses: 16,730 + 2,105.8 + 601.1 + 74.9 = 19,511.8 M. Revenue 20,082 - 19,511.8 = 570.2 M. Add Capitalized Work 82.5 M = 652.7 M. Subtract Depreciation 667.1 M = -14.4 M? This does not match the "Profit Loss From Operating Activities" of 533.8 M. Why? "Other Revenue" is 548.2 M. Total Revenue = 20,082 + 548.2 = 20,630.2 M. Expenses = 19,511.8 M. Gross Margin = 1,118.4 M. Add Capitalized Work 82.5 M = 1,200.9 M. Subtract Depreciation 667.1 M = 533.8 M. Matches exactly. So, EBITDA = Operating Profit + Depreciation = 533.8 + 667.1 = 1,200.9 M. This confirms the EBITDA figure. Debt Check: Noncurrent Financial Liabilities: 5,689.9 M Current Financial Liabilities: 650.1 M Total Financial Debt: 6,340.0 M Leases: 55.1 + 21.3 = 76.4 M Total Gross 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... Round to 3.73. 3.73