hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
ITEM 6. SELECTED FINANCIAL DATA
In December 2016, we acquired the 67% remaining interest in Inotera and began consolidating Inotera's operating results. In the periods presented above through December 2016, Inotera sold DRAM products exclusively to us through supply agreements. The cash paid for the Inotera Acquisition was funded, in part, with a term loan of 80 billion New Taiwan dollars and $986 million from the sale of 58 million shares of our common stock. See "Item 8. Financial Statements and Supplementary Data – Notes to Consolidated Financial Statements – Acquisition of Inotera."
Table:
 | 2019 | 2018 | 2017 | 2016 | 2015
 |  |  | (in millions, except per share amounts) |  | 
Revenue | $23,406 | $30,391 | $20,322 | $12,399 | $16,192
Gross margin | 10,702 | 17,891 | 8,436 | 2,505 | 5,215
Operating income | 7,376 | 14,994 | 5,868 | 168 | 2,998
Net income (loss) | 6,358 | 14,138 | 5,090 | (275) | 2,899
Net income (loss) attributable to Micron | 6,313 | 14,135 | 5,089 | (276) | 2,899
Diluted earnings (loss) per share | 5.51 | 11.51 | 4.41 | (0.27) | 2.47
Cash and short-term investments | 7,955 | 6,802 | 5,428 | 4,398 | 3,521
Total current assets | 16,503 | 16,039 | 12,457 | 9,495 | 8,596
Property, plant, and equipment | 28,240 | 23,672 | 19,431 | 14,686 | 10,554
Total assets | 48,887 | 43,376 | 35,336 | 27,540 | 24,143
Total current liabilities | 6,390 | 5,754 | 5,334 | 4,835 | 3,905
Long-term debt | 4,541 | 3,777 | 9,872 | 9,154 | 6,252
Total Micron shareholders' equity | 35,881 | 32,294 | 18,621 | 12,080 | 12,302
Noncontrolling interests in subsidiaries | 889 | 870 | 849 | 848 | 937
Total equity | 36,770 | 33,164 | 19,470 | 12,928 | 13,239


Question: How did Inotera sell DRAM products to Micron in the periods presented in the table through December 2016?
Answer: through supply agreements
Presentation of Derivative Gains (Losses) from Economic Hedges of Forecasted Cash Flows in Segment Results
Derivatives used to manage commodity price risk and foreign currency risk are not designated for hedge accounting treatment. We believe these derivatives provide economic hedges of certain forecasted transactions. As such, these derivatives are generally recognized at fair market value with realized and unrealized gains and losses recognized in general corporate expenses. The gains and losses are subsequently recognized in the operating results of the reporting segments in the period in which the underlying transaction being economically hedged is included in earnings. In the event that management determines a particular derivative entered into as an economic hedge of a forecasted commodity purchase has ceased to function as an economic hedge, we cease recognizing further gains and losses on such derivatives in corporate expense and begin recognizing such gains and losses within segment operating results, immediately.
The following table presents the net derivative gains (losses) from economic hedges of forecasted commodity consumption and the foreign currency risk of certain forecasted transactions associated with continuing operations, under this methodology:
As of May 26, 2019, the cumulative amount of net derivative gains from economic hedges that had been recognized in general corporate expenses and not yet allocated to reporting segments was $1.4 million. This amount reflected net gains of $1.0 million incurred during the fiscal year ended May 26, 2019, as well as net gains of $0.4 million incurred prior to fiscal 2019. Based on our forecasts of the timing of recognition of the underlying hedged items, we expect to reclassify to segment operating results gains of $0.9 million in fiscal 2020 and $0.5 million in fiscal 2021 and thereafter.
Table:
 |  | Fiscal Years Ended | 
($ in millions) | May 26, 2019 | May 27, 2018 | May 28, 2017
Net derivative gains (losses) incurred | $(3.6) | $(0.9) | $0.6
Less: Net derivative gains (losses) allocated to reporting segments | (1.8) | (7.1) | 5.7
Net derivative gains (losses) recognized in general corporate expenses | $(1.8) | $6.2 | $(5.1)
Net derivative gains (losses) allocated to Grocery & Snacks | $(2.1) | $0.2 | $3.4
Net derivative gains (losses) allocated to Refrigerated & Frozen | (1.1) | (0.3) | 0.8
Net derivative gains (losses) allocated to International Foods . | 2.8 | (6.9) | 1.6
Net derivative losses allocated to Foodservice . | (0.6) | (0.1) | —
Net derivative losses allocated to Pinnacle Foods | (0.8) | — | —
Net derivative losses allocated to Commercial . | — | — | (0.1)
Net derivative gains (losses) included in segment operating profit . | $(1.8) | $(7.1) | $5.7


Question: What is the percentage change of net derivative gains (losses) allocated to Grocery & Snacks from the fiscal year 2017 to 2018?
Answer: -94.12
Calculation: ((0.2-3.4)/3.4) * 100
stock performance graph the following graph compares the most recent five-year performance of the company 2019s common stock with ( 1 ) the standard & poor 2019s 500 ae index and ( 2 ) the standard & poor 2019s 500 ae materials index , a group of 25 companies categorized by standard & poor 2019s as active in the 201cmaterials 201d market sector . the graph assumes , in each case , an initial investment of $ 100 on december 31 , 2012 , and the reinvestment of dividends . historical prices prior to the separation of alcoa corporation from the company on november 1 , 2016 , have been adjusted to reflect the value of the separation transaction . the graph , table and related information shall not be deemed to be 201cfiled 201d with the sec , nor shall such information be incorporated by reference into future filings under the securities act of 1933 or securities exchange act of 1934 , each as amended , except to the extent that the company specifically incorporates it by reference into such filing . copyright a9 2018 standard & poor's , a division of s&p global . all rights reserved. .

Table:
as of december 31, | 2012 | 2013 | 2014 | 2015 | 2016 | 2017
arconic inc . | $ 100 | $ 124.15 | $ 186.02 | $ 117.48 | $ 99.40 | $ 147.47
s&p 500 aeindex | 100 | 132.39 | 150.51 | 152.59 | 170.84 | 208.14
s&p 500 aematerials index | 100 | 125.60 | 134.28 | 123.03 | 143.56 | 177.79
s&p 500 ae index 100 132.39 150.51 152.59 170.84 208.14 s&p 500 ae materials index 100 125.60 134.28 123.03 143.56 177.79 .

Question: what is the annualized return for the s&p 500 aematerials index during 2012 and 2017?
Answer: 22.25%
Calculation: subtract(177.79, 100), divide(const_1, const_5), subtract(#1, const_1), exp(#0, #2), subtract(#3, const_1)
Restricted Stock Awards and Restricted Stock Unit Awards
For equity based restricted stock and restricted stock unit awards that contain only service conditions for vesting (time-based awards), we calculate the award fair value based on the closing price of CenturyLink common stock on the accounting grant date. We also grant equity-based awards that contain service conditions as well as additional market or performance conditions. For awards having both service and market conditions, the award fair value is calculated using Monte-Carlo simulations. Awards with service as well as market or performance conditions specify a target number of shares for the award, although each recipient ultimately has the opportunity to receive between 0% and 200% of the target number of shares. For awards with service and market conditions, the percentage received is based on our total shareholder return over the three-year service period versus that of selected peer companies. For awards with service and performance conditions, the percentage received depends upon the attainment of one or more financial performance targets during the two or three-year service period.
The following table summarizes activity involving restricted stock and restricted stock unit awards for the year ended December 31, 2019:
(1) Shares granted whose related performance conditions were not finalized at December 31, 2019, were excluded from this figure.
During 2018, we granted 9.7 million shares of restricted stock and restricted stock unit awards at a weighted-average price of $17.02. During 2017, we granted 5.2 million shares of restricted stock and restricted stock unit awards at a weighted-average price of $22.02. The total fair value of restricted stock that vested during 2019, 2018 and 2017, was $118 million, $169 million and $60 million, respectively.
Table:
 | Number of shares | Weighed-Average Grant Date Fair Value
 | (In thousands) | 
Non-vested at December 31, 2018 | 17,059 | $19.65
Granted(1) | 9,780 | 12.41
Vested | (9,038) | 19.54
Forfeited | (1,757) | 18.62
Non-vested at December 31, 2019 | 16,044 | 15.42


Question: What type of granted shares was excluded from the table?
Answer: Shares granted whose related performance conditions were not finalized at December 31, 2019
6. Inventories
Inventories consisted of the following components at June 30, 2019 and 2018:
If the FIFO method of inventory had been used instead of the LIFO method, inventories would have been $178.4 million and $210.3 million higher as of June 30, 2019 and 2018, respectively. Current cost of LIFO-valued inventories was $793.0 million at June 30, 2019 and $760.8 million at June 30, 2018. The reductions in LIFO-valued inventories decreased cost of sales by $0.0 million during fiscal year 2019 and $0.6 million during fiscal year 2018 and $0.0 million during fiscal year 2017.
Table:
 | June 30, | 
($ in millions) | 2019 | 2018
Raw materials and supplies | $169.8 | $157.5
Work in process | 425.7 | 372.5
Finished and purchased products | 192.2 | 159.2
Total inventory | $787.7 | $689.2


Question: In which year was Raw materials and supplies larger?
Answer: 2019
Calculation: 169.8>157.5
5. CASH FLOW ANALYSIS
(1) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy as well as to reclassify results from Cogeco Peer 1 as discontinued operations. For further details, please consult the "Accounting policies" and "Discontinued operations" sections.
(2) For further details on the Corporation's cash flow attributable to discontinued operations, please consult the "Discontinued operations" section.
Fiscal 2019 cash flow from operating activities increased by 39.9% compared to the prior year mainly from: • higher adjusted EBITDA; • the decreases in income taxes paid and in financial expense paid; and • the decrease in integration, restructuring and acquisitions costs.
Fiscal 2019 investing activities decreased by 78.5% compared to the prior year mainly due to the MetroCast acquisition of $1.76 billion in the second quarter of fiscal 2018.
Table:
Years ended August 31, | 2019 | 2018 (1) | Change
(in thousands of dollars, except percentages) | $ | $ | %
Cash flow from operating activities | 868,711 | 620,748 | 39.9
Cash flow from investing activities | (471,078) | (2,191,666) | (78.5)
Cash flow from financing activities | (659,222) | 1,426,136 | —
Effect of exchange rate changes on cash and cash equivalents denominated in a foreign currency | (439) | 1,989 | —
Net change in cash and cash equivalents from continuing operations | (262,028) | (142,793) | 83.5
Net change in cash and cash equivalent from discontinued operations(2) | 733,807 | 16,333 | —
Cash and cash equivalents, beginning of the year | 84,725 | 211,185 | (59.9)
Cash and cash equivalents, end of the year | 556,504 | 84,725 | —


Question: What was the increase in cash flow from operating activities in 2019?
Answer: 39.9%
we are not under any obligation ( and expressly disclaim any such obligation ) to update or alter our forward- looking statements , whether as a result of new information , future events or otherwise . you should carefully consider the possibility that actual results may differ materially from our forward-looking statements . item 1b . unresolved staff comments . item 2 . properties . our corporate headquarters are located in jacksonville , florida , in an owned facility . fnf occupies and pays us rent for approximately 121000 square feet in this facility . we lease office space as follows : number of locations ( 1 ) .

Table:
state | number of locations ( 1 )
california | 57
florida | 26
georgia | 22
texas | 19
minnesota new york | 9
illinois ohio maryland | 8
pennsylvania | 7
other | 63
( 1 ) represents the number of locations in each state listed .
we also lease approximately 81 locations outside the united states .
we believe our properties are adequate for our business as presently conducted .
item 3 .
legal proceedings .
in the ordinary course of business , we are involved in various pending and threatened litigation matters related to our operations , some of which include claims for punitive or exemplary damages .
we believe that no actions , other than the matters listed below , depart from customary litigation incidental to our business .
as background to the disclosure below , please note the following : 2022 these matters raise difficult and complicated factual and legal issues and are subject to many uncertainties and complexities .
2022 we review these matters on an on-going basis and follows the provisions of statement of financial accounting standards ( 201csfas 201d ) no .
5 , 201caccounting for contingencies , 201d when making accrual and disclosure decisions .
when assessing reasonably possible and probable outcomes , we base our decision on our assessment of the ultimate outcome following all appeals .
the company and certain of its employees were named on march 6 , 2006 as defendants in a civil lawsuit brought by grace & digital information technology co. , ltd .
( 201cgrace 201d ) , a chinese company that formerly acted as a sales agent for alltel information services ( 201cais 201d ) .
grace originally filed suit in december 2004 in state court in monterey county , california , alleging that the company breached a sales agency agreement by failing to pay commissions associated with sales contracts signed in 2001 and 2003 .
the 2001 contracts were never completed .
the 2003 contracts , as to which grace provided no assistance , were for a different project and were executed one and one-half years after grace 2019s sales agency agreement was terminated .
in addition to its breach of contract claim , grace also alleged that the company violated the foreign corrupt practices act ( fcpa ) in its dealings with a bank customer in china .
the company denied grace 2019s allegations in this california lawsuit. .

Question: what portion of the total leased locations are in texas?
Answer: 13.2%
Calculation: add(63, 81), divide(19, #0)
3.3 Fair value estimation The table below analyses the Group’s financial instruments carried at fair value as at 31 December 2019 by level of the inputs to valuation techniques used to measure fair value. Such inputs are categorised into three levels within a fair value hierarchy as follows:
Quoted prices (unadjusted) in active markets for identical assets or liabilities (level 1);
Inputs other than quoted prices included within level 1 that are observable for the asset or liability, either directly (that is, as prices) or indirectly (that is, derived from prices) (level 2); and
Inputs for the asset or liability that are not based on observable market data (that is, unobservable inputs) (level 3).
The fair value of financial instruments traded in active markets is determined with reference to quoted market prices at the end of the reporting period. A market is regarded as active if quoted prices are readily and regularly available from an exchange, dealer, broker, industry group, pricing service, or regulatory agency, and those prices represent actual and regularly occurring market transactions on an arm’s length basis. These instruments are included in level 1.
The fair value of financial instruments that are not traded in an active market is determined by using valuation techniques. These valuation techniques maximise the use of observable market data where it is available and rely as little as possible on entity specific estimates. If all significant inputs required for evaluating the fair value of a financial instrument are observable, the instrument is included in level 2.
If one or more of the significant inputs are not based on observable market data, the instrument is included in level 3.
Specific valuation techniques used to value financial instruments mainly include: • Dealer quotes for similar instruments; • The fair value of interest rate swaps is calculated as the present value of the estimated future cash flows based on observable yield curves; and • Other techniques, such as discounted cash flow analysis, are used to determine fair value for financial instruments.
Table:
 | Level 1 | Level 2 | Level 3 | Total
 | RMB’Million | RMB’Million | RMB’Million | RMB’Million
As at 31 December 2019 |  |  |  | 
FVPL | 14,766 | 5,091 | 116,079 | 135,936
FVOCI | 74,707 | – | 7,014 | 81,721
OFA | – | 375 | – | 375
Other financial liabilities | – | 523 | 1,873 | 2,396
As at 31 December 2018 |  |  |  | 
FVPL | 10,875 | 5,009 | 81,993 | 97,877
FVOCI | 41,578 | – | 1,941 | 43,519
OFA | – | 2,032 | – | 2,032
Other financial liabilities | – | 40 | 4,466 | 4,506


Question: How much did the level 1 FVPL change by from 2018 year end to 2019 year end?
Answer: 3891
Calculation: 14,766-10,875
The following table summarizes the potentially dilutive common shares that were excluded from diluted weighted-average common shares outstanding because including them would have had an anti-dilutive effect (in thousands):
Since the Company expects to settle the principal amount of its outstanding convertible senior notes in cash and any excess in cash or shares of the Company’s Class A 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 diluted net income per share of common stock when the average market price of the Company’s Class A Common Stock for a given period exceeds the conversion price of $81.45 per share for the Notes.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Shares of common stock issuable under equity incentive plans outstanding | 6,832 | 8,943 | 10,806
Convertible senior notes | 1,905 | 79 | -
Potential common shares excluded from diluted net loss per share | 8,737 | 9,022 | 10,806


Question: What is the average number of potential common shares excluded from diluted net loss per share between 2017 and 2019?
Answer: 9521.67
Calculation: (10,806 + 9,022 + 8,737)/3
NOTE 21—EARNINGS PER SHARE
Basic earnings per share are computed by dividing net income, attributable to OpenText, by the weighted average number of Common Shares outstanding during the period. Diluted earnings per share are computed by dividing net income, attributable to OpenText, by the shares used in the calculation of basic earnings per share plus the dilutive effect of Common Share equivalents, such as stock options, using the treasury stock method. Common Share equivalents are excluded from the computation of diluted earnings per share if their effect is anti-dilutive.
(1) Please also see note 14 "Income Taxes" for details relating to a one-time tax benefit of $876.1 million recorded during the three months ended September 30, 2016 in connection with an internal reorganization of our subsidiaries.
(2) Represents options to purchase Common Shares excluded from the calculation of diluted earnings per share because the exercise price of the stock options was greater than or equal to the average price of the Common Shares during the period.
Table:
 |  | Year Ended June 30, | 
 | 2019 | 2018 | 2017
Basic earnings per share |  |  | 
Net income attributable to OpenText | $285,501 | $242,224 | $1,025,659(1)
Basic earnings per share attributable to OpenText | $1.06 | $0.91 | $4.04
Diluted earnings per share |  |  | 
Net income attributable to OpenText | $285,501 | $242,224 | $1,025,659(1)
Diluted earnings per share attributable to OpenText | $1.06 | $0.91 | $4.01
Weighted-average number of shares outstanding (in 000's) |  |  | 
Basic | 268,784 | 266,085 | 253,879
Effect of dilutive securities | 1,124 | 1,407 | 1,926
Diluted | 269,908 | 267,492 | 255,805
Excluded as anti-dilutive(2) | 2,759 | 2,770 | 1,371


Question: What is the Effect of dilutive securities expressed as a percentage of Excluded as anti-dilutive for fiscal year 2019?
Answer: 40.74
Calculation: (1,124/2,759) * 100
Issuer Purchases of Equity Securities
(a) During the fourth quarter of 2015, Lifeway publicly announced a share repurchase program. On November 1, 2017, the our Board of Directors amended the 2015 stock repurchase program (the “2017 amendment”), by adding to (i.e., exclusive of the shares previously authorized under the 2015 stock program repurchase) the authorization the lesser of $5,185 or 625 shares. The program has no expiration date.
Table:
Period | Total number of shares purchased | Average price paid per share | Total number of shares purchased as part of a publicly announced program (a) | Approximate Dollar Value of Shares that may yet be Purchased under the Plans or Programs ($ in thousands)
1/1/2018 to 1/31/2018 | 106,441 | $ 8.22 | 106,441 | $ 5,007
2/1/2018 to 2/28/2018 | 24,486 | $ 7.21 | 24,486 | $ 4,830
4/1/2018 to 4/30/2018 | 15,433 | $ 6.09 | 15,433 | $ 4,736
6/1/2018 to 6/30/2018 | 4,143 | $ 5.46 | 4,143 | $ 4,714
8/1/2018 to 8/31/2018 | 1,332 | $ 3.96 | 1,332 | $ 4,709
9/1/2018 to 9/30/18 | 40,364 | $ 3.35 | 40,364 | $ 4,573
11/1/2018 to 11/30/18 | 17,228 | $ 2.99 | 17,228 | $ 4,522
12/1/2018 to 12/31/18 | 8,305 | $ 2.25 | 8,305 | $ 4,503
Fiscal Year 2018 | 217,732 | $ 6.33 | 217,732 | $ 4,503
1/1/2019 to 1/31/2019 | 46,743 | $ 2.54 | 46,743 | $ 4,384
2/1/2019 to 2/28/2019 | 9,100 | $ 2.75 | 9,100 | $ 4,358
3/1/2019 to 3/31/2019 | 26,932 | $ 2.24 | 26,932 | $ 4,298
4/1/2019 to 4/30/2019 | 4,300 | $ 2.24 | 4,300 | $ 4,288
5/1/2019 to 5/31/2019 | 57,817 | $ 2.49 | 57,817 | $ 4,145
6/1/2019 to 6/30/2019 | 11,146 | $ 2.32 | 11,146 | $ 4,119
8/1/2019 to 8/31/2019 | 37,567 | $ 2.69 | 37,567 | $ 4,018
9/1/2019 to 9/30/2019 | 17,531 | $ 2.98 | 17,531 | $ 3,965
Fiscal Year 2019 | 211,136 | $ 2.55 | 211,136 | $ 3,965


Question: What is the change in the total number of shares purchased between fiscal years 2018 and 2019?
Answer: -6596
Calculation: 211,136-217,732
Operational Highlights
Altium achieved US$177.2 million in sales (a 23% increase) and US$171.8 million in product revenue (a 23% increase).
The Board and Systems business revenue grew to US$126.8 million with all regions reporting positive results. EMEA grew revenue to US$44.6 million, an increase of 15% and continued the transformation of its business model to direct transactional sales in key markets. The America’s achieved revenue of US$50.9 million which was a 14% growth rate. China results were outstanding with revenue at US$19.8 million, a growth rate of 37%. The Altium focus on our business in China led us to open a new sales office in Beijing and to expand our existing sales centres in Shenzhen and Shanghai. The expansion of our footprint in China will enable us to increase our penetration of the market.
Table:
Consolidated |  |  | 
 | 2019 | 2018 | Change
Product Sales | US$’000 | US$’000 | %
Altium Designer licenses | 65,157 | 53,088 | 23%
Altium Designer subscriptions | 58,959 | 53,701 | 10%
Octopart search advertising | 17,940 | 11,968 | 50%
TASKING licenses | 13,536 | 10,432 | 30%
TASKING maintenance | 8,324 | 4,706 | 67%
Altium Nexus | 6,277 | 3,769 | 67%
Service sales | 3,337 | 4,624 | (28%)
Other | 3,656 | 2,254 | 62%
Total Product Sales | 177,216 | 144,541 | 23%


Question: What is the Board and Systems business revenue in 2019?
Answer: US$126.8 million