I'll work through this step-by-step for ACEA S.P.A. ## Step 1: Identify the relevant industry ACEA S.P.A. is an Italian multi-utility company. Based on the facts provided, it operates in regulated utility sectors (water, electricity, gas). The company name "ACEA" stands for "Azienda Comunale Energia e Ambiente" (Municipal Energy and Environment Company). This clearly falls under **Regulated Utilities - Multi-utilities** sector. ## Step 2: Estimate 2021 Adjusted_EBITDA For regulated utilities, S&P focuses on EBITDA as the key profitability metric unless distorted. Let me reconstruct EBITDA from the available data. From the income statement: - Revenue 2021: 3,972,061,000 EUR - Operating Expense 2021: 2,737,035,000 EUR - Gross Profit 2021: 1,256,075,000 EUR Wait - let me check: Revenue - Operating Expense should equal some measure of operating profit. But we also have: - Profit Loss From Operating Activities 2021: 581,101,000 EUR Let me verify: Gross Profit 2021 = 1,256,075,000 EUR Then we have impairments and amortizations that reduce this to operating profit: - Impairment Loss (IFRS9) 2021: 86,207,000 EUR - Ammortamenti E Accantonamenti (Depreciation and provisions) 2021: 588,768,000 EUR So: Gross Profit - Impairments - D&A = 1,256,075,000 - 86,207,000 - 588,768,000 = 581,100,000 ≈ 581,101,000 ✓ For EBITDA, I need to add back D&A and impairments to operating profit: EBITDA = Profit Loss From Operating Activities + D&A + Impairments EBITDA 2021 = 581,101,000 + 588,768,000 + 86,207,000 = 1,256,076,000 EUR Or more directly: EBITDA = Gross Profit (since gross profit already excludes D&A and impairments... wait, let me re-check) Actually, looking at the structure: - Gross Profit = Revenue - Operating Expense? No, that doesn't work: 3,972,061,000 - 2,737,035,000 = 1,235,026,000 ≠ 1,256,075,000 Let me recalculate: "Ricavi Da Vendita E Prestazioni" (Sales and Services Revenue) = 3,816,030,000 "Other Income" = 156,032,000 Total Revenue = 3,972,062,000 ≈ 3,972,061,000 ✓ "Costi Esterni" (External Costs) = 2,461,216,000 "Employee Benefits Expense" = 275,819,000 Total operating costs before D&A = 2,737,035,000 = Operating Expense ✓ So Gross Profit = Revenue - Operating Expense = 3,972,061,000 - 2,737,035,000 = 1,235,026,000... but reported Gross Profit is 1,256,075,000. Difference = 21,049,000. This might be "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates" = 21,048,000 ≈ 21,049,000 ✓ So Gross Profit includes this other income from subsidiaries/associates. For EBITDA: Operating Profit + D&A + Impairments = 581,101,000 + 588,768,000 + 86,207,000 = 1,256,076,000 Or: Gross Profit + Other Income from subs/associates... wait, already included. Actually, let me use: EBITDA = Profit From Operating Activities + Depreciation & Amortization + Impairments = 581,101,000 + 588,768,000 + 86,207,000 = 1,256,076,000 EUR For regulated utilities, we need to check for lease adjustments, pension adjustments, etc. From cash flow statement: - "Adjustments For Depreciation And Amortisation Expense" 2021: 546,626,000 EUR - This is slightly different from "Ammortamenti E Accantonamenti" 2021: 588,768,000 EUR The difference might include provisions/accruals beyond pure D&A. For S&P purposes, we typically use reported D&A. Looking at Right-of-use assets: - 2022-01-01: 53,096,000 EUR - 2023-01-01: 90,397,000 EUR This indicates leases. For 2021, we need 2021 right-of-use assets. Not directly given, but we can infer from changes. Actually, for 2021 balance sheet, we don't have right-of-use assets directly, but we can work with what's available. For S&P's Adjusted EBITDA for regulated utilities: - Start with reported EBITDA - Add back operating lease expense if capitalized (already in IFRS 16) - Adjust for non-recurring items - Joint venture proportional EBITDA From the data: - "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates" 2021: 21,048,000 EUR (this is equity method income, already in operating profit) For regulated utilities with IFRS 16 already applied, leases are capitalized. We need to check if there are operating lease expenses not captured. Looking at the data, I don't see explicit operating lease expense. IFRS 16 is already applied (Right-of-use assets exist). For 2021 Adjusted_EBITDA, I'll use: - Base EBITDA: 1,256,076,000 EUR (as calculated) Need to check for non-recurring items. The "Other Inflows Outflows Of Cash Classified As Operating Activities" 2021: -136,125,000 EUR might include some non-recurring items, but this is cash flow. Let me check if there are adjustments needed: - Joint ventures: "Share Of Profit Loss Of Associates And Joint Ventures" 2021: 7,798,000 EUR - this is below operating profit, so already excluded from EBITDA Actually, looking more carefully at the income statement structure: - Profit Loss From Operating Activities: 581,101,000 - Then Finance Income, Finance Costs, Share of profit of associates, etc. So EBITDA = 581,101,000 + 588,768,000 + 86,207,000 = 1,256,076,000 But wait - "Ammortamenti E Accantonamenti" includes both depreciation and provisions. The cash flow shows "Adjustments For Depreciation And Amortisation Expense" = 546,626,000 and "Adjustments For Impairment Loss Reversal Of Impairment Loss" = 57,360,000. Total = 603,986,000. Actually for S&P, we want to add back D&A to get to EBITDA. Let me use the cash flow approach: Cash flow from operations before working capital = 1,002,058,000 This = Operating Profit + D&A + other non-cash items - taxes? No, taxes paid are separate. Actually: "Cash Flows From Used In Operations Before Changes In Working Capital" 2021: 1,002,058,000 This typically = EBIT + D&A - cash taxes +/- other adjustments... or more commonly EBITDA - cash interest - cash taxes for FFO proxy, but here it's before working capital. Let me use: EBITDA = Operating Profit + D&A + Impairments (as standard) Using reported: 581,101,000 + 588,768,000 + 86,207,000 = 1,256,076,000 Or using cash flow adjustments: 581,101,000 + 546,626,000 + 57,360,000 + other items = ? Actually, let me verify with cash flow: "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,002,058,000 This should equal: Operating Profit + D&A - cash interest? No, finance costs are after operating profit. Standard formula: Cash flow from operations before working capital changes = Operating profit + depreciation and amortization + other non-cash expenses - cash taxes paid? No, taxes paid are shown separately. Looking at the items: + Adjustments For Depreciation And Amortisation Expense: 546,626,000 + Adjustments For Impairment Loss: 57,360,000 + Variazione Fondo Rischi: -3,706,000 + Variazione Netta Fondo Per Benefici Ai Dipendenti: -7,004,000 + Adjustments For Finance Costs: 85,897,000 - Income Taxes Paid: 180,117,000 Sum of adjustments to operating profit: 546,626 + 57,360 - 3,706 - 7,004 + 85,897 - 180,117 = 499,056,000 Operating profit 581,101 + 499,056 = 1,080,157,000 ≠ 1,002,058,000 Hmm, difference of 78,099,000. Let me check other items. Actually "Other Inflows Outflows Of Cash Classified As Operating Activities" 2021: -136,125,000 might be included. Let me recalculate: 581,101 + 546,626 + 57,360 - 3,706 - 7,004 + 85,897 - 180,117 - 136,125 = 943,032,000? No... Actually the formula is probably: Cash flow before working capital = Operating profit + D&A + impairments + provisions changes + finance costs (non-cash?) - taxes paid + other Let me just use: EBITDA = 1,256,076,000 based on standard definition (Operating profit + D&A + impairments) For S&P adjustments to regulated utilities: - Add back operating lease depreciation if we want full EBITDA (but IFRS 16 already capitalizes) - Check for non-recurring items Looking at "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates" = 21,048,000 - this is likely recurring. For 2021, I'll estimate Adjusted_EBITDA ≈ 1,256,076,000 EUR, or roughly 1,256 million EUR. Actually, let me be more careful. S&P for regulated utilities uses "Adjusted EBITDA" which may include proportional consolidation of JVs, add-backs, etc. Looking at equity method investments: "Investment Accounted For Using Equity Method" 2022: 292,239,000; 2023: 348,885,000 For EBITDA, S&P may want to add proportional EBITDA of JVs. But we don't have JV revenue/EBITDA directly. The "Share Of Profit Loss Of Associates And Joint Ventures" is 7,798,000 in 2021. For regulated utilities, S&P's main adjustments are typically: 1. D&A and impairment addbacks (already in EBITDA) 2. Operating lease adjustments (IFRS 16 already applied) 3. Pension adjustments 4. JV proportional EBITDA Given limited data, I'll use reported-based EBITDA with minimal adjustments. Let me define: **2021 Adjusted_EBITDA = 1,256,076,000 EUR** (Operating profit + D&A + impairments) Wait - I need to check if "Ammortamenti E Accantonamenti" includes only depreciation or also other provisions. In Italian accounting, "accantonamenti" means provisions/accruals. From cash flow: "Adjustments For Depreciation And Amortisation Expense" = 546,626,000 and "Adjustments For Impairment Loss" = 57,360,000, total 603,986,000. But "Ammortamenti E Accantonamenti" = 588,768,000 and "Impairment Loss" = 86,207,000, total 674,975,000. The difference might be due to different treatment of certain items. For EBITDA, standard is to add back depreciation, amortization, and impairment. I'll use the income statement figures as they're more directly tied to operating profit. Actually, let me recalculate EBITDA more carefully: EBITDA = Revenue - Cash Operating Costs (excluding D&A and impairments) Revenue: 3,972,061,000 Operating Expense (cash costs): 2,737,035,000 Gross Profit: 1,256,075,000 (includes some non-cash items?) Actually Gross Profit = Revenue - Operating Expense = 3,972,061,000 - 2,737,035,000 = 1,235,026,000, but reported is 1,256,075,000. Difference is 21,049,000 ≈ Other Income from subs/associates (21,048,000). So Gross Profit includes equity income from subs/associates? That would be unusual for "gross profit." Actually, looking at Italian terminology, "Margine Operativo Lordo" (Gross Operating Margin) is often used as EBITDA equivalent in Italian reporting! Let me check: "Margine Operativo Lordo" = Gross Operating Margin = EBITDA in Italian terminology! So "Gross Profit" here likely means EBITDA! Let me verify: "Margine Operativo Lordo Di Cui Verso Parti Correlate" = 49,140,000 If Gross Profit = EBITDA, then: 2021 EBITDA = 1,256,075,000 EUR 2022 EBITDA = 1,305,021,000 EUR This makes more sense! In Italian financial reporting, "Margine Operativo Lordo" (MOL) is indeed EBITDA. Let me verify with operating profit: 2021: EBITDA 1,256,075,000 - Impairments 86,207,000 - D&A 588,768,000 = 581,100,000 ≈ Operating Profit 581,101,000 ✓ Great! So "Gross Profit" in this data = EBITDA = MOL. Now for S&P Adjusted EBITDA: - Base: 1,256,075,000 (2021) - Adjustments: need to check for leases, pensions, non-recurring, JVs For regulated utilities, S&P adjustments to EBITDA: 1. Add operating lease expense if not already in EBITDA (but IFRS 16 means it's in D&A, not EBITDA) 2. Non-recurring items 3. Pension adjustments 4. JV proportional EBITDA Looking at the data, I don't see explicit non-recurring items or major adjustments needed. The "Other Inflows Outflows Of Cash Classified As Operating Activities" might include some non-recurring cash items but these are cash flow timing differences. For JVs: Share of profit of associates is 7,798,000 in 2021, but this is already below EBITDA (in operating profit). For proportional EBITDA, we'd need gross JV EBITDA, not just profit share. Given limited data, I'll use reported EBITDA as Adjusted EBITDA baseline, with minimal adjustments. Actually, for S&P's regulated utility methodology, they mention: - "We do not adjust GAAP earnings or balance-sheet figures to remove the effects of regulatory accounting" - For IFRS, "our financial analysis focuses on the economics and actual cash flow generation" For 2021, let me use: **Adjusted_EBITDA_2021 = 1,256,075,000 EUR** But I should add back any operating lease expense if EBITDA is meant to be pre-IFRS 16. Actually, under IFRS 16, EBITDA includes lease depreciation in D&A, so "Gross Profit"/MOL/EBITDA should already exclude lease expense (it's in D&A below). Wait - let me re-think. Under IFRS 16, operating lease expense is replaced by depreciation of right-of-use asset and interest on lease liability. The depreciation is in D&A, so EBITDA (as operating profit + D&A) includes the lease depreciation add-back. So EBITDA is higher than under old IAS 17. For S&P's "Adjusted EBITDA," they typically want to add back operating lease expense to make it comparable. But under IFRS 16, there's no operating lease expense in operating profit - it's depreciation and interest. Actually, S&P's standard approach for IFRS 16 companies is: - Add back lease depreciation to get to "Adjusted EBITDA" that approximates pre-IFRS 16 EBITDA + lease expense Or alternatively, they may keep IFRS 16 EBITDA and adjust debt accordingly. Let me check S&P's methodology statement: "For integrated electric utilities that meet native load obligations partly by using third-party power contracts, we use our purchased power methodology... Where substantial seasonal working capital requirements... distort leverage measures, we adjust inventory and debt balances..." For leases in regulated utilities: S&P typically adds back operating lease expense to EBITDA. Under IFRS 16, this means adding back the depreciation component of lease expense. Actually, looking at Right-of-use assets: 2022-01-01: 53,096,000 2023-01-01: 90,397,000 The increase suggests new leases. For 2021, we need to estimate lease depreciation. From cash flow or notes, we don't have explicit lease depreciation. But we can estimate: Change in ROU assets 2021 to 2022 = 53,096,000 - (some 2021 start value) Actually we don't have 2021-01-01 ROU assets. But looking at the pattern, ROU assets grew from some base to 53,096,000. For simplicity, and given relatively small amounts (53M vs 1.2B EBITDA), I'll note that lease adjustments are relatively minor. Let me proceed with reported-based EBITDA and make minor lease adjustment if needed. Actually, let me re-read S&P's general approach: for IFRS 16, they typically add back lease depreciation to get "Adjusted EBITDA" and capitalize leases in debt. This double-adjusts compared to pre-IFRS 16. Given the complexity and relatively small lease amounts, I'll use: **Adjusted_EBITDA_2021 = 1,256,075,000 + lease_depreciation_addback** But I don't have lease depreciation separately. Let me estimate from ROU assets. ROU assets 2022-01-01: 53,096,000. If average lease life is 5 years, annual depreciation ~10,619,000. For 2021, if ROU assets were say 40,000,000 at 2021-01-01, depreciation would be ~8,000,000. This is small relative to 1.2B EBITDA (~0.7%). I'll proceed with base EBITDA and note this minor adjustment. Actually, let me check if "Ammortamenti E Accantonamenti" includes lease depreciation. It likely does. So EBITDA already includes lease depreciation add-back. For S&P's "Adjusted EBITDA" with IFRS 16, they want to add back the lease depreciation to get to a "pre-IFRS 16" equivalent EBITDA. So: Adjusted EBITDA = Reported EBITDA + lease depreciation But I don't have lease depreciation split out. Let me estimate it or ignore given small size. Given the small materiality, I'll use: **Adjusted_EBITDA_2021 ≈ 1,256,075,000 EUR** (with minor lease adjustment possible) Actually, let me be more precise. Looking at the data again, I see "Adjustments For Depreciation And Amortisation Expense" in cash flow is 546,626,000 vs "Ammortamenti E Accantonamenti" of 588,768,000. The difference of 42,142,000 might include lease-related items or other adjustments. For conservative approach, let me use the higher D&A figure from income statement to ensure I capture all depreciation. Let me settle on: **2021 Adjusted_EBITDA = 1,256,075,000 EUR** ## Step 3: Estimate 2021 FFO For regulated utilities, S&P defines FFO as: FFO = Adjusted EBITDA - cash interest - cash taxes From the data: - Finance Costs 2021: 97,388,000 (this is accrual-based) - Cash interest paid: "Interest Paid Classified As Financing Activities" 2021: 100,752,000 EUR Wait - there's also "Adjustments For Finance Costs" in operating cash flow: 85,897,000. This suggests some finance costs are non-cash or accrued. For cash interest, I should use actual interest paid: 100,752,000 (from financing activities) or look for interest received/paid in operating activities. Actually, "Interest Received Classified As Investing Activities" 2021: 14,511,000 "Interest Paid Classified As Financing Activities" 2021: 100,752,000 For FFO, S&P typically uses: Adjusted EBITDA - cash interest paid - cash taxes paid Cash taxes paid: "Income Taxes Paid Refund Classified As Operating Activities" 2021: 180,117,000 But wait - we also have "Income Tax Expense Continuing Operations" 2021: 150,662,000 (accrual) For FFO calculation: FFO = Adjusted EBITDA - cash interest - cash taxes Cash interest = interest paid - interest received? Or just interest paid on debt? S&P typically uses "cash interest paid" net of "cash interest received" if interest received is from financial assets. But for utilities, interest received might be from customer deposits or late payments. Looking at cash flow structure: - Operating activities include working capital, taxes paid, etc. - Investing activities include interest received: 14,511,000 - Financing activities include interest paid: 100,752,000 For S&P FFO: typically uses cash interest paid on debt, which is 100,752,000. Sometimes interest received is deducted from this if it's from surplus cash. But standard S&P FFO = EBITDA - cash interest - cash taxes. Cash interest is typically interest paid on debt, not net of interest received. Actually, let me check: "Finance Income" 2021: 11,491,000; "Finance Costs" 2021: 97,388,000. Net finance cost = 85,897,000 which matches "Adjustments For Finance Costs" in cash flow. For cash flow purposes, the net cash interest paid would be interest paid minus interest received. From financing activities: Interest Paid = 100,752,000 From investing activities: Interest Received = 14,511,000 Net cash interest = 86,241,000 ≈ 85,897,000 (the adjustment figure, small difference due to accruals/foreign exchange) For S&P FFO, I should use: Adjusted EBITDA - net cash interest paid - cash taxes paid = 1,256,075,000 - 86,241,000 - 180,117,000 = 989,717,000 Or using the cash flow "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,002,058,000 which is close. Actually, let me verify: 1,002,058,000 vs my 989,717,000. Difference of 12,341,000. This might be due to other items in the "before working capital" figure. Looking more carefully, "Cash Flows From Used In Operations Before Changes In Working Capital" includes: - Operating profit: 581,101,000 + D&A: 546,626,000 + Impairments: 57,360,000 + Provisions change: -3,706,000 + Employee benefits change: -7,004,000 + Finance costs adjustment: 85,897,000 - Taxes paid: 180,117,000 + Other? = 1,002,058,000 Sum: 581,101 + 546,626 + 57,360 - 3,706 - 7,004 + 85,897 - 180,117 = 1,080,157,000... not 1,002,058,000. Hmm, I'm off by 78,099,000. Let me check if there's "Other Inflows Outflows Of Cash Classified As Operating Activities" = -136,125,000 included or excluded. Actually the "before working capital" figure likely excludes this "other" line. Let me check: 1,080,157 - 136,125 = 944,032, still not matching. I think the "Cash Flows From Used In Operations Before Changes In Working Capital" might be defined differently. Let me just use it as given: 1,002,058,000. For S&P FFO, the standard formula is: FFO = Net Income + D&A + deferred taxes + other non-cash items - working capital changes... no, that's cash flow from operations. Actually, S&P defines FFO as: FFO = Funds From Operations = Net Income + D&A + impairment + deferred taxes - equity earnings + other non-cash items... Or more commonly for utilities: FFO = EBITDA - cash interest - cash taxes Let me use: FFO = 1,002,058,000 (cash from operations before working capital) - this is close to S&P's FFO definition. Actually, S&P's FFO is typically: Operating Cash Flow before working capital changes, or equivalently EBITDA - cash interest - cash taxes. Given 1,002,058,000 is "before changes in working capital" and includes taxes paid, this is very close to S&P FFO. But let me verify: does it include interest paid? The "Adjustments For Finance Costs" of 85,897,000 is added back to operating profit, suggesting finance costs were deducted to get operating profit? No, finance costs are below operating profit. Actually, looking at the P&L: Operating Profit 581,101, then Finance Income 11,491, Finance Costs 97,388, etc. So operating profit is pre-finance costs. Then "Adjustments For Finance Costs" in cash flow must be adding back the non-cash portion or accrued portion of finance costs. For cash flow from operations before working capital: Start with operating profit + add back non-cash items (D&A, impairments, provisions) +/- other adjustments - cash taxes paid = cash from operations before working capital changes The "Adjustments For Finance Costs" of 85,897,000 seems odd if finance costs are below operating profit. Unless this represents capitalized interest or accrued interest not yet paid. Actually, I think this might represent the adjustment from accrual to cash basis for interest, or it could be related to derivative valuations. Given the complexity, let me use a cleaner approach: **FFO = Adjusted EBITDA - cash interest paid + interest received - cash taxes paid** = 1,256,075,000 - 100,752,000 + 14,511,000 - 180,117,000 = 989,717,000 Or using the cash flow figure: 1,002,058,000 These are close. Let me use **FFO_2021 = 1,002,058,000 EUR** as it's directly from the statement and represents "Cash Flows From Used In Operations Before Changes In Working Capital" which aligns with S&P's pre-working-capital FFO concept. Actually, I need to be more careful. S&P's FFO is specifically "Funds From Operations" not "Cash Flow From Operations Before Working Capital Changes." They're similar but FFO typically excludes some items. Standard S&P FFO = Net Income + Depreciation + Deferred Income Taxes + Other Non-Cash Items Or: FFO = EBIT + Depreciation - Cash Interest - Cash Taxes Let me calculate: EBIT = Operating Profit + Finance Income - Finance Costs? No, EBIT is Operating Profit for this company (no "other income/expense" between operating and finance). Actually: Profit Before Tax = Operating Profit + Finance Income - Finance Costs + Share of profit of associates = 581,101 + 11,491 - 97,388 + 7,798 = 503,002 ✓ So EBIT = Operating Profit = 581,101,000 (since finance items are below) FFO = EBIT + D&A + Impairments - Cash Interest - Cash Taxes? No, that's not right. Standard S&P: FFO = Net Income from continuing operations + depreciation + amortization + impairment + deferred income taxes + other non-cash items Net Income 2021: 352,340,000 + D&A (from cash flow): 546,626,000 + Impairments (from cash flow): 57,360,000 + Deferred taxes? Not given directly + Other non-cash: provisions changes, etc. = 352,340 + 546,626 + 57,360 + (-3,706) + (-7,004) + ... = roughly 945,616,000 This is getting messy. Let me use the direct S&P formula for utilities: **FFO = Adjusted EBITDA - Cash Interest - Cash Taxes** = 1,256,075,000 - 86,241,000 [net cash interest, or use 100,752,000 gross?] - 180,117,000 For "cash interest," S&P typically uses interest paid on debt minus interest received on financial assets. If interest received is from operations (customer late payment interest), it might be treated differently. From the data, "Interest Received Classified As Investing Activities" suggests it's from financial investments, not operations. So for utility operations, we might exclude this. But "Finance Income" 2021: 11,491,000 includes interest income. Some might be from cash deposits (investing), some from operations. For conservative approach: **Cash Interest = 100,752,000** (interest paid, financing activities) **FFO_2021 = 1,256,075,000 - 100,752,000 - 180,117,000 = 975,206,000 EUR** Or if we net interest received: 1,256,075 - 86,241 - 180,117 = 989,717,000 I'll use **FFO_2021 = 989,717,000 EUR** (net cash interest approach) or about 990 million. Actually, let me check S&P's typical treatment. They usually use "cash interest paid" as a deduction, and treat interest received as part of FFO if it's from surplus cash. But for simplicity, many analysts use EBITDA - gross cash interest - cash taxes. Given the "Cash Flows From Used In Operations Before Changes In Working Capital" is 1,002,058,000, which is close to my 989,717,000, I'll use: **FFO_2021 = 1,002,058,000 EUR** (the reported pre-working-capital figure, which is essentially S&P's FFO proxy) ## Step 4: Estimate 2021 Adjusted_Debt For regulated utilities, S&P Adjusted Debt includes: - Reported debt (current + non-current) + Capitalized operating leases (if not already in debt under IFRS 16) + Pension deficit + Guarantees, hybrid debt portion, other debt-like items - Eligible cash From balance sheet 2022-01-01 (which is 2021 year-end): - Other Noncurrent Financial Liabilities: 4,791,979,000 - Other Current Financial Liabilities: 285,222,000 Total reported debt = 4,791,979,000 + 285,222,000 = 5,077,201,000 EUR Wait - are there "Noncurrent Contract Liabilities"? 5,514,512,000. These are likely regulatory liabilities or deferred revenue, not debt. Also check: "Trade And Other Current Payables" = 1,683,563,000 - this is trade payables, not debt. So debt = 5,077,201,000 EUR at 2021 year-end. For IFRS 16, leases are already in debt. Right-of-use assets 2022-01-01: 53,096,000. The corresponding lease liability should be in financial liabilities. Actually, under IFRS 16, lease liabilities are included in "Other Noncurrent Financial Liabilities" and/or "Other Current Financial Liabilities." So reported debt already includes lease liabilities. For S&P Adjusted Debt: = Reported debt + pension deficit + guarantees + hybrids - eligible cash Pension deficit: "Noncurrent Provisions For Employee Benefits" 2022-01-01: 120,150,000. But this is gross liability, not net of plan assets. We don't have plan assets data. Looking at equity: "Reserve Of Remeasurements Of Defined Benefit Plans Member" 2022-01-01: -18,234,000 (negative = deficit) This suggests pension deficit is recognized in equity. The actual pension liability is 120,150,000, but there may be plan assets offsetting some. For S&P, pension deficit = pension liability - plan assets. If plan assets > liability, it's a surplus. Without plan assets data, I'll use the liability as proxy or check if there's net deficit. Actually, the negative reserve in equity (-18,234,000) represents unrecognized actuarial losses, not the funded status. For S&P purposes, if we can't determine funded status, we might add the gross liability or use a standard adjustment. Given complexity, let me use: **Reported Debt = 5,077,201,000 EUR** For cash deduction: "Disponibilità Liquide E Mezzi Equivalenti Alla Fine Dellesercizio Continued Operations" 2022-01-01: 680,820,000 Plus "Disponibilità Liquide E Mezzi Equivalenti Alla Fine Dellesercizio Discontinued Operations" 2022-01-01: 12,374,000 Total cash = 693,193,000 EUR Also "Disponibilità Monetaria Netta" 2022-01-01: 693,193,000 EUR - this confirms. For S&P "eligible cash," they typically deduct surplus cash above operating needs. For utilities, they often deduct most cash as it's generally needed for working capital or is surplus. Conservative approach: deduct all cash or most of it. Let me use 100% cash deduction for simplicity, or check if there's restricted cash. "Disponibilità Monetaria Netta" suggests net cash position. I'll deduct all cash. **Adjusted_Debt_2021 = 5,077,201,000 - 693,193,000 = 4,384,008,000 EUR** But wait - I need to check for other debt-like items: - Guarantees: not disclosed - Hybrid debt: not apparent - Securitized debt: not mentioned - Pension deficit: need to estimate Let me add pension liability as debt-like: +120,150,000 Less: plan assets? Unknown. If I assume plan assets = 0 (conservative), add 120,150,000. Actually, for funded plans, S&P adds the net deficit (liability - plan assets). Without plan assets, I can't calculate this. Let me assume the 120,150,000 is the net liability (common for Italian companies to show net). So **Adjusted_Debt_2021 = 5,077,201,000 + 120,150,000 - 693,193,000 = 4,504,158,000 EUR** Or approximately **4,504 million EUR** Let me round to: **Adjusted_Debt_2021 ≈ 4,504,000,000 EUR** ## Step 5: Calculate 2021 Adjusted_Debt / Adjusted_EBITDA = 4,504,158,000 / 1,256,075,000 = **3.59x** ## Step 6: Calculate 2021 FFO / Adjusted_Debt = 1,002,058,000 / 4,504,158,000 = **0.222** or **22.2%** Or using FFO = 989,717,000: 0.220 or 22.0% Let me use the reported pre-working-capital figure: **0.222 or 22.2%** ## Step 7: Estimate 2022 Adjusted_EBITDA Using same approach: "Gross Profit" 2022 = 1,305,021,000 EUR (this is MOL/EBITDA) Verify: Operating Profit 2022 = 565,851,000 + Impairments 2022: 113,370,000 + D&A 2022: 625,799,000 = 1,305,020,000 ≈ 1,305,021,000 ✓ **Adjusted_EBITDA_2022 = 1,305,021,000 EUR** ## Step 8: Estimate 2022 FFO Using same approach: FFO = Adjusted EBITDA - net cash interest - cash taxes Cash interest paid 2022: "Interest Paid Classified As Financing Activities" = 114,121,000 Interest received 2022: "Interest Received Classified As Investing Activities" = 29,243,000 Net cash interest = 84,878,000 Cash taxes paid 2022: "Income Taxes Paid Refund Classified As Operating Activities" = 178,506,000 FFO = 1,305,021,000 - 84,878,000 - 178,506,000 = 1,041,637,000 Or using reported "Cash Flows From Used In Operations Before Changes In Working Capital" 2022: 1,062,464,000 Difference is about 21M, likely due to other items. Let me use reported figure: **FFO_2022 = 1,062,464,000 EUR** Or if I must calculate: 1,041,637,000 EUR. I'll use the more standard calculation: **1,041,637,000 EUR** Actually, let me check: "Cash Flows From Used In Operations Before Changes In Working Capital" 2022 = 1,062,464,000 This includes various adjustments. For consistency with 2021, let me use the same method: 2021: I used 1,002,058,000 (reported pre-WC) 2022: 1,062,464,000 (reported pre-WC) **FFO_2022 = 1,062,464,000 EUR** ## Step 9: Estimate 2022 Adjusted_Debt Debt at 2023-01-01 (2022 year-end): - Other Noncurrent Financial Liabilities: 4,722,263,000 - Other Current Financial Liabilities: 619,418,000 Total reported debt = 5,341,681,000 EUR Pension liability: "Noncurrent Provisions For Employee Benefits" 2023-01-01: 112,989,000 Cash at 2023-01-01: - Continued operations: 559,908,000 - Discontinued operations: 0 Total cash = 559,908,000 Also "Disponibilità Monetaria Netta" 2023-01-01: 559,908,000 EUR **Adjusted_Debt_2022 = 5,341,681,000 + 112,989,000 - 559,908,000 = 4,894,762,000 EUR** Or approximately **4,895 million EUR** ## Step 10: Calculate 2022 Adjusted_Debt / Adjusted_EBITDA = 4,894,762,000 / 1,305,021,000 = **3.75x** ## Step 11: Calculate 2022 FFO / Adjusted_Debt = 1,062,464,000 / 4,894,762,000 = **0.217** or **21.7%** Or using calculated FFO: 1,041,637 / 4,894,762 = 0.213 or 21.3% Let me use reported-based FFO: **0.217 or 21.7%** ## Step 12: Classify year-on-year credit trend ### Signal 1: Leverage (Adjusted_Debt / Adjusted_EBITDA) - 2021: 3.59x - 2022: 3.75x - Change: +0.16x Threshold: ≤ -0.2x: Improving; between -0.2x and +0.2x: Stable; ≥ +0.2x: Deteriorating +0.16x is **Stable** (between -0.2x and +0.2x, though closer to deteriorating threshold) ### Signal 2: Cash-flow coverage (FFO / Adjusted_Debt) - 2021: 0.222 (22.2%) - 2022: 0.217 (21.7%) - Change: -0.005 or -0.5 percentage points Wait, let me recalculate: 0.217 - 0.222 = -0.005 Threshold: ≥ +0.03: Improving; between -0.03 and +0.03: Stable; ≤ -0.03: Deteriorating -0.005 is **Stable** (between -0.03 and +0.03) ### Combining signals: - Signal 1 (Leverage): Stable (+0.16x, below +0.2x threshold) - Signal 2 (Coverage): Stable (-0.005, within ±0.03 band) Both signals are **Stable**. However, let me double-check my calculations as both are near the deteriorating boundaries. Actually, let me recalculate more carefully: For 2021: - Adjusted_EBITDA = 1,256,075,000 - Adjusted_Debt = 5,077,201,000 + 120,150,000 - 693,193,000 = 4,504,158,000 - Ratio = 3.587x For 2022: - Adjusted_EBITDA = 1,305,021,000 - Adjusted_Debt = 5,341,681,000 + 112,989,000 - 559,908,000 = 4,894,762,000 - Ratio = 3.750x Change = 3.750 - 3.587 = +0.163x This is clearly in Stable range (below +0.2x), though directionally negative. For FFO/Debt: 2021: 1,002,058,000 / 4,504,158,000 = 0.2225 2022: 1,062,464,000 / 4,894,762,000 = 0.2171 Change = 0.2171 - 0.2225 = -0.0054 This is clearly Stable (well within ±0.03). But wait - I want to verify my FFO_2022. Let me recalculate using the formula: FFO = Adjusted EBITDA - cash interest - cash taxes = 1,305,021,000 - 114,121,000 + 29,243,000 - 178,506,000? Actually, for "cash interest" in S&P FFO, do we use gross or net? Standard S&P: FFO = EBITDA - Cash Interest Paid - Cash Taxes Paid + Interest Received (if operational) Or: FFO = EBITDA - Net Cash Interest - Cash Taxes If I use net: 114,121 - 29,243 = 84,878 net paid FFO = 1,305,021 - 84,878 - 178,506 = 1,041,637 If I use gross interest paid: 1,305,021 - 114,121 - 178,506 = 1,012,394 The reported "Cash Flows From Used In Operations Before Changes In Working Capital" is 1,062,464, which is higher than both. This suggests there are other add-backs or adjustments. Looking at the components: Operating profit: 565,851 + D&A: 594,636 + Impairments: 67,680 + Provisions change: 14,167 + Employee benefits change: -19,158 + Finance costs adjustment: 85,708 - Taxes paid: 178,506 = 1,130,378... not matching 1,062,464 Hmm, let me recheck: 565,851 + 594,636 + 67,680 + 14,167 - 19,158 + 85,708 - 178,506 = 1,130,378 Difference from 1,062,464 is 67,914. Could be "Other Inflows Outflows Of Cash Classified As Operating Activities" of -210,271 not included? No, that would make it lower. Actually, I think "Cash Flows From Used In Operations Before Changes In Working Capital" might exclude some items or include others. Let me just use the reported figure for consistency. But wait - 1,130,378 vs 1,062,464. The difference is 67,914. Looking at "Gains Losses On Change In Fair Value Of Derivatives" = 0. Not that. Maybe the "Adjustments For Finance Costs" of 85,708 includes some non-cash items that should be excluded? Or maybe there's a different definition. Given the uncertainty, let me use the formula-based FFO for consistency across years, or use reported pre-WC cash flow. Actually, for 2021 I used 1,002,058 reported. For 2022 I'll use 1,062,464 reported. These are comparable as both are "Cash Flows From Used In Operations Before Changes In Working Capital." But S&P FFO is technically different from this. However, for many practical purposes, they're close. Let me recalculate with formula-based for both years: 2021 FFO = 1,256,075 - (97,388 - 11,491) - 150,662? No, cash taxes not accrual. Use cash amounts: 2021: 1,256,075 - 100,752 + 14,511 - 180,117 = 989,717? Or with net interest: 1,256,075 - 86,241 - 180,117 = 989,717 2022: 1,305,021 - 114,121 + 29,243 - 178,506 = 1,041,637? Or with net: 1,305,021 - 84,878 - 178,506 = 1,041,637 FFO/Debt: 2021: 989,717 / 4,504,158 = 0.2197 2022: 1,041,637 / 4,894,762 = 0.2128 Change: -0.0069 Still Stable. Using reported pre-WC: 2021: 1,002,058 / 4,504,158 = 0.2225 2022: 1,062,464 / 4,894,762 = 0.2171 Change: -0.0054 Both approaches give Stable. Now, let me reconsider the leverage signal more carefully. +0.16x is close to +0.2x threshold. Is there any reason to think it's more material? The increase in leverage is driven by: - EBITDA growth: +3.9% (1,256 to 1,305) - Debt growth: +8.7% (4,504 to 4,895) Debt grew faster than EBITDA, mainly due to increased financial liabilities (5,077 to 5,342, +5.2%) and reduced cash (693 to 560, -19.2%). The cash reduction is notable - from 693M to 560M, partly funding capex and dividends. For a regulated utility, some leverage increase is expected during investment cycles. The +0.16x is modest and below the 0.2x threshold. Both signals are Stable. However, the direction is slightly negative for both (leverage up, coverage down). But neither crosses the threshold. Wait - I need to re-verify my debt calculation. Let me check if I'm double-counting pension or missing something. Actually, looking more carefully at "Noncurrent Provisions For Employee Benefits" - this is IAS 19 employee benefits, which includes pension but also other post-employment benefits. The "Reserve Of Remeasurements Of Defined Benefit Plans Member" in equity shows actuarial gains/losses. For S&P, they typically add the funded status deficit to debt. If the plan is underfunded, liability > assets, and deficit is added to debt. If I don't have plan assets, I might overstate debt by adding full liability. However, for many European companies, especially Italian ones, pension plans are often unfunded or partially funded. The 120M/113M might be largely unfunded. Let me check if there's any indication of plan assets. Looking through the data, I don't see "Plan Assets" or similar. So I'll keep my approach. Actually, let me reconsider whether to include pension liability in debt. S&P's standard formula is: Adjusted Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash If pension is already in "provisions" and not in "debt," I should add it. But if it's a provision for employee benefits that includes both funded and unfunded portions, I need to be careful. In Italian GAAP/IFRS, "Noncurrent Provisions For Employee Benefits" typically includes the full IAS 19 liability, net of any plan assets. So the 120,150,000 and 112,989,000 are likely net liabilities (already net of plan assets). So I should include these in debt-like items. My calculation stands. Let me also verify reported debt: 2021: Other Noncurrent Financial Liabilities 4,791,979 + Other Current Financial Liabilities 285,222 = 5,077,201 2022: 4,722,263 + 619,418 = 5,341,681 Wait - current financial liabilities increased significantly from 285M to 619M (+117%). This is a notable increase. Noncurrent decreased from 4,792M to 4,722M (-1.5%). Total debt up 5.2%. The shift from noncurrent to current suggests refinancing needs or reclassification. This could indicate some near-term refinancing pressure, but overall debt growth is moderate. For a regulated utility, debt growth to fund capex is normal. Let me check capex: "Acquisto O Cessione Immobilizzazioni Materiali" 2022: 350,085 "Acquisto O Cessione Di Immobilizzazioni Immateriali" 2022: 700,218 Total capex 2022: ~1,050M 2021 capex: 626,507 + 354,759 = 981,266 Capex increased, partly explaining debt growth. Also, working capital was negative in both years (cash outflow), suggesting some operational pressure. Overall, the credit metrics show: - Leverage: Stable (3.59x to 3.75x, +0.16x) - Coverage: Stable (22.2% to 21.7%, -0.5pp) Both signals are Stable. The trend is very mildly negative but does not cross any threshold. However, I want to double-check: is +0.16x really "Stable"? The threshold is +0.2x for Deteriorating. +0.16x < +0.2x, so yes, Stable. And -0.005 for coverage is well within ±0.03. Therefore, the classification is **Stable**. But let me consider if there's any reason to lean toward Deteriorating given the direction. The instructions say: - If both signals agree, return that category - If one is Stable and other is Improving/Deteriorating, return non-Stable - If conflict, reason explicitly and lean conservative Here both are Stable, so answer is Stable. Wait - I want to re-verify my EBITDA and debt figures one more time to ensure no calculation error. 2021: - Revenue: 3,972,061 - Operating Expense: 2,737,035 - Gross Profit (MOL/EBITDA): 1,256,075 ✓ - Operating Profit: 581,101 - D&A + Impairments: 588,768 + 86,207 = 674,975 - 581,101 + 674,975 = 1,256,076 ≈ 1,256,075 ✓ 2022: - Revenue: 5,138,245 - Operating Expense: 3,861,121 - Gross Profit: 1,305,021... wait, 5,138,245 - 3,861,121 = 1,277,124 ≠ 1,305,021 Hmm! Let me check. Revenue 2022 = 5,138,245. Operating Expense 2022 = 3,861,121. Difference = 1,277,124. But Gross Profit = 1,305,021. Difference = 27,897. This 27,897 matches "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates" 2022: 27,897. So Gross Profit = Revenue - Operating Expense + Other Income from subs/associates? That would be unusual for "gross profit" definition. Actually, in Italian reporting, "Margine Operativo Lordo" (Gross Operating Margin) is calculated as: Revenue - Variable Costs - External Costs - Personnel Costs + Other Operating Income It may include some "other operating income" items. The 27,897 from subsidiaries/associates might be included in MOL. So MOL/EBITDA = 1,305,021 is correct as reported. For 2021: 3,972,061 - 2,737,035 = 1,235,026. Other income from subs/associates = 21,048. Sum = 1,256,074 ≈ 1,256,075 ✓ So EBITDA includes equity income from subsidiaries/associates that are operationally related. This is a feature of Italian reporting. For S&P purposes, is this appropriate? Equity income is typically below EBITDA. But if these are operational JVs that are proportionally consolidated in management EBITDA, it might be acceptable. However, for strict S&P methodology, they might want to exclude equity income and use proportional EBITDA instead. But we don't have enough data to reconstruct this. Given the data limitations, I'll proceed with reported MOL as EBITDA proxy, noting that it includes some equity income. Actually, looking more carefully: "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates" - this is likely dividends or income from participations, not operating equity income. The "Share Of Profit Loss Of Associates And Joint Ventures Accounted For Using Equity Method" is separate (17,793 in 2022, 7,798 in 2021). So the 27,897 in 2022 is other income from subs/associates, not equity method income. It might be management fees, service income, or other operational items. Given this, I'll keep my EBITDA figures. Final verification of ratios: 2021: - Adj EBITDA: 1,256,075 - Adj Debt: 4,504,158 (5,077,201 debt + 120,150 pension - 693,193 cash) - Debt/EBITDA: 3.587x - FFO: 1,002,058 (reported pre-WC) or 989,717 (calculated) - FFO/Debt: 22.25% or 21.97% 2022: - Adj EBITDA: 1,305,021 - Adj Debt: 4,894,762 (5,341,681 debt + 112,989 pension - 559,908 cash) - Debt/EBITDA: 3.750x - FFO: 1,062,464 (reported) or 1,041,637 (calculated) - FFO/Debt: 21.71% or 21.28% Changes: - Debt/EBITDA: +0.163x (Stable) - FFO/Debt: -0.54% or -0.69% (Stable) Both Stable. One final check: should I use gross or net interest for FFO? S&P typically uses "cash interest paid" which is gross. But they also sometimes deduct "interest received" if it's operational. From financing activities: Interest Paid = 114,121 (2022), 100,752 (2021) From investing activities: Interest Received = 29,243 (2022), 14,511 (2021) For utilities, interest received is often from late customer payments or cash deposits. If from cash deposits, it's more investing; if from operations, it's operating. Given "Interest Received Classified As Investing Activities," this suggests it's from financial assets, not operations. So for operational FFO, we might exclude it. Using gross interest paid: 2021 FFO = 1,256,075 - 100,752 - 180,117 = 975,206 2022 FFO = 1,305,021 - 114,121 - 178,506 = 1,012,394 FFO/Debt: 2021: 975,206 / 4,504,158 = 21.65% 2022: 1,012,394 / 4,894,762 = 20.68% Change: -0.97% or -0.0097 Still Stable (within ±0.03). Using reported pre-WC cash flow: 2021: 1,002,058 / 4,504,158 = 22.25% 2022: 1,062,464 / 4,894,762 = 21.71% Change: -0.54% or -0.0054 Still Stable. I think my conclusion is robust: **Stable**. However, I want to note that both metrics moved in a negative direction (higher leverage, lower coverage), though not enough to trigger a "Deteriorating" classification. The company increased debt to fund capex and acquisitions, while EBITDA grew but not as fast as debt. This is a common pattern for regulated utilities in investment phases. Given the conservative bias instruction for conflicting signals, but here both agree on Stable, the answer is clear. Stable