I'll work through this step-by-step, first identifying HERA S.P.A.'s industry and then calculating the required metrics. ## Step 1: Identify the Relevant Industry HERA S.P.A. is an Italian multi-utility company. Based on the name, description, and the nature of its operations (revenue from utilities, regulated operations), this falls under the **Regulated Utilities** sector, specifically **Multi-utilities**. From the methodology: "Multi-utilities" is listed as a typical subsector under Regulated Utilities. ## Step 2: Estimate Adjusted_EBITDA First, let me reconstruct EBITDA from the income statement data. For 2022 (2022-01-01 to 2023-01-01): - Revenue: 20,082,000,000 EUR - Other Revenue: 548,200,000 EUR - Total Revenue = 20,630,200,000 EUR Expenses: - Raw Materials And Consumables Used: 16,730,000,000 EUR - Services Expense: 2,105,800,000 EUR - Employee Benefits Expense: 601,100,000 EUR - Other Expense By Nature: 74,900,000 EUR - Other Work Performed By Entity And Capitalised: -82,500,000 EUR (capitalized, so subtract from expenses) - Amortisation Depreciation And Provisions: 667,100,000 EUR Operating Profit (Profit Loss From Operating Activities): 533,800,000 EUR Let me verify: Total Revenue = 20,082,000,000 + 548,200,000 = 20,630,200,000 Total operating expenses (excluding depreciation): - Raw Materials: 16,730,000,000 - Services: 2,105,800,000 - Employee Benefits: 601,100,000 - Other Expense: 74,900,000 - Less: Capitalized work: -82,500,000 = 19,429,300,000 Operating profit before depreciation = 20,630,200,000 - 19,429,300,000 = 1,200,900,000 Less: Amortisation Depreciation And Provisions: 667,100,000 Operating profit = 533,800,000 ✓ **EBITDA** = Profit Loss From Operating Activities + Amortisation Depreciation And Provisions = 533,800,000 + 667,100,000 = **1,200,900,000 EUR** Now for adjustments per S&P Regulated Utilities methodology: - **Lease adjustments**: The methodology mentions netting seasonal working capital but doesn't specifically require lease add-backs for EBITDA in the same way. However, for debt we include leases. For EBITDA, we typically add back lease expenses (the operating lease equivalent). Looking at the cash flow, Payments Of Lease Liabilities = 43,400,000 EUR. We need to estimate the lease expense component. Given right-of-use assets declined from 101,600,000 to 84,200,000, and lease liabilities declined from 53,200,000+43,400,000=96,600,000 to 55,100,000+21,300,000=76,400,000, the lease expense is roughly the payment minus principal reduction. However, under IFRS 16, leases are already in EBITDA (depreciation + interest). For S&P, we typically add back the lease depreciation and subtract the lease payment, or use a standard adjustment. Actually, for S&P methodology on regulated utilities, the standard approach is: - EBITDA includes lease depreciation under IFRS 16 - For Adjusted EBITDA, we typically add back lease depreciation and subtract lease payments, or more commonly for S&P: add back the lease expense equivalent Let me check: Under IFRS 16, the total lease expense recognized is depreciation + interest. The cash payment is 43,400,000. The depreciation on ROU assets would be roughly (101,600,000 + 84,200,000)/2 / useful life, or we can estimate from the change. Actually, for S&P Global Ratings, the standard adjustment for leases in EBITDA is to add back the operating lease expense (the straight-line lease expense that would have been recognized under IAS 17). However, this is complex to estimate. A simpler approach: S&P typically uses "EBITDA including lease effects" or adjusts by adding back lease-related depreciation and subtracting lease payments. Given the complexity, and that regulated utilities often have small lease portfolios relative to debt, let me check if leases are material. Total lease liabilities: 76,400,000 vs total debt of ~6,340,000,000. Leases are about 1.2% of debt, relatively small. For regulated utilities, S&P may not make significant EBITDA lease adjustments if using standard methodology. However, the general corporate methodology suggests we should normalize. Let me use a practical approach: The lease payment was 43,400,000. Under IFRS 16, this is split between principal (financing) and interest (operating). The interest portion would be in finance costs. Looking at finance costs of 217,200,000, this includes lease interest. For S&P Adjusted EBITDA, standard practice is: Adjusted_EBITDA = EBITDA + lease expense (as if operating lease) - lease depreciation already in EBITDA Actually, the most common S&P approach is to add back the full lease payment to EBITDA (since EBITDA under IFRS 16 has lease depreciation instead). So: Adjusted_EBITDA = EBITDA + lease depreciation - lease payment + lease interest... This gets complicated. Let me use a simplified approach: add back the lease liability reduction (principal payment) as it's financing, and the interest portion is already in finance costs. Actually, looking at the cash flow statement: "Payments Of Lease Liabilities Classified As Financing Activities" = 43,400,000. This is the principal payment. The interest portion would be in "Finance Costs" and likely in operating or financing. For S&P purposes, a common simplification is: Adjusted_EBITDA = Reported EBITDA + Lease depreciation (included in amortization/depreciation) But we need to separate lease depreciation from total depreciation. Given ROU assets went from 101,600,000 to 84,200,000, and assuming no additions, depreciation was about 17,400,000. But there may have been additions. Let me try a different approach. Looking at the detailed methodology, for regulated utilities with seasonal working capital, S&P mentions netting inventory against short-term borrowings. But for EBITDA, the standard formula is relatively straightforward. Given complexity and materiality, I'll use: **Adjusted_EBITDA = 1,200,900,000 EUR** (base EBITDA, assuming lease effects are small and included) Wait - let me re-read the S&P methodology more carefully. For regulated utilities, they mention "Where substantial seasonal working capital requirements...distort leverage measures, we adjust inventory and debt balances by netting the value of inventory against outstanding short-term borrowings." This doesn't affect EBITDA. For the EBITDA calculation, I need to check if there are non-recurring items. Looking at the data: - "Capital Gains Losses And Other Non Monetary Elements" in cash flow = 41,600,000 EUR (this is an adjustment, so it was likely deducted to get to operating cash flow, meaning it was a gain or non-cash item) Actually, looking at cash flow adjustments: "Capital Gains Losses And Other Non Monetary Elements" = 41,600,000. This suggests there were gains/losses that need adjustment. Since it's positive in the adjustment (added back), it suggests a loss was deducted or a gain needs to be removed. Actually, in cash flow statements, positive adjustments typically mean adding back losses or subtracting gains. The sign convention here: "Capital Gains Losses And Other Non Monetary Elements" = 41,600,000 as an adjustment to get from profit to cash flow. Since it's positive, and looking at the pattern: adjustments for depreciation are positive (added back), so this is likely adding back losses or subtracting gains. Given it's "Capital Gains Losses", a positive value likely means gains (which were added to profit, so we subtract them) or losses added back. Actually, standard cash flow: start with profit, add back depreciation, add back losses, subtract gains. So 41,600,000 is likely losses added back (or the net effect). Given "Capital Gains Losses And Other Non Monetary Elements" is 41,600,000 and it's an adjustment to operating cash flow, this suggests there were gains/losses. If positive, it means we're adding back losses (positive adjustment to profit). So there were losses of 41,600,000. For EBITDA, these would already be included in operating profit. For S&P, we want to exclude non-recurring gains/losses. Since this is "Capital Gains Losses And Other Non Monetary Elements", and it's 41,600,000 (positive in cash flow adjustment, meaning losses), we should add this back for normalized EBITDA if these are non-recurring losses. Actually, re-reading: "Capital Gains Losses And Other Non Monetary Elements" = 41,600,000. The naming suggests "Capital Gains Losses" (net). If positive, it's likely gains. But in cash flow adjustments, gains are subtracted. Let me check the pattern: "Adjustments For Finance Income Cost" = 135,000,000 (positive). Finance costs are expenses, so to add them back to get cash, we add the expense. Similarly, "Capital Gains Losses" - if it's gains, we'd subtract; if losses, we'd add. Given it's positive like depreciation, it's likely adding back losses. Hmm, but let me look more carefully. The item is "Capital Gains Losses And Other Non Monetary Elements". In Italian financial statements (Hera is Italian), this often includes both gains and losses. The 41,600,000 is the net amount. If it's an add-back (positive adjustment), it means net losses or non-monetary items that reduced profit. For S&P normalization, we should adjust for non-recurring items. Given this includes "Capital Gains Losses", these are typically non-recurring. If it's a net loss (added back to profit), then for normalized EBITDA, we should add back this loss (i.e., increase EBITDA). So: **Adjustment for non-recurring losses = +41,600,000** Also, "Change In Provision For Risks And Charges" = -27,800,000 (negative, meaning provision decreased, released to profit). This is likely non-recurring or at least not operational. For EBITDA, we might want to exclude this. But it's already in operating profit. Actually, looking more carefully at S&P methodology: for FFO, we start from Adjusted EBITDA and subtract cash interest and cash taxes. The adjustments to EBITDA should be for truly non-recurring or non-operational items. Let me also check "Other Work Performed By Entity And Capitalised" = 82,500,000. This is capitalized costs, already excluded from operating expenses. And "Other Revenue" = 548,200,000 - need to check if this is recurring. For a utility, most revenue is recurring. I'll assume "Other Revenue" is recurring operational revenue. Also, looking at "Share Of Profit Loss Of Associates And Joint Ventures" = 10,000,000. This is equity method earnings, not in operating profit (it's after operating activities). So not in EBITDA. For regulated utilities, S&P may also adjust for pension items. Looking at the data: - "Noncurrent Provisions For Employee Benefits" 2023: 92,000,000; 2022: 105,400,000 - "Other Comprehensive Income Before Tax Gains Losses On Remeasurements Of Defined Benefit Plans" = 3,100,000 - "Adjustments For Increase Decrease In Employee Benefit Liabilities" = -12,700,000 The pension deficit: we need to check if there's a pension deficit. "Noncurrent Provisions For Employee Benefits" is 92,000,000 (2023) and 105,400,000 (2022). These are liabilities. The net pension position isn't fully clear without plan assets, but typically these provisions represent the net liability. For EBITDA, pension adjustments are typically for service cost (part of employee benefits). The "Employee Benefits Expense" of 601,100,000 likely includes pension service costs. This is operational and should remain. Let me now construct Adjusted_EBITDA: Base EBITDA = 1,200,900,000 Add: Non-recurring losses (Capital Gains Losses and other non-monetary elements if losses) = +41,600,000 But wait - I need to be more careful. Let me check if 41,600,000 is a gain or loss. Looking at the cash flow statement structure: - Start with Profit Loss From Operating Activities: 533,800,000 - Add back depreciation: 478,600,000 - Add back provisions allocation: 188,500,000 - Subtract undistributed profits of equity investments: -10,000,000 - Add back finance costs (net): 135,000,000 - Add capital gains losses and other non-monetary: 41,600,000 - Change in provision for risks: -27,800,000 - Change in employee benefits: -12,700,000 Sum: 533,800 + 478,600 + 188,500 - 10,000 + 135,000 + 41,600 - 27,800 - 12,700 = 1,327,000,000 But "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000 Wait, let me recalculate: 533,800 + 478,600 = 1,012,400; +188,500 = 1,200,900; -10,000 = 1,190,900; +135,000 = 1,325,900; +41,600 = 1,367,500; -27,800 = 1,339,700; -12,700 = 1,327,000. But reported is 1,202,000,000. There's a discrepancy. Let me re-read: "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000. Hmm, maybe I need to include "Other Work Performed By Entity And Capitalised"? No, that's already in operating profit. Actually, looking more carefully at the adjustments: "Allocation To Provisions Excluding Change In Provision For Risks And Charges" = 188,500,000. This is added back. And "Change In Provision For Risks And Charges" = -27,800,000 is separate. Let me try: 533,800 + 478,600 + 188,500 - 10,000 + 135,000 + 41,600 - 27,800 - 12,700 = 1,327,000. Still not 1,202,000. Wait - I need to check: "Adjustments For Depreciation And Amortisation Expense And Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss" = 478,600,000. But Amortisation Depreciation And Provisions in P&L = 667,100,000. The difference is 188,500,000, which equals "Allocation To Provisions Excluding Change In Provision For Risks And Charges". So total depreciation + provisions charges in P&L = 478,600,000 + 188,500,000 = 667,100,000. ✓ So the cash flow starts with 533,800, adds 478,600 (depreciation), adds 188,500 (provisions), subtracts 10,000 (equity earnings), adds 135,000 (finance costs), adds 41,600 (capital losses), subtracts 27,800 (provision releases), subtracts 12,700 (employee benefits change). But 533,800 + 478,600 + 188,500 - 10,000 + 135,000 + 41,600 - 27,800 - 12,700 = 1,327,000, not 1,202,000. Unless... "Adjustments For Finance Income Cost" = 135,000,000. But "Finance Income Cost" in P&L = -125,000,000 (net). So finance costs are 217,200 - 82,200 = 135,000 expense net. But in operating profit, finance costs are not included! Operating profit is before finance items. So why is "Adjustments For Finance Income Cost" in the operating cash flow? This suggests the cash flow statement starts from a different base or includes items differently. Actually, looking at Italian GAAP/IFRS practice, the cash flow may start from "Profit Loss" (net income) not operating profit. Let me check: "Profit Loss" = 305,300,000. But the cash flow items start with operating activities and list adjustments. The structure seems to start from operating profit. Hmm, let me re-read: "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000. This should equal operating profit + adjustments. If operating profit = 533,800, and we add depreciation 478,600, we get 1,012,400. Then +188,500 provisions = 1,200,900. Then -10,000 equity = 1,190,900. Then +135,000 finance = 1,325,900. Then +41,600 capital losses = 1,367,500. Then -27,800 provision change = 1,339,700. Then -12,700 employee benefits = 1,327,000. Still not 1,202,000. Difference is 125,000,000. That's exactly the "Finance Income Cost" of -125,000,000. Ah! I think "Adjustments For Finance Income Cost" = 135,000,000 might be the gross finance costs, not net. And "Finance Income Cost" = -125,000,000 is the net. But in operating cash flow, we adjust for the net finance cost that was deducted to get net income, not operating profit. Actually, I think the cash flow might start from a different point. Let me check: "Profit Loss From Operating Activities" = 533,800,000. But "Profit Loss" = 305,300,000. The difference is finance costs net (125,000) + equity earnings (10,000) + tax (103,500) = 238,500. And 533,800 - 238,500 = 295,300, not 305,300. Hmm, close but not exact. Actually 533,800 - 125,000 - 10,000 - 103,500 = 295,300. But "Profit Loss" is 305,300. Difference of 10,000,000. Actually, "Share Of Profit Loss Of Associates" = 10,000,000 (positive, profit). So: 533,800 - 125,000 (finance net) + 10,000 (equity earnings, added) - 103,500 (tax) = 315,300. Still not 305,300. Let me try: Profit before tax = 408,800. Tax = 103,500. Profit = 305,300. ✓ And 533,800 (operating) + 10,000 (equity) - 125,000 (finance net) = 418,800 profit before tax? No, that's 418,800, not 408,800. Difference of 10,000,000. Hmm, "Finance Income Cost" = -125,000,000. "Finance Income" = 82,200,000. "Finance Costs" = 217,200,000. Net = 82,200 - 217,200 = -135,000,000. But "Finance Income Cost" is -125,000,000. There's a 10,000,000 difference. Ah! "Share Of Profit Loss Of Associates" = 10,000,000. This is NOT in operating profit. So: Operating profit 533,800 + equity earnings 10,000 = 543,800. Then finance net -125,000 = 418,800. Then tax -103,500 = 315,300. But profit is 305,300. Still off by 10,000,000. Wait, let me re-check: "Profit Loss Before Tax" = 408,800,000. And "Profit Loss" = 305,300,000. So tax = 408,800 - 305,300 = 103,500. ✓ And 533,800 (operating) + 10,000 (equity) - 135,000 (finance net: 82,200 - 217,200) = 408,800. ✓ So "Finance Income Cost" should be -135,000,000, but it's reported as -125,000,000. The 10,000,000 difference might be due to how equity earnings are treated or some other item. Actually, re-reading: "Finance Income" = 82,200,000. "Finance Costs" = 217,200,000. "Finance Income Cost" = -125,000,000. But 82,200 - 217,200 = -135,000, not -125,000. Unless there's 10,000,000 of finance income elsewhere. Actually, looking at "Share Of Profit Loss Of Associates" - this is not finance income. So the -10,000,000 difference remains unexplained. But let's move on. Back to EBITDA: I'll use **EBITDA = 1,200,900,000 EUR** For Adjusted_EBITDA, I need to consider: - Lease adjustments: small, but let's estimate. ROU assets declined by 17,400,000. Lease liabilities declined by 20,200,000. Payment was 43,400,000. So new leases were about 23,200,000. Depreciation on ROU assets was roughly 17,400,000 + additions allocated. This is small relative to EBITDA. I'll add back lease depreciation of approximately 20,000,000 and subtract lease payment of 43,400,000, or use a simpler approach. Actually, for S&P, the standard lease adjustment to EBITDA is to add back the lease expense that was deducted (operating lease expense under old rules). Under IFRS 16, there's no lease expense in EBITDA - instead there's depreciation. So we add back depreciation of ROU assets and subtract the "lease payment" (which is financing + interest). But the interest is already below EBITDA. Simplified approach: Add back ROU depreciation, subtract lease payment. ROU depreciation ≈ 20,000,000. Lease payment = 43,400,000. Net effect: -23,400,000. But this reduces EBITDA, which seems odd. Actually, under S&P methodology, for leverage calculations, they often use "EBITDA as reported" and adjust debt. For FFO, they have specific treatments. Let me re-read the workflow instructions more carefully. The formula is: Adjusted_EBITDA = EBITDA (reported or reconstructed) + adjustment_leases (if any) + nonrecurring_losses - nonrecurring_gains ± pension_adjustments ± joint_venture_proportional_EBITDA ± other_normalization_adjustments For regulated utilities, the methodology doesn't specify special EBITDA adjustments beyond standard ones. Let me focus on: - adjustment_leases: For EBITDA, if we want to approximate pre-IFRS 16, we'd add back lease depreciation and subtract lease payment. But actually, for EBITDA calculation, IFRS 16 already puts lease costs in depreciation and interest, so EBITDA is "inflated" compared to old operating lease treatment. S&P sometimes adjusts this by adding back the "lease expense" (as if operating lease). Actually, I think for simplicity and given materiality, I'll use: - Base EBITDA: 1,200,900,000 - Add back lease-related amounts: The lease payment was 43,400,000, but this includes principal and interest. The interest portion is in finance costs. For EBITDA, we want the operating lease expense. Roughly, if we assume 5% interest on average lease liability of (96,600+76,400)/2 = 86,500, interest = 4,325,000. Principal = 39,075,000. Depreciation was about 20,000,000. So total "lease expense" under old rules ≈ 24,325,000. Under IFRS 16, we have depreciation 20,000,000 in EBITDA (already there) and interest 4,325,000 below EBITDA. So EBITDA is higher by the principal portion of 39,075,000. For S&P Adjusted EBITDA, we might want to reduce EBITDA by the principal portion to approximate old treatment, or add back the full lease payment and subtract depreciation. Given the complexity and small materiality (~3% of EBITDA), I'll use a simplified approach: no lease adjustment to EBITDA, but include leases in debt. For nonrecurring items: "Capital Gains Losses And Other Non Monetary Elements" = 41,600,000. If this is net losses, we add back. If net gains, we subtract. Given it's an add-back in cash flow (positive adjustment), it's adding back losses or subtracting gains. In standard cash flow preparation, gains are subtracted from profit, losses are added. So 41,600,000 as a positive adjustment means adding back losses. For normalized EBITDA, we add back these losses: **+41,600,000** For pension: The "Adjustments For Increase Decrease In Employee Benefit Liabilities" = -12,700,000. This is a cash flow adjustment. The pension expense in P&L is part of Employee Benefits Expense. For S&P, we typically adjust for pension service cost vs. cash contributions. But without detailed pension data, I'll assume the pension expense is normalized. For joint ventures: "Share Of Profit Loss Of Associates" = 10,000,000. This is equity earnings, not in EBITDA. For proportional EBITDA, we'd add our share of JV EBITDA. But we don't have JV financials. This is typically not material enough to estimate without data. So: **Adjusted_EBITDA = 1,200,900,000 + 41,600,000 = 1,242,500,000 EUR** Wait - let me reconsider. The 41,600,000 is "Capital Gains Losses And Other Non Monetary Elements". If it's capital losses (non-recurring), we add back. But "Other Non Monetary Elements" might include recurring non-monetary items. Given we can't separate, and S&P typically normalizes for capital gains/losses, I'll use +41,600,000. Actually, re-thinking: In cash flow statements, "Capital Gains Losses" as a positive adjustment typically means we're adding back losses (which reduced profit) or subtracting gains. The sign convention: if it says "Capital Gains Losses" and the amount is positive, and it's an adjustment to reconcile profit to cash flow, then: - If it was a gain (increased profit), we subtract it (negative adjustment) - If it was a loss (decreased profit), we add it (positive adjustment) Since the adjustment is positive 41,600,000, this means we had losses of 41,600,000 that we're adding back. So for normalized EBITDA, we should add back these losses (they reduced operating profit). But wait - are these in operating profit? "Capital Gains Losses" are typically not in operating profit (they're usually below operating profit, in financing or exceptional items). Let me check: In the P&L, we have "Profit Loss From Operating Activities" = 533,800,000. Then "Share Of Profit Loss Of Associates" = 10,000,000. Then "Finance Income" = 82,200,000. Then "Finance Costs" = 217,200,000. Then "Finance Income Cost" = -125,000,000 (net). Then "Profit Loss Before Tax" = 408,800,000. So 533,800 + 10,000 - 125,000 = 418,800, not 408,800. Hmm, discrepancy of 10,000,000. Unless finance net is -135,000, not -125,000. Actually, re-checking: "Finance Income" = 82,200,000. "Finance Costs" = 217,200,000. "Finance Income Cost" = -125,000,000. But 82,200 - 217,200 = -135,000. The difference is 10,000,000. Maybe "Share Of Profit Loss Of Associates" includes some finance-related items, or there's a reclassification. Regardless, capital gains/losses are typically not in operating profit. So if 41,600,000 is a cash flow adjustment, it might be adjusting from net income, not operating profit. Or it could be in operating profit as "Other Expense By Nature" or similar. Given the uncertainty, and that 41,600,000 is relatively small (~3.5% of EBITDA), I'll include it as a normalization adjustment but note it could go either way. Let me also check "Change In Provision For Risks And Charges" = -27,800,000. This is a provision release (reduction), which increased profit. For normalized EBITDA, we might want to exclude this. But it's already in operating profit. If we add it back (since it reduced expenses artificially), we get higher EBITDA. Actually, provision releases are typically considered non-recurring or at least non-cash benefits. For S&P normalization, we might add back provision releases (which increased profit) or subtract them. Actually, we want to normalize, so if a provision release artificially boosted profit, we should subtract it for normalized EBITDA. Hmm, but "Allocation To Provisions Excluding Change In Provision For Risks And Charges" = 188,500,000 was added to expenses (reducing profit). And "Change In Provision For Risks And Charges" = -27,800,000 means the provision decreased, which means some of the allocation was reversed or used. This is confusing. Let me try a different approach. Looking at the cash flow: "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000. This is essentially EBITDA minus working capital changes, or more precisely, operating cash flow before working capital. If Adjusted_EBITDA = 1,242,500,000 (with +41,600,000), then cash interest and taxes would get us to FFO. Actually, let me step back. The S&P formula for FFO is: FFO = Adjusted_EBITDA - cash_interest - cash_taxes And from cash flow: "Finance Income Received Classified As Operating Activities" = 41,800,000. "Finance Costs Paid Classified As Operating Activities" = 128,000,000. So net cash interest paid = 128,000 - 41,800 = 86,200,000. "Income Taxes Paid Classified As Operating Activities" = 165,900,000. So if FFO = Adjusted_EBITDA - cash_interest - cash_taxes, and we also know that "Cash Flows From Used In Operating Activities" = 35,700,000 (which includes working capital changes), we can work backwards. Actually, let me use the cash flow data more directly. "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000. This is essentially: Operating profit + depreciation - cash taxes paid (some) + other adjustments... Actually, this 1,202,000,000 is very close to my EBITDA of 1,200,900,000. The difference is 1,100,000, essentially rounding or minor items. So "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000 can be thought of as roughly EBITDA adjusted for cash items. Then: FFO = this - working capital impact - cash interest? No, the 1,202,000,000 already includes interest and tax adjustments. Let me look at the components again: - Operating profit: 533,800 - + Depreciation: 478,600 - + Provisions: 188,500 - - Equity earnings: -10,000 - + Finance costs (net): 135,000? - + Capital losses: 41,600 - - Provision change: -27,800 - - Employee benefits change: -12,700 Sum: 1,327,000, but reported as 1,202,000. The difference is 125,000,000, which equals the "Finance Income Cost". Ah! I think "Adjustments For Finance Income Cost" = 135,000,000 is actually adding back the gross finance cost, not net. But then we'd double count with "Finance Income". Actually, I think the cash flow starts from "Profit Loss" (305,300,000), not operating profit. Let me try: 305,300 + 478,600 + 188,500 - 10,000 + 135,000 + 41,600 - 27,800 - 12,700 = 1,098,500. Not 1,202,000. Or from "Profit Loss Before Tax" (408,800): 408,800 + 478,600 + 188,500 - 10,000 + 41,600 - 27,800 - 12,700 = 1,067,000. Not 1,202,000. Hmm. Let me try: 533,800 (operating) + 478,600 (depreciation) + 188,500 (provisions) + 41,600 (losses) - 27,800 (provision release) - 12,700 (employee benefits) = 1,202,000. Yes! 533,800 + 478,600 = 1,012,400; +188,500 = 1,200,900; +41,600 = 1,242,500; -27,800 = 1,214,700; -12,700 = 1,202,000. ✓ So the equity earnings (-10,000) and finance costs (+135,000) are NOT in this subtotal. The "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000 excludes these items. This means the cash flow statement structure is: - Start with Operating Profit - Add back depreciation, provisions, losses, etc. - Get to "Cash Flows From Used In Operations Before Changes In Working Capital" - Then working capital changes - Then operating cash flows including interest and tax Actually, looking at the sequence: after "Cash Flows From Used In Operations Before Changes In Working Capital", we have working capital changes, then "Dividends Received", "Finance Income Received", "Finance Costs Paid", "Income Taxes Paid", to get to "Cash Flows From Used In Operating Activities". So "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000 is before working capital, interest, and taxes. This is essentially: EBITDA + non-cash/non-operating adjustments = 1,202,000,000. And my calculation: 1,200,900,000 + 41,600,000 - 27,800,000 - 12,700,000 = 1,202,000,000. ✓ So this 1,202,000,000 is NOT EBITDA, it's "operating cash flow before working capital and before interest and taxes". For S&P FFO, we want: Adjusted_EBITDA - cash_interest - cash_taxes. From the cash flow: - Finance Income Received = 41,800,000 - Finance Costs Paid = 128,000,000 - Income Taxes Paid = 165,900,000 So cash_interest_net = 128,000 - 41,800 = 86,200,000 (paid) Or cash_interest_paid_gross = 128,000,000 For S&P, "cash interest" typically means interest paid, not net of interest received. So cash_interest = 128,000,000. Cash taxes = 165,900,000. So FFO = Adjusted_EBITDA - 128,000,000 - 165,900,000 = Adjusted_EBITDA - 293,900,000. Now, what is Adjusted_EBITDA? From the 1,202,000,000, we can work backwards. This 1,202,000,000 includes: - Operating profit 533,800 - + Depreciation 478,600 - + Provisions 188,500 - + Losses 41,600 - - Provision release 27,800 - - Employee benefits 12,700 For S&P Adjusted_EBITDA, we want normalized EBITDA. The 1,202,000,000 has some normalization items already (provisions, losses). Actually, let me think differently. S&P Adjusted_EBITDA is typically: Reported EBITDA + adjustments for non-recurring items + lease adjustments + pension adjustments + JV adjustments. Reported EBITDA = 1,200,900,000 (as calculated: operating profit + depreciation). Adjustments: - Capital losses of 41,600,000 (non-recurring): add back = +41,600,000 - Provision release of 27,800,000 (non-recurring benefit): subtract = -27,800,000 - Employee benefits change of 12,700,000 (non-cash benefit): subtract = -12,700,000 Wait, but these last two are already in operating profit. The provision release reduced expenses, increasing profit. For normalized EBITDA, we want to exclude this benefit. So subtract 27,800,000. Similarly, employee benefits change - this is a non-cash reduction in liability, which reduced expenses. Subtract 12,700,000. But actually, these are already reflected in the operating profit. Let me check if they're in "Employee Benefits Expense" or elsewhere. "Employee Benefits Expense" = 601,100,000. This includes service cost, interest cost, etc. The "Adjustments For Increase Decrease In Employee Benefit Liabilities" = -12,700,000 is a cash flow adjustment, meaning the expense was 12,700,000 less than cash paid, or more likely, the liability decreased by 12,700,000 more than expected, meaning past service cost was released. This is getting very detailed. Let me use a practical approach: **Adjusted_EBITDA = 1,200,900,000 + 41,600,000 = 1,242,500,000 EUR** I'll add back the capital losses (non-recurring), and ignore the smaller provision/employee benefit items as they're already in the base and difficult to normalize without more data. Actually, for more precision, let me use the "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000 as a check. This includes the capital losses (+41,600), provision change (-27,800), and employee benefits (-12,700). If we reverse these to get to "pure" EBITDA: 1,202,000 - 41,600 + 27,800 + 12,700 = 1,200,900. ✓ This matches my EBITDA. So for Adjusted_EBITDA, if we want to normalize by adding back losses but keeping provision and employee benefit changes as operational: 1,202,000 + 27,800 + 12,700 = 1,242,500? No wait, that doesn't make sense. Let me think again. The 1,202,000 is "operating cash before working capital, interest, taxes". It's not EBITDA. To get to EBITDA from 1,202,000: - Add back provision change 27,800 (this was a use of cash or reduction in expense?) - Add back employee benefits change 12,700 - Subtract capital losses 41,600 (these are not in EBITDA, they're non-operating) Actually no - the 1,202,000 was computed FROM EBITDA-like base by adding losses and subtracting provision releases. Let me re-trace: - Start: Operating profit 533,800 - Add depreciation 478,600 → 1,012,400 (this is EBITDA excluding provisions and other items) - Add provisions 188,500 → 1,200,900 (this is like EBITDAP or EBITDA including provision charge) - Add losses 41,600 → 1,242,500 - Subtract provision release 27,800 → 1,214,700 - Subtract employee benefits 12,700 → 1,202,000 Hmm, so 1,200,900 is "EBITDA with provision charge". True EBITDA is 1,012,400 (just operating profit + depreciation). But then we have 188,500 of provisions which are like operating items. For S&P, EBITDA typically includes recurring provision charges. The 188,500 is "Allocation To Provisions Excluding Change In Provision For Risks And Charges" - this is the provision charge for the year, an expense. So EBITDA = 1,012,400 + 188,500 = 1,200,900 if we consider provisions as operating. But wait, provisions are typically not in EBITDA - they're below EBITDA. Actually, in standard EBITDA calculation, we start from operating profit and add back depreciation. Operating profit already includes provision charges as expenses. So: Operating profit = Revenue - COGS - Operating expenses - Depreciation - Provisions... Wait, "Amortisation Depreciation And Provisions" = 667,100,000 is a single line item. So operating profit = Revenue - Expenses - (Depreciation + Provisions). So EBITDA (standard) = Operating profit + Depreciation + Provisions? No, standard EBITDA = Operating profit + Depreciation only, where "Depreciation" is just depreciation, not provisions. But here, "Amortisation Depreciation And Provisions" is combined. We can't separate depreciation from provisions in the P&L. However, in cash flow, "Adjustments For Depreciation And Amortisation Expense And Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss" = 478,600,000. This is the depreciation and amortization. And "Allocation To Provisions Excluding Change In Provision For Risks And Charges" = 188,500,000 is separate. So in the P&L, the 667,100,000 includes both 478,600,000 (depreciation) and 188,500,000 (provisions). Therefore, standard EBITDA = Operating profit + Depreciation only = 533,800 + 478,600 = 1,012,400,000. But then we have provisions of 188,500,000 which are operating expenses in the P&L. For S&P, should these be in EBITDA? Provisions for bad debts, warranties, etc. are typically operating and stay in EBITDA. But "Allocation To Provisions" might include non-recurring items. Actually, for regulated utilities, provisions for decommissioning, environmental, etc. might be recurring. I'll assume provisions are part of operations. So **EBITDA = 1,012,400,000 + 188,500,000? No, that's double counting. Let me recalculate from revenue: Revenue: 20,630,200 Expenses (excluding depreciation and provisions): - Raw materials: 16,730,000 - Services: 2,105,800 - Employee benefits: 601,100 - Other expense: 74,900 - Less capitalized: -82,500 Total expenses = 19,429,300 Operating profit before depreciation and provisions = 20,630,200 - 19,429,300 = 1,200,900 Then depreciation and provisions = 667,100 Operating profit = 533,800 So "EBITDA" if we define as earnings before depreciation, amortization, and provisions = 1,200,900. But standard EBITDA is before depreciation and amortization only, not provisions. Standard EBITDA = Operating profit + Depreciation + Amortization = 533,800 + 478,600 = 1,012,400 (assuming 478,600 is the depreciation portion). But we don't know the exact split. The cash flow calls 478,600 "Depreciation And Amortisation Expense And Impairment Loss Reversal Of Impairment Loss". This includes impairment. And 188,500 is "Allocation To Provisions". For practical purposes, S&P often uses "EBITDA" broadly. The 1,200,900 figure (operating profit before depreciation, amortization, and provisions) is a useful metric. Actually, looking at S&P methodology for regulated utilities: "We typically use the EBITDA margin as key indicator of profitability, unless it is distorted..." So they use standard EBITDA. Given the data, I'll use: **EBITDA = 1,200,900,000** (operating profit + total amortization/depreciation/provisions, as reported in the P&L line item) This is consistent with how many companies report "EBITDA" when depreciation and provisions are combined. For Adjusted_EBITDA: - Add non-recurring losses: +41,600,000 (capital losses) - The provision change and employee benefit changes are already reflected in the base So **Adjusted_EBITDA = 1,242,500,000 EUR** ## Step 3: Estimate FFO FFO = Adjusted_EBITDA - cash_interest - cash_taxes From cash flow statement: - Finance Costs Paid Classified As Operating Activities = 128,000,000 - Finance Income Received Classified As Operating Activities = 41,800,000 - Income Taxes Paid Classified As Operating Activities = 165,900,000 For S&P, cash_interest is typically interest paid (gross), not net. So: cash_interest = 128,000,000 EUR cash_taxes = 165,900,000 EUR FFO = 1,242,500,000 - 128,000,000 - 165,900,000 = **948,600,000 EUR** Wait - but we also need to consider if dividends received should be in FFO. "Dividends Received Classified As Operating Activities" = 13,400,000. S&P sometimes includes dividends from operating activities in FFO. Let me check the cash flow: these are classified as operating, so they might be included. Actually, looking at the cash flow structure, dividends received are after "Cash Flows From Used In Operations Before Changes In Working Capital" and after working capital changes. They're part of operating cash flow. For FFO, S&P typically includes dividends received from investments if they're part of operations. But in the formula FFO = Adjusted_EBITDA - cash_interest - cash_taxes, dividends aren't included. However, some S&P methodologies add dividends received to FFO. Let me check if this is material: 13,400,000 vs 948,600,000 = 1.4%. I'll exclude it for now as the formula doesn't specify, but note it could be added. Actually, re-reading the workflow: "FFO = Adjusted_EBITDA - cash_interest - cash_taxes". This is the specified formula. I'll follow it strictly. But wait - is "cash_interest" net or gross? The formula says "cash_interest", not "cash_interest_paid". In S&P methodology, this is typically cash interest paid (gross), not net of interest received. Interest received is typically excluded or considered separately. However, for regulated utilities, interest income might be operational. Let me use cash_interest = 128,000,000 (paid). FFO = 1,242,500,000 - 128,000,000 - 165,900,000 = 948,600,000 EUR ## Step 4: Estimate Adjusted_Debt Adjusted_Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash First, reported debt. From balance sheet 2023-01-01 (year-end 2022): - Noncurrent Financial Liabilities: 5,689,900,000 - Current Financial Liabilities: 650,100,000 - Total reported debt = 6,340,000,000 EUR Leases: - Noncurrent Lease Liabilities: 55,100,000 - Current Lease Liabilities: 21,300,000 - Total leases = 76,400,000 EUR Pension deficit: - "Noncurrent Provisions For Employee Benefits" = 92,000,000 (2023-01-01) - This is a liability, but is it a pension deficit? We need to check if there are plan assets. Without plan asset data, we assume this is the net pension liability (IFRS typically nets plan assets against liabilities). - Actually, under IAS 19, the balance sheet shows the net position (surplus or deficit). So 92,000,000 is likely the net pension deficit. However, S&P typically uses the "deficit" or "funded status". If the 92,000,000 is the net liability, that's the pension deficit. But we need to check if it's already in debt-like items. Actually, for S&P, pension deficit is added to debt if it's a net liability. The 92,000,000 is "Provisions For Employee Benefits", which includes more than just pensions (it includes other post-employment benefits). But we'll use this as the pension-related amount. Guarantees: Not disclosed separately, assume 0. Hybrid debt portion: Not disclosed, assume 0. Other debt-like items: - "Other Longterm Provisions" = 565,600,000 - these might be debt-like if they're environmental, decommissioning, etc. For regulated utilities, these are often operational and already considered in cash flows. S&P sometimes includes certain provisions as debt-like. - "Noncurrent Derivative Financial Liabilities" = 6,300,000 - these are mark-to-market, not debt-like typically - "Current Derivative Financial Liabilities" = 1,347,600,000 - these could be debt-like if they're hedges of debt, but typically not included as debt For regulated utilities, S&P mentions netting seasonal working capital: "we adjust inventory and debt balances by netting the value of inventory against outstanding short-term borrowings." Looking at the data: - Inventories: 995,100,000 (2023-01-01) - Current Financial Liabilities: 650,100,000 (short-term borrowings) If we net inventory against short-term borrowings: 995,100 - 650,100 = 345,000,000 excess inventory. This doesn't reduce debt below zero, so we'd set short-term borrowings to 0 and not subtract more. Actually, the S&P methodology says: "netting the value of inventory against outstanding short-term borrowings. This adjustment informs balance sheet analysis by reducing seasonal debt balances when we are very confident of near-term cost recovery." So if inventory > short-term borrowings, short-term borrowings = 0 for seasonal adjustment purposes, and we don't create a negative. Adjusted short-term borrowings = max(0, 650,100 - 995,100) = 0? No, we net inventory against ST borrowings, reducing ST borrowings by inventory value, but not below zero. So seasonal adjusted ST borrowings = 650,100 - 995,100 = -345,000, but we cap at 0? Or do we only net to the extent of ST borrowings? Typically: ST borrowings are reduced by inventory value, but not below zero. So adjusted ST borrowings = 0, and we don't have negative debt. But this seems odd - we're eliminating all current financial liabilities. Let me re-read: "netting the value of inventory against outstanding short-term borrowings." This suggests: if you have 100 inventory and 80 ST borrowings, net ST borrowings = 0 (and you have 20 excess inventory). If you have 100 inventory and 120 ST borrowings, net ST borrowings = 20. So for Hera: inventory 995,100 > ST borrowings 650,100. Net ST borrowings = 0. But wait - this is for "seasonal working capital requirements" that "distort leverage measures." Is Hera's inventory seasonal? Looking at 2022-01-01 inventory: 368,000,000. 2023-01-01: 995,100,000. This is a huge increase, likely due to energy price volatility (gas/electricity inventory). This could be seasonal or market-driven. For regulated utilities with seasonal gas storage, this adjustment applies. So I'll use it. Adjusted current financial liabilities = max(0, 650,100 - 995,100) = 0? Actually, the netting is: ST borrowings are reduced by inventory, but not below zero. So 650,100 - 995,100 = negative, so we use 0. But this seems aggressive. Let me check if there's a cap: typically we only net to the extent that inventory is "seasonal" and debt is short-term. If inventory increased due to price spikes (not volume), the value may not be fully realizable at that value. Actually, looking at 2021 inventory: not given directly, but "Inventories" 2022-01-01 = 368,000,000. 2023-01-01 = 995,100,000. This 2.7x increase is likely due to energy price increases in 2022 (Ukraine war). The volume may not have changed much. For S&P's seasonal adjustment, they net inventory against ST borrowings when "we are very confident of near-term cost recovery." For a utility with regulatory cost recovery, this confidence exists. So adjusted current financial liabilities = 0 (after netting). But wait - we also have "Current Derivative Financial Liabilities" = 1,347,600,000. Are these part of debt? Typically derivatives are mark-to-market and not included in debt. Let me also check "Noncurrent Financial Liabilities" - these are long-term debt. Do we adjust these? No, the seasonal adjustment is for short-term borrowings only. So adjusted debt components: - Noncurrent Financial Liabilities: 5,689,900,000 - Adjusted Current Financial Liabilities: 0 (after netting with inventory) - Leases: 76,400,000 - Pension deficit (net): 92,000,000 But wait - we need to check if pension is already included in debt. "Noncurrent Provisions For Employee Benefits" is a provision, not financial liability. So we add it. Other debt-like items: "Other Longterm Provisions" = 565,600,000. These could include environmental, decommissioning, legal provisions. S&P sometimes includes these as debt-like if they're probable and measurable. For utilities, decommissioning and environmental provisions are often treated as debt-like. However, without knowing the composition, I'll be conservative and include a portion or exclude. Given the methodology doesn't specify, and these are typical utility provisions, I'll include 50% or exclude. Let me exclude for now as they're operational provisions. Eligible cash: "Cash And Cash Equivalents" = 1,942,400,000 (2023-01-01). S&P typically subtracts "available cash" or "surplus cash". For regulated utilities, they may not subtract all cash due to regulatory requirements. But without specific guidance, I'll subtract all cash or a portion. S&P typically uses "cash and liquid investments" less "restricted cash". Assuming no restricted cash is disclosed, eligible cash = 1,942,400,000. But this seems high - it would significantly reduce debt. Let me check if this is reasonable. Total debt is ~6.3 billion, cash is 1.9 billion. Net debt would be ~4.4 billion. However, for regulated utilities with seasonal working capital, cash may be needed for operations. S&P sometimes uses a "minimum cash" approach. Given the workflow says "eligible_cash", I'll use the full cash amount unless there's clear evidence of restriction. But wait - the seasonal working capital adjustment already netted inventory against ST borrowings. If we also subtract cash, we might be double-counting the working capital benefit. Let me re-think: The seasonal adjustment is a balance sheet presentation adjustment. It reduces both working capital and debt. The cash is separate. Actually, for S&P's standard approach: Adjusted_Debt = Gross Debt - Cash and Equivalents Where Gross Debt includes all interest-bearing liabilities + leases + pension deficit + other debt-like. So: Gross Debt = 5,689,900 + 650,100 + 76,400 + 92,000 = 6,508,400 (in thousands, i.e., 6.508 billion) Less: eligible cash = 1,942,400 Adjusted_Debt = 6,508,400 - 1,942,400 = 4,566,000,000 But with seasonal adjustment to current debt: Gross Debt = 5,689,900 + 0 (seasonally adjusted) + 76,400 + 92,000 = 5,858,300 Adjusted_Debt = 5,858,300 - 1,942,400 = 3,915,900,000 Hmm, this seems too low. Let me reconsider the seasonal adjustment. Actually, re-reading S&P: "we adjust inventory and debt balances by netting the value of inventory against outstanding short-term borrowings. This adjustment informs balance sheet analysis by reducing seasonal debt balances" This suggests we reduce both inventory and debt in the analysis. But for the debt calculation, we reduce debt. For leverage, we also reduce the asset side (inventory). This is a net-zero effect on equity, but reduces both debt and assets. So if we have ST borrowings of 650,100 and inventory of 995,100, we can net 650,100 of inventory against ST borrowings, leaving ST borrowings at 0 and inventory at 345,000. Adjusted_Debt = (5,689,900 + 0 + 76,400 + 92,000) - 1,942,400 = 3,915,900,000 Or if we don't fully eliminate ST borrowings but just reduce by inventory value (even if negative): Adjusted ST borrowings = 650,100 - 995,100 = -345,000, but we don't report negative debt, so 0. I'll use this approach. But wait - I need to check if "Current Financial Liabilities" includes only borrowings or also other items. In IFRS, "Financial Liabilities" typically means interest-bearing debt. So 650,100 is likely short-term borrowings. However, looking at the balance sheet structure, "Current Financial Liabilities" might include derivatives or other items. But given the name, it's likely borrowings. Let me also check if there are other current debt-like items: "Current Derivative Financial Liabilities" = 1,347,600,000. These are mark-to-market derivatives, not borrowings. S&P typically excludes these from debt unless they're hedges of debt and in an asset-liability pair. Actually, for a utility with commodity hedges, these derivative liabilities represent future obligations. But they're typically settled in net terms and fluctuate with prices. S&P usually excludes commodity derivatives from debt. So my Adjusted_Debt calculation: - Noncurrent Financial Liabilities: 5,689,900,000 - Current Financial Liabilities (seasonally adjusted): 0 - Noncurrent Lease Liabilities: 55,100,000 - Current Lease Liabilities: 21,300,000 - Pension deficit (Noncurrent Provisions For Employee Benefits): 92,000,000 - Total gross debt-like: 5,858,300,000 - Less: Cash And Cash Equivalents: 1,942,400,000 - **Adjusted_Debt = 3,915,900,000 EUR** But this seems quite low. Let me reconsider if I should apply the seasonal adjustment. The inventory increase from 368M to 995M is 627M, which matches the cash flow "Adjustments For Decrease Increase In Inventories" = 627,400,000 (use of cash). This inventory build-up was financed somehow. Looking at cash flow: the operating cash flow before working capital was 1,202,000, but after working capital changes of -927,600,000 (mainly inventory increase), operating cash flow became 35,700,000. So the inventory was financed by operating cash flow reduction, not necessarily by debt. Actually, looking at financing activities: "Proceeds From Noncurrent Borrowings" = 2,127,000,000. This is significant debt issuance. Some of this likely went to finance inventory. For the seasonal adjustment, S&P says to net inventory against ST borrowings "when we are very confident of near-term cost recovery." For a regulated utility, this confidence exists. But the inventory build-up in 2022 was extraordinary due to energy crisis, not normal seasonality. Given this, I'll apply the seasonal adjustment but with caution. Alternatively, I might not apply it fully. Let me try without seasonal adjustment first: Gross debt = 5,689,900 + 650,100 + 76,400 + 92,000 = 6,508,400 Adjusted_Debt = 6,508,400 - 1,942,400 = 4,566,000,000 And with seasonal adjustment: Adjusted_Debt = 3,915,900,000 The difference is significant (650M). Given the energy crisis was extraordinary, I'll use the non-seasonally-adjusted figure as more representative of normal operations, or apply a partial adjustment. Actually, re-reading S&P more carefully: "Where substantial seasonal working capital requirements--for example, at natural gas distribution utilities--distort leverage measures, we adjust inventory and debt balances by netting the value of inventory against outstanding short-term borrowings." Hera is a multi-utility with gas distribution. The inventory is likely gas storage for winter heating season. This is seasonal. So the adjustment applies. But the 2022 inventory increase was extraordinary. Let me check 2021: "Inventories" 2022-01-01 = 368,000,000. 2023-01-01 = 995,100,000. The average or normal inventory might be around 400-500M. For S&P's adjustment, they use the actual inventory balance. So 995,100,000 is the amount to net. I'll apply the adjustment: **Adjusted_Debt = 3,915,900,000 EUR** Wait - I need to double-check my lease and pension numbers. The total leases I used were 76,400,000. But in the seasonal adjustment, I eliminated current financial liabilities. Do I also eliminate current lease liabilities? No, leases are separate from borrowings. Actually, let me re-verify: "Current Financial Liabilities" = 650,100,000. "Current Lease Liabilities" = 21,300,000. These are separate line items. So my calculation is correct. But I want to double-check the pension. "Noncurrent Provisions For Employee Benefits" = 92,000,000. Is this a "deficit"? Under IAS 19, the balance sheet shows the net funded status. If it's a liability, it's a deficit. So yes, add to debt. However, some of this might be other post-employment benefits, not just pension. But for S&P, all employee benefit liabilities are typically treated similarly. ## Step 5: Calculate FFO / Adjusted_Debt FFO = 948,600,000 Adjusted_Debt = 3,915,900,000 FFO / Adjusted_Debt = 948,600,000 / 3,915,900,000 = 0.2422 Let me verify my calculations and consider if I need adjustments. Rechecking FFO: Adjusted_EBITDA = 1,242,500,000 cash_interest = 128,000,000 cash_taxes = 165,900,000 FFO = 1,242,500 - 128,000 - 165,900 = 948,600,000 ✓ Rechecking Adjusted_Debt: Noncurrent Financial Liabilities: 5,689,900 Current Financial Liabilities (after netting with inventory): 0 (650,100 - 995,100 = negative, so 0) Noncurrent Lease Liabilities: 55,100 Current Lease Liabilities: 21,300 Pension deficit: 92,000 Total: 5,858,300 Less Cash: 1,942,400 Adjusted_Debt: 3,915,900 ✓ Ratio: 948,600 / 3,915,900 = 0.24224... ≈ 0.2422 But let me reconsider if I should use the non-seasonally-adjusted debt. If I use that: Adjusted_Debt = 6,508,400 - 1,942,400 = 4,566,000 FFO / Adjusted_Debt = 948,600 / 4,566,000 = 0.2078 Which is more appropriate? Given S&P specifically mentions this adjustment for utilities with seasonal working capital, and Hera is a gas utility with seasonal inventory, I should apply it. But the extraordinary nature of 2022 makes me cautious. Let me also check if there's another way to interpret the seasonal adjustment. Perhaps we only net to the extent that inventory is "seasonal" - i.e., the increase from normal levels. Normal inventory might be ~400M (based on 2021), and seasonal peak might be 600M, with the remaining 400M being price-related. If we only net the seasonal portion (200M increase), then adjusted ST borrowings = 650,100 - 200,000 = 450,100. But S&P doesn't specify this nuanced approach. They say "netting the value of inventory against outstanding short-term borrowings." Given the ambiguity, let me use the full adjustment as specified, but note that the ratio is sensitive to this. Actually, let me re-read the workflow instructions. They say "Use the following baseline formula, modifying it as required by the industry methodology identified in Step 1." The regulated utilities methodology specifically mentions this adjustment. So I should apply it. Final calculation: 948,600 / 3,915,900 = 0.24224... Rounded to four decimal places: 0.2422 But wait - I want to double-check my Adjusted_EBITDA. Should I include the provision and employee benefit changes? If I use a cleaner EBITDA approach: EBITDA (standard) = Operating profit + Depreciation only = 533,800 + 478,600 = 1,012,400 Plus provisions (if considered operating): +188,500 = 1,200,900 Plus capital losses (non-recurring): +41,600 = 1,242,500 This is what I used. But if provisions are non-recurring or non-cash in nature, maybe I shouldn't add them. However, for utilities, provision charges are typically recurring (regulatory cost recovery, environmental, etc.). Actually, looking at the cash flow, "Allocation To Provisions Excluding Change In Provision For Risks And Charges" = 188,500,000 is added back to operating profit to get to cash flow. This suggests it's a non-cash expense. But it's still an operating expense for EBITDA purposes. Hmm, but in standard EBITDA, we don't add back provisions - they're already in operating profit. The depreciation add-back is what gets us to EBITDA. Provisions stay in EBITDA. Wait, I need to be clearer. Let me recalculate: - Revenue: 20,630,200 - Operating expenses (cash-like): 16,730,000 + 2,105,800 + 601,100 + 74,900 - 82,500 = 19,429,300 - EBITDA (before non-cash provisions) = 20,630,200 - 19,429,300 = 1,200,900 But this "EBITDA" includes no provision charge. The operating profit of 533,800 includes the 667,100 of depreciation+provisions. So: 1,200,900 - 667,100 = 533,800 operating profit. So 1,200,900 is "EBITDA before provision charge" or "EBITDAP". Standard EBITDA would be 1,200,900 - 188,500 (provisions) = 1,012,400? No, that's not right either. Actually, let me think about this differently. The P&L line "Amortisation Depreciation And Provisions" = 667,100 includes both: - Depreciation and amortization: 478,600 (from cash flow) - Provisions: 188,500 (from cash flow) Operating profit = Revenue - Expenses - 667,100. Standard EBITDA = Operating profit + Depreciation/Amortization = 533,800 + 478,600 = 1,012,400. But this 1,012,400 still includes the 188,500 provision charge as an expense. So it's "EBITDA with provision charge included." For S&P, is this the right EBITDA? Or should we add back provisions too? Provisions are non-cash charges, so in some EBITDA definitions, they're added back. But standard EBITDA doesn't add back all non-cash charges - only depreciation and amortization. However, for S&P's "Adjusted EBITDA", they might add back certain non-cash items if they're non-recurring or non-operational. Given the ambiguity, and that 188,500 is a provision "allocation" (expense), I'll keep it in EBITDA as part of operations. My 1,200,900 figure effectively adds back all of "Amortisation Depreciation And Provisions", which is broader than standard EBITDA. Let me use a more conservative, standard EBITDA: EBITDA = 533,800 + 478,600 = 1,012,400 (only adding back depreciation, not provisions) Then Adjusted_EBITDA = 1,012,400 + 41,600 (losses) = 1,054,000,000 FFO = 1,054,000 - 128,000 - 165,900 = 760,100,000 FFO / Adjusted_Debt = 760,100 / 3,915,900 = 0.1941 Or with non-seasonal debt: 760,100 / 4,566,000 = 0.1665 This is quite different. Which EBITDA is right? Looking back at the cash flow: "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000. This is roughly "EBITDA + provisions - other adjustments" or more precisely, it's the cash generation before working capital. If I compare: 1,202,000 vs my 1,054,000 (EBITDA) vs 1,242,500 (EBITDAP). The 1,202,000 is in between. Actually, 1,202,000 = 1,200,900 (my EBITDAP) - 27,800 (provision release) - 12,700 (employee benefits) + adjustments. Or 1,202,000 = 1,012,400 (standard EBITDA) + 188,500 (provisions) + 41,600 (losses) - 27,800 - 12,700 = 1,202,000. Yes! So "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000 includes: - Standard EBITDA: 1,012,400 - Plus provisions: 188,500 - Plus losses: 41,600 - Less provision release: -27,800 - Less employee benefits: -12,700 For S&P FFO, they often use this "cash flow before working capital" as a starting point, or they use Adjusted EBITDA - cash interest - cash taxes. Given the formula specified in the workflow: FFO = Adjusted_EBITDA - cash_interest - cash_taxes, and Adjusted_EBITDA should be normalized, I think my original 1,242,500 is reasonable as it includes the non-recurring losses add-back. But to be more conservative with standard EBITDA: Adjusted_EBITDA = 1,012,400 + 188,500 (provisions, recurring for utility) + 41,600 (losses, non-recurring) = 1,242,500. Same result! Wait, if provisions are recurring, they're in EBITDA. So standard EBITDA = 1,012,400 + 188,500 = 1,200,900? No, that's wrong. Standard EBITDA doesn't add back provisions. Let me be very precise. In the P&L: Revenue - COGS - SG&A - Depreciation - Provisions = Operating Profit Standard EBITDA = Revenue - COGS - SG&A = Operating Profit + Depreciation + Provisions? No! Standard EBITDA = Operating Profit + Depreciation + Amortization (only) So if Operating Profit already has Provisions deducted, then: Standard EBITDA = Operating Profit + Depreciation + Amortization = 533,800 + 478,600 = 1,012,400. This 1,012,400 still has the 188,500 provision charge embedded in it (as an expense that reduced operating profit). For "Adjusted EBITDA" that S&P uses, they might use a broader measure that includes certain recurring non-cash items. But typically, S&P uses standard EBITDA or EBITDAR (with rents). Given the confusion, let me use the most straightforward approach: - Start from "Profit Loss From Operating Activities" = 533,800 - Add back "Amortisation Depreciation And Provisions" = 667,100 - This gives 1,200,900, which is "EBITDA including provisions" or "EBITDAP" This is what the P&L structure implies when depreciation and provisions are combined in one line. For S&P, this 1,200,900 is a reasonable starting point for "EBITDA" in this context, given the P&L presentation. Then Adjusted_EBITDA = 1,200,900 + 41,600 = 1,242,500. I'll stick with this. Final verification of numbers: - Adjusted_EBITDA: 1,242,500,000 - Cash interest paid: 128,000,000 - Cash taxes paid: 165,900,000 - FFO: 948,600,000 - Noncurrent Financial Liabilities: 5,689,900,000 - Current Financial Liabilities: 650,100,000 - Inventory: 995,100,000 - Seasonally adjusted current debt: max(0, 650,100 - 995,100) = 0 - Leases: 76,400,000 - Pension: 92,000,000 - Cash: 1,942,400,000 - Adjusted_Debt: 5,689,900 + 0 + 76,400 + 92,000 - 1,942,400 = 3,915,900,000 Wait, I need to re-add: 5,689,900 + 0 + 76,400 + 92,000 = 5,858,300. Less 1,942,400 = 3,915,900. ✓ Ratio: 948,600 / 3,915,900 = 0.242235... Rounded to four decimal places: 0.2422 Actually, let me double-check the rounding: 0.242235... the fifth decimal is 3, so we round down to 0.2422. But I want to reconsider one more time if I should include leases in debt. The S&P formula says "leases" explicitly. For IFRS 16, leases are already on balance sheet. So yes, include them. Also, should I include the pension deficit? The formula says "pension_deficit". The 92,000 is a provision for employee benefits, which is likely the net pension liability. Yes, include it. One more check: are there any hybrid securities or guarantees? Not disclosed in the data, so 0. And "other_debt_like_items"? The "Other Longterm Provisions" = 565,600,000 could be considered. Let me think about including a portion. For utilities, long-term provisions often include: - Decommissioning/environmental: these are debt-like as they're future obligations - Legal/onerous contracts: may be debt-like - Restructuring: typically non-recurring Without knowing the composition, and that 565,600 is significant, I might include a portion. But S&P typically only includes specific types. Given the methodology doesn't explicitly mention these for regulated utilities (unlike oil & gas or other sectors), I'll exclude them to be consistent with the baseline formula. If I included them fully: Adjusted_Debt = 3,915,900 + 565,600 = 4,481,500, and ratio = 0.2117. But I think excluding them is more appropriate based on the methodology provided. Final answer: 0.2422 Wait - one more consideration. The workflow says "Round the final answer to four decimal places, using standard rounding." So 0.2422. But let me also verify my FFO calculation once more. The formula is FFO = Adjusted_EBITDA - cash_interest - cash_taxes. Is "cash_interest" the net or gross amount? In S&P methodology, "cash interest" typically refers to interest paid, not net of interest received. So 128,000,000 is correct. However, some S&P methodologies use "net cash interest" = interest paid - interest received = 128,000 - 41,800 = 86,200,000. If I use net: FFO = 1,242,500 - 86,200 - 165,900 = 990,400,000 Ratio = 990,400 / 3,915,900 = 0.2529 Which is correct? The workflow says "cash_interest", not "cash_interest_paid" or "net_cash_interest". In S&P's standard definition, FFO = EBITDA - cash interest - cash taxes, where cash interest is typically gross interest paid. But looking at the cash flow statement, "Finance Income Received" is classified as operating activities, and "Finance Costs Paid" is also operating. This suggests both are part of operations. For regulated utilities, interest income might be operational (regulatory mechanisms). But for FFO, S&P typically uses gross interest paid. I'll stick with gross: 128,000,000. Final answer: 0.2422 Actually, I want to do one more sanity check. Let me look at the ratio from a different angle. If I use "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,202,000,000, and subtract cash interest and taxes: 1,202,000 - 128,000 - 165,900 = 908,100,000. This is close to my FFO of 948,600,000. The difference is 40,500,000, which is roughly the capital losses add-back (41,600) net of other items. This gives me confidence that my FFO is in the right ballpark. Using 908,100 / 3,915,900 = 0.2319, or with seasonal adjustment not applied to debt: 908,100 / 4,566,000 = 0.1989. Given my Adjusted_EBITDA is higher than the cash flow subtotal (1,242,500 vs 1,202,000), my FFO is higher too. This is because I added back the capital losses. I think my calculation is reasonable. 0.2422