To estimate the FFO / Net Debt ratio for Acciona 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, but for leverage ratios involving total debt, it is common to use Consolidated Net Income or adjust for non-controlling interests if comparing to consolidated debt. However, the standard S&P definition for "FFO" usually refers to the cash flow available to service debt, often starting from Net Income including non-controlling interests or adjusting EBITDA. A common simplified proxy for S&P FFO is: Net Income + Depreciation & Amortization + Deferred Taxes + Other non-cash adjustments.* Let's look at the provided data for the period 2022-01-01 to 2023-01-01 (Fiscal Year 2022): * **Net Income (Profit Loss):** 615,000,000 EUR * *Note: This is the consolidated profit. S&P typically uses Net Income attributable to controlling interests for per-share metrics, but for coverage/leverage ratios against consolidated debt, we often look at the total entity's ability to generate cash. However, standard S&P FFO definition often adds back non-cash items to Net Income. Let's use the Consolidated Net Income of 615M.* * **Depreciation and Amortization:** The line item "Dotacion Amortizacion YVariacion De Provisiones" (Provision for Amortization and Variation of Provisions) is 762,000,000 EUR. * *Refinement:* S&P usually adds back D&A. The cash flow statement shows "Ajustes Por Amortizacion Variacion De Provisiones YDeterioros" (Adjustments for Amortization, Variation of Provisions and Impairment) as 848,000,000 EUR. This figure includes impairment and provision changes. The income statement shows "Impairment Loss..." as -15,000,000 EUR (a gain/reversal) and "Dotacion..." as 762,000,000 EUR. The difference between 848M and 762M is 86M, which likely relates to the impairment reversals and other non-cash working capital or provision adjustments not detailed fully. * Standard S&P FFO calculation: $$FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Impairment Charges} - \text{Impairment Reversals} + \text{Deferred Taxes} + \text{Other Non-Cash Items}$$ * Let's use the Cash Flow from Operations approach which is often a close proxy or starting point, but S&P makes specific adjustments. * Let's stick to the core components: * Net Income: 615,000,000 EUR * Add: Depreciation & Amortization (from "Dotacion Amortizacion..."): 762,000,000 EUR * Add: Deferred Tax Expense? The income tax expense is 254M. The change in deferred tax assets/liabilities affects cash but not necessarily FFO in the strictest sense if we are adding back non-cash charges. However, S&P often adds back deferred taxes. * Let's look at "Adjustments For Reconcile Profit Loss": 927,000,000 EUR. * Cash Flow from Operating Activities (CFO) = Net Income + Adjustments + Working Capital Changes. * CFO = 1,648,000,000 EUR. * S&P FFO is typically higher than CFO because it excludes changes in working capital (which are volatile) but includes other non-cash items. * A common S&P approximation: $FFO \approx \text{Net Income} + \text{D\&A} + \text{Deferred Taxes} + \text{Other Non-Cash}$. * Let's sum the explicit non-cash add-backs from the P&L/Cash Flow notes: * Net Income: 615,000,000 * D&A (Dotacion Amortizacion): 762,000,000 * Impairment Reversal (gain, so subtract): -15,000,000 (Wait, the line item is -15M. If it's a reversal of loss, it's a gain, reducing income. To get to cash/op flow, we subtract gains. But FFO adds back non-cash *charges*. A reversal is a non-cash *credit*. So we should subtract it from Net Income if it was included, or rather, since Net Income is already reduced/increased by it? * Let's check the sign. "Impairment Loss Reversal... -15,000,000". In many European reports, expenses are positive, income/gains are negative or vice versa. Given "Profit Loss" is positive 615M, and "Revenue" is positive, usually expenses are subtracted. If "Impairment Loss Reversal" is -15M, it likely means it *increased* profit (a gain). So Net Income includes this +15M gain. FFO should exclude this non-cash gain. So we subtract 15M. * Deferred Taxes: The tax expense is 254M. The cash tax paid is 215M. The difference is roughly the change in deferred tax balances. Change in Deferred Tax Assets: 920 -> 872 (Decrease of 48M, which is a source of cash/add-back). Change in Deferred Tax Liabilities: 813 -> 890 (Increase of 77M, source of cash/add-back). Net Deferred Tax add-back approx 48 + 77 = 125M. * Let's try a simpler S&P proxy: $FFO = \text{CFO} + \text{Cash Taxes Paid} + \text{Cash Interest Paid} - \text{Changes in Working Capital}$. This is getting complicated. * Let's use the standard definition: $FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Deferred Taxes} + \text{Other Non-Cash Items}$. * Net Income: 615,000,000 * D&A: 762,000,000 * Deferred Tax Expense (Non-cash portion): The total tax expense is 254M. The current tax liability change is 41->74 (increase 33M). The deferred tax asset change is 920->872 (decrease 48M). The deferred tax liability change is 813->890 (increase 77M). The non-cash tax expense is roughly the change in net deferred tax positions. Net Deferred Tax Liability increased by (77 - (-48))? No. * DTA decreased by 48M (Expense recognized, no cash out). * DTL increased by 77M (Expense recognized, no cash out). * Total Deferred Tax Expense added back: 48 + 77 = 125,000,000. * Other Non-Cash: * Impairment Reversal: -15,000,000 (Gain, subtract from NI or don't add back). Since NI includes it, and it's non-cash, we subtract it to remove the effect. * Share of profit of associates (Equity Method): -194,000,000. This is a non-cash loss included in NI. We add it back. * Gains/Losses on financial instruments at fair value: -70,000,000. This is a loss (expense) included in NI. It is non-cash. We add it back. * Gains/Losses on exchange differences: 8,000,000. This is a gain. Subtract it. * Let's recalculate FFO with these adjustments: * Net Income: 615,000,000 * + D&A: 762,000,000 * + Deferred Taxes: 125,000,000 * + Share of Loss of Associates: 194,000,000 (Add back non-cash loss) * + Fair Value Loss on Financial Instruments: 70,000,000 (Add back non-cash loss) * - Impairment Reversal: 15,000,000 (Subtract non-cash gain) * - Exchange Gain: 8,000,000 (Subtract non-cash gain) * + Other? The "Other Gains Losses" is 13,000,000. Assuming this is a gain, subtract 13,000,000. Sum: $615 + 762 + 125 + 194 + 70 - 15 - 8 - 13 = 1,730,000,000$ EUR. * Let's cross-check with CFO. CFO = 1,648,000,000. CFO includes working capital changes. FFO excludes them. Change in Working Capital = 135,000,000 (Positive inflow). If we take CFO (1,648) and add back the working capital improvement (since FFO ignores WC changes, and WC improvement boosted CFO, we might need to adjust? No, FFO is generally Net Income + Non-Cash. CFO is Net Income + Non-Cash + WC Changes. So, $FFO \approx CFO - \text{Change in WC} + \text{Other Adjustments?}$ Actually, S&P FFO is often very close to CFO if WC changes are small, but technically FFO *excludes* WC changes. If WC change is +135M (source of cash), then CFO is 135M higher than the operational accrual-based generation. So $FFO \approx 1,648 - 135 = 1,513$? Wait, the "Increase Decrease In Working Capital" in the cash flow is 135,000,000. Let's look at the components of WC change: Inventories: 1210 -> 1386 (Increase 176, use of cash) Receivables: 2731 -> 3340 (Increase 609, use of cash) Payables: 3148 -> 3889 (Increase 741, source of cash) Net WC Change roughly: -176 - 609 + 741 = -44? The cash flow statement says "Increase Decrease In Working Capital" is 135,000,000. This is a net source. Let's stick to the Net Income + Add-backs method which is more robust for S&P FFO. Recalculating carefully: 1. Net Income: 615 2. D&A: 762 3. Deferred Tax: 125 (Estimated from balance sheet changes in DTA/DTL) 4. Equity Income/Loss: The line "Resultado De Puesta En Equivalencia Operativa" is 159M (Income). The line "Share Of Profit Loss Of Associates... Using Equity Method" is -194M (Loss). Wait, there are two lines. "Resultado De Puesta En Equivalencia Operativa": 159,000,000. "Share Of Profit Loss Of Associates And Joint Ventures Accounted For Using Equity Method": -194,000,000. Usually, the equity method result is a single line. The -194M is likely the total share of loss. The 159M might be a sub-component or operating share? Looking at the P&L structure: Operating Profit: 1,334 Finance Income/Costs... Share of profit/loss of associates: -194. So the -194M is the non-cash loss included in Net Income. We add this back. What is the 159M? "Resultado De Puesta En Equivalencia Operativa". This might be included in Operating Profit? If so, it's already in the 1,334. The -194M is below operating profit? Let's check: 1334 (Op) + 47 (Fin Inc) - 256 (Fin Cost) + 8 (FX) - 70 (FV) - 194 (Equity) = 869 (Pre-tax). 1334 + 47 - 256 + 8 - 70 - 194 = 869. Correct. So the -194M is the non-cash equity loss. Add back 194. The 159M "Operativa" might be a disclosure detail, but the -194M is the actual P&L line item affecting Net Income. 5. Fair Value Loss: -70M. This is a non-cash loss. Add back 70. 6. Impairment Reversal: -15M. This is a non-cash gain. Subtract 15. 7. FX Gain: 8M. Non-cash gain. Subtract 8. 8. Other Gains/Losses: 13M. Assuming non-cash gain. Subtract 13. FFO = 615 + 762 + 125 + 194 + 70 - 15 - 8 - 13 = 1,730 Million EUR. * Alternative Check: S&P often defines FFO as Net Income + Depreciation + Amortization + Deferred Taxes + Other Non-Cash Items. * Let's check if "Other Noncurrent Assets" or other items imply more non-cash adjustments. * Let's assume FFO is approximately **1,730,000,000 EUR**. **2. Calculate Net Debt** Net Debt = Total Debt - Cash and Cash Equivalents. * **Total Debt:** * Noncurrent Financial Assets are assets, not debt. * Debt items: * "Participaciones Preferentes Obligaciones YOtros Valores Negociables No Corrientes1" (Non-current bonds/preferreds): 3,101,000,000 EUR * "Noncurrent Portion Of Noncurrent Loans Received": 2,624,000,000 EUR * "Noncurrent Lease Liabilities": 439,000,000 EUR * "Participaciones Preferentes Obligaciones YOtros Valores Negociables Corrientes" (Current bonds/preferreds): 1,139,000,000 EUR * "Current Loans Received And Current Portion Of Noncurrent Loans Received": 553,000,000 EUR * "Current Lease Liabilities": 72,000,000 EUR * S&P Methodology for Debt: Includes interest-bearing debt and lease liabilities. * Total Debt = 3,101 + 2,624 + 439 + 1,139 + 553 + 72 = **7,928,000,000 EUR**. * **Cash and Cash Equivalents:** * "Cash And Cash Equivalents" 2023-01-01: **2,360,000,000 EUR**. * Note: S&P may deduct restricted cash. We don't have that breakdown, so we use total CCE. * **Net Debt:** * Net Debt = 7,928,000,000 - 2,360,000,000 = **5,568,000,000 EUR**. **3. Calculate FFO / Net Debt Ratio** * Ratio = FFO / Net Debt * Ratio = 1,730,000,000 / 5,568,000,000 * Ratio ≈ 0.3107 Let's double check the FFO calculation. Sometimes S&P uses "EBITDA - Capex - Taxes - Interest" or similar proxies if detailed non-cash items aren't clear. EBITDA Proxy: Operating Profit: 1,334 + D&A: 762 EBITDA = 2,096 FFO is usually lower than EBITDA because it subtracts cash taxes and cash interest? No, FFO is a pre-interest, pre-tax metric in some contexts, but S&P FFO is effectively "Cash flow from operations before working capital changes and after tax/interest"? Actually, standard S&P FFO definition: $FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Deferred Taxes} + \text{Other Non-Cash Items}$. It does *not* subtract interest or taxes because they are already subtracted in Net Income. It adds back non-cash charges. So my calculation of 1,730M seems consistent with the definition. Let's refine the "Other Non-Cash Items". - Equity Loss (-194): Add back. - FV Loss (-70): Add back. - Impairment Reversal (-15): Subtract. - FX Gain (8): Subtract. - Other Gain (13): Subtract. - Deferred Tax: 125. Is there any other significant non-cash item? "Changes In Inventories..." is a working capital item, excluded from FFO (added back to CFO to get FFO? No, FFO ignores WC). "Dotacion Amortizacion" 762 is the main D&A. Let's check if the "Resultado De Puesta En Equivalencia Operativa" (159) is part of the -194. If -194 is the total, and 159 is operating, maybe the rest is non-operating? It doesn't matter for FFO, as the whole -194 is non-cash and included in Net Income. One potential adjustment: S&P sometimes adjusts for "Preferred Dividends" if calculating FFO to Common Equity, but for the ratio FFO/Net Debt, we use Consolidated FFO. Let's re-verify the Debt. S&P includes lease liabilities. Non-current leases: 439 Current leases: 72 Total Leases: 511. Interest-bearing debt: Non-current bonds: 3,101 Non-current loans: 2,624 Current bonds: 1,139 Current loans: 553 Total Interest Bearing Debt: 7,417. Total Debt = 7,417 + 511 = 7,928. Correct. Net Debt = 7,928 - 2,360 = 5,568. FFO = 1,730. Ratio = 1,730 / 5,568 = 0.3107. Let's consider if "FFO" should be higher. Some definitions of FFO add back *all* equity income/losses. I did that. Some add back *all* fair value adjustments. I did that. Is it possible D&A is higher? "Ajustes Por Amortizacion Variacion De Provisiones YDeterioros" in Cash Flow is 848. This includes the 762 D&A plus the 15 impairment reversal (which is a negative expense, so adds to cash flow relative to expense?) and other provision changes. If we use 848 instead of 762: FFO = 615 + 848 + 125 + 194 + 70 - 15 (already in 848?) - 8 - 13. The 848 figure is the cash flow adjustment. Net Income (615) + Adj (848) + Other Adj (79) = CFO before WC? CFO = 1,648. WC Change = 135. So Cash Flow from Ops before WC = 1,648 - 135 = 1,513. This 1,513 includes Cash Interest and Cash Taxes paid. S&P FFO is generally *before* interest and taxes? No, S&P FFO is derived from Net Income, so it is *after* interest and taxes. However, S&P *Leverage* ratios often use FFO as defined above. If FFO is ~1,513 (excluding WC changes from CFO), then: Ratio = 1,513 / 5,568 = 0.271. Let's look at the difference between my manual build (1,730) and the CFO-derived (1,513). Manual Build: 615 (NI) + 762 (D&A) + 125 (Def Tax) + 194 (Equity Loss) + 70 (FV Loss) - 15 (Imp Rev) - 8 (FX Gain) - 13 (Other Gain) = 1,730. CFO Derived: CFO = 1,648. Less WC Change = 135. Pre-WC CFO = 1,513. Why the difference? The "Adjustments For Reconcile Profit Loss" is 927. NI (615) + Adj (927) = 1,542. Then WC (135) -> 1,677? Then "Otros Flujos..." (-283) -> 1,394? Then Interest/Tax adjustments? The Cash Flow Statement structure provided is: Cash Flows From Operating Activities: 1,648. Adjustments For Reconcile Profit Loss: 927. Increase Decrease In Working Capital: 135. Otros Flujos De Efectivo De Actividades De Explotacion: -283. Interest Paid: 209. Interest Received: 40. Dividends Received: 89. Income Taxes Paid: 215. Standard Indirect Method: NI + Non-Cash Adj + WC Changes = CFO. 615 + 927 + 135 = 1,677. But reported CFO is 1,648. The difference is 29. There is a line "Otros Flujos... -283". This might be included in the 1,648 total but not in the simple sum above? Usually, CFO = NI + Adjustments + WC Changes + Other Operating Cash Flows. If "Otros Flujos" is -283, then 615 + 927 + 135 - 283 = 1,394. This is far from 1,648. Perhaps the "Adjustments" (927) *includes* the "Otros Flujos"? Unlikely. Perhaps Interest and Dividends are classified as Operating here? "Interest Paid Classified As Operating Activities": 209. "Interest Received...": 40. "Dividends Received...": 89. "Income Taxes Paid...": 215. If we assume the standard S&P FFO is close to **CFO + Cash Interest + Cash Taxes - WC Changes**? No, FFO is an accrual concept adjusted for non-cash. Let's stick to the 1,730 figure as it explicitly adds back the major non-cash items reported in the P&L. The discrepancy with CFO might be due to the "Otros Flujos" or timing differences in taxes/interest which are cash items subtracted in NI but added back in some FFO definitions? No, FFO is after tax/interest. However, a very common S&P metric is **FFO / Net Debt**. For industrial companies like Acciona, an FFO/Net Debt of 0.31 is reasonable (approx 3.2x Net Debt/FFO). Let's do a sanity check on Net Debt. Total Assets: 22,595. Total Equity: 6,304. Total Liabilities: 16,291. Debt is ~7.9B. Net Debt ~5.6B. EBITDA ~2.1B. Net Debt / EBITDA = 5.6 / 2.1 = 2.66x. FFO is usually lower than EBITDA? EBITDA (2,096) - Cash Tax (215) - Cash Interest (209-40=169) = 1,712. This is very close to my FFO estimate of 1,730. So FFO ≈ 1,712 - 1,730. Let's use 1,720 as a robust estimate. Ratio = 1,720 / 5,568 = 0.3089. Rounding to two decimal places: 0.31. 0.31