hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Disaggregation of Revenue
The following table presents the Company's revenue disaggregated by major product category (amounts in thousands):
Software and hardware revenue is generated from on premise software license sales, as well as sales of hardware scanner boxes and on premise appliance products. Service and other revenue is generated from the sale of transactional SaaS products and services, maintenance associated with the sale of software and hardware, and consulting and professional services.
Table:
 |  | Twelve Months Ended September 30, | 
 | 2019 | 2018 | 2017
Major product category |  |  | 
Deposits software and hardware | $41,860 | $33,071 | $25,407
Deposits service and other | 15,170 | 8,437 | 6,963
Deposits revenue | 57,030 | 41,508 | 32,370
Identity verification software and hardware | 4,985 | 7,627 | 4,240
Identity verification service and other | 22,575 | 14,424 | 8,780
Identity verification revenue | 27,560 | 22,051 | 13,020
Total revenue | $84,590 | $63,559 | $45,390


Question: Which year had the greatest amount of total revenue?
Answer: 2019
Calculation: 84,590> 63,559> 45,390
Trading profit
The Group reported Trading profit of £128.5m in the year, growth of £5.5m, up +4.5% compared to 2017/18. Divisional contribution increased by £6.1m to £161.9m. The Grocery business recorded Divisional contribution growth of £8.3m to £138.3m while Sweet Treats Divisional contribution was £2.2m lower than the prior year at £23.6m. Group & corporate costs were £0.6m higher than the prior year.
In the first half of the year, Grocery Divisional contribution benefitted from previous changes in the promotional strategy of Ambrosia. The business reduced the depth of promotional deals it offered which resulted in lower volumes and revenue in the period but growth in Divisional contribution.
Additionally, Divisional contribution margins in the Grocery business grew 2.1 percentage points in the first half compared to the prior year. This is in line with margins two years ago, whereby margins in the prior year were impacted by a longer than expected process to recover input cost inflation seen across the Group’s categories.
Table:
£m | 2018/19 | 2017/18 | Change
Divisional contribution2 |  |  | 
Grocery | 138.3 | 130.0 | +6.3%
Sweet Treats | 23.6 | 25.8 | (8.4%)
Total | 161.9 | 155.8 | +3.9%
Group & corporate costs | (33.4) | (32.8) | (1.8%)
Trading profit | 128.5 | 123.0 | +4.5%


Question: How much was the growth in trading profit in the year 2018/19?
Answer: growth of £5.5m
Unrecognized Tax Benefits
The aggregate changes in the balance of gross unrecognized tax benefits were as follows (in millions):
As of July 27, 2019, $1.7 billion of the unrecognized tax benefits would affect the effective tax rate if realized. During fiscal 2019, we recognized $30 million of net interest expense and $6 million of penalty expense. During fiscal 2018, we recognized $10 million of net interest expense and no net penalty expense. During fiscal 2017, we recognized $26 million of net interest expense and a $4 million reduction in penalties. Our total accrual for interest and penalties was $220 million, $180 million, and $186 million as of the end of fiscal 2019, 2018, and 2017, respectively. We are no longer subject to U.S. federal income tax audit for returns covering tax years through fiscal 2010. We are no longer subject to foreign or state income tax audits for returns covering tax years through fiscal 1999 and fiscal 2008, respectively.
We regularly engage in discussions and negotiations with tax authorities regarding tax matters in various jurisdictions. We believe it is reasonably possible that certain federal, foreign, and state tax matters may be concluded in the next 12 months. Specific positions that may be resolved include issues involving transfer pricing and various other matters. We estimate that the unrecognized tax benefits at July 27, 2019 could be reduced by $50 million in the next 12 months.
Table:
Years Ended | July 27, 2019 | July 28, 2018 | July 29, 2017
Beginning balance | $2,000 | $1,973 | $1,627
Additions based on tax positions related to the current year | 185 | 251 | 336
Additions for tax positions of prior years | 84 | 84 | 180
Reductions for tax positions of prior years . | (283) | (129) | (78)
Settlements | (38) | (124) | (43)
Lapse of statute of limitations . | (23) | (55) | (49)
Ending balance . | $ 1,925 | $ 2,000 | $ 1,973


Question: How many years did Additions for tax positions of prior years exceed $100 million?
Answer: 1
Calculation: 2017
Results of Operations
(2) Operating expenses include stock-based compensation expense as follows (in thousands):
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Stock-based compensation expense data: |  |  | 
Sales and marketing | $2,075 | $1,196 | $561
General and administrative | 6,474 | 4,901 | 2,638
Research and development | 12,054 | 7,332 | 4,214
Total stock-based compensation expense | $20,603 | $13,429 | $7,413


Question: What was the change in sales and marketing between 2017 and 2018?
Answer: 635
Calculation: 1,196-561
19. Cash and cash equivalents
Cash at bank and in hand is denominated in the following currencies:
Cash balances with an original maturity of less than three months were held in current accounts during the year and attracted interest at a weighted average rate of 0.3% (2018: 0.3%).
Table:
 | 2019 | 2018
 | £m | £m
Sterling | 5.8 | 4.1
Euro | 0.1 | 0.2
Cash at bank and in hand | 5.9 | 4.3


Question: Where were cash balances with an original maturity of less than three months held in?
Answer: held in current accounts during the year
Segment Financial Results
Revenues
The following table sets forth revenues by segment for the periods presented (in millions):
(1) Revenues for Corporate and Other represent deferred revenue purchase accounting adjustments recorded in accordance with GAAP.
Software Solutions
Revenues were $962.0 million in 2018 compared to $904.5 million in 2017, an increase of $57.5 million, or 6%. Our servicing software solutions revenues increased 7%, or $52.5 million, primarily driven by loan growth on MSP® from new and existing  clients. Our origination software solutions revenues increased 3%, or $5.0 million, primarily driven by growth in our loan origination system solutions and a software license fee in our Lending Solutions business, partially offset by the effect of lower volumes on our Exchange and eLending platforms primarily as a result of the 26% decline in refinancing originations as reported by the Mortgage Bankers Association.
Data and Analytics
Revenues were $154.5 million in 2018 compared to $151.6 million in 2017, an increase of $2.9 million, or 2%. The increase was primarily driven by growth in our property data and multiple listing service businesses, partially offset by upfront revenues from long-term strategic license deals in 2017.
Table:
 | Year ended December 31 |  | Variance | 
 | 2018 | 2017 | $ | %
Software Solutions | $962.0 | $904.5 | $57.5 | 6%
Data and Analytics | 154.5 | 151.6 | 2.9 | 2%
Corporate and Other(1) | (2.5) | (4.5) | 2.0 | NM
Total | $1,114.0 | $1,051.6 | $62.4 | 6%


Question: What was revenue from Data and Analytics in 2017?
Answer: 151.6
9. DEFERRED REVENUES
Deferred revenues consisted of the following:
Deferred cloud services and license support revenues and deferred hardware revenues substantially represent customer payments made in advance for cloud or support contracts that are typically billed in advance with corresponding revenues generally being recognized ratably over the contractual periods. Deferred services revenues include prepayments for our services business and revenues for these services are generally recognized as the services are performed. Deferred cloud license and on-premise license revenues typically resulted from customer payments that related to undelivered products and services or specified enhancements.
In connection with our acquisitions, we have estimated the fair values of the cloud services and license support performance obligations assumed from our acquired companies. We generally have estimated the fair values of these obligations assumed using a cost build-up approach. The cost build-up approach determines fair value by estimating the costs related to fulfilling the obligations plus a normal profit margin. The sum of the costs and operating profit approximates, in theory, the amount that we would be required to pay a third party to assume these acquired obligations. These aforementioned fair value adjustments recorded for obligations assumed from our acquisitions reduced the cloud services and license support deferred revenues balances that we recorded as liabilities from these acquisitions and also reduced the resulting revenues that we recognized or will recognize over the terms of the acquired obligations during the post-combination periods.
Table:
 |  | May 31,
(in millions) | 2019 | 2018
Cloud services and license support | $7,340 | $7,265
Hardware | 635 | 645
Services | 360 | 404
Cloud license and on-premise license | 39 | 27
Deferred revenues, current | 8,374 | 8,341
Deferred revenues, non-current (in other non-current liabilities) | 669 | 625
Total deferred revenues | $9,043 | $8,966


Question: What is the current deferred revenue in 2019 as a percentage of total deferred revenue?
Answer: 92.6
Calculation: 8,374/9,043
Contractual Obligations
The following table summarizes our contractual obligations as of November 29, 2019:
As of November 29, 2019, our Term Loan’s carrying value was $2.25 billion. At our election, the Term Loan will bear interest at either (i) the London Interbank Offered Rate (“LIBOR”) plus a margin, based on our debt ratings, ranging from 0.500% to 1.000% or (ii) a base rate plus a margin, based on our debt ratings, ranging from 0.040% to 0.110%. Interest is payable periodically, in arrears, at the end of each interest period we elect. Based on the LIBOR rate at November 29, 2019, our estimated maximum commitment for interest payments was $23.2 million for the remaining duration of the Term Loan.
As of November 29, 2019, the carrying value of our Notes payable was $1.89 billion. Interest on our Notes is payable semi-annually, in arrears on February 1 and August 1. At November 29, 2019, our maximum commitment for interest payments was $200.1 million for the remaining duration of our Notes.
Our Term Loan and Revolving Credit Agreement contain similar financial covenants requiring us not to exceed a maximum leverage ratio. As of November 29, 2019, we were in compliance with this covenant. We believe this covenant will not impact our credit or cash in the coming fiscal year or restrict our ability to execute our business plan. Our senior notes do not contain any financial covenants.
Under the terms of our Term Loan and Revolving Credit Agreement, we are not prohibited from paying cash dividends unless payment would trigger an event of default or if one currently exists. We do not anticipate paying any cash dividends in the foreseeable future.
Table:
(in millions) |  |  | Payment Due by Period |  | 
 | Total | Less than 1 year | 1-3 years | 3-5 years | More than 5 years
Term Loan and Notes, including interest | $4,373.3 | $3,227.0 | $65.0 | $65.0 | $1,016.3
Operating lease obligations, net | 711.5 | 88.7 | 158.0 | 126.9 | 337.9
Purchase obligations | 2,036.5 | 545.0 | 935.8 | 555.7 | —
Total | $7,121.3 | $3,860.7 | $1,158.8 | $747.6 | $1,354.2


Question: What is the carrying value of Notes payable as of November 29 2019?
Answer: $1.89
Notes to Consolidated Financial Statements - (Continued) Fiscal Years Ended May 26, 2019, May 27, 2018, and May 28, 2017 (columnar dollars in millions except per share amounts)  10. EARNINGS PER SHARE
Basic earnings per share is calculated on the basis of weighted average outstanding shares of common stock. Diluted earnings per share is computed on the basis of basic weighted average outstanding shares of common stock adjusted for the dilutive effect of stock options, restricted stock unit awards, and other dilutive securities. During the second quarter of fiscal 2019, we issued 77.5 million shares of our common stock out of treasury to the former shareholders of Pinnacle pursuant to the terms of the Merger Agreement. In addition, we issued 16.3 million shares of our common stock, par value $5.00 per share, in an underwritten public offering in connection with the financing of the Pinnacle acquisition, with net proceeds of $555.7 million (see Note 2).
The following table reconciles the income and average share amounts used to compute both basic and diluted earnings per share:
For fiscal 2019, 2018, and 2017, there were 2.0 million, 1.3 million, and 0.8 million stock options outstanding, respectively, that were excluded from the computation of diluted weighted average shares because the effect was antidilutive.
Table:
 | 2019 | 2018 | 2017
Net income available to Conagra Brands, Inc. common stockholders: |  |  | 
Income from continuing operations attributable to Conagra Brands, Inc. common stockholders | $680.2 | $794.1 | $544.1
Income (loss) from discontinued operations, net of tax, attributable to Conagra Brands, Inc. common stockholders | (1.9) | 14.3 | 95.2
Net income attributable to Conagra Brands, Inc. common stockholders | $678.3 | $808.4 | $639.3
Less: Increase in redemption value of noncontrolling interests in excess of earnings allocated | — | — | 0.8
Net income available to Conagra Brands, Inc. common stockholders | $678.3 | $808.4 | $638.5
Weighted average shares outstanding: |  |  | 
Basic weighted average shares outstanding | 444.0 | 403.9 | 431.9
Add: Dilutive effect of stock options, restricted stock unit awards, and other dilutive securities | 1.6 | 3.5 | 4.1
Diluted weighted average shares outstanding | 445.6 | 407.4 | 436.0


Question: How is diluted earnings per share computed?
Answer: on the basis of basic weighted average outstanding shares of common stock adjusted for the dilutive effect of stock options, restricted stock unit awards, and other dilutive securities
GasLog Ltd. and its Subsidiaries
Notes to the consolidated financial statements (Continued)
For the years ended December 31, 2017, 2018 and 2019
(All amounts expressed in thousands of U.S. Dollars, except share and per share data)
25. Capital Risk Management
The Group’s objectives when managing capital are to safeguard the Group’s ability to continue as a going concern, to ensure that it maintains a strong credit rating and healthy capital ratios in order to support its business and maximize shareholders value.
The Group monitors capital using a gearing ratio, which is total debt divided by total equity plus total debt. The gearing ratio is calculated as follows:
Table:
 | As of December 31, | 
 | 2018 | 2019
Borrowings, current portion | 520,550 | 255,422
Borrowings, non-current portion | 2,307,909 | 2,891,973
Lease liabilities, current portion | 6,675 | 9,363
Lease liabilities, non-current portion | 199,424 | 195,567
Total debt | 3,034,558 | 3,352,325
Total equity | 1,983,122 | 1,649,853
Total debt and equity | 5,017,680 | 5,002,178
Gearing ratio | 60.48% | 67.01%


Question: What are the components required to calculate gearing ratio?
Answer: Total debt, Total debt and equity
Sales and Marketing
Sales and marketing expenses in 2019 decreased by $7.6 million, or 32%, as compared to 2018. This decrease was primarily due to a reduction in the global sales support and marketing headcount, including reductions that were part of our restructuring activities during 2019 (refer to Note 4 of the accompanying consolidated financial statements), contributing to net decreases of $4.8 million in personnel-related costs, and $1.0 million in allocated facilities and information technology costs as compared to 2018. Restructuring costs in 2019 decreased $0.4 million, as there were additional restructuring activities in 2018, including a headcount reduction of approximately 13% of our workforce and the closure of certain leased facilities. The remaining decrease during 2019 was primarily the result of lower marketing costs of $0.6 million, as we eliminated or shifted the timing of certain of our marketing activities.
Table:
 | Years Ended December 31, |  | Change | 
 | 2019 | 2018 | $ | %
 | (dollars in thousands) |  |  | 
Sales and marketing | $15,836 | $23,425 | $(7,589) | (32)%
Percent of revenues, net | 32% | 40% |  | 


Question: What is the company's decrease in sales and marketing expenses between 2018 and 2019?
Answer: $7.6 million
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
NOTE 11. PROPERTY AND EQUIPMENT, NET
Property and equipment, net is comprised of the following:
Table:
 | December 31, | 
 | 2019 | 2018
Buildings and land | $1,693 | $1,737
Machinery and equipment | 108,945 | 41,330
Computer and communication equipment | 29,106 | 24,051
Furniture and fixtures | 4,119 | 3,203
Vehicles | 262 | 282
Leasehold improvements | 33,041 | 20,593
Construction in process | 9,089 | 867
 | 186,255 | 92,063
Less: Accumulated depreciation | (78,146) | (60,794)
Property and equipment, net | $108,109 | $31,269


Question: What are the three highest property and equipment components in 2018?
Answer: Machinery and equipment, Computer and communication equipment, Leasehold improvements
Calculation: Find the 3 largest values for Rows 3 to 9, COL4 and the corresponding component in COL2
Other payables and accrued liabilities consisted of the following:
Derivative instruments are further described in Note 27.
As of December 31, 2019, payables to equity-method investments was nil compared to $49 million as of December 31, 2018, as a result of the wind-down of the joint venture with Ericsson.
On January 1, 2019, the Company adopted the new guidance on lease accounting and the current portion of the lease obligation is now included in other payables and accrued liabilities. The impact of the adoption of this new guidance is further described in Note 11.
Other payables and accrued liabilities also include individually insignificant amounts as of December 31, 2019 and December 31, 2018, presented cumulatively in line “Others”.
Table:
 | December 31, 2019 | December 31, 2018
Employee related liabilities | 375 | 384
Employee compensated absences | 138 | 125
Taxes other than income taxes | 53 | 60
Advances | 63 | 77
Payables to equity-method investments | — | 49
Derivative instruments | 7 | 34
Provision for restructuring | 10 | 22
Defined benefit plans – current portion | 10 | 12
Defined contribution plans – accrued benefits | 20 | 18
Other long-term benefits – current portion | 7 | 6
Royalties | 21 | 26
Current lease obligation | 55 | —
Deferred consideration for business combinations | 10 | —
Others | 62 | 61
Total | 831 | 874


Question: What was the new guideline adopted by the company on January 1, 2019?
Answer: On January 1, 2019, the Company adopted the new guidance on lease accounting and the current portion of the lease obligation is now included in other payables and accrued liabilities.
Sales-Type Leases
We are the lessor in sales-type lease arrangements for network equipment, which have initial terms of up to five years. Our sales-type lease arrangements contain either a provision whereby the network equipment reverts back to us upon the expiration of the lease or a provision that allows the lessee to purchase the network equipment at a bargain purchase amount at the end of the lease. In addition, our sales-type lease arrangements do not contain any residual value guarantees or material restrictive covenants. The allocation of the consideration between lease and nonlease components is determined by stand-alone selling price by component. The net investment in sales-type leases consists of lease receivables less unearned income. Collectability of sales-type leases is evaluated periodically at an individual customer level. The Company has elected to exclude taxes related to sales-type leases from revenue and the associated expense of such taxes. As of December 31, 2019 and 2018, we did not have an allowance for credit losses for our net investment in sales-type leases. As of December 31, 2019 and 2018, the components of the net investment in sales-type leases were as follows:
(1) Included in other receivables on the Consolidated Balance Sheet.
(2) Included in other assets on the Consolidated Balance Sheet.
Table:
(In thousands) | December 31, 2019 | December 31, 2018
Current minimum lease payments receivable(1) | $1,201 | $11,339
Non-current minimum lease payments receivable(2) | 889 | 1,670
Total minimum lease payments receivable | 2,090 | 13,009
Less: Current unearned revenue(1) | 365 | 631
Less: Non-current unearned revenue(2) | 163 | 473
Net investment in sales-type leases | $1,562 | $11,905


Question: What was the difference in total minimum lease payments receivables between 2018 and 2019?
Answer: -10919
Calculation: 2,090-13,009
Our revenues for 2019 include $1.9 million related to the acquired MGI business. Our net loss for 2019 includes $0.3 million of net loss from the acquired MGI business. The following table provides unaudited pro forma information for the periods presented as if the MGI acquisition had occurred January 1, 2018.
No adjustments have been made in the pro forma information for synergies that are resulting or planned from the MGI acquisition. The unaudited proforma information is not indicative of the results that may have been achieved had the companies been combined as of January 1, 2018, or of our future operating results.
Table:
 | Year Ended December 31 | 
 | 2019 | 2018
Revenues (in thousands) | $ 224,913 | $ 17,542
Loss from continuing operations (in thousands) | $ (13,432) | $ ( 7,792)
Loss per share - continuing operations | $           (0.42) | $          ( 0.35)
Weighted average number of common shares outstanding - basic and diluted | 32,359,316 | 22,099,149


Question: What are the revenue and net loss for 2019?
Answer: $1.9 million, $0.3 million
Lockheed Martin Transaction
On August 16, 2016, a wholly-owned subsidiary of Leidos Holdings, Inc. merged with the IS&GS Business in a Reverse Morris Trust transaction (the "IS&GS Transactions").
During fiscal 2017, the Company recorded adjustments to finalize the fair value of acquired assets and liabilities assumed which resulted in a $337 million increase in goodwill. Significant changes included intangible assets, property, plant and equipment, deferred tax assets, other assets, accounts payable and accrued liabilities and deferred tax liabilities.
On January 10, 2018, the final amount of the net working capital of the IS&GS Business was determined through a binding arbitration proceeding in accordance with the Separation Agreement with Lockheed Martin. As a result, $24 million was recorded as acquisition costs in the consolidated statements of income for fiscal 2017. On January 18, 2018, the final working capital amount of $105 million was paid to Lockheed Martin, of which $24 million and $81 million was presented as cash flows from operating and investing activities, respectively, on the consolidated statements of cash flows.
During fiscal 2018, a tax indemnification liability of $23 million was paid to Lockheed Martin in accordance with the Tax Matters Agreement, which was presented as cash flows from financing activities on the consolidated statements of cash flows.
The Company incurred the following expenses related to the acquisition and integration of the IS&GS Business:
These acquisition and integration costs have been recorded within Corporate and presented in "Acquisition, integration and restructuring costs" on the consolidated statements of income.
Table:
 |  | Year Ended | 
 | January 3, 2020 | December 28, 2018 | December 29, 2017
 |  | (in millions) | 
Acquisition costs | $— | $— | $25
Integration costs | 3 | 29 | 77
Total acquisition and integration costs | $3 | $29 | $102


Question: What was the acquisition costs in the consolidated statements of income for fiscal 2017?
Answer: $24 million