hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
17. Income Taxes
Income before income taxes for the Company’s domestic and foreign operations was as follows:
Table:
 |  | Years Ended June 30, | 
($ in millions) | 2019 | 2018 | 2017
Domestic | $204.2 | $140.3 | $56.0
Foreign | 11.8 | 19.9 | 14.2
Income before income taxes | $216.0 | $160.2 | $70.2


Question: What was the change in Foreign in 2019 from 2018?
Answer: -8.1
Calculation: 11.8-19.9
9. BALANCE SHEET DETAILS
Prepaid expenses and other assets consist of the following (in thousands):
Table:
 | Fiscal year-end | 
 | 2019 | 2018
Prepaid and refundable income taxes | $44,096 | $37,884
Other taxes receivable | 11,208 | 16,930
Prepaid expenses and other assets | 22,689 | 30,266
Total prepaid expenses and other assets | $77,993 | $85,080


Question: What was the percentage change in Prepaid and refundable income taxes from 2018 to 2019?
Answer: 16.4
Calculation: (44,096-37,884)/37,884
During the period 5.0 million (2017/18: 5.0 million) options were granted under the Sharesave Plan, with a weighted average exercise price at the date of exercise of 30 pence per ordinary share (2017/18: 33 pence).
The options outstanding at 30 March 2019 had a weighted average exercise price of 32 pence (2017/18: 33 pence), and a weighted average remaining contractual life of 1.6 years (2017/18: 1.6 years).
In 2018/19, the Group recognised an expense of £2.1m (2017/18: £2.8m), related to all equity-settled share-based payment transactions.
Premier Foods plc Sharesave Plan
Table:
 | 2018/19 |  | 2017/18 | 
 |  | Weighted average exercise price |  | Weighted average exercise price
 | Options | (p) | Options | (p)
Outstanding at the beginning of the period | 17,835,628 | 33 | 20,231,334 | 35
Exercised during the period | (4,306,470) | 32 | (3,536,539) | 34
Granted during the period | 5,022,240 | 30 | 4,988,669 | 33
Forfeited/lapsed during the period | (2,447,511) | 33 | (3,847,836) | 44
Outstanding at the end of the period | 16,103,887 | 32 | 17,835,628 | 33
Exercisable at the end of the period | 2,673,154 | 32 | 792,451 | 35


Question: What is the change in options granted between 2017/18 and 2018/19?
Answer: 33571
Calculation: 5,022,240 - 4,988,669
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 average income from operations in 2018 and 2019?
Answer: 4717
Calculation: (4,461+ 4,973)/2
Note 3 – Net Income per Share
The following table sets forth the computation of basic and diluted earnings per share:
Table:
 |  | Fiscal Year Ended | 
 | December 27, 2019  | December 28, 2018  | December 29, 2017
Net income per share: |  |  | 
Basic | $0.82 | $0.71 | $0.55
Diluted | $0.81 | $0.70 | $0.54
Weighted average common shares: |  |  | 
Basic | 29,532,342 | 28,703,265 | 26,118,482
Diluted | 30,073,338 | 29,678,919 | 27,424,526


Question: Which year has the highest net income per basic share?
Answer: 2019
Calculation: $0.82>$0.71>$0.55
We recorded $14.2 million, $15.2 million and $12.3 million of amortization related to our intangible assets for the years ended December 31, 2019, 2018 and 2017, respectively. There were no impairments of long-lived assets during the years ended December 31, 2019, 2018 and 2017.
The following tables reflect the weighted-average remaining life and carrying value of finite-lived intangible assets (in thousands, except weighted-average remaining life):
Table:
 |  | December 31, 2019 |  | 
 | Gross Carrying Amount | Accumulated Amortization | Net Carrying Value | Weighted- Average Remaining Life
Customer relationships | $123,731 | $(39,335) | $84,396 | 9.8
Developed technology | 30,542 | (13,722) | 16,820 | 8.7
Trade name | 3,304 | (1,082) | 2,222 | 4.8
Other | 234 | (234) | — | —
Total intangible assets | $157,811 | $(54,373) | $103,438 | 


Question: What was the amortization related to the company's intangible assets in 2019?
Answer: $14.2 million
Cash and Cash Equivalents and Restricted Cash: Cash equivalents include short-term highly liquid investments and are classified as Level 1 in the fair value hierarchy described below. Restricted cash represents cash received from customers to settle invoices sold under accounts receivable purchase agreements that is contractually required to be set aside. The restrictions will lapse when the cash is remitted to the purchaser of the receivables. Restricted cash is also classified as Level 1 in the fair value hierarchy described below.
As of September 28, 2019 and September 29, 2018, cash and cash equivalents and restricted cash consisted of the following (in thousands):
Table:
 | 2019 | 2018
Cash | $85,688 | $99,197
Money market funds and other | 138,073 | 198,072
Restricted cash | 2,493 | 417
Total cash and cash equivalents and restricted cash | 226,254 | 297,686


Question: How many years did the Money market funds and other exceed $100,000 thousand?
Answer: 2
Calculation: 2019##2018
Sales and Marketing Expense
Sales and marketing expense increased by $22.6 million in 2018 compared to 2017. The increase was primarily due to a $20.0 million increase in employee- related costs, which includes stock-based compensation, associated with our increased headcount from 215 employees as of December 31, 2017 to 286 employees as of December 31, 2018. The remaining increase was principally the result of a $1.8 million increase in trade show and advertising costs and a $0.8 million increase attributed to office related expenses to support the sales team. The adoption of ASC 606 did not have a material impact on the change in commission expense when compared to year over year.
Table:
 | Year Ended December 31, |  | Change | 
 | 2018 | 2017 | $ | %
 |  | (dollars in thousands) |  | 
Sales and marketing | $ 69,608 | $ 46,998 | $ 22,610 | 48.1%
% of revenue | 47% | 45% |  | 


Question: What is the average Sales and marketing expense for 2017 and 2018?
Answer: 58303
Calculation: (69,608 + 46,998) / 2
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
Information about receivables, contract assets and contract liabilities from contracts with tenants is as follows:
(1) Prior-period amounts adjusted with the adoption of the new lease accounting guidance, as applicable.
(2) Excludes $56.7 million and $55.0 million of capital contributions related to DAS networks as of December 31, 2019 and 2018, respectively.
(3) Excludes $300.2 million and $313.6 million of capital contributions related to DAS networks as of December 31, 2019 and 2018, respectively.
The Company records unearned revenue when payments are received from tenants in advance of the completion of the Company’s performance obligations. Long-term unearned revenue is included in Other non-current liabilities. During the year ended December 31, 2019, the Company recognized $62.2 million of revenue that was included in the Unearned revenue balance as of December 31, 2018. During the year ended December 31, 2018, the Company recognized $44.4 million of revenue that was included in the Unearned revenue balance as of January 1, 2018. The Company also recognized revenues of $59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during each of the years ended December 31, 2019 and 2018. $59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during each of the years ended December 31, 2019 and 2018.
$59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital
contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during
each of the years ended December 31, 2019 and 2018.
Table:
 | December 31, 2019 | December 31, 2018 (1)
Accounts receivable | $80.5 | $92.6
Prepaids and other current assets | 8.3 | 7.7
Notes receivable and other non-current assets | 21.3 | 22.2
Unearned revenue (2) | 35.0 | 35.0
Other non-current liabilities (3) | 79.0 | 54.1


Question: What does Other non-current liabilities exclude?
Answer: Excludes $300.2 million and $313.6 million of capital contributions related to DAS networks as of December 31, 2019 and 2018, respectively.
Assumptions used
The last triennial actuarial valuation of the Scheme was performed by an independent professional actuary at 30 April 2018 using the projected unit method of valuation. For the purposes of IAS 19 (revised) the actuarial valuation as at 30 April 2018 has been updated on an approximate basis to 31 March 2019. There have been no changes in the valuation methodology adopted for this year’s disclosures compared to the prior year’s disclosures.
The principal financial assumptions used to calculate the liabilities under IAS 19 (revised) are as follows:
The financial assumptions reflect the nature and term of the Scheme’s liabilities.
Table:
 | 2019 | 2018
 | % | %
Discount rate for scheme liabilities | 2.45 | 2.60
CPI inflation | 2.35 | 2.25
RPI inflation | 3.45 | 3.35
Pension increases |  | 
Pre 1988 GMP | – | –
Post 1988 GMP | 2.10 | 2.10
Pre 2004 non GMP | 5.00 | 5.00
Post 2004 | 3.35 | 3.25


Question: In which year was CPI inflation percentage larger?
Answer: 2019
Calculation: 2.35%>2.25%
Vesting of Equity Awards During 2019
The following table provides details regarding the equity awards held by our named executives that vested during 2019. Restricted stock and restricted stock units were the only equity awards held by our named executives during 2019.
(1) Represents both time-vested and performance-based equity awards that vested during 2019. For details on the payout of our performance-based equity awards, please see “Compensation Discussion and Analysis—Our 2019 Compensation Program and Components of Pay—Grants of Long Term Incentive Compensation—Long Term Incentive Performance Updates” and “—Our Compensation Philosophy Objectives and Linkage to Corporate Strategy—Overview of Pay Elements and Linkage to Compensation Philosophy and Corporate Strategy.”
(2) Based on the closing trading price of the Common Shares on the applicable vesting date.
Table:
 | Stock Vested During 2019 | 
Name | Number of Shares Acquired on Vesting(1) | Value Realized on Vesting(2)
Mr. Storey | 1,063,929 | $13,479,617
Mr. Dev | 55,490 | 749,737
Mr. Goff | 114,167 | 1,338,934
Mr. Trezise | 71,576 | 812,600
Mr. Andrews | 16,678 | 221,859


Question: What is the average number of shares acquired on vesting?
Answer: 264368
Calculation: (1,063,929+55,490+114,167+71,576+16,678)/5
performance graph the graph below compares the cumulative total shareholder return on pmi's common stock with the cumulative total return for the same period of pmi's compensation survey group and the s&p 500 index . the graph assumes the investment of $ 100 as of december 31 , 2010 , in pmi common stock ( at prices quoted on the new york stock exchange ) and each of the indices as of the market close and reinvestment of dividends on a quarterly basis . date pmi pmi compensation survey group ( 12 ) s&p 500 index .

Table:
date | pmi | pmi compensation survey group ( 12 ) | s&p 500 index
december 31 2010 | $ 100.00 | $ 100.00 | $ 100.00
december 31 2011 | $ 139.80 | $ 114.10 | $ 102.10
december 31 2012 | $ 154.60 | $ 128.00 | $ 118.50
december 31 2013 | $ 167.70 | $ 163.60 | $ 156.80
december 31 2014 | $ 164.20 | $ 170.10 | $ 178.30
december 31 2015 | $ 186.20 | $ 179.20 | $ 180.80
( 1 ) the pmi compensation survey group consists of the following companies with substantial global sales that are direct competitors ; or have similar market capitalization ; or are primarily focused on consumer products ( excluding high technology and financial services ) ; and are companies for which comparative executive compensation data are readily available : bayer ag , british american tobacco p.l.c. , the coca-cola company , diageo plc , glaxosmithkline , heineken n.v. , imperial brands plc ( formerly , imperial tobacco group plc ) , johnson & johnson , mcdonald's corp. , international , inc. , nestl e9 s.a. , novartis ag , pepsico , inc. , pfizer inc. , roche holding ag , unilever nv and plc and vodafone group plc .
( 2 ) on october 1 , 2012 , international , inc .
( nasdaq : mdlz ) , formerly kraft foods inc. , announced that it had completed the spin-off of its north american grocery business , kraft foods group , inc .
( nasdaq : krft ) .
international , inc .
was retained in the pmi compensation survey group index because of its global footprint .
the pmi compensation survey group index total cumulative return calculation weights international , inc.'s total shareholder return at 65% ( 65 % ) of historical kraft foods inc.'s market capitalization on december 31 , 2010 , based on international , inc.'s initial market capitalization relative to the combined market capitalization of international , inc .
and kraft foods group , inc .
on october 2 , 2012 .
note : figures are rounded to the nearest $ 0.10. .

Question: what is the roi of an investment in s&p 500 in 2010 and liquidated in 2011?
Answer: 2.1%
Calculation: subtract(102.10, const_100), divide(#0, const_100)
Underlying operating profit and underlying operating margin
Underlying operating profit and underlying operating margin mean operating profit and operating margin before the impact of non-underlying items within operating profit. Underlying operating profit represents our measure of segment profit or loss as it is the primary measure used for making decisions about allocating resources and assessing performance of the segments.
The Group reconciliation of operating profit to underlying operating profit is as follows:
Further details of non-underlying items can be found in note 3 on page 96 of the consolidated financial statements.
Refer to Note 2 on page 94 for the reconciliation of operating profit to underlying operating profit by Division. For each Division operating margin is computed as operating profit divided by turnover and underlying operating margin is computed as underlying operating profit divided by turnover.
Table:
 | € million | € million | € million
 | 2019 | 2018 | 2017
 |  | (Restated)(a) | (Restated)(a)
Operating profit | 8,708 | 12,639 | 8,957
Non-underlying items within |  |  | 
operating profit (see note 3) | 1,239 | (3,176) | 543
Underlying operating profit | 9,947 | 9,463 | 9,500
Turnover | 51,980 | 50,982 | 53,715
Operating margin | 16.8% | 24.8% | 16.7%
Underlying operating margin | 19.1% | 18.6% | 17.7%


Question: What is the increase / (decrease) in the operating margin from 2018 to 2019?
Answer: -8
Calculation: 16.8 - 24.8
NOTE 7 - continued
Lease payments not recognized as a liability The Group has elected not to recognize a lease liability for short-term leases (leases of an expected term of 12 months or less) or for leases of low value assets. Payments made under such leases are expensed on a straight-line basis. The expenses relating to payments not recognized as a lease liability are insignificant.
Administrative expenses The total outflow for leases, USD 2.9m, is presented as “Depreciation” of USD 2.5m and “Financial expenses” (interest) of USD 0.4m, in contrast to the recording of an operating lease charge of a materially equivalent figure within the line item “Administrative expenses” under IAS 17.
Financial expenses
Financial expenses for the reporting periods:
Table:
USDm | 2019 | 2018 | 2017
Interest expenses: | - | - | -
Financial expenses arising from lease liabilities regarding right-of-use assets | 2.4 | 2.3 | 1.8
Other financial expenses | 39.5 | 37.0 | 38.8
Total | 41.9 | 39.3 | 40.6


Question: What does the table show?
Answer: Financial expenses for the reporting periods
12. Derivative Instruments
(a) Summary of Derivative Instruments
We use derivative instruments primarily to manage exposures to foreign currency exchange rate, interest rate, and equity price risks. Our primary objective in holding derivatives is to reduce the volatility of earnings and cash flows associated with changes in foreign currency exchange rates, interest rates, and equity prices. Our derivatives expose us to credit risk to the extent that the counterparties may be unable to meet the terms of the agreement. We do, however, seek to mitigate such risks by limiting our counterparties to major financial institutions. In addition, the potential risk of loss with any one counterparty resulting from this type of credit risk is monitored. Management does not expect material losses as a result of defaults by counterparties.
The notional amounts of our outstanding derivatives are summarized as follows (in millions):
Table:
 | July 27, 2019 | July 28, 2018
Derivatives designated as hedging instruments: |  | 
Foreign currency derivatives—cash flow hedges | $663 | $147
Interest rate derivatives | 4,500 | 6,750
Net investment hedging instruments | 309 | 250
Derivatives not designated as hedging instruments: |  | 
Foreign currency derivatives | 2,708 | 2,298
Total return swaps—deferred compensation | 574 | 566
Total | $8,754 | $10,011


Question: How many years did foreign currency derivatives exceed $2,000 million?
Answer: 2
Calculation: 2019##2018
the following is a schedule of future minimum rental payments required under long-term operating leases at october 29 , 2011 : fiscal years operating leases .

Table:
fiscal years | operating leases
2012 | $ 17590
2013 | 12724
2014 | 6951
2015 | 5649
2016 | 3669
later years | 19472
total | $ 66055
12 .
commitments and contingencies from time to time in the ordinary course of the company 2019s business , various claims , charges and litigation are asserted or commenced against the company arising from , or related to , contractual matters , patents , trademarks , personal injury , environmental matters , product liability , insurance coverage and personnel and employment disputes .
as to such claims and litigation , the company can give no assurance that it will prevail .
the company does not believe that any current legal matters will have a material adverse effect on the company 2019s financial position , results of operations or cash flows .
13 .
retirement plans the company and its subsidiaries have various savings and retirement plans covering substantially all employees .
the company maintains a defined contribution plan for the benefit of its eligible u.s .
employees .
this plan provides for company contributions of up to 5% ( 5 % ) of each participant 2019s total eligible compensation .
in addition , the company contributes an amount equal to each participant 2019s pre-tax contribution , if any , up to a maximum of 3% ( 3 % ) of each participant 2019s total eligible compensation .
the total expense related to the defined contribution plan for u.s .
employees was $ 21.9 million in fiscal 2011 , $ 20.5 million in fiscal 2010 and $ 21.5 million in fiscal 2009 .
the company also has various defined benefit pension and other retirement plans for certain non-u.s .
employees that are consistent with local statutory requirements and practices .
the total expense related to the various defined benefit pension and other retirement plans for certain non-u.s .
employees was $ 21.4 million in fiscal 2011 , $ 11.7 million in fiscal 2010 and $ 10.9 million in fiscal 2009 .
non-u.s .
plan disclosures the company 2019s funding policy for its foreign defined benefit pension plans is consistent with the local requirements of each country .
the plans 2019 assets consist primarily of u.s .
and non-u.s .
equity securities , bonds , property and cash .
the benefit obligations and related assets under these plans have been measured at october 29 , 2011 and october 30 , 2010 .
analog devices , inc .
notes to consolidated financial statements 2014 ( continued ) .

Question: what was the difference in percentage that total expenses changed between the us and non-us employees from 2009 to 2011?
Answer: the non-us employees had a change of 94.4% greater than the us employees
Calculation: subtract(21.4, 10.9), divide(#0, 10.9), subtract(21.9, 21.5), divide(#2, 21.5), subtract(#1, #3)
Acquisition-Related Expenses
We have incurred acquisition-related expenses related to our acquisition of Level 3. The table below summarizes our acquisition-related expenses, which consist of integration and transformation-related expenses, including severance and retention compensation expenses, and transaction-related expenses:
At December 31, 2019, we had incurred cumulative acquisition-related expenses of $950 million for Level 3. The total amounts of these expenses are included in our selling, general and administrative expenses.
Level 3 incurred transaction-related expenses of $47 million on the date of acquisition. This amount is not included in our results of operations.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (Dollars in millions) | 
Transaction-related expenses | $— | 2 | 174
Integration and transformation-related expenses | 234 | 391 | 97
Total acquisition-related expenses | $234 | 393 | 271


Question: What is the change in the total acquisition-related expense in 2019 from 2018?
Answer: -159
Calculation: 234-393
Financial Statement Impact of Adoption on Previously Reported Results
We adopted Topic 606 using the modified retrospective method. The cumulative impact of applying the new guidance to all contracts with customers that were not completed as of April 1, 2018 was recorded as an adjustment to retained earnings as of the adoption date. As a result of applying the modified retrospective method to adopt the new standard, the following adjustments were made to noted accounts on the Consolidated Balance Sheet as of April 1, 2018:
The acceleration of revenue that was deferred under prior guidance as of the adoption date was primarily attributable to the requirement of Topic 606 to allocate the transaction price to the performance obligations in the contract on a relative basis using SSP rather than allocating under the residual method, which allocates the entire arrangement discount to the delivered performance obligations.
Due to the Company's full valuation allowance as of the adoption date, there is no tax impact associated with the adoption of Topic 606.
We made certain presentation changes to our Consolidated Balance Sheet on April 1, 2018 to comply with Topic 606. Prior to adoption of the new standard, we offset accounts receivable and contract liabilities (previously presented as deferred revenue on our Consolidated Balance Sheet) for unpaid deferred performance obligations included in contract liabilities.
Under the new standard, we record accounts receivable and related contract liabilities for non-cancelable contracts with customers when the right to consideration is unconditional. Upon adoption, the right to consideration in exchange for goods or services that have been transferred to a customer when that right is conditional on something other than the passage of time were reclassified from accounts receivable to contract assets.
Table:
(In thousands) | March 31, 2018 | Adjustment from Topic 606 | April 1, 2018
Assets: |  |  | 
Accounts receivable, net | 16,389 | 3,124 | 19,513
Contract assets | — | 4,583 | 4,583
Prepaid expenses and other current assets | 5,593 | (496) | 5,097
Other non-current assets | 2,484 | 2,409 | 4,893
Liabilities: |  |  | 
Contract liabilities | 26,820 | 7,006 | 33,826
Shareholders' equity: |  |  | 
Retained earnings | 103,601 | 2,614 | 106,215


Question: What was the adjustment amount to accounts receivable, net?
Answer: 3,124