hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Billings
Group reported billings decreased by $8.3 million or 1.1 per cent to $760.3 million in the year-ended 31 March 2019. This represented a 0.1 per cent decrease on a constant currency (“CC”) basis.
Billings by region
Americas Billings attributable to the Americas decreased by $2.2 million to $267.8 million in the period, representing a 0.8 per cent reduction on a reported basis and 0.7 per cent on a constant currency basis; this decrease largely driven by a decline in Enduser products due to the stronger performance in the prior-year compare as a consequence of the impact of the WannaCry ransomware outbreak and the launch of Intercept X, the Group’s next-gen endpoint product, partially offset by an improved performance in UTM sales.
EMEA Billings attributable to EMEA increased by $0.2 million to $395.3 million in the period, representing 0.1 per cent growth on a reported basis and 0.9 per cent growth on a constant currency basis. An increase in sales of Server products being partially offset by a reduction in endpoint and email products.
APJ Billings attributable to APJ decreased by $6.3 million to $97.2 million in the period, representing 6.1 per cent on a reported basis and 2.8 per cent on a constant currency basis. As in the Americas, growth was negatively impacted by the stronger performance in the prior-year compare compounded by a legacy Network product transition in the first-half of the year partially offset by an improvement in sales of Server products.
Table:
 | FY19 | FY18 | Growth % | Growth %
 | $m (Reported) | $m (Reported) | (Reported) | (CC)
Billings by Region: |  |  |  | 
- Americas | 267.8 | 270.0 | (0.8) | (0.7)
- EMEA | 395.3 | 395.1 | 0.1 | 0.9
- APJ | 97.2 | 103.5 | (6.1) | (2.8)
 | 760.3 | 768.6 | (1.1) | (0.1)
Billings by Product: |  |  |  | 
– Network | 345.9 | 353.4 | (2.1) | (1.1)
– Enduser | 377.1 | 383.2 | (1.6) | (0.7)
– Other | 37.3 | 32.0 | 16.6 | 17.1
 | 760.3 | 768.6 | (1.1) | (0.1)
Billings by Type: |  |  |  | 
– Subscription | 644.6 | 644.2 | 0.1 | 1.0
– Hardware | 105.7 | 113.7 | (7.0) | (6.1)
– Other | 10.0 | 10.7 | (6.5) | (4.6)
 | 760.3 | 768.6 | (1.1) | (0.1)


Question: What was the average amount of Billings in 2018 and 2019?
Answer: 764.45
Calculation: (760.3+768.6)/2
Disaggregation of Revenue
The tables below present the Company’s revenue disaggregated by type of revenue. Refer to Note 13, Reportable Segment Information, for disaggregated revenue by type and reportable segment. The majority of the Company’s revenue is earned domestically, with revenue from customers outside the United States comprising less than 1% of total revenue.
Table:
 | Year Ended June 30, |  | 
 | 2019 | 2018 | 2017
Processing | $594,202 | $550,058 | $506,555
Outsourcing & Cloud | 405,359 | 361,922 | 327,738
Product Delivery & Services | 231,982 | 251,743 | 256,794
In-House Support | 321,148 | 307,074 | 297,203
Services & Support | 958,489 | 920,739 | $881,735
Total Revenue | $1,552,691 | $1,470,797 | $1,388,290


Question: What is the average outsourcing & cloud revenue for 2018 and 2019?
Answer: 383640.5
Calculation: (405,359+361,922)/2
Other loss
In May 2019, the Company completed a cash tender offer and purchased $460.9 million in aggregate principal amount of the 2020 Notes and issued $250.0 million in aggregate principal amount of 9.25% senior secured notes at par due November 2022. The Company recognized a loss of $10.6 million on the purchase of the 2020 Notes for the year ended December 31, 2019 (see Note 9).
During September 2019, Teekay LNG refinanced the Torben Spirit by acquiring the Torben Spirit from its original Lessor and then selling the vessel to another Lessor and leasing it back for a period of 7.5 years. As a result of this refinancing transaction, the Partnership recognized a loss of $1.4 million for the year ended December 31, 2019 on the extinguishment of the original finance lease (see Note 11).
Following the termination of the finance lease arrangements for the RasGas II LNG Carriers in 2014, the lessor made a determination that additional rentals were due under the leases following a challenge by the UK taxing authority. As a result, in 2017 the Teekay Nakilat Joint Venture recognized an additional liability, which was included as part of other loss in the Company's consolidated statements of loss.
Related to settlements and accruals made prior to September 2017 as a result of claims and potential claims made against Logitel Offshore Holding AS (or Logitel), a company acquired by Altera in 2014. Altera was deconsolidated in September 2017 (see Note 4).
Table:
 | Year Ended | Year Ended | Year Ended
 | December 31, | December 31, | December 31,
 | 2019 | 2018 | 2017
 | $ | $ | $
Loss on bond repurchases (1) | (10,601) | (1,772) | —
Loss on lease extinguishment (2) | (1,417) | — | —
Tax indemnification guarantee liability (3) | — | (600) | (50,000)
Contingent liability (4) | — | — | (4,500)
Gain on sale / (write-down) of cost-accounted investment | — | — | 1,250
Miscellaneous (loss) income | (2,457) | 359 | (731)
Other loss | (14,475) | (2,013) | (53,981)


Question: What is the increase / (decrease) in Other loss from 2018 to 2019?
Answer: -12462
Calculation: -14,475 - (-2,013)
16. Earnings Per Share
The weighted-average number of shares outstanding used in the computations of basic and diluted earnings per share were as follows:
Table:
 |  | Fiscal | 
 | 2019 | 2018 | 2017
 |  | (in millions) | 
Basic | 338 | 350 | 355
Dilutive impact of share-based compensation arrangements | 2 | 3 | 3
Diluted | 340 | 353 | 358


Question: In which years was the basic earnings per share calculated for?
Answer: 2019, 2018, 2017
Seasonality
The Company’s sales, income and cash flow from operations vary between quarters, and are generally lowest in the first quarter of the from operations vary between quarters, and are generally lowest in the first quarter of the year and highest in the fourth quarter. This is mainly a result of the seasonal purchase patterns of network operators.
Table:
Most recent three-year average seasonality |  |  |  | 
 | First quarter | Second quarter | Third quarter | Fourth quarter
Sequential change, sales | -25% | 11% | 4% | 17%
Share of annual sales | 22% | 24% | 25% | 29%


Question: Which quarter has lowest in sales, income and cash flow from operations?
Answer: First quarter
The following table disaggregates our revenue by major source for the year ended December 31, 2018:
(1) Subscriber Solutions & Experience was formerly reported as Customer Devices. With the increasing focus on enhancing the customer experience for both our business and consumer broadband customers and the addition of SmartRG during the fourth quarter of 2018, Subscriber Solutions & Experience more accurately represents this revenue category.
Table:
(In thousands) | Network Solutions | Services & Support | Total
Access & Aggregation | $301,801 | $57,069 | $358,870
Subscriber Solutions & Experience (1) | 129,067 | 5,393 | 134,460
Traditional & Other Products | 27,364 | 8,583 | 35,947
Total | $458,232 | $71,045 | $529,277


Question: What was the difference between the total revenue from Subscriber Solutions & Experience and Traditional & Other Products?
Answer: 98513
Calculation: 134,460-35,947
30. EMPLOYEE BENEFIT PLANS (cont.)
The fair value of the plan assets were allocated as follows between the various types of investments:
Plan assets are valued at the measurement date of December 31 each year.
The investments are made in accordance with the Statement of Investment Policies and Procedures. The Statement of Investment Policies and Procedures is reviewed on an annual basis by the Management Level Pension Fund Investment Committee with approval of the policy being provided by the Audit Committee.
Table:
As at December 31, | 2019 | 2018
Equity securities |  | 
Canada | 22.3% | 20.8%
United States | 19.8% | 12.7%
International (other than United States) | 14.1% | 18.1%
Fixed income instruments |  | 
Canada | 41.2% | 45.7%
Cash and cash equivalents |  | 
Canada | 2.6% | 2.7%


Question: When are the plan assets valued each year?
Answer: December 31 each year
In 2019, Global Financing delivered external revenue of $1,400 million and total revenue of $2,632 million, with a decrease in gross margin of 2.7 points to 58.8 percent. Total pre-tax income of $1,055 million decreased 22.5 percent compared to 2018 and return on equity decreased 5.0 points to 25.8 percent.
Global Financing total revenue decreased 17.8 percent compared to the prior year. This was due to a decrease in internal revenue of 23.5 percent, driven by decreases in internal used equipment sales (down 27.4 percent to $862 million) and internal financing (down 12.6 percent to $370 million). External revenue declined 11.9 percent due to decreases in external financing (down 8.5 percent to $1,120 million) and external used equipment sales (down 23.4 percent to $281 million).
The decrease in internal financing revenue was due to lower average asset balances, partially offset by higher asset yields. The decrease in external financing revenue reflects the wind down of the OEM IT commercial financing operations.
Sales of used equipment represented 43.4 percent and 48.5 percent of Global Financing’s revenue for the years ended December 31, 2019 and 2018, respectively. The decrease in 2019 was due to a lower volume of internal used equipment sales. The gross profit margin on used sales was 52.2 percent and 54.2 percent for the years ended December 31, 2019 and 2018, respectively. The decrease in the gross profit margin was driven by lower margins on internal used equipment sales.
Global Financing pre-tax income decreased 22.5 percent year to year primarily driven by a decrease in gross profit ($422 million), partially offset by a decrease in total expense ($115 million), which was mainly driven by a decline in IBM shared expenses in line with the segment’s performance, a lower provision for credit losses and a gain from the sale of certain commercial financing capabilities in the first quarter of 2019.
The decrease in return on equity from 2018 to 2019 was primarily due to lower net income. Refer to page 45 for the details of the after-tax income and return on equity calculations.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2019 | 2018 | Yr.-to-Yr. Percent Change
External revenue | $1,400 | $1,590 | (11.9) %
Internal revenue | 1,232 | 1,610 | (23.5)
Total revenue | $2,632 | $3,200 | (17.8) %
Pre-tax income | $1,055 | $1,361 | (22.5) %


Question: What caused the Global Financing total revenue to decrease?
Answer: This was due to a decrease in internal revenue of 23.5 percent, driven by decreases in internal used equipment sales (down 27.4 percent to $862 million) and internal financing (down 12.6 percent to $370 million).
11 Intangible assets
(a) Intangible assets
RIGHTS AND LICENCES
Certain licences that NEXTDC possesses have an indefinite useful life and are carried at cost less impairment losses and are subject to impairment review at least annually and whenever there is an indication that it may be impaired.
Other licences that NEXTDC acquires are carried at cost less accumulated amortisation and accumulated impairment losses. Amortisation is recognised on a straight-line basis over the estimated useful life. The estimated useful life and amortisation method are reviewed at the end of each annual reporting period.
INTERNALLY GENERATED SOFTWARE
Internally developed software is capitalised at cost less accumulated amortisation. Amortisation is calculated using the straight-line basis over the asset’s useful economic life which is generally two to three years. Their useful lives and potential impairment are reviewed at the end of each financial year.
SOFTWARE UNDER DEVELOPMENT
Costs incurred in developing products or systems and costs incurred in acquiring software and licenses that will contribute to future period financial benefits through revenue generation and/or cost reduction are capitalised to software and systems. Costs capitalised include external direct costs of materials and services and employee costs.
Assets in the course of construction include only those costs directly attributable to the development phase and are only recognised following completion of technical feasibility and where the Group has an intention and ability to use the asset.
Table:
 | 30 June 2019 | 30 June 2018
 | $'000 | $'000
Rights and licences | 13 | 13
Internally generated software | 7,381 | 6,385
Software under development | 16,284 | 6,509
Total intangible assets | 23,678 | 12,907


Question: What was the value of Rights and licences in 2019 and 2018 respectively?
Answer: 13, 13
FNF
We are party to certain agreements with FNF, including agreements that were entered into when we were related parties. As a result of the Distribution, FNF no longer has an ownership interest in us, but was still considered a related party until December 1, 2019 due to the combination of certain shared board members, members of senior management and various agreements. As of December 1, 2019, the Chairman of our Board of Directors no longer serves as one of our executive officers, and FNF is no longer considered a related party.
We have various agreements with FNF to provide software, data and analytics services, as well as corporate shared services and information technology. We are also a party to certain other agreements under which we incur other expenses or receive revenues from FNF.
A detail of the revenues and expenses, net from FNF is as follows (in millions):
(1) Transactions with FNF are summarized through November 30, 2019, the date after which FNF is no longer considered a related party.
We paid to FNF a guarantee fee of 1.0% of the outstanding principal of the Senior Notes (as defined in Note 12 — Long Term Debt) in exchange for the guarantee by FNF of the Senior Notes. For the year ended December 31, 2017, the guarantee fee was included in Interest expense, net on the Consolidated Statements of Earnings and Comprehensive Earnings. On April 26, 2017, the Senior Notes were redeemed, and we are no longer required to pay a guarantee fee.
Table:
 |  | Year ended December 31, | 
 | 2019 (1) | 2018 | 2017
Revenues | $59.5 | $57.6 | $56.8
Operating expenses | 12.5 | 12.1 | 12.3
Guarantee fee | — | — | 1.2


Question: What does the company's agreements with FNF entail the provision of?
Answer: software, data and analytics services, as well as corporate shared services and information technology.
Restricted Stock and Restricted Stock Units ("Restricted Stock Awards")
As of August 29, 2019, there were 16 million shares of Restricted Stock Awards outstanding, 14 million of which contained only service conditions. For service-based Restricted Stock Awards, restrictions generally lapse in one-fourth or one-third increments during each year of employment after the grant date. Restrictions lapse on Restricted Stock granted in 2019 with performance or market conditions over a three-year period if conditions are met. At the end of the performance period, the number of actual shares to be awarded will vary between 0% and 200% of target amounts, depending upon the achievement level. Restricted Stock Awards activity for 2019 is summarized as follows:
Table:
 | Number of Shares | Weighted-Average Grant Date Fair Value Per Share
Outstanding as of August 30, 2018 | 15 | $25.18
Granted | 9 | 41.11
Restrictions lapsed | (6) | 24.22
Canceled | (2) | 24.79
Outstanding as of August 29, 2019 | 16 | 34.72


Question: What is the total price of granted and restrictions lapsed stocks?
Answer: 224.67
Calculation: (9*41.11)+(-6*24.22)
16. Earnings Per Share
The weighted-average number of shares outstanding used in the computations of basic and diluted earnings per share were as follows:
Table:
 |  | Fiscal | 
 | 2019 | 2018 | 2017
 |  | (in millions) | 
Basic | 338 | 350 | 355
Dilutive impact of share-based compensation arrangements | 2 | 3 | 3
Diluted | 340 | 353 | 358


Question: What was the change in Dilutive impact of share-based compensation arrangements in 2019 from 2018?
Answer: -1
Calculation: 2-3
11 Intangible assets
(a) Intangible assets
RIGHTS AND LICENCES
Certain licences that NEXTDC possesses have an indefinite useful life and are carried at cost less impairment losses and are subject to impairment review at least annually and whenever there is an indication that it may be impaired.
Other licences that NEXTDC acquires are carried at cost less accumulated amortisation and accumulated impairment losses. Amortisation is recognised on a straight-line basis over the estimated useful life. The estimated useful life and amortisation method are reviewed at the end of each annual reporting period.
INTERNALLY GENERATED SOFTWARE
Internally developed software is capitalised at cost less accumulated amortisation. Amortisation is calculated using the straight-line basis over the asset’s useful economic life which is generally two to three years. Their useful lives and potential impairment are reviewed at the end of each financial year.
SOFTWARE UNDER DEVELOPMENT
Costs incurred in developing products or systems and costs incurred in acquiring software and licenses that will contribute to future period financial benefits through revenue generation and/or cost reduction are capitalised to software and systems. Costs capitalised include external direct costs of materials and services and employee costs.
Assets in the course of construction include only those costs directly attributable to the development phase and are only recognised following completion of technical feasibility and where the Group has an intention and ability to use the asset.
Table:
 | 30 June 2019 | 30 June 2018
 | $'000 | $'000
Rights and licences | 13 | 13
Internally generated software | 7,381 | 6,385
Software under development | 16,284 | 6,509
Total intangible assets | 23,678 | 12,907


Question: What was the percentage change in rights and licences between 2018 and 2019?
Answer: 0
Calculation: (13 - 13) / 13
Capital reserve and reserves retained from earnings
Prior to the effective date of the reclassification and demerger of CECONOMY AG on 12 July 2017, METRO AG was not yet a group within the meaning of IFRS 10. Accordingly, combined financial statements of METRO Wholesale & Food Specialist GROUP (hereinafter: MWFS GROUP) were prepared for the IPO prospectus of METRO AG. Equity in the combined financial statements was the residual amount from the combined assets and liabilities of MWFS GROUP. Following the demerger, METRO became an independent group with METRO AG as the listed parent company. Therefore, the equity in the consolidated financial statements is subdivided according to legal requirements. The subscribed capital of €363 million and the capital reserve of €6,118 million were recognised at the carrying amounts from the METRO AG Annual Financial Statements as of 30 September 2017. For this purpose, a transfer was made from the equity item net assets, recognised as of 1 October 2016, attributable to the former METRO GROUP of the combined financial statements of MWFS GROUP. The remaining negative amount of this equity item was reclassified to reserves retained from earnings. It cannot be traced back to a history of loss.
Reserves retained from earnings can be broken down as follows:
1 Previous year: gains/losses on remeasuring financial instruments in the category ‘available for sale’.
2 Adjustment of previous year according to explanation in notes.
Table:
€ million | 30/9/2018 | 30/9/2019
Effective portion of gains/losses from cash flow hedges | 0 | 2
Equity and debt instruments1 | 9 | −3
Currency translation differences from translating the financial statements of foreign operations | −738 | −602
Remeasurement of defined benefit pension plans | −410 | −500
Income tax on components of other comprehensive income | 91 | 106
Other reserves retained from earnings | −2,401 2 | −2,782
 | −3,449 | −3,778


Question: What did the amount of equity and debt instruments in the previous year relate to?
Answer: gains/losses on remeasuring financial instruments in the category ‘available for sale’
b) Transactions with Golar Power and affiliates:
Net revenues: The transactions with Golar Power and its affiliates for the twelve months ended December 31, 2019, 2018 and 2017 consisted of the following:
(i) Debt guarantee compensation - In connection with the closing of the Golar Power and Stonepeak transaction, Golar Power entered into agreements to compensate Golar in relation to certain debt guarantees (as further described under the subheading "Guarantees and other") relating to Golar Power and subsidiaries.
(ii) Balances due to Golar Power and affiliates - Receivables and payables with Golar Power and its subsidiaries are comprised primarily of unpaid management fees, advisory and administrative services. In addition, certain receivables and payables arise when we pay an invoice on behalf of a related party and vice versa. Receivables and payables are generally settled quarterly in arrears. Balances owing to or due from Golar Power and its subsidiaries are unsecured, interest-free and intended to be settled in the ordinary course of business. In December 2019, we loaned $7.0 million to Golar Power, with interest of LIBOR plus 5.0%. The loan was fully repaid, including interest, in December 2019.
Table:
(in thousands of $) | 2019 | 2018 | 2017
Management and administrative services revenue | 5,904 | 6,167 | 5,711
Ship management fees income | 1,210 | 1,400 | 824
Debt guarantee compensation (i) | 693 | 861 | 775
Other (ii) | (2) | (247) | 135
Total | 7,805 | 8,181 | 7,445


Question: What was the percentage change in total transactions from 2018 to 2019?
Answer: -4.6
Calculation: (7,805 - 8,181)/8,181
(5) Revenue Recognition
The following tables present our reported results under ASC 606 and a reconciliation to results using the historical accounting method:
Table:
 |  | Year Ended December 31, 2018 | 
 | Reported Balances | Impact of ASC 606 | ASC 605 Historical Adjusted Balances
 |  | (Dollars in millions, except per share amounts and shares in thousands) | 
Operating revenue | $23,443 | 39 | 23,482
Cost of services and products (exclusive of depreciation and amortization) | 10,862 | 22 | 10,884
Selling,general and administrative | 4,165 | 71 | 4,236
Interest expense | 2,177 | (9) | 2,168
Income tax expense | 170 | (12) | 158
Net loss | (1,733) | (33) | (1,766)
BASIC AND DILUTED LOSS PER COMMON SHARE |  |  | 
BASIC | $(1.63) | (0.03) | (1.66)
DILUTED | $(1.63) | (0.03) | (1.66)
WEIGHTED-AVERAGE COMMON SHARES OUTSTANDING |  |  | 
BASIC | 1,065,866 | - | 1,065,866
DILUTED | 1,065,866 | - | 1,065,866


Question: What is the Reported Balances operating revenue?
Answer: $23,443
RSUs/PSUs
RSUs/PSUs are granted to executives and other eligible employees. The value of an RSU/PSU at the grant date is equal to the value of one BCE common share. Dividends in the form of additional RSUs/PSUs are credited to the participant’s account on each dividend payment date and are equivalent in value to the dividend paid on BCE common shares. Executives and other eligible employees are granted a specific number of RSUs/PSUs for a given performance period based on their position and level of contribution. RSUs/PSUs vest fully after three years of continuous employment from the date of grant and, in certain cases, if performance objectives are met, as determined by the board of directors.
The following table summarizes outstanding RSUs/PSUs at December 31, 2019 and 2018.
(1) The weighted average fair value of the RSUs/PSUs granted was $58 in 2019 and $57 in 2018
(2) The RSUs/PSUs vested on December 31, 2019 were fully settled in February 2020 with BCE common shares and/or DSUs.
Table:
NUMBER OF RSUs/PSUs | 2019 | 2018
Outstanding, January 1 | 2,812,697 | 2,740,392
Granted (1) | 975,348 | 1,006,586
Dividends credited | 149,648 | 149,258
Settled | (932,133) | (1,027,321)
Forfeited | (90,442) | (56,218)
Outstanding, December 31 | 2,915,118 | 2,812,697
Vested, December 31 (2) | 904,266 | 880,903


Question: What is the weighted average fair value of the RSUs/PSUs granted in 2019?
Answer: $58