hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
NOTE 21. REVENUE
Geographical information is summarized as follows:
For geographical reporting, the revenue is attributed to the geographical location in which the customer’s facilities are located.
Table:
 | Year ended December 31, | 
 | 2018 | 2019
(EUR thousand) | Revenue | Revenue
United States | 175,855 | 339,463
Europe | 165,602 | 126,203
Asia | 476,624 | 818,194
Total | 818,081 | 1,283,860


Question: Which region had the largest percentage change in revenue from 2018 to 2019?
Answer: United States
Calculation: United States:((339,463-175,855)/175,855=0.93)  Europe :((126,203-165,602)/165,602=-0.24)  Asia:( (818,194 -476,624)/476,624=0.72)
(c) Summary of Share-Based Compensation Expense
Share-based compensation expense consists primarily of expenses for stock options, stock purchase rights, restricted stock, and RSUs granted to employees. The following table summarizes share-based compensation expense (in millions):
As of July 27, 2019, the total compensation cost related to unvested share-based awards not yet recognized was $3.3 billion, which is expected to be recognized over approximately 2.8 years on a weighted-average basis.
Table:
Years Ended | July 27, 2019 | July 28, 2018 | July 29, 2017
Cost of sales—product | $90 | $94 | $85
Cost of sales—service | 130 | 133 | 134
Share-based compensation expense in cost of sales . | 220 | 227 | 219
Research and development . | 540 | 538 | 529
Sales and marketing | 519 | 555 | 542
General and administrative | 250 | 246 | 236
Restructuring and other charges | 62 | 33 | 3
Share-based compensation expense in operating expenses | 1,371 | 1,372 | 1,310
Total share-based compensation expense | $1,591 | $1,599 | $1,529
Income tax benefit for share-based compensation . | $542 | $558 | $451


Question: What does share-based compensation expense consist of?
Answer: primarily of expenses for stock options, stock purchase rights, restricted stock, and RSUs granted to employees.
P. Income Taxes
VMware’s income tax provision (benefit) for the periods presented consisted of the following (table in millions):
Table:
 |  | For the Year Ended | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Federal: |  |  | 
Current | $78 | $181 | $688
Deferred | (219) | (92) | 275
 | (141) | 89 | 963
State: |  |  | 
Current | 45 | 31 | 8
Deferred | (44) | (10) | 21
 | 1 | 21 | 29
Foreign: |  |  | 
Current | 240 | 137 | 156
Deferred | (5,018) | (8) | 4
 | (4,778) | 129 | 160
Total income tax provision (benefit) | $(4,918) | $239 | $1,152


Question: What was the change in the current federal income tax provision between 2018 and 2019?
Answer: -507
Calculation: 181-688
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
NOTE 3 — Accounts Receivable
The components of accounts receivable are as follows:
Table:
 | As of December 31, | 
 | 2019 | 2018
Accounts receivable, gross | $78,269 | $79,902
Less: Allowance for doubtful accounts | (261) | (384)
Accounts receivable, net | $78,008 | $79,518


Question: What was the amount of net accounts receivables in 2018?
Answer: 79,518
stock performance graph the following graph compares the most recent five-year performance of alcoa 2019s common stock with ( 1 ) the standard & poor 2019s 500 ae index and ( 2 ) the standard & poor 2019s 500 ae materials index , a group of 27 companies categorized by standard & poor 2019s as active in the 201cmaterials 201d market sector . such information shall not be deemed to be 201cfiled . 201d five-year cumulative total return based upon an initial investment of $ 100 on december 31 , 2010 with dividends reinvested alcoa inc . s&p 500 ae index s&p 500 ae materials index dec-'10 dec-'11 dec-'12 dec-'14 dec-'15dec-'13 .

Table:
as of december 31, | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
alcoainc . | $ 100 | $ 57 | $ 58 | $ 72 | $ 107 | $ 68
s&p 500 aeindex | 100 | 102 | 118 | 157 | 178 | 181
s&p 500 aematerials index | 100 | 90 | 104 | 130 | 139 | 128
s&p 500 ae index 100 102 118 157 178 181 s&p 500 ae materials index 100 90 104 130 139 128 copyright a9 2016 standard & poor 2019s , a division of the mcgraw-hill companies inc .
all rights reserved .
source : research data group , inc .
( www.researchdatagroup.com/s&p.htm ) .

Question: what was the percentual increase observed in the alcoainc . investment during 2013 and 2014?
Answer: 48.6%
Calculation: divide(107, 72), subtract(#0, const_1)
Assets in the combined schemes increased by £177.1m to £5,040.7m in the period. RHM scheme assets increased by £149.1m to £4,333.6m while the Premier Foods’ schemes assets increased by £28.0m to £707.1m. The most significant movement by asset class is that of government bonds which increased by £444.0m in the year, predominantly in the RHM scheme.
Liabilities in the combined schemes increased by £121.0m in the year to £4,667.6m. The value of liabilities associated with the RHM scheme were £3,495.8m, an increase of £65.3m while liabilities in the Premier Foods schemes were £55.7m higher at £1,171.8m. The increase in the value of liabilities in both schemes is due to a lower discount rate assumption of 2.45% (31 March 2018: 2.70%) and an increase in the RPI inflation rate assumption; from 3.15% to 3.25%.
The Group’s Pension Trustees have just commenced the triennial actuarial valuation process of the Group’s pension schemes as at 31 March 2019 (RHM scheme) and 5 April 2019 (Premier Foods main scheme). This exercise typically takes a number of months to conclude; the output of which will be provided in due course.
The net present value of future deficit payments, to the end of the respective recovery periods remains at circa £300–320m.
Table:
Combined pensions schemes (£m) | 30 March 2019 | 31 March 2018
Assets |  | 
Equities | 179.5 | 296.5
Government bonds | 1,490.4 | 1,046.4
Corporate bonds | 26.9 | 20.7
Property | 436.5 | 391.0
Absolute return products | 1,141.2 | 1,323.3
Cash | 38.1 | 32.4
Infrastructure funds | 256.1 | 254.6
Swaps | 556.4 | 715.3
Private equity | 446.1 | 344.0
Other | 469.5 | 439.4
Total Assets | 5,040.7 | 4,863.6
Liabilities |  | 
Discount rate | 2.45% | 2.70%
Inflation rate (RPI/CPI) | 3.25%/2.15% | 3.15%/2.05%


Question: What was the increase in the assets in the combined schemes in 2019?
Answer: £177.1m
Accrued Warranty
The following table summarizes the activity related to the Company’s product warranty liability during the following periods (in thousands):
Table:
 | Year Ended | 
 | June 30,
2019 | June 30,
2018
Balance beginning of period | $12,807 | $10,584
Warranties assumed due to acquisitions   | — | 3,682
New warranties issued | 22,919 | 10,491
Warranty expenditures | (20,947) | (11,950)
Balance end of period  | $14,779 | $12,807


Question: What was the change in the Warranty expenditures between 2018 and 2019?
Answer: -8997
Calculation: -20,947-(-11,950)
6. Supplemental Financial Information
Cash and cash equivalents (in millions):
The following table presents cash and cash equivalents as reported in our consolidated balance sheets, as well as the sum of cash, cash equivalents and restricted cash as reported on our consolidated statement of cash flows in accordance with our adoption of the ASU discussed in Note 1 – Description of Business and Significant Accounting Policies.
Table:
 | April 26, 2019 | April 26, 2018
Cash | $ 2,216 | $ 2,727
Cash equivalents | 109 | 214
Cash and cash equivalents | $ 2,325 | $ 2,941
Short-term restricted cash | 5 | 5
Long-term restricted cash | 1 | 1
Restricted cash | $ 6 | $ 6
Cash, cash equivalents and restricted cash | $ 2,331 | $ 2,947


Question: Which years does the table provide information for cash and cash equivalents?
Answer: 2019, 2018
Restructuring Expense
In October 2019, we began implementing a restructuring plan in our ongoing efforts to reduce operating costs and focus on advanced technologies. The restructuring plan, when complete, is expected to result in a workforce reduction of approximately 5% of our workforce and the closure and consolidation of certain U.S. and international office facilities. We expect to complete the restructuring by the end of the second fiscal quarter of 2020. We recorded restructuring expenses of $2.5 million in the fourth quarter of 2019, which included the following (in thousands)
As of December 31, 2019, we had accrued but unpaid restructuring costs of $1.5 million included in accrued liabilities on the Consolidated Balance Sheets
Table:
 | Cost of revenue | Sales and marketing | Research and development | General and administrative | Total restructuring expense
Employee severance and related payroll taxes | $28 | $1,355 | $340 | $194 | $1,917
Facilities closure expenses | . | 435 | 89 |  | 524
Legal fees | . | . | . | 89 | 89
 | $28 | $1,790 | $429 | $283 | $2,530


Question: What is the total Sales and marketing and General and administrative?
Answer: 2073
Calculation: 1,790+283
Contract Liabilities
Contract liabilities include payments received in advance of performance under the contract, and are realized with the associated revenue recognized under the contract. The changes in our contract liabilities are as follows (in thousands):
The revenue recognized from amounts included in contract liabilities primarily relates to prepayment contracts with customers as well as payments of activation fees.
Table:
Year Ended December 31, |  | 
 | 2019 | 2018
Beginning of period balance | $11,176 | $12,678
Revenue deferred and acquired in current period | 6,127 | 3,954
Revenue recognized from amounts included in contract liabilities | (6,805) | (5,456)
End of period balance | $10,498 | $11,176


Question: What did the revenue recognized from amounts included in contract liabilities primarily related to?
Answer: prepayment contracts with customers as well as payments of activation fees.
Product Licensing Segment
(1) Excludes operating expenses which are not allocated on a segment basis.
Product Licensing revenue for the year ended December 31, 2019 was $198.1 million as compared to $219.7 million for the year ended December 31, 2018, a decrease of $21.6 million. The decrease in revenue was primarily due to the timing and duration of minimum guarantee contracts up for renewal and executed, decreased NRE services revenue, as well as a decrease in per-unit royalty revenue in 2019 as compared to 2018.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (in thousands) | 
Revenue: |  |  | 
Royalty and license fees | $198,124 | $219,708 | $167,923
Total revenue | 198,124 | 219,708 | 167,923
Operating expenses: |  |  | 
Cost of revenues | 8,460 | 13,291 | 6,308
Research, development and other related costs | 83,613 | 78,892 | 75,809
Litigation | 1,656 | — | 288
Amortization | 88,075 | 88,544 | 90,340
Total operating expenses (1) | 181,804 | 180,727 | 172,745
Total operating income (loss) | $16,320 | $38,981 | $(4,822)


Question: What was the total operating income/loss from 2017 to 2019, respectively?
Answer: $(4,822), $38,981, $16,320
Net revenues by location of shipment are classified by location of customer invoiced or reclassified by shipment destination in line with customer demand. For example, products ordered by U.S.-based companies to be invoiced to Asia Pacific affiliates are classified as Asia Pacific revenues.
By location of shipment, in 2019, revenues grew 6.8% in Americas, driven by Power Discrete, remained substantially flat in Asia and decreased 8.6% in EMEA, mainly due to lower sales of Microcontrollers and Power Discrete. In 2018 revenues grew across all regions, led by Asia Pacific and EMEA, mainly due to growth in Imaging and Automotive.
Table:
 | Year Ended December 31, | Year Ended December 31, | Year Ended December 31, | % Variation | % Variation
 | 2019 | 2018 | 2017 | 2019 vs 2018 | 2018 vs 2017
 | (In millions) | (In millions) | (In millions) |  | 
EMEA | $2,265 | $2,478 | $2,142 | (8.6)% | 15.7%
Americas | 1,351 | 1,264 | 1,085 | 6.8 | 16.5
Asia Pacific | 5,940 | 5,922 | 5,120 | 0.3 | 15.7
Total | $9,556 | $9,664 | $8,347 | (1.1)% | 15.8%


Question: In 2018,why did the revenues grew across all regions?
Answer: mainly due to growth in Imaging and Automotive.
13. Loss per Share
The following data shows the amounts used in computing loss per share and the effect on earnings and the weighted average number of shares of dilutive potential common shares.
Basic earnings (loss) per share is computed as net income available to common shareholders divided by the weighted average basic shares outstanding. The outstanding shares used to calculate the weighted average basic shares excludes 300,437, 334,817 and 490,355 of restricted shares and performance shares at March 31, 2019, 2018 and 2017, respectively, as these shares were issued but were not vested and, therefore, not considered outstanding for purposes of computing basic earnings per share at the balance sheet dates.
Diluted earnings (loss) per share includes the effect of all potentially dilutive securities on earnings per share. We have stock options, stock-settled appreciation rights ("SSARs"), unvested restricted shares and unvested performance shares that are potentially dilutive securities. When a loss is reported, the denominator of diluted earnings per share cannot be adjusted for the dilutive impact of sharebased compensation awards because doing so would be anti-dilutive.
In addition, when a net loss is reported, adjusting the denominator of diluted earnings per share would also be anti-dilutive to the loss per share, even if the entity has net income after adjusting for a discontinued operation. Therefore, for all periods presented, basic weighted-average shares outstanding were used in calculating the diluted net loss per share.
Table:
 |  | Year ended March 31, | 
(In thousands, except per share data) | 2019 | 2018 | 2017
Numerator: |  |  | 
Net loss | $(13,164) | $(8,350) | $(11,721)
Denominator: |  |  | 
Weighted average shares outstanding - basic and diluted | 23,037 | 22,801 | 22,615
Loss per share - basic and diluted: |  |  | 
Net loss per share-basic and diluted | $(0.57) | $(0.37) | $(0.52)
Anti-dilutive stock options, SSARs, restricted shares and performance shares | 1,433 | 756 | 1,004


Question: What was the increase / (decrease) in the net loss from 2018 to 2019?
Answer: -4814
Calculation: -13,164 - (- 8,350)
4. Acquisitions and Divestitures
(a) Acquisition Summary
We completed five acquisitions during fiscal 2019. A summary of the allocation of the total purchase consideration is presented as follows (in millions):
On September 28, 2018, we completed our acquisition of privately held Duo Security, Inc. (“Duo”), a leading provider of unified access security and multi-factor authentication delivered through the cloud. Revenue from the Duo acquisition has been included in our Security product category.
On February 6, 2019, we completed our acquisition of Luxtera, Inc. (“Luxtera”), a privately held semiconductor company. Revenue from the Luxtera acquisition has been included in our Infrastructure Platforms product category.
The total purchase consideration related to our acquisitions completed during fiscal 2019 consisted of cash consideration and vested share-based awards assumed. The total cash and cash equivalents acquired from these acquisitions was approximately $100 million.
Table:
Fiscal 2019 | Purchase Consideration | Net Tangible Assets Acquired (Liabilities Assumed) | Purchased Intangible Assets | Goodwill
Duo | $2,025 | $(57) | $342 | $1,740
Luxtera | 596 | (19) | 319 | 296
Others (three in total) | 65 | 2 | 11 | 52
Total | $2,686 | $(74) | $672 | $2,088


Question: What company did the company acquire in fiscal 2019?
Answer: Luxtera, Inc. (“Luxtera”), a privately held semiconductor company
INCOME TAX EXPENSE
Below is a summary of the difference between income tax expense computed by applying the statutory income tax rate to income before income tax expense and the actual income tax expense for the year.
Our effective income tax rate this year was 25.8% compared to 26.9% for 2018. The effective income tax rate for 2019 was lower than the statutory tax rate primarily as a result of a reduction to the Alberta corporate income tax rate over a four-year period.
Cash income taxes paid increased this year primarily as a result of the timing of installment payments.
Table:
 | Years ended December31 | 
(In millions of dollars, except tax rates) | 2019 | 2018
Statutory income tax rate | 26.7% | 26.7%
Income before income tax expense | 2,755 | 2,817
Computed income tax expense | 736 | 752
Increase (decrease) in income tax expense resulting from: |  | 
Non-deductible stock-based compensation | – | 5
Non-deductible portion of equity losses | 7 | 1
Income tax adjustment, legislative tax change | (23) | -
Non-taxable portion of capital gains | (2) | (9)
Other items | (6) | 9
Total income tax expense | 712 | 758
Effective income tax rate | 25.8% | 26.9%
Cash income taxes paid | 400 | 370


Question: What was the effective tax rate in 2019?
Answer: 25.8%
Our 2019 net revenues decreased 1.1% compared to the prior year, primarily due to a decrease in volumes of approximately 8%, partially compensated by an increase in average selling prices of approximately 7%. The increase in the average selling prices was driven by favorable product mix of approximately 10%, partially offset by a negative pricing effect of approximately 3%.
Our 2018 net revenues increased 15.8% compared to the prior year, primarily due to increase in average selling prices of approximately 16%, while volumes remained substantially flat. The increase in the average selling prices was driven by favorable product mix of approximately 18%, partially offset by a negative pricing effect of approximately 2%. Our net revenues registered double-digit growth across all product groups and geographies.
In 2019, 2018 and 2017, our largest customer, Apple, accounted for 17.6%, 13.1% and 10.5% of our net revenues, respectively, reported within our three product groups.
Table:
 | Year Ended December 31, | Year Ended December 31, | Year Ended December 31, | % Variation | % Variation
 | 2019 | 2018 | 2017 | 2019 vs 2018 | 2018 vs 2017
 | (in millions) | (in millions) | (in millions) |  | 
Net sales | $9,529 | $9,612 | $8,308 | (0.9)% | 15.7%
Other revenues | 27 | 52 | 39 | (49.0) | 36.1
Net revenues | $9,556 | $9,664 | $8,347 | (1.1)% | 15.8%


Question: Why did the 2019 net revenues decreased 1.1% compared to the prior year?
Answer: a decrease in volumes of approximately 8%, partially compensated by an increase in average selling prices of approximately 7%.
During the year ended 31 December 2019, the Company repurchased 3,486,700 shares on the Stock Exchange for an aggregate consideration of approximately HKD1.16 billion before expenses. The repurchased shares were subsequently cancelled. The repurchase was effected by the Board for the enhancement of shareholder value in the long term. Details of the shares repurchased are as follows:
Save as disclosed above and in Note 32 to the consolidated financial statements, neither the Company nor any of its subsidiaries has purchased, sold or redeemed any of the Company’s shares during the year ended 31 December 2019.
Table:
 | Purchase consideration per share |  |  | 
 |  |  |  | Aggregate
 | No. of shares | Highest | Lowest | consideration
Month of purchase in 2019 | purchased | price paid | price paid | paid
 |  | HKD | HKD | HKD
August | 362,200 | 327.00 | 312.40 | 116,330,916
September | 2,294,500 | 351.00 | 323.60 | 776,104,729
October | 830,000 | 327.80 | 317.40 | 268,272,462
Total: | 3,486,700 |  |  | 1,160,708,107


Question: What percentage of the total aggregate consideration paid is the August aggregate consideration paid?
Answer: 10.02
Calculation: 116,330,916/1,160,708,107
Lockheed Martin Transaction
On August 16, 2016, a wholly-owned subsidiary of Leidos Holdings, Inc. merged with the IS&GS Business in a Reverse Morris Trust transaction (the "IS&GS Transactions").
During fiscal 2017, the Company recorded adjustments to finalize the fair value of acquired assets and liabilities assumed which resulted in a $337 million increase in goodwill. Significant changes included intangible assets, property, plant and equipment, deferred tax assets, other assets, accounts payable and accrued liabilities and deferred tax liabilities.
On January 10, 2018, the final amount of the net working capital of the IS&GS Business was determined through a binding arbitration proceeding in accordance with the Separation Agreement with Lockheed Martin. As a result, $24 million was recorded as acquisition costs in the consolidated statements of income for fiscal 2017. On January 18, 2018, the final working capital amount of $105 million was paid to Lockheed Martin, of which $24 million and $81 million was presented as cash flows from operating and investing activities, respectively, on the consolidated statements of cash flows.
During fiscal 2018, a tax indemnification liability of $23 million was paid to Lockheed Martin in accordance with the Tax Matters Agreement, which was presented as cash flows from financing activities on the consolidated statements of cash flows.
The Company incurred the following expenses related to the acquisition and integration of the IS&GS Business:
These acquisition and integration costs have been recorded within Corporate and presented in "Acquisition, integration and restructuring costs" on the consolidated statements of income.
Table:
 |  | Year Ended | 
 | January 3, 2020 | December 28, 2018 | December 29, 2017
 |  | (in millions) | 
Acquisition costs | $— | $— | $25
Integration costs | 3 | 29 | 77
Total acquisition and integration costs | $3 | $29 | $102


Question: What was the change in the Total acquisition and integration costs from 2017 to 2018?
Answer: -73
Calculation: 29 - 102
Discontinued Operations
In December 2015, we completed the wind down of engineering, manufacturing and sales of our solar inverter product line (the "inverter business"). Accordingly, the results of our inverter business have been reflected as “Income (loss) from discontinued operations, net of income taxes” on our Consolidated Statements of Operations for all periods presented herein.
The effect of our sales of extended inverter warranties to our customers continues to be reflected in deferred revenue in our Consolidated Balance Sheets. Deferred revenue for extended inverter warranties and the associated costs of warranty service will be reflected in Sales and Cost of goods sold, respectively, from continuing operations in future periods in our Consolidated Statement of Operations, as the deferred revenue, is earned and the associated services are rendered. Extended warranties related to the inverter product line are no longer offered.
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
Assets and Liabilities of discontinued operations within the Consolidated Balance Sheets are comprised of the following:
Table:
 | December 31, | 
 | 2019 | 2018
Cash and cash equivalents | $  — | $ 5,251
Accounts and other receivables, net | — | 406
Inventories | 30 | 198
Current assets of discontinued operations | 30 | 5,855
Other assets | — | 67
Deferred income tax assets | 269 | 5,917
Non-current assets of discontinued operations | 269 | 5,984
Accounts payable and other accrued expenses | — | 350
Accrued warranty | 914 | 4,936
Current liabilities of discontinued operations | 914 | 5,286
Accrued warranty | 698 | 10,429
Other liabilities | 189 | 286
Non-current liabilities of discontinued operations | $887 | $10,715


Question: What was the change in Accrued warranty of Accounts payable and other accrued expenses between 2018 and 2019?
Answer: -4022
Calculation: 914-4,936