To estimate the S&P-adjusted FFO-to-debt ratio for Electricité de France (EDF) for the fiscal year ended December 31, 2022, we follow the workflow outlined in the prompt. ### Step 1: Identify the Relevant Industry EDF is a major French electric utility company. Its primary activities include electricity generation (nuclear, hydro, renewable, thermal), transmission, distribution, and supply. * **Regulated Utilities:** EDF operates significant regulated networks (distribution in France) and benefits from regulated tariffs for its nuclear generation (ARENH mechanism and regulated access). The provided text for "Regulated Utilities" describes companies that provide essential infrastructure, are shielded from competition, and subject to comprehensive regulation. EDF fits this description, particularly regarding its distribution and historical nuclear assets which are subject to state-defined regulatory frameworks. * **Unregulated Power and Gas:** EDF also has significant unregulated generation and supply activities, especially in competitive markets. However, the core of its credit profile is often assessed under the Regulated Utilities framework due to the stability provided by its regulated asset base and the state's role. The prompt provides specific methodologies for "Regulated Utilities" and "Unregulated Power and Gas". Given EDF's status as a national incumbent with significant regulated operations (distribution and regulated nuclear output), the **Regulated Utilities** methodology is the most appropriate primary classification, although elements of unregulated risk exist. The "Regulated Utilities" section notes that for integrated electric utilities, purchased power contracts may require debt-like adjustments, and seasonal working capital adjustments may apply. However, a key distinction in S&P methodology for utilities is the calculation of FFO. For regulated utilities, FFO is typically derived from EBITDA minus cash interest and cash taxes. We will proceed with the **Regulated Utilities** industry classification. ### Step 2: Estimate Adjusted EBITDA First, we need to determine the reported EBITDA. The provided facts include "Operating Profit Before Depreciation And Amortisation" (EBITDA) for the period 2022-01-01 to 2023-01-01. * **Reported EBITDA:** -4,986,000,000 EUR (from "Operating Profit Before Depreciation And Amortisation" 2022-01-01 - 2023-01-01). Next, we apply adjustments as per S&P guidelines for Regulated Utilities: * **Leases:** The prompt does not provide specific lease liability or right-of-use asset data to calculate an explicit lease adjustment. In the absence of specific data, we assume reported EBITDA is the starting point. Standard S&P adjustments often add back lease depreciation and interest, but without the breakdown, we rely on the reported EBITDA figure which is already before depreciation and amortization. Note: IFRS 16 impacts EBITDA, but "Operating Profit Before Depreciation And Amortisation" usually includes the depreciation of ROU assets in the D&A line, meaning EBITDA is pre-lease-depreciation. However, the interest on leases is in finance costs. The baseline formula `Adjusted_EBITDA = EBITDA + adjustment_leases` suggests adding back any lease-related expenses excluded from EBITDA if necessary, or normalizing. Without specific lease data, we assume the reported EBITDA is the best available proxy for Operating EBITDA. * **Non-recurring items:** The facts show "Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss" of 1,762,000,000 EUR. Impairment reversals are typically considered non-recurring gains and should be subtracted from EBITDA to normalize it. There are no explicit "nonrecurring losses" listed separately that aren't already in operating profit, but we should check for other items. "Net Changes In Fair Value On Energy And Commodity Derivatives Excluding Trading Activities" is -849,000,000 EUR. S&P often adjusts for mark-to-market volatility on derivatives if they are not part of core operations or if hedging accounting isn't applied. However, for utilities, derivative gains/losses related to hedging are often part of core operations. The item specifies "Excluding Trading Activities", implying these are operational hedges. We will treat the impairment reversal as the primary non-recurring adjustment. * **Pension Adjustments:** The facts show "Noncurrent Provisions For Employee Benefits" decreasing from 21,716,000,000 to 16,231,000,000. This significant decrease might involve remeasurements. The OCI section shows "Gains Losses On Remeasurements Of Defined Benefit Plans" of 3,494,000,000 EUR (before tax). These are recorded in OCI, not P&L, so they don't affect EBITDA directly. However, S&P may adjust for the service cost vs cash contribution difference. Without detailed pension expense vs cash contribution data, we cannot make a precise cash-based pension adjustment. We will assume the reported EBITDA reflects the operating pension expense. * **Joint Ventures:** "Share Of Profit Loss Of Associates And Joint Ventures" is 759,000,000 EUR. This is equity income, typically below EBITDA. S&P often adds back the proportionate EBITDA of JVs if they are material. However, the equity pick-up is already excluded from the "Operating Profit Before Depreciation And Amortisation" line (which is usually consolidated operating profit). To get *Adjusted* EBITDA, we might need to add the JV's EBITDA. We don't have the JV's EBITDA, only the share of profit. Given the lack of data, we will stick to the consolidated EBITDA and adjust for the impairment reversal. **Calculation of Adjusted EBITDA:** * Reported EBITDA: -4,986,000,000 EUR * Less: Non-recurring gains (Impairment Reversal): -1,762,000,000 EUR * **Adjusted EBITDA** = -4,986,000,000 - 1,762,000,000 = **-6,748,000,000 EUR** *Self-Correction/Refinement:* In 2022, EDF faced exceptional costs related to the "Tariff Shield" and nuclear maintenance issues. The negative EBITDA reflects this. The impairment reversal is a non-cash, non-recurring gain that inflated the EBITDA relative to core operating performance. Subtracting it makes the EBITDA more negative, reflecting the underlying operational strain. ### Step 3: Estimate FFO Formula: `FFO = Adjusted_EBITDA - cash_interest - cash_taxes` * **Cash Interest:** * Reported "Interest Expense": 1,730,000,000 EUR. * "Finance Income Cost": -3,553,000,000 EUR (Net finance cost is negative, meaning net finance income? No, usually expenses are positive in this context or signs are mixed. Let's look at the components). * "Interest Expense": 1,730,000,000. * "Discount Effect": 174,000,000. * "Other Finance Income Cost": -1,997,000,000. * Total Finance Income Cost: -3,553,000,000. This implies a net finance *income* of 3.55 billion? Or is the sign convention that expenses are positive? * Let's check the P&L flow: * Operating Profit: -19,363,000,000. * Finance Income Cost: -3,553,000,000. * Profit Before Tax: -22,916,000,000. * -19,363 + (-3,553) = -22,916. The math holds. * If Finance Income Cost is negative, it *reduced* the loss? No, -19B + (-3.5B) = -22.9B. So the negative sign indicates an *expense* (cost) in this dataset's convention? * Wait, usually Income is positive, Expense is negative in some formats, or vice versa. * Let's look at 2021: Operating Profit 5,225. Finance Income Cost 360. Profit Before Tax 5,585. 5,225 + 360 = 5,585. So in 2021, positive Finance Income Cost meant net *income*. * In 2022, Finance Income Cost is -3,553. This means net finance *expense* of 3,553,000,000 EUR. * However, FFO uses *cash* interest. The reported interest expense is 1,730,000,000 EUR. The rest of the finance cost (-1,997 other + 174 discount) likely includes non-cash items or fair value changes. * S&P typically uses cash interest paid. We can approximate cash interest using the "Interest Expense" line if no other data is available, or look at cash flow statements. * The Cash Flow statement shows "Net Financial Expeneses Disbursed Including Dividends Received" as 1,003,000,000 EUR. This is a net outflow. * "Dividends Received Classified As Operating Activities" is 590,000,000 EUR. * So, Net Financial Expenses Disbursed = Cash Interest Paid - Cash Interest Received + Other Fin Disbursed? * Usually, `Cash Interest Paid` is the key component. * Let's estimate Cash Interest Paid. The "Interest Expense" in P&L is 1,730,000,000. * The "Net Financial Expenses Disbursed" is 1,003,000,000. This figure *includes* dividends received (which are operating inflows, but here grouped in financing disbursement netting?). The label says "Including Dividends Received". * If Net Disbursed = 1,003, and Dividends Received = 590, then Gross Financial Disbursed might be higher? Or is it Net of receipts? * Let's assume the cash interest paid is close to the interest expense of 1,730,000,000 EUR, adjusted for any capitalization or accruals. Without a detailed cash flow bridge for interest, we will use the reported **Interest Expense** of **1,730,000,000 EUR** as a proxy for cash interest, acknowledging it might differ slightly. A more conservative approach might use the net finance cost if it's all cash, but the "Discount Effect" and "Other Finance" suggest non-cash or trading components. The "Interest Expense" line is the most reliable proxy for contractual cash interest on debt. * **Cash Taxes:** * "Income Tax Expense Continuing Operations": -3,926,000,000 EUR. * "Income Taxes Paid Refund" in Cash Flow: 1,282,000,000 EUR. * The cash flow line "Income Taxes Paid Refund" being positive 1,282,000,000 EUR likely indicates a net *refund* or inflow? Or is it an outflow labeled positively? * In the Cash Flow from Operations section: * Net Cash Flow From Operations Before Net Financial Expenses... : -5,140,000,000. * Net Financial Expenses Disbursed... : 1,003,000,000. * Income Taxes Paid Refund : 1,282,000,000. * Cash Flows From Operating Activities : -7,425,000,000. * Check: -5,140 - 1,003 - 1,282 = -7,425. * Since the result is more negative, the "Income Taxes Paid Refund" of 1,282,000,000 is a **cash outflow** (tax paid). The label "Paid Refund" is ambiguous, but the arithmetic confirms it reduces cash flow. * So, **Cash Taxes Paid** = **1,282,000,000 EUR**. **Calculation of FFO:** * Adjusted EBITDA: -6,748,000,000 EUR * Less Cash Interest: 1,730,000,000 EUR * Less Cash Taxes: 1,282,000,000 EUR * **FFO** = -6,748,000,000 - 1,730,000,000 - 1,282,000,000 = **-9,760,000,000 EUR** ### Step 4: Estimate Adjusted Debt Formula: `Adjusted_Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash` * **Reported Debt:** * We need to sum interest-bearing debt. * "Other Noncurrent Financial Liabilities": 56,543,000,000 EUR (2022-01-01 balance? No, we need 2022 year-end, which is 2023-01-01 in the report labels? The labels are "2022-01-01 - 2023-01-01" for flows, and "2023-01-01" for balance sheet items, which represents the end of the 2022 fiscal year). * So we use the **2023-01-01** balance sheet values for Debt. * "Other Noncurrent Financial Liabilities": 71,058,000,000 EUR. * "Other Current Financial Liabilities": 71,844,000,000 EUR. * Total Reported Financial Debt = 71,058 + 71,844 = **142,902,000,000 EUR**. * Note: "Special French Public Electricity Distribution Concession Liabilities" (49,459,000,000) are typically regulatory liabilities, not financial debt, so they are excluded. "Provisions" are excluded. * **Leases:** Not explicitly broken out in debt lines. IFRS 16 lease liabilities are often included in "Other Financial Liabilities". Without a specific breakdown, we assume they are included in the reported financial liabilities above. S&P adds back lease liabilities if they were expensed, but here we are calculating Debt. If leases are in the financial liabilities, they are part of Reported Debt. S&P often treats lease liabilities as debt. So no additional add-back needed if already included. If not included, we would add them. Given the magnitude of "Other Financial Liabilities", it likely contains lease liabilities. We will assume Reported Debt captures all interest-bearing obligations including leases. * **Pension Deficit:** * S&P adjusts debt for the underfunded status of defined benefit pension plans. * Pension Assets vs Liabilities are not explicitly detailed in the provided facts as a net deficit number on the balance sheet face, but "Noncurrent Provisions For Employee Benefits" is 16,231,000,000 EUR. * Usually, the net pension liability is reported. If the provision represents the net deficit, we add it to debt. However, S&P often calculates the deficit as PBO - Plan Assets. * In the absence of specific Plan Assets data, we might look at the provision. However, standard S&P practice for utilities with large nuclear provisions (which are in "Provisions Related To Nuclear Generation...") distinguishes them from pensions. * The "Noncurrent Provisions For Employee Benefits" is 16.2 billion. This is a large number. It likely includes the net pension liability. * S&P adds the **unfunded** pension liability to debt. * Let's assume the provision of 16,231,000,000 is the accounting liability. Without asset data, we can't determine the deficit precisely. However, EDF's pension scheme is largely state-backed or unfunded in part? * Actually, for EDF, the "special regime" pensions are often considered a state obligation or have specific funding. * To be conservative and stick to the provided facts: We don't have a "Pension Deficit" line item. We have "Noncurrent Provisions For Employee Benefits". We will **not** add the full provision to debt unless we know it's unfunded. Standard adjustment is `Debt + (PBO - Assets)`. If we assume the provision is the net liability on the balance sheet, it's already in Equity/Liabilities but not in Financial Debt. S&P adds it to Debt. * Let's check if there's a specific "Net Pension Debt" fact. There isn't. * However, looking at the magnitude, adding 16B to 142B is significant. * Let's look for "Hybrid Debt". "Proceeds From Issue Of Subordinated Liabilities And Convertible Instruments" is a flow. The stock of hybrid debt is likely in "Other Noncurrent Financial Liabilities". * S&P treats hybrids as 50% debt / 50% equity usually, or 100% debt if not equity-like. * Without specific hybrid identification, we assume the reported financial liabilities are treated as 100% debt. * **Eligible Cash:** * "Cash And Cash Equivalents": 10,948,000,000 EUR (2023-01-01). * S&P deducts unrestricted cash. We assume all cash is eligible. * **Other Debt-like Items:** * "Special French Public Electricity Distribution Concession Liabilities": These are regulatory, not debt. * "Provisions Related To Nuclear Generation": These are regulatory provisions, not debt. **Calculation of Adjusted Debt:** * Reported Financial Debt (Current + Noncurrent): 71,844 + 71,058 = 142,902,000,000 EUR. * Add: Pension Deficit? (Data insufficient to calculate exact deficit, but provision is 16,231. If we assume it's unfunded, we add it. However, EDF's pension regime is complex. Often, rating agencies adjust for the *unfunded* portion. Lacking specific asset data, we might exclude this adjustment or assume it's partially funded. Given the strict "based on these facts" constraint, and the absence of "Pension Assets", we cannot calculate the deficit. We will proceed with Reported Debt only, or check if "Provisions" are considered debt-like. S&P usually adds the *unfunded* pension liability. Without assets, we can't. We will stick to Financial Liabilities.) * Less: Eligible Cash: 10,948,000,000 EUR. * **Adjusted Debt** = 142,902,000,000 - 10,948,000,000 = **131,954,000,000 EUR**. *Refinement on Debt:* Does "Other Current Financial Liabilities" include trade payables? No, "Trade And Other Current Payables" is separate (23,284). So "Other Current Financial Liabilities" is likely short-term debt, commercial paper, etc. This confirms the 142.9B figure is interest-bearing debt. ### Step 5: Calculate FFO / Adjusted Debt * FFO: -9,760,000,000 EUR * Adjusted Debt: 131,954,000,000 EUR Ratio = -9,760,000,000 / 131,954,000,000 Ratio ≈ -0.073965 Rounding to four decimal places: **-0.0740** Let's double check the FFO calculation. EBITDA: -4,986. Adj for Impairment Reversal (Gain): -1,762. Adj EBITDA: -6,748. Cash Interest: 1,730. Cash Tax: 1,282. FFO: -6,748 - 1,730 - 1,282 = -9,760. Debt: Noncurrent Fin Liab: 71,058. Current Fin Liab: 71,844. Total Debt: 142,902. Cash: 10,948. Net Debt: 131,954. Ratio: -9,760 / 131,954 = -0.07396... One potential adjustment: **Working Capital**. The Regulated Utilities section mentions: "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." EDF has "Inventories" of 17,661,000,000 EUR. "Other Current Financial Liabilities" (Short term debt) is 71,844,000,000 EUR. If we apply this adjustment: Adjusted Debt = Reported Debt - Inventory (if netting against short term debt). The adjustment reduces debt by the amount of inventory, up to the amount of short-term debt. Inventory = 17,661. Short-term debt = 71,844. We can net the full inventory amount. New Adjusted Debt = 131,954 - 17,661 = 114,293,000,000 EUR. Does this apply? "Natural gas distribution utilities" are cited as examples. EDF is primarily electric, but has gas activities. The prompt says "For regulated utilities... we adjust...". It's a conditional "Where substantial...". EDF's inventory (fuel, primarily nuclear fuel and gas/coal) is significant. Nuclear fuel inventory is often considered a working capital item that can be netted against debt in S&P utility analysis because it's a necessary operating stockpile funded by short-term debt. Let's apply this adjustment as it is specific to the Regulated Utilities methodology provided. Revised Adjusted Debt = 114,293,000,000 EUR. Revised Ratio = -9,760,000,000 / 114,293,000,000 Ratio ≈ -0.085394 Rounding to four decimal places: **-0.0854** Let's re-read the working capital adjustment rule carefully: "we adjust inventory and debt balances by netting the value of inventory against outstanding short-term borrowings." This implies: Adjusted Debt = Total Debt - min(Inventory, Short Term Debt). Total Debt (Gross) = 142,902. Short Term Debt = 71,844. Inventory = 17,661. Net Debt before inventory adjustment = 142,902 - 10,948 (Cash) = 131,954. Inventory adjustment reduces the *debt balance* used in the denominator. So, Adjusted Debt = 131,954 - 17,661 = 114,293. Is there any other adjustment? "Deconsolidate securitized debt". No info. "Purchased power methodology". No info on specific debt-like PPAs. Let's stick with the inventory adjustment. Final Calculation: FFO = -9,760,000,000 Adj Debt = 114,293,000,000 Ratio = -0.08539... -0.0854