hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Liquidity and Capital Resources
As of December 31, 2019 and 2018, we had cash and cash equivalents of $343.6 million and $566.3 million, respectively. We finance our operations primarily through sales to our customers and a majority of our customers are billed monthly. For customers with annual or multi-year contracts and those who opt for annual invoicing, we generally invoice only one annual period in advance and all invoicing occurs at the start of the respective subscription period. Revenue is deferred for such advanced billings. We also finance our operations from proceeds from issuance of stock under our stock plans, and proceeds from issuance of debt. We believe that our operations and existing liquidity sources will satisfy our cash requirements for at least the next 12 months
Our future capital requirements will depend on many factors, including revenue growth and costs incurred to support customer growth, acquisitions and expansions, sales and marketing, research and development, increased general and administrative expenses to support the anticipated growth in our operations, and capital equipment required to support our growing headcount and in support of our co-location data center facilities. Our capital expenditures in future periods are expected to grow in line with our business. We continually evaluate our capital needs and may decide to raise additional capital to fund the growth of our business, to further strengthen our balance sheet, or for general corporate purposes through public or private equity offerings or through additional debt financing. We also may in the future make investments in or acquire businesses or technologies that could require us to seek additional equity or debt financing. Access to additional capital may not be available, or on favorable terms
The table below provides selected cash flow information for the periods indicated (in thousands)
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Net cash provided by operating activities | $64,846 | $72,130 | $41,165
Net cash used in investing activities | (296,780) | (83,448) | (26,387)
Net cash provided by financing activities | 9,042 | 397,255 | 6,783
Effect of exchange rate changes | 169 | (800) | (724)
Net (decrease) increase in cash, cash equivalents, and restricted cash | $(222,723) | 385,137 | 20,837


Question: What is the total net cash provided by financing activities between 2017 to 2019?
Answer: 413080
Calculation: 6,783 + 397,255 + 9,042
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 percent of share repurchases took place in the fourth quarter?
Answer: 21.7%
Calculation: divide(12508023, 57669746)
Results of Operations: Year Ended December 31, 2019, versus Year Ended December 31, 2018 (Amounts in thousands, except percentages and per share amounts):
Other income and expense items are summarized in the following table:
Interest expense increased mainly as a result of an increase in debt related to the QTI acquisition. Other expense in 2019 was principally driven by foreign currency translation losses, mainly due to the appreciation of the U.S. Dollar compared to the Chinese Renminbi and Euro, as well as an increase in pension expense.
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Interest expense | $(2,648) | $(2,085)
Interest income | 1,737 | 1,826
Other (expense) income | (2,638) | (2,676)
Total other (expense) income, net | $(3,549) | $(2,935)


Question: What was the percentage change in interest income between 2018 and 2019?
Answer: -4.87
Calculation: (1,737-1,826)/1,826
Stock-based Compensation Expense
The income tax benefit related to share-based compensation was $66 million, $158 million and $97 million for 2019, 2018 and 2017, respectively. The income tax benefits related to share-based compensation for the periods presented prior to the second quarter of 2018 were offset by an increase in the U.S. valuation allowance. Stock-based compensation expense of $30 million and $19 million was capitalized and remained in inventory as of August 29, 2019 and August 30, 2018, respectively. As of August 29, 2019, $439 million of total unrecognized compensation costs for unvested awards, before the effect of any future forfeitures, was expected to be recognized through the fourth quarter of 2023, resulting in a weighted-average period of 1.3 years.
Table:
For the year ended | 2019 | 2018 | 2017
Stock-based compensation expense by caption |  |  | 
Cost of goods sold | $102 | $83 | $88
Selling, general, and administrative | 73 | 61 | 75
Research and development | 68 | 54 | 52
 | $243 | $198 | $215
Stock-based compensation expense by type of award |  |  | 
Restricted stock awards | $178 | $140 | $144
Stock options | 33 | 55 | 71
ESPP | 32 | 3 | —
 | $243 | $198 | $215


Question: What was the stock-based compensation expense of ESPP by type of reward in 2019?
Answer: 32
7. Balance Sheet Details
Cash, cash equivalents, and restricted cash consist of the following:
As of December 31, 2019 and December 31, 2018, cash and cash equivalents included $20.4 million and $0 of money market funds, respectively. As of December 31, 2019 and 2018, the Company has restricted cash of $0.4 million and $1.0 million, respectively. The cash is restricted in connection with guarantees for certain import duties and office leases.
Table:
 | December 31, 2019 | December 31, 2018
(in thousands) |  | 
Cash and cash equivalents | $92,708 | $73,142
Short-term restricted cash | 349 | 645
Long-term restricted cash | 60 | 404
Total cash, cash equivalents and restricted cash | $93,117 | $74,191


Question: In which year was Long-term restricted cash less than 100 thousands?
Answer: 2019
Calculation: locate and analyze long-term restricted cash in row 5
ACQUISITIONS OF PROPERTY, PLANT AND EQUIPMENT
The acquisitions of property, plant and equipment as well as the capital intensity per operating segment are as follows:
(1) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy. For further details, please consult the "Accounting policies" section. (2) Fiscal 2019 actuals are translated at the average foreign exchange rate of the comparable period of fiscal 2018 which was 1.3100 USD/CDN.
Fiscal 2019 fourth-quarter acquisitions of property, plant and equipment decreased by 10.6% (11.2% in constant currency) mainly due to lower capital expenditures in the Canadian and American broadband services segments. Fiscal 2019 fourth-quarter capital intensity reached 24.9% compared to 28.7% for the same period of the prior year mainly as a result of lower capital capital expenditures combined with higher revenue.
Table:
Three months ended August 31, | 2019 | 2018 | Change | Change in constant currency(2)
(in thousands of dollars, except percentages) | $ | $ | % | %
Canadian broadband services | 79,132 | 89,405 | (11.5) | (11.7)
Capital intensity | 24.7% | 28.0% |  | 
American broadband services | 65,967 | 72,914 | (9.5) | (10.5)
Capital intensity | 25.0% | 29.6% |  | 
Consolidated | 145,099 | 162,319 | (10.6) | (11.2)
Capital intensity | 24.9% | 28.7% |  | 


Question: What is the increase/ (decrease) Consolidated from 2018 to 2019?
Answer: -17220
Calculation: 145,099-162,319
Net Income (Loss) Per Share
The Company calculates net income (loss) per share in accordance with FASB ASC Topic 260,Earnings per Share. Basic net income (loss) per share is based on the weighted-average number of common shares outstanding during the period. Diluted net income (loss) per share also gives effect to all potentially dilutive securities outstanding during the period, such as restricted stock units (“RSUs”), stock options, and Employee Stock Purchase Plan ("ESPP") shares, if dilutive. In a period with a net loss position, potentially dilutive securities are not included in the computation of diluted net loss because to do so would be antidilutive, and the number of shares used to calculate basic and diluted net loss is the same.
For the fiscal years ended September 30, 2019, 2018 and 2017, the following potentially dilutive common shares were excluded from the net income (loss)
per share calculation, as they would have been antidilutive (amounts in thousands):
Table:
 | 2019 | 2018 | 2017
Stock options | 1,687 | 2,806 | 569
RSUs | 2,352 | 2,580 | 83
ESPP common stock equivalents | 74 | 71 | —
ID Checker earnout shares | — | — | 24
Total potentially dilutive common shares outstanding | 4,113 | 5,457 | 676


Question: What is basic net income (loss) per share based on?
Answer: the weighted-average number of common shares outstanding during the period
Contractual Obligations
We have various contractual obligations impacting our liquidity. The following represents our contractual obligations as of January 31, 2020 (table in millions)
(1) Consists of principal and interest payments on the Senior Notes. Refer to “Liquidity and Capital Resources” for a discussion of the public debt offering we issued on August 21, 2017 in the aggregate principal amount of $4.0 billion.
(2) Consists of principal and interest payments on the outstanding note payable to Dell. Refer to “Liquidity and Capital Resources” for a discussion of the $270 million note payable we entered into with Dell per the note exchange agreement from January 21, 2014.
(3) Consists of the principal on the senior unsecured term loan facility (the “Term Loan”). The Term Loan can be repaid any time before October 2020. Given the variable nature of the interest on the Term Loan, including when the repayment will take place, interest payments have been excluded from the table above.
(4) Consists of both operating and finance leases. Our operating leases are primarily for facility space and land. Amounts in the table above exclude legally binding minimum lease payments for leases signed but not yet commenced of $361 million, as well as expected sublease income.
(5) Consists of future cash payments related to the Transition Tax.
(6) As of January 31, 2020, we had $479 million of gross uncertain tax benefits, excluding interest and penalties. The timing of future payments relating to these obligations is highly uncertain. Based on the timing and outcome of examinations of our subsidiaries, the result of the expiration of statutes of limitations for specific jurisdictions or the timing and result of ruling requests from taxing authorities, it is reasonably possible that within the next 12 months total unrecognized tax benefits could be potentially reduced by approximately $17 million.
Table:
 |  |  | Payments Due by Period |  | 
 | Total | Less than 1 year | 1-3 years | 3-5 years | More than 5 years
Senior Notes(1) | $4,552 | $1,372 | $1,686 | $98 | $1,396
Note payable to Dell(2) | 283 | 5 | 278 | — | —
Term Loan(3) | 1,500 | 1,500 | — | — | —
Future Lease Commitments(4) | 1,202 | 144 | 268 | 178 | 612
Purchase obligations | 255 | 168 | 87 | — | —
Tax obligations(5) | 545 | 53 | 104 | 227 | 161
Asset Retirement Obligations | 13 | 1 | 5 | 2 | 5
Sub-Total | 8,350 | 3,243 | 2,428 | 505 | 2,174
Uncertain tax positions(6) | 479 |  |  |  | 
Total | $8,829 |  |  |  | 


Question: What was the total term loans?
Answer: 1,500
17. Called up share capital
Called up share capital is the number of shares in issue at their par value. A number of shares were allotted during the year in relation to employee share schemes.
Accounting policies
Equity instruments issued by the Group are recorded at the amount of the proceeds received, net of direct issuance costs.
Notes: 1 At 31 March 2019 the Group held 1,584,882,610 (2018: 2,139,038,029) treasury shares with a nominal value of €264 million (2018: €356 million). The market value of shares held was €2,566 million (2018: €4,738 million). During the year, 45,657,750 (2018: 53,026,317) treasury shares were reissued under Group share schemes. On 25 August 2017, 729,077,001 treasury shares were issued in settlement of tranche 1 of a maturing subordinated mandatory convertible bond issued on 19 February 2016. On 25 February 2019, 799,067,749 treasury shares were issued in settlement of tranche 2 of the maturing subordinated mandatory convertible bond.
2 On 5 March 2019 the Group announced the placing of subordinated mandatory convertible bonds totalling £1.72 billion with a 2 year maturity date in 2021 and £1.72 billion with a 3 year maturity date due in 2022. The bonds are convertible into a total of 2,547,204,739 ordinary shares with a conversion price of £1.3505 per share.
3 Represents US share awards and option scheme awards.
Table:
 |  | 2019 |  | 2018
 | Number | €m | Number | €m
Ordinary shares of 2020⁄21 US cents each allotted, issued and fully paid:1, 2 |  |  |  | 
1 April | 28,814,803,308 | 4,796 | 28,814,142,848 | 4,796
Allotted during the year3 | 454,870 | – | 660,460 | –
31 March | 28,815,258,178 | 4,796 | 28,814,803,308 | 4,796


Question: Between 2018 and 2019, which year had more ordinary shares as at 1 April?
Answer: 2019
Calculation: 28,814,803,308>28,814,142,848
This section presents the total remuneration of the Group’s external auditors for audit, assurance, and other services.
The auditors’ remuneration for the Group is as follows:
(1) Assurance related services include various agreed upon procedures and review of the sustainability report.
(2)  Other non-audit services include financial due diligence and other sundry services.
(3)  Other auditors are international associates of Deloitte Touche Tohmatsu Australia.
Table:
 | 2019 | 2018
 | $’000 | $’000
Auditors of the parent entity – Deloitte Touche Tohmatsu Australia |  | 
Audit or review of the financial reports | 3,055 | 2,778
Assurance related services (1) | 341 | 289
Tax compliance services | – | 11
Other non-audit services (2) | 222 | 193
 | 3,618 | 3,271
Other auditors (3) |  | 
Audit or review of the financial reports | 432 | 419
Assurance related services (1) | 50 | 50
Tax compliance services | 62 | 29
 | 544 | 498
Total auditors’ remuneration | 4,162 | 3,769


Question: What is the total auditors' remuneration in 2019?
Answer: 4,162
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 dj trans , and the s&p 500 . the graph assumes that $ 100 was invested in the common stock of union pacific corporation and each index on december 31 , 2012 and that all dividends were reinvested . the information below is historical in nature and is not necessarily indicative of future performance . purchases of equity securities 2013 during 2017 , we repurchased 37122405 shares of our common stock at an average price of $ 110.50 . the following table presents common stock repurchases during each month for the fourth quarter of 2017 : 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 | 3831636 | $ 113.61 | 3800000 | 89078662
nov . 1 through nov . 30 | 3005225 | 117.07 | 2937410 | 86141252
dec . 1 through dec . 31 | 2718319 | 130.76 | 2494100 | 83647152
total | 9555180 | $ 119.58 | 9231510 | n/a
[a] total number of shares purchased during the quarter includes approximately 323670 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: for the fourth quarter of 2017 what was the percent of the total number of shares purchased in october
Answer: 40.1%
Calculation: divide(3831636, 9555180)
EXPLANATORY INFORMATION
For the years ended December 31, 2019 and 2018, accounting for outstanding share-based payments using the equity-settled method for stock-based compensation was determined to be more dilutive than using the cash-settled method. As a result, net income for the year ended December 31, 2019 was reduced by $6 million (2018 – $2 million) in the diluted earnings per share calculation.
For the year ended December 31, 2019, there were 1,077,875 options out of the money (2018 – 37,715) for purposes of the calculation of earnings per share. These options were excluded from the calculation of the effect of dilutive securities because they were anti-dilutive.
Table:
 | Years ended December 31 | 
(In millions of dollars, except per share amounts) | 2019 | 2018
Numerator (basic) – Net income for the year | 2,043 | 2,059
Denominator – Number of shares (in millions): Weighted average number of shares outstanding – basic | 512 | 515
Effect of dilutive securities (in millions): Employee stock options and restricted share units | 1 | 1
Weighted average number of shares outstanding – diluted | 513 | 516
Earnings per share: |  | 
Basic | $3.99 | $4.00
Diluted | $3.97 | $3.99


Question: What is the increase/ (decrease) in Basic Earnings per share from 2018 to 2019?
Answer: -0.01
Calculation: 3.99-4.00
OPERATING AND FINANCIAL RESULTS
(1) For the three-month period ended August 31, 2019, the average foreign exchange rate used for translation was 1.3222 USD/CDN.
(2) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy as well as to reclassify results from Cogeco Peer 1 as discontinued
operations. For further details, please consult the "Accounting policies" and "Discontinued operations" sections.
(3) Fiscal 2019 actuals are translated at the average foreign exchange rate of the comparable period of fiscal 2018 which was 1.3100 USD/CDN.
Table:
Three months ended August 31, | 2019 (1) | 2018 (2) | Change | Change in constant currency | Foreign exchange impact
(in thousands of dollars, except percentages) | $ | $ | % | % | $
Revenue | 583,673 | 566,184 | 3.1 | 2.7 | 2,427
Operating expenses | 302,833 | 297,977 | 1.6 | 1.1 | 1,441
Management fees – Cogeco Inc. | 5,230 | 4,796 | 9.0 | 9.0 | -
Adjusted EBITDA | 275,610 | 263,411 | 4.6 | 4.3 | 986
Adjusted EBITDA margin | 47.2% | 46.5% |  |  | 


Question: What was the increase / (decrease) in the Adjusted EBITDA margin from three months ended August 31, 2018 to 2019?
Answer: 0.7
Calculation: 47.2% - 46.5%
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
NOTE 9 — Accrued Expenses and Other Liabilities
The components of accrued expenses and other liabilities are as follows:
Table:
 | As of December 31, | 
 | 2019 | 2018
Accrued product-related costs | $4,464 | $4,377
Accrued income taxes | 7,903 | 6,914
Accrued property and other taxes | 1,574 | 1,976
Accrued professional fees | 1,599 | 3,350
Contract liabilities | 2,877 | 1,981
Dividends payable | 1,299 | 1,310
Remediation reserves | 11,444 | 11,274
Other accrued liabilities | 5,218 | 6,165
Total accrued expenses and other liabilities | $36,378 | $37,347


Question: What was the percentage change in the Other accrued liabilities between 2018 and 2019?
Answer: -15.36
Calculation: (5,218-6,165)/6,165
Insurance Segment
(1) The Insurance segment revenues are inclusive of realized and unrealized gains and net investment income for the year ended December 31, 2019 and 2018. Such adjustments are related to transactions between entities under common control which are eliminated or are reclassified in consolidation.
Life, accident and health earned premiums, net: Life, accident and health earned premiums, net from our Insurance segment for the year ended December 31, 2019 increased $22.4 million to $116.8 million from $94.4 million for the year ended December 31, 2018. The increase was primarily due to the premiums generated from the acquisition of KIC in 2018.
Net investment income: Net investment income from our Insurance segment for the year ended December 31, 2019 increased $95.8 million to $212.9 million from $117.1 million for the year ended December 31, 2018. The increase was primarily due to the income generated from the assets acquired in the KIC acquisition, higher average invested assets as a result of the reinvestment of premiums and investment income received, and to a lesser extent, rotation into higher-yielding investments.
Net realized and unrealized gains on investments: Net realized and unrealized gains on investments from our Insurance segment for the year ended December 31, 2019 decreased $3.7 million to $1.9 million from $5.6 million for the year ended December 31, 2018. The decrease was driven by smaller realized gains on bonds and common stocks, higher impairments, and losses on fair value changes on interest only bonds in 2019. The decrease was offset by overall improvement in fair value changes in equity securities and realized gains on mortgage loans in 2019.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | Increase / (Decrease)
Life, accident and health earned premiums, net | $116.8 | $94.4 | $22.4
Net investment income | 212.9 | 117.1 | 95.8
Net realized and unrealized gains on investments | 1.9 | 5.6 | (3.7)
Net revenue | 331.6 | 217.1 | 114.5
Policy benefits, changes in reserves, and commissions | 234.4 | 197.3 | 37.1
Selling, general and administrative | 35.7 | 30.4 | 5.3
Depreciation and amortization | (23.1) | (12.4) | (10.7)
Other operating expense | 47.3 | — | 47.3
Income from operations (1) | $37.3 | $1.8 | $35.5


Question: What was the net investment income in December 2019?
Answer: $212.9 million
For 2019, we reported a net income of $1,032 million, compared to a net income of $1,287 million and $802 million for 2018 and 2017, respectively.
The 2019 net income represented diluted earnings per share of $1.14 compared to $1.41 and $0.89 for 2018 and 2017, respectively.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (In millions) | 
Net income attributable to parent company | $1,032 | $1,287 | $802
As percentage of net revenues | 10.8% | 13.3% | 9.6%


Question: How much net income represented diluted earnings per share in 2019?
Answer: $1.14