# FFO / Adjusted_Debt Analysis for REDEIA CORPORACION SA ## Step 1: Identify Relevant Industry REDEIA Corporación, S.A. is the operator of Spain's electricity transmission network. It is a **regulated utility** operating in the electricity transmission sector. It meets all criteria for the "Regulated Utilities" industry classification: - Essential infrastructure service (electricity transmission) - Subject to comprehensive regulatory oversight - Operates under a stable regulatory framework in Spain - Network/transmission business model **Industry Methodology:** Regulated Utilities --- ## Step 2: Estimate Adjusted_EBITDA ### Extract Operating Data for 2022 (fiscal year ended Dec 31, 2022): From the income statement for period 2021-01-01 to 2022-01-01: - Revenue: 1,952,958,000 EUR - Profit from Operating Activities (EBIT): 991,970,000 EUR - Depreciation and Amortisation Expense: 522,114,000 EUR **EBITDA Reconstruction:** ``` EBITDA = EBIT + Depreciation & Amortisation EBITDA = 991,970,000 + 522,114,000 EBITDA = 1,514,084,000 EUR ``` ### Adjustments per S&P Methodology for Regulated Utilities: For regulated utilities with strong regulatory frameworks like REDEIA: - **Lease adjustments:** Operating leases are minimal for transmission operators; no material adjustment needed - **Nonrecurring items:** - Gains/losses on asset disposals: -730,000 EUR (loss, add back) - **Government grants:** - Imputacion De Subvenciones: 14,717,000 EUR (non-cash benefit, subtract) - **Pension adjustments:** Limited evidence of material pension obligations; no adjustment required - **Joint venture adjustments:** Equity method income of 29,546,000 EUR should be added back to normalize for proportional contribution ``` Adjusted_EBITDA = 1,514,084,000 + 730,000 - 14,717,000 + 29,546,000 Adjusted_EBITDA = 1,529,643,000 EUR ``` --- ## Step 3: Estimate FFO (Free Cash Flow Available for Debt Service) ### Formula: ``` FFO = Adjusted_EBITDA - Cash_Interest - Cash_Taxes ``` ### Extract Cash Flow Data for 2022: From the cash flow statement for period 2021-01-01 to 2022-01-01: - Interest Paid (Operating Activities): 121,920,000 EUR - Income Taxes Paid (Operating Activities): 181,263,000 EUR ### Calculate FFO: ``` FFO = 1,529,643,000 - 121,920,000 - 181,263,000 FFO = 1,226,460,000 EUR ``` --- ## Step 4: Estimate Adjusted_Debt ### Extract Debt Components as of 2022-01-01 (end of fiscal year 2022): **Reported Debt:** - Longterm Borrowings: 5,896,170,000 EUR - Current Borrowings and Current Portion of Noncurrent Borrowings: 1,391,722,000 EUR - Other Noncurrent Financial Liabilities: 57,264,000 EUR - Other Current Financial Liabilities: 752,703,000 EUR **Total Reported Debt:** ``` Reported_Debt = 5,896,170,000 + 1,391,722,000 + 57,264,000 + 752,703,000 Reported_Debt = 8,097,859,000 EUR ``` ### Adjustments per S&P Methodology for Regulated Utilities: **Lease Adjustments:** - Operating leases are not separately disclosed; minimal adjustment estimated at 0 EUR **Pension Adjustments:** - No significant pension deficit disclosed; assessment shows stable pension position - Adjustment: 0 EUR **Government Grants (Noncurrent):** - Per S&P guidance, government grants that are non-repayable should be excluded from debt - Noncurrent Government Grants: 726,002,000 EUR (deduct from adjusted debt) **Guarantees and Other Debt-like Items:** - No material guarantees disclosed; adjustment: 0 EUR **Hybrid Debt:** - No hybrid instruments identified in the capital structure; adjustment: 0 EUR **Eligible Cash and Equivalents:** - Cash and Cash Equivalents (2022-01-01): 1,574,427,000 EUR - Per S&P guidance for regulated utilities, the full amount of cash can typically be deducted as it is not needed for operations ### Calculate Adjusted_Debt: ``` Adjusted_Debt = Reported_Debt - Government_Grants - Eligible_Cash Adjusted_Debt = 8,097,859,000 - 726,002,000 - 1,574,427,000 Adjusted_Debt = 5,797,430,000 EUR ``` --- ## Step 5: Calculate FFO / Adjusted_Debt Ratio ``` FFO / Adjusted_Debt = 1,226,460,000 / 5,797,430,000 FFO / Adjusted_Debt = 0.211493... ``` Rounded to four decimal places: 0.2115