To estimate the FFO / Net Debt ratio for Naturgy Energy Group SA 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, FFO is generally calculated as: $$FFO = \text{Net Income} + \text{Depreciation and Amortization} + \text{Other Non-Cash Items}$$ *Note: S&P often starts with Net Income attributable to the parent or consolidated Net Income. Given the data, we will use Consolidated Net Income (Profit Loss) and adjust for non-cash items. We must also consider minority interests if starting from consolidated net income, but standard FFO definitions often start from Net Income including minorities and then adjust, or start from Net Income Attributable to Parent. S&P typically uses Consolidated Net Income before minority interests for the top line, then adds back D&A. Let's look at the specific line items.* Standard S&P FFO Formula: $$FFO = \text{Consolidated Net Income} + \text{Depreciation \& Amortization} + \text{Non-cash charges/credits}$$ From the data provided for the period 2022-01-01 to 2023-01-01 (Fiscal Year 2022): * **Profit Loss (Consolidated Net Income):** 1,826,000,000 EUR * **Amortizacion Y Perdidas Por Deterioro De Activos (Depreciation, Amortization & Impairment):** 1,532,000,000 EUR Are there other significant non-cash items? * **Increase Decrease In Allowance Account For Credit Losses:** -228,000,000 EUR. This is a non-cash charge (credit) that reduced profit. Since it's a negative expense (a gain/reduction in allowance), it was added to net income. To get to cash flow from operations proxy, we usually add back non-cash expenses. If this is a reduction in allowance, it's a non-cash gain, so we should subtract it. However, S&P FFO often simplifies to Net Income + D&A. Let's look at "Adjustments For Reconcile Profit Loss" in the cash flow section. * **Adjustments For Reconcile Profit Loss:** 3,057,000,000 EUR. This includes D&A (1,532,000,000) and "Other Adjustments" (1,525,000,000). * The "Other Adjustments" likely include changes in provisions, deferred taxes, and other non-cash items. A more robust S&P-style FFO calculation often starts with **EBITDA** or **Operating Profit** and adjusts, or starts with **Net Income** and adds back **D&A**. Let's use the standard definition: $FFO = \text{Net Income} + \text{D\&A}$. However, S&P often defines FFO as: $$FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Impairment Charges} - \text{Gains on Sales of Assets} + \text{Losses on Sales of Assets}$$ Let's extract the specific components: * **Net Income (Profit Loss):** 1,826,000,000 EUR * **Depreciation & Amortization & Impairment:** 1,532,000,000 EUR * **Gains On Disposals Of Property Plant And Equipment:** 8,000,000 EUR (This is a gain included in Net Income, so we subtract it to get FFO). * **Other Gains Losses:** -111,000,000 EUR (This is a net loss, so we add it back). $$FFO = 1,826 + 1,532 - 8 + 111 = 3,461 \text{ million EUR}$$ Let's double-check if "Profit Loss" includes minority interests. Yes, "Profit Loss" is 1,826m. "Profit Loss Attributable To Owners Of Parent" is 1,649m. S&P typically calculates ratios on a consolidated basis including non-controlling interests for the debt side, so the numerator should also reflect the whole entity or be consistent. Usually, FFO is calculated on consolidated net income. Let's refine the FFO calculation using the Cash Flow from Operations (CFO) as a base, which is often close, but FFO differs by working capital changes. $CFO = 4,242 \text{ million EUR}$. $FFO \approx CFO + \text{Interest Paid} + \text{Taxes Paid} - \text{Working Capital Changes}$? No, that's getting complicated. Let's stick to the standard S&P definition: $$FFO = \text{Consolidated Net Income} + \text{Depreciation and Amortization} + \text{Non-cash items (like impairments, deferred taxes)}$$ Often, S&P reports FFO directly. Without that, we approximate. Using: Net Income (1,826) + D&A (1,532) = 3,358 million. Adjusting for gains/losses on disposals: Gain on disposal (8m) is in Net Income. Subtract it. Other Gains/Losses (-111m) is a loss. Add it back. $FFO = 1,826 + 1,532 - 8 + 111 = 3,461 \text{ million EUR}$. Let's check if there are significant deferred tax adjustments. Deferred Tax Expense is part of the tax line. The tax expense is 697m. Change in Deferred Tax Assets: $2,267 - 2,210 = 57$ decrease (expense). Change in Deferred Tax Liabilities: $1,951 - 1,787 = 164$ increase (benefit). Net Deferred Tax Benefit = $164 - 57 = 107$ million. This is a non-cash benefit included in the tax expense. Since it reduced tax expense (increased net income), we should subtract it from FFO? Or is it already handled? Standard FFO adds back non-cash charges. A deferred tax benefit is a non-cash gain. So we subtract it. $FFO = 3,461 - 107 = 3,354 \text{ million EUR}$. However, a simpler and very common approximation for utilities/energy firms in absence of detailed breakdown is: $FFO = \text{Net Income} + \text{D\&A}$. $FFO = 1,826 + 1,532 = 3,358 \text{ million EUR}$. Let's look at "Adjustments For Reconcile Profit Loss" = 3,057m. This amount is added to Net Income (1,826) to get Operating Cash Flow before working capital? $1,826 + 3,057 = 4,883$. Then "Increase Decrease In Working Capital" is -272m. $4,883 - 272 = 4,611$. Then "Other Inflows Outflows..." -1,089. $4,611 - 1,089 = 3,522$. Then Interest/Tax/Dividends adjustments? The reported "Cash Flows From Used In Operating Activities" is 4,242m. There seems to be a discrepancy in my manual summation vs reported CFO. Let's trust the reported CFO of 4,242m. S&P FFO is typically higher than CFO because it adds back interest and taxes paid? No, FFO is a pre-interest, pre-tax metric? Actually, S&P defines FFO as: $$FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Impairment} + \text{Deferred Taxes} + \text{Other Non-Cash Items}$$ Essentially, it is Net Income + Non-Cash Charges. Let's use the value **3,358 million EUR** (Net Income + D&A) as a conservative base, or **3,461 million EUR** adjusting for explicit gains/losses. Let's look at the "Beneficio Bruto De Explotacion Ebitda" (EBITDA): 4,954 million EUR. $EBITDA = 4,954$. $Interest = 837$ (Finance Costs) - $164$ (Finance Income) = Net Interest 673? Or use Gross? S&P uses Gross Interest for coverage, but for FFO, we start from Net Income. $EBITDA - \text{Interest} - \text{Taxes} - \text{Minority Interests?} = \text{Net Income}$. $4,954 - 665 (\text{Net Finance Cost}) - 697 (\text{Tax}) = 3,592$. This is close to Profit Before Tax (2,546) - Tax (697) = 1,849 (Profit from Continuing Ops). Total Profit = 1,826. Let's calculate FFO as: $FFO = \text{Net Income} + \text{D\&A} + \text{Deferred Tax} + \text{Impairments (if separate)}$. D&A is 1,532. Net Income is 1,826. Sum = 3,358. This is a solid estimate for FFO. **2. Calculate Net Debt** Net Debt is defined as: $$\text{Net Debt} = \text{Total Debt} - \text{Cash and Cash Equivalents}$$ *Note: S&P may also subtract short-term investments or unrestricted cash, but we will use Cash and Cash Equivalents.* We need to identify Total Debt. This includes: 1. **Current Financial Liabilities** (specifically interest-bearing debt): * Current Borrowings And Current Portion Of Noncurrent Borrowings: 2,110,000,000 EUR * Current Lease Liabilities: 177,000,000 EUR (S&P often includes lease liabilities in debt for utilities/infrastructure) * Other Current Financial Liabilities: 15,000,000 EUR * *Note: "Current Financial Liabilities" total is 2,302,000,000. This matches $2,110 + 177 + 15 = 2,302$. So we use the total Current Financial Liabilities as debt.* * Current Debt = 2,302,000,000 EUR. 2. **Noncurrent Financial Liabilities** (interest-bearing debt): * Noncurrent Financial Liabilities: 13,999,000,000 EUR. * Breakdown: Longterm Borrowings (12,689) + Noncurrent Lease Liabilities (1,309) + Other (1). Sum = 13,999. * Noncurrent Debt = 13,999,000,000 EUR. **Total Gross Debt** = Current Financial Liabilities + Noncurrent Financial Liabilities $$\text{Total Gross Debt} = 2,302,000,000 + 13,999,000,000 = 16,301,000,000 \text{ EUR}$$ **Cash and Cash Equivalents** (at 2023-01-01, which is the end of 2022): $$\text{Cash} = 3,985,000,000 \text{ EUR}$$ **Net Debt** = Total Gross Debt - Cash $$\text{Net Debt} = 16,301,000,000 - 3,985,000,000 = 12,316,000,000 \text{ EUR}$$ *Self-Correction on Debt Definition:* Does S&P include "Other Noncurrent Nonfinancial Liabilities" or "Trade Payables" in debt? Generally, no. Only interest-bearing financial liabilities and lease liabilities. Does S&P include "Activo Derivados Comerciales" (Commercial Derivatives Assets) as cash reduction? No. Does S&P include "Pasivo Derivados Comerciales" (Commercial Derivatives Liabilities) as debt? Generally, derivatives are excluded from debt unless they are financing derivatives. These are likely commercial hedging instruments. We will exclude them from debt. So, Net Debt = 12,316 million EUR. **3. Calculate FFO / Net Debt Ratio** $$FFO = 3,358 \text{ million EUR}$$ $$\text{Net Debt} = 12,316 \text{ million EUR}$$ $$\text{Ratio} = \frac{3,358}{12,316} \approx 0.2726$$ Let's consider if FFO should be higher. Sometimes "Other Adjustments To Reconcile Profit Loss" (1,525m) contains significant non-cash items that S&P adds back. The total adjustments to reconcile profit to operating cash flow (before working capital) is 3,057m. This includes D&A (1,532m). The remaining 1,525m includes: * Deferred taxes (non-cash) * Provisions (non-cash) * Share-based payments (non-cash) * Gains/Losses on disposals (non-cash/investing) * Equity income (non-cash) If we assume S&P adds back all non-cash operating items, FFO might be closer to: $Net Income (1,826) + \text{Total Non-Cash Operating Adjustments}$. However, FFO is not Operating Cash Flow. FFO excludes working capital changes but also excludes interest and taxes paid in the cash flow sense? No, FFO is an accrual-based metric. Standard S&P FFO for regulated utilities/energy: $FFO = \text{Net Income} + \text{D\&A} + \text{Impairment} + \text{Deferred Tax} + \text{Other Non-Cash}$. If we take the "Adjustments For Reconcile Profit Loss" of 3,057m, this is the sum of all non-cash items added back to Net Income to get to Operating Cash Flow *before* working capital changes. If we assume all these are valid add-backs for FFO (which is common for a quick estimate if specific line items aren't broken out), then: $FFO \approx \text{Net Income} + \text{Adjustments} = 1,826 + 3,057 = 4,883 \text{ million EUR}$. But wait, "Adjustments" usually includes changes in working capital? No, the line "Increase Decrease In Working Capital" is separate (-272m). So, $1,826 + 3,057 = 4,883$ is essentially "Cash Flow from Operations before Working Capital Changes". Is FFO equal to CFO before WC? S&P FFO is generally *lower* than CFO before WC because it doesn't add back *all* non-cash items (e.g., some gains/losses might be subtracted/added differently) and it is pre-interest/tax? No, Net Income is post-interest/tax. Actually, a very common proxy for FFO in European utilities is: $FFO = \text{EBITDA} - \text{Cash Interest} - \text{Cash Taxes}$. Let's try this approach. $EBITDA = 4,954 \text{ million}$. $Cash Interest$: Finance Costs were 837m. Interest Paid (Operating) was 520m. Interest Paid (Financing) is not listed separately, but "Interest Paid Classified As Operating Activities" is 520m. Usually, total interest paid is the cash outflow for interest. Let's assume 520m is the relevant cash interest (or potentially higher if some is capitalized or in financing). The difference between Finance Cost (837) and Interest Paid (520) is 317m. This could be due to capitalization, accruals, or lease interest. S&P usually deducts *cash* interest paid. $Cash Taxes$: Income Taxes Paid Classified As Operating Activities = 762m. $FFO = 4,954 - 520 - 762 = 3,672 \text{ million EUR}$. Let's compare the two FFO estimates: 1. Net Income + D&A = 3,358m. 2. EBITDA - Cash Interest - Cash Tax = 3,672m. The difference (314m) comes from: * Non-cash interest/tax differences. * Minority interests (Net Income includes minority share of profit, EBITDA is pre-minority). * Profit Attributable to Noncontrolling Interests = 177m. * If we use Net Income Attributable to Parent (1,649) + D&A (1,532) = 3,181m. * If we use Consolidated Net Income (1,826) + D&A (1,532) = 3,358m. * S&P ratios usually use Consolidated figures for both numerator and denominator. Let's look at the "Adjustments" again. If we use the definition $FFO = \text{Net Income} + \text{D\&A} + \text{Deferred Taxes} + \text{Other Non-Cash}$. Deferred Tax Expense (from P&L) = Total Tax (697) - Current Tax? Current Tax Liability change: $133 - 53 = 80$ decrease (paid more than expense?). Deferred Tax Asset change: 57 decrease (expense). Deferred Tax Liability change: 164 increase (benefit). Net Deferred Tax Benefit = 107m. So Cash Tax = Tax Expense (697) + Net Deferred Tax Benefit (107)? No. Tax Expense = Current Tax Expense + Deferred Tax Expense. If Deferred Tax is a benefit (negative expense), then Current Tax Expense must be higher. Cash Tax Paid = 762m. Let's stick to the most standard, conservative S&P approximation for FFO when detailed breakdowns are missing: **FFO = Net Income + Depreciation & Amortization.** $FFO = 1,826 + 1,532 = 3,358 \text{ million EUR}$. However, many analysts add back "Other Non-Cash Items" found in the reconciliation. The "Other Adjustments To Reconcile Profit Loss" is 1,525m. If we assume half of these are valid FFO add-backs (like impairments, deferred tax, share-based comp) and half are working-capital-like or investing-related (gains/losses), we might add ~500-700m. Let's look at "Gains On Disposals" (8m) and "Other Gains Losses" (-111m). These are small. "Share Of Other Comprehensive Income Of Associates" is OCI, not P&L. "Increase Decrease In Allowance" (-228m). Let's use the **EBITDA - Cash Interest - Cash Tax** method as it is robust for cash-generation based FFO proxies. $FFO = 3,672 \text{ million EUR}$. Let's calculate the ratio with both: 1. $3,358 / 12,316 = 0.27$ 2. $3,672 / 12,316 = 0.30$ S&P often reports FFO/Net Debt for Naturgy in the range of 0.25x - 0.35x. In 2022, Naturgy's leverage was improving. Let's check the debt again. Gross Debt = 16,301m. Cash = 3,985m. Net Debt = 12,316m. Is there any "Minority Interest" adjustment for FFO? S&P FFO is typically "Consolidated FFO". If we use the reported "Cash Flows From Operating Activities" (4,242m) and subtract Working Capital Changes (-272m) -> Add back WC decrease? WC change was -272m (Outflow? Or Inflow?). "Increase Decrease In Working Capital" = -272m. Usually, a negative number in cash flow statements for WC means an *increase* in assets or *decrease* in liabilities, which is a cash *outflow*. So CFO (4,242) = Operating Cash Flow before WC + WC Change. Operating Cash Flow before WC = $4,242 - (-272) = 4,514$? Or is the -272 already subtracted? Standard format: Net Income + Adjustments = Cash Flow before WC + WC Changes = CFO. Here, Adjustments (3,057) + Net Income (1,826) = 4,883. 4,883 + WC Change (-272) = 4,611. Then "Other Inflows Outflows" (-1,089). 4,611 - 1,089 = 3,522. Then Interest/Tax/Dividends? The reported CFO is 4,242. There is a discrepancy of ~700m. Likely "Other Inflows Outflows" includes interest and taxes paid? Interest Paid (Op) = 520. Tax Paid (Op) = 762. Sum = 1,282. If we add these back to CFO, we get Pre-Interest, Pre-Tax Operating Cash Flow. $4,242 + 520 + 762 = 5,524$. This is close to EBITDA (4,954) + Changes in WC/Other? EBITDA (4,954) is accrual. 5,524 is cash. S&P FFO is an accrual metric. Let's stick to **FFO = Net Income + D&A + Deferred Taxes + Impairments**. Net Income: 1,826 D&A: 1,532 Deferred Tax Benefit (add back? No, it's a non-cash gain, so subtract): -107 Impairments: Included in D&A line? "Amortizacion Y Perdidas Por Deterioro". Yes. Other Non-Cash: Share based payments? "Increase Decrease Through Sharebased Payment Transactions" in equity is small (-8m). Gains on disposal: -8. Other Gains/Losses: +111. FFO = $1,826 + 1,532 - 107 - 8 + 111 = 3,354$. Let's use **3,354 million EUR**. Ratio = $3,354 / 12,316 = 0.272$. Rounding to two decimal places, 0.27. 0.27