hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
NOTE 13 – INCOME TAX
The domestic and foreign components of loss before income taxes from operations for the years ended December 31, 2019, 2018 and 2017 are as follows:
Table:
 |  | For the Years Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (in thousands) | 
Domestic | $(22,708) | $29,110 | $17,120
Foreign | — | (320) | (469)
 | $(22,708) | $28,790 | $16,651


Question: What are the respective total income before tax in 2017 and 2018?
Answer: $16,651, $28,790
The following highlights net sales by geographic location (amounts in thousands):
(1) Revenues are attributed to countries or regions based on the location of the customer. Net Sales to one customer, TTI, Inc., exceeded 10% of total net sales as follows: $184.3 million, $133.5 million and $104.4 million in fiscal years 2019, 2018 and 2017, respectively.
(2) No country included in this caption exceeded 3% of consolidated net sales for fiscal years 2019, 2018 and 2017.
(3) Fiscal years ended March 31, 2018 and 2017 adjusted due to the adoption of ASC 606.
Table:
 |  | Fiscal Years Ended March 31,(1) | 
 | 2019 | 2018 | 2017
United States | $292,980 | $233,133 | $198,250
Hong Kong | 188,102 | 169,073 | 121,813
Germany | 124,805 | 105,548 | 104,755
Europe (2) (3) | 76,149 | 64,248 | 63,863
China | 173,148 | 163,016 | 71,223
Taiwan | 88,853 | 78,728 | 9,147
Asia Pacific (2) | 47,233 | 36,647 | 26,878
Japan | 178,502 | 170,282 | 3,565
United Kingdom | 42,472 | 37,038 | 33,837
Netherlands | 44,065 | 39,684 | 32,478
Malaysia | 33,748 | 28,165 | 15,177
Singapore | 19,417 | 17,267 | 15,565
Italy | 15,551 | 17,905 | 15,376
Hungary | 12,245 | 13,254 | 18,856
Mexico | 44,267 | 23,915 | 22,424
Other Countries (2) | 1,281 | 2,278 | 4,131
Total Non-United States (3) | 1,089,838 | 967,048 | 559,088
 | $1,382,818 | $1,200,181 | $757,338


Question: What was the change in net sales in Mexico between 2017 and 2018?
Answer: 1491
Calculation: 23,915-22,424
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: How many shares was purchased in August?
Answer: 362,200
Operating income in 2019 was $1,203 million, decreasing by $197 million compared to 2018, reflecting normal price pressure, increased unsaturation charges and higher R&D spending, partially offset by higher level of grants and favorable currency effects, net of hedging.
Operating income in 2018 was $1,400 million, improved by $395 million compared to 2017, reflecting higher volumes, improved manufacturing efficiencies and product mix and lower restructuring charges, partially offset by unfavorable currency effects, net of hedging, normal price pressure and higher operating expenses.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (In millions) | 
Operating income | $1,203 | $1,400 | $1,005
As percentage of net revenues | 12.6% | 14.5% | 12.0%


Question: What was the Operating income in 2019?
Answer: $1,203 million
Performance Share Plan
The relevant disclosures in respect of the Performance Share Plan grants are set out below.
Table:
 | 2015 Grant | 2016 Grant | 2017 Grant | 2018 Grant | 2019 Grant
Grant date | 11th June | 5th April | 26th May | 4th April | 15th May
Mid market share price at grant date | 3,460.0p | 3,550.0p | 5,256.0p | 5,560.0p | 8,161.0p
Number of employees | 15 | 13 | 12 | 12 | 12
Shares under scheme | 70,290 | 69,890 | 62,356 | 60,899 | 60,626
Vesting period | 3 years | 3 years | 3 years | 3 years | 3 years
Probability of vesting | 71.5% | 70.8% | 73.1% | 73.5% | 74.1%
Fair value | 2,473.9p | 2,513.4p | 3,842.1p | 4,084.4p | 6,048.9p


Question: For which years were the relevant disclosures in respect of the Performance Share Plan grants set out?
Answer: 2015, 2016, 2017, 2018, 2019
Supplemental balance sheet information related to operating and finance leases as of the period presented was as follows (table in millions):
(1) ROU assets for operating leases are included in other assets and ROU assets for finance leases are included in property and equipment, net on the consolidated balance sheets
(2) Current lease liabilities are included primarily in accrued expenses and other on the consolidated balance sheets. An immaterial amount is presented in due from related parties, net on the consolidated balance sheets.
(3) Operating lease liabilities are presented as operating lease liabilities on the consolidated balance sheets. Finance lease liabilities are included in other liabilities on the consolidated balance sheets.
Table:
 | January 31, 2020 | 
 | Operating Leases | Finance Leases
ROU assets, non-current (1) | $886 | $58
Lease liabilities, current (2) | $109 | $4
Lease liabilities, non-current (3) | 746 | 55
Total lease liabilities | $855 | $59


Question: Where are ROU assets for operating leases included in the consolidated balance sheets?
Answer: ROU assets for operating leases are included in other assets and ROU assets for finance leases are included in property and equipment, net
Asset Retirement Obligations
At December 31, 2019, our asset retirement obligations balance was primarily related to estimated future costs of removing equipment from leased properties and estimated future costs of properly disposing of asbestos and other hazardous materials upon remodeling or demolishing buildings. Asset retirement obligations are included in other long-term liabilities on our consolidated balance sheets.
As of the Level 3 acquisition date, we recorded liabilities to reflect our fair values of Level 3’s asset retirement obligations. Our fair value estimates were determined using the discounted cash flow method.
The following table provides asset retirement obligation activity:
(1) The liabilities assumed during 2018 relate to purchase price adjustments during the year.
The 2019, 2018 and 2017 change in estimates are offset against gross property, plant and equipment.
Table:
 | Years Ended December 31, |  | 
 | 2019 | 2018 | 2017
 | (Dollars in millions) |  | 
Balance at beginning of year | $190 | 115 | 95
Accretion expense | 11 | 10 | 6
Liabilities assumed in acquisition of Level 3(1) | — | 58 | 45
Liabilities settled | (14) | (14) | (3)
Liabilities transferred to Cyxtera | — | — | (20)
Change in estimate | 10 | 21 | (8)
Balance at end of year | $197 | 190 | 115


Question: Which years are considered in the table providing asset retirement obligation activity?
Answer: 2019, 2018, 2017
Reconciliation of Bookings
The following table reconciles total bookings to total revenue, its most directly comparable GAAP financial measure:
(1) Change in deferred revenue also includes the impact of realized gains or losses from the hedging of bookings in foreign currencies.
Table:
 | Year Ended December 31, |  |  |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
Total Bookings: | (unaudited; in millions) |  |  |  | 
Total revenue | $2,988.1 | $2,660.1 | $2,231.9 | $1,847.9 | $1,607.3
Change in deferred revenue(1) | 180.5 | 163.2 | 214.4 | 163.5 | 165.9
Net refunds | 233.4 | 192.6 | 170.0 | 141.9 | 137.8
Other | (0.8) | (4.4) | 1.9 | 2.2 | 3.2
Total bookings | $3,401.2 | $3,011.5 | $2,618.2 | $2,155.5 | $1,914.2


Question: What financial items does reconciliation of total bookings consist of?
Answer: Total revenue, Change in deferred revenue, Net refunds, Other
ITEM 7. MANAGEMENT’S DISCUSSION AND ANALYSIS OF FINANCIAL CONDITION AND RESULTS OF OPERATIONS
RESULTS OF OPERATIONS
Consolidated Performance Summary. The following table presents selected consolidated financial data for the indicated fiscal years (dollars in millions, except per share data):
*Non-GAAP metric; refer to "Return on Invested Capital ("ROIC") and Economic Return" below for more information and Exhibit 99.1 for a reconciliation.
Net sales. Fiscal 2019 net sales increased $290.9 million, or 10.1%, as compared to fiscal 2018.
Net sales are analyzed by management by geographic segment, which reflects the Company's reportable segments, and by market sector. Management measures operational performance and allocates resources on a geographic segment basis. The Company’s global business development strategy is based on our targeted market sectors.
Table:
 | 2019 | 2018
Net sales  | $3,164.4 | $2,873.5
Cost of sales  | 2,872.6 | 2,615.9
Gross profit  | 291.8 | 257.6
Gross margin  | 9.2% | 9.0%
Operating income  | 142.1 | 118.3
Operating margin  | 4.5% | 4.1%
Other expense  | 16.1 | 10.7
Income tax expense | 17.3 | 94.6
Net income  | 108.6 | 13.0
Diluted earnings per share  | $3.50 | $0.38
Return on invested capital*  | 13.1% | 16.1%
Economic return* | 4.1% | 6.6%


Question: How was net sales analyzed?
Answer: by management by geographic segment, which reflects the Company's reportable segments, and by market sector.
5. Other operating expenses
The expenses from logistics services provided by METRO LOGISTICS to companies intended for sale and non-group companies are offset by income from logistics services, which are reported under other operating income.
Table:
€ million | 2017/2018 | 2018/2019
Expenses from logistics services | 272 | 254
Losses from the disposal of fixed assets | 4 | 6
Impairment losses on goodwill | 0 | 3
Miscellaneous | 17 | 17
 | 293 | 279


Question: Where is income from logistics services reported?
Answer: reported under other operating income.
Inventory
Inventory is stated at the lower of cost and net realizable value, using the first-in, first-out (“FIFO”) valuation method. Net realizable value is the estimated selling prices in the ordinary course of business, less reasonably predictable costs of completion, disposal, and transportation. Any adjustments to reduce the cost of inventories to their net realizable value are recognized in earnings in the current period.
Due to the low sell-through of our AirBar products, management has decided to fully reserve work-in-process for AirBar components, as well as AirBar related raw materials. Management has further decided to reserve for a portion of AirBar finished goods, depending on type of AirBar and in which location it is stored. The AirBar inventory reserve was $0.8 million and $1.0 million for the years ended December 31, 2019 and 2018, respectively.
In order to protect our manufacturing partners from losses in relation to AirBar production, we agreed to secure the value of the inventory with a bank guarantee. Since the sale of AirBars has been lower than expected, a major part of the inventory at the partner remained unused when the due date of the bank guarantee neared and Neonode therefore agreed that the partner should keep inventory for the production of 20,000 AirBars and the rest be purchased by us. The inventory value of these purchases has been fully reserved.
As of December 31, 2019, the Company’s inventory consists primarily of components that will be used in the manufacturing of our sensor modules. We segregate inventory for reporting purposes by raw materials, work-in-process, and finished goods.
Raw materials, work-in-process, and finished goods are as follows (in thousands):
Table:
 | December 31, | December 31,
 | 2019 | 2018
Raw materials | $396 | $246
Work-in-process | 186 | 220
Finished goods | 448 | 753
Ending inventory | $1,030 | $1,219


Question: What is the proportion of work-in-process and finished goods over ending inventory in 2018?
Answer: 0.8
Calculation: (220+753)/$1,219
performance graph the performance graph below shows the five-year cumulative total stockholder return on applied common stock during the period from october 28 , 2012 through october 29 , 2017 . this is compared with the cumulative total return of the standard & poor 2019s 500 stock index and the rdg semiconductor composite index over the same period . the comparison assumes $ 100 was invested on october 28 , 2012 in applied common stock and in each of the foregoing indices and assumes reinvestment of dividends , if any . dollar amounts in the graph are rounded to the nearest whole dollar . the performance shown in the graph represents past performance and should not be considered an indication of future performance . comparison of 5 year cumulative total return* among applied materials , inc. , the s&p 500 index and the rdg semiconductor composite index *assumes $ 100 invested on 10/28/12 in stock or 10/31/12 in index , including reinvestment of dividends . indexes calculated on month-end basis . copyright a9 2017 standard & poor 2019s , a division of s&p global . all rights reserved. .

Table:
 | 10/28/2012 | 10/27/2013 | 10/26/2014 | 10/25/2015 | 10/30/2016 | 10/29/2017
applied materials | 100.00 | 171.03 | 207.01 | 165.34 | 293.64 | 586.91
s&p 500 index | 100.00 | 127.18 | 149.14 | 156.89 | 163.97 | 202.72
rdg semiconductor composite index | 100.00 | 131.94 | 167.25 | 160.80 | 193.36 | 288.96
dividends during each of fiscal 2017 , 2016 and 2015 , applied 2019s board of directors declared four quarterly cash dividends in the amount of $ 0.10 per share .
applied currently anticipates that cash dividends will continue to be paid on a quarterly basis , although the declaration of any future cash dividend is at the discretion of the board of directors and will depend on applied 2019s financial condition , results of operations , capital requirements , business conditions and other factors , as well as a determination by the board of directors that cash dividends are in the best interests of applied 2019s stockholders .
10/28/12 10/27/13 10/26/14 10/25/15 10/30/16 10/29/17 applied materials , inc .
s&p 500 rdg semiconductor composite .

Question: what is the roi in applied materials if the investment was made in 2012 and sold in 2015?
Answer: 65.3%
Calculation: subtract(165.34, const_100), divide(#0, const_100)
Note 11: Income Taxes
The components of income before income taxes and equity income (loss) from equity method investments are as follows (amounts in thousands):
(1) Fiscal years ended March 31, 2018 and 2017 adjusted due to the adoption of ASC 606.
Table:
 |  | Fiscal Years Ended March 31, | 
 | 2019 | 2018 | 2017
Domestic (U.S.) (1) | $95,639 | $141,582 | $(67)
Foreign (Outside U.S.) (1) | 74,792 | 45,485 | 9,875
Total (1) | $170,431 | $187,067 | $9,808


Question: What was the total income in 2019?
Answer: 170,431
24. Cash and cash equivalents
Significant accounting policies that apply to cash and cash equivalents Cash and cash equivalents comprise cash in hand and current balances with banks and similar institutions, which are readily convertible to cash and are subject to insignificant risk of changes in value and have an original maturity of three months or less. All are held at amortised cost on the balance sheet, equating to fair value. For the purpose of the consolidated cash flow statement, cash and cash equivalents are as defined above net of outstanding bank overdrafts. Bank overdrafts are included within the current element of loans and other borrowings (note 25).
IFRS 9 was applied for the first time on 1 April 2018 and introduces new classifications for financial instruments. Cash and cash equivalents were classified as loans and receivables under IAS 39, and are now classified as financial assets held at amortised cost under IFRS 9. This has not had an impact on the accounting for these instruments, or on their carrying amounts.
Cash and cash equivalents include restricted cash of £44m (2017/18: £32m, 2016/17: £43m), of which £40m (2017/18: £29m, 2016/17: £41m) was held in countries where local capital or exchange controls currently prevent us from accessing cash balances. The remaining balance of £4m (2017/18: £3m, 2016/17: £2m) was held in escrow accounts, or in commercial arrangements akin to escrow.
Table:
 | 2019 | 2018 | 2017
At 31 March | £m | £m | £m
Cash at bank and in hand | 495 | 446 | 469
Cash equivalents |  |  | 
US deposits | 3 | 26 | 32
UK deposits | 1,132 | 31 | 1
Other deposits | 36 | 25 | 26
Total cash equivalents | 1,171 | 82 | 59
Total cash and cash equivalents | 1,666 | 528 | 528
Bank overdrafts (note25) | (72) | (29) | (17)
Cash and cash equivalents per the cash flow statement | 1,594 | 499 | 511


Question: What was the cash at bank and in hand in 2019, 2018 and 2017?
Answer: 495, 446, 469
Our net sales by offering category for North America for 2019 and 2018, were as follows (dollars
in thousands):
Net sales in North America increased 12%, or $661.3 million, in 2019 compared to 2018. This increase reflects the addition of PCM, which reported $716.1 million in net sales in 2019, partially offset by a decline in net sales of the core business of $51.3 million. Net sales of hardware, software and services increased 10%, 14% and 25%, respectively, year over year.
Table:
 | North America |  | 
SalesMix | 2019 | 2018 | %Change
Hardware | $3,957,507 | $3,610,356 | 10%
Software | 1,269,983 | 1,112,715 | 14%
Services | 796,815 | 639,910 | 25%
 | $6,024,305 | $5,362,981 | 12%


Question: What is the change in Sales Mix of Hardware betweeen 2018 and 2019?
Answer: 347151
Calculation: 3,957,507-3,610,356
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)
Vessels under construction represent scheduled advance payments to the shipyards as well as certain capitalized expenditures. As of December 31, 2019, the Group has paid to the shipyard $197,637 for the vessels that are under construction and expects to pay the remaining installments as they come due upon each vessel’s keel laying, launching and delivery (Note 23(a)).
The vessels under construction costs as of December 31, 2018 and 2019 are comprised of:
Table:
 | As of  December 31, | 
 | 2018 | 2019
Progress shipyard installments | 152,075 | 197,637
Onsite supervision costs | 5,766 | 3,879
Critical spare parts, equipment and other vessel delivery expenses | 1,434 | 1,807
Total | 159,275 | 203,323


Question: What was the change in onsite supervision costs  from 2018 to 2019 ?
Answer: -1887
Calculation: 3,879 - 5,766
Notes to Consolidated Financial Statements - (Continued) Fiscal Years Ended May 26, 2019, May 27, 2018, and May 28, 2017 (columnar dollars in millions except per share amounts)  During fiscal 2019, we recognized the following pre-tax expenses for the Pinnacle Integration Restructuring Plan:
Included in the above results are $163.5 million of charges that have resulted or will result in cash outflows and $4.7 million in non-cash charges.
Table:
 | International | Pinnacle Foods | Corporate | Total
Other cost of goods sold | $— | $3.7 | $— | $3.7
Total cost of goods sold . | — | 3.7 | — | 3.7
Severance and related costs | 0.7 | 0.6 | 110.8 | 112.1
Accelerated depreciation | — | — | 4.7 | 4.7
Contract/lease termination . | — | 0.8 | 0.3 | 1.1
Consulting/professional fees . | 0.2 | — | 38.1 | 38.3
Other selling, general and administrative expenses . | 0.1 | — | 8.2 | 8.3
Total selling, general and administrative expenses | 1.0 | 1.4 | 162.1 | 164.5
Consolidated total | $1.0 | $5.1 | $162.1 | $168.2


Question: How much were the non-cash charges included in the pre-tax expenses?
Answer: $4.7 million
Depreciation and Amortization
The following table sets forth depreciation and amortization by segment for the periods presented (in millions):
(1) Depreciation and amortization for Corporate and Other primarily represents net incremental depreciation and amortization adjustments associated with the application of purchase accounting recorded in accordance with GAAP.
The increase in Depreciation and Amortization is primarily driven by implementation of new clients, accelerated amortization of deferred contract costs and hardware and software placed in service.
Table:
 | Year ended December 31, |  | Variance | 
 | 2019 | 2018 | $ | %
Software Solutions | $123.9 | $112.9 | $11.0 | 10%
Data and Analytics | 15.9 | 14.1 | 1.8 | 13%
Corporate and Other(1) | 96.4 | 90.0 | 6.4 | 7%
Total | $236.2 | $217.0 | 19.2 | 9%


Question: What was the difference in the percent variance between Software Solutions and Data and Analytics?
Answer: 3
Calculation: 13-10
The movement of contract liabilities is mainly caused by the timing difference of the satisfaction of a performance of obligation and the consideration received from customers.
The Company recognized NT$3,815 million and NT$616 million, respectively, in revenues from the contract liabilities balance at the beginning of the period as performance obligations were satisfied for the years ended December 31, 2018 and 2019.
Table:
 | As of January 1,2018 | As of December 31,2018 | As of December 31,2019
 | NT$(In Thousands) | NT$(In Thousands) | NT$(In Thousands)
Sales of goods and services | $3,951,414 | $932,371 | $1,470,195
Current | $3,951,414 | $932,371 | $988,115
Noncurrent | — | — | 482,080
Total | $3,951,414 | $932,371 | $1,470,195


Question: What was the revenue recorded from the contract liabilities balance at the beginning of the period for the years ended December 31, 2019?
Answer: NT$616 million
Restricted Share Awards
During the years ended December 31, 2017, pursuant to the Company’s 2016 Incentive Plan and 2005 Incentive Plan, the Company granted RSAs. The awards have requisite service periods of three years and vest in increments of 33% on the anniversary of the grant dates. Under each arrangement, shares are issued without direct cost to the employee. RSAs granted to our board vest one year from grant or as of the next annual shareholders meeting, whichever is earlier. The Company estimates the fair value of the RSAs based upon the market price of the Company’s stock at the date of grant. The RSA grants provide for the payment of dividends on the Company’s common stock, if any, to the participant during the requisite service period, and the participant has voting rights for each share of common stock. The Company recognizes compensation expense for RSAs on a straight-line basis over the requisite service period.
A summary of nonvested RSAs is as follows:
During the year ended December 31, 2019, a total of 106,610 RSAs vested. The Company withheld 32,371 of those shares to pay the employees’ portion of the minimum payroll withholding taxes.
Table:
 | Number of Shares | Weighted Average Grant Date Fair Value
Nonvested at December 31, 2018 | 213,337 | $20.21
Vested | -106,610 | 20.17
Forfeited | -13,885 | 20.64
Nonvested at December 31, 2019 | 92,842 | $20.13


Question: What is the change in nonvested shares between 2018 and 2019?
Answer: -120495
Calculation: 92,842-213,337
xii. Shareholding as on March 31, 2019:
a. Distribution of equity shareholding as on March 31, 2019:
Table:
Number of shares | Holding | Percentage to capital | Number of accounts | Percentage to total accounts
1 - 100 | 18,402,438 | 0.5 | 528,148 | 70.3
101 - 500 | 37,550,103 | 1.0 | 185,200 | 24.6
501 - 1000 | 14,900,327 | 0.4 | 20,749 | 2.8
1001 - 5000 | 27,199,737 | 0.7 | 13,897 | 1.9
5001 - 10000 | 9,150,929 | 0.2 | 1,292 | 0.2
10001 - 20000 | 8,811,580 | 0.2 | 622 | 0.1
20001 - 30000 | 5,636,878 | 0.2 | 230 | -
30001 - 40000 | 5,424,479 | 0.1 | 154 | -
40001- 50000 | 4,808,196 | 0.1 | 106 | -
50001 -100000 | 21,790,964 | 0.6 | 304 | -
100001 - above | 3,598,709,075 | 96.0 | 903 | 0.1
GRAND TOTAL | 3,752,384,706 | 100.0 | 751,605 | 100.0


Question: What is the percentage of accounts holding 20001 - 100000 number of shares?
Answer: 0.11
Calculation: (230+154+106+304)/751,605