Jersey, Channel Islands
|
|||||||||||
(State or other jurisdiction of incorporation or organization) | |||||||||||
001-38911 | |||||||||||
(Commission File Number)
|
|||||||||||
N/A | |||||||||||
(I.R.S. Employer Identification No.)
|
|||||||||||
Friars House
160 Blackfriars Road |
|||||||||||
London |
SE1 8EZ
|
||||||||||
United Kingdom
|
|||||||||||
(Address of Principal Executive Offices)
|
Title of each class | Trading Symbol(s) | Name of each exchange on which registered | ||||||
Ordinary Shares, no par value | CLVT | New York Stock Exchange | ||||||
5.25% Series A Mandatory Convertible Preferred Shares, no par value | CLVT PR A | New York Stock Exchange |
No. | Document Description | ||||
23.1 | |||||
99.1 | |||||
99.2 | |||||
99.3 | |||||
104 | The cover page from the Company's Current Report on Form 8-K/A dated February 3, 2022, formatted in Inline XBRL |
CLARIVATE PLC | ||||||||
Date: February 3, 2022 | By: | /s/ Jonathan Collins | ||||||
Name: | Jonathan Collins | |||||||
Title: |
Executive Vice President & Chief Financial Officer
|
(In millions) |
September 30, 2021 (unaudited)
|
December 31, 2020
|
|||||||||
Assets
|
|||||||||||
Current assets: | |||||||||||
Cash and cash equivalents | $ | 53.6 | $ | 86.0 | |||||||
Restricted cash | 2.1 | 2.5 | |||||||||
Accounts receivable (net of allowances $6.2 and $7.7, respectively)
|
144.7 | 138.1 | |||||||||
Deferred royalties | 19.6 | 19.5 | |||||||||
Other current assets | 40.3 | 34.6 | |||||||||
Total current assets | 260.3 | 280.7 | |||||||||
Property and equipment, net | 52.2 | 51.6 | |||||||||
Content and software development, net | 112.4 | 109.4 | |||||||||
Other intangible assets, net | 253.3 | 284.9 | |||||||||
Goodwill | 629.1 | 629.1 | |||||||||
Other long-term assets | 13.4 | 15.3 | |||||||||
Total assets | $ | 1,320.7 | $ | 1,371.0 | |||||||
Liabilities and Member's Equity | |||||||||||
Current liabilities | |||||||||||
Accounts payable | $ | 34.5 | $ | 36.1 | |||||||
Accrued wages and benefits | 43.9 | 46.0 | |||||||||
Accrued royalty cost | 63.8 | 65.9 | |||||||||
Deferred revenue | 363.0 | 334.0 | |||||||||
Other current liabilities | 46.0 | 33.2 | |||||||||
Total current liabilities | 551.2 | 515.2 | |||||||||
Long-term deferred revenue | 7.9 | 5.7 | |||||||||
Long-term debt | 903.0 | 1,016.8 | |||||||||
Long-term capital lease | 26.3 | 22.3 | |||||||||
Long-term deferred income taxes | 16.9 | 17.2 | |||||||||
Other long-term liabilities | 17.3 | 48.3 | |||||||||
Total liabilities | $ | 1,522.6 | $ | 1,625.5 | |||||||
Commitments and Contingencies (Note 15) | |||||||||||
Member’s equity | |||||||||||
Member’s equity
|
(191.0) | (243.9) | |||||||||
Accumulated other comprehensive loss | (10.9) | (10.6) | |||||||||
Total member’s equity | $ | (201.9) | $ | (254.5) | |||||||
Total liabilities and member’s equity | $ | 1,320.7 | $ | 1,371.0 |
(In millions; unaudited) |
Nine months ended September 30, 2021
|
Nine months ended September 30, 2020
|
|||||||||
Revenues: | |||||||||||
Subscription and maintenance | $ | 503.8 | $ | 482.4 | |||||||
Content licenses and other products | 172.6 | 153.7 | |||||||||
Total revenues | 676.4 | 636.1 | |||||||||
Cost and expenses: | |||||||||||
Cost of subscription and maintenance (exclusive of depreciation and amortization shown below) | 137.7 | 142.2 | |||||||||
Cost of content licenses and other products (exclusive of depreciation and amortization shown below) | 112.6 | 100.3 | |||||||||
Selling, general and administrative | 195.9 | 179.3 | |||||||||
Depreciation and amortization | 74.7 | 98.4 | |||||||||
Research and development | 54.5 | 53.8 | |||||||||
Management fee - related party | 5.5 | 5.2 | |||||||||
Total costs and expenses | 580.9 | 579.2 | |||||||||
Income from operations | 95.5 | 56.9 | |||||||||
Interest expense, net | (36.0) | (36.2) | |||||||||
Gain on contingent considerations | — | 1.2 | |||||||||
Unrealized gains (losses) on derivative instruments | 18.9 | (32.1) | |||||||||
Foreign currency transaction losses | (0.2) | (1.6) | |||||||||
Extraordinary loss | — | (0.1) | |||||||||
Non-operating expense, net | (17.3) | (68.8) | |||||||||
Income (loss) before income taxes | 78.2 | (11.9) | |||||||||
Provision for federal, state and foreign taxes | (8.4) | (0.3) | |||||||||
Net income (loss) | $ | 69.8 | $ | (12.2) |
(In millions; unaudited)
|
Nine months ended September 30, 2021
|
Nine months ended September 30, 2020
|
|||||||||
Net Income (Loss)
|
$ | 69.8 | $ | (12.2) | |||||||
Other comprehensive income:
|
|||||||||||
Currency translation adjustment | (0.3) | 1.4 | |||||||||
Tax effect | — | — | |||||||||
Total other comprehensive (loss) income | (0.3) | 1.4 | |||||||||
Comprehensive income (loss) | $ | 69.5 | $ | (10.8) |
(In millions; unaudited) |
Nine months ended September 30, 2021
|
Nine months ended September 30, 2020
|
|||||||||
Cash flows provided by operating activities:
|
|||||||||||
Net income (loss) | $ | 69.8 | $ | (12.2) | |||||||
Adjustments to reconcile net income (loss) to net cash provided by operating activities: | |||||||||||
Depreciation and amortization | 74.7 | 98.4 | |||||||||
Amortization of debt issuance costs | 2.0 | 1.5 | |||||||||
Deferred compensation | 3.6 | 3.3 | |||||||||
Unrealized (gains) losses on derivative instruments | (18.9) | 32.1 | |||||||||
Gain on contingent consideration | — | (1.2) | |||||||||
Changes in deferred taxes | 0.3 | (5.9) | |||||||||
Changes in deferred rent | 1.2 | (0.4) | |||||||||
Imputed interest | — | 0.1 | |||||||||
Decrease in accounts receivable allowances | — | 4.6 | |||||||||
Changes in assets and liabilities, net of effects of acquisitions made: | |||||||||||
Increase in accounts receivable | (6.8) | (42.3) | |||||||||
Increase in other assets | (0.3) | (0.8) | |||||||||
Decrease in deferred royalties | 0.8 | 1.4 | |||||||||
Decrease in accounts payable and accrued expenses | (7.1) | (10.8) | |||||||||
Decrease in accrued royalties | (3.1) | (0.6) | |||||||||
Increase in deferred revenue | 31.2 | 62.4 | |||||||||
Net cash provided by operating activities | 147.4 | 129.6 | |||||||||
Cash flows from investing activities: | |||||||||||
Property and equipment purchases | (7.5) | (5.5) | |||||||||
Product development costs | (35.6) | (31.0) | |||||||||
Acquisition of business, net of cash acquired | — | (222.6) | |||||||||
Investment in equity-method investee | — | (1.5) | |||||||||
Net cash used in investing activities | (43.1) | (260.6) | |||||||||
Cash flows from financing activities: | |||||||||||
Payments on contingent consideration | (0.4) | — | |||||||||
Payments on capital lease | (0.4) | (0.5) | |||||||||
Proceeds from revolver | 1.5 | 171.4 | |||||||||
Payments on revolver | (1.5) | (171.4) | |||||||||
Proceeds from long-term debt | — | 210.0 | |||||||||
Repayments of long-term debt | (115.0) | (53.9) | |||||||||
Debt issuance costs | (0.8) | (3.8) | |||||||||
Changes in due to affiliates, net | — | (0.2) | |||||||||
Capital distributions, net | (20.7) | (5.9) | |||||||||
Net cash (used in) provided by financing activities | (137.3) | 145.7 | |||||||||
Effects of exchange rate changes on cash | 0.2 | 0.7 | |||||||||
Net (decrease) increase in cash, cash equivalents, and restricted cash | (32.8) | 15.4 | |||||||||
Cash, cash equivalents, and restricted cash: | |||||||||||
Beginning | 88.5 | 40.5 | |||||||||
Ending | $ | 55.7 | $ | 55.9 |
(In millions; unaudited) |
Nine months ended September 30, 2021
|
Nine months ended September 30, 2020
|
|||||||||
Supplemental disclosures of cash flow information: | |||||||||||
Interest paid
|
$ | 34.1 | $ | 34.8 | |||||||
Income taxes paid | 4.7 | 6.1 | |||||||||
Supplemental schedule of non-cash investing and financing activities: | |||||||||||
Accrued member’s distribution | — | 0.2 | |||||||||
Accrued capital expenditures | 0.4 | — | |||||||||
Capital lease modification | 4.0 | — | |||||||||
Reconciliation of cash, cash equivalents, and restricted cash: | |||||||||||
Cash and cash equivalents | 53.6 | 53.4 | |||||||||
Restricted cash | 2.1 | 2.5 | |||||||||
Total cash, cash equivalents, and restricted cash shown in the statement of cash flows | $ | 55.7 | $ | 55.9 |
Accumulated Other Comprehensive Loss | |||||||||||||||||
(In millions; unaudited) | Member’s Equity | Currency Translation Adjustment | Total Member’s Equity | ||||||||||||||
Balance at December 31, 2020 | $ | (243.9) | $ | (10.6) | $ | (254.5) | |||||||||||
Net income | 69.8 | — | 69.8 | ||||||||||||||
Deferred compensation | 3.6 | — | 3.6 | ||||||||||||||
Capital distributions, net | (20.5) | — | (20.5) | ||||||||||||||
Other comprehensive loss | — | (0.3) | (0.3) | ||||||||||||||
Balance at September 30, 2021 | $ | (191.0) | $ | (10.9) | $ | (201.9) | |||||||||||
Balance at December 31, 2019 | $ | (83.6) | $ | (12.7) | $ | (96.3) | |||||||||||
Net loss | (12.2) | — | (12.2) | ||||||||||||||
Deferred compensation | 3.3 | — | 3.3 | ||||||||||||||
Capital distributions, net | (5.9) | — | (5.9) | ||||||||||||||
Other comprehensive income | — | 1.4 | 1.4 | ||||||||||||||
Balance at September 30, 2020 | $ | (98.4) | $ | (11.3) | $ | (109.7) |
September 30, 2021 | September 30, 2020 | ||||||||||
Subscription and maintenance:
|
|||||||||||
Subscription and maintenance | $ | 488.8 | $ | 464.0 | |||||||
Implementation services | 15.0 | 18.4 | |||||||||
Total subscription and maintenance | 503.8 | 482.4 | |||||||||
Content licenses and other products: | |||||||||||
Perpetual archive licenses | 138.8 | 112.1 | |||||||||
Books and other | 33.8 | 41.6 | |||||||||
Total content licenses and other products | 172.6 | 153.7 | |||||||||
Total revenues | $ | 676.4 | $ | 636.1 |
September 30, 2021 | December 31, 2020 | ||||||||||
Balance, at the beginning of the period
|
$ | 339.7 | $ | 271.4 | |||||||
Additions from acquisitions | — | 38.4 | |||||||||
Deferral of revenue | 535.8 | 684.3 | |||||||||
Recognition of deferred revenue | (504.6) | (654.4) | |||||||||
Balance, at the end of period | $ | 370.9 | $ | 339.7 |
September 31, 2021 | December 31, 2020 | ||||||||||
Balance, at the beginning of the period
|
$ | 8.1 | $ | 7.3 | |||||||
Additions from acquisitions
|
— | 0.6 | |||||||||
Costs associated with new projects | 6.0 | 5.0 | |||||||||
Costs amortized during the period | (7.0) | (4.8) | |||||||||
Balance, at the end of period | $ | 7.1 | $ | 8.1 |
Machinery and equipment
|
3 to 8 years | ||||
Furniture and fixtures
|
5 to 8 years | ||||
Computer software | 3 to 5 years |
Nine months ended September 30, 2021
|
As previously Reported | Effect of Change in Accounting Principle | As Reported | |||||||||||||||||
Depreciation and amortization
|
$ | 145.9 | $ | (47.5) | $ | 98.4 | ||||||||||||||
Net loss | (59.7) | 47.5 | (12.2) |
September 30, 2021 | |||||||||||||||||||||||
Level 1 | Level 2 | Level 3 | Total Fair Value | ||||||||||||||||||||
Financial assets | |||||||||||||||||||||||
Derivative financial instruments
|
$ | — | $ | 6.9 | $ | — | $ | 6.9 | |||||||||||||||
Total assets
|
— | 6.9 | — | 6.9 | |||||||||||||||||||
Financial liabilities | |||||||||||||||||||||||
Derivative financial instruments | — | 23.7 | — | 23.7 | |||||||||||||||||||
Contingent consideration | — | — | 0.5 | 0.5 | |||||||||||||||||||
Total liabilities
|
$ | — | $ | 23.7 | $ | 0.5 | $ | 24.2 |
December 31, 2020 | |||||||||||||||||||||||
Level 1 | Level 2 | Level 3 | Total Fair Value | ||||||||||||||||||||
Financial assets | |||||||||||||||||||||||
Derivative financial instruments
|
$ | — | $ | 1.0 | $ | — | $ | 1.0 | |||||||||||||||
Total assets
|
— | 1.0 | — | 1.0 | |||||||||||||||||||
Financial liabilities | |||||||||||||||||||||||
Derivative financial instruments | — | 36.7 | — | 36.7 | |||||||||||||||||||
Contingent consideration | — | — | 0.9 | 0.9 | |||||||||||||||||||
Total liabilities
|
$ | — | $ | 36.7 | $ | 0.9 | $ | 37.6 |
September 30, 2021 | December 31, 2020 | ||||||||||
Beginning balance
|
$ | 0.9 | $ | 4.7 | |||||||
Payments made on contingent liabilities | (0.4) | (2.9) | |||||||||
Gain on contingent considerations | — | (1.2) | |||||||||
Imputed interest | — | 0.3 | |||||||||
Ending balance | $ | 0.5 | $ | 0.9 |
2020 | |||||
Accounts receivable and other current assets | $ | 0.2 | |||
Intangible assets | 2.5 | ||||
Goodwill | 0.9 | ||||
Total assets | 3.6 | ||||
Accrued expenses and other liabilities | 0.1 | ||||
Deferred revenues | 0.8 | ||||
Total liabilities | 0.9 | ||||
Net assets acquired | 2.7 | ||||
Net assets acquired, net of cash | $ | 2.7 |
September 30, 2020 | ||||||||||||||||||||
As Reported | Innovative Proforma | As Adjusted | ||||||||||||||||||
Revenue
|
$ | 636.1 | $ | 3.5 | $ | 639.6 | ||||||||||||||
Net Loss | (12.2) | — | (12.2) |
2020 | |||||
Cash and cash equivalents | $ | 13.7 | |||
Accounts receivable and other current assets | 20.5 | ||||
Property and equipment, net | 1.6 | ||||
Intangible assets | 193.3 | ||||
Goodwill | 50.6 | ||||
Other long-term assets | 0.9 | ||||
Total assets | 280.6 | ||||
Accounts payable | 1.2 | ||||
Other current liabilities | 5.5 | ||||
Deferred revenues | 37.6 | ||||
Total liabilities | 44.3 | ||||
Net assets acquired | 236.3 | ||||
Net assets acquired, net of cash | $ | 222.6 |
Developed Technology | 15 years | $ | 91.1 | |||||
Customer Relationships | 16 years | 88.9 | ||||||
Trademarks | 13 years | 13.3 | ||||||
$ | 193.3 |
September 30, 2021
|
December 31, 2020
|
||||||||||
Trade | $ | 151.7 | $ | 146.5 | |||||||
Less allowance for bad debts | (6.2) | (7.7) | |||||||||
145.5 | 138.8 | ||||||||||
Less long-term receivables | (0.8) | (0.7) | |||||||||
Accounts receivable, net of allowances | $ | 144.7 | $ | 138.1 |
September 30, 2021
|
December 31, 2020
|
||||||||||
Property and equipment: | |||||||||||
Machinery and equipment | $ | 65.3 | $ | 65.4 | |||||||
Furniture and fixtures | 6.3 | 8.1 | |||||||||
Leasehold improvements | 13.3 | 13.3 | |||||||||
Computer software | 12.8 | 12.1 | |||||||||
Capital lease | 28.9 | 24.9 | |||||||||
Land and buildings | 1.5 | 1.5 | |||||||||
128.1 | 125.3 | ||||||||||
Less accumulated depreciation | (75.9) | (73.7) | |||||||||
Total property and equipment, net | $ | 52.2 | $ | 51.6 | |||||||
Content and software development: | |||||||||||
Capitalized content and software | $ | 728.0 | $ | 696.0 | |||||||
Internal software development | 37.9 | 34.3 | |||||||||
765.9 | 730.3 | ||||||||||
Less accumulated amortization | (653.5) | (620.9) | |||||||||
Total content and software development, net | $ | 112.4 | $ | 109.4 |
Total Goodwill | |||||
Balances as of December 31, 2020 | $ | 629.1 | |||
Additions | — | ||||
Foreign currency translation | — | ||||
Disposals | — | ||||
Balances as of September 30, 2021 | $ | 629.1 | |||
Balances as of December 31, 2019 | $ | 577.0 | |||
Additions(1)
|
51.5 | ||||
Foreign currency translation | 0.6 | ||||
Disposals | — | ||||
Balances as of December 31, 2020 | $ | 629.1 |
Subscription and Customer lists
|
Trademarks | Publisher relationships |
Databases and Developed Technology
|
Archive tapes and other | Totals | |||||||||||||||
As of December 31, 2020 | ||||||||||||||||||||
Gross carrying amount | $ | 346.3 | $ | 105.6 | $ | 47.1 | $ | 290.6 | $ | 38.8 | $ | 828.4 | ||||||||
Additions | (0.1) | (0.1) | — | 0.1 | — | (0.1) | ||||||||||||||
Disposals | — | — | — | — | (0.1) | (0.1) | ||||||||||||||
Gross balance as of September 30, 2021 | 346.2 | 105.5 | 47.1 | 290.7 | 38.7 | 828.2 | ||||||||||||||
Accumulated amortization as of December 31, 2020 | (191.1) | (77.0) | (42.9) | (199.9) | (32.6) | (543.5) | ||||||||||||||
Amortization expenses | (17.3) | (5.1) | (1.2) | (6.9) | (1.0) | (31.5) | ||||||||||||||
Foreign currency translation | — | — | — | — | — | — | ||||||||||||||
Disposals | — | — | — | — | 0.1 | 0.1 | ||||||||||||||
Accumulated amortization as of September 30, 2021 | (208.4) | (82.1) | (44.1) | (206.8) | (33.5) | (574.9) | ||||||||||||||
Net balances as of September 30, 2021 | $ | 137.8 | $ | 23.4 | $ | 3.0 | $ | 83.9 | $ | 5.2 | $ | 253.3 |
Subscription and Customer lists
|
Trademarks | Publisher relationships |
Databases and Developed Technology
|
Archive tapes and other | Totals | |||||||||||||||
As of December 31, 2019 | ||||||||||||||||||||
Gross carrying amount | $ | 264.2 | $ | 90.7 | $ | 47.1 | $ | 207.0 | $ | 44.7 | $ | 653.7 | ||||||||
Additions | 90.0 | 14.9 | — | 91.9 | 0.1 | 196.9 | ||||||||||||||
Disposals | (7.9) | — | — | (8.3) | (6.0) | (22.2) | ||||||||||||||
Gross balance as of December 31, 2020 | 346.3 | 105.6 | 47.1 | 290.6 | 38.8 | 828.4 | ||||||||||||||
Accumulated amortization as of December 31, 2019 | (173.4) | (70.2) | (40.9) | (171.3) | (35.6) | (491.4) | ||||||||||||||
Amortization expenses | (25.5) | (6.7) | (2.0) | (36.2) | (3.0) | (73.4) | ||||||||||||||
Foreign currency translation | (0.1) | (0.1) | — | 0.2 | — | — | ||||||||||||||
Disposals | 7.9 | — | — | 7.4 | 6.0 | 21.3 | ||||||||||||||
Accumulated amortization as of December 31, 2020 | (191.1) | (77.0) | (42.9) | (199.9) | (32.6) | (543.5) | ||||||||||||||
Net balances as of December 31, 2020 | $ | 155.2 | $ | 28.6 | $ | 4.2 | $ | 90.7 | $ | 6.2 | $ | 284.9 |
Foreign Exchange Translation Adjustment | |||||
Balance, December 31, 2020 | $ | (10.6) | |||
Currency translation | (0.3) | ||||
Balance, September 30, 2021 | $ | (10.9) | |||
Balance, December 31, 2019 | $ | (12.7) | |||
Currency translation | 1.4 | ||||
Balance, September 30, 2020 | $ | (11.3) |
September 30, 2021
|
December 31, 2020
|
||||||||||
Senior secured first lien credit facility due 2026 (a)
|
$ | 903.0 | $ | 1,016.8 | |||||||
Senior secured revolver loan (a)
|
— | — | |||||||||
Total Debt | 903.0 | 1,016.8 | |||||||||
Less current maturities | — | — | |||||||||
Long-term debt | $ | 903.0 | $ | 1,016.8 |
Year ending December 31, | |||||
2021 (excluding nine months ended September 30, 2021) | $ | — | |||
2022 | — | ||||
2023 | — | ||||
2024 | — | ||||
2025 | — | ||||
Thereafter | 917.3 | ||||
Total principal payments | $ | 917.3 | |||
Original issue and deferred financing cost | (14.3) | ||||
Total debt | $ | 903.0 |
Other current assets |
September 30, 2021
|
December 31, 2020
|
|||||||||
Prepaid cloud storage and software licensing expenses | $ | 13.2 | $ | 10.9 | |||||||
Capitalized commissions | 7.1 | 8.1 | |||||||||
Prepaid taxes | 7.0 | 6.1 | |||||||||
Derivatives | 6.9 | 1.0 | |||||||||
Prepaid royalties | 1.7 | 2.1 | |||||||||
Security deposits | 1.4 | 1.4 | |||||||||
Other prepaid expenses | 3.0 | 5.0 | |||||||||
Total other current assets | $ | 40.3 | $ | 34.6 |
Other long-term assets |
September 30, 2021
|
December 31, 2020
|
|||||||||
Long-term prepaid expenses | $ | 4.1 | $ | 3.7 | |||||||
Long-term accounts receivable | 0.8 | 0.7 | |||||||||
Long-term income taxes | 0.8 | 1.2 | |||||||||
Long-term deferred royalty | 0.8 | 1.6 | |||||||||
Other long-term receivables | 6.9 | 8.1 | |||||||||
Total other long-term assets | $ | 13.4 | $ | 15.3 |
Other current liabilities |
September 30, 2021
|
December 31, 2020
|
|||||||||
Derivatives | $ | 23.7 | $ | 8.5 | |||||||
Accrued other taxes | 10.5 | 10.2 | |||||||||
Reserve for self-insurance | 4.2 | 4.3 | |||||||||
Short term portion of contingent consideration | — | 0.4 | |||||||||
Other current liabilities | 7.6 | 9.8 | |||||||||
Total other current liabilities | $ | 46.0 | $ | 33.2 |
Other long-term liabilities |
September 30, 2021
|
December 31, 2020
|
|||||||||
Long-term severance payable | $ | 8.9 | $ | 10.5 | |||||||
Long-term income tax reserves | 5.1 | 4.7 | |||||||||
Long-term accrued royalty expense | 0.8 | 1.6 | |||||||||
Derivatives | — | 28.2 | |||||||||
Other long-term liabilities | 2.5 | 3.3 | |||||||||
Total other long-term liabilities | $ | 17.3 | $ | 48.3 |
2021
|
2020 | ||||||||||
Current tax provision | |||||||||||
Federal | $ | 3.3 | $ | 2.5 | |||||||
State | 1.1 | (0.7) | |||||||||
Foreign | 3.8 | 4.4 | |||||||||
$ | 8.2 | $ | 6.2 | ||||||||
Deferred tax provision | |||||||||||
Federal | $ | — | $ | (6.1) | |||||||
State | (0.2) | 0.4 | |||||||||
Foreign | 0.4 | (0.2) | |||||||||
$ | 0.2 | $ | (5.9) | ||||||||
Total expense | $ | 8.4 | $ | 0.3 |
Issuance of 46,910,923 shares(1)
|
$ | 1,094,901 | |||
Estimated cash consideration(2)
|
3,951,947 | ||||
Total purchase price | $ | 5,046,848 | |||
Estimated cash acquired(2)
|
(39,086) | ||||
Total purchase price, net of cash acquired | $ | 5,007,762 |
Historical | Pro Forma Adjustments | ||||||||||||||||||||||||||||
Clarivate
(As Restated) |
ProQuest | Acquisition and Related | Financing | Pro Forma Combined | |||||||||||||||||||||||||
Note 2 | Note 3 | Note 4 | |||||||||||||||||||||||||||
Assets | |||||||||||||||||||||||||||||
Current assets: | |||||||||||||||||||||||||||||
Cash and cash equivalents | $ | 2,479,880 | $ | 53,600 | $ | (3,990,822) | (c) | $ | 1,767,240 | (l) | $ | 309,898 | |||||||||||||||||
Restricted cash | 1,857,657 | 2,100 | — | (1,842,576) | (l) | 17,181 | |||||||||||||||||||||||
Accounts receivable, net of allowance for doubtful accounts | 610,755 | 144,700 | — | — | 755,455 | ||||||||||||||||||||||||
Prepaid expenses | 58,056 | 24,900 | — | — | 82,956 | ||||||||||||||||||||||||
Other current assets | 42,192 | 35,000 | (1,400) | (f) | — | 75,792 | |||||||||||||||||||||||
Total current assets | 5,048,540 | 260,300 | (3,992,222) | (75,336) | 1,241,282 | ||||||||||||||||||||||||
Property and equipment, net | 27,948 | 52,200 | — | — | 80,148 | ||||||||||||||||||||||||
Other intangible assets, net | 6,964,081 | 365,700 | 3,162,300 | (e) | — | 10,492,081 | |||||||||||||||||||||||
Goodwill | 5,999,322 | 629,100 | 1,093,131 | (e) | — | 7,721,553 | |||||||||||||||||||||||
Other non-current assets | 28,998 | 12,600 | — | — | 41,598 | ||||||||||||||||||||||||
Deferred income taxes | 28,469 | 800 | — | — | 29,269 | ||||||||||||||||||||||||
Operating lease right-of-use assets | 45,880 | — | 60,500 | (e) | — | 106,380 | |||||||||||||||||||||||
Total Assets | 18,143,238 | 1,320,700 | 323,709 | (75,336) | 19,712,311 | ||||||||||||||||||||||||
Liabilities and Shareholders' equity | |||||||||||||||||||||||||||||
Current liabilities: | |||||||||||||||||||||||||||||
Accounts payable | 94,494 | 34,500 | — | — | 128,994 | ||||||||||||||||||||||||
Accrued expenses and other current liabilities | 559,693 | 153,700 | (23,700) | (f) | — | 689,693 | |||||||||||||||||||||||
Current portion of deferred revenues | 579,935 | 363,000 | (90,700) | (e) | — | 852,235 | |||||||||||||||||||||||
Current portion of operating lease liabilities | 28,459 | — | 8,800 | (e) | — | 37,259 | |||||||||||||||||||||||
Current portion of long-term debt | 1,865,627 | — | — | (1,837,027) | (l) | 28,600 | |||||||||||||||||||||||
Total current liabilities | 3,128,208 | 551,200 | (105,600) | (1,837,027) | 1,736,781 | ||||||||||||||||||||||||
Long-term debt | 3,443,578 | 903,000 | (903,000) | (g) | 1,811,691 | (l) | 5,255,269 | ||||||||||||||||||||||
Warrant liabilities | 195,952 | — | — | — | 195,952 | ||||||||||||||||||||||||
Non-current portion of deferred revenues | 44,934 | 7,900 | (2,000) | (e) | — | 50,834 | |||||||||||||||||||||||
Other non-current liabilities | 49,960 | 43,600 | — | — | 93,560 | ||||||||||||||||||||||||
Deferred income taxes | 329,755 | 16,900 | 6,991 | (i) | — | 353,646 | |||||||||||||||||||||||
Operating lease liabilities | 58,443 | — | 52,900 | (e) | — | 111,343 | |||||||||||||||||||||||
Total liabilities | 7,250,830 | 1,522,600 | (950,709) | (25,336) | 7,797,385 | ||||||||||||||||||||||||
Commitments and contingencies | |||||||||||||||||||||||||||||
Shareholders’ equity: | |||||||||||||||||||||||||||||
Ordinary Shares | 10,810,130 | — | 1,094,901 | (c) | — | 11,905,031 | |||||||||||||||||||||||
Preferred Shares | 1,392,671 | — | — | — | 1,392,671 | ||||||||||||||||||||||||
Treasury Shares | (196,038) | — | — | — | (196,038) | ||||||||||||||||||||||||
Member's Equity | — | (191,000) | 191,000 | (h) | — | — | |||||||||||||||||||||||
Accumulated other comprehensive income (loss) | 318,008 | (10,900) | 10,900 | (h) | — | 318,008 | |||||||||||||||||||||||
Accumulated deficit | (1,432,363) | — | (22,383) | (h) | (50,000) | (l) | (1,504,746) | ||||||||||||||||||||||
Total shareholders’ equity | 10,892,408 | (201,900) | 1,274,418 | (50,000) | 11,914,926 | ||||||||||||||||||||||||
Total Liabilities and Shareholders’ equity | $ | 18,143,238 | $ | 1,320,700 | $ | 323,709 | $ | (75,336) | $ | 19,712,311 |
Historical | Pro Forma Adjustments | ||||||||||||||||||||||||||||||||||||||||
ProQuest | |||||||||||||||||||||||||||||||||||||||||
Clarivate
(As Restated) |
ProQuest | Acquisition and Related | Financing |
Pro Forma Combined
|
|||||||||||||||||||||||||||||||||||||
Note 2 | Note 3 | Note 4 | |||||||||||||||||||||||||||||||||||||||
Revenues, net | $ | 1,316,192 | $ | 676,400 | $ | (975) | (e) | $ | — | $ | 1,991,617 | ||||||||||||||||||||||||||||||
Operating costs and expenses: | |||||||||||||||||||||||||||||||||||||||||
Cost of revenues | (438,311) | (250,300) | — | — | (688,611) | ||||||||||||||||||||||||||||||||||||
Selling, general and administrative costs | (458,847) | (255,900) | — | — | (714,747) | ||||||||||||||||||||||||||||||||||||
Depreciation | (9,243) | (10,600) | — | — | (19,843) | ||||||||||||||||||||||||||||||||||||
Amortization | (383,270) | (64,100) | (74,092) | (e) | — | (521,462) | |||||||||||||||||||||||||||||||||||
Restructuring and impairment | (125,685) | — | — | — | (125,685) | ||||||||||||||||||||||||||||||||||||
Other operating (expense) income, net | (19,741) | 5,200 | — | — | (14,541) | ||||||||||||||||||||||||||||||||||||
Total operating expenses | (1,435,097) | (575,700) | (74,092) | — | (2,084,889) | ||||||||||||||||||||||||||||||||||||
(Loss) income from operations | (118,905) | 100,700 | (75,067) | — | (93,272) | ||||||||||||||||||||||||||||||||||||
Mark to market adjustment on financial instruments | 113,207 | — | — | — | 113,207 | ||||||||||||||||||||||||||||||||||||
Income (loss) before interest expense and income tax | (5,698) | 100,700 | (75,067) | — | 19,935 | ||||||||||||||||||||||||||||||||||||
Interest expense and amortization of debt discount, net | (141,156) | (22,500) | 22,500 | (g) | (41,890) | (m) | (183,046) | ||||||||||||||||||||||||||||||||||
(Loss) income before income tax | (146,854) | 78,200 | (52,567) | (41,890) | (163,111) | ||||||||||||||||||||||||||||||||||||
(Provision) benefit for income taxes | (12,240) | (8,400) | 543 | (i) | — | (20,097) | |||||||||||||||||||||||||||||||||||
Net (loss) income | $ | (159,094) | $ | 69,800 | $ | (52,024) | $ | (41,890) | $ | (183,208) | |||||||||||||||||||||||||||||||
Dividends on preferred shares | (22,431) | — | — | (34,171) | (n) | (56,602) | |||||||||||||||||||||||||||||||||||
Net (loss) income attributable to ordinary shares | $ | (181,525) | $ | 69,800 | $ | (52,024) | $ | (76,061) | $ | (239,810) | |||||||||||||||||||||||||||||||
Per share: | |||||||||||||||||||||||||||||||||||||||||
Basic and diluted | $ | (0.29) | $ | (0.35) | |||||||||||||||||||||||||||||||||||||
Weighted average shares used to compute loss per share: | |||||||||||||||||||||||||||||||||||||||||
Basic and diluted | 616,135,071 | 46,910,923 | (o) | 19,230,769 | (o) | 682,276,763 |
Historical | Pro Forma Adjustments | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DRG | CPA Global | ProQuest | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Clarivate
(As Restated) |
ProQuest | CPA Global | DRG | Acquisition and Related | Financing | Acquisition and Related | Financing | Acquisition and Related | Financing | Pro Forma Combined | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
Note 2 | Note 2 | Note 2 | Note 3 | Note 4 | Note 3 | Note 4 | Note 3 | Note 4 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Revenues, net | $ | 1,254,047 | $ | 862,900 | $ | 440,138 | $ | 23,215 | $ | — | $ | — | $ | — | $ | — | $ | (90,700) | (e) | $ | — | $ | 2,489,600 | ||||||||||||||||||||||||||||||||||||||||||
Operating costs and expenses: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cost of revenues | (438,787) | (327,400) | (139,989) | (14,918) | — | — | — | — | — | — | (921,094) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Selling, general and administrative costs | (544,700) | (318,700) | (170,127) | (66,368) | — | — | — | — | (38,875) | (d) | — | (1,138,770) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Depreciation | (12,709) | (14,700) | (3,047) | (1,273) | — | — | — | — | — | — | (31,729) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Amortization | (290,441) | (116,900) | (63,949) | (3,136) | (4,412) | (a) | — | (109,978) | (b) | — | (67,355) | (e) | — | (656,171) | |||||||||||||||||||||||||||||||||||||||||||||||||||
Restructuring and impairment | (56,138) | — | (5,928) | — | — | — | — | — | — | — | (62,066) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Other operating income (expense), net | 52,381 | (8,600) | 10,323 | 698 | — | — | — | — | — | — | 54,802 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total operating expenses | (1,290,394) | (786,300) | (372,717) | (84,997) | (4,412) | — | (109,978) | — | (106,230) | — | (2,755,028) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Income (loss) from operations | (36,347) | 76,600 | 67,421 | (61,782) | (4,412) | — | (109,978) | — | (196,930) | — | (265,428) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Market to market adjustment on financial instruments | (205,062) | — | — | — | — | — | — | — | — | — | (205,062) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Legal Settlement | — | — | (760) | — | — | — | — | — | — | — | (760) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
(Loss) income before interest expense and income tax | (241,409) | 76,600 | 66,661 | (61,782) | (4,412) | — | (109,978) | — | (196,930) | — | (471,250) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Interest expense and amortization of debt discount, net | (111,914) | (71,500) | (9,878) | (6,623) | — | 3,637 | (j) | — | (45,576) | (k) | 71,500 | (g) | (134,987) | (m) | (305,341) | ||||||||||||||||||||||||||||||||||||||||||||||||||
(Loss) income before income tax | (353,323) | 5,100 | 56,783 | (68,405) | (4,412) | 3,637 | (109,978) | (45,576) | (125,430) | (134,987) | (776,591) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Benefit (provision) for income taxes | 2,698 | (1,700) | (5,862) | 23,106 | 1,201 | (990) | 6,707 | — | 17,653 | (i) | — | 42,813 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Net (loss) income | (350,625) | 3,400 | 50,921 | (45,299) | (3,211) | 2,647 | (103,271) | (45,576) | (107,777) | (134,987) | (733,778) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Dividends on preferred shares | — | — | — | — | — | — | — | — | — | (75,469) | (n) | (75,469) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Net (loss) income attributable to ordinary shares | $ | (350,625) | $ | 3,400 | $ | 50,921 | $ | (45,299) | $ | (3,211) | $ | 2,647 | $ | (103,271) | $ | (45,576) | $ | (107,777) | $ | (210,456) | $ | (809,247) | |||||||||||||||||||||||||||||||||||||||||||
Per share: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Basic and diluted | $ | (0.82) | $ | (1.61) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Weighted average shares used to compute loss per share: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Basic and diluted | 427,023,558 | 46,910,923 | (o) | 28,846,154 | (o) | 502,780,635 |
DRG Historical Combined Statement of Comprehensive Loss Line Items | Clarivate Historical Consolidated Statement of Operations Line Items | DRG Historical Combined Statement of Comprehensive Loss | Reclassification (Rounded) | DRG Adjusted Historical Combined Statement of Operations (Unaudited, Rounded) | ||||||||||
Share-based compensation expense | $ | (47,387) | $ | 47,387 | $ | — | ||||||||
Selling, general and administrative costs | (18,981) | (47,387) | (66,368) |
CPA Global Holdings Limited Historical Combined Statement of Comprehensive Loss Line Items | Clarivate Historical Consolidated Statement of Operations Line Items | CPA Global Holdings Limited Historical Combined Statement of Comprehensive Loss | Reclassification (Rounded) | CPA Global Holdings Limited Adjusted Historical Combined Statement of Operations (Unaudited, Rounded) | ||||||||||
Transaction expenses | $ | (35,725) | $ | 35,725 | $ | — | ||||||||
Transition, integration and other related expenses | (5,374) | 5,374 | — | |||||||||||
Selling, general and administrative costs | Selling, general and administrative costs | (129,028) | (41,099) | (170,127) | ||||||||||
Related party interest expense | (8,523) | 8,523 | — | |||||||||||
Interest expense | Interest expense and amortization of debt discount, net | (1,355) | (8,523) | (9,878) |
ProQuest Historical Consolidated Statements of Financial Position Line Items | Clarivate Historical Consolidated Balance Sheet Line Items | ProQuest Historical Consolidated Statements of Financial Position | Reclassification (Rounded) | ProQuest Adjusted Historical Consolidated Statements of Financial Position | ||||||||||
Deferred Royalties | $ | 19,600 | $ | (19,600) | $ | — | ||||||||
Prepaid expenses | 24,900 | 24,900 | ||||||||||||
Other current assets | 40,300 | (5,300) | 35,000 | |||||||||||
Content and software development, net | 112,400 | (112,400) | — | |||||||||||
Other intangible assets, net | 253,300 | 112,400 | 365,700 | |||||||||||
Other non-current assets | Other non-current assets | 13,400 | (800) | 12,600 | ||||||||||
Deferred income taxes | — | 800 | 800 | |||||||||||
Accrued wages and benefits | 43,900 | (43,900) | — | |||||||||||
Accrued royalty costs | 63,800 | (63,800) | — | |||||||||||
Other current liabilities | 46,000 | (46,000) | — | |||||||||||
Accrued expenses and other current liabilities | — | 153,700 | 153,700 | |||||||||||
Long-term capital lease | 26,300 | (26,300) | — | |||||||||||
Other non-current liabilities | 17,300 | 26,300 | 43,600 |
ProQuest Historical Consolidated Statements of Operations Line Items | Clarivate Historical Consolidated Statement of Operations Line Items | ProQuest Historical Consolidated Statement of Comprehensive Income | Reclassification (Rounded) | ProQuest Adjusted Historical Consolidated Statement of Operations (Unaudited, Rounded) | ||||||||||
Cost of subscription and maintenance (exclusive of depreciation and amortization shown below) | $ | (137,700) | $ | 137,700 | $ | — | ||||||||
Cost of content licenses and other products (exclusive of depreciation and amortization shown below) | (112,600) | 112,600 | — | |||||||||||
Cost of revenues | — | (250,300) | (250,300) | |||||||||||
Selling, general and administrative | Selling, general and administrative | (195,900) | (60,000) | (255,900) | ||||||||||
Depreciation and amortization | (74,700) | 74,700 | — | |||||||||||
Depreciation | — | (10,600) | (10,600) | |||||||||||
Amortization | — | (64,100) | (64,100) | |||||||||||
Research and development | (54,500) | 54,500 | — | |||||||||||
Management fee - related party | (5,500) | 5,500 | — | |||||||||||
Interest expense, net | (36,000) | 36,000 | — | |||||||||||
Interest expense and amortization of debt discount, net | (22,500) | (22,500) | ||||||||||||
Unrealized gains on derivative instruments | 18,900 | (18,900) | — | |||||||||||
Foreign currency transaction losses | (200) | 200 | — | |||||||||||
Other operating income (expense), net | — | 5,200 | 5,200 |
ProQuest Historical Consolidated Statements of Operations Line Items | Clarivate Historical Consolidated Statement of Operations Line Items | ProQuest Historical Consolidated Statement of Comprehensive Income | Reclassification (Rounded) | ProQuest Adjusted Historical Consolidated Statement of Operations (Unaudited, Rounded) | ||||||||||
Cost of subscription and maintenance (exclusive of depreciation and amortization shown below) | $ | (191,000) | $ | 191,000 | $ | — | ||||||||
Cost of content licenses and other products (exclusive of depreciation and amortization shown below) | (136,400) | 136,400 | — | |||||||||||
Cost of revenues | (327,400) | (327,400) | ||||||||||||
Selling, general and administrative | Selling, general and administrative | (237,800) | (80,900) | (318,700) | ||||||||||
Depreciation and amortization | (131,600) | 131,600 | — | |||||||||||
Depreciation | — | (14,700) | (14,700) | |||||||||||
Amortization | — | (116,900) | (116,900) | |||||||||||
Research and development | (75,100) | 75,100 | — | |||||||||||
Management fee - related party | (7,000) | 7,000 | — | |||||||||||
Interest expense, net | (48,400) | 48,400 | — | |||||||||||
Interest expense and amortization of debt discount, net | (71,500) | (71,500) | ||||||||||||
Unrealized losses on derivative instruments | (30,600) | 30,600 | — | |||||||||||
Foreign currency transaction losses | (1,000) | 1,000 | — | |||||||||||
Other (expense) income | (100) | 100 | — | |||||||||||
Gain on contingent considerations | 1,200 | (1,200) | — | |||||||||||
Other operating income (expense), net | — | (8,600) | (8,600) |
Amortization Estimate | |||||||||||||||||
Estimated Fair Value
|
Remaining Range of Years |
Year Ended December 31, 2020
|
|||||||||||||||
Customer relationships | $ | 381,000 | 10-21 | $ | 3,757 | ||||||||||||
Database and content | 50,200 | 2-7 | 1,798 | ||||||||||||||
Tradenames | 5,200 | 4-7 | 217 | ||||||||||||||
Purchased software | 23,000 | 3-8 | 601 | ||||||||||||||
Backlog | 28,000 | 4 | 1,175 | ||||||||||||||
Total | $ | 487,400 | $ | 7,548 | |||||||||||||
Eliminate historical DRG amortization expense | (3,136) | ||||||||||||||||
Pro forma amortization adjustment | $ | 4,412 |
Amortization Estimate | |||||||||||||||||
Estimated Fair Value
|
Remaining Range of Years |
Year Ended December 31, 2020
|
|||||||||||||||
Customer relationships | $ | 4,643,306 | 17-23 | $ | 153,077 | ||||||||||||
Technology | 266,224 | 6-14 | 17,729 | ||||||||||||||
Trademarks | 10,787 | 2-17 | 3,121 | ||||||||||||||
Total | $ | 4,920,317 | $ | 173,927 | |||||||||||||
Eliminate historical CPA Global amortization expense | (63,949) | ||||||||||||||||
Pro forma amortization adjustment | $ | 109,978 |
Issuance of 46,910,923 shares | $ | 1,094,901 | |||
Estimated cash consideration(1)
|
3,951,947 | ||||
Adjusted purchase price | $ | 5,046,848 | |||
Estimated cash consideration(1)
|
$ | 3,951,947 | |||
Estimated transaction expenses(2)
|
38,875 | ||||
Pro forma adjustment to cash and cash equivalents | $ | 3,990,822 |
Transaction expenses contingent upon consummation of the acquisition | $ | 33,261 | |||
Additional transaction costs related to the ProQuest acquisition incurred subsequent to September 30, 2021 recognized within selling, general and administrative costs(1)
|
5,614 | ||||
Total Transaction Costs(2)
|
$ | 38,875 |
Assets assumed | $ | 385,000 | |||
Liabilities assumed | (548,000) | ||||
Accumulated deficit adjustment for removal of historical deferred tax liability for valuation allowance(1)
|
(16,492) | ||||
Net deferred tax liability | (23,891) | ||||
Identifiable intangible assets | 3,528,000 | ||||
Goodwill | 1,722,231 | ||||
Total estimated consideration | $ | 5,046,848 |
Estimated fair value of identified intangible assets | $ | 3,528,000 | |||
Pre-existing ProQuest intangible assets | 365,700 | ||||
Pro forma adjustment(1)
|
$ | 3,162,300 | |||
Estimated fair value of goodwill | $ | 1,722,231 | |||
Pre-existing ProQuest goodwill | 629,100 | ||||
Pro forma adjustment(2)
|
$ | 1,093,131 | |||
Estimated fair value of operating lease right-of-use assets | $ | 60,500 | |||
Pre-existing ProQuest operating lease right-of-use assets | — | ||||
Pro forma adjustment(3)
|
$ | 60,500 | |||
Estimated fair value of current portion of operating lease liability | $ | 8,800 | |||
Pre-existing ProQuest current portion of operating lease liability | — | ||||
Pro forma adjustment(4)
|
$ | 8,800 | |||
Estimated fair value of long-term portion of operating lease liability | $ | 52,900 | |||
Pre-existing ProQuest long-term portion of operating lease liability | — | ||||
Pro forma adjustment(4)
|
$ | 52,900 | |||
Estimated fair value of current portion of deferred revenues | $ | 272,300 | |||
Pre-existing ProQuest current portion of deferred revenues | 363,000 | ||||
Pro forma adjustment(5)
|
$ | (90,700) | |||
Estimated fair value of non-current portion of deferred revenues | $ | 5,900 | |||
Pre-existing ProQuest non-current portion of deferred revenues | 7,900 | ||||
Pro forma adjustment(6)
|
$ | (2,000) |
Estimated Fair Value | Remaining Range of Years | ||||||||||
Customer relationships | $ | 2,773,000 | 17-23 | ||||||||
Technology & databases | 709,300 | 5-17 | |||||||||
Trademarks | 45,700 | 2-10 | |||||||||
Total | $ | 3,528,000 |
Amortization Estimate | |||||||||||
Nine Months Ended September 30, 2021 | Year Ended December 31, 2020 | ||||||||||
Customer relationships | $ | 92,473 | $ | 123,296 | |||||||
Technology & databases | 41,052 | 54,737 | |||||||||
Trademarks | 4,667 | 6,222 | |||||||||
Total | $ | 138,192 | $ | 184,255 | |||||||
Eliminate historical amortization expense | (64,100) | (116,900) | |||||||||
Pro forma amortization adjustment | $ | 74,092 | $ | 67,355 |
Nine Months Ended September 30, 2021 | Year Ended December 31, 2020 | ||||||||||
Eliminate historical interest expense | $ | 34,000 | $ | 45,900 | |||||||
Eliminate historical (gains) losses for interest rate swap | (13,500) | 23,100 | |||||||||
Eliminate historical amortization of deferred financing costs | 2,000 | 2,500 | |||||||||
Total | $ | 22,500 | $ | 71,500 |
Member's equity | Ordinary shares | Accumulated Other Comprehensive Loss | Accumulated Deficit | ||||||||||||||||||||
Shares issued to ProQuest owners(1)
|
$ | — | $ | 1,094,901 | $ | — | $ | — | |||||||||||||||
Elimination of historical shareholders' equity(2)
|
191,000 | — | 10,900 | (22,383) | |||||||||||||||||||
$ | 191,000 | $ | 1,094,901 | $ | 10,900 | $ | (22,383) |
Estimated fair value of deferred tax liabilities | $ | 23,891 | ||||||
Pre-existing ProQuest deferred tax liabilities | (16,900) | |||||||
Pro forma adjustment | $ | 6,991 |
Nine Months Ended September 30, 2021 | Year Ended December 31, 2020 | ||||||||||
Tax effect of the pro forma adjustments based on the estimated blended statutory income tax rate of 7.5%(1)
|
$ | 543 | $ | 1,161 | |||||||
Historical deferred tax liability removed for valuation allowance(2)
|
— | 16,492 | |||||||||
Pro forma adjustment | $ | 543 | $ | 17,653 |
Year Ended
December 31, 2020
|
|||||
Estimated interest expense on new financing (1)
|
$ | (2,944) | |||
Elimination of historical interest expenses (2)
|
2,801 | ||||
Amortization of deferred financing costs (3)
|
(42) | ||||
Remove historical DRG amortization of deferred financing costs (4)
|
3,822 | ||||
Total pro forma adjustment to interest expense | $ | 3,637 |
Year Ended December 31, 2020
|
|||||
Estimated interest expense on new financing (1)
|
$ | (52,155) | |||
Elimination of historical interest expenses (2)
|
9,877 | ||||
Amortization of deferred financing costs (3)
|
(3,298) | ||||
Total pro forma adjustment to interest expense | $ | (45,576) |
September 30, 2021 | |||||
Reclassification of cash proceeds from long-term debt held in segregated escrow accounts as of September 30, 2021 | $ | 1,842,576 | |||
Payment of bridge commitment and structuring fees contingent upon consummation of the acquisition | (50,000) | ||||
Discount on debt for the underwriter's fee contingent upon consummation of the acquisition | (25,336) | ||||
Pro forma cash and cash equivalents adjustment | $ | 1,767,240 | |||
Reclassification of cash proceeds from long-term debt held in segregated escrow accounts as of September 30, 2021 | $ | (1,842,576) | |||
Pro forma restricted cash adjustment | $ | (1,842,576) | |||
Reclassification of long-term debt in accordance with the escrow conditions, net of $7,471 of deferred financing costs(1)
|
$ | (1,837,027) | |||
Pro forma current portion of long-term debt adjustment | $ | (1,837,027) | |||
Reclassification of long-term debt in accordance with the escrow conditions, net of $7,471 of deferred financing costs(1)
|
$ | 1,837,027 | |||
Discount on debt for the underwriter's fee contingent upon consummation of the acquisition | (25,336) | ||||
Pro forma long-term debt adjustment | $ | 1,811,691 |
Nine Months Ended September 30, 2021 | Year Ended December 31, 2020 | ||||||||||
Interest expense on new financings(1)
|
$ | (38,860) | $ | (80,614) | |||||||
Amortization of deferred financing costs(2)
|
(3,030) | (4,373) | |||||||||
Bridge commitment fees in connection with the new notes(3)
|
— | (50,000) | |||||||||
Pro forma amortization adjustment | $ | (41,890) | $ | (134,987) |
Nine Months Ended September 30, 2021 | Year Ended December 31, 2020 | ||||||||||
Dividends on our convertible preferred shares at an annual rate of 5.25%(1)
|
$ | (34,171) | $ | (75,469) | |||||||
Pro forma dividends on preferred shares adjustment | $ | (34,171) | $ | (75,469) |
Nine Months Ended September 30, 2021 | Year Ended December 31, 2020 | ||||||||||
Historical weighted average shares outstanding - basic and diluted | 616,135,071 | 427,023,558 | |||||||||
Equity consideration in connection with the ProQuest Transactions | 46,910,923 | 46,910,923 | |||||||||
Equity consideration in connection with the Primary Offering(1)
|
19,230,769 | 28,846,154 | |||||||||
Pro forma weighted average shares outstanding - basic and diluted | 682,276,763 | 502,780,635 |