feyninc/tacha huggingface dataset:
## Table

|  | FY19 | FY18 | Growth % | Growth % |
|---|---|---|---|---|
|  | $m (Reported) | $m (Reported) | (Reported) | (CC) |
| Billings by Region: |  |  |  |  |
| - Americas | 267.8 | 270.0 | (0.8) | (0.7) |
| - EMEA | 395.3 | 395.1 | 0.1 | 0.9 |
| - APJ | 97.2 | 103.5 | (6.1) | (2.8) |
|  | 760.3 | 768.6 | (1.1) | (0.1) |
| Billings by Product: |  |  |  |  |
| – Network | 345.9 | 353.4 | (2.1) | (1.1) |
| – Enduser | 377.1 | 383.2 | (1.6) | (0.7) |
| – Other | 37.3 | 32.0 | 16.6 | 17.1 |
|  | 760.3 | 768.6 | (1.1) | (0.1) |
| Billings by Type: |  |  |  |  |
| – Subscription | 644.6 | 644.2 | 0.1 | 1.0 |
| – Hardware | 105.7 | 113.7 | (7.0) | (6.1) |
| – Other | 10.0 | 10.7 | (6.5) | (4.6) |
|  | 760.3 | 768.6 | (1.1) | (0.1) |



## Text

Billings


Group reported billings decreased by $8.3 million or 1.1 per cent to $760.3 million in the year-ended 31 March 2019. This represented a 0.1 per cent decrease on a constant currency (“CC”) basis.


Billings by region


Americas Billings attributable to the Americas decreased by $2.2 million to $267.8 million in the period, representing a 0.8 per cent reduction on a reported basis and 0.7 per cent on a constant currency basis; this decrease largely driven by a decline in Enduser products due to the stronger performance in the prior-year compare as a consequence of the impact of the WannaCry ransomware outbreak and the launch of Intercept X, the Group’s next-gen endpoint product, partially offset by an improved performance in UTM sales.


EMEA Billings attributable to EMEA increased by $0.2 million to $395.3 million in the period, representing 0.1 per cent growth on a reported basis and 0.9 per cent growth on a constant currency basis. An increase in sales of Server products being partially offset by a reduction in endpoint and email products.


APJ Billings attributable to APJ decreased by $6.3 million to $97.2 million in the period, representing 6.1 per cent on a reported basis and 2.8 per cent on a constant currency basis. As in the Americas, growth was negatively impacted by the stronger performance in the prior-year compare compounded by a legacy Network product transition in the first-half of the year partially offset by an improvement in sales of Server products.
## Table

| (In millions) | Food Care | Product Care | Total |
|---|---|---|---|
| Gross Carrying Value at December 31, 2017 | $ 576.5 | $ 1,554.1 | $ 2,130.6 |
| Accumulated impairment | (49.6 ) | (141.2) | (190.8) |
| Carrying Value at December 31, 2017 | $ 526.9 | $ 1,412.9 | $ 1,939.8 |
| Acquisition, purchase price and other adjustments | (0.6 ) | 18.2 | 17.6 |
| Currency translation | (6.6 ) | (3.2) | (9.8) |
| Gross Carrying Value at December 31, 2018 | $ 568.9 | $ 1,568.9 | $ 2,137.8 |
| Accumulated impairment | (49.2 ) | (141.0) | (190.2) |
| Carrying Value at December 31, 2018 | $ 519.7 | $ 1,427.9 | $ 1,947.6 |
| Acquisition, purchase price and other adjustments | 6.3 | 257.0 | 263.3 |
| Currency translation | 2.0 | 4.1 | 6.1 |
| Gross Carrying Value at December 31, 2019 | $ 577.2 | $ 1,830.0 | $ 2,407.2 |
| Accumulated impairment | (49.3 ) | (141.0) | (190.3) |
| Carrying Value at December 31, 2019 | $ 527.9 | $ 1,689.0 | $ 2,216.9 |



## Text

Allocation of Goodwill to Reporting Segment


The following table shows our goodwill balances by reportable segment:


As noted above, it was determined under a quantitative assessment that there was no impairment of goodwill. However, if we become aware of indicators of impairment in future periods, we may be required to perform an interim assessment for some or all of our reporting units before the next annual assessment. Examples of such indicators may include a decrease in expected net earnings, adverse equity market conditions, a decline in current market multiples, a decline in our common stock price, a significant adverse change in legal factors or business climates, an adverse action or assessment by a regulator, unanticipated competition, strategic decisions made in response to economic or competitive conditions, or a more likely than not expectation that a reporting unit or a significant portion of a reporting unit will be sold or disposed of. In the event of significant adverse changes of the nature described above, we may have to recognize a non-cash impairment of goodwill, which could have a material adverse effect on our consolidated financial condition and results of operations.
## Table

|  |  | At December 31, 2019 |  |
|---|---|---|---|
|  | Gross Carrying Amount | Unamortized Discount and Deferred Financing Costs | Net Carrying Amount |
| 2021 Notes | $650 | $(2) | $648 |
| 2022 Notes | 400 | (2) | 398 |
| 2026 Notes | 850 | (7) | 843 |
| 2027 Notes | 400 | (5) | 395 |
| 2047 Notes | 400 | (9) | 391 |
| Total long-term debt | $2,700 | $(25) | $2,675 |
|  |  | At December 31, 2018 |  |
|  | Gross Carrying Amount | Unamortized Discount and Deferred Financing Costs | Net Carrying Amount |
| 2021 Notes | 650 | (3) | 647 |
| 2022 Notes | 400 | (3) | 397 |
| 2026 Notes | 850 | (8) | 842 |
| 2027 Notes | 400 | (5) | 395 |
| 2047 Notes | 400 | (10) | 390 |
| Total long-term debt | $2,700 | $(29) | $2,671 |



## Text

Interest expense and financing costs


Fees and discounts associated with the issuance of our debt instruments are recorded as debt discount, which reduces their respective carrying values, and are amortized over their respective terms. Amortization expense is recorded within “Interest and other expense (income), net” in our consolidated statement of operations.


For the years ended December 31, 2019, 2018, and 2017: interest expense was $86 million, $134 million, and $150 million, respectively; amortization of the debt discount and deferred financing costs was $4 million, $6 million, and $12 million, respectively.


A summary of our outstanding debt is as follows (amounts in millions):


With the exception of the 2026 and the 2047 Notes, using Level 2 inputs (i.e., observable market prices in less-than-active markets) at December 31, 2019, the carrying values of the Notes approximated their fair values, as the interest rates were similar to the current rates at which we could borrow funds over the selected interest periods. At December 31, 2019, based on Level 2 inputs, the fair value of the 2026 and the 2047 Notes were $893 million and $456 million, respectively.


Using Level 2 inputs at December 31, 2018, the carrying values of the 2021 Notes and the 2022 Notes approximated their fair values, as the interest rates were similar to the current rates at which we could borrow funds over the selected interest periods. At December 31, 2019, based on Level 2 inputs, the fair values of the 2026 Notes, the 2027 Notes, and the 2047 Notes were $800 million, $376 million, and $360 million, respectively.
## Table

|  |  | Year ended March 31,  |  |
|---|---|---|---|
|  | 2019 | 2018 | 2017 |
| Tax at statutory rate | 19.0% | 19.0% | 20.0% |
| U.S. state taxes, net of federal | 31.1 | 14.1 | (1.0) |
| Foreign rate differential   | 26.3 | 36.8 | (39.3) |
| Meals and entertainment   | (11.4) | (3.1) | (7.4) |
| Branch income / loss   | (0.6) | 0.4 | 0.9 |
| Share-based compensation | 172.3 | 105.3 | (4.0) |
| Foreign exchange   | — | — | (24.8) |
| Non-deductible interest expense   | — | — | (3.3) |
| Tax credits | 7.7 | 8.1 | 15.6 |
| Unremitted earnings   | (3.8) | (1.2) | — |
| Change in valuation allowance   | (249.9) | (110.7) | 124.7 |
| Deferred tax true-ups   | (3.5) | 8.4 | (12.4) |
| Tax reserves   | (4.9) | (21.5) | (117.7) |
| Provision to return   | (0.1) | 0.4 | (0.7) |
| Withholding taxes   | (2.6) | (3.5) | — |
| Other foreign taxes   | — | — | (6.7) |
| Non-deductible expenses   | (5.2) | (2.4) | (10.6) |
| Deferred tax rate change   | (6.3) | (77.8) | (1.3) |
| Acquisition related costs   | (7.6) | — | — |
| Other   | (0.5) | (0.2) | — |
| Effective Tax Rate   | (40.0)% | (27.9)% | (68.0)% |



## Text

The reconciliation of the United Kingdom statutory tax rate to the Company’s effective tax rate included in the accompanying consolidated statements of operations is as follows:


Although the Company’s parent entity is organized under Jersey law, our affairs are, and are intended to be, managed and controlled ongoing in the United Kingdom. Therefore, the Company is resident in the United Kingdom for tax purposes. The Company’s parent entity is domiciled in the United Kingdom and its earnings are subject to 19%, 19% and 20% statutory tax rate for the years ended March 31, 2019, 2018 and 2017, respectively.


The Company’s effective tax rate differs from the statutory rate each year primarily due to windfall tax benefits on equity award exercises, the valuation allowance maintained against the Company’s net deferred tax assets, the jurisdictional earnings mix, tax credits, withholding taxes, and other permanent differences primarily related to non-deductible expenses.
## Table

|  |  |  | Payments Due by Year |  |  |
|---|---|---|---|---|---|
|  |  | Less Than | 1 - 3 | 3 - 5 | More Than |
|  | Total | 1 Year | Years | Years | 5 Years |
| Long-term debt obligations | $482,892 | $17,684 | $98,571 | $37,496 | $329,141 |
| Interest payments (1) . | 168,040 | 17,276 | 29,533 | 27,409 | 93,822 |
| Operating lease obligations | 162,913 | 15,153 | 28,771 | 26,708 | 92,281 |
| Purchase obligations (2) . | 1,424,267 | 900,200 | 221,888 | 187,277 | 114,902 |
| Recycling obligations . | 137,761 | — | — | — | 137,761 |
| Contingent consideration (3) . | 6,895 | 2,395 | 4,500 | — | — |
| Transition tax obligations (4) . | 76,667 | 6,620 | 14,747 | 32,259 | 23,041 |
| Other obligations (5) . | 10,527 | 2,933 | 5,164 | 2,430 | — |
| Total . | $2,469,962 | $962,261 | $403,174 | $313,579 | $790,948 |



## Text

Contractual Obligations


The following table presents the payments due by fiscal year for our outstanding contractual obligations as of December 31, 2019 (in thousands):


(1) Includes estimated cash interest to be paid over the remaining terms of the underlying debt. Interest payments are based on fixed and floating rates as of December 31, 2019.


(2) Purchase obligations represent agreements to purchase goods or services, including open purchase orders and contracts with fixed volume commitments, that are noncancelable or cancelable with a significant penalty. Purchase obligations for our long-term supply agreements for the purchase of substrate glass and cover glass represent specified termination penalties, which are up to $430 million in the aggregate under the agreements. Our actual purchases under these supply agreements are expected to be approximately $2.4 billion of substrate glass and $500 million of cover glass.


(3) In connection with business or project acquisitions, we may agree to pay additional amounts to the selling parties upon achievement of certain milestones. See Note 14. “Commitments and Contingencies” to our consolidated financial statements for further information.


(4) Transition tax obligations represent estimated payments for U.S. federal taxes associated with accumulated earnings and profits of our foreign corporate subsidiaries. See Note 18. “Income Taxes” to our consolidated financial statements for further information.


(5) Includes expected letter of credit fees and unused revolver fees.


We have excluded $72.2 million of unrecognized tax benefits from the amounts presented above as the timing of such obligations is uncertain.
## Table

|  |  |  | As of June 30, |  |  |
|---|---|---|---|---|---|
|  | 2019 | 2018 | 2017 | 2016 | 2015 |
|  |  | (U.S. $ in thousands) |  |  |  |
|  |  | *As Adjusted | *As Adjusted |  |  |
| Cash and cash equivalents | $1,268,441 | $1,410,339 | $244,420 | $259,709 | $187,094 |
| Short-term investments | 445,046 | 323,134 | 305,499 | 483,405 | 30,251 |
| Derivative assets | 215,233 | 99,995 | 3,252 | — | — |
| Working capital | (287,597) | 1,377,145 | 296,984 | 542,038 | 50,477 |
| Total assets | 2,977,258 | 2,421,828 | 1,282,117 | 990,973 | 397,161 |
| Deferred revenue | 468,820 | 342,871 | 245,195 | 181,068 | 136,565 |
| Derivative liabilities | 855,079 | 207,970 | — | — | — |
| Exchangeable senior notes, net | 853,576 | 819,637 | — | — | — |
| Total liabilities | 2,411,791 | 1,514,508 | 379,424 | 259,310 | 207,107 |
| Share capital | 24,199 | 23,531 | 22,726 | 21,620 | 18,461 |
| Total equity | 565,467 | 907,320 | 902,693 | 731,663 | 190,054 |



## Text

Consolidated Statements of Financial Position Data:


* Adjusted IFRS balances to reflect the impact of the full retrospective adoption of IFRS 15. See Note 2 of the notes to our consolidated financial statements for further details.
## Table

|  |  | April 26, 2019 |  |
|---|---|---|---|
|  |  | Fair Value Measurements at Reporting Date Using |  |
|  | Total | Level 1 | Level 2 |
| Cash | $ 2,216 | $  2,216 | $  — |
| Corporate bonds | 1,353 | — | 1,353 |
| U.S. Treasury and government debt securities | 213 | 131 | 82 |
| Certificates of deposit | 117 | — | 117 |
| Total cash, cash equivalents and short-term investments | $ 3,899 | $ 2,347 | $ 1,552 |
| Other items: |  |  |  |
| Mutual funds (1) | $ 6 | $  6 | $  — |
| Mutual funds (2) | $ 29 | $  29 | $  — |
| Foreign currency exchange contracts assets (1) | $ 4 | $  — | $ 4 |
| Foreign currency exchange contracts liabilities (3) | (1 ) | $  — | (1 ) |



## Text

Fair Value of Financial Instruments


The following table summarizes our financial assets and liabilities measured at fair value on a recurring basis (in millions):


(1) Reported as other current assets in the consolidated balance sheets


(2) Reported as other non-current assets in the consolidated balance sheets


(3) Reported as accrued expenses in the consolidated balance sheets
## Table

|  |  | Years Ended December 31, |  |
|---|---|---|---|
|  | 2019 | 2018 | 2017 |
| Income taxes per federal statutory rate | $14,111 | $36,199 | $69,348 |
| State income taxes, net of federal deduction | 10 | 2,372 | 1,794 |
| Transition tax - U.S. Tax Reform | — | 1,174 | 61,690 |
| Corporate tax rate changes - U.S. Tax Reform | — | (652) | 11,177 |
| Tax benefit associated with inverter business wind down | — | — | (33,837) |
| Stock based compensation | (97) | (974) | (5,263) |
| GILTI Tax | 8,796 | 13,064 | — |
| Tax effect of foreign operations | (13,086) | (19,162) | (47,482) |
| Uncertain tax position | (4,487) | (3,088) | 4,948 |
| Unremitted earnings | 1,624 | 2,564 | — |
| Tax credits | (6,280) | (9,844) | (658) |
| Change in valuation allowance | 7,222 | (1,306) | 841 |
| Withholding taxes | 6,500 | 1,371 | — |
| Other permanent items, net | (3,614) | 3,509 | (468) |
| Total provision for income taxes | $10,699 | $25,227 | $62,090 |



## Text

ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)


The Company’s effective tax rate differs from the U.S. federal statutory rate of 35% for the year ended December 31, 2017, primarily due to the benefit related to the wind down of our solar inverter business and earnings in foreign jurisdictions, which are subject to lower tax rates, offset by the impact of U.S. tax reform. The principal causes of the difference between the federal statutory rate and the effective income tax rate for each the years below are as follows:
## Table

|  | Fiscal Year Ended June 30, |  |  |
|---|---|---|---|
|  | 2019 | 2018 | 2017 |
|  |  | (U.S. $ in thousands, except per share data) |  |
|  |  | *As Adjusted | *As Adjusted |
| Numerator: |  |  |  |
| Net loss attributable to ordinary shareholders | $(637,621) | $(113,432) | $(37,449) |
| Denominator: |  |  |  |
| Weighted-average ordinary shares outstanding—basic | 238,611 | 231,184 | 222,224 |
| Weighted-average ordinary shares outstanding—diluted | 238,611 | 231,184 | 222,224 |
| Net loss per share attributable to ordinary shareholders: |  |  |  |
| Basic net loss per share | $(2.67) | $(0.49) | $(0.17) |
| Diluted net loss per share | $(2.67) | $(0.49) | $(0.17) |



## Text

17. Earnings Per Share


Basic earnings per share is computed by dividing the net income attributable to ordinary shareholders by the weighted-average number of ordinary shares outstanding during the period. Diluted earnings per share is computed by giving effect to all potential weighted-average dilutive shares. The dilutive effect of outstanding awards is reflected in diluted earnings per share by application of the treasury stock method.


A reconciliation of the calculation of basic and diluted loss per share is as follows:


* As adjusted to reflect the impact of the full retrospective adoption of IFRS 15. See Note 2 for further details.


For fiscal years ended June 30, 2019, 2018 and 2017 , 9.6 million, 12.8 million and 13.8 million, respectively of potentially anti-dilutive shares were excluded from the computation of net loss per share.
## Table

|  |  |  | RESTRUCTURING, ONEROUS |  |
|---|---|---|---|---|
|  |  |  | CONTRACTS, STORE EXIT COSTS, |  |
|  | SELF‑INSURED RISKS |  | AND OTHER |  |
|  | 2019 | 2018 | 2019 | 2018 |
|  | $M | $M | $M | $M |
| Movement: |  |  |  |  |
| Balance at start of period | 596 | 593 | 679 | 800 |
| Net provisions recognised/(reversed) (1) | 177 | 161 | 225 | 55 |
| Cash payments | (157) | (148) | (162) | (178) |
| Other | (13) | (10) | (5) | 2 |
| Balance at end of period | 603 | 596 | 737 | 679 |
| Current | 173 | 177 | 280 | 256 |
| Non‑current | 430 | 419 | 457 | 423 |
|  | 603 | 596 | 737 | 679 |



## Text

Movements in total self‐insured risks, restructuring, onerous contracts, store exit costs, and other provisions


(1) The increase in restructuring, onerous contracts, and store exit costs in 2019 is primarily attributable to the recognition of provisions associated with the BIG W network review as outlined in Note 1.4.


A provision is recognised when the Group has a present legal or constructive obligation as a result of a past event, it is probable that an outflow of economic benefits will be required to settle the obligation, and a reliable estimate can be made as to the amount of the obligation. The amount recognised is the best estimate of the consideration required to settle the present obligation at the reporting date, taking into account the risks and uncertainties surrounding the obligation.


A liability is recognised for benefits accruing to employees in respect of annual leave and long service leave.


Liabilities expected to be settled within 12 months are measured at their nominal values using the remuneration rate expected to apply at the time of settlement.


Liabilities which are not expected to be settled within 12 months are measured as the present value of the estimated future cash outflows to be made by the Group in respect of services provided by employees up to the reporting date.


The provision for self-insured risks primarily represents the estimated liability for workers’ compensation and public liability claims.


Provision for restructuring is recognised when the Group has developed a detailed formal plan for the restructuring and has raised a valid expectation in those affected by the restructuring that the restructuring will occur.


An onerous contract is a contract in which the unavoidable costs of meeting the obligations under the contract exceed the economic benefits expected to be received under it. The unavoidable costs under a contract reflect the least net cost of exiting from the contract, which is the lower of the cost of fulfilling it and any compensation or penalties arising from failure to fulfil it.
## Table

|  |  | Year Ended December 31, |  |  |  |
|---|---|---|---|---|---|
| (In thousands) | 2019 | 2018 | 2017 | 2019 $ Change from 2018 | 2018 $ Change from 2017 |
| Proceeds from sale or issuance of common stock | $0 | $1,283 | $1,568 | $(1,283) | $(285) |
| Taxes paid related to net share settlement of equity awards | (7,286) | (9,466) | (7,269) | 2,180 | (2,197) |
| Proceeds from issuance of 0.875% Convertible Senior Notes | 218,000 | 0 | 0 | 218,000 | 0 |
| Payments for issuance costs on 0.875% Convertible Senior Notes | (5,445) | 0 | 0 | (5,445) | 0 |
| Payments for capped call transaction on 0.875% Convertible Senior Notes | (17,222) | 0 | 0 | (17,222) | 0 |
| Credit facility payments | (220,000) | (713,751) | (138,139) | 493,751 | (575,612) |
| Credit facility borrowings, net of issuance costs | 279,241 | 430,843 | 325,001 | (151,602) | 105,842 |
| Repurchase of common stock | (111,460) | (138,928) | (12,077) | 27,468 | (126,851) |
| Payment of acquisition and other financing obligations | (14,685) | (5,198) | (1,283) | (9,487) | (3,915) |
| Purchases of subsidiary shares owned by non-controlling interest | (53,800) | (7,198) | 0 | (46,602) | (7,198) |
| Net cash provided by (used in) financing activities - continuing operations | 67,343 | (442,415) | 167,801 | 509,758 | (610,216) |
| Net cash provided by (used in) financing activities - discontinued operations | 0 | 149,432 | 30,784 | (149,432) | 118,648 |
| Net cash provided (used in) by financing activities | $67,343 | $(292,983) | $198,585 | $360,326 | $(491,568) |



## Text

Financing Cash Flow Activities


Year Ended December 31, 2019 Compared with the Year Ended December 31, 2018


Net cash provided by financing activities – continuing operations increased during the year ended December 31, 2019 primarily due to inflows resulting from (i) the issuance of the 0.875% Convertible Senior Notes, (ii) lower credit facility payments, partially offset with less credit facility borrowings and (iii) a decrease in the repurchase of common stock. These were partially offset by the purchase of the remaining minority interest in Pulse8 during 2019.


Year Ended December 31, 2018 Compared with the Year Ended December 31, 2017


We used cash in financing activities – continuing operations during the year ended December 31, 2018 compared with cash inflows from financing activities – continuing operations during the year ended December 31, 2017, which was primarily driven by higher repayments of borrowings outstanding under our senior secured credit facility and higher common stock repurchases. We used a portion of the proceeds from the sale of our investment in Netsmart to repay balances outstanding under our senior secured credit facilities at the end of 2018. We borrowed funds in 2018 to purchase Practice Fusion and Health Grid and to acquire the remaining outstanding minority interest in which we initially acquired a controlling interest in April 2015.


Net cash provided by financing activities – discontinued operations increased during the year ended December 31, 2018 compared with the prior year primarily due to higher borrowings by Netsmart used to finance business acquisitions.