I'll work through this step-by-step for ITALGAS S.P.A., which is a gas utility company. ## Step 1: Identify the relevant industry ITALGAS S.P.A. is a gas distribution company. Based on the provided methodologies, this falls under **"Regulated Utilities"** - specifically the "Gas" subsector. The company operates under regulated tariff frameworks for gas distribution. ## Step 2: Estimate Adjusted_EBITDA First, I need to reconstruct EBITDA from the available data. From the income statement data for 2022 (2022-01-01 to 2023-01-01): - Revenue And Operating Income: 2,312,476,000 EUR - Operating Expense: 1,191,952,000 EUR - Depreciation Amortisation And Impairment Loss Reversal: 479,186,000 EUR - Profit Loss From Operating Activities (EBIT): 641,338,000 EUR EBITDA = EBIT + Depreciation/Amortization EBITDA = 641,338,000 + 479,186,000 = 1,120,524,000 EUR For regulated utilities, S&P typically does not make significant EBITDA adjustments unless there are specific items. Looking at the data: - No lease adjustments mentioned (no finance lease information explicitly provided) - The "Costs For The Use Of Third Party Assets" of 102,319,000 EUR may include lease costs, but without explicit lease accounting details, I'll use reported figures - No significant nonrecurring items identified that require adjustment Adjusted_EBITDA = 1,120,524,000 EUR ## Step 3: Estimate FFO Baseline formula: FFO = Adjusted_EBITDA - cash_interest - cash_taxes From the cash flow data for 2022: - Finance Costs Paid Classified As Operating Activities: 53,720,000 EUR (this is cash interest paid) - Income Taxes Paid Classified As Operating Activities: 152,372,000 EUR (cash taxes) FFO = 1,120,524,000 - 53,720,000 - 152,372,000 = 914,432,000 EUR Let me verify this using the indirect approach from cash flow statement: - Cash Flows From Used In Operations: 548,169,000 EUR - This includes working capital changes, so let me use the EBITDA-based approach which is more standard for FFO. Actually, let me recalculate more carefully using S&P's typical approach. FFO is typically calculated as: FFO = Net Income + Depreciation/Amortization + Deferred Taxes + Other non-cash items - Working capital changes (sometimes) Or more standard for S&P: FFO = Funds from Operations = EBIT + Depreciation - Cash Interest - Cash Taxes (with adjustments) Let me use: FFO = EBITDA - Cash Interest - Cash Taxes = 1,120,524,000 - 53,720,000 - 152,372,000 = 914,432,000 EUR Wait - let me also check if there's a more direct way. Looking at cash flow from operations: Cash Flows From Used In Operations = 548,169,000 EUR This is after working capital changes. For FFO, S&P typically wants pre-working capital or with certain adjustments. Let me use the standard S&P approach for utilities: FFO = Net Income + D&A + Deferred Taxes + Other non-cash items ± working capital adjustments (if normalized) Actually, for regulated utilities, S&P typically uses: FFO = EBITDA - Cash Interest - Cash Taxes But let me verify with another approach: Net Income (Profit Loss) = 436,126,000 + Depreciation/Amortization = 479,186,000 + Interest expense (accrual) = 61,367,000 (Finance Costs) - Interest received = 4,043,000 (Finance Income) = 972,636,000 (rough proxy for operating cash before working capital and taxes) Then subtract cash taxes paid: 152,372,000 = 820,264,000 This doesn't match well. Let me be more careful. Actually, looking more carefully at S&P methodology for regulated utilities - they focus on sustainable cash generation. Let me use: FFO = Adjusted_EBITDA - cash_interest - cash_taxes = 1,120,524,000 - 53,720,000 - 152,372,000 = 914,432,000 EUR But I need to check if this is correct. The cash interest paid is 53,720,000, but finance costs on P&L are 61,367,000. The difference may be capitalized interest or accrual differences. For S&P purposes, cash interest paid is what matters. Let me also consider: should I use the cash flow from operations and adjust? Cash Flows From Used In Operations = 548,169,000 + Working capital increase (negative impact) = 336,750,000 (from "Increase Decrease In Working Capital" being -336,750,000, meaning working capital used cash) Actually "Increase Decrease In Working Capital" 2022-01-01 - 2023-01-01: -336,750,000 means working capital increased, using cash. So pre-working capital operating cash flow = 548,169,000 + 336,750,000 = 884,919,000? No wait, if working capital increased (negative in cash flow), then: Cash flow from ops = EBIT + D&A - WC changes - cash taxes - cash interest (roughly) 548,169,000 = ? Let me try: EBIT(641,338) + D&A(479,186) = 1,120,524 (EBITDA) - WC increase (336,750,000) [since "Increase Decrease In Working Capital" is -336,750,000, this means working capital increased, reducing cash] - cash interest (53,720,000) - cash taxes (152,372,000) = 1,120,524,000 - 336,750,000 - 53,720,000 - 152,372,000 = 577,682,000 This doesn't equal 548,169,000. There's a discrepancy of about 29.5 million. Looking at other items in cash flow from operations: - Dividends Received Classified As Operating Activities: 1,372,000 - Finance Income Received: 4,043,000 These might be added back or treated differently. Let me try simpler: S&P FFO for utilities is often calculated as: FFO = Net Income + Depreciation + Deferred Taxes - Equity Earnings + Other non-cash items Or more practically for this case, I'll use: FFO = Cash Flows From Used In Operations + Cash Interest Paid + Cash Taxes Paid - Working Capital Changes - Other non-operating items in CFO Actually, the cleanest S&P approach is: FFO = EBITDA - Cash Interest - Cash Taxes For regulated utilities with seasonal working capital needs, S&P may also adjust working capital. But looking at the methodology provided: "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." For FFO, the standard approach is EBITDA - cash interest - cash taxes. Let me verify my EBITDA calculation: Revenue And Operating Income: 2,312,476,000 Operating Expense: 1,191,952,000 = Gross operating margin: 1,120,524,000? No wait, this already includes D&A. Actually: Profit Loss From Operating Activities = 641,338,000 This is EBIT. And Depreciation Amortisation And Impairment = 479,186,000 So EBITDA = 641,338,000 + 479,186,000 = 1,120,524,000. ✓ Now for FFO, I'll use: FFO = EBITDA - Cash Interest - Cash Taxes = 1,120,524,000 - 53,720,000 - 152,372,000 = 914,432,000 EUR But wait - I need to check if "Finance Costs Paid" includes all cash interest or if there are other interest payments. Also, is there capitalized interest? Looking at the data, "Finance Costs" on P&L = 61,367,000, but "Finance Costs Paid Classified As Operating Activities" = 53,720,000. The difference (7,647,000) could be capitalized interest or accrual timing differences. For S&P FFO, we use cash interest paid, so 53,720,000 seems right. However, I want to double-check using another approach. Let me look at what S&P typically does for European utilities. Actually, let me recalculate more carefully using the cash flow statement approach and adjusting to get FFO: Cash Flows From Used In Operations = 548,169,000 + Cash Interest Paid (53,720,000) - this is typically a financing outflow in IFRS but here it's classified as operating + Cash Taxes Paid (152,372,000) - Dividends Received (1,372,000) - typically investing - Finance Income Received (4,043,000) - typically investing or operating Hmm, this gets complicated with IFRS classification differences. Let me use a cleaner approach: S&P's standard FFO calculation for utilities: FFO = Net Income + Depreciation/Amortization + Interest Expense + Income Tax Expense - Cash Interest - Cash Taxes + Deferred Taxes... Actually no, the standard is: FFO = Funds From Operations = EBIT + D&A - Cash Interest - Cash Taxes ± other adjustments Or: FFO = Operating Cash Flow + Cash Interest Paid + Cash Taxes Paid - Working Capital Changes (to normalize) Let me try: Operating Cash Flow (548,169,000) + Cash Interest (53,720,000) + Cash Taxes (152,372,000) = 754,261,000 Then subtract working capital changes: the "Increase Decrease In Working Capital" was -336,750,000 (meaning working capital increased, using cash) So normalized FFO before working capital = 754,261,000 - 336,750,000? No wait, if working capital increased and used cash, then to normalize we add back the working capital use? Actually: CFO = EBIT + D&A - ΔWC - Cash Interest - Cash Taxes (simplified) 548,169,000 = 641,338 + 479,186 - ΔWC - 53,720 - 152,372 - other items 548,169,000 = 1,120,524 - ΔWC - 53,720 - 152,372 - other 548,169,000 = 914,432 - ΔWC - other So 914,432 - ΔWC - other = 548,169 ΔWC + other = 366,263 But reported "Increase Decrease In Working Capital" = -336,750,000 (negative means cash outflow from working capital increase) Hmm, there's a 29.5 million difference. This could be dividends received (1,372) + finance income received (4,043) + other items = 5,415, plus some other adjustments. For practical purposes, let me use the direct S&P formula: FFO = EBITDA - Cash Interest - Cash Taxes = 1,120,524,000 - 53,720,000 - 152,372,000 = 914,432,000 EUR But I want to also consider if S&P would use "Funds From Operations" more aligned with sustainable cash generation. Let me check if there are adjustments needed for regulated utilities. Looking back at the methodology: "We do not adjust GAAP earnings or balance-sheet figures to remove the effects of regulatory accounting." For Italian utilities, there may be specific adjustments. But without more specific information, I'll proceed with: FFO = 914,432,000 EUR Actually, let me reconsider. The cash flow statement shows "Cash Flows From Used In Operations" of 548,169,000. This is the IFRS operating cash flow. S&P's FFO is typically defined as: FFO = Net cash provided by operating activities + Increase in inventory + Decrease in accounts receivable + Decrease in prepaid expenses - Increase in accounts payable and accrued liabilities + Cash interest paid + Cash taxes paid - Dividends received - Interest received ± other adjustments Or more simply for many companies: FFO = Operating Cash Flow + Cash Interest + Cash Taxes - Working Capital Changes (normalized) Actually, I think the most standard S&P approach for utilities is: FFO = EBITDA - Cash Interest - Cash Taxes This gives 914,432,000. But let me also calculate using the cash flow approach to cross-check: CFO = 548,169,000 Add: Cash Interest Paid = 53,720,000 Add: Cash Taxes Paid = 152,372,000 Less: Dividends Received (1,372,000) - reclassify to investing Less: Finance Income Received (4,043,000) - reclassify to investing = 548,169 + 53,720 + 152,372 - 1,372 - 4,043 = 748,846,000 Then adjust for working capital changes to get "funds from operations" before working capital: The "Increase Decrease In Working Capital" line shows -336,750,000, meaning working capital increased, reducing cash flow. To normalize: 748,846,000 + 336,750,000 = 1,085,596,000? No that doesn't work either. Let me think more carefully. The standard formula is: CFO = Net Income + D&A + Other non-cash - ΔWC - Cash Interest - Cash Taxes... Actually in IFRS, CFO already includes: Net Income + D&A - ΔWC - Cash Taxes - Cash Interest (sometimes, or this is in financing) Looking at the data: "Finance Costs Paid Classified As Operating Activities" = 53,720,000 and "Income Taxes Paid Classified As Operating Activities" = 152,372,000. So these are in operating cash flows. So: CFO = Net Income + D&A - ΔWC + Other - Cash Interest - Cash Taxes (roughly) 548,169 = 436,126 + 479,186 - ΔWC + other - 53,720 - 152,372 548,169 = 709,220 - ΔWC + other So ΔWC - other = 161,051 But "Increase Decrease In Working Capital" = -336,750,000. This seems to include more than just working capital. Actually, looking at the detailed working capital components: - Decrease Increase In Inventories: -4,751,000 (inventory increased) - Decrease Increase In Trade Account Receivable: -65,399,000 (receivables increased) - Increase Decrease In Trade Account Payable: -400,375,000 (payables decreased... wait that's a huge number) Hmm, "Adjustments For Increase Decrease In Trade Account Payable" = -400,375,000. This is strange - payables decreased by 400 million? Let me check: Trade And Other Current Payables 2022-01-01: 769,137,000 and 2023-01-01: 1,197,117,000. This is an increase of 427,980,000, not a decrease. Wait, the label says "Adjustments For Increase Decrease In Trade Account Payable" 2022-01-01 - 2023-01-01: -400,375,000. If payables increased from 769,137 to 1,197,117, that's an increase of 427,980,000. But the adjustment is -400,375,000. This is close but not exact. The difference might be related party adjustments or other items. Actually, looking more carefully: "Trade And Other Current Payables" 2023-01-01: 1,197,117,000, but "Related Parties Member" 2023-01-01: 444,040,000. The total includes related parties. For 2022: 769,137,000 total with 36,683,000 related party. The increase in total is 427,980,000. But the cash flow adjustment is -400,375,000. This negative means... actually in cash flow statements, a negative adjustment for payables means... I'm getting confused with signs. Let me just use the direct EBITDA-based FFO calculation which is cleaner. FFO = EBITDA - Cash Interest - Cash Taxes = 1,120,524,000 - 53,720,000 - 152,372,000 = 914,432,000 EUR I'll use this as my FFO estimate. ## Step 4: Estimate Adjusted_Debt Baseline formula: Adjusted_Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash First, identify debt components from balance sheet: **Current financial liabilities:** - Short Term Financial Liabilities Excluding Other Current Financial Liabilities: 142,437,000 EUR (2023-01-01) - Other Current Financial Liabilities: 290,000 EUR **Noncurrent financial liabilities:** - Long Term Financial Liabilities Excluding Other Non Current Financial Liabilities: 6,402,913,000 EUR - Other Noncurrent Financial Liabilities: 34,000 EUR Total reported debt = 142,437,000 + 290,000 + 6,402,913,000 + 34,000 = 6,545,674,000 EUR Wait, I need to check if there are related party portions to include: - Short Term Financial Liabilities Excluding Other Current Financial Liabilities "Related Parties Member" 2023-01-01: 118,000 EUR - Long Term Financial Liabilities Excluding Other Non Current Financial Liabilities "Related Parties Member" 2023-01-01: -2,048,000 EUR (negative?) The negative related party amount for long-term debt is odd. This might be a net position. Let me use the total figures which should already include related party amounts. Total debt = 142,437,000 + 290,000 + 6,402,913,000 + 34,000 = 6,545,674,000 EUR **Leases:** Looking through the data, I see "Cash Outflow For Leases" = 27,865,000 EUR for 2022. This indicates lease obligations exist. However, I don't see explicit lease liability disclosure in the balance sheet items provided. In IFRS 16, leases are typically included in debt. Looking at the financial liabilities, they may already include lease liabilities. Without explicit separation, I'll assume leases are included in reported debt or make a rough estimate. Actually, looking more carefully: "Costs For The Use Of Third Party Assets" = 102,319,000 EUR on P&L. This could be lease expenses. But in IFRS 16, most leases are capitalized. Given the data limitations, I'll proceed with reported debt and note that leases may need adjustment. However, for many utilities, lease obligations are relatively small compared to total debt. **Pension deficit:** "Noncurrent Provisions For Employee Benefits" = 69,917,000 EUR. This is a pension/employee benefit obligation. S&P typically treats unfunded pension deficits as debt-like. However, "Reserves" includes "Reserve Of Remeasurements Of Defined Benefit Plans Member" = -7,195,000 EUR (negative, meaning liability). Actually, looking at the balance sheet: "Noncurrent Provisions For Employee Benefits" = 69,917,000 EUR. This is likely the net pension liability. For S&P purposes, pension deficit = gross pension liability - plan assets. Without more detail, I'll use the provision amount or check if there's a deficit. Actually, the methodology says "pension_deficit" not total pension liability. The deficit is the underfunded portion. Without plan asset data, I'll use a conservative approach. Looking at the cash flow: "Adjustments For Increase Decrease In Employee Benefit Liabilities" = -17,574,000 EUR (meaning liability decreased, cash inflow or benefit). I'll include "Noncurrent Provisions For Employee Benefits" = 69,917,000 EUR as debt-like, but this may overstate if there are plan assets. **Hybrid debt:** No explicit hybrid debt mentioned. **Guarantees:** No explicit guarantee disclosures. **Other debt-like items:** - "Other Longterm Provisions" = 144,277,000 EUR - these could be debt-like if they represent constructive obligations - Deferred Tax Liabilities = 91,633,000 EUR - typically not treated as debt for S&P ratios For regulated utilities, S&P may also consider: - "Other Noncurrent Nonfinancial Liabilities" = 545,192,000 EUR - need to assess if debt-like Looking at typical S&P treatment for utilities, major debt-like items are: - Regulatory liabilities (if any) - Asset retirement obligations - Derivative liabilities Without more specific information, I'll focus on the main items. **Eligible cash:** - Cash And Cash Equivalents = 451,946,000 EUR - Current Financial Assets Excluding Other Current Financial Assets = 5,770,000 EUR S&P typically nets "available cash" against debt. For utilities, they may not fully net cash if it's needed for operations. However, standard practice is to subtract most cash. "Current Financial Assets Excluding Other Current Financial Assets" = 5,770,000 EUR (with 2,246,000 related party). This looks like short-term investments or deposits. Total liquid assets = 451,946,000 + 5,770,000 = 457,716,000 EUR But S&P may only subtract a portion. For investment-grade utilities, they might subtract most cash. I'll use 457,716,000 as eligible cash, but note that S&P sometimes uses a more nuanced approach. Actually, re-reading the methodology: "eligible_cash" - S&P typically subtracts cash and cash equivalents and very liquid short-term investments. Let me calculate Adjusted_Debt: = Reported debt + Leases (if not in debt) + Pension deficit + Other debt-like - Eligible cash Reported debt = 6,545,674,000 + Pension provision (conservative, as proxy for deficit) = 69,917,000 + Other long-term provisions (if debt-like) - I'll include a portion = 144,277,000 × 0.5 = 72,138,500 (rough estimate, or include full if clearly constructive obligation) Actually, let me be more conservative. For "Other Longterm Provisions" - these often include asset retirement obligations, restructuring, etc. Some are debt-like. I'll include 50% as a rough estimate = 72,138,500. - Eligible cash = 451,946,000 + 5,770,000 = 457,716,000 Adjusted_Debt = 6,545,674,000 + 69,917,000 + 72,138,500 - 457,716,000 = 6,230,013,500 EUR Hmm, this seems high. Let me reconsider. Actually, looking at typical S&P treatment, they might not include other long-term provisions as debt. Let me use a cleaner approach: Adjusted_Debt = Total Debt - Cash = 6,545,674,000 - 457,716,000 = 6,087,958,000 EUR With pension deficit added: = 6,087,958,000 + 69,917,000 = 6,157,875,000 EUR Let me verify total debt calculation: - Short Term Financial Liabilities Excluding Other Current Financial Liabilities: 142,437,000 - Other Current Financial Liabilities: 290,000 - Long Term Financial Liabilities Excluding Other Non Current Financial Liabilities: 6,402,913,000 - Other Noncurrent Financial Liabilities: 34,000 Total = 142,437,000 + 290,000 + 6,402,913,000 + 34,000 = 6,545,674,000 ✓ Wait, I need to check if there are current portion of long-term debt or bank overdrafts included. The "Short Term Financial Liabilities Excluding Other Current Financial Liabilities" likely includes the current portion of long-term debt plus short-term borrowings. Also, I should check if there are lease liabilities embedded. Looking at IFRS 16 implementation, lease liabilities are typically in "Long Term Financial Liabilities" or "Short Term Financial Liabilities." Given "Cash Outflow For Leases" = 27,865,000, and this is a financing outflow, there are lease obligations. But they're likely already in the debt figures. Let me also check "Other Noncurrent Financial Liabilities" = 34,000 - very small, likely not material. And "Other Current Financial Liabilities" = 290,000 - also small. Now for cash: "Cash And Cash Equivalents" = 451,946,000. Is this all "eligible"? S&P sometimes excludes restricted cash. Without information on restricted cash, I'll assume it's all eligible or use a haircut. Actually, for regulated utilities, S&P may consider that some cash is needed for working capital and not subtract it all. But standard practice for FFO/debt is to subtract available cash. Let me use Adjusted_Debt = 6,545,674,000 + 69,917,000 - 457,716,000 = 6,157,875,000 EUR Or with more conservative cash treatment (only subtract 75% of cash): = 6,545,674,000 + 69,917,000 - 343,287,000 = 6,272,304,000 EUR I think for this exercise, I'll use the standard approach and subtract all cash: Adjusted_Debt = 6,157,875,000 EUR But wait - I need to re-check. Is the pension provision already included in debt? No, it's in "Noncurrent Provisions" not financial liabilities. Actually, looking more carefully at the balance sheet structure: - Noncurrent Liabilities include: Long Term Financial Liabilities, Other Longterm Provisions, Noncurrent Provisions For Employee Benefits, Deferred Tax Liabilities, Other Noncurrent Financial Liabilities, Other Noncurrent Nonfinancial Liabilities The "Noncurrent Provisions For Employee Benefits" = 69,917,000 is separate from financial liabilities. For S&P, pension deficits are added to debt. So +69,917,000 is correct. ## Step 5: Calculate FFO / Adjusted_Debt FFO = 914,432,000 EUR Adjusted_Debt = 6,157,875,000 EUR Ratio = 914,432,000 / 6,157,875,000 = 0.1485 Let me recalculate with more precision: 914,432 / 6,157,875 = 0.148498... Rounded to 4 decimal places: 0.1485 But let me double-check my FFO calculation. I want to make sure I'm using the right approach. Alternative FFO calculation using cash flow statement: CFO = 548,169,000 + Cash Interest = 53,720,000 + Cash Taxes = 152,372,000 - Dividends Received = 1,372,000 (reclassify to investing) - Finance Income Received = 4,043,000 (reclassify to investing) = 748,846,000 This is "funds from operations before working capital changes" if we add back working capital uses. Then FFO = 748,846,000 - (-336,750,000)? No, working capital increased by 336,750,000 (negative sign in cash flow). Actually, the "Increase Decrease In Working Capital" = -336,750,000 means it was a use of cash (increase in working capital). So pre-working capital cash flow would be: 548,169,000 + 336,750,000 = 884,919,000? But this includes other items. Let me try: CFO before working capital and interest/taxes = ? = Net Income 436,126 + D&A 479,186 + Other non-cash items - Working capital - Cash Interest - Cash Taxes + Other operating Hmm, this is getting messy. Let me use the cleaner EBITDA approach. Actually, I realize I should check if S&P's FFO includes or excludes working capital changes. Standard S&P FFO excludes working capital changes - it's meant to be a sustainable measure. So FFO = EBITDA - Cash Interest - Cash Taxes is correct for the base measure. But wait - I need to verify my EBITDA. Is "Revenue And Operating Income" the same as total revenue? "Revenue And Operating Income" = 2,312,476,000 "Core Business Revenue" = 2,182,712,000 "Other Revenue And Income" = 129,764,000 Total = 2,182,712 + 129,764 = 2,312,476 ✓ And "Operating Expense" = 1,191,952,000 So Gross Profit (or rather, operating margin before D&A) = 2,312,476 - 1,191,952 = 1,120,524,000 Wait, this equals my EBITDA. Let me verify: Profit Loss From Operating Activities = 641,338,000 + Depreciation Amortisation = 479,186,000 = 1,120,524,000 And Revenue - Operating Expense = 2,312,476 - 1,191,952 = 1,120,524,000 So Operating Expense does NOT include D&A? That seems odd. Let me check. Actually, looking at typical income statement structure: Revenue - Cost of materials/services/etc (operating expenses) - D&A = EBIT But here: "Operating Expense" might be defined as all operating costs excluding D&A, or including D&A. Given that: Revenue And Operating Income (2,312,476) - Operating Expense (1,191,952) = 1,120,524 And EBIT = 641,338 And D&A = 479,186 So 1,120,524 - 479,186 = 641,338 = EBIT This means "Operating Expense" in this context is costs BEFORE D&A. So "Operating Expense" = raw materials + services + employee benefits + other costs = 1,191,952. Then EBITDA = Revenue - Operating Expense (as defined) = 2,312,476 - 1,191,952 = 1,120,524. ✓ Or EBITDA = EBIT + D&A = 641,338 + 479,186 = 1,120,524. ✓ Good, my EBITDA is correct. Now, one more check on FFO. Should I use accrual taxes or cash taxes? S&P FFO = EBITDA - Cash Interest - Cash Taxes. Cash taxes is correct. But what about the difference between Income Tax Expense (152,369,000) and Income Taxes Paid (152,372,000)? They're virtually identical (3,000 difference). And Finance Costs (accrual 61,367,000) vs Finance Costs Paid (53,720,000)? There's a 7,647,000 difference. For S&P FFO, should I use cash interest paid or accrual interest? Standard S&P FFO uses: EBITDA - Cash Interest - Cash Taxes. This is because FFO is meant to approximate cash generation available for debt service. So my FFO = 1,120,524 - 53,720 - 152,372 = 914,432 is correct. But wait - I want to verify if "Finance Costs Paid Classified As Operating Activities" truly represents all cash interest. In some IFRS statements, interest paid can be classified as operating or financing. Here it's in operating. Is there also interest paid in financing activities? Looking at the financing section, I don't see explicit interest payments. The "Cash Outflow For Leases" = 27,865,000 includes lease principal and interest. So total cash interest might be higher than 53,720,000. But for S&P purposes, we typically use the explicit cash interest paid, not lease interest. Actually, let me reconsider. The 53,720,000 is "Finance Costs Paid Classified As Operating Activities". Finance costs on P&L are 61,367,000. The difference could be: - Capitalized interest: part of finance costs capitalized to assets - Accrual timing differences - Lease interest included in lease payments For S&P FFO, we want the cash interest actually paid on debt, not lease interest. So 53,720,000 might be correct, or slightly low if some interest was paid in financing activities. Given data limitations, I'll proceed with 53,720,000. Now let me recalculate with potential adjustments: What about dividends received and finance income received? These are typically excluded from FFO as they're non-operating or non-sustainable. My FFO formula already excludes them (starting from EBITDA, not net income). Actually, let me verify: EBITDA is pre-interest, pre-tax, so dividends received and finance income are below the line. Good. One more item: "Share Of Profit Loss Of Associates And Joint Ventures Accounted For Using Equity Method" = 3,432,000. This is equity earnings, excluded from EBITDA (it's after operating profit). Good, not in EBITDA. And "Revenue From Dividends" = 48,000 - also below line. So my EBITDA and FFO calculations seem correct. Now for Adjusted_Debt, let me reconsider more carefully. Total financial liabilities: - Short-term: 142,437,000 + 290,000 = 142,727,000 - Long-term: 6,402,913,000 + 34,000 = 6,402,947,000 - Total: 6,545,674,000 But wait - is "Other Current Financial Liabilities" part of debt? It's 290,000, very small. And "Other Noncurrent Financial Liabilities" = 34,000, also very small. Are there any other debt-like items I missed? Looking at current liabilities: "Trade And Other Current Payables" = 1,197,117,000. These are trade payables, not debt. "Current Tax Liabilities" = 16,105,000 - not debt. "Other Current Nonfinancial Liabilities" = 30,072,000 - not typically debt. For noncurrent: "Other Longterm Provisions" = 144,277,000 - could include asset retirement obligations, restructuring, etc. "Other Noncurrent Nonfinancial Liabilities" = 545,192,000 - this is large. What does it include? In Italian utilities, this often includes: - Regulatory liabilities (deferred revenue or costs to be recovered) - Asset retirement obligations - Deferred income - Other provisions Without more detail, it's hard to classify. S&P might treat some as debt-like. Actually, for regulated utilities, S&P notes: "We deconsolidate securitized debt (and associated revenue and expense) that has been accorded specialized recovery provisions." And "We do not adjust GAAP earnings or balance-sheet figures to remove the effects of regulatory accounting." This suggests they generally accept GAAP/IFRS balance sheets for regulated utilities, with specific adjustments. Let me take a more standard approach: Adjusted_Debt = Total Debt - Cash + Pension deficit (if underfunded) Total Debt = 6,545,674,000 Cash = 451,946,000 + 5,770,000 = 457,716,000 Pension = 69,917,000 (treating full provision as deficit, conservative) Adjusted_Debt = 6,545,674,000 + 69,917,000 - 457,716,000 = 6,157,875,000 But I want to check if "Current Financial Assets Excluding Other Current Financial Assets" is truly "cash-like". It's 5,770,000 with 2,246,000 related party. This seems to be short-term deposits or investments. I'll include it as cash-like. Actually, re-reading: "Current Financial Assets Excluding Other Current Financial Assets" - this is a strange label. It excludes "Other Current Financial Assets" which is 17,455,000. So "Current Financial Assets Excluding Other Current Financial Assets" = 5,770,000 is the main current financial assets, and "Other Current Financial Assets" = 17,455,000 is additional. Total current financial assets = 5,770,000 + 17,455,000 = 23,225,000? But they're labeled as separate items. Actually, looking at the structure: - "Current Financial Assets Excluding Other Current Financial Assets" 2023-01-01: 5,770,000 - "Other Current Financial Assets" 2023-01-01: 17,455,000 These are separate line items. The "Other Current Financial Assets" might be derivatives, receivables from finance leases, etc. For cash netting, S&P typically uses "Cash And Cash Equivalents" and sometimes "Short-term investments" or "Marketable securities." I'll use: 451,946,000 + 5,770,000 = 457,716,000 as eligible cash. Or should I include "Other Current Financial Assets"? At 17,455,000, if these are liquid financial assets, maybe. But "Other" suggests they're not standard cash equivalents. Let me be conservative and use 457,716,000. Final calculation: FFO = 914,432,000 Adjusted_Debt = 6,157,875,000 Ratio = 0.1485 Let me also try a slightly different FFO to see sensitivity: If I used accrual interest instead of cash interest: FFO = 1,120,524 - 61,367 - 152,372 = 906,785,000 Ratio = 906,785 / 6,157,875 = 0.1473 Or if I used a different cash figure: If only "Cash And Cash Equivalents" is eligible (no short-term investments): Adjusted_Debt = 6,545,674 + 69,917 - 451,946 = 6,163,645 Ratio = 914,432 / 6,163,645 = 0.1484 Very similar. Let me also consider: should I add back the working capital change to FFO for a "normalized" measure? S&P sometimes does this for utilities with seasonal working capital. "Increase Decrease In Working Capital" = -336,750,000 (use of cash) If we normalize (add back the working capital use): Adjusted FFO = 914,432 + 336,750 = 1,251,182,000? No wait, that would be if we want pre-WC FFO. Actually, standard S&P FFO is already pre-working capital by using EBITDA - cash interest - cash taxes. The working capital changes are excluded by starting from EBITDA (accrual-based) rather than cash flow from operations. So my FFO is correct as is. One final check: are there any "nonrecurring" items to adjust in EBITDA? Looking at the P&L: - "Net Accrual To Provisions For Risk And Charges" = -1,797,000 (negative = release) - "Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss Trade Receivables" = -342,000 (reversal) - "Other Income Expense From Equity Investments" = 2,722,000 - this is below EBIT? Let me check. Actually, looking at the structure: Profit Loss From Operating Activities = 641,338 Then: Finance Income/Cost, Effect Of Valuation Using Equity Method, Revenue From Dividends, Other Income From Equity Investments, Share Of Profit Loss Of Associates... So "Other Income Expense From Equity Investments" = 2,722,000 is below operating profit. Not in EBITDA. And "Net Accrual To Provisions" and "Impairment Loss Reversal" are in operating expenses, so already in EBITDA. Are these nonrecurring? Provision releases and impairment reversals can be nonrecurring. But they're relatively small: - Provision release: 1,797,000 - Impairment reversal: 342,000 Total: 2,139,000 This is only 0.2% of EBITDA, immaterial. What about "Gains On Change In Fair Value Of Derivatives" = 1,049,000? This is likely in finance income/cost, below EBIT. And "Adjustments For Losses Gains On Disposal Of Noncurrent Assets" in cash flow = -25,357,000 (gain on disposal, negative adjustment). This is a gain, nonrecurring. But it's in investing activities or below EBIT. Actually, looking at cash flow from operations adjustments: "Adjustments For Losses Gains On Disposal Of Noncurrent Assets" = -25,357,000. This means there was a gain of 25,357,000 on disposal, deducted from net income in the indirect cash flow method. Where is this in P&L? It might be in "Other Revenue And Income" or "Other Expense By Nature". "Other Revenue And Income" = 129,764,000 including 17,863,000 related party. "Other Expense By Nature" = 25,440,000 including 155,131,000 related party? Wait, the related party is higher than total, that doesn't make sense. Actually "Other Expense By Nature" "Related Parties Member" 2022-01-01 - 2023-01-01: 155,131,000 EUR. But total is 25,440,000. This is odd - related party exceeds total? Wait, re-reading: "Other Expense By Nature" 2022-01-01 - 2023-01-01: 25440000 EUR "Other Expense By Nature" "Related Parties Member" 2022-01-01 - 2023-01-01: 155131000 EUR This seems like a data issue or the "Related Parties Member" is a different sign convention. Or perhaps related party is income not expense? Actually, looking at 2021-2022: "Other Expense By Nature" total: 25,783,000 "Related Parties Member": 99,170,000 The related party amount exceeds total, suggesting the related party figure might be absolute value or there's netting. This is confusing. I'll ignore this data anomaly and proceed. The gain on disposal of 25,357,000 - if this is in operating activities, it might need adjustment. But looking at the cash flow, it's an "adjustment" for gains/losses, meaning it was deducted from net income. This suggests the gain was included in net income but not in operating cash flow. Is this gain in EBIT? If it's from disposal of noncurrent assets, it's typically in non-operating income or below EBIT. But for some companies, it might be in operating income. Given "Profit Loss From Operating Activities" is 641,338, and then various items below, the gain is likely below operating profit or included in operating profit. Actually, looking at typical IFRS, gains on disposal of PPE can be in operating or non-operating. If in operating, S&P would adjust it out as nonrecurring. But 25,357,000 is about 2.3% of EBITDA. Not huge. I'll check if my EBITDA already includes it or not. Since I calculated EBITDA from EBIT + D&A, and EBIT is "Profit Loss From Operating Activities", if the gain is in operating activities, it's in EBIT and thus in EBITDA. To be conservative, I could adjust EBITDA down by 25,357,000 for this nonrecurring gain: Adjusted_EBITDA = 1,120,524 - 25,357 = 1,095,167,000 Then FFO = 1,095,167 - 53,720 - 152,372 = 889,075,000 Ratio = 889,075 / 6,157,875 = 0.1444 Or if the gain is after operating profit, no adjustment needed. Given uncertainty, and that the gain is relatively small, I'll use the unadjusted figure but note this potential conservatism. Actually, re-looking: the cash flow adjustment "Adjustments For Losses Gains On Disposal Of Noncurrent Assets" = -25,357,000. In the indirect method, gains are subtracted from net income. This means the gain was included in net income. But was it in operating profit? Looking at the line items below operating profit: "Finance Income", "Gains On Change In Fair Value Of Derivatives", etc. No explicit "Gains on disposal" line. It might be in "Other Revenue And Income" or netted in operating expenses. Given "Other Revenue And Income" increased from 64,769 to 129,764 (roughly doubled), and includes 17,863 related party, there might be some nonrecurring items. But without explicit identification, I'll keep my base calculation. Final numbers: - FFO = 914,432,000 EUR - Adjusted_Debt = 6,157,875,000 EUR - Ratio = 0.1485 Let me do one more verification of debt. The total liabilities are 8,639,987,000. Equity is 2,390,570,000. Total = 11,030,557,000 which matches assets. Financial liabilities portion: - Current: Short Term Financial Liabilities (142,437) + Other Current Financial Liabilities (290) = 142,727 - Noncurrent: Long Term Financial Liabilities (6,402,913) + Other Noncurrent Financial Liabilities (34) = 6,402,947 Total financial debt = 6,545,674 This is about 76% of total liabilities. The rest is payables, provisions, taxes, deferred taxes, etc. For a utility, this leverage seems reasonable. One more check: should I include "Other Current Financial Assets" = 17,455,000 in cash? Looking at the label, it's "Other" which suggests less liquid. And there's a related party portion of 0. I'll exclude it from eligible cash. And "Noncurrent Financial Assets" = 22,945,000 with 612,000 related party. These are noncurrent, so not cash-like. "Current Tax Assets" = 8,703,000 - not cash-like. So eligible cash = 451,946 + 5,770 = 457,716. ✓ Final calculation: FFO / Adjusted_Debt = 914,432 / 6,157,875 = 0.148498... ≈ 0.1485 0.1485