hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
3. REVENUE FROM CONTRACTS WITH CUSTOMERS
Revenues and related costs on construction contracts are recognized as the performance obligations are satisfied over time in accordance with ASC 606, Revenue from Contracts with Customers. Under ASC 606, revenue and associated profit, will be recognized as the customer obtains control of the goods and services promised in the contract (i.e., performance obligations). The cost of uninstalled materials or equipment will generally be excluded from the Company’s recognition of profit, unless specifically produced or manufactured for a project, because such costs are not considered to be a measure of progress.
In adopting ASC 606, the Company had the following significant changes in accounting principles:
(i) Timing of revenue recognition for uninstalled materials - The Company previously recognized the majority of its revenue from the installation or construction of commercial & public works projects using the percentage-of-completion method of accounting, whereby revenue is recognized as the Company progresses on the contract. The percentage-of-completion for each project was determined on an actual cost-to-estimated final cost basis. Under ASC 606, revenue and associated profit, is recognized as the customer obtains control of the goods and services promised in the contract (i.e., performance obligations). The cost of uninstalled materials or equipment is generally excluded from the Company’s recognition of profit, unless specifically produced or manufactured for a project, because such costs are not considered to be a measure of progress.
(ii) Completed contracts - The Company previously recognized the majority of its revenue from the installation of residential projects using the completed contract method of accounting whereby revenue the Company recognized when the project is completed. Under, ASC 606, revenue is recognized as the customer obtains control of the goods and services promised in the contract (i.e., performance obligations).
Revenue recognition for other sales arrangements such as the sales of materials will remain materially consistent with prior treatment.
The adoption of the new revenue recognition standard resulted in a cumulative effect adjustment to retained earnings of approximately $1,405 as of January 1, 2018. The details of this adjustment are summarized below.
Table:
 | Balance at December 31, 2017 | Adjustments Due to ASC 606 | Balance at January 1, 2018
Contract assets | $3,790 | $(584) | $3,206
Contract liabilities | 7,288 | 821 | 8,109
Accumulated deficit | (56,365) | (1,405) | (57,770)


Question: What is the Contract assets balance at December 31, 2017? 
Answer: $3,790
and $ 19 million of these expenses in 2011 and 2010 , respectively , with the remaining expense unallocated . the company financed the acquisition with the proceeds from a $ 1.0 billion three-year term loan credit facility , $ 1.5 billion in unsecured notes , and the issuance of 61 million shares of aon common stock . in addition , as part of the consideration , certain outstanding hewitt stock options were converted into options to purchase 4.5 million shares of aon common stock . these items are detailed further in note 8 2018 2018debt 2019 2019 and note 11 2018 2018stockholders 2019 equity 2019 2019 . the transaction has been accounted for using the acquisition method of accounting which requires , among other things , that most assets acquired and liabilities assumed be recognized at their fair values as of the acquisition date . the following table summarizes the amounts recognized for assets acquired and liabilities assumed as of the acquisition date ( in millions ) : amounts recorded as of the acquisition .

Table:
 | amountsrecorded as ofthe acquisitiondate
working capital ( 1 ) | $ 348
property equipment and capitalized software | 297
identifiable intangible assets: | 
customer relationships | 1800
trademarks | 890
technology | 215
other noncurrent assets ( 2 ) | 344
long-term debt | 346
other noncurrent liabilities ( 3 ) | 360
net deferred tax liability ( 4 ) | 1021
net assets acquired | 2167
goodwill | 2765
total consideration transferred | $ 4932
( 1 ) includes cash and cash equivalents , short-term investments , client receivables , other current assets , accounts payable and other current liabilities .
( 2 ) includes primarily deferred contract costs and long-term investments .
( 3 ) includes primarily unfavorable lease obligations and deferred contract revenues .
( 4 ) included in other current assets ( $ 31 million ) , deferred tax assets ( $ 30 million ) , other current liabilities ( $ 7 million ) and deferred tax liabilities ( $ 1.1 billion ) in the company 2019s consolidated statements of financial position .
the acquired customer relationships are being amortized over a weighted average life of 12 years .
the technology asset is being amortized over 7 years and trademarks have been determined to have indefinite useful lives .
goodwill is calculated as the excess of the acquisition cost over the fair value of the net assets acquired and represents the synergies and other benefits that are expected to arise from combining the operations of hewitt with the operations of aon , and the future economic benefits arising from other assets acquired that could not be individually identified and separately recognized .
goodwill is not amortized and is not deductible for tax purposes .
a single estimate of fair value results from a complex series of the company 2019s judgments about future events and uncertainties and relies heavily on estimates and assumptions .
the company 2019s .

Question: what is the total value of identified intangible assets?
Answer: 2905
Calculation: add(1800, 890), add(#0, 215)
16. SHARE-BASED PAYMENTS
a. Employee Share Plan
The Employee Share Plan (ESP) is available to all eligible employees each year to acquire ordinary shares in the Company from future remuneration (before tax). Shares to be issued or transferred under the ESP will be valued at the volume-weighted average price of the Company’s shares traded on the Australian Securities Exchange during the five business days immediately preceding the day the shares are issued or transferred. Shares issued under the ESP are not allowed to be sold, transferred or otherwise disposed until the earlier of the end of an initial three-year period, or the participant ceasing continuing employment with the Company.
Details of the movement in employee shares under the ESP are as follows:
The consideration for the shares issued on 22 May 2019 was $3.72 (7 May 2018: $4.24).
Table:
 | 2019 | 2018
 | No. of Shares | No. of Shares
Number of shares at beginning of year | 114,758 | 137,227
Number of shares distributed to employees | 45,560 | 42,480
Number of shares transferred to main share registry and/or disposed of | (44,526) | (64,949)
Number of shares at year end | 115,792 | 114,758


Question: What was the difference between the number of shares at the beginning and end of year 2019?
Answer: 1034
Calculation: 115,792 - 114,758
Cloud & Cognitive Software revenue increased in 2018 compared to the prior year with growth in all three lines of business, as reported and adjusted for currency. Within Cognitive Applications, the increase was driven by strong double-digit growth in security services, while growth in Cloud & Data Platforms was led by analytics platforms and integration offerings. Transaction Processing Platforms grew with improved revenue performance sequentially in the fourth-quarter 2018 versus the third-quarter 2018 reflecting clients’ commitment to the company’s platform for the long term and the value it provides in managing mission-critical workloads. Within Cloud & Cognitive Software, cloud revenue of $3.0 billion grew 10 percent as reported and adjusted for currency compared to the prior year.
* Recast to reflect segment changes.
Gross margin in Cloud & Cognitive Software was impacted by an increased mix toward SaaS, a mix toward security services and increased royalty costs associated with IP licensing agreements compared to the prior year. Pre-tax income improvement year to year was primarily driven by operational efficiencies and mix.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2018* | 2017* | Yr.-to-Yr. Percent/ Margin Change
Cloud & Cognitive Software |  |  | 
External gross profit | $17,224 | $16,986 | 1.4%
External gross profit margin | 77.6% | 78.1% | (0.5)pts.
Pre-tax income | $8,882 | $8,068 | 10.1%
Pre-tax margin | 35.0% | 32.4% | 2.6pts.


Question: What is the increase / (decrease) in the external gross profit from 2017 to 2018?
Answer: 238
Calculation: 17,224 - 16,986
Fiscal 2018 Restructuring Plan
During Fiscal 2018 and in the context of our acquisitions of Covisint, Guidance and Hightail (each defined below), we began to implement restructuring activities to streamline our operations (collectively referred to as the Fiscal 2018 Restructuring Plan). The Fiscal 2018 Restructuring Plan charges relate to workforce reductions and facility consolidations. These charges require management to make certain judgments and estimates regarding the amount and timing of restructuring charges or recoveries. Our estimated liability could change subsequent to its recognition, requiring adjustments to the expense and the liability recorded. On a quarterly basis, we conduct an evaluation of the related liabilities and expenses and revise our assumptions and estimates as appropriate.
Since the inception of the plan, approximately $10.7 million has been recorded within "Special charges (recoveries)" to date. We do not expect to incur any further significant charges relating to this plan.
A reconciliation of the beginning and ending liability for the year ended June 30, 2019 and 2018 is shown below.
Table:
Fiscal 2018 Restructuring Plan | Workforce reduction | Facility costs | Total
Balance payable as at June 30, 2017 | $— | $— | $—
Accruals and adjustments | 8,511 | 1,643 | 10,154
Cash payments | (8,845) | (489) | (9,334)
Foreign exchange and other non-cash adjustments | 892 | 11 | 903
Balance payable as at June 30, 2018 | $558 | $1,165 | $1,723
Accruals and adjustments | (20) | 535 | 515
Cash payments | (337) | (928) | (1,265)
Foreign exchange and other non-cash adjustments | (51) | (286) | (337)
Balance payable as at June 30, 2019 | $150 | $486 | $636


Question: How much has been  recorded within "Special charges (recoveries)" since the inception of the plan to date?
Answer: $10.7 million
1. Goodwill and Other Intangible Assets
The changes in the carrying amount of goodwill for the years ended December 31, 2019 and 2018, are as follows:
Our 2019 acquisitions of DeliverySlip (as defined herein) and AppRiver (as defined herein) resulted in the addition to our goodwill balance in 2019. Our 2018 acquisition of Erado (as defined herein) resulted in the addition to our goodwill balance in 2018. Our 2018 acquisition adjustments to goodwill reflect the appropriate reallocation of excess purchase price from goodwill to acquired assets and liabilities related to our 2017 Greenview and EMS (as defined herein) purchases. We evaluate goodwill for impairment annually in the fourth quarter, or when there is reason to believe that the value has been diminished or impaired. There were no impairment indicators to the goodwill recorded as of December 31, 2019.
Table:
 | Year Ended December 31, | 
(In thousands) | 2019 | 2018
Opening balance | $ 13,783 | $ 8,469
Additions | 157,121 | 6,215
Acquisition adjustments | — | (901 )
Effect of currency translation adjustment | 305 | —
Goodwill | $ 171,209 | $ 13,783


Question: From 2018 to 2019, how many years was the Opening balance more than $5,000 thousand?
Answer: 2
Calculation: 2018 ## 2019
8. Deferred Revenue
Deferred revenue consisted of the following:
Table:
 | December 31, | 
 | 2019 | 2018
Current: |  | 
Domains | $752.7 | $686.3
Hosting and presence | 526.7 | 483.3
Business applications | 265.0 | 224.1
 | $1,544.4 | $1,393.7
Noncurrent: |  | 
Domains | $382.2 | $365.8
Hosting and presence | 187.2 | 180.6
Business applications | 85.0 | 77.4
 | $ 654.4 | $623.8


Question: What is the 2018 year end total non-current deferred revenue?
Answer: 623.8
7 OTHER GAINS, NET
Note: (a) The disposal and deemed disposal gains of approximately RMB8,492 million recognised during the year ended 31 December 2019 mainly comprised the following:
– net gains of approximately RMB4,859 million (2018: RMB1,661 million) on dilution of the Group’s equity interests in certain associates due to new equity interests being issued by these associates (Note 21). These investee companies are principally engaged in Internet-related business; and
– aggregate net gains of approximately RMB3,633 million (2018: RMB1,271 million) on disposals, partial disposals or deemed disposals of various investments of the Group.
(b) Net fair value gains on FVPL of approximately RMB9,511 million (Note 24) recognised during the year ended 31 December 2019 mainly comprised the following:
– aggregate gains of approximately RMB1,886 million (2018: RMB22,215 million) arising from reclassification of several investments principally engaged in Internet-related business from FVPL to investments in associates due to the conversion of the Group’s redeemable instruments or preferred shares of these investee companies into their ordinary shares and the Group has board representation upon their respective initial public offerings (“IPO”); and
– net gains of approximately RMB7,625 million (2018: RMB6,523 million) from fair value changes of FVPL.
Table:
 | 2019 | 2018
 | RMB’Million | RMB’Million
Net gains on disposals and deemed disposals of investee companies (Note (a)) | 8,492 | 2,932
Net fair value gains on FVPL (Note (b)) | 9,511 | 28,738
Subsidies and tax rebates | 4,263 | 3,456
Impairment provision/(reversal) for investee companies and intangible assets arising from acquisitions (Note (c)) | (4,006) | (17,577)
Net fair value gains on other financial instruments (Note 27 and Note 38) | 1,647 | 1,019
Dividend income | 1,014 | 686
Donations to Tencent Charity Funds | (850) | (730)
Others | (382) | (1,810)
 | 19,689 | 16,714


Question: How much is the 2019 dividend income?
Answer: 1,014
Contract Balances
A contract asset will be recorded if we have recognized revenue but do not have an unconditional right to the related consideration from the customer. For example, this will be the case if implementation services offered in a cloud arrangement are identified as a separate performance obligation and are provided to a customer prior to us being able to bill the customer. In addition, a contract asset may arise in relation to subscription licenses if the license revenue that is recognized upfront exceeds the amount that we are able to invoice the customer at that time. Contract assets are reclassified to accounts receivable when the rights become unconditional.
The balance for our contract assets and contract liabilities (i.e. deferred revenues) for the periods indicated below were as follows:
The difference in the opening and closing balances of our contract assets and deferred revenues primarily results from the timing difference between our performance and the customer’s payments. We fulfill our obligations under a contract with a customer by transferring products and services in exchange for consideration from the customer. During the year ended June 30, 2019, we reclassified $19.2 million of contract assets to receivables as a result of the right to the transaction consideration becoming unconditional. During the year ended June 30, 2019, there was no significant impairment loss recognized related to contract assets.
We recognize deferred revenue when we have received consideration or an amount of consideration is due from the customer for future obligations to transfer products or services. Our deferred revenues primarily relate to customer support agreements which have been paid for by customers prior to the performance of those services. The amount of revenue that was recognized during the year ended June 30, 2019 that was included in the deferred revenue balances at July 1, 2018 was approximately $617 million.
Table:
 | As of June 30, 2019 | As of July 1, 2018
Short-term contract assets | $20,956 | $5,474
Long-term contract assets | $15,386 | $12,382
Short-term deferred revenue | $641,656 | $618,197
Long-term deferred revenue | $46,974 | $64,743


Question: When will a contract asset be recorded?
Answer: if we have recognized revenue but do not have an unconditional right to the related consideration from the customer
A summary of additions and deductions related to the allowance for doubtful accounts for the years ended March 31, 2019, 2018 and 2017 follows (amounts in millions):
(1) Deductions represent uncollectible accounts written off, net of recoveries.
Table:
 | Balance at Beginning of Year | Additions Charged to Costs and Expenses | Deductions (1) | Balance at End of Year
Allowance for doubtful accounts: |  |  |  | 
Fiscal 2019 | $2.2 | $— | $(0.2) | $2.0
Fiscal 2018 | $2.1 | $0.2 | $(0.1) | $2.2
Fiscal 2017 | $2.5 | $0.2 | $(0.6) | $2.1


Question: How many years did the balance at end of the year exceed $2 million?
Answer: 3
Calculation: 2019##2018##2017
Overview of 2019
Total revenues for 2019 were $36.0 million, a decrease of $75.0 million, or 68%, versus 2018. The decrease was primarily driven by the $70.9 million decrease in fixed fee license revenue and the $4.0 million decrease in per-unit royalty revenue.
For 2019, we had a net loss of $20.0 million as compared to $54.3 million of net income for 2018. The $74.4 million decrease in net income was mainly related to the $75.0 million decrease in total revenue partially offset by a $0.5 million decrease in cost and operating expenses for 2019 compared to 2018.
We adopted ASC 606, effective January 1, 2018. Consistent with the modified retrospective transaction method, our results of operations for periods prior to the adoption of ASC 606 remain unchanged. As a result, the change in total revenues from 2018 to 2019 included a component of accounting policy change arising from the adoption of ASC 606.
The following table sets forth our consolidated statements of income data as a percentage of total revenues:
Table:
 | Years Ended December 31, |  | 
 | 2019 | 2018 | 2017
Revenues:      |  |  | 
Fixed fee license revenue | 35.1 %  | 75.3 %  | 36.0 %
Per-unit royalty revenue | 64.0 | 24.3 | 61.4
Total royalty and license revenue | 99.1 | 99.6 | 97.4
Development, services, and other | 0.9 | 0.4 | 2.6
Total revenues | 100.0 | 100.0 | 100.0
Costs and expenses: |  |  | 
Cost of revenues | 0.5 | 0.2 | 0.6
Sales and marketing | 17.9 | 5.5 | 38.6
Research and development | 21.8 | 8.8 | 33.6
General and administrative | 119.4 | 37.7 | 152.4
Restructuring costs | — | — | 4.6
Total costs and expenses | 159.6 | 52.2 | 229.8
Operating income (loss) | (59.6) | 47.8 | (129.8)
Interest and other income | 5.0 | 1.7 | 1.0
Other expense | 0.2 | (0.2) | 0.9
Income (loss) before provision for income taxes | (54.4) | 49.3 | (127.9)
Provision for income taxes | (1.3) | (0.4) | (1.4)
Net income (loss) | (55.7)% | 48.9 % | (129.3)%


Question: What led to $74.4 million decrease in net income?
Answer: the $75.0 million decrease in total revenue partially offset by a $0.5 million decrease in cost and operating expenses for 2019 compared to 2018.
Vesting of Equity Awards During 2019
The following table provides details regarding the equity awards held by our named executives that vested during 2019. Restricted stock and restricted stock units were the only equity awards held by our named executives during 2019.
(1) Represents both time-vested and performance-based equity awards that vested during 2019. For details on the payout of our performance-based equity awards, please see “Compensation Discussion and Analysis—Our 2019 Compensation Program and Components of Pay—Grants of Long Term Incentive Compensation—Long Term Incentive Performance Updates” and “—Our Compensation Philosophy Objectives and Linkage to Corporate Strategy—Overview of Pay Elements and Linkage to Compensation Philosophy and Corporate Strategy.”
(2) Based on the closing trading price of the Common Shares on the applicable vesting date.
Table:
 | Stock Vested During 2019 | 
Name | Number of Shares Acquired on Vesting(1) | Value Realized on Vesting(2)
Mr. Storey | 1,063,929 | $13,479,617
Mr. Dev | 55,490 | 749,737
Mr. Goff | 114,167 | 1,338,934
Mr. Trezise | 71,576 | 812,600
Mr. Andrews | 16,678 | 221,859


Question: What is the difference in the value realized on vesting between Mr. Trezise and Mr. Dev? 
Answer: 62863
Calculation: $812,600-$749,737
In the following table, we provide information regarding our common stock repurchases under our publicly-announced share repurchase program for the quarter ended December 31, 2019. All repurchases related to the share repurchase program were made on
the open market.
During the year ended December 31, 2019, we repurchased a total of 1,640,055 shares at an average price per share of $70.65 under our publicly-announced share repurchase program. In January 2020, our Board of Directors authorized the Company to repurchase up to an aggregate of $50 million of the Company’s common stock.
Table:
Period | Total number of Shares Purchased | Average Price Paid per Share | Total Number of Shares Purchased as Part of Publicly Announced Plans or Programs | Maximum Number (or Approximate Dollar Value) of Shares that May Yet Be Purchased Under the Plans or Programs
October 1 - October 31, 2019 | 13,425 | $78.21 | 13,425 | $48,950,059
November 1 - November 30, 2019 | 245,454 | 76.95 | 245,454 | 30,062,919
December 1 - December 31, 2019 | 185,973 | 80.95 | 185,973 | 15,008,242
Total | 444,852 |  | 444,852 | 


Question: Which period has the highest total number of shares purchased?
Answer: November 1 - November 30, 2019
Calculation: 245,454> 185,973> 13,425
Option Exercises and Stock Vested
The table below sets forth information concerning the number of shares acquired on exercise of option awards and vesting of stock awards in 2019 and the value realized upon vesting by such officers.
(1) Amounts realized from the vesting of stock awards are calculated by multiplying the number of shares that vested by the fair market value of a share of our common stock on the vesting date.
Table:
 | Option Awards |  | Stock Awards | 
Name | Number of Shares Acquired on Exercise (#) | Value Realized on Exercise ($) | Number of Shares Acquired on Vesting (#) | Value Realized on Vesting ($)
Jon Kirchner | — | — | 153,090 | 3,428,285
Robert Andersen | — | — | 24,500 | 578,806
Paul Davis | — | — | 20,500 | 482,680
Murali Dharan | — | — | 15,000 | 330,120
Geir Skaaden | — | — | 21,100 | 500,804


Question: What is the average number of shares that the officers acquired on vesting?
Answer: 46838
Calculation: (153,090+24,500+20,500+15,000+21,100)/5
LIQUIDITY AND CAPITAL RESOURCES
The Company’s cash and cash equivalents increased to $93,628 at June 30, 2019 from $31,440 at June 30, 2018. Cash at the end of fiscal 2018 was lower due primarily to the acquisition of Ensenta and higher repayment of debt in fiscal 2018.
The following table summarizes net cash from operating activities in the statement of cash flows:
Cash provided by operating activities increased 5% compared to fiscal 2018. Cash from operations is primarily used to repay debt, pay dividends and repurchase stock, and for capital expenditures.
Table:
 | Year Ended | 
 | June 30 | 
 | 2019 | 2018
Net income | $271,885 | $365,034
Non-cash expenses | 180,987 | 87,906
Change in receivables | (11,777) | 21,489
Change in deferred revenue | 23,656 | 1,255
Change in other assets and liabilities | (33,623) | (63,542)
Net cash provided by operating activities | $431,128 | $412,142


Question: What is the average net cash provided by operating activities for 2018 and 2019?
Answer: 421635
Calculation: ($431,128+$412,142)/2