hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
15. Revenue from Contracts with Customers
Impact of Adopting Topic 606
The effects of the adoption on the Company's Consolidated Financial Statements for the fiscal year ended September 28, 2019 was as follows (in thousands):
Table:
 | September 28, 2019
As Reported | Adjustments due to Topic 606 | September 28, 2019
As Adjusted - Without
Adoption of Topic 606
ASSETS |  |  | 
   Contract assets | $90,841 | $90,841 | $—
Inventories | 700,938 | (81,895) | 782,833
LIABILITIES AND SHAREHOLDERS' EQUITY |  |  | 
Other accrued liabilities | $106,461 | $(375) | $106,836
Retained earnings | 1,178,677 | 9,321 | 1,169,356


Question: How many types of assets and liabilities had adjustments that exceeded $10,000 thousand?
Answer: 2
Calculation: Contract assets##Inventories
8 Auditor’s remuneration
1 Relates to the interim report review of the Group, and interim reviews of certain subsidiary undertakings.
2 2019 other non-audit assurance services relate primarily to reporting accountants’ work associated with the potential equity raise not completed.
The reporting accountants’ work surrounding the potential equity raise not completed includes a working capital report that requires the accountant to have detailed knowledge of the Group. If a firm other than the audit firm were to undertake this work, they would require a significant amount of additional time to become familiar with the Group. Deloitte was therefore chosen to undertake this work as it was considered to be sensible and more efficient both in terms of time and costs.
2018 other non-audit assurance services included £40,000 related to reporting accountants’ work associated with a year end significant change report and £190,000 related to reporting accountants’ work in connection with the Group’s Q3 profit estimate which was required at the time due to Takeover Code rules.
The work surrounding a significant change report and a profit estimate requires the accountant to have detailed knowledge of the Group. If a firm other than the audit firm were to undertake this work, they would require a significant amount of additional time to become familiar with the Group. PwC was therefore chosen to undertake this work as it was considered to be sensible and more efficient both in terms of time and costs.
As for all 2019 and 2018 non-audit work, consideration was given as to whether Deloitte’s (2019) and PwC’s (2018) independence could be affected by undertaking this work. It was concluded by the Audit Committee that this would not be the case.
Fees payable by the Group’s joint ventures in respect of 2019 were £156,000 (Group’s share), all of which relates to audit and audit-related services (2018: £121,000, all of which related to audit and audit-related services).
Table:
 | 2019 | 2018
 | £000 | £000
Fees payable to the Company’s auditor and its associates for: |  | 
The audit of the Company’s annual financial statements | 559 | 382
The audit of the Company’s subsidiaries | 533 | 441
Fees related to the audit of the Company and its subsidiaries | 1,092 | 823
Audit-related assurance services1 | 64 | 51
Total fees for audit and audit-related services | 1,156 | 874
Other non-audit assurance services2 | 534 | 230
Total fees | 1,690 | 1,104


Question: What were the fees payable related to audit and audit-related services in 2018?
Answer: £121,000
The Systems gross profit margin decrease year to year was driven by the mix away from IBM Z and margin declines in Power Systems and Storage Systems.
The pre-tax income decline was driven by the strong performance in IBM Z in the prior year and the continued investment in innovation across the Systems portfolio.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2018 | 2017 | Yr.-to-Yr. Percent/ Margin Change
Systems |  |  | 
External Systems Hardware gross profit | $2,590 | $2,893 | (10.5)%
External Systems Hardware gross profit margin | 40.7% | 44.6% | (3.8)pts
External Operating Systems Software gross profit | $1,412 | $1,469 | (3.9)%
External Operating Systems Software gross profit margin | 84.5% | 86.4% | (1.9)pts.
External total gross profit | $4,002 | $4,362 | (8.2)%
External total gross profit margin | 49.8% | 53.2% | (3.4)pts.
Pre-tax income | $ 904 | $1,128 | (19.9)%
Pre-tax margin | 10.2% | 12.6% | (2.4)pts.


Question: What is the average of External Systems Hardware gross profit?
Answer: 2741.5
Calculation: (2,590+2,893) / 2
The following table sets forth the components of identifiable intangible assets acquired and their estimated useful lives as of the date of acquisition.
The amount recorded for developed technology represents the estimated fair value of AgileCraft’s enterprise agile planning technology. The amount recorded for customer relationships represents the fair value of the underlying relationships with AgileCraft’s customers. The amount recorded for backlog represents the fair value of AgileCraft’s backlog as of acquisition date.
Table:
 | Fair Value | Useful Life
 | (U.S. $ in thousands) | (years)
Developed technology | $34,600 | 5
Customer relationships | 16,900 | 7
Backlog | 1,400 | 3
Total intangible assets subject to amortization | $52,900 | 


Question: What is the difference in fair value between developed technology and customer relationships?
Answer: 17700
Calculation: 34,600-16,900
The following table summarizes the activity related to stock options during the year ended December 31, 2019
As of December 31, 2019, the Company had $1,641 of unrecognized stock-based compensation expense related to the stock options. This cost is expected to be recognized over a weighted-average period of 2.5 years.
(Dollars in thousands, except per share amounts)
Table:
 | Number of Shares | Weighted-Average Exercise Price | Weighted Average Remaining Contractual Life (in years) | Aggregated Intrinsic Value (in thousands)
Stock options outstanding - December 31, 2018 | - | - - |  | 
Granted | 5,835,724 | $0.56 |  | 
Forfeited or expired | (20,000) | $0.55 |  | 
Stock options outstanding - December 31, 2019 | 5,815,724 | $0.56 | 9.6 years | $2,725
Stock options exercisable - December 31, 2019 | 137,500 | $0.55 | 9.6 years | $66


Question: What is the value of unrecognized stock-based compensation expense related to the stock options at December 31, 2019?
Answer: $1,641
stock performance graph the following graph sets forth the cumulative total shareholder return on our series a common stock , series b common stock and series c common stock as compared with the cumulative total return of the companies listed in the standard and poor 2019s 500 stock index ( 201cs&p 500 index 201d ) and a peer group of companies comprised of cbs corporation class b common stock , scripps network interactive , inc . ( acquired by the company in march 2018 ) , time warner , inc . ( acquired by at&t inc . in june 2018 ) , twenty-first century fox , inc . class a common stock ( news corporation class a common stock prior to june 2013 ) , viacom , inc . class b common stock and the walt disney company . the graph assumes $ 100 originally invested on december 31 , 2013 in each of our series a common stock , series b common stock and series c common stock , the s&p 500 index , and the stock of our peer group companies , including reinvestment of dividends , for the years ended december 31 , 2014 , 2015 , 2016 , 2017 and 2018 . two peer companies , scripps networks interactive , inc . and time warner , inc. , were acquired in 2018 . the stock performance chart shows the peer group including scripps networks interactive , inc . and time warner , inc . and excluding both acquired companies for the entire five year period . december 31 , december 31 , december 31 , december 31 , december 31 , december 31 .

Table:
 | december 312013 | december 312014 | december 312015 | december 312016 | december 312017 | december 312018
disca | $ 100.00 | $ 74.58 | $ 57.76 | $ 59.34 | $ 48.45 | $ 53.56
discb | $ 100.00 | $ 80.56 | $ 58.82 | $ 63.44 | $ 53.97 | $ 72.90
disck | $ 100.00 | $ 80.42 | $ 60.15 | $ 63.87 | $ 50.49 | $ 55.04
s&p 500 | $ 100.00 | $ 111.39 | $ 110.58 | $ 121.13 | $ 144.65 | $ 135.63
peer group incl . acquired companies | $ 100.00 | $ 116.64 | $ 114.02 | $ 127.96 | $ 132.23 | $ 105.80
peer group ex . acquired companies | $ 100.00 | $ 113.23 | $ 117.27 | $ 120.58 | $ 127.90 | $ 141.58
equity compensation plan information information regarding securities authorized for issuance under equity compensation plans will be set forth in our definitive proxy statement for our 2019 annual meeting of stockholders under the caption 201csecurities authorized for issuance under equity compensation plans , 201d which is incorporated herein by reference. .

Question: did the b series stock's 5 year performance beat the s&p 500?
Answer: no
Calculation: greater(72.90, 135.63)
RESEARCH AND DEVELOPMENT EXPENSES
Total research and development (R&D) expenses, excluding impairment charges, increased by 22% in 2019 compared to the previous year, mainly as a result of higher development activities. As a percentage of sales (excluding the patent litigation & arbitration settlement), R&D expenses decreased to 10% compared to 11% in 2018. Currency changes resulted in a 4% increase in R&D expenses year-over-year.
Total research and development expenses developed as follows:
Impairment of capitalized development expenses related primarily to the development of new technology that is now no longer in-demand from customers.
We continue to invest strongly in R&D. As part of our R&D activities, we are engaged in various development programs with customers and research institutes. These allow us to develop products that meet customer requirements and obtain access to new technology and expertise. The costs relating to prototypes and experimental models, which we may subsequently sell to customers, are charged to the cost of sales.
Our R&D operations in the Netherlands, Belgium, and the United States receive research and development grants and credits from various sources.
Table:
Year ended December 31, |  |  | 
(EUR million) | 2018 | 2019 | % Change
Front-end: |  |  | 
Research and development expenses | 125.3 | 150.7 | 20%
Capitalization of development expenses | (49.7) | (60.2) | 21%
Research and development grants and credits | (0.3) | – | –
Amortization of capitalized development  expenses | 12.0 | 15.6 | 30%
 | 87.3 | 106.1 | 22%
Impairment capitalized development expenses | 1.3 | 4.8 | –
Total | 88.6 | 110.8 | 25%


Question: What are the years included in the table for Total research and development expenses?
Answer: 2018, 2019
Product Revenue by Groups of Similar Products
In addition to the primary view on a geographic basis, we also prepare financial information related to groups of similar products and customer markets for various purposes. We report our product revenue in the following categories: Infrastructure Platforms, Applications, Security, and Other Products. This aligns our product categories with our evolving business model. Prior period amounts have been reclassified to conform to the current period’s presentation.
The following table presents revenue for groups of similar products (in millions, except percentages):
Amounts may not sum and percentages may not recalculate due to rounding.
Infrastructure Platforms The Infrastructure Platforms product category represents our core networking offerings related to switching, routing, wireless, and the data center. Infrastructure Platforms revenue increased by 7%, or $1,869 million, with growth across the portfolio. Switching had solid growth, with strong revenue growth in campus switching driven by an increase in sales of our intent-based networking Catalyst 9000 Series, and with growth in data center switching driven by increased revenue from our ACI portfolio. Routing experienced modest revenue growth driven by an increase in sales of SD-WAN products, partially offset by weakness in the service provider market. We experienced double digit revenue growth from wireless products driven by increases across the portfolio. Revenue from data center increased driven by higher sales of HyperFlex and our server products.
Applications The Applications product category includes our collaboration offerings (unified communications, Cisco TelePresence and conferencing) as well as IoT and AppDynamics analytics software offerings. Revenue in our Applications product category increased by 15%, or $767 million, with double digit growth in unified communications, TelePresence, AppDynamics, and IoT software.
Security Revenue in our Security product category increased 16%, or $378 million, driven by higher sales of identity and access, advanced threat security, unified threat management and web security products. The Duo acquisition in the first quarter of fiscal 2019 also contributed to the revenue increase in this product category.
Other Products The decrease in revenue from our Other Products category was primarily driven by a decrease in revenue from SPVSS business which we divested on October 28, 2018.
Table:
 |  | Years Ended |  | 2019 vs. 2018 | 
 | July 27, 2019 | July 28, 2018 | July 29, 2017 | Variance in Dollars | Variance in Percent
Product revenue: |  |  |  |  | 
Infrastructure Platforms | $30,191 | $28,322 | $27,817 | $1,869 | 7%
Applications | 5,803 | 5,036 | 4,568 | 767 | 15%
Security  . | 2,730 | 2,352 | 2,152 | 378 | 16%
Other Products | 281 | 999 | 1,168 | (718) | (72)%
Total  . | $39,005 | $36,709 | $35,705 | $2,296 | 6%


Question: What was the revenue from Other products in 2018?
Answer: 999
27 Financial risk management (continued)
The table below summarises the Group’s exposure to foreign exchange risk as well as the foreign exchange rates applied:
The approximate impact of a 10 per cent appreciation in foreign exchange rates would be a positive movement of £50.0 million (2018: £63.4 million) to equity attributable to owners of the Group. The approximate impact of a 10 per cent depreciation in foreign exchange rates would be a negative movement of £40.9 million (2018: £51.9 million) to equity attributable to owners of the Group. There is no material income statement impact as these exchange differences are recognised in other comprehensive income.
As part of the strategy to mitigate the Group’s exposure to foreign exchange risk, the Group is able to borrow part of its RCF in euros, up to €100 million. The RCF borrowings denominated in euros have been designated as a hedging instrument (net investment hedge) against the Group’s net investment in Spain with the hedged risk being the changes in the euro/pounds sterling spot rate that will result in changes in the value of the Group’s net investments in Spain. At 31 December 2019, €100 million (2018: €100 million) was drawn in euros.
Table:
 | 2019 | 2018 | 2019 | 2018
 | €m | €m | INRm | INRm
Net exposure | 468.9 | 555.7 | 5,072.4 | 6,274.5
Foreign exchange rate | 1.1825 | 1.1126 | 94.4586 | 88.3432


Question: What is the percentage change in the amount drawn in euros from 2018 to 2019?
Answer: 0
Calculation: (100-100)/100
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
13. INCOME TAXES
Beginning in the taxable year ended December 31, 2012, the Company has filed, and intends to continue to file, U.S. federal income tax returns as a REIT, and its domestic TRSs filed, and intend to continue to file, separate tax returns as required. The Company also files tax returns in various states and countries. The Company’s state tax returns reflect different combinations of the Company’s subsidiaries and are dependent on the connection each subsidiary has with a particular state and form of organization. The following information pertains to the Company’s income taxes on a consolidated basis.
The income tax provision from continuing operations consisted of the following:
The effective tax rate (“ETR”) on income from continuing operations for the years ended December 31, 2019, 2018 and 2017 differs from the federal statutory rate primarily due to the Company’s qualification for taxation as a REIT, as well as adjustments for state and foreign items. As a REIT, the Company may deduct earnings distributed to stockholders against the income generated by its REIT operations. In addition, the Company is able to offset certain income by utilizing its NOLs, subject to specified limitations.
Table:
 | 2019 | 2018 | 2017
Current: |  |  | 
Federal | $(1.7) | $(1.4) | $(0.1)
State | (5.0) | (1.8) | (3.8)
Foreign | (48.2) | (189.7) | (113.4)
Deferred: |  |  | 
Federal | 1.4 | 4.0 | 0.2
State | 0.5 | 0.7 | 1.0
Foreign | 53.2 | 298.3 | 85.4
Income tax benefit (provision) | $0.2 | $110.1 | $(30.7)


Question: What do the company's state tax returns reflect?
Answer: different combinations of the Company’s subsidiaries and are dependent on the connection each subsidiary has with a particular state and form of organization.
DEVELOPMENT OF EMPLOYEE NUMBERS BY SEGMENTS
By headcount1 as of closing date of 30/9
1 Excluding METRO China.
Table:
 | 2018 | 2019
METRO | 92,603 | 89,574
METRO Germany | 13,711 | 13,606
METRO Western Europe (excl.Germany) | 27,207 | 27,227
METRO Russia | 13,960 | 12,357
METRO Eastern Europe (excl.Russia) | 29,060 | 28,375
METRO Asia | 8,665 | 8,009
Others | 7,008 | 7,152
METROAG | 909 | 880
Total | 100,520 | 97,606


Question: In which year was the amount in METRO Asia headcount larger?
Answer: 2018
Calculation: 8,665>8,009
Common Stock Reserved for Issuance
As of July 31, 2019 and 2018, the Company was authorized to issue 500,000,000 shares of common stock with a par value of $0.0001 per share and, of these, 82,140,883 and 80,611,698 shares of common stock were issued and outstanding, respectively. Per the terms of the Company’s 2011 Stock Plan, on January first of each year, an additional number of shares equal to up to 5% of the number of shares of common stock issued and outstanding on the preceding December 31st is added to the Company’s 2011 Stock Plan reserve.
As of July 31, 2019 and 2018, the Company had reserved shares of common stock for future issuance as follows:
In March 2018, the Company completed a public offering of 2,628,571 shares of its common stock. The public offering price of the shares sold in the offering was $87.50 per share. No shares were sold by the Company’s stockholders in this public offering.
Table:
 | July 31, 2019  | July 31, 2018
Exercise of stock options to purchase common stock | 216,727 | 537,064
Vesting of restricted stock awards | 2,384,673 | 2,932,155
Shares available for grant under stock plans | 24,776,361 | 21,592,494
Total common stock reserved for issuance | 27,377,761 | 25,061,713


Question: In which year was Exercise of stock options to purchase common stock less than 300,000?
Answer: 2019
Calculation: locate and analyze Exercise of stock options to purchase common stock in row 2
3. VOYAGE REVENUES
Our voyage revenues consist of time charter revenues and spot charter revenues with the following split:
*Spot charter revenues for 2019 and 2018 are presented in accordance we ASC 606 Revenue from Contracts with Customers. The comparative information for 2017 has not been restated.
Table:
All amounts in USD ‘000  | 2019 | 2018 | 2017
Spot charter revenues* | 283,007 | 259,978 | 257,495
Time charter revenues   | 34,213 | 29,038 | 39,646
Total Voyage Revenues   | 317,220 | 289,016 | 297,141


Question: What is the value of the 2019 time charter revenues as a percentage of the 2018 time charter revenues?
Answer: 117.82
Calculation: 34,213/29,038
Revenue and deferred revenue
The Group adopted IFRS 15 Revenue from Contracts with Customers in the current year and has therefore restated the results for the prior-year on a consistent basis, see note 2 of the Financial Statements for further details.
The Group’s revenue increased by $71.6 million, or 11.2 per cent, to $710.6 million in the year-ended 31 March 2019. Subscription revenue was notably strong in the period, with reported growth of 15.9 per cent, or 16.7 per cent on a constant currency basis, because of strong prior-period billings and incremental growth of the MSP channel in the current period.
1 Restated for the adoption of IFRS 15 as explained in note 2 of the Financial Statements
Revenue in the period of $710.6 million comprised $394.1 million from the recognition of prior-period deferred revenues and $316.5 million from in-period billings. The majority of the Group’s billings, which are recognised over the life of the contract, relate to subscription products (FY19: 84.8 per cent; FY18: 83.8 per cent), with the benefit from increased billings being spread over a number of years on the subsequent recognition of deferred revenue. The deferred revenue balance at the end of the period of $742.1 million increased $13.5 million year-on-year, an increase of 1.9 per cent. This was mainly due to a net deferral of billings amounting to $49.7 million partially offset by a net currency revaluation of $36.2 million, a consequence of the weakening of the euro and sterling against the US dollar during the year. Deferred revenue due within one year at the balance sheet date of $428.6M increased by 5.1 per cent at actual rates or by 10.7 per cent in constant currency.
Revenue in the Americas increased by $29.7 million or 13.3 per cent to $253.3 million in the year-ended 31 March 2019, supported by the recognition of prior-period Enduser billings from the Sophos Central platform and the growth of the MSP channel in the current period.
EMEA revenue increased by $39.1 million or 12.0 per cent to $363.6 million in the year-ended 31 March 2019, with growth in Enduser in particular, but also aided by Network sales.
APJ revenue increased by $2.8 million, or 3.1 per cent to $93.7 million in the year-ended 31 March 2019, with good growth in Enduser products partially offset by a decline in Network sales following the legacy product transition.
Table:
 | FY19 | FY18¹ | Growth % | Growth %
 | $m (Reported) | $m (Reported) | (Reported) | (CC)
Revenue by Region: |  |  |  | 
– Americas | 253.3 | 223.6 | 13.3 | 13.4
– EMEA | 363.6 | 324.5 | 12.0 | 12.7
– APJ | 93.7 | 90.9 | 3.1 | 6.2
 | 710.6 | 639.0 | 11.2 | 12.0
Revenue by Product: |  |  |  | 
– Network | 328.5 | 316.5 | 3.8 | 4.7
– Enduser | 348.4 | 291.8 | 19.4 | 20.2
– Other | 33.7 | 30.7 | 9.8 | 10.0
 | 710.6 | 639.0 | 11.2 | 12.0
Revenue by Type: |  |  |  | 
– Subscription | 593.9 | 512.4 | 15.9 | 16.7
– Hardware | 106.8 | 115.1 | (7.2) | (6.3)
– Other | 9.9 | 11.5 | (13.9) | (12.8)
 | 710.6 | 639.0 | 11.2 | 12.0


Question: What was the reported percentage increase in APJ revenue in 2019 from 2018?
Answer: 3.1 per cent
Unbilled receivables are client committed amounts for which revenue recognition precedes billing, and billing is solely subject to the passage of time.
Unbilled receivables are expected to be billed in the future as follows
Table:
(Dollars in thousands) | December 31, 2019 | 
1 year or less | $180,219 | 60%
1-2 years | 91,132 | 30%
2-5 years | 30,604 | 10%
 | $301,955 | 100%


Question: What is the total unbilled receivables due within 2 years?
Answer: 271351
Calculation: 180,219 + 91,132