Skip to content
Annalist
Companies Screener Compare Deal Lab Method Data Quality For AI agents

Deal Lab · Buyout model 1.0

Bristol-Myers Squibb Company Buyout Model

A buyout of Bristol-Myers Squibb Company on its published figures for the last 4 quarters to Q3 FY2026, in US dollars: revenue flat, the margin and the shares of revenue of that period, entry and exit at 10.0x EBITDA, exit after 5 years.

Last 4 quarters to Q3 FY2026US GAAPUS dollarsLeases as debtCompany page

Returns

Internal rate of return

6.4%

Multiple of money

1.36x

Sponsor's equity

$86.1bn

Enterprise value

$161bn

Proceeds at exit

$117bn

Sources and Uses

UsesAmount
Equity price$128bn
Borrowings refinanced$43.6bn
Transaction costs$3.2bn
Financing fees$1.6bn
Minimum cash$1.0bn
Uses$177bn
SourcesAmount
Senior loan$58.8bn
Subordinated notes$19.6bn
Cash of the company$12.6bn
Sponsor's equity$86.1bn
Sources$177bn

Projection

ClosingYear 1Year 2Year 3Year 4Year 5
Revenue$50.0bn$50.0bn$50.0bn$50.0bn$50.0bn$50.0bn
EBITDA of the case$16.1bn$16.1bn$16.1bn$16.1bn$16.1bn$16.1bn
Cash cost of leases$293m$293m$293m$293m$293m$293m
Depreciation and amortisation$2.8bn$2.8bn$2.8bn$2.8bn$2.8bn
Capital expenditure$1.3bn$1.3bn$1.3bn$1.3bn$1.3bn
Increase in working capital$0$0$0$0$0
Interest$6.3bn$5.8bn$5.3bn$4.8bn$4.2bn
Tax$1.7bn$1.8bn$2.0bn$2.1bn$2.2bn
Cash available for debt service$12.7bn$12.6bn$12.5bn$12.3bn$12.2bn

Debt Schedule

ClosingYear 1Year 2Year 3Year 4Year 5
Senior loan$58.8bn$52.4bn$45.6bn$38.4bn$30.8bn$22.8bn
Subordinated notes$19.6bn$19.6bn$19.6bn$19.6bn$19.6bn$19.6bn
Revolving facility$0$0$0$0$0$0
Cash$1.0bn$1.0bn$1.0bn$1.0bn$1.0bn$1.0bn
Debt to EBITDA5.00x4.60x4.18x3.73x3.26x2.76x
EBITDA to interest2.56x2.77x3.03x3.37x3.82x

Covenants and the Credit View

ClosingYear 1Year 2Year 3Year 4Year 5
Limit of debt to EBITDA6.50x
Lease-adjusted debt to EBITDA5.00x4.60x4.18x3.73x3.26x2.76x
Band of debt to EBITDAHighly leveragedAggressiveAggressiveSignificantSignificantIntermediate

Return Bridge

Amount
Sponsor's equity$86.1bn
EBITDA growth$0
Change of multiple$0
Net debt repaid+$36.0bn
Non-controlling interests$0
Costs at closing−$4.8bn
Management and limited liability$0
Proceeds at exit$117bn

Sensitivity Tables

Entry by exit8.00x9.00x10.0x11.0x12.0x
8.00x9.6%13.3%16.6%19.5%22.2%
9.00x4.1%7.7%11.0%13.8%16.5%
10.0x−0.2%3.3%6.4%9.1%11.7%
11.0x−3.6%−0.2%2.7%5.4%7.8%
12.0x−6.5%−3.2%−0.3%2.3%4.7%
Debt by growth−4.0%−2.0%0.0%2.0%4.0%
4.00x0.4%3.4%6.4%9.2%12.0%
4.50x−0.2%3.2%6.4%9.4%12.4%
5.00x−0.9%2.9%6.4%9.7%12.9%
5.50x−1.7%2.5%6.4%10.0%13.5%
6.00x−2.8%2.0%6.4%10.4%14.2%

Solvers

Highest entry multiple for a return of 20.0%

4.33x

The target return

Revenue growth a year for a return of 20.0%

8.7%

The target return

Debt capacity at closing, times EBITDA

6.00x

The loan to value limit

Assumptions and Their Origins

GroupAssumptionValueOrigin
TransactionEntry multiple10.0xConvention of buyout 1.0
TransactionYears to exit5 yearsConvention of buyout 1.0
TransactionTransaction costs2.0%Convention of buyout 1.0
TransactionFinancing fees2.0%Convention of buyout 1.0
TransactionMinimum cash, of revenue2.0%Convention of buyout 1.0
FinancingDebt at closing, times EBITDA5.00xConvention of buyout 1.0
FinancingDebt at most, of the enterprise value60.0%Convention of buyout 1.0
FinancingSenior loan, of the new debt75.0%Convention of buyout 1.0
FinancingSenior loan repaid each year1.0%Convention of buyout 1.0
FinancingCash sweep100%Convention of buyout 1.0
FinancingRevolving facility, times EBITDA1.00xConvention of buyout 1.0
FinancingBase rate3.9%Policy rate of the United States, BIS central bank policy rates, 27 October 2026
FinancingSenior loan spread3.5%Convention of buyout 1.0
FinancingSubordinated notes spread6.0%Convention of buyout 1.0
FinancingRevolving facility spread3.0%Convention of buyout 1.0
FinancingCovenant headroom on debt to EBITDA30.0%Convention of buyout 1.0
FinancingMinimum EBITDA to interest2.00xConvention of buyout 1.0
OperationsRevenue growth a year0.0%Convention of buyout 1.0
OperationsEBITDA margin32.1%EBITDA over revenue, last 4 quarters to FY2026 Q3
OperationsCash cost of leases, of revenue0.6%Cash cost of leases over revenue, last 4 quarters to FY2026 Q3
OperationsDepreciation and amortisation, of revenue5.6%Depreciation and amortisation over revenue, last 4 quarters to FY2026 Q3
OperationsCapital expenditure, of revenue2.7%Median capital expenditure over revenue, fiscal 2023 to 2025
OperationsWorking capital, of revenue14.5%Working capital over revenue, end of the last 4 quarters to FY2026 Q3
OperationsLeases as debtYesLeases as debt, the basis of the credit metrics
OperationsShare-based pay added backNoConvention of buyout 1.0
TaxesTax rate25.5%Combined statutory rate of corporate income tax of the United States, OECD Corporate Tax Statistics, 2026
TaxesInterest deducted up to 30% of EBITDANoConvention of buyout 1.0
ExitExit multiple10.0xConvention of buyout 1.0
ExitManagement share of the proceeds0.0%Convention of buyout 1.0
ExitTarget return20.0%Convention of buyout 1.0

Inputs and Their Documents

Published figures of the last 4 quarters to Q3 FY2026, each with the documents it comes from.

InputValueMethodDocuments
Adjusted EBITDA$16.6bn est.Adjusted EBITDA of the company page10-K 2025-12, 10-Q 2025-09, 10-Q 2026-03, 10-Q 2026-06, 10-Q 2026-09
Share-based pay$552mShare-based pay that adjusted EBITDA adds back10-K 2025-12, 10-Q 2025-09, 10-Q 2026-03, 10-Q 2026-06, 10-Q 2026-09
EBITDA after share-based pay$16.1bn est.Adjusted EBITDA less share-based pay10-K 2025-12, 10-Q 2025-09, 10-Q 2026-03, 10-Q 2026-06, 10-Q 2026-09
Depreciation and amortisation$2.8bnDepreciation and amortisation of adjusted EBITDA10-K 2025-12, 10-Q 2025-09, 10-Q 2026-03, 10-Q 2026-06, 10-Q 2026-09
Revenue$50.0bnRevenue of the base period10-K 2025-12, 10-Q 2025-09, 10-Q 2026-03, 10-Q 2026-06, 10-Q 2026-09
Operating lease cost$293m est.Operating lease cost10-K 2025-12
Borrowings$43.6bnTotal debt less lease liabilities10-Q 2026-09
Lease liabilities$1.9bnLease liabilities10-Q 2026-09
Cash and short-term investments$12.6bnCash and short-term investments10-Q 2026-09
Non-controlling interests$0The balance sheet reports none10-Q 2026-09
Receivables$9.2bnReceivables10-Q 2026-09
Payables$4.6bnPayables10-Q 2026-09
Inventories$2.7bnInventories10-Q 2026-09
Capital expenditure$1.3bnCapital expenditure of the latest fiscal year10-K 2025-12

Checks of the Model

  • Sources equal uses
  • The equity price is above nil
  • The sponsor's equity is above nil
  • Each balance of debt stays between nil and its amount at closing
  • Cash is the cash of the year before and the cash flow of the year
  • Cash stays at the minimum unless a shortfall is stated
  • The 6 parts of the bridge add up to the proceeds less the sponsor's equity
  • The cash flows at the internal rate of return have a present value of nil

Deal Lab computes arithmetic on published figures and on the assumptions of the user. It values no company, recommends no transaction and forecasts no result.