hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Product Revenue by Segment
The following table presents the breakdown of product revenue by segment (in millions, except percentages):
Amounts may not sum and percentages may not recalculate due to rounding.
Americas Product revenue in the Americas segment increased by 8%, driven by growth in the enterprise, public sector and commercial markets. These increases were partially offset by a product revenue decline in the service provider market. From a country perspective, product revenue increased by 9% in the United States, 26% in Mexico and 6% in Canada, partially offset by a product revenue decrease of 1% in Brazil.
EMEA The increase in product revenue in the EMEA segment of 6% was driven by growth in the public sector and enterprise markets, partially offset by a decline in the service provider market. Product revenue in the commercial market was flat. Product revenue from emerging countries within EMEA increased by 9%, and product revenue for the remainder of the EMEA segment increased by 5%.
APJC Product revenue in the APJC segment increased by 1%, driven by growth in the public sector and enterprise markets, partially offset by declines in the service provider and commercial markets. From a country perspective, product revenue increased by 9% in Japan and 5% in India, partially offset by a product revenue decrease of 16% in China.
Table:
 |  | Years Ended |  | 2019 vs. 2018 | 
 | July 27, 2019 | July 28, 2018 | July 29, 2017 | Variance in Dollars | Variance in Percent
Product revenue: |  |  |  |  | 
Americas | $22,754 | $21,088 | $20,487 | $1,666 | 8%
Percentage of product revenue | 58.3% | 57.5% | 57.4% |  | 
EMEA | 10,246 | 9,671 | 9,369 | 575 | 6%
Percentage of product revenue | 26.3% | 26.3% | 26.2% |  | 
APJC | 6,005 | 5,950 | 5,849 | 55 | 1%
Percentage of product revenue | 15.4% | 16.2% | 16.4% |  | 
Total | $39,005 | $36,709 | $35,705 | $2,296 | 6%


Question: What was the product revenue from Americas in 2017?
Answer: 20,487
humana inc . notes to consolidated financial statements 2014 ( continued ) the total intrinsic value of stock options exercised during 2007 was $ 133.9 million , compared with $ 133.7 million during 2006 and $ 57.8 million during 2005 . cash received from stock option exercises for the years ended december 31 , 2007 , 2006 , and 2005 totaled $ 62.7 million , $ 49.2 million , and $ 36.4 million , respectively . total compensation expense related to nonvested options not yet recognized was $ 23.6 million at december 31 , 2007 . we expect to recognize this compensation expense over a weighted average period of approximately 1.6 years . restricted stock awards restricted stock awards are granted with a fair value equal to the market price of our common stock on the date of grant . compensation expense is recorded straight-line over the vesting period , generally three years from the date of grant . the weighted average grant date fair value of our restricted stock awards was $ 63.59 , $ 54.36 , and $ 32.81 for the years ended december 31 , 2007 , 2006 , and 2005 , respectively . activity for our restricted stock awards was as follows for the year ended december 31 , 2007 : shares weighted average grant-date fair value .

Table:
 | shares | weighted average grant-date fair value
nonvested restricted stock at december 31 2006 | 1107455 | $ 45.86
granted | 852353 | 63.59
vested | -51206 ( 51206 ) | 56.93
forfeited | -63624 ( 63624 ) | 49.65
nonvested restricted stock at december 31 2007 | 1844978 | $ 53.61
the fair value of shares vested during the years ended december 31 , 2007 , 2006 , and 2005 was $ 3.4 million , $ 2.3 million , and $ 0.6 million , respectively .
total compensation expense related to nonvested restricted stock awards not yet recognized was $ 44.7 million at december 31 , 2007 .
we expect to recognize this compensation expense over a weighted average period of approximately 1.4 years .
there are no other contractual terms covering restricted stock awards once vested. .

Question: considering the years 2005-2007 , what is the average fair value of shares vested , in millions?
Answer: 2.1
Calculation: add(3.4, 0.6), add(#0, 2.3), divide(#1, const_3)
NOTE 8. INVENTORIES
The changes in the allowance for obsolescence are as follows:
On December 31, 2019, our allowance for inventory obsolescence amounted to €12,527, which is 6.7% of total inventory. The major part of the allowance is related to components and raw materials. The additions for the years 2018 and 2019 mainly relate to inventory items which ceased to be used due to technological developments and design changes which resulted in obsolescence of certain parts.
The cost of inventories recognized as costs and included in cost of sales amounted to €510.2 million (2018: €365.8 million).
Table:
 | December 31, | 
 | 2018 | 2019
Balance at beginning of year | (12,749) | (13,364)
Charged to cost of sales | (2,958) | (4,748)
Reversals | 723 | 915
Utilization of the provision | 1,978 | 4,994
Foreign currency translation effect | (358) | (324)
Balance at end of year | (13,364) | (12,527)


Question: What is the change in reversals from 2018 to 2019?
Answer: 192
Calculation: 915-723
comparison of cumulative return among lkq corporation , the nasdaq stock market ( u.s. ) index and the peer group .

Table:
 | 12/31/2007 | 12/31/2008 | 12/31/2009 | 12/31/2010 | 12/31/2011 | 12/31/2012
lkq corporation | $ 100 | $ 55 | $ 93 | $ 108 | $ 143 | $ 201
nasdaq stock market ( u.s. ) index | $ 100 | $ 59 | $ 86 | $ 100 | $ 98 | $ 114
peer group | $ 100 | $ 83 | $ 100 | $ 139 | $ 187 | $ 210
this stock performance information is "furnished" and shall not be deemed to be "soliciting material" or subject to rule 14a , shall not be deemed "filed" for purposes of section 18 of the securities exchange act of 1934 or otherwise subject to the liabilities of that section , and shall not be deemed incorporated by reference in any filing under the securities act of 1933 or the securities exchange act of 1934 , whether made before or after the date of this report and irrespective of any general incorporation by reference language in any such filing , except to the extent that it specifically incorporates the information by reference .
information about our common stock that may be issued under our equity compensation plans as of december 31 , 2012 included in part iii , item 12 of this annual report on form 10-k is incorporated herein by reference. .

Question: what was the difference in percentage of cumulative return for lkq corporation and the peer group for the five years ended 12/31/2012?
Answer: -9%
Calculation: subtract(201, 100), divide(#0, 100), subtract(210, 100), divide(#2, 100)
The three levels are described below:
Level 1 Inputs – Unadjusted quoted prices in active markets for identical assets or liabilities that is accessible by the Company;
Level 2 Inputs – Quoted prices in markets that are not active or financial instruments for which all significant inputs are observable, either directly or indirectly;
Level 3 Inputs – Unobservable inputs for the asset or liability including significant assumptions of the Company and other market participants.
The carrying amount of the Company’s financial assets and liabilities, such as cash, accounts payable and accrued expenses approximate their fair value because of
the short maturity of those instruments. The carrying amount of the Company’s financial assets and liabilities, such as cash, accounts payable and accrued expenses approximate their fair value because of the short maturity of those instruments.
Transactions involving related parties cannot be presumed to be carried out on an arm’s-length basis, as the requisite conditions of competitive, free-market dealings
may not exist. Representations about transactions with related parties, if made, shall not imply that the related party transactions were consummated on terms equivalent to
those that prevail in arm’s-length transactions unless such representations can be substantiated.
The assets or liability’s fair value measurement within the fair value hierarchy is based upon the lowest level of any input that is significant to the fair value measurement. The following table provides a summary of financial instruments that are measured at fair value as of December 31, 2019.
Table:
 |  | Fair Value Measurement Using |  |  | 
 | Carrying Value | Level 1 | Level 2 | Level 3 | Total
Marketable securities | 0 | 0 | 0 | 0 | 0
Derivative warrants liabilities | $(332,222) | $- | $- | $(332,222) | $(332,222)


Question: What is the difference in Level 1 and Level 2 marketable securities?
Answer: 0
Calculation: 0 -0
Cost of Revenue, Gross Profit, and Gross Margin
Cost of revenue increased $4.9 million, or 3%, in 2019 as compared to 2018. The increase in cost of revenue was primarily due to $12.1 million in increased personnel expenses, stock-based compensation, and overhead costs, $3.9 million in increased content costs, $3.6 million in increased amortization of acquired intangible assets, and $1.6 million in increased capitalized software amortization. These increased costs were partially offset by $16.4 million in decreased external implementation professional service costs. These costs were incurred to service our existing customers and support our continued growth. The improvement in gross margin was primarily due to a higher mix of subscription revenue, which carries a higher gross margin.
Cost of revenue increased $1.5 million, or 1%, in 2018 as compared to 2017. The increase in cost of revenue was primarily due to $6.0 million in increased capitalized software amortization and $4.5 million in increased content costs. These increased costs were partially offset by $6.6 million in decreased amortization of acquired intangible assets and $2.9 million in external implementation service costs. These costs were incurred to service our existing customers and support our continued growth. The improvement in gross margin was primarily due to a higher mix of subscription revenue, which carries a higher gross margin.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (dollars in thousands) | 
Cost of revenue | $149,215 | $144,349 | $142,867
Gross profit | $427,308 | $393,542 | $339,118
Gross margin | 74.1% | 73.2% | 70.4%


Question: What was the cost of revenue in 2019?
Answer: $149,215
Reconciliation of segment EBITDA to total adjusted EBITDA is below:
For additional information on our reportable segments and product and services categories, see Note 17— Segment Information to our consolidated financial statements in Item 8 of Part II of this report.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (Dollars in millions) | 
Adjusted EBITDA |  |  | 
International and Global Accounts | $2,286 | 2,341 | 821
Enterprise | 3,490 | 3,522 | 2,456
Small and Medium Business | 1,870 | 2,013 | 1,581
Wholesale | 3,427 | 3,666 | 2,566
Consumer | 4,914 | 5,105 | 5,136
Total segment EBITDA | $15,987 | 16,647 | 12,560
Operations and Other EBITDA | (7,216) | (8,045) | (6,504)
Total adjusted EBITDA | $8,771 | 8,602 | 6,056


Question: How many segments are there under Adjusted EBITDA?
Answer: 5
Calculation: International and Global Accounts##Enterprise##Small and Medium Business##Wholesale##Consumer
ACQUISITIONS OF PROPERTY, PLANT AND EQUIPMENT
The acquisitions of property, plant and equipment as well as the capital intensity per operating segment are as follows:
(1) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy. For further details, please consult the "Accounting policies" section. (2) Fiscal 2019 actuals are translated at the average foreign exchange rate of the comparable period of fiscal 2018 which was 1.3100 USD/CDN.
Fiscal 2019 fourth-quarter acquisitions of property, plant and equipment decreased by 10.6% (11.2% in constant currency) mainly due to lower capital expenditures in the Canadian and American broadband services segments. Fiscal 2019 fourth-quarter capital intensity reached 24.9% compared to 28.7% for the same period of the prior year mainly as a result of lower capital capital expenditures combined with higher revenue.
Table:
Three months ended August 31, | 2019 | 2018 | Change | Change in constant currency(2)
(in thousands of dollars, except percentages) | $ | $ | % | %
Canadian broadband services | 79,132 | 89,405 | (11.5) | (11.7)
Capital intensity | 24.7% | 28.0% |  | 
American broadband services | 65,967 | 72,914 | (9.5) | (10.5)
Capital intensity | 25.0% | 29.6% |  | 
Consolidated | 145,099 | 162,319 | (10.6) | (11.2)
Capital intensity | 24.9% | 28.7% |  | 


Question: What is the increase/ (decrease) Canadian broadband services from 2018 to 2019?
Answer: -10273
Calculation: 79,132-89,405
The following table summarizes information regarding common stock share awards granted and vested (in thousands, except per share award amounts):
As of December 31, 2019, there was $0.2 million of total unrecognized compensation costs, net of actual forfeitures, related to nonvested common stock share awards. This cost is expected to be recognized over a weighted average period of 0.8 years.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Number of share awards granted | 34 | 34 | 24
Weighted average grant-date fair value per share award | $25.41 | $27.68 | $32.93
Fair value of share awards vested | $840 | $880 | $850


Question: In which year was the Weighted average grant-date fair value per share award the largest?
Answer: 2017
Calculation: $32.93>$27.68>$25.41
22. Income Taxes
Teekay and a majority of its subsidiaries are not subject to income tax in the jurisdictions in which they are incorporated because they do not conduct business or operate in those jurisdictions. However, among others, the Company’s U.K. and Norwegian subsidiaries are subject to income taxes.
The significant components of the Company’s deferred tax assets and liabilities are as follows:
(1) Substantially all of the Company's estimated net operating loss carryforwards of $878.3 million relates primarily to its U.K., Spanish, Norwegian and Luxembourg subsidiaries and, to a lesser extent, to its Australian subsidiaries.
The Company had estimated disallowed finance costs in Spain and Norway of approximately $15.1 million and $15.0 million, respectively, at December 31, 2019, which are available for 18 years and 10 years, respectively, from the year the costs are incurred for offset against future taxable income in Spain and Norway, respectively. The Company's estimated tax losses in Luxembourg are available for offset against taxable future income in Luxembourg, either indefinitely for losses arising prior to 2017, or for 17 years for losses arising subsequent to 2016.
Table:
 | December 31, | December 31,
 | 2019 | 2018
 | $ | $
Deferred tax assets: |  | 
Vessels and equipment | 1,646 | 5,868
Tax losses carried forward and disallowed finance costs (1) | 164,009 | 155,910
Other | 19,674 | 10,545
Total deferred tax assets | 185,329 | 172,323
Deferred tax liabilities: |  | 
Vessels and equipment | 22,913 | 18,037
Provisions | 6,512 | 5,588
Other | — | 2,060
Total deferred tax liabilities | 29,425 | 25,685
Net deferred tax assets | 155,904 | 146,638
Valuation allowance | (153,302) | (144,560)
Net deferred tax assets | 2,602 | 2,078


Question: What is the increase/ (decrease) in Deferred tax assets: Tax losses carried forward and disallowed finance costs from December 31, 2019 to December 31, 2018?
Answer: 8099
Calculation: 164,009-155,910
Supported by a recovery in commodity-related markets, orders and revenue showed broad-based growth year-over-year with strongest increases in the mechanical drives business. Overall, Portfolio Companies businesses made good progress in achieving their targets. Adjusted EBITA improved in all fully consolidated units and turned positive in total, mainly driven by the large drives applications business.
The result from equity investments in total also improved slightly, though it was negative in both periods under review. Severance charges decreased to € 14 million, from € 86 million in fiscal 2018. Portfolio Companies’ order backlog was € 5 billion at the end of the fiscal year, of which € 3 billion are expected to be converted into revenue in fiscal 2020. Regarding Portfolio Companies’ at-equity investments, volatile results are expected in coming quarters.
Markets for Portfolio Companies are generally impacted by rising uncertainties regarding geopolitical and economic developments, which weaken investment sentiment. Although the broad range of businesses are operating in diverse markets, overall, moderate growth is expected in the coming years for the main markets served by the Portfolio Companies.
Beginning with fiscal 2020, the equity investments Ethos Energy Group Limited and Voith Hydro Holding GmbH & Co. KG, the subsea business, and the majority of the process solutions business will be transferred to the Operating Company Gas and Power. If this organizational structure had already existed in fiscal 2019, Portfolio Companies would have posted orders of € 4.746 billion, revenue of € 4.558 billion and Adjusted EBITA of €(115) million.
Mitsubishi-Hitachi Metals Machinery (MHMM) and Siemens AG reached an agreement in September 2019, that MHMM will acquire Siemens’ stake in Primetals Technologies. Closing of the transaction is subject to customary conditions and is expected by the beginning of calendar 2020.
Table:
 |  | Fiscal year |  | % Change
(in millions of €) | 2019 | 2018 | Actual | Comp.
Orders | 5,806 | 5,569 | 4 % | 3 %
Revenue | 5,526 | 4,930 | 12 % | 11 %
Adjusted EBITA | (71) | (305) | 77 % | 
Adjusted EBITA margin | (1.3) % | (6.2) % |  | 


Question: If the new organizational structure had already existed in fiscal 2019, Smart Infrastructure would have posted what revenue in 2019? 
Answer: 4.558 billion
Stock purchase warrants
Prior to the 2019 Brookfield Transaction, Teekay held 15.5 million common unit warrants (or the Brookfield Transaction Warrants) issued by Altera to Teekay in connection with the 2017 Brookfield Transaction (see Note 4) and 1,755,000 warrants to purchase common units of Altera issued to Teekay in connection with Altera's private placement of Series D Preferred Units in June 2016 (or the Series D Warrants). In May 2019, Teekay sold to Brookfield all of the Company’s remaining interests in Altera, which included, among other things, both the Brookfield Transaction Warrants and Series D Warrants.
Changes in fair value during the years ended December 31, 2019 and 2018 for the Company’s Brookfield Transaction Warrants and the Series D Warrants, which were measured at fair value using significant unobservable inputs (Level 3), are as follows:
Table:
 | Year Ended December 31, | 
 | 2019 | 2018
 | $ | $
Fair value at the beginning of the year | 12,026 | 30,749
Fair value on acquisition/issuance | — | 2,330
Unrealized gain (loss) included in earnings | 26,900 | (21,053)
Realized loss included in earnings | (25,559) | —
Settlements | (13,367) | —
Fair value at the end of the year | — | 12,026


Question: What was the Fair value at the beginning of the year for 2019 and 2018?
Answer: 12,026, 30,749
Receivables (payables): The balances with Golar Partners and subsidiaries as of December 31, 2019 and 2018 consisted of the following:
(iii) Interest income on short-term loan, balances due(to)/from Golar Partners and its subsidiaries - Receivables and payables with Golar Partners and its subsidiaries comprise primarily of unpaid management fees and expenses for management, advisory and administrative services, dividends in respect of the Hilli Common Units and other related party arrangements including the Hilli Disposal. In addition, certain receivables and payables arise when we pay an invoice on behalf of a related party and vice versa. Receivables and payables are generally settled quarterly in arrears. Balances owing to or due from Golar Partners and its subsidiaries are unsecured, interest-free and intended to be settled in the ordinary course of business. In November 2019, we loaned $15.0 million to Golar Partners, with interest of LIBOR plus 5.0%. The loan was fully repaid, including interest of $0.1 million, in December 2019.
(vii) Methane Princess lease security deposit movements - This represents net advances from Golar Partners since its IPO, which correspond with the net release of funds from the security deposits held relating to a lease for the Methane Princess. This is in connection with the Methane Princess tax lease indemnity provided to Golar Partners under the Omnibus Agreement. Accordingly, these amounts will be settled as part of the eventual termination of the Methane Princess lease.
Table:
(in thousands of $) | 2019 | 2018
Balances due (to)/from Golar Partners and its subsidiaries (iii) | (2,708) | 4,091
Methane Princess lease security deposit movements (vii) | (2,253) | (2,835)
Total | (4,961) | 1,256


Question: What was the change in Methane Princess lease security deposit movements between 2018 and 2019?
Answer: 582
Calculation: (2,253) - (2,835)
Total Other (Income) Expense, Net
Total other income for the year ended December 31, 2019 was $6.6 million compared to $0.5 million of other expense for the year ended December 31,
2018. Interest income increased due to interest earned on investing our public offering cash proceeds. Interest expense decreased due to having no outstanding borrowings during the year ended December 31, 2019. We discuss borrowings under “Liquidity and Capital Resources” below. Other (income) expense, net was $0.9 million other income in the year ended December 31, 2019 compared to $0.6 million of other income in the year ended December 31, 2018, primarily due to our earnout liabilities. We estimate the fair value of earnout liabilities related to business combinations quarterly. During the year ended December 31, 2019, the adjustments to fair value decreased the carrying value of the earnout liability for our acquisition of Indix, resulting in other income of $1.7 million, partially offset by an increase in the carrying value of the earnout liabilities for our acquisitions of Compli and Portway, which resulted in other expense of $0.6 million. The fair value of the Indix acquisition earnout liability decreased at December 31, 2019, from the fair value at acquisition in February 2019, due primarily to the last three earnout milestones, which are nonfinancial, being more difficult to complete within the required timeframe than initially assessed. During the year ended December 31, 2018, the adjustments to fair value decreased the carrying value of the earnout liabilities for prior acquisitions, resulting in other income of $0.4 million.
Table:
 |  | For the Year Ended December 31, |  |  |  | 
 |  | 2019 |  | 2018 | $ Change | 
 | As reported (ASC 606) | Impacts from Adoption | Without Adoption (ASC 605) | As Reported (ASC 605) | As Reported | Without Adoption
 |  | (dollars in thousands) |  |  |  | 
Other (income) expense, net |  |  |  |  |  | 
Interest income | $(6,037) | $ - | $(6,037) | $(1,553) | $(4,484) | $(4,484)
Interest expense | 289 | - | 289 | 2,608 | (2,319) | (2,319)
Other (income) expense, net | (865) | - | (865) | (583) | (282) | (282)
Total other (income) expense, net | $(6,613) | $ - | $(6,613) | $472 | $(7,085) | $(7,085)


Question: What are the net other (income) expense for the years ended December 31, 2019 and 2018 respectively?
Answer: $0.9 million, $0.6 million