hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Deferred revenue and financed unearned services revenue (in millions):
The following table summarizes the components of our deferred revenue and financed unearned services balance as reported in our consolidated balance sheets (in millions):
Deferred product revenue represents unrecognized revenue related to undelivered product commitments and other product deliveries that have not met all revenue recognition criteria. Deferred services revenue represents customer payments made in advance for services, which include software and hardware maintenance contracts and other services. Financed unearned services revenue represents undelivered services for which cash has been received under certain third-party financing arrangements. See Note 18 – Commitments and Contingencies for additional information related to these arrangements
Table:
 | April 26, 2019 | April 27, 2018
Deferred product revenue | $ 84 | $ 107
Deferred services revenue | 3,502 | 3,134
Financed unearned services revenue | 82 | 122
Total | $ 3,668 | $ 3,363
Reported as: |  | 
Short-term | $ 1,825 | $ 1,712
Long-term | 1,843 | 1,651
Total | $ 3,668 | $ 3,363


Question: What was the percentage change in revenues reported as long-term between 2018 and 2019?
Answer: 11.63
Calculation: (1,843-1,651)/1,651
Presentation of Derivative Gains (Losses) for Economic Hedges of Forecasted Cash Flows in Segment Results
Derivatives used to manage commodity price risk and foreign currency risk are not designated for hedge accounting treatment. We believe these derivatives provide economic hedges of certain forecasted transactions. As such, these derivatives are recognized at fair market value with realized and unrealized gains and losses recognized in general corporate expenses. The gains and losses are subsequently recognized in the operating results of the reporting segments in the period in which the underlying transaction being economically hedged is included in earnings. In the event that management determines a particular derivative entered into as an economic hedge of a forecasted commodity purchase has ceased to function as an economic hedge, we cease recognizing further gains and losses on such derivatives in corporate expense and begin recognizing such gains and losses within segment operating results, immediately.
The following table presents the net derivative gains (losses) from economic hedges of forecasted commodity consumption and the foreign currency risk of certain forecasted transactions, under this methodology:
As of May 26, 2019, the cumulative amount of net derivative gains from economic hedges that had been recognized in general corporate expenses and not yet allocated to reporting segments was $1.4 million. This amount reflected net gains of $1.0 million incurred during the fiscal year ended May 26, 2019, as well as net gains of $0.4 million incurred prior to fiscal 2019. Based on our forecasts of the timing of recognition of the underlying hedged items, we expect to reclassify to segment operating results gains of $0.9 million in fiscal 2020 and $0.5 million in fiscal 2021 and thereafter.
Notes to Consolidated Financial Statements - (Continued) Fiscal Years Ended May 26, 2019, May 27, 2018, and May 28, 2017 (columnar dollars in millions except per share amounts)
Table:
 | 2019 | 2018 | 2017
Net derivative gains (losses) incurred | $(3.6) | $(0.9) | $0.6
Less: Net derivative gains (losses) allocated to reporting segments | (1.8) | (7.1) | 5.7
Net derivative gains (losses) recognized in general corporate expenses | $(1.8) | $6.2 | $(5.1)
Net derivative gains (losses) allocated to Grocery & Snacks | $(2.1) | $0.2 | $3.4
Net derivative gains (losses) allocated to Refrigerated & Frozen | (1.1) | (0.3) | 0.8
Net derivative gains (losses) allocated to International | 2.8 | (6.9) | 1.6
Net derivative losses allocated to Foodservice | (0.6) | (0.1) | —
Net derivative losses allocated to Pinnacle Foods | (0.8) | — | —
Net derivative losses allocated to Commercial | — | — | (0.1)
Net derivative gains (losses) included in segment operating profit | $(1.8) | $(7.1) | $5.7


Question: What does the table show us?
Answer: the net derivative gains (losses) from economic hedges of forecasted commodity consumption and the foreign currency risk of certain forecasted transactions
12. Earnings per share How are earnings per share calculated?
Basic earnings per share is calculated by dividing the profit after tax attributable to equity shareholders by the weighted average number of shares in issue after deducting the own shares held by employee share ownership trusts and treasury shares.
In calculating the diluted earnings per share, share options outstanding and other potential shares have been taken into account where the impact of these is dilutive. Options over 36m shares (2017/18: 23m shares, 2016/17: 27m shares) were excluded from the calculation of the total diluted number of shares as the impact of these is antidilutive.
The earnings per share calculations are based on profit after tax attributable to equity shareholders of the parent company which excludes non-controlling interests. Profit after tax was £2,159m (2017/18: £2,032m, 2016/17: £1,908m) and profit after tax attributable to non-controlling interests was £3m (2017/18: £4m, 2016/17: £1m). Profit attributable to non-controlling interests is not presented separately in the financial statements as it is not material.
Table:
Year ended 31 March | 2019 | 2018 | 2017
Basic weighted average number of shares (millions) | 9,912 | 9,911 | 9,938
Dilutive shares from share options (millions) | 6 | 2 | 27
Dilutive shares from executive share awards (millions) | 57 | 48 | 29
Diluted weighted average number of shares (millions) | 9,975 | 9,961 | 9,994
Basic earnings per share | 21.8p | 20.5p | 19.2p
Diluted earnings per share | 21.6p | 20.4p | 19.1p


Question: What was the  Basic weighted average number of shares (millions)  in 2019?
Answer: 9,912
SHARE INFORMATION
On December 31, 2019, the total number of issued common shares of ASMI amounted to 51,297,394 compared to 56,297,394 at year-end 2018. The decrease was the result of the cancellation of 5 million treasury shares that was approved by the Annual General Meeting of Shareholders (AGM) on May 20, 2019, and became effective on July 23, 2019.
On December 31, 2019, we had 48,866,220 outstanding common shares excluding 2,431,174 treasury shares. This compared to 49,318,898 outstanding common shares and 6,978,496 treasury shares at year-end 2018. Besides the cancellation of 5 million treasury shares in July 2019, the change in the number of treasury shares in 2019 was the result of approximately 951,000 repurchased shares and approximately 498,000 treasury shares that were used as part of share based payments.
On December 31, 2019, 48,583,340 of the outstanding common shares were registered with our transfer agent in the Netherlands, ABN AMRO Bank NV; and 282,880 were registered with our transfer agent in the United States, Citibank, NA, New York.
On February 25, 2020, ASMI announced that it will propose to the AGM 2020 the cancellation of 1.5 million treasury shares, as the number of 2.4 million treasury shares held at that date was more than sufficient to cover our outstanding options and restricted/performance shares.
Table:
 | 2018 | 2019
As per January 1: |  | 
Issued shares | 62,297,394 | 56,297,394
Treasury shares | 6,157,241 | 6,978,496
Outstanding shares | 56,140,153 | 49,318,898
Changes during the year: |  | 
Cancellation of treasury shares | 6,000,000 | 5,000,000
Share buybacks | 7,242,734 | 950,902
Treasury shares used for share based performance programs | 421,479 | 498,224
As per December 31: |  | 
Issued shares | 56,297,394 | 51,297,394
Treasury shares | 6,978,496 | 2,431,174
Outstanding shares | 49,318,898 | 48,866,220


Question: Where are the outstanding common shares registered with in 2019?
Answer: Netherlands, ABN AMRO Bank NV, United States, Citibank, NA, New York
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
NOTE 11. PROPERTY AND EQUIPMENT, NET
Property and equipment, net is comprised of the following:
Table:
 | December 31, | 
 | 2019 | 2018
Buildings and land | $1,693 | $1,737
Machinery and equipment | 108,945 | 41,330
Computer and communication equipment | 29,106 | 24,051
Furniture and fixtures | 4,119 | 3,203
Vehicles | 262 | 282
Leasehold improvements | 33,041 | 20,593
Construction in process | 9,089 | 867
 | 186,255 | 92,063
Less: Accumulated depreciation | (78,146) | (60,794)
Property and equipment, net | $108,109 | $31,269


Question: What was the percentage change in the net property and equipment between 2018 and 2019?
Answer: 245.74
Calculation: ($108,109-$31,269)/$31,269
9. Pensions continued
Defined benefit plans continued
iii) Amount, timing and uncertainty of future cash flows continued
The liability has the following duration and maturity:
Table:
 | 2019 | 2018
Weighted average duration of the defined benefit obligation (years) | 14 | 15
Maturity analysis of benefit payments (non-discounted amounts) $ million |  | 
Maturity ≤ 1 year | 10.8 | 10.4
Maturity > 1 ≤ 5 years | 45.6 | 43.2
Maturity > 5 ≤ 10 years | 61.7 | 119.0
Maturity > 10 ≤ 20 years | 114.3 | 103.0
Maturity > 20 ≤ 30 years | 81.7 | 68.0
Maturity > 30 years | 63.0 | 42.9


Question: What was the change in the benefit payments (non-discounted amounts) for maturity > 30 years?
Answer: 20.1
Calculation: 63.0-42.9
Disaggregation of revenue
The following table provides information about disaggregated revenue by primary geographical markets:
The Company derived over 90%, and approximately 88% and 84% of subscription revenues from RingCentral Office product for the years ended December 31, 2019, 2018 and 2017, respectively
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Primary geographical markets |  |  | 
North America | 93% | 95% | 96%
Others | 7% | 5% | 4%
Total revenues | 100% | 100% | 100%


Question: What is the average percentage of revenue earned in North America between 2017 to 2019?
Answer: 94.67
Calculation: (93 + 95 +96)/3
NOTE 22. INCOME TAXES
Amounts recognized in profit or loss
The income tax expense consists of:
Table:
 | Year ended December 31, | 
 | 2018 | 2019
Current: |  | 
The Netherlands | (4,128) | (28,409)
Other countries | (6,374) | (9,011)
 | (10,502) | (37,420)
Deferred: |  | 
The Netherlands | 1,944 | (6,860)
Other countries | (6,878) | (9,370)
Income tax expense | (15,436) | (53,650)


Question: What is the change in total Current income tax expense from 2018 to 2019?
Answer: -26918
Calculation: -37,420-(-10,502)
Subsequent to the year end, we have received the final ratifications required for full planning to become effective and therefore we expect the positive impact on retained earnings to reverse once these arrangements are formally concluded. In this event EPRA NAV per share would have been 143 pence.
Debt measures
A Debt to asset ratio
Our debt to assets ratio increased to 67.8 per cent in 2019 due to the property revaluation deficit in the year. This reduces to 65.3 per cent when adjusted for expected disposal proceeds from intu Puerto Venecia and intu Asturias.
B Interest cover
Interest cover of 1.67x remains above our target minimum level of 1.60x although it has reduced in 2019 as a result of the reduction in net rental income.
C Immediately available cash and facilities
Immediately available cash and facilities has reduced in the year by £5.3 million to £241.5 million at 31 December 2019. This excludes the rents collected at the end of December 2019 which relate to the first quarter of 2020 and remain in the debt structures until interest payments are made. At 10 March 2020, immediately available cash and facilities is £200.3 million, which will be augmented by the intu Puerto Venecia sales proceeds expected to be received in early April.
Table:
 | Notes | 2019 | 2018 | Change
Debt to assets ratio | A | 67.8% | 53.1% | 14.7%
Interest cover | B | 1.67x | 1.91x | –0.24x
Weighted average debt maturity |  | 5.0 years | 5.8 years | –0.8 years
Weighted average cost of gross debt (excluding RCF) |  | 4.3% | 4.2% | –0.1%
Proportion of gross debt with interest rate protection |  | 88% | 84% | 4%
Immediately available cash and facilities | C | £241.5m | £246.8m | £(5.3)m


Question: What is the weighted average cost of gross debt (excluding RCF) in 2019?
Answer: 4.3
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
In February 2018, Advanced Energy acquired Trek Holding Co., LTD ("Trek"), a privately held company with operations in Tokyo, Japan and Lockport, New York, for $6.1 million, net of cash acquired. Trek has a 95% ownership interest in its U.S. subsidiary which is also its primary operation.
The components of the fair value of the total consideration transferred for our 2018 acquisitions are as follows:
Table:
 | Trek | Electrostatic Product Line | LumaSense | Total
Cash paid for acquisition | $11,723 | $3,000 | $94,946 | $ 109,669
Less cash acquired | (5,651) | — | (10,262) | (15,913)
Total purchase price | $6,072 | $3,000 | $84,684 | $ 93,756


Question: What is the average total purchase price amongst the three companies?
Answer: 31252
Calculation: ($6,072+$3,000+$84,684)/3
s c h e d u l e i v ( continued ) ace limited and subsidiaries s u p p l e m e n t a l i n f o r m a t i o n c o n c e r n i n g r e i n s u r a n c e premiums earned for the years ended december 31 , 2008 , 2007 , and 2006 ( in millions of u.s . dollars ) direct amount ceded to companies assumed from other companies net amount percentage of amount assumed to .

Table:
for the years ended december 31 2008 2007 and 2006 ( in millions of u.s . dollars ) | direct amount | ceded to other companies | assumed from other companies | net amount | percentage of amount assumed to net
2008 | $ 16087 | $ 6144 | $ 3260 | $ 13203 | 25% ( 25 % )
2007 | $ 14673 | $ 5834 | $ 3458 | $ 12297 | 28% ( 28 % )
2006 | $ 13562 | $ 5198 | $ 3461 | $ 11825 | 29% ( 29 % )
.

Question: what is the growth rate of net amount from 2007 to 2008?
Answer: 7.4%
Calculation: subtract(13203, 12297), divide(#0, 12297)
Uncertain Tax Positions
In accordance with authoritative guidance, the impact of an uncertain income tax position on the income tax return must be recognized at the largest amount that is more-likely-than-not to be sustained upon audit by the relevant taxing authority. An uncertain income tax position will not be recognized if it has less than a 50% likelihood of being sustained.
The following table reconciles the beginning and ending amount of unrecognized tax benefits for the fiscal years ended September 30, 2019, 2018,and 2017 (amounts shown in thousands):
Of the total unrecognized tax benefits at September 30, 2019, $1.6 million will impact the Company’s effective tax rate. The Company does not anticipate that there will be a substantial change in unrecognized tax benefits within the next twelve months.
The Company's practice is to recognize interest and/or penalties related to income tax matters in income tax expense. As of September 30, 2019, no accrued interest or penalties related to uncertain tax positions are recorded in the consolidated financial statements.
The Company is subject to income taxation in the U.S. at the federal and state levels. All tax years are subject to examination by U.S., California, and other state tax authorities due to the carryforward of unutilized net operating losses and tax credits. The Company is also subject to foreign income taxes in the countries in which it operates. The Company’s U.S. federal tax return for the year ended September 30, 2017 is currently under examination. To our knowledge, the Company is not currently under examination by any other taxing authorities.
Table:
 | 2019 | 2018 | 2017
Gross unrecognized tax benefits at the beginning of the year | $1,321 | $1,181 | $—
Additions from tax positions taken in the current year | 213 | 140 | 140
Additions from tax positions taken in prior years | 73 | — | 1,041
Reductions from tax positions taken in prior years | — | — | —
Tax settlements | — | — | —
Gross unrecognized tax benefits at end of the year | $1,607 | $1,321 | $1,181


Question: What is the condition when an uncertain income tax position will not be recognized?
Answer: if it has less than a 50% likelihood of being sustained
Adjusted EBITDA Non-GAAP Reconciliation
(UNAUDITED)
($ in millions)
(1) Refer to Non-GAAP Integration and Transformation Costs and Special Items table for details of the integration and transformation costs and special items included above.
Table:
 |  |  | Pro Forma (1)
 | 2019 | 2018 | 2017
Net income (loss) | $(5,269) | (1,733) | 1,508
Income tax expense | 503 | 170 | (770)
Total other expense, net | 2,040 | 2,133 | 2,147
Depreciation and amortization expense | 4,829 | 5,120 | 5,125
Share-based compensation expenses | 162 | 186 | 238
Goodwill impairment | 6,506 | 2,726 | 0
Adjusted EBITDA | 8,771 | 8,602 | 8,248
Exclude: transaction related expenses | 0 | 0 | 192
Exclude: integration and transformation costs(1) | 234 | 378 | 164
Exclude: special items(1) | 65 | 60 | 82
Adjusted EBITDA excluding integration and transformation costs and special items | $9,070 | 9,040 | 8,686
Total revenue | $22,401 | 23,443 | 24,128
Adjusted EBITDA Margin | 39.2% | 36.7% | 34.2%
Adjusted EBITDA Margin, excluding integration and transformation costs and special items | 40.5% | 38.6% | 36.0%


Question: What is the average total revenue across the three years?
Answer: 23324
Calculation: ($22,401+$23,443+$24,128)/3
Stock-based compensation expense is included in the following captions of the consolidated statements of comprehensive income (loss) (in thousands): Stock-based compensation expense is included in the following captions of the consolidated statements of comprehensive income (loss) (in thousands):
As of February 28, 2019, there was $25.5 million of unrecognized stock-based compensation cost related to non-vested equity awards, which is expected to be recognized over a weighted-average remaining vesting period of 2.8 years.
Table:
 |  | Year Ended February 28, | 
 | 2019 | 2018 | 2017
Cost of revenues | $723 | $653 | $374
Research and development | 2,061 | 1,471 | 1,033
Selling and marketing | 2,863 | 2,314 | 1,655
General and administrative | 5,382 | 4,860 | 4,771
 | $11,029 | $9,298 | $7,833


Question: How much was the cost of revenues in 2019?
Answer: $723
UK OPERATING COSTS
UK operating costs decreased 1.2%. Store closures more than offset the cost of new space and channel shift. Cost savings across the business outweighed inflation related increases.
Store staffing costs reduced, as savings from store management restructuring, closures and other efficiencies more than offset pay inflation. Other store costs reduced driven by lower depreciation, due to our closure programme and as a number of assets have reached the end of their useful life, which more than offset rent and rates inflation in the year.
The growth in distribution and warehousing costs was largely driven by inflation and the costs of channel shift, as well as costs associated with the closure of an equipment warehouse, with some offset achieved from improved efficiencies at Castle Donington.
The increase in marketing costs reflected investments in our Food brand and the planned increase in costs in the second half of the year due to the timing of campaigns.
Central costs reduced as lower incentive costs year-on-year, the benefits of technology transformation programmes and other cost efficiencies more than offset system investment write offs and expenditure on the Fuse programme.
Table:
 | 52 weeks ended |  | 
 | 30 Mar 2019 | 31 Mar 2018 | Change
 | £m | £m | %
Store staffing | 1,044.7 | 1,070.6 | -2.4
Other store costs | 950.4 | 992.1 | -4.2
Distribution & warehousing | 564.6 | 538.0 | 4.9
Marketing | 155.1 | 151.6 | 2.3
Central costs | 694.8 | 698.0 | -0.5
Total | 3,409.6 | 3,450.3 | -1.2


Question: What is the operating costs of Distribution & warehousing in 2019 and 2018 respectively?
Answer: 564.6, 538.0
We engaged with Dell in the following ongoing related party transactions, which resulted in costs to us:
• We purchase and lease products and purchase services from Dell.
• From time to time, we and Dell enter into agreements to collaborate on technology projects, and we pay Dell for services provided to us by Dell related to such projects.
• In certain geographic regions where we do not have an established legal entity, we contract with Dell subsidiaries for support services and support from Dell personnel who are managed by us. The costs incurred by Dell on our behalf related to these employees are charged to us with a mark-up intended to approximate costs that would have been incurred had we contracted for such services with an unrelated third party. These costs are included as expenses on our consolidated statements of income and primarily include salaries, benefits, travel and occupancy expenses. Dell also incurs certain administrative costs on our behalf in the U.S. that are recorded as expenses on our consolidated statements of income.
• In certain geographic regions, Dell files a consolidated indirect tax return, which includes value added taxes and other indirect taxes collected by us from our customers. We remit the indirect taxes to Dell and Dell remits the tax payment to the foreign governments on our behalf.
• From time to time, we invoice end users on behalf of Dell for certain services rendered by Dell. Cash related to these services is collected from the end user by us and remitted to Dell.
• From time to time, we also enter into agency arrangements with Dell that enable us to sell our subscriptions and services, leveraging the Dell enterprise relationships and end customer contracts.
Information about our payments for such arrangements during the periods presented consisted of the following (table in millions):
1) Amount includes indirect taxes that were remitted to Dell during the periods presented.
We also purchase Dell products through Dell’s channel partners. Purchases of Dell products through Dell’s channel partners were not significant during the periods presented.
Table:
 |  | For the Year Ended | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Purchases and leases of products and purchases of services(1) | $242 | $200 | $142
Dell subsidiary support and administrative costs | 119 | 145 | 212


Question: Which years does the table provide information for the company's payment arrangements?
Answer: 2020, 2019, 2018