hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Electro-Magnetic, Sensors, and Actuators
The following table sets forth net sales, operating income, and operating income as a percentage of net sales for our MSA reportable segment in fiscal years 2019 and 2018 (amounts in thousands, except percentages).
Net Sales MSA net sales of $240.7 million in fiscal year 2019 increased $13.8 million or 6.1% from $227.0 million in fiscal year 2018. The increase in net sales was primarily driven by a $15.0 million increase in OEM sales in the JPKO region. Also contributing to the increase in net sales was a $4.3 million increase in EMS sales across all regions and a $3.7 million increase in distributor sales across the Americas and EMEA regions. These increase in net sales were partially offset by a $5.5 million decrease in distributor sales across the APAC and JPKO regions and a $3.8 million decrease in OEM sales across the Americas, APAC, and JPKO regions.
Reportable Segment Operating Income
Segment operating income of $22.5 million in fiscal year 2019 increased $6.9 million from $15.7 million in fiscal year 2018. The increase in operating income was primarily due to a $6.6 million decrease in SG&A expenses resulting from a decrease in payroll expenses that was caused by a reduction in head count. Also contributing to the increase in operating income was a $2.9 million decrease in restructuring charges, a $1.3 million decrease in net loss on write down and disposal of long-lived assets, and a $0.2 million decrease in R&D expenses. Partially offsetting these improvements was a $4.1 million decrease in gross margin, which was primarily driven by a change in the sales mix to lower margin products.
Table:
 |  | For the Fiscal Years Ended |  | 
 | March 31, 2019 |  | March 31, 2018 | 
Sales | Amount | % to Net Sales | Amount | % to Net Sales
Net sales | $240,740 |  | $226,964 | 
Segment operating income | 22,546 | 9.4% | 15,694 | 6.9%


Question: Which years did net sales exceed $200,000 thousand?
Answer: 2019, 2018
Calculation: (2019:240,740),(2018:226,964)
Note 10. Intangible Assets and Goodwill
Intangible assets consist of the following (in millions):
Table:
 |  | March 31, 2019 | 
 | Gross Amount | Accumulated Amortization | Net Amount
Core and developed technology | $7,413.0 | $(1,112.9) | $6,300.1
Customer-related | 917.1 | (544.0) | 373.1
In-process research and development | 7.7 | — | 7.7
Distribution rights | 0.3 | (0.2) | 0.1
Other | 7.3 | (2.7) | 4.6
Total | $8,345.4 | $(1,659.8) | $6,685.6


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


Question: Which were the bottom 2 revenue items for 2017?
Answer: LinkedIn, Other
Calculation:  21,649>25,573>18,593>9,051>6,219>5,542>5,062>2,611>2,271
Debt
Our funding requirements are continually monitored and we execute our strategies to manage the overall asset and liability profile. Additionally, we maintain sufficient flexibility to access global funding sources as needed.
Total debt of $62,899 million increased $17,087 million from December 31, 2018, driven by issuances of $32,415 million; partially offset by debt maturities of $12,673 million and a decrease in commercial paper of $2,691 million.
Non-Global Financing debt of $38,173 million increased $23,587 million from prior year-end levels primarily driven by issuances to fund the Red Hat acquisition.
Global Financing debt of $24,727 million decreased $6,500 million from December 31, 2018, primarily due to the wind down of OEM IT commercial financing operations.
Global Financing provides financing predominantly for IBM’s external client assets, as well as for assets under contract by other IBM units. These assets, primarily for GTS, generate long-term, stable revenue streams similar to the Global Financing asset portfolio. Based on their attributes, these GTS assets are leveraged with the balance of the Global Financing asset base.
The debt used to fund Global Financing assets is composed of intercompany loans and external debt. Total debt changes generally correspond with the level of client and commercial financing receivables, the level of cash and cash equivalents, the change in intercompany and external payables and the change in intercompany investment from IBM. The terms of the intercompany loans are set by the company to substantially match the term, currency and interest rate variability underlying the financing receivable and are based on arm’s-length pricing. The Global Financing debt-to-equity ratio remained at 9 to 1 at December 31, 2019.
As previously stated, we measure Global Financing as a stand-alone entity, and accordingly, interest expense relating to debt supporting Global Financing’s external client and internal business is included in the “Global Financing Results of Operations” and in note D, “Segments.” In the Consolidated Income Statement, the external debt-related interest expense supporting Global Financing’s internal financing to IBM is reclassified from cost of financing to interest expense.
Table:
($ in millions) |  | 
At December 31: | 2019 | 2018
Total company debt | $62,899 | $45,812
Total Global Financing segment debt | $24,727 | $31,227
Debt to support external clients | 21,487 | 27,536
Debt to support internal clients | 3,239 | 3,690
Non-Global Financing debt | 38,173 | 14,585


Question: What was the average Debt to support external clients?
Answer: 24511.5
Calculation: (21,487 + 27,536) / 2
2016 Collective Bargaining Negotiations
During 2016, we adopted changes to our defined benefit pension plans and other postretirement benefit plans to reflect the agreed upon terms and conditions of the collective bargaining agreements ratified in June 2016. The impact includes a net increase to Accumulated other comprehensive income of $2.9 billion (net of taxes of $1.8 billion).
The amount recorded in Accumulated other comprehensive income will be reclassified to net periodic benefit cost on a straight-line basis over the average remaining service period of the respective plans’ participants, which, on a weighted-average basis, is 12.2 years for defined benefit pension plans and 7.8 years for other postretirement benefit plans.
The above-noted reclassification resulted in a decrease to net periodic benefit cost and increase to pre-tax income of approximately $658 million during 2019, 2018 and 2017, respectively. Information for pension plans with an accumulated benefit obligation in excess of plan assets follows:
Information for pension plans with an accumulated benefit obligation in excess of plan assets follows:
Table:
 |  | (dollars in millions)
At December 31, | 2019 | 2018
Projected benefit obligation | $ 21,190 | $ 19,510
Accumulated benefit obligation | 21,134 | 19,461
Fair value of plan assets | 19,388 | 17,757


Question: What is the change in the projected benefit obligation from 2018 to 2019?
Answer: 1680
Calculation: 21,190 - 19,510
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
NOTE 6. EARNINGS PER SHARE
Basic earnings per share (“EPS”) is computed by dividing income available to common stockholders by the weighted-average number of common shares outstanding during the period. The computation of diluted EPS is similar to the computation of basic EPS except that the denominator is increased to include the number of additional common shares that would have been outstanding (using the if-converted and treasury stock methods), if our outstanding stock options and restricted stock units had been converted to common shares, and if such assumed conversion is dilutive.
The following is a reconciliation of the weighted-average shares outstanding used in the calculation of basic and diluted earnings per share for the years ended December 31, 2019, 2018 and 2017:
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Income from continuing operations | $56,495 | $147,149 | $136,101
Income from continuing operations attributable to noncontrolling interest | 34 | 86 | —
Income from continuing operations attributable to Advanced Energy Industries, Inc. | $56,461 | $147,063 | $136,101
Basic weighted-average common shares outstanding | 38,281 | 39,081 | 39,754
Assumed exercise of dilutive stock options and restricted stock units | 214 | 271 | 422
Diluted weighted-average common shares outstanding | 38,495 | 39,352 | 40,176
Continuing operations: |  |  | 
Basic earnings per share | $ 1.47 | $ 3.76 | $  3.42
Diluted earnings per share | $ 1.47 | $ 3.74 | $  3.39


Question: What was the change in Diluted weighted-average common shares outstanding between 2018 and 2019?
Answer: -857
Calculation: 38,495-39,352
Note 3: Debt
The line item “Interest expense” on the Consolidated Statements of Operations for the fiscal years 2019, 2018 and 2017, respectively, is as follows (amounts in thousands):
Table:
 |  | Fiscal Years Ended March 31, | 
 | 2019 | 2018 | 2017
Contractual interest expense | $19,471 | $30,323 | $38,825
Capitalized interest | (232) | (141) | (154)
Amortization of debt issuance costs | 334 | 511 | 1,390
Amortization of debt (premium) discount | 1,481 | 1,843 | (788)
Imputed interest on acquisition related obligations | 57 | 113 | 159
Interest expense on capital leases | 128 | 233 | 323
Total interest expense | $21,239 | $32,882 | $39,755


Question: What was the change in the Amortization of debt issuance costs between 2017 and 2018?
Answer: -879
Calculation: 511-1,390
Note 14 Debt and Credit Facilities
Our total debt outstanding consisted of the amounts set forth on the following table:
(1) Short-term borrowings of $98.9 million at December 31, 2019 were comprised of $89.0 million under our revolving credit facility and $9.9 million of short-term borrowings from various lines of credit. Short-term borrowings of $232.8 million at December 31, 2018 were comprised of $140.0 million under our revolving credit facility, $83.9 million under our European securitization program and $8.9 million of short-term borrowings from various lines of credit.
(2) The Current portion of long-term debt includes finance lease liabilities of $10.4 million as of December 31, 2019. The Other debt balance includes $28.7 million for long-term liabilities associated with our finance leases as of December 31, 2019. See Note 4, "Leases," of the Notes to Condensed Consolidated Financial Statements for additional information on finance and operating lease liabilities.
(3) Amounts are net of unamortized discounts and issuance costs of $24.6 million and $24.3 million as of December 31, 2019 and 2018, respectively.
(4) As of December 31, 2019, our weighted average interest rate on our short-term borrowings outstanding was 5.0% and on our long-term debt outstanding was 4.8%. As of December 31, 2018, our weighted average interest rate on our short-term borrowings outstanding was 2.8% and on our long-term debt outstanding was 5.4%.
Table:
 | December 31, | 
(In millions) | 2019 | 2018
Short-term borrowings (1) | $ 98.9 | $ 232.8
Current portion of long-term debt(2) | 16.7 | 4.9
Total current debt | 115.6 | 237.7
Term Loan A due July 2022 | 474.6 | —
Term Loan A due July 2023 | 218.2 | 222.2
6.50% Senior Notes due December 2020 | — | 424.0
4.875% Senior Notes due December 2022 | 421.9 | 421.1
5.25% Senior Notes due April 2023 | 422.0 | 421.2
4.50% Senior Notes due September 2023 | 445.6 | 454.9
5.125% Senior Notes due December 2024 | 421.9 | 421.3
5.50% Senior Notes due September 2025 | 397.4 | 397.1
4.00% Senior Notes due December 2027 | 420.4 | —
6.875% Senior Notes due July 2033 | 445.7 | 445.5
Other(2) | 30.9 | 29.2
Total long-term debt, less current portion(3) | 3,698.6 | 3,236.5
Total debt(4) | $ 3,814.2 | $ 3,474.2


Question: What were Short-term borrowings of $98.9 million at December 31, 2019 comprised of?
Answer: $89.0 million under our revolving credit facility and $9.9 million of short-term borrowings from various lines of credit.
Contract Balances
Our contract assets consist of unbilled amounts for technology development contracts as well as custom product contracts. Also included in contract assets are royalty revenue and carrying amounts of right of returned inventory. Long-term contract assets include the fee withholding on cost reimbursable contracts that will not be billed within a year. Contract liabilities include excess billings, subcontractor accruals, warranty expense, extended warranty revenue, right of return refund, and customer deposits. The net contract (liabilities)/assets changed by $1.0 million, due primarily to increased contract liabilities in addition to a slight increase in contract assets. The increase in contract liabilities is a result of the increased number of government research programs in addition to an increase in the number of our fixed-price contracts that have reached milestones as designated in their respective contracts, but revenue has not yet been recognized. The increase in contract assets is primarily driven by the unbilled fee required by our cost-reimbursable government contracts, which cannot be fully billed until after the specific contract is complete.
The following table shows the components of our contract balances as of December 31, 2019 and 2018:
Table:
 | December 31, | 
 | 2019 | 2018
Contract assets | $3,208,206 | $2,759,315
Contract liabilities | (3,887,685) | (2,486,111)
   Net contract assets | $(679,479) | $273,204


Question: What do contract assets consist of?
Answer: unbilled amounts for technology development contracts as well as custom product contracts.
equity compensation plan information the following table presents the equity securities available for issuance under our equity compensation plans as of december 31 , 2015 . equity compensation plan information plan category number of securities to be issued upon exercise of outstanding options , warrants and rights ( 1 ) weighted-average exercise price of outstanding options , warrants and rights ( 2 ) number of securities remaining available for future issuance under equity compensation plans ( excluding securities reflected in column ( a ) ) ( a ) ( b ) ( c ) equity compensation plans approved by security holders 1424356 $ 33.90 4281952 equity compensation plans not approved by security holders ( 3 ) 2014 2014 2014 .

Table:
plan category | number of securities to be issued upon exercise of outstanding options warrants and rights ( 1 ) ( a ) ( b ) | weighted-average exercise price of outstanding optionswarrants and rights ( 2 ) | number of securities remaining available for future issuance under equity compensation plans ( excluding securitiesreflected in column ( a ) ) ( c )
equity compensation plans approved by security holders | 1424356 | $ 33.90 | 4281952
equity compensation plans not approved by security holders ( 3 ) | 2014 | 2014 | 2014
total | 1424356 | $ 33.90 | 4281952
( 1 ) includes grants made under the huntington ingalls industries , inc .
2012 long-term incentive stock plan ( the "2012 plan" ) , which was approved by our stockholders on may 2 , 2012 , and the huntington ingalls industries , inc .
2011 long-term incentive stock plan ( the "2011 plan" ) , which was approved by the sole stockholder of hii prior to its spin-off from northrop grumman corporation .
of these shares , 533397 were subject to stock options and 54191 were stock rights granted under the 2011 plan .
in addition , this number includes 35553 stock rights , 10279 restricted stock rights , and 790936 restricted performance stock rights granted under the 2012 plan , assuming target performance achievement .
( 2 ) this is the weighted average exercise price of the 533397 outstanding stock options only .
( 3 ) there are no awards made under plans not approved by security holders .
item 13 .
certain relationships and related transactions , and director independence information as to certain relationships and related transactions and director independence will be incorporated herein by reference to the proxy statement for our 2016 annual meeting of stockholders , to be filed within 120 days after the end of the company 2019s fiscal year .
item 14 .
principal accountant fees and services information as to principal accountant fees and services will be incorporated herein by reference to the proxy statement for our 2016 annual meeting of stockholders , to be filed within 120 days after the end of the company 2019s fiscal year. .

Question: in the "2011 plan" what was the ratio of the stock option stock option stock to the stock rights
Answer: 9.84
Calculation: divide(533397, 54191)
Comparison of Years Ended December 31, 2019 to December 31, 2018
The following tables in this section set forth our selected consolidated statements of operations (in thousands), data for the percentage change and data as a percentage of revenue for the years ended December 31, 2019 and 2018. Certain previously reported amounts in the consolidated statements of operations for the year ended December 31, 2018 have been reclassified to conform to our current presentation to reflect interest income as a separate line item, which was previously included in other income, net.
Revenue
The $81.9 million increase in total revenue in 2019 as compared to 2018 was the result of a $46.3 million, or 16%, increase in our SaaS and license revenue and a $35.6 million, or 27%, increase in our hardware and other revenue. Our software license revenue included within SaaS and license revenue increased $2.1 million to $43.4 million in 2019 as compared to $41.3 million during 2018. The increase in our Alarm.com segment SaaS and license revenue in 2019 was primarily due to growth in our subscriber base, including the revenue impact from subscribers we added in 2018. To a lesser extent, SaaS and license revenue increased in the period due to an increase in license fees. The increase in hardware and other revenue in 2019 compared to 2018 was due to an increase in the volume of video cameras sold. Our Other segment contributed 15% of the increase in SaaS and license revenue in 2019 as compared to 2018. The increase in SaaS and license revenue for our Other segment in 2019 as compared to 2018 was due to an increase in sales of our energy management and demand response solutions and our property management and HVAC solutions. Hardware and other revenue in our Other segment decreased 13% in 2019 as compared to 2018, primarily due to the timing of sales related to our remote access management solution.
Table:
 |  | Year Ended December 31, | 
Revenue: |  |  | % Change
 | 2019 | 2018 | 2019 vs. 2018
SaaS and license revenue | $337,375 | $291,072 | 16%
Hardware and other revenue | 164,988 | 129,422 | 27%
Total revenue | $502,363 | $420,494 | 19%


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


Question: What was the percentage change in Gains excluded from the hedging relationship in 2019 from 2018?
Answer: 214.29
Calculation: (66-21)/21