I'll work through this step-by-step, analyzing ACEA S.P.A. and calculating the S&P-adjusted FFO-to-debt ratio. ## Step 1: Identify the Relevant Industry ACEA S.P.A. is an Italian multi-utility company. Based on the facts provided: - Revenue from "Ricavi Da Vendita EPrestazioni" (Revenue from Sales and Services) of ~€4.96 billion - The company operates in regulated utility sectors (water, electricity, gas infrastructure) - Located in Italy with regulated operations This fits the **Regulated Utilities** sector, specifically **Multi-utilities**. I will apply the Regulated Utilities methodology with its specific adjustments. ## Step 2: Estimate Adjusted_EBITDA First, let me reconstruct EBITDA from the income statement data: **Starting from Operating Profit (EBIT):** - Profit Loss From Operating Activities (2022): €565,851,000 **Add back Depreciation & Amortization:** - "Ammortamenti EAccantonamenti" (Depreciation and Provisions): €625,799,000 - However, this includes more than just D&A. Looking at cash flow statement: - "Adjustments For Depreciation And Amortisation Expense": €594,636,000 **EBITDA = Operating Profit + D&A** - EBITDA = €565,851,000 + €594,636,000 = **€1,160,487,000** Let me verify with another approach: - Gross Profit: €1,305,021,000 - Employee Benefits Expense: €305,066,000 - Other external costs would be in operating expenses Actually, let me use: EBIT + D&A = €565,851,000 + €594,636,000 = €1,160,487,000 **Adjustments for Regulated Utilities:** From the methodology: - **Leases**: Add back operating lease expense (already in EBIT, so we need to consider IFRS 16 right-of-use assets) - Right-of-use assets 2023: €90,397,000; 2022: €53,096,000 - For regulated utilities, we need to consider lease adjustments. Under IFRS 16, leases are capitalized. S&P typically adds back lease expense and capitalizes lease debt. - Looking at the cash flow, there's no explicit lease expense. The "Adjustments For Depreciation And Amortisation Expense" likely includes ROU asset depreciation. Let me check if there are lease-related items in operating expenses or if we need to make adjustments. Given IFRS 16 is applied, leases are already in debt and D&A includes ROU depreciation. For S&P purposes, we typically: - Add back lease expense (not already in EBITDA since IFRS 16 capitalizes) - Actually, under IFRS 16, there's no lease expense in EBIT - it's replaced by depreciation and interest. Looking more carefully: The company uses IFRS 16. We need to estimate the lease expense that would exist under operating lease treatment. From balance sheet: Right-of-use assets 2022: €53,096,000; 2023: €90,397,000 The increase suggests significant lease activity. For a utility, typical approach is to use the "lease debt" equivalent. However, looking at the data, I don't see explicit lease liabilities broken out. Let me check financial liabilities. Actually, for regulated utilities, S&P notes: "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." And for purchased power contracts: "we use our purchased power methodology to adjust measures for such contracts' debt-like obligations." Looking at the facts, I don't see explicit purchased power contracts or significant seasonal working capital issues mentioned. Let me focus on what's available. For **Adjusted_EBITDA**: Baseline: EBITDA = EBIT + D&A = €565,851,000 + €594,636,000 = €1,160,487,000 **Nonrecurring items:** - "Impairment Loss Impairment Gain And Reversal Of Impairment Loss Determined In Accordance With IFRS9": €113,370,000 (this is credit impairment, not asset impairment - keep in EBIT) - Looking at "Adjustments For Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss" in cash flow: €67,680,000 Wait - let me re-examine. The income statement shows: - "Impairment Loss Impairment Gain And Reversal Of Impairment Loss Determined In Accordance With IFRS9": €113,370,000 This is likely credit impairment (bad debt expense), which is an operating item for utilities. Not nonrecurring. Looking for truly nonrecurring items: - "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates": €27,897,000 - this is equity method income, already excluded from EBIT - Gains/Losses on disposal of PPE: €0 (from cash flow) Actually, looking at operating profit calculation: - Gross Profit: €1,305,021,000 - Less: Impairment (IFRS 9): €113,370,000 - Less: D&A: €625,799,000 - = Operating Profit: €565,851,000 Wait, let me verify: €1,305,021,000 - €113,370,000 - €625,799,000 = €565,852,000 ≈ €565,851,000 ✓ So "Ammortamenti EAccantonamenti" = €625,799,000 includes depreciation and "accantonamenti" (provisions/allowances). The cash flow shows "Adjustments For Depreciation And Amortisation Expense" = €594,636,000. The difference (€625,799,000 - €594,636,000 = €31,163,000) is likely provision movements or other accruals. For EBITDA, standard S&P approach is to use: Operating Profit + Depreciation & Amortization (excluding impairment if it's credit-related). Actually, let me use: EBITDA = Revenue - Operating Expenses (excl D&A) = or simply EBIT + D&A. Using cash flow D&A figure: €565,851,000 + €594,636,000 = €1,160,487,000 **Joint venture adjustments:** - "Share Of Profit Loss Of Associates And Joint Ventures Accounted For Using Equity Method": €17,793,000 - For proportional EBITDA, we'd need to add back proportional share. However, we don't have detailed JV financials. S&P typically adds dividends received from JVs or proportional EBITDA. - "Dividends Received Classified As Investing Activities": €3,381,000 (from JVs likely) Given limited data, I'll note this but may not be able to fully adjust. For regulated utilities, equity income is often excluded from FFO calculations or treated carefully. **Pension adjustments:** - "Variazione Netta Fondo Per Benefici Ai Dipendenti" (Net change in employee benefits provision): -€19,158,000 (negative means increase in liability/expense) - Looking at balance sheet: Noncurrent Provisions For Employee Benefits 2022: €120,150,000; 2023: €112,989,000 For S&P, pension adjustments typically involve adding back pension expense and subtracting cash contributions, or adjusting for funded status. The cash flow shows the net change. Actually, for FFO (not EBITDA), we care about cash pension contributions. Let me note this for Step 3. For **Adjusted_EBITDA**, let me proceed with: Adjusted_EBITDA = €1,160,487,000 (EBITDA) + lease adjustments + nonrecurring losses - nonrecurring gains ± other adjustments Given IFRS 16, we need to add back the "lease expense" equivalent. Under IFRS 16, the operating lease expense is replaced by depreciation of ROU assets and interest on lease liabilities. Since EBITDA starts from EBIT, it already excludes lease interest but includes ROU depreciation (part of D&A). To get "operating lease" style EBITDA, S&P typically adds back the lease depreciation component. However, this is complex without detailed lease notes. Alternative approach for utilities: Often S&P accepts IFRS 16 EBITDA and adjusts debt instead (adding lease liabilities). Let me check if there are explicit lease liabilities in debt. Looking at financial liabilities: - "Other Noncurrent Financial Liabilities": €4,722,263,000 (2023), €4,791,979,000 (2022) - "Other Current Financial Liabilities": €619,418,000 (2023), €285,222,000 (2022) These likely include lease liabilities but aren't broken out. Given the complexity and limited data, let me use a pragmatic approach: use reported EBITDA with IFRS 16 and adjust debt for leases. **Adjusted_EBITDA = €1,160,487,000** I'll make minimal normalization adjustments given data limitations. Let me add back any nonrecurring or normalize: Looking at "Other Inflows Outflows Of Cash Classified As Operating Activities" of -€210,271,000 - this is a cash flow item, not P&L. For nonrecurring P&L items, I don't see clear material items. Let me proceed. Actually, re-examining: "Impairment Loss Impairment Gain And Reversal Of Impairment Loss Determined In Accordance With IFRS9" of €113,370,000 - this is credit impairment. For some S&P analyses, this might be viewed as somewhat nonrecurring or normalized. However, for utilities with large customer bases, bad debt is a normal operating cost. Let me keep Adjusted_EBITDA at **€1,160,487,000** with potential upward revision if we identify add-backs. Wait - I should also consider if "Other Income" of €181,066,000 includes nonrecurring items. The revenue is €5,138,245,000 = €4,957,179,000 (sales) + €181,066,000 (other income). Other income could include grants, gains, etc. Without detail, I'll treat as recurring. ## Step 3: Estimate FFO **Baseline formula:** FFO = Adjusted_EBITDA - cash_interest - cash_taxes **Cash interest:** - "Interest Paid Classified As Financing Activities": €114,121,000 - "Finance Costs" P&L: €111,670,000 - "Adjustments For Finance Costs" in cash flow: €85,708,000 (this is the non-cash portion added back) Cash interest paid = €114,121,000 (from financing activities) Wait - is there also interest received? "Interest Received Classified As Investing Activities": €29,243,000 For FFO, S&P typically uses: EBITDA - cash interest paid + interest received (or just net cash interest). Actually, standard is: FFO = Funds From Operations = EBITDA - cash interest - cash taxes Where cash interest is interest paid (not net of received). Some versions use net interest. Let me use gross interest paid for conservatism, or check S&P standard. Standard S&P FFO: EBITDA - cash interest - cash taxes. Cash interest is typically interest paid, not net. However, looking at the cash flow statement approach: "Cash Flows From Used In Operations Before Changes In Working Capital" = €1,062,464,000 This equals: EBIT + D&A + other non-cash items - cash interest - cash taxes (or similar). Let me verify: - Operating profit: €565,851,000 - Add: D&A (cash flow figure): €594,636,000 - Add: Impairment reversal/adjustment: €67,680,000 - Add: Other provisions change: €14,167,000 - Add: Employee benefits change: -€19,158,000 - Add: Finance costs adjustment: €85,708,000 - Less: Income taxes paid: €178,506,000 Sum: €565,851,000 + €594,636,000 + €67,680,000 + €14,167,000 - €19,158,000 + €85,708,000 - €178,506,000 = €1,130,378,000 Hmm, this doesn't match €1,062,464,000. Let me recheck. Actually "Cash Flows From Used In Operations Before Changes In Working Capital" should include working capital changes. Let me look more carefully. The formula in cash flow is typically: - Profit before tax - Adjustments for non-cash items - = Cash flow before working capital changes and tax Actually, looking at standard IFRS cash flow: - Profit before tax: €497,937,000 - Add: Finance costs: €111,670,000 - Add: Other non-cash items - = €565,851,000 + adjustments... Let me use the reported "Cash Flows From Used In Operations Before Changes In Working Capital": €1,062,464,000 This figure is after tax but before working capital. For FFO, S&P wants: - EBITDA - cash interest - cash taxes Or equivalently: - EBIT + D&A - cash interest - cash taxes Let me calculate: - Cash taxes: "Income Taxes Paid Refund Classified As Operating Activities": €178,506,000 From the cash flow before WC: €1,062,464,000 = EBIT + D&A + other non-cash - cash interest - cash taxes (approximately) Actually, let me derive cash interest: Starting from Operating Profit €565,851,000 Add D&A €594,636,000 Add other non-cash adjustments (impairment, provisions, etc.) = €67,680,000 + €14,167,000 - €19,158,000 + €85,708,000 = €148,397,000 Subtotal: €1,308,884,000 Less cash taxes: €178,506,000 Less cash interest: ? = €1,062,464,000 (before WC changes) So: €1,308,884,000 - €178,506,000 - cash interest = €1,062,464,000 Cash interest = €1,308,884,000 - €178,506,000 - €1,062,464,000 = €67,914,000 But reported interest paid is €114,121,000. The difference suggests my calculation is off, or there are other items. Actually, the "Cash Flows From Used In Operations Before Changes In Working Capital" includes finance income received possibly. Let me check if interest received is included. Looking at cash flow structure, interest received is in investing activities (€29,243,000), so not in operating. Let me try another approach. The cash flow statement shows: - "Cash Flows From Used In Operations Before Changes In Working Capital": €1,062,464,000 - This is a standard subtotal in Italian/IFRS cash flows For FFO, S&P typically uses: FFO = Net income + D&A + deferred taxes + other non-cash - working capital changes... Actually, standard S&P FFO from EBITDA: FFO = EBITDA - cash interest - cash taxes Where: - EBITDA = €1,160,487,000 (my calculation) - Cash interest = interest paid = €114,121,000 - Cash taxes = €178,506,000 FFO = €1,160,487,000 - €114,121,000 - €178,506,000 = **€867,860,000** But wait - is this too high compared to "Cash Flows From Used In Operations Before Changes In Working Capital" of €1,062,464,000? The difference is €194,604,000. This could be due to: - EBITDA including other income/expense items - Or my EBITDA being wrong Let me recalculate EBITDA from the cash flow approach: Cash flow before WC = €1,062,464,000 This includes: EBIT + D&A - cash interest - cash taxes + other items (like dividends received? no, that's investing) Actually, Italian cash flow statements often show "Risultato operativo netto" (net operating result) before adjustments. Let me look at the structure again. "Cash Flows From Used In Operations Before Changes In Working Capital" of €1,062,464,000 likely equals: - Operating profit - Plus depreciation and amortization - Plus other non-cash charges - Less: cash taxes paid (or plus tax refund) - Less: cash interest paid (or plus interest received if classified here) In some presentations, interest received/paid are in operating. But here, interest paid is in financing, interest received in investing. Actually, looking more carefully at IFRS cash flow presentation: - Operating activities typically include: profit before tax, adjusted for non-cash items, working capital, and taxes paid - Interest paid can be in operating or financing - Interest received can be in operating or investing Here, "Interest Paid Classified As Financing Activities" = €114,121,000 → financing "Interest Received Classified As Investing Activities" = €29,243,000 → investing So the operating cash flow before WC does NOT include interest paid or received. Let me verify: "Cash Flows From Used In Operations Before Changes In Working Capital" = €1,062,464,000 This should equal: EBIT + D&A + other non-cash items - cash taxes (if taxes are in operating) Wait, "Income Taxes Paid Refund Classified As Operating Activities" = €178,506,000 is shown separately after this subtotal. Looking at the structure: 1. Cash Flows From Used In Operations Before Changes In Working Capital: €1,062,464,000 2. Working capital changes: -€125,490,000 3. Other operating cash flows: -€210,271,000 4. Cash Flows From Used In Operating Activities: €726,703,000 And "Income Taxes Paid Refund Classified As Operating Activities" is listed separately, likely included in one of these lines or before line 1. Actually, re-reading: "Income Taxes Paid Refund Classified As Operating Activities" appears in the list before "Cash Flows From Used In Operations Before Changes In Working Capital". This suggests it's part of the calculation. Let me try: Profit before tax €497,937,000 + adjustments = ? Standard approach: - Profit before tax: €497,937,000 - Add: Finance costs: €111,670,000 - Less: Finance income: €25,962,000 - Add: Share of profit of associates: -€17,793,000 (or add back if equity method) - = Operating profit before working capital changes: €565,852,000 - Add: D&A: €594,636,000 - Add: Impairment: €67,680,000 - Add: Other non-cash: €14,167,000 - €19,158,000 + €85,708,000 = €80,717,000 - = €1,308,885,000 - Less: Taxes paid: €178,506,000 - = €1,130,379,000 Still not €1,062,464,000. Difference of €67,915,000. Hmm, this is close to the €67,680,000 impairment. Maybe timing or other items. Actually, I think the "Cash Flows From Used In Operations Before Changes In Working Capital" is a subtotal that already includes some adjustments. Let me just use it as given and work from there. For S&P FFO, a common approach is: FFO = Cash Flow From Operations Before Changes In Working Capital + cash interest paid - interest received (if in operating) But since interest paid is in financing and received in investing: FFO ≈ Cash Flow From Operations Before Changes In Working Capital + cash interest paid = €1,062,464,000 + €114,121,000 = €1,176,585,000? No, that would double count. Actually, the €1,062,464,000 already excludes interest paid (which is in financing). So to get FFO from EBITDA, we need to subtract cash interest. Let me try: FFO = EBITDA - cash taxes. Since cash interest is not in the €1,062,464,000 (as it's paid in financing), the €1,062,464,000 might be after some interest or not. This is getting confusing. Let me use a cleaner approach from S&P methodology: **Standard S&P FFO calculation:** FFO = Net income from continuing operations + Depreciation & amortization + Deferred income taxes + Other non-cash items - Gain/(loss) on asset sales - Undistributed earnings in affiliates (or + dividends from affiliates) - Working capital changes (excluding cash and debt) Or from EBITDA: FFO = EBITDA - cash interest - cash taxes Let me use: - EBITDA: €1,160,487,000 - Cash interest: €114,121,000 (interest paid in financing activities) - Cash taxes: €178,506,000 FFO = €1,160,487,000 - €114,121,000 - €178,506,000 = **€867,860,000** But I need to verify if this interest is the right amount. "Finance Costs" P&L is €111,670,000, and "Adjustments For Finance Costs" is €85,708,000, suggesting non-cash finance costs of €85,708,000 and cash finance costs of €111,670,000 - €85,708,000 = €25,962,000? No wait, that's not right. Actually, "Adjustments For Finance Costs" in cash flow is the amount added back to reconcile profit to cash flow. So: - Finance costs in P&L: €111,670,000 - Less: Non-cash finance costs (accretion, amortization of fees, etc.): €85,708,000? Or plus? The adjustment is "Adjustments For Finance Costs" = €85,708,000. This is added back in cash flow, meaning it's a non-cash finance cost. So cash finance costs = €111,670,000 - €85,708,000 = €25,962,000? But interest paid is €114,121,000. This doesn't reconcile well. The €85,708,000 might include other items like FX gains/losses, fair value changes, etc. Actually, looking at the P&L: "Finance Costs" €111,670,000 and "Finance Income" €25,962,000. Net finance cost = €85,708,000. And "Adjustments For Finance Costs" = €85,708,000. This equals the net finance cost! This suggests all finance costs are non-cash, which can't be right. Wait - €111,670,000 - €25,962,000 = €85,708,000. Yes! So "Adjustments For Finance Costs" equals the net P&L finance cost, meaning in the cash flow reconciliation, the entire net finance cost is added back (as non-cash or because it's financing activity). This confirms that in the operating cash flow reconciliation, finance costs are added back because they're either non-cash or classified elsewhere. The actual cash interest paid (€114,121,000) is in financing activities. So my EBITDA calculation should be correct, and cash interest for FFO is €114,121,000. But wait - is there interest received to net against? In some S&P calculations, they use net cash interest. Interest received is €29,243,000 in investing. For conservative FFO, I'll use gross interest paid: €114,121,000. **FFO = €867,860,000** However, let me cross-check with another approach: - Net income: €311,160,000 - Add: D&A: €594,636,000 - Add: Other non-cash items from cash flow: €67,680,000 + €14,167,000 - €19,158,000 + €85,708,000 = €148,397,000 - Less: Gain on disposal: €0 - = €1,054,193,000 - Less: working capital changes and other items... This is getting messy with different treatments. Let me stick with the EBITDA-based FFO of €867,860,000 but note it might need refinement. Actually, I realize I should check if "Cash Flows From Used In Operations Before Changes In Working Capital" of €1,062,464,000 is closer to what S&P might use as a starting point. This figure likely includes: - Operating profit - D&A and other non-cash items - But NOT interest paid (in financing) and NOT taxes paid (shown separately? or included?) If taxes paid are NOT in the €1,062,464,000, then: FFO = €1,062,464,000 - €178,506,000 (taxes) = €883,958,000 This is close to my €867,860,000. The difference (€16,098,000) could be due to EBITDA vs. this subtotal differences. Let me use **FFO = €867,860,000** or perhaps adjust to **€883,958,000** if using the reported subtotal. Actually, I want to be more careful. Let me recalculate EBITDA using the components: - Revenue: €5,138,245,000 - Operating Expense: €3,861,121,000 - Employee Benefits: €305,066,000 - D&A (separate): €625,799,000? Or is this included? From income statement: - Gross Profit = Revenue - Cost of external services - Employee benefits? Actually: Gross Profit = €1,305,021,000 - This is after cost of sales/services but before other operating expenses. Then: Operating Profit = Gross Profit - Impairment - D&A = €1,305,021,000 - €113,370,000 - €625,799,000 = €565,852,000 ✓ So EBITDA = €565,852,000 + €625,799,000 = €1,191,651,000? No wait, I used €594,636,000 earlier. The difference: "Ammortamenti EAccantonamenti" (€625,799,000) vs "Adjustments For Depreciation And Amortisation Expense" (€594,636,000). The €625,799,000 likely includes depreciation, amortization, AND other provision movements ("accantonamenti"). The cash flow figure €594,636,000 is the pure D&A. For EBITDA, standard is EBIT + D&A (pure depreciation and amortization). So €565,851,000 + €594,636,000 = €1,160,487,000 is correct. But wait - is the €113,370,000 impairment included in operating profit? Yes. And is it part of "Ammortamenti EAccantonamenti"? No, it's separate. So EBIT is already after this impairment. For S&P EBITDA, should we add back credit impairment (IFRS 9)? This is a judgment call. For utilities, bad debt expense is normal operations. I'll keep it. Final **Adjusted_EBITDA = €1,160,487,000** And **FFO = €1,160,487,000 - €114,121,000 - €178,506,000 = €867,860,000** Let me also consider if we need to add back dividends from JVs or equity income. "Share Of Profit Loss Of Associates And Joint Ventures" is €17,793,000. This is already in pre-tax profit. For FFO, S&P sometimes excludes equity earnings and includes dividends instead. Dividends received: €3,381,000. If we adjust: FFO = €867,860,000 - €17,793,000 (remove equity earnings) + €3,381,000 (add dividends) = €853,448,000 This is more conservative. I'll use **FFO = €853,448,000** or keep €867,860,000. Given the methodology says to follow S&P guidelines and the baseline is Adjusted_EBITDA - cash interest - cash taxes, and Adjusted_EBITDA starts from EBITDA which is pre-equity income (since equity income is after EBIT), my original FFO should be correct. Actually, equity income is AFTER operating profit. So EBIT excludes equity income. EBITDA = EBIT + D&A also excludes equity income. So my FFO calculation is correct at **€867,860,000**. ## Step 4: Estimate Adjusted_Debt **Baseline formula:** Adjusted_Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash **Reported debt:** From balance sheet, I need to identify total debt (financial liabilities). Noncurrent financial liabilities: - "Other Noncurrent Financial Liabilities": €4,791,979,000 (2022 year-end) Current financial liabilities: - "Other Current Financial Liabilities": €285,222,000 (2022 year-end) Total reported debt = €4,791,979,000 + €285,222,000 = **€5,077,201,000** Wait - I need to check if there are other debt items. Let me look for: - Trade payables: €1,683,563,000 - this is operating, not debt - Contract liabilities: €5,514,512,000 - this is deferred revenue, not debt Are there lease liabilities included in "Other Noncurrent Financial Liabilities" and "Other Current Financial Liabilities"? Under IFRS 16, yes, lease liabilities would be in these categories. For S&P, we need to separate lease liabilities or ensure they're included. Given the breakdown isn't provided, I'll assume these figures include lease liabilities. **Leases:** - Right-of-use assets: €53,096,000 (2022) - This suggests lease liabilities of similar magnitude (roughly equal to ROU assets at inception, but changes over time) For a more precise estimate, lease liabilities are typically close to ROU assets. Let me estimate lease liabilities at approximately €53,096,000 or higher. Actually, ROU assets and lease liabilities can diverge significantly. Given the lack of explicit lease liability disclosure, and that "Other Noncurrent Financial Liabilities" and "Other Current Financial Liabilities" likely include lease liabilities, I'll use the total as reported but note we may need to add more if leases are under-reported. Actually, for regulated utilities with IFRS 16, S&P may treat leases as debt already. Let me check if the €5,077,201,000 includes leases. Given IFRS 16 requires lease capitalization, it should. **Pension deficit:** - "Noncurrent Provisions For Employee Benefits": €120,150,000 (2022) - This is a provision, not necessarily a funded pension deficit. For S&P, we look at pension deficit = liability - plan assets. No pension plan assets are disclosed. Assuming this is unfunded or the net liability, I'll treat €120,150,000 as debt-like. Actually, for Italian companies, employee benefits are often unfunded provisions. The €120,150,000 is a provision liability. S&P typically adds pension deficits (underfunded status) to debt. If this is already a net liability, I'll add it. But wait - is this already in operating liabilities and not financial liabilities? Yes, it's in "Noncurrent Provisions", separate from financial liabilities. **Guarantees, hybrid debt, other debt-like items:** Not explicitly disclosed. **Eligible cash:** - "DisponibilitàLiquide EMezzi Equivalenti Alla Fine Dellesercizio Continued Operations" (Cash and cash equivalents): €680,820,000 (2022 year-end) - Also "DisponibilitàMonetaria Netta" (Net cash): €693,193,000 - this might include other liquid items S&P typically uses "cash and cash equivalents" as eligible cash. €680,820,000 seems right. But they may restrict to certain types or deduct trapped cash. Also, "Current Assets Other Than Assets Or Disposal Groups Classified As Held For Sale Or As Held For Distribution To Owners": €168,425,000 - not sure what this is. And "DisponibilitàLiquide EMezzi Equivalenti Alla Fine Dellesercizio Discontinued Operations": €12,374,000 (2022) - this is for discontinued ops. Total cash-like: €680,820,000 + €12,374,000 = €693,194,000 ≈ €693,193,000 (the "Net cash" figure) For eligible cash, I'll use €680,820,000 (continuing operations) or possibly €693,193,000. S&P typically uses readily available cash, so €680,820,000. **Adjusted_Debt calculation:** = (€5,077,201,000 + leases [already included?] + €120,150,000 pension + 0 guarantees + 0 hybrid + other) - €680,820,000 If leases are already in the €5,077,201,000: = €5,077,201,000 + €120,150,000 - €680,820,000 = **€4,516,531,000** But I need to verify if pension is already counted. The €120,150,000 is in "Noncurrent Provisions", not in financial liabilities. So yes, add it. However, I want to double-check the debt figures. Let me look again: 2022 year-end (which is 2022-01-01 in the facts, but actually the labels show 2022-01-01 and 2023-01-01, meaning start of 2022 and start of 2023, i.e., end of 2021 and end of 2022): Wait - I need to be careful about dates! - "Property Plant And Equipment" "2022-01-01": €2,938,530,000 - this is BEGINNING of 2022 (end of 2021) - "Property Plant And Equipment" "2023-01-01": €3,144,250,000 - this is BEGINNING of 2023 (end of 2022) So for 2022 fiscal year, the year-end balance is "2023-01-01"! Let me re-identify 2022 year-end balances: **2022 Year-End Balances (labeled as 2023-01-01):** - Other Noncurrent Financial Liabilities: €4,722,263,000 - Other Current Financial Liabilities: €619,418,000 - Noncurrent Provisions For Employee Benefits: €112,989,000 - Cash and equivalents: €559,908,000 - DisponibilitàMonetaria Netta: €693,193,000? No, that's labeled 2022-01-01 and 2023-01-01 Wait, let me check "DisponibilitàMonetaria Netta": - 2022-01-01: €693,193,000 - 2023-01-01: €559,908,000 Hmm, but "DisponibilitàLiquide EMezzi Equivalenti Alla Fine Dellesercizio Continued Operations": - 2022-01-01: €680,820,000 - 2023-01-01: €559,908,000 And there's also "DisponibilitàLiquide EMezzi Equivalenti Alla Fine Dellesercizio Discontinued Operations": - 2022-01-01: €12,374,000 - 2023-01-01: €0 So 2022 year-end cash (continuing + discontinued) = €559,908,000 + €0 = €559,908,000? Or is €559,908,000 just continuing? Actually, looking at 2022-01-01: €680,820,000 + €12,374,000 = €693,194,000 ≈ €693,193,000 (the "Net cash" figure). So "Net cash" includes both continuing and discontinued. For 2023-01-01 (end of 2022): €559,908,000 continuing + €0 discontinued = €559,908,000. But wait, "DisponibilitàMonetaria Netta" 2023-01-01 is not shown directly. The label shows: - "DisponibilitàMonetaria Netta" 2022-01-01: €693,193,000 - "DisponibilitàMonetaria Netta" 2023-01-01: not explicitly shown? Let me check... Actually I see: "DisponibilitàMonetaria Netta" "2022-01-01": 693193000 EUR and "DisponibilitàMonetaria Netta" "2023-01-01": not in my list? Let me search... Looking back: I don't see "DisponibilitàMonetaria Netta" for 2023-01-01. I see "DisponibilitàLiquide EMezzi Equivalenti Alla Fine Dellesercizio Continued Operations" 2023-01-01: €559,908,000. OK so for 2022 year-end (2023-01-01): - Other Noncurrent Financial Liabilities: €4,722,263,000 - Other Current Financial Liabilities: €619,418,000 - Total debt: €5,341,681,000 - Noncurrent Provisions For Employee Benefits: €112,989,000 - Cash (continuing): €559,908,000 **Adjusted_Debt (2022 year-end) = €5,341,681,000 + €112,989,000 - €559,908,000 = €4,894,762,000** But wait - I need to check if the 2022 fiscal year averages or year-ends are used. S&P typically uses year-end debt for ratios, or sometimes averages. For FFO/debt, they often use year-end debt. However, for the 2022 ratio, should I use 2022 year-end debt or average? S&P typically uses year-end debt for FFO/debt. Let me also check if there are other debt-like items I missed: - "AttivitàFinanziarie Non Correnti Di Cui Verso Parti Correlate" (Non-current financial assets related parties): €4,865,000 (2023-01-01) - this is an asset, not liability - "AttivitàFinanziarie Correnti Di Cui Verso Parti Correlate": €117,998,000 (2023-01-01) - asset For related party items in liabilities: - "Debiti Finanziari Correnti Di Cui Verso Parti Correlate": €108,523,000 (2023-01-01) - this is likely already in "Other Current Financial Liabilities" Actually, let me verify: "Other Current Financial Liabilities" 2023-01-01 is €619,418,000, and "Debiti Finanziari Correnti Di Cui Verso Parti Correlate" is €108,523,000. The latter is likely a subset. Similarly, "Other Noncurrent Financial Liabilities" €4,722,263,000 likely includes related party portions. **Lease adjustments:** Given IFRS 16 is applied, I need to consider if S&P makes additional lease adjustments. For utilities, S&P may treat operating leases as debt already capitalized. However, if there are significant leases not properly capitalized or if we need to add operating lease expense back to EBITDA and capitalize leases, we need to estimate. Given ROU assets are €90,397,000 (2023-01-01) and €53,096,000 (2022-01-01), lease liabilities are likely similar. These seem already capitalized in the debt figures. Actually, for a more conservative approach, let me check if total debt should include more items. "Trade And Other Current Payables" of €1,849,980,000 includes trade payables, not debt. **Final Adjusted_Debt = €4,894,762,000** Wait - I want to double-check using 2022 beginning balances too, in case S&P uses average debt. 2021 year-end / 2022 beginning (2022-01-01): - Other Noncurrent Financial Liabilities: €4,791,979,000 - Other Current Financial Liabilities: €285,222,000 - Total debt: €5,077,201,000 - Noncurrent Provisions For Employee Benefits: €120,150,000 - Cash: €680,820,000 Adjusted_Debt (beginning 2022) = €5,077,201,000 + €120,150,000 - €680,820,000 = €4,516,531,000 Average Adjusted_Debt = (€4,516,531,000 + €4,894,762,000) / 2 = €4,705,646,500 S&P typically uses year-end debt for FFO/debt ratio. I'll use **€4,894,762,000** (2022 year-end). But actually, I realize I should check S&P's standard practice. They often use "adjusted debt" at year-end for the FFO/debt ratio. However, for some ratios they use average debt. Let me use year-end as it's more common for FFO/debt. ## Step 5: Calculate FFO / Adjusted_Debt Using: - FFO = €867,860,000 - Adjusted_Debt = €4,894,762,000 FFO / Adjusted_Debt = €867,860,000 / €4,894,762,000 = **0.1773** Let me also calculate with average debt: €867,860,000 / €4,705,646,500 = **0.1844** And with beginning debt: €867,860,000 / €4,516,531,000 = **0.1922** Given S&P typically uses year-end debt for this ratio, I'll use **0.1773**. However, let me reconsider my FFO calculation. Using the alternative approach with "Cash Flows From Used In Operations Before Changes In Working Capital": If FFO = €1,062,464,000 - €178,506,000 (taxes, if not already subtracted) = €883,958,000? Or is the €1,062,464,000 already after taxes? Looking at the cash flow structure more carefully. In Italian/IFRS statements: "Cash Flows From Used In Operations Before Changes In Working Capital" typically includes: - Operating profit - D&A and non-cash items - Interest paid (if classified in operating) - Income taxes paid But here, "Income Taxes Paid Refund Classified As Operating Activities" is shown separately at €178,506,000. This suggests it might NOT be in the €1,062,464,000. Actually, looking at the ordering in the facts: 1. Various adjustments 2. "Cash Flows From Used In Operations Before Changes In Working Capital" €1,062,464,000 3. Working capital changes 4. "Income Taxes Paid Refund Classified As Operating Activities" €178,506,000 5. Other items 6. "Cash Flows From Used In Operating Activities" €726,703,000 If taxes paid are AFTER the €1,062,464,000, then: €1,062,464,000 - €125,490,000 (WC) - €178,506,000 (taxes) + other items = €726,703,000? €1,062,464,000 - €125,490,000 = €936,974,000 €936,974,000 - €178,506,000 = €758,468,000 Then "Other Inflows Outflows Of Cash Classified As Operating Activities" -€210,271,000 €758,468,000 - €210,271,000 = €548,197,000 ≠ €726,703,000 Hmm, that doesn't work. Let me try: €1,062,464,000 - €178,506,000 = €883,958,000 €883,958,000 - €125,490,000 = €758,468,000 €758,468,000 - €210,271,000 = €548,197,000 Still not €726,703,000. The difference is €178,506,000. Wait - maybe "Income Taxes Paid Refund" is a positive in some years (refund)? The label says "Paid Refund" and amount is €178,506,000. If it's a refund (negative in cash flow terms, or positive cash), then: €1,062,464,000 - €125,490,000 + €178,506,000 - €210,271,000 = €905,209,000 ≠ €726,703,000 Still doesn't work. Let me try another combination. Actually, I think the €1,062,464,000 might already include some tax effects or exclude them differently. The exact reconciliation is complex without seeing the full cash flow statement. Let me just use my EBITDA-based FFO of €867,860,000 as it's more directly derived and transparent. But let me also try: FFO = Net income + D&A - working capital changes (normalized) + other adjustments. Actually, S&P FFO is often approximated as: FFO = Net income from continuing operations + Depreciation & amortization + Deferred taxes + Other non-cash expenses - Gain on asset sales = €311,160,000 + €594,636,000 + ? + ? - 0 Deferred taxes: Not explicitly stated. "Income Tax Expense Continuing Operations" is €186,777,000. Cash taxes paid is €178,506,000. So deferred tax expense = €186,777,000 - €178,506,000 = €8,271,000 (expense, meaning liability increase or asset decrease). Add back deferred tax expense: +€8,271,000 Other non-cash: impairment €67,680,000, provision changes, etc. FFO = €311,160,000 + €594,636,000 + €8,271,000 + €67,680,000 + €14,167,000 - €19,158,000 + ... = €976,756,000 + other items This is higher than my €867,860,000. The difference is largely because this approach starts from net income (after interest and tax expense) and adds back non-cash items, while my EBITDA approach starts higher but subtracts cash interest and cash taxes. Actually, let me reconcile: Net income €311,160,000 + D&A €594,636,000 + Deferred tax €8,271,000 + Non-cash items (impairment, provisions, equity income, etc.) From cash flow reconciliation items that are non-cash: + Impairment adjustment €67,680,000 + Provision change €14,167,000 - Employee benefits -€19,158,000 (this is a use, so add back if expense?) + Finance costs adjustment €85,708,000 (non-cash finance costs) Subtotal non-cash adds: €148,397,000 But wait, finance costs of €111,670,000 were deducted to get to net income. The non-cash portion €85,708,000 was added back in cash flow. And cash interest paid was €114,121,000 in financing. Actually, net income includes: - Finance costs (expense): €111,670,000 - Finance income: €25,962,000 - Net finance cost: €85,708,000 Cash flow adds back "Adjustments For Finance Costs" €85,708,000, which equals the net finance cost in P&L. This means the entire net finance cost is treated as non-cash in operating cash flow, with actual cash flows in financing/investing. So if I add back €85,708,000 to net income, I'm adding back the net finance cost. But for FFO, I want to exclude finance costs entirely (since we subtract cash interest separately in the EBITDA approach). Let me try a clean FFO from net income: Net income: €311,160,000 Add: D&A: €594,636,000 Add: Deferred tax: €8,271,000 Add: Non-cash impairment and provisions: €67,680,000 + €14,167,000 - €19,158,000 = €62,689,000 Add: Other non-cash in net income (like equity income): €17,793,000? No, we want to subtract this or exclude. Actually, equity income of €17,793,000 is IN net income. For FFO, we typically want to exclude it and include dividends instead (€3,381,000). So: -€17,793,000 + €3,381,000 = -€14,412,000 adjustment FFO = €311,160,000 + €594,636,000 + €8,271,000 + €62,689,000 - €14,412,000 + €85,708,000 (finance costs added back) - €25,962,000 (finance income subtracted, or rather, it was in net income so...) This is getting convoluted. Let me just accept that my EBITDA-based FFO is reasonable. Actually, I realize I should check if the €1,062,464,000 "Cash Flows From Used In Operations Before Changes In Working Capital" is a good proxy for "EBITDA - cash interest - cash taxes" or similar. In many European presentations, this line equals: EBITDA - cash interest - cash taxes If so, then FFO = €1,062,464,000 - cash interest? No, if it already includes cash interest... Let me assume €1,062,464,000 = EBIT + D&A + other non-cash - cash interest (if classified in operating) - cash taxes. Since interest paid is in financing, not operating, the €1,062,464,000 likely does NOT subtract cash interest. And taxes paid might or might not be subtracted. If taxes are NOT subtracted: €1,062,464,000 = EBIT + D&A + non-cash adjustments Then FFO = €1,062,464,000 - cash taxes - cash interest = €1,062,464,000 - €178,506,000 - €114,121,000 = €769,837,000 This is lower than my €867,860,000. The difference is my EBITDA is €1,160,487,000 vs this implied €1,062,464,000 + taxes €178,506,000 = €1,240,970,000 (if taxes not included) or just €1,062,464,000. Hmm, €1,062,464,000 is close to my FFO of €867,860,000 + €178,506,000 + €114,121,000 = €1,160,487,000? No wait, that's EBITDA. Let me try: if €1,062,464,000 = EBITDA - cash taxes, then EBITDA = €1,062,464,000 + €178,506,000 = €1,240,970,000. That's higher than my €1,160,487,000. Or if €1,062,464,000 = EBITDA - cash interest, then EBITDA = €1,062,464,000 + €114,121,000 = €1,176,585,000. Closer but still higher. Or if €1,062,464,000 = EBITDA - cash taxes - cash interest, then EBITDA = €1,062,464,000 + €178,506,000 + €114,121,000 = €1,355,091,000. Way too high. Given these don't reconcile well, let me trust my direct EBITDA calculation more. Actually, I think the €1,062,464,000 might include other items like dividends received or paid, or working capital items that I can't identify. Let me just use my calculated FFO = €867,860,000. But to be thorough, let me also consider if S&P uses a different FFO definition for regulated utilities. The methodology mentions: - "Our financial analysis focuses on the economics and actual cash flow generation" - They use FFO/debt as a core ratio For regulated utilities, FFO is typically: FFO = Net income + D&A + deferred taxes + other non-cash - working capital changes (excluding certain items) Given the complexity, let me present a range and pick the most defensible. My preferred FFO: €867,860,000 (EBITDA - cash interest - cash taxes) Alternative using cash flow subtotal: If €1,062,464,000 is "funds from operations before working capital and before interest/taxes", then FFO could be €1,062,464,000 - €114,121,000 - €178,506,000 = €769,837,000. But this seems too low. Actually, I think I need to re-examine. The "Cash Flows From Used In Operations Before Changes In Working Capital" in Italian/European format often equals: Net income + D&A + other non-cash items - gain on disposal - working capital changes in non-cash items It does NOT include interest or taxes if they're shown separately. So: €1,062,464,000 = Net income + D&A + other non-cash items (before working capital and tax/interest adjustments) Then the full operating cash flow is: €1,062,464,000 - €125,490,000 (WC changes) - €178,506,000 (taxes) + other items = €726,703,000 Let me verify: €1,062,464,000 - €125,490,000 = €936,974,000 Then - €178,506,000 = €758,468,000 Then - €210,271,000 (other) = €548,197,000 ≠ €726,703,000 The €178,506,000 might be a refund (positive), so: €936,974,000 + €178,506,000 = €1,115,480,000 Then - €210,271,000 = €905,209,000 ≠ €726,703,000 Or the €210,271,000 might include other offsets. Given the reconciliation doesn't work perfectly with the data provided, I'll trust my direct calculation. **Final calculation with refined numbers:** Let me use a slightly more conservative FFO. If I use the cash flow subtotal approach and assume: - "Cash Flows From Used In Operations Before Changes In Working Capital" €1,062,464,000 is a good starting point - This likely includes net income + D&A + non-cash items, but excludes interest and taxes - For FFO, subtract cash interest and cash taxes: €1,062,464,000 - €114,121,000 - €178,506,000 = €769,837,000 But this seems low. Let me check if this €769,837,000 makes sense: - Net income: €311,160,000 - Add D&A: €594,636,000 - Add other non-cash: €148,397,000 (from cash flow adjustments excluding D&A) - Subtotal: €1,054,193,000 - Less: cash interest: €114,121,000 - Less: cash taxes: €178,506,000 - = €761,566,000 Close to €769,837,000. The difference is about €8 million, likely due to other items. So **FFO ≈ €769,837,000** using this approach, or **€867,860,000** using EBITDA approach. The difference (€98 million) is because my EBITDA (€1,160,487,000) is higher than the implied EBITDA from cash flow (€1,062,464,000 + €178,506,000 + €114,121,000 - other non-cash = ...). Actually, let me check: if €1,062,464,000 = EBIT + D&A - cash taxes (a common subtotal), then: = €565,851,000 + €594,636,000 - €178,506,000 = €981,981,000 ≠ €1,062,464,000 Or = EBITDA - cash taxes = €1,160,487,000 - €178,506,000 = €981,981,000 ≠ €1,062,464,000 So €1,062,464,000 is €80 million higher. This could be due to adding back other non-cash items or different EBITDA. Let me try: EBIT + D&A + impairment + other provisions - cash taxes = €565,851,000 + €594,636,000 + €67,680,000 + €14,167,000 - €19,158,000 - €178,506,000 = €1,044,670,000 Still not €1,062,464,000. Close though. Add finance costs adjustment: +€85,708,000 = €1,130,378,000. Too high. Hmm. Let me just accept that there's some complexity and use my original FFO = €867,860,000 as it's directly derived from EBITDA which I can verify. Actually, one more try: maybe "Cash Flows From Used In Operations Before Changes In Working Capital" includes interest received if classified in operating? But we saw interest received is in investing. Or maybe it includes dividends received? €3,381,000 in investing. I'll stick with **FFO = €867,860,000** and **Adjusted_Debt = €4,894,762,000**. **FFO / Adjusted_Debt = 0.1773** Let me round to four decimal places: **0.1773** Actually, let me also try with beginning debt to see the range, and consider if S&P might use average debt for some reason. With beginning debt (2021 year-end): €4,516,531,000 Ratio: €867,860,000 / €4,516,531,000 = 0.1922 With average debt: €4,705,646,500 Ratio: 0.1844 Given S&P typically uses year-end debt, I'll stay with **0.1773**. However, I want to make one more refinement. Looking at the debt at 2022 year-end (2023-01-01): - Other Noncurrent Financial Liabilities: €4,722,263,000 - Other Current Financial Liabilities: €619,418,000 Is there any debt in "Trade And Other Current Payables" or other items? Typically not - trade payables are operating. But wait - for utilities, there might be "debt-like" payables or contract liabilities. "Noncurrent Contract Liabilities" of €5,452,905,000 is deferred revenue, not debt. And "Current Liabilities" includes trade payables and other operating items, not debt. So my debt figure seems correct. One more check: should I include the €112,989,000 pension provision as debt? For S&P, yes, typically unfunded pension obligations are treated as debt-like. However, if this is already a net provision (after any plan assets), it's appropriate to add. Given no plan assets are disclosed, I'll assume it's a net liability. Final answer: **0.1773** Actually, let me reconsider one more time if I should use FFO from the cash flow statement more directly. The "Cash Flows From Used In Operating Activities" is €726,703,000. This includes working capital changes. S&P FFO typically excludes working capital changes (uses "before changes in working capital" or similar). So €1,062,464,000 is the right starting point from cash flow. If I assume this equals "EBITDA - cash taxes" (with interest in financing), then: FFO = €1,062,464,000 - cash interest = €1,062,464,000 - €114,121,000 = €948,343,000? No, FFO should subtract both interest and taxes. If €1,062,464,000 = EBITDA - cash taxes, then FFO = EBITDA - cash interest - cash taxes = €1,062,464,000 + €178,506,000 - €114,121,000 - €178,506,000 = €948,343,000? That doesn't work. Let me try: if €1,062,464,000 = EBITDA, then FFO = €1,062,464,000 - €114,121,000 - €178,506,000 = €769,837,000. But €1,062,464,000 as EBITDA is too low (my calculated EBITDA is €1,160,487,000). Difference: €98,023,000. This could be the "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates" of €27,897,000 and other items, or different treatment of certain costs. Given this uncertainty, let me use a weighted approach or just pick the most defensible. I'll use **FFO = €867,860,000** as it's based on clearly identifiable EBITDA components. Wait - I want to check one more thing. Is "Revenue" = €5,138,245,000 the right starting point? It includes "Other Income" of €181,066,000. For some S&P analyses, "other income" might be excluded if non-operating. But it's likely operating for a utility (grants, ancillary services, etc.). Let me also verify my debt calculation by looking at total liabilities and equity: - Equity 2022 year-end: €2,755,243,000 - Total liabilities = €11,338,533,000 - €2,755,243,000 = €8,583,290,000 This includes: - Noncurrent provisions: €218,025,000 - Noncurrent contract liabilities: €5,452,905,000 - Other noncurrent liabilities: €399,628,000 - Trade payables: €1,849,980,000 - Current tax: €26,810,000 - Other current liabilities: €632,259,000 - Current liabilities held for sale: €1,919,000 Sum of non-debt liabilities: €218,025,000 + €5,452,905,000 + €399,628,000 + €1,849,980,000 + €26,810,000 + €632,259,000 + €1,919,000 = €8,581,526,000 Close to €8,583,290,000. Difference is about €1.7 million, likely rounding or minor items. Debt portion: €4,722,263,000 + €619,418,000 = €5,341,681,000 So debt is about 62% of total liabilities, which seems reasonable for a utility. My Adjusted_Debt adds pension and subtracts cash: €5,341,681,000 + €112,989,000 - €559,908,000 = €4,894,762,000. Actually, I used €559,908,000 cash, but should I use more? "DisponibilitàMonetaria Netta" at 2022 beginning was €693,193,000. At 2022 year-end, it's not explicitly stated, but "DisponibilitàLiquide EMezzi Equivalenti Alla Fine Dellesercizio Continued Operations" is €559,908,000 and discontinued is €0, so total €559,908,000. For S&P, they might deduct all cash or only "excess cash" or "readily available cash." €559,908,000 seems reasonable. One more consideration: should I use 2022 average or year-end FFO? FFO is a flow measure for the year 2022, so it's correct as calculated. Debt is a stock measure, and S&P typically uses year-end for FFO/debt. Final calculation: 867,860,000 / 4,894,762,000 = 0.177309... Rounded to four decimal places: **0.1773** 0.1773