hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Selected Quarterly Financial Data (Unaudited)
Selected quarterly financial data is as follows (in millions, except per share amounts):
(1) In the quarter ended January 26, 2018, our provision for income taxes included significant charges attributable to United States tax reform.
(2) The quarters of fiscal 2018 have been adjusted for our retrospective adoption of the new accounting standard Revenue from Contracts with Customers (ASC 606).
Table:
 |  |  | Quarter Ended (2) | 
 | July 28, 2017 | October 27, 2017 | January 26, 2018 | April 27, 2018
Net revenues | $ 1,321 | $ 1,415 | $ 1,539 | $ 1,644
Gross profit | $ 824 | $ 900 | $ 956 | $ 1,029
Provision for income taxes (1) | $ 14 | $ 48 | $ 983 | $ 38
Net income (loss) | $ 131 | $ 174 | $(479 ) | $ 290
Net income (loss) per share, basic | $ 0.49 | $ 0.65 | $(1.79 ) | $ 1.09
Net income (loss) per share, diluted | $ 0.47 | $ 0.63 | $(1.79 ) | $ 1.06


Question: What was the net revenue for the quarter of July 28, 2017?
Answer: 1,321
(g) Prepaid Expenses and Other Current Assets:
A summary of prepaid expenses and other current assets is as follows (in millions):
Prepaid inventory represents inventory in-transit that has been paid for but not received.
Table:
 | September 2019 | September 2018
Prepaid expenses | $1.8 | $1.6
Prepaid inventory | 5.3 | 3.3
 | $7.1 | $4.9


Question: How much is the company's respective prepaid inventory in 2018 and 2019?
Answer: 3.3, 5.3
Our common shares are not a direct investment of our pension funds; however, the pension funds may indirectly include our shares. The aggregate amount of our common shares would not be considered material relative to the total pension fund assets.
Our funding policy is to make contributions in accordance with the laws and customs of the various countries in which we operate as well as to make discretionary voluntary contributions from time to time. We expect to make the minimum required contributions of $42 million and $26 million to our non-U.S. and U.S. pension plans, respectively, in fiscal 2020. We may also make voluntary contributions at our discretion.
At fiscal year end 2019, benefit payments, which reflect future expected service, as appropriate, are expected to be
paid as follows:
Table:
 | Non-U.S. Plans | U.S. Plans
 |  | (in millions)
Fiscal 2020 | $  82 | $  77
Fiscal 2021 | 77 | 74
Fiscal 2022 | 81 | 74
Fiscal 2023 | 85 | 74
Fiscal 2024 | 86 | 74
Fiscal 2025-2029 | 490 | 361


Question: What is the company's funding policy?
Answer: to make contributions in accordance with the laws and customs of the various countries in which we operate as well as to make discretionary voluntary contributions from time to time
4. Cash and Cash Equivalents
The following table summarizes the components of our cash and cash equivalents (amounts in millions):
Table:
 | At December 31, | 
 | 2019 | 2018
Cash | $437 | $268
Foreign government treasury bills | 37 | 32
Money market funds | 5,320 | 3,925
Cash and cash equivalents | $5,794 | $4,225


Question: What was the foreign government treasure bills amount in 2019?
Answer: 37
Sales-Type Leases
We are the lessor in sales-type lease arrangements for network equipment, which have initial terms of up to five years. Our sales-type lease arrangements contain either a provision whereby the network equipment reverts back to us upon the expiration of the lease or a provision that allows the lessee to purchase the network equipment at a bargain purchase amount at the end of the lease. In addition, our sales-type lease arrangements do not contain any residual value guarantees or material restrictive covenants. The allocation of the consideration between lease and nonlease components is determined by stand-alone selling price by component. The net investment in sales-type leases consists of lease receivables less unearned income. Collectability of sales-type leases is evaluated periodically at an individual customer level. The Company has elected to exclude taxes related to sales-type leases from revenue and the associated expense of such taxes. As of December 31, 2019 and 2018, we did not have an allowance for credit losses for our net investment in sales-type leases. As of December 31, 2019 and 2018, the components of the net investment in sales-type leases were as follows:
(1) Included in other receivables on the Consolidated Balance Sheet.
(2) Included in other assets on the Consolidated Balance Sheet.
Table:
(In thousands) | December 31, 2019 | December 31, 2018
Current minimum lease payments receivable(1) | $1,201 | $11,339
Non-current minimum lease payments receivable(2) | 889 | 1,670
Total minimum lease payments receivable | 2,090 | 13,009
Less: Current unearned revenue(1) | 365 | 631
Less: Non-current unearned revenue(2) | 163 | 473
Net investment in sales-type leases | $1,562 | $11,905


Question: What was the percentage change in net investment in sales-type leases between 2018 and 2019?
Answer: -86.88
Calculation: ($1,562-$11,905)/$11,905
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
13. INCOME TAXES
Beginning in the taxable year ended December 31, 2012, the Company has filed, and intends to continue to file, U.S. federal income tax returns as a REIT, and its domestic TRSs filed, and intend to continue to file, separate tax returns as required. The Company also files tax returns in various states and countries. The Company’s state tax returns reflect different combinations of the Company’s subsidiaries and are dependent on the connection each subsidiary has with a particular state and form of organization. The following information pertains to the Company’s income taxes on a consolidated basis.
The income tax provision from continuing operations consisted of the following:
The effective tax rate (“ETR”) on income from continuing operations for the years ended December 31, 2019, 2018 and 2017 differs from the federal statutory rate primarily due to the Company’s qualification for taxation as a REIT, as well as adjustments for state and foreign items. As a REIT, the Company may deduct earnings distributed to stockholders against the income generated by its REIT operations. In addition, the Company is able to offset certain income by utilizing its NOLs, subject to specified limitations.
Table:
 | 2019 | 2018 | 2017
Current: |  |  | 
Federal | $(1.7) | $(1.4) | $(0.1)
State | (5.0) | (1.8) | (3.8)
Foreign | (48.2) | (189.7) | (113.4)
Deferred: |  |  | 
Federal | 1.4 | 4.0 | 0.2
State | 0.5 | 0.7 | 1.0
Foreign | 53.2 | 298.3 | 85.4
Income tax benefit (provision) | $0.2 | $110.1 | $(30.7)


Question: What was the deferred Foreign income tax provision in 2019?
Answer: 53.2
Teradyne’s gross unrecognized tax benefits for the years ended December 31, 2019, 2018 and 2017 were as follows:
Current year additions relate to federal and state research credits. Prior year additions primarily relate to stock-based compensation. Prior year reductions are primarily composed of federal and state reserves related to transfer pricing and research credits and resulted from the completion of the 2015 U.S. federal audit in the first quarter of 2019.
Of the $21.2 million of unrecognized tax benefits as of December 31, 2019, $12.7 million would impact the consolidated income tax rate if ultimately recognized. The remaining $8.5 million would impact deferred taxes if recognized.
Teradyne does not anticipate a material change in the balance of unrecognized tax benefits as of December 31, 2019 in the next twelve months.
Teradyne records all interest and penalties related to income taxes as a component of income tax expense. Accrued interest and penalties related to income tax items at December 31, 2019 and 2018 amounted to $1.4 million and $0.3 million, respectively. For the years ended December 31, 2019, 2018 and 2017, expense of $1.1 million, expense of $0.1 million and benefit of $0.1 million, respectively, was recorded for interest and penalties related to income tax items.
Teradyne is subject to U.S. federal income tax, as well as income tax in multiple state, local and foreign jurisdictions. As of December 31, 2019, all material state and local income tax matters have been concluded through 2013, all material federal income tax matters have been concluded through 2015 and all material foreign income tax matters have been concluded through 2011. However, in some jurisdictions, including the United States, operating losses and tax credits may be subject to adjustment until such time as they are utilized and the year of utilization is closed to adjustment.
As of December 31, 2019, Teradyne is not permanently reinvested with respect to the unremitted earnings of non-U.S. subsidiaries to the extent that those earnings exceed local statutory and operational requirements. Remittance of those earnings is not expected to result in material income tax.
Table:
 | 2019 | 2018 | 2017
 |  | (in thousands) | 
Beginning balance, as of January 1 | $43,395 | $36,263 | $38,958
Additions: |  |  | 
Tax positions for current year | 1,322 | 4,716 | 8,208
Tax positions for prior years | 8,043 | 2,626 | 199
Reductions: |  |  | 
Tax positions for prior years | (31,397) | (153) | (10,573)
Expiration of statutes | (183) | (57) | (325)
Settlements with tax authorities | — | — | (204)
Ending balance, as of December 31 | $21,180 | $43,395 | $36,263


Question: What do Current year additions relate to?
Answer: federal and state research credits
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
NOTE 13. INTANGIBLE ASSETS
Intangible assets consisted of the following as of December 31, 2019 and 2018:
At December 31, 2019, the weighted average remaining useful life of intangibles subject to amortization was approximately 11.2 years.
Table:
December 31, 2019 | Gross Carrying Amount | Accumulated Amortization | Net Carrying Amount
Technology | $83,368 | $(14,250) | $69,118
Customer relationships | 108,995 | (18,197) | 90,798
Trademarks and other | 26,888 | (2,793) | 24,095
Total | $219,251 | $(35,240) | $184,011
December 31, 2018 | Gross Carrying Amount | Accumulated Amortization | Net Carrying Amount
Technology | $39,879 | $(7,927) | $31,952
Customer relationships | 35,509 | (13,484) | 22,025
Trademarks and other | 2,501 | (1,568) | 933
Total | $77,889 | $(22,979) | $  54,910


Question: Which years does the table provide data for intangible assets?
Answer: 2019, 2018
b) Liquefaction services revenue:
The Hilli is moored in close proximity to the Customer’s gasfields, providing liquefaction service capacity over the term of the LTA. Liquefaction services revenue recognized comprises the following amounts:
(1) The LTA bills at a base rate in periods when the oil price is $60 or less per barrel (included in "Liquefaction services revenue" in the consolidated statements of income), and at an increased rate when the oil price is greater than $60 per barrel (recognized as a derivative and included in "Realized and unrealized gain on oil derivative instrument" in the consolidated statements of income, excluded from revenue and from the transaction price).
(2) Customer billing during the commissioning period, prior to vessel acceptance and commencement of the contract term, of $33.8 million is considered an upfront payment for services. These amounts billed were deferred (included in "Other current liabilities" and "Other non-current liabilities" in the consolidated balance sheets) and recognized as part of "Liquefaction services revenue" in the consolidated statements of income evenly over the contract term.
(3) The Day 1 gain was established when the oil derivative instrument was initially recognized in December 2017 for $79.6 million (recognized in "Other current liabilities" and "Other non-current liabilities" in the consolidated balance sheets). This amount is amortized and recognized as part of "Liquefaction services revenue" in the consolidated statements of income evenly over the contract term.
We expect to recognize liquefaction services revenue related to the partially unsatisfied performance obligation at the reporting date evenly over the remaining contract term of less than eight years, including the components of transaction price described above.
Table:
 | Year Ended December 31, | 
(in thousands of $) | 2019 | 2018
Base tolling fee (1) | 204,501 | 119,677
Amortization of deferred commissioning period revenue (2) | 4,220 | 2,467
Amortization of Day 1 gain (3) | 9,950 | 5,817
Other | (575) | (336)
Total | 218,096 | 127,625


Question: In which years as the liquefaction services revenue recorded for?
Answer: 2019, 2018
O. Accrued Expenses and Other
Accrued expenses and other as of the periods presented consisted of the following (table in millions)
(1) Other primarily consists of litigation accrual, leases accrual, income tax payable and indirect tax accrual.
Accrued partner liabilities primarily relate to rebates and marketing development fund accruals for channel partners, system vendors and systems integrators. Accrued partner liabilities also include accruals for professional service arrangements for which VMware intends to leverage channel partners to directly fulfill the obligation to its customers.
As of January 31, 2020, other included $237 million litigation accrual related to Cirba patent and trademark infringement lawsuit and $155 million accrual for amounts owed to dissenting shareholders in connection with the Pivotal acquisition. Refer to Note E and Note B, respectively, for more information.
Table:
 | January 31, 2020 | February 1, 2019
Accrued employee related expenses | $845 | $780
Accrued partner liabilities | 181 | 207
Customer deposits | 247 | 239
Other(1) | 878 | 438
Total | $2,151 | $1,664


Question: How many years did Other exceed $500 million?
Answer: 1
Calculation: 2020
Unaudited Pro Forma Results of Acquirees
Autodesk has included the financial results of each of the acquirees in the consolidated financial statements from the respective dates of acquisition; the revenues and the results of each of the acquirees, except for PlanGrid, have not been material both individually or in the aggregate to Autodesk's fiscal 2019 and 2018 results.
The following unaudited pro forma financial information summarizes the combined results of operations for Autodesk and PlanGrid, as though the companies were combined as of the beginning of Autodesk's fiscal year 2018. The unaudited pro forma financial information was as follows (in millions):
The pro forma financial information for all periods presented includes the business combination accounting effects from the acquisition of PlanGrid including amortization expense from acquired intangible assets, compensation expense, and the interest expense and debt issuance costs related to the term loan agreement. The historical financial information has been adjusted to give effect to pro forma events that are directly attributable to the business combinations and factually supportable. The pro forma financial information is for informational purposes only and is not indicative of the results of operations that would have been achieved if the acquisition had taken place at the beginning of the Company’s fiscal 2018.
The pro forma financial information for fiscal 2019 and 2018 combines the historical results of the Company, the adjusted historical results of PlanGrid for fiscal 2019 and 2018 considering the date the Company acquired PlanGrid and the effects of the pro forma adjustments described above
Table:
 | Fiscal Year ended January 31, | 
 | 2019 | 2018
Total revenues | $2,632.6 | $2,099.2
Pretax loss | (157.5) | (724.9)
Net loss | (200.1) | (734.5)


Question: What is the % change in the total revenue from 2018 to 2019?
Answer: 25.41
Calculation: (($2,632.6-$2,099.2)/$2,099.2)
(1) For the three-month period ended August 31, 2019, the average foreign exchange rate used for translation was 1.3222 USD/CDN. (2) 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. (3) Fiscal 2019 actuals are translated at the average foreign exchange rate of the comparable period of fiscal 2018 which was 1.3100 USD/CDN.
REVENUE Fiscal 2019 fourth-quarter revenue increased by 7.0% (6.0% in constant currency). In local currency, revenue amounted to US$199.5 million compared to US$188.1 million for the same period of fiscal 2018. The increase resulted mainly from: • rate increases; • activation of bulk properties in Florida during the fourth quarter of fiscal 2019; • continued growth in Internet service customers; and • the FiberLight acquisition completed in the first quarter of fiscal 2019; partly offset by • a decrease in video service customers.
OPERATING EXPENSES Fiscal 2019 fourth-quarter operating expenses increased by 8.6% (7.6% in constant currency) mainly as a result of: • programming rate increases; • the FiberLight acquisition completed in the first quarter of fiscal 2019; • higher compensation expenses due to higher headcount to support growth; and • higher marketing initiatives to drive primary service units growth.
ADJUSTED EBITDA Fiscal 2019 fourth-quarter adjusted EBITDA increased by 5.1% (4.1% in constant currency). In local currency, adjusted EBITDA amounted to US$87.4 million compared to US$83.9 million for the same period of fiscal 2018. The increase was mainly due to organic growth combined with the impact of the FiberLight acquisition.
ACQUISITIONS OF PROPERTY, PLANT AND EQUIPMENT Fiscal 2019 fourth-quarter acquisitions of property, plant and equipment decreased by 9.5% (10.5% in constant currency) mainly due to: • lower purchases of customer premise equipment due to the timing of certain initiatives; and • lower capital expenditures due to the timing of certain initiatives; partly offset by • additional capital expenditures related to the expansion in Florida.
Table:
Three months ended August 31, | 2019(1) | 2018(2) | Change | Change in constant currency(3) | Foreign exchange impact(3)
(in thousands of dollars, except percentages) | $ | $ | % | % | $
Revenue | 263,738 | 246,443 | 7.0 | 6.0 | 2,427
Operating expenses | 148,215 | 136,506 | 8.6 | 7.6 | 1,370
Adjusted EBITDA | 115,523 | 109,937 | 5.1 | 4.1 | 1,057
Adjusted EBITDA margin | 43.8% | 44.6% |  |  | 
Acquisitions of property, plant and equipment | 65,967 | 72,914 | (9.5) | (10.5) | 704
Capital intensity | 25.0% | 29.6% |  |  | 


Question: What was the exchange rate in 2019?
Answer: 1.3222 USD/CDN
stock performance graph the following graph sets forth the cumulative total shareholder return on our series a common stock , series b common stock and series c common stock as compared with the cumulative total return of the companies listed in the standard and poor 2019s 500 stock index ( 201cs&p 500 index 201d ) and a peer group of companies comprised of cbs corporation class b common stock , news corporation class a common stock , scripps network interactive , inc. , time warner , inc. , viacom , inc . class b common stock and the walt disney company . the graph assumes $ 100 originally invested on september 18 , 2008 , the date upon which our common stock began trading , in each of our series a common stock , series b common stock and series c common stock , the s&p 500 index , and the stock of our peer group companies , including reinvestment of dividends , for the period september 18 , 2008 through december 31 , 2008 and the years ended december 31 , 2009 , 2010 , 2011 , and 2012 . december 31 , december 31 , december 31 , december 31 , december 31 .

Table:
 | december 312008 | december 312009 | december 312010 | december 312011 | december 312012
disca | $ 102.53 | $ 222.09 | $ 301.96 | $ 296.67 | $ 459.67
discb | $ 78.53 | $ 162.82 | $ 225.95 | $ 217.56 | $ 327.11
disck | $ 83.69 | $ 165.75 | $ 229.31 | $ 235.63 | $ 365.63
s&p 500 | $ 74.86 | $ 92.42 | $ 104.24 | $ 104.23 | $ 118.21
peer group | $ 68.79 | $ 100.70 | $ 121.35 | $ 138.19 | $ 190.58
equity compensation plan information information regarding securities authorized for issuance under equity compensation plans will be set forth in our definitive proxy statement for our 2013 annual meeting of stockholders under the caption 201csecurities authorized for issuance under equity compensation plans , 201d which is incorporated herein by reference. .

Question: what was the percentage cumulative total shareholder return on discb common stock from september 18 , 2008 to december 31 , 2012?
Answer: 227.11%
Calculation: subtract(327.11, const_100), divide(#0, const_100)
5. INVESTMENTS
The Company determines the appropriate designation of investments at the time of purchase and reevaluates such designation as of each balance sheet date. All of the Company’s investments are designated as available-for-sale debt securities. As of September 30, 2019 and 2018, the Company’s short-term investments have maturity dates of less than one year from the balance sheet date. The Company’s long-term investments have maturity dates of greater than one year from the balance sheet date.
Available-for-sale marketable securities are carried at fair value as determined by quoted market prices for identical or similar assets, with unrealized gains and losses, net of taxes, and reported as a separate component of stockholders’ equity. Management reviews the fair value of the portfolio at least monthly and evaluates individual securities with fair value below amortized cost at the balance sheet date. For debt securities, in order to determine whether impairment is other than-temporary, management must conclude whether the Company intends to sell the impaired security and whether it is more likely than not that the Company will be required to sell the security before recovering its amortized cost basis. If management intends to sell an impaired debt security or it is more likely than not the Company will be required to sell the security prior to recovering its amortized cost basis, an other-than-temporary impairment is deemed to have occurred. The amount of an other-than-temporary impairment related to a credit loss, or securities that management intends to sell before recovery, is recognized in earnings. The amount of an other-than-temporary impairment on debt securities related to other factors is recorded consistent with changes in the fair value of all other available for-sale securities as a component of stockholders’ equity in other comprehensive income. No other-than-temporary impairment charges were recognized in the fiscal years ended September 30, 2019, 2018, and 2017. There were no realized gains or losses from the sale of available-for-sale securities during the years ended September 30, 2019 and 2017. The Company recorded a net realized loss from the sale of available-for-sale securities of $49,000 during the year ended September 30, 2018.
The cost of securities sold is based on the specific identification method. Amortization of premiums, accretion of discounts, interest, dividend income, and realized gains and losses are included in investment income.
The following tables summarize investments by type of security as of September 30, 2019 and 2018, respectively(amounts shown in thousands):
Table:
September 30, 2019: | Cost | Gross Unrealized Gains | Gross Unrealized Losses | Fair Market Value
Available-for-sale securities: |  |  |  | 
U.S. Treasury, short-term | $4,240 | $2 | $— | $4,242
Corporate debt securities, short-term | 12,258 | 2 | — | 12,260
U.S. Treasury, long-term | 1,102 | — | (1) | 1,101
Corporate debt securities, long-term | 451 | — | — | 451
Total | $18,051 | $4 | $(1) | $18,054


Question: What is the percentage gain of short-term U.S. Treasury securities in 2019?
Answer: 0.05
Calculation: 2/4,242