hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Other income, net
The components of other income, net from continuing operations for the years ended December 31 are as follows:
In 2018, we recorded a $0.5 million adjustment to decrease the fair value of the Company's contingent consideration related to the Brink Acquisition. Also, during 2019 and 2018, the Company incurred a net loss on rental contracts of approximately $1.0 million and $0.9 million, respectively.
Table:
 | Year ended December 31 (in thousands) | 
 | 2019 | 2018
Foreign currency loss | $(83) | $(258)
Rental loss-net | (996) | (865)
Gain on sale of real estate | — | 649
Fair value adjustment contingent consideration | — | 450
Other | (424) | 330
Other income, net | $(1,503) | $306


Question: What was the adjustment recorded to decrease the fair value of the Company's contingent consideration related to the Brink Acquisition in 2018?
Answer: $0.5 million
Pro Forma Results
The following table summarizes, on a pro forma basis, the combined results of operations of the Company and TOKIN as though the acquisition and the Sale of EMD had occurred as of April 1, 2016. The pro forma amounts presented are not necessarily indicative of either the actual consolidated results had the acquisition occurred as of April 1, 2016, or of future consolidated operating results (amounts in thousands, except per share data):
(1) The net income for the fiscal year ended March 31, 2018 excludes the following: 34% of the gain on sale of the EMD business of $75.2 million, the gain related to the fair value of KEMET’s previous 34% interest in TOKIN of $68.7 million, and the bargain gain on the acquisition of TOKIN of $62.2 million.
(2) The net income for the fiscal year ended March 31, 2017 includes the following: 34% of the gain on sale of the EMD business of $123.4 million (which includes the release of a valuation allowance that was recorded in the fourth quarter of fiscal year 2017 and the use of the deferred tax asset which was recorded in the first quarter of fiscal year 2018), the gain related to the fair value of KEMET’s previous 34% interest in TOKIN of $66.7 million, and the bargain gain on the acquisition of TOKIN of $60.3 million.
(3) Fiscal years ended March 31, 2018 and 2017 adjusted due to the adoption of ASC 606.
Table:
 | Fiscal Years Ended March 31, | 
 | 2018 (1) | 2017 (2)
Pro forma revenues (3) | $1,217,655 | $1,060,777
Pro forma net income from continuing operations available to common stockholders (3) | 51,975 | 226,086
Pro forma earnings per common share - basic (3) | 0.98 | 4.86
Pro forma earnings per common share - diluted (3) | 0.89 | 4.08
Pro forma common shares - basic | 52,798 | 46,552
Pro forma common shares - diluted | 58,640 | 55,389


Question: Which years did the basic Pro forma earnings per common share exceed $1.00?
Answer: 2017
Calculation: (2017:4.86)
five-year performance comparison 2013 the following graph provides an indicator of cumulative total shareholder returns for the corporation as compared to the peer group index ( described above ) , the dj trans , and the s&p 500 . the graph assumes that $ 100 was invested in the common stock of union pacific corporation and each index on december 31 , 2009 and that all dividends were reinvested . the information below is historical in nature and is not necessarily indicative of future performance . purchases of equity securities 2013 during 2014 , we repurchased 33035204 shares of our common stock at an average price of $ 100.24 . the following table presents common stock repurchases during each month for the fourth quarter of 2014 : period total number of shares purchased [a] average price paid per share total number of shares purchased as part of a publicly announced plan or program [b] maximum number of shares that may yet be purchased under the plan or program [b] .

Table:
period | total number ofsharespurchased[a] | averageprice paidpershare | total number of sharespurchased as part of apublicly announcedplan or program [b] | maximum number ofshares that may yetbe purchased under the planor program [b]
oct . 1 through oct . 31 | 3087549 | $ 107.59 | 3075000 | 92618000
nov . 1 through nov . 30 | 1877330 | 119.84 | 1875000 | 90743000
dec . 1 through dec . 31 | 2787108 | 116.54 | 2786400 | 87956600
total | 7751987 | $ 113.77 | 7736400 | n/a
[a] total number of shares purchased during the quarter includes approximately 15587 shares delivered or attested to upc by employees to pay stock option exercise prices , satisfy excess tax withholding obligations for stock option exercises or vesting of retention units , and pay withholding obligations for vesting of retention shares .
[b] effective january 1 , 2014 , our board of directors authorized the repurchase of up to 120 million shares of our common stock by december 31 , 2017 .
these repurchases may be made on the open market or through other transactions .
our management has sole discretion with respect to determining the timing and amount of these transactions. .

Question: what percent of the share repurchases were in the fourth quarter?
Answer: 23.5%
Calculation: divide(7751987, 33035204)
Net Sales
Market Application
The following table sets forth, for the periods indicated, the amount of net sales and their relative
percentages of total net sales by market application (dollars in thousands):
During fiscal 2019, net sales decreased by $471.9 million, or 25%, compared to fiscal 2018, with decreases in the microelectronics and materials processing markets, partially offset by increases in the OEM components and instrumentation market. Ondax, which we acquired on October 5, 2018, contributed $6.4 million in incremental net sales to the materials processing market in the ILS segment in fiscal 2019. In fiscal 2019, we continued to experience weaker demand in the microelectronics and materials processing markets. Entering fiscal 2020, we have started seeing indications which could lead to increased future demand in the microelectronics flat panel display market, but this is balanced by possible continuing headwinds in the global materials processing industry.
Table:
 | Fiscal 2019 |  | Fiscal 2018 | 
 | Amount | Percentage of total net sales | Amount | Percentage of total net sales
Microelectronics | $632,176 | 44.2% | $1,036,354 | 54.5%
Materials processing | 404,878 | 28.3% | 520,904 | 27.4%
OEM components and instrumentation | 266,788 | 18.6% | 220,823 | 11.6%
Scientific and government programs | 126,798 | 8.9% | 124,492 | 6.5%
Total | $1,430,640 | 100.0% | $1,902,573 | 100.0%


Question: What is the change in net sales in 2019?
Answer: decreased by $471.9 million
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The following table presents our unaudited pro forma results for the acquisitions of Artesyn and LumaSense:
The unaudited pro forma results for all periods presented include adjustments made to account for certain costs and transactions that would have been incurred had the acquisitions been completed at the beginning of the year prior to the year of acquisition. These include adjustments to amortization charges for acquired intangible assets, interest and financing expenses, transaction costs, amortization of purchased gross profit and the alignment of various accounting policies. These adjustments are net of any applicable tax impact and were included to arrive at the pro forma results above.
Artesyn’s operating results have been included in the Advanced Energy’s operating results for the periods subsequent to the completion of the acquisition on September 10, 2019. During the year ended December 31, 2019, Artesyn contributed total sales of $220.3 million and net income of $7.1 million, including interest and other expense associated with the financing of the transaction.
Table:
 |  |  | Year Ended December 31, | 
 | 2019 |  | 2018 | 
 | As Reported | Pro Forma | As Reported | Pro Forma
Total sales | $788,948 | $1,202,790 | $718,892 | $1,350,037
Net income attributable to Advanced Energy Industries, Inc. | $64,941 | $83,104 | $147,025 | $158,422
Earnings per share: |  |  |  | 
Basic earnings per share | $1.70 | $2.17 | $3.76 | $4.05
Diluted earnings per share | $ 1.69 | $ 2.16 | $ 3.74 | $ 4.03


Question: What was the change in basic earnings per share as reported between 2018 and 2019?
Answer: -2.06
Calculation: $1.70-$3.76
(3) Accounts Receivable, Net
Accounts receivable, net, is as follows (in thousands):
Bad debt expense for the years ended December 31, 2019, 2018 and 2017 was $0.7 million, $0.1 million and $0.6 million, respectively.
Table:
 | As of December 31, | 
 | 2019 | 2018
Accounts receivable | $69,767 | $41,818
Allowance for doubtful accounts | (1,125) | (711)
Net accounts receivable | $68,642 | $41,107


Question: How much was the Bad debt expense for the years ended December 31, 2019?
Answer: $0.7 million
The Corporation is also exposed to credit risk in relation to its trade accounts receivable. To mitigate such risk, the Corporation continuously monitors the financial condition of its customers and reviews the credit history or worthiness of each new large customer. The Corporation establishes an allowance for lifetime expected credit losses related to doubtful accounts. The doubtful accounts allowance is calculated on a specific-identification basis for larger customer accounts receivable and on a statistically derived basis for the remainder.
Factors such as the current economic conditions, forward-looking macroeconomic data and historical information (number of overdue days of the customer’s balance outstanding as well as the customer’s collection history) are examined. The Corporation believes that its allowance for doubtful accounts is sufficient to cover the related credit risk.
The Corporation has credit policies in place and has established various credit controls, including credit checks, deposits on accounts and advance billing, and has also established procedures to suspend the availability of services when customers have fully utilized approved credit limits or have violated existing payment terms. Since the Corporation has a large and diversified clientele dispersed throughout its market areas in Canada and the United States, there is no significant concentration of credit risk.
The following table provides further details on trade and other receivables, net of allowance for doubtful accounts:
Table:
At August 31, | 2019 | 2018
(In thousands of Canadian dollars) | $ | $
Trade accounts receivable | 74,021 | 95,541
Allowance for doubtful accounts | (6,759) | (6,497)
 | 67,262 | 89,044
Other accounts receivable | 8,390 | 8,250
 | 75,652 | 97,294


Question: What is the average other accounts receivable from 2018 to 2019?
Answer: 8320
Calculation: (8,390 + 8,250) / 2
ii) Amounts in the financial statements
The assets and liabilities on the balance sheet are as follows:
3. Pensions continued
Table:
 | 2019 | 2018
 | £ million | £ million
Schemes in net asset position |  | 
UK defined benefit pension plan – Staff Plan | 7.8 | 1.1
UK defined benefit pension plan – Cash Plan | 1.0 | 0.9
 | 8.8 | 2.0
Schemes in net liability position |  | 
UK unfunded plan | (0.5) | (0.5)
Net pension plan surplus on the balance sheet | 8.3 | 1.5


Question: What are the schemes comprising the assets and liabilities on the balance sheet in the table?
Answer: Schemes in net asset position, Schemes in net liability position
Contract balances
The following table provides information about receivables, contract assets and contract liabilities from contracts with customers.
Accrued income relates to the Group’s rights to consideration for services provided but not invoiced at the reporting date. Accrued income is transferred to receivables when invoiced.
Deferred income relates to advanced consideration received for which revenue is recognised as or when services are provided. Included within deferred income is £11.2m (2018: £nil) relating to consideration received from Auto Trader Auto Stock Limited (which forms part of the Group’s joint venture) for the provision of data services (note 16). Revenue relating to this service is recognised on a straight-line basis over a period of 20 years.
Table:
 | 2019 | 2018
 | £m | £m
Receivables, which are included in trade and other receivables | 27.0 | 28.8
Accrued income | 28.0 | 26.7
Deferred income | (13.2) | (1.8)


Question: In which year was accrued income larger?
Answer: 2019
Calculation: 28.0>26.7
Effective Tax Rate
The items accounting for the difference between income taxes computed at the U.S. federal statutory rate and our effective rate were as follows:
The decrease from the federal statutory rate in fiscal year 2019 is primarily due to a $2.6 billion net income tax benefit related to intangible property transfers, and earnings taxed at lower rates in foreign jurisdictions resulting from producing and distributing our products and services through our foreign regional operations centers in Ireland, Singapore, and Puerto Rico. The increase from the federal statutory rate in fiscal year 2018 is primarily due to the net charge related to the enactment of the TCJA in the second quarter of fiscal year 2018, offset in part by earnings taxed at lower rates in foreign jurisdictions. The decrease from the federal statutory rate in fiscal year 2017 is primarily due to earnings taxed at lower rates in foreign jurisdictions. Our foreign regional operating centers in Ireland, Singapore and Puerto Rico, which are taxed at rates lower than the U.S. rate, generated 82%, 87%, and 76% of our foreign income before tax in fiscal years 2019, 2018, and 2017, respectively. Other reconciling items, net consists primarily of tax credits, GILTI, and U.S. state income taxes. In fiscal years 2019, 2018, and 2017, there were no individually significant other reconciling items.
The decrease in our effective tax rate for fiscal year 2019 compared to fiscal year 2018 was primarily due to the net charge related to the enactment of the TCJA in the second quarter of fiscal year 2018, and a $2.6 billion net income tax benefit in the fourth quarter of fiscal year 2019 related to intangible property transfers. The increase in our effective tax rate for fiscal year 2018 compared to fiscal year 2017 was primarily due to the net charge related to the enactment of the TCJA and the realization of tax benefits attributable to previous Phone business losses in fiscal year 2017.
Table:
Year Ended June 30, | 2019 | 2018 | 2017
Federal statutory rate | 21.0% | 28.1% | 35.0%
Effect of: |  |  | 
Foreign earnings taxed at lower rates | (4.1)% | (7.8)% | (11.6)%
Impact of the enactment of the TCJA | 0.4% | 37.7% | 0%
Phone business losses | 0% | 0% | (5.7)%
Impact of intangible property transfers | (5.9)% | 0% | 0%
Foreign-derived intangible income deduction | (1.4)% | 0% | 0%
Research and development credit | (1.1)% | (1.3)% | (0.9)%
Excess tax benefits relating to stock-based compensation | (2.2)% | (2.5)% | (2.1)%
Interest, net | 1.0% | 1.2% | 1.4%
Other reconciling items, net | 2.5% | (0.8)% | (1.3)%
Effective rate | 10.2% | 54.6% | 14.8%


Question: Why did the federal statutory rate in fiscal year 2017? 
Answer: The decrease from the federal statutory rate in fiscal year 2017 is primarily due to earnings taxed at lower rates in foreign jurisdictions.
Research and Development
Research and development expenses in 2019 decreased by $4.6 million, or 21%, as compared to 2018. The decrease was primarily due to a reduction in the number of full-time research and development personnel, resulting in a decrease of $3.1 million in compensation expense and $0.6 million in allocated facilities and information technology costs as compared to 2018. We did not incur restructuring costs in 2019, as compared to 2018 when $0.1 million was incurred as part of the 2018 Restructuring Plan (refer to Note 4 of the accompanying consolidated financial statements). Finally, the decrease was further driven by lower professional fees of $0.6 million, as we reduced the number of research and development contractors as compared to 2018.
Table:
 | Years Ended December 31, |  | Change | 
 | 2019 | 2018 | $ | %
 |  | (dollars in thousands) |  | 
Research and development | $17,845 | $22,450 | $(4,605) | (21)%
Percent of revenues, net | 36% | 38% |  | 


Question: What is the total research and development expenses in 2018 and 2019?
Answer: 40295
Calculation: 22,450 + 17,845
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: For which years are the weighted average inputs into the Black-Scholes model considered? 
Answer: 2019, 2018
ITEM 15. EXHIBITS AND FINANCIAL STATEMENT SCHEDULES
(a) 1. Financial Statements
Reference is made to Item 8 for a list of all financial statements and schedules filed as a part of this Report.
2. Financial Statement Schedules
QuickLogic Corporation
Valuation and Qualifying Accounts
(in thousands)
All other schedules not listed above have been omitted because the information required to be set forth therein is not applicable or is shown in the financial statements or notes hereto.
Table:
 | Balance at Beginning of Period | Charged to Costs and Expenses | Write-offs | Balance at End of Period
Allowance for Doubtful Accounts: |  |  |  | 
Fiscal Year 2019 | $— | $— | $5 | $—
Fiscal Year 2018 | $— | $— | $— | $—
Fiscal Year 2017 | $— | $— | $— | $—
Allowance for Deferred Tax Assets: |  |  |  | 
Fiscal Year 2019 | $54,913 | $3,227 | $— | $58,140
Fiscal Year 2018 | $55,931 | $— | $(1,018) | $54,913
Fiscal Year 2017 | $79,150 | $— | $(23,219) | $55,931


Question: What is the total balance at the beginning of the period in fiscal year 2018 and 2019?
Answer: 110844
Calculation: $55,931 + $54,913
LONG-TERM DEBT
In addition to the Facility, the Company also had the following long-term obligations at fiscal 2019 and fiscal 2018.
Table:
 | 2019 | 2018
Note payable to a bank (“Real Estate Loan”), interest payable at a fixed rate of 2.99% with monthly installments of principal and interest of $38,344 through August 2021 with remaining principal due September 2021, collateralized by three distribution facilities | $ 2,263,040 | $  2,648,179
Note payable, interest payable at a fixed rate of 4.50% with quarterly installments of principal and interest of $49,114 through June 2023 with remaining principal due September 2023 | 1,395,351 | 1,476,772
Note payable, interest-free with varying installments during fiscal 2019 | — | 629,746
 | 3,658,391 | 4,754,697
Less current maturities | (532,747) | (1,096,306)
 | $3,125,644 | $3,658,391


Question: What is the percentage change in the company's net long-term debt between 2018 and 2019?
Answer: -14.56
Calculation: (3,125,644 - 3,658,391)/3,658,391
Remaining Performance Obligation Associated with Non-Lease Arrangements
A majority of the Company’s revenue is provided over a contract term. When allocating the total contract transaction price to identified performance obligations, a portion of the total transaction price relates to performance obligations that are yet to be satisfied or are partially satisfied as of the end of the reporting period.
In determining the transaction price allocated to remaining performance obligations, the Company does not include non- recurring charges and estimates for usage.
Remaining performance obligations associated with the Company’s contracts reflect recurring charges billed, adjusted to reflect estimates for sales incentives and revenue adjustments.
The table below reflects an estimate of the remaining transaction price of fixed fee, non-lease revenue arrangements to be recognized in the future periods presented. The table below does not include estimated amounts to be recognized in future periods associated with variable usage-based consideration.
Table:
 | Year Ended June 30, |  |  |  |  |  | 
 | 2020 | 2021 | 2022 | 2023 | 2024 | Thereafter | Total
 | (in millions) |  |  |  |  |  | 
Reportable Segment |  |  |  |  |  |  | 
Zayo Networks | 621.4 | 295.9 | 117.4 | 36.7 | 14.1 | 17.5 | 1,103.0
zColo | 21.7 | 11.0 | 6.2 | 3.5 | 2.5 | 2.0 | 46.9
Allstream | 110.3 | 26.7 | 11.8 | 1.6 | 0.3 | — | 150.7
Total | $753.4 | $333.6 | $135.4 | $41.8 | $16.9 | $19.5 | $1,300.6


Question: Which reportable segment had the highest amount in 2024? 
Answer: Zayo Networks
Calculation: 36.7 > 3.5 > 1.6
Exposures The maximum credit risk exposure of the group’s financial assets at the balance sheet date is as follows:
The carrying amount excludes £445m (2017/18: £317m, 2016/17: £360m) of non-current trade and other receivables which relate to non-financial assets, and £1,456m (2017/18: £1,496m, 2016/17: £1,106m) of prepayments, deferred contract costs and other receivables.
Table:
 | Notes | 2019 | 2018 | 2017
At 31 March Notes |  | £m | £m | £m
Derivative financial assets |  | 1,592 | 1,509 | 2,246
Investments | 23 | 3,268 | 3,075 | 1,564
Trade and other receivables a | 17 | 1,766 | 2,518 | 2,729
Contract assets | 6 | 1,602 | – | –
Cash and cash equivalents | 24 | 1,666 | 528 | 528
 |  | 9,894 | 7,630 | 7,067


Question: What amount of non-current trade and other receivables was excluded from the carrying amount in 2019?
Answer: £445m
Changes in Estimates on Contracts
Changes in estimates related to contracts accounted for using the cost-to-cost method of accounting are recognized in the period in which such changes are made for the inception-to-date effect of the changes, with the exception of contracts acquired through a business combination, where the adjustment is made for the period commencing from the date of acquisition.
Changes in estimates on contracts for the periods presented were as follows:
The impact on diluted EPS attributable to Leidos common stockholders is calculated using the Company's statutory tax rate.
Table:
 |  | Year Ended | 
 | January 3, 2020 | December 28, 2018 | December 29, 2017
 |  | (in millions, except for per share amounts) | 
Favorable impact | $95 | $167 | $185
Unfavorable impact | (52) | (62) | (82)
Net favorable impact to income before income taxes | $43 | $105 | $103
Impact on diluted EPS attributable to Leidos common stockholders | $0.23 | $0.52 | $0.41


Question: What is the average Unfavorable impact in 2018 and 2017?
Answer: -72
Calculation: -(62 + 82) / 2