hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
rates are still low and that a significant portion of cruise guests carried are first-time cruisers . we believe this presents an opportunity for long-term growth and a potential for increased profitability . the following table details industry market penetration rates for north america , europe and asia/pacific computed based on the number of annual cruise guests as a percentage of the total population : year north america ( 1 ) ( 2 ) europe ( 1 ) ( 3 ) asia/pacific ( 1 ) ( 4 ) .

Table:
year | north america ( 1 ) ( 2 ) | europe ( 1 ) ( 3 ) | asia/pacific ( 1 ) ( 4 )
2012 | 3.33% ( 3.33 % ) | 1.21% ( 1.21 % ) | 0.04% ( 0.04 % )
2013 | 3.32% ( 3.32 % ) | 1.24% ( 1.24 % ) | 0.05% ( 0.05 % )
2014 | 3.46% ( 3.46 % ) | 1.23% ( 1.23 % ) | 0.06% ( 0.06 % )
2015 | 3.36% ( 3.36 % ) | 1.25% ( 1.25 % ) | 0.08% ( 0.08 % )
2016 | 3.49% ( 3.49 % ) | 1.24% ( 1.24 % ) | 0.09% ( 0.09 % )
( 1 ) source : our estimates are based on a combination of data obtained from publicly available sources including the international monetary fund , united nations , department of economic and social affairs , cruise lines international association ( "clia" ) and g.p .
wild .
( 2 ) our estimates include the united states and canada .
( 3 ) our estimates include european countries relevant to the industry ( e.g. , nordics , germany , france , italy , spain and the united kingdom ) .
( 4 ) our estimates include the southeast asia ( e.g. , singapore , thailand and the philippines ) , east asia ( e.g. , china and japan ) , south asia ( e.g .
india and pakistan ) and oceanian ( e.g. , australia and fiji islands ) regions .
we estimate that the global cruise fleet was served by approximately 503000 berths on approximately 298 ships at the end of 2016 .
there are approximately 60 ships with an estimated 173000 berths that are expected to be placed in service in the global cruise market between 2017 and 2021 , although it is also possible that additional ships could be ordered or taken out of service during these periods .
we estimate that the global cruise industry carried 24.0 million cruise guests in 2016 compared to 23.0 million cruise guests carried in 2015 and 22.0 million cruise guests carried in .

Question: at the end of 2016 , what was the average number of berths per ship in the global cruise fleet?
Answer: 1687.92
Calculation: divide(503000, 298)
Year Ended December 31, 2018 Compared to Year Ended December 31, 2017
Revenue
Total revenue for the year ended December 31, 2018 increased by $58.9 million, or 28%, compared to the year ended December 31, 2017. Subscription
and returns revenue for the year ended December 31, 2018 increased by $54.1 million, or 27%, compared to the year ended December 31, 2017. Professional
services revenue for the year ended December 31, 2018 increased by $4.8 million, or 37%, compared to the year ended December 31, 2017. Growth in total
revenue was due primarily to increased demand for our products and services from both new and existing customers. Of the increase in total revenue for the year
ended December 31, 2018 compared to 2017, approximately $29.6 million was attributable to existing customers, approximately $28.3 million was attributable to
new customers, and approximately $1.1 million was due to interest income on funds held for customers. Total subscription and returns revenue for 2018 included
$1.2 million related to our cross-border transactions technology acquired in May 2018.
Table:
 | For the Year Ended December 31, |  | Change | 
 | 2018 | 2017 | Amount | Percentage
 |  | (dollars in thousands) |  | 
Revenue: |  |  |  | 
Subscription and returns | $254,056 | $199,942 | $54,114 | 27%
Professional services | 18,042 | 13,217 | 4,825 | 37%
Total revenue | $272,098 | $213,159 | $58,939 | 28%


Question: What is the total revenue earned in both 2017 and 2018?
Answer: 485257
Calculation: 272,098 + 213,159
Dividends are distributions of the Group’s profit after tax before significant items to its shareholders and represent one of the ways the Group distributes returns to its shareholders.
All dividends are fully franked at a 30% tax rate.
On 29 August 2019, the Board of Directors declared a final dividend in respect of the 2019 period of 57 cents per share, fully franked at a 30% tax rate. The amount will be paid on or around 30 September 2019 and is expected to be $717 million. As the dividend was declared subsequent to 30 June 2019, no provision had been made as at 30 June 2019.
The DRP remains active. Eligible shareholders may participate in the DRP in respect of all or part of their shareholding. There is currently no DRP discount applied and no limit on the number of shares that can participate in the DRP.
Shares will be allocated to shareholders under the DRP for the 2019 final dividend at an amount equal to the average of the daily volume weighted average market price of ordinary shares of the Company traded on the ASX over the period of 10 trading days commencing on 6 September 2019. The last date for receipt of election notices for the DRP is 5 September 2019. The Company may acquire shares on-market during this period to satisfy its obligations under the DRP.
During the period, 13.4% (2018: 39.9%) of the dividends paid were reinvested in shares of the Company. The change in the reinvestment participation rate reflects the removal of the discount with effect from the 2018 final dividend paid on 12 October 2018. The DRP in respect of the 2019 interim dividend was satisfied in full through the on-market purchase and transfer of $73 million of shares to participating shareholders.
Table:
 | 2019 |  |  |  | 2018 | 
 | CENTS PER | TOTAL | DATE OF | CENTS PER | TOTAL | DATE OF
 | SHARE | AMOUNT | PAYMENT | SHARE | AMOUNT | PAYMENT
 |  | $M |  |  | $M | 
Current year interim | 45 | 593 | 5 April 2019 | 43 | 561 | 6 April 2018
Prior year final | 50 | 657 | 12 October 2018 | 50 | 647 | 6 October 2017
Prior year special | 10 | 131 | 12 October 2018 | - | – | 
Dividends paid during the period | 105 | 1,381 |  | 93 | 1,208 | 
Issues of shares to satisfy the dividend |  |  |  |  |  | 
reinvestment plan |  | (114) |  |  | (482) | 
Dividends received - shares held in trust |  | - |  |  | (2) | 
Dividends paid in cash |  | 1,267 |  |  | 724 | 


Question: What is the average cents per share during the current year interim for 2018 and 2019?
Answer: 44
Calculation: (45 + 43)/2
Item 5. Market for Registrant’s Common Equity, Related Stockholder Matters and Issuer Purchases of Equity Securities
The Company’s common stock is traded on the NASDAQ Stock Market LLC (“NASDAQ”) under the symbol NTAP.
Price Range of Common Stock
The price range per share of common stock presented below represents the highest and lowest intraday sales prices for the Company’s common stock on the NASDAQ during each quarter of our two most recent fiscal years.
Holders
As of June 7, 2019 there were 413 holders of record of our common stock.
Table:
 |  | Fiscal 2019 |  | Fiscal 2018
 | High | Low | High | Low
First Quarter | $ 83.14 | $ 63.81 | $ 45.24 | $ 37.43
Second Quarter | $ 88.08 | $ 70.26 | $ 45.14 | $ 37.55
Third Quarter | $ 83.95 | $ 54.50 | $ 64.06 | $ 43.24
Fourth Quarter | $ 78.35 | $ 61.00 | $ 69.75 | $ 52.00


Question: In 2019, how many quarters did the high share price exceed $85.00?
Answer: 1
Calculation: Second Quarter
Contractual Obligations
Our contractual obligations as of August 31, 2019 are summarized below. As disclosed below, while we have certain non-cancelable purchase order obligations for property, plant and equipment, we generally do not enter into non-cancelable purchase orders for materials until we receive a corresponding purchase commitment from our customer. Non-cancelable purchase orders do not typically extend beyond the normal lead time of several weeks, at most. Purchase orders beyond this time frame are typically cancelable.
(1) Consists of interest on notes payable and long-term debt outstanding as of August 31, 2019. Certain of our notes payable and long-term debt pay interest at variable rates. We have applied estimated interest rates to determine the value of these expected future interest payments.
(2) Consists of purchase commitments entered into as of August 31, 2019 primarily for property, plant and equipment and software pursuant to legally enforceable and binding agreements.
(3) Includes the estimated company contributions to funded pension plans during fiscal year 2020 and the expected benefit payments for unfunded pension and postretirement plans from fiscal years 2020 through 2029. These future payments are not recorded on the Consolidated Balance Sheets but will be recorded as incurred.
(4) Includes (i) a $28.5 million capital commitment, (ii) a $16.2 million obligation related to a new human resource system and (iii) $33.0 million related to the one-time transition tax as a result of the Tax Act that will be paid in annual installments through fiscal year 2026.
(5) As of August 31, 2019, we have $1.5 million and $103.7 million recorded as a current and a long-term liability, respectively, for uncertain tax positions. We are not able to reasonably estimate the timing of payments, or the amount by which our liability for these uncertain tax positions will increase or decrease over time, and accordingly, this liability has been excluded from the above table.
Table:
 |  |  | Payments due by period (in thousands) |  | 
 | Total | Less than 1 year | 1-3 years | 3-5 years | After 5 years
Notes payable and long-term debt | $2,496,465 | $375,181 | $491,655 | $1,134,733 | $494,896
Future interest on notes payable and long-term debt(1) | 373,762 | 109,506 | 142,082 | 55,463 | 66,711
Operating lease obligations | 603,185 | 118,312 | 187,644 | 114,297 | 182,932
Capital lease obligations | 77,829 | 6,038 | 11,726 | 10,928 | 49,137
Non-cancelable purchase order obligations(2) | 351,230 | 289,516 | 61,537 | 177 | —
Pension and post retirement contributions and payments(3) | 14,618 | 1,135 | 1,904 | 2,396 | 9,183
Other(4) | 77,669 | 17,922 | 27,863 | 14,214 | 17,670
Total contractual obligations(5) | $3,994,758 | $917,610 | $924,411 | $1,332,208 | $820,529


Question: Which periods does the table provide information for total contractual obligations as of August 31, 2019?
Answer: Less than 1 year, 1-3 years, 3-5 years, After 5 years
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
NOTE 5 — Property, Plant and Equipment
Property, plant and equipment is comprised of the following:
Table:
 | As of December 31, | 
 | 2019 | 2018
Land and land improvements | $1,095 | $1,136
Buildings and improvements | 68,350 | 70,522
Machinery and equipment | 224,312 | 231,619
Less: Accumulated depreciation | (188,719) | (203,876)
Property, plant and equipment, net | $105,038 | $99,401


Question: How many years did the amount of Machinery and equipment exceed $200,000 thousand?
Answer: 2
Calculation: 2019##2018
NOTE 15. ACCRUED EXPENSES AND OTHER PAYABLES
Accrued expenses and other payables consist of the following:
Personnel-related items comprise accrued management bonuses, accrued vacation days, accrued wage tax, social securities and pension premiums. Deferred revenue consists of the revenue relating to the undelivered elements of the arrangements, see Note 21 for more information. This part of revenue is deferred at their relative selling prices until delivery of these elements. Other includes accruals for VAT, other taxes and invoices to be received for goods and services.
Table:
 | December 31, | 
 | 2018 | 2019
Personnel-related items | 32,636 | 45,318
Deferred revenue | 28,255 | 32,146
Financing related items | – | 3,912
Current portion of lease liabilities | – | 7,002
Advanced payments from customers | 25,382 | 47,601
Supplier related items | 1,828 | 2,175
Marketing related items | 1,049 | 1,365
R&D projects | 1,209 | 1,109
Other | 8,634 | 9,215
Total accrued expenses and other payables | 98,993 | 149,843


Question: What is the component that contributes the most to total accrued expenses and other payables?
Answer: Advanced payments from customers
Calculation: For COL4 row 3 to 11 find the largest number and the corresponding component in COL2
Assumptions
Weighted-average actuarial assumptions used to determine net periodic benefit cost and projected benefit obligation for the plans for the fiscal years 2019, 2018 and 2017 were as follows:
(1) The expected return on plan assets assumption used in calculating net periodic benefit cost is based on historical return experience and estimates of future long-term performance with consideration to the expected investment mix of the plan.
(2) The discount rate is used to state expected cash flows relating to future benefits at a present value on the measurement date. This rate represents the market rate for high-quality fixed income investments whose timing would match the cash outflow of retirement benefits. Other assumptions include demographic factors such as retirement, mortality and turnover.
Table:
 |  | Pension | 
 | 2019 | 2018 | 2017
Net periodic benefit cost: |  |  | 
Expected long-term return on plan assets(1) | 3.6% | 3.8% | 3.3%
Rate of compensation increase | 4.4% | 3.3% | 2.7%
Discount rate | 2.2% | 2.1% | 1.9%
Projected benefit obligation: |  |  | 
Expected long-term return on plan assets | 2.0% | 3.6% | 4.0%
Rate of compensation increase | 4.3% | 4.4% | 4.4%
Discount rate(2) | 1.7% | 2.2% | 2.3%


Question: What was the rate of compensation increase in 2019?
Answer: 4.3%
The following table lists customers from which the Company derived revenues in excess of 10% of total revenues for the years ended years ended September 30, 2019 and 2018
In addition, accounts receivable from Customer A totaled approximately $0.3 million, or 1%, and approximately $1.1 million, or 9%, of total consolidated accounts receivable as of September 30, 2019 and September 30, 2018, respectively. Accounts receivable and long term receivable from Customer B totaled approximately $7.4 million, or 36%, and approximately $0.2 million, or 2%, of total consolidated accounts receivable as of September 30, 2019 and September 30, 2018, respectively. We believe that the Company is not exposed to any significant credit risk with respect to the accounts receivable with these customers as of September 30, 2019. No other customers accounted for 10% or more of total consolidated accounts receivable as
of September 30, 2019.
Table:
 |  | For the years ended |  | 
 | September 30, 2019 |  | September 30, 2018 | 
 | Amount | % of Revenue | Amount | % of Revenue
 |  | (Amounts in millions) |  | 
Customer A | $3.8 | 5% | $7.5 | 10%
Customer B | $10.2 | 13% | 1.1 | 3%


Question: What is the difference in revenue earned from customer A and customer B in 2019?
Answer: 6.4
Calculation: 10.2 - 3.8
other items on our consolidated financial statements have been appropriately adjusted from the amounts provided in the earnings release , including a reduction of our full year 2016 gross profit and income from operations by $ 2.9 million , and a reduction of net income by $ 1.7 million. .

Table:
( in thousands ) | at december 31 , 2016 | at december 31 , 2015 | at december 31 , 2014 | at december 31 , 2013 | at december 31 , 2012
cash and cash equivalents | $ 250470 | $ 129852 | $ 593175 | $ 347489 | $ 341841
working capital ( 1 ) | 1279337 | 1019953 | 1127772 | 702181 | 651370
inventories | 917491 | 783031 | 536714 | 469006 | 319286
total assets | 3644331 | 2865970 | 2092428 | 1576369 | 1155052
total debt including current maturities | 817388 | 666070 | 281546 | 151551 | 59858
total stockholders 2019 equity | $ 2030900 | $ 1668222 | $ 1350300 | $ 1053354 | $ 816922
( 1 ) working capital is defined as current assets minus current liabilities. .

Question: what was the percentage change in inventories from 2015 to 2016?
Answer: 17%
Calculation: subtract(917491, 783031), divide(#0, 783031)
item 4 . mine safety disclosures not applicable part ii item 5 . market for registrant 2019s common equity , related stockholder matters , and issuer purchases of equity securities our common stock ( ticker symbol apd ) is listed on the new york stock exchange . our transfer agent and registrar is broadridge corporate issuer solutions , inc. , p.o . box 1342 , brentwood , new york 11717 , telephone ( 844 ) 318-0129 ( u.s. ) or ( 720 ) 358-3595 ( all other locations ) ; website , http://shareholder.broadridge.com/ airproducts ; and e-mail address , shareholder@broadridge.com . as of 31 october 2018 , there were 5391 record holders of our common stock . cash dividends on the company 2019s common stock are paid quarterly . it is our expectation that we will continue to pay cash dividends in the future at comparable or increased levels . the board of directors determines whether to declare dividends and the timing and amount based on financial condition and other factors it deems relevant . dividend information for each quarter of fiscal years 2018 and 2017 is summarized below: .

Table:
 | 2018 | 2017
first quarter | $ .95 | $ .86
second quarter | 1.10 | .95
third quarter | 1.10 | .95
fourth quarter | 1.10 | .95
total | $ 4.25 | $ 3.71
purchases of equity securities by the issuer on 15 september 2011 , the board of directors authorized the repurchase of up to $ 1.0 billion of our outstanding common stock .
this program does not have a stated expiration date .
we repurchase shares pursuant to rules 10b5-1 and 10b-18 under the securities exchange act of 1934 , as amended , through repurchase agreements established with one or more brokers .
there were no purchases of stock during fiscal year 2018 .
at 30 september 2018 , $ 485.3 million in share repurchase authorization remained .
additional purchases will be completed at the company 2019s discretion while maintaining sufficient funds for investing in its businesses and growth opportunities. .

Question: what is the increase observed in the payment of dividends during 2017 and 2018?
Answer: 14.55%
Calculation: divide(4.25, 3.71), subtract(#0, const_1)
The accumulated benefit obligation for the United States defined benefit pension plans was $198.2 million and $172.8 million at December 31, 2019 and 2018, respectively. The accumulated benefit obligation for foreign defined benefit pension plans was $39.9 million and $35.6 million at December 31, 2019 and 2018, respectively.
Information for pension plans with an accumulated benefit obligation in excess of plan assets as of December 31:
Table:
 | 2019 |  | 2018 | 
 | United States | Foreign | United States | Foreign
 |  | (in millions) |  | 
Projected benefit obligation | $55.3 | $44.0 | $50.8 | $39.1
Accumulated benefit obligation | 53.2 | 39.9 | 48.6 | 35.6
Fair value of plan assets | — | 1.6 | — | 1.4


Question: In which years is information of the accumulated benefit obligation provided?
Answer: 2019, 2018
(1) Mr. Clark did not receive a FY19 EAIP payout.
(2) Pursuant to the terms of Mr. Noviello’s Transition Services Agreement dated January 31, 2019 (the ‘‘Transition Services Agreement’’), Mr. Noviello received 75% of his target FY19 EAIP amount under the Company’s Executive Severance Plan because it was greater than the amount that he would have earned under the FY19 EAIP irrespective of individual performance.
(3) Ms. Cappellanti-Wolf and Messrs. Kapuria and Taylor each earned an individual performance factor of 100%. In determining the appropriate individual performance factor for each of these executives, the Compensation Committee, with recommendation of the CEO, considered leadership, contributions to NortonLifeLock’s achievement of its goals, and strategic planning among other factors.
(4) The Compensation Committee did not exercise its discretion to reduce any payouts.
Table:
 | FY19 EAIP NEO Payout Amounts |  |  |  | 
NEO | Base Salary | Annual Incentive Target (%) | Company Performance Funding (%) | Individual Performance Factor (%) | Individual Payout Amount ($)(4)
Gregory S. Clark(1) | 1,000,000 | 150 | n/a | n/a | 0
Nicholas R. Noviello(2) | 650,000 | 100 | n/a | n/a | 487,500
Amy L. Cappellanti-Wolf(3) | 440,000 | 70 | 35.6 | 100 | 109,648
Samir Kapuria(3) | 450,000 | 100 | 35.6 | 100 | 152,172
Scott C. Taylor(3) | 600,000 | 100 | 35.6 | 100 | 213,600


Question: What is the average FY19 individual payout amount?
Answer: 192584
Calculation: (0+487,500+109,648+152,172+213,600)/5
NOTE 21—EARNINGS PER SHARE
Basic earnings per share are computed by dividing net income, attributable to OpenText, by the weighted average number of Common Shares outstanding during the period. Diluted earnings per share are computed by dividing net income, attributable to OpenText, by the shares used in the calculation of basic earnings per share plus the dilutive effect of Common Share equivalents, such as stock options, using the treasury stock method. Common Share equivalents are excluded from the computation of diluted earnings per share if their effect is anti-dilutive.
(1) Please also see note 14 "Income Taxes" for details relating to a one-time tax benefit of $876.1 million recorded during the three months ended September 30, 2016 in connection with an internal reorganization of our subsidiaries.
(2) Represents options to purchase Common Shares excluded from the calculation of diluted earnings per share because the exercise price of the stock options was greater than or equal to the average price of the Common Shares during the period.
Table:
 |  | Year Ended June 30, | 
 | 2019 | 2018 | 2017
Basic earnings per share |  |  | 
Net income attributable to OpenText | $285,501 | $242,224 | $1,025,659(1)
Basic earnings per share attributable to OpenText | $1.06 | $0.91 | $4.04
Diluted earnings per share |  |  | 
Net income attributable to OpenText | $285,501 | $242,224 | $1,025,659(1)
Diluted earnings per share attributable to OpenText | $1.06 | $0.91 | $4.01
Weighted-average number of shares outstanding (in 000's) |  |  | 
Basic | 268,784 | 266,085 | 253,879
Effect of dilutive securities | 1,124 | 1,407 | 1,926
Diluted | 269,908 | 267,492 | 255,805
Excluded as anti-dilutive(2) | 2,759 | 2,770 | 1,371


Question: What is the average annual Basic earnings per share attributable to OpenText? 
Answer: 2
Calculation: (1.06+0.91+4.04)/3
10.2. Assets held for sale
On 21 December 2018, the Group entered into an agreement for the divestment of a component of freehold investment property in Melbourne, Victoria for $1m. This has been included within fair value adjustments in the statement of profit or loss. This transaction settled on 15 January 2019.
On 28 June 2019, the Group entered into an agreement for the sale of commercial investment property in Dunedin, New Zealand for NZD $1.3m less cost of sale of NZD $0.1m (AUD $1.2m less cost of sale of $0.1m). This has resulted in an unrealised gain of NZD $1.2m (AUD $1.1m) on the asset’s carrying value. This has been included within fair value adjustments in the statement of profit or loss.
As at 1 July 2018, the Group held a contractual agreement for the sale of the land and buildings of the Croydon self-storage centre for $5.8m, less cost of sale of $0.1m. This resulted in this asset being classified as held for sale. Due to unforeseen circumstances outside of the Group’s control this transaction did not proceed. At 30 June 2019 the asset has been classified as freehold investment property and is no longer held for sale.
Table:
 |  | 2019 | 2018
 | Notes | $'000 | $'000
Current assets |  |  | 
Opening balance at 1 July |  | 5,713 | 5,713
Item reclassified from freehold investment property | 10.4 | 2,068 | 4,400
Item reclassified to freehold investment property | 10.4 | (5,713) | 
Disposals during the year |  | (961) | (4,400)
Total assets held for sale |  | 1,107 | 5,713


Question: Which agreement was entered by the group on 28 June 2019?
Answer: agreement for the sale of commercial investment property in Dunedin, New Zealand for NZD $1.3m less cost of sale of NZD $0.1m (AUD $1.2m less cost of sale of $0.1m).