hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
The tax effects of temporary differences that give rise to significant portions of the Company's deferred tax assets and deferred tax liabilities are as follows (amounts in millions):
In assessing whether it is more likely than not that deferred tax assets will be realized, the Company considers all available evidence, both positive and negative, including its recent cumulative earnings experience and expectations of future available taxable income of the appropriate character by taxing jurisdiction, tax attribute carryback and carryforward periods available to them for tax reporting purposes, and prudent and feasible tax planning strategies.
Table:
 | March 31, | 
 | 2019 | 2018
Deferred tax assets: |  | 
Deferred income on shipments to distributors | $— | $39.1
Inventory valuation | 45.0 | 10.7
Net operating loss carryforward | 94.3 | 101.1
Capital loss carryforward | 9.6 | 10.6
Share-based compensation | 42.4 | 31.4
Income tax credits | 376.5 | 178.4
Property, plant and equipment | 23.6 | 25.7
Accrued expenses and other | 91.4 | 91.2
Intangible assets | 1,608.1 | —
Other | 12.6 | —
Gross deferred tax assets | 2,303.5 | 488.2
Valuation allowances | (332.1) | (204.5)
Deferred tax assets, net of valuation allowances | 1,971.4 | 283.7
Deferred tax liabilities: |  | 
Convertible debt | (279.3) | (304.4)
Intangible assets | (721.0) | (66.6)
Other | — | (18.3)
Deferred tax liabilities | (1,000.3) | (389.3)
Net deferred tax asset (liability) | $971.1 | $(105.6)
Reported as: |  | 
Non-current deferred tax assets | $1,677.2 | $100.2
Non-current deferred tax liability | (706.1) | (205.8)
Net deferred tax asset (liability) | $971.1 | $(105.6)


Question: What was the percentage change in the Net deferred tax asset between 2018 and 2019?
Answer: -1019.6
Calculation: (971.1-(-105.6))/-105.6
Selected Current Liabilities
Current liabilities reflected in our consolidated balance sheets include accounts payable and other current liabilities as follows:
Included in accounts payable at December 31, 2019 and 2018, were (i) $106 million and $86 million, respectively, representing book overdrafts and (ii) $469 million and $434 million, respectively, associated with capital expenditures.
Table:
 | As of December 31, | 
 | 2019 | 2018
 | (Dollars in millions) | 
Accounts payable | $1,724 | 1,933
Other current liabilities: |  | 
Accrued rent | $75 | 45
Legal contingencies | 88 | 30
Other | 223 | 282
Total other current liabilities | $386 | 357


Question: Which year has a larger amount of accounts payable associated with capital expenditures?
Answer: 2019
Calculation: 469>434
GAINS (LOSSES) ON EQUITY INVESTMENTS AND INTEREST AND OTHER, NET
GAINS (LOSSES) ON EQUITY INVESTMENTS, NET
Ongoing mark-to-market net gains and losses reported in 2019 and 2018 were primarily driven by ASML Holding N.V. (ASML) and Cloudera Inc. (Cloudera). During 2019 we sold our equity investment in ASML.
In 2019, we recognized $293 million in observable price adjustments primarily from one investment.
During 2018, we recognized an impairment charge of $290 million in our equity method investment in IMFT. During 2017, we recognized impairment charges in our investments of Cloudera for $278 million and Unisoc for $308 million.
Major drivers of sales of equity investments and other in 2019 were dividends of $632 million from McAfee and a gain of $107 million from our sale of our non-controlling interest in IMFT. In 2017, we recognized $3.4 billion in realized gains on sales of a portion of our interest in ASML.
INTEREST AND OTHER, NET
We recognized a higher net gain in interest and other in 2019 compared to 2018, primarily due to lower loss on debt conversions and larger divestiture gains in 2019 compared to 2018.
We recognized a net gain in interest and other in 2018 compared to a net loss in 2017, primarily due to lower losses on debt conversions, higher assets under construction resulting in more capitalized interest, and larger divestiture gains in 2018 compared to 2017.
Table:
Years Ended | Dec 28, | Dec 29, | Dec 30,
(In Millions) | 2019 | 2018 | 2017
Ongoing mark-to market adjustments on marketable equity securities | $277 | $(129) | $ —
Observable price adjustments on non-marketable equity securities | 293 | 202 | —
Impairment charges | (122) | (424) | (833)
Sale of equity investments and other | 1,091 | 226 | 3,484
Gains (losses) one equity investments, net | $1,539 | $(125) | $2,651
Interest and other, net | $484 | $126 | $(349)


Question: What is the percentage change in gains (losses) on equity investments, net from 2017 to 2019?
Answer: -41.95
Calculation: (1,539 - 2,651) / 2,651
The following table presents a rollforward of our restructuring liability as of September 30, 2019, which is included within accrued compensation and other current liabilities within our Consolidated Balance Sheet, (in millions):
Certain restructuring costs are based upon estimates. Actual amounts paid may ultimately differ from these estimates. If additional costs are incurred or recognized amounts exceed costs, such changes in estimates will be recognized when incurred.
Table:
 | Restructuring Liability Employee Separation and other | Restructuring Liability Consulting Costs
Balance as of October 1, 2017 | $ 1.0 | $  —
Accrued costs | 4.2 | 0.8
Cash payments | (4.6) | (0.5)
Balance as of September 30, 2018 | $  0.6 | $  0.3
Accrued costs | 7.5 | 7.9
Cash payments | (6.1) | (7.4)
Balance as of September 30, 2019 | $  2.0 | $  0.8


Question: What is the change in balance as of September 30, 2019 from September 30, 2018 for Restructuring Liability Consulting Costs?
Answer: 0.5
Calculation: 0.8-0.3
Asia Pacific
Asia Pacific net revenues decreased $1.4 million in 2019 compared to 2018 (see “Revenues” above). Asia Pacific expenses decreased $203,000 from 2018 to 2019. This decrease was primarily due to a $503,000 decrease of salary expense, offset partially by a $303,000 increase in member acquisition costs.
Foreign currency movements relative to the U.S. dollar negatively impacted our local currency loss from our operations in Asia Pacific by approximately $136,000 for 2019. Foreign currency movements relative to the U.S. dollar positively impacted our local currency loss from our operations in Asia Pacific by approximately $127,000 for 2018.
Table:
Year Ended December 31, |  | 
 | 2019 | 2018
(In thousands) |  | 
Revenues | $6,490 | $7,859
(Loss) from operations | $(7,488) | $(6,322)
(Loss) from operations as a % of revenues | (115)% | (80)%


Question: Which year has a higher amount of revenue?
Answer: 2018
Calculation: Look at COL3 and COL4 and compare the values for revenues in Row 4
The table below shows the annual pension entitlement earned during the Executive Board membership of each member of the Executive Board on reaching the scheduled retirement age of 62, based on entitlements from SAP under performance-based and salary-linked plans.
Annual Pension Entitlement
1) The rights shown here for Bill McDermott refer solely to rights under the pension plan for SAP America.
These are vested entitlements. To the extent that members continue to serve on the Executive Board and that therefore more contributions are made for them in the future, pensions actually payable at the scheduled retirement age will be higher than the amounts shown in the table.
Table:
€ thousands | Vested on 12/31/2019 | Vested on 12/31/2018
Christian Klein (Co-CEO from 10/11/2019) | 8.2 | 4.1
Adaire Fox-Martin | 11.8 | 7.3
Michael Kleinemeier | 20.0 | 14.8
Bernd Leukert (until 3/31/2019) | 34.7 | 24.6
Bill McDermott (CEO until 10/10/2019, Executive Board Member until 11/15/2019)1) | 90.8 | 105.1
Luka Mucic | 27.6 | 23.2
Jürgen Müller (from 1/1/2019) | 4.8 | -
Stefan Ries | 16.8 | 12.6
Thomas Saueressig (from 11/1/2019) | 0.2 | -


Question: What was the percentage change in the amount for Christian Klein in 2019 from 2018?
Answer: 100
Calculation: (8.2-4.1)/4.1
Total CO2 emissions FY19
1 Tonnes of carbon dioxide equivalent.
2 Absolute carbon emissions divided by revenue in millions.
Auto Trader is required to measure and
report its direct and indirect greenhouse
gas (‘GHG’) emissions by the Companies Act
2006 (Strategic Report and Directors’ Report)
Regulations 2013. The greenhouse gas
reporting period is aligned to the financial
reporting year. The methodology used to
calculate our emissions is based on the
financial consolidation approach, as
defined in the Greenhouse Gas Protocol,
A Corporate Accounting and Reporting
Standard (Revised Edition). Emission
factors used are from UK government
(‘BEIS’) conversion factor guidance for
the year reported.
Auto Trader is required to measure and report its direct and indirect greenhouse gas (‘GHG’) emissions by the Companies Act 2006 (Strategic Report and Directors’ Report) Regulations 2013. The greenhouse gas reporting period is aligned to the financial reporting year. The methodology used to calculate our emissions is based on the financial consolidation approach, as defined in the Greenhouse Gas Protocol, A Corporate Accounting and Reporting Standard (Revised Edition). Emission factors used are from UK government (‘BEIS’) conversion factor guidance for the year reported.
The report includes the ‘Scope 1’ (combustion of fuel) in relation to company cars and ‘Scope 2’ (purchased electricity and gas) emissions associated with our offices. We have chosen to include the emissions associated with leased company cars in Scope 1, as we are responsible for these emissions.
We have chosen to present a revenue intensity ratio as this is a relevant indicator of our growth and is aligned with our business strategy. The reduction in our GHG emissions is due to a reduction in the fuel emissions from our company car fleet, as the fleet has reduced. We have also reduced the amount of electricity we use, and this coupled with a decrease in BEIS conversion factors has also contributed to our Scope 2 reduction.
Table:
 | FY19 | FY18 | FY17 | FY16
Scope 1 | 263 | 390 | 491 | 565
Manchester | 213 | 281 | 361 | 357
London | 44 | 60 | 76 | 88
Scope 2 | 258 | 340 | 437 | 445
Total | 521 | 731 | 928 | 1,010
Revenue | 355.1 | 330.1 | 311.5 | 281.6
Carbon intensity | 1.47 | 2.21 | 2.98 | 3.59
Year-on-year change | -34% | -26% | -17% | 


Question: In which year was the CO2 emissions amount in London largest?
Answer: FY16
Calculation: 88>76>60>44
Deferred Revenue
The opening balances of current and long-term deferred revenue were $30,694 and $1,352, respectively, as of January 1, 2018.
Expressed in US $000's except share and per share amounts
Table:
 | Years ended | 
 | December 31, 2019 | December 31, 2018
 | $ | $
Current portion | 56,691 | 39,180
Long term portion | 5,969 | 1,881
 | 62,660 | 41,061


Question: Between 2018 and 2019, which year had a higher amount of total deferred revenue?
Answer: 2019
Calculation: 62,660>41,061
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
23. SELECTED QUARTERLY FINANCIAL DATA (UNAUDITED)
Selected quarterly financial data for the years ended December 31, 2019 and 2018 is as follows (in millions, except per share data):
(1) Represents Operating expenses, exclusive of Depreciation, amortization and accretion, Selling, general, administrative and development expense, and Other operating expenses.
Table:
 |  | Three Months Ended |  |  | 
 | March 31, | June 30, | September 30, | December 31, | Year Ended December 31,
2018: |  |  |  |  | 
Operating revenues | $1,741.8 | $1,780.9 | $1,785.5 | $2,131.9 | $7,440.1
Costs of operations (1) | 519.9 | 560.3 | 556.7 | 540.9 | 2,177.8
Operating income | 402.9 | 546.0 | 567.2 | 388.9 | 1,905.0
Net income | 280.3 | 314.4 | 377.3 | 292.7 | 1,264.7
Net income attributable to American Tower Corporation stockholders | 285.2 | 306.7 | 366.9 | 277.6 | 1,236.4
Dividends on preferred stock | (9.4) | — | — | — | (9.4)
Net income attributable to American Tower Corporation common stockholders | 275.8 | 306.7 | 366.9 | 277.6 | 1,227.0
Basic net income per share attributable to American Tower Corporation common stockholders | 0.63 | 0.69 | 0.83 | 0.63 | 2.79
Diluted net income per share attributable to American Tower Corporation common stockholders | 0.63 | 0.69 | 0.83 | 0.62 | 2.77


Question: What was the change in Operating revenues between Three Months Ended March and June?
Answer: 39.1
Calculation: $1,780.9-$1,741.8
The following table provides a reconciliation of Adjusted SG&A to SG&A expenses, the most directly comparable financial measure presented in accordance with U.S. GAAP:
(a) Represents depreciation and amortization expense included in SG&A.
(b) Represents non-cash share-based compensation expense included in SG&A.
(c) Represents new store marketing allowance of $1,000 for each store added to our distribution network, as well as the non-capitalized freight costs associated with Freshpet Fridge replacements. The expense enhances the overall marketing spend to support our growing distribution network.
(d) Represents fees associated with secondary public offerings of our common stock.
(e) Represents charges associated with our former Chief Executive Officer’s separation agreement, as well as changes in estimates associated with leadership transition costs
(f) Represents fees associated with two securities lawsuits.
Table:
 | Twelve Months Ended December 31, |  |  |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
 | (Dollars in thousands) |  |  |  | 
SG&A expenses | $114,450 | $94,876 | $75,167 | $62,586 | $58,297
Depreciation and amortization expense (a) | 9,551 | 7,977 | 6,901 | 5,859 | 5,008
Non-cash share-based compensation (b) | 6,912 | 5,949 | 4,195 | 3,972 | 3,723
Launch expense (c) | 4,563 | 3,540 | 3,066 | 2,813 | 2,626
Loss on disposal of equipment | 649 | — | — | — | —
Secondary offering expenses (d) | 302 | 362 | — | — | 593
Leadership transition expenses (e) | — | — | 63 | 1,291 | —
Litigation expense (f) | — | 348 | 145 | — | —
Adjusted SG&A Expenses | $92,473 | $76,698 | $60,797 | $48,651 | $46,347
Adjusted SG&A Expenses as a % of Net Sales | 37.6% | 39.7% | 39.9% | 37.5% | 40.8%


Question: Which year had the greatest adjusted SG&A expenses?
Answer: 2019
Calculation: $92,473>$76,698>$60,797>$48,651>$46,347
The following table presents the contractual maturities of our debt investments as of April 26, 2019 (in millions):
Actual maturities may differ from the contractual maturities because borrowers may have the right to call or prepay certain obligations.
Table:
 | Amortized Cost | Fair Value
Due in one year or less | $ 591 | $ 589
Due after one year through five years | 644 | 642
Due after five years through ten years | 455 | 452
 | $ 1,690 | $ 1,683


Question: What type of cost and value information does the table provide about the contractual maturities of our debt investments as of April 26, 2019?
Answer: Amortized Cost, Fair Value
The following table shows the activity of our U.S. and international plan assets, which are measured at fair value using Level 3 inputs.
(1) Balances as of December 31, 2018 have been revised from our 2018 Form 10-K filing to reflect changes in leveling classification of specific funds. These reclassifications did not impact the fair value of any of our pension plan assets.
(2) Purchases of Level 3 assets in 2018 primarily represent the purchase of bulk annuity contracts (buy-ins) in some of our international plans.
Table:
 | December 31, | 
(In millions) | 2019 | 2018
Balance at beginning of period(1) | $ 150.1 | $ 71.5
Gains (losses) on assets still held at end of year | 16.8 | (16.0)
Purchases, sales, issuance, and settlements(2) | 8.3 | 103.7
Transfers in and/or out of Level 3 | — | 1.0
Foreign exchange gain (loss) | 5.0 | (10.1)
Balance at end of period(1) | $ 180.2 | $ 150.1


Question: What years are included in the table?
Answer: 2019, 2018
The service cost component of net pension expense represents the estimated cost of future pension liabilities earned associated with active employees. The pension earnings, interest and deferrals (“pension EID”) is comprised of the expected return on plan assets, interest costs on the projected benefit obligations of the plans and amortization of actuarial gains and losses and prior service costs.
Net pension expense is recorded in accounts that are included in both the cost of sales and selling, general and administrative expenses based on the function of the associated employees and in other income (expense), net. The following is a summary of the classification of net pension expense for the years ended June 30, 2019, 2018 and 2017:
As of June 30, 2019 and 2018, amounts capitalized in gross inventory were $1.7 million and $1.7 million, respectively.
Table:
 |  | Years Ended June 30, | 
($ in millions) | 2019 | 2018 | 2017
Cost of sales |  |  | 
Service cost | $10.0 | $10.5 | $20.2
Total cost of sales | 10.0 | 10.5 | 20.2
Selling, general and administrative expenses |  |  | 
Service cost | 1.5 | 1.6 | 3.9
Total selling, general and administrative expenses | 1.5 | 1.6 | 3.9
Other expense |  |  | 
Pension earnings, interest and deferrals | 0.1 | 2.1 | 23.8
Curtailment charge | — | — | 0.5
Total other expense | 0.1 | 2.1 | 24.3
Net pension expense | $11.6 | $14.2 | $48.4


Question: How is net pension expense recorded?
Answer: recorded in accounts that are included in both the cost of sales and selling, general and administrative expenses based on the function of the associated employees and in other income (expense), net.
NOTE 14—INCOME TAXES
Our effective tax rate represents the net effect of the mix of income earned in various tax jurisdictions that are subject to a wide range of income tax rates.
The following is a geographical breakdown of income before the provision for income taxes:
Table:
 |  | Year Ended June 30, | 
 | 2019 | 2018 | 2017
Domestic income (loss) | $269,331 | $238,405 | $110,562
Foreign income | 171,243 | 147,721 | 138,989
Income before income taxes | $440,574 | $386,126 | $249,551


Question: For Fiscal year 2019, what is the Foreign income expressed as a percentage of Income before income taxes?
Answer: 38.87
Calculation: 171,243/440,574
FAIR VALUE
Fair value is the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurement date.
Certain fair value estimates are affected by assumptions we make about the amount and timing of future cash flows and discount rates, all of which reflect varying degrees of risk. Income taxes and other expenses that would be incurred on disposition of financial instruments are not reflected in the fair values. As a result, the fair values are not the net amounts that would be realized if these instruments were settled.
The carrying values of our cash and cash equivalents, trade and other receivables, dividends payable, trade payables and accruals, compensation payable, severance and other costs payable, interest payable, notes payable and loans secured by trade receivables approximate fair value as they are short-term.
The following table provides the fair value details of financial instruments measured at amortized cost in the statements of financial position.
(1) Upon adoption of IFRS 16 on January 1, 2019, fair value disclosures are no longer required for leases
Table:
 |  |  | DECEMBER 31, 2019 |  | DECEMBER 31, 2018 | 
 | CLASSIFICATION | FAIR VALUE METHODOLOGY | CARRYING VALUE | FAIR VALUE | CARRYING VALUE | FAIR VALUE
CRTC tangible benefits obligation | Trade payables and other liabilities and other non-current liabilities | Present value of estimated future cash flows discounted using observable market interest rates | 29 | 29 | 61 | 61
CRTC deferral account obligation | Trade payables and other liabilities and other non-current liabilities | Present value of estimated future cash flows discounted using observable market interest rates | 82 | 85 | 108 | 112
Debt securities and other debt | Debt due within one year and long-term debt | Quoted market price of debt | 18,653 | 20,905 | 18,188 | 19,178
Finance leases (1) | Debt due within one year and long-term debt | Present value of future cash flows discounted using observable market interest rates | - | - | 2,097 | 2,304


Question: What is the percentage change in fair values for CRTC tangible benefits obligation in 2019?
Answer: -52.46
Calculation: (29-61)/61
28. Contingent liabilities and legal proceedings
Contingent liabilities are potential future cash outflows, where the likelihood of payment is considered more than remote, but is not considered probable or cannot be measured reliably.
Notes: 1 Performance bonds require the Group to make payments to third parties in the event that the Group does not perform what is expected of it under the terms of any related contracts or commercial arrangements
2 Other guarantees principally comprise Vodafone Group Plc’s guarantee of the Group’s 50% share of an AUD1.7 billion loan facility and a US$3.5 billion loan facility of its joint venture, Vodafone Hutchison Australia Pty Limited. The Group’s share of these loan balances is included in the net investment in joint venture (see note 12 “Investments in associates and joint arrangements”).
Table:
 | 2019 | 2018
 | €m | €m
Performance bonds1 | 337 | 993
Other guarantees and contingent liabilities2 | 2,943 | 4,036


Question: How much are the 2019 performance bonds?
Answer: 337
Capitalized software development costs consisted of the following (in thousands):
The Company capitalized software development costs of $8.8 million, $8.8 million and $6.2 million during the years ended December 31, 2019, 2018 and 2017, respectively.
Amortized expense for capitalized software development costs was $7.0 million, $5.9 million and $5.0 million during the years ended December 31, 2019, 2018 and 2017, respectively. Amortization of capitalized software development costs is classified within cost of revenue in the consolidated statements of operations and comprehensive loss. During the year ended December 31, 2019, the Company retired $4.6 million of fully amortized capitalized software development costs.
Table:
 |  |  | As of December 31, 2019 | 
 | Gross carrying amount | Amortization period | Accumulated amortization | Net carrying amount
Capitalized software development costs | $ 49,909 | 3 years | $ (35,622) | $ 14,287
Total capitalized software development costs | $ 49,909 |  | $ (35,622) | $ 14,287
 |  |  | As of December 31, 2018 | 
 | Gross carrying amount | Amortization period | Accumulated amortization | Net carrying amount
Capitalized software development costs | $ 45,677 | 3 years | $ (32,784) | $ 12,893
Total capitalized software development costs | $ 45,677 |  | $ (32,784) | $ 12,893


Question: What was the company capitalized software development costs during the years ended December 31, 2018?
Answer: $8.8 million