hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Greenhouse gas emissions
In line with the Companies Act 2006, Sophos is required to measure and report on its Greenhouse Gas (“GHG”) emissions disclosures. These have been calculated for the year-ending 31 March 2019, in line with the Group’s financial year. The calculation of the disclosures has been performed in accordance with Greenhouse Gas Protocol Corporate Standard and using the UK government’s conversion factor guidance for the year reported.
The Group’s operations that primarily release GHG includes usage of electricity and gas of owned and leased offices, business travel and usage of vehicles. The Group keeps its data capture process under review, seeking to extend the availability of direct information wherever possible. Where direct information for certain sites is not available, estimates have been developed that enable reporting for them. These estimates are revised if new or improved data is obtained.
The Group will continue to build its GHG reporting capabilities. The Group’s chosen intensity ratio is ‘tonnes of CO2 equivalent per million US dollars of billings’ as it aligns with Sophos’ strategic growth ambitions.
Creating an environmentally friendly HQ
The Group commissioned a greening study of its global headquarters in Abingdon, Oxfordshire. The purpose of the study was to benchmark the current environmental, health and wellbeing performance of the building against current best practice and against direct and indirect competitors.
The findings of the study showed that the building performance was consistent with intermediate good practice and the building management was consistent with standard good practice. The study highlighted areas of future improvement. The findings and recommendations of this report will be a key driver for developing best practice in environmental sustainability to match the growth aspirations and objectives of the Company.
The Group is endeavouring to achieve the standards in environmental performance, health and wellbeing that is expected of a global technology organisation at the Group’s headquarters.
Table:
 |  | Year-ended 31 March 2019 | Year-ended 31 March 2018 | Year-ended 31 March 2017
 |  | tCO2e | tCO2e | tCO2e
Scope 1 | Combustion of natural gas and operation of owned vehicles | 220.9 | 320.0 | 251.8
Scope 2 | Electricity consumption in offices | 4,487.2 | 4,457.3 | 4,681.9
Scope 3 | Business travel (air and car) | 3,260.9 | 5,117.4 | 4,510.9
Total |  | 7,969.0 | 9,894.7 | 9,444.6
Intensity ratio |  |  |  | 
tCO2e per $M of billings |  | 10.5 | 12.9 | 14.9


Question: What does the Companies Act 2006 require Sophos to do?
Answer: Sophos is required to measure and report on its Greenhouse Gas (“GHG”) emissions disclosures.
Restricted Share Awards
During the years ended December 31, 2017, pursuant to the Company’s 2016 Incentive Plan and 2005 Incentive Plan, the Company granted RSAs. The awards have requisite service periods of three years and vest in increments of 33% on the anniversary of the grant dates. Under each arrangement, shares are issued without direct cost to the employee. RSAs granted to our board vest one year from grant or as of the next annual shareholders meeting, whichever is earlier. The Company estimates the fair value of the RSAs based upon the market price of the Company’s stock at the date of grant. The RSA grants provide for the payment of dividends on the Company’s common stock, if any, to the participant during the requisite service period, and the participant has voting rights for each share of common stock. The Company recognizes compensation expense for RSAs on a straight-line basis over the requisite service period.
A summary of nonvested RSAs is as follows:
During the year ended December 31, 2019, a total of 106,610 RSAs vested. The Company withheld 32,371 of those shares to pay the employees’ portion of the minimum payroll withholding taxes.
Table:
 | Number of Shares | Weighted Average Grant Date Fair Value
Nonvested at December 31, 2018 | 213,337 | $20.21
Vested | -106,610 | 20.17
Forfeited | -13,885 | 20.64
Nonvested at December 31, 2019 | 92,842 | $20.13


Question: What was the difference between the Weighted Average Grant Date Fair Value of nonvested shares in 2019 and forfeited shares?
Answer: 0.51
Calculation: 20.64-20.13
Hardware
Hardware sales, net decreased $1.5 million, or -10% in 2019 compared to 2018. We adopted the new ASC 606 standard as of January 1, 2018 and elected to use the modified retrospective method. Historical hardware sales prior to the adoption of ASC 606 were recorded on a gross basis, as we were the principal in the transaction in accordance with the previous standard, ASC 605-45. Under the new standard, we are an agent in the transaction as we do not physically control the hardware which we sell. Accordingly, starting January 1, 2018, we recognize our hardware revenue net of related cost which reduces both hardware revenue and cost of sales as compared to our accounting prior to 2018. For comparison purposes only, had we implemented ASC 606 using the full retrospective method, we would have also presented hardware revenue net of cost for prior periods as shown below.
The majority of hardware sales are derived from our Americas segment. Sales of hardware are largely dependent upon customer- specific desires, which fluctuate.
Table:
 |  |  |  | Year Ended December 31, | 
 |  |  |  | % Change vs.Prior Year | 
2019 | 2019 | 2018 | 2017 | 2019 | 2018
Hardware Revenue (Pre ASC 606 Adoption) | $44,972 | $49,914 | $43,190 | -10% | 16%
Cost of hardware | -32,455 | -35,947 | - 32,205 | -10% | 12%
Hardware Revenue, net (Post ASC 606 Adoption) | $12,517 | $13,967 | $ 10,985 | -10% | 27%


Question: What is the revenue from hardware, net (Post ASC 606 Adoption) in 2019
Answer: $12,517
6. Other Balance Sheet Account Details
Allowance for Doubtful Accounts
The following table presents the changes in the allowance for doubtful accounts (in thousands):
Table:
 | December 31, 2019 | December 31, 2018
Allowance for doubtful accounts, beginning balance | $319 | $983
Increase (decrease) of provision | (72) | (26)
Write-offs | (195) | (638)
Allowance for doubtful accounts, ending balance | $52 | $319


Question: What data is covered by the table?
Answer: Allowance for Doubtful Accounts
2 Alternative performance measures continued
Return on capital employed (ROCE)
ROCE measures effective management of fixed assets and working capital relative to the profitability of the business. It is calculated as adjusted operating profit divided by average capital employed. More information on ROCE can be found in the Capital Employed and ROCE sections of the Financial Review on page 57.
An analysis of the components is as follows:
Table:
 | 2019 | 2018
 | £m | £m
Property, plant and equipment | 251.2 | 230.8
Right-of-use assets (IFRS 16) | 40.8 | –
Prepayments | 0.9 | 6.2
Inventories | 185.9 | 160.6
Trade receivables | 240.7 | 245.1
Other current assets | 35.3 | 32.9
Tax recoverable | 8.4 | 4.6
Trade, other payables and current provisions | (178.3) | (172.0)
Current tax payable | (26.7) | (23.7)
Capital employed | 558.2 | 484.5
Average capital employed | 521.4 | 482.2
Average capital employed (excluding IFRS 16) | 501.0 | 482.2
Operating profit | 245.0 | 299.1
Adjustments (see adjusted operating profit on page 160) | 37.7 | (34.2)
Adjusted operating profit | 282.7 | 264.9
Adjusted operating profit (excluding IFRS 16) | 281.4 | 264.9
Return on capital employed | 54.2% | 54.9%
Return on capital employed (excluding IFRS 16) | 56.2% | 54.9%


Question: How is ROCE calculated?
Answer: adjusted operating profit divided by average capital employed
12 Earnings per share
(a) Basic and diluted earnings per share
1 The weighted average number of shares used has been adjusted to remove shares held in the ESOP
2 Diluted shares include the impact of any dilutive convertible bonds, share options and share awards.
During 2017 the Group incurred a £49.4 million share related charge in relation to its Spanish development partner Eurofund’s future interests in the share capital of the intu Costa del Sol development company. The positive impact of this share related charge on equity attributable to owners of intu properties plc is a credit to retained earnings of £49.4 million. Subsequent to 31 December 2019, the Group has 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.
Table:
 | 2019 |  |  | 2018 |  | 2018
 | Loss £m | Shares million | Loss per share pence | Loss £m | Shares million | Loss per Share pence
Basic1 | (1950.9) | 1,344.5 | (145.1)p | (1,132.2) | 1,343.7 | (84.3)p
Diluted2 | (1950.9) | 1,344.5 | (145.1)p | (1,132.2) | 1,343.7 | (84.3)p


Question: In which year is there a greater number of shares?
Answer: 2019
Calculation: Find the year with the greater number of shares
COHERENT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In thousands)
(1) Reclassification adjustments were not significant during fiscal 2019, 2018 and 2017.
(2) Tax benefits of $(5,161), $0 and $(326) were provided on translation adjustments during fiscal 2019, 2018 and 2017, respectively.
(3) Tax benefits of $0, $(2) and $(1,876) were provided on changes in unrealized losses on available-for-sale securities during fiscal 2019, 2018 and 2017, respectively.
(4) Tax expenses (benefits) of $(2,371), $202 and $1,747 were provided on changes in defined benefit pension plans during fiscal 2019, 2018 and 2017, respectively.
Table:
 |  | Year Ended | 
 | September 28,2019 | September 29,2018 | September 30,2017
Net income | $53,825 | $247,358 | $207,122
Other comprehensive income (loss):(1) |  |  | 
Translation adjustment, net of taxes(2) | (32,609) | (18,065) | 24,923
Changes in unrealized losses on available-for-sale securities, net of taxes(3) | — | (4) | (3,330)
Defined benefit pension plans, net of taxes(4) | (6,560) | 996 | 3,613
Other comprehensive income (loss), net of tax | (39,169) | (17,073) | 25,206
Comprehensive income | $14,656 | $230,285 | $232,328


Question: What was the change in Net income in 2018 from 2017?
Answer: 40236
Calculation: 247,358-207,122
24. Cash and cash equivalents
Significant accounting policies that apply to cash and cash equivalents Cash and cash equivalents comprise cash in hand and current balances with banks and similar institutions, which are readily convertible to cash and are subject to insignificant risk of changes in value and have an original maturity of three months or less. All are held at amortised cost on the balance sheet, equating to fair value. For the purpose of the consolidated cash flow statement, cash and cash equivalents are as defined above net of outstanding bank overdrafts. Bank overdrafts are included within the current element of loans and other borrowings (note 25).
IFRS 9 was applied for the first time on 1 April 2018 and introduces new classifications for financial instruments. Cash and cash equivalents were classified as loans and receivables under IAS 39, and are now classified as financial assets held at amortised cost under IFRS 9. This has not had an impact on the accounting for these instruments, or on their carrying amounts.
Cash and cash equivalents include restricted cash of £44m (2017/18: £32m, 2016/17: £43m), of which £40m (2017/18: £29m, 2016/17: £41m) was held in countries where local capital or exchange controls currently prevent us from accessing cash balances. The remaining balance of £4m (2017/18: £3m, 2016/17: £2m) was held in escrow accounts, or in commercial arrangements akin to escrow.
Table:
 | 2019 | 2018 | 2017
At 31 March | £m | £m | £m
Cash at bank and in hand | 495 | 446 | 469
Cash equivalents |  |  | 
US deposits | 3 | 26 | 32
UK deposits | 1,132 | 31 | 1
Other deposits | 36 | 25 | 26
Total cash equivalents | 1,171 | 82 | 59
Total cash and cash equivalents | 1,666 | 528 | 528
Bank overdrafts (note25) | (72) | (29) | (17)
Cash and cash equivalents per the cash flow statement | 1,594 | 499 | 511


Question: What was the balance held in escrow account in 2019?
Answer: £4m
The movements below in foreign currency translation reserve and cashflow hedge reserve relating to the NSPT Group are presented within non-controlling interest in the Group’s consolidated statement of changes in equity.
Taxation impact on revaluation applies only to cash flow hedges held in NSNZPT, a sub-trust of NSPT, which is subject to New Zealand tax legislation. Deferred tax does not apply to any other cash flow hedges held in the NSPT Group under current Australian tax legislation.
The hedging reserve is used to record gains or losses on derivatives that are designated as cash flow hedges and recognised in other comprehensive income, as described in note 2(m). Amounts are reclassified to profit or loss in the period when the associated hedged transaction takes place.
On 24 June 2019, the Group reset the interest rates associated with AUD denominated interest rate swaps designated as cash flow hedges. This resulted in a cash outflow of $22.9m which reduced the Group’s financial liability as presented in note 9.8. In accordance with AASB 9 Financial instruments, as the nature of the underlying hedged instrument is unchanged the fair value of this outflow remains in the cash flow hedge reserve and will be amortised to the statement of profit or loss in future periods.
The cash flow hedge is included in non-controlling interest in the Consolidated Group and is not classified within other reserves.
Table:
NSPT Group |  | 
 | 2019 | 2018
 | $'000 | $'000
Foreign currency translation reserve |  | 
Opening balance at 1 July | (115) | 232
Net investment hedge | (1,591) | 1,007
Foreign exchange translation differences | 2,464 | (1,354)
Closing balance at 30 June | 758 | (115)
Cash flow hedge reserve |  | 
Opening balance at 1 July | (2,073) | (45)
Revaluation of derivatives | (22,098) | (2,112)
Taxation impact on revaluation | 290 | 84
Closing balance at 30 June | (23,881) | (2,073)
Other reserves | (23,123) | (2,188)


Question: In which year is the Net investment hedge negative?
Answer: 2019
Calculation: locate and analyze Net investment hedge in row 6
entergy new orleans , inc . and subsidiaries management 2019s financial discussion and analysis results of operations net income 2016 compared to 2015 net income increased $ 3.9 million primarily due to higher net revenue , partially offset by higher depreciation and amortization expenses , higher interest expense , and lower other income . 2015 compared to 2014 net income increased $ 13.9 million primarily due to lower other operation and maintenance expenses and higher net revenue , partially offset by a higher effective income tax rate . net revenue 2016 compared to 2015 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges . following is an analysis of the change in net revenue comparing 2016 to 2015 . amount ( in millions ) .

Table:
 | amount ( in millions )
2015 net revenue | $ 293.9
retail electric price | 39.0
net gas revenue | -2.5 ( 2.5 )
volume/weather | -5.1 ( 5.1 )
other | -8.1 ( 8.1 )
2016 net revenue | $ 317.2
the retail electric price variance is primarily due to an increase in the purchased power and capacity acquisition cost recovery rider , as approved by the city council , effective with the first billing cycle of march 2016 , primarily related to the purchase of power block 1 of the union power station .
see note 14 to the financial statements for discussion of the union power station purchase .
the net gas revenue variance is primarily due to the effect of less favorable weather on residential and commercial sales .
the volume/weather variance is primarily due to a decrease of 112 gwh , or 2% ( 2 % ) , in billed electricity usage , partially offset by the effect of favorable weather on commercial sales and a 2% ( 2 % ) increase in the average number of electric customers. .

Question: what is the growth rate in net revenue in 2016 for entergy new orleans , inc?
Answer: 7.9%
Calculation: subtract(317.2, 293.9), divide(#0, 293.9)
12. Income taxes
Income taxes include the taxes on income paid or owed in the individual countries as well as deferred taxes.
1 Adjustment of previous year according to explanation in notes.
The income tax rate of the German companies of METRO consists of a corporate income tax of 15.00% plus a 5.50% solidarity surcharge on corporate income tax as well as the trade tax of 14.70% given an average assessment rate of 420.00%. All in all, this results in an aggregate tax rate of 30.53%. The tax rates are unchanged from the previous year. The income tax rates applied to foreign companies are based on the respective laws and regulations of the individual countries and vary within a range of 0.00% (2017/18: 0.00%) and 34.94% (2017/18: 44.41%).
At €298 million (2017/18: €216 million), recognised income tax expenses are €81 million higher than in the previous year. In addition to an increase in pre-tax earnings, the change is due to higher expenses for impairments on deferred taxes, among other things.
Table:
€ million | 2017/2018 | 2018/2019
Actual taxes | 173 | 215
thereof Germany | (14) | (9)
thereof international | (159) | (206)
thereof tax expenses/income of current period | (194) | (221)
thereof tax expenses/income of previous periods | (−21) | (−6)
Deferred taxes | 43 | 83
thereof Germany | (39) | (104)
thereof international | (4) | (−21)
 | 216 | 298


Question: What was the percentage change in recognised income tax expenses in 2018/2019 from 2017/2018?
Answer: 37.96
Calculation: (298-216)/216
declaration and payment of future quarterly dividends is at the discretion of our board and may be adjusted as business needs or market conditions change . in addition , under the terms of the merger agreement , we have agreed with aetna to coordinate the declaration and payment of dividends so that our stockholders do not fail to receive a quarterly dividend around the time of the closing of the merger . on october 29 , 2015 , the board declared a cash dividend of $ 0.29 per share that was paid on january 29 , 2016 to stockholders of record on december 30 , 2015 , for an aggregate amount of $ 43 million . stock total return performance the following graph compares our total return to stockholders with the returns of the standard & poor 2019s composite 500 index ( 201cs&p 500 201d ) and the dow jones us select health care providers index ( 201cpeer group 201d ) for the five years ended december 31 , 2015 . the graph assumes an investment of $ 100 in each of our common stock , the s&p 500 , and the peer group on december 31 , 2010 , and that dividends were reinvested when paid. .

Table:
 | 12/31/2010 | 12/31/2011 | 12/31/2012 | 12/31/2013 | 12/31/2014 | 12/31/2015
hum | $ 100 | $ 162 | $ 128 | $ 195 | $ 274 | $ 343
s&p 500 | $ 100 | $ 102 | $ 118 | $ 157 | $ 178 | $ 181
peer group | $ 100 | $ 110 | $ 129 | $ 177 | $ 226 | $ 239
the stock price performance included in this graph is not necessarily indicative of future stock price performance. .

Question: what is the highest return for the first year of the investment?
Answer: 62%
Calculation: subtract(162, 100)
Summarized financial information concerning our segments is shown in the tables below (in millions):
(1) Revenues for Corporate and Other represent deferred revenue purchase accounting adjustments recorded in accordance with GAAP.
(2) Operating expenses for Corporate and Other includes equity-based compensation, including certain related payroll taxes, of $51.7 million, $51.4 million and $19.2 million for the years ended December 31, 2019, 2018 and 2017, respectively.
(4) Depreciation and amortization for Corporate and Other primarily represents net incremental depreciation and amortization adjustments associated with the application of purchase accounting recorded in accordance with GAAP.
(5) Transition and integration costs primarily consists of costs associated with executive transition, transition-related costs as we transferred certain corporate functions from FNF and acquisitions.
(6) Receivables from related parties are included in Corporate and Other.
Table:
 |  |  | Year ended December 31, 2018 |  | 
 | Software Solutions | Data and Analytics | Corporate and Other |  | Total
Revenues | $962.0 | $154.5 | $(2.5) | (1) | $1,114.0
Expenses: |  |  |  |  | 
Operating expenses | 394.8 | 115.0 | 115.6 | (2) | 625.4
Transition and integration costs | — | — | 6.6 | (5) | 6.6
EBITDA | 567.2 | 39.5 | (124.7) |  | 482.0
Depreciation and amortization | 112.9 | 14.1 | 90.0 | (4) | 217.0
Operating income (loss) | 454.3 | 25.4 | (214.7) |  | 265.0
Interest expense, net |  |  |  |  | (51.7)
Other expense, net |  |  |  |  | (7.1)
Earnings before income taxes |  |  |  |  | 206.2
Income tax expense |  |  |  |  | 37.7
Net earnings |  |  |  |  | $168.5
Balance sheet data: |  |  |  |  | 
Total assets | $3,227.8 | $310.2 | $115.4 | (6) | $3,653.4
Goodwill | $2,157.6 | $172.1 | $— |  | $2,329.7


Question: What was the difference in Depreciation and amortization between Software Solutions and Corporate and Other?
Answer: 22.9
Calculation: 112.9-90.0
At December 31, 2019, the Company’s net operating losses and credit carryforwards are:
(1) Excludes federal and state net operating losses of $60.2 million and $0.8 million, respectively, from prior acquisitions that the Company expects will expire unutilized
(2) Excludes federal and state tax credits of $0.1 million and $8.3 million, respectively, that the Company expects will expire unutilized
Carryforward losses and credits expire between 2020 and 2038, except for the 2019 federal net operating loss of $43.9 million and $1 million of state credits, which both have unlimited carryforward periods.
The Company’s India subsidiary is primarily located in Special Economic Zones (“SEZs”) and is entitled to a tax holiday in India. The tax holiday reduces or eliminates income tax in India. The tax holiday in the Hyderabad SEZ is scheduled to expire in 2024. The tax holiday in the Bangalore SEZ is scheduled to expire in 2022. For 2019, 2018 and 2017, the income tax holiday reduced the Company’s provision for income taxes by $1.9 million, $1.3 million, and $1 million, respectively.
Table:
(in thousands) | Federal | State
Net operating losses (1) | $120,722 | $3,337
Net operating losses due to acquisitions (1) | $76,827 | $778
Credit carryforwards (2) | $8,202 | $1,958
Credit carryforwards due to acquisitions | $640 | $227


Question: What is the difference between the company's federal and state net operating losses?
Answer: 117385
Calculation: 120,722 - 3,337
NOTE 8. PROPERTY AND EQUIPMENT
The following table details the components of property and equipment (amounts in thousands).
Amounts payable for property and equipment included in accounts payable totaled $0.1 million at December 31, 2019, and $0.2 million at December 31, 2018. During 2019, we financed the purchase of $0.3 million of property with finance leases and equipment notes. Assets which had not yet been placed in service, included in property and equipment, totaled $1.5 million at December 31, 2019, and $2.2 million at December 31, 2018.
Table:
 | December 31 |  | 
 | 2019 | 2018 | Estimated Useful Lives
Land | $730 | $585 | 
Furniture and fixtures | 476 | 430 | 5-10 years
Plant | 9,667 | 8,613 | 20-40 years, or life of lea
Computer and software | 1,317 | 1,295 | 3-5 years
Leasehold improvements | 2,019 | 681 | 4-15 years, or life of lease
Machinery and equipment | 16,864 | 13,528 | 5-15 years
Property and equipment, cost | 31,073 | 25,132 | 
Less accumulated depreciation | 11,996 | 10,122 | 
Property and equipment, net | $      19,077 | $     15,010 | 


Question: What is the change in the land value between 2018 and 2019?
Answer: 145
Calculation: 730 - 585