### Step 1: Identify the relevant industry ACEA S.P.A. is a multi-utility company operating in Italy, providing water, electricity, and gas distribution, among other services. The financial data shows significant regulated revenue streams and terminology consistent with a regulated utility (e.g., "Margine Operativo Lordo," detailed disclosures on regulatory reserves). Therefore, the **Regulated Utilities** methodology is the most appropriate. ### Step 2: Estimate Adjusted EBITDA First, we reconstruct EBITDA from the income statement. - **Revenue (2022):** 5,138,245,000 EUR - **Operating Expense (2022):** 3,861,121,000 EUR - Employee Benefits Expense: 305,066,000 EUR - Costi Esterni: 3,556,055,000 EUR - **Gross Profit = Revenue - Operating Expense:** 1,277,124,000 EUR - Wait, the directly provided "Gross Profit" is 1,305,021,000 EUR. This matches Revenue (5,138,245) - Costi Esterni (3,556,055) - Employee Benefits (305,066) + Other Income (181,066) - Other adjustments? Let's check: 5,138,245 - 3,556,055 - 305,066 = 1,277,124. Then + 181,066 (Other Income) = 1,458,190. That doesn't match the given Gross Profit of 1,305,021. The difference might be Other Income/Expense from Subsidiaries (27,897). Let's recalculate: Revenue 5,138,245 - Operating Expense 3,861,121 = 1,277,124. Plus Other Income 181,066 = 1,458,190. Plus Other Income Expense From Subsidiaries 27,897 = 1,486,087. The given "Gross Profit" (Margine Operativo Lordo) is actually EBITDA. Italian "Margine Operativo Lordo" (MOL) is EBITDA. Let's check the provided "Gross Profit": 1,305,021,000. How is it derived? Revenue 5,138,245 - Costi Esterni 3,556,055 - Employee Benefits 305,066 = 1,277,124. Difference: 1,305,021 - 1,277,124 = 27,897. This is exactly "Other Income Expense From Subsidiaries Jointly Controlled Entities And Associates" = 27,897,000. So "Gross Profit" (EBITDA) = Revenue - Costi Esterni - Employee Benefits + Other Income from Subsidiaries. Wait, where is "Other Income" 181,066? If we include it, EBITDA would be 1,486,087. Let's check the cash flow statement for adjustments: "Profit Loss From Operating Activities" (EBIT) = 565,851,000. "Ammortamenti EAccantonamenti" (D&A) = 625,799,000. "Impairment Loss" = 113,370,000. EBIT + D&A + Impairment = 565,851 + 625,799 + 113,370 = 1,305,020. This matches the provided "Gross Profit" of 1,305,021,000 (1 EUR rounding difference). Therefore, reported EBITDA = 1,305,021,000 EUR. - **Adjustments for Leases:** - Right-of-use assets 2023: 90,397,000; 2022: 53,096,000. - S&P adds back depreciation from leases to EBITDA. We need lease depreciation. - "Ammortamenti EAccantonamenti" includes 625,799,000 total D&A. Lease depreciation is part of this. Without explicit lease depreciation, we can approximate or check "Other Inflows Outflows Of Cash Classified As Financing Activities" for lease payments, but we don't have a breakdown. - For regulated utilities, S&P typically adds back lease depreciation if it was deducted from EBITDA (which it was, per IFRS 16). Since we cannot separate it, we might need to assume it's part of the D&A. But we can leave it as is, or adjust if data exists. The data shows "Rightofuse Assets" increasing, so there's depreciation. However, without the exact amount, we'll assume EBITDA already reflects IFRS 16 (i.e., lease costs are depreciation and interest, not operating lease expense). S&P's "Adjusted EBITDA" for IFRS reporters often adds back the lease depreciation to get to an "EBITDAR-like" measure for leverage, but the formula above says `Adjusted_EBITDA = EBITDA (reported) + adjustment_leases`. Since the industry section doesn't specify a different treatment, and we lack the lease depreciation amount, we might use "Cash Flows From Used In Operations Before Changes In Working Capital" of 1,062,464,000 plus "Income Taxes Paid" 178,506,000 plus "Finance Costs" adjustments? Let's stick to the given EBITDA and note the lease adjustment is likely embedded in the reported EBITDA under IFRS 16. S&P guidance often does: `Adjusted EBITDA = EBIT + D&A + Impairment + Lease depreciation`. Since we have EBIT + D&A + Impairment = 1,305,021, and lease depreciation is already in D&A, we'd need to add it back *again*? No, S&P adds back the entire lease depreciation to EBITDAR. Wait, "Adjustments For Depreciation And Amortisation Expense" is 594,636,000. EBITDA from operations: Profit Loss From Operating Activities (565,851) + D&A (594,636) + Impairment (113,370) + Variazione Fondo Rischi (14,167) + Variazione Netta Fondo ( -19,158 )? That's cash flow adjustments. Let's just use reported EBITDA = 1,305,021,000. We will assume no separate lease adjustment is needed to EBITDA if we are not adjusting debt for leases, BUT S&P typically adds lease liabilities to debt, so they DO adjust EBITDA for leases. S&P methodology: `FFO = Adjusted EBITDA - Cash Interest - Cash Taxes + ...` For IFRS 16, S&P adds back depreciation of right-of-use assets to EBITDA, because lease payments are treated as debt repayment (principal part) in FFO/debt calculation. We don't have the explicit lease depreciation. Let's check if we can derive it. Right-of-use assets: Beginning 53,096, End 90,397. Increase of 37,301. This increase could be additions minus depreciation. We have additions from "Acquisto OCessione Immobilizzazioni" but that's capex. Actually, "Other Inflows Outflows Of Cash Classified As Operating Activities" includes -210,271,000. Lease payments? Not clear. Let's use the data given: S&P usually takes reported EBITDA, then for debt adds operating lease liabilities. But with IFRS 16, operating leases are already on balance sheet. We have "Noncurrent Contract Liabilities" which seem huge: 5,452,905,000. That doesn't look like lease liabilities. There are financial liabilities: "Other Noncurrent Financial Liabilities" 4,722,263,000 and "Other Current Financial Liabilities" 619,418,000. These likely include financial debt and lease liabilities. We don't have a breakdown. Given the assignment, maybe we should not overcomplicate and just use the given EBITDA and treat debt as reported financial debt. - **Pension adjustments:** "Noncurrent Provisions For Employee Benefits" 112,989,000 (TFR). S&P adds back service cost and subtracts pension contributions maybe? We don't have the data. We'll assume it's not material or already reflected. - **Nonrecurring items:** Gains Losses On Change In Fair Value Of Derivatives = 0. Other Income = 181,066, but part of EBITDA already. - **Joint ventures:** "Share Of Profit Loss Of Associates And Joint Ventures Accounted For Using Equity Method" = 17,793,000. This is after EBIT, so not in EBITDA. Since we lack detailed data to make sophisticated adjustments, and the Regulated Utilities methodology doesn't specify drastic deviations from the baseline formula for EBITDA (other than standard IFRS 16 adjustments), we'll take the reported EBITDA plus associate income? No, associate income is not in EBITDA. Let's assume **Adjusted EBITDA = 1,305,021,000**. ### Step 3: Estimate FFO FFO = Adjusted EBITDA - Cash Interest - Cash Taxes - **Adjusted EBITDA:** 1,305,021,000 EUR - **Cash Interest:** - "Finance Costs" = 111,670,000 EUR - "Adjustments For Finance Costs" in cash flow = 85,708,000 EUR (this is the non-cash part? No, "Adjustments For Finance Costs" in the reconciliation is added back to profit to get to operating cash flow, meaning it's the accrued interest. Cash interest paid is "Interest Paid Classified As Financing Activities" = 114,121,000 EUR. We'll use 114,121,000 EUR.) - **Cash Taxes:** - "Income Tax Expense" = 186,777,000 EUR - "Income Taxes Paid Refund" = 178,506,000 EUR. We'll use 178,506,000 EUR. **FFO = 1,305,021,000 - 114,121,000 - 178,506,000 = 1,012,394,000 EUR** Check: "Cash Flows From Used In Operating Activities" = 726,703,000. FFO is typically close to CFO before working capital changes. "Cash Flows From Used In Operations Before Changes In Working Capital" = 1,062,464,000. This includes interest and taxes? Yes, it's after interest and taxes? No, that's after interest and taxes. Cash Flows Before Working Capital = 1,062,464 Minus "Income Taxes Paid" (-178,506 is already included? Actually, the reconciliation: "Cash Flows From Used In Operations Before Changes In Working Capital" is *after* taxes? Yes, the statement says "Cash Flows From Used In Operations Before Changes In Working Capital" and then "Income Taxes Paid Refund Classified As Operating Activities" is shown separately earlier in the indirect method reconciliation, meaning the "before changes" already deducted taxes? Let's re-read: - Profit Loss From Operating Activities: 565,851 - Adjustments for D&A: 594,636 - Adjustments for Impairment: 67,680 - Variazione Fondo Rischi: 14,167 - Variazione Netta Fondo: -19,158 - Adjustments for Finance Costs: 85,708 - Sum of these = 1,308,884? No, 565,851 + 594,636 = 1,160,487; + 67,680 = 1,228,167; + 14,167 = 1,242,334; -19,158 = 1,223,176; + 85,708 = 1,308,884. - Then minus Income Taxes Paid (178,506)? The provided line "Cash Flows From Used In Operations Before Changes In Working Capital" is 1,062,464. - 1,308,884 - 178,506 = 1,130,378. Not 1,062,464. - There is also "Other Inflows Outflows Of Cash Classified As Operating Activities" = -210,271. But that's later. - Actually, S&P FFO = EBIT + D&A + Impairment - Cash Interest - Cash Taxes. - EBIT = 565,851. - D&A = 594,636. - Impairment = 113,370? Wait, "Adjustments For Impairment Loss..." is 67,680 in cash flow, but income statement has 113,370. - Let's just use the simple formula: EBITDA (1,305,021) - Cash Interest (114,121) - Cash Taxes (178,506) = 1,012,394. ### Step 4: Estimate Adjusted Debt Adjusted Debt = (Reported Debt + Leases + Pension Deficit + Guarantees + Hybrid Debt Portion + Other Debt-like Items) - Eligible Cash - **Reported Debt:** - "Other Noncurrent Financial Liabilities": 4,722,263,000 EUR - "Other Current Financial Liabilities": 619,418,000 EUR - Total Reported Financial Debt = 4,722,263 + 619,418 = 5,341,681,000 EUR - **Leases:** Already included in the above under IFRS 16? Yes, lease liabilities are part of financial liabilities. So no separate add-back needed. - **Pension Deficit:** - "Noncurrent Provisions For Employee Benefits" (TFR): 112,989,000 EUR. - Is there a deficit? This is the entire provision. TFR is a defined benefit obligation in Italy. We'll include the full amount as debt-like, as S&P typically treats unfunded pensions as debt. 112,989,000 EUR. - **Guarantees/Hybrids/Other:** Not indicated. - **Eligible Cash:** - "DisponibilitàLiquide EMezzi Equivalenti" (Cash and Equivalents): 559,908,000 EUR. - "Other Current Financial Assets": 342,085,000 EUR. (Are these liquid? They might include short-term investments, but typically S&P only nets surplus cash. We'll be conservative and only net cash and equivalents, or maybe all current financial assets? The prompt says "eligible cash", usually unrestricted cash and equivalents. We'll use 559,908,000). **Adjusted Debt = 5,341,681,000 + 112,989,000 - 559,908,000 = 4,894,762,000 EUR** Alternatively, some analysts include "Other Current Financial Assets" as cash if they are liquid. The Italian label "Altre attività finanziarie correnti" includes short-term securities. Let's check the 2022 vs 2021 numbers: 342,085 vs 407,944. They might be part of surplus cash. But we'll stick to cash equivalents as stated: 559,908,000. Wait, the cash flow statement says "DisponibilitàMonetaria Netta" 559,908,000. This is net cash. ### Step 5: Calculate FFO / Adjusted_Debt FFO = 1,012,394 Adjusted Debt = 4,894,762 Ratio = 1,012,394 / 4,894,762 = 0.206831... Rounding to four decimal places: **0.2068** Let's double-check if there are any other adjustments. - "Adjustments For Finance Costs" in cash flow was 85,708, but cash interest paid was 114,121. The difference could be interest income or something else. - "Finance Income" = 25,962. S&P usually nets interest income against interest expense in FFO? No, FFO = EBITDA - Cash Interest - Cash Taxes. Cash interest is net? S&P's definition: "Cash interest paid net of interest received". So we subtract 114,121 and add "Interest Received Classified As Investing Activities"? No, "Interest Received Classified As Investing Activities" is 29,243, but "Finance Income" in P&L is 25,962. The cash flow from investing has "Interest Received" = 29,243. So net cash interest = 114,121 - 29,243 = 84,878. - If we use net cash interest, FFO = 1,305,021 - 84,878 - 178,506 = 1,041,637. - Ratio = 1,041,637 / 4,894,762 = 0.2128. Which one is correct? S&P's definition: "FFO is adjusted EBITDA minus cash interest paid net of interest received, minus cash taxes paid." So we need to subtract net cash interest. Cash interest paid = 114,121. Interest received (cash) = 29,243. Net = 84,878. Taxes paid = 178,506. FFO = 1,305,021 - 84,878 - 178,506 = 1,041,637. Adjusted Debt = Total financial debt 5,341,681 + TFR 112,989 - Cash 559,908 = 4,894,762. Ratio = 1,041,637 / 4,894,762 = 0.2128. Wait, what about leases? IFRS 16 already capitalizes leases, so debt includes lease liabilities. EBITDA includes lease depreciation? No, EBITDA under IFRS 16 excludes lease depreciation and lease interest, so reported EBITDA is higher than old IAS 17 EBITDA. S&P's methodology for IFRS 16: They keep EBITDA as reported AND keep lease liabilities in debt. So no adjustment is needed to EBITDA for leases, and debt already includes them. This is the standard S&P treatment for IFRS 16. Final check on TFR: S&P adds back total deficit or just unfunded? "Noncurrent Provisions For Employee Benefits" is the defined benefit obligation. We assumed it's the deficit. Since there's no plan assets listed, it's likely unfunded, so the entire obligation is the deficit. 112,989,000. Let's recalculate adjusted debt: Financial Liabilities Noncurrent: 4,722,263 Financial Liabilities Current: 619,418 Total Debt: 5,341,681 Plus Pension Deficit: 112,989 Minus Cash: 559,908 Adjusted Debt = 4,894,762 FFO: Adjusted EBITDA = 1,305,021 Cash Interest (Net) = 114,121 - 29,243? Wait, interest received is from investing activities. But the cash flow from investing has "Interest Received Classified As Investing Activities" = 29,243,000. S&P adds this back to FFO? No, they subtract net interest. So cash interest net = 114,121 - 29,243 = 84,878. Cash Taxes = 178,506. FFO = 1,305,021 - 84,878 - 178,506 = 1,041,637. Ratio = 1,041,637 / 4,894,762 = 0.2128. Let's quickly check if there are any other debt-like items, like "Other Noncurrent Provisions" = 218,025. S&P typically doesn't add operating provisions to debt. TFR is specifically a pension/debt-like item. Final calculation: 1,041,637 / 4,894,762 = 0.212805... Rounding to four decimal places: 0.2128.0.2128