hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
21 Cash and Cash Equivalents
Cash at bank earns interest at floating rates based on daily bank deposit rates. Short-term deposits are made for varying periods of between one day and three months, depending on the immediate cash requirements of the Group, and earn interest at the respective short-term deposit rates.
Table:
 | 31 March 2019 | 31 March 2018
 | $M | $M
Cash at bank and in hand | 134.3 | 67.2
Short-term deposits | 37.8 | 52.8
Total cash and cash equivalent | 172.1 | 120.0


Question: What was the percentage change in the Total cash and cash equivalent in 2019 from 2018?
Answer: 43.42
Calculation: (172.1-120.0)/120.0
five-year performance comparison 2013 the following graph provides an indicator of cumulative total shareholder returns for the corporation as compared to the peer group index ( described above ) , the dow jones , and the s&p 500 . the graph assumes that the value of the investment in the common stock of union pacific corporation and each index was $ 100 on december 31 , 2002 , and that all dividends were reinvested . comparison of five-year cumulative return 2002 2003 2004 2005 2006 2007 upc s&p 500 peer group dj trans purchases of equity securities 2013 during 2007 , we repurchased 13266070 shares of our common stock at an average price of $ 115.66 . during the first nine months of 2007 , we repurchased 10639916 shares of our common stock at an average price per share of $ 112.68 . the following table presents common stock repurchases during each month for the fourth quarter of 2007 : period number of shares purchased average paid per total number of shares purchased as part of a publicly announced plan or program maximum number of shares that may yet be purchased under the plan or program .

Table:
period | totalnumber ofsharespurchased[a] | averagepricepaid pershare | total number of sharespurchased as part of apublicly announcedplan orprogram | maximum number ofshares that may yetbe purchased underthe plan orprogram[b]
oct . 1 through oct . 31 | 99782 | $ 128.78 | - | 9774279
nov . 1 through nov . 30 | 540294 | 124.70 | 528000 | 9246279
dec . 1 through dec . 31 | 1986078 | 128.53 | 1869800 | 7376479
total | 2626154 | $ 127.75 | 2397800 | n/a
[a] total number of shares purchased during the quarter includes 228354 shares delivered or attested to upc by employees to pay stock option exercise prices , satisfy excess tax withholding obligations for stock option exercises or vesting of retention units , and pay withholding obligations for vesting of retention shares .
[b] on january 30 , 2007 , our board of directors authorized us to repurchase up to 20 million shares of our common stock through december 31 , 2009 .
we may make these repurchases on the open market or through other transactions .
our management has sole discretion with respect to determining the timing and amount of these transactions. .

Question: what percentage of the total number of shares purchased were purchased in october?
Answer: 4%
Calculation: divide(99782, 2626154)
shareowner return performance graph the following performance graph and related information shall not be deemed 201csoliciting material 201d or to be 201cfiled 201d with the sec , nor shall such information be incorporated by reference into any future filing under the securities act of 1933 or securities exchange act of 1934 , each as amended , except to the extent that the company specifically incorporates such information by reference into such filing . the following graph shows a five year comparison of cumulative total shareowners 2019 returns for our class b common stock , the standard & poor 2019s 500 index , and the dow jones transportation average . the comparison of the total cumulative return on investment , which is the change in the quarterly stock price plus reinvested dividends for each of the quarterly periods , assumes that $ 100 was invested on december 31 , 2010 in the standard & poor 2019s 500 index , the dow jones transportation average , and our class b common stock. .

Table:
 | 12/31/2010 | 12/31/2011 | 12/31/2012 | 12/31/2013 | 12/31/2014 | 12/31/2015
united parcel service inc . | $ 100.00 | $ 103.88 | $ 107.87 | $ 158.07 | $ 171.77 | $ 160.61
standard & poor 2019s 500 index | $ 100.00 | $ 102.11 | $ 118.43 | $ 156.77 | $ 178.22 | $ 180.67
dow jones transportation average | $ 100.00 | $ 100.01 | $ 107.49 | $ 151.97 | $ 190.08 | $ 158.23
.

Question: what was the percentage total cumulative return on investment for united parcel service inc . for the five year period ending 12/31/2015?
Answer: 60.61%
Calculation: subtract(160.61, const_100), divide(#0, const_100)
4. Profit before tax
The following items have been charged in arriving at profit before tax:
Table:
 |  | 2019 | 2018
 | Notes | $ million | $ million
Employee benefit costs | 8 | 220.5 | 208.9
Costs of inventories recognised as an expense |  | 81.6 | 79.8
Write-down of inventories to net realisable value | 19 | 1.6 | 0.1
Amortisation of intangible assets | 13 | 2.1 | 4.3
Depreciation of property, plant and equipment | 14 | 14.7 | 16.5
Depreciation of right-of-use assets | 15 | 7.5 | –
Amortisation of assets recognised from costs to obtain a contract | 21 | 0.5 | 0.6
Operating leases – minimum lease payments |  | – | 8.5
Expenses relating to short-term leases and leases of low-value assets | 26 | 0.3 | –
Product development costs |  | 96.5 | 96.9
Net foreign exchange loss |  | 0.6 | 0.6


Question: What have the items in the table been charged in arriving at?
Answer: profit before tax
At the end of each reporting period, the Company evaluates all available information at that time to determine if it is more likely than not that some or all of these credits will be utilized. As of October 31, 2019, 2018, and 2017, the Company determined that a total of $1.8 million, $0.7 million, and $0.6 million, respectively, would be recovered. Accordingly, those amounts were released from the valuation allowance and benefited deferred tax expense in the respective periods.
The differences between the consolidated effective income tax rate and the federal statutory rate effective during the applicable year presented are as follows:
Table:
 |  | Years Ended October 31, | 
 | 2019 | 2018 | 2017
 |  | (In thousands)  | 
Income taxes at statutory rate | $13,408 | $ 7,132 | $148,585
Discrete benefit resulting from TCJA  | — | (37,505) | —
State income taxes | 1,189 | 1,014 | 9,038
State income tax credits  | (2,139) | (804) | (606)
Expiration of state income tax credits  | 4,121 | 4,117 | 642
Federal income tax credits  | (474) | (460) | (390)
Federal manufacturers deduction  | — | — | (11,527)
Excess tax benefits  | (1,388) | (1,638) | (3,345)
Nondeductible expenses | 1,786 | 1,890 | 3,506
Change in valuation allowance  | (5,380) | (5,297) | (1,106)
Other  | (570) | 677 | (12)
Income tax expense (benefit)  | $10,553 | $(30,874) | $144,785


Question: What is the State income taxes for fiscal years 2019 and 2018 respectively?
Answer: 1,189, 1,014
Segment Financial Results
Revenues
The following table sets forth revenues by segment for the periods presented (in millions):
(1) Revenues for Corporate and Other represent deferred revenue purchase accounting adjustments recorded in accordance with GAAP.
Table:
 | Year ended December 31 |  | Variance | 
 | 2019 | 2018 | $ | %
Software Solutions | $1,012.3 | $962.0 | $50.3 | 5%
Data and Analytics | 165.4 | 154.5 | 10.9 | 7%
Corporate and Other (1) | (0.5) | (2.5) | 2.0 | NM
Total | $1,177.2 | $1,114.0 | $63.2 | 6%


Question: What did Revenues for Corporate and Other represent?
Answer: deferred revenue purchase accounting adjustments recorded in accordance with GAAP.
Unearned Revenue
Unearned revenue as of the periods presented consisted of the following (table in millions):
Unearned subscription and SaaS revenue is generally recognized over time as customers consume the services or ratably over the term of the subscription, commencing upon provisioning of the service. Previously, unearned subscription and SaaS revenue was allocated between unearned license revenue and unearned software maintenance revenue in prior periods and has been reclassified to conform with current period presentation.
Unearned software maintenance revenue is attributable to our maintenance contracts and is generally recognized over time on a ratable basis over the contract duration. The weighted-average remaining contractual term as of January 31, 2020 was approximately two years. Unearned professional services revenue results primarily from prepaid professional services and is generally recognized as the services are performed.
Table:
 | January 31, 2020 | February 1,2019
Unearned license revenue | $19 | $15
Unearned subscription and SaaS revenue | 1,534 | 916
Unearned software maintenance revenue | 6,700 | 5,741
Unearned professional services revenue | 1,015 | 767
Total unearned revenue | $9,268 | $7,439


Question: Which years does the table provide information for unearned revenue?
Answer: 2020, 2019
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENT(Tabular amounts in millions, unless otherwise disclosed)
11. ASSET RETIREMENT OBLIGATIONS
The changes in the carrying amount of the Company’s asset retirement obligations were as follows:
(1) Revisions in estimates include decreases to the liability of $6.7 million and $49.4 million related to foreign currency translation for the years ended December 31, 2019 and 2018, respectively.
As of December 31, 2019, the estimated undiscounted future cash outlay for asset retirement obligations was $3.2 billion.
Table:
 | 2019 | 2018
Beginning balance as of January 1, | $1,210.0 | $1,175.3
Additions | 61.8 | 39.6
Accretion expense | 81.6 | 83.6
Revisions in estimates (1) | 56.8 | (81.5)
Settlements | (26.1) | (7.0)
Balance as of December 31, | $1,384.1 | $1,210.0


Question: How much were the decreases to the liability included in the revisions in estimates by the company in 2019 and 2018 respectively?
Answer: $6.7 million, 49.4 million
3. Operating (loss)/profit
Detailed below are the key amounts recognised in arriving at our operating (loss)/profit
Notes: 1 The year ended 31 March 2019 included €nil (2018: €80 million credit, 2017: €127 million charge) reported in other income and expense in the consolidated income statement
2 Reported in other income and expense in the consolidated income statement.
Table:
 | 2019 | 2018 | 2017
 | €m | €m | €m
Net foreign exchange losses/(gains)1 | 1 | (65) | 133
Depreciation of property, plant and equipment (note 11): |  |  | 
Owned assets | 5,795 | 5,963 | 6,253
Leased assets | 59 | 47 | 12
Amortisation of intangible assets (note 10) | 3,941 | 4,399 | 4,821
Impairment of goodwill in subsidiaries, associates and joint arrangements (note 4) | 3,525 | – | –
Staff costs (note 23) | 5,267 | 5,295 | 5,519
Amounts related to inventory included in cost of sales | 5,886 | 6,045 | 6,464
Operating lease rentals payable | 3,826 | 3,788 | 3,976
Loss on disposal of property, plant and equipment and intangible assets | 33 | 36 | 22
Own costs capitalised attributable to the construction or acquisition of property, plant and equipment | (844) | (829) | (800)
Net gain on formation of VodafoneZiggo (note 26)2 | – | – | (1,275)


Question: What is the average leased assets for 2018 and 2019?
Answer: 53
Calculation: (47+59)/2
The total annual compensation of the Supervisory Board members is as follows:
Supervisory Board Compensation
The Supervisory Board members do not receive any share-based payment for their services. As far as members who are employee representatives on the Supervisory Board receive share-based payment, such compensation is for their services as employees only and is unrelated to their status as members of the Supervisory Board.
Table:
€ thousands | 2019 | 2018 | 2017
Total compensation | 3,770 | 3,702 | 3,663
Thereof fixed compensation | 3,218 | 3,162 | 3,135
Thereof committee remuneration | 553 | 540 | 528


Question: What was the total compensation in 2019?
Answer: 3,770
NOTE 22. INCOME TAXES
Amounts recognized in profit or loss
The income tax expense consists of:
Table:
 | Year ended December 31, | 
 | 2018 | 2019
Current: |  | 
The Netherlands | (4,128) | (28,409)
Other countries | (6,374) | (9,011)
 | (10,502) | (37,420)
Deferred: |  | 
The Netherlands | 1,944 | (6,860)
Other countries | (6,878) | (9,370)
Income tax expense | (15,436) | (53,650)


Question: What is the current income tax expense for The Netherlands in 2018 and 2019 respectively?
Answer: (4,128), (28,409)
18. Trade and other payables  Significant accounting policies that apply to trade and other payables We initially recognise trade and other payables at fair value, which is usually the original invoiced amount. We subsequently carry them at amortised cost using the effective interest method.
a Deferred income recognised in prior periods has substantially been reclassified to contract liabilities on adoption of IFRS 15, see notes 1 and 2. The remaining balance includes £51m (2017/18: £132m, 2016/17: £71m) current and £586m (2017/18: £404m, 2016/17: £375m) non-current liabilities relating to the Broadband Delivery UK programme, for which grants received by the group may be subject to re-investment or repayment depending on the level of take-up.
b Other payables relate to operating lease liabilities and deferred gains on a 2001 sale and finance leaseback transaction.
Table:
 | 2019 | 2018 | 2017
At 31 March | £m | £m | £m
Current |  |  | 
Trade payables | 4,141 | 3,991 | 4,205
Other taxation and social security | 564 | 704 | 704
Other payables | 387 | 456 | 672
Accrued expenses | 630 | 492 | 382
Deferred income a | 68 | 1,525 | 1,474
 | 5,790 | 7,168 | 7,437


Question: What is the change in Current: Trade payables from 2018 to 2019?
Answer: 150
Calculation: 4,141-3,991
Operating income increased to SEK 2.3 (1.1) billion. Operating income excluding restructur- ing charges improved to SEK 2.4 (1.4) billion due to a positive effect from reversal of a provision for impairment of trade receivables made in Q1 2019, of SEK 0.7 billion, and higher gross margin.
Operating margin was 6.3%, excluding restructuring charges and the positive effect from reversal of a provision for impairment of trade receivables of SEK 0.7 billion in Q1 2019.
Restructuring charges amounted to SEK 0.0 (–0.3) billion.
Emerging Business and Other
Segment Emerging Business and Other represented 3% (4%) of Group net sales in 2019.
The segment includes:
–– Emerging Business, including IoT, iconectiv
and New businesses
–– Media businesses, including Red Bee
Media and a 49% ownership of MediaKind.
Net sales
Reported sales decreased by –19% in 2019 due to the 51% divestment of MediaKind in February 2019. Sales adjusted for comparable units and currency increased by 14% driven by growth in the iconectiv business through a multi-year number portability contract in the US.
Gross margin
Gross margin declined mainly due to the 51% divestment of MediaKind. The decline was partly offset by lower restructuring charges.
Operating income (loss)
Operating income was impacted by costs of SEK –10.7 billion related to the resolution of the US SEC and DOJ investigations, a refund of earlier paid social security costs in Sweden of SEK 0.9 billion and by costs of SEK –0.3
billion related to the wind-down of the ST-Ericsson legal structure.
Operating income in Emerging Business, iconectiv and common costs improved, driven by profitable growth in iconectiv. Red Bee Media income improved supported by profit improvement activities. Media Solutions income improved driven by the 51% divestment of Media Kind, including a capital gain from the transaction.
Table:
SEK billion | Full year 2019 | Full year 2018
Segment operating income | -12.5 | -5.4
income of which Emerging Business, iconective, media businesses and common costs | -2.4 | -5.4
of which SEC and DOJ
settlement costs | –10.7 | –
of which costs for
ST-Ericsson wind-down | –0.3 | –
of which a refund of social security costs in Sweden | 0.9 | -


Question: What is the reason that gross margin declined?
Answer: the 51% divestment of MediaKind
Inventory
Inventory is stated at the lower of cost and net realizable value, using the first-in, first-out (“FIFO”) valuation method. Net realizable value is the estimated selling prices in the ordinary course of business, less reasonably predictable costs of completion, disposal, and transportation. Any adjustments to reduce the cost of inventories to their net realizable value are recognized in earnings in the current period.
Due to the low sell-through of our AirBar products, management has decided to fully reserve work-in-process for AirBar components, as well as AirBar related raw materials. Management has further decided to reserve for a portion of AirBar finished goods, depending on type of AirBar and in which location it is stored. The AirBar inventory reserve was $0.8 million and $1.0 million for the years ended December 31, 2019 and 2018, respectively.
In order to protect our manufacturing partners from losses in relation to AirBar production, we agreed to secure the value of the inventory with a bank guarantee. Since the sale of AirBars has been lower than expected, a major part of the inventory at the partner remained unused when the due date of the bank guarantee neared and Neonode therefore agreed that the partner should keep inventory for the production of 20,000 AirBars and the rest be purchased by us. The inventory value of these purchases has been fully reserved.
As of December 31, 2019, the Company’s inventory consists primarily of components that will be used in the manufacturing of our sensor modules. We segregate inventory for reporting purposes by raw materials, work-in-process, and finished goods.
Raw materials, work-in-process, and finished goods are as follows (in thousands):
Table:
 | December 31, | December 31,
 | 2019 | 2018
Raw materials | $396 | $246
Work-in-process | 186 | 220
Finished goods | 448 | 753
Ending inventory | $1,030 | $1,219


Question: What is the net realizable value?
Answer: the estimated selling prices in the ordinary course of business, less reasonably predictable costs of completion, disposal, and transportation
Note 12. Current liabilities - trade and other payables
Accounting policy for trade and other payables 

These amounts represent liabilities for goods and services provided to the Group prior to the end of the financial year and which are unpaid. Due to their short-term nature they are measured at amortised cost and are not discounted. The amounts are unsecured and are usually paid within 30 days of recognition.
Deferred consideration 

The payable represents the obligation to pay consideration following the acquisition of a business or assets and is deferred based on passage of time. It is measured at the present value of the estimated liability.
Table:
Consolidated |  | 
 | 2019 | 2018
 | US$’000 | US$’000
Trade payables | 3,492 | 2,016
Deferred consideration | 888 | 643
Other payables | 11,898 | 9,488
 | 16,278 | 12,147


Question: What are the components of the liabilities?
Answer: Trade payables, Deferred consideration, Other payables
(a) Revenue and Gross Margin by Segment
We conduct business globally and are managed on a geographic basis consisting of three segments: the Americas, EMEA, and APJC. Our management makes financial decisions and allocates resources based on the information it receives from our internal management system. Sales are attributed to a segment based on the ordering location of the customer. We do not allocate research and development, sales and marketing, or general and administrative expenses to our segments in this internal management system because management does not include the information in our measurement of the performance of the operating segments. In addition, we do not allocate amortization and impairment of acquisition-related intangible assets, sharebased compensation expense, significant litigation settlements and other contingencies, charges related to asset impairments and restructurings, and certain other charges to the gross margin for each segment because management does not include this information in our measurement of the performance of the operating segments.
Summarized financial information by segment for fiscal 2019, 2018, and 2017, based on our internal management system and as utilized by our Chief Operating Decision Maker (CODM), is as follows (in millions):
Amounts may not sum and percentages may not recalculate due to rounding.
Revenue in the United States was $27.4 billion, $25.5 billion, and $25.0 billion for fiscal 2019, 2018, and 2017, respectively.
Table:
Years Ended | July 27, 2019 | July 28, 2018 | July 29, 2017
Revenue: |  |  | 
Americas  . | $30,927 | $29,070 | $28,351
EMEA  . | 13,100 | 12,425 | 12,004
APJC . | 7,877 | 7,834 | 7,650
Total | $51,904 | $49,330 | $48,005
Gross margin: |  |  | 
Americas . | $20,338 | $18,792 | $18,284
EMEA  . | 8,457 | 7,945 | 7,855
APJC . | 4,683 | 4,726 | 4,741
Segment total . | 33,479 | 31,463 | 30,880
Unallocated corporate items . | (813) | (857) | (656)
Total | $32,666 | $30,606 | $30,224


Question: What was the gross margin from Americas in 2019?
Answer: 20,338
A tax credit of £8.9m in the year compared to a £13.7m charge in the prior year. This included a deferred tax credit in the current year of £6.1m, largely reflecting the loss before tax reported of £42.7m and a credit of £1.7m relating to the adjustment of prior period losses and capital allowances. A current year tax credit of £1.1m was in respect of overseas tax.
A deferred tax liability at 30 March 2019 of £13.5m compared to a liability of £12.1m at 31 March 2018. This movement is primarily due to a slightly higher pensions surplus reported at 30 March 2019 compared to 31 March 2018 reflecting the allowability for tax on pensions contribution payments. Recognised and unrecognised deferred tax assets relating to brought forward losses were approximately £44m at 30 March 2019 and equate to around £250m of future taxable profits.
The corporation tax rate and deferred tax rate applied in calculations are 19.0% and 17.0% respectively.
Table:
£m | 2018/19 | 2017/18 | Change
Overseas current tax |  |  | 
Current year | 1.1 | 0.8 | 0.3
Deferred tax |  |  | 
Current period | 6.1 | (4.1) | 10.2
Prior periods | 1.7 | (8.1) | 9.8
– Adjustment to restate opening deferred tax at 17.0% | – | (2.3) | 2.3
Income tax credit/ (charge) | 8.9 | (13.7) | 22.6


Question: What was the corporation tax rate?
Answer: 19.0%