To estimate the FFO / Net Debt ratio for REDEIA CORPORACION SA (Red Eléctrica Corporación) for the year 2022 based on S&P methodology, we need to calculate two main 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} + \text{Change in Working Capital (sometimes excluded or adjusted, but standard FFO often starts with Net Income + D&A)}$$ However, a more precise S&P definition for utilities/regulated entities often starts with Net Income attributable to controlling interests, adds back depreciation and amortization, adds back deferred taxes, and adjusts for other non-cash items. A common simplified proxy used when detailed cash flow adjustments aren't fully broken out to the "S&P FFO" line item is: $$FFO \approx \text{Net Income Attributable to Owners} + \text{Depreciation & Amortization}$$ Let's look at the data provided for the period 2022-01-01 to 2023-01-01 (which represents the fiscal year 2022): * **Profit Loss Attributable To Owners Of Parent (Net Income):** 664,731,000 EUR * **Depreciation And Amortisation Expense:** 544,992,000 EUR Standard S&P FFO calculation also typically adds back **Deferred Tax Expense** because it is a non-cash charge in the context of operating cash flow generation for rating purposes, although sometimes it is left in if paid. Let's look at the tax line. * **Income Tax Expense Continuing Operations:** 188,330,000 EUR We can check the cash flow statement to see if there's a specific "FFO" or if we should derive it from Operating Cash Flow. * **Cash Flows From Used In Operating Activities:** 1,566,829,000 EUR S&P often defines FFO as Net Income + Depreciation + Amortization + Deferred Taxes + Other Non-Cash Charges - Non-Cash Credits. Let's try the standard additive approach: Net Income (Attributable to Parent): 664,731,000 + Depreciation & Amortization: 544,992,000 + Deferred Tax Expense (Change in Deferred Tax Liabilities - Change in Deferred Tax Assets): * Deferred Tax Liabilities 2023: 417,650,000; 2022: 397,811,000. Change: +19,839,000 * Deferred Tax Assets 2023: 69,217,000; 2022: 70,567,000. Change: -1,350,000 (Decrease in asset is an expense/add-back) * Total Deferred Tax Add-back approx: 19,839,000 + 1,350,000 = 21,189,000. Alternatively, we can look at the difference between Income Tax Expense (188,330,000) and Income Taxes Paid (363,996,000). The cash paid is higher, meaning deferred taxes might be negative or working capital tax changes are significant. S&P usually adds back the *expense* if it's non-cash, but here the cash outflow is higher. Let's stick to the core components often cited in simple estimations if detailed deferred tax breakdowns are ambiguous in the summary. A very common approximation for FFO in absence of a specific reported S&P FFO figure is: $$FFO = \text{Net Income} + \text{Depreciation & Amortization}$$ $$FFO = 664,731,000 + 544,992,000 = 1,209,723,000 \text{ EUR}$$ Let's refine this. S&P methodology for regulated utilities often includes **Minority Interest (Non-controlling interests)** in the debt and capitalization, but FFO is usually pre-minority interest or adjusted. Actually, S&P defines FFO as net income plus depreciation, amortization, and other non-cash items. It is generally calculated *before* deducting minority interests if the minority interests are treated as debt-like, or *after* if treated as equity. Red Eléctrica usually treats NCI as equity. The Net Income provided is "Attributable To Owners Of Parent". If we use Consolidated Net Income, it would be 681,187,000. Let's use Consolidated Net Income to be safe, as FFO is a group metric. Consolidated Net Income: 681,187,000 EUR + Depreciation & Amortization: 544,992,000 EUR = 1,226,179,000 EUR. Let's check if there are other significant non-cash items. "Participacion En Beneficios De Sociedades Valoradas Por El Metodo De La Participacion" (Equity Income): 50,405,000 EUR. This is included in Net Income but is non-cash (unless dividends received). Dividends received from equity method investees are often added back if the income was accrued, or the income is subtracted and dividends added. The cash flow statement shows "Dividends Received Classified As Operating Activities" of 7,578,000. The equity income is 50,405,000. The difference (42,827,000) is non-cash accrual. So we should subtract the undistributed equity income. Adjustment: - (50,405,000 - 7,578,000) = -42,827,000. Revised FFO Estimate: Net Income (Consolidated): 681,187,000 + D&A: 544,992,000 - Undistributed Equity Income: 42,827,000 + Deferred Taxes (Non-cash portion): Income Tax Expense: 188,330,000 Income Tax Paid: 363,996,000 The company paid *more* tax than the expense, so deferred taxes were likely a benefit (negative expense) or prior year liabilities were paid. The change in Deferred Tax Liab/Asset was roughly +21M expense. The cash paid is much higher due to working capital tax movements (Current Tax Assets/Liabilities). Current Tax Assets increased from 7.5M to 182.5M (Use of cash/asset increase). Current Tax Liabilities increased from 10.8M to 13.3M. This suggests the high tax payment is partly due to settling prior obligations or timing. For S&P FFO, we typically add back the Deferred Tax *Expense* found in the P&L. If the P&L tax expense is 188M and Cash Paid is 364M, the Deferred Tax component in the P&L was likely negative (a benefit) or small. Let's look at the Balance Sheet changes again. DTL Change: +19.8M. DTA Change: -1.35M. Net Deferred Tax Expense in P&L should be around +21M. Current Tax Expense = Total Tax Expense (188.3M) - Deferred Tax Expense (21.2M) = 167.1M. Cash Paid for Taxes = 364M. The difference between Current Tax Expense (167M) and Cash Paid (364M) is explained by the change in Current Tax Assets/Liabilities. S&P FFO adds back Deferred Tax Expense. So we add back ~21.2M. Let's recalculate FFO: 1. Consolidated Net Income: 681,187,000 2. Add: Depreciation & Amortization: 544,992,000 3. Add: Deferred Tax Expense: ~21,189,000 4. Less: Undistributed Equity Earnings: (50,405,000 - 7,578,000) = 42,827,000 5. Add/Subtract Other Non-Cash: "Deterioro YResultado Por Enajenaciones..." (Impairment/Gains on disposal): 488,000 (Loss/Expense). Add back 488,000. "Gains Losses On Financial Assets...": 1,196,000 (Gain). Subtract 1,196,000. "Gains Losses On Exchange...": 74,000 (Gain). Subtract 74,000. FFO = 681,187,000 + 544,992,000 + 21,189,000 - 42,827,000 + 488,000 - 1,196,000 - 74,000 FFO ≈ 1,203,759,000 EUR. Let's double check with the "Cash Flow from Operations" approach which is often a good proxy for FFO + Working Capital Changes. CFO = 1,566,829,000. S&P FFO is roughly CFO + Interest Paid (if classified as financing) - Changes in Working Capital. In this report, Interest Paid is classified as Operating Activities (123,524,000). So CFO already includes interest outflow. S&P FFO is pre-interest. So we should add back Interest Paid. CFO (1,566,829,000) + Interest Paid (123,524,000) = 1,690,353,000 (This is roughly Unlevered Operating Cash Flow before WC changes and taxes? No, CFO is after tax). Actually, the standard reconciliation is: FFO = Net Income + D&A + Deferred Taxes + Other Non-Cash. The result ~1.204 Billion seems reasonable relative to Net Income of 0.68B and D&A of 0.54B. Let's use **1,204,000,000 EUR** as the estimated FFO. **2. Calculate Net Debt** S&P Net Debt = Gross Debt - Cash and Cash Equivalents. Gross Debt includes Short-term and Long-term Financial Liabilities (Borrowings). It typically excludes trade payables and provisions. From the Balance Sheet at 2023-01-01 (End of 2022): * **Noncurrent Financial Liabilities:** 5,543,755,000 EUR * Longterm Borrowings: 5,491,124,000 EUR * Other Noncurrent Financial Liabilities: 52,631,000 EUR * **Current Financial Liabilities:** 1,705,277,000 EUR * Current Borrowings And Current Portion Of Noncurrent Borrowings: 721,845,000 EUR * Other Current Financial Liabilities: 983,432,000 EUR We need to determine what constitutes "Debt". S&P typically includes all interest-bearing debt. "Longterm Borrowings" and "Current Borrowings" are clearly debt. "Other Noncurrent Financial Liabilities" and "Other Current Financial Liabilities" often contain derivatives or other instruments. The report lists "Noncurrent Derivative Financial Liabilities" (22,016,000) and "Current Derivative Financial Liabilities" (7,053,000) separately in the notes, but they might be included in the "Other" or "Financial Liabilities" totals. Usually, S&P excludes derivatives from Gross Debt unless they are synthetic debt. We should check if "Other Financial Liabilities" are primarily derivatives. Total Derivatives Liabilities = 22,016,000 + 7,053,000 = 29,069,000 EUR. Total "Other" Financial Liabilities = 52,631,000 (Noncurrent) + 983,432,000 (Current) = 1,036,063,000 EUR. The Current "Other" is very large (983M). This likely includes short-term commercial paper or other funding instruments, not just derivatives. Given the magnitude, it is safer to include "Current Financial Liabilities" and "Noncurrent Financial Liabilities" as Gross Debt, or specifically the "Borrowings" lines if "Other" is ambiguous. However, looking at the Cash Flow statement, "Cobros Pagos Por Instrumentos De Pasivo Financiero" (Proceeds/Payments for Financial Liability Instruments) is -1,141,718,000. This suggests active management of these liabilities. Standard practice for Red Eléctrica: Gross Debt is usually defined as Long-term Borrowings + Short-term Borrowings + Current portion of long-term debt. Let's sum the explicit Borrowings: Long-term Borrowings: 5,491,124,000 Current Borrowings: 721,845,000 Total Explicit Borrowings = 6,212,969,000 EUR. What about the "Other Financial Liabilities"? If we look at the ratio of "Other Current Financial Liabilities" (983M) to "Current Borrowings" (721M), it's significant. In many utility reports, "Other Current Financial Liabilities" can include accrued interest, dividends payable, or short-term notes. If they are interest-bearing, they are debt. If they are trade-related or accruals, they are not. Given the label "Financial Liabilities", they are likely interest-bearing or funding-related. S&P generally includes all financial liabilities that are debt-like. Let's assume Gross Debt = Noncurrent Financial Liabilities + Current Financial Liabilities. Gross Debt = 5,543,755,000 + 1,705,277,000 = 7,249,032,000 EUR. Let's subtract Cash and Cash Equivalents. Cash And Cash Equivalents (2023-01-01): 794,824,000 EUR. Net Debt = Gross Debt - Cash Net Debt = 7,249,032,000 - 794,824,000 = 6,454,208,000 EUR. *Alternative Conservative Debt Calculation:* If we only count "Borrowings": Gross Debt = 5,491,124,000 + 721,845,000 = 6,212,969,000. Net Debt = 6,212,969,000 - 794,824,000 = 5,418,145,000. Which definition does S&P use? S&P uses "Debt" which is broadly defined as all obligations that rank equal to or senior to unsecured senior debt. This typically includes bank loans, bonds, commercial paper, and capital leases. It excludes trade payables, accrued expenses, and pension liabilities. "Other Current Financial Liabilities" of 983M is very high. Let's look at the previous year. 2022-01-01: Other Current Financial Liabilities = 752,703,000. 2022-01-01: Current Borrowings = 1,391,722,000. The sum of Current Financial Liabilities is ~2.14B. The sum of Noncurrent Financial Liabilities is ~5.95B. Total Financial Liabilities 2022 start: ~8.1B. Total Financial Liabilities 2023 start: ~7.25B. Red Eléctrica's annual reports typically define "Net Debt" as Financial Liabilities (Long and Short term) minus Cash. Financial Liabilities usually comprise: - Long-term borrowings - Short-term borrowings - Derivatives (sometimes excluded from Net Debt for leverage ratios if marked to market, but often included in gross debt if they are hedges). S&P often adjusts debt to exclude the mark-to-market of derivatives if they are hedging operational risk, or includes the notional if synthetic. However, for simple "Net Debt" calculation from balance sheet lines, we usually take the book value of financial liabilities. Let's check the size of derivatives again: ~29M. This is small compared to the 983M "Other". The 983M is likely Commercial Paper or similar short-term debt instruments. Therefore, it should be included in Gross Debt. So, Gross Debt = 7,249,032,000 EUR. Cash = 794,824,000 EUR. Net Debt = 6,454,208,000 EUR. **3. Calculate the Ratio** FFO / Net Debt = 1,204,000,000 / 6,454,208,000 Calculation: 1,204 / 6,454.2 ≈ 0.1865 Let's refine the FFO number slightly. If we use Net Income Attributable to Parent (664.7M) instead of Consolidated (681.2M): FFO = 664,731,000 + 544,992,000 + 21,189,000 - 42,827,000 (equity adjustment might differ if NCI is involved, but equity income is usually at parent level or consolidated. The line "Participacion En Beneficios..." is usually consolidated equity income). If we stick to Consolidated Net Income (681.2M), we must ensure we aren't double counting NCI. FFO is a group metric. Let's check Red Eléctrica's reported FFO in recent years. In 2021, Red Eléctrica reported FFO around 1.1-1.2B. For 2022, with Net Income ~681M and D&A ~545M, the base is 1.226B. Adjustments: - Deferred Tax: +21M - Equity Income non-cash: -43M - Other: ~0 FFO ≈ 1.204B. Net Debt: End of 2022 Net Debt. Gross Debt: 7,249M. Cash: 795M. Net Debt: 6,454M. Ratio: 1,204 / 6,454 = 0.1865. Let's consider if "Net Debt" should be average or year-end. S&P typically uses year-end debt for the ratio denominator unless specified otherwise (often they use average debt for return on capital, but for leverage FFO/Debt, year-end is common, or sometimes average). Given the prompt asks for "the ratio for 2022", and provides year-end balance sheet data for 2022 (dated 2023-01-01), we use year-end 2022 debt. Is there any other debt-like item? "Noncontrolling Interests" are sometimes treated as debt by S&P if they have mandatory redemption features. For Red Eléctrica, NCI is usually treated as equity. "Lease Liabilities"? Under IFRS 16, lease liabilities are included in Financial Liabilities. The lines "Longterm Borrowings" and "Current Borrowings" likely include lease liabilities or they are in "Other". If they are in "Other", they are already included in our Gross Debt figure. Let's double check the "Other Current Financial Liabilities". In 2022, Red Eléctrica had significant commercial paper programs. This confirms the inclusion of "Other Current Financial Liabilities" in Debt. Final Check of Numbers: FFO ≈ 1,204 million EUR. Net Debt ≈ 6,454 million EUR. Ratio ≈ 0.1865. Rounding to two decimal places: 0.19. Rounding to three decimal places: 0.187. Let's try a slightly different FFO calculation often used by analysts: EBITDA - Interest - Taxes + Deferred Taxes? EBITDA = Operating Profit + D&A. Operating Profit (Profit Loss From Operating Activities) = 961,554,000. EBITDA = 961,554,000 + 544,992,000 = 1,506,546,000. Less Interest (Finance Costs): 116,468,000. Less Taxes (Cash Taxes? or Current Tax Expense?): If we use Cash Taxes paid: 363,996,000. FFO Proxy = EBITDA - Interest - Cash Taxes + Deferred Tax Addback? This gets complicated. The Net Income + D&A method is more robust if we trust the Net Income figure. Let's verify the "Finance Costs". Finance Costs: 116,468,000. Finance Income: 23,161,000. Net Finance Cost: 93,307,000. S&P FFO is pre-interest? No, FFO is after interest and tax. Wait, standard FFO (NAREIT) is Net Income + D&A. S&P FFO for corporates is often defined as: Net Income + D&A + Deferred Taxes + Other Non-Cash. This matches my previous calculation. Result: 0.1865. Let's check if the denominator should be Average Net Debt. Net Debt 2021 (2022-01-01): Gross Debt 2021: Noncurrent Fin Liab: 5,953,434,000 Current Fin Liab: 2,144,425,000 Total Gross: 8,097,859,000 Cash 2021: 1,574,427,000 Net Debt 2021: 6,523,432,000 Net Debt 2022 (2023-01-01): 6,454,208,000 Average Net Debt = (6,523,432,000 + 6,454,208,000) / 2 = 6,488,820,000. Ratio with Average Debt: 1,204,000,000 / 6,488,820,000 = 0.1855. The difference is minimal (0.186 vs 0.185). S&P often uses year-end debt for snapshot leverage ratios in public commentary unless calculating trend averages. I will provide the year-end based ratio as it is the most direct interpretation of "ratio for 2022" using the provided ending balances. Value: 0.1865 -> 0.19 or 0.187. I will provide 0.19. 0.19