hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Foreign Currencies
As a multinational business, the Company's transactions are denominated in a variety of currencies. When appropriate, the Company uses forward foreign currency contracts to reduce its overall exposure to the effects of currency fluctuations on its results of operations and cash flows. The Company's policy prohibits trading in currencies for which there are no underlying exposures and entering into trades for any currency to intentionally increase the underlying exposure.
The Company primarily hedges existing assets and liabilities associated with transactions currently on its balance sheet, which are undesignated hedges for accounting purposes.
As of December 31, 2019 and 2018, the Company had net outstanding foreign exchange contracts with net notional amounts of $183.3 million and $157.3 million, respectively. Such contracts were obtained through financial institutions and were scheduled to mature within one to three months from the time of purchase.
Management believes that these financial instruments should not subject the Company to increased risks from foreign exchange movements because gains and losses on these contracts should offset losses and gains on the underlying assets, liabilities and transactions to which they are related.
The following schedule summarizes the Company's net foreign exchange positions in U.S. dollars (in millions):
Amounts receivable or payable under the contracts are included in other current assets or accrued expenses in the accompanying Consolidated Balance Sheets. For the years ended December 31, 2019, 2018 and 2017, realized and unrealized foreign currency transactions totaled a loss of $5.0 million, $8.0 million and $6.3 million, respectively. The realized and unrealized foreign currency transactions are included in other income and expenses in the Company's Consolidated Statements of Operations and Comprehensive Income.
Table:
 |  | As of December 31, |  | 
 | 2019 |  | 2018 | 
 | Buy (Sell) | Notional Amount | Buy (Sell) |  Notional Amount
Japanese Yen | $49.8 | $49.8 | $29.9 | $29.9
Philippine Peso | 36.4 | 36.4 | 30.1 | 30.1
Malaysian Ringgit | 20.4 | 20.4 | — | —
Chinese Yuan | 20.2 | 20.2 | 20.4 | 20.4
Korean Won | 18.1 | 18.1 | 20.8 | 20.8
Czech Koruna | 11.9 | 11.9 | 9.2 | 9.2
Euro | — | — | 13.1 | 13.1
Other currencies - Buy | 21.9 | 21.9 | 26.3 | 26.3
Other currencies - Sell | (4.6) | 4.6 | (7.5) | 7.5
 | $174.1 | $183.3 | $142.3 | $157.3


Question: How much was the loss of realized and unrealized foreign currency transactions for the years ended December 31, 2019, 2018 and 2017 respectively?
Answer: $5.0 million, $8.0 million, $6.3 million
note 9 2014goodwill and other intangibles , net goodwill the following table outlines the activity in the carrying value of the company 2019s goodwill , which is all assigned to the company 2019s trading and investing segment ( dollars in thousands ) : .

Table:
 | trading & investing
balance at december 31 2011 | $ 1934232
activity | 2014
balance at december 31 2012 | 1934232
impairment of goodwill | -142423 ( 142423 )
balance at december 31 2013 | $ 1791809
goodwill is evaluated for impairment on an annual basis and when events or changes indicate the carrying value of an asset exceeds its fair value and the loss may not be recoverable .
at december 31 , 2013 and 2012 , the company 2019s trading and investing segment had two reporting units ; market making and retail brokerage .
at the end of june 2013 , the company decided to exit its market making business .
based on this decision in the second quarter of 2013 , the company conducted an interim goodwill impairment test for the market making reporting unit , using the expected sale structure of the market making business .
this structure assumed a shorter period of cash flows related to an order flow arrangement , compared to prior estimates of fair value .
based on the results of the first step of the goodwill impairment test , the company determined that the carrying value of the market making reporting unit , including goodwill , exceeded the fair value for that reporting unit as of june 30 , 2013 .
the company proceeded to the second step of the goodwill impairment test to measure the amount of goodwill impairment .
as a result of the evaluation , it was determined that the entire carrying amount of goodwill allocated to the market making reporting unit was impaired , and the company recognized a $ 142.4 million impairment of goodwill during the second quarter of 2013 .
for the year ended december 31 , 2013 , the company performed its annual goodwill assessment for the retail brokerage reporting unit , electing to qualitatively assess whether it was more likely than not that the fair value was less than the carrying value .
as a result of this assessment , the company determined that the first step of the goodwill impairment test was not necessary , and concluded that goodwill was not impaired at december 31 , 2013 .
at december 31 , 2013 , goodwill is net of accumulated impairment losses of $ 142.4 million related to the trading and investing segment and $ 101.2 million in the balance sheet management segment .
at december 31 , 2012 , goodwill is net of accumulated impairment losses of $ 101.2 million in the balance sheet management segment. .

Question: what was the percentage change in carrying value of the company 2019s goodwill between 2012 and 2013?
Answer: -7%
Calculation: divide(-142423, 1934232)
Non-Operating Income, net: Non-operating income, net consists primarily of interest income, net foreign currency exchange losses, the noncontrolling interests in the net profits of our majority-owned subsidiaries (primarily Oracle Financial Services Software Limited and Oracle Corporation Japan) and net other income, including net recognized gains and losses related to all of our investments, net unrealized gains and losses related to the small portion of our investment portfolio related to our deferred compensation plan, net unrealized gains and losses related to certain equity securities and non-service net periodic pension income (losses).
On a constant currency basis, our non-operating income, net decreased in fiscal 2019 compared to fiscal 2018 primarily due to decreases in other income, net in fiscal 2019 , which was primarily attributable to realized gains on the sale of certa in marketable securities during fiscal 2018 , and lower interest income in fiscal 2019 primarily due to lower average cash, cash equivalent and marketable securities balances during fiscal 2019 .
Table:
 |  |  | Year Ended May 31, | 
 |  |  | Percent Change | 
(Dollars in millions) | 2019 | Actual | Constant | 2018
Interest income | $1,092 | -9% | -9% | $1,203
Foreign currency losses, net | (111) | 50% | 62% | (74)
Noncontrolling interests in income | (152) | 12% | 12% | (135)
Other income, net | (14) | -107% | -42% | 191
Total non-operating income, net | $815 | -31% | -31% | $1,185


Question: What are two of Oracle's majority-owned subsidiaries?
Answer: Oracle Financial Services Software Limited and Oracle Corporation Japan
The following direct customers accounted for 10% or more of our net revenues in one or more of the following periods:
Nokia was our largest customer in fiscal 2019, 2018 and 2017. Nokia purchases products directly from us and through contract manufacturers and distributors. Based on information provided to us by its contract manufacturers and our distributors, purchases by Nokia represented approximately 45%, 36% and 41% of our net revenues in fiscal 2019, 2018 and 2017, respectively. To our knowledge, none of our other OEM customers accounted for more than 10% of our net revenues in any of these periods.
Table:
 |  | Fiscal Year Ended | 
 |  | March 31, | 
 | 2019 | 2018 | 2017
Contract manufacturers and consignment warehouses:        |  |  | 
Flextronics Technology | 21.8% | 14.0% | 10.4%
Sanmina | 17.7 | 16.0 | 20.4
Distributors:        |  |  | 
Avnet Logistics | 31.3 | 35.3 | 25.5
Nexcomm  | 14.8 | 16.1 | 19.7


Question: What was the percentage of purchases made by Nokia in 2019, 2018 and 2017 respectively?
Answer: 45%, 36%, 41%
COHERENT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In thousands)
(1) Reclassification adjustments were not significant during fiscal 2019, 2018 and 2017.
(2) Tax benefits of $(5,161), $0 and $(326) were provided on translation adjustments during fiscal 2019, 2018 and 2017, respectively.
(3) Tax benefits of $0, $(2) and $(1,876) were provided on changes in unrealized losses on available-for-sale securities during fiscal 2019, 2018 and 2017, respectively.
(4) Tax expenses (benefits) of $(2,371), $202 and $1,747 were provided on changes in defined benefit pension plans during fiscal 2019, 2018 and 2017, respectively.
Table:
 |  | Year Ended | 
 | September 28,2019 | September 29,2018 | September 30,2017
Net income | $53,825 | $247,358 | $207,122
Other comprehensive income (loss):(1) |  |  | 
Translation adjustment, net of taxes(2) | (32,609) | (18,065) | 24,923
Changes in unrealized losses on available-for-sale securities, net of taxes(3) | — | (4) | (3,330)
Defined benefit pension plans, net of taxes(4) | (6,560) | 996 | 3,613
Other comprehensive income (loss), net of tax | (39,169) | (17,073) | 25,206
Comprehensive income | $14,656 | $230,285 | $232,328


Question: What was the percentage change in Net income in 2018 from 2017?
Answer: 19.43
Calculation: (247,358-207,122)/207,122
Cash Flows
The following table summarizes key cash flow activity for the years ended December 31, 2019, 2018, and 2017 (in thousands):
Operating Activities
The increase in net cash provided by operating activities during 2019 was primarily driven by higher cash proceeds from sales of systems projects, including the Sunshine Valley, Sun Streams, and California Flats projects, and advance payments received for sales of solar modules prior to the step down in the U.S. investment tax credit as discussed above. These increases were partially offset by operating expenditures associated with initial ramp of certain Series 6 manufacturing lines and expenditures for the construction of certain projects.
Investing Activities
The decrease in net cash used in investing activities during 2019 was primarily due to higher net sales of marketable securities and restricted investments, partially offset by proceeds associated with the sale of our interests in 8point3 and its subsidiaries in 2018.
Financing Activities
The decrease in net cash provided by financing activities during 2019 was primarily the result of lower net proceeds from borrowings under project specific debt financings associated with the construction of certain projects in Australia, Japan, and India.
Table:
 | 2019 | 2018 | 2017
Net cash provided by (used in) operating activities | $174,201 | $(326,809) | $1,340,677
Net cash used in investing activities | (362,298) | (682,714) | (626,802)
Net cash provided by financing activities | 74,943 | 255,228 | 192,045
Effect of exchange rate changes on cash, cash equivalents and restricted cash. | (2,959) | (13,558) | 8,866
Net (decrease) increase in cash, cash equivalents and restricted cash | $(116,113) | $(767,853) | $914,786


Question: What are the reasons for the increase in cash provided by operating activities in 2019?
Answer: primarily driven by higher cash proceeds from sales of systems projects, including the Sunshine Valley, Sun Streams, and California Flats projects, and advance payments received for sales of solar modules prior to the step down in the U.S. investment tax credit as discussed above.
The amount of unrecognized tax benefits at December 31, 2019 increased by $387 million in 2019 to $7,146 million. A reconciliation of the beginning and ending amount of unrecognized tax benefits was as follows:
The additions to unrecognized tax benefits related to the current and prior years were primarily attributable to U.S. federal and state tax matters, as well as non-U.S. tax matters, including transfer pricing, credits and incentives. The settlements and reductions to unrecognized tax benefits for tax positions of prior years were primarily attributable to U.S. federal and state tax matters, non-U.S. audits and impacts due to lapse of statute of limitations.
The unrecognized tax benefits at December 31, 2019 of $7,146 million can be reduced by $584 million associated with timing adjustments, U.S. tax credits, potential transfer pricing adjustments and state income taxes. The net amount of $6,562 million, if recognized, would favorably affect the company’s effective tax rate. The net amounts at December 31, 2018 and 2017 were $6,041 million and $6,064 million, respectively.
Table:
($ in millions) |  |  | 
 | 2019 | 2018 | 2017
Balance at January 1 | $6,759 | $ 7,031 | $3,740
Additions based on tax positions related to the current year | 816 | 394 | 3,029
Additions for tax positions of prior years | 779 | 1,201 | 803
Reductions for tax positions of prior years (including impacts due to a lapse of statute) | (922) | (1,686) | (367)
Settlements | (286) | (181) | (174)
Balance at December 31 | $7,146 | $ 6,759 | $7,031


Question: What is the average of Balance at January 1?
Answer: 5843.33
Calculation: (6,759+7,031+3,740) / 3
Selling, general and administrative
Selling, general and administrative expense consists primarily of salaries and other personnel-related costs, professional fees, insurance costs, and other business development and selling expenses.
The following table shows selling, general and administrative expense for the years ended December 31, 2019, 2018, and 2017:
Selling, general and administrative expense in 2019 increased compared to 2018 primarily due to higher employee compensation expense, lower accretion expense in 2018 associated with the reduction in our module collection and recycling liability described above, and higher professional fees.
Table:
 |  | Year Ended |  | Change |  |  | 
(Dollars in thousands) | 2019 | 2018 | 2017 | 2019 over 2018 |  | 2018 over 2017 | 
Selling, general and administrative | $205,471 | $176,857 | $202,699 | $28,614 | 16% | $(25,842) | (13)%
% of net sales . | 6.7% | 7.9% | 6.9% |  |  |  | 


Question: What is the amount of net sales in 2019?
Answer: 3066731.34
Calculation: 205,471 / 6.7%
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
Other Redeemable Noncontrolling Interests—During the year ended December 31, 2019, the Company entered into an agreement with MTN to acquire MTN’s noncontrolling interests in each of the Company’s joint ventures in Ghana and Uganda for total consideration of approximately $523.0 million. The transaction is expected to close in the first quarter of 2020, subject to regulatory approval and other closing conditions. In addition, the Company, through a subsidiary of ATC Europe, entered into an agreement with its local partners in France to form Eure-et-Loir Réseaux Mobiles SAS (“Eure-et-Loir”), a telecommunications infrastructure company that owns and operates wireless communications towers in France. The Company’s controlling interest in Eure-et-Loir is 51% with local partners holding a 49% noncontrolling interest. The agreement provides the local partners with put options, which allow them to sell outstanding shares of Eure-et-Loir to the Company, and the Company with call options, which allow it to buy the noncontrolling shares of Eure-et-Loir. The put options, which are not under the Company’s control, cannot be separated from the noncontrolling interests. As a result, the combination of the noncontrolling interests and the redemption feature requires classification as redeemable noncontrolling interests in the consolidated balance sheet, separate from equity. The value of the Eure-et-Loir interests as of December 31, 2019 was $2.7 million.
The changes in Redeemable noncontrolling interests for the years ended December 31, 2019, 2018 and 2017 were as follows:
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Balance as of January 1, | $1,004.8 | $1,126.2 | $1,091.3
Additions to redeemable noncontrolling interests | 525.7 | — | —
Net income (loss) attributable to noncontrolling interests | 35.8 | (87.9) | (33.4)
Adjustment to noncontrolling interest redemption value | (35.8) | 86.7 | —
Adjustment to noncontrolling interest due to merger | — | (28.1) | —
Purchase of redeemable noncontrolling interest | (425.7) | — | —
Foreign currency translation adjustment attributable to noncontrolling interests | (8.3) | (92.1) | 68.3
Balance as of December 31, | $1,096.5 | $1,004.8 | $1,126.2


Question: What was the change in Adjustment to noncontrolling interest redemption value between 2018 and 2019?
Answer: -122.5
Calculation: -35.8-86.7
1. Sales revenues
Commencing with financial year 2018/19, METRO has been applying IFRS 15 (Revenue from Contracts with Customers). The sales revenues reported for the current financial year relate exclusively to revenues from contracts with customers.
Sales revenues are allocated to the following categories:
Table:
€ million | 2017/2018 | 2018/2019
Store-based and other business | 22,585 | 22,487
METRO Germany | 4,128 | 4,075
METRO Western Europe (excl. Germany) | 8,904 | 8,885
METRO Russia | 2,550 | 2,406
METRO Eastern Europe (excl. Russia) | 5,893 | 5,986
METRO Asia | 1,074 | 1,097
Others | 35 | 38
Delivery sales | 4,207 | 4,595
METRO Germany | 633 | 660
METRO Western Europe (excl. Germany) | 1,704 | 1,867
METRO Russia | 265 | 257
METRO Eastern Europe (excl. Russia) | 1,059 | 1,205
METRO Asia | 538 | 599
Others | 7 | 7
Total sales | 26,792 | 27,082
METRO Germany | 4,761 | 4,735
METRO Western Europe (excl. Germany) | 10,609 | 10,752
METRO Russia | 2,815 | 2,662
METRO Eastern Europe (excl. Russia) | 6,952 | 7,191
METRO Asia | 1,612 | 1,696
Others | 43 | 46


Question: What are the categories of sales revenue allocations in the table?
Answer: Store-based and other business, Delivery sales, Total sales
Fair Value of Financial Instruments
The following table summarizes our financial assets and liabilities measured at fair value on a recurring basis (in millions):
(1) Reported as other current assets in the consolidated balance sheets
(2) Reported as other non-current assets in the consolidated balance sheets
(3) Reported as accrued expenses in the consolidated balance sheets
Table:
 |  | April 26, 2019 | 
 |  | Fair Value Measurements at Reporting Date Using | 
 | Total | Level 1 | Level 2
Cash | $ 2,216 | $  2,216 | $  —
Corporate bonds | 1,353 | — | 1,353
U.S. Treasury and government debt securities | 213 | 131 | 82
Certificates of deposit | 117 | — | 117
Total cash, cash equivalents and short-term investments | $ 3,899 | $ 2,347 | $ 1,552
Other items: |  |  | 
Mutual funds (1) | $ 6 | $  6 | $  —
Mutual funds (2) | $ 29 | $  29 | $  —
Foreign currency exchange contracts assets (1) | $ 4 | $  — | $ 4
Foreign currency exchange contracts liabilities (3) | (1 ) | $  — | (1 )


Question: What does the table show?
Answer: summarizes our financial assets and liabilities measured at fair value on a recurring basis
Net debt
Net debt is a measure that provides valuable additional information on the summary presentation of the Group’s net financial liabilities and is a measure in common use elsewhere.
Prior to this quarter, all financial asset derivatives were current financial assets and so reduced net debt. Following a recent review we now also have financial asset derivatives that are non-current in nature. As all of these derivatives relate to financial liabilities, we continue to exclude them for the purposes of our net debt calculation and have expanded our definition to reflect this.
Net debt is now defined as the excess of total financial liabilities, excluding trade payables and other current liabilities, over cash, cash equivalents and other current financial assets, excluding trade and other current receivables, and non-current financial asset derivatives that relate to financial liabilities.
(a) Restated following adoption of IFRS 16. See note 1 and note 24 for further details.
Table:
 | € million | € million
 | 2019 | 2018
 |  | (Restated)(a)
Total financial liabilities | (28,257) | (26,738)
Current financial liabilities | (4,691) | (3,613)
Non-current financial liabilities | (23,566) | (23,125)
Cash and cash equivalents as per balance sheet | 4,185 | 3,230
Cash and cash equivalents as per cash flow statement | 4,116 | 3,090
Add bank overdrafts deducted therein | 69 | 140
Other current financial assets | 907 | 874
Non-current financial assets derivatives that relate to financial liabilities | 114 | –
Net debt | (23,051) | (22,634)


Question: What is the average total financial liabilities?
Answer: -27497.5
Calculation: - (28,257 + 26,738) / 2
The actual return on plan assets amounted to €125 million in the reporting period (2017/ 18: €45 million).
For financial year 2019/20, the company expects employer payments to external pension providers totalling approximately €18 million and employee contributions of €9 million in plan assets, with contributions in the Netherlands, Belgium and Germany accounting for the major share of this total. Expected contributions from payment contribution commitments in Germany are not included in expected payments.
The fair value of plan assets developed as follows:
At one Dutch company, plan assets exceeded the value of commitments as of the closing date. Since the company cannot draw any economic benefits from this overfunding, the balance sheet amount was reduced to €0 in line with IAS 19.64 (b).
Table:
€ million | 2017/2018 | 2018/2019
Change in plan assets |  | 
Fair value of plan assets as of beginning of period | 905 | 940
Recognised under | 21 | 23
Interest income | 21 | 23
Recognised outside of profit or loss under ‘remeasurement of defined benefit pension plans’ in other comprehensive income | 24 | 102
Gains/losses from plan assets excl. interest income (+/−) | 24 | 102
Other effects | −10 | 0
Benefit payments (incl. tax payments) | −34 | −27
Settlement payments | −6 | 0
Employer contributions | 35 | 18
Contributions from plan participants | 11 | 9
Change in consolidation group / transfers | 0 | 0
Reclassification in accordance with IFRS5 | −16 | 0
Currency effects | 0 | 1
Fair value of plan assets as of end of period | 940 | 1,066


Question: What was the percentage change in interest income in FY2019 from FY2018?
Answer: 9.52
Calculation: (23-21)/21