To estimate the S&P-adjusted FFO-to-debt ratio for Bouygues for the fiscal year ended December 31, 2022, we follow the workflow outlined in the prompt. ### Step 1: Identify the Relevant Industry Bouygues is a diversified industrial group with major activities in Construction (Colas, Bouygues Construction), Media (TF1), and Telecommunications (Bouygues Telecom). It does not fit neatly into the specific "Regulated Utilities," "Oil And Gas Exploration And Production," "Unregulated Power And Gas," or "Transportation Infrastructure" categories provided in the text as its primary classification. While it has infrastructure components, it is a conglomerate. Therefore, we apply the **general corporate baseline formulas** as instructed for entities not fitting the specific industry methodologies. ### Step 2: Estimate Adjusted_EBITDA The baseline formula is: `Adjusted_EBITDA = EBITDA (reported or reconstructed) + adjustment_leases (if any) + nonrecurring_losses - nonrecurring_gains ± pension_adjustments ± joint_venture_proportional_EBITDA ± other_normalization_adjustments` First, we reconstruct EBITDA from the provided income statement data for the period 2022-01-01 to 2023-01-01. **Reported Operating Profit (EBIT):** The report provides "Profit Loss From Operating Activities" which is **1,872,000,000 EUR**. **Add back Depreciation and Amortization:** The report provides "Depreciation And Amortisation Expense" of **2,228,000,000 EUR**. Note: This figure typically includes depreciation of right-of-use assets. The report separately lists "Depreciation Rightofuse Assets" as 446,000,000 EUR, which is likely a subset of the total D&A. We use the total D&A figure. **Reconstructed EBITDA:** $$EBITDA = \text{Operating Profit} + \text{Depreciation \& Amortization}$$ $$EBITDA = 1,872,000,000 + 2,228,000,000 = 4,100,000,000 \text{ EUR}$$ **Adjustments:** 1. **Leases:** Under S&P general corporate methodology, we typically add back the interest portion of lease liabilities to EBITDA if we are calculating FFO, but for Adjusted EBITDA, the standard definition often starts with EBITDA including lease depreciation. However, S&P often defines Adjusted EBITDA for leverage ratios by adding back lease interest to EBITDA or treating leases as debt. Let's look at the FFO definition. * Standard S&P FFO calculation: $FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Deferred Taxes} + \text{Other Non-Cash Items}$. * Alternative S&P FFO calculation (from EBITDA): $FFO = \text{Adjusted EBITDA} - \text{Cash Interest} - \text{Cash Taxes}$. * The prompt asks for `Adjusted_EBITDA` first. In many S&P corporate contexts, Adjusted EBITDA is close to Reported EBITDA adjusted for non-recurring items. * Let's check for non-recurring items. * "Other Operating Income Non Recurring": 93,000,000 EUR (Gain) * "Other Operating Expense Non Recurring": 183,000,000 EUR (Loss) * Net Non-Recurring Operating Impact = $93 - 183 = -90,000,000$ EUR (Net Loss). * To normalize, we add back net non-recurring losses. So, add 90,000,000 EUR. * Are there other adjustments? * "Impairment Loss Reversal...": 172,000,000 EUR. This is included in operating profit. Impairments are often added back to EBITDA. If this is a net expense (loss), we add it back. The label says "Impairment Loss Reversal Of Impairment Loss Recognised In Profit Or Loss And Provision Expense". A positive number in expenses usually implies an expense. However, "Reversal" suggests income. Let's look at the context. Usually, impairment *losses* are added back. If it's a reversal, it's income and should be subtracted. The line item is grouped with "Provision Expense". In the cash flow, "Adjustments For Provisions And Adjustments For Depreciation... And Impairment Loss..." is 2,261,000,000. D&A is 2,228,000,000. The difference is 33,000,000. This suggests the net impact of provisions and impairments added back is small. * Let's stick to the explicit non-recurring operating items provided: Net non-recurring operating loss of 90 million. * Adjusted EBITDA = Reported EBITDA + Net Non-Recurring Losses. * $Adjusted\_EBITDA = 4,100,000,000 + 90,000,000 = 4,190,000,000$ EUR. * *Self-Correction/Refinement on Leases:* S&P often treats lease interest as part of cash interest in the FFO calculation, not an EBITDA adjustment. The EBITDA figure derived from Operating Profit + D&A already includes the EBITDA impact of leases (since lease depreciation is in D&A and lease interest is below EBIT). So no specific "add back lease EBITDA" adjustment is needed unless we started from Net Income. We started from Operating Profit. * *Joint Ventures:* The share of profit/loss from associates is -30,000,000 EUR. This is below the operating profit line (usually). The "Profit Loss From Operating Activities" is 1,872,000,000. The share of JV is listed after finance costs and tax? No, it's listed after tax in the P&L structure provided? * Structure: * Profit Loss From Operating Activities: 1,872 * Cost Of Net Debt: (198) * Other Finance Income/Cost: Net (27) -> 91 - 118 = -27 * Income Tax: (424) * Share of Profit/Loss of Associates: (30) * Profit Loss From Continuing Operations: 1,131 * Check: $1,872 - 198 - 27 - 424 - 30 = 1,193$. This doesn't match 1,131. There might be other items or the "Share of profit" is pre-tax? * Actually, $1,872 - 198 (Net Debt) + 91 (Other Fin Inc) - 118 (Other Fin Cost) - 424 (Tax) - 30 (JV) = 1,193$. The reported Profit is 1,131. The difference is 62. * Regardless, EBITDA is derived from Operating Profit. The JV result is usually equity accounted and not part of EBITDA. S&P may adjust FFO to include proportional EBITDA of JVs, but without specific JV EBITDA data, we cannot make this adjustment accurately. We will proceed with the consolidated Adjusted EBITDA. **Adjusted_EBITDA Estimate:** **4,190,000,000 EUR** ### Step 3: Estimate FFO Formula: `FFO = Adjusted_EBITDA - cash_interest - cash_taxes` 1. **Cash Interest:** * Reported "Interest Expense": 231,000,000 EUR. * Reported "Interest Expense On Lease Liabilities": 62,000,000 EUR. * Reported "Interest Income On Cash And Cash Equivalents": 33,000,000 EUR. * "Cost Of Net Debt": 198,000,000 EUR. (This is likely Net Interest Expense: $231 + 62 - 33 - \text{other?}$ or just $231 - 33 = 198$? $231-33=198$. So "Cost of Net Debt" excludes lease interest? Or includes? * Let's check the Cash Flow Statement for "Interest Paid". * "Interest Paid Classified As Financing Activities": **260,000,000 EUR**. * S&P typically uses cash interest paid. This figure (260m) is close to the sum of Interest Expense (231) + Lease Interest (62) - Interest Income (33) = 260. * So, **Cash Interest = 260,000,000 EUR**. 2. **Cash Taxes:** * Look at Cash Flow Statement: "Income Taxes Paid Classified As Operating Activities". * Value: **518,000,000 EUR**. 3. **Calculate FFO:** $$FFO = 4,190,000,000 - 260,000,000 - 518,000,000$$ $$FFO = 3,412,000,000 \text{ EUR}$$ *Alternative Check using Net Income approach:* $Net Income = 1,131,000,000$ $+ D\&A = 2,228,000,000$ $+ Deferred Tax Change?$ (Deferred Tax Liabilities increased from 344 to 759, Assets from 292 to 489. Net DTL increase = 415. Net DTA increase = 197. Net Deferred Tax Expense/Benefit? Tax Expense is 424. Cash Tax is 518. Deferred Tax Benefit = $518 - 424 = 94$? Or Expense? If Cash > Expense, we paid more than we expensed, so Deferred Tax Asset increased or Liability decreased. Let's stick to the EBITDA derivation as it is more robust given the explicit "Adjusted EBITDA" instruction. However, we must consider if "FFO" requires adding back deferred taxes. The standard S&P FFO formula is: $FFO = \text{Net Income} + \text{Depreciation} + \text{Amortization} + \text{Deferred Taxes} + \text{Other Non-Cash Items}$. Let's try this path to verify. Net Income: 1,131,000,000 Add: D&A: 2,228,000,000 Add: Deferred Taxes: Tax Expense: 424,000,000 Cash Tax Paid: 518,000,000 The difference is 94,000,000. Since Cash Paid > Expense, this is a use of cash relative to expense, meaning Deferred Tax Assets increased or Liabilities decreased. This is a non-cash *add-back* if we start from Net Income? No. Change in Deferred Tax Liability: $759 - 344 = +415$ (Source of cash/Non-cash expense reduction?) Change in Deferred Tax Asset: $489 - 292 = +197$ (Use of cash/Non-cash income?) Net Deferred Tax Change in Balance Sheet = $415 - 197 = +218$ (Net Liability Increase). An increase in Net Deferred Tax Liability is a non-cash charge that reduced Net Income but didn't use cash? No, it's an expense recognized but not paid. So we add it back. Wait, Tax Expense (424) vs Cash Tax (518). If Expense < Cash, then Deferred Tax Benefit was recognized? Or DTA increased? Let's look at the P&L Tax Expense: 424. Cash Flow Tax Paid: 518. This implies we paid 94 more than we expensed. This reduces FFO relative to Net Income + D&A if we don't adjust. Standard FFO = Net Income + D&A + Deferred Tax Expense. Deferred Tax Expense = Tax Expense - Cash Tax? No. Deferred Tax Expense = Change in DTL - Change in DTA? Let's assume the "Income Tax Expense" of 424 includes current and deferred. If we use the EBITDA method: $FFO = EBITDA - Cash Interest - Cash Taxes$. This is a standard approximation. Let's refine Adjusted EBITDA. Did we miss any "nonrecurring" items in the EBITDA calc? Operating Profit: 1,872. Non-recurring Operating Income: 93. Non-recurring Operating Expense: 183. Net Non-recurring: -90. Add back 90 to Operating Profit -> 1,962. Add D&A: 2,228. Adjusted EBITDA = 4,190. FFO = 4,190 - 260 (Cash Int) - 518 (Cash Tax) = 3,412. Let's double check if "Cost of Net Debt" (198) is the right interest figure. Cash Flow shows "Interest Paid" 260. The difference between 198 and 260 is 62, which is exactly the "Interest Expense On Lease Liabilities". So, Cost of Net Debt (198) = Interest Expense (231) - Interest Income (33). Total Cash Interest Paid = 260. S&P FFO subtracts *cash* interest. So 260 is correct. **FFO Estimate:** **3,412,000,000 EUR** ### Step 4: Estimate Adjusted_Debt Formula: `Adjusted_Debt = (reported_debt + leases + pension_deficit + guarantees + hybrid_debt_portion + other_debt_like_items) - eligible_cash` 1. **Reported Debt:** * Long-term Borrowings: 11,586,000,000 EUR (Note: The date 2023-01-01 corresponds to the end of fiscal 2022). * Current Borrowings: 1,361,000,000 EUR. * Current Overdrafts: 418,000,000 EUR. * Total Reported Interest-Bearing Debt = $11,586 + 1,361 + 418 = 13,365,000,000$ EUR. 2. **Leases:** * Noncurrent Lease Liabilities: 2,107,000,000 EUR. * Current Lease Liabilities: 498,000,000 EUR. * Total Lease Liabilities = $2,107 + 498 = 2,605,000,000$ EUR. * S&P adds the full lease liability to debt for the Adjusted Debt calculation (or treats it as debt-like). 3. **Pension Deficit:** * Not explicitly provided as a net deficit figure in the facts. We see "Employee Benefits Expense" but not the balance sheet obligation vs asset. Without specific "Net Pension Liability" data separate from provisions, and given "Noncurrent Provisions" are 2,250,000,000, we might assume provisions include some pension items, but typically S&P requires specific pension deficit data. In the absence of explicit "Pension Deficit" line item, we may have to omit or assume it's included in provisions/not material enough to estimate precisely. However, looking at "Noncurrent Provisions" (2,250) and "Current Provisions" (1,832), these are large. But without a breakdown, we cannot confidently extract pension deficit. We will proceed with Reported Debt + Leases. *Note: Often, if not specified, we might ignore or assume zero adjustment for pension deficit in this simplified context, or check if "Net Debt" provided in the report gives a clue.* * The report provides "Net Debt" = 7,440,000,000 EUR. * Let's check how the company calculates Net Debt. * Company Net Debt = Gross Debt - Cash. * Gross Debt (Company) = $13,365$ (Interest bearing) + Leases? * If Company Net Debt is 7,440 and Cash is 5,736 (from Balance Sheet "Cash And Cash Equivalents"), then Implied Gross Debt = $7,440 + 5,736 = 13,176$. * Our calculated Interest-Bearing Debt is 13,365. This is close (difference of ~189m, possibly due to hedging instruments or other minor financial liabilities/assets). * Company Net Debt usually *includes* lease liabilities in modern reporting (IFRS 16). * If Company Net Debt (7,440) includes leases, then: * Gross Debt (incl leases) = 13,176. * Our sum of Borrowings (13,365) + Leases (2,605) = 15,970. * This suggests the company's "Net Debt" definition might *exclude* leases or the "Borrowings" figure in my sum is different from their "Gross Debt". * Let's look at the components again. * Long-term Borrowings: 11,586. * Current Borrowings: 1,361. * Overdrafts: 418. * Sum = 13,365. * Leases = 2,605. * Total Debt + Leases = 15,970. * Cash = 5,736. * Net Debt (S&P Style) = $15,970 - 5,736 = 10,234$. * S&P Adjusted Debt typically adds leases to reported debt. * Are there other debt-like items? * "Hedging Instrument Liabilities": 4 (Current) + ? (Noncurrent not listed separately, likely in Noncurrent Liabilities or Hedging). Noncurrent Liabilities total 16,702. Breakdown: Borrowings 11,586, Leases 2,107, Provisions 2,250, Deferred Tax 759. Sum = 16,702. So no hidden hedging liabilities in non-current. * So Total Debt + Leases = 15,970,000,000 EUR. 4. **Eligible Cash:** * Cash and Cash Equivalents: 5,736,000,000 EUR. * S&P typically deducts unrestricted cash. We assume all cash is eligible unless stated otherwise. 5. **Calculate Adjusted_Debt:** $$Adjusted\_Debt = (\text{Total Borrowings} + \text{Total Leases}) - \text{Cash}$$ $$Adjusted\_Debt = (13,365,000,000 + 2,605,000,000) - 5,736,000,000$$ $$Adjusted\_Debt = 15,970,000,000 - 5,736,000,000$$ $$Adjusted\_Debt = 10,234,000,000 \text{ EUR}$$ ### Step 5: Calculate FFO / Adjusted_Debt $$Ratio = \frac{FFO}{Adjusted\_Debt}$$ $$Ratio = \frac{3,412,000,000}{10,234,000,000}$$ Calculation: $3,412 / 10,234 \approx 0.333398$ Rounding to four decimal places: **0.3334** **Double Check Steps:** * **EBITDA:** * Op Profit: 1,872 * D&A: 2,228 * EBITDA: 4,100 * Non-rec net loss: 90 (Add back) * Adj EBITDA: 4,190 * **FFO:** * Cash Interest: 260 * Cash Tax: 518 * FFO: $4,190 - 260 - 518 = 3,412$ * **Debt:** * LT Borrow: 11,586 * ST Borrow: 1,361 * Overdraft: 418 * LT Lease: 2,107 * ST Lease: 498 * Total Debt+Lease: 15,970 * Cash: 5,736 * Net Debt: 10,234 * **Ratio:** * $3,412 / 10,234 = 0.333398...$ One potential adjustment: S&P sometimes adjusts FFO for "Proportional EBITDA of Joint Ventures" if they are equity accounted. The share of loss is -30m. If we assume the JV EBITDA is proportional to the result, it's negligible. If we assume the JV has significant debt, we might need to consolidate proportionally, but S&P standard for non-controlled JVs is often equity method for FFO (adding back share of income/loss and depreciation if excluded) or proportional consolidation for Debt/EBITDA if significant. Given the small size (-30m profit share) relative to the group, and lack of specific JV debt/EBITDA data, we stick to the consolidated numbers. Another check: Did we handle the "Net Debt" provided in the text (7,440) correctly? If the company reports Net Debt as 7,440, and our calculated S&P Net Debt is 10,234, the difference is ~2,800. This difference is roughly equal to the Lease Liabilities (2,605). This implies the company's reported "Net Debt" likely *excludes* lease liabilities (or treats them differently), whereas S&P *includes* them in Adjusted Debt. Therefore, using the S&P methodology (adding leases to debt), our calculation of 10,234 is correct for "Adjusted Debt". Final Ratio: 0.3334 0.3334