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: Net Debt and EBITDA. **1. Calculate EBITDA** S&P typically defines EBITDA as Earnings Before Interest, Taxes, Depreciation, and Amortization. We can derive this from the "Profit Loss From Operating Activities" (Operating Profit) or "Profit Loss Before Tax". Using the Operating Profit approach is standard for operational performance. From the data provided for the period 2022-01-01 - 2023-01-01: * **Profit Loss From Operating Activities**: 533,800,000 EUR * **Amortisation Depreciation And Provisions**: 667,100,000 EUR Note: The line item "Amortisation Depreciation And Provisions" usually includes D&A. S&P EBITDA adds back D&A. Sometimes "Provisions" are excluded from the add-back if they are considered non-cash operating items already included in operating profit, but typically D&A is the main add-back. Let's look for a more precise D&A figure if available. The item "Adjustments For Depreciation And Amortisation Expense And Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss" is 478,600,000 EUR. This is found in the Cash Flow statement adjustments. However, the Income Statement line "Amortisation Depreciation And Provisions" is 667,100,000 EUR. Let's check the composition. Operating Profit = 533,800,000. If we add back the specific D&A adjustment from cash flows (478,600,000), we get an EBITDA of ~1,012,400,000. If we add back the full "Amortisation Depreciation And Provisions" (667,100,000), we get an EBITDA of ~1,200,900,000. Let's look at the standard S&P definition: EBITDA = Operating Income + Depreciation + Amortization. The line "Amortisation Depreciation And Provisions" likely contains D&A plus changes in provisions. The cash flow adjustment "Adjustments For Depreciation And Amortisation Expense..." (478,600,000) is a cleaner proxy for actual D&A expense charged against profit. The difference between 667.1M and 478.6M is roughly 188.5M. Interestingly, there is a line "Allocation To Provisions Excluding Change In Provision For Risks And Charges" at 188,500,000 EUR. This suggests the 667.1M figure includes D&A (478.6M) and Provisions (188.5M). Standard EBITDA adds back D&A. It does *not* typically add back provisions unless they are non-operating or exceptional, but provisions are often part of operating expenses. However, S&P often uses "EBITDA" as reported by the company or calculated as Operating Profit + D&A. Let's use Operating Profit + D&A. Operating Profit: 533,800,000 EUR. D&A: 478,600,000 EUR (from Cash Flow adjustments, which is the standard non-cash add-back for D&A). EBITDA = 533,800,000 + 478,600,000 = **1,012,400,000 EUR**. Alternatively, some definitions start from Net Income and add back Interest, Tax, D&A. Net Income (Profit Loss): 305,300,000 EUR. Interest (Finance Costs): 217,200,000 EUR. Tax: 103,500,000 EUR. D&A: 478,600,000 EUR. EBITDA = 305,300,000 + 217,200,000 + 103,500,000 + 478,600,000 = 1,104,600,000 EUR. The difference arises from "Share Of Profit Loss Of Associates" (10,000,000) and potentially other non-operating items included in Operating Profit vs Net Income. S&P generally prefers Operating EBITDA. Let's stick to the Operating Profit based calculation but verify if "Amortisation Depreciation And Provisions" is the intended D&A line. In many European reports, the D&A line in the income statement is the correct add-back. If we assume the 667.1M is the total depreciation and amortization charge (including some provision movements that might be considered part of the operational cost base but not cash), using the Cash Flow statement's specific D&A adjustment (478.6M) is safer for "Earnings Before...". However, looking at the magnitude, 478M seems low compared to the asset base. Let's re-read carefully. "Amortisation Depreciation And Provisions" 667,100,000. "Adjustments For Depreciation And Amortisation Expense..." 478,600,000. The difference is exactly the "Allocation To Provisions" (188,500,000). Provisions are non-cash but are often excluded from EBITDA if they are operating provisions? No, EBITDA is before interest and tax, but *after* operating expenses. Provisions are operating expenses. D&A are non-cash operating expenses added back. Therefore, we should only add back D&A. So, D&A = 478,600,000 EUR. EBITDA = Operating Profit (533,800,000) + D&A (478,600,000) = **1,012,400,000 EUR**. Let's double check if there are other adjustments. S&P might adjust for "Other Work Performed By Entity And Capitalised" (82,500,000). This is revenue-like but non-cash/investing. It is included in Revenue/Operating Profit. Often EBITDA calculations leave this in as it's part of operating performance, or adjust it out if looking for cash generation. Standard EBITDA usually leaves it in. Let's consider the "Finance Income Cost" net figure is -125,000,000. Let's consider the "Profit Loss Before Tax" is 408,800,000. EBIT = Profit Before Tax + Net Finance Costs = 408,800,000 + 125,000,000 (net cost) = 533,800,000. This matches Operating Profit. So Operating Profit is effectively EBIT. EBITDA = EBIT + D&A = 533,800,000 + 478,600,000 = 1,012,400,000 EUR. **2. Calculate Net Debt** S&P Net Debt is generally Gross Debt minus Cash and Cash Equivalents (and sometimes short-term investments). Gross Debt includes Financial Liabilities (Current and Noncurrent) and Lease Liabilities (Current and Noncurrent). S&P typically treats lease liabilities as debt. From the Balance Sheet at 2023-01-01 (End of 2022): * **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 Total Gross Debt = 5,689,900,000 + 55,100,000 + 650,100,000 + 21,300,000 Total Gross Debt = 6,416,400,000 EUR. Now, subtract Cash and Cash Equivalents. * **Cash And Cash Equivalents**: 1,942,400,000 EUR Are there other cash-like items? "Current Financial Assets" (77,700,000) and "Noncurrent Financial Assets" (151,800,000) are typically not deducted from debt in standard Net Debt calculations unless specified as "cash equivalents" or highly liquid short-term investments. S&P usually deducts only Cash and Cash Equivalents. Sometimes they deduct short-term investments if they are very liquid. Given the label "Financial Assets", these are likely investments, not cash equivalents. We will stick to Cash and Cash Equivalents. Net Debt = Gross Debt - Cash & 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,012,400,000 Calculation: 4,474 / 1,012.4 ≈ 4.419 Let's refine the EBITDA calculation. Is it possible S&P uses the "Amortisation Depreciation And Provisions" line directly? If we used 667.1M: EBITDA = 533.8 + 667.1 = 1,200.9M. Ratio = 4,474 / 1,200.9 ≈ 3.72. Which D&A figure is more appropriate? The Cash Flow statement reconciles Net Income to Operating Cash Flow. The line "Adjustments For Depreciation And Amortisation Expense..." is explicitly D&A. The Income Statement line "Amortisation Depreciation And Provisions" mixes D&A with Provisions. Provisions are expenses that reduce profit but are non-cash. However, EBITDA is "Earnings Before Interest, Taxes, Depreciation and Amortization". It does *not* say "Before Provisions". Therefore, provisions should remain deducted (i.e., not added back). Only D&A should be added back. Thus, the D&A figure of 478,600,000 is the correct one to add back. EBITDA = 1,012,400,000 EUR. Let's check if there are any other debt components. "Current Derivative Financial Liabilities" and "Noncurrent Derivative Financial Liabilities" are generally excluded from Debt unless they are hedging debt and the methodology specifies grossing up, but standard Net Debt excludes derivatives. "Trade And Other Current Payables" are operating liabilities, not debt. So, Net Debt = 4,474,000,000 EUR. EBITDA = 1,012,400,000 EUR. Ratio = 4.4192... Let's double check the "Finance Costs" and "Finance Income". S&P sometimes calculates "Gross Debt" including the current portion of long-term debt, which we have done. Is there any "Capitalised Interest" or other adjustments? Not visible. Let's consider if "Other Work Performed By Entity And Capitalised" (82.5M) should be subtracted from EBITDA? S&P Global Ratings' criteria often define EBITDA as reported operating income plus depreciation and amortization. They may make adjustments for non-recurring items. Capitalized own work is a standard accounting practice in utilities/construction and is part of recurring operations. It is usually left in. Let's consider if the "Share Of Profit Loss Of Associates" (10M) should be excluded? Operating Profit includes this. S&P EBITDA often excludes income from associates because it's not consolidated cash flow. If we exclude it: Adjusted Operating Profit = 533.8 - 10 = 523.8 M. EBITDA = 523.8 + 478.6 = 1,002.4 M. Ratio = 4,474 / 1,002.4 ≈ 4.46. However, the standard "EBITDA" metric without specific "S&P Adjusted EBITDA" instructions usually just takes Operating Profit + D&A. The prompt asks for "S&P methodology". S&P's *corporate* methodology for leverage ratios (Net Debt/EBITDA) typically uses "EBITDA" as defined in their criteria, which is often close to reported EBITDA but may adjust for equity income. According to S&P Global Ratings' "Key Credit Ratios" methodology: EBITDA = EBIT + Depreciation + Amortization. EBIT is often "Operating Income". Does Operating Income include equity income? In IFRS, "Profit from operating activities" often includes share of associates if they are considered part of operations, or it might be below operating profit. Here, "Profit Loss From Operating Activities" is 533.8M. "Share Of Profit... Associates" is listed *after* Operating Profit in many formats, or *before*? Looking at the list: "Profit Loss From Operating Activities" 533,800,000 "Share Of Profit Loss Of Associates..." 10,000,000 "Finance Income" ... "Finance Costs" ... "Profit Loss Before Tax" 408,800,000. Let's check the math: 533.8 (Op Profit) + 10 (Associates) - 125 (Net Finance Cost) = 418.8. But Profit Before Tax is 408.8. There is a 10M difference. 533.8 + 10 - 125 = 418.8. Actual PBT = 408.8. Difference = 10M. Perhaps the "Share of Associates" is *included* in the 533.8? Or maybe there are other items? If 533.8 is the final Operating Profit line, and Associates are listed separately, usually they are added to get to PBT. 533.8 + 10 - 125 = 418.8. Why is PBT 408.8? Maybe "Other Expense By Nature" or something else is below the line? Or maybe the 10M is already in the 533.8? If it's already in, then we don't add it again. If the 10M is *not* in Operating Profit, and we add it, we get 418.8. The reported PBT is 408.8. There is a missing 10M expense or income. Let's look at "Other Expense By Nature" 74.9M. This is likely above the operating profit line. Let's assume the standard structure: Revenue - Expenses = Operating Profit. Operating Profit + Share of Associates + Net Finance = PBT. If the math doesn't tie perfectly (418.8 vs 408.8), there might be a "Other Income/Expense" line not explicitly detailed as a separate add-back or it's embedded. However, for EBITDA, we start with Operating Profit. If S&P excludes equity income from EBITDA (as it's not cash from operations), and if the 10M is *included* in the 533.8M, we should subtract it. If it's *excluded* from 533.8M, we ignore it (as it's below the line). In IFRS, "Operating Profit" definitions vary. Hera's report likely defines "Profit from operating activities" as EBIT. If we assume the 533.8M is the robust EBIT figure: EBITDA = 533.8 + 478.6 = 1,012.4 M. Let's check the previous year to see if the methodology holds. 2021 Op Profit: 611.7 M. 2021 D&A: 469.9 M. 2021 EBITDA: 1,081.6 M. 2021 Net Debt: Debt 2022-01-01 (Start of 2022 / End of 2021): Noncurrent Fin Liab: 3,716.0 Noncurrent Lease: 53.2 Current Fin Liab: 499.7 Current Lease: 43.4 Gross Debt = 4,312.3 M. Cash 2022-01-01: 885.6 M. Net Debt = 3,426.7 M. Ratio 2021 = 3,426.7 / 1,081.6 = 3.17. Back to 2022: Net Debt = 4,474.0 M. EBITDA = 1,012.4 M. Ratio = 4.42. Is there any reason to use the higher D&A (667.1)? If the "Provisions" (188.5M) are considered non-cash and S&P adds them back? S&P usually adds back "non-cash operating items" only if they are exceptional or if calculating "Funds From Operations" (FFO). For EBITDA, it's strictly D&A. However, some simplified calculations use the Income Statement line "Depreciation and Amortization" if it's distinct. Here it is bundled with Provisions. The Cash Flow statement breaks it out. The Cash Flow break-out is more accurate for D&A. One nuance: S&P often calculates "Debt" including "Capital Leases" (which we did via Lease Liabilities) and sometimes "Operating Leases" capitalized (IFRS 16 does this automatically, so Lease Liabilities are on the balance sheet). We included Lease Liabilities. Another nuance: "Cash and Cash Equivalents". S&P may deduct "Short-term investments" if they are highly liquid. "Current Financial Assets" are 77.7M. If we deduct these too: Net Debt = 4,474.0 - 77.7 = 4,396.3 M. Ratio = 4,396.3 / 1,012.4 = 4.34. Given the ambiguity on "Financial Assets", standard Net Debt usually just uses Cash & Cash Equivalents. I will stick to 4,474 / 1,012.4. Let's do a sanity check on the numbers. Revenue ~20B. EBITDA ~1B. EBITDA Margin ~5%. This is typical for a utility/distributor with high pass-through costs (Raw Materials 16.7B). Net Debt ~4.5B. Leverage ~4.4x. This is a reasonable leverage ratio for a utility infrastructure company. Final Calculation: Net Debt = (5,689.9 + 55.1 + 650.1 + 21.3) - 1,942.4 = 6,416.4 - 1,942.4 = 4,474.0 (in millions) EBITDA = 533.8 + 478.6 = 1,012.4 (in millions) Ratio = 4,474.0 / 1,012.4 = 4.4192 Rounding to two decimal places: 4.42. 4.42