hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
CREDIT RISK
In many instances, trade receivables are written off directly to bad debt expense if the account has not been collected after a predetermined period of time.
The following table provides further details on trade receivables, net of allowance for doubtful accounts.
Table:
AT DECEMBER 31 | 2019 | 2018
Trade receivables not past due | 2,082 | 2,091
Trade receivables past due, net of allowance for doubtful accounts |  | 
Under 60 days | 541 | 508
60 to 120 days | 232 | 304
Over 120 days | 64 | 72
Trade receivables, net of allowance for doubtful accounts | 2,919 | 2,975


Question: What segments does the trade receivables past due, net of allowance for doubtful accounts consist of?
Answer: Under 60 days, 60 to 120 days, Over 120 days
Below is the summary of the FY17 PRUs vested and earned by each NEO.
(1) The Compensation Committee did not exercise its discretion to reduce any payouts.
Table:
NEO | Total FY17 PRUs Vested at end of FY18 | Total FY17 PRUs Vested at end of FY19 | Total FY17 PRUs Earned and Vested (1)
Gregory S. Clark | 2,404,175 | 175,023 | 2,579,198
Nicholas R. Noviello | 606,935 | 44,184 | 651,119
Amy L. Cappellanti-Wolf | 207,142 | 15,080 | 222,222
Samir Kapuria | 148,322 | 10,798 | 159,120
Scott C. Taylor | 414,287 | 30,160 | 444,447


Question: What is the Total FY17 PRUs Earned and Vested for  Gregory S. Clark?
Answer: 2,579,198
NOTE 10 – FREIGHT RECEIVABLES
As of 31 December 2019, freight receivables included receivables at a value of USD 0.0m (2018: USD 0.0m 2017: USD 0.0m) that are individually determined to be impaired to a value of USD 0.0m (2018: USD 0.0m, 2017: USD 0.0m).
Management makes allowance for expected credit loss based on the simplified approach to provide for expected credit losses, which permits the use of the lifetime expected loss provision for all trade receivables. Expected credit loss for receivables overdue more than 180 days is 25%-100%, depending on category. Expected credit loss for receivables overdue more than one year is 100%.
Table:
USDm | 2019 | 2018 | 2017
Analysis as of 31 December of freight receivables: |  |  | 
Gross freight receivables: |  |  | 
Not yet due | 39.8 | 44.0 | 25.5
Due < 30 days | 22.5 | 18.8 | 26.0
Due between 30 and 180 days | 25.3 | 20.5 | 18.4
Due > 180 days | 6.0 | 4.4 | 2.7
Total gross | 93.6 | 87.7 | 72.6
Allowance for expected credit loss | 3.7 | 1.7 | 1.3
Total net | 89.9 | 86.0 | 71.3


Question: In which year was the amount of total gross freight receivables the largest?
Answer: 2019
Calculation: 93.6>87.7>72.6
The table below summarizes our cash flows from continuing operations activities for each of the last two fiscal years (in thousands):
Operating Activities. Operating cash flows increased $64.4 million in 2019 compared with 2018 primarily due to favorable changes in working capital of  $37.0 million, primarily due to lower income tax payments of$41.3 million, and higher net income adjusted for non-cash items of $27.3 million
Pension and Postretirement Contributions — Our policy is to fund our pension plans at or above the minimum required by law. As of January 1, 2019, the date of our last actuarial funding valuation for our qualified pension plan, there was no minimum contribution funding requirement. In 2019 and 2018, we contributed $6.2 million and $5.5 million, respectively, to our pension and postretirement plans. We do not anticipate making any contributions to our qualified defined benefit pension plan in fiscal 2020. For additional information, refer to Note 12, Retirement Plans, of the notes to the consolidated financial statements.
Table:
 | 2019 | 2018
Total cash provided by (used in) continuing operations: |  | 
Operating activities | $168,405 | $104,055
Investing activities | (13,819) | 65,661
Financing activities | (5,730) | (445,529)
Net increase (decrease) in cash from continuing operations | $148,856 | $(275,813)


Question: How much money was contributed to the pension and postretirement plan in 2019?
Answer: $6.2 million
ADJUSTED EBITDA
(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.
Fiscal 2019 fourth-quarter adjusted EBITDA increased by 4.6% (4.3% in constant currency) as a result of: • an increase in the American broadband services segment mainly as a result of strong organic growth combined with the impact of the FiberLight acquisition; and • an increase in the Canadian broadband services segment resulting mainly from a decline in operating expenses.
Table:
Three months ended August 31, | 2019 (1) | 2018 (2) | Change | Change in constant currency (3) | Foreign exchange impact (3)
(in thousands of dollars, except percentages) | $ | $ | % | % | $
Canadian broadband services | 172,120 | 166,181 | 3.6 | 3.6 | (73)
American broadband services | 115,523 | 109,937 | 5.1 | 4.1 | 1,057
Inter-segment eliminations and other | (12,033) | (12,707) | (5.3) | (5.3) | 2
 | 275,610 | 263,411 | 4.6 | 4.3 | 986


Question: What was the average American broadband services from 2018 to 2019?
Answer: 112730
Calculation: (115,523 + 109,937) / 2
D) SHARE-BASED PAYMENT PLANS
The Corporation offers an Employee Stock Purchase Plan for the benefit of its employees and those of its subsidiaries and a Stock Option Plan to its executive officers and designated employees. No more than 10% of the outstanding subordinate voting shares are available for issuance under these plans. Furthermore, the Corporation offers an Incentive Share Unit Plan ("ISU Plan") and a Performance Share Unit Plan ("PSU Plan") for executive officers and designated employees, and a Deferred Share Unit Plan ("DSU Plan") for members of the Board of Directors ("Board").
Stock purchase plan The Corporation offers, for the benefit of its employees and those of its subsidiaries, an Employee Stock Purchase Plan, which is accessible to all employees up to a maximum of 7% of their base annual salary and the Corporation contributes 25% of the employee contributions. The subscriptions are made monthly and employee subordinate voting shares are purchased on the stock market.
Stock option plan A total of 3,432,500 subordinate voting shares are reserved for the purpose of the Stock Option Plan. The minimum exercise price at which options are granted is equal to the market value of such shares at the time the option is granted. Options vest equally over a period of five years beginning one year after the day such options are granted and are exercisable over ten years.
Under the Stock Option Plan, the following options were granted by the Corporation and are outstanding at August 31:
(1) For the year ended August 31, 2019, the Corporation granted 97,725 (126,425 in 2018) stock options to Cogeco's executive officers as executive officers of the Corporation. (2) The weighted average share price for options exercised during the year was $92.43 ($83.46 in 2018).
Table:
Years ended August 31, |  | 2019 |  | 2018
 | Options | Weighted average exercise price | Options | Weighted average exercise price
 |  | $ |  | $
Outstanding, beginning of the year | 819,393 | 65.27 | 652,385 | 56.61
Granted (1) | 201,525 | 65.62 | 281,350 | 85.08
Exercised (2) | (170,754) | 57.28 | (60,337) | 57.77
Cancelled | (134,550) | 72.43 | (54,005) | 72.28
Outstanding, end of the year | 715,614 | 65.93 | 819,393 | 65.27
Exercisable, end of the year | 264,374 | 55.99 | 277,108 | 49.76


Question: What is the average options granted from 2018 to 2019?
Answer: 241437.5
Calculation: (201,525 + 281,350) / 2
20. Computation of Basic/Diluted Earnings Per Common Share
The following table sets forth the computation of basic and diluted earnings per common share (amounts in millions, except per share data):
The vesting of certain of our employee-related restricted stock units and options is contingent upon the satisfaction of predefined performance measures. The shares underlying these equity awards are included in the weighted-average dilutive common shares only if the performance measures are met as of the end of the reporting period. Additionally, potential common shares are not included in the denominator of the diluted earnings per common share calculation when the inclusion of such shares would be anti-dilutive.
Table:
 |  | For the Years Ended December 31, | 
 | 2019 | 2018 | 2017
Numerator: |  |  | 
Consolidated net income | $1,503 | $1,848 | $273
Denominator: |  |  | 
Denominator for basic earnings per common share—weighted-average common shares outstanding | 767 | 762 | 754
Effect of dilutive stock options and awards under the treasury stock method | 4 | 9 | 12
Denominator for diluted earnings per common share—weighted-average common shares outstanding plus dilutive common shares under the treasury stock method | 771 | 771 | 766
Basic earnings per common share | $1.96 | $2.43 | $0.36
Diluted earnings per common share | $1.95 | $2.40 | $0.36


Question: What was the consolidated net income in 2018?
Answer: $1,848
Restricted Stock Grants—During 2019 and 2018, the Company granted 0.321 and 0.410 shares, respectively, of restricted stock to certain employee and director participants under its share-based compensation plans. Restricted stock grants generally vest over a period of 1 to 4 years. The Company recorded $72.5, $109.7 and $63.0 of compensation expense related to outstanding shares of restricted stock held by employees and directors during 2019, 2018 and 2017, respectively. In 2018, this expense included $29.4 associated with accelerated vesting due to the passing of our former executive chairman. A summary of the Company’s nonvested shares activity for 2019 and 2018 is as follows:
At December 31, 2019, there was $77.9 of total unrecognized compensation expense related to nonvested awards granted to both employees and directors under the Company’s share-based compensation plans. That cost is expected to be recognized over a weighted-average period of 1.8 years. Unrecognized compensation expense related to nonvested shares of restricted stock grants is recorded as a reduction to additional paid-in capital in stockholder’s equity at December 31, 2019.
Employee Stock Purchase Plan—During 2019, 2018 and 2017, participants of the ESPP purchased 0.021, 0.020 and 0.020 shares, respectively, of Roper’s common stock for total consideration of $6.8, $5.4, and $4.2, respectively. All of these shares were purchased from Roper’s treasury shares.
Table:
 | Number of shares | Weighted-average grant date fair value
Nonvested at December 31, 2017 | 0.859 | $ 187.01
Granted | 0.410 | 278.29
Vested | (0.492) | 204.24
Forfeited | (0.038) | 191.51
Nonvested at December 31, 2018 | 0.739 | $ 225.93
Granted | 0.321 | 318.75
Vested | (0.290) | 209.05
Forfeited | (0.061) | 225.23
Nonvested at December 31, 2019 | 0.709 | $ 275.00


Question: How long does restricted stock grants generally vest over?
Answer: a period of 1 to 4 years
16. SHARE-BASED PAYMENTS continued
c. Employee Share Option Plan
The Employee Share Option Plan (the Option Plan) was approved by shareholders at the Company’s AGM on 9 November 2001 and reaffirmed at the AGM on 24 November 2011.The Employee Share Option Plan (the Option Plan) was approved by shareholders at the Company’s AGM on 9 November 2001 and reaffirmed at the AGM on 24 November 2011. Under the Option Plan, awards are made to eligible executives and other management personnel who have an impact on the Group’s performance. Option Plan awards are delivered in the form of options over shares, which vest over a period of three years subject to meeting performance measures and continuous employment with the Company. Each option is to subscribe for one ordinary share when the option is exercised and, when issued, the shares will rank equally with other shares.
Unless the terms on which an option was offered specified otherwise, an option may be exercised at any time after the vesting date on satisfaction of the relevant performance criteria.
Options issued under the Employee Share Option Plan are valued on the same basis as those issued to KMP, which is described in Note 16(d).
There were no new options issued under the Option Plan during the 30 June 2019 and 30 June 2018 financial years, as the Option Plan was replaced with the Rights Plan as described in Note 16(b).
Movement of options during the year ended 30 June 2019:
1. The original expiry date for this tranche of options was 2 July 2018. However, due to extraordinary circumstances, the remaining 75,000 options could not be exercised during the prior financial year. Therefore, the Board had exercised its discretion during the year to extend the expiry date for the remaining options to 30 September 2018.
2. Options associated with an EPS hurdle are not expected to vest on 31 August 2019 as the minimum performance target will not be met. Options associated with a TSR hurdle will vest on 31 August 2019 in accordance with accounting standards. However, because the minimum target was not met, these options will be restricted and unexercisable. Refer to Section 3b) of the audited Remuneration Report for further details.
Table:
Grant Date | Vesting Date | Expiry Date | Exercise Price $ | No. of Options at Beg. of Year | Options Exercised or Lapsed | No. of Options at End of Year
2 Jul 2013 | 2 Jul 2016 | 30 Sept 2018 1 | 0.92 | 75,000 | (75,000) | -
2 Jul 2014 | 2 Jul 2017 | 2 Jul 2019 | 1.30 | 470,000 | (205,000) | 265,000
2 Jul 2015 | 2 Jul 2018 | 2 Jul 2020 | 2.67 | 1,000,000 | (75,000) | 925,000
22 Dec 2016 | 31 Aug 2019 2 | 22 Dec 2021 | 3.59 | 1,323,730 | - | 1,323,730
Total |  |  |  | 2,868,730 | (355,000) | 2,513,730
Weighted average exercise price |  |  |  |  | $1.51 | $3.01


Question: What was the total percentage change in number of options at beginning of the year for options granted between 2013 and 2016?
Answer: 1664.97
Calculation: (1,323,730 - 75,000) / 75,000
Revenue
Both reported and adjusted revenue fell by 1% as growth in our Consumer business, was more than offset by regulated price reductions in Openreach and declines in our enterprise businesses in particular in fixed voice and also reflecting our strategy to reduce low margin activity such as equipment sales. Excluding the negative impact of £35m from foreign exchange movements, underlying revenue fell 0.9% (2017/18: fell 1%), which exceeds our expectation of down around 2%.
You can find details of revenue by customer-facing unit on pages 40 to 41. Note 6 to the consolidated financial statements shows a full breakdown of reported revenue by all our major product and service categories.
Operating costs
Reported operating costs were down 2% and adjustedb operating costs before depreciation and amortisation were down 1%. This was mainly driven by restructuring related cost savings and lower payments to telecommunications operators driven by Global Services strategy to de-emphasise low margin business, partly offset by higher costs of recruiting and training engineers to support Openreach’s ‘Fibre First’ programme and help deliver improved customer service.
Our cost transformation programme remains on track. c4,000 roles were removed in the year, with the largest elements being in Global Services and our Corporate Units. Overall savings from the programme are currently an annualised benefit of £875m with an associated cost of £386m. Note 7 to the consolidated financial statements shows a detailed breakdown of our operating costs.
Note 7 to the consolidated financial statements shows a detailed breakdown of our operating costs.
a Excluding depreciation and amortisation.
Table:
 | 2019 | 2018 | 2017
Year ended 31 March | £m | £m | £m
Revenue | 23,428 | 23,723 | 24,062
Operating costs a | (16,461) | (16,828) | (17,323)
Depreciation and amortisation | (3,546) | (3,514) | (3,572)
Operating profit | 3,421 | 3,381 | 3,167
Net finance expense | (756) | (764) | (804)
Associates and joint ventures | 1 | (1) | (9)
Profit before tax | 2,666 | 2,616 | 2,354
Tax | (507) | (584) | (446)
Profit for the period | 2,159 | 2,032 | 1,908


Question: What is the revenue for 2017, 2018 and 2019 respectively?
Answer: 24,062, 23,723, 23,428
the fair value of our grants receivable is determined using a discounted cash flow model , which discounts future cash flows using an appropriate yield curve . as of december 28 , 2013 , and december 29 , 2012 , the carrying amount of our grants receivable was classified within other current assets and other long-term assets , as applicable . our long-term debt recognized at amortized cost is comprised of our senior notes and our convertible debentures . the fair value of our senior notes is determined using active market prices , and it is therefore classified as level 1 . the fair value of our convertible long-term debt is determined using discounted cash flow models with observable market inputs , and it takes into consideration variables such as interest rate changes , comparable securities , subordination discount , and credit-rating changes , and it is therefore classified as level 2 . the nvidia corporation ( nvidia ) cross-license agreement liability in the preceding table was incurred as a result of entering into a long-term patent cross-license agreement with nvidia in january 2011 . we agreed to make payments to nvidia over six years . as of december 28 , 2013 , and december 29 , 2012 , the carrying amount of the liability arising from the agreement was classified within other accrued liabilities and other long-term liabilities , as applicable . the fair value is determined using a discounted cash flow model , which discounts future cash flows using our incremental borrowing rates . note 5 : cash and investments cash and investments at the end of each period were as follows : ( in millions ) dec 28 , dec 29 .

Table:
( in millions ) | dec 282013 | dec 292012
available-for-sale investments | $ 18086 | $ 14001
cash | 854 | 593
equity method investments | 1038 | 992
loans receivable | 1072 | 979
non-marketable cost method investments | 1270 | 1202
reverse repurchase agreements | 800 | 2850
trading assets | 8441 | 5685
total cash and investments | $ 31561 | $ 26302
in the third quarter of 2013 , we sold our shares in clearwire corporation , which had been accounted for as available-for-sale marketable equity securities , and our interest in clearwire communications , llc ( clearwire llc ) , which had been accounted for as an equity method investment .
in total , we received proceeds of $ 470 million on these transactions and recognized a gain of $ 439 million , which is included in gains ( losses ) on equity investments , net on the consolidated statements of income .
proceeds received and gains recognized for each investment are included in the "available-for-sale investments" and "equity method investments" sections that follow .
table of contents intel corporation notes to consolidated financial statements ( continued ) .

Question: what was the percent of the increase in the total cash and investments from 2012 to 2013
Answer: 19.9%
Calculation: subtract(31561, 26302), divide(#0, 26302)
RESULTS OF OPERATIONS
Revenue
(1) Reflects client arrangements (term license, cloud, and maintenance) that are subject to renewal.
We expect our revenue mix to continue to shift in favor of our subscription offerings, particularly cloud arrangements, which could result in slower total revenue growth in the near term. Revenue from cloud arrangements is generally recognized over the service period, while revenue from term and perpetual license arrangements is generally recognized upfront when the license rights become effective.
Subscription revenue
The increase in cloud revenue in 2019 reflects the shift in client preferences to cloud arrangements from other types of arrangements. The increase in term license revenue in 2019 was due to several large, multi-year term license contracts executed in 2019. This increase was partially offset by term license contracts with multi-year committed maintenance periods, where a greater portion of the contract value is allocated to maintenance.
The increase in maintenance revenue in 2019 was primarily due to the continued growth in the aggregate value of the installed base of our software and strong renewal rates in excess of 90%
Perpetual license
The decrease in perpetual license revenue in 2019 reflects the shift in client preferences in favor of our subscription offerings, particularly cloud arrangements
Consulting
Our consulting revenue fluctuates depending upon the mix of new implementation projects we perform as compared to those performed by our enabled clients or led by our partners. See "Our consulting revenue is significantly dependent upon our consulting personnel implementing new license and cloud arrangements" in Item 1A of this Annual Report for additional information.
The decrease in consulting revenue in 2019 was primarily due to a decrease in billable hours.
Table:
(Dollars in thousands) | 2019 |  | 2018 |  | Change | 
Cloud | $133,746 | 15% | 82,627 | 9% | $51,119 | 62%
Term license | 199,433 | 22% | 178,256 | 20% | 21,177 | 12%
Maintenance | 280,580 | 30% | 263,875 | 30% | 16,705 | 6%
Subscription (1) | 613,759 | 67% | 524,758 | 59% | 89,001 | 17%
Perpetual license | 80,015 | 9% | 109,863 | 12% | (29,848) | (27)%
Consulting | 217,609 | 24% | 256,960 | 29% | (39,351) | (15)%
 | $911,383 | 100% | $891,581 | 100% | $19,802 | 2%


Question: What can the increase in maintenance revenue in 2019 be primarily attributed to?
Answer: the continued growth in the aggregate value of the installed base of our software and strong renewal rates in excess of 90%
Income Tax Provision Reconciliation
The difference between the income tax benefit (provision) and income taxes computed using the U.S. federal income tax rate was as follows for the years ended September 30, 2019, 2018, and 2017 (amounts shown in thousands):
Table:
 | 2019 | 2018 | 2017
Amount computed using statutory rate | $841 | $2,122 | $(1,078)
Net change in valuation allowance for net deferred tax assets | (459) | (367) | 10,058
AMT and other | — | (191) | 20
Foreign rate differential | 664 | 22 | (169)
Non-deductible items | (151) | (276) | (370)
State income tax | (370) | 50 | (34)
Impact of tax reform on deferred taxes | — | (4,901) | —
Research and development credits | 1,694 | 475 | 2,494
Foreign income tax | (494) | — | —
Stock compensation, net | 1,539 | — | —
Income tax benefit (provision) | $3,264 | $(3,066) | $10,921


Question: What are state income tax for the years 2018 and 2019, respectively?
Answer: 50, (370)
Disaggregated revenue
The Group’s revenues by geographic region based on end-users who purchased our products or services are as follows:
Revenues from the United States totaled approximately $529 million, $386 million, and $281 million for the fiscal years ended 2019, 2018, and 2017, respectively. Revenues from our country of domicile, the United Kingdom, totaled approximately $86 million, $63 million, and $46 million for the fiscal years ended 2019, 2018, and 2017, respectively. No one customer has accounted for more than 10% of revenue for the fiscal years ended 2019, 2018, and 2017.
Table:
 |  | Fiscal Year Ended June 30, | 
 | 2019 | 2018 | 2017
 |  | (U.S. $ in thousands) | 
 |  | *As Adjusted | *As Adjusted
Americas | $603,959 | $439,363 | $317,432
EMEA | 474,712 | 347,509 | 193,790
Asia Pacific | 131,456 | 94,106 | 115,462
 | $1,210,127 | $880,978 | $626,684


Question: In fiscal year ended 2019, how many geographic regions have more than $500,000 thousand of revenues?
Answer: 1
Calculation: Americas