hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Noncurrent Assets and Liabilities
The increase in noncurrent assets of $39,531 million ($39,470 million adjusted for currency) was driven by: • A net increase in goodwill and net intangible assets of $34,104 million ($34,058 million adjusted for currency) due to the acquisition of Red Hat; and • An increase in operating right-of-use assets of $4,996 million ($5,010 million adjusted for currency) as a result of the adoption of the new leasing standard on January 1, 2019; and• An increase in prepaid pension assets of $2,199 million ($2,152 million adjusted for currency) driven by higher returns on plan assets and plan remeasurements; partially offset by • A decrease in net property, plant and equipment of $782 million ($785 million adjusted for currency).
Long-term debt increased $18,497 million ($18,550 million adjusted for currency) primarily driven by: • Issuances of $26,081 million; partially offset by • Reclassifications to short-term debt of $7,592 million to reflect upcoming maturities.
Noncurrent liabilities (excluding debt) increased $6,778 million ($6,911 million adjusted for currency) primarily driven by: • An increase in long-term operating lease liabilities of $3,879 million ($3,893 million adjusted for currency) as a result of the adoption of the new leasing standard on January 1, 2019; and • An increase in other liabilities of $2,352 million ($2,320 million adjusted for currency), primarily driven by increases in deferred tax liabilities of $1,534 million and income tax reserves of $923 million.
Table:
($ in millions) |  | 
At December 31: | 2019 | 2018
Noncurrent assets | $113,767 | $74,236
Long-term debt | $ 54,102 | $35,605
Noncurrent liabilities (excluding debt) | $ 39,398 | $32,621


Question: What is the percentage increase / (decrease) in the Noncurrent liabilities (excluding debt) from 2018 to 2019?
Answer: 20.77
Calculation: (39,398 / 32,621 - 1) * 100
The Company incurred approximately $106,000 in legal, professional, and other costs related to this acquisition accounted for as selling and administrative expenses when incurred. The remaining weighted-average useful life of intangible assets acquired was 12.5 years as of the acquisition date.
As the active cabinet business was not operated as a separate subsidiary, division or entity, Calix did not maintain separate financial statements for the active cabinet business. As a result, we are unable to accurately determine earnings/loss for the active cabinet business on a standalone basis since the date of acquisition.
The following table below reflects our unaudited pro forma combined results of operations as if the acquisition had taken place as of October 1, 2016 and shows the net sales and net income as if the active cabinet business were combined with the Clearfield business for the years ended September 30, 2018 and 2017.
The pro forma includes estimated expenses relating to the amortization of intangibles purchased, the amortization of the inventory fair value adjustment, and estimated personnel costs:
The pro forma unaudited results do not purport to be indicative of the results which would have been obtained had the acquisition been completed as of the beginning of the earliest period presented or of results that may be obtained in the future. In addition, they do not include any benefits that may result from the acquisition due to synergies that may be derived from the elimination of any duplicative costs.
Table:
 | Pro Forma Year Ended September 30, 2018 (unaudited) | Pro Forma Year Ended September 30, 2017 (unaudited)
Net sales | $80,958,789 | $89,672,074
Income from operations | $5,554,766 | $8,174,841
Net income | 4,794,757 | $5,809,018
Net income per share: |  | 
Basic | 0.36 | $0.43
Diluted | 0.36 | $0.43


Question: What is the difference between the net income per share between basic and diluted shares in 2018?
Answer: 0
Calculation: 0.36-0.36
The following table summarizes the components of net periodic pension cost recognized in the consolidated statements of operations for the plans for the years ended December 31, 2019, 2018 and 2017:
The components of net periodic pension cost other than the service cost component are included in other, net within other income (expense) in the consolidated statements of operations.
In 2019, we purchased a group annuity contract to transfer the pension benefit obligations and annuity administration for a select group of retirees or their beneficiaries to an annuity provider. Upon issuance of the group annuity contract, the pension benefit obligation of $24.4 million for approximately 500 participants was irrevocably transferred to the annuity provider. The purchase of the group annuity was funded directly by the assets of the Pension Plans. During the year ended December 31, 2019, we recognized a pension settlement charge of $6.7 million as a result of the transfer of the pension liability to the annuity provider and other lump sum payments made during the year.
In 2018 and 2017, the Retirement Plan was amended to freeze benefit accruals under the cash balance benefit plan for certain participants under collective bargaining agreements. As a result of these amendments, we recognized a pre-tax curtailment gain of $1.2 million and $1.3 million as a component of net periodic pension cost during the years ended December 31, 2018 and 2017, respectively.
Table:
(In thousands) | 2019 | 2018 | 2017
Service cost | $ 50 | $ 5,809 | $ 3,055
Interest cost | 30,327 | 28,870 | 21,882
Expected return on plan assets | (34,627) | (38,640) | (28,459)
Amortization of: |  |  | 
Net actuarial loss | 2,890 | 6,110 | 6,244
Prior service cost (credit) | 123 | (204) | (316)
Plan curtailment | — | (1,156) | (1,337)
Plan settlement | 6,726 | 94 | 17
Net periodic pension cost | $ 5,489 | $ 883 | $ 1,086


Question: What was the average net actuarial loss for 2017-2019?
Answer: 5081.33
Calculation: (2,890 + 6,110 + 6,244) / 3
Restructuring Expenses: restructuring expenses resulted from the execution of management approved restructuring plans that were generally developed to improve our cost structure and/or operations, often in conjunction with our acquisition integration strategies. restructuring expenses consist of employee severance costs and may also include charges for duplicate facilities and other contract termination costs to improve our cost structure prospectively. For additional information regarding our restructuring plans, see Note 8 of Notes to Consolidated Financial Statements included elsewhere in this Annual report.
Restructuring expenses in fiscal 2019 primarily related to our 2019 restructuring Plan. restructuring expenses in fiscal 2018 primarily related to our 2017 restructuring Plan, which is substantially complete. Our management approved, committed to and initiated these plans in order to restructure and further improve efficiencies in our operations. In the fourth quarter of fiscal 2019, our management supplemented the 2019 restructuring Plan to reflect additional actions that we expect to take. The total estimated restructuring costs associated with the 2019 restructuring Plan are up to $584 million, of which approximately $108 million remained as of May 31, 2019, and will be recorded to the restructuring expense line item within our consolidated statements of operations as the costs are incurred through an expected end date during fiscal 2020. Our estimated costs are subject to change in future periods. We may incur additional restructuring expenses in future periods due to the initiation of new restructuring plans or from changes in estimated costs associated with existing restructuring plans .
Table:
 |  |  | Year Ended May 31, | 
 |  |  | Percent Change | 
(Dollars in millions) | 2019 | Actual | Constant | 2018
restructuring expenses | $443 | -25% | -22% | $588


Question: How much was the average restructuring expenses in 2018 and 2019?
Answer: 515.5
Calculation: (443+588) / 2
NOTE 26 – EARNINGS PER SHARE AND DIVIDEND PER SHARE
When calculating diluted earnings per share for 2018 and 2017, RSUs have been omitted as they are out-of-the-money and thus anti-dilutive, but the RSUs may potentially dilute earnings per share in the future. Please refer to note 3 for information on the RSU share options.
Table:
 | 2019 | 2018 | 2017
EARNINGS PER SHARE |  |  | 
Net profit/(loss) for the year (USDm) | 166.0 | -34.8 | 2.4
Million shares |  |  | 
Weighted average number of shares | 74.3 | 73.4 | 62.3
Weighted average number of treasury shares | -0.3 | -0.3 | -0.3
Weighted average number of shares outstanding | 74.0 | 73.1 | 62.0
Dilutive effect of outstanding share options | 0.0 | - | -
Weighted average number of shares outstanding incl. dilutive effect of share options | 74.0 | 73.1 | 62.0
Basic earnings/(loss) per share (USD) | 2.24 | -0.48 | 0.04
Diluted earnings/(loss) per share (USD) | 2.24 | -0.48 | 0.04


Question: Why have RSUs been omitted when calculating diluted earnings per share for 2018 and 2017?
Answer: RSUs have been omitted as they are out-of-the-money and thus anti-dilutive
The fair value of the derivative feature of the 127,346 and 295,945 warrants issued to the placement agent of the Company’s 2016 private offering and to a holder of its debt for debt cancellation in connection with the Merger, respectively on the issuance dates and at the balance sheet date were calculated using a Black-Scholes option model valued with the following assumptions:
Risk-free interest rate: The Company uses the risk-free interest rate of a U.S. Treasury Note with a similar expected term on the date of measurement.
Dividend yield: The Company uses a 0% expected dividend yield as the Company has not paid dividends to date and does not anticipate declaring dividends in the near future.
Volatility: The Company calculates the expected volatility of the stock price based on the corresponding volatility of the Company’s peer group stock price for a period consistent with the warrants’ expected term.
Expected term: The Company’s expected term is based on the remaining contractual maturity of the warrants.
During the year ended December 31, 2019 and 2018, the Company marked the derivative feature of the warrants to fair value and recorded a loss of $343,857 and a gain
of $250,241 relating to the change in fair value, respectively.
Table:
 | December 31, 2018 | December 31, 2019
Exercise price | 1.25 | 1.25
Risk-free interest rate | 2.46% | 1.59%
Dividend yield | 0.00% | 0.00%
Expected volatility | 152% | 133%
Contractual term | 2.15 years | 1.15 years


Question: How many warrants did the company issue altogether?
Answer: 423291
Calculation: 127,346 + 295,945
13. Income Taxes
On December 22, 2017, the Tax Cuts and Jobs Act (“Tax Act”) was signed into U.S. Law. As of December 31, 2018, the Company had completed its accounting for the tax effects related to the enactment of the Tax Act.
The Tax Act reduced the U.S. federal corporate income tax rate from 35% to 21%, effective January 1, 2018. During the year ended December 31, 2017, the Company remeasured certain deferred tax assets and liabilities and recorded a $15.0 million provisional tax charge. During the year ended December 31, 2018, the Company reduced the initial provisional tax charge by recording a $4.9 million benefit related to accelerated tax deductions claimed on the 2018 U.S. Federal Income Tax Return.
The Tax Act required U.S. companies to pay a one-time transition tax on certain unremitted foreign earnings. During the year ended December 31, 2017, the Company recorded a $20.9 million provisional tax charge based on post-1986 earnings and profits of foreign subsidiaries that were previously deferred from U.S. income taxes. Upon further analysis, the Company reduced the initial provisional tax charge by recording an $8.1 million benefit during the year ended December 31, 2018.
During the year ended December 31, 2018, the Company recorded a $15.5 million valuation allowance on its deferred tax asset related to U.S. foreign tax credits based upon business conditions and tax laws in effect at that time.
During the year ended December 31, 2019, following the acquisition of Speedpay, the Company determined it will more likely than not be able to utilize foreign tax credits in future years due to additional income generated by Speedpay; therefore, the Company released the $15.5 million valuation allowance that had been established on this deferred tax asset.
The Tax Act subjects a U.S. shareholder to tax on global intangible low-taxed income ("GILTI") earned by certain foreign subsidiaries. The Company has elected to account for GILTI in the year the tax is incurred.
Prior to 2018, the Company considered all earnings in foreign subsidiaries to be indefinitely reinvested, and accordingly, recorded no deferred income taxes related to unremitted earnings. As of December 31, 2019 and 2018, the Company considered only the earnings in its Indian subsidiaries to be indefinitely reinvested. The earnings of all other foreign subsidiaries are no longer considered indefinitely reinvested. The Company is also permanently reinvested for outside book/tax basis differences related to foreign subsidiaries.
For financial reporting purposes, income before income taxes includes the following components (in thousands):
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
United States | -16,317 | $16,312 | -42,863
Foreign | 88,527 | 75,487 | 86,435
Total | $72,210 | $91,799 | $43,572


Question: What was the income from Foreign countries in 2019?
Answer: 88,527
Liquidity risk
Our policy is to maintain a strong capital base so as to maintain investor, creditor and market confidence and to sustain future development of the business.
Our liquidity needs are affected by many factors, some of which are based on the normal on-going operations of the business, and others that relate to the uncertainties of the global economy and the semiconductor industry. Although our cash requirements fluctuate based on the timing and extent of these factors, we believe that cash generated from operations, together with our principal sources of liquidity are sufficient to satisfy our current requirements, including our expected capital expenditures in 2020.
We intend to return cash to our shareholders on a regular basis in the form of dividend payments and, subject to our actual and anticipated liquidity requirements and other relevant factors, share buybacks.
The following table summarizes the Company’s contractual and other obligations as at December 31, 2019.
Total short-term lines of credit amounted to €150 million at December 31, 2019. The amount outstanding at December 31, 2019 was nil and the undrawn portion totaled €150 million. The standby revolving credit facility of €150 million with a consortium of banks will be available through December 16, 2023.
For the majority of purchase commitments, the Company has flexible delivery schedules depending on the market conditions, which allows the Company, to a certain extent, to delay delivery beyond originally planned delivery schedules.
Table:
 | Total | Less than 1 year | 1-5 years | More than 5 years
Accounts payable | 119,712 | 119,712 | — | —
Income tax payable | 34,599 | 34,599 | — | —
Accrued expenses and other payables | 149,843 | 149,843 | — | —
Lease liabilities | 24,261 | 6,977 | 14,726 | 2,558
Pension liabilities | 7,734 | 333 | 2,544 | 4,857
Purchase obligations: |  |  |  | 
Purchase commitments to suppliers | 100,694 | 99,546 | 1,148 | —
Capital expenditure and other commitments | 43,692 | 40,745 | 2,947 | —
Total contractual obligations | 480,535 | 451,755 | 21,365 | 7,415


Question: What is the Total short-term lines of credit at the end of 2019?
Answer: €150 million
Cash Flow
Cash flow provided by operating activities. Cash flows provided by operating activities were $7.2 million in fiscal 2019. The provision of cash was due primarily to our operating loss of $13.2 million adjusted for $22.4 million in non-cash expense including depreciation, amortization, and share based compensation and an increase of approximately $2 million in net operating assets and liabilities.
Cash flows provided by operating activities were $6.9 million in fiscal 2018. The provision of cash was due primarily to our operating loss of $12.1 million adjusted for $19.2 million in non-cash expense including depreciation, amortization, and share based compensation.
Cash flows provided by operating activities were $3.4 million in fiscal 2017. The provision of cash included $6.4 million in increased collections on accounts receivable.
Cash flow used in investing activities. Cash flows used in investing activities in fiscal 2019 were $5.5 million. This is primarily attributed to $2.2 million in development of proprietary software and $3.3 million for purchase of property and equipment, including internal use software.
Cash flows used in investing activities in fiscal 2018 were $15.1 million. This is primarily attributed to $8.9 million in development of proprietary software and $6.1 million for purchase of property and equipment, including internal use software.
Cash flows used in investing activities in fiscal 2017 were $13.9 million. This is primarily attributed to $11.9 million in development of proprietary software and $4.2 million for purchase of property and equipment, including internal use software offset by $2.2 million in proceeds from corporate owned life insurance policies.
Cash flow used in financing activities. Respectively, in fiscal 2019, 2018, and 2017, the $0.8 million, $1.3 million, and $0.8 million cash flows used in financing activities were primarily comprised of the repurchase of shares to satisfy employee tax withholding and to cover the exercise price of the options, and payments on capital lease obligations.
Table:
 |  | Year ended March 31, | 
(In thousands) | 2019 | 2018 | 2017
Net cash provided by (used in): |  |  | 
Operating activities | $7,241 | $6,874 | $3,433
Investing activities | (5,534) | (15,085) | (13,865)
Financing activities | (767) | (1,295) | (847)
Effect of exchange rate changes on cash | (112) | 194 | (74)
Cash flows provided by (used in) operations | $828 | $(9,312) | $(11,353)


Question: What was the average investing activities for 2018 and 2019?
Answer: -10309.5
Calculation: -(5,534 + 15,085) / 2
share-based compensation cost is recorded net of estimated forfeitures on a straight-line basis for awards with service conditions only , and on a graded-vesting basis for awards with service , performance and market conditions . the company 2019s estimated forfeiture rate is based on an evaluation of historical , actual and trended forfeiture data . for fiscal 2014 , 2013 , and 2012 , the company recorded share-based compensation cost of $ 172 million , $ 179 million and $ 147 million , respectively , in personnel on its consolidated statements of operations . the amount of capitalized share-based compensation cost was immaterial during fiscal 2014 , 2013 and 2012 . options options issued under the eip expire 10 years from the date of grant and vest ratably over 3 years from the date of grant , subject to earlier vesting in full under certain conditions . during fiscal 2014 , 2013 and 2012 , the fair value of each stock option was estimated on the date of grant using a black-scholes option pricing model with the following weighted-average assumptions: .

Table:
 | 2014 | 2013 | 2012
expected term ( in years ) ( 1 ) | 4.80 | 6.08 | 6.02
risk-free rate of return ( 2 ) | 1.3% ( 1.3 % ) | 0.8% ( 0.8 % ) | 1.2% ( 1.2 % )
expected volatility ( 3 ) | 25.2% ( 25.2 % ) | 29.3% ( 29.3 % ) | 34.9% ( 34.9 % )
expected dividend yield ( 4 ) | 0.8% ( 0.8 % ) | 0.9% ( 0.9 % ) | 0.9% ( 0.9 % )
fair value per option granted | $ 44.11 | $ 39.03 | $ 29.65
( 1 ) beginning in fiscal 2014 , assumption is based on the company 2019s historical option exercises and those of a set of peer companies that management believes is generally comparable to visa .
the company 2019s data is weighted based on the number of years between the measurement date and visa 2019s initial public offering as a percentage of the options 2019 contractual term .
the relative weighting placed on visa 2019s data and peer data in fiscal 2014 was approximately 58% ( 58 % ) and 42% ( 42 % ) , respectively .
in fiscal 2013 and 2012 , assumption was fully based on peer companies 2019 data .
( 2 ) based upon the zero coupon u.s .
treasury bond rate over the expected term of the awards .
( 3 ) based on the company 2019s implied and historical volatility .
in fiscal 2013 and 2012 , historical volatility was a blend of visa 2019s historical volatility and those of comparable peer companies .
the relative weighting between visa historical volatility and the historical volatility of the peer companies was based on the percentage of years visa stock price information is available since its initial public offering compared to the expected term .
the expected volatilities ranged from 22% ( 22 % ) to 26% ( 26 % ) in fiscal ( 4 ) based on the company 2019s annual dividend rate on the date of grant. .

Question: what is the total share-based compensation cost in the last three years?
Answer: 498
Calculation: add(172, 179), add(#0, 147)
compensation plan approved by security holders . the employee stock purchase plan and the 2005 director stock plan were approved by shareholders at our 2005 annual meeting of shareholders . in connection with our mergers with cbot holdings and nymex holdings , we assumed their existing equity plans . the shares relating to the cbot holdings and nymex holdings plans are listed in the table below as being made under an equity compensation plan approved by security holders based upon the fact that shareholders of the company approved the related merger transactions . plan category number of securities to be issued upon exercise of outstanding options ( a ) weighted-average exercise price of outstanding options ( b ) number of securities remaining available for future issuance under equity compensation plans ( excluding securities reflected in column ( a ) ) ( c ) equity compensation plans approved by security holders . . . . . . . . . . . . . . . . . . . 1211143 $ 308.10 5156223 equity compensation plans not approved by security holders . . . . . . . . . . . . . . . . 5978 22.00 2014 .

Table:
plan category | number of securities to be issued upon exercise of outstanding options ( a ) | weighted-average exercise price of outstanding options ( b ) | number of securities remaining available for future issuance underequity compensation plans ( excluding securities reflected in column ( a ) ) ( c )
equity compensation plans approved by security holders | 1211143 | $ 308.10 | 5156223
equity compensation plans not approved by security holders | 5978 | 22.00 | 2014
total | 1217121 |  | 5156223
item 13 .
certain relationships , related transactions and director independence the information required by this item is included in cme group 2019s proxy statement under the heading 201ccertain business relationships with related parties 201d and 201ccorporate governance 2014director independence 201d and is incorporated herein by reference , pursuant to general instruction g ( 3 ) .
item 14 .
principal accountant fees and services the information required by this item is included in cme group 2019s proxy statement under the heading 201caudit committee disclosures 2014principal accountant fees and services 201d and 201caudit committee disclosures 2014audit committee policy for approval of audit and permitted non-audit services 201d and is incorporated herein by reference , pursuant to general instruction g ( 3 ) . .

Question: what is the total value of the approved equity compensation plans in 2005 , in millions of dollars?
Answer: 375.15
Calculation: multiply(1211143, 308.10), divide(#0, const_1000000)