hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Items Not Resulting in a Deferred Tax Asset
Of the unused tax losses, €187 million (2018: €213 million; 2017: €263 million) relate to U.S. state tax loss carryforwards.
We have not recognized a deferred tax liability on approximately €17.41 billion (2018: €14.04 billion) for undistributed profits of our subsidiaries, because we are in a position to control the timing of the reversal of the temporary difference and it is probable that such differences will not reverse in the foreseeable future.
Table:
€ millions | 2019 | 2018 | 2017
Unused tax losses |  |  | 
Not expiring | 688 | 575 | 375
Expiring in the following year | 63 | 7 | 9
Expiring after the following year | 373 | 476 | 535
Total unused tax losses | 1,124 | 1,058 | 919
Deductible temporary differences | 538 | 509 | 524
Unused research and development and foreign tax credits |  |  | 
Not expiring | 28 | 54 | 38
Expiring in the following year | 0 | 0 | 2
Expiring after the following year | 17 | 18 | 34
Total unused tax credits | 45 | 72 | 74


Question: What was the change in the amount Expiring after the following year in 2019 from 2018?
Answer: -1
Calculation: 17-18
FLNG segment
Total operating revenues: On May 31, 2018, the Hilli was accepted by the Customer and, accordingly, commenced operations. As a result, she generated $127.6 million total operating revenues in relation to her liquefaction services for the year ended December 31, 2018.
Vessel operating expenses: This represents the vessel operating expenses incurred by the Hilli since she commenced operations.
Project development expenses: This relates to non-capitalized project-related expenses comprising of legal, professional and consultancy costs. The increase for the twelve months ended December 31, 2018 was primarily as a result of increased engineering consultation fees and front-end engineering and design costs in relation to the Gimi GTA project.
Depreciation: Subsequent to the Customer's acceptance of the Hilli, we determined her to be operational and, therefore, depreciation commenced during the second quarter of 2018.
Other operating gains: Includes the realized and unrealized gain on the oil derivative instrument. In 2018, we recognized a realized gain of $26.7 million, and an unrealized fair value loss of $10.0 million, relating to the LTA oil derivative instrument as a result of the increased price of Brent Crude during the year. The derivative asset was recognized upon the LTA becoming effective in December 2017. In 2017, we recognized an unrealized fair value gain of $15.1 million.
For the year ended December 31, 2018, this is partially offset by a $1.3 million write off of capitalized conversion costs in relation to the Gandria. In addition, subsequent to the decision to wind down OneLNG, we wrote off $12.7 million of the trading balance with OneLNG as we deem it to be no longer recoverable.
Equity in net losses of affiliates: Pursuant to the formation of OneLNG in July 2016, we equity account for our share of net losses in OneLNG. Given the difficulties in finalizing an attractive debt financing package along with other capital and resource priorities, in April 2018, Golar and Schlumberger decided to wind down OneLNG and work on FLNG projects as required on a case-by-case basis. As a result, activity levels have been substantially reduced for the year ended December 31, 2018 and the carrying value of the investment was written down to $nil.
Table:
 |  | December 31, |  | 
(in thousands of $) | 2018 | 2017 | Change | % Change
Total operating revenues | 127,625 | — | 127,625 | 100%
Vessel operating expenses | (26,317) | (2) | (26,315) | 1,315,750%
Voyage expenses | (1,363) | (121) | (1,242) | 1,026%
Administrative expenses | 175 | (1,736) | 1,911 | (110)%
Project development expenses | (16,526) | (2,506) | (14,020) | 559%
Depreciation and amortization | (28,193) | — | (28,193) | 100%
Other operating gains | 2,749 | 15,100 | (12,351) | (82)%
Operating income | 58,150 | 10,735 | 47,415 | 442%
Equity in net losses of affiliates | (2,047) | (8,153) | 6,106 | (75)%


Question: In which year was the project development expenses higher?
Answer: 2018
Calculation: (16,526) > (2,506)
Gross Profit
Gross profit increased $269.4 million, or 45.2%, for the year ended December 31, 2019 compared to the same period in 2018. As a percentage of total revenues, gross profit decreased from 55.6% in the year ended December 31, 2018 to 54.9% in the year ended December 31, 2019, due to Shopify Payments representing a larger percentage of total revenue and an increase in amortization of technology related to the 6RS acquisition as well as other platform enhancements. This was partly offset by lower third-party infrastructure and hosting costs and employee-related costs as a percentage of revenues as well as the relative growth of higher-margin merchant solutions products, namely Shopify Capital and referral fees from partners.
Gross profit increased $216.0 million, or 56.8%, for the year ended December 31, 2018 compared to the same period in 2017. As a percentage of total revenues, gross profit decreased from 56.5% in the year ended December 31, 2017 to 55.6% in the year ended December 31, 2018, due to Shopify Payments representing a larger percentage of total revenue, increasing the functionality and flexibility of our hosting infrastructure, and higher product costs associated with expanding our product offerings. This was partly offset by the relative growth of higher-margin merchant solutions products, namely referral fees from partners, Shopify Capital, and Shopify Shipping.
Table:
 | Years ended December 31 |  |  | 2019 vs 2018 | 2018 vs 2017
 | 2019 | 2018 | 2017 | % Change | % Change
 | (in thousands, except percentages) |  |  |  | 
Gross profit | $ 865,643 | $ 596,267 | $ 380,253 | 45.2 % | 56.8 %
Percentage of total revenues | 54.9 % | 55.6 % | 56.5 % |  | 


Question: Between year ended 2018 and 2019, which year had higher gross profit?
Answer: 2019
Calculation: 865,643>596,267
Executive Annual Incentive Plan Target Opportunities: The following table presents each NEO’s target incentive opportunity for FY19 under the FY19 Executive Annual Incentive Plan (the ‘‘FY19 EAIP’’):
(1) In connection with Mr. Kapuria’s promotion, his FY19 Individual Annual Incentive Target under the FY19 EAIP increased from 60% to 100% effective May 8, 2018. Mr. Kapuria’s prorated target annual incentive value for FY19 is $427,451.
Table:
 | FY19 Individual Annual | FY19
NEO | Incentive Target (%) | Target ($)
Gregory S. Clark | 150 | 1,500,000
Nicholas R. Noviello | 100 | 650,000
Amy L. Cappellanti-Wolf | 70 | 308,000
Samir Kapuria(1) | 100 | 450,000
Scott C. Taylor | 100 | 600,000


Question: Who are the NEO(s) with a FY19 target above the average?
Answer: Gregory S. Clark
Calculation: For each row for COL4 if the value>(1,500,000+650,000+308,000+450,000+600,000)/5=701,600, select corresponding NEO name as answer.
12 Directors’ Remuneration
Directors’ emoluments represent all earnings and aggregate contributions to pension schemes made during the year as a Director of Sophos Group plc and its subsidiaries. Further details can be found in the Group’s Remuneration Report on pages 91 to 101.
Table:
 | Year-ended 31 March 2019 | Year-ended 31 March 2018
 | $M | $M
Directors’ emoluments | 2.3 | 3.3
Gains on exercise of share options | 3.6 | 3.5
Gains on vesting of LTIP awards | 14.5 | 4.2
Total Directors’ remuneration | 20.4 | 11.0


Question: In which year was the amount of Gains on exercise of share options larger?
Answer: 2019
Calculation: 3.6>3.5
Disaggregation of Revenue
The following table presents the Company's revenue disaggregated by major product category (amounts in thousands):
Software and hardware revenue is generated from on premise software license sales, as well as sales of hardware scanner boxes and on premise appliance products. Service and other revenue is generated from the sale of transactional SaaS products and services, maintenance associated with the sale of software and hardware, and consulting and professional services.
Table:
 |  | Twelve Months Ended September 30, | 
 | 2019 | 2018 | 2017
Major product category |  |  | 
Deposits software and hardware | $41,860 | $33,071 | $25,407
Deposits service and other | 15,170 | 8,437 | 6,963
Deposits revenue | 57,030 | 41,508 | 32,370
Identity verification software and hardware | 4,985 | 7,627 | 4,240
Identity verification service and other | 22,575 | 14,424 | 8,780
Identity verification revenue | 27,560 | 22,051 | 13,020
Total revenue | $84,590 | $63,559 | $45,390


Question: What is the total revenue in the fiscal year 2018?
Answer: $63,559
Note 9 - Software Development Costs
Capitalized software development costs as of December 31, 2019 and 2018 consisted of the following (in thousands):
The weighted average remaining amortization period for the Company’s software development costs is 1.61 years.
Amortization expense for capitalized software development costs was $1.025 million and $1.2 million for each of the years ended December 31, 2019 and 2018.
Table:
 | As of December 31, | 
 | 2019 | 2018
Capitalized software development costs | $6,029 | $5,102
Accumulated amortization | (4,485) | (3,412)
Software development costs, net | 1,544 | $1,690


Question: What was the Capitalized software development costs in 2019?
Answer: $6,029
Research and development
Research and development expense consists primarily of salaries and other personnel-related costs; the cost of products, materials, and outside services used in our R&D activities; and depreciation and amortization expense associated with R&D specific facilities and equipment. We maintain a number of programs and activities to improve our technology and processes in order to enhance the performance and reduce the costs of our solar modules.
The following table shows research and development expense for the years ended December 31, 2019, 2018, and 2017:
Research and development expense in 2019 increased compared to 2018 primarily due to increased material and module testing costs and higher employee compensation expense.
Table:
 |  | Year Ended |  |  | Change |  | 
(Dollars in thousands) | 2019 | 2018 | 2017 | 2019 over 2018 |  | 2018 over 2017 | 
Research and development | $96,611 | $84,472 | $88,573 | $12,139 | 14% | $(4,101) | (5)%
% of net sales . | 3.2% | 3.8% | 3.0% |  |  |  | 


Question: What is the net difference in research and development expense between 2019 and 2017?
Answer: 8038
Calculation: 96,611 - 88,573
Sources and Uses of Cash
Our primary source of liquidity from operations was the collection of revenue in advance from our customers, accounts receivable from our customers, and the management of the timing of payments to our vendors and service providers.
Investing activities in 2019 consist of $284.6 million, net of cash acquired, used in the acquisitions of AppRiver and DeliverySlip and $11.7 million for capital expenditures, which include $8.2 million in internal-use software costs, and $3.5 million for computer and networking equipment. These investments in new equipment and cloud hosting infrastructure are to renovate our business processes and product offerings.
Investing activities in 2018 consist of $11.8 million, net of cash acquired, used in the acquisition of Erado and $4.2 million for capital expenditures, which include $2.1 million for computer and networking equipment, $1.5 million in internal-use software costs, and $500 thousand for other activities including the acquisition of other internal use software. These investments in new equipment and cloud hosting infrastructure were to modernize our business processes and product offerings.
Financing activities in 2019 includes proceeds from long term debt of $179.2 million, net of issuance costs of $6.4 million and repayment of $1.4 million, as well as $96.6 million, net of issuance costs, raised through the private purchase of preferred stock, and $415 thousand received from the exercise of stock options. The proceeds from our debt and preferred stock issuances were used to fund our AppRiver acquisition in February 2019 and our DeliverySlip acquisition in May 2019. We also used $3.8 million for contingent consideration payments associated with our acquisitions of Greenview, Erado and DeliverySlip. In addition to these items, we paid $1.7 million to satisfy finance lease liabilities and $1.9 million to repurchase common stock related to the tax impact of vesting restricted awards in 2019.
Financing activities in 2018 relate primarily to $5.4 million used in a $10 million share repurchase program authorized by our Board of Directors on April 24, 2017, and $656 thousand used in the repurchase of common stock related to the tax impact of vesting restricted stock awards, and a $605 thousand earn-out payment associated with our acquisition of Greenview. Financing activities in 2017 include $3.8 million used in the same share repurchase program and $762 thousand used in the repurchase of common stock related to the tax impact of vesting restricted awards offset by the receipt of $4.2 million from the exercise of stock options.
Table:
Years Ended December 31, |  |  | 
(In thousands) | 2019 | 2018 | 2017
Net cash provided by operations | $ 13,951 | $ 16,671 | $ 18,204
Net cash used in investing activities | $ (296,243 ) | $ (15,952 ) | $ (11,285 )
Net cash provided by (used in) financing activities | $ 268,740 | $ (6,593 ) | $ (367 )


Question: Which acquisitions made use of proceeds from the company's debt and preferred stock issuances in February 2019 and May 2019 respectively?
Answer: AppRiver, DeliverySlip
AMERICAN TOWER CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(Tabular amounts in millions, unless otherwise disclosed)
At December 31, 2019, the Company had net federal, state and foreign operating loss carryforwards available to reduce future taxable income. If not utilized, the Company’s NOLs expire as follows:
Table:
Years ended December 31, | Federal | State | Foreign
2020 to 2024 | $— | $222.3 | $11.9
2025 to 2029 | 141.6 | 285.7 | 104.8
2030 to 2034 | 7.0 | 41.4 | 19.6
2035 to 2039 | 3.6 | 159.5 | —
Indefinite carryforward | 22.8 | — | 853.8
Total | $175.0 | $708.9 | $990.1


Question: What was the company's Federal NOLs expiring in 2025 to 2029?
Answer: 141.6
IBM Working Capital
Working capital decreased $10,200 million from the year-end
2018 position. The key changes are described below:
Current assets decreased $10,726 million ($10,477 million adjusted for currency) due to: • A decline in receivables of $6,769 million ($6,695 million adjusted for currency) driven by a decline in financing receivables of $8,197 million primarily due to the wind down of OEM IT commercial financing operations; partially offset by an increase in other receivables of $989 million primarily related to divestitures; and • A decrease of $3,213 million ($3,052 million adjusted for currency) in cash and cash equivalents, restricted cash, and marketable securities primarily due to retirement of debt.
Current liabilities decreased $526 million ($449 million adjusted
for currency) as a result of:
• A decrease in accounts payable of $1,662 million primarily due to the wind down of OEM IT commercial financing operations; and • A decrease in short-term debt of $1,410 million due to maturities of $12,649 million and a decrease in commercial paper of $2,691 million; partially offset by reclassifications of $7,592 million from long-term debt to reflect upcoming maturities and issuances of $6,334 million; offset by • An increase in operating lease liabilities of $1,380 million as a result of the adoption of the new leasing standard on January 1, 2019; and • An increase in deferred income of $861 million ($890 million adjusted for currency).
Table:
($ in millions) |  | 
At December 31: | 2019 | 2018
Current assets | $38,420 | $49,146
Current liabilities | 37,701 | 38,227
Working capital | $   718 | $10,918
Current ratio | 1.02:1 | 1.29:1


Question: What is the percentage increase / (decrease) in Current liabilities from 2018 to 2019?
Answer: -1.38
Calculation: 37,701/38,227 - 1
Underlying effective tax rate
The underlying effective tax rate is calculated by dividing taxation excluding the tax impact of non-underlying items by profit before tax excluding the impact of non-underlying items and share of net profit/(loss) of joint ventures and associates. This measure reflects the underlying tax rate in relation to profit before tax excluding non-underlying items before tax and share of net profit/(loss) of joint ventures and associates.
Tax impact on non-underlying items within operating profit is the sum of the tax on each non-underlying item, based on the applicable country tax rates and tax treatment. This is shown in the table:
(a) Restated following adoption of IFRS 16. See note 1 and note 24 for further details.
(b) Refer to note 3 for further details on these items.
(c) Excludes €3 million (2018: €32 million) gain on disposal of spreads business by the joint venture in Portugal which is included in the share of net profit/(loss) of joint ventures and associates line. Including the gain, total non-underlying items not in operating profit but within net profit before tax is €35 million (2018: €154 million). See note 3.
Table:
 | € million | € million
 | 2019 | 2018
 |  | (Restated)(a)
Taxation | 2,263 | 2,572
Tax impact of: |  | 
Non-underlying items within operating profit(b) | 309 | (259)
Non-underlying items not in operating profit  Taxation before tax impact of non-underlying | (196) | (29)
Taxation before tax impact of non-underlying | 2,376 | 2,284
Profit before taxation | 8,289 | 12,360
Non-underlying items within operating profit before tax(b) | 1,239 | (3,176)
Non-underlying items not in operating profit but within net profit before tax(c) | (32) | (122)
Share of net (profit)/loss of joint ventures and associates | (176) | (185)
Profit before tax excluding non-underlying items before tax and share of net profit/ (loss) of joint ventures and associates | 9,320 | 8,877
Underlying effective tax rate | 25.5% | 25.7%


Question: What is the increase / (decrease) in Profit before taxation from 2018 to 2019?
Answer: -4071
Calculation: 8,289 - 12,360
performance graph the following graph compares the yearly change in the cumulative total stockholder return for our last five full fiscal years , based upon the market price of our common stock , with the cumulative total return on a nasdaq composite index ( u.s . companies ) and a peer group , the nasdaq medical equipment-sic code 3840-3849 index , which is comprised of medical equipment companies , for that period . the performance graph assumes the investment of $ 100 on march 31 , 2010 in our common stock , the nasdaq composite index ( u.s . companies ) and the peer group index , and the reinvestment of any and all dividends. .

Table:
 | 3/31/2010 | 3/31/2011 | 3/31/2012 | 3/31/2013 | 3/31/2014 | 3/31/2015
abiomed inc | 100 | 140.79 | 215.02 | 180.91 | 252.33 | 693.60
nasdaq composite index | 100 | 115.98 | 128.93 | 136.26 | 175.11 | 204.38
nasdaq medical equipment sic code 3840-3849 | 100 | 108.31 | 115.05 | 105.56 | 123.18 | 118.95
this graph is not 201csoliciting material 201d under regulation 14a or 14c of the rules promulgated under the securities exchange act of 1934 , is not deemed filed with the securities and exchange commission and is not to be incorporated by reference in any of our filings under the securities act of 1933 , as amended , or the exchange act whether made before or after the date hereof and irrespective of any general incorporation language in any such filing .
transfer agent american stock transfer & trust company , 59 maiden lane , new york , ny 10038 , is our stock transfer agent. .

Question: what is the roi of an investment in abiomed inc from march 2010 to march 2013?
Answer: 80.9%
Calculation: subtract(180.91, 100), divide(#0, 100)
b. Categories of equity shareholding as on March 31, 2019:
c. Top ten equity shareholders of the Company as on March 31, 2019:
* Shareholding is consolidated based on Permanent Account Number (PAN) of the shareholder.
Table:
Category | Number of equity shares held | Percentage of holding
Promoters | 2,702,450,947 | 72.0
Other Entities of the Promoter Group | 1,091,053 | -
Mutual Funds & UTI | 93,357,668 | 2.5
Banks, Financial Institutions, States and Central Government | 2,750,113 | 0.1
Insurance Companies | 196,172,807 | 5.2
Foreign Institutional Investors and Foreign Portfolio Investors - Corporate | 592,842,601 | 15.8
NRI's / OCB's / Foreign Nationals | 4,854,682 | 0.1
Corporate Bodies / Trust | 26,208,151 | 0.7
Indian Public & Others | 130,744,399 | 3.6
Alternate Investment Fund | 1,663,495 | -
IEPF account | 248,790 | -
GRAND TOTAL | 3,752,384,706 | 100.0
 |  | 
Name of the shareholder* | Number of equity shares held | Percentage of holding
1. Tata Sons Private Limited | 2,702,450,947 | 72.0
2. Life Insurance Corporation of India | 152,493,927 | 4.1
3. SBI Mutual Fund | 21,680,561 | 0.6
4. First State Investments Icvc- Stewart Investors Asia Pacific Leaders Fund | 19,248,438 | 0.5
5. Government of Singapore | 18,028,475 | 0.5
6. Oppenheimer Developing Markets Fund | 16,731,906 | 0.5
7. ICICI Prudential Life Insurance Company Ltd | 16,139,316 | 0.4
8. Axis Mutual Fund Trustee Limited | 15,244,614 | 0.4
9. Abu Dhabi Investment Authority | 15,036,984 | 0.4
10. Vanguard Emerging Markets Stock Index Fund, A Series of Vanguard International Equity Index Funds | 14,112,213 | 0.4


Question: How many equity shares does the Government of Singapore hold in the company?
Answer: 18,028,475
Operating assets and liabilities
5 Trade and other receivables
(a) Trade receivables
(i) Classification as trade receivables
Trade receivables are amounts due from customers for goods sold or services performed in the ordinary course of business. They are generally due for settlement within 30 - 60 days and therefore are all classified as current. Trade receivables are recognised initially at the amount of consideration that is unconditional unless they contain significant financing components, when they are recognised at fair value. The Group holds the trade receivables with the objective to collect the contractual cash flows and therefore measures them subsequently at amortised cost using the effective interest method.
(ii) Fair values of trade and other receivables
Due to the short-term nature of the trade and other receivables, their carrying amount is considered to be the same as their fair value.
(iii) Impairment and risk exposure
Information about the Group's impairment policies, calculation of loss allowance and exposure to credit risk, foreign currency risk and interest rate risk can be found in note 15.
(b) Interest receivable
Interest receivable relates to interest accrued on term deposits. Credit risk of this is assessed in the same manner as cash and cash equivalents which is detailed in note 15.
Table:
 |  | 30 June 2019 | 30 June 2018
 | Note | $'000 | $'000
Trade receivables | 5(a) | 28,320 | 36,522
Loss allowance (see note 15(b)) |  | (741) | (1,254)
 |  | 27,579 | 35,268
Interest receivable | 5(b) | 54 | 27
GST receivable |  | 6,222 | 162
Other receivables |  | 1 | 1,629
Total |  | 33,856 | 37,086


Question: What was the percentage change in GST receivables between 2018 and 2019?
Answer: 3740.74
Calculation: (6,222 - 162) / 162