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


Question: What was the Net investment hedge in 2019 and 2018 respectively?
Answer: (1,591), 1,007
Employee Stock Purchase Plan
The weighted average estimated fair value, as defined by the amended authoritative guidance, of rights issued pursuant to the Company’s ESPP during 2019, 2018 and 2017 was $4.28, $5.18 and $6.02, respectively. Sales under the ESPP were 24,131 shares of common stock at an average price per share of $9.76 for 2019, 31,306 shares of common stock at an average price per share of $15.40 for 2018, and 38,449 shares of common stock at an average price per share of $12.04 for 2017.
As of December 29, 2019, 62,335 shares under the 2009 ESPP remained available for issuance. The Company recorded compensation expenses related to the ESPP of $60,000, $205,000 and $153,000 in 2019, 2018 and 2017, respectively.
The fair value of rights issued pursuant to the Company’s ESPP was estimated on the commencement date of each offering period using the following weighted average assumptions:
The methodologies for determining the above values were as follows:
• Expected term: The expected term represents the length of the purchase period contained in the ESPP.
• Risk-free interest rate: The risk-free interest rate assumption is based upon the risk-free rate of a Treasury Constant Maturity bond with a maturity appropriate for the term of the purchase period.
• Volatility: The Company determines expected volatility based on historical volatility of the Company’s common stock for the term of the purchase period.
• Dividend Yield: The expected dividend assumption is based on the Company’s intent not to issue a dividend under its dividend policy.
Table:
 | Fiscal Years |  | 
 | 2019 | 2018 | 2017
Expected life (months) | 6.0 | 6.0 | 6.1
Risk-free interest rate | 2.37% | 2.26% | 1.22%
Volatility | 54% | 50% | 53%


Question: What are the respective weighted average estimated fair value of the company's ESPP during 2019 and 2018?
Answer: $4.28, $5.18
9. Debt
Silicon Valley Bank Facility
We maintained a Loan and Security Agreement with SVB (the "Credit Facility") under which we had a term loan with an original borrowing amount of $6.0 million (the “Original Term Loan”). The Original Term Loan carried a floating annual interest rate equal to SVB’s prime rate then in effect plus 2%. The Original Term Loan matured and was repaid in May 2019.
On October 10, 2019, we entered into an Amended and Restated Loan and Security Agreement (the “Loan Agreement”) with SVB, which amended and restated in its entirety our previous Credit Facility. Under the Loan Agreement, SVB agreed to make advances available up to $10.0 million (the “Revolving Line”). If we borrow from the Revolving Line, such borrowing would carry a floating annual interest rate equal to the greater of (i) the Prime Rate (as defined in the Loan Agreement) then in effect plus 1% or (ii) 6%. Amounts borrowed under the Revolving Line may be repaid and, prior to the Revolving Line Maturity Date (defined below), reborrowed. The Revolving Line terminates on October 10, 2020 (the “Revolving Line Maturity Date”), unless earlier terminated by us. No amounts have been borrowed under this Loan Agreement.
Amounts due under the Loan Agreement are secured by our assets, including all personal property, inventory and bank accounts; however, intellectual property is not secured under the Loan Agreement. The inventory used to secure the amount due does not include demo or loaner equipment with an aggregate book value up to $1.0 million. The Loan Agreement requires us to observe a number of financial and operational covenants, including maintenance of a specified Liquidity Coverage Ratio (as defined in the Loan Agreement), protection and registration of intellectual property rights and customary negative covenants. If any event of default occurs SVB may declare due immediately all borrowings under the Credit Facility and foreclose on the collateral. Furthermore, an event of default under the Credit Facility would result in an increase in the interest rate on any amounts outstanding. As of December 31, 2019, there were no events of default on the Credit Facility.
Interest expense, net for the years ended December 31, 2019 and 2018 consisted of the following:
Table:
 | Years ended December 31, | 
 | 2019 | 2018
Interest expense on Term Loans | $8,073 | $101,087
Amortization of debt issuance costs | 5,685 | 16,308
Other interest expense  | 2,120 | 6,949
Total interest expense, net | $15,878 | $124,344


Question: What is the change in Interest expense on Term Loans between December 31, 2018 and 2019?
Answer: -93014
Calculation: 8,073-101,087
purchases of equity securities 2013 during 2018 , we repurchased 57669746 shares of our common stock at an average price of $ 143.70 . the following table presents common stock repurchases during each month for the fourth quarter of 2018 : period total number of shares purchased [a] average price paid per share total number of shares purchased as part of a publicly announced plan or program [b] maximum number of shares remaining under the plan or program [b] .

Table:
period | total number of shares purchased [a] | average price paid per share | total number of shares purchased as part of a publicly announcedplan or program [b] | maximum number of shares remaining under the plan or program [b]
oct . 1 through oct . 31 | 6091605 | $ 158.20 | 6087727 | 32831024
nov . 1 through nov . 30 | 3408467 | 147.91 | 3402190 | 29428834
dec . 1 through dec . 31 | 3007951 | 148.40 | 3000715 | 26428119
total | 12508023 | $ 153.04 | 12490632 | n/a
[a] total number of shares purchased during the quarter includes approximately 17391 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] effective january 1 , 2017 , our board of directors authorized the repurchase of up to 120 million shares of our common stock by december 31 , 2020 .
these repurchases may be made 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 where purchased in november?
Answer: 27%
Calculation: divide(3408467, 12508023)
Share-Based Payment Expense
The expense recognised for employee services received during the year is as follows:
The cash-settled expense comprises cash-based awards together with certain social security taxes. The carrying value of the liability as at 31 March 2019 was $1.6M (2018: $3.1M).
Table:
 | Year-ended 31 March 2019 | Year-ended 31 March 2018
 | $M | $M
Cash-settled transactions | 1.9 | 2.7
Equity-settled transactions | 35.0 | 39.6
Total share-based payment expense | 36.9 | 42.3


Question: What was the percentage change in Cash-settled transactions in 2019 from 2018?
Answer: -29.63
Calculation: (1.9-2.7)/2.7
Item 6. Selected Financial Data
The following table summarizes our selected consolidated financial data for the periods indicated. The selected consolidated financial data should be read in conjunction with our Consolidated Financial Statements and related notes and “Management's Discussion and Analysis of Financial Condition and Results of Operations” appearing elsewhere in this Annual Report on Form 10-K. The selected consolidated statement of income and balance sheet data for each of the five fiscal years indicated below has been derived from our audited Consolidated Financial Statements. Over the last five fiscal years we have acquired a number of companies including, but not limited to Catalyst, Liaison, Hightail, Guidance, Covisint, ECD Business, CCM Business, Recommind, ANX, CEM Business, Daegis, and Actuate. The results of these companies and all of our previously acquired companies have been included herein and have contributed to the growth in our revenues, net income and net income per share and such acquisitions affect period-to-period comparability.
(1) Effective July 1, 2018, we adopted Accounting Standards Codification (ASC) Topic 606 "Revenue from Contracts with Customers" (Topic 606) using the cumulative effect approach. We applied the standard to contracts that were not completed as of the date of the initial adoption. Results for reporting periods commencing on July 1, 2018 are presented under the new revenue standard, while prior period results continue to be reported under the previous standard.
(2) Fiscal 2017 included a significant one-time tax benefit of $876.1 million recorded in the first quarter of Fiscal 2017.
Table:
 |  |  | Fiscal Year Ended June 30, |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
(In thousands, except per share data) |  |  |  |  | 
Statement of Income Data: |  |  |  |  | 
Revenues(1) | $2,868,755 | $2,815,241 | $2,291,057 | $1,824,228 | $1,851,917
Net income, attributable to OpenText(2) | $285,501 | $242,224 | $1,025,659 | $284,477 | $234,327
Net income per share, basic, attributable to OpenText(1) | $1.06 | $0.91 | $4.04 | $1.17 | $0.96
Net income per share, diluted, attributable to OpenText(1) | $1.06 | $0.91 | $4.01 | $1.17 | $0.95
Weighted average number of Common Shares outstanding, basic | 268,784 | 266,085 | 253,879 | 242,926 | 244,184
Weighted average number of Common Shares outstanding, diluted | 269,908 | 267,492 | 255,805 | 244,076 | 245,914


Question: What units are used in this table?
Answer: In thousands, except per share data
NOTE 6 – OTHER LIABILITIES
As described in Note 4, the Company and Finjan Blue entered into a Patent Assignment Agreement with IBM.The components of other liabilities are as presented below:
Table:
As of December 31, |  | 
 | 2019 | 2018
 | (In thousands) | 
Other liabilities, current | $2,000 | $1,500
Other liabilities, non-current | 1,799 | 3,463
 | $3,799 | $4,963


Question: What are the respective values of other current liabilities in 2019 and 2018?
Answer: $2,000, $1,500
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 , 2012 in the standard & poor 2019s 500 index , the dow jones transportation average and our class b common stock. .

Table:
 | 12/31/2012 | 12/31/2013 | 12/31/2014 | 12/31/2015 | 12/31/2016 | 12/31/2017
united parcel service inc . | $ 100.00 | $ 146.54 | $ 159.23 | $ 148.89 | $ 182.70 | $ 195.75
standard & poor 2019s 500 index | $ 100.00 | $ 132.38 | $ 150.49 | $ 152.55 | $ 170.79 | $ 208.06
dow jones transportation average | $ 100.00 | $ 141.38 | $ 176.83 | $ 147.19 | $ 179.37 | $ 213.49
.

Question: what is the difference in percentage cumulative total shareowners return for united parcel service inc . versus the dow jones transportation average for the five years ended 12/31/2017?
Answer: -17.74%
Calculation: subtract(195.75, const_100), divide(#0, const_100), subtract(213.49, const_100), divide(#2, const_100), subtract(#1, #3)
At the balance sheet date, the combined principal accounting assumptions were as follows:
For the smaller overseas schemes the discount rate used was 1.50% (2017/18: 1.80%) and future pension increases were 1.30% (2017/18: 1.45%).
At 30 March 2019 and 31 March 2018, the discount rate was derived based on a bond yield curve expanded to also include bonds rated AA by one credit agency (and which might for example be rated A or AAA by other agencies).
Table:
 | At 30 Mar 2019 |  | At 31 Mar 2018 | 
 | Premier schemes | RHM schemes | Premier schemes | RHM schemes
Discount rate | 2.45% | 2.45% | 2.70% | 2.70%
Inflation – RPI | 3.25% | 3.25% | 3.15% | 3.15%
Inflation – CPI | 2.15% | 2.15% | 2.05% | 2.05%
Expected salary increases | n/a | n/a | n/a | n/a
Future pension increases | 2.10% | 2.10% | 2.10% | 2.10%


Question: What is the change in the premier schemes discount rate from 2018 to 2019?
Answer: -0.25
Calculation: 2.45% - 2.70%
Stock Repurchase Program
As of April 26, 2019, our Board of Directors has authorized the repurchase of up to $13.6 billion of our common stock under our stock repurchase program . Under this program, which we may suspend or discontinue at any time, we may purchase shares of our outstanding common stock through solicited or unsolicited transactions in the open market, in privately negotiated transactions, through accelerated share repurchase programs, pursuant to a Rule 10b5-1 plan or in such other manner as deemed appropriate by our management.
The following table summarizes activity related to this program (in millions, except per share amounts):
The aggregate purchase price of our stock repurchases for fiscal 2019 consisted of $2.1 billion of open market purchases of which $1.0 billion and $1.1 billion were allocated to additional paid-in capital and retained earnings (accumulated deficit), respectively.
Since the May 13, 2003 inception of our stock repurchase program through April 26, 2019, we repurchased a total of 313 million shares of our common stock at an average price of $37.46 per share, for an aggregate purchase price of $11.7 billion.
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
Number of shares repurchased | 29 | 15 | 22
Average price per share | $ 72.87 | $ 51.57 | $ 32.72
Aggregate purchase price | $ 2,111 | $ 794 | $ 705
Remaining authorization at end of period | $ 1,889 | $ 4,000 | $ 794


Question: What was the change in the average price per share between 2017 and 2018?
Answer: 18.85
Calculation: 51.57-32.72
Options outstanding that are exercisable and that have vested and are expected to vest as of January 31, 2020 were as follows (outstanding options in thousands, aggregate intrinsic value in in millions):
(1) The aggregate intrinsic values represent the total pre-tax intrinsic values based on VMware's closing stock price of $148.06 as of January 31, 2020, which would have been received by the option holders had all in-the-money options been exercised as of that date.
The total fair value of VMware stock options that vested during the years ended January 31, 2020, February 1, 2019 and February 2, 2018 was $64 million, $35 million and $32 million, respectively. Total fair value of Pivotal stock options that vested during the years ended January 31, 2020, February 1, 2019 and February 2, 2018 was $27 million, $41 million and $23 million, respectively.
The VMware stock options exercised during the years ended January 31, 2020, February 1, 2019 and February 2, 2018 had a pre-tax intrinsic value of $103 million, $56 million, and $62 million, respectively. The Pivotal options exercised during the years ended January 31, 2020 and February 1, 2019 had a pre-tax intrinsic value of $278 million and $97 million, respectively, and was not material during the year ended February 2, 2018. The pre-tax intrinsic value of Pivotal options exercised during the year ended January 31, 2020 includes vested options that were settled in cash as part of the Pivotal acquisition.
Table:
 |  | VMware Stock Options |  | 
 | Outstanding Options | Exercise Price | Weighted- Average Remaining Contractual Term (in years) | Aggregate Intrinsic Value(1)
Exercisable | 945 | $47.24 | 3.81 | $95
Vested and expected to vest | 2,589 | 56.13 | 6.41 | 238


Question: What was the aggregate intrinsic value that was vested and expected to vest?
Answer: 238
NOTE 15 — LEASES
We have operating and finance leases for datacenters, corporate offices, research and development facilities, retail stores, and certain equipment. Our leases have remaining lease terms of 1 year to 20 years, some of which include options to extend the leases for up to 5 years, and some of which include options to terminate the leases within 1 year.
The components of lease expense were as follows:
Table:
(In millions) |  |  | 
Year Ended June 30, | 2019 | 2018 | 2017
Operating lease cost | $  1,707 | $  1,585 | $  1,412
Finance lease cost: |  |  | 
Amortization of right-of-use assets | $ 370 | $ 243 | $ 104
Interest on lease liabilities | 247 | 175 | 68
Total finance lease cost | $617 | $418 | $172


Question: How long are the remaining lease terms for?
Answer: Our leases have remaining lease terms of 1 year to 20 years,
Sales and Marketing Expenses
Sales and marketing expenses increased $105 million, or 36%, in 2019 compared to 2018. The overall increase was primarily due to increased employee compensation-related costs, including
amortization of capitalized commissions, of $72 million, driven by headcount growth, and an increase in marketing program costs of $8 million. The increase in marketing program costs was driven by increased volume of advertising activities. Further contributing to the overall increase was an increase in allocated shared costs of $14 million.
Sales and marketing expenses increased $80 million, or 38%, in 2018 compared to 2017. The overall increase was primarily due to increased employee compensation-related costs, including amortization of capitalized commissions, of $55 million, driven by headcount growth, and an increase in marketing program costs of $10 million. The increase in marketing program costs was driven by increased volume of advertising activities. Further contributing to the overall increase was an increase in allocated shared costs of $11 million.
Table:
 |  | Year Ended December 31, |  |  | 
 | 2019 | 2018 | 2017 | 2018 to 2019 % change | 2017 to 2018 % change
 |  |  | (In thousands, except percentages) |  | 
Sales and Marketing | $ 396,514 | $ 291,668 | $ 211,918 | 36% | 38%


Question: What was the increase in sales and marketing expenses from 2017 to 2019?
Answer: 185
Calculation: 80 + 105
Unrecognized Tax Benefits
Activity related to unrecognized tax benefits is as follows (in thousands):
During the year ended July 31, 2019, the Company’s unrecognized tax benefits increased by $1.3 million, primarily associated with the Company’s U.S. Federal and California R&D credits. As of July 31, 2019, the Company had unrecognized tax benefits of $6.2 million that, if recognized, would affect the Company’s effective tax rate. An estimate of the range of possible change within the next 12 months cannot be made at this time.
The Company, or one of its subsidiaries, files income taxes in the U.S. Federal jurisdiction and various state and foreign jurisdictions. If the Company utilizes net operating losses or tax credits in future years, the U.S. Federal, state and local, and non-U.S. tax authorities may examine the tax returns covering the period in which the net operating losses and tax credits arose. As a result, the Company’s tax returns in the U.S. and California remain open to examination from fiscal years 2002 through 2019. As of July 31, 2019, the Company has no income tax audits in progress in the U.S. or foreign jurisdictions.
Table:
 |  | Fiscal years ended July 31, | 
 | 2019 | 2018 | 2017
Unrecognized tax benefit - beginning of period | $10,321 | $9,346 | $7,687
Gross increases - prior period tax positions | 98 | 729 | 712
Gross decreases - prior period tax positions | (88) | (878) | (691)
Gross increases - current period tax positions | 1,302 | 1,124 | 1,638
Unrecognized tax benefit - end of period | $11,633 | $10,321 | $9,346


Question: In which year was Unrecognized tax benefit - end of period less than 10,000 thousands?
Answer: 2017
Calculation: locate and analyze Unrecognized tax benefit - beginning of period in row 3