To estimate the Net Debt / EBITDA ratio for Electricité de France (EDF) for the year 2022 based on the S&P methodology, we need to determine two components: Net Debt and EBITDA. **1. Calculate EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)** The provided data includes "Operating Profit Before Depreciation And Amortisation" (often referred to as EBITDA in many contexts, but we must check if it aligns with the standard definition used for leverage ratios). * "Operating Profit Before Depreciation And Amortisation" 2022-01-01 - 2023-01-01: -4,986,000,000 EUR. However, S&P typically uses a measure closer to EBITDA derived from operating profit or net income, adding back depreciation, amortization, and often adjusting for non-recurring items. Let's look at the components: * Revenue: 143,476,000,000 EUR * Expense Fuel Energy And Transmission Charges: 121,010,000,000 EUR * Other External Services: 9,420,000,000 EUR * Employee Benefits Expense: 15,236,000,000 EUR * Tax Expense Other Than Income Tax: 3,163,000,000 EUR * Other Operating Income/Expenses included in EBE: 367,000,000 EUR Let's verify the "Operating Profit Before Depreciation And Amortisation" figure: Revenue (143,476) - Fuel (121,010) - Other Ext Services (9,420) - Employee Benefits (15,236) - Other Tax (3,163) + Other Op Inc (367) = -4,986. This matches the reported "Operating Profit Before Depreciation And Amortisation" of -4,986,000,000 EUR. In S&P methodology, EBITDA is often defined as EBIT + Depreciation + Amortization. * "Profit Loss From Operating Activities" (EBIT): -19,363,000,000 EUR * "Depreciation And Amortisation Expense": 11,079,000,000 EUR * EBITDA = EBIT + D&A = -19,363 + 11,079 = -8,284,000,000 EUR? Wait, the line item "Operating Profit Before Depreciation And Amortisation" is explicitly given as -4,986,000,000 EUR. Why is there a discrepancy? Let's check the reconciliation: EBIT (-19,363) + D&A (11,079) + Impairment Reversal (1,762) + Other Income/Expenses excluded from EBE (687) + Net Changes in Fair Value (-849) ... Actually, the line "Operating Profit Before Depreciation And Amortisation" usually corresponds to EBITDA. Let's assume the reported figure of **-4,986,000,000 EUR** is the EBITDA. Note that this is negative. However, S&P Global Ratings often makes adjustments to EBITDA for "one-time" or "non-recurring" items, or may use a trailing 12-month or forward-looking estimate if the reported figure is distorted. In 2022, EDF was heavily impacted by the energy crisis and nuclear availability issues. The negative EBITDA is a factual result of the reported numbers. Let's double-check if "Operating Profit Before Depreciation And Amortisation" is indeed the standard EBITDA. Revenue: 143,476 - Fuel: 121,010 - Other External: 9,420 - Employee: 15,236 - Other Tax: 3,163 + Other Op Inc: 367 = 143,476 - 121,010 - 9,420 - 15,236 - 3,163 + 367 = -4,986. Yes, this is the operational EBITDA. So, **EBITDA = -4,986,000,000 EUR**. **2. Calculate Net Debt** S&P defines Net Debt as Total Debt minus Cash and Cash Equivalents (and sometimes short-term investments). * **Total Debt**: We need to sum interest-bearing debt. * "Other Noncurrent Financial Liabilities": 71,058,000,000 EUR * "Other Current Financial Liabilities": 71,844,000,000 EUR * Are there other debt items? "Special French Public Electricity Distribution Concession Liabilities" (49,459) are often treated as debt-like liabilities or provisions depending on the rating agency's specific treatment. S&P typically includes "debt-like" items. However, standard Net Debt usually focuses on financial liabilities. Let's stick to explicit financial liabilities first. * Total Financial Liabilities = 71,058 + 71,844 = 142,902,000,000 EUR. * Note: "Provisions Related To Nuclear Generation..." are provisions, not debt. "Special French Public Electricity Distribution Concession Liabilities" are regulatory liabilities, often excluded from standard Net Debt unless specified as debt-like. S&P might include them in "Adjusted Debt". Let's calculate standard Net Debt first. * **Cash and Cash Equivalents**: * "Cash And Cash Equivalents": 10,948,000,000 EUR. * "Other Current Financial Assets": 58,033,000,000 EUR. S&P often deducts unrestricted cash and short-term investments from debt. However, "Other Current Financial Assets" may include derivatives or other items not strictly cash. The most conservative and standard "Net Debt" calculation uses Cash & Cash Equivalents. Sometimes, short-term financial assets are included if they are liquid and unrestricted. Given the magnitude, excluding them might overstate net debt. However, without a breakdown, we usually stick to Cash & Cash Equivalents for a strict definition, or add liquid financial assets if they are clearly cash-equivalents. Let's look at the change in cash flow. The cash balance is 10,948. * Let's check if "Other Current Financial Assets" are considered cash equivalents. In utility balance sheets, this often includes derivatives and short-term placements. S&P methodology for "Net Debt" typically is Gross Debt minus Cash and Short-term Investments. If we assume "Other Current Financial Assets" are largely liquid investments, we might deduct them. But often, only "Cash and Cash Equivalents" are safely deducted. Let's calculate with just Cash first. * Net Debt = Total Financial Liabilities - Cash * Net Debt = 142,902 - 10,948 = 131,954,000,000 EUR. *Alternative*: If we include "Other Current Financial Assets" as cash-like (which is risky without detail), Net Debt would be much lower. However, standard practice for "Net Debt" in many automated contexts is Debt - Cash. Let's stick to the explicit "Cash And Cash Equivalents". *Refinement on Debt*: Does "Special French Public Electricity Distribution Concession Liabilities" count? These are obligations to return assets at the end of concessions. They are non-interest bearing typically. S&P "Adjusted Debt" might include them. But "Net Debt" usually refers to financial debt. Let's stick to Financial Liabilities. So, Net Debt ≈ 131,954,000,000 EUR. **3. Calculate the Ratio** Ratio = Net Debt / EBITDA Ratio = 131,954,000,000 / -4,986,000,000 Ratio ≈ -26.46 A negative ratio indicates that the company has negative EBITDA. In financial analysis, a negative EBITDA makes the Net Debt/EBITDA ratio meaningless or negative, indicating severe distress or a specific accounting year anomaly (like the 2022 energy crisis impact on EDF). However, sometimes "EBITDA" for leverage ratios is adjusted. Did EDF have significant non-recurring charges? The "Impairment Loss Reversal" is 1,762. "Net Changes In Fair Value..." is -849. "Other Income And Expenses Excluded From Ebe" is 687. If we look at S&P's "Funds From Operations (FFO)" or "Debt/EBITDA" adjustments, they might add back non-cash or volatile items. But even adding back the impairment reversal (1.7B) and fair value changes (0.8B) won't turn -4.9B positive. Let's re-read the "Operating Profit Before Depreciation And Amortisation". It is -4,986 million. Is it possible the question implies using the *previous* year's EBITDA or an average? No, it asks for 2022. Is it possible "Net Debt" should include the concession liabilities? If we include Concession Liabilities (49,459) in Debt: Debt = 142,902 + 49,459 = 192,361. Net Debt = 192,361 - 10,948 = 181,413. Ratio = 181,413 / -4,986 = -36.38. Let's consider if "EBITDA" should be calculated differently. Some definitions use EBITDA = Net Income + Interest + Tax + Depreciation + Amortization. Net Income (Profit Loss): -18,225 Interest Expense: 1,730 (Note: Finance Income Cost is -3,553, which includes interest expense and other finance costs. The net finance cost is -3,553. So we add back the net finance cost if starting from Net Income? No, EBITDA is pre-interest. Let's stick to the Operating measure. EBITDA = -4,986. Given the negative EBITDA, the ratio is negative. However, in many automated financial data contexts, if EBITDA is negative, the ratio is often reported as "N/A" or negative. The prompt asks for an estimate. Let's double check the "Net Debt" definition. S&P Global Ratings often uses "Debt" which includes short-term and long-term borrowings. Short-term borrowings: "Other Current Financial Liabilities" (71,844). Long-term borrowings: "Other Noncurrent Financial Liabilities" (71,058). Total Debt = 142,902. Cash = 10,948. Net Debt = 131,954. EBITDA = -4,986. Ratio = -26.46. Let's check if there is a different interpretation of "EBITDA" in the S&P methodology for utilities. S&P often uses "EBITDA" as reported by the company if it aligns with their definition. EDF reports "Operating Profit Before Depreciation And Amortisation" as -4,986. If the user expects a positive number, they might be looking for Gross Debt / EBITDA (still negative) or using a normalized EBITDA. Without instructions to normalize, we must use the reported figures. Another possibility: Did I miss a large component of EBITDA? Revenue: 143,476 Expenses: Fuel: 121,010 Ext Services: 9,420 Employee: 15,236 Tax (other): 3,163 Total Op Ex: 148,829 Op Income: 367 EBITDA = 143,476 - 148,829 + 367 = -4,986. Correct. The ratio is negative. -26.46