hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Revenue from external customers, classified by significant product and service offerings, was as follows:
Our commercial cloud revenue, which includes Office 365 Commercial, Azure, the commercial portion of LinkedIn, Dynamics 365, and other commercial cloud properties, was $38.1 billion, $26.6 billion and $16.2 billion in fiscal years 2019, 2018, and 2017, respectively. These amounts are primarily included in Office products and cloud services, Server products and cloud services, and LinkedIn in the table above.
Table:
 |  | (In millions) | 
Year Ended June 30, | 2019 | 2018 | 2017
Server products and cloud services | $ 32,622 | $ 26,129 | $ 21,649
Office products and cloud services | 31,769 | 28,316 | 25,573
Windows | 20,395 | 19,518 | 18,593
Gaming | 11,386 | 10,353 | 9,051
Search advertising | 7,628 | 7,012 | 6,219
LinkedIn | 6,754 | 5,259 | 2,271
Enterprise Services | 6,124 | 5,846 | 5,542
Devices | 6,095 | 5,134 | 5,062
Other | 3,070 | 2,793 | 2,611
Total | $  125,843 | $  110,360 | $   96,571


Question: How much revenue came from LinkedIn in 2019?
Answer: 6,754
Compensation of Key Management Personnel (Including Directors)
Short-term employee benefits comprise fees, salaries, benefits and bonuses earned during the year as well as nonmonetary benefits.
Post-employment benefits comprise the cost of providing defined contribution pensions to senior management in respect of the current period.
Share-based payments comprise the cost of senior management’s participation in share-based payment plans for the period as measured by the fair value of awards in accordance with IFRS2.
Table:
 | Year-ended 31 March 2019 | Year-ended 31 March 2018
 | $M | $M
Short-term employee benefits | 6.6 | 9.1
Post-employment benefits | 0.1 | 0.1
Share-based payments - equity-settled | 10.4 | 17.7
Total | 17.1 | 26.9


Question: What do post-employment benefits comprise?
Answer: the cost of providing defined contribution pensions to senior management in respect of the current period.
A summary of our outstanding debt as of December 31, 2018, is as follows (amounts in millions):
Refer to Note 13 of the notes to the consolidated financial statements included in Item 8 of this Annual Report on Form 10-K for further disclosures regarding our debt obligations.
Table:
 |  |  | 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 debt | $2,700 | $(29) | $2,671


Question: What was the percentage change in the net carrying amount between the 2026 and 2027 notes?
Answer: -53.09
Calculation: (395-842)/842
6. Inventories
Inventories at April 30, 2019 and 2018, respectively, consisted of the following (in thousands):
For the year ended April 30, 2018, the Company recorded a non-cash write-down of approximately $5.6 million of inventory. Inventory write-down resulted from two principal factors: (1) adoption by satellite manufacturers of policies precluding the use of parts and components over ten years old. This policy was unanticipated and resulted in reduced likelihood of FEI being able to use inventory that exceeds that threshold, and (2) changing technology associated with the advanced analog-to-digital converters which enables direct synthesis of certain frequencies for which FEI previously provided frequency conversion technology, reducing the likelihood that some parts and components associated with frequency conversion will be usable. Additionally, the Company’s new inventory reserve policy resulted in a charge of $1.1 million in the fiscal year ended April 30, 2019. Inventory reserves included in inventory were $6.6 million and $5.5 million for the fiscal years ended April 30, 2019 and 2018, respectively.
Table:
 | 2019 | 2018
Raw Materials and Component Parts | $11,600 | $ 16,206
Work in Progress | 8,896 | 8,216
Finished Goods | 2,860 | 1,764
 | $23,356 | $ 26,186


Question: What is the amount of work in progress inventory in 2019 and 2018 respectively?
Answer: 8,896, 8,216
6. Property and Equipment, Net
Property and equipment, net was comprised of the following (amounts in millions):
Depreciation expense for the years ended December 31, 2019, 2018, and 2017 was $124 million, $138 million, and $130 million, respectively.
Table:
 | At December 31, | 
 | 2019 | 2018
Land | $1 | $1
Buildings | 4 | 4
Leasehold improvements | 252 | 248
Computer equipment | 654 | 700
Office furniture and other equipment | 91 | 99
Total cost of property and equipment | 1,002 | 1,052
Less accumulated depreciation | (749) | (770)
Property and equipment, net | $253 | $282


Question: What was the net cost of Land in 2019?
Answer: $1
Item 5. Market for Registrant's Common Equity, Related Shareholder Matters and Issuer Purchases of Equity Securities.
Our common shares, without par value, are traded on the NASDAQ Stock Market LLC under the symbol “AGYS”. The high and low sales prices for the common shares for each quarter during the past two fiscal years are presented in the table below.
The closing price of the common shares on May 21, 2019, was $22.51 per share. There were 1,561 active shareholders of record.
We did not pay dividends in fiscal 2019 or 2018 and are unlikely to do so in the foreseeable future. The current policy of the Board of Directors is to retain any available earnings for use in the operations of our business.
Table:
2019 | High | Low
Fourth quarter | $21.17 | $13.92
Third quarter | $17.02 | $13.88
Second quarter | $16.72 | $14.72
First quarter | $15.55 | $11.78
2018 | High | Low
Fourth quarter | $13.00 | $10.77
Third quarter | $12.98 | $11.30
Second quarter | $12.14 | $9.80
First quarter | $10.30 | $9.08


Question: What were the number of active shareholders on May 21, 2019?
Answer: 1,561
Adjusted cash flow
A reconciliation showing the items that bridge between net cash from operating activities as reported under IFRS to an adjusted basis is given below. Adjusted cash from operations is used by the Board to monitor the performance of the Group, with a focus on elements of cashflow, such as Net capital expenditure, which are subject to day to day control by the business.
Adjusted cash conversion in 2019 is 84% (2018: 91%). Cash conversion is calculated as adjusted cash from operations divided by adjusted operating profit.
The adjusted cash flow is included in the Financial Review on page 58.
Table:
 | 2019 | 2018
 | £m | £m
Net cash from operating activities as reported under IFRS | 227.4 | 212.6
Acquisition and disposal costs | 2.5 | 0.2
Net capital expenditure excluding acquired intangibles from acquisitions | (59.0) | (31.5)
Tax paid | 78.4 | 61.6
Repayments of principal under lease liabilities | (11.2) | –
Adjusted cash from operations | 238.1 | 242.9


Question: What was the percentage change in the adjusted cash conversion in 2019 from 2018?
Answer: 7
Calculation: 91%-84%
ACCOUNTING POLICY
Accounts receivable represent amounts owing to us that are currently due and collectible. We initially recognize accounts receivable on the date they originate. We measure accounts receivable initially at fair value, and subsequently at amortized cost, with changes recognized in net income. We measure an impairment loss for accounts receivable as the excess of the carrying amount over the present value of future cash flows we expect to derive from it, if any. The excess is allocated to an allowance for doubtful accounts and recognized as a loss in net income.
EXPLANATORY INFORMATION
We have retrospectively reclassified $23 million as at December 31, 2018 and January 1, 2019 related to our wireless financing programs from “accounts receivable” to “other current assets” as the collection time frame of the amounts differs from accounts receivable.
Table:
 | As at December 31 | As at December 31 | As at December 31
(In millions of dollars) | Note | 2019 | 2018
Customer accounts receivable |  | 1,579 | 1,529
Other accounts receivable |  | 785 | 762
Allowance for doubtful accounts | 15 | (60) | (55)
Total accounts receivable |  | 2,304 | 2,236


Question: What is the increase/ (decrease) in Customer accounts receivable from 2018 to 2019?
Answer: 50
Calculation: 1,579-1,529
GasLog Ltd. and its Subsidiaries Notes to the consolidated financial statements (Continued) For the years ended December 31, 2017, 2018 and 2019 (All amounts expressed in thousands of U.S. Dollars, except share and per share data)      Investment in associates and joint venture consist of the following:
The additions of $158 relate to the investment in Gastrade (December 31, 2018: $136). On February 9, 2017, GasLog acquired a 20% shareholding in Gastrade, a private limited company licensed to develop an independent natural gas system offshore Alexandroupolis in Northern Greece utilizing an FSRU along with other fixed infrastructure. GasLog, as well as being a shareholder, will provide operations and maintenance (‘‘O&M’’) services for the FSRU through an O&M agreement which was signed on February 23, 2018.
Table:
 | Associates | 
 | 2018 | 2019
As of January 1, | 20,800 | 20,713
Additions | 136 | 158
Share of profit of associates | 1,800 | 1,627
Dividend declared | (2,023) | (878)
As of December 31, | 20,713 | 21,620


Question: What was the percentage change in share of profit of associates from 2018 to 2019?
Answer: -9.61
Calculation: (1,627 - 1,800)/1,800
The total compensation of the Executive Board members for each of the years 2019, 2018, and 2017 was as follows:
Executive Board Compensation
1) Portion of total executive compensation allocated to the respective year
Table:
€ thousands | 2019 | 2018 | 2017
Short-term employee benefits | 17,378 | 18,652 | 16,634
Share-based payment1) | 32,393 | 23,646 | 25,723
Subtotal1) | 49,771 | 42,298 | 42,357
Post-employment benefits | 2,825 | 1,106 | 1,312
Thereof defined-benefit | 2,056 | 250 | 423
Thereof defined-contribution | 769 | 856 | 889
Total1) | 52,596 | 43,404 | 43,669


Question: What was the total amount of Executive Board Compensation in 2019?
Answer: 52,596
Cash Flows
The following table sets forth summary cash flow data for the periods indicated (in thousands).
Cash Flow from Operating Activities
Net cash flows provided by operating activities for the year ended December 31, 2019, were $137.6 million as compared to $183.9 million during the same period in 2018. Net cash provided by operating activities primarily consists of net income adjusted to add back depreciation, amortization, and stock-based compensation. Cash flows provided by operating activities were $46.3 million lower for the year ended December 31, 2019, compared to the same period in 2018, due to the timing of working capital. Our current policy is to use our operating cash flow primarily for funding capital expenditures, lease payments, stock repurchases, and acquisitions.
Cash Flow from Investing Activities
During the year ended December 31, 2019, we paid $753.9 million, net of $0.1 million in cash acquired, to acquire Speedpay. We also used cash of $18.5 million to invest in a payment technology and services company in India and $7.0 million to acquire the technology assets of RevChip, LLC and TranSend Integrated Technologies Inc. In addition, we used cash of $48.0 million to purchase software, property and equipment, as compared to $43.9 million during the same period in 2018.
Cash Flow from Financing Activities
Net cash flows provided by financing activities for the year ended December 31, 2019, were $667.2 million, as compared to net cash flows used by financing activities of $57.7 million during the same period in 2018. During 2019, we received proceeds of $500.0 million from our Delayed Draw Term Loan and $280.0 million from our Revolving Credit Facility to fund our purchase of Speedpay and stock repurchases, and we repaid $28.9 million on the Initial Term Loan and $41.0 million on the Revolving Credit Facility. In addition, we received proceeds of $16.6 million from the exercise of stock options and the issuance of common stock under our 2017 Employee Stock Purchase Plan, as amended, and used $4.0 million for the repurchase of stock-based compensation awards for tax withholdings. During 2019, we also used $35.6 million to repurchase common stock. During 2018, we received proceeds of $400.0 million from the issuance of the 2026 Notes. We used $300.0 million of the proceeds to redeem, in full, our outstanding 6.375% Senior Notes due 2020 and repaid $109.3 million on the Initial Term Loan. In addition, during 2018, we received proceeds of $22.8 million from the exercise of stock options and the issuance of common stock under our 2017 Employee Stock Purchase Plan, as amended, and used $2.6 million for the repurchase of restricted share awards ("RSAs") for tax withholdings. During 2018, we also used $54.5 million to repurchase common stock.
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Net cash provided by (used in): |  | 
Operating activities | $137,649 | $183,932
Investing activities | -830,481 | -45,360
Financing activities | 667,223 | -57,704


Question: What was the change in net cash used in investing activities between 2018 and 2019?
Answer: -785121
Calculation: -830,481+45,360
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The table below summarizes the restructuring charges for the years ended:
Table:
 | 2019 | 2018 | Cumulative Cost Through December 31, 2019
Severance and related charges | $3,041 | $4,239 | $7,280
Facility relocation and closure charges | 1,996 | — | 1,996
Total restructuring charges | $5,038 | $4,239 | $9,277


Question: What was the total restructuring charges in 2018?
Answer: $4,239
Foreign Currency Exchange Rate Risk
As part of managing the exposure to changes in foreign currency exchange rates, we utilize cross-currency swap contracts and foreign currency forward contracts, a portion of which are designated as cash flow hedges. The objective of these contracts is to minimize impacts to cash flows and profitability due to changes in foreign currency exchange rates on intercompany and other cash transactions. We expect that significantly all of the balance in accumulated other comprehensive income (loss) associated with the cash flow hedge-designated instruments addressing foreign exchange risks will be reclassified into the Consolidated Statement of Operations within the next twelve months.
During fiscal 2015, we entered into cross-currency swap contracts with an aggregate notional value of €1,000 million to reduce our exposure to foreign currency exchange rate risk associated with certain intercompany loans. Under the terms of these contracts, which have been designated as cash flow hedges, we make interest payments in euros at 3.50% per annum and receive interest in U.S. dollars at a weighted-average rate of 5.33% per annum. Upon the maturity of these contracts in fiscal 2022, we will pay the notional value of the contracts in euros and receive U.S. dollars from our counterparties. In connection with the cross-currency swap contracts, both counterparties to each contract are required to provide cash collateral.
At fiscal year end 2019, these cross-currency swap contracts were in an asset position of $19 million and were recorded in other assets on the Consolidated Balance Sheet. The cross-currency swap contracts were in a liability position of $100 million and were recorded in other liabilities on the Consolidated Balance Sheet at fiscal year end 2018. At fiscal year end 2019 and 2018, collateral received from or paid to our counterparties approximated the derivative positions and was recorded in accrued and other current liabilities (when the contracts are in an asset position) or prepaid expenses and other current assets (when the contracts are in a liability position) on the Consolidated Balance Sheets. The impacts of these cross-currency swap contracts were as follows:
(1) Gains and losses excluded from the hedging relationship are recognized prospectively in selling, general, and administrative expenses and are offset by losses and gains generated as a result of re-measuring certain intercompany loans to the U.S. dollar.
Table:
 |  | Fiscal | 
 | 2019 | 2018 | 2017
 |  | (in millions) | 
Gains (losses) recorded in other comprehensive income (loss) | $ 53 | $  (25) | $ (20)
Gains (losses) excluded from the hedging relationship (1) | 66 | 21 | (58)


Question: How are Gains and losses excluded from the hedging relationship recognized?
Answer: recognized prospectively in selling, general, and administrative expenses and are offset by losses and gains generated as a result of re-measuring certain intercompany loans to the U.S. dollar
3. REVENUE FROM CONTRACTS WITH CUSTOMERS
Revenues and related costs on construction contracts are recognized as the performance obligations are satisfied over time in accordance with ASC 606, Revenue from Contracts with Customers. Under ASC 606, revenue and associated profit, will be recognized as the customer obtains control of the goods and services promised in the contract (i.e., performance obligations). The cost of uninstalled materials or equipment will generally be excluded from the Company’s recognition of profit, unless specifically produced or manufactured for a project, because such costs are not considered to be a measure of progress.
In adopting ASC 606, the Company had the following significant changes in accounting principles:
(i) Timing of revenue recognition for uninstalled materials - The Company previously recognized the majority of its revenue from the installation or construction of commercial & public works projects using the percentage-of-completion method of accounting, whereby revenue is recognized as the Company progresses on the contract. The percentage-of-completion for each project was determined on an actual cost-to-estimated final cost basis. Under ASC 606, revenue and associated profit, is recognized as the customer obtains control of the goods and services promised in the contract (i.e., performance obligations). The cost of uninstalled materials or equipment is generally excluded from the Company’s recognition of profit, unless specifically produced or manufactured for a project, because such costs are not considered to be a measure of progress.
(ii) Completed contracts - The Company previously recognized the majority of its revenue from the installation of residential projects using the completed contract method of accounting whereby revenue the Company recognized when the project is completed. Under, ASC 606, revenue is recognized as the customer obtains control of the goods and services promised in the contract (i.e., performance obligations).
Revenue recognition for other sales arrangements such as the sales of materials will remain materially consistent with prior treatment.
The adoption of the new revenue recognition standard resulted in a cumulative effect adjustment to retained earnings of approximately $1,405 as of January 1, 2018. The details of this adjustment are summarized below.
Table:
 | Balance at December 31, 2017 | Adjustments Due to ASC 606 | Balance at January 1, 2018
Contract assets | $3,790 | $(584) | $3,206
Contract liabilities | 7,288 | 821 | 8,109
Accumulated deficit | (56,365) | (1,405) | (57,770)


Question: What are the two changes in accounting principles in adopting ASC 606?
Answer: Timing of revenue recognition for uninstalled materials, Completed contracts
Discontinued Operations
On October 27, 2017, we entered into a purchase agreement to sell the Compute business. In consideration for the transfer and sale of the Compute business, we received an equity interest in the buyer valued at approximately $36.5 million, representing the carrying value of the assets divested and representing less than 20.0% of the buyer's total outstanding equity. The operations of the Compute business were accounted for as discontinued operations through the date of divestiture.
We also entered into a transition services agreement (the "Compute TSA"), pursuant to which we agreed to perform certain primarily general and administrative functions on the buyer's behalf during a migration period and for which we are reimbursed for costs incurred.
During the fiscal year 2019, we received $0.1 million of reimbursements under the Compute TSA, which was recorded as a reduction of our general and administrative expenses. During the fiscal year 2018, we received $3.6 million of reimbursements under the Compute TSA, which was recorded as a reduction of our general and administrative expenses.
In August of fiscal year 2015, we sold our Automotive business, as the Automotive business was not consistent with our long-term strategic vision from both a growth and profitability perspective.
Additionally, we entered into a Consulting Agreement with the buyer pursuant to which we were to provide the buyer with certain non-design advisory services for a period of two years following the closing of the transaction for up to $15.0 million, from which we have recorded $7.5 million as other income during both fiscal years 2017 and 2016. No income was recognized during fiscal years 2019 or 2018. During fiscal year 2017, we received $18.0 million, the full amount of the indemnification escrow.
The accompanying Consolidated Statements of Operations includes the following operating results related to these discontinued operations (in thousands):
(1) Amounts are associated with the Compute business. (2) Amounts are associated with the Automotive business.
Table:
 | Fiscal Years | 
 | 2018 | 2017
Revenue (1) | $— | $660
Cost of revenue (1) | (596) | 2,252
Gross profit (loss) | 596 | (1,592)
Operating expenses:    |  | 
Research and development (1) | 5,251 | 29,167
Selling, general and administrative (1) | 1,560 | 13,840
Total operating expenses | 6,811 | 43,007
Loss from discontinued operations (1) | (6,215) | (44,599)
Other income (2) | — | 7,500
Gain on sale (2) | — | 18,022
Loss income before income taxes | (6,215) | (19,077)
Income tax provision (benefit) | — | —
Loss income from discontinued operations | (6,215) | (19,077)
Cash flow used in Operating Activities (1) | (10,734) | (42,776)
Cash flow from Investing Activities (2) | — | 25,522


Question: When did the company enter into purchase agreement to sell the Compute business?
Answer: October 27, 2017