To estimate the FFO / Net Debt ratio for ENGIE for the year 2022 based on S&P methodology, we need to calculate two components: Funds From Operations (FFO) and Net Debt. **1. Calculate Funds From Operations (FFO)** According to S&P Global Ratings methodology for utilities and energy companies, FFO is generally calculated as: $$FFO = \text{Net Income} + \text{Depreciation, Amortization, and Impairment} + \text{Other Non-Cash Items} + \text{Changes in Working Capital (sometimes excluded or adjusted, but standard FFO often starts from Operating Cash Flow or Net Income + D&A)}$$ A more precise S&P definition for FFO is: $$FFO = \text{Net Income} + \text{Depreciation and Amortization} + \text{Impairment Charges/Reversals} + \text{Other Non-Cash Adjustments}$$ *Note: S&P often uses "Funds From Operations" as Net Income plus Depreciation, Amortization, and significant non-cash items. Sometimes it is derived from Operating Cash Flow before working capital changes, but the standard credit metric FFO is typically Net Income + D&A + Non-cash items.* Let's look at the available data for the period 2022-01-01 to 2023-01-01 (Fiscal Year 2022): * **Net Income (Profit Loss):** 390,000,000 EUR * **Depreciation, Amortization, and Provisions:** 5,187,000,000 EUR * *Note: The line item is "Depreciation Amortization And Provisions". S&P usually adds back D&A. Provisions can be non-cash, but cash taxes/interest are handled separately. Let's look for a clearer "Net Depreciation Amortization Impairment" line.* * **Impairment Loss / Reversal:** 2,774,000,000 EUR (This is a positive number in the P&L, likely a net reversal or gain, or an expense? The label is "Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss". In the P&L context, if it's positive income, it's already in Net Income. If it's an expense, it's subtracted. Let's check the Operating Income calculation to determine the sign. * Revenue: 93,865 * Purchases: (74,535) * Employee Benefits: (8,078) * Depreciation: (5,187) * Tax Other: (3,380) * Other Income: 1,624 * Current Operating Income (reported): 4,309. * Let's sum: $93,865 - 74,535 - 8,078 - 5,187 - 3,380 + 1,624 = 4,309$. This matches. So Depreciation is an expense. * The "Impairment Loss Reversal..." line item of 2,774 is likely *below* the Operating Income line or included in "Other Non Recurring Items" or separate. * Let's look at "Profit Loss From Operating Activities": 1,127. * Current Operating Income incl MTM & Equity: 5,367. * Items between Current Op Income and Profit from Ops: * Impairment: 2,774 * Restructuring: (230) * Other Income/Expense from Subs: 91 * Other Non Recurring: (1,328) * Sum: $5,367 + 2,774 - 230 + 91 - 1,328 = 6,674$. This does not match 1,127. * Wait, the "Impairment Loss Reversal" might be an expense if the label implies the *net* movement. However, usually, a positive number in these datasets for "Impairment Loss" implies an expense (outflow/negative impact) or a reversal (positive impact). Given the drop from Operating Income (5,367) to Operating Profit (1,127), there is a large negative gap of ~4,240. * Let's re-read the items. * Current Op Income (incl MTM & Equity): 5,367 * Less: Impairment? If 2,774 is an expense, then $5,367 - 2,774 = 2,593$. * Less: Restructuring (230) -> 2,363. * Add: Other Income from Subs (91) -> 2,454. * Less: Other Non Recurring (1,328) -> 1,126. This matches "Profit Loss From Operating Activities" of 1,127 (rounding diff). * Therefore, the **2,774,000,000 EUR is an impairment expense** (non-cash charge) that was subtracted to reach Operating Profit. Thus, it must be added back to Net Income to calculate FFO. * **Other Non-Cash Items:** * S&P FFO adds back non-cash items. * "Net Depreciation Amortization Impairment And Provisions" in Cash Flow statement is -8,057,000,000 EUR. This likely represents the total add-back for D&A and Impairment in the indirect cash flow method. * Let's verify: D&A (5,187) + Impairment (2,774) = 7,961. The CF statement says 8,057. The difference (96) might be provisions or other small non-cash items. * Standard FFO Calculation: $$FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Impairment} + \text{Other Non-Cash Charges} - \text{Non-Cash Gains}$$ * Using the Cash Flow Statement adjustment "Net Depreciation Amortization Impairment And Provisions": 8,057,000,000 EUR. * Are there other significant non-cash items? * "Adjustments For Gains Losses On Change In Fair Value Of Derivatives": -3,661,000,000 EUR. This is a large non-cash adjustment. In the Cash Flow from Operations, this is subtracted (or added depending on sign convention). The label says "Adjustments...". In the CF section, "Cash Flows From Used In Operations Before Changes In Working Capital" is 12,415. * Let's reconstruct FFO from the top down or bottom up using standard S&P preferences. S&P often defines FFO as Net Income + D&A + Impairment + Other Non-Cash Items. * Net Income: 390,000,000 EUR. * Add: Depreciation, Amortization, Impairment: ~8,057,000,000 EUR (from CF statement "Net Depreciation Amortization Impairment And Provisions"). * Add/Subtract: Other non-cash items included in Net Income but not in Operating Cash Flow? * S&P FFO is often very close to "Cash Flow from Operations before Working Capital Changes" but excludes interest and taxes paid/received if they are considered financing/investing, but typically FFO includes interest and taxes paid. * Actually, a common proxy for FFO in S&P reports for utilities is: **Net Income + Depreciation & Amortization + Impairment + Deferred Taxes + Other Non-Cash Items**. * Let's use the Cash Flow from Operations (CFO) as a base and adjust, or build up. * CFO (Continuing + Discontinued): 8,586,000,000 EUR. * CFO includes changes in working capital. FFO typically *excludes* changes in working capital. * "Cash Flows From Used In Operations Before Changes In Working Capital": 12,415,000,000 EUR. * This figure (12,415) is essentially EBITDA-like cash flow but after interest and taxes? No, the CF statement starts from Net Income and adds back non-cash items. * Let's check the composition of "Cash Flows From Used In Operations Before Changes In Working Capital" (12,415). * It is derived from Net Income (390) + Non-cash adjustments. * Non-cash adjustments sum: * Net Dep/Amort/Imp/Prov: 8,057 * Impact of changes in scope/other non-recurring: -74 * Adj for Gains/Losses on Derivatives: -3,661 * Other Noncash: -157 * Adj for Income Tax: -83 (Deferred tax?) * Adj for Finance Income/Cost: -3,003 * Share of Profit of Associates (Equity method): 1,059 (Added back because it's non-cash income included in Net Income? Or is it? The line "Adjustments For Undistributed Profits..." is 1,059. Usually, you subtract the equity income and add back dividends. Here, the adjustment is positive 1,059. Wait. If Equity Income is 1,059 (from P&L), and it's non-cash, you subtract it from Net Income to get cash flow. But the adjustment here is listed as positive 1,059 in the "Adjustments" section? * Let's look at the signs in the CF data provided. * Net Income: 390. * If we sum the adjustments provided in the text: * Undistributed profits adj: 1,059 * Dividend income adj: -713 * Net Dep/Amort/Imp: -8,057 (Wait, the text says "Net Depreciation...: -8057000000". In CF statements, expenses are added back, so they are positive adjustments. Why is it negative? Perhaps the data source uses negative for outflows/expenses in the P&L and the CF adjustment sign follows the P&L sign? Or maybe it's a subtraction? * Let's look at "Cash Flows From Used In Operations Before Changes In Working Capital": 12,415. * If Net Income is 390, and the result is 12,415, the net adjustments must be +12,025. * Let's check the signs of the adjustments provided: * "Net Depreciation...": -8,057. If this is added back, it should be +8,057. * "Adjustments For Gains Losses On Change In Fair Value Of Derivatives": -3,661. * "Adjustments For Finance Income Cost": -3,003. * "Adjustments For Undistributed Profits...": 1,059. * "Adjustments For Dividend Income": -713. * "Impact Of Changes In Scope...": -74. * "Other Adjustments...": -157. * "Adjustments For Income Tax...": -83. * Sum of these specific adjustments: $-8057 - 3661 - 3003 + 1059 - 713 - 74 - 157 - 83 = -14,689$. * $390 - 14,689 = -14,299$. This is not 12,415. * There is a sign convention mismatch. In many XBRL datasets, expenses are negative. In Cash Flow, add-backs of expenses are positive. * Let's assume the absolute values are the add-backs/subtractions. * Depreciation/Impairment (Expense): Add back 8,057. * Finance Cost (Expense): Add back 3,003? No, Interest paid is a cash flow. S&P FFO includes interest paid. So we shouldn't add back interest if we want FFO. However, the CF statement "Before Working Capital" usually starts from Net Income and adds back non-cash items. Interest is a cash item, so it stays in Net Income. Why is there an adjustment for Finance Income/Cost? * Usually, "Adjustments for Finance Income/Cost" in CF refers to non-cash interest or reclassifications. * Let's rely on the explicit line: **"Cash Flows From Used In Operations Before Changes In Working Capital" = 12,415,000,000 EUR**. * S&P defines FFO as Net Income + Depreciation + Amortization + Impairment + Other Non-Cash Items. This is conceptually very similar to "Cash Flow from Operations Before Changes in Working Capital" *except* for the treatment of interest and taxes if they were excluded from the operating section. However, in IFRS (ENGIE's standard), Interest Paid and Taxes Paid are often classified as Operating Activities. * If Interest and Taxes are in Operating Cash Flow, then "CFO before WC changes" is a very strong proxy for FFO. * S&P FFO adjustments often include: * Add: D&A, Impairment. * Add: Deferred Taxes. * Subtract: Non-cash gains. * Add: Non-cash losses. * The line "Cash Flows From Used In Operations Before Changes In Working Capital" (12,415) effectively represents the cash generated from operations before the timing differences of working capital. This is the standard definition of FFO used by many rating agencies when derived from the Cash Flow Statement (often called "FFO" or "Cash Flow from Operations before WC"). * Let's verify if there are any specific S&P adjustments needed. S&P sometimes adjusts for "volatile" items like mark-to-market derivatives. The adjustment for "Gains Losses On Change In Fair Value Of Derivatives" (-3,661) is already included in the derivation of the 12,415 figure (as it's an adjustment to Net Income). Since S&P prefers to exclude volatile MTM gains/losses from core earnings, and this figure *adds back* the non-cash MTM impact (neutralizing it), this 12,415 figure is a robust FFO estimate. * Therefore, **FFO ≈ 12,415,000,000 EUR**. **2. Calculate Net Debt** Net Debt is typically defined as: $$\text{Net Debt} = \text{Total Debt} - \text{Cash and Cash Equivalents}$$ *Total Debt* includes Short-term and Long-term borrowings. S&P may also include lease liabilities, but standard "Net Debt" in many contexts refers to financial debt. Let's look for "Borrowings". From the Balance Sheet data (2023-01-01, which is the end of 2022): * **Long-term Borrowings:** 28,083,000,000 EUR * **Current Borrowings And Current Portion Of Noncurrent Borrowings:** 12,508,000,000 EUR * **Total Gross Debt:** $28,083 + 12,508 = 40,591,000,000$ EUR. *Note: Does "Debt" include Derivative Liabilities?* Generally, Net Debt for leverage ratios includes interest-bearing debt. Derivative liabilities are usually excluded from Net Debt unless they are closely linked to debt management, but standard S&P Net Debt focuses on borrowings. Lease liabilities are increasingly included, but "Borrowings" is the explicit line item. Let's stick to Borrowings. * **Cash and Cash Equivalents:** 15,570,000,000 EUR. $$\text{Net Debt} = 40,591,000,000 - 15,570,000,000 = 25,021,000,000 \text{ EUR}$$ *Self-Correction/Refinement on Debt:* S&P often includes "Lease Liabilities" in debt for utilities. The data provided does not explicitly list "Lease Liabilities". It lists "Other Noncurrent Nonfinancial Liabilities" and "Other Current Nonfinancial Liabilities". Leases are often embedded there or in a separate line not provided. However, without explicit lease data, we must use the provided "Borrowings". Also, S&P might adjust Cash for "restricted cash". "Cash And Cash Equivalents" is 15,570. We assume this is the usable cash. Let's double check if there are other debt-like items. "Noncurrent Derivative Financial Liabilities": 39,417. "Current Derivative Financial Liabilities": 11,859. These are huge. However, derivatives are typically marked-to-market. Including them in Net Debt would distort the ratio significantly and is not standard for "Net Debt" unless specified as "Debt + Derivatives". Standard S&P "Debt" definition for leverage is Interest Bearing Debt. Derivatives are part of the risk profile but not usually principal debt. Let's stick to Borrowings. Gross Debt = 40,591 million EUR. Cash = 15,570 million EUR. Net Debt = 25,021 million EUR. **3. Calculate the Ratio** $$\text{FFO / Net Debt} = \frac{12,415}{25,021}$$ $$12,415 / 25,021 \approx 0.49618$$ Let's review the FFO calculation again. Is "Cash Flows From Used In Operations Before Changes In Working Capital" exactly FFO? S&P FFO = Net Income + D&A + Impairment + Deferred Tax + Other Non-Cash. Let's try to build FFO manually from the P&L and CF adjustments to be sure. Net Income: 390 + Depreciation, Amortization, Provisions: 5,187 + Impairment Loss: 2,774 + Deferred Tax? - Income Tax Expense (Current/Total): -83 (This is very low, likely due to losses/credits). - The CF adjustment for Income Tax is -83. - Deferred Tax Assets/Liabilities change: - DTA: 1,181 -> 2,029 (Increase of 848). Increase in DTA is a source of cash (add back). - DTL: 7,738 -> 6,408 (Decrease of 1,330). Decrease in DTL is a use of cash (subtract). - Net Deferred Tax impact on Cash Flow: $848 - 1,330 = -482$. - The CF adjustment "Adjustments For Income Tax Expense" is -83. This doesn't seem to capture the full balance sheet movement, possibly because tax paid is different. Let's look at the "Cash Flows From Used In Operations Before Changes In Working Capital" again: 12,415. This figure is the standard starting point for FFO in many analytical models when derived from reported Cash Flow Statements under IFRS, assuming interest and taxes are operating cash flows. However, S&P sometimes makes adjustments to "reported" FFO. Common S&P adjustments: - Add back restructuring costs (cash or non-cash)? S&P often adds back *non-recurring* restructuring costs to "Adjusted FFO". The prompt asks for "FFO / Net debt ratio... based on S&P methodology". S&P publishes "Core FFO" or "Adjusted FFO". Standard "FFO" is usually the unadjusted metric. - If we use unadjusted FFO: 12,415. - If we use Adjusted FFO (adding back restructuring, etc.): - Restructuring Expense: 230. - Other Non-Recurring: -1,328 (This is a net expense? Or income? In P&L, "Other Non Recurring Items" is -1,328. Since it reduced Operating Profit, it's an expense/loss. So we add it back). - Impairment is already added back in the 12,415 figure (via the D&A+Imp adjustment). - MTM Derivatives: The adjustment of -3,661 in CF neutralizes the P&L impact. If the P&L had a gain, it was subtracted. If a loss, added. The 12,415 figure is "clean" of non-cash MTM volatility. So, 12,415 is a very solid "Core" FFO number. Let's check the Net Debt again. Does S&P include "Noncontrolling Interests" or other equity-like debt? "Deeply Subordinated Perpetual Notes": 3,393 (2023) / 3,767 (2022). S&P often treats perpetual notes as 50% debt and 50% equity, or 100% debt depending on the terms. For ENGIE, these are likely treated as debt or hybrid. If treated as debt, Net Debt increases. However, the standard "Net Debt" ratio usually refers to Senior Unsecured Debt + Cash. If we include Perpetual Notes as 50% debt: Debt = 40,591 + 0.5 * 3,393 = 42,287. Net Debt = 42,287 - 15,570 = 26,717. Ratio = 12,415 / 26,717 = 0.464. If we include Perpetual Notes as 100% debt: Debt = 40,591 + 3,393 = 43,984. Net Debt = 43,984 - 15,570 = 28,414. Ratio = 12,415 / 28,414 = 0.437. Standard S&P "FFO to Debt" ratio usually uses "Total Debt" which includes bank loans, bonds, and commercial paper. Perpetuals are often classified as "Hybrid Capital" and might be excluded from "Debt" in the denominator of "FFO/Debt" but included in "FFO/Total Capitalization". The prompt asks for "FFO / Net debt". "Net Debt" is a specific term usually meaning Interest Bearing Debt minus Cash. Perpetual notes are interest-bearing. However, in many utility credit analyses, "Net Debt" refers to the senior debt structure. Let's look at ENGIE's specific reporting. ENGIE reports "Net Debt" in its own financials. ENGIE's definition of Net Debt typically includes: - Current and non-current borrowings. - Derivatives related to borrowings? - Less cash and cash equivalents. - Less current financial assets? Let's check if we can find ENGIE's reported Net Debt or a close proxy. In the absence of explicit "Net Debt" line, we use Gross Borrowings - Cash. Gross Borrowings = 40,591. Cash = 15,570. Net Debt = 25,021. Is there any other debt? "Other Current Financial Assets": 2,394. "Other Noncurrent Financial Assets": 10,599. Sometimes Net Debt is defined as (Debt - Cash - Short Term Investments). If we subtract "Other Current Financial Assets" (likely liquid): Net Debt = 25,021 - 2,394 = 22,627. Ratio = 12,415 / 22,627 = 0.548. However, standard S&P methodology for "Net Debt" in the context of leverage ratios (like FFO/Net Debt) typically uses **Gross Debt minus Cash and Cash Equivalents**. It does not usually subtract other financial assets unless they are strictly cash equivalents. Let's assume the standard definition: FFO = 12,415 million EUR. Net Debt = 25,021 million EUR. Ratio = 0.496. Let's double check the FFO number. Is it possible FFO is lower? Some definitions of FFO subtract "Maintenance CapEx". S&P "FFO" does *not* subtract CapEx. "Discretionary Cash Flow" or "Free Operating Cash Flow" does. The prompt asks for FFO. Is it possible FFO is higher? Did we miss add-backs? The "Cash Flows From Used In Operations Before Changes In Working Capital" is 12,415. This includes the add-back of 8,057 (D&A+Imp) and the neutralization of 3,661 (Derivatives). It seems robust. Let's consider the "Net Debt" denominator again. S&P Global Ratings often uses "Total Debt" which may include lease liabilities. ENGIE has significant lease liabilities (not explicitly broken out in the provided lines, but likely in "Other Noncurrent Nonfinancial Liabilities" or similar). If we cannot identify leases, we stick to Borrowings. One detail: The "Net Debt" might be average Net Debt? S&P often uses average debt for flow/stock ratios. Net Debt 2022 (End 2021 / Start 2022): Borrowings 2022-01-01: Long-term: 30,458 Current: 10,590 Total Gross: 41,048 Cash 2022-01-01: 13,890 Net Debt Start: 41,048 - 13,890 = 27,158. Net Debt 2023-01-01 (End 2022): Total Gross: 40,591 Cash: 15,570 Net Debt End: 25,021. Average Net Debt = (27,158 + 25,021) / 2 = 26,089.5. Ratio using Average Net Debt: $12,415 / 26,089.5 \approx 0.4758$. S&P methodology typically uses **average** debt for leverage ratios involving flow metrics (like FFO) to match the period coverage. So, 0.476 is a better estimate. Let's refine the FFO. Is "Cash Flows From Used In Operations Before Changes In Working Capital" the exact S&P FFO? S&P FFO = Net Income + D&A + Impairment + Deferred Taxes + Other Non-Cash. The CF line "Before Changes in Working Capital" is: Net Income + All Non-Cash Adjustments (including D&A, Imp, Deferred Tax, Stock Based Comp, etc.) +/- Non-Operating Gains/Losses. The CF statement provided shows "Adjustments For Finance Income Cost" of -3,003. In the P&L, Net Financial Income Loss is -3,003. This adjustment in CF likely removes the non-cash portion of finance costs or reclassifies them. Actually, if Interest Paid is in Operating Cash Flow, then Finance Costs are cash expenses. Why adjust? Usually, the adjustment "Adjustments For Finance Income Cost" in the indirect method adds back non-cash interest (accruals) or subtracts cash interest if it was classified elsewhere. Given the complexity, the line "Cash Flows From Used In Operations Before Changes In Working Capital" (12,415) is the most reliable "Cash Earnings" proxy provided. Let's check if S&P adjusts for "Working Capital" in FFO. No, FFO is *before* working capital changes. Free Cash Flow is after. So 12,415 is the correct numerator. Denominator: Average Net Debt. Start Net Debt: 27,158. End Net Debt: 25,021. Average: 26,090. Ratio: $12,415 / 26,090 = 0.4758$. Rounding to two decimal places: 0.48. Rounding to three: 0.476. Let's check if there are any "Preferred Dividends" to subtract from FFO? ENGIE has "Deeply Subordinated Perpetual Notes". These act like preferred stock. S&P FFO is available to *all* capital providers (debt and equity). Preferred dividends are not subtracted from FFO (they are subtracted from Net Income to get "Net Income Available to Common", but FFO starts from Net Income and adds back non-cash. Preferred dividends are a cash distribution, not a non-cash add-back. However, FFO is a pre-financing cash flow metric? No, FFO is post-interest and post-tax. Wait. FFO = Net Income + D&A. Net Income is after interest and taxes. So FFO is the cash flow available to pay debt principal, dividends, etc. So we do NOT subtract preferred dividends from FFO. Therefore, the ratio is ~0.48. 0.48