hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Opening Balance Sheet Adjustments
The following summarizes the effect of adopting the above new accounting standards:
(1) The balance as of March 30, 2018, includes income tax receivable and prepaid income taxes of $107 million and short-term deferred commissions of $94 million. The opening balance as of March 31, 2018, includes income tax receivable and prepaid income taxes of $99 million and short-term deferred commissions of $86 million.
(2) The balance as of March 30, 2018, includes long-term deferred commissions of $35 million, long-term income tax receivable and prepaid income taxes of $61 million and deferred income tax assets of $46 million. The opening balance as of March 31, 2018, includes long-term deferred commissions of $92 million, long-term income tax receivable and prepaid income taxes of $29 million, and deferred income tax assets of $828 million.
Table:
(in millions) | Balance as of March 30, 2018 | Revenue Recognition Guidance | Accounting for Income Taxes Guidance | Opening Balance as of March 31, 2018
Accounts receivable, net | $809 | $24 | $— | $833
Other current assets (1) | $522 | $(8) | $(8) | $506
Other long-term assets (2) | $526 | $57 | $750 | $1,333
Total assets | $15,759 | $73 | $742 | $16,574
Short-term contract liabilities | $2,368 | $(107) | $— | $2,261
Other current liabilities | $372 | $(2) | $— | $370
Long-term contract liabilities | $735 | $(62) | $— | $673
Deferred income tax liabilities | $592 | $47 | $— | $639
Total liabilities | $10,736 | $(124) | $— | $10,612
Retained earnings | $328 | $197 | $742 | $1,267


Question: What is the Opening balance as of March 31, 2018 for Accounts receivable, net?
Answer: $809
18. Geographic Information
Revenue by geography is based on the customer's billing address, and was as follows:
No individual international country represented more than 10% of total revenue in any period presented.
Table:
 | Year Ended December 31, |  | 
 | 2019 | 2018 | 2017
U.S. | $1,979.6 | $1,723.9 | 1,504.5
International | 1,008.5 | 936.2 | 727.4
 | $2,988.1 | $2,660.1 | $2,231.9


Question: What is the change in the average U.S. revenue between 2017-2018 and 2018-2019?
Answer: 237.55
Calculation: [(1,979.6+1,723.9)/2] - [(1,723.9+1,504.5)/2]
Backlog
At December 31, 2019 and 2018, our backlog of unfilled orders in our four reportable segments was as follows:
Customers may delay delivery of products or cancel orders suddenly and without advanced notice, subject to possible cancellation penalties. Due to possible customer changes in delivery schedules and cancellation of orders, our backlog at any particular date is not necessarily indicative of the actual sales for any succeeding period. Delays in delivery schedules or cancellations of backlog during any particular period could have a material adverse effect on our business, financial condition or results of operations.
Table:
 | 2019 | 2018
 | (in millions) | 
Semiconductor Test | $543.2 | $367.5
System Test | 206.0 | 149.5
Wireless Test | 42.9 | 32.0
Industrial Automation | 17.9 | 19.7
 | $810.0 | $568.7


Question: What was the change in Wireless Test in 2019 from 2018?
Answer: 10.9
Calculation: 42.9-32.0
notes to consolidated financial statements 2014 ( continued ) the following table summarizes the changes in non-vested restricted stock awards for the year ended may 31 , 2009 ( share awards in thousands ) : share awards weighted average grant-date fair value .

Table:
 | share awards | weighted average grant-date fair value
non-vested at may 31 2007 | 278 | $ 37
granted | 400 | 38
vested | -136 ( 136 ) | 30
forfeited | -24 ( 24 ) | 40
non-vested at may 31 2008 | 518 | 39
granted | 430 | 43
vested | -159 ( 159 ) | 39
forfeited | -27 ( 27 ) | 41
non-vested at may 31 2009 | 762 | 42
the weighted average grant-date fair value of share awards granted in the years ended may 31 , 2008 and 2007 was $ 38 and $ 45 , respectively .
the total fair value of share awards vested during the years ended may 31 , 2009 , 2008 and 2007 was $ 6.2 million , $ 4.1 million and $ 1.7 million , respectively .
we recognized compensation expense for restricted stock of $ 9.0 million , $ 5.7 million , and $ 2.7 million in the years ended may 31 , 2009 , 2008 and 2007 .
as of may 31 , 2009 , there was $ 23.5 million of total unrecognized compensation cost related to unvested restricted stock awards that is expected to be recognized over a weighted average period of 2.9 years .
employee stock purchase plan we have an employee stock purchase plan under which the sale of 2.4 million shares of our common stock has been authorized .
employees may designate up to the lesser of $ 25000 or 20% ( 20 % ) of their annual compensation for the purchase of stock .
the price for shares purchased under the plan is 85% ( 85 % ) of the market value on the last day of the quarterly purchase period .
as of may 31 , 2009 , 0.8 million shares had been issued under this plan , with 1.6 million shares reserved for future issuance .
the weighted average grant-date fair value of each designated share purchased under this plan was $ 6 , $ 6 and $ 8 in the years ended may 31 , 2009 , 2008 and 2007 , respectively .
these values represent the fair value of the 15% ( 15 % ) discount .
note 12 2014segment information general information during fiscal 2009 , we began assessing our operating performance using a new segment structure .
we made this change as a result of our june 30 , 2008 acquisition of 51% ( 51 % ) of hsbc merchant services llp in the united kingdom , in addition to anticipated future international expansion .
beginning with the quarter ended august 31 , 2008 , the reportable segments are defined as north america merchant services , international merchant services , and money transfer .
the following tables reflect these changes and such reportable segments for fiscal years 2009 , 2008 , and 2007. .

Question: what was the percentage increase of total fair value of share awards vested from 2007 to 2009?
Answer: 265% increase
Calculation: subtract(6.2, 1.7), divide(#0, 1.7)
(10) Goodwill
Goodwill consists of the following (in millions):
The increase in Goodwill related to our Compass Analytics acquisition is deductible for tax purposes. For the 2018 increase in Goodwill, $19.7 million is deductible for tax purposes and $3.2 million is not deductible for tax purposes.
Table:
 | Software Solutions | Data and Analytics | Corporate and Other | Total
Balance, December 31, 2017 | $2,134.7 | $172.1 | $— | $2,306.8
HeavyWater and Ernst acquisitions (Note 3) | 22.9 | — | — | 22.9
Balance, December 31, 2018 | 2,157.6 | 172.1 | — | 2,329.7
Compass Analytics acquisition (Note 3) | 31.7 | — | — | 31.7
Balance, December 31, 2019 | $2,189.3 | $172.1 | $— | $2,361.4


Question: For the 2018 increase in Goodwill, how much was deductible for tax purposes?
Answer: 19.7
Product Revenue by Groups of Similar Products
In addition to the primary view on a geographic basis, we also prepare financial information related to groups of similar products and customer markets for various purposes. We report our product revenue in the following categories: Infrastructure Platforms, Applications, Security, and Other Products. This aligns our product categories with our evolving business model. Prior period amounts have been reclassified to conform to the current period’s presentation.
The following table presents revenue for groups of similar products (in millions, except percentages):
Amounts may not sum and percentages may not recalculate due to rounding.
Infrastructure Platforms The Infrastructure Platforms product category represents our core networking offerings related to switching, routing, wireless, and the data center. Infrastructure Platforms revenue increased by 7%, or $1,869 million, with growth across the portfolio. Switching had solid growth, with strong revenue growth in campus switching driven by an increase in sales of our intent-based networking Catalyst 9000 Series, and with growth in data center switching driven by increased revenue from our ACI portfolio. Routing experienced modest revenue growth driven by an increase in sales of SD-WAN products, partially offset by weakness in the service provider market. We experienced double digit revenue growth from wireless products driven by increases across the portfolio. Revenue from data center increased driven by higher sales of HyperFlex and our server products.
Applications The Applications product category includes our collaboration offerings (unified communications, Cisco TelePresence and conferencing) as well as IoT and AppDynamics analytics software offerings. Revenue in our Applications product category increased by 15%, or $767 million, with double digit growth in unified communications, TelePresence, AppDynamics, and IoT software.
Security Revenue in our Security product category increased 16%, or $378 million, driven by higher sales of identity and access, advanced threat security, unified threat management and web security products. The Duo acquisition in the first quarter of fiscal 2019 also contributed to the revenue increase in this product category.
Other Products The decrease in revenue from our Other Products category was primarily driven by a decrease in revenue from SPVSS business which we divested on October 28, 2018.
Table:
 |  | Years Ended |  | 2019 vs. 2018 | 
 | July 27, 2019 | July 28, 2018 | July 29, 2017 | Variance in Dollars | Variance in Percent
Product revenue: |  |  |  |  | 
Infrastructure Platforms | $30,191 | $28,322 | $27,817 | $1,869 | 7%
Applications | 5,803 | 5,036 | 4,568 | 767 | 15%
Security  . | 2,730 | 2,352 | 2,152 | 378 | 16%
Other Products | 281 | 999 | 1,168 | (718) | (72)%
Total  . | $39,005 | $36,709 | $35,705 | $2,296 | 6%


Question: What was the percentage change in total revenue between 2017 and 2018?
Answer: 2.81
Calculation: (36,709-35,705)/35,705
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
Contract Assets and Liabilities
Contract assets and liabilities included in our Consolidated Balance Sheets are as follows:
During the twelve months ended December 31, 2019, we recognized revenues of $256 that was included in contract liabilities at the beginning of the period.
Table:
 | As of December 31, | 
 | 2019 | 2018
Contract Assets |  | 
Prepaid rebates included in Other current assets | $64 | $65
Prepaid rebates included in Other assets | 1,853 | 999
Total Contract Assets | $1,917 | $1,064
Contract Liabilities |  | 
Customer discounts and price concessions included in Accrued expenses and other liabilities | $(2,070) | $(1,656)
Customer rights of return included in Accrued expenses and other liabilities | (807) | (325)
Total Contract Liabilities | $(2,877) | $(1,981)


Question: What was the change in the Prepaid rebates included in Other assets between 2018 and 2019?
Answer: 854
Calculation: 1,853-999
(5) Revenue Recognition
The following tables present our reported results under ASC 606 and a reconciliation to results using the historical accounting method:
Table:
 |  | Year Ended December 31, 2018 | 
 | Reported Balances | Impact of ASC 606 | ASC 605 Historical Adjusted Balances
 |  | (Dollars in millions, except per share amounts and shares in thousands) | 
Operating revenue | $23,443 | 39 | 23,482
Cost of services and products (exclusive of depreciation and amortization) | 10,862 | 22 | 10,884
Selling,general and administrative | 4,165 | 71 | 4,236
Interest expense | 2,177 | (9) | 2,168
Income tax expense | 170 | (12) | 158
Net loss | (1,733) | (33) | (1,766)
BASIC AND DILUTED LOSS PER COMMON SHARE |  |  | 
BASIC | $(1.63) | (0.03) | (1.66)
DILUTED | $(1.63) | (0.03) | (1.66)
WEIGHTED-AVERAGE COMMON SHARES OUTSTANDING |  |  | 
BASIC | 1,065,866 | - | 1,065,866
DILUTED | 1,065,866 | - | 1,065,866


Question: The table presents the reported results including the impact of what?
Answer: ASC 606
Contract Balances
The following table provides information about contract assets and contract liabilities from contracts with customers (amounts in thousands):
Contract assets, reported within current assets and other long-term assets in the consolidated balance sheets, primarily result from revenue being recognized when a license is delivered and payments are made over time. Contract liabilities primarily relate to advance consideration received from customers, deferred revenue, for which transfer of control occurs, and therefore revenue is recognized, as services are provided. Contract balances are reported in a net contract asset or liability position on a contract-by-contract basis at the end of each reporting period. The Company recognized $4.4 million of revenue during the year ended September 30, 2019 that was included in the contract liability balance at the beginning of the period.
Table:
 | September 30, 2019 | October 1, 2018
Contract assets, current | $2,350 | $169
Contract assets, non-current | 581 | 507
Contract liabilities, current | 5,612 | 4,281
Contract liabilities, non-current | 736 | 485


Question: What is the ratio of contract liabilities to contract assets in 2018?
Answer: 7.05
Calculation: (4,281+485)/(169+507)
Europe
Europe net revenues increased $749,000 in 2019 compared to 2018 (see “Revenues” above). Europe expenses increased $1.3 million from 2018 to 2019 primarily due to increased marketing costs.
Foreign currency movements relative to the U.S. dollar negatively impacted our local currency income from our operations in Europe by approximately $207,000 and $181,000 for 2019 and 2018, respectively.
Table:
Year Ended December 31, |  | 
 | 2019 | 2018
(In thousands) |  | 
Revenues | $36,898 | $36,149
Income from operations | $4,461 | $4,973
Income from operations as a % of revenues | 12% | 14%


Question: What is the percentage change in revenues from 2018 to 2019?
Answer: 2.07
Calculation: (36,898-36,149)/36,149
shareowner return performance graph the following performance graph and related information shall not be deemed 201csoliciting material 201d or to be 201cfiled 201d with the securities and exchange commission , nor shall such information be incorporated by reference into any future filing under the securities act of 1933 or securities exchange act of 1934 , each as amended , except to the extent that the company specifically incorporates such information by reference into such filing . the following graph shows a five year comparison of cumulative total shareowners 2019 returns for our class b common stock , the standard & poor 2019s 500 index , and the dow jones transportation average . the comparison of the total cumulative return on investment , which is the change in the quarterly stock price plus reinvested dividends for each of the quarterly periods , assumes that $ 100 was invested on december 31 , 2005 in the standard & poor 2019s 500 index , the dow jones transportation average , and our class b common stock . comparison of five year cumulative total return $ 40.00 $ 60.00 $ 80.00 $ 100.00 $ 120.00 $ 140.00 $ 160.00 201020092008200720062005 s&p 500 ups dj transport .

Table:
 | 12/31/05 | 12/31/06 | 12/31/07 | 12/31/08 | 12/31/09 | 12/31/10
united parcel service inc . | $ 100.00 | $ 101.76 | $ 98.20 | $ 78.76 | $ 84.87 | $ 110.57
standard & poor 2019s 500 index | $ 100.00 | $ 115.79 | $ 122.16 | $ 76.96 | $ 97.33 | $ 111.99
dow jones transportation average | $ 100.00 | $ 109.82 | $ 111.38 | $ 87.52 | $ 103.79 | $ 131.59
.

Question: what was the difference in percentage cumulative total shareowners 2019 returns for united parcel service inc . versus the standard & poor 2019s 500 index for the five years ended 12/31/10?
Answer: -1.42%
Calculation: subtract(110.57, const_100), divide(#0, const_100), subtract(111.99, const_100), divide(#2, const_100), subtract(#1, #3)
27 Financial risk management (continued)
The table below summarises the Group’s exposure to foreign exchange risk as well as the foreign exchange rates applied:
The approximate impact of a 10 per cent appreciation in foreign exchange rates would be a positive movement of £50.0 million (2018: £63.4 million) to equity attributable to owners of the Group. The approximate impact of a 10 per cent depreciation in foreign exchange rates would be a negative movement of £40.9 million (2018: £51.9 million) to equity attributable to owners of the Group. There is no material income statement impact as these exchange differences are recognised in other comprehensive income.
As part of the strategy to mitigate the Group’s exposure to foreign exchange risk, the Group is able to borrow part of its RCF in euros, up to €100 million. The RCF borrowings denominated in euros have been designated as a hedging instrument (net investment hedge) against the Group’s net investment in Spain with the hedged risk being the changes in the euro/pounds sterling spot rate that will result in changes in the value of the Group’s net investments in Spain. At 31 December 2019, €100 million (2018: €100 million) was drawn in euros.
Table:
 | 2019 | 2018 | 2019 | 2018
 | €m | €m | INRm | INRm
Net exposure | 468.9 | 555.7 | 5,072.4 | 6,274.5
Foreign exchange rate | 1.1825 | 1.1126 | 94.4586 | 88.3432


Question: What is the change in the positive movement of money to equity attributable to owners of the Group when there is a 10 per cent appreciation in foreign exchange rates from 2018 to 2019?
Answer: -13.4
Calculation: 50.0-63.4
Research and Development
Research and development expenses increased $124.3 million, or 53.9%, for the year ended December 31, 2019 compared to the same period in 2018, due to an increase of $114.4 million in employee-related costs ($45.1 million of which related to stock-based compensation and related payroll taxes), a $7.4 million increase in computer hardware and software costs, and a $2.5 million increase in professional services fees, all as a result of growth in our research and development employee base and expanded development programs.
Research and development expenses increased $94.7 million, or 69.6%, for the year ended December 31, 2018 compared to the same period in 2017, due to an increase of $89.6 million in employee-related costs, an increase of $3.1 million in computer hardware and software costs, and a $2.0 million increase in professional services fees, all as a result of growth in our research and development employee base and expanded development programs.
Table:
 | Years ended December 31, |  |  | 2019 vs 2018 | 2018 vs 2017
 | 2019 | 2018 | 2017 | % Change | % Change
 | (in thousands, except percentages) |  |  |  | 
Research and development | $ 355,015 | $ 230,674 | $ 135,997 | 53.9 % | 69.6 %
Percentage of total revenues | 22.5 % | 21.5 % | 20.2 % |  | 


Question: Between year ended 2018 and 2019, which year had higher research and development expenses?
Answer: 2019
Calculation: 355,015> 230,674
system energy resources , inc . management 2019s financial discussion and analysis also in addition to the contractual obligations , system energy has $ 382.3 million of unrecognized tax benefits and interest net of unused tax attributes and payments for which the timing of payments beyond 12 months cannot be reasonably estimated due to uncertainties in the timing of effective settlement of tax positions . see note 3 to the financial statements for additional information regarding unrecognized tax benefits . in addition to routine spending to maintain operations , the planned capital investment estimate includes specific investments and initiatives such as the nuclear fleet operational excellence initiative , as discussed below in 201cnuclear matters , 201d and plant improvements . as a wholly-owned subsidiary , system energy dividends its earnings to entergy corporation at a percentage determined monthly . sources of capital system energy 2019s sources to meet its capital requirements include : 2022 internally generated funds ; 2022 cash on hand ; 2022 debt issuances ; and 2022 bank financing under new or existing facilities . system energy may refinance , redeem , or otherwise retire debt prior to maturity , to the extent market conditions and interest and dividend rates are favorable . all debt and common stock issuances by system energy require prior regulatory approval . debt issuances are also subject to issuance tests set forth in its bond indentures and other agreements . system energy has sufficient capacity under these tests to meet its foreseeable capital needs . system energy 2019s receivables from the money pool were as follows as of december 31 for each of the following years. .

Table:
2016 | 2015 | 2014 | 2013
( in thousands ) | ( in thousands ) | ( in thousands ) | ( in thousands )
$ 33809 | $ 39926 | $ 2373 | $ 9223
see note 4 to the financial statements for a description of the money pool .
the system energy nuclear fuel company variable interest entity has a credit facility in the amount of $ 120 million scheduled to expire in may 2019 .
as of december 31 , 2016 , $ 66.9 million in letters of credit were outstanding under the credit facility to support a like amount of commercial paper issued by the system energy nuclear fuel company variable interest entity .
see note 4 to the financial statements for additional discussion of the variable interest entity credit facility .
system energy obtained authorizations from the ferc through october 2017 for the following : 2022 short-term borrowings not to exceed an aggregate amount of $ 200 million at any time outstanding ; 2022 long-term borrowings and security issuances ; and 2022 long-term borrowings by its nuclear fuel company variable interest entity .
see note 4 to the financial statements for further discussion of system energy 2019s short-term borrowing limits. .

Question: as of december 31 , 2016 , what is the remaining capacity ( in millions ) for the credit facility scheduled to expire in may 2019?
Answer: 53.1
Calculation: subtract(120, 66.9)