hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Effect of ASC 606 as of December 31, 2018 and for the Year Ended December 31, 2018
The following table summarizes the effect of adopting ASC 606 on our Consolidated Balance Sheet (in millions):
Table:
 | As reported December 31, 2018 | Effect of ASC 606 adoption | Amounts without adoption of ASC 606 December 31, 2018
Trade receivables, net | $172.3 | $6.9 | $179.2
Prepaid expenses and other current assets | 67.3 | (14.4) | 52.9
Receivables from related parties | 6.2 | 4.8 | 11.0
Computer software, net | 405.6 | (3.7) | 401.9
Deferred contract costs, net | 161.3 | (17.2) | 144.1
Other non-current assets | 125.6 | (7.0) | 118.6
Total assets | 3,653.4 | (30.6) | 3,622.8
Deferred revenues (current) | 52.9 | 4.1 | 57.0
Deferred revenues (non-current) | 106.8 | (4.3) | 102.5
Deferred income taxes | 220.9 | (8.1) | 212.8
Total liabilities | 1,866.9 | (8.3) | 1,858.6
Retained earnings | 381.1 | (22.3) | 358.8
Total equity | 1,786.5 | (22.3) | 1,764.2
Total liabilities and equity | 3,653.4 | (30.6) | 3,622.8


Question: What was the difference in the reported amount in 2018 between net computer software and net deferred contract costs?
Answer: 244.3
Calculation: 405.6-161.3
Other Income/Expense
The following table details our other income/expenses for the years ended September 30, 2019 and 2018:
The decrease to other income (expenses) for the fiscal year ended September 30, 2019 as compared to the fiscal year ended September 30, 2018 was primarily driven by a decrease in Other income, net of $0.3 mil.
Table:
 | For the year ended |  | 
 | September 30, 2019 | September 30, 2018 | Increase (Decrease)
 | (Amounts in thousands) |  | 
Interest expense | $(99) | $(85) | $(14)
Interest income | 323 | 20 | 303
Foreign exchange gain (loss) | 157 | 263 | (106)
Other income, net | 3 | 297 | (294)
Total other income (expense), net | $384 | $495 | $(111)


Question: What caused the decrease in income between 2018 and 2019?
Answer: A decrease in Other income
Summarised cash flow statement
Cash flow
We generated a net cash inflow from operating activities of £4,256m, down £671m, mainly driven by £2bn contributions to the BT Pension Scheme, offset by favourable working capital movements. In line with our outlook, normalised free cash flowb was £2,440m, down £533m or 18%, driven by increased cash capital expenditure, decrease in EBITDA and higher tax payments.
Free cash flow, which includes specific item outflows of £598m (2017/18: £828m) and a £273m (2017/18: £109m) tax benefit from pension deficit payments, was £619m (2017/18: £1,586m). Last year also included payments of £325m for the acquisition of mobile spectrum.
The spectrum auction bidding took place across the 2017/18 and 2018/19 financial years. Whilst £325m was on deposit with Ofcom at 31 March 2018, we went on to acquire spectrum for a total price of £304m and the excess deposit balance has since been refunded. We made pension deficit payments of £2,024m (2017/18: £872m) and paid dividends to our shareholders of £1,504m (2017/18: £1,523m).
The net cash cost of specific items of £598m (2017/18: £828m) includes restructuring payments of £372m (2017/18: £189m) and regulatory payments of £170m (2017/18: £267m). Last year also included payments of £225m relating to the settlement of warranty claims under the 2015 EE acquisition agreement.
b After net interest paid, before pension deficit payments (including the cash tax benefit of pension deficit payments) and specific items.
Table:
 | 2019 | 2018 | 2017
Year ended 31 March | £m | £m | £m
Cash generated from operations | 4,687 | 5,400 | 6,725
Tax paid | (431) | (473) | (551)
Net cash inflows from operating activities | 4,256 | 4,927 | 6,174
Net purchase of property, plant and equipment and software | (3,637) | (3,341) | (3,119)
Free cash flow | 619 | 1,586 | 3,055
Interest received | 23 | 7 | 7
Interest paid | (531) | (555) | (629)
Add back pension deficit payments | 2,024 | 872 | 274
Add back net cash flow from specific items | 598 | 828 | 205
Add back net sale of non-current asset investments | 1 | 19 | (20)
Add back prepayments in respect of acquisition of spectrum licence | - | 325 | -
Remove refund on acquisition of spectrum licence | (21) | - | -
Remove cash tax benefit of pension deficit payments | (273) | (109) | (110)
Normalised free cash flow b | 2,440 | 2,973 | 2,782


Question: What was the net cash inflow from operating activities?
Answer: £4,256m
25. Loans and other borrowings continued
Net Debt
Net debt consists of loans and other borrowings (both current and non-current), less current asset investments and cash and cash equivalents. Loans and other borrowings are measured at the net proceeds raised, adjusted to amortise any discount over the term of the debt. For the purpose of this measure, current asset investments and cash and cash equivalents are measured at the lower of cost and net realisable value. Currency denominated balances within net debt are translated to sterling at swapped rates where hedged.
Net debt is considered to be an alternative performance measure as it is not defined in IFRS. The most directly comparable IFRS measure is the aggregate of loans and other borrowings (current and non-current), current asset investments and cash and cash equivalents. A reconciliation from the most directly comparable IFRS measure to net debt is given below.
A reconciliation from the most directly comparable IFRS measure to net debt is given below.
Table:
At 31 March | 2019 £m | 2018 £m | 2017 £m
Loans and other borrowings | 16,876 | 14,275 | 12,713
Less: |  |  | 
Cash and cash equivalents | (1,666) | (528) | (528)
Current asset investments | (3,214) | (3,022) | (1,520)
 | 11,996 | 10,725 | 10,665
Adjustments: |  |  | 
To retranslate debt balances at swap rates where hedged by currency swaps | (701) | (874) | (1,419)
To remove accrued interest applied to reflect the effective interest method and fair value adjustments | (260) | (224) | (314)
Net debt | 11,035 | 9,627 | 8,932


Question: What is the average Cash and cash equivalents for 2017-2019?
Answer: -907.33
Calculation: -(1,666 + 528 + 528) / 3
Consolidated statement of comprehensive income
For the year ended 31 March 2019
1 The Group has adopted IFRS 9 ‘Financial Instruments’, IFRS 15 ‘Revenue from Contracts with Customers’, and IFRS 16 ‘Leases’ from 1 April 2018. The year ended 31 March 2018 has been restated for IFRS 16 which was implemented using the fully retrospective method. For further information on the impact of the change in accounting policies, see note 2 of these consolidated financial statements.
Table:
 |  | 2019 | 2018 (Restated)1
 | Note | £m | £m
Profit for the year |  | 197.7 | 171.1
Other comprehensive income |  |  | 
Items that may be subsequently reclassified to profit or loss |  |  | 
Exchange differences on translation of foreign operations |  | (0.1) | 0.2
Items that will not be reclassified to profit or loss |  |  | 
Remeasurements of post-employment benefit obligations | 24 | 0.2 | –
Other comprehensive income for the year, net of tax |  | 0.1 | 0.2
Total comprehensive income for the year attributable to equity holders of the parent |  | 197.8 | 171.3


Question: Which IFRS standard(s) did the Group adopt?
Answer: IFRS 9 ‘Financial Instruments’, IFRS 15 ‘Revenue from Contracts with Customers’, and IFRS 16 ‘Leases’ from 1 April 2018
11. Stockholders’ Equity
The Company recognized stock-based compensation expense within selling, general and administrative expense as follows (in thousands):
(1) For the fiscal year ended August 31, 2018, represents a one-time cash-settled stock award that vested on November 30, 2017.
Table:
 |  | Fiscal Year Ended August 31, | 
 | 2019 | 2018 | 2017
Restricted stock units | $53,766 | $84,082 | $42,122
Employee stock purchase plan (1) | 7,580 | 6,891 | 6,334
Other | — | 7,538 | 88
Total | $61,346 | $98,511 | $48,544


Question: What years does the table provide information for recognized stock-based compensation expense within selling, general and administrative expense for?
Answer: 2019, 2018, 2017
Accounts Receivable and Allowance for Doubtful Accounts
The majority of our accounts receivable are derived from sales to large multinational semiconductor manufacturers throughout the world, are recorded at their invoiced amount and do not bear interest.
In order to monitor potential credit losses, we perform ongoing credit evaluations of our customers' financial condition. An allowance for doubtful accounts is maintained based upon our assessment of the expected collectability of all accounts receivable. The allowance for doubtful accounts is reviewed and assessed for adequacy on a quarterly basis.
We take into consideration (1) any circumstances of which we are aware of a customer's inability to meet its financial obligations and (2) our judgments as to prevailing economic conditions in the industry and their impact on our customers. If circumstances change, and the financial condition of our customers is adversely affected and they are unable to meet their financial obligations, we may need to take additional allowances, which would result in an increase in our operating expense.
Activity related to our allowance for doubtful accounts receivable was as follows (in thousands):
Table:
 |  | Fiscal Year Ended | 
 | December 28, 2019 | December 29, 2018 | December 30, 2017
Balance at beginning of year | $185 | $200 | $299
Charges (reversals) to costs and expenses | 37 | (15) | (99)
Balance at end of year | $222 | $185 | $200


Question: What is the change in allowance Charges (reversals) to costs and expenses from Fiscal Year Ended December 28, 2019 to December 29, 2018?
Answer: 52
Calculation: 37-(15)
stock performance graph the following graph provides a comparison of five year cumulative total stockholder returns of teleflex common stock , the standard & poor 2019s ( s&p ) 500 stock index and the s&p 500 healthcare equipment & supply index . the annual changes for the five-year period shown on the graph are based on the assumption that $ 100 had been invested in teleflex common stock and each index on december 31 , 2010 and that all dividends were reinvested . market performance .

Table:
company / index | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
teleflex incorporated | 100 | 117 | 138 | 185 | 229 | 266
s&p 500 index | 100 | 102 | 118 | 157 | 178 | 181
s&p 500 healthcare equipment & supply index | 100 | 99 | 116 | 148 | 187 | 199
s&p 500 healthcare equipment & supply index 100 99 116 148 187 199 .

Question: what is the total return of an investment of $ 1000000 in teleflex incorporated in 2010 and sold in 2015?
Answer: 1660000
Calculation: subtract(266, 100), divide(1000000, 100), multiply(#1, #0)
Streamlined Energy and Carbon Reporting
We have decided to voluntarily comply with the UK government’s Streamlined Energy and Carbon Reporting (SECR) policy a year early. The table below represents Unilever’s energy use and associated GHG emissions from electricity and fuel in the UK for the 2018 and 2019 reporting years (1 October to 30 September), with scope calculations aligned to the Greenhouse Gas Protocol. The scope of this data includes 8 manufacturing sites and 11 non-manufacturing sites based in the UK. The UK accounts for 5% of our global total Scope 1 and 2 emissions, outlined in our mandatory GHG reporting also on this page.
(a) Fleet and associated diesel use excluded. Transportation is operated by a
third party and accounted for under Scope 3.
(b) Carbon emission factors for grid electricity calculated according to the marketbased method'
For further information on energy efficiency measures taken to reduce our carbon
emissions, please see page 19.
Table:
K operations | 2019 | 2018
Biogas (MWh) | 17,045 | 15,958
Natural gas (MWh) | 238,081 | 278,849
PG (MWh) | 866 | 1,513
Fuel oils (MWh) | 580 | 648
Coal (MWh) | 0 | 0
Electricity (MWh) | 195,796 | 196,965
Heat and steam (MWh) | 212,482 | 272,985
Total energy (MWh)(a) | 408,280 | 469,950
Total Scope 1 emissions (tonnes CO2e) | 48,178 | 56,533
Total Scope 2 emissions (tonnes COe)(b)2 | 702 | 3,067


Question: What is the increase in the Biogas from 2018 to 2019?
Answer: 1087
Calculation: 17,045 - 15,958
17. Quarterly Financial Data (Unaudited)
The following is summarized quarterly financial data for fiscal 2019 and 2018 (in thousands, except per share amounts):
(1) The annual total amounts may not equal the sum of the quarterly amounts due to rounding. Earnings per share is computed independently for each quarter.
(2) The first quarter of fiscal 2019 results included $7.0 million of tax expense as a result of new regulations issued in November 2018 under Tax Reform. These regulations impacted the treatment of foreign taxes paid.
(3) The fourth quarter of fiscal 2019 results included restructuring costs of $1.7 million, $1.5 million net of taxes.
(4) The fourth quarter of fiscal 2019 results included the permanent reinvestment assertion of $10.5 million of certain historical undistributed earnings of two foreign subsidiaries.
(7) The first quarter of fiscal 2019 included $0.23 per share of tax expense as a result of U.S. Tax Reform. The fourth quarter of fiscal 2019 included $0.05 per share of expense related to restructuring costs and $0.35 per share tax benefit resulting from the permanent reinvestment assertion of certain historical undistributed earnings of two foreign subsidiaries.
Table:
2019 | First
Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total
Net sales  | $765,544 | $789,051 | $799,644 | $810,195 | $3,164,434
Gross profit  | 72,383 | 70,636 | 71,030 | 77,789 | 291,838
Net income (2,3,4)  | 22,226 | 24,758 | 24,801 | 36,831 | 108,616
Earnings per share (1):           |  |  |  |  | 
Basic  | $0.71 | $0.81 | $0.83 | $1.26 | $3.59
Diluted (7)  | $0.69 | $0.79 | $0.81 | $1.23 | $3.50


Question: What was the total net income?
Answer: 108,616
Foreign Currency Exchange Risk
Our foreign exchange forward contracts outstanding at fiscal year-end are summarized in U.S. dollar equivalents as follows (in millions):
At July 27, 2019 and July 28, 2018, we had no option contracts outstanding.
We conduct business globally in numerous currencies. The direct effect of foreign currency fluctuations on revenue has not been material because our revenue is primarily denominated in U.S. dollars. However, if the U.S. dollar strengthens relative to other currencies, such strengthening could have an indirect effect on our revenue to the extent it raises the cost of our products to non-U.S. customers and thereby reduces demand. A weaker U.S. dollar could have the opposite effect. However, the precise indirect effect of currency fluctuations is difficult to measure or predict because our revenue is influenced by many factors in addition to the impact of such currency fluctuations
Approximately 70% of our operating expenses are U.S.-dollar denominated. In fiscal 2019, foreign currency fluctuations, net of hedging, decreased our combined R&D, sales and marketing, and G&A expenses by approximately $233 million, or 1.3%, as compared with fiscal 2018. In fiscal 2018, foreign currency fluctuations, net of hedging, increased our combined R&D, sales and marketing, and G&A expenses by approximately $93 million, or 0.5%, as compared with fiscal 2017. To reduce variability in operating expenses and service cost of sales caused by non-U.S.-dollar denominated operating expenses and costs, we may hedge certain forecasted foreign currency transactions with currency options and forward contracts. These hedging programs are not designed to provide foreign currency protection over long time horizons. In designing a specific hedging approach, we consider several factors, including offsetting exposures, significance of exposures, costs associated with entering into a particular hedge instrument, and potential effectiveness of the hedge. The gains and losses on foreign exchange contracts mitigate the effect of currency movements on our operating expenses and service cost of sales.
We also enter into foreign exchange forward and option contracts to reduce the short-term effects of foreign currency fluctuations on receivables and payables that are denominated in currencies other than the functional currencies of the entities. The market risks associated with these foreign currency receivables, investments, and payables relate primarily to variances from our forecasted foreign currency transactions and balances. We do not enter into foreign exchange forward or option contracts for speculative purposes
Table:
 | July 27, 2019 |  | July 28, 2018 | 
 | Notional Amount | Fair Value | Notional Amount | Fair Value
Forward contracts: |  |  |  | 
Purchased | $2,239 | $14 | $1,850 | $(2)
Sold | $1,441 | $(14) | $845 | $2


Question: What was the Fair value of purchased forward contracts in 2019?
Answer: 14
(4) Property and Equipment
Property and equipment consist of the following (in thousands):
Depreciation and amortization expense related to property and equipment was $22,538,000, $21,721,000 and $25,787,000 in 2019, 2018 and 2017, respectively.
On November 1, 2019, we completed the purchase of real estate in Chandler, Arizona for approximately $48,000,000 that we intend to use as our global corporate headquarters. The property contains a building and some infrastructure in place that we will complete readying for our use over the next year. We intend to sell our current properties in Tempe, Arizona.
Included within the software, buildings and land values presented above are assets in the process of being readied for use in the amounts of approximately $12,138,000, $27,658,000 and $11,700,000, respectively. Depreciation on these assets will commence, as appropriate, when they are ready for use and placed in service.
Table:
 | December 31, | 
 | 2019 | 2018
Software | $114,674 | $170,327
Buildings | 92,092 | 64,263
Equipment | 60,661 | 100,421
Furniture and fixtures | 34,768 | 38,200
Lease hold improvements | 33,668 | 26,319
Land | 31,374 | 5,124
 | 367,237 | 404,654
Accumulated depreciation and amortization | (236,330) | (331,700)
Property and equipment, net | $130,907 | $72,954


Question: What is the average Software for 2018 and 2019?
Answer: 142500.5
Calculation: (114,674+170,327) / 2
1 Segment performance (continued)
(c) Other segment information
(i) Profit/(loss) before tax
Management assesses the performance of the operating segments based on a measure of EBITDA. Interest income and expenditure are not allocated to segments, as this type of activity is driven by the central treasury function, which manages the cash position of the Group. On adoption of AASB 16 from 1 July 2018, associated lease interest is allocated to the respective segments as a finance charge.
Table:
 | 30 June 2019 | 30 June 2018
 | $'000 | $'000
Total segment profit before tax | 62,583 | 61,449
Employee benefits expense (non-facility staff) | (23,036) | (20,752)
Interest revenue | 8,220 | 5,778
Distributions from investments | 1,344 | 3,191
Other income | 3,034 | 284
Finance costs | (45,612) | (25,452)
Head office depreciation | (2,079) | (1,909)
Overheads and other expenses | (20,527) | (11,698)
Profit/(loss) before tax | (16,073) | 10,891


Question: Which year(s) incurred a loss before tax?
Answer: 2019
Calculation: Profit/(loss) before tax = (16,073)
3.4 FINANCIAL EXPENSE
(1) Fiscal 2018 was restated to reclassify results from Cogeco Peer 1 as discontinued operations. For further details, please consult the "Discontinued operations" section.
Fiscal 2019 financial expense decreased by 5.4% mainly due to:
• the reimbursement at maturity of the Senior Secured Notes Series B on October 1, 2018; • the reimbursements of $65 million and US$35 million under the Canadian Revolving Facility during the second quarter of fiscal 2019 and of US$328 million during the third quarter of fiscal 2019 following the sale of Cogeco Peer 1; and
• early reimbursement of the US$400 million Senior Unsecured Notes during the third quarter of fiscal 2018 which resulted in a $6.2 million redemption premium and the write-off of the unamortized deferred transaction costs of $2.5 million; partly offset by • higher interest cost on the First Lien Credit Facilities resulting from the full year impact of the financing of the MetroCast acquisition; and • the appreciation of the US dollar against the Canadian dollar compared to the prior year.
Table:
Years ended August 31, | 2019 | 2018 (1) | Change
(in thousands of dollars, except percentages) | $ | $ | %
Interest on long-term debt | 176,798 | 179,680 | (1.6)
Net foreign exchange gains | (2,744) | (2,134) | 28.6
Amortization of deferred transaction costs | 1,836 | 1,884 | (2.5)
Capitalized borrowing costs | (690) | (2,074) | (66.7)
Other | 302 | 8,100 | (96.3)
 | 175,502 | 185,456 | (5.4)


Question: What was the early reimbursement amount of Senior Unsecured Notes in the third quarter of 2018?
Answer: US$400 million
Balance sheet
Under IAS 12 Income Taxes, provision is made for the deferred tax assets and liabilities associated with the revaluation of assets and liabilities at the corporate tax rate expected to apply to the Group at the time the temporary differences are expected to reverse. For those UK assets and liabilities benefiting from REIT exemption the relevant tax rate will be 0 per cent (2018: 0 per cent), and for other UK assets and liabilities the relevant rate will be 19 per cent if the temporary difference is expected to be realised before 1 April 2020 and 17 per cent if it is expected to be realised on or after 1 April 2020 (2018: 19 per cent before 1 April 2020, 17 per cent thereafter). For Spanish assets and liabilities the relevant tax rate will be 25 per cent (2018: 25 per cent).
Movements in the provision for deferred tax:
The net deferred tax provision of £0.9 million predominantly arises in respect of the revaluation of development property at intu Costa del Sol, partially offset by associated tax losses.
Table:
£m | Investment and development property | Other temporary differences | Total
Provided deferred tax provision/(asset): |  |  | 
At 1 January 2018 | 24.6 | (0.9) | 23.7
Recognised in the income statement | (5.5) | (0.3) | (5.8)
Foreign exchange movements | 0.1 | – | 0.1
At 31 December 2018 | 19.2 | (1.2) | 18.0
Recognised in the income statement | (16.4) | (0.2) | (16.6)
Foreign exchange movements | (0.5) | – | (0.5)
At 31 December 2019 | 2.3 | (1.4) | 0.9


Question: What is the relevant tax rate for those UK assets and liabilities benefiting from REIT exemption in 2019?
Answer: 0 per cent