hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Revenue stream
The Company generates revenue primarily from the sales of equipment and sales of spares & service. The products and services described by nature in Note 1, can be part of all revenue streams.
The proceeds resulting from the patent litigation & arbitration settlements (€159 million) are included in the equipment revenue stream.
Table:
 | Year ended December 31, | 
(EUR thousand) | 2018 | 2019
Equipment revenue | 631,504 | 1,068,645
Spares & service revenue | 186,577 | 215,215
Total | 818,081 | 1,283,860


Question: Where can the products and services described by nature be found?
Answer: Note 1
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
The components of the prepaid (accrued) cost of the domestic and foreign pension plans are classified in the following lines in the Consolidated Balance Sheets at December 31:
Table:
 | U.S.Pension Plans |  | Non-U.S. Pension Plans | 
 | 2019 | 2018 | 2019 | 2018
Prepaid pension asset | $62,082 | $54,100 | $— | $—
Accrued expenses and other liabilities | (100) | (100) | — | —
Long-term pension obligations | (1,045) | (992) | (1,214) | (1,331)
Net prepaid (accrued) cost | $60,937 | $53,008 | $(1,214) | $(1,331)


Question: What was the change in the Net prepaid (accrued) cost for U.S. Pension Plans between 2018 and 2019?
Answer: 7929
Calculation: 60,937-53,008
Items Not Resulting in a Deferred Tax Asset
Of the unused tax losses, €187 million (2018: €213 million; 2017: €263 million) relate to U.S. state tax loss carryforwards.
We have not recognized a deferred tax liability on approximately €17.41 billion (2018: €14.04 billion) for undistributed profits of our subsidiaries, because we are in a position to control the timing of the reversal of the temporary difference and it is probable that such differences will not reverse in the foreseeable future.
Table:
€ millions | 2019 | 2018 | 2017
Unused tax losses |  |  | 
Not expiring | 688 | 575 | 375
Expiring in the following year | 63 | 7 | 9
Expiring after the following year | 373 | 476 | 535
Total unused tax losses | 1,124 | 1,058 | 919
Deductible temporary differences | 538 | 509 | 524
Unused research and development and foreign tax credits |  |  | 
Not expiring | 28 | 54 | 38
Expiring in the following year | 0 | 0 | 2
Expiring after the following year | 17 | 18 | 34
Total unused tax credits | 45 | 72 | 74


Question: In which year was the amount Expiring after the following year the largest?
Answer: 2017
Calculation: 34>18>17
Quantitative effect of ASC Topics 606 and 340-40 adoption
(1) While not shown here, gross margin, loss from operations, and loss before income taxes have consequently been affected as a result of the net effect of the adjustments noted above.
(2) The impact on the Consolidated Statements of Comprehensive Loss is limited to the net effects of the impacts noted above on the Consolidated Statements of Operations, specifically on the line item "Net loss."
Table:
 |  | For the Fiscal Year ended January 31, 2019 | 
 | As reported | Impact from the adoption of ASC 606 and 340-40 | As adjusted
Net revenue (1) |  |  | 
Subscription | $1,802.3 | $(16.6) | $1,785.7
Maintenance | 635.1 | 5.7 | 640.8
Other | 132.4 | (11.3) | 121.1
Cost of revenue (1) |  |  | 
Cost of subscription and maintenance revenue | 216.0 | (0.1) | 215.9
Cost of other revenue | 54.4 | 1.1 | 55.5
Operating expenses (1): |  |  | 
Marketing and sales | 1,183.9 | (17.9) | 1,166.0
Provision for income taxes | (38.1) | (4.8) | (42.9)
Net loss (2) | $(80.8) | $(10.1) | $(90.9)
Basic net loss per share | $(0.37) | $(0.05) | $(0.42)
Diluted net loss per share | $(0.37) | $(0.05) | $(0.42)


Question: What is other reported revenue as a % of total reported net revenue?
Answer: 5.15
Calculation: (132.4/(1,802.3+635.1+132.4))
4. Cash and Cash Equivalents
The following table summarizes the components of our cash and cash equivalents (amounts in millions):
Table:
 | At December 31, | 
 | 2019 | 2018
Cash | $437 | $268
Foreign government treasury bills | 37 | 32
Money market funds | 5,320 | 3,925
Cash and cash equivalents | $5,794 | $4,225


Question: What was the amount of cash and cash equivalents in 2018?
Answer: 4,225
Reconciliations between the amounts computed by applying the U.S. federal statutory tax rate to loss before income taxes, and income tax expense (benefit) follows (in thousands):
We determined no material liabilities related to uncertain income tax positions existed as of December 31, 2019 or 2018, based on our analysis of tax positions taken on income tax returns filed. Although we believe the amounts reflected in our tax returns substantially comply with applicable U.S. federal, state, and foreign tax regulations, the respective taxing authorities may take contrary positions based on their interpretation of the law. A tax position successfully challenged by a taxing authority could result in an adjustment to our provision or benefit for income taxes in the period in which a final determination is made.
Table:
Year Ended December 31 |  | 
 | 2019 | 2018
Income tax benefit at federal statutory rate | $(2,928) | $(1,692)
Increase (decrease) resulting from: |  | 
State tax benefit, net of federal tax effect | (437) | (184)
Effect of change in state tax rate | (26) | 146
Change in valuation allowance | 3,341 | (8,474)
Expirations of net operating losses and application of IRC 382 limitation | 7 | 9,939
Adjustments to deferreds | (29) | 321
Other | 72 | (11)
Income tax expense | $          - | $           45


Question: What is the change in income tax benefit between 2018 and 2019?
Answer: 1236
Calculation: 2,928 - 1,692
16. INCOME TAXES
The components of (loss) income before (benefit from) income taxes are:
Table:
(in thousands) | 2019 | 2018 | 2017
Domestic | $(51,396) | (27,494) | 57,493
Foreign | (83,450) | 15,951 | 28,742
(Loss) income before (benefit from) income taxes | $(134,846) | $(11,543) | $86,235


Question: What are the respective domestic and foreign income before income taxes in 2017?
Answer: 57,493, 28,742
the graph below shows a five-year comparison of the cumulative shareholder return on the company's common stock with the cumulative total return of the s&p smallcap 600 index and the s&p 600 electrical equipment index , all of which are published indices . comparison of five-year cumulative total return from december 31 , 2002 to december 31 , 2007 assumes $ 100 invested with reinvestment of dividends period indexed returns .

Table:
company/index | baseperiod 12/31/02 | baseperiod 12/31/03 | baseperiod 12/31/04 | baseperiod 12/31/05 | baseperiod 12/31/06 | 12/31/07
a o smith corp | 100.00 | 132.23 | 115.36 | 138.20 | 150.26 | 142.72
s&p smallcap 600 index | 100.00 | 138.79 | 170.22 | 183.30 | 211.01 | 210.39
s&p 600 electrical equipment | 100.00 | 126.12 | 152.18 | 169.07 | 228.83 | 253.33
12/31/02 12/31/03 12/31/04 12/31/05 12/31/06 12/31/07 smith ( a o ) corp s&p smallcap 600 index s&p 600 electrical equipment .

Question: what was the difference in cumulative total return for the five year period ending 12/31/07 between a o smith corp and the s&p smallcap 600 index?
Answer: -67.67%
Calculation: subtract(142.72, const_100), divide(#0, const_100), subtract(210.39, const_100), divide(#2, const_100), subtract(#1, #3)
5. Accrued expenses
Accrued expenses consisted of the following:
Table:
October 31, |  | 
 | 2019 | 2018
(In thousands) |  | 
Workers’ compensation claims | $9,687 | $9,020
Accrued wages | 19,525 | 14,142
Accrued rebates | 13,529 | 7,828
Accrued vacation  | 10,592 | 8,554
Accrued property taxes  | 11,331 | 9,453
Accrued payroll taxes | 8,290 | 9,034
Other accrued expenses  | 9,986 | 11,922
Total accrued expenses | $82,940 | $69,953


Question: What is the average Workers’ compensation claims for fiscal years 2019 and 2018?
Answer: 9353.5
Calculation: (9,687+ 9,020)/2
Interest and Other Income (Loss), Net
Interest Income (Expense), Net The following table summarizes interest income and interest expense (in millions):
Interest income decreased, driven by a decrease in the average balance of cash and available-for-sale debt investments. The decrease in interest expense was driven by a lower average debt balance, partially offset by the impact of higher effective interest rates.
Table:
 |  | Years Ended |  | 2019 vs. 2018
 | July 27, 2019 | July 28, 2018 | July 29, 2017 | Variance in Dollars
Interest income | $1,308 | $1,508 | $1,338 | $(200)
Interest expense | (859) | (943) | (861) | 84
Interest income (expense), net | $449 | $565 | $477 | $(116)


Question: What was the interest expense in 2017?
Answer: (861)
Group Value Added Statements
Note:
(1) FY 2018 included the gain on disposal of economic interest in NetLink Trust of S$2.03 billion.
Table:
 | FY 2019 | FY 2018
 | S$ million | S$ million
Value added from: |  | 
Operating revenue | 17,372 | 17,268
Less: Purchases of goods and services | (10,307) | (9,716)
 | 7,065 | 7,552
Other income | 225 | 259
Interest and investment income (net) | 38 | 45
Share of results of associates (post-tax) | 1,563 | 1,804
Exceptional items (1) | 68 | 1,895
 | 1,894 | 4,003
Total value added | 8,959 | 11,555
Distribution of total value added |  | 
To employees in wages, salaries and benefits | 2,597 | 2,760
To government in income and other taxes | 675 | 703
To providers of capital on: |  | 
- Interest on borrowings | 393 | 390
- Dividends to shareholders | 2,857 | 3,346
Total distribution | 6,522 | 7,199
Retained in business |  | 
Depreciation and amortisation | 2,222 | 2,250
Retained profits | 238 | 2,127
Non-controlling interests | (23) | (21)
 | 2,437 | 4,356
Total value added | 8,959 | 11,555
Average Number of employees | 24,071 | 25,614


Question: Which year had a higher total value added figure?
Answer: 2018
Calculation: 11,555 > 8,959
Capital expenditures
For 2019, capital expenditure was SEK 5.1 (4.0) billion, representing 2.3% of sales. Expenditures are largely related to test sites and equipment for R&D, network operation centers and manufacturing and repair operations.
The increase in 2019 was mainly due to investments in 5G test equipment.
Annual capital expenditures are normally around 2% of sales. This corresponds to the needs for keeping and maintaining the current capacity level. The Board of Directors reviews the Company’s investment plans and proposals.
As of December 31, 2019, no material land, buildings, machinery or equipment were pledged as collateral for outstanding indebtedness.
Table:
Capital expenditures 2017–2019 |  |  | 
SEK billion | 2019 | 2018 | 2017
Capital expenditures | 5.1 | 4.0 | 3.9
Of which in Sweden | 2.0 | 1.3 | 1.5
Share of annual sales | 2.3% | 1.9% | 1.9%


Question: What is the capital expenditure of 2017?
Answer: 3.9
If not presented separately in our income statement, restructuring expenses would have been classified in the different expense items in our income statement as follows:
Restructuring Expenses by Functional Area
Table:
€ millions | 2019 | 2018 | 2017
Cost of cloud and software | –138 | –3 | –55
Cost of services | –154 | –3 | –118
Research and development | –467 | –3 | –9
Sales and marketing | –299 | –11 | –2
General and administration | –71 | 0 | 2
Restructuring expenses | –1,130 | –19 | –182


Question: What was the Research and development in 2019?
Answer: –467
PSUs, RSUs and restricted stock
Under the 2015 Plan, awards other than stock options, including PSUs, RSUs and restricted stock, may be granted to certain employees and officers.
Under our market-based PSU program, the number of shares of common stock earned by a recipient is subject to a market condition based on ADTRAN’s relative total shareholder return against all companies in the NASDAQ Telecommunications Index at the end of a three-year performance period. Depending on the relative total shareholder return over the performance period, the recipient may earn from 0% to 150% of the shares underlying the PSUs, with the shares earned distributed upon the vesting. The fair value of the award is based on the market price of our common stock on the date of grant, adjusted for the expected outcome of the impact of market conditions using a Monte Carlo Simulation valuation method. A portion of the granted PSUs vests and the underlying shares become deliverable upon the death or disability of the recipient or upon a change of control of ADTRAN, as defined by the 2015 Plan. The recipients of the PSUs receive dividend credits based on the shares of common stock underlying the PSUs. The dividend credits vest and are earned in the same manner as the PSUs and are paid in cash upon the issuance of common stock for the PSUs.
During the first quarter of 2017, the Compensation Committee of the Board of Directors approved a one-time PSU grant of 0.5 million shares that contained performance conditions and would have vested at the end of a three-year period if such performance conditions were met. The fair value of these performance-based PSU awards was equal to the closing price of our stock on the date of grant. These awards were forfeited during the first quarter of 2020 as the performance conditions were not achieved.
The fair value of RSUs and restricted stock is equal to the closing price of our stock on the business day immediately preceding the grant date. RSUs and restricted stock vest ratably over four-year and one-year periods, respectively.
We will continue to assess the assumptions and methodologies used to calculate the estimated fair value of stock-based compensation. If circumstances change, and additional data becomes available over time, we may change our assumptions and methodologies, which may materially impact our fair value determination.
The following table is a summary of our PSUs, RSUs and restricted stock outstanding as of December 31, 2018 and 2019 and the changes that occurred during 2019:
Table:
(In thousands, except per share amounts) | Number of Shares | Weighted Average Grant Date Fair Value
Unvested PSUs, RSUs and restricted stock outstanding, December 31, 2018 | 1,570 | $18.52
PSUs, RSUs and restricted stock granted | 897 | $9.63
PSUs, RSUs and restricted stock vested | (368) | $17.23
PSUs, RSUs and restricted stock forfeited | (208) | $18.24
Unvested RSUs and restricted stock outstanding, December 31, 2019 | 1,891 | $14.58


Question: What was the number of shares of PSUs, RSUs and restricted stock granted 
Answer: 897
As described in Note 7, the acquisition of Norstel resulted in the recognition of technology in process for $86 million in the line “Technologies in progress”.
The line “Technologies in progress” in the table above also includes internally developed software under construction and software not ready for use.
The amortization expense in 2019, 2018 and 2017 was $69 million, $64 million and $58 million, respectively.
Table:
December 31, 2019 | Gross Cost | Accumulated Amortization | Net Cost
Technologies & licenses | 699 | (578) | 121
Purchased & internally developed software | 486 | (427) | 59
Technologies in progress | 119 | — | 119
Other intangible assets | 70 | (70) | —
Total | 1,374 | (1,075) | 299
December 31, 2018 | Gross Cost | Accumulated Amortization | Net Cost
Technologies & licenses | 705 | (592) | 113
Purchased & internally developed software | 459 | (404) | 55
Technologies in progress | 44 | — | 44
Other intangible assets | 69 | (69) | —
Total | 1,277 | (1,065) | 212


Question: What is the average Net Cost?
Answer: 255.5
Calculation: (299+212) / 2
Sources and Uses of Cash
Our primary source of liquidity from operations was the collection of revenue in advance from our customers, accounts receivable from our customers, and the management of the timing of payments to our vendors and service providers.
Investing activities in 2019 consist of $284.6 million, net of cash acquired, used in the acquisitions of AppRiver and DeliverySlip and $11.7 million for capital expenditures, which include $8.2 million in internal-use software costs, and $3.5 million for computer and networking equipment. These investments in new equipment and cloud hosting infrastructure are to renovate our business processes and product offerings.
Investing activities in 2018 consist of $11.8 million, net of cash acquired, used in the acquisition of Erado and $4.2 million for capital expenditures, which include $2.1 million for computer and networking equipment, $1.5 million in internal-use software costs, and $500 thousand for other activities including the acquisition of other internal use software. These investments in new equipment and cloud hosting infrastructure were to modernize our business processes and product offerings.
Financing activities in 2019 includes proceeds from long term debt of $179.2 million, net of issuance costs of $6.4 million and repayment of $1.4 million, as well as $96.6 million, net of issuance costs, raised through the private purchase of preferred stock, and $415 thousand received from the exercise of stock options. The proceeds from our debt and preferred stock issuances were used to fund our AppRiver acquisition in February 2019 and our DeliverySlip acquisition in May 2019. We also used $3.8 million for contingent consideration payments associated with our acquisitions of Greenview, Erado and DeliverySlip. In addition to these items, we paid $1.7 million to satisfy finance lease liabilities and $1.9 million to repurchase common stock related to the tax impact of vesting restricted awards in 2019.
Financing activities in 2018 relate primarily to $5.4 million used in a $10 million share repurchase program authorized by our Board of Directors on April 24, 2017, and $656 thousand used in the repurchase of common stock related to the tax impact of vesting restricted stock awards, and a $605 thousand earn-out payment associated with our acquisition of Greenview. Financing activities in 2017 include $3.8 million used in the same share repurchase program and $762 thousand used in the repurchase of common stock related to the tax impact of vesting restricted awards offset by the receipt of $4.2 million from the exercise of stock options.
Table:
Years Ended December 31, |  |  | 
(In thousands) | 2019 | 2018 | 2017
Net cash provided by operations | $ 13,951 | $ 16,671 | $ 18,204
Net cash used in investing activities | $ (296,243 ) | $ (15,952 ) | $ (11,285 )
Net cash provided by (used in) financing activities | $ 268,740 | $ (6,593 ) | $ (367 )


Question: What was the amount used for capital expenditures in investing activities in 2018 and 2019?
Answer: 4.2 million, 11.7 million
ITEM 6. SELECTED FINANCIAL DATA
The selected financial data presented below has been derived from our audited consolidated financial statements. This data should be read in conjunction with “Item 7. Management’s Discussion and Analysis of Financial Condition and Results of Operations” and “Item 8. Financial Statements and Supplementary Data” of this Annual Report.
(1) We elected to early adopt Accounting Standards Update (“ASU”) 2016-09 “Compensation - Stock Compensation (Topic 718): Improvements to Employee Share-Based Payment Accounting” (“ASU 2016-09”) in 2016, which requires us, among other things, to prospectively record excess tax benefits as a reduction of the provision for income taxes in the consolidated statement of operations, whereas they were previously recognized in equity.
(2) We retrospectively adopted ASU 2014-09, “Revenue from Contracts with Customers (Topic 606)” in 2018. As a result, we have adjusted balances for 2017 and 2016. We have not adjusted 2015 for ASU 2014-09.
Table:
(in thousands, except per share amounts) | 2019 | 2018 | 2017 | 2016 | 2015
Consolidated Statements of Operations Data (1) (2): |  |  |  |  | 
Revenue: |  |  |  |  | 
Perpetual license | $80,015 | 109,863 | 132,883 | 145,053 | 166,305
Term license | 199,433 | 178,256 | 206,411 | 152,231 | 109,283
Maintenance | 280,580 | 263,875 | 242,320 | 218,635 | 202,802
Cloud | 133,746 | 82,627 | 51,097 | 40,647 | 30,626
Consulting | 217,609 | 256,960 | 255,756 | 205,663 | 173,679
Total revenue | $911,383 | 891,581 | 888,467 | 762,229 | 682,695
(Loss) income from operations | $(134,878) | $(17,032) | $93,177 | $50,644 | $64,661
Net (loss) income | $(90,433) | $10,617 | $98,548 | $45,015 | $36,322
(Loss) earnings per share |  |  |  |  | 
Basic | $(1.14) | $0.14 | $1.27 | $0.59 | $0.47
Diluted | $(1.14) | $0.13 | $1.19 | $0.56 | $0.46
Cash dividends declared per common share | $0.12 | $0.12 | $0.12 | $0.12 | $0.12


Question: What are the respective revenue from perpetual license in 2018 and 2019?
Answer: 109,863, 80,015
Transactions involving stock options issued to employees are summarized as follows:
The expected life of awards granted represents the period of time that they are expected to be outstanding. The Company determines the expected life based on historical experience with similar awards, giving consideration to the contractual terms, vesting schedules, exercise patterns and pre-vesting and post-vesting forfeitures. The Company estimates the volatility of the Company’s common stock based on the calculated historical volatility of the Company’s common stock using the share price data for the trailing period equal to the expected term prior to the date of the award. The Company bases the risk-free interest rate used in the Black-Scholes option valuation model on the implied yield currently available on U.S. Treasury zero-coupon issues with an equivalent remaining term equal to the expected life of the award. The Company has not paid any cash dividends on the Company’s common stock and does not anticipate paying any cash dividends in the foreseeable future. Consequently, the Company uses an expected dividend yield of zero in the Black-Scholes option valuation model. The Company uses historical data to estimate pre-vesting option forfeitures and records share-based compensation for those awards that are expected to vest. In accordance with ASC 718-10, the Company calculates share-based compensation for changes to the estimate of expected equity award forfeitures based on actual forfeiture experience.
Table:
 | Number of Shares | Weighted Average Exercise Price Per Share
Outstanding at January 1, 2018 | 4,376,474 | $0.16
Granted | 67,394 | 0.17
Exercised | – | –
Cancelled or expired | (1,094,075) | 0.14
Outstanding at December 31, 2018 | 3,349,793 | $0.16
Granted | – | –
Exercised | – | –
Cancelled or expired | – | –
Outstanding at December 31, 2019 | 3,349,793 | $0.16


Question: How is the volatility of the Company's common stock estimated?
Answer: based on the calculated historical volatility of the Company’s common stock using the share price data for the trailing period equal to the expected term prior to the date of the award