**Step 1: Identify the relevant industry** TenneT Holding B.V. is described in the facts as a "transmission system operator" and its principal activity is "Energy Transmission Charges". It is owned by the Dutch State. This fits squarely into the **Regulated Utilities** sector, specifically under the subsector of Electricity National/Transmission. The methodology provided for "Regulated Utilities" will be applied. **Step 2: Estimate 2021 Adjusted_EBITDA** For Regulated Utilities, S&P typically uses EBITDA as a key profitability indicator. We need to reconstruct EBITDA for the fiscal year 2021 (period 2021-01-01 to 2022-01-01). * **Revenue (2021):** 5,524 million EUR * **Operating Expense (2021):** 5,861 million EUR * **Profit/Loss from Operating Activities (2021):** -275 million EUR (Note: Revenue - OpEx = 5524 - 5861 = -337. The difference between -337 and -275 is likely due to other operating income/expenses not explicitly broken out or included in the "Operating Expense" line item vs the final operating profit line. We will use the reported Operating Profit/Loss as the starting point for EBIT reconstruction). * **Depreciation and Amortisation (2021):** 1,165 million EUR * **Share of Profit of Associates/JV (2021):** 62 million EUR. This is an equity accounting item, usually excluded from EBITDA or added back if included in operating profit. In utility EBITDA calculations, we often look at Operating EBITDA. Let's calculate EBITDA from the bottom up or top down. * Top Down: Revenue (5,524) - Operating Expenses excluding D&A? The "Operating Expense" line is 5,861. "Depreciation" is 1,165. Usually, Operating Expense includes D&A. If we assume Operating Expense includes D&A, then EBIT = Revenue - OpEx = -337. Then EBITDA = EBIT + D&A = -337 + 1,165 = 828. * Let's check the reported "Profit Loss From Operating Activities": -275. * EBITDA = Operating Profit + Depreciation & Amortization. * EBITDA (2021) = -275 + 1,165 = 890 million EUR. * *Correction/Refinement*: The "Operating Expense" line (5,861) is higher than Revenue (5,524), implying an operating loss before other items. The reported Operating Profit is -275. The difference (5,861 - 5,524 = 337 loss vs 275 reported loss) suggests there are other operating gains/income of ~62 million (which matches the Share of Profit of Associates/JV of 62 million). It is standard to exclude equity income from EBITDA for operating performance, or include it depending on the definition. S&P often adjusts for non-operating items. However, for a pure transmission utility, the core operating cash flow is key. * Let's stick to the standard definition: EBITDA = EBIT + D&A. * EBIT (Operating Profit) = -275 million EUR. * D&A = 1,165 million EUR. * Unadjusted EBITDA = 890 million EUR. * **Adjustments:** * **Leases:** IFRS 16 requires lease liabilities. S&P often adds back lease depreciation and interest to EBITDA for comparability, or treats lease liabilities as debt. The prompt asks for `adjustment_leases`. In the Regulated Utilities methodology, lease adjustments are common. We have "Right-of-use Assets" and "Lease Liabilities". * Lease Interest (Finance Costs portion): Total Finance Costs are 202 million. We don't have a specific breakdown of lease interest vs debt interest in the P&L lines provided, but we can estimate. * Depreciation on ROU Assets: Not explicitly broken out from total D&A. * However, a simpler approach often used in these automated estimations when specific lease P&L splits aren't given is to look at the change in lease liabilities or use the reported EBITDA and adjust debt. Let's look at the `Adjusted_EBITDA` formula provided: `EBITDA + adjustment_leases`. * If we assume the reported Operating Profit already includes the depreciation of ROU assets (part of the 1,165 D&A) and the finance costs include lease interest, adding back lease interest and ROU depreciation would increase EBITDA. * Without explicit split, we might assume the "Operating Expense" and "Finance Costs" are as reported. * Let's check if there are significant non-recurring items. "Other Gains Losses" is -4 million. Negligible. * Pension adjustments: "Noncurrent Recognised Liabilities Defined Benefit Plan" decreased from 351 to 174 (in 2022 balance sheet, so 2021 end was 351, 2020 end was higher?). The P&L doesn't show a specific pension service cost separate from Employee Benefits. We will assume no major non-cash pension adjustment beyond what's in EBITDA unless specified. * Joint Ventures: The share of profit (62m) is included in Operating Profit. S&P often excludes equity income from EBITDA to focus on operating cash generation, or includes it if it's cash-dividend yielding. Given the small amount, we will leave it or treat it as neutral. * Let's calculate **Adjusted EBITDA 2021** = 890 million EUR. (We will verify if lease adjustments are material. Lease liabilities current+noncurrent 2021: 169 + 235 = 404. 2020: Not given. Interest on leases is likely a portion of the 202m finance cost. If we add back lease interest (est. ~10-15m) and ROU Dep (est. ~50m?), EBITDA might rise to ~950m. However, without explicit data, we stick to the reported reconstruction: **890 million EUR**). * **Refined Calculation for 2021:** * Operating Profit: -275 * Add: Depreciation & Amortization: 1,165 * **EBITDA 2021: 890 million EUR.** **Step 3: Estimate 2021 FFO** Formula: `FFO = Adjusted_EBITDA - cash_interest - cash_taxes` * **Cash Interest:** * Finance Costs (2021): 202 million EUR. * Finance Income (2021): 2 million EUR. * Net Finance Costs: 200 million EUR. * "Interest Paid Classified As Financing Activities" (2021): 174 million EUR. * S&P usually uses cash interest paid. So, **Cash Interest = 174 million EUR**. * **Cash Taxes:** * Income Tax Expense (2021): -135 million EUR (Benefit? Or expense? The sign is negative in the data `Income Tax Expense Continuing Operations 2021...: -135000000`. Wait, Profit Before Tax was -475. A tax benefit of 135 makes sense. Net Loss -340. -475 + 135 = -340. So it's a tax benefit). * "Income Taxes Paid Refund Classified As Operating Activities" (2021): 246 million EUR. Positive value usually indicates inflow (refund) or outflow? In cash flow statements, "Income taxes paid" is an outflow. "Refund" is an inflow. The label is "Income Taxes Paid Refund...". Let's look at 2022: Expense -354, Paid/Refund 231. Profit before tax -1233. Tax benefit 354. Net loss -879. * Usually, if the company is making losses, it might receive refunds or pay zero. The positive number in the cash flow line `Income Taxes Paid Refund` likely represents a net cash **inflow** (refund) or the absolute value of tax paid? * Let's check the context. TenneT is a utility. It likely pays taxes. But with accounting losses due to high depreciation/finance costs, taxable income might differ. * However, FFO definition subtracts cash taxes. If it's a refund, it adds to cash flow. * Let's assume the figure `246` is the net cash tax payment (outflow) or refund (inflow). Given the label "Paid Refund", and standard XBRL tagging, positive often means outflow for "Paid" and inflow for "Refund". But here it's a single line. Let's look at the change in Deferred Tax Assets. DTA increased from 162 (2021 start? No, 2022-01-01 is 162. 2021-01-01 is not given for DTA, but 2022-01-01 is the end of 2021). * Let's look at 2022 DTA: 711. 2021 DTA: 162. Increase of 549. This suggests significant deferred tax assets recognized, consistent with losses. * If the company is in a tax loss position, cash taxes paid are likely low or negative (refunds). * Let's assume the `246 million` is a cash **outflow** (taxes paid) or **inflow**? In many datasets, "Income taxes paid" is presented as a positive number representing the cash outflow. Let's assume **Cash Tax = 246 million EUR outflow**. (Even if it's a refund, the magnitude is what matters for the trend). * Actually, let's look at the sign convention. `Profit Loss` is negative. `Income Tax Expense` is negative (benefit). If `Income Taxes Paid` is positive 246, it usually means cash outflow in many financial databases unless specified as "Net". Let's assume it's a cash outflow of 246. * **FFO 2021** = 890 (EBITDA) - 174 (Cash Interest) - 246 (Cash Tax) = **470 million EUR**. **Step 4: Estimate 2021 Adjusted_Debt** Formula: `Adjusted_Debt = reported_debt + leases + pension_deficit + ... - eligible_cash` * **Reported Debt (2021 year-end, i.e., 2022-01-01 balance sheet):** * Long-term Borrowings: 12,366 million EUR. * Short-term Borrowings: 1,339 million EUR. * Current Bank Overdrafts: 64 million EUR. * Total Interest-Bearing Debt = 12,366 + 1,339 + 64 = 13,769 million EUR. * **Leases:** * Noncurrent Lease Liabilities: 235 million EUR. * Current Lease Liabilities: 169 million EUR. * Total Leases = 404 million EUR. * **Pension Deficit:** * "Noncurrent Recognised Liabilities Defined Benefit Plan": 351 million EUR. * Are there pension assets? Not explicitly listed as an asset offset. We assume the liability is the net deficit. * Pension Deficit = 351 million EUR. * **Hybrid Debt:** * Hybrid Capital: 2,125 million EUR. * S&P typically treats hybrids as 50% debt and 50% equity for leverage ratios, or 100% debt if they are very debt-like. For regulated utilities with strong regulatory support, they might get equity credit. However, the baseline formula says `hybrid_debt_portion`. Standard S&P practice for hybrids is 50% debt adjustment unless specified otherwise. Let's assume **50% of Hybrid Capital** is added to debt. * Hybrid Debt Portion = 0.5 * 2,125 = 1,062.5 million EUR. * **Eligible Cash:** * Cash and Cash Equivalents: 3,204 million EUR (from 2022-01-01 balance sheet, which is end of 2021). * S&P allows deduction of unrestricted cash. We assume all cash is eligible. * Eligible Cash = 3,204 million EUR. * **Adjusted Debt 2021 Calculation:** * Debt: 13,769 * Leases: 404 * Pension: 351 * Hybrid (50%): 1,062.5 * Less Cash: -3,204 * **Adjusted Debt 2021** = 13,769 + 404 + 351 + 1,062.5 - 3,204 = **12,382.5 million EUR**. **Step 5: Calculate 2021 Adjusted_Debt / Adjusted_EBITDA** * Ratio = 12,382.5 / 890 = **13.91x** **Step 6: Calculate 2021 FFO / Adjusted_Debt** * Ratio = 470 / 12,382.5 = **0.038** (or 3.8%) **Step 7: Estimate 2022 Adjusted_EBITDA** * **Revenue (2022):** 8,299 million EUR. * **Operating Expense (2022):** 9,395 million EUR. * **Profit/Loss from Operating Activities (2022):** -976 million EUR. * **Depreciation and Amortisation (2022):** 1,233 million EUR. * **EBITDA 2022** = Operating Profit + D&A = -976 + 1,233 = **257 million EUR**. *Note: The drop in EBITDA from 890 to 257 is significant. This is driven by higher operating expenses (energy costs?) and potentially higher depreciation.* * **Adjustments:** * Non-recurring: "Other Gains Losses" is -38 million. Small. * Leases/Pension: Similar logic as 2021. * **Adjusted EBITDA 2022** = **257 million EUR**. **Step 8: Estimate 2022 FFO** * **Cash Interest:** * "Interest Paid Classified As Financing Activities" (2022): 202 million EUR. * **Cash Taxes:** * "Income Taxes Paid Refund..." (2022): 231 million EUR. * **FFO 2022** = 257 (EBITDA) - 202 (Cash Interest) - 231 (Cash Tax) = **-176 million EUR**. **Step 9: Estimate 2022 Adjusted_Debt** * **Reported Debt (2022 year-end, i.e., 2023-01-01 balance sheet):** * Long-term Borrowings: 19,006 million EUR. * Short-term Borrowings: 709 million EUR. * Current Bank Overdrafts: 0 EUR. * Total Interest-Bearing Debt = 19,006 + 709 = 19,715 million EUR. * **Leases:** * Noncurrent Lease Liabilities: 574 million EUR. * Current Lease Liabilities: 155 million EUR. * Total Leases = 729 million EUR. * **Pension Deficit:** * "Noncurrent Recognised Liabilities Defined Benefit Plan": 174 million EUR. * **Hybrid Debt:** * Hybrid Capital: 2,125 million EUR. * Hybrid Debt Portion (50%) = 1,062.5 million EUR. * **Eligible Cash:** * Cash and Cash Equivalents: 6,547 million EUR. * **Adjusted Debt 2022 Calculation:** * Debt: 19,715 * Leases: 729 * Pension: 174 * Hybrid (50%): 1,062.5 * Less Cash: -6,547 * **Adjusted Debt 2022** = 19,715 + 729 + 174 + 1,062.5 - 6,547 = **15,133.5 million EUR**. **Step 10: Calculate 2022 Adjusted_Debt / Adjusted_EBITDA** * Ratio = 15,133.5 / 257 = **58.88x** **Step 11: Calculate 2022 FFO / Adjusted_Debt** * Ratio = -176 / 15,133.5 = **-0.012** (or -1.2%) **Step 12: Classify the credit trend** * **Signal 1: Leverage (Adjusted Debt / Adjusted EBITDA)** * 2021: 13.91x * 2022: 58.88x * Change: 58.88 - 13.91 = **+44.97x** * Threshold: ≥ +0.2x is Deteriorating. * Signal 1: **Deteriorating** * **Signal 2: Cash-flow coverage (FFO / Adjusted Debt)** * 2021: 0.038 * 2022: -0.012 * Change: -0.012 - 0.038 = **-0.050** * Threshold: ≤ -0.03 is Deteriorating. * Signal 2: **Deteriorating** * **Combination:** * Both signals are Deteriorating. **Reasoning Check:** The massive increase in leverage ratio is driven by the collapse in EBITDA (from 890m to 257m) and the increase in Net Debt (from 12.4bn to 15.1bn). The EBITDA collapse is due to Operating Expenses rising faster than Revenue (OpEx 5.8bn -> 9.4bn vs Rev 5.5bn -> 8.3bn), leading to a deeper operating loss. While TenneT is a regulated utility and likely has pass-through mechanisms for energy costs (which might mean the "Operating Expense" spike includes pass-through costs that are recovered in revenue, but perhaps with a timing lag or accounting mismatch in the reported EBITDA), the raw financial metrics provided show a severe deterioration in coverage and leverage. S&P ratings for regulated utilities often look through temporary mismatches if regulatory recovery is certain, but based *strictly* on the provided facts and the calculated ratios, the metrics have deteriorated significantly. The prompt asks to estimate the trend *based on these facts*. The facts show a negative operating profit, negative FFO, and skyrocketing leverage ratios. Therefore, the trend is Deteriorating. Deteriorating