hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Dividends
The following is a summary of our fiscal 2019, 2018 and 2017 activities related to dividends on our common stock (in millions, except per share amounts).
On May 22, 2019, we declared a cash dividend of $0.48 per share of common stock, payable on July 24, 2019 to shareholders of record as of the close of business on July 5, 2019. The timing and amount of future dividends will depend on market conditions, corporate business and financial considerations and regulatory requirements. All dividends declared have been determined by the Company to be legally authorized under the laws of the state in which we are incorporated.
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
Dividends per share declared | $ 1.60 | $ 0.80 | $ 0.76
Dividend payments allocated to additional paid-in capital | $ 403 | $ 106 | $ 88
Dividend payments allocated to retained earnings (accumulated deficit) | $ — | $ 108 | $ 120


Question: What was the change in the Dividend payments allocated to retained earnings (accumulated deficit) between 2017 and 2018?
Answer: -12
Calculation: 108-120
16. INCOME TAXES
The provision for (benefit from) income taxes on income from continuing operations before income taxes consists of the following (in thousands):
Table:
 | 2019 | 2018 | 2017
Currently payable: |  |  | 
Federal | $1,995 | $1,163 | $5,617
State | 557 | 114 | 1,022
Foreign | 13,448 | 107,487 | 116,022
 | 16,000 | 108,764 | 122,661
Deferred and other: |  |  | 
Federal | (407) | 26,334 | 1,413
State | 516 | (489) | (153)
Foreign | (9,886) | (20,414) | (30,510)
 | (9,777) | 5,431 | (29,250)
Provision for income taxes | $6,223 | $114,195 | $93,411


Question: What was the currently payable federal income tax in 2019?
Answer: $1,995
Liquidity
The following table presents selected financial information on liquidity (in thousands):
(1) We define working capital as current assets less current liabilities. Fiscal year 2019 includes the impact of recognizing operating lease right-of-use assets and liabilities as a result of our adoption of Accounting Standards Codification Topic 842, “Leases,” as of December 29, 2018.
We believe our existing balances of cash and cash equivalents, working capital and the availability under our asset-based loan facility, are sufficient to satisfy our working capital needs, capital expenditures, debt service and other liquidity requirements associated with our current operations over the next 12 months.
Our capital expenditures, excluding cash paid for acquisitions, were approximately $16.1 million for fiscal 2019. We believe our capital expenditures, excluding cash paid for acquisitions, for fiscal 2020 will be approximately $38.0 million to $42.0 million. The increase in projected capital expenditures in fiscal 2020 as compared to fiscal 2019 is the result of planned expansions of several of our distribution facilities. Our planned capital projects will provide both new and expanded facilities and improvements to our technology that we believe will produce increased efficiency and the capacity to continue to support the growth of our customer base.
Table:
 |  | Fiscal Year Ended | 
 | December 27, 2019  | December 28, 2018  | December 29, 2017
Cash and cash equivalents | $140,233 | $42,410 | $41,504
Working capital,(1) excluding cash and cash equivalents | $162,772 | $160,783 | $147,063
Availability under asset-based loan facility | $133,359 | $90,015 | $64,805


Question: What is the Working capital, excluding cash and cash equivalents for fiscal years 2019, 2018 and 2017 respectively?
Answer: $162,772, $160,783, $147,063
OUTSTANDING COMMON SHARES
1 Holders of our Class B Non-Voting Shares are entitled to receive notice of and to attend shareholder meetings; however, they are not entitled to vote at these meetings except as required by law or stipulated by stock exchanges. If an offer is made to purchase outstanding Class A Shares, there is no requirement under applicable law or our constating documents that an offer be made for the outstanding Class B Non-Voting Shares, and there is no other protection available to shareholders under our constating documents. If an offer is made to purchase both classes of shares, the offer for the Class A Shares may be made on different terms than the offer to the holders of Class B Non-Voting Shares.
As at February 29, 2020, 111,154,811 Class A Shares, 393,770,507
Class B Non-Voting Shares, and 3,145,274 options to purchase
Class B Non-Voting Shares were outstanding.
Table:
 | As at December 31 | 
 | 2019 | 2018
Common shares outstanding 1 |  | 
Class A Voting | 111,154,811 | 111,155,637
Class B Non-Voting | 393,770,507 | 403,657,038
Total common shares | 504,925,318 | 514,812,675
Options to purchase Class B |  | 
Non-Voting Shares |  | 
Outstanding options | 3,154,795 | 2,719,612
Outstanding options exercisable | 993,645 | 1,059,590


Question: What were the number of Class B shares outstanding as at February 29, 2020?
Answer: 393,770,507
Disaggregation of revenue
To provide visibility into our transition from older products to our newer, higher growth products and clarity into the dynamics of our product revenue, we have historically grouped our products by “Strategic” and “Mature” solutions. Strategic solutions include Clustered ONTAP, branded E-Series, SolidFire, converged and hyper-converged infrastructure, ELAs and other optional add-on software products. Mature solutions include 7-mode ONTAP, add-on hardware and related operating system (OS) software and original equipment manufacturers (OEM) products. Both our Mature and Strategic product lines include a mix of disk, hybrid and all flash storage media. Additionally, we provide a variety of services including software maintenance, hardware maintenance and other services including professional services, global support solutions, and customer education and training.
The following table depicts the disaggregation of revenue by our products and services (in millions):
Revenues by geographic region are presented in Note 16 – Segment, Geographic, and Significant Customer Information
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
Product revenues | $ 3,755 | $  3,525 | $  3,060
Strategic | 2,709 | 2,468 | 2,000
Mature | 1,046 | 1,057 | 1,060
Software maintenance revenues | 946 | 902 | 905
Hardware maintenance and other services revenues | 1,445 | 1,492 | 1,526
Hardware maintenance support contracts | 1,182 | 1,214 | 1,258
Professional and other services | 263 | 278 | 268
Net revenues | $ 6,146 | $  5,919 | $  5,491


Question: What was the change in the company's product revenue between 2017 and 2018?
Answer: 465
Calculation: 3,525-3,060
AMERICAN TOWER CORPORATION AND SUBSIDIARIES SCHEDULE III—SCHEDULE OF REAL ESTATE AND ACCUMULATED DEPRECIATION (dollars in millions)
(7) Primarily includes foreign currency exchange rate fluctuations and other deductions.
Table:
 | 2019 | 2018 | 2017
Gross amount of accumulated depreciation at beginning | $(5,724.7) | $(5,181.2) | $(4,548.1)
Additions during period: |  |  | 
Depreciation | (768.4) | (751.4) | (718.7)
Other | — | — | —
Total additions | (768.4) | (751.4) | (718.7)
Deductions during period: |  |  | 
Amount of accumulated depreciation for assets sold or disposed | 121.4 | 129.3 | 100.7
Other (7) | (10.5) | 78.6 | (15.1)
Total deductions | 110.9 | 207.9 | 85.6
Balance at end | $(6,382.2) | $(5,724.7) | $(5,181.2)


Question: What was the percentage change in total deductions between 2018 and 2019?
Answer: -46.66
Calculation: (110.9-207.9)/207.9
NOTE 4 - ACCOUNTS PAYABLE AND ACCRUED EXPENSES
Accounts payable and accrued expenses consist of the following at:
On October 1 2019, the Company entered into an agreement with a consultant for toxicology studies. The consultant quoted a commitment of approximately $988,000 as an
estimate for the study. 50% of the total price is to be paid upon the signing of the agreement, 35% of the total price is to be upon completion of the in-life study, and the
remaining 15% of the total price is to be paid upon the issuance of the report. If the Company cancels the study the Company will be required to pay a cancelation fee. If the
cancelation happens prior to the arrival of the test animals then the Company will need to pay between 20% and 50% of the animal fees depending on when the cancellation
happens. If the cancellation occurs after the animals arrive but before the study begins then the company will be responsible for paying 50% of the protocol price plus a fee of
$7,000 per room/week for animal husbandry until the animals can be relocated or disposed of. If the Company cancels the study after it has begun then the Company will need to pay any fees for procured items for the study and any nonrecoverable expenses incurred by the vendor. As of December 31, 2019, the Company has paid $0 and there is a balance of $493,905 due.
Table:
 | December 31, 2019 | December 31, 2018
Accounting | $36,161 | $52,365
Research and development | 650,584 | 137,114
Legal | 15,273 | 32,161
Other | 163,029 | 10,048
Total | $865,047 | $231,688


Question: How much did the company pay upon the signing of the toxicology studies agreement?
Answer: 494000
Calculation: 988,000 * 50%
TREASURY SHARES
On December 31, 2019, we had 48,866,220 outstanding common shares excluding 2,431,174 treasury shares. This compared to 49,318,898 outstanding common shares and 6,978,496 treasury shares at year-end 2018. Besides the cancellation of 5 million treasury shares in July 2019, the change in the number of treasury shares in 2019 was the result of approximately 950,000 repurchased shares and approximately 498,000 treasury shares that were used as part of share based payments.
Table:
 | 2018 | 2019
As per January 1: |  | 
Issued shares | 62,297,394 | 56,297,394
Treasury shares | 6,157,241 | 6,978,496
Outstanding shares | 56,140,153 | 49,318,898
Changes during the year: |  | 
Cancellation of treasury shares | 6,000,000 | 5,000,000
Share buybacks | 7,242,734 | 950,902
Treasury shares used for share based performance programs | 421,479 | 498,224
As per December 31: |  | 
Issued shares | 56,297,394 | 51,297,394
Treasury shares | 6,978,496 | 2,431,174
Outstanding shares | 49,318,898 | 48,866,220


Question: What is the percentage change in  Share buybacks from during the year 2018 to during the year 2019?
Answer: -86.87
Calculation:  (950,902-7,242,734)/ 7,242,734
The pension expenses of the direct and indirect company pension plan commitments can be broken down as follows:
1 Netted against employees’ contributions.
2 Included therein: Interest effect from the adjustment of the asset ceiling.
The entire loss to be recognised outside of profit or loss in the other comprehensive income amounts to €90 million in financial year 2018/19. This figure is comprised of the effect from the change in actuarial parameters in the amount of €+247 million and the experience-based adjustments of €+4 million. It was offset by income from plan assets of €103 million and a gain of €58 million resulting from the change in the effect of the asset ceiling in the Netherlands.
In addition to expenses from defined benefit commitments, expenses for payments to external pension providers relating to defined contribution pension commitments of €82 million in financial year 2018/19 (2017/18: €82 million) were recorded. These figures also include payments to statutory pension insurance.
The provisions for obligations similar to pensions essentially comprise commitments from employment anniversary allowances, death benefits and partial retirement plans. Provisions amounting to €34 million (30/9/2018: €41 million) were allocated for these commitments. The commitments are valued on the basis of actuarial expert opinions. The valuation parameters used for this purpose are generally determined in the same way as for the company pension plan.
Table:
€ million | 2017/2018 | 2018/2019
Current service cost1 | 24 | 21
Net interest expenses2 | 11 | 9
Past service cost (incl. curtailments and changes) | 0 | 0
Settlements | 0 | 0
Other pension expenses | 1 | 1
Pension expenses | 36 | 31


Question: For which years were the pension expenses of the direct and indirect company pension plan commitments recorded in?
Answer: 2018, 2019
SELECTED FINANCIAL DATA
The following data should be read in conjunction with the consolidated financial statements and accompanying notes included elsewhere in the Annual Report on Form 10-K. Fiscal 2018 and 2017 have been recast to reflect the Company’s retrospective adoption of Accounting Standards Update (“ASU”) 2014-09, Revenue from Contracts with Customers, and related amendments, collectively referred to as Accounting Standards Codification (“ASC”) 606. Fiscal 2016 and 2015 were not recast. Net income for fiscal 2018 and 2019 has been impacted by the reduced U.S. corporate tax rate enacted by the Tax Cuts and Jobs Act (“TCJA”) of 2017, and fiscal 2018 net income contains the related adjustment for the re-measurement of deferred taxes. Acquisitions have affected revenue and net income in fiscal 2019 as well as the historical periods presented.
(1) Revenue includes license sales, support and service revenues, and hardware sales, less returns and allowances.
Table:
 |  |  | (In Thousands, Except Per Share Data) |  | 
 |  |  | YEAR ENDED JUNE 30, |  | 
Income Statement Data | 2019 | 2018 | 2017 | 2016 | 2015
 |  |  |  | *Unadjusted | *Unadjusted
Revenue (1) | $1,552,691 | $1,470,797 | $1,388,290 | $1,354,646 | $1,256,190
Net Income | $271,885 | $365,034 | $229,561 | $248,867 | $211,221
Basic earnings per share | $3.52 | $4.73 | $2.95 | $3.13 | $2.60
Diluted earnings per share | $3.52 | $4.70 | $2.93 | $3.12 | $2.59
Dividends declared per share | $1.54 | $1.36 | $1.18 | $1.06 | $0.94
Balance Sheet Data |  |  |  |  | 
Total deferred revenue | $394,306 | $369,915 | $368,151 | $521,054 | $531,987
Total assets | $2,184,829 | $2,033,058 | $1,868,199 | $1,815,512 | $1,836,835
Long-term debt | $— | $— | $50,000 | $— | $50,102
Stockholders’ equity | $1,429,013 | $1,322,844 | $1,099,693 | $996,210 | $991,534


Question: What is the average revenue for 2017 and 2018?
Answer: 1429543.5
Calculation: ($1,470,797+$1,388,290)/2
Comparison of Fiscal Year Ended September 28, 2018 to Fiscal Year Ended September 29, 2017
We acquired AppliedMicro on January 26, 2017 and certain assets of Picometrix on August 9, 2017, and we divested the Compute business on October 27, 2017 and our LR4 business on May 10, 2018. For additional information related to acquisitions and divestitures refer to Note 4 - Acquisitions and Note 23 - Divested Business and Discontinued Operations, respectively, in this Annual Report.
Our annual Statements of Operations includes activity since the dates of acquisition for AppliedMicro and Picometrix and excludes activity for the Compute business and LR4 business after the date of the divestiture, representing less than twelve months of activity for AppliedMicro and Picometrix for the fiscal year ended September 29, 2017.
Revenue. In fiscal year 2018, our revenue decreased by $128.4 million, or 18.4%, to $570.4 million from $698.8 million for fiscal year 2017. Revenue from our primary markets, the percentage of change between the years and revenue by primary markets expressed as a percentage of total revenue were (in thousands, except percentages):
In fiscal year 2018, our Telecom market revenue decreased by $117.1 million, or 34.4%, compared to fiscal year 2017. The decrease was primarily due to lower sales of carrier-based optical semiconductor products to our Asia customer base, lower sales of products targeting fiber to the home applications and the May 2018 sale of our LR4 business.
In fiscal year 2018, our Data Center market revenue decreased by $10.4 million, or 6.0%, compared to fiscal year 2017. The decrease was primarily due to decreased revenue from sales of legacy optical products and lasers and cloud data center applications.
In fiscal year 2018, our I&D market revenues decreased by $0.9 million, or 0.5%, compared to fiscal year 2017. The decrease was primarily related to lower certain legacy defense products partially offset by higher revenue across other areas within the product portfolio.
Table:
 |  Fiscal Years   |  | 
 | 2018 | 2017 | % Change
Telecom | $222,940 | $340,022 | (34.4)%
Data Center | 162,098 | 172,481 | (6.0)%
Industrial & Defense | 185,360 | 186,269 | (0.5)%
 | 570,398 | 698,772 | (18.4)%
Telecom | 39.1% | 48.6% | 
Data Center | 28.4% | 24.7% | 
Industrial & Defense | 32.5% | 26.7% | 
Total | 100.0% | 100.0% | 


Question: When was AppliedMicro acquired?
Answer: January 26, 2017
8. Marketable Securities
The cost, gross unrealized gains, gross unrealized losses and fair market value of available-for-sale securities at April 30, 2019 and 2018, respectively, were as follows (in thousands):
Table:
 |  |  | April 30, 2019 | 
 | Cost | Gross Unrealized Gains | Gross Unrealized Losses | Fair Market Value
Fixed income securities | $8,152 | $71 | $(24) | $8,199
 |  |  | April 30, 2018 | 
 | Cost | Gross Unrealized Gains | Gross Unrealized Losses | Fair Market Value
Fixed income securities | $6,274 | $10 | $(135) | $6,149


Question: What does the table show?
Answer: The cost, gross unrealized gains, gross unrealized losses and fair market value of available-for-sale securities at April 30, 2019 and 2018, respectively
Total Expense for Share-Based Payment
Total expense for the share-based payment plans of Executive Board members was determined in accordance with IFRS 2 (Share- Based Payments) and consists exclusively of obligations arising from Executive Board activities.
Table:
€ thousands | 2019 | 2018
Christian Klein (Co-CEO from 10/10/2019) | 1,925 | 442.2
Jennifer Morgan (Co-CEO from 10/10/2019) | 2,894 | 796.1
Robert Enslin (until 4/5/2019) | 3,480 | 727.0
Adaire Fox-Martin | 2,667 | 796.1
Michael Kleinemeier | 3,253 | 914.2
Bernd Leukert (until 3/31/2019) | 8,606 | 775.2
Bill McDermott (CEO until 10/10/2019, Executive Board member until 11/15/2019) | 14,689 | 2,155.8
Luka Mucic | 3,391 | 675.8
Jürgen Müller (from 1/1/2019) | 768 | -
Stefan Ries | 2,646 | 772.0
Thomas Saueressig (from 11/1/2019) | 128 | -
Total | 44,446.5 | 8,054.4


Question: What was the average total expense for share-based payment for  Stefan Ries  in 2018 and 2019?
Answer: 1709
Calculation:  (2,646 + 772.0)/2
Disaggregation of Revenue
The following table disaggregates revenue generated within the United States (U.S.) from revenue generated from customers outside of the U.S. Revenue
for transaction tax compliance in the U.S. is further disaggregated based on the solutions or services purchased by customers. Total revenues consisted of the
following (in thousands):
Table:
 |  | For the Year Ended December 31, | 
 | 2019 | 2018 | 2017
Revenue (U.S.): |  |  | 
Subscription and returns |  |  | 
Tax determination | $203,584 | $147,847 | $114,575
Tax returns and compliance management | 127,815 | 91,239 | 74,454
Interest income on funds held for customers | 3,213 | 1,055 | -
Total subscription and returns | 334,612 | 240,141 | 189,029
Professional services | 24,399 | 15,126 | 12,476
Total revenue (U.S.) | 359,011 | 255,267 | 201,505
Total revenue (non U.S.) | 23,410 | 16,831 | 11,654
Total revenue | $382,421 | $272,098 | $213,159


Question: What is the percentage change in total revenue between 2018 and 2019?
Answer: 40.55
Calculation: (382,421 - 272,098)/272,098
Periodic Benefit Costs The aggregate net pension cost recognized in the consolidated statements of operations were costs of $6.5 million and $4.6 million for the years ended December 31, 2019 and 2018, respectively.
The following table presents the components of net periodic benefit cost are as follows (in millions):
Of the amounts presented above, income of $1.4 million has been included in cost of revenue and loss of $7.9 million included in other comprehensive income for the year ended December 31, 2019, and income of $2.1 million has been included in cost of revenue and loss of $6.7 million included in other comprehensive income for the year ended December 31, 2018.
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Service cost—benefits earning during the period | $- | $-
Interest cost on projected benefit obligation | 5.3 | 5.3
Expected return on assets | (6.7) | (7.5)
Actuarial (gain) loss | 7.9 | 6.7
Foreign currency gain (loss) | - | 0.1
Net pension (benefit) cost | $ 6.5 | $ 4.6


Question: What is the increase / (decrease) in the expected return on assets from 2018 to 2019?
Answer: 1
Calculation: -6.5 - (-7.5)
NOTE 2. RIGHT-OF-USE ASSETS
The Company leases many assets, including land, buildings, houses, motor vehicles, machinery and equipment. Leases typically run up to a period of 5 years, some with an option to renew the lease after the end of the non-cancelable period. Lease payments are renegotiated on a periodic basis; timing is depending on the region and type of lease. The Company has not entered into any sub-lease arrangements.
Right-of-use assets
Table:
 | Land and buildings | Motor vehicles | Other machinery and equipment | Total
Balance January 1, 2019 | 23,579 | 1,488 | 620 | 25,687
Additions | 6,475 | 1,588 | 16 | 8,079
Transfer from property, plant and equipment | 459 | – | – | 459
Modifications and reassessments | 75 | 31 | (24) | 82
Retirements | – | – | – | –
Depreciation for the year | (6,057) | (1,008) | (268) | (7,333)
Foreign currency translation effect | 518 | 43 | 12 | 573
Balance December 31, 2019 | 25,049 | 2,142 | 356 | 27,547


Question: What is the total balance in january 1, 2019?
Answer: 25,687
NON-GAAP FINANCIAL MEASURES
Non-GAAP operating income, net income, and diluted EPS are non-GAAP financial measures which exclude the net tax impact of transfer of intangible properties, the net tax impact of the TCJA, and restructuring expenses. We believe these non-GAAP measures aid investors by providing additional insight into our operational performance and help clarify trends affecting our business. For comparability of reporting, management considers non-GAAP measures in conjunction with GAAP financial results in evaluating business performance. These non-GAAP financial measures presented should not be considered a substitute for, or superior to, the measures of financial performance prepared in accordance with GAAP.
The following table reconciles our financial results reported in accordance with GAAP to non-GAAP financial results:
* Not meaningful.
Table:
(In millions, except percentages and per share amounts) | 2019 | 2018 | 2017 | Percentage Change 2019 Versus 2018 | Percentage Change 2018 Versus 2017
Operating income | $42,959 | $35,058 | $  29,025 | 23% | 21%
Net tax impact of transfer of intangible properties | 0 | 0 | 0 | * | *
Net impact of the TCJA | 0 | 0 | 0 | * | *
Restructuring expenses | 0 | 0 | 306 | * | *
Non-GAAP operating income | $42,959 | $35,058 | $ 29,331 | 23% | 20%
Net income | $39,240 | $16,571 | $ 25,489 | 137% | (35)%
Net tax impact of transfer of intangible properties | (2,567) | 0 | 0 | * | *
Net tax impact of the TCJA | 157 | 13,696 | 0 |  | 
Restructuring expenses | 0 | 0 | 243 | * | *
Non-GAAP net income | $36,830 | $30,267 | $ 25,732 | 22% | 18%
Diluted earnings per share | $5.06 | $2.13 | $ 3.25 | 138% | (34)%
Net tax impact of transfer of intangible properties | (0.33) | 0 | 0 | * | *
Net tax impact of the TCJA | 0.02 | 1.75 | 0 | * | *
Restructuring expenses | 0 | 0 | 0.04 | * | *
Non-GAAP diluted earnings per share | $4.75 | $3.88 | $ 3.29 | 22% | 18%
* not meaningful |  |  |  |  | 


Question: What is the average non-GAAP net income for the 3 year period from 2017 to 2019?
Answer: 30943
Calculation: (36,830+30,267+25,732)/(2019-2017+1)