hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Net Periodic Benefit Cost
The following table provides information about the net periodic benefit cost for the plans for fiscal years 2019, 2018 and 2017 (in thousands):
On September 1, 2018, the Company adopted a new accounting standard, which changes the presentation of net periodic benefit cost in the Consolidated Statements of Operation. The Company adopted the standard on a retrospective basis which results in reclassifications for the service cost component of net periodic benefit cost from selling, general and administrative expense to cost of revenue and for the other components from selling, general and administrative expense to other expense. Prior periods have not been reclassified due to immateriality.
Table:
 |  | Pension | 
 | 2019 | 2018 | 2017
Service cost | $1,437 | $1,063 | $1,068
Interest cost | 3,715 | 3,807 | 2,942
Expected long-term return on plan assets | (5,291) | (5,954) | (4,206)
Recognized actuarial loss | 741 | 1,127 | 1,929
Amortization of prior service credit | (44) | (88) | (138)
Net settlement loss | 634 | 116 | 1,472
Net periodic benefit cost | $1,192 | $71 | $3,067


Question: How many years did the recognized actuarial loss exceed $1,000 thousand?
Answer: 2
Calculation: 2018##2017
16. Segment, Geographic, and Significant Customer Information
We operate in one industry segment: the design, manufacturing, marketing, and technical support of high-performance storage and data management solutions. We conduct business globally, and our sales and support activities are managed on a geographic basis. Our management reviews financial information presented on a consolidated basis, accompanied by disaggregated information it receives from our internal management system about revenues by geographic region, based on the location from which the customer relationship is managed, for purposes of allocating resources and evaluating financial performance. We do not allocate costs of revenues, research and development, sales and marketing, or general and administrative expenses to our geographic regions in this internal management reporting because management does not review operations or operating results, or make planning decisions, below the consolidated entity level.
The majority of our assets, excluding cash, cash equivalents, short-term investments and accounts receivable, were attributable to our domestic operations. The following table presents cash, cash equivalents and short-term investments held in the U.S. and internationally in various foreign subsidiaries (in millions):
Table:
 | April 26, 2019 | April 27, 2018
U.S. | $ 159 | $ 853
International | 3,740 | 4,538
Total | $ 3,899 | $ 5,391


Question: What was the percentage change in the total assets between 2018 and 2019?
Answer: -27.68
Calculation: (3,899-5,391)/5,391
Interest expense and financing costs
Fees and discounts associated with the issuance of our debt instruments are recorded as debt discount, which reduces their respective carrying values, and are amortized over their respective terms. Amortization expense is recorded within “Interest and other expense (income), net” in our consolidated statement of operations.
For the years ended December 31, 2019, 2018, and 2017: interest expense was $86 million, $134 million, and $150 million, respectively; amortization of the debt discount and deferred financing costs was $4 million, $6 million, and $12 million, respectively.
A summary of our outstanding debt is as follows (amounts in millions):
With the exception of the 2026 and the 2047 Notes, using Level 2 inputs (i.e., observable market prices in less-than-active markets) at December 31, 2019, the carrying values of the Notes approximated their fair values, as the interest rates were similar to the current rates at which we could borrow funds over the selected interest periods. At December 31, 2019, based on Level 2 inputs, the fair value of the 2026 and the 2047 Notes were $893 million and $456 million, respectively.
Using Level 2 inputs at December 31, 2018, the carrying values of the 2021 Notes and the 2022 Notes approximated their fair values, as the interest rates were similar to the current rates at which we could borrow funds over the selected interest periods. At December 31, 2019, based on Level 2 inputs, the fair values of the 2026 Notes, the 2027 Notes, and the 2047 Notes were $800 million, $376 million, and $360 million, respectively.
Table:
 |  | At December 31, 2019 | 
 | Gross Carrying Amount | Unamortized Discount and Deferred Financing Costs | Net Carrying Amount
2021 Notes | $650 | $(2) | $648
2022 Notes | 400 | (2) | 398
2026 Notes | 850 | (7) | 843
2027 Notes | 400 | (5) | 395
2047 Notes | 400 | (9) | 391
Total long-term debt | $2,700 | $(25) | $2,675
 |  | At December 31, 2018 | 
 | Gross Carrying Amount | Unamortized Discount and Deferred Financing Costs | Net Carrying Amount
2021 Notes | 650 | (3) | 647
2022 Notes | 400 | (3) | 397
2026 Notes | 850 | (8) | 842
2027 Notes | 400 | (5) | 395
2047 Notes | 400 | (10) | 390
Total long-term debt | $2,700 | $(29) | $2,671


Question: What was the change in the net carrying amount between the 2026 and 2027 Notes in 2018?
Answer: -447
Calculation: 395-842
Cubic Transportation Systems
Sales: CTS sales increased 16% to $670.7 million in 2018 compared to $578.6 million in 2017 and were higher in North America and the U.K., but were slightly lower in Australia. Sales in 2018 were higher in the U.S. primarily due to system development on the New York New Fare Payment System contract, which was awarded in October 2017. Increased work on both development and service contracts, including work on new change orders in London also increased CTS sales for the year. Sales were also positively impacted in the U.K. and Australia due to the impact of exchange rates. The average exchange rates between the prevailing currencies in our foreign operations and the U.S. dollar resulted in an increase in CTS sales of $12.4 million for 2018 compared to 2017, primarily due to the strengthening of the British Pound against the U.S. dollar.
Amortization of Purchased Intangibles: Amortization of purchased intangibles included in the CTS operating results totaled $5.2 million in 2018 and $5.7 million in 2017.
Operating Income: CTS operating income increased 52% in 2018 to $60.4 million compared to $39.8 million in 2017. For 2018, operating income was higher from increased volumes of system development work and services, including work on new projects and change orders, primarily in North America and the U.K. Operating income was also higher due to operational efficiencies and reductions in R&D spending. R&D expenses for CTS in 2017 included $6.4 million of system development expenses related to our anticipated contract with the New York Metropolitan Transit Authority that was awarded in early fiscal 2018; such expenses incurred in 2018 on this contract are classified as cost of sales. During the first quarter of fiscal year 2018 CTS implemented our new enterprise resource planning (ERP) system, and as a result began depreciating the cost of certain capitalized software into its operating results. This resulted in a decrease in operating income of $4.2 million between fiscal 2017 and fiscal 2018. The average exchange rates between the prevailing currency in our foreign operations and the U.S. dollar resulted in an increase in CTS operating income of $2.2 million for 2018 compared to 2017.
Adjusted EBITDA: CTS Adjusted EBITDA increased 50% to $73.3 million in 2018 compared to $48.8 million in 2017 primarily due to the same items described in the operating income section above. The increase in Adjusted EBITDA was primarily driven by the same factors that drove the increase in operating income described above excluding the increase in depreciation and decrease in amortization which are excluded from Adjusted EBITDA.
Table:
 | Fiscal 2018 | Fiscal 2017 | % Change
 |  | (in millions) | 
Sales | $ 670.7 | $  578.6 | 16 %
Operating income | 60.4 | 39.8 | 52
Adjusted EBITDA | 73.3 | 48.8 | 50


Question: In which year was the amortization of purchased intangibles included in the CTS operating results lower?
Answer: 2018
Calculation: 5.2<5.7
Revenue Disaggregation
Autodesk recognizes revenue from the sale of (1) product subscriptions, cloud service offerings, and flexible enterprise business agreements ("EBAs"), (2) renewal fees for existing maintenance plan agreements that were initially purchased with a perpetual software license, and (3) consulting, training and other goods and services. The three categories are presented as line items on Autodesk's Consolidated Statements of Operations.
Information regarding the components of Autodesk's net revenue from contracts with customers by geographic location, product family, and sales channel is as follows:
(1) Due to changes in the go-to-market offerings of our AutoCAD product subscription, prior period balances have been adjusted to conform to current period presentation.
Payments for product subscriptions, industry collections, cloud subscriptions, and maintenance subscriptions are typically due up front with payment terms of 30 to 45 days. Payments on EBAs are typically due in annual installments over the contract term, with payment terms of 30 to 60 days. Autodesk does not have any material variable consideration, such as obligations for returns, refunds, or warranties or amounts payable to customers for which significant estimation or judgment is required as of the reporting date.
As of January 31, 2019, Autodesk had total billed and unbilled deferred revenue of $2.7 billion, which represents the total contract price allocated to undelivered performance obligations, which are generally recognized over the next three years. We expect to recognize $1.9 billion or 72% of this revenue during the next 12 months. We expect to recognize the remaining $0.8 billion or 28% of this revenue thereafter.
We expect that the amount of billed and unbilled deferred revenue will change from quarter to quarter for several reasons, including the specific timing, duration and size of customer subscription and support agreements, varying billing cycles of such agreements, the specific timing of customer renewals, and foreign currency fluctuations
Table:
 |  | Fiscal Year ended January 31, | 
 | 2019 | 2018 | 2017
Net revenue by product family (1): |  |  | 
Architecture, Engineering and Construction | $1,021.6 | $787.5 | $810.4
Manufacturing | 616.2 | 528.8 | 575.2
AutoCAD and AutoCAD LT | 731.8 | 561.4 | 472.7
Media and Entertainment | 182 | 152.1 | 138.8
Other | 18.2 | 26.8 | 33.9
Total net revenue | $2,569.8 | $2,056.6 | $2,031.0
Net revenue by geographic area: |  |  | 
Americas |  |  | 
U.S. | $874.6 | $740.4 | $742.1
Other Americas | 175.3 | 130.7 | 129.8
Total Americas | 1,049.9 | 871.1 | 871.9
Europe, Middle East and Africa | 1,034.3 | 815.4 | 800.4
Asia Pacific | 485.6 | 370.1 | 358.7
Total net revenue | $2,569.8 | $2,056.6 | $2,031.0
Net revenue by sales channel: |  |  | 
Indirect | $1,830.8 | $1,443.8 | $1,468.9
Direct | 739.0 | 612.8 | 562.1
Total net revenue | $2,569.8 | $2,056.6 | $2,031.0


Question: What is the total revenue from Manufacturing from 2018 to 2019? 
Answer: 1145
Calculation: 528.8+616.2
Share Options
The fair value of equity-settled share options granted is measured as at the date of grant using a Black-Scholes model, taking into account the terms and conditions upon which the options were granted.
The following table illustrates the weighted average inputs into the Black-Scholes model in the year:
The weighted average fair value of options granted during the year was $ cents 220.53 (2018: $ cents 185.33).
The expected volatility reflects the assumption that the historical share price volatility is indicative of future trends, which may not necessarily be the actual outcome. An increase in the expected volatility will increase the estimated fair value.
The expected life of the options is based on historical data and is not necessarily indicative of exercise patterns that may occur. The expected life used in the model has been adjusted, based on the Director’s best estimate, taking into account the effects of exercise restrictions, non-transferability and behavioural considerations. An increase in the expected life will increase the estimated fair value.
Table:
 | Year-ended | Year-ended
 | 31 March 2019 | 31 March 2018
Weighted average share price ($ cents) | 676.10 | 628.23
Weighted average exercise price ($ cents) | 558.54 | 516.70
Expected volatility | 54.91% | 38.20%
Expected life of options (years) | 1.69 | 2.08
Risk free rate | 1.56% | 1.49%
Dividend yield | 0.81% | 0.70%


Question: In which year was the Weighted average share price larger?
Answer: 2019
Calculation: 676.10>628.23
Stock Option Activity - The weighted-average fair value of options granted during the years ended December 31, 2019, 2018 and 2017, as determined under the Black-Scholes-Merton valuation model, was $12.07, $10.42 and $6.75, respectively. Option grants that vested during the years ended December 31, 2019, 2018 and 2017 had a combined fair value of $2.5 million, $1.5 million and $1.7 million, respectively.
The following table summarizes stock option activity for the years ended December 31, 2019, 2018 and 2017:
Table:
 | Number of Shares | Weighted Average Exercise Price | Aggregate Intrinsic Value (in thousands) | Weighted Average Remaining Contractual Life
Stock options outstanding at December 31, 2016 | 1,160,419 | $29.93 | $14,299 | 
Granted | 534,030 | $42.90 |  | 
Exercised | (463,800) | $29.34 | $7,203 | 
Cancelled and expired | (61,241) | $33.80 |  | 
Stock options outstanding at December 31, 2017 | 1,169,408 | $35.88 | $16,731 | 
Granted | 466,828 | $54.87 |  | 
Exercised | (420,524) | $30.05 | $12,411 | 
Cancelled and expired | (122,312) | $43.85 |  | 
Stock options outstanding at December 31, 2018 | 1,093,400 | $45.34 | $8,776 | 
Granted | 489,947 | $63.87 |  | 
Exercised | (338,748) | $37.94 | $9,641 | 
Cancelled and expired | (108,504) | $51.21 |  | 
Stock options outstanding at December 31, 2019 | 1,136,095 | $54.98 | $28,291 | 4 years
Stock options exercisable at December 31, 2019 | 290,540 | $44.90 | $10,163 | 3 years


Question: What is the total value of stock options outstanding on December 31, 2018?
Answer: 49574756
Calculation: 1,093,400*$45.34
Our net sales by market sector for the indicated fiscal years were as follows (in millions):
Healthcare/Life Sciences. Net sales for fiscal 2019 in the Healthcare/Life Sciences sector increased $180.1 million, or 17.3%, as compared to fiscal 2018. The increase was driven by overall net increased customer end-market demand, a $32.7 million increase in production ramps of new products for existing customers and a $26.9 million increase in production ramps for new customers.
Industrial/Commercial. Net sales for fiscal 2019 in the Industrial/Commercial sector increased $63.5 million, or 6.9%, as compared to fiscal 2018. The increase was driven by a $64.8 million increase in production ramps of new products for existing customers and a $33.2 million increase in production ramps for new customers. The increase was partially offset by a $7.3 million decrease due to end-of-life products, a $4.2 million decrease due to a disengagement with a customer and overall net decreased customer end-market demand.
Aerospace/Defense. Net sales for fiscal 2019 in the Aerospace/Defense sector increased $143.5 million, or 32.2%, as compared to fiscal 2018. The increase was driven by a $120.2 million increase in production ramps of new products for existing customers, a $9.9 million increase in production ramps for new customers and overall net increased customer end-market demand.
Communications. Net sales for fiscal 2019 in the Communications sector decreased $96.2 million, or 20.4%, as compared to fiscal 2018. The decrease was driven by a $37.3 million reduction due to disengagements with customers, a $15.3 million decrease due to end-of-life products and overall net decreased customer endmarket demand. The decrease was partially offset by an $18.1 million increase in production ramps of new products for existing customers and a $4.5 million increase in production ramps for new customers.
Table:
Market Sector  | 2019 | 2018
Healthcare/Life Sciences  | $1,220.0 | $1,039.9
Industrial/Commercial  | 981.2 | 917.7
Aerospace/Defense  | 588.6 | 445.1
Communications  | 374.6 | 470.8
Total net sales | 3,164.4 | 2,873.5


Question: Which years does the table provide information for the company's net sales by market sector?
Answer: 2019, 2018
RSUs
The Company’s RSUs include time-based RSUs, RSUs with performance conditions (“PSUs”), RSUs with market conditions (“MSUs”), and RSUs with both market and performance conditions (“MPSUs”). Vesting of awards with performance conditions or market conditions is subject to the achievement of pre-determined performance goals and the approval of such achievement by the Compensation Committee of the Board of Directors (the “Compensation Committee”). All awards include service conditions which require continued employment with the Company.
A summary of RSU activity is presented in the table below (in thousands, except per-share amounts):
(1) Amount reflects the number of awards that may ultimately be earned based on management’s probability assessment of the achievement of performance conditions at each reporting period.
The intrinsic value related to vested RSUs was $138.3 million, $90.0 million and $74.0 million for the years ended December 31, 2019, 2018 and 2017, respectively. As of December 31, 2019, the total intrinsic value of all outstanding RSUs was $679.5 million, based on the closing stock price of $178.02. As of December 31, 2019, unamortized compensation expense related to all outstanding RSUs was $100.1 million with a weighted-average remaining recognition period of approximately three years.
Cash proceeds from vested PSUs with a purchase price totaled $16.6 million and $10.6 million for the years ended December 31, 2019 and 2018, respectively. There were no proceeds for the year ended December 31, 2017.
Table:
 | Time-Based RSUs |  | PSUs and MPSUs |  | MSUs |  | Total | 
 | Number of Shares | Weighted- Average Grant Date Fair Value Per Share | Number of Shares | Weighted- Average Grant Date Fair Value Per Share | Number of Shares | Weighted- Average Grant Date Fair Value Per Share | Number of Shares | Weighted- Average Grant Date Fair Value Per Share
Outstanding at January 1, 2017 | 366 | $51.35 | 2,284 | $43.24 | 1,620 | $23.57 | 4,270 | $36.47
Granted | 81 | $94.25 | 585(1) | $62.72 | - | $- | 666 | $66.56
Vested | (175) | $48.35 | (597) | $41.94 | - | $- | (772) | $43.39
Forfeited | (14) | $61.8 | (6) | $49.82 | - | $- | (20) | $58.46
Outstanding at December 31, 2017 | 258 | $66.3 | 2,266 | $48.59 | 1,620 | $23.57 | 4,144 | $39.91
Granted | 133 | $114.36 | 630(1) | $85.06 | 600 | $68.48 | 1,363 | $80.62
Vested | (136) | $60.23 | (717) | $41.08 | - | $- | (853) | $44.13
Forfeited | (15) | $82.2 | (5) | $63.16 | (1) | $68.48 | (21) | $76.92
Outstanding at December 31, 2018 | 240 | $95.38 | 2,174 | $61.61 | 2,219 | $35.69 | 4,633 | $50.94
Granted | 52 | $142.32 | 512(1) | $99.88 | - | $- | 564 | $103.68
Vested | (103) | $81.53 | (656) | $53.72 | (324) | $23.57 | (1,083) | $47.34
Forfeited | (9) | $117.31 | (43) | $42.72 | (9) | $68.48 | (61) | $57.01
Outstanding at December 31, 2019 | 180 | $115.45 | 1,987 | $74.50 | 1,886 | $37.63 | 4,053 | $59.16


Question: At which point of time time were there the most total shares outstanding?
Answer: December 31, 2018
Calculation: 4,633>4,270>4,053>4,144
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
Disaggregation of Revenue
The following table presents our sales by product line, which includes certain reclassifications to prior comparative periods to conform to our current year presentation:
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Semiconductor Equipment | $403,018 | $533,770 | $554,063
Industrial & Medical | 245,992 | 185,122 | 116,949
Data Center Computing | 91,438 | — | —
Telecom & Networking | 48,500 | — | —
Total | $788,948 | $718,892 | $671,012


Question: What was the change in sales of Semiconductor Equipment between 2017 and 2018?
Answer: -20293
Calculation: $533,770-$554,063
We operate in the following two reportable segments, which are the same as our operating segments:
• Enterprise Security. Our Enterprise Security segment focuses on providing our Integrated Cyber Defense solutions to help business and government customers unify cloud and on-premises security to deliver a more effective cyber defense solution, while driving down cost and complexity. • Consumer Cyber Safety. Our Consumer Cyber Safety segment focuses on providing cyber safety solutions under our Norton LifeLock brand to help consumers protect their devices, online privacy, identities, and home networks.
Operating segments are based upon the nature of our business and how our business is managed. Our Chief Operating Decision Makers, comprised of our Chief Executive Officer and Chief Financial Officer, use our operating segment financial information to evaluate segment performance and to allocate resources.
There were no inter-segment sales for the periods presented. The following table summarizes the operating results of our reportable segments:
Note 15. Segment and Geographic Information
Table:
 |  | Year Ended | 
(In millions) | March 29, 2019 | March 30, 2018 | March 31, 2017
Total segments: |  |  | 
Net revenues | $4,731 | $4,834 | $4,019
Operating income | $1,414 | $1,584 | $1,026
Enterprise Security: |  |  | 
Net revenues | $2,323 | $2,554 | $2,355
Operating income | $269 | $473 | $187
Consumer Cyber Safety: |  |  | 
Net revenues | $2,408 | $2,280 | $1,664
Operating income | $1,145 | $1,111 | $839


Question: What is the average total segments Operating income for the fiscal years 2019, 2018 and 2017?
Answer: 1341.33
Calculation: (1,414+1,584+1,026)/3
9. Pensions continued
Defined benefit plans continued
ii) Amounts in the financial statements continued
e) Movements in the fair value of plans’ assets
Table:
 | 2019 | 2018
 | $ million | $ million
At 1 January | 254.2 | 282.6
Interest income on plans’ assets | 7.0 | 7.0
Employer contributions | 6.6 | 6.8
Benefit payments | (11.4) | (12.1)
Plan administration expenses | (0.6) | (0.5)
Re-measurement gain/(loss) on plans’ assets | 25.8 | (14.2)
Exchange adjustment | 9.5 | (15.4)
Fair value of plans’ assets | 291.1 | 254.2


Question: In which year were the employer contributions larger?
Answer: 2018
Calculation: 6.8>6.6
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: When do sales in the energy market typically increase?
Answer: in the third and fourth fiscal quarters as customer activity increases