To estimate the Net Debt / EBITDA ratio for Enel SpA for the year 2022 based on the S&P methodology, we need to calculate two components: Net Debt and EBITDA. **1. Calculate Net Debt** S&P defines Net Debt generally as Total Debt minus Cash and Cash Equivalents (and sometimes short-term investments). Total Debt includes short-term and long-term borrowings. From the provided data for the period ending 2023-01-01 (which represents the balance sheet at the end of 2022): * **Long-term Borrowings:** 68,191,000,000 EUR * **Short-term Borrowings:** 18,392,000,000 EUR * **Current Portion of Long-term Borrowings:** 2,835,000,000 EUR * *Note: In many financial reports, "Short-term Borrowings" and "Current Portion of Long-term Borrowings" are distinct line items. We must sum all interest-bearing debt obligations.* * Total Debt = Long-term Borrowings + Short-term Borrowings + Current Portion of Long-term Borrowings * Total Debt = 68,191,000,000 + 18,392,000,000 + 2,835,000,000 = 89,418,000,000 EUR * **Cash and Cash Equivalents:** 11,041,000,000 EUR * *Note: The report also lists "Short-term Investments Classified As Cash Equivalents" of 78,000,000 EUR and "Cash And Cash Equivalents Classified As Part Of Disposal Group Held For Sale" of 98,000,000 EUR. The main line item "Cash And Cash Equivalents" (11,041,000,000) usually aggregates the continuing operations cash. The breakdown shows "Cash And Cash Equivalents Of Continuing Operations" is 11,041,000,000. S&P typically deducts unrestricted cash and cash equivalents. We will use the total Cash and Cash Equivalents reported on the balance sheet.* * Cash = 11,041,000,000 EUR * **Net Debt** = Total Debt - Cash * Net Debt = 89,418,000,000 - 11,041,000,000 = **78,377,000,000 EUR** **2. Calculate EBITDA** EBITDA stands for Earnings Before Interest, Taxes, Depreciation, and Amortization. We can derive this from the "Profit Loss From Operating Activities" (also known as Operating Profit or EBIT) and add back Depreciation and Amortization. From the provided data for the period 2022-01-01 to 2023-01-01: * **Profit Loss From Operating Activities:** 11,193,000,000 EUR * **Depreciation Amortisation And Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss:** 7,447,000,000 EUR * *Note: This line item includes impairment reversals. To be precise, EBITDA adds back Depreciation and Amortization. The label suggests it includes impairment reversals which are subtracted in the P&L to arrive at operating profit? Or added? Usually, impairment losses are expenses (subtracted), so reversals are income (added). If the figure 7,447,000,000 is the net amount recognized in P&L, we need to be careful. However, standard EBITDA calculations often use "EBIT + Depreciation + Amortization".* * Let's look at the Cash Flow statement adjustments for a clearer picture of D&A. * "Adjustments For Depreciation And Amortisation Expense And Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss": 8,809,000,000 EUR. This figure is significantly higher. Why? * Let's stick to the standard definition: EBITDA = Operating Profit + Depreciation + Amortization. * The line "Depreciation Amortisation And Impairment Loss Reversal..." (7,447,000,000) seems to be the specific P&L charge/credit. * However, S&P often uses EBITDA as reported by the company or calculated as Operating Income + D&A. * Let's check if there is a more direct EBITDA figure or if we should use the Cash Flow adjustment. The Cash Flow adjustment (8,809,000,000) likely includes non-cash items beyond just D&A or handles impairments differently. * Let's look at the components of Operating Expense. * Operating Revenue: 140,517,000,000 * Operating Expense: 131,689,000,000 * Operating Profit: 11,193,000,000 (Matches 140,517 - 131,689 + Other Income/Expenses? Let's check: 140,517 - 131,689 = 8,828. The difference is due to "Other Income" (4,864) and "Other Expense" (4,685) and "Net Results From Commodity Contracts" (2,365) and "Other Work Capitalised" (3,415). * Actually, "Profit Loss From Operating Activities" is explicitly given as 11,193,000,000. Let's add back Depreciation and Amortization. The line item "Depreciation Amortisation And Impairment Loss Reversal..." is 7,447,000,000. If we assume this is the net D&A charge: EBITDA = 11,193,000,000 + 7,447,000,000 = **18,640,000,000 EUR**. *Alternative Check:* Sometimes "EBITDA" is approximated by Operating Cash Flow + Interest Paid + Taxes Paid + Changes in Working Capital? No, that's circular. Let's look at the "Adjustments For Depreciation..." in Cash Flow: 8,809,000,000. This is much higher. The difference between 8,809 and 7,447 is 1,362. This could be due to impairments or other non-cash items included in the cash flow add-back but not in the specific D&A line, or vice versa. Standard S&P methodology usually starts with EBIT (Operating Profit) and adds back D&A. The line "Depreciation Amortisation And Impairment Loss Reversal..." is the most direct source for D&A. However, if impairments are significant, they might distort it. Let's look at "Impairment Loss Reversal... Trade Receivables": 1,278,000,000. This is a reversal (income). If the 7,447,000,000 figure *includes* the reversal (i.e., net expense), then adding it back is correct for D&A if the reversal is considered part of that line. However, often EBITDA excludes impairment charges/reversals. If the 7,447,000,000 is net of a 1,278,000,000 reversal, the gross D&A might be higher? Or is the reversal separate? The label says "Depreciation Amortisation AND Impairment Loss Reversal...". This implies the figure is a net sum. If we use the Cash Flow statement adjustment of 8,809,000,000, it is labeled "Adjustments For Depreciation And Amortisation Expense And Impairment Loss Reversal...". Let's assume the standard EBITDA calculation: EBITDA = Operating Profit + Depreciation + Amortization. Using the explicit D&A line: 11,193 + 7,447 = 18,640 million. Let's consider if "Net Results From Commodity Contracts" (2,365) is considered operating. Yes, it's included in Operating Profit. Let's refine the Net Debt calculation. Does S&P include "Lease Liabilities" in debt? The data doesn't explicitly break out lease liabilities, but they are often part of borrowings or other liabilities. Without explicit data, we stick to Borrowings. Let's refine the Cash deduction. S&P deducts "Cash and short-term investments". Cash: 11,041 Short-term investments classified as cash equivalents: 78 Total Cash & Equivalents: ~11,119 (if we add the 78). The balance sheet line "Cash And Cash Equivalents" is 11,041. The breakdown shows "Cash And Cash Equivalents Of Continuing Operations" is 11,041. The 78 is likely included or separate? Looking at the assets: Current Assets: 66,063 (excluding held for sale) + 6,149 (held for sale) = 72,212? Let's sum current assets components: Inventories: 4,853 Trade Receivables: 16,605 Contract Assets: 106 Tax Assets: 561 Derivative Assets: 14,830 Other Financial Assets: 13,753 Other Assets: 4,314 Cash: 11,041 Sum = 4,853+16,605+106+561+14,830+13,753+4,314+11,041 = 66,063. So the 11,041 figure is the total cash and cash equivalents reported in the main current assets block. The "Short-term Investments Classified As Cash Equivalents" (78) and "Disposal Group" (98) and "Discontinued Ops" (326) seem to be supplementary disclosures or subsets. Wait, the sum of the components equals 66,063 exactly. So Cash = 11,041. Net Debt = 89,418 - 11,041 = 78,377. Now, EBITDA. If we use the Cash Flow adjustment for D&A (8,809), EBITDA = 11,193 + 8,809 = 20,002. If we use the P&L line (7,447), EBITDA = 11,193 + 7,447 = 18,640. Which one is more appropriate for S&P? S&P typically adjusts for non-recurring items. The difference between 8,809 and 7,447 is 1,362. The "Impairment Loss Reversal... Trade Receivables" is 1,278. If the 7,447 figure *nets* the reversal (i.e., D&A Expense - Reversal), then adding it back adds back the net amount. However, EBITDA should ideally add back the gross D&A expense and exclude the impairment reversal (treat it as non-operating or below EBITDA). If 7,447 is net of a 1,278 reversal, then Gross D&A = 7,447 + 1,278 = 8,725? Then EBITDA = 11,193 + 8,725 = 19,918. Let's look at the Cash Flow adjustment again: 8,809. This is very close to 8,725. The difference might be other small impairments. Using the Cash Flow adjustment is often a safer proxy for "Cash EBITDA" or adjusted EBITDA in the absence of a specific management EBITDA figure, as it adds back the non-cash charges actually deducted. Let's try to calculate EBITDA using the "Profit Loss From Operating Activities" and adding back the "Adjustments For Depreciation..." from the cash flow statement, as this represents the non-cash charges removed to get to operating cash flow (before working capital changes). EBITDA ≈ Operating Profit + D&A (from CF) EBITDA = 11,193 + 8,809 = 20,002 million EUR. Let's double check if "Profit Loss From Operating Activities" is before or after the impairment reversals. The line "Impairment Loss Reversal... Trade Receivables" (1,278) is likely included in Operating Profit. If we add back the full 8,809 (which includes the reversal adjustment), we are effectively saying: Operating Profit (which includes +1,278 reversal and -D&A Expense) + D&A Expense - Reversal? The Cash Flow line "Adjustments For Depreciation... And Impairment Loss Reversal" usually means: Add back Depreciation (expense) and Add back Impairment Loss (expense) or Subtract Reversal (income). If it's a reversal, it's a negative expense (income). In the Cash Flow indirect method, you subtract gains/reversals from Net Income/Operating Profit to reconcile to Cash. If the figure 8,809 is a positive number in the "Adjustments" section, it usually means it was an expense added back. However, the label says "And Impairment Loss Reversal". If the reversal is 1,278, and it's a gain, it should be subtracted in the CF reconciliation. If the total adjustment is 8,809, and it includes D&A (say 9,000) and Reversal (-1,278), the net would be 7,722. But the P&L line is 7,447. Let's look at Enel's actual reporting conventions. Enel typically reports "EBITDA" in its annual report. In 2022, Enel's reported EBITDA was approximately **20.1 billion EUR** (based on external knowledge of Enel's 2022 results, EBITDA was ~20.1bn). Let's see which calculation gets us close to 20.1bn. Calculation A: 11,193 + 7,447 = 18,640. (Too low) Calculation B: 11,193 + 8,809 = 20,002. (Very close to 20.1bn) Therefore, the EBITDA figure derived from adding the Cash Flow adjustment (8,809) to Operating Profit (11,193) is the most accurate reflection of the company's EBITDA, likely because the P&L line "Depreciation..." netted out impairments/reversals or didn't include all amortization/depreciation components (e.g., from joint ventures or other comprehensive income items, though unlikely for EBITDA). The Cash Flow adjustment is the standard "add-back" for non-cash operating items. So, EBITDA = 20,002,000,000 EUR. **3. Calculate Ratio** Net Debt = 78,377,000,000 EUR EBITDA = 20,002,000,000 EUR Ratio = 78,377 / 20,002 ≈ 3.918 Let's refine the Debt. S&P Net Debt often includes: - Short term debt - Long term debt - Capital leases (if not in debt, but usually are) - Preferred stock (sometimes treated as debt) - Minus Cash Enel has "Equity Instruments Perpetual Hybrid Bonds" of 5,567,000,000 EUR. S&P often treats hybrid bonds as 50% equity and 50% debt, or fully debt depending on the terms. If treated as debt, Net Debt increases. However, standard "Net Debt" calculations for covenants or general leverage often stick to interest-bearing borrowings. If we include 50% of Hybrids (2,783) as debt: Net Debt = 78,377 + 2,783 = 81,160. Ratio = 81,160 / 20,002 = 4.05. If we include 100% of Hybrids: Net Debt = 78,377 + 5,567 = 83,944. Ratio = 83,944 / 20,002 = 4.19. Standard S&P "Debt/EBITDA" for ratings usually adjusts debt to include hybrids. However, the prompt asks for "Net Debt / EBIDTA ... based on S&P methodology". S&P Global Ratings' methodology for "Debt" includes: - Short-term and long-term borrowings - Capital leases - Preferred stock (if mandatory redeemable or high yield) - Hybrid securities (typically 50% equity credit, so 50% counts as debt). Let's assume the 50% equity credit for hybrids. Adjusted Debt = Reported Borrowings + 0.5 * Hybrid Bonds Reported Borrowings = 89,418 Hybrid Bonds = 5,567 Adjusted Debt = 89,418 + 2,783.5 = 92,201.5 Adjusted Net Debt = 92,201.5 - 11,041 = 81,160.5 EBITDA = 20,002 Ratio = 81,160.5 / 20,002 = 4.057 Let's check if there are other debt-like items. "Noncurrent Derivative Financial Liabilities" and "Current Derivative Financial Liabilities" are usually marked-to-market and not considered principal debt, though S&P might look at gross debt. We stick to borrowings. Is there any other cash to deduct? "Short-term Investments Classified As Cash Equivalents" (78) is likely already in the 11,041 or separate? In the asset sum, 11,041 was the cash line. The 78 was a separate disclosure line "Shortterm Investments Classified As Cash Equivalents". Usually, "Cash and Cash Equivalents" on the balance sheet includes short-term investments that meet the definition. The sum of current assets (66,063) included the 11,041 line. It did NOT explicitly include a separate 78 line item in the summation I did earlier? Let's re-verify the Current Assets sum. Inventories 4,853 Trade Rec 16,605 Contract Assets 106 Tax Assets 561 Deriv Assets 14,830 Other Fin Assets 13,753 Other Assets 4,314 Cash 11,041 Sum = 66,063. This matches "Current Assets Other Than Assets... Held For Sale" (66,063). So the 78 is likely a subset of the 11,041 or a memo item. Given the label "Classified As Cash Equivalents", it is part of the Cash balance. So we deduct 11,041. So, Net Debt (Standard) = 78,377. Net Debt (S&P Adjusted with 50% Hybrid) = 81,160. EBITDA = 20,002. Ratio = 4.06. If we do NOT adjust for hybrids (strict Net Debt = Borrowings - Cash): Ratio = 78,377 / 20,002 = 3.92. S&P Methodology specifically for *ratings* adjusts debt. The prompt asks for "Net Debt / EBIDTA ... based on the S&P methodology". This implies the rating agency's definition of debt. S&P defines "Debt" as: "Our definition of debt includes... hybrid securities... We typically apply a 50% equity credit to hybrid securities..." So Debt = Borrowings + 50% Hybrids. Let's calculate the final value. Debt = 89,418 + (0.5 * 5,567) = 89,418 + 2,783.5 = 92,201.5 Cash = 11,041 Net Debt = 81,160.5 EBITDA = 20,002 Ratio = 4.0576... Rounding to two decimal places: 4.06. Let's double check the EBITDA calculation. Operating Profit: 11,193 Add: Depreciation/Amortization/Impairment Adjustment from CF: 8,809 EBITDA = 20,002. Is there any other adjustment? S&P EBITDA usually adds back share-based compensation? "Increase Decrease Through Sharebased Payment Transactions": 8,000,000 (8 million). Negligible. S&P EBITDA adds back restructuring? "Other Expense By Nature": 4,685. This is large. Is it restructuring? Enel's 2022 report shows "Other expenses" include grid services, taxes, etc. Not necessarily restructuring. Without specific "Restructuring" labels, we assume Operating Profit is a good starting point. One detail: "Profit Loss From Operating Activities" (11,193) vs "Profit Loss Before Tax" (8,741). The difference is Net Financial Expense (5,880 - 3,430 = 2,450 cost? No. Finance Income 3,430, Finance Costs 5,880. Net Finance Cost = 2,450. 11,193 - 2,450 = 8,743. Close to 8,741 (diff due to share of associates etc). So Operating Profit is the correct starting point for EBITDA. Final check on Debt: Long-term Borrowings: 68,191 Short-term Borrowings: 18,392 Current Portion LT Borrowings: 2,835 Total Borrowings: 89,418 Hybrids: 5,567. 50% = 2,783.5. Total Adjusted Debt: 92,201.5. Cash: 11,041. Net Debt: 81,160.5. EBITDA: 20,002. Ratio: 4.06. If the question implies a simpler "Net Debt" (just borrowings - cash) without the hybrid adjustment, the answer would be 3.92. However, "S&P methodology" strongly suggests the rating agency's definition of debt, which includes the hybrid adjustment. Let's provide the answer based on the S&P adjusted debt. 4.06