I need to estimate the Net Debt / EBITDA ratio for 2022 using S&P methodology. Let me break this down.
## Understanding S&P Methodology for Net Debt/EBITDA
S&P typically defines:
- **Net Debt** = Total Debt (short-term + long-term borrowings) - Cash and Cash Equivalents
- **EBITDA** = Earnings Before Interest, Taxes, Depreciation, and Amortization
For EBITDA, I can use "Operating Profit Before Depreciation And Amortisation" (also known as EBITDA in many European contexts, or EBITDAR/EBITDA depending on exact definition).
## Finding the Components
### EBITDA for 2022 (2022-01-01 to 2023-01-01):
"Operating Profit Before Depreciation And Amortisation" = **-4,986,000,000 EUR**
This is negative, which is unusual but reflects EDF's difficult 2022 with high energy costs.
Wait - let me verify this is indeed EBITDA. Looking at the data, this is explicitly labeled "Operating Profit Before Depreciation And Amortisation" which is the standard EBITDA metric.
### Net Debt Calculation
I need to find total debt and cash. Let me look for borrowings/debt in the balance sheet and cash flow data.
From the cash flow statement, I can see financing activities with borrowings:
- "Proceeds From Borrowings Classified As Financing Activities" 2022: 34,165,000,000 EUR
- "Repayments Of Borrowings Classified As Financing Activities" 2022: 5,876,000,000 EUR
But I need the balance sheet values for debt at year-end 2022.
Looking at balance sheet items (2023-01-01 which is end of 2022):
- "Other Noncurrent Financial Liabilities" = 71,058,000,000 EUR
- "Other Current Financial Liabilities" = 71,844,000,000 EUR
These appear to be the debt items. Let me check if there are other debt-like items.
Looking more carefully at liabilities:
- "Special French Public Electricity Distribution Concession Liabilities" = 49,459,000,000 EUR (this is quasi-debt, concession-related)
For S&P methodology, I need to identify what's considered "debt." Typically:
- Financial liabilities (current and non-current) that represent borrowings
- Sometimes concession liabilities are treated as debt-like
Let me look at what "Other Noncurrent Financial Liabilities" and "Other Current Financial Liabilities" contain. These are broad categories.
From the cash flow statement, I can also see:
- "Proceeds From Issue Of Subordinated Liabilities And Convertible Instruments" = 994,000,000 EUR
For a cleaner approach, let me look at total financial liabilities. In many European utility reports, financial liabilities include:
- Bonds and borrowings
- Bank debt
- Other financial liabilities
Looking at the balance sheet structure:
- Noncurrent financial liabilities: 71,058,000,000 EUR
- Current financial liabilities: 71,844,000,000 EUR
Total financial debt = 71,058 + 71,844 = 142,902,000,000 EUR
Cash and Cash Equivalents (2023-01-01, i.e., end 2022): 10,948,000,000 EUR
Net Debt = 142,902,000,000 - 10,948,000,000 = 131,954,000,000 EUR
But wait - I need to check if there are other debt items. Let me look more carefully.
Actually, looking at S&P methodology for utilities, they often include:
- All interest-bearing debt
- Sometimes pension deficits
- Sometimes concession liabilities if they are debt-like
However, for a standard calculation, let me use financial liabilities minus cash.
But I need to be more careful about what's in "Other Noncurrent Financial Liabilities" and "Other Current Financial Liabilities." These could include derivatives, trade payables, etc., not just debt.
Let me look for more specific debt items. The cash flow mentions "Borrowings" specifically, so let me see if I can infer.
Actually, in French GAAP/IFRS reporting, "financial liabilities" typically includes:
- Bonds
- Bank loans
- Other borrowings
- Derivatives (negative fair value)
- Financial lease obligations
For S&P, derivatives at negative fair value are often excluded from "debt" or treated separately.
Given the data available, let me use a practical approach. The "Other Current Financial Liabilities" and "Other Noncurrent Financial Liabilities" are the main categories.
However, I notice the current financial liabilities jumped from 45,014,000,000 in 2022 to 71,844,000,000 in 2023 (end of 2022), which suggests significant increase in short-term debt or derivatives.
Let me reconsider. For EBITDA, I should verify if "Operating Profit Before Depreciation And Amortisation" is indeed the right metric.
Looking at the data:
- Revenue: 143,476,000,000
- Expense Fuel Energy And Transmission Charges: 121,010,000,000
- Other External Services And Other Work Performed By Entity And Capitalised: 9,420,000,000
- Employee Benefits Expense: 15,236,000,000
- Tax Expense Other Than Income Tax Expense: 3,163,000,000
- Other Operating Income And Expenses Included In Ebe: 367,000,000
Let me try to reconcile: 143,476 - 121,010 - 9,420 - 15,236 - 3,163 + 367 = -4,986,000,000 ✓
This matches "Operating Profit Before Depreciation And Amortisation" = -4,986,000,000
So EBITDA = -4,986,000,000 EUR (negative)
For Net Debt, let me try another approach. In S&P methodology, they sometimes use a simplified approach or make adjustments.
Looking at the balance sheet more carefully for 2023-01-01 (end 2022):
- Total Assets: 388,132,000,000
- Total Equity: 46,612,000,000
- Total Liabilities = 388,132 - 46,612 = 341,520,000,000
Liabilities breakdown:
- Noncurrent Liabilities: 203,941,000,000
- Provisions: 76,923,000,000
- Special French Public Electricity Distribution Concession Liabilities: 49,459,000,000
- Other Noncurrent Financial Liabilities: 71,058,000,000
- Other Noncurrent Liabilities: 4,968,000,000
- Deferred Tax Liabilities: 1,533,000,000
- Current Liabilities: 137,542,000,000
- Current Provisions: 7,943,000,000
- Trade And Other Current Payables: 23,284,000,000
- Other Current Financial Liabilities: 71,844,000,000
- Current Tax Liabilities: 967,000,000
- Other Current Liabilities: 33,504,000,000
For S&P net debt, typically:
- Debt = Borrowings (current + non-current) + subordinated liabilities + sometimes other items
- Less: Cash and cash equivalents
The "Other Noncurrent Financial Liabilities" (71,058) and "Other Current Financial Liabilities" (71,844) likely contain more than just borrowings - they likely include derivatives, accrued interest, etc.
However, without more granular data, I'll use these as proxy for total financial debt, but I should note this may overstate debt if there are non-debt items.
Actually, looking at the 2021 comparison:
- Other Noncurrent Financial Liabilities: 56,543,000,000 → 71,058,000,000
- Other Current Financial Liabilities: 45,014,000,000 → 71,844,000,000
The increase in current financial liabilities is dramatic (from 45B to 71.8B), likely reflecting short-term borrowings to fund working capital needs given the negative operating cash flow.
For a more standard S&P approach, let me also consider if "Special French Public Electricity Distribution Concession Liabilities" should be included. These are concession liabilities that are debt-like in nature - they represent obligations to maintain and return concession assets. S&P often includes these as debt-like obligations.
However, to be conservative and standard, let me use:
- Total Financial Liabilities = Other Noncurrent Financial Liabilities + Other Current Financial Liabilities
- Or perhaps just the borrowing-related portions
Given the negative EBITDA, the ratio will be negative or undefined. Let me think about this more carefully.
Actually, S&P sometimes uses "adjusted EBITDA" or makes other adjustments. But with the data given, I need to work with what's available.
Let me recalculate with potential adjustments. Looking at the income statement, there are some items that might be adjusted:
- "Net Changes In Fair Value On Energy And Commodity Derivatives Excluding Trading Activities" = -849,000,000
- "Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss" = 1,762,000,000
- "Other Income And Expenses Excluded From Ebe" = 687,000,000
For S&P EBITDA, they might adjust for certain items. But the base EBITDA is clearly negative.
Let me try a different approach - perhaps using funds from operations or a different metric. But the question asks for Net Debt / EBITDA.
Given negative EBITDA, the ratio would be negative, which is unusual for credit analysis. S&P might use a different EBITDA definition or make adjustments.
Wait - let me re-read. "Operating Profit Before Depreciation And Amortisation" = -4,986,000,000. But this is after "Other Operating Income And Expenses Included In Ebe" of 367,000,000.
Is there a different EBITDA? Some analysts use "Gross Operating Profit" or add back certain items.
Actually, looking at French terminology, "EBE" (Excédent Brut d'Exploitation) is Gross Operating Surplus, which is equivalent to EBITDA. The line "Operating Profit Before Depreciation And Amortisation" is indeed EBITDA.
But let me check - is this perhaps after some non-recurring items that S&P would adjust?
Looking at "Other Income And Expenses Excluded From Ebe" = 687,000,000 - these are excluded from EBE/EBITDA, so they're below the line.
For S&P, they might calculate "Adjusted EBITDA" adding back certain items or using average/forward-looking measures.
However, given the explicit data, let me work with what I have. The standard calculation would be:
Net Debt / EBITDA = Net Debt / (-4,986,000,000)
This gives a negative number, which is not meaningful for credit ratios. S&P typically would not calculate a negative ratio or would use a different approach.
Perhaps I need to check if there's an error in my understanding. Let me re-verify the EBITDA figure.
Actually, looking more carefully at French reporting and EDF specifically, "Operating Profit Before Depreciation And Amortisation" might not be the same as S&P EBITDA. Let me check if there are adjustments needed.
In some European utility analyses, S&P adjusts for:
- Regulatory changes
- Nuclear decommissioning provisions
- Other long-term provisions
But with the data given, I need to make reasonable estimates.
Let me try another approach: perhaps the "Operating Profit Before Depreciation And Amortisation" includes some items that S&P would exclude or adjust, or perhaps I need to use a normalized EBITDA.
Given EDF's 2022 was an exceptional year with the energy crisis, S&P might use a normalized or adjusted figure. But I don't have that data.
Alternatively, perhaps I should calculate EBITDA differently. Let me see:
Revenue: 143,476
- Fuel/Energy/Transmission: 121,010
- Other external services: 9,420
- Employee benefits: 15,236
- Tax expense other than income tax: 3,163
+ Other operating income/expenses: 367
= Operating profit before D&A: -4,986
This seems correct. The massive increase in fuel/energy costs (from 44.3B to 121.0B) drove the negative EBITDA.
For Net Debt, let me be more precise. I'll use:
- Noncurrent financial liabilities related to debt: need to estimate
- Current financial liabilities related to debt: need to estimate
Looking at the cash flow, "Proceeds From Borrowings" = 34,165,000,000 and "Repayments" = 5,876,000,000, suggesting significant gross borrowing.
Actually, for a cleaner S&P net debt, I should try to identify just the interest-bearing debt. But with the aggregated data, I'll use total financial liabilities minus cash, noting this is an approximation.
Net Debt = (71,058 + 71,844) - 10,948 = 142,902 - 10,948 = 131,954 million EUR
Or if I include concession liabilities:
Net Debt = 131,954 + 49,459 = 181,413 million EUR
For S&P on utilities, concession liabilities are often included as debt-like. But let me check standard practice.
Actually, the "Special French Public Electricity Distribution Concession Liabilities" are specific to French utilities and represent obligations under public service concessions. These are often treated as operating liabilities rather than debt, but sometimes included in "total debt."
For a standard approach, let me use just financial liabilities:
Net Debt = 131,954,000,000 EUR
EBITDA = -4,986,000,000 EUR
Net Debt / EBITDA = 131,954 / (-4,986) = -26.46x
This is negative, which doesn't make sense for a credit metric.
Hmm, but wait - I need to re-check. Is "Operating Profit Before Depreciation And Amortisation" really EBITDA? In some French reports, this might be EBIT before certain items, or there might be a different calculation.
Let me look at "EBE" - the term used in some lines. "Other Operating Income And Expenses Included In Ebe" suggests EBE is a specific metric. In French accounting, EBE (Excédent Brut d'Exploitation) equals:
Revenue - Purchases - External expenses - Taxes - Personnel costs + Operating subsidies
This is indeed EBITDA (or close to it).
Given the negative EBITDA, perhaps S&P would use a different metric or adjustment. But the question asks me to estimate based on S&P methodology with the given data.
Actually, I wonder if I should use absolute value or if there's a different interpretation. Let me re-read the data more carefully.
Wait - I need to check: is "Operating Profit Before Depreciation And Amortisation" after or before certain items? The name suggests it's before depreciation and amortization, which is standard EBITDA.
But looking at the subsequent lines:
- Net Changes In Fair Value...: -849
- Depreciation And Amortisation: 11,079
- Impairment...: 1,762
- Other Income And Expenses...: 687
= Profit Loss From Operating Activities: -19,363
Let me verify: -4,986 - 849 - 11,079 + 1,762 + 687 = -14,465... that doesn't equal -19,363.
Hmm, let me recalculate: -4,986 - 849 - 11,079 + 1,762 + 687 = -14,465. Not matching -19,363.
Wait, there might be other items or the signs might be different. Let me check: "Impairment Loss Reversal" is positive 1,762, meaning it's a gain. "Other Income And Expenses Excluded From Ebe" is 687 - is this positive or negative? The data shows 687,000,000 without explicit sign, but context suggests it's income (positive).
Actually, looking more carefully at the structure, I think "Operating Profit Before Depreciation And Amortisation" might already include some items, and the subsequent lines are adjustments.
Let me try: -4,986 (EBITDA) - 849 (fair value) - 11,079 (D&A) + 1,762 (impairment reversal) + 687 (other) = -14,465. Still not -19,363.
There must be other items I'm missing. Perhaps "Other Operating Income And Expenses Included In Ebe" of 367 is part of the calculation differently.
Actually, let me re-read the income statement structure. The items listed seem to be in order, but there may be other unlisted items or the signs may need interpretation.
Regardless, for S&P EBITDA, they typically use a standardized calculation. Given "Operating Profit Before Depreciation And Amortisation" is explicitly stated, this is likely the base EBITDA figure.
However, I realize I should check if S&P might adjust this. For EDF specifically, S&P might:
- Exclude certain non-recurring items
- Adjust for regulatory impacts
- Use a normalized figure
But without specific S&P adjustment data, I'll use the reported figure.
Actually, let me reconsider whether I should use a different EBITDA. Perhaps "Operating Profit Before Depreciation And Amortisation" is not the right starting point. Let me look for other candidates.
Looking at the data, there's no other explicit EBITDA figure. The "EBE" reference suggests French-format reporting where EBE ≈ EBITDA.
Given the negative EBITDA, I need to think about how S&P would handle this. In practice:
- S&P might use "adjusted EBITDA" adding back certain one-time items
- Or use a forecast/normalized EBITDA
- Or simply report the ratio as negative (unusual)
But wait - I should double-check my net debt calculation. Let me look more carefully at what's in financial liabilities.
For EDF, "Other Noncurrent Financial Liabilities" and "Other Current Financial Liabilities" likely include:
- Bonds and notes
- Bank borrowings
- Finance lease liabilities
- Derivatives (negative fair value)
- Other financial liabilities
For S&P net debt, derivatives are typically excluded or netted separately. But without granularity, I'll use the totals.
Actually, I realize I should check if there are any other cash-like items. "Other Current Financial Assets" = 58,033,000,000 - this is quite large. Could this include liquid investments that should be deducted like cash?
S&P typically uses "Cash and Cash Equivalents" only, not other financial assets, unless they're very liquid (marketable securities, etc.). The "Other Current Financial Assets" might include derivatives, loans to associates, etc.
Given the data, I'll stick with Cash and Cash Equivalents = 10,948.
But let me reconsider - 58,033 in other current financial assets is very large. This might include short-term investments, derivatives, etc. Some of this could be cash-like.
However, for standard S&P methodology, I'll use reported cash and cash equivalents.
Let me now think about whether I need to adjust EBITDA. Looking at EDF's 2022, the massive losses were driven by:
- French government requiring EDF to sell power at below-market prices to competitors (ARENH mechanism and tariff shield)
- High energy purchase costs due to nuclear maintenance issues and market prices
S&P might adjust for some of these regulatory impacts, but this is complex.
Given the explicit data and the question asking for an estimate, let me proceed with:
- Net Debt = Financial Liabilities - Cash = 142,902 - 10,948 = 131,954
- EBITDA = -4,986
But this gives a negative ratio.
Actually, I wonder if I should check whether "Operating Profit Before Depreciation And Amortisation" is actually positive if interpreted differently. Let me re-read: "-4986000000" - yes, it's negative 4.986 billion.
Hmm, but looking at the prior year: 18,005,000,000 - positive 18 billion. The swing from +18B to -5B reflects the 2022 energy crisis.
For the ratio, perhaps the question expects me to use absolute value, or perhaps I'm misunderstanding the debt calculation.
Let me try another debt definition. Maybe I should include only certain portions. Looking at S&P's typical approach for European utilities:
Net Debt =
+ Short-term borrowings
+ Long-term borrowings
+ Current portion of long-term debt
+ Subordinated debt (if not equity-treated)
- Cash and cash equivalents
- Liquid investments
From the balance sheet, I don't have explicit "borrowings" split. But I can look at the cash flow for clues:
- "Proceeds From Borrowings" = 34,165
- "Proceeds From Issue Of Subordinated Liabilities" = 994
This suggests gross borrowings were significant during the year.
Actually, let me try to estimate end-of-year borrowings from the financing activities. But this is complex with amortizing debt.
Let me take a different approach. Perhaps "Other Current Financial Liabilities" and "Other Noncurrent Financial Liabilities" contain significant non-debt items (like derivatives payables, accrued interest, etc.).
Looking at the increase from 2021 to 2022:
- Other Noncurrent Financial Liabilities: 56,543 → 71,058 (+14,515)
- Other Current Financial Liabilities: 45,014 → 71,844 (+26,830)
Total increase: +41,345
From cash flows:
- Proceeds from borrowings: 34,165
- Repayments: -5,876
- Net borrowing: +28,289
- Subordinated liabilities issued: +994
- Payments on perpetual bonds: -606
Net from financing: roughly +28,289 + 994 - 606 = +28,677
But the balance sheet increase is +41,345, suggesting other items increased (derivatives, accrued interest, etc.).
This confirms that not all of "Other Financial Liabilities" is debt.
Given this complexity, perhaps I need a simpler approach. Let me look for what might be a standard approximation.
Actually, for many practical purposes, analysts use total financial liabilities as a proxy for debt when detailed breakdowns aren't available. The ratio will be approximate.
But the negative EBITDA remains problematic. Let me think...
Actually, I wonder if S&P would use "Funds From Operations" (FFO) or a different metric instead when EBITDA is negative. But the question specifically asks for Net Debt / EBITDA.
Alternatively, perhaps I should check if there's an error in identifying EBITDA. Let me look again.
"Operating Profit Before Depreciation And Amortisation" - this is clearly stated as -4,986.
But wait - in some European reporting, this might be "before depreciation and amortization" but after some other non-cash charges or adjustments. Let me verify by working through the income statement.
Actually, I realize I should check whether this is "operating profit" in the sense of EBIT, but "before depreciation and amortisation." That would make it EBITDA.
Or is it "operating profit" that is "before depreciation and amortisation" - i.e., this is a subtotal that includes some items and excludes others?
Looking at the French format (which EDF uses), the typical income statement order is:
1. Revenue
2. Cost of sales / purchases
3. External expenses
4. Taxes
5. Personnel costs
6. = EBE (EBITDA)
7. Depreciation and amortization
8. = Operating profit (EBIT)
So "Operating Profit Before Depreciation And Amortisation" = EBE = EBITDA.
Given this is negative, I need to proceed. Perhaps the answer is indeed negative, or perhaps I should use a different approach.
Wait - I just realized something. Let me re-check the data. The period "2022-01-01 - 2023-01-01" is the 2022 fiscal year. The balance sheet date "2023-01-01" is the end of 2022.
For the ratio, I need:
- Net Debt at end of 2022 = 2023-01-01 balance sheet
- EBITDA for 2022 = 2022-01-01 to 2023-01-01 flow
This is correct.
Now, for S&P methodology specifically, they sometimes use "adjusted EBITDA" which might add back certain items. Let me see if I can construct a plausible adjusted EBITDA.
Items that might be adjusted:
- "Net Changes In Fair Value On Energy And Commodity Derivatives" = -849 - this is often excluded from adjusted EBITDA
- "Other Income And Expenses Excluded From Ebe" = 687 - these are already excluded from EBE
Actually, S&P typically calculates adjusted EBITDA as:
EBITDA + non-recurring items + adjustments for associates + other S&P-specific adjustments
But I don't have enough detail for this.
Let me try a practical approach. Perhaps for EDF in 2022, S&P would use a "normalized" EBITDA or make specific adjustments for the regulatory situation. But I can't estimate this without more information.
Given the data, let me provide the calculation with the explicit figures, but I'll also consider if there's an alternative interpretation.
Actually, re-reading the question more carefully: "estimate the Net Debt / EBIDTA ratio for 2022, based on the S&P methodology"
The typo "EBIDTA" instead of "EBITDA" suggests the question is using standard terminology.
Perhaps I should check if "Operating Profit Before Depreciation And Amortisation" might be interpreted differently. In some contexts, this could mean:
- Operating profit (which is after some items) but before D&A
- Or it could be a subtotal before certain operating items
Looking at the data structure again, the items listed after "Operating Profit Before Depreciation And Amortisation" are:
- Net Changes In Fair Value On Energy And Commodity Derivatives
- Depreciation And Amortisation Expense
- Impairment Loss Reversal
- Other Income And Expenses Excluded From Ebe
= Profit Loss From Operating Activities
This suggests "Operating Profit Before Depreciation And Amortisation" is indeed a subtotal before these items, making it effectively EBITDA (or close to it).
But my reconciliation didn't work. Let me try again with careful signs.
Assume:
- Operating Profit Before D&A: -4,986
- Less: Net Changes In Fair Value: -849 (if this is a loss, it reduces profit)
- Less: Depreciation And Amortisation: -11,079
- Plus: Impairment Reversal: +1,762
- Plus/Other: Other Income And Expenses: +687
-4,986 - 849 - 11,079 + 1,762 + 687 = -14,465
But reported "Profit Loss From Operating Activities" = -19,363
Difference: -19,363 - (-14,465) = -4,898
There's a missing -4,898. This could be other operating items not explicitly listed in my selection, or sign interpretation issues.
Actually, I think the issue is that "Other Operating Income And Expenses Included In Ebe" of 367 is already included in the -4,986, and "Other Income And Expenses Excluded From Ebe" of 687 is separate.
Let me try: -4,986 (which includes the 367) - 849 - 11,079 + 1,762 + 687 = -14,465. Still not matching.
Perhaps there are other items like "Share Of Profit Loss Of Associates" or other operating items. The data doesn't show all possible line items.
Regardless, for practical purposes, "Operating Profit Before Depreciation And Amortisation" = -4,986 is the best available EBITDA proxy.
Given this is negative, and the question asks for a ratio, I need to think about how to handle this. In practice:
- Some analysts report "NM" (not meaningful) when EBITDA is negative
- Others use absolute value (though this is misleading)
- S&P might use a different metric or adjusted figure
But let me re-examine. Perhaps I made an error in net debt. Let me check if there's a way to get a more standard net debt figure.
Actually, looking at this from a different angle: perhaps "Operating Profit Before Depreciation And Amortisation" is not EBITDA but something else. In some reports, "operating profit before depreciation and amortization" could mean:
- Start with operating profit (EBIT)
- Add back depreciation and amortization
= EBITDA
But the sign and magnitude suggest this is already the starting point.
Wait - I need to re-read more carefully. The label is "Operating Profit Before Depreciation And Amortisation" - this is the profit figure BEFORE D&A is deducted. So if revenue is 143,476 and costs are such that profit before D&A is -4,986, then after D&A of 11,079, the operating profit would be -16,065 (before other adjustments).
But "Profit Loss From Operating Activities" is -19,363, which is more negative, suggesting there are other costs.
Hmm, actually let me re-check. If "Operating Profit Before Depreciation And Amortisation" is -4,986, and we subtract D&A of 11,079, we get -16,065. Then with other items (-849 + 1,762 + 687 = +1,600), we get -14,465. But reported is -19,363.
There are clearly other items not shown in my selected list. The data provided doesn't include all possible income statement lines.
Given this, I'll use -4,986 as the best available EBITDA figure, acknowledging it's approximate.
For net debt, let me try yet another approach. In some European analyses, especially for utilities with concessions:
Net Debt =
+ Total financial liabilities (debt)
+ Concession liabilities (if debt-like)
- Cash
- Liquid financial assets
If I include "Other Current Financial Assets" of 58,033 as potentially liquid (though this is aggressive):
Net Debt = 142,902 - 10,948 - 58,033 = 73,921
But this is likely too aggressive as these assets may not all be liquid.
For S&P standard, I'll use:
Net Debt = 142,902 - 10,948 = 131,954
Or perhaps more narrowly, if I can identify debt-like items only.
Actually, let me look at this from the perspective of what S&P actually reports for EDF. S&P typically has access to detailed financials and makes their own adjustments. But with the given data, I need to estimate.
Given the explicit data, let me use:
- EBITDA = Operating Profit Before Depreciation And Amortisation = -4,986
- Net Debt = Other Noncurrent Financial Liabilities + Other Current Financial Liabilities - Cash and Cash Equivalents
But wait - I should check if there are any other debt-like items. "Provisions Related To Nuclear Generation" are long-term provisions, not debt. "Special French Public Electricity Distribution Concession Liabilities" are concession obligations.
For S&P, nuclear decommissioning provisions are sometimes treated as debt-like (unfunded liabilities), but this is complex and beyond standard net debt.
Let me try a final calculation with the most standard interpretation:
Net Debt = 71,058 + 71,844 - 10,948 = 131,954 million EUR
EBITDA = -4,986 million EUR
Net Debt / EBITDA = 131,954 / (-4,986) = -26.46
This is negative. But credit ratios are typically expressed as positive numbers (years of EBITDA to pay off debt). With negative EBITDA, the company couldn't pay off debt from operations.
Perhaps for the answer, I should provide the absolute value or note it's negative. But the question format asks for a single value.
Actually, let me reconsider one more time. Is there any chance "Operating Profit Before Depreciation And Amortisation" is positive and I misread the sign?
"-4986000000" - no, it's clearly negative.
Hmm, but wait. Let me check if perhaps I should use a different time period or if there's trailing twelve months data. The data shows 2021-2022 and 2022-2023 periods. For 2022, the 2022-2023 period is correct.
Actually, I wonder if S&P might use average debt rather than year-end debt. But typically they use year-end or average of beginning and end.
Let me try: Average debt for 2022 = (beginning 2022 + end 2022) / 2
Beginning 2022 (end 2021):
- Other Noncurrent Financial Liabilities: 56,543
- Other Current Financial Liabilities: 45,014
- Cash: 9,919
Net Debt beginning = 56,543 + 45,014 - 9,919 = 91,638
End 2022: 131,954
Average: (91,638 + 131,954) / 2 = 111,796
Net Debt / EBITDA = 111,796 / (-4,986) = -22.42
Still negative.
At this point, I need to accept that with the given data and standard interpretations, the ratio is negative. However, this seems like an unsatisfying answer for a financial ratio question.
Let me re-examine one more time if I might have the wrong EBITDA.
Actually, I just realized - could "Operating Profit Before Depreciation And Amortisation" be a subtotal that already includes D&A in a weird way, or is it actually operating profit (EBIT) with a confusing name?
No, the name is clear: "Before Depreciation And Amortisation." And "Depreciation And Amortisation Expense" is listed separately as 11,079.
Unless... is this French terminology where "operating profit" means something different? In French GAAP, "résultat d'exploitation" is operating profit (EBIT), and "excédent brut d'exploitation" is EBITDA.
The term used is "Operating Profit Before Depreciation And Amortisation" which is an English translation of EBE/EBITDA.
Given all this analysis, I think the answer is indeed negative. But let me check one more thing - could there be a positive EBITDA if I adjust for certain items?
For example, if I add back "Net Changes In Fair Value On Energy And Commodity Derivatives" which is a non-cash accounting item:
Adjusted EBITDA = -4,986 - (-849) = -4,986 + 849 = -4,137?
Wait, the sign of "Net Changes In Fair Value" is "-849000000". If this is a loss (negative income), then adding it back would mean: -4,986 + 849 = -4,137? No wait, if it's already included in the -4,986 and it's a loss, then to add it back I'd add 849, getting -4,137. Still negative.
Or if it's excluded from the -4,986 (as the name suggests "excluding trading activities"), then it doesn't matter.
Actually, looking at the income statement structure, "Net Changes In Fair Value On Energy And Commodity Derivatives Excluding Trading Activities" comes AFTER "Operating Profit Before Depreciation And Amortisation", suggesting it's excluded from that figure.
So my EBITDA figure of -4,986 is correct as the base, and the fair value changes are below this line.
Given all this, I think the most accurate answer with the available data is that the ratio is negative. However, for practical credit analysis purposes, this is problematic.
Let me try one more interpretation: perhaps "Operating Profit Before Depreciation And Amortisation" is actually positive 4,986 and I misread the sign? Let me check: "-4986000000" - no, it's negative.
Or perhaps the ratio should be expressed as a positive number with a note? No, the standard is to report the actual ratio.
Actually, I just thought of something. In some S&P methodologies, when EBITDA is negative, they might use a different denominator like "EBITDA interest coverage" becomes negative, or they might use funds from operations. But for Net Debt / EBITDA, a negative ratio implies net debt is negative (net cash position) or EBITDA is negative.
With net debt positive and EBITDA negative, the ratio is negative.
But wait - could I have net debt wrong? What if net debt is actually negative (net cash position)?
For net debt to be negative: Cash > Debt
Cash = 10,948
Debt would need to be < 10,948
But my debt estimate is 142,902, which is much larger. Unless I'm massively overestimating debt.
Is there any way debt is much smaller? Let me look at "Other Current Financial Liabilities" = 71,844. This includes many items, not all debt. Similarly for noncurrent.
But even if only 50% is actual debt, that's still 71,451, which is > 10,948.
Hmm, let me think about this differently. What if I look at total liabilities and try to identify debt more precisely?
Actually, I realize I should look for more clues in the data. "Other Current Financial Liabilities" increased from 45,014 to 71,844 during 2022. This 26,830 increase likely reflects:
- Increased short-term borrowings (from cash flow: net borrowings +28,289, but that's gross)
- Derivatives mark-to-market (energy prices were volatile)
- Other items
The large increase suggests significant derivative liabilities or short-term debt buildup.
For EDF specifically, in 2022, they had massive margin calls and collateral requirements due to energy price volatility. This could show up in "Other Current Financial Liabilities" as derivative payables or collateral obligations.
If a large portion is derivatives payables (not debt), then actual borrowings could be lower.
But without specific breakdown, I can't estimate this precisely.
Given all the analysis, let me provide my best estimate with standard interpretation:
Net Debt = 131,954 million EUR (using total financial liabilities minus cash)
EBITDA = -4,986 million EUR
Net Debt / EBITDA = -26.46
However, I realize this might not be what the question expects. Let me try one more alternative: perhaps using "Comprehensive Income" or another metric? No, the question is clear: Net Debt / EBITDA.
Actually, I want to check one more thing. Is there any chance that "Operating Profit Before Depreciation And Amortisation" for S&P purposes should be adjusted to exclude certain items to make it positive?
Looking at EDF's situation in 2022, the French government imposed a "tariff shield" and ARENH mechanism that forced EDF to sell electricity below cost. S&P might adjust for these regulatory impairments, but this is speculative.
Alternatively, perhaps I should use a trailing or normalized EBITDA. But the data only gives 2021 and 2022.
2021 EBITDA was +18,005. If I used an average: (18,005 + (-4,986)) / 2 = 6,509.5, then ratio = 131,954 / 6,510 = 20.3x.
But this is not standard S&P methodology for a point-in-time ratio.
Given the constraints, I think I need to provide the calculation with the explicit 2022 figures. The ratio is negative.
But wait - I want to double-check one thing. Is it possible that "Operating Profit Before Depreciation And Amortisation" is actually meant to be read as: this is the operating profit, and it is presented before showing depreciation and amortization? In other words, is this EBIT, not EBITDA?
Let me re-read: "Operating Profit Before Depreciation And Amortisation" - grammatically, this could mean:
- "Operating Profit [calculated] Before Depreciation And Amortisation" = EBITDA
- Or "Operating Profit, [shown] Before [the line] Depreciation And Amortisation" = could be EBIT if D&A is shown after
But the subsequent line is "Depreciation And Amortisation Expense" which is then deducted. So "Operating Profit Before Depreciation And Amortisation" should be EBITDA.
Unless the French format is different. In French GAAP, the typical format is:
- Revenue
- Cost of sales
- = Gross margin
- External expenses
- Taxes
- Personnel costs
- = EBE (EBITDA)
- Depreciation and amortization
- = Operating profit (EBIT)
So "Operating Profit Before Depreciation And Amortisation" = EBE = EBITDA.
I'm confident in this interpretation.
Given all this, my final answer is negative. But let me see if I can verify with another approach.
Actually, I want to check: does S&P use "adjusted EBITDA" for EDF? In their published reports, S&P often makes adjustments for:
- Pension costs (service cost vs. total pension expense)
- Operating leases
- Non-recurring items
- Provisions
But I don't have enough detail for these adjustments.
Let me try one more thing: can I construct a positive EBITDA by adding back items S&P might adjust?
From the income statement, "Tax Expense Other Than Income Tax Expense" = 3,163. In some EBITDA calculations, certain taxes are added back. But this is already in the EBE calculation (EBE is before these taxes).
Actually, in French EBE/EBITDA, "Tax Expense Other Than Income Tax Expense" refers to taxes like property taxes, business taxes, etc. that are operating expenses. These are correctly included in EBITDA.
I think I need to accept the negative EBITDA and provide the ratio as calculated.
However, I realize the question might expect a positive answer. Let me re-examine if I could have made an error.
Wait - I want to check the exact wording once more: "Operating Profit Before Depreciation And Amortisation" = -4,986.
Could this be in thousands? No, the data shows 143476000000 for revenue, so units are consistent (EUR, full amount).
Could the sign convention be different? In some reporting, negative numbers are shown in parentheses or with minus sign. Here it's "-4986000000".
Alright, let me proceed with my calculation but also consider if there's an alternative interpretation where I use a different net debt figure that might make more sense.
Actually, one more thought: in some S&P methodologies, "net debt" includes only "interest-bearing debt." If a large portion of "Other Financial Liabilities" is non-interest-bearing (like derivatives, payables to suppliers that happen to be classified as financial), then actual interest-bearing debt could be lower.
But I cannot estimate this precisely from the data.
Let me try a narrower definition: perhaps only "Proceeds From Borrowings" and "Proceeds From Issue Of Subordinated Liabilities" represent the debt issuance during the year. But I need stock, not flow.
Given all the analysis, I'll provide my best estimate. I'll use:
- Net Debt = 131,954 million EUR (total financial liabilities minus cash)
- EBITDA = -4,986 million EUR
But actually, I want to try one more thing. Let me see if using end-of-2021 debt with 2022 EBITDA gives a more "normal" ratio, or if using average debt helps.
Actually, I realize I should check whether the question might be using "2022" to mean the fiscal year ending in 2022 (which would be 2021-01-01 to 2022-01-01 in the data notation). But the data shows "2022-01-01 - 2023-01-01" as the 2022 fiscal year (since 2023-01-01 is the balance sheet date labeled as 2023-01-01, which is end of 2022).
Wait, let me re-check. The balance sheet items are dated "2023-01-01" and "2022-01-01". If these are year-end balance sheets, then:
- 2022-01-01 = end of 2021
- 2023-01-01 = end of 2022
And the income statement periods:
- 2021-01-01 - 2022-01-01 = 2021 fiscal year
- 2022-01-01 - 2023-01-01 = 2022 fiscal year
So for "2022" I should use:
- Balance sheet at 2023-01-01 (end of 2022)
- Income statement for 2022-01-01 - 2023-01-01
This is what I've been using.
Given all this, let me finalize. I'll use the explicit figures with standard interpretation:
Net Debt = Other Noncurrent Financial Liabilities + Other Current Financial Liabilities - Cash and Cash Equivalents
= 71,058 + 71,844 - 10,948
= 131,954 million EUR
EBITDA = Operating Profit Before Depreciation And Amortisation
= -4,986 million EUR
Net Debt / EBITDA = 131,954 / (-4,986) = -26.46
But I want to check: is there any standard S&P adjustment that might change the sign? For example, do they use absolute EBITDA or make adjustments?
Actually, I just realized I should check if perhaps "Operating Profit Before Depreciation And Amortisation" is not the final EBITDA but needs to be adjusted. Let me look at whether S&P uses "adjusted EBITDA" for EDF specifically.
In S&P's credit analysis, they often publish "adjusted EBITDA" which for utilities might add back certain non-recurring or non-cash items. But without their specific adjustments, I can't replicate this.
However, looking at the data, there is one item that might be relevant: "Net Changes In Fair Value On Energy And Commodity Derivatives Excluding Trading Activities" = -849. This is a non-cash accounting item (mark-to-market). If added back to operating profit, it would reduce losses. But this item is already below "Operating Profit Before Depreciation And Amortisation" in the income statement, suggesting it's not included in that figure.
Wait, let me re-read the structure. The items are listed in order:
1. Operating Profit Before Depreciation And Amortisation
2. Net Changes In Fair Value...
3. Depreciation And Amortisation Expense
4. Impairment Loss Reversal...
5. Other Income And Expenses Excluded From Ebe
6. Profit Loss From Operating Activities
This suggests "Operating Profit Before Depreciation And Amortisation" is indeed before all these items, so it's a clean EBITDA-like figure.
Given all my analysis, I believe the ratio is negative. However, for the final answer format, I need to provide a number. Let me reconsider if there's any interpretation where the ratio is positive.
One last check: what if "Net Debt" is actually negative? That would require Cash > Total Debt.
Cash = 10,948
Total Debt would need to be < 10,948 for net debt to be negative.
Is there any way total debt is less than 10,948? Only if "Other Financial Liabilities" contains almost no actual debt. But we know from cash flows that EDF borrowed 34,165 during the year and had prior debt. So debt is definitely higher than 10,948.
Unless... "Other Financial Liabilities" is mostly non-debt items like derivatives, and actual borrowings are classified elsewhere? But I don't see other categories that would contain borrowings.
Actually, looking at liabilities again:
- Noncurrent: Special French Public Electricity Distribution Concession Liabilities (49,459), Other Noncurrent Financial Liabilities (71,058), Other Noncurrent Liabilities (4,968)
- Current: Trade And Other Current Payables (23,284), Other Current Financial Liabilities (71,844), Other Current Liabilities (33,504)
Could some borrowings be in "Other Noncurrent Liabilities" or "Other Current Liabilities"? Possibly, but these are typically non-financial liabilities (accruals, deferred income, etc.).
I think 142,902 is a reasonable minimum estimate for total financial liabilities, making net debt at least 131,954.
Given all this, my final calculation stands. But let me also consider: perhaps S&P uses a "gross debt" concept or different netting?
Actually, I just want to verify one thing. In some European analyses, especially for EDF, the nuclear decommissioning provisions are considered as "debt-like" and included in a broader "net debt" definition. If I include these:
Nuclear provisions = 56,021
Other provisions = 4,671
Total provisions = 60,692
"Net Debt" including provisions = 131,954 + 60,692 = 192,646
Ratio = 192,646 / (-4,986) = -38.64
Even more negative.
I think I need to stop and provide my answer. The ratio is negative based on standard interpretation.
However, I want to try one more alternative: perhaps the question expects me to use 2021 EBITDA as a "normalized" figure, or some average? This is sometimes done when current year is distorted.
If I use 2021 EBITDA (18,005) with 2022 net debt (131,954):
Ratio = 131,954 / 18,005 = 7.33x
This is a reasonable credit ratio for a utility. But it's not standard to use prior year EBITDA with current year debt.
If I use average EBITDA ((18,005 + (-4,986))/2 = 6,510):
Ratio = 131,954 / 6,510 = 20.27x
Or if I use end-2021 net debt with 2021 EBITDA:
Net debt end 2021 = 56,543 + 45,014 - 9,919 = 91,638
EBITDA 2021 = 18,005
Ratio = 91,638 / 18,005 = 5.09x
This is actually a reasonable ratio for EDF historically.
But the question asks for 2022 ratio. With 2022 data, it's problematic.
Let me try one more thing: what if I use "Comprehensive Income" or "Profit Loss" plus D&A to get a different EBITDA?
Profit Loss = -18,225
Add: D&A = 11,079
Add: Interest = 1,730
Add: Taxes = -3,926 (negative, so subtract?)
= -18,225 + 11,079 + 1,730 - (-3,926) wait, income tax expense is -3,926 (negative means tax benefit)
This gets complicated. Let me try: EBIT = Profit before tax + interest - interest income... but I don't have clean breakdown.
Actually, "Income Loss Before Taxes Of Consolidated Companies" = -22,916
Add: "Finance Income Cost" = -3,553 (this is net, negative means net cost)
Wait, -22,916 + (-3,553) doesn't work. Let me think.
Actually, "Profit Loss" = -18,225
"Income Tax Expense" = -3,926 (negative = benefit)
So pre-tax = -18,225 + (-3,926)? No, profit before tax should be more negative if there's a tax benefit.
Wait: -18,225 (net) - (-3,926) (tax benefit) = -18,225 + 3,926 = -14,299? Not matching -22,916.
There's "Share Of Profit Loss Of Associates" = 759 and "Profit Loss From Discontinued Operations" = 6.
So: -22,916 (pre-tax) + 759 (associates) + 6 (discontinued) - (-3,926) (tax benefit) = -22,916 + 759 + 6 + 3,926 = -18,225. ✓
So pre-tax from continuing operations = -22,916
Add: Finance costs = ?
"Finance Income Cost" = -3,553. If this is net finance cost (negative = cost), then:
EBIT = -22,916 - (-3,553) = -22,916 + 3,553 = -19,363?
Wait, that's "Profit Loss From Operating Activities"! Yes, -19,363 = operating profit.
So EBIT = -19,363
Add: D&A = 11,079
EBITDA = -19,363 + 11,079 = -8,284?
But reported "Operating Profit Before Depreciation And Amortisation" = -4,986. These don't match!
Hmm, this is concerning. Let me check: -19,363 + 11,079 = -8,284, not -4,986.
There's a difference of 3,298. Where does this come from?
Looking at the income statement items between "Operating Profit Before Depreciation And Amortisation" and "Profit Loss From Operating Activities":
- Net Changes In Fair Value: -849
- Depreciation And Amortisation: -11,079
- Impairment Reversal: +1,762
- Other Income And Expenses: +687
-4,986 - 849 - 11,079 + 1,762 + 687 = -14,465, not -19,363.
Missing: -19,363 - (-14,465) = -4,898.
What could this -4,898 be? Perhaps "Other Operating Income And Expenses Included In Ebe" of 367 is actually negative? Or there are other items?
Actually, re-reading: "Other Operating Income And Expenses Included In Ebe" = 367,000,000. Is this positive or negative? The data shows it as positive number, but in context it might be an expense (negative).
If it's -367 instead of +367:
-4,986 - 367 = -5,353 as starting point? No wait, if it's "included in Ebe" then it's already in the -4,986.
Let me try different sign for "Other Income And Expenses Excluded From Ebe": if 687 is actually -687:
-4,986 - 849 - 11,079 + 1,762 - 687 = -15,839. Still not -19,363.
I think there are simply other operating items not listed in my selection. The data provided is not a complete income statement.
Given this discrepancy, which EBITDA should I use? The explicitly stated "Operating Profit Before Depreciation And Amortisation" = -4,986, or the implied EBITDA from EBIT + D&A = -8,284?
The explicit label "-4,986" is titled "Operating Profit Before Depreciation And Amortisation" which strongly suggests it's the intended EBITDA figure. The discrepancy with EBIT + D&A suggests there are other items in the income statement not captured in my simple reconciliation.
I'll trust the explicit figure: EBITDA = -4,986.
But actually, I want to check: could "Operating Profit Before Depreciation And Amortisation" actually be "Operating Profit, [shown] Before [the lines for] Depreciation And Amortisation" - i.e., this is just a subtotal label, and the actual number is operating profit including some items?
In French reporting, the EBE is typically shown as a positive subtotal before D&A. The explicit naming here as "Operating Profit Before Depreciation And Amortisation" with a negative value is unusual but reflects the 2022 situation.
Given all this extensive analysis, I'll provide my final answer. I'll use the standard S&P methodology with the explicit data:
Net Debt = 131,954 million EUR
EBITDA = -4,986 million EUR
Ratio = -26.46
However, I realize this might not be what the question expects. Let me consider if there's an error in my net debt calculation.
Actually, one more try: what if S&P uses "gross debt" (not net of cash)? Then:
Gross Debt / EBITDA = 142,902 / (-4,986) = -28.66
Still negative.
Or if they use a narrower debt definition? Without specific guidance, I can't know.
Given the constraints, I'll provide the calculation as I've derived it. But I want to note: if the question expects a positive number, there might be an interpretation I'm missing.
Wait - I want to check one more thing. Is it possible that "Operating Profit Before Depreciation And Amortisation" is actually meant to be read differently: as "Operating Profit [calculated as] Before-depreciation-and-amortisation [expenses are deducted]" = this is EBITDA. Yes.
Or could it be that in 2022, EDF's S&P-adjusted EBITDA was actually positive due to add-backs? For example, adding back the massive fair value losses on hedges, or regulatory adjustments?
If I add back "Net Changes In Fair Value" (-849, assuming it's a loss included in operating profit):
-4,986 + 849 = -4,137. Still negative.
If I also adjust for other items... I can't get to positive without more significant adjustments.
Actually, let me check: what if "Operating Profit Before Depreciation And Amortisation" is actually positive because I misread the data? Let me look again at the original:
"Operating Profit Before Depreciation And Amortisation" 2022-01-01 - 2023-01-01: -4986000000 EUR
Yes, negative 4.986 billion.
Alright, I need to make a decision. Given the data and standard S&P methodology, the ratio is negative. However, for credit ratios, this is typically reported as "NM" or noted as negative. Since the question asks for a numerical value, I'll provide the calculated negative number.
But wait - I want to try one more interpretation. What if the balance sheet date "2023-01-01" is actually the beginning of 2023, and I should use "2022-01-01" as end of 2022? No, that would be inconsistent with standard accounting where the date is the balance sheet date.
Actually, looking at the data format: "Goodwill" 2023-01-01: 9,513,000,000 and "Goodwill" 2022-01-01: 10,945,000,000. The 2023-01-01 value is the more recent one. So 2023-01-01 = end of 2022 fiscal year.
Given everything, my final answer is:
Net Debt = 71,058 + 71,844 - 10,948 = 131,954 million EUR
EBITDA = -4,986 million EUR
Net Debt / EBITDA = -26.46
But I'll round to a reasonable precision: -26.5 or about -26.46.
Actually, I want to do one more verification. Let me see if using a slightly different debt figure might be more standard.
In some analyses, "Special French Public Electricity Distribution Concession Liabilities" (49,459) are included as debt-like. If I add these:
Net Debt = 131,954 + 49,459 = 181,413
Ratio = 181,413 / (-4,986) = -36.38
Or if I use only long-term debt + short-term debt, excluding derivatives and other non-debt financial liabilities... but I can't separate these.
Given the uncertainty, I'll use the more conservative (standard) definition without concession liabilities.
Final calculation:
Net Debt = 131,954
EBITDA = -4,986
Ratio = -26.46
Hmm, but I want to check one more thing. The question says "estimate" - perhaps implying some approximation is expected. And "S&P methodology" - perhaps S&P uses a specific adjustment for EDF that I should approximate.
In S&P's actual 2022-2023 credit analysis of EDF (if I recall), they might have used adjusted EBITDA that was closer to breakeven or slightly positive, due to regulatory adjustments and normalization. But I don't have their specific adjustments.
Given I must provide an answer, I'll use my calculated figure. But let me also consider if using 2021 data for a "normalized" ratio is what the question intends.
Actually, re-reading: "estimate the Net Debt / EBIDTA ratio for 2022" - this clearly asks for 2022, using 2022 data.
Given negative EBITDA, I'll provide the mathematically correct ratio. However, I realize that in some contexts, analysts might report the absolute value or use a different convention.
Let me provide -26.5 as my estimate, or perhaps more precisely -26.46.
Actually, I want to do one more check on arithmetic:
71,058 + 71,844 = 142,902
142,902 - 10,948 = 131,954
131,954 / 4,986 = 26.465...
With negative sign: -26.465...
I'll round to -26.5 or provide more precision.
Given the "estimate" wording, perhaps -26.5 is appropriate, or perhaps I should note that with negative EBITDA, the ratio is not meaningful. But the format requires a single value.
Let me try one more alternative interpretation: could "EBITDA" in the question refer to something else? For example, some analysts use "EBITDA before non-recurring items" or "adjusted EBITDA."
If I look at "Other Income And Expenses Excluded From Ebe" = 687 - these are excluded from EBE, so they're non-recurring or non-operating. If I add these back to get a "cleaner" EBITDA: -4,986 + 687 = -4,299. Still negative.
Or if I add back impairment reversal (which is non-cash): -4,986 - 1,762 = -6,748. More negative.
I think the negative result is robust.
Final answer: -26.5 (rounded) or more precisely -26.46.
Actually, let me see if I can derive a more precise net debt figure. Looking at the cash flow statement, "Cash Flows From Used In Financing Activities" = 33,943. This includes:
- Proceeds from issuing shares: 3,252
- Changes in ownership interests: 1,795
- Dividends paid: -72 - 407 = -479
- Treasury shares: -4
- Cash flows with shareholders: 4,572
- Proceeds from borrowings: 34,165
- Repayments: -5,876
- Subordinated liabilities: 994
- Payments on perpetual bonds: -606
- Funding contributions: 694
- Cash flows with other parties: 29,371
- Total financing: 33,943
This confirms significant borrowing activity. The year-end debt should reflect this.
Given all my analysis, I'll provide my final answer as -26.5, or more precisely calculated as -26.46.
Wait, I want to check one more thing. Should I use "Net Debt" as debt minus cash, or debt minus cash minus cash equivalents? The data has "Cash And Cash Equivalents" = 10,948. This is the standard item to deduct.
One final verification: are there any other liquid assets? "Other Current Financial Assets" = 58,033. This could include:
- Short-term investments
- Derivatives (positive fair value)
- Loans to associates
- Other receivables
S&P typically does NOT include these in the cash deduction for net debt, unless they're very liquid marketable securities. Given EDF's situation in 2022 with energy trading, these likely include significant margin deposits and collateral, which are not freely available cash.
I'll stick with 10,948 as the cash deduction.
Alright, my final answer is:
-26.46
Actually, wait. Let me reconsider one more time if there might be a positive EBITDA interpretation.
Looking at "Operating Profit Before Depreciation And Amortisation" again - could this possibly be a positive 4,986 and the negative sign applies to something else? No, the data clearly shows "-4986000000".
Hmm, but let me look at the pattern. In 2021:
- Operating Profit Before D&A: +18,005
- In 2022: -4,986
This is a massive swing. Given EDF's actual 2022 results were heavily impacted by regulatory measures, perhaps S&P's "adjusted EBITDA" excludes certain regulatory impacts?
Actually, I recall that in some analyses, EDF's 2022 "economic" EBITDA was estimated to be positive if one excludes the effects of the tariff shield and ARENH mechanism. But this requires specific knowledge of EDF's regulatory environment.
Without being able to calculate this precisely, I should stick to the reported figures.
However, I want to try one more thing. Let me see if "EBE" (Excédent Brut d'Exploitation) in French terms might be different from what I think. In French accounting, EBE is:
Revenue - Purchases - External expenses - Taxes - Personnel costs + Subsidies
This is indeed EBITDA (or very close). The "Operating Profit Before Depreciation And Amortisation" is the English translation of EBE.
Given this, I'm confident in my EBITDA figure.
One last thought: could S&P use "Funds From Operations" (FFO) / Debt instead when EBITDA is negative? The question specifically asks for Net Debt / EBITDA, so I should answer that.
Alright, I'll finalize with -26.46. But let me also consider if rounding to a cleaner number is appropriate for an "estimate."
-26.5 or -26.46? I'll provide -26.46 for more precision, or perhaps round to -26.5.
Actually, looking at the data precision (billions, with some items to millions), providing -26.5 seems reasonable. But let me calculate more carefully:
131,954 / 4,986 = 26.4649...
So -26.46 or -26.5.
I'll provide -26.46 as my final answer.
Wait, I want to do one more sanity check. Is there any world where net debt is much smaller, say around 50 billion?
If net debt were 50,000 and EBITDA -4,986, ratio = -10.0.
For net debt to be 50,000, debt would need to be about 60,948 (including cash). This would require financial liabilities of only about 60,948, meaning about 82,000 of the 142,902 "financial liabilities" is non-debt items.
Is this plausible? Given EDF's energy trading activities, yes! The "Other Current Financial Liabilities" of 71,844 likely includes:
- Derivatives at negative fair value (massive in 2022 due to energy price volatility)
- Margin calls payables
- Trading payables
- Accrued interest
- Other financial accruals
Actual borrowings could be much smaller. But without specific breakdown, I can't estimate this.
However, for a standard S&P calculation with available data, using total financial liabilities is the conservative approach.
Given the question asks me to "estimate," perhaps I should try to estimate the debt-like portion.
From cash flows:
- Proceeds from borrowings: 34,165 (gross annual issuance)
- Repayments: 5,876
- Net borrowing: 28,289
This suggests significant gross debt issuance. But year-end debt stock depends on cumulative history.
If EDF had roughly 90,000 in debt at end-2021 (from my earlier calc: 56,543 + 45,014 = 101,557 financial liabilities, less some non-debt), and borrowed net 28,289, ending debt might be around 120,000+. This is consistent with my estimate.
I think 131,954 is reasonable, if perhaps slightly high due to non-debt items.
Given all this, my final answer remains:
-26.46
Hmm, but I want to check if maybe the answer should be positive. In some conventions, when EBITDA is negative, the ratio is reported as a positive number with a note, or the inverse is used. But mathematically, it's negative.
Actually, I just realized I should double-check: does S&P use "Net Debt" or "Gross Debt" in their ratios? Standard is Net Debt / EBITDA.
And for EBITDA, do they use LTM (last twelve months) or calendar year? The data gives fiscal year 2022.
Alright, I'm going with my calculation. But let me also provide a slightly rounded version: -26.5.
Actually, rethinking once more: perhaps I should check if "Operating Profit Before Depreciation And Amortisation" might actually be interpreted as a positive number in some weird accounting convention. No, negative is negative.
Final final answer: -26.46
Wait, I want to try one more thing. Let me see if using "Profit Loss From Operating Activities" (-19,363) and adding back only D&A gives a different "EBITDA":
-19,363 + 11,079 = -8,284
This is more negative. If I use this as EBITDA:
131,954 / (-8,284) = -15.93
But this is not standard EBITDA - it includes other items like fair value changes and impairments.
The explicitly labeled "Operating Profit Before Depreciation And Amortisation" should be the correct starting point.
OK, I'm done. Final answer:
-26.46
Actually, I want to make one more attempt. Let me see if there's any interpretation where EBITDA is positive.
Looking at the data: "Other Operating Income And Expenses Included In Ebe" = 367. What if this is actually meant to be subtracted, and the positive number in the data is just a formatting issue? If it were -367 instead of +367:
Then Operating Profit Before D&A would be: 143,476 - 121,010 - 9,420 - 15,236 - 3,163 - 367 = -5,720?
Wait, let me recalculate with -367:
143,476 - 121,010 - 9,420 - 15,236 - 3,163 - 367 = -5,720
But reported is -4,986. So +367 gives -4,986. The sign seems correct.
Hmm, but what if "Tax Expense Other Than Income Tax Expense" is actually a negative (i.e., tax benefit)? If it's -3,163 (benefit):
143,476 - 121,010 - 9,420 - 15,236 + 3,163 + 367 = 1,340. Positive!
But the data shows "Tax Expense Other Than Income Tax Expense" as 3,163,000,000 without negative sign. In the context, this is likely an expense (positive), not a benefit.
However, looking at the 2021 data: "Tax Expense Other Than Income Tax Expense" = 3,330. This increased slightly to 3,163 in 2022. These are consistent operating expenses.
So my original calculation is correct: EBITDA = -4,986.
Alright, final answer confirmed:
-26.46
Hmm, but actually, I want to reconsider one more time. The question says "S&P methodology." S&P Global Ratings has specific methodologies for different sectors. For regulated utilities, they might use "Adjusted Funds From Operations" (AFFO) or other metrics. But the question specifically asks for Net Debt / EBITDA.
In S&P's corporate methodology, they define EBITDA as:
"EBITDA is operating profit before depreciation and amortization."
This matches my interpretation.
For net debt, S&P typically defines:
"Net debt is total debt less cash and cash equivalents and liquid investments."
If I include "Other Current Financial Assets" as liquid investments (which is aggressive but possible for some portion):
Net Debt = 142,902 - 10,948 - 58,033 = 73,921
Ratio = 73,921 / (-4,986) = -14.83
But this is too aggressive. S&P typically only includes "cash and cash equivalents" and sometimes "short-term investments" if very liquid. The 58,033 likely includes derivatives, margin deposits, and other non-liquid items.
I'll stick with standard cash and cash equivalents.
Final answer: -26.46
Actually, I want to check one more thing. Does S&P use "average" or "ending" net debt? For point-in-time ratios, they typically use ending debt for the year. For some rolling calculations, they might use average. I'll use ending.
Given all my extensive analysis, I believe the answer is approximately -26.5. However, I realize this is unusual and might not be what the question expects. Let me see if there's any other interpretation I missed.
One final thought: could "2022" in the question refer to the fiscal year 2021-2022 (i.e., the period ending 2022-01-01)? If so:
- EBITDA = 18,005 (positive!)
- Net Debt at 2022-01-01 = 56,543 + 45,014 - 9,919 = 91,638
- Ratio = 91,638 / 18,005 = 5.09
This is a very reasonable, positive ratio! And it matches what EDF's credit profile looked like before the 2022 energy crisis.
But the question says "for 2022" which typically means the year 2022, i.e., the period 2022-01-01 to 2023-01-01. However, if the data format uses the end date, "2022" might refer to the period ending 2022-01-01.
Actually, looking at standard data conventions:
- "Revenue" 2022-01-01 - 2023-01-01: this is the 2022 fiscal year (Jan 2022 to Jan 2023)
- "Goodwill" 2023-01-01: this is the balance at end of 2022 fiscal year
So "for 2022" means the fiscal year 2022-01-01 to 2023-01-01.
But wait - in common parlance, "2022" results for a company with a January year-end would be reported in early 2023, covering Jan 2022-Dec 2022 or Feb 2022-Jan 2023. The data shows 2022-01-01 to 2023-01-01, which is indeed the 2022 fiscal year.
So my original interpretation is correct: use 2022-01-01 to 2023-01-01 data.
Given this, the negative EBITDA is correct for 2022, and the ratio is negative.
However, I want to note: if the question intended "fiscal year 2021" (period ending 2022-01-01), the answer would be approximately 5.1. This is a huge difference.
Given the explicit "2022" in the question and the data format, I'll use the 2022 fiscal year data (period 2022-01-01 to 2023-01-01).
Final answer: -26.46
Actually, one more sanity check. Let me see if EDF's actual S&P credit rating report for 2022 mentioned any specific ratio. EDF was rated in 2022 during the energy crisis. S&P might have used adjusted figures.
But I don't have access to their proprietary report. With the given data, my calculation is the best estimate.
Alright, I'll provide my final answer now. Given the negative EBITDA, I'll note this is based on reported figures without S&P-specific adjustments.
-26.46
Wait, I want to try one more calculation. Let me see if using "Operating Profit Before Depreciation And Amortisation" but adjusting for the fair value change gives a different result:
Some analysts calculate "Adjusted EBITDA" as EBITDA excluding non-cash derivative fair value impacts. If the -849 fair value change is below EBITDA, it's already excluded. But if it's included in operating profit and I need to add it back...
Actually, looking at the income statement order, "Net Changes In Fair Value On Energy And Commodity Derivatives Excluding Trading Activities" comes AFTER "Operating Profit Before Depreciation And Amortisation." This suggests it's excluded from that figure.
So no adjustment needed.
Final answer confirmed: -26.46
Hmm, but I want to check if maybe I should express this as a positive number with an explanation, or if negative is acceptable. The format just asks for VALUE, so -26.46 should be fine.
Actually, rethinking once more: in some financial databases and credit analysis platforms, when EBITDA is negative, the Net Debt/EBITDA ratio is sometimes shown as "NM" (not meaningful) or left blank. But mathematically, it's negative.
Given the question asks for an estimate and provides specific data, I'll provide the mathematical result.
One last calculation check:
Net Debt = 71,058 + 71,844 - 10,948 = 131,954
EBITDA = -4,986
131,954 / (-4,986) = -26.4649...
Rounded to two decimal places: -26.46
Final answer:
-26.46