hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
16. Segment, Geographic, and Significant Customer Information
We operate in one industry segment: the design, manufacturing, marketing, and technical support of high-performance storage and data management solutions. We conduct business globally, and our sales and support activities are managed on a geographic basis. Our management reviews financial information presented on a consolidated basis, accompanied by disaggregated information it receives from our internal management system about revenues by geographic region, based on the location from which the customer relationship is managed, for purposes of allocating resources and evaluating financial performance. We do not allocate costs of revenues, research and development, sales and marketing, or general and administrative expenses to our geographic regions in this internal management reporting because management does not review operations or operating results, or make planning decisions, below the consolidated entity level.
Summarized revenues by geographic region based on information from our internal management system and utilized by our Chief Executive Officer, who is considered our Chief Operating Decision Maker, is as follows (in millions):
Americas revenues consist of sales to Americas commercial and U.S. public sector markets. Sales to customers inside the U.S. were $3,116 million, $2,878 million and $2,721 million during fiscal 2019, 2018 and 2017, respectively.
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
United States, Canada and Latin America (Americas) | $ 3,425 | $ 3,207 | $ 3,021
Europe, Middle East and Africa (EMEA) | 1,847 | 1,873 | 1,741
Asia Pacific (APAC) | 874 | 839 | 729
Net revenues | $ 6,146 | $ 5,919 | $ 5,491


Question: How many years did revenue from the Americas exceed $3,000 million?
Answer: 3
Calculation: 2019##2018##2017
TERM DEPOSITS
An analysis of the Group’s term deposits by currencies are as follows:
The effective interest rate for the term deposits of the Group with initial terms of over three months to three years during the year ended 31 December 2019 was 3.57% (2018: 4.08%).
Term deposits with initial terms of over three months were neither past due nor impaired. As at 31 December 2019, the carrying amounts of the term deposits with initial terms of over three months approximated their fair values.
Table:
 | As at 31 December | 
 | 2019 | 2018
 | RMB’Million | RMB’Million
Included in non-current assets: |  | 
RMB term deposits | 19,000 | –
Included in current assets: |  | 
RMB term deposits | 28,598 | 55,180
USD term deposits | 16,325 | 6,349
Other currencies | 1,988 | 1,389
 | 46,911 | 62,918
 | 65,911 | 62,918


Question: What was the effective interest rate for the term deposits of the Group with initial terms of over three months to three years during the year ended 31 December 2018?
Answer: 4.08%
Contractual Obligations
We have various contractual obligations impacting our liquidity. The following represents our contractual obligations as of January 31, 2020 (table in millions)
(1) Consists of principal and interest payments on the Senior Notes. Refer to “Liquidity and Capital Resources” for a discussion of the public debt offering we issued on August 21, 2017 in the aggregate principal amount of $4.0 billion.
(2) Consists of principal and interest payments on the outstanding note payable to Dell. Refer to “Liquidity and Capital Resources” for a discussion of the $270 million note payable we entered into with Dell per the note exchange agreement from January 21, 2014.
(3) Consists of the principal on the senior unsecured term loan facility (the “Term Loan”). The Term Loan can be repaid any time before October 2020. Given the variable nature of the interest on the Term Loan, including when the repayment will take place, interest payments have been excluded from the table above.
(4) Consists of both operating and finance leases. Our operating leases are primarily for facility space and land. Amounts in the table above exclude legally binding minimum lease payments for leases signed but not yet commenced of $361 million, as well as expected sublease income.
(5) Consists of future cash payments related to the Transition Tax.
(6) As of January 31, 2020, we had $479 million of gross uncertain tax benefits, excluding interest and penalties. The timing of future payments relating to these obligations is highly uncertain. Based on the timing and outcome of examinations of our subsidiaries, the result of the expiration of statutes of limitations for specific jurisdictions or the timing and result of ruling requests from taxing authorities, it is reasonably possible that within the next 12 months total unrecognized tax benefits could be potentially reduced by approximately $17 million.
Table:
 |  |  | Payments Due by Period |  | 
 | Total | Less than 1 year | 1-3 years | 3-5 years | More than 5 years
Senior Notes(1) | $4,552 | $1,372 | $1,686 | $98 | $1,396
Note payable to Dell(2) | 283 | 5 | 278 | — | —
Term Loan(3) | 1,500 | 1,500 | — | — | —
Future Lease Commitments(4) | 1,202 | 144 | 268 | 178 | 612
Purchase obligations | 255 | 168 | 87 | — | —
Tax obligations(5) | 545 | 53 | 104 | 227 | 161
Asset Retirement Obligations | 13 | 1 | 5 | 2 | 5
Sub-Total | 8,350 | 3,243 | 2,428 | 505 | 2,174
Uncertain tax positions(6) | 479 |  |  |  | 
Total | $8,829 |  |  |  | 


Question: What was the difference between total Term Loans and total Future Lease Commitments?
Answer: 298
Calculation: 1,500-1,202
performance graph the table below compares the cumulative total shareholder return on our common stock with the cumulative total return of ( i ) the standard & poor 2019s 500 composite stock index ( 201cs&p 500 index 201d ) , ( ii ) the standard & poor 2019s industrials index ( 201cs&p industrials index 201d ) and ( iii ) the standard & poor 2019s consumer durables & apparel index ( 201cs&p consumer durables & apparel index 201d ) , from december 31 , 2005 through december 31 , 2010 , when the closing price of our common stock was $ 12.66 . the graph assumes investments of $ 100 on december 31 , 2005 in our common stock and in each of the three indices and the reinvestment of dividends . performance graph 201020092008200720062005 s&p 500 index s&p industrials index s&p consumer durables & apparel index the table below sets forth the value , as of december 31 for each of the years indicated , of a $ 100 investment made on december 31 , 2005 in each of our common stock , the s&p 500 index , the s&p industrials index and the s&p consumer durables & apparel index and includes the reinvestment of dividends. .

Table:
 | 2006 | 2007 | 2008 | 2009 | 2010
masco | $ 101.79 | $ 76.74 | $ 42.81 | $ 54.89 | $ 51.51
s&p 500 index | $ 115.61 | $ 121.95 | $ 77.38 | $ 97.44 | $ 111.89
s&p industrials index | $ 113.16 | $ 126.72 | $ 76.79 | $ 92.30 | $ 116.64
s&p consumer durables & apparel index | $ 106.16 | $ 84.50 | $ 56.13 | $ 76.51 | $ 99.87
in july 2007 , our board of directors authorized the purchase of up to 50 million shares of our common stock in open-market transactions or otherwise .
at december 31 , 2010 , we had remaining authorization to repurchase up to 27 million shares .
during 2010 , we repurchased and retired three million shares of our common stock , for cash aggregating $ 45 million to offset the dilutive impact of the 2010 grant of three million shares of long-term stock awards .
we did not purchase any shares during the three months ended december 31 , 2010. .

Question: what was percent of the remaining authorization to repurchase of the 2007 authorized the purchase at december 2010
Answer: 54%
Calculation: divide(27, 50)
The following highlights net sales by geographic location (amounts in thousands):
(1) Revenues are attributed to countries or regions based on the location of the customer. Net Sales to one customer, TTI, Inc., exceeded 10% of total net sales as follows: $184.3 million, $133.5 million and $104.4 million in fiscal years 2019, 2018 and 2017, respectively.
(2) No country included in this caption exceeded 3% of consolidated net sales for fiscal years 2019, 2018 and 2017.
(3) Fiscal years ended March 31, 2018 and 2017 adjusted due to the adoption of ASC 606.
Table:
 |  | Fiscal Years Ended March 31,(1) | 
 | 2019 | 2018 | 2017
United States | $292,980 | $233,133 | $198,250
Hong Kong | 188,102 | 169,073 | 121,813
Germany | 124,805 | 105,548 | 104,755
Europe (2) (3) | 76,149 | 64,248 | 63,863
China | 173,148 | 163,016 | 71,223
Taiwan | 88,853 | 78,728 | 9,147
Asia Pacific (2) | 47,233 | 36,647 | 26,878
Japan | 178,502 | 170,282 | 3,565
United Kingdom | 42,472 | 37,038 | 33,837
Netherlands | 44,065 | 39,684 | 32,478
Malaysia | 33,748 | 28,165 | 15,177
Singapore | 19,417 | 17,267 | 15,565
Italy | 15,551 | 17,905 | 15,376
Hungary | 12,245 | 13,254 | 18,856
Mexico | 44,267 | 23,915 | 22,424
Other Countries (2) | 1,281 | 2,278 | 4,131
Total Non-United States (3) | 1,089,838 | 967,048 | 559,088
 | $1,382,818 | $1,200,181 | $757,338


Question: Which years did the total net sales in all regions exceed $1,000,000 thousand?
Answer: 2019, 2018
Calculation: (2019:1,382,818),(2018:1,200,181)
11. Income Taxes
The geographical breakdown of loss before income taxes is as follows (in thousands):
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Domestic loss | $(20,345) | $(29,658) | $(13,752)
Foreign income | 3,933 | 3,123 | 4,207
Loss before income taxes | $(16,412) | $(26,535) | $(9,545)


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


Question: Which year was there a higher average number of employees?
Answer: 2018
Calculation: 25,614 > 24,071
table of contents capital deployment program will be subject to market and economic conditions , applicable legal requirements and other relevant factors . our capital deployment program does not obligate us to continue a dividend for any fixed period , and payment of dividends may be suspended at any time at our discretion . stock performance graph the following stock performance graph and related information shall not be deemed 201csoliciting material 201d or 201cfiled 201d with the securities and exchange commission , nor shall such information be incorporated by reference into any future filings under the securities act of 1933 or the exchange act , each as amended , except to the extent that we specifically incorporate it by reference into such filing . the following stock performance graph compares our cumulative total stockholder return on an annual basis on our common stock with the cumulative total return on the standard and poor 2019s 500 stock index and the amex airline index from december 9 , 2013 ( the first trading day of aag common stock ) through december 31 , 2015 . the comparison assumes $ 100 was invested on december 9 , 2013 in aag common stock and in each of the foregoing indices and assumes reinvestment of dividends . the stock performance shown on the graph below represents historical stock performance and is not necessarily indicative of future stock price performance. .

Table:
 | 12/9/2013 | 12/31/2013 | 12/31/2014 | 12/31/2015
american airlines group inc . | $ 100 | $ 103 | $ 219 | $ 175
amex airline index | 100 | 102 | 152 | 127
s&p 500 | 100 | 102 | 114 | 113
purchases of equity securities by the issuer and affiliated purchasers since july 2014 , our board of directors has approved several share repurchase programs aggregating $ 7.0 billion of authority of which , as of december 31 , 2015 , $ 2.4 billion remained unused under repurchase programs .

Question: what was the 4 year return of american airlines group inc . common stock?
Answer: 75%
Calculation: subtract(175, 100), divide(#0, 100)
entergy arkansas , inc . and subsidiaries management 2019s financial discussion and analysis results of operations net income 2016 compared to 2015 net income increased $ 92.9 million primarily due to higher net revenue and lower other operation and maintenance expenses , partially offset by a higher effective income tax rate and higher depreciation and amortization expenses . 2015 compared to 2014 net income decreased $ 47.1 million primarily due to higher other operation and maintenance expenses , partially offset by higher net revenue . net revenue 2016 compared to 2015 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges ( credits ) . following is an analysis of the change in net revenue comparing 2016 to 2015 . amount ( in millions ) .

Table:
 | amount ( in millions )
2015 net revenue | $ 1362.2
retail electric price | 161.5
other | -3.2 ( 3.2 )
2016 net revenue | $ 1520.5
the retail electric price variance is primarily due to an increase in base rates , as approved by the apsc .
the new base rates were effective february 24 , 2016 and began billing with the first billing cycle of april 2016 .
the increase includes an interim base rate adjustment surcharge , effective with the first billing cycle of april 2016 , to recover the incremental revenue requirement for the period february 24 , 2016 through march 31 , 2016 .
a significant portion of the increase is related to the purchase of power block 2 of the union power station .
see note 2 to the financial statements for further discussion of the rate case .
see note 14 to the financial statements for further discussion of the union power station purchase. .

Question: what is the net change in net revenue during 2016 for entergy arkansas , inc.?
Answer: 158.3
Calculation: subtract(1520.5, 1362.2)
Other Current Liabilities
The components of other current liabilities are included in the following table (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Operating lease liabilities | $15,049 | $ —
Vendor financed licenses | 9,667 | 3,551
Royalties payable | 6,107 | 11,318
Accrued interest | 9,212 | 8,407
Other | 36,936 | 38,412
Total other current liabilities | $76,971 | $61,688


Question: What were the royalties payable in 2019?
Answer: 6,107
Profitability Measures
Net Income:
Our net income in the fiscal year ended February 28, 2019 was $18.4 million as compared to net income of $16.6 million in the same period last year. The increase is due to a $11.7 million increase in operating income, $3.0 million increase in investment income and $12.0 million decrease in income tax provision. The increase in operating income was primarily attributable to $21.0 million decrease in general and administrative expense due to reduced legal provision and related costs as further discussed in Note 19 and partially offset by $8.0 million of restructuring expense.
Adjusted EBITDA for Telematics Systems in the fiscal year ended February 28, 2019 decreased $8.1 million compared to the same period last year due to lower revenues as described above and the impact of high margin revenue earned on a strategic technology partnership arrangement in fiscal 2018. These factors were coupled with higher operating expenses in Telematics Systems as a result of increased headcount and outsourced professional service fees. Adjusted EBITDA for Software and Subscription Services increased $4.9 million compared to the same period last year due primarily to continued growth in revenues and gross profit from our Italia market and higher gross profit from our fleet management services.
See Note 20 for reconciliation of Adjusted EBITDA by reportable segments and a reconciliation to GAAP-basis net income (loss).
Table:
 | Fiscal years ended |  |  | 
 | February 28, |  |  | 
(In thousands) | 2019 | 2018 | $ Change | % Change
 | Segment |  |  | 
Telematics Systems | $40,821 | $48,943 | $(8,122) | (17.0%)
Software & Subscription Services | 13,093 | 8,233 | 4,860 | 59.0%
Corporate Expense | (5,699) | (4,794) | (905) | 19.0%
Total Adjusted EBITDA | $48,215 | $52,382 | $(4,167) | (8.0%)


Question: What was the Total Adjusted EBITDA for the fiscal year ended February 28, 2018?
Answer: 52,382
Free cash flow
The Free cash flow for the Industrial Businesses amounted to €8,000 millions, resulting in a cash conversation rate of 0.89.
Beginning with fiscal 2020, Siemens adopts IFRS 16, Leases, applying
the modified retrospective approach as described in more detail in NOTE 2 in B.6 NOTES TO CONSOLIDATED FINANCIAL STATEMENTS. As a result, the shift of lease payments from cash flows from operating activities to cash flows from financing activities will have a positive effect on Free cash flow.
With our ability to generate positive operating cash flows, our total liquidity (defined as cash and cash equivalents plus current interest-bearing debt securities) of €13.7 billion, our unused lines of credit, and our credit ratings at year-end, we believe that we have sufficient flexibility to fund our capital requirements. Also in our opinion, our operating net working capital is sufficient for our present requirements.
Table:
 |  |  | Fiscal Year 2019
(in millions of €) | Continuing operations | Discontinued operations | Continuing and discontinued operations
Cash flows from operating activities | 8,482 | (27) | 8,456
Additions to intangible assets and property, plant and equipment | (2,610) | − | (2,610)
Free cash flow | 5,872 | (27) | 5,845


Question: What is the source for capital funding requirement?
Answer: With our ability to generate positive operating cash flows, our total liquidity (defined as cash and cash equivalents plus current interest-bearing debt securities) of €13.7 billion, our unused lines of credit, and our credit ratings at year-end, we believe that we have sufficient flexibility to fund our capital requirements.
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The following table summarizes long-lived assets by geographic area as of December 31, 2019 and December 31, 2018:
Long-lived assets include property and equipment, operating lease right-of-use assets, goodwill and other intangible assets.
Table:
 | December 31, | 
 | 2019 | 2018
United States | $239,511 | $115,869
Asia | 301,020 | 12,274
Europe | 59,925 | 59,936
Total | $600,456 | $188,079


Question: What is the sum of the highest two long-lived assets in 2018?
Answer: 175805
Calculation: $115,869+59,936
The Corporation’s segment profit (loss) is reported in two operating segments: Canadian broadband services and American broadband services. The reporting structure reflects how the Corporation manages its business activities to make decisions about resources to be allocated to the segments and to assess their performance.
The Canadian and American broadband services segments provide a wide range of Internet, video and telephony services primarily to residential customers as well as business services across their coverage areas. The Canadian broadband services activities are carried out by Cogeco Connexion in the provinces of Québec and Ontario and the American broadband services activities are carried out by Atlantic Broadband in 11 states: Connecticut, Delaware, Florida, Maine, Maryland, New Hampshire, New York, Pennsylvania, South Carolina, Virginia and West Virginia.
The previously reported Business ICT services segment, comprised of the Cogeco Peer 1 operations, is now reported in discontinued operations following the sale on April 30, 2019 of the Cogeco Peer 1 subsidiary. Information about the discontinued segment is provided in Note 8.
The Corporation and its chief operating decision maker assess the performance of each operating segment based on its segment profit (loss), which is equal to revenue less operating expenses. The other expenses, except for management fees, financial expense and income taxes, are reported by segment solely for external reporting purposes.
(1) Revenue by geographic market includes $1,294,967 in Canada and $1,036,853 in the United States. (2) Comprised of restructuring costs within the Canadian broadband services segment and acquisition and integration costs related to the FiberLight network acquisition in the American broadband services segment.
Table:
Year ended August 31, 2019 | Canadian broadband services | American broadband services | Inter-segment eliminations and other | Consolidated
(In thousands of Canadian dollars) | $ | $ | $ | $
Revenue (1) | 1,294,967 | 1,036,853 | — | 2,331,820
Operating expenses | 606,286 | 571,208 | 26,486 | 1,203,980
Management fees – Cogeco Inc. | — | — | 19,900 | 19,900
Segment profit (loss) | 688,681 | 465,645 | (46,386) | 1,107,940
Integration, restructuring and acquisition costs (2) | 9,299 | 1,851 | — | 11,150
Depreciation and amortization | 254,345 | 226,301 | 79 | 480,725
Financial expense |  |  |  | 175,502
Profit before income taxes |  |  |  | 440,563
Income taxes |  |  |  | 83,655
Profit for the year from continuing operations |  |  |  | 356,908
Acquisition of property, plant and equipment | 241,940 | 192,605 | — | 434,545


Question: What is the average Integration, restructuring and acquisition costs from Canadian and American broadband services for year ended August 31, 2019?
Answer: 5575
Calculation: (9,299+1,851) / 2
NOTE 9. ACCOUNTS RECEIVABLE
A significant percentage of our accounts receivable is derived from sales to a limited number of large multinational semiconductor device manufacturers located throughout the world. In order to monitor potential expected credit losses, we perform ongoing credit evaluations of our customers’ financial condition.
The carrying amount of accounts receivable is as follows:
Table:
 | December 31, | 
 | 2018 | 2019
Current | 154,607 | 171,866
Overdue <30 days | 8,802 | 19,977
Overdue 31-60 days | 2,258 | 2,076
Overdue 61-120 days | 3,507 | 1,599
Overdue >120 days | 4,276 | 4,017
Total | 173,450 | 199,535


Question: How does the company monitor potential expected credit losses?
Answer: perform ongoing credit evaluations of our customers’ financial condition