I'll work through this step-by-step for VEOLIA ENVIRONNEMENT. ## Step 1: Identify the Relevant Industry VEOLIA ENVIRONNEMENT is a water and environmental services company. Based on the provided methodologies, this falls under **Regulated Utilities** (specifically the "Water" subsector, and also "Multi-utilities"). The company provides essential infrastructure services (water, waste, energy) with significant regulated/concession-based activities. ## Step 2: Estimate Adjusted_EBITDA First, I need to reconstruct EBITDA from the available data. From the income statement items for 2022 (2022-01-01 to 2023-01-01): - Revenue: 42,885,300,000 EUR - Cost of Sales: 35,739,800,000 EUR - Selling Expense: 954,200,000 EUR - General and Administrative Expense: 3,215,800,000 EUR - Other Operating Income Expense: -769,200,000 EUR (this is a net expense) Operating Income Before Share Of Net Income Loss Of Equity Accounted Entities: 2,206,300,000 EUR Let me verify: Revenue - Cost of Sales - Selling Expense - G&A + Other Operating Income Expense = 42,885,300,000 - 35,739,800,000 - 954,200,000 - 3,215,800,000 - 769,200,000 = 2,206,300,000 ✓ Now, to get to EBITDA, I need to add back depreciation and amortization: - Operating Depreciation Amortization Provisions And Impairment Losses: 3,178,600,000 EUR So, Reported EBITDA = Operating Income Before Share Of Net Income + Operating Depreciation Amortization = 2,206,300,000 + 3,178,600,000 = 5,384,900,000 EUR Wait - let me recalculate more carefully. "Operating Income Before Share Of Net Income Loss Of Equity Accounted Entities" is 2,206,300,000. This is EBIT before equity accounted earnings. Actually, let me use: EBITDA = Operating Income Before Share Of Net Income + D&A = 2,206,300,000 + 3,178,600,000 = 5,384,900,000 EUR But I need to check if this includes other operating income/expense properly. The "Other Operating Income Expense" of -769,200,000 is already included in the operating income figure. For **Adjusted_EBITDA**, per S&P guidelines for regulated utilities: - Need to consider lease adjustments (IFRS 16 already capitalizes leases, so we may need to adjust) - Nonrecurring items - Joint venture proportional EBITDA From the data, I can identify: - Gains Losses On Disposal Of Operating Assets: -299,000,000 EUR (this is a gain, so subtract from EBITDA to normalize) - Share Of Net Income Loss Of Core Equity Accounted Entities: 127,000,000 EUR (this is equity income, already excluded from operating income before equity) Actually, let me look more carefully. The operating income of 2,206,300,000 is BEFORE share of equity accounted entities. The "Resultat Operationnel Apres Quote Part" (Operating income after equity share) is 2,333,300,000. For EBITDA reconstruction, I should use: EBITDA = Revenue - Cost of Sales - Selling - G&A + Other Operating Income + D&A (but need to be careful about what's in "Other Operating Income Expense") Actually, simpler approach: EBITDA = Operating Income Before Share Of Net Income + D&A = 2,206,300,000 + 3,178,600,000 = 5,384,900,000 EUR But we need Adjusted EBITDA. Per S&P methodology: - Add back nonrecurring losses, subtract nonrecurring gains - The gain on disposal of operating assets of 299,000,000 EUR should be subtracted as nonrecurring Also for regulated utilities, we need to consider: - Pension adjustments: Not explicitly provided, but we have "Other Comprehensive Income Before Tax Gains Losses On Remeasurements Of Defined Benefit Plans" of 125,200,000 EUR. This is an OCI item, not necessarily an EBITDA adjustment. For joint ventures: S&P may want proportional EBITDA from JVs. We have: - Investments In Joint Ventures: 1,197,900,000 EUR (end), 1,238,500,000 (start) - Share Of Net Income Loss Of Core Joint Ventures: 56,500,000 EUR - Share Of Net Income Loss Of Core Associates: 70,500,000 EUR For proportional consolidation, we'd need EBITDA of JVs, but we don't have full financials. S&P typically adds proportional EBITDA for significant JVs. However, with limited data, I'll note this but may not fully adjust. For leases: IFRS 16 is already applied. S&P typically adds back lease expense to EBITDA for comparability, or treats lease debt separately. Looking at the debt calculation approach, I'll handle leases in debt. Let me also check for any "nonrecurring" or special items in the operating results. The large increase in assets and goodwill (from 6.2B to 11.6B) suggests the Suez acquisition in 2022, which would create integration costs and one-time items. Given data limitations, let me use a pragmatic approach: **Adjusted_EBITDA = Reported EBITDA + lease adjustment (if operating lease expense not in D&A) + nonrecurring losses - nonrecurring gains ± JV adjustments** For IFRS 16, D&A includes depreciation on right-of-use assets. The "Operating Depreciation Amortization Provisions And Impairment Losses" of 3,178,600,000 likely includes this. Actually, let me recalculate more carefully using the cash flow approach: Cash Flows From Used In Operations Before Changes In Working Capital: 4,804,300,000 EUR This is essentially: Net Income + D&A + other non-cash items + interest + taxes - working capital changes... wait, no, "before changes in working capital" means: OCF before WC = Net Income + D&A - gains/losses on disposal + other non-cash + interest(1-t) + ... Actually, looking at the components in the cash flow statement: - Profit Loss: 997,600,000 - Operating Depreciation Amortization: 3,178,600,000 - Gains Losses On Disposal Of Operating Assets: -299,000,000 - Plus Ou Moins Values De Cessions Dactifs Financiers: -370,000,000 - Share Of Net Income Loss Of Joint Ventures: -56,500,000 - Adjustments For Undistributed Profits Of Associates: -70,500,000 - Adjustments For Dividend Income: 4,100,000 - Net Finance Costs Adjustments: 632,700,000 - Adjustments For Income Tax Expense: 419,800,000 - Other Adjustments: 282,300,000 Sum: 997,600,000 + 3,178,600,000 - 299,000,000 - 370,000,000 - 56,500,000 - 70,500,000 + 4,100,000 + 632,700,000 + 419,800,000 + 282,300,000 = 4,719,100,000 But reported is 4,804,300,000. Difference of ~85M, possibly from discontinued ops or other items. For EBITDA, I can use: OCF before WC + Cash Interest + Cash Taxes - Working capital impact... no that's circular. Better: EBITDA = EBIT + D&A = (Operating Income After Equity Share - Equity Income) + D&A + some adjustments Let me use: EBIT = Operating Income Before Share Of Net Income = 2,206,300,000 Add: Financial Amortization? No, that's financing. Add: Operating D&A = 3,178,600,000 EBITDA = 2,206,300,000 + 3,178,600,000 = 5,384,900,000 But this is too low for a company with 42.9B revenue. Let me check: EBITDA margin would be 12.6%, which seems reasonable for a utility with pass-through costs. Actually, I need to be more careful. "Cost Of Sales" for utilities often includes pass-through energy costs. The "Other Operating Income Expense" of -769,200,000 might include various items. For **Adjusted EBITDA per S&P**: - Start with reported or reconstructed EBITDA - For regulated utilities, S&P focuses on the economics and cash flow generation - They don't typically adjust for regulatory accounting differences under IFRS Key adjustments I should make: 1. **Nonrecurring items**: The gain on disposal of 299,000,000 should be excluded (subtract) 2. **JV proportional EBITDA**: For significant equity investments, add proportional share For JVs: Share of net income is 56,500,000 (JVs) + 70,500,000 (associates) = 127,000,000. To get proportional EBITDA, I'd need their D&A. Rough estimate: if JVs have similar margins, proportional EBITDA might be ~2-3x equity income. But without data, I'll use a conservative approach. Let me also consider if there are acquisition-related costs from the Suez merger that should be added back. Given the Suez acquisition (goodwill increased from 6.2B to 11.6B), there are likely significant one-time integration costs. These would be nonrecurring losses to add back. However, I don't have explicit breakouts. Let me use what I have. **Adjusted_EBITDA estimate:** - Base EBITDA: 5,384,900,000 - Less: Gain on disposal of operating assets: -299,000,000 - Plus: Estimated nonrecurring integration costs (unknown, but likely material) Actually, looking at "Other Adjustments To Reconcile Profit Loss" of 282,300,000 - this could include various non-cash or nonrecurring items. Let me try a different approach using the cash flow statement more directly, and also look at what S&P typically does for utilities. For **FFO calculation** (Step 3), S&P defines: FFO = Funds From Operations = Net Income from continuing operations + D&A + deferred taxes + other non-cash items - gains on asset sales + or - other adjustments Or more commonly for corporates: FFO = EBIT + D&A - Cash Interest - Cash Taxes (approximation) Actually, the standard S&P formula given is: FFO = Adjusted_EBITDA - cash_interest - cash_taxes But also: FFO = Net Income + D&A + deferred tax changes + other non-cash - working capital changes... no, FFO is before working capital. Let me use the direct S&P formula: FFO = Adjusted_EBITDA - Cash Interest - Cash Taxes From the cash flow statement: - Interest Paid: 637,700,000 - Interest On Operating Assets: 78,500,000 (this is interest received, not paid) - Interest On Lease: 52,500,000 (part of lease payments) Total cash interest paid (approx): 637,700,000 + 52,500,000 = 690,200,000? Wait, "Interest Paid" of 637,700,000 likely includes lease interest. Let me check: under IFRS 16, lease interest is part of financing cash flows. The "Interest On Lease" of 52,500,000 might be a disclosure of the lease interest component. Actually, looking more carefully at cash flow items: - Interest Paid: 637,700,000 (this is total interest paid) - Interest On Operating Assets: 78,500,000 (this is interest received on operating financial assets) - Interest On Lease: 52,500,000 (this might be the lease interest expense, which is part of the 637,700,000) For cash interest in FFO calculation, S&P typically uses: gross interest paid before capitalization, or interest expense adjusted for accruals. From P&L: Net Finance Costs: 632,700,000 (this is interest expense net of interest income) Other Finance Income Cost: -204,600,000 (more financing costs) Total finance costs: 632,700,000 + 204,600,000 = 837,300,000? Or is Other Finance Income Cost already in Net Finance Costs? "Net Finance Costs" is likely the net interest expense. "Other Finance Income Cost" of -204,600,000 is additional. Total financial expense = 632,700,000 + 204,600,000 = 837,300,000 But cash interest paid is 637,700,000. The difference could be capitalized interest, accruals, or other items. For S&P FFO, we need **cash interest paid**, which is approximately 637,700,000 (from financing activities) or we can use interest expense adjusted. Actually, looking at cash flow from operations: it includes "Net Finance Costs Adjustments" of 632,700,000 added back. This suggests the 632,700,000 is the net finance cost in P&L, added back because it's a financing item not operating. For **Cash Taxes**: Income Tax Expense Continuing Operations is 419,800,000. But cash taxes paid from operating activities is 557,400,000. For FFO = Adjusted_EBITDA - Cash Interest - Cash Taxes: - Cash Interest: ~637,700,000 (or higher if we include lease interest separately) - Cash Taxes: 557,400,000 But wait - the formula FFO = Adjusted_EBITDA - Cash Interest - Cash Taxes assumes these are the cash outflows from the EBITDA. Let me recalculate Adjusted_EBITDA more carefully. From the cash flow reconciliation starting from Profit Loss: Profit Loss: 997,600,000 + Operating D&A: 3,178,600,000 - Gain on disposal operating: -299,000,000 - Gain on disposal financial: -370,000,000 (this is financial assets, might be in investing) - Share of JV income: -56,500,000 - Share of associate income: -70,500,000 + Dividend income adjustment: 4,100,000 (this is likely removing dividend income) + Net finance costs: 632,700,000 + Income tax expense: 419,800,000 + Other adjustments: 282,300,000 = 4,719,100,000 (approx, my calc shows this but reported is 4,804,300,000) Difference is about 85M, possibly from discontinued operations or other. The 4,804,300,000 is "Cash Flows From Used In Operations Before Changes In Working Capital" - this is essentially **FFO before working capital and before some adjustments**, or more precisely, it's the starting point for working capital adjustments. Actually, this 4,804,300,000 is very close to what S&P calls "FFO" in some contexts, but let me verify. S&P FFO definition: Funds from operations = Net income + depreciation & amortization + deferred income taxes + other non-cash items - gains on asset sales + or - other adjustments Or: FFO = Cash flow from operations before working capital changes - dividends from equity investments (maybe) + adjustments Let me use the standard: FFO = Net Income + D&A + Deferred Tax changes - Gains on asset sales + Other non-cash From the data: - Net Income (continuing): 1,076,200,000 - Total Net Income: 997,600,000 (includes discontinued ops loss of 78,600,000) - D&A: 3,178,600,000 (operating) + 14,800,000 (financial) = 3,193,400,000 - Deferred tax: Change in deferred tax assets/liabilities. DTA: 2,050,800,000 - 1,059,200,000 = 991,600,000 increase. DTL: 2,640,100,000 - 1,196,400,000 = 1,443,700,000 increase. Net deferred tax liability increase = 452,100,000. This is a non-cash charge that reduces net income, so add back. - Gains on disposal: 299,000,000 (operating) + 370,000,000 (financial? but this might be in investing) Wait, the "Plus Ou Moins Values De Cessions Dactifs Financiers" of -370,000,000 is likely a gain on sale of financial assets (Suez shares?). This is in investing activities. For FFO, we typically exclude gains/losses on asset sales (both operating and financial if they're non-operating). Let me recalculate using the EBITDA approach: Adjusted_EBITDA = EBIT + D&A + lease adjustments + nonrecurring - nonrecurring gains EBIT from continuing operations (before equity income): Operating Income Before Share: 2,206,300,000 Less: Equity income (core): 127,000,000 Plus: Financial expenses (to get to pre-tax): 632,700,000 + 204,600,000 = 837,300,000? Actually, "Resultat Operationnel Apres Quote Part" (Operating income after equity share) is 2,333,300,000. This includes equity income. Then: Profit Before Tax = 2,333,300,000 - 632,700,000 (net finance costs) - 204,600,000 (other finance) = 1,496,000,000 ✓ matches! So EBIT (as S&P might define, operating) = 2,333,300,000 + 632,700,000 = 2,966,000,000? No wait, that's not right either. Let me think more carefully. "Operating Income Before Share Of Net Income" = 2,206,300,000. This is EBIT before equity income and before financing costs. Then "Resultat Operationnel Apres Quote Part" = 2,333,300,000 = 2,206,300,000 + 127,000,000 (equity income) Then Profit Before Tax = 2,333,300,000 - 632,700,000 (net finance costs) - 204,600,000? But 2,333,300,000 - 632,700,000 = 1,700,600,000, not 1,496,000,000. So "Other Finance Income Cost" of -204,600,000 must be already included or there's something else. Actually, re-reading: "Net Finance Costs" is 632,700,000 (negative, so expense). "Other Finance Income Cost" is -204,600,000 (also negative, so expense). Total finance expense = 837,300,000. 2,333,300,000 - 837,300,000 = 1,496,000,000 ✓ matches Profit Before Tax! So EBIT (S&P definition, before equity and financing) = 2,206,300,000 Or EBIT including equity income = 2,333,300,000 For EBITDA, add D&A to the operating measure: EBITDA = 2,206,300,000 + 3,178,600,000 = 5,384,900,000 (before equity) Or including proportional JVs: need to add proportional EBITDA of JVs For S&P, they often use "EBITDA including equity income" or proportional consolidation. Let me use: EBITDA = 2,333,300,000 + 3,178,600,000 + D&A of JVs (unknown) Actually, for regulated utilities, S&P may use different approaches. Let me focus on what we can calculate robustly. **Adjusted_EBITDA calculation:** Base: 5,384,900,000 (EBIT + D&A, before equity income) Adjustments: - Nonrecurring gains on disposal: -299,000,000 (subtract gain) - For Suez acquisition-related costs: likely included in "Other Operating Income Expense" or other items. Without explicit data, I'll note this as a limitation. - For JVs: Add proportional EBITDA. Share of net income is 127,000,000. If JVs have similar D&A/revenue ratios, proportional EBITDA might be roughly 2-3x. But let's use a different approach - look at dividends received from investing activities: 128,600,000, which suggests cash distributions from equity investments. Actually, for S&P methodology, when they say "joint_venture_proportional_EBITDA", they mean adding the company's share of JV EBITDA (not just equity income). If we assume JVs have similar EBITDA margins to Veolia's core operations (~12.5%), and equity income / EBITDA ratio is roughly net margin (~3%), then proportional EBITDA ≈ 127,000,000 × (12.5%/3%) ≈ 530,000,000. But this is speculative. Given data limitations, I'll use a conservative approach and not adjust for JVs, or use equity income as a proxy. Let me try yet another approach: Use the cash flow from operations before working capital as a check. Cash Flow From Operations Before WC = 4,804,300,000 = Net Income + D&A - gains + equity income adjustments + finance costs + tax expense + other = 997,600,000 + 3,178,600,000 - 299,000,000 - 370,000,000 - 56,500,000 - 70,500,000 + 4,100,000 + 632,700,000 + 419,800,000 + 282,300,000 = 4,719,100,000 (my calc) Hmm, difference of 85,200,000. Possibly from discontinued operations: "Cash Flows From Used In Operating Activities Discontinued Operations" is 43,800,000. But that's after the main calculation. Actually, looking at "Cash Flows From Used In Operating Activities Continuing Operations": 4,104,400,000. Then add discontinued: 43,800,000 = 4,148,200,000 total operating cash flow. But "Cash Flows From Used In Operations Before Changes In Working Capital" is 4,804,300,000 for... which period? It says 2022-01-01 to 2023-01-01. Wait, I need to re-read. "Cash Flows From Used In Operations Before Changes In Working Capital" 2022-01-01 - 2023-01-01: 4,804,300,000. Then "Change In Operating Working Capital Requirements": -48,000,000. Then "Change In Concession Working Capital Requirements": 190,500,000. Then taxes paid: 557,400,000. Then continuing operations: 4,104,400,000. Then discontinued: 43,800,000. Total: 4,148,200,000. But 4,804,300,000 - 48,000,000 + 190,500,000 - 557,400,000 = 4,389,400,000, not 4,104,400,000. There are more adjustments. This is getting complex. Let me use a simplified but robust approach for the S&P ratio. ## Simplified Approach Using Direct S&P Formulas For **Adjusted_EBITDA**: I'll use: Revenue - Cash Operating Costs + D&A, adjusted for nonrecurring Or more directly: Adjusted_EBITDA = EBIT + D&A + Lease Expense (if operating leases not capitalized) + nonrecurring losses - nonrecurring gains With IFRS 16, leases are capitalized, so D&A includes ROU asset depreciation. The "Operating Depreciation Amortization" of 3,178,600,000 includes this. For the lease adjustment in EBITDA: S&P sometimes adds back the lease depreciation and subtracts the lease payment, or uses a "lease-adjusted EBITDA" with operating lease expense added back. But with IFRS 16, this is already in the numbers. Let me use a practical approach: - Start with 5,384,900,000 as base EBITDA - Adjust for nonrecurring: The gain on disposal of 299,000,000 is clearly nonrecurring, subtract it - For Suez integration costs: These would be in operating expenses. Without explicit data, I'll assume "Other Operating Income Expense" includes some, but it's net -769,200,000 (expense). Actually, looking at year-over-year: Other Operating Income Expense was -496,900,000 in 2021, and -769,200,000 in 2022. The increase of ~272M could include integration costs. But I can't reliably separate this. Let me use reported numbers with minimal adjustments. **Adjusted_EBITDA = 5,384,900,000 - 299,000,000 (gain on disposal) = 5,085,900,000** Or, if we want to include proportional JVs: add ~200M-400M estimated proportional EBITDA. Let's use 300M as rough estimate: 5,385,900,000. I'll use **5,385,900,000** (rounding, with minimal JV adjustment) or about **5,400,000,000** as rough Adjusted_EBITDA. Actually, let me be more precise and use 5,385,900,000 with the gain adjustment only, or if we include JVs more fully. For **FFO**: FFO = Adjusted_EBITDA - Cash Interest - Cash Taxes Cash Interest: From cash flow, "Interest Paid" = 637,700,000. But this might not include capitalized interest or lease interest. From P&L: Total finance costs = 632,700,000 + 204,600,000 = 837,300,000. But cash paid is 637,700,000. The difference could be accruals, capitalized interest, or non-cash items. For S&P, "cash interest" typically means interest actually paid, or interest expense adjusted for accruals. I'll use 637,700,000 as base, but note that "Interest On Lease" of 52,500,000 might be part of this or additional. Looking at financing activities: "Change In Current Lease Debt Ifrs16" is 552,900,000 (repayment). "Repayment Of New Noncurrent Lease Debt" is 130,400,000. Total lease debt repayment: 683,300,000. This includes principal + interest. The "Interest On Lease" of 52,500,000 disclosed separately suggests total lease payments include this interest plus principal. For cash interest, I'll use: 637,700,000 (total interest paid per financing) + check if lease interest is separate. Actually, in cash flow statement, interest paid can be in operating or financing. Here "Interest Paid" of 637,700,000 is likely the total. "Interest On Operating Assets" of 78,500,000 is received (income). "Interest On Lease" of 52,500,000 might be a disclosure of lease interest component. Let me use **Cash Interest = 637,700,000 + 52,500,000 = 690,200,000** if lease interest is separate, or just **637,700,000** if included. Given the disclosure format, I'll use **637,700,000** as total interest paid, assuming lease interest is included in "Interest Paid" or in the lease debt repayment. Cash Taxes: "Income Taxes Paid Refund Classified As Operating Activities" = 557,400,000. This is clearly cash taxes. So **FFO = 5,385,900,000 - 637,700,000 - 557,400,000 = 4,190,800,000** Or if Adjusted_EBITDA is higher with JVs: ~4,500,000,000. Let me cross-check with the "Cash Flows From Used In Operations Before Changes In Working Capital" of 4,804,300,000. This is higher than my FFO because it includes working capital and other items, or rather it's a different measure. Actually, S&P FFO is typically lower than CFO before WC because FFO excludes working capital changes but also makes other adjustments. Wait, no - FFO is usually similar to CFO before WC for many companies. Let me recalculate: If FFO ≈ 4,190,800,000, but CFO before WC is 4,804,300,000, the difference is ~613,500,000. This could be from: - Dividends received in operating activities? No, those are in investing. - Other items in the reconciliation. Actually, looking at the reconciliation to CFO before WC: it includes "Net Finance Costs Adjustments" of 632,700,000 and "Adjustments For Income Tax Expense" of 419,800,000. These are added back to get to a pre-interest, pre-tax measure... wait, that's not right. Let me re-read the cash flow statement structure. It starts from Profit Loss, adds back D&A, subtracts gains, adjusts for equity income, adds back finance costs and tax expense, etc. This is the standard indirect method to get to operating cash flow before working capital. So: 997,600,000 (Net Income) + 3,178,600,000 (D&A) - 299,000,000 (gain) - 370,000,000 (financial gain) - 56,500,000 (JV income) - 70,500,000 (associate income) + 4,100,000 (dividend income remove?) + 632,700,000 (finance costs) + 419,800,000 (tax expense) + 282,300,000 (other) = 4,719,100,000 But reported is 4,804,300,000. Difference of 85,200,000. Could be from discontinued operations or rounding. For **S&P FFO**, a common definition is: FFO = Net Income + Depreciation & Amortization + Deferred Income Taxes + Other Non-Cash Items - Gains on Asset Sales +/− Other Adjustments Or: FFO = Funds from operations = Cash flow from operations before changes in working capital - dividends received from equity investments +/− other adjustments Let me use: FFO ≈ 4,190,800,000 from the EBITDA approach, or ≈ 4,700,000,000-4,800,000,000 from the cash flow approach. Given the ambiguity, let me use a more conservative FFO estimate based on direct S&P formula, and also check against reported "Cash Flows From Used In Operations Before Changes In Working Capital". Actually, I realize the 4,804,300,000 might already be essentially FFO for S&P purposes, or close to it. Let me adjust: - Subtract dividends received from equity investments (these are in investing, not operating, so no adjustment needed for CFO before WC) - The 4,804,300,000 includes add-back of finance costs and tax expense, so it's before interest and taxes in a sense, but then subtracts actual cash interest and taxes... no wait, it's a reconciliation to operating cash flow. Let me think of this as: CFO before WC = Net Income + Non-cash items - Non-operating items = 997,600,000 + 3,178,600,000 (D&A) - 299,000,000 (gain) - 370,000,000 (fin gain) - 56,500,000 - 70,500,000 + 4,100,000 + 632,700,000 + 419,800,000 + 282,300,000 = 4,719,100,000 (my calc) Hmm, but reported is 4,804,300,000. The difference might be that "Other Adjustments To Reconcile Profit Loss" of 282,300,000 is not the full story, or there's additional items. Let me just use **FFO ≈ 4,700,000,000** as a reasonable estimate, or more precisely, let me use the EBITDA-based calculation. Actually, for regulated utilities, S&P in their rating reports often use "FFO" as reported by the company or calculated as: FFO = Net Income + D&A + Deferred Taxes - Working Capital Changes (sometimes with adjustments) Let me use a cleaner approach. From the cash flow data: - Cash Flows From Used In Operating Activities Continuing Operations: 4,104,400,000 - This is after working capital and taxes paid - Add back: Change In Operating Working Capital Requirements: -48,000,000 (negative means cash outflow, so add to get before WC) - Add back: Change In Concession Working Capital Requirements: 190,500,000 - Add back: Income Taxes Paid: 557,400,000 - Add back: Interest Paid? No, interest is not in operating cash flow for IFRS (it's in financing) Wait, under IFRS, interest paid can be in operating or financing. Here, "Interest Paid" of 637,700,000 is in financing activities. So operating cash flow excludes interest paid. So CFO before WC (but after interest? No, interest is not in operating) = 4,104,400,000 - 43,800,000 (discontinued) + 557,400,000 (taxes) - 190,500,000 (concession WC) + 48,000,000 (operating WC) = 4,475,500,000? This is getting messy with the exact cash flow classification. Let me use the reported "Cash Flows From Used In Operations Before Changes In Working Capital" of 4,804,300,000 as the best proxy for FFO before working capital, and make adjustments. For S&P FFO from this base: - Subtract: Cash interest paid (since it's a financing outflow, not in operating) - actually, since interest paid is in financing, the 4,804,300,000 is already after interest in the P&L but before cash payment... no, the reconciliation starts from net income which is after interest expense. Actually, the reconciliation adds back "Net Finance Costs Adjustments" of 632,700,000, which is the P&L finance cost. So the 4,804,300,000 is before finance costs in a cash sense (since they're added back), but then actual cash interest paid is in financing activities. For S&P FFO, we want: Funds available to service debt before working capital changes. FFO = EBIT + D&A - Cash Taxes (approximately), or more precisely: FFO = Net Income + D&A + Deferred Taxes + Other Non-Cash - Gains + Finance Costs (added back) - Cash Interest + ... Standard S&P: FFO = Cash flow from operations before changes in working capital + after-tax interest expense - cash interest paid + other adjustments Or simpler: FFO = EBITDA - Cash Interest - Cash Taxes ± Other Let me use: FFO = 5,385,900,000 (Adj EBITDA) - 637,700,000 (Cash Interest) - 557,400,000 (Cash Taxes) = 4,190,800,000 But wait, the 5,385,900,000 is before equity income. If we use EBITDA that includes equity income (as S&P sometimes does for proportional consolidation), it would be higher. Let me try: EBITDA including equity income = 2,333,300,000 + 3,178,600,000 = 5,511,900,000 Less gain on disposal: -299,000,000 = 5,212,900,000 FFO = 5,212,900,000 - 637,700,000 - 557,400,000 = 4,017,800,000 Or if we use the lower EBITDA (before equity income): FFO = 4,190,800,000 I'll use **FFO ≈ 4,200,000,000** as a reasonable middle estimate. Actually, let me cross-check with another approach. The "Cash Flows From Used In Operations Before Changes In Working Capital" of 4,804,300,000 is essentially: Net Income + D&A - Gains + Equity adjustments + Finance costs + Tax expense + Other = 997,600,000 + 3,178,600,000 - 299,000,000 - 370,000,000 - 56,500,000 - 70,500,000 + 4,100,000 + 632,700,000 + 419,800,000 + 282,300,000 + other items to reach 4,804,300,000 If we define FFO as this amount minus after-tax interest expense plus cash interest minus cash taxes plus tax expense... this is circular. Simpler S&P approach: FFO = Cash Flow From Operations + Cash Interest + Cash Taxes - Working Capital Changes - Dividends Received (if in CFO) - Other Non-Operating Items in CFO For Veolia: - Cash Flow From Operating Activities: 4,148,200,000 (total, including discontinued) - Add: Cash Interest Paid: 637,700,000 (financing) - Add: Cash Taxes Paid: 557,400,000 (operating, but already in CFO... wait, taxes paid reduce CFO) Actually: CFO = Net Income + D&A - WC changes - Cash Taxes (if tax expense not already... no, under indirect method, tax expense is added back and cash taxes paid is the outflow). Let me just use: FFO ≈ CFO + Cash Interest + Increase in WC - Decrease in WC - Dividends from investments ± other = 4,148,200,000 + 637,700,000 + (-48,000,000 + 190,500,000)? No, the WC changes are already in CFO. CFO before WC changes is 4,804,300,000. Then WC changes: -48,000,000 (operating) + 190,500,000 (concession) = 142,500,000. Then taxes paid: -557,400,000. Then continuing CFO: 4,804,300,000 + 142,500,000 - 557,400,000 = 4,389,400,000. But reported is 4,104,400,000. Difference of 285M. Hmm, there are other adjustments. "Cash Flows From Used In Operating Activities Continuing Operations" is 4,104,400,000, and total with discontinued is 4,148,200,000. For FFO, I'll use **4,700,000,000** as a rounded estimate based on CFO before WC of 4,804,300,000, adjusted for items that S&P excludes (like dividends received, if any, in the operating section). Actually, looking more carefully: "Dividends Received Classified As Investing Activities" is 128,600,000. So dividends are in investing, not operating. Good. "Dividends Received" in operating would be 4,100,000 adjustment (removing dividend income from net income). Let me use **FFO = 4,800,000,000** approximately, or more precisely 4,700,000,000-4,800,000,000. I'll settle on **FFO = 4,700,000,000** as a conservative estimate. ## Step 4: Estimate Adjusted_Debt Adjusted_Debt = Reported_Debt + Leases + Pension_Deficit + Guarantees + Hybrid_Debt_Portion + Other_Debt_Like_Items - Eligible_Cash From balance sheet 2022 (end of year, i.e., 2023-01-01): - Noncurrent Financial Liabilities Excluding Concession Liabilities: 19,692,100,000 - Current Financial Liabilities Excluding Concession Liabilities: 6,521,400,000 - Noncurrent Concession Liabilities: 1,680,500,000 - Current Concession Liabilities: 243,200,000 - Noncurrent Lease Liabilities: 1,656,200,000 - Current Lease Liabilities: 496,500,000 Total reported debt-like items: 19,692,100,000 + 6,521,400,000 + 1,680,500,000 + 243,200,000 + 1,656,200,000 + 496,500,000 = 30,289,900,000 But we need to be careful about what's in "financial liabilities excluding concession liabilities" - this likely includes bonds, loans, etc. For S&P Adjusted Debt: - Reported debt: 19,692,100,000 + 6,521,400,000 = 26,213,500,000 (financial liabilities) - Plus: Concession liabilities? S&P treats these as debt-like or operating, depending on nature. For utilities with concessions, these are often debt-like. - Plus: Lease liabilities: 1,656,200,000 + 496,500,000 = 2,152,700,000 - Plus: Pension deficit - need to check For pension deficit: We have "Other Comprehensive Income Before Tax Gains Losses On Remeasurements Of Defined Benefit Plans" of 125,200,000, but this is a flow. For balance sheet, we'd need net pension position. Not explicitly provided. "Noncurrent Provisions" of 2,844,400,000 might include pension provisions. Actually, looking at the equity section, there's no explicit pension reserve. The "Other Comprehensive Income" items include pension remeasurements. For S&P, pension deficit = liability - asset for defined benefit plans. Without explicit data, I'll assume minimal or use provisions as proxy. - Plus: Hybrid debt portion: "Titres Super Subordonnes ADuree Indeterminee" (deeply subordinated securities) = 3,496,300,000. These are hybrid instruments. S&P treats 50% or 100% as equity or debt depending on features. For "super subordinated" perpetual securities, S&P typically treats 50% as debt. So hybrid debt portion: 3,496,300,000 × 50% = 1,748,150,000 - Plus: Other debt-like items: "Actifs Financiers Operationnels" vs liabilities? Or other? - Less: Eligible cash: "Cash And Cash Equivalents" = 9,012,200,000. But need to subtract "Bank Overdrafts And Other Cash Position Items" = 213,600,000. Net cash = 8,798,600,000. For S&P, eligible cash is typically 100% of unrestricted cash, or sometimes 75% if there are restrictions. I'll use 100% for simplicity, or maybe 75% to be conservative. Let me calculate Adjusted_Debt: Base debt (financial liabilities): 26,213,500,000 Plus concession liabilities (debt-like for utilities): 1,680,500,000 + 243,200,000 = 1,923,700,000 Plus lease liabilities: 2,152,700,000 Plus hybrid portion (50%): 1,748,150,000 Less cash: 9,012,200,000 (or 8,798,600,000 net) Adjusted_Debt = 26,213,500,000 + 1,923,700,000 + 2,152,700,000 + 1,748,150,000 - 8,798,600,000 = 23,239,450,000 Or if we don't include concession liabilities as debt (since they might be operating): Adjusted_Debt = 26,213,500,000 + 2,152,700,000 + 1,748,150,000 - 8,798,600,000 = 21,315,750,000 For regulated utilities, S&P typically includes concession liabilities as debt if they're debt-like (i.e., contractual payments required). Given the nature of Veolia's water concessions, these are likely debt-like. Let me also check if there are other debt-like items: - "Other Current Financial Assets" and "Other Noncurrent Financial Assets" - these are assets, not liabilities - Derivatives: assets of 634,400,000 + 127,800,000 = 762,200,000; liabilities of 883,400,000 + 720,200,000 = 1,603,600,000. Net derivative liability = 841,400,000. S&P may include this in debt. Adding net derivative liability: 841,400,000 Adjusted_Debt with derivatives = 23,239,450,000 + 841,400,000 = 24,080,850,000 Or ~24,000,000,000. Let me also consider "Nonconsolidated Suez Shares" of 3,721,000,000 in 2022 start - this was likely sold/acquired. By 2023, "Nonconsolidated Other Securities" is 112,500,000. The change relates to the Suez acquisition. For guarantees and other debt-like items: Not explicitly provided. I'll use **Adjusted_Debt ≈ 24,000,000,000** or more precisely around **23,000,000,000 - 25,000,000,000**. Let me be more precise with my calculation: Reported debt (financial liabilities): - Noncurrent Financial Liabilities Excluding Concession Liabilities: 19,692,100,000 - Current Financial Liabilities Excluding Concession Liabilities: 6,521,400,000 - Total: 26,213,500,000 Concession liabilities: - Noncurrent: 1,680,500,000 - Current: 243,200,000 - Total: 1,923,700,000 Lease liabilities: - Noncurrent: 1,656,200,000 - Current: 496,500,000 - Total: 2,152,700,000 Hybrid securities (50% equity treatment by S&P, so 50% debt): - 3,496,300,000 × 50% = 1,748,150,000 Net derivatives (liability): - Noncurrent derivative liabilities: 720,200,000 - Current derivative liabilities: 883,400,000 - Noncurrent derivative assets: 127,800,000 - Current derivative assets: 634,400,000 - Net liability: 1,603,600,000 - 762,200,000 = 841,400,000 Cash and equivalents: - 9,012,200,000 - Less bank overdrafts: 213,600,000 - Net cash: 8,798,600,000 Adjusted_Debt = 26,213,500,000 + 1,923,700,000 + 2,152,700,000 + 1,748,150,000 + 841,400,000 - 8,798,600,000 = 24,080,850,000 I'll use **24,080,850,000** or rounded **24,081,000,000**. ## Step 5: Calculate FFO / Adjusted_Debt Using: - FFO = 4,190,800,000 (from EBITDA - cash interest - cash taxes, conservative) - Or FFO = 4,700,000,000 to 4,800,000,000 (from cash flow based) Let me also try the cash flow based FFO more carefully. From "Cash Flows From Used In Operations Before Changes In Working Capital" = 4,804,300,000: - This includes add-back of finance costs (632,700,000) and tax expense (419,800,000) - To get to S&P FFO, we need: subtract cash interest paid, subtract cash taxes paid, add back any non-operating items Actually, S&P FFO from this base: FFO = CFO before WC - after-tax interest expense + cash interest paid - tax expense + cash taxes paid ± other = 4,804,300,000 - 632,700,000 + 637,700,000 - 419,800,000 + 557,400,000 ± other = 4,804,300,000 + 5,000,000 + 137,600,000 ± other = 4,946,900,000 ± other Hmm, this gives higher FFO. But this doesn't seem right because we're adding back finance costs and taxes then adjusting. Actually, let me think again. CFO before WC starts from Net Income. Net Income already includes: - Interest expense (632,700,000 + 204,600,000 = 837,300,000 total finance costs, but net is 632,700,000) - Tax expense (419,800,000) The reconciliation adds back these non-cash or financing/fiscal items to get to operating cash before WC. So: CFO before WC = Net Income + D&A - gains + equity adjustments + finance costs (added back) + tax expense (added back) + other For S&P FFO, we want: Funds from operations available to all capital providers (debt and equity). FFO = Net Income + D&A + Deferred Taxes + Other Non-Cash - Gains on asset sales + Interest Expense (since FFO is pre-interest) Or: FFO = EBIT + D&A - Cash Taxes ± other = 2,333,300,000 (EBIT including equity) + 3,178,600,000 (D&A) - 557,400,000 (cash taxes) + adjustments = 4,954,500,000 + adjustments Less gain on disposal: -299,000,000 = 4,655,500,000 Less other finance costs (already in EBIT? No, EBIT is before finance): wait, EBIT is 2,333,300,000 which includes equity income and is after operating items but before finance. Actually, "Resultat Operationnel Apres Quote Part" = 2,333,300,000 is operating income after equity share, before finance costs. This is essentially EBIT with equity income. So EBIT + D&A = 2,333,300,000 + 3,178,600,000 = 5,511,900,000 Less cash taxes: 557,400,000 = 4,954,500,000 Less gain on disposal (nonrecurring): 299,000,000 = 4,655,500,000 Or if we use EBIT before equity income (2,206,300,000): = 2,206,300,000 + 3,178,600,000 - 557,400,000 = 4,827,500,000 Less gain: 299,000,000 = 4,528,500,000 For S&P, they typically want proportional EBITDA and FFO, so including JVs. Let me use 4,655,500,000 as base FFO before hybrid adjustments and other items. Less: Hybrid coupon (since hybrid is part equity, part debt): "Coupons On Deeply Subordinated Securities" = 88,300,000. Since we treat 50% as debt, the coupon on the equity portion might be subtracted like a dividend. But this is complex. For simplicity, I'll use **FFO ≈ 4,650,000,000** as a reasonable estimate. With Adjusted_Debt = 24,080,850,000: FFO / Adjusted_Debt = 4,650,000,000 / 24,080,850,000 = 0.1931 Or with FFO = 4,190,800,000 (conservative EBITDA approach): = 4,190,800,000 / 24,080,850,000 = 0.1740 Or with FFO = 4,800,000,000 (cash flow based): = 4,800,000,000 / 24,080,850,000 = 0.1993 Given the range, let me refine my estimates. More precise FFO calculation using S&P standard approach for utilities: From the cash flow statement, "Cash Flows From Used In Operations Before Changes In Working Capital" = 4,804,300,000 Adjustments to get to S&P FFO: - This amount includes add-back of net finance costs (632,700,000) and tax expense (419,800,000) - It excludes actual cash interest paid (637,700,000) and cash taxes paid (557,400,000) - The difference between finance cost expensed and cash interest paid is an accrual adjustment For S&P FFO, we typically use: FFO = CFO before WC + Cash Interest - Interest Expense (added back in reconciliation) + Cash Taxes - Tax Expense (added back) - Dividends Received ± other Actually, simpler: The 4,804,300,000 is already a comprehensive measure of operating funds before WC changes. We need to: - Subtract: Cash interest paid (since it's a financing outflow, not in operating) - but wait, it's already excluded from CFO - The 4,804,300,000 is funds from operations in a broad sense, before working capital, interest, and taxes are paid in cash Hmm, I think the 4,804,300,000 is essentially: Net Income + D&A - gains + equity adjustments + finance costs + tax expense + other = funds generated before working capital changes, but after non-cash adjustments This is close to S&P's "CFO before changes in working capital" which they sometimes use as FFO or close to it. For strict S&P FFO, we want to add back interest expense and subtract cash interest, and handle taxes similarly: FFO = 4,804,300,000 - 632,700,000 (finance costs added back, so remove) + 637,700,000 (cash interest) - 419,800,000 (tax expense added back) + 557,400,000 (cash taxes) - 128,600,000 (dividends received, if in operating? No, they're in investing) = 4,804,300,000 + 5,000,000 + 137,600,000 = 4,946,900,000 But this seems too high. Let me check: if we remove the added-back finance costs and taxes, we're going to a pre-interest, pre-tax measure, then subtracting cash versions. This should give FFO available to service debt. Actually, I realize the issue. The 4,804,300,000 includes adding back finance costs and tax expense, which are P&L items. But in cash flow, we want to know actual cash generated. Since interest paid is in financing activities (not operating), and taxes paid are in operating, the 4,804,300,000 is before cash tax payments but after tax expense accruals. Let me recalculate from scratch using the direct S&P formula: **FFO = Adjusted_EBITDA - Cash Interest - Cash Taxes** Adjusted_EBITDA = 5,212,900,000 (including equity income, excl. gain on disposal) Cash Interest = 637,700,000 (from financing activities, total interest paid) Cash Taxes = 557,400,000 (from operating activities) FFO = 5,212,900,000 - 637,700,000 - 557,400,000 = 4,017,800,000 But wait, is the 5,212,900,000 correct? Let me verify: EBITDA = Operating Income After Equity Share + D&A = 2,333,300,000 + 3,178,600,000 = 5,511,900,000 Less gain on disposal: 299,000,000 Adjusted_EBITDA = 5,212,900,000 However, this includes equity income but not proportional EBITDA. For S&P, they might want to add proportional EBITDA and subtract equity income, or just use the equity income as is. If we use EBITDA before equity income: = 2,206,300,000 + 3,178,600,000 = 5,384,900,000 Less gain: 299,000,000 = 5,085,900,000 FFO = 5,085,900,000 - 637,700,000 - 557,400,000 = 3,890,800,000 The difference is whether we include equity income in the base. For FFO to debt, S&P typically wants FFO available to service debt at the consolidated level, which includes dividends from JVs but not their full EBITDA. Given Veolia's significant JVs, and that equity income is part of operating income, I'll use the approach that includes equity income but then FFO is after receiving those dividends. Actually, for FFO calculation, S&P typically: - Starts from Net Income (which includes equity income) - Adds D&A - Adds back other non-cash items - Subtracts gains - This gives FFO From Net Income: 997,600,000 + D&A: 3,178,600,000 + Financial Amortization: 14,800,000 (though this might be in finance costs) - Gain on disposal operating: 299,000,000 - Gain on disposal financial: 370,000,000 (if considered non-operating) - Equity income (to remove, since we want FFO at consolidated level before JV dividends): 127,000,000? Or keep it? Standard approach: Keep equity income in Net Income, since FFO includes actual dividends received or equity income as non-cash to be adjusted. Actually, looking at the reconciliation: Net Income 997,600,000 + D&A 3,178,600,000 - Gain on disposal operating 299,000,000 - Gain on disposal financial 370,000,000 - Share of JV income 56,500,000 (remove equity income) - Share of associate income 70,500,000 (remove equity income) + Dividend income adjustment 4,100,000 (add back dividends received, or remove dividend income) + Net finance costs 632,700,000 + Tax expense 419,800,000 + Other adjustments 282,300,000 = 4,719,100,000 (my calc, vs 4,804,300,000 reported) The difference of 85,200,000 might be from discontinued operations or other items not detailed. For S&P FFO, from this base: - Start from 4,804,300,000 (CFO before WC) - Adjust for items that S&P treats differently S&P FFO typically excludes: - Dividends received from equity investments (if included in operating) - but here they're in investing - Gains on asset sales (already excluded in the reconciliation) - Working capital changes (not yet applied) And FFO is before: - Cash interest paid - Cash taxes paid So FFO = 4,804,300,000 + adjustments for S&P methodology = approximately 4,700,000,000 to 4,900,000,000 Given the complexity, let me use a pragmatic approach and calculate with my best estimates, then provide a range. **Final Calculation:** I'll use: - **FFO = 4,500,000,000** (conservative, between the EBITDA-based and cash flow-based estimates) - Or more precisely, let me use **4,650,000,000** from the EBIT+D&A-cash taxes approach Actually, let me try to be more accurate. I'll use the direct cash flow information and S&P methodology more carefully. From Veolia's annual report data, I can construct: EBITDA = 5,384,900,000 (before equity) or 5,511,900,000 (after equity) Adjusted for gain on disposal: -299,000,000 For S&P, they also adjust for leases if operating leases were expensed. But with IFRS 16, leases are capitalized. However, S&P may still make a "lease adjustment" to EBITDA to reflect the operating lease expense for comparability. The "Change In Current Lease Debt Ifrs16" is 552,900,000 and "Repayment Of New Noncurrent Lease Debt" is 130,400,000. Total lease debt repayment: 683,300,000. This is principal repayment. Lease interest: 52,500,000 (disclosed) So total lease payments: 683,300,000 + 52,500,000 = 735,800,000? Or is the 683,300,000 total including interest? Actually, "Change In Current Lease Debt Ifrs16" of 552,900,000 is likely the principal repayment of current portion. "Repayment Of New Noncurrent Lease Debt" of 130,400,000 is principal repayment of noncurrent portion. Total principal: 683,300,000. Plus interest 52,500,000 = total lease payments 735,800,000. For S&P lease adjustment to EBITDA: They might add back ROU depreciation (part of D&A) and subtract estimated lease payment. But this is complex and usually done for pre-IFRS 16 comparability. Given IFRS 16 is applied, I'll use the reported EBITDA with D&A including ROU depreciation. For **Adjusted_Debt**, I calculated 24,080,850,000. Let me verify this with another approach. Total liabilities: Noncurrent Liabilities: 29,233,500,000 Current Liabilities: 29,203,700,000 Total Liabilities: 58,437,200,000 Less: Operating liabilities (payables, provisions, deferred taxes, derivatives, etc.): - Operating Payables: 19,475,200,000 - Current Provisions: 1,015,300,000 - Noncurrent Provisions: 2,844,400,000 - Deferred Tax Liabilities: 2,640,100,000 - Current Derivative Liabilities: 883,400,000 - Noncurrent Derivative Liabilities: 720,200,000 - Concession liabilities (might be debt-like): 1,923,700,000 - Held for sale liabilities: 355,100,000 This gets messy. Let me stick with my direct debt calculation. **Refined Adjusted_Debt:** - Financial liabilities (noncurrent + current, excl. concession): 26,213,500,000 - Concession liabilities: 1,923,700,000 (debt-like for utilities) - Lease liabilities: 2,152,700,000 (already in financial liabilities? Or separate?) Wait, I need to check if "Noncurrent Financial Liabilities Excluding Concession Liabilities" includes lease liabilities. Under IFRS 16, lease liabilities are financial liabilities. So "Financial Liabilities Excluding Concession Liabilities" likely INCLUDES lease liabilities. Let me re-read: "Noncurrent Financial Liabilities Excluding Concession Liabilities" - this excludes concession liabilities, but likely includes all other financial liabilities: bonds, loans, AND lease liabilities. If so, then my adding lease liabilities separately would be double-counting! Let me recalculate: - Noncurrent Financial Liabilities Excluding Concession Liabilities: 19,692,100,000 (includes leases, bonds, loans) - Current Financial Liabilities Excluding Concession Liabilities: 6,521,400,000 (includes current portion of leases, short-term debt) Total financial liabilities: 26,213,500,000 (already includes leases) Plus concession liabilities: 1,923,700,000 Plus hybrid portion (50%): 1,748,150,000 Plus net derivative liability: 841,400,000 Less cash: 8,798,600,000 Adjusted_Debt = 26,213,500,000 + 1,923,700,000 + 1,748,150,000 + 841,400,000 - 8,798,600,000 = 21,928,150,000 This is lower than before. Let me verify if leases are indeed in financial liabilities. Under IFRS 16, lease liabilities are presented as financial liabilities. The line "Noncurrent Lease Liabilities" of 1,656,200,000 and "Current Lease Liabilities" of 496,500,000 are shown separately, suggesting they might be broken out from the total financial liabilities, or included in them. Looking at the balance sheet structure: Noncurrent Liabilities total: 29,233,500,000 Components listed: - Noncurrent Provisions: 2,844,400,000 - Noncurrent Financial Liabilities Excluding Concession Liabilities: 19,692,100,000 - Noncurrent Lease Liabilities: 1,656,200,000 - Noncurrent Derivative Financial Liabilities: 720,200,000 - Noncurrent Concession Liabilities: 1,680,500,000 - Deferred Tax Liabilities: 2,640,100,000 Sum: 2,844,400,000 + 19,692,100,000 + 1,656,200,000 + 720,200,000 + 1,680,500,000 + 2,640,100,000 = 29,233,500,000 ✓ matches! So "Noncurrent Financial Liabilities Excluding Concession Liabilities" of 19,692,100,000 does NOT include lease liabilities, concession liabilities, derivatives, or deferred taxes. It includes bonds, loans, and other financial liabilities. Similarly for current: - Operating Payables: 19,475,200,000 - Current Concession Liabilities: 243,200,000 - Current Provisions: 1,015,300,000 - Current Financial Liabilities Excluding Concession Liabilities: 6,521,400,000 - Current Lease Liabilities: 496,500,000 - Current Derivative Financial Liabilities: 883,400,000 - Bank Overdrafts: 213,600,000 - Held for sale liabilities: 355,100,000 Sum: 19,475,200,000 + 243,200,000 + 1,015,300,000 + 6,521,400,000 + 496,500,000 + 883,400,000 + 213,600,000 + 355,100,000 = 29,203,700,000 ✓ matches! So my original calculation was correct: financial liabilities excluding concession (26,213,500,000) + concession liabilities (1,923,700,000) + lease liabilities (2,152,700,000) + hybrid portion + derivatives - cash. Adjusted_Debt = 26,213,500,000 + 1,923,700,000 + 2,152,700,000 + 1,748,150,000 + 841,400,000 - 8,798,600,000 = 24,080,850,000 Good, this is correct. Now for FFO, let me use a more refined approach. From the cash flow reconciliation, I can calculate FFO as: FFO = Net Income + D&A + Deferred Tax changes + Other Non-Cash - Gains on Asset Sales + Interest Expense - Cash Interest + ... Actually, let me use the standard S&P formula more directly: **FFO = Cash Flow From Operations Before Changes In Working Capital - Cash Interest Paid + Interest Expense - Cash Taxes Paid + Tax Expense ± Other Adjustments** Or simpler for this case, since we have detailed data: FFO = EBIT + D&A - Cash Taxes (with adjustments for nonrecurring and equity income) Let me define: - EBIT (including equity income) = 2,333,300,000 - EBIT (before equity income) = 2,206,300,000 For S&P FFO, they typically use the measure that includes proportional consolidation or equity income as appropriate. For debt servicing, FFO at the parent level includes dividends from JVs, not full EBITDA. Using EBIT before equity income + D&A - Cash Taxes: = 2,206,300,000 + 3,178,600,000 - 557,400,000 = 4,827,500,000 Less gain on disposal (nonrecurring): 299,000,000 FFO = 4,528,500,000 Or with equity income: = 2,333,300,000 + 3,178,600,000 - 557,400,000 - 299,000,000 = 4,655,500,000 The difference is 127,000,000 (equity income). For FFO, if we assume JVs distribute roughly their earnings (or we use equity income as proxy for cash distributions), then including it is appropriate. I'll use **FFO = 4,550,000,000** as a middle ground, or more precisely **4,528,500,000** (before equity income) to **4,655,500,000** (with equity income). Let me also consider the "Other Adjustments To Reconcile Profit Loss" of 282,300,000. This includes various non-cash or nonrecurring items. Some might be added back to FFO, others might be nonrecurring losses to add back. If we assume 282,300,000 is largely non-cash/nonrecurring added back in the cash flow statement, it's already in my EBITDA/FFO calculation. For conservative FFO, I'll use: **4,500,000,000** For moderate FFO: **4,650,000,000** Let me check what FFO/Debt ratio would be reasonable for Veolia. As a utility with significant regulated activities, S&P typically expects FFO/Debt around 15-25%. Given the Suez acquisition in 2022, leverage increased, so FFO/Debt might be lower. With debt of ~24B and FFO of ~4.5-4.7B, ratio is 18.75% to 19.6%. Let me use more precise numbers: **FFO = 4,600,000,000** (rounded from 4,655,500,000 with equity income, or 4,528,500,000 without) I'll use **4,592,000,000** as precise: (4,528,500,000 + 4,655,500,000) / 2 = 4,592,000,000 Or let me use the cash flow based approach more precisely: From "Cash Flows From Used In Operations Before Changes In Working Capital" = 4,804,300,000 This is: Net Income + D&A - Gains - Equity Income + Dividend Income Adjustment + Finance Costs + Tax Expense + Other Adjustments For S&P FFO, we want to: - Remove gains on asset sales (already done in the reconciliation, but we want to exclude from FFO) - The 4,804,300,000 already has -299,000,000 and -370,000,000 for gains - It has -56,500,000 and -70,500,000 for equity income (removed) - It has +632,700,000 for finance costs (added back) - It has +419,800,000 for tax expense (added back) To get FFO, we need to subtract cash interest and cash taxes: FFO = 4,804,300,000 - 632,700,000 (remove finance costs add-back) + 0 (cash interest not in operating) - 419,800,000 (remove tax expense add-back) + 0 (cash taxes not in this measure) + adjustments Hmm, this doesn't work cleanly because the 4,804,300,000 is constructed differently. Let me try: FFO = 4,804,300,000 - 419,800,000 (tax expense was added back, but we want FFO before tax, so subtract it? No, FFO is after tax expense but before cash tax paid). Actually, I think the cleanest is: FFO = EBITDA - Cash Interest - Cash Taxes = 5,212,900,000 - 637,700,000 - 557,400,000 = 4,017,800,000 But this seems low. Let me add back the financial asset gain of 370,000,000 if it's non-operating: = 4,017,800,000 + 370,000,000 = 4,387,800,000 And if equity income should be included via dividends rather than full amount, adjust by 127,000,000 - actual dividends. Dividends received in investing: 128,600,000. So roughly equivalent. I'll use **FFO = 4,400,000,000** as a reasonable estimate. With Adjusted_Debt = 24,080,850,000: FFO / Adjusted_Debt = 4,400,000,000 / 24,080,850,000 = 0.1827 Or with FFO = 4,600,000,000: 0.1910 Or with FFO = 4,800,000,000: 0.1993 Given the uncertainty, let me use **FFO = 4,600,000,000** and **Adjusted_Debt = 24,080,850,000** for a ratio of **0.1910**. But let me also consider if Adjusted_Debt should be different. S&P sometimes uses "average debt" rather than year-end. With the Suez acquisition, average debt might be lower than year-end. Also, S&P might treat hybrid securities differently. "Titres Super Subordonnes ADuree Indeterminee" are deeply subordinated perpetual securities. S&P typically treats 50% as equity for these. I used 50% debt treatment. If 100% equity treatment: Adjusted_Debt = 24,080,850,000 - 1,748,150,000 = 22,332,700,000 FFO/Debt = 4,600,000,000 / 22,332,700,000 = 0.2060 If 0% equity treatment (all debt): Adjusted_Debt = 24,080,850,000 + 1,748,150,000 = 25,829,000,000 FFO/Debt = 4,600,000,000 / 25,829,000,000 = 0.1781 The 50% treatment is standard for these hybrid securities, so 0.1910 is reasonable. Let me also verify with reported net debt. From the balance sheet: Cash: 9,012,200,000 Bank overdrafts: 213,600,000 Net cash: 8,798,600,000 Gross debt (financial + concession + lease): 26,213,500,000 + 1,923,700,000 + 2,152,700,000 = 30,289,900,000 Net debt: 30,289,900,000 - 8,798,600,000 = 21,491,300,000 My Adjusted_Debt of 24,080,850,000 includes hybrid portion (1,748,150,000) and net derivatives (841,400,000), so: 21,491,300,000 + 1,748,150,000 + 841,400,000 = 24,080,850,000 ✓ This seems correct. For FFO, let me do one more check using the "Cash Flows From Used In Operations Before Changes In Working Capital" and adjusting: 4,804,300,000 - This includes +632,700,000 finance costs and +419,800,000 tax expense - For FFO, we want to subtract cash interest (637,700,000) and cash taxes (557,400,000) - But the 4,804,300,000 is before actual cash payments of interest and taxes (since interest is in financing, taxes are shown separately in operating) Actually, the 4,804,300,000 is a subtotal before working capital and before tax payments. The tax payments of 557,400,000 are subtracted later to get to 4,104,400,000 continuing operations CFO. So 4,804,300,000 - 557,400,000 = 4,246,900,000 before working capital but after cash taxes? No, the 557,400,000 is subtracted in the cash flow statement to get to 4,104,400,000. Wait, let me re-read: "Cash Flows From Used In Operations Before Changes In Working Capital" 4,804,300,000 Then "Change In Operating Working Capital Requirements" -48,000,000 Then "Change In Concession Working Capital Requirements" 190,500,000 Then "Income Taxes Paid Refund Classified As Operating Activities" 557,400,000 (this is an outflow, so subtracts) Then "Cash Flows From Used In Operating Activities Continuing Operations" 4,104,400,000 Check: 4,804,300,000 - 48,000,000 + 190,500,000 - 557,400,000 = 4,389,400,000, not 4,104,400,000. There's a 285,000,000 difference. There must be other adjustments not shown in the summary. For FFO, I'll use: 4,804,300,000 - 557,400,000 (cash taxes, since FFO is after cash taxes) - adjustments for interest + other items. Actually, S&P FFO is typically: Cash flow from operations before working capital changes - cash interest - cash taxes + interest expense + tax expense... no that's wrong. Let me use the simplest reliable approach: **FFO = Net Income + D&A + Deferred Tax changes - Gains on asset sales + Other non-cash items** Net Income: 997,600,000 + D&A: 3,178,600,000 + 14,800,000 = 3,193,400,000 + Deferred tax increase in liability (non-cash charge): 452,100,000 (from DTL increase - DTA increase, or net deferred tax liability change) - Gain on disposal: 299,000,000 - Gain on financial assets: 370,000,000 (if non-operating) + Other adjustments: 282,300,000 FFO = 997,600,000 + 3,193,400,000 + 452,100,000 - 299,000,000 - 370,000,000 + 282,300,000 = 4,256,400,000 Hmm, this is lower. The 452,100,000 deferred tax might not be correct - I calculated DTL increase 1,443,700,000 - DTA increase 991,600,000 = 452,100,000 net DTL increase. But this is a balance sheet change, not necessarily the deferred tax expense. Actually, the tax expense in P&L is 419,800,000, and cash taxes paid is 557,400,000. The difference 137,600,000 could be deferred tax benefit or working capital tax adjustments. For FFO, we add back deferred tax expense (non-cash), not the balance sheet change. Without explicit deferred tax expense breakdown, I'll skip this. Using simpler FFO = 4,256,400,000 from above, or with equity income adjustments. If I include equity income (don't subtract it, since it's part of operations): Add back: 56,500,000 + 70,500,000 = 127,000,000 FFO = 4,383,400,000 This is close to my 4,400,000,000 estimate. I'll use **FFO = 4,400,000,000** as final estimate. **Final Calculation:** FFO / Adjusted_Debt = 4,400,000,000 / 24,080,850,000 = 0.1827 Or with more precise FFO = 4,383,400,000: 0.1820 Or with FFO = 4,600,000,000: 0.1910 Given all my analysis, I'll use **0.1900** as a rounded estimate, or more precisely **0.1910** with moderate FFO, or **0.1827** with conservative FFO. Let me settle on **0.1900** as a reasonable midpoint, or calculate more precisely with my best numbers: FFO = 4,528,500,000 (EBIT before equity + D&A - cash taxes - gain) Adjusted_Debt = 24,080,850,000 Ratio = 4,528,500,000 / 24,080,850,000 = 0.1881 Or with EBIT including equity: = 4,655,500,000 / 24,080,850,000 = 0.1933 Average: 0.1907 I'll round to **0.1907** or **0.1910** with four decimal places. Actually, let me recalculate with slightly different assumption for hybrid treatment. If S&P treats the deeply subordinated securities as 50% equity (standard), my calculation is correct. But if they treat more as equity due to features, debt would be lower. Also, let me verify the FFO one more time. The "Cash Flows From Used In Operations Before Changes In Working Capital" of 4,804,300,000 is very close to what some analysts use as FFO. If I simply subtract cash taxes (557,400,000) from this, I get 4,246,900,000. But cash interest is not in this measure (it's in financing activities). Actually, for utility analysis, S&P sometimes uses "CFO before working capital" as a proxy for FFO, or makes minimal adjustments. If we use 4,804,300,000 as base and subtract only non-recurring or non-operating items: 4,804,300,000 - 299,000,000 (gain on disposal, if considered non-operating) - 370,000,000 (gain on financial assets, non-operating) = 4,135,300,000 This is lower. But the 370,000,000 gain on financial assets might be from selling Suez shares, which is non-recurring. For conservative FFO: 4,135,300,000 Ratio: 4,135,300,000 / 24,080,850,000 = 0.1717 For moderate FFO (including some adjustments): 4,400,000,000 to 4,600,000,000 Ratio: 0.1827 to 0.1910 Given the wide range, let me use my most defensible calculation: **FFO = Adjusted_EBITDA - Cash Interest - Cash Taxes** Adjusted_EBITDA = EBIT (including equity income) + D&A - gain on disposal = 2,333,300,000 + 3,178,600,000 - 299,000,000 = 5,212,900,000 FFO = 5,212,900,000 - 637,700,000 - 557,400,000 = 4,017,800,000 Wait, this is lower because I didn't add back the financial asset gain or other items. Let me check if EBIT includes the financial asset gain - no, "Plus Ou Moins Values De Cessions Dactifs Financiers" is likely below operating income, in financing or exceptional. Actually, the gain on financial assets of 370,000,000 is likely in "Other Finance Income Cost" or below operating income. Let me check: "Other Finance Income Cost" is -204,600,000 (expense). The 370,000,000 gain might be part of this or separate. Looking at the cash flow reconciliation, the 370,000,000 is subtracted from net income to get to CFO before WC. This suggests it's included in net income but non-operating. So my Adjusted_EBITDA of 5,212,900,000 doesn't include this gain (since it's below operating income). For FFO, we want to exclude non-operating gains, so no adjustment needed in EBITDA - it's already excluded. But wait, if the gain is in net income but not in operating income, then EBIT/EBITDA doesn't include it. So my EBITDA is correct. Then FFO = 5,212,900,000 - 637,700,000 - 557,400,000 = 4,017,800,000 seems low compared to cash flow based measures. The discrepancy is because the 5,212,900,000 EBITDA includes equity income (127,000,000) which is non-cash, but FFO should include cash dividends from JVs, not equity income. If JVs distributed 128,600,000 in dividends (per investing activities), this is close to equity income. Actually, for FFO calculation, S&P typically: - Starts from Net Income (which includes equity income of 127,000,000) - Adds D&A (3,178,600,000) - Subtracts equity income (127,000,000) if using proportional EBITDA, or keeps it if using dividends - Adds dividends received from equity investments (128,600,000 in investing activities) This is getting too detailed. Let me use a pragmatic final estimate. **Final pragmatic estimate:** FFO ≈ 4,600,000,000 (based on cash flow from operations before WC, adjusted for non-recurring and financing items) Adjusted_Debt ≈ 24,080,850,000 FFO / Adjusted_Debt = 4,600,000,000 / 24,080,850,000 = 0.1910 Or using slightly different FFO = 4,500,000,000: = 4,500,000,000 / 24,080,850,000 = 0.1869 I'll use **0.1900** as my final answer, with more precise calculation: With FFO = 4,592,000,000 (average of my estimates): = 4,592,000,000 / 24,080,850,000 = 0.1907 Rounded to four decimal places: **0.1907** Or with FFO = 4,655,500,000 (EBITDA with equity income approach): = 4,655,500,000 / 24,080,850,000 = 0.1933 Given the uncertainty range of 0.18 to 0.20, I'll provide **0.1907** as a middle estimate, or **0.1933** if using the higher FFO estimate. Actually, re-reading my calculations more carefully, let me use the most defensible precise numbers: Adjusted_EBITDA = 5,212,900,000 (EBIT with equity income + D&A - gain on disposal) Less: Cash Interest = 637,700,000 Less: Cash Taxes = 557,400,000 FFO = 4,017,800,000 But this seems to exclude dividends from JVs which are cash. If we add dividends received (128,600,000 from investing, but these are from financial assets not JVs? No, "Dividends Received Classified As Investing Activities" includes all dividends from investments). For JVs specifically: "Adjustments For Dividend Income" of 4,100,000 is in operating, and "Dividends Received Classified As Investing Activities" of 128,600,000 is in investing. The 128,600,000 likely includes dividends from JVs and other investments. If we add 128,600,000 to FFO: 4,017,800,000 + 128,600,000 = 4,146,400,000 Ratio = 4,146,400,000 / 24,080,850,000 = 0.1722 This is lower. But S&P FFO typically excludes dividend income from investments if they're non-operating. For core JVs in utilities, dividends might be considered operating. It's complex. Given all this analysis, I'll use my estimate of **0.1900** as the final answer, representing approximately 19% FFO to debt ratio, which is reasonable for a utility post-major acquisition. More precisely, I'll calculate with: FFO = 4,600,000,000 Adjusted_Debt = 24,080,850,000 Ratio = 0.1910 0.1910