hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Item 6. Selected Financial Data
The following selected data is derived from our Consolidated Financial Statements. This data should be read in conjunction with the Consolidated Financial Statements and notes thereto incorporated into Item 8, “Financial Statements and Supplementary Data” and with Item 7, “Management’s Discussion and Analysis of Financial Condition and Results of Operations.”
(2) Working capital is defined as current assets minus current liabilities.
Table:
 |  |  | August 31, |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
 |  |  | (in thousands) |  | 
Consolidated Balance Sheets Data: |  |  |  |  | 
Working capital(2) | $(187,020) | $319,050 | $(243,910) | $280,325 | $191,168
Total assets | $12,970,475 | $12,045,641 | $11,095,995 | $10,322,677 | $9,591,600
Current installments of notes payable and long-term debt | $375,181 | $25,197 | $444,255 | $44,689 | $321,964
Notes payable and long-term debt, less current installments | $2,121,284 | $2,493,502 | $1,606,017 | $2,046,655 | $1,308,663
Total Jabil Inc. stockholders’ equity | $1,887,443 | $1,950,257 | $2,353,514 | $2,438,171 | $2,314,856
Common stock shares outstanding | 153,520 | 164,588 | 177,728 | 186,998 | 192,068


Question: What was the percentage change in Total Jabil Inc. stockholders’ equity between 2018 and 2019?
Answer: -3.22
Calculation: (1,887,443-1,950,257)/1,950,257
European revenue decreased by 1.9%. Foreign exchange movements contributed a 0.8 percentage point negative impact and the deconsolidation of Vodafone Netherlands contributed a 4.1 percentage point negative impact, offset by 3.0% organic growth. Service revenue increased by 0.9%* or 0.6%* excluding a legal settlement in Germany in Q4, driven by strong fixed customer growth and the benefit of the Group’s “more-for-more” mobile propositions in several markets, which offset increased regulatory headwinds following the implementation of the EU’s “Roam Like At Home” policy in June and the impact of the introduction of handset financing in the UK. Excluding regulation and UK handset financing, as well as a legal settlement in Germany in Q4, service revenue growth was 2.0%* (Q3: 1.9%*, Q4: 1.7%*).
Adjusted EBITDA increased 7.3%, including a 5.1 percentage point negative impact from the deconsolidation of Vodafone Netherlands and a 0.6 percentage point negative impact from foreign exchange movements. On an organic basis, adjusted EBITDA increased 13.0%*, supported by the benefit of the introduction of handset financing in the UK, regulatory settlements in the UK and a legal settlement in Germany. Excluding these items, as well as the net impact of roaming, adjusted EBITDA grew by 7.9*, reflecting operating leverage and tight cost control through our “Fit for Growth” programme.
Adjusted EBIT increased by 86.3%*, reflecting strong adjusted EBITDA growth and stable depreciation and amortisation expenses.
Table:
 | Reported change | Other activity (including M&A) | Foreign exchange | Organic* change
 | % | pps | pps | %
Revenue – Europe | (1.9) | 4.1 | 0.8 | 3.0
Service revenue |  |  |  | 
Germany | 2.6 | – | – | 2.6
Italy | 1.0 | 0.2 | – | 1.2
UK | (8.1) | 0.1 | 4.5 | (3.5)
Spain | 1.8 | 0.3 | – | 2.1
Other Europe | (19.6) | 22.9 | (0.4) | 2.9
Europe | (3.9) | 4.0 | 0.8 | 0.9
Adjusted EBITDA |  |  |  | 
Germany | 10.9 | (0.1) | (0.1) | 10.7
Italy | 4.5 | 0.1 | – | 4.6
UK | 45.4 | (1.2) | 7. 6 | 51.8
Spain | 4.4 | 0.6 | – | 5.0
Other Europe | (18.8) | 26.8 | (0.3) | 7.7
Europe | 7.3 | 5.1 | 0.6 | 13.0
Europe adjusted operating profit | 53.2 | 34.8 | (1.7) | 86.3


Question: How many percent of organic change in Europe adjusted operating profit is the organic change in Italy EBITDA?
Answer: 5.33
Calculation: 4.6/86.3
GasLog Ltd. and its Subsidiaries
Notes to the consolidated financial statements (Continued)
For the years ended December 31, 2017, 2018 and 2019
(All amounts expressed in thousands of U.S. Dollars, except share and per share data)
7. Leases (Continued)
On February 24, 2016, GasLog’s subsidiary, GAS-twenty six Ltd., completed the sale and leaseback of the Methane Julia Louise with a subsidiary of Mitsui. Mitsui has the right to on-sell and lease back the vessel. The vessel was sold to Mitsui for a cash consideration of $217,000. GasLog leased back the vessel under a bareboat charter from Mitsui for a period of up to 20 years. GasLog has the option to repurchase the vessel on pre-agreed terms no earlier than the end of year ten and no later than the end of year 17 of the bareboat charter. The bareboat hire is fixed and GasLog had a holiday period for the first 210 days, which expired on September 21, 2016. This leaseback meets the definition of a finance lease under IAS 17 Leases.
The movements in right-of use assets are reported in the following table:
*The balance as of December 31, 2018 represented the vessel held under finance lease and was included in the financial statement line ‘‘Vessel held under finance lease’’, which was renamed to ‘‘Right-of-use assets’’ as of January 1, 2019.
Table:
Right-of-Use Assets | Vessel | Vessel Equipment | Properties | Other | Total
As of January 1, 2019 | 206,753(*) | 2,630 | 4,969 | 19 | 214,371
Additions | 1,001 | 336 | 1,080 | 47 | 2,464
Depreciation expense | (7,722) | (1,109) | (1,499) | (10) | (10,340)
As of December 31, 2019 | 200,032 | 1,857 | 4,550 | 56 | 206,495


Question: Which company was the vessel sold to?
Answer: Mitsui
NOTE 19 – DERIVATIVE FINANCIAL INSTRUMENTS
Please refer to note 21 “Financial Instruments” for further information on fair value hierarchies.
Table:
USDm | 2019 | 2018
Fair value of derivatives: |  | 
Derivative financial instruments regarding freight and bunkers: |  | 
Forward freight agreements | -0.3 | 0.5
Bunker swaps | - | -1.2
Derivative financial instruments regarding interest and currency exchange rate: |  | 
Forward exchange contracts | -0.4 | -1.8
Interest rate swaps | -11.1 | 2.8
Fair value of derivatives as of 31 December | -11.8 | 0.3


Question: What information is provided in Note 21?
Answer: further information on fair value hierarchies.
Performance-Based Restricted Stock Units
PRSU activity is summarized as follows (shares in thousands):
1 Assumes maximum achievement of the specified financial targets.
The weighted-average grant date fair value of PRSUs granted during the years ended December 31, 2019, 2018, and 2017 was $56.74, $40.53, and $41.73, respectively.
Unrecognized compensation expense related to unvested PRSUs was $16.9 million at December 31, 2019, which is expected to be recognized over a weighted-average period of 1.7 years.
Table:
 | Number of Shares | Weighted- Average Grant Date Fair Value
Unvested shares at December 31, 2018 | 1,924 | $40.81
Granted | 390 | 56.74
Forfeited | (562) | 41.29
Vested | — | —
Unvested shares at December 31, 2019 1 | 1,752 | $44.21


Question: What was the unrecognized compensation expense related to unvested PRSUs in 2019?
Answer: $16.9 million
2019 Compared to 2018
Net Sales. Net sales increased 9%, or $651 million, in 2019 compared to 2018. Net sales of products (hardware and software) increased 8% and net sales of services increased 20% in 2019 compared to 2018. Our net sales by operating segment for 2019 and 2018 were as follows (dollars in thousands):
Table:
 | 2019 | 2018 | %Change
NorthAmerica | $6,024,305 | $5,362,981 | 12%
EMEA | 1,526,644 | 1,530,241 | —
APAC | 180,241 | 186,914 | (4%)
Consolidated | $7,731,190 | $7,080,136 | 9%


Question: How much did Net sales of products (hardware and software) increased in 2019 compared to 2018?
Answer: 8%
the graph below matches cadence design systems , inc . 2019s cumulative 5-year total shareholder return on common stock with the cumulative total returns of the s&p 500 index , the s&p information technology index , and the nasdaq composite index . the graph assumes that the value of the investment in our common stock , and in each index ( including reinvestment of dividends ) was $ 100 on december 28 , 2002 and tracks it through december 29 , 2007 . comparison of 5 year cumulative total return* among cadence design systems , inc. , the s&p 500 index , the nasdaq composite index and the s&p information technology index 12/29/0712/30/0612/31/051/1/051/3/0412/28/02 cadence design systems , inc . nasdaq composite s & p information technology s & p 500 * $ 100 invested on 12/28/02 in stock or on 12/31/02 in index-including reinvestment of dividends . indexes calculated on month-end basis . copyright b7 2007 , standard & poor 2019s , a division of the mcgraw-hill companies , inc . all rights reserved . www.researchdatagroup.com/s&p.htm .

Table:
 | 12/28/02 | 1/3/04 | 1/1/05 | 12/31/05 | 12/30/06 | 12/29/07
cadence design systems inc . | 100.00 | 149.92 | 113.38 | 138.92 | 147.04 | 139.82
s & p 500 | 100.00 | 128.68 | 142.69 | 149.70 | 173.34 | 182.87
nasdaq composite | 100.00 | 149.75 | 164.64 | 168.60 | 187.83 | 205.22
s & p information technology | 100.00 | 147.23 | 150.99 | 152.49 | 165.32 | 192.28
the stock price performance included in this graph is not necessarily indicative of future stock price performance .

Question: what is the roi of an investment in s&p500 from 2006 to 2007?
Answer: 5.5%
Calculation: subtract(182.87, 173.34), divide(#0, 173.34)
Stock-Based Compensation
The Company recognizes stock-based compensation expense in the consolidated statements of operations, based on the department to which the related employee reports, as follows: The Company recognizes stock-based compensation expense in the consolidated statements of operations, based on the department to which the related employee reports, as follows:
The total unrecognized compensation cost related to performance-based restricted stock units as of December 31, 2019 was $3.6 million, and the weighted average period over which these equity awards are expected to vest is 1.6 years. The total unrecognized compensation cost related to unvested stock options as of December 31, 2019 was $2.0 million, and the weighted average period over which these equity awards are expected to vest is 2.30 years.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (in thousands) | 
Cost of net revenue | $577 | $489 | $332
Research and development | 16,545 | 17,953 | 16,190
Selling, general and administrative | 14,938 | 13,279 | 11,016
Restructuring expense | — | — | 5,130
 | $32,060 | $31,721 | $32,668


Question: What was the average Research and development between 2017-2019?
Answer: 16896
Calculation: (16,545 + 17,953 + 16,190) / 3
Net revenue: Net revenue from our Energy segment for the year ended December 31, 2019 increased $18.3 million to $39.0 million from $20.7 million for the year ended December 31, 2018. The increase was primarily driven by the AFTC related to the 2018 and 2019 CNG sales that was recognized in the fourth quarter of 2019, inclusive of prior period AFTC at the acquired ampCNG stations which was also recognized in 2019. The increase was also driven by higher volume-related revenues from the recent acquisition of the ampCNG stations and growth in CNG sales volumes.
Cost of revenue: Cost of revenue from our Energy segment for the year ended December 31, 2019 increased $5.9 million to $17.1 million from $11.2 million for the year ended December 31, 2018. The increase was due to overall growth in volumes of gasoline gallons delivered and higher commodity and utility costs driven by the acquisition of ampCNG stations.
Selling, general and administrative: Selling, general and administrative expenses from our Energy segment for the year ended December 31, 2019 increased $0.9 million to $4.9 million from $4.0 million for the year ended December 31, 2018. The increase was driven by an increase in salaries and benefits largely due to the of the acquisition of ampCNG stations, which were acquired late in the second quarter of 2019, partially offset by a one-time expense in the prior year related to the abandonment of a station development project.
Depreciation and amortization from our Energy segment for the year ended December 31, 2019 increased $1.4 million to $6.9 million from $5.5 million for the year ended December 31, 2018. The increase was due to additional depreciation and amortization from the recent acquisition of ampCNG stations.
Other operating expense from our Energy segment was a loss of $0.5 million for the year ended December 31, 2018, driven by impairment of certain stations during the fourth quarter of 2018.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | Increase / (Decrease)
Net revenue | $39.0 | $20.7 | $18.3
Cost of revenue | 17.1 | 11.2 | 5.9
Selling, general and administrative | 4.9 | 4.0 | 0.9
Depreciation and amortization | 6.9 | 5.5 | 1.4
Other operating expense | — | 0.5 | (0.5)
Income (loss) from operations | 10.1 | $(0.5) | $10.6


Question: What was the net revenue for the year ended December 31, 2018?
Answer: $20.7 million
Reporting Channels and Whistleblower Protection
To ensure that our conduct meets relevant legal requirements and the highest ethical standards under the Ethics Code, TSMC provides multiple channels for reporting business conduct concerns.
First of all, our Audit Committee approved and we have implemented the “Complaint Policy and Procedures for Certain Accounting and Legal Matters” and “Procedures for Ombudsman System” that allow employees or any whistleblowers with relevant evidence to report any financial, legal, or ethical irregularities anonymously through either the Ombudsman or directly to the Audit Committee.
TSMC maintains additional internal reporting channels for our employees. To foster an open culture of ethics compliance, we encourage our employees and the third parties we do business with to report any suspected noncompliance with law or relevant TSMC policy.
TSMC treats any complaint and the investigation thereof in a confidential and sensitive manner, and strictly prohibits any form of retaliation against any individual who in good faith reports or helps with the investigation of any complaint. Due to the open reporting channels, TSMC receives reports on various issues from employees and external parties such as our customers and suppliers from time to time. Below is a summary of the Number of Reported Incidents.
Note 1: Among the 205 cases, 132 were related to employee relationship, 47 cases related to other matters (e.g. employee’s individual interest or private matters), and 26 cases related to ethical matters.
Note 2: One case involved an employee who requested a supplier to reserve a hotel and pay advance accommodation fees during his business trip, actions which violate TSMC policy, and the employee was disciplined. Another case involved an employee who abused his work relationship by requesting a supplier to make a personal loan to the employee, a severe violation of our Ethics Code, and the employee was terminated.
Note 3: After the investigation by TSMC’s Sexual Harassment Investigation Committee, four employees involved in confirmed cases of sexual harassment received severe discipline from the Company.
Table:
Year | FY 2016 | FY 2017 | FY 2018 | FY 2019
Total reported cases | 116 | 113 | 150 | 205 (Note 1)
Ethics-related cases | 16 | 20 | 14 | 26
Cases investigated and verified as ethics violations | 2 | 4 | 1 | 2 (Note 2)
Sexual Harassment Investigation Committees Formed | 5 | 7 | 3 | 4
Cases investigated and verified as violations | 5 | 3 | 3 | 4 (Note 3)


Question: What was the total reported cases in FY 16?
Answer: 116
Valuation and Qualifying Accounts
Following is our schedule of valuation and qualifying accounts for the last three years (in thousands):
(1) Amounts under “Other” represent the reserves and valuation allowance assumed in acquisition of LoJack.
The warranty reserve is included in the Other Current Liabilities in the consolidated balance sheets.
(2) Amount under “Other” represents the valuation allowance previously netted against deferred tax assets of foreign net deferred tax assets not recorded on the balance sheet, which were disclosed narratively in the fiscal 2018 Form 10-K (see Note 12). Deferred tax assets and valuation allowances were grossed up by $15.1 million.
Table:
 |  | Charged |  |  | 
 |  | (credited) |  |  | 
 | Balance at | to costs |  |  | Balance at
 | beginning | and |  |  | end of
 | of year | expenses | Deductions | Other | year
Allowance for doubtful accounts: |  |  |  |  | 
Fiscal 2017 | 622 | 541 | (201) | - | 962
Fiscal 2018 | 962 | 685 | (461) | - | 1,186
Fiscal 2019 | 1,186 | 1,230 | (660) |  | 1,756
Warranty reserve: |  |  |  |  | 
Fiscal 2017 (1) | 1,892 | 1,305 | (2,562) | 5,883 | 6,518
Fiscal 2018 | 6,518 | 1,331 | (2,115) | - | 5,734
Fiscal 2019 | 5,734 | 1,126 | (5,462) |  | 1,398
Deferred tax assets valuation allowance: |  |  |  |  | 
Fiscal 2017 (1) | 1,618 | 1,391 | - | 3,578 | 6,587
Fiscal 2018 (2) | 6,587 | - | (4,835) | 15,092 | 16,844
Fiscal 2019 | 16,844 | 799 | (6,714) | - | 10,929


Question: What was the allowance for doubtful accounts balance at the beginning of fiscal year 2019?
Answer: 1,186
Note 3 – Inventories, net
Inventories consisted of the following:
Table:
 |  | December 31,
 | 2019 | 2018
Ingredients | $ 1,942 | $ 1,580
Packaging | 2,230 | 2,072
Finished goods | 2,220 | 2,165
Total inventories, net | $ 6,392 | $ 5,817


Question: What is the value of ingredients in 2019?
Answer: 1,942
Summarized financial information of Hilli LLC
The most significant impacts of Hilli LLC VIE's operations on our consolidated statements of income and consolidated statements of cash flows, as of December 31, 2019 and 2018, are as follows:
Table:
(in thousands of $) | 2019 | 2018
Statement of income |  | 
Liquefaction services revenue | 218,096 | 127,625
Realized and unrealized (losses)/gains on the oil derivative instrument | (26,001) | 16,767
Statement of cash flows |  | 
Net debt repayments | (243,513) | (30,300)
Net debt receipts | 129,454 | —


Question: In which years was the financial information recorded for?
Answer: 2019, 2018
P. Income Taxes
The domestic and foreign components of income before income tax for the periods presented were as follows (table in millions):
Table:
 |  | For the Year Ended | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Domestic | $895 | $680 | $462
Foreign | 543 | 1,149 | 1,115
Total income before income tax | $1,438 | $1,829 | $1,577


Question: What was the foreign income in 2018?
Answer: 1,115
NOTE 8—OTHER ASSETS
Deposits and restricted cash primarily relate to security deposits provided to landlords in accordance with facility lease agreements and cash restricted per the terms of certain contractual-based agreements.
Deferred implementation costs relate to direct and relevant costs on implementation of long-term contracts, to the extent such costs can be recovered through guaranteed contract revenues. As a result of the adoption of Topic 606, deferred implementation costs are no longer capitalized, but rather expensed as incurred as these costs do not relate to future performance obligations. Accordingly, these costs were adjusted through opening retained earnings as of July 1, 2018 (see note 3 "Revenues").
Capitalized costs to obtain a contract relate to incremental costs of obtaining a contract, such as sales commissions, which are eligible for capitalization on contracts to the extent that such costs are expected to be recovered (see note 3 "Revenues").
Investments relate to certain non-marketable equity securities in which we are a limited partner. Our interests in each of these investees range from 4% to below 20%. These investments are accounted for using the equity method. Our share of net income or losses based on our interest in these investments is recorded as a component of other income (expense), net in our Consolidated Statements of Income. During the year ended June 30, 2019, our share of income (loss) from these investments was $13.7 million (year ended June 30, 2018 and 2017 — $6.0 million and $6.0 million, respectively).
Long-term prepaid expenses and other long-term assets includes advance payments on long-term licenses that are being amortized over the applicable terms of the licenses and other miscellaneous assets.
Table:
 | As of June 30, 2019 | As of June 30, 2018
Deposits and restricted cash | $13,671 | $9,479
Deferred implementation costs | — | 13,740
Capitalized costs to obtain a contract | 35,593 | 13,027
Investments | 67,002 | 49,635
Long-term prepaid expenses and other long-term assets | 32,711 | 25,386
Total | $148,977 | $111,267


Question: As of June 30, 2019, what is the Investment cost expressed as a percentage of total costs?
Answer: 44.97
Calculation: 67,002/148,977
In connection with the asset-backed securitization programs, the Company recognized the following (in millions):
(1) The amounts primarily represent proceeds from collections reinvested in revolving-period transfers.
(2) Recorded to other expense within the Consolidated Statements of Operations.
(3) Excludes $650.3 million of trade accounts receivable sold, $488.1 million of cash and $13.9 million of net cash received prior to the amendment of the foreign asset-backed securitization program and under the previous North American asset-backed securitization program.
The asset-backed securitization programs require compliance with several covenants. The North American asset-backed securitization program covenants include compliance with the interest ratio and debt to EBITDA ratio of the five-year unsecured credit facility amended as of November 8, 2017 (“the 2017 Credit Facility”). The foreign asset-backed securitization program covenants include limitations on certain corporate actions such as mergers and consolidations. As of August 31, 2019 and 2018, the Company was in compliance with all covenants under the asset-backed securitization programs.
Table:
 |  | Fiscal Year Ended August 31, | 
 | 2019(3) | 2018 | 2017
Trade accounts receivable sold | $4,057 | $8,386 | $8,878
Cash proceeds received(1) | $4,031 | $7,838 | $8,300
Pre-tax losses on sale of receivables(2) | $26 | $15 | $9
Deferred purchase price receivables as of August 31 | $— | $533 | $569


Question: What were the cash proceeds received in 2019?
Answer: $4,031
The following table summarizes our purchase commitments with contract manufacturers and suppliers as of the respective period ends (in millions):
Purchase commitments with contract manufacturers and suppliers decreased by approximately 23% compared to the end of fiscal 2018. On a combined basis, inventories and purchase commitments with contract manufacturers and suppliers decreased by 24% compared with the end of fiscal 2018.
Inventory and supply chain management remain areas of focus as we balance the need to maintain supply chain flexibility to help ensure competitive lead times with the risk of inventory obsolescence because of rapidly changing technology and customer requirements. We believe the amount of our inventory and purchase commitments is appropriate for our revenue levels.
Table:
Commitments by Period | July 27, 2019 | July 28, 2018
Less than 1 year | $4,239 | $5,407
1 to 3 years | 728 | 710
3 to 5 years | — | 360
Total | $4,967 | $6,477


Question: How many years did commitments that were 1 to 3 years exceed $700 million?
Answer: 2
Calculation: 2019##2018