hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
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 is the total revenue earned from maintenance in 2017 and 2018?
Answer: 506195
Calculation: 242,320 + 263,875
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
Information about receivables, contract assets and contract liabilities from contracts with tenants is as follows:
(1) Prior-period amounts adjusted with the adoption of the new lease accounting guidance, as applicable.
(2) Excludes $56.7 million and $55.0 million of capital contributions related to DAS networks as of December 31, 2019 and 2018, respectively.
(3) Excludes $300.2 million and $313.6 million of capital contributions related to DAS networks as of December 31, 2019 and 2018, respectively.
The Company records unearned revenue when payments are received from tenants in advance of the completion of the Company’s performance obligations. Long-term unearned revenue is included in Other non-current liabilities. During the year ended December 31, 2019, the Company recognized $62.2 million of revenue that was included in the Unearned revenue balance as of December 31, 2018. During the year ended December 31, 2018, the Company recognized $44.4 million of revenue that was included in the Unearned revenue balance as of January 1, 2018. The Company also recognized revenues of $59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during each of the years ended December 31, 2019 and 2018. $59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during each of the years ended December 31, 2019 and 2018.
$59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital
contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during
each of the years ended December 31, 2019 and 2018.
Table:
 | December 31, 2019 | December 31, 2018 (1)
Accounts receivable | $80.5 | $92.6
Prepaids and other current assets | 8.3 | 7.7
Notes receivable and other non-current assets | 21.3 | 22.2
Unearned revenue (2) | 35.0 | 35.0
Other non-current liabilities (3) | 79.0 | 54.1


Question: What was the change in Other non-current liabilities between 2018 and 2019?
Answer: 24.9
Calculation: 79.0-54.1
asset category target allocation total quoted prices in active markets for identical assets ( level 1 ) significant observable inputs ( level 2 ) significant unobservable inputs .

Table:
 | level 3
balance as of january 1 2018 | $ 278
actual return on assets | -23 ( 23 )
purchases issuances and settlements net | -25 ( 25 )
balance as of december 31 2018 | $ 230
balance as of january 1 , 2017 .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
$ 140 actual return on assets .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
2 purchases , issuances and settlements , net .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
136 balance as of december 31 , 2017 .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
$ 278 the company 2019s postretirement benefit plans have different levels of funded status and the assets are held under various trusts .
the investments and risk mitigation strategies for the plans are tailored specifically for each trust .
in setting new strategic asset mixes , consideration is given to the likelihood that the selected asset allocation will effectively fund the projected plan liabilities and meet the risk tolerance criteria of the company .
the company periodically updates the long-term , strategic asset allocations for these plans through asset liability studies and uses various analytics to determine the optimal asset allocation .
considerations include plan liability characteristics , liquidity needs , funding requirements , expected rates of return and the distribution of returns .
in 2012 , the company implemented a de-risking strategy for the american water pension plan after conducting an asset-liability study to reduce the volatility of the funded status of the plan .
as part of the de-risking strategy , the company revised the asset allocations to increase the matching characteristics of fixed- income assets relative to liabilities .
the fixed income portion of the portfolio was designed to match the bond- .

Question: was actual return on assets greater than purchases issuances and settlements?
Answer: yes
Calculation: multiply(23, const_m1), greater(#0, -25)
Long-lived assets by geographic region were as follows (amounts in millions):
The only long-lived assets that we classify by region are our long-term tangible fixed assets, which consist of property, plant, and equipment assets, and beginning with 2019, as a result of our adoption of a new lease accounting standard, our lease ROU assets; all other long-term assets are not allocated by location.
For information regarding significant customers, see “Concentration of Credit Risk” in Note 2.
Table:
 |  | At December 31, | 
 | 2019 | 2018 | 2017
Long-lived assets* by geographic region: |  |  | 
Americas | $322 | $203 | $197
EMEA | 142 | 62 | 75
Asia Pacific | 21 | 17 | 22
Total long-lived assets by geographic region | $485 | $282 | $294


Question: What was the percentage change in the long-lived assets in Americas between 2018 and 2019?
Answer: 58.62
Calculation: ($322-$203)/$203
Net Income (Loss) Per Share: Basic net income (loss) per share (EPS) is computed by dividing the net income (loss) attributable to Cubic for the period by the weighted average number of common shares outstanding during the period, including vested RSUs.
In periods with a net income from continuing operations attributable to Cubic, diluted EPS is computed by dividing the net income for the period by the weighted average number of common and common equivalent shares outstanding during the period. Common equivalent shares consist of dilutive RSUs. Dilutive RSUs are calculated based on the average share price for each fiscal period using the treasury stock method. For RSUs with performance-based vesting, no common equivalent shares are included in the computation of diluted EPS until the related performance criteria have been met. For RSUs with performance and market-based vesting, no common equivalent shares are included in the computation of diluted EPS until the performance criteria have been met, and once the criteria are met the dilutive restricted stock units are calculated using the treasury stock method, modified by the multiplier that is calculated at the end of the accounting period as if the vesting date was at the end of the accounting period. The multiplier on RSUs with performance and market-based vesting is further described in Note 16.
In periods with a net loss from continuing operations attributable to Cubic, common equivalent shares are not included in the computation of diluted EPS, because to do so would be anti-dilutive.
The weighted-average number of shares outstanding used to compute net income (loss) per common share were as follows (in thousands):
Table:
 |  | Years Ended September 30, | 
 | 2019 | 2018 | 2017
Weighted average shares - basic | 30,495 | 27,229 | 27,106
Effect of dilutive securities | 111 | 122 | —
Weighted average shares - diluted | 30,606 | 27,351 | 27,106
Number of anti-dilutive securities | — | — | 967


Question: Which year has the largest amount for the effect of dilutive securities?
Answer: 2018
Calculation: 122>111
NOTE 11 – INCOME TAXES
The components of loss before income taxes are as follows:
Table:
 | 2019 | 2018
Domestic | (1,698,689) | (2,468,805)
Foreign | (52,222) | (88,726)
Loss before income taxes | (1,750,911) | (2,557,531)


Question: What is the company's percentage change in foreign loss between 2018 and 2019?
Answer: -41.14
Calculation: (52,222 - 88,726)/88,726
Finite-lived Intangible Assets
Other intangible assets, net consisted of the following:
The remaining $152 of intangible asset at December 31, 2019 is expected to be amortized in 2020.
Table:
 |  | December 31,
 | 2019 | 2018
Recipes | $ 44 | $ 44
Customer lists and other customer related intangibles | 4,529 | 4,529
Customer relationships | 985 | 985
Trade names | 2,248 | 2,248
Formula | 438 | 438
 | 8,244 | 8,244
Accumulated amortization | (8,092 ) | (7,900 )
Intangible assets, net | $ 152 | $ 344


Question: What is the value of recipes in 2018 and 2019 respectively?
Answer: $ 44, $ 44
NOTE 14—INCOME TAXES
Our effective tax rate represents the net effect of the mix of income earned in various tax jurisdictions that are subject to a wide range of income tax rates.
The following is a geographical breakdown of income before the provision for income taxes:
Table:
 |  | Year Ended June 30, | 
 | 2019 | 2018 | 2017
Domestic income (loss) | $269,331 | $238,405 | $110,562
Foreign income | 171,243 | 147,721 | 138,989
Income before income taxes | $440,574 | $386,126 | $249,551


Question: What is the average annual Income before income taxes?
Answer: 358750.33
Calculation: (440,574+386,126+249,551)/3
RSUs/PSUs
RSUs/PSUs are granted to executives and other eligible employees. The value of an RSU/PSU at the grant date is equal to the value of one BCE common share. Dividends in the form of additional RSUs/PSUs are credited to the participant’s account on each dividend payment date and are equivalent in value to the dividend paid on BCE common shares. Executives and other eligible employees are granted a specific number of RSUs/PSUs for a given performance period based on their position and level of contribution. RSUs/PSUs vest fully after three years of continuous employment from the date of grant and, in certain cases, if performance objectives are met, as determined by the board of directors.
The following table summarizes outstanding RSUs/PSUs at December 31, 2019 and 2018.
(1) The weighted average fair value of the RSUs/PSUs granted was $58 in 2019 and $57 in 2018
(2) The RSUs/PSUs vested on December 31, 2019 were fully settled in February 2020 with BCE common shares and/or DSUs.
Table:
NUMBER OF RSUs/PSUs | 2019 | 2018
Outstanding, January 1 | 2,812,697 | 2,740,392
Granted (1) | 975,348 | 1,006,586
Dividends credited | 149,648 | 149,258
Settled | (932,133) | (1,027,321)
Forfeited | (90,442) | (56,218)
Outstanding, December 31 | 2,915,118 | 2,812,697
Vested, December 31 (2) | 904,266 | 880,903


Question: In which year is the amount of dividends credited larger?
Answer: 2019
Calculation: 149,648>149,258
We believe our success in attracting these end customers is a direct result of our commitment to high quality service and our intense focus on customer needs and performance. As an independent semiconductor foundry, most of our operating revenue is generated by our sales of wafers. The following table presented the percentages of our wafer sales by types of customers for the years ended December 31, 2017, 2018 and 2019.
We focus on providing a high level of customer service in order to attract customers and maintain their ongoing loyalty. Our culture emphasizes responsiveness to customer needs with a focus on flexibility, speed and accuracy throughout our manufacturing and delivery processes. Our customer oriented approach is especially evident in two types of services: customer design development services and manufacturing services.
For example, in 2013, we expand our regional business by opening our UMC Korea office, in order to provide local support to our customers in Korea, and shorten time-to-market for our Korea-based customers designing and manufacturing on UMC process technologies. We believe that our large production capacity and advanced process technology enable us to provide better customer service than many other foundries through shorter turn-around time, greater manufacturing flexibility and higher manufacturing yields.
Table:
 |  | Years Ended December 31, | 
Customer Type | 2017 | 2018 | 2019
 | % | % | %
Fabless design companies | 91.0 | 92.4 | 91.3
Integrated device manufacturers | 9.0 | 7.6 | 8.7
Total | 100.0 | 100.0 | 100.0


Question: What is the major portion of the operating revenue?
Answer: wafers
the following table provides the weighted average assumptions used in the black-scholes option-pricing model for grants and the resulting weighted average grant date fair value per share of stock options granted for the years ended december 31: .

Table:
 | 2018 | 2017 | 2016
intrinsic value | $ 9 | $ 10 | $ 18
exercise proceeds | 7 | 11 | 15
income tax benefit realized | 2 | 3 | 6
stock units during 2018 , 2017 and 2016 , the company granted rsus to certain employees under the 2007 plan and 2017 omnibus plan , as applicable .
rsus generally vest based on continued employment with the company over periods ranging from one to three years. .

Question: what was average income tax benefit realized for the three year period?
Answer: 3.67
Calculation: table_average(income tax benefit realized, none)
The following changes occurred in the amount of unrecognized tax benefits (in thousands):
For the year ended December 31, 2019, 2018 and 2017, the Company has recorded income tax expense of $128,000, $143,000 and $76,000, respectively, related to uncertain tax positions. The Company’s policy is to recognize potential interest and penalties related to unrecognized tax benefits associated with uncertain tax positions, if any, in the income tax provision. At December 31, 2019, 2018 and 2017, the Company had accrued $22,000, $15,000 and $11,000 in interest and penalties related to uncertain tax positions.
The Company is subject to taxation in the United States and various states along with other foreign countries. The Company has not been notified that it is under audit by the IRS or any state or foreign taxing authorities, however, due to the presence of NOL carryforwards, all of the income tax years remain open for examination in each of these jurisdictions. The Company does not believe that it is reasonably possible that the total amount of unrecognized tax benefits will significantly increase or decrease in the next 12 months.
Deferred income taxes have not been provided for undistributed earnings of the Company’s consolidated foreign subsidiaries because of the Company’s intent to reinvest such earnings indefinitely in active foreign operations. At December 31, 2019, the Company had $0.6 million in unremitted earnings that were permanently reinvested related to its consolidated foreign subsidiaries.
Table:
 |  | Year Ended December 31 | 
 | 2019 | 2018 | 2017
Beginning balance of unrecognized tax benefits | $469 | $326 | $250
Additions for current year tax positions | 106 | 142 | 65
Reductions for prior year tax positions | — | (14) | —
Ending balance (excluding interest and penalties) | 575 | 454 | 315
Interest and penalties | 22 | 15 | 11
Total | $597 | $469 | $326


Question: What was the income tax expense in 2019,2018 and 2017 respectively?
Answer: $128,000, $143,000, $76,000
5. Net Income (Loss) per Share
The Company calculates basic earnings per share by dividing the net income (loss) by the weighted average number of shares of common stock outstanding for the period. The diluted earnings per share is computed by giving effect to all potential dilutive common stock equivalents outstanding for the period using the treasury stock method. For purposes of this calculation, options to purchase common stock, stock awards, and the Convertible Senior Notes are considered to be common stock equivalents.
Since the Company has the intent and ability to settle the principal amount of the Convertible Senior Notes in cash and any excess in shares of the Company’s common stock, the Company uses the treasury stock method for calculating any potential dilutive effect of the conversion spread on diluted net income per share, if applicable.
The conversion spread will have a dilutive impact on net income (loss) per share of common stock when the average market price of the Company’s common stock for a given period exceeds the conversion price of $113.75 per share for the Convertible Senior Notes. During the fiscal years ended July 31, 2019 and 2018, the Company’s weighted average common stock price was below the conversion price of the Convertible Senior Notes.
The following table sets forth the computation of the Company’s basic and diluted net income per share for the years endedJ uly 31, 2019, 2018 and 2017 (in thousands, except share and per share amounts):
Table:
 | 2019 | 2018 | 2017
Numerator: |  |  | 
Net income (loss) | $20,732 | $(26,743) | $18,072
Net income (loss) per share: |  |  | 
Basic | $0.25 | $(0.34) | $0.24
Diluted | $0.25 | $(0.34) | $0.24
Denominator: |  |  | 
Weighted average shares used in computing net income (loss) per share: |  |  | 
Basic | 81,447,998 | 77,709,592 | 73,994,577
Weighted average effect of diluted stock options | 229,035 | — | 544,520
Weighted average effect of diluted stock awards | 1,004,181 | — | 789,246
Diluted | 82,681,214 | 77,709,592 | 75,328,343


Question: What was the Net income (loss) in 2019, 2018 and 2017 respectively?
Answer: $20,732, $(26,743), $18,072
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The Company’s effective tax rate differs from the U.S. federal statutory rate of 35% for the year ended December 31, 2017, primarily due to the benefit related to the wind down of our solar inverter business and earnings in foreign jurisdictions, which are subject to lower tax rates, offset by the impact of U.S. tax reform. The principal causes of the difference between the federal statutory rate and the effective income tax rate for each the years below are as follows:
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Income taxes per federal statutory rate | $14,111 | $36,199 | $69,348
State income taxes, net of federal deduction | 10 | 2,372 | 1,794
Transition tax - U.S. Tax Reform | — | 1,174 | 61,690
Corporate tax rate changes - U.S. Tax Reform | — | (652) | 11,177
Tax benefit associated with inverter business wind down | — | — | (33,837)
Stock based compensation | (97) | (974) | (5,263)
GILTI Tax | 8,796 | 13,064 | —
Tax effect of foreign operations | (13,086) | (19,162) | (47,482)
Uncertain tax position | (4,487) | (3,088) | 4,948
Unremitted earnings | 1,624 | 2,564 | —
Tax credits | (6,280) | (9,844) | (658)
Change in valuation allowance | 7,222 | (1,306) | 841
Withholding taxes | 6,500 | 1,371 | —
Other permanent items, net | (3,614) | 3,509 | (468)
Total provision for income taxes | $10,699 | $25,227 | $62,090


Question: What was the change in Unremitted earnings between 2018 and 2019?
Answer: -940
Calculation: 1,624-2,564
Note 12—Property, Plant and Equipment
Property, plant and equipment, net consisted of the following:
Depreciation expense was $61 million, $56 million and $55 million for fiscal 2019, 2018 and 2017, respectively.
Table:
 | January 3, 2020 | December 28, 2018
 | (in millions) | 
Computers and other equipment | $259 | $233
Leasehold improvements | 203 | 206
Office furniture and fixtures | 37 | 36
Buildings and improvements | 23 | 56
Land | 4 | 40
Construction in progress | 104 | 15
 | 630 | 586
Less: accumulated depreciation and amortization | (343) | (349)
 | $ 287 | $ 237


Question: What was the percentage change in the Office furniture and fixtures from 2018 to 2020?
Answer: 2.78
Calculation: (37-36)/36