hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Stock options
The following tables summarize our stock option activities and related information:
(1) The aggregate intrinsic value represents the excess of the closing price of our common stock of $6.87 as of December 31, 2019 over theexercise price of the outstanding in-the-money options.
Table:
 | Number of Shares (thousands) | Weighted-Average Exercise Price | Weighted-Average Remaining Contractual Term (years) | Aggregate Intrinsic Value(1) (thousands)
Outstanding as of December 31, 2018 | 4,674 | $5.19 |  | 
Granted | — | $ — |  | 
Exercised | (842) | $2.84 |  | 
Canceled | (130) | $9.41 |  | 
Outstanding as of December 31, 2019 | 3,702 | $5.57 | 3.52 | $6,395
Vested and exercisable as of December 31, 2019 | 3,427 | $5.49 | 3.56 | $6,210


Question: What is the total amount spent on the canceled shares?
Answer: -1223.3
Calculation: (130)* $9.41
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
We have established an allowance for doubtful accounts based upon factors surrounding the credit risk of specific customers, historical trends, and other information.
Accounts Receivable and Allowance for Doubtful Accounts — Accounts receivable are recorded at net realizable value. We maintain a credit approval process and we make significant judgments in connection with assessing our customers’ ability to pay. Despite this assessment, from time to time, our customers are unable to meet their payment obligations. We continuously monitor our customers’ credit worthiness and use our judgment in establishing a provision for estimated credit losses based upon our historical experience and any specific customer collection issues that we have identified. While such credit losses have historically been within our expectations and the provisions established, there is no assurance that we will continue to experience the same credit loss rates that we have in the past. For example, in the fourth quarter, we increased our allowance for doubtful accounts by $4.2 million relating to a customer exposure in China resulting from economic softness and funding delays causing uncertainty in large program timing which uncertainty is now exacerbated by the spreading Coronavirus. A significant change in the liquidity or financial position of our customers could have a material adverse impact on the collectability of accounts receivable and our future operating results.
Changes in allowance for doubtful accounts are summarized as follows:
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Balances at beginning of period | $1,856 | $1,748
Additions from acquisition | 1,884 | 416
Additions - charged to expense | 4,207 | 109
Deductions - write-offs, net of recoveries | (202) | (417)
Balances at end of period | $7,745 | $1,856


Question: What was the change in balances at the end of period between 2018 and 2019?
Answer: 5889
Calculation: $7,745-$1,856
Accumulated Benefit Obligation
The following table provides information for the plans with an accumulated benefit obligation for fiscal years 2019 and 2018 (in thousands):
Table:
 | August 31, | 
 | 2019 | 2018
Projected benefit obligation | $174,690 | $161,104
Accumulated benefit obligation | $161,729 | $152,380
Fair value of plan assets | $158,101 | $151,715


Question: Which years does the table provide information for the plans with an accumulated benefit obligation for?
Answer: 2019, 2018
Note 6 – Accrued Expenses
Accrued expenses consisted of the following:
Table:
 |  | December 31,
 | 2019 | 2018
Payroll and incentive compensation | $ 3,009 | $ 1,937
Current portion of operating lease liabilities     – | 285 | -
Real estate taxes | 398 | 398
Other | 395 | 442
Total accrued expenses | $ 4,087 | $ 2,777


Question: What is the change in payroll and incentive compensation between 2018 and 2019?
Answer: 1072
Calculation: 3,009-1,937
Seasonality and Backlog
We experience a slight seasonal pattern to our business. Overall, the third and fourth fiscal quarters are typically the strongest quarters of our fiscal year, whereas the first fiscal quarter is negatively affected by holidays and the second fiscal quarter may be affected by adverse winter weather conditions in some of our markets.
Certain of our end markets experience some seasonality. Our sales in the automotive market are dependent upon global automotive production, and seasonal declines in European production may negatively impact net sales in the fourth fiscal quarter. Also, our sales in the energy market typically increase in the third and fourth fiscal quarters as customer activity increases.
Customer orders typically fluctuate from quarter to quarter based upon business and market conditions. Backlog is not necessarily indicative of future net sales as unfilled orders may be cancelled prior to shipment of goods. Backlog by reportable segment was as follows:
We expect that the majority of our backlog at fiscal year end 2019 will be filled during fiscal 2020.
Table:
 |  | Fiscal Year End
 | 2019 | 2018
 |  | (in millions)
Transportation Solutions | $ 1,639 | $ 1,779
Industrial Solutions | 1,315 | 1,245
Communications Solutions | 361 | 441
Total | $ 3,315 | $ 3,465


Question: What are sales in the automotive market dependent upon?
Answer: dependent upon global automotive production, and seasonal declines in European production may negatively impact net sales in the fourth fiscal quarter
Note 24 Post-employment benefit plans
POST-EMPLOYMENT BENEFIT PLANS COST
We provide pension and other benefits for most of our employees. These include DB pension plans, DC pension plans and OPEBs.
We operate our DB and DC pension plans under applicable Canadian and provincial pension legislation, which prescribes minimum and maximum DB funding requirements. Plan assets are held in trust, and the oversight of governance of the plans, including investment decisions, contributions to DB plans and the selection of the DC plans investment options offered to plan participants, lies with the Pension Fund Committee, a committee of our board of directors.
The interest rate risk is managed using a liability matching approach, which reduces the exposure of the DB plans to a mismatch between investment growth and obligation growth.
The longevity risk is managed using a longevity swap, which reduces the exposure of the DB plans to an increase in life expectancy.
COMPONENTS OF POST-EMPLOYMENT BENEFIT PLANS SERVICE COST
Table:
FOR THE YEAR ENDED DECEMBER 31 | 2019 | 2018
DB pension | (193) | (213)
DC pension | (110) | (106)
OPEBs | (3) | (3)
Less: |  | 
Capitalized benefit plans cost | 59 | 56
Total post-employment benefit plans service cost included in operating costs | (247) | (266)
Other costs recognized in severance, acquisition and other costs | – | (4)
Total post-employment benefit plans service cost | (247) | (270)


Question: What is the average total post-employment benefit plans service cost over 2018 and 2019?
Answer: -258.5
Calculation: (-247+(-270))/2
18. Other taxes
The other taxes (for example property tax, motor vehicle tax, excise tax and transaction tax) have the following effects on the income statement:
Table:
€ million | 2017/2018 | 2018/2019
Other taxes | 79 | 79
thereof from cost of sales | (1) | (1)
thereof from selling expenses | (65) | (62)
thereof from general administrative expenses | (13) | (16)


Question: What was the percentage change in Other taxes in 2018/2019 from 2017/2018?
Answer: 0
Calculation: (79-79)/79
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The following table summarizes long-lived assets by geographic area as of December 31, 2019 and December 31, 2018:
Long-lived assets include property and equipment, operating lease right-of-use assets, goodwill and other intangible assets.
Table:
 | December 31, | 
 | 2019 | 2018
United States | $239,511 | $115,869
Asia | 301,020 | 12,274
Europe | 59,925 | 59,936
Total | $600,456 | $188,079


Question: What was the change in the amount of long-lived assets between 2018 and 2019 in United States?
Answer: 123642
Calculation: $239,511-$115,869
Cash Flows
The following table provides a summary of cash flows from operating, investing and financing activities (in millions):
Operating Activities
The $57.2 million decrease in cash provided by operating activities in 2019 compared to 2018 is primarily related to the timing and amount of cash receipts for Trade receivables, net, higher payments primarily related to income taxes and incentive bonus, and the timing of payments for Trade accounts payable and other accrued liabilities. The $84.4 million increase in cash provided by operating activities in 2018 compared to 2017 was primarily related to increased earnings excluding the prior year effect of the Tax Reform Act and the timing and amount of cash receipts for Trade receivables, net.
Investing Activities
The $406.9 million increase in cash used in investing activities in 2019 compared to 2018 is primarily related to our D&B Investment and our acquisition of Compass Analytics. The $59.4 million increase in cash used in investing activities in 2018 compared to 2017 was primarily related to the HeavyWater and Ernst acquisitions and higher capital expenditures in 2018.
Financing Activities
The $455.1 million increase in cash provided by financing activities in 2019 compared to 2018 is primarily related to an incremental borrowing to fund our D&B Investment as well as fewer share repurchases. The $96.8 million decrease in cash used in financing activities in 2018 compared to 2017 was primarily related to tax distributions to BKFS LLC members and the senior notes redemption fee in 2017.
Table:
 | Year ended December 31, |  |  | Variance | 
 | 2019 | 2018 | 2017 | 2019 v. 2018 | 2018 v. 2017
Cash flows provided by operating activities | $378.3 | $435.5 | $351.1 | $(57.2) | $84.4
Cash flows used in investing activities | (551.0) | (144.1) | (84.7) | (406.9) | (59.4)
Cash flows provided by (used in) financing activities | 167.8 | (287.3) | (384.1) | 455.1 | 96.8
Net (decrease) increase in cash and cash equivalents | $(4.9) | $4.1 | $(117.7) | $(9.0) | $121.8


Question: What was the cash flows provided by operating activities in 2019 as a percentage of the cash flow in 2018?
Answer: 86.87
Calculation: 378.3/435.5
Gross margin
The Group achieved further gross margin expansion in 2019 with an increase of 1.0 percentage points, to 73.2 per cent from 72.2 per cent in 2018. This followed an increase of 0.7 percentage points last year. Once again, all the operating segments achieved an improvement in gross margin, benefiting from new product launches and a higher proportion of software sales.
Table:
$ million | 2019 | % | 2018 | %
Networks & Security | 232.3 | 72.6 | 205.3 | 72.0
Lifecycle Service Assurance | 88.6 | 79.7 | 87.9 | 77.9
Connected Devices | 47.7 | 65.8 | 51.3 | 64.9
 | 368.6 | 73.2 | 344.5 | 72.2


Question: In which year was the amount of gross profit for Connected Devices larger?
Answer: 2018
Calculation: 51.3>47.7
Unaudited Pro Forma Information - OpenEye
The following unaudited pro forma data is presented as if OpenEye were included in our historical consolidated statements of operations beginning January 1, 2018. These pro forma results do not necessarily represent what would have occurred if all the business combination had taken place on January 1, 2018, nor do they represent the results that may occur in the future.
This pro forma financial information includes our historical financial statements and those of our OpenEye business combination with the following adjustments: (i) we adjusted the pro forma amounts for income taxes, (ii) we adjusted for amortization expense assuming the fair value adjustments to intangible assets had been applied beginning January 1, 2018, and (iii) we adjusted for transaction fees incurred and reclassified them to January 1, 2018.
The pro forma adjustments were based on available information and upon assumptions that we believe are reasonable to reflect the impact of these acquisitions on our historical financial information on a supplemental pro forma basis, as follows (in thousands, except per share data):
Table:
 | Pro Forma | 
 | Year Ended December 31, | 
 | 2019 | 2018
Revenue | $527,550 | $451,013
Net income attributable to common stockholders | 51,075 | 13,264
Net income attributable to common stockholders per share - basic | $1.05 | $0.27
Net income attributable to common stockholders per share - diluted | $1.02 | $0.26


Question: What was the change in the Net income attributable to common stockholders per share - diluted between 2018 and 2019?
Answer: 0.76
Calculation: 1.02-0.26
The tax effects of temporary differences that give rise to significant portions of the Company's deferred tax assets and deferred tax liabilities are as follows (amounts in millions):
In assessing whether it is more likely than not that deferred tax assets will be realized, the Company considers all available evidence, both positive and negative, including its recent cumulative earnings experience and expectations of future available taxable income of the appropriate character by taxing jurisdiction, tax attribute carryback and carryforward periods available to them for tax reporting purposes, and prudent and feasible tax planning strategies.
Table:
 | March 31, | 
 | 2019 | 2018
Deferred tax assets: |  | 
Deferred income on shipments to distributors | $— | $39.1
Inventory valuation | 45.0 | 10.7
Net operating loss carryforward | 94.3 | 101.1
Capital loss carryforward | 9.6 | 10.6
Share-based compensation | 42.4 | 31.4
Income tax credits | 376.5 | 178.4
Property, plant and equipment | 23.6 | 25.7
Accrued expenses and other | 91.4 | 91.2
Intangible assets | 1,608.1 | —
Other | 12.6 | —
Gross deferred tax assets | 2,303.5 | 488.2
Valuation allowances | (332.1) | (204.5)
Deferred tax assets, net of valuation allowances | 1,971.4 | 283.7
Deferred tax liabilities: |  | 
Convertible debt | (279.3) | (304.4)
Intangible assets | (721.0) | (66.6)
Other | — | (18.3)
Deferred tax liabilities | (1,000.3) | (389.3)
Net deferred tax asset (liability) | $971.1 | $(105.6)
Reported as: |  | 
Non-current deferred tax assets | $1,677.2 | $100.2
Non-current deferred tax liability | (706.1) | (205.8)
Net deferred tax asset (liability) | $971.1 | $(105.6)


Question: What was the amount of convertible debt in 2019?
Answer: (279.3)
Geographic Information
The amounts for revenue by region in the following tables are based on the location of customers. The regions in the following table are EMEA (Europe, Middle East, and Africa), Americas (North America and Latin America), and APJ (Asia Pacific Japan).
Total Revenue by Region
Table:
€ millions | 2019 | 2018 | 2017
Germany | 3,948 | 3,658 | 3,352
Rest of EMEA | 8,158 | 7,446 | 7,063
EMEA | 12,105 | 11,104 | 10,415
United States | 9,085 | 7,880 | 7,436
Rest of Americas | 2,109 | 1,832 | 1,911
Americas | 11,194 | 9,713 | 9,347
Japan | 1,180 | 963 | 885
Rest of APJ | 3,074 | 2,928 | 2,814
APJ | 4,254 | 3,891 | 3,699
SAP Group | 27,553 | 24,708 | 23,461


Question: What was the change in APJ in 2019 from 2018?
Answer: 363
Calculation: 4,254-3,891
Net Pool Allocation: Net pool allocation increased by $10.5 million, from $7.3 million during the year ended December 31, 2017 to $17.8 million during the year ended December 31, 2018. The increase in net pool allocation was attributable to the movement in the adjustment of the net pool results earned by the GasLog vessels in accordance with the pool distribution formula. GasLog recognized gross revenues and gross voyage expenses and commissions of $102.3 million and $10.2 million, respectively, from the operation of its vessels in the Cool Pool during the year ended December 31, 2018 (December 31, 2017: $38.0 million and $9.1 million, respectively). The increase in GasLog’s total net pool performance was driven by higher spot rates and higher utilization achieved by all vessels trading in the Cool Pool. GasLog’s total net pool performance is presented below:
Voyage Expenses and Commissions: Voyage expenses and commissions increased by 32.5%, or $5.0 million, from $15.4 million during the year ended December 31, 2017 to $20.4 million during the year ended December 31, 2018. The increase in voyage expenses and commissions is mainly attributable to an increase of $3.6 million in bunkers consumed and voyage expenses during certain unchartered and off-hire periods, an increase of $0.3 million in voyage expenses of the vessels operating in the spot market and an increase of $1.1 million in brokers’ commissions.
Table:
 | For the year ended | 
 | 2017 | 2018
Amounts in thousands of U.S. Dollars |  | 
Pool gross revenues (included in Revenues) | 38,046 | 102,253
Pool gross voyage expenses and commissions (included in Voyage expenses and commissions) | (9,122) | (10,154)
GasLog’s adjustment for net pool allocation (included in Net pool allocation) | 7,254 | 17,818
GasLog’s total net pool performance | 36,178 | 109,917


Question: Which year was the pool gross revenues higher?
Answer: 2018
Calculation: 102,253 > 38,046
Provision for Income Taxes: Our effective income tax rates for each of the periods presented were the result of the mix of income earned in various tax jurisdictions that apply a broad range of income tax rates. In fiscal 2018, the Tax Act was signed into law. The more significant provisions of the Tax Act as applicable to us are described above under “Impacts of the U.S. Tax Cuts and Jobs Act of 2017”. refer to Note 14 of Notes to Consolidated Financial Statements included elsewhere in this Annual report for a discussion regarding the differences between the effective income tax rates as presented for the periods below and the U.S. federal statutory income tax rates that were in effect during these periods. Future effective income tax rates could be adversely affected by an unfavorable shift of earnings weighted to jurisdictions with higher tax rates, by unfavorable changes in tax laws and regulations, by adverse rulings in tax related litigation, or by shortfalls in stock-based compensation realized by employees relative to stock-based compensation that was recorded for book purposes, among others.
Provision for income taxes decreased in fiscal 2019 relative to fiscal 2018 primarily due to the absence of the initial accounting charges related to the Tax Act that were recorded in fiscal 2018. To a lesser extent, provision for income taxes also decreased in fiscal 2019 due to the net favorable impacts of our final accounting for the Tax Act in fiscal 2019; the net favorable impacts of the Tax Act on our tax profile during fiscal 2019; the favorable impact of a tax benefit arising from an increase in a deferred tax asset associated with a partial realignment of our legal structure in fiscal 2019; and lower income before provision for income taxes in fiscal 2019. These decreases to our provision for income taxes in fiscal 2019 relative to fiscal 2018 were partially offset both by lower excess tax benefits related to stock-based compensation expense in fiscal 2019, and by less favorable changes in net unrecognized tax benefits due to settlements with tax authorities and other events in fiscal 2019 relative to fiscal 2018.
Table:
 |  |  | Year Ended May 31, | 
 |  |  | Percent Change | 
(Dollars in millions) | 2019 | Actual | Constant | 2018
Provision for income taxes | $1,185 | -87% | -86% | $8,837
Effective tax rate | 9.7% |  |  | 71.1%


Question: How much was the total provision for income taxes across 2018 and 2019?
Answer: 10022
Calculation: 1,185 + 8,837
Contributions and Direct Benefit Payments
It is the company’s general practice to fund amounts for pensions sufficient to meet the minimum requirements set forth in applicable employee benefits laws and local tax laws. From time to time, the company contributes additional amounts as it deems appropriate.
The following table presents the contributions made to the non-U.S. DB plans, non pension postretirement benefit plans, multi-employer plans, DC plans and direct payments for 2019 and 2018. The cash contributions to the multi-employer plans represent the annual cost included in the net periodic (income)/ cost recognized in the Consolidated Income Statement. The company’s participation in multi-employer plans has no material impact on the company’s financial statements.
In 2019 and 2018, $635 million and $598 million, respectively, was contributed in U.S. Treasury securities, which is considered a non-cash transaction (includes the Active Medical Trust).
Table:
($ in millions) |  | 
For the year ended December 31: | 2019 | 2018
Non-U.S. DB plans | $  243 | $  325
Non pension postretirement benefit plans | 304 | 335
Multi-employer plans | 32 | 38
DC plans | 1,040 | 1,024
Direct benefit payments | 559 | 567
Total | $2,177 | $2,288


Question: What is the increase / (decrease) in the Non-U.S. DB plans from 2018 to 2019?
Answer: -82
Calculation: 243 - 325
H. Net Income Per Share
Basic net income per share is computed by dividing net income by the weighted-average number of common stock outstanding during the period. Diluted net income per share is computed by dividing net income by the weighted-average number of common stock outstanding and potentially dilutive securities outstanding during the period, as calculated using the treasury stock method. Potentially dilutive securities primarily include unvested restricted stock units (“RSUs”), including PSU awards, and stock options, including purchase options under VMware’s employee stock purchase plan, which included Pivotal’s employee stock purchase plan through the date of acquisition. Securities are excluded from the computation of diluted net income per share if their effect would be anti-dilutive. VMware uses the two-class method to calculate net income per share as both classes share the same rights in dividends; therefore, basic and diluted earnings per share are the same for both classes.
The following table sets forth the weighted-average common share equivalents of Class A common stock that were excluded from the diluted net income per share calculations during the periods presented because their effect would have been anti-dilutive (shares in thousands):
Table:
 | For the Year Ended |  | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Anti-dilutive securities: |  |  | 
Employee stock options | 34 | 50 | 51
Restricted stock units | 315 | 255 | 140
Total | 349 | 305 | 191


Question: What were the Restricted stock units in 2018?
Answer: 140