hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
LONG-TERM DEBT
In addition to the Facility, the Company also had the following long-term obligations at fiscal 2019 and fiscal 2018.
Table:
 | 2019 | 2018
Note payable to a bank (“Real Estate Loan”), interest payable at a fixed rate of 2.99% with monthly installments of principal and interest of $38,344 through August 2021 with remaining principal due September 2021, collateralized by three distribution facilities | $ 2,263,040 | $  2,648,179
Note payable, interest payable at a fixed rate of 4.50% with quarterly installments of principal and interest of $49,114 through June 2023 with remaining principal due September 2023 | 1,395,351 | 1,476,772
Note payable, interest-free with varying installments during fiscal 2019 | — | 629,746
 | 3,658,391 | 4,754,697
Less current maturities | (532,747) | (1,096,306)
 | $3,125,644 | $3,658,391


Question: What are the respective values of the company's current maturities in 2018 and 2019?
Answer: 1,096,306, 532,747
The following is a reconciliation of the federal statutory income tax rate to the effective income tax rates reflected in the Consolidated Statements of Comprehensive Income for fiscal 2019, 2018 and 2017:
The effective tax rate for fiscal 2019 was lower than the effective tax rate for fiscal 2018 primarily due to the impact of the U.S. Tax Cuts and Jobs Act (“Tax Reform”) that was recorded in fiscal 2018. During fiscal 2019, the Company reasserted that certain historical undistributed earnings of two foreign subsidiaries will be permanently reinvested which provided a $10.5 million benefit to the effective tax rate. The impact of the changes in the Company's assertion has been included in "Withholding tax on dividends" in the effective income tax reconciliation above. The reduction to the effective tax rate compared to fiscal 2018 was offset by an increase due to the GILTI provisions of Tax Reform in fiscal 2019. The GILTI impact in the table above includes the deduction allowed by the regulations as well as the foreign tax credits attributed to GILTI. The Company has elected to treat the income tax effects of GILTI as a period cost. The effective tax rate for fiscal 2018 was higher than the effective tax rate for fiscal 2017 primarily due to expenses related to Tax Reform.
During fiscal 2019, the Company recorded a $1.9 million increase to its valuation allowance due to continuing losses in certain jurisdictions within the AMER and EMEA segments, partially offset by an expiration of net operating losses that had a valuation allowance recorded.
During fiscal 2018, the Company recorded a $32.9 million reduction to its valuation allowance which includes $9.7 million related to the U.S. federal tax rate change as part of Tax Reform from 35% to 21%, $21.0 million of carryforward credits and net operating losses utilized against the deemed repatriation of undistributed foreign earnings and $3.6 million for the release of the U.S. valuation allowance due to the expected future U.S. taxable income related to the GILTI provisions of Tax Reform. These benefits were partially offset by a $1.4 million increase in foreign valuation allowances in the EMEA segment.
During fiscal 2017, the Company recorded a $14.9 million addition to its valuation allowance relating to continuing losses in certain jurisdictions within the AMER and EMEA segments.
Table:
 | 2019 | 2018 | 2017
Federal statutory income tax rate | 21.0 % | 24.5 %  | 35.0 %
Increase (decrease) resulting from:       |  |  | 
Foreign tax rate differences | (21.0) | (30.2) | (39.9)
Withholding tax on dividends  | (5.4) | 23.7 | —
Permanent differences  | (1.3) | 0.8 | 3.0
Excess tax benefits related to share-based compensation  | (1.3) | (2.7) | (2.0)
Global intangible low-taxed income ("GILTI")  | 11.7 | — | —
Deemed repatriation tax  | 5.6 | 92.2 | —
Non-deductible compensation | 1.5 | 0.2 | 0.2
Valuation allowances  | 1.5 | (30.6) | 12.2
Rate changes  | — | 9.0 | —
Other, net  | 1.5 | 1.0 | (0.5)
Effective income tax rate | 13.8 %  | 87.9 %  | 8.0 %


Question: What was the foreign tax rate differences in 2017?
Answer: (39.9)
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: In which years was the transactions recorded for?
Answer: 2019, 2018, 2017
The Group has non-current borrowing facilities denominated in Australian Dollars (“AUD”) and New Zealand Dollars (“NZD”). All facilities are interest only facilities with any drawn balances payable at maturity. Drawn amounts and facility limits are as follows:
The major terms of these agreements are as follows: • Maturity dates on the facilities range from 23 July 2020 to 23 December 2026 (2018: 23 July 2019 to 23 December 2026). • The interest rate applied is the bank bill rate plus a margin depending on the gearing ratio. • Security has been granted over the Group's freehold investment properties.
The Group has a bank overdraft facility with a limit of $3m that was undrawn at 30 June 2019 and 30 June 2018. During the year ended 30 June 2019, the Group converted an existing AUD facility of $25m into an NZD facility of $25.75m, refinanced part of the existing debt facilities, and increased its club banking facilities by AUD $100m and NZD $50m (year ended 30 June 2018 facilities increased by $150m AUD and $25m NZD).
The Group have complied with the financial covenants of their borrowing facilities during the 2019 and 2018 reporting periods (see note 16). The fair value of borrowings approximates carrying value. Details of the exposure to risk arising from current and non-current borrowings are set out in note 15.
Table:
 | 2019 | 2018
 | $'000 | $'000
Bank finance facilities (AUD) |  | 
Drawn amount | 663,800 | 520,300
Facility limit | 680,000 | 605,000
Bank finance facilities (NZD) |  | 
Drawn amount | 192,250 | 87,500
Facility limit | 196,750 | 121,000
AUD equivalent of NZD facilities |  | 
Drawn amount | 184,038 | 80,048
Facility limit | 188,346 | 110,696


Question: What is the change in Bank finance facilities (AUD) Facility limit from 2018 to 2019?
Answer: 75000
Calculation: 680,000-605,000
11. Stock Award Plan
Total recognized stock-based compensation expense is included in our consolidated statements of operations as shown in the table below. Stock-based compensation expense includes both non-cash expense related to grants of stock-based awards as well as cash expense related to the employee discount applied to purchases of our common stock under our employee stock purchase plan.
The estimated income tax benefit of stock-based compensation expense included in the provision for income taxes for the year ended December 31, 2019 is approximately $5.3 million. No stock-based compensation costs were capitalized during the years ended December 31, 2019, 2018 and 2017. The calculation of stock-based compensation expenses includes an estimate for forfeitures at the time of grant.
This estimate can be revised in subsequent periods if actual forfeitures differ from those estimates, which are based on historical trends. Total unrecognized stock-based compensation expense related to nonvested awards and options was $62.4 million as of December 31, 2019, and this expense is expected to be recognized over a weighted-average period of 2.3 years.
Table:
 |  | Year Ended December 31, | 
(In thousands) | 2019 | 2018 | 2017
Cost of revenue: |  |  | 
Software delivery, support and maintenance | $ 2,075 | $ 2,184 | $ 2,879
Client services | 4,067 | 3,997 | 4,484
Total cost of revenue | 6,142 | 6,181 | 7,363
Selling, general and administrative expenses | 27,348 | 24,213 | 23,497
Research and development | 9,200 | 8,937 | 8,605
Total stock-based compensation expense | $ 42,690 | $ 39,331 | $ 39,465


Question: What is the change in the Total cost of revenue from 2018 to 2019?
Answer: -39
Calculation: 6,142 - 6,181
Debt Activity
The table below presents the effects of issuances, prepayments, and conversions of debt in 2019. When we receive a notice of conversion for any of our convertible notes and elect to settle in cash any amount of the conversion obligation in excess of the principal amount, the cash settlement obligations become derivative debt liabilities subject to mark-to-market accounting treatment based on the volume-weighted-average price of our common stock over a period of 20 consecutive trading days. Accordingly, at the date of our election to settle a conversion in cash, we reclassify the fair value of the equity component of the converted notes from additional capital to derivative debt liability within current debt in our consolidated balance sheet.
In 2018, we repurchased or redeemed $6.96 billion of principal amount of notes (carrying value of $6.93 billion) for an aggregate of $9.42 billion in cash and 4 million shares of our treasury stock. As of August 30, 2018, an aggregate of $35 million principal amount of our 2033F Notes (with a carrying value of $165 million) had converted but not settled. These notes settled in 2019 for $153 million in cash and the effect of the settlement is included in the table above. In connection with these transactions, we recognized aggregate non-operating losses of $385 million in 2018.
In 2017, we repurchased or redeemed $1.55 billion of principal amount of notes (carrying value of $1.54 billion) for an aggregate of $1.63 billion in cash. In connection with these transactions, we recognized aggregate non-operating losses of $94 million in 2017.
(1)  Issued February 6, 2019.
(2)  Issued July 12, 2019.
(3)  As of August 29, 2019, an aggregate of $44 million principal amount of our 2033F Notes (with a carrying value of $179 million) had converted but not settled. These notes settled in the first quarter of 2020 for $192 million in cash.
Table:
 | Increase (Decrease) in Principal | Increase (Decrease) in Carrying Value | Increase (Decrease) in Cash | Decrease in Equity | Gain (Loss)
Issuances |  |  |  |  | 
2024 Notes(1) | $600 | $597 | $597 | $— | $—
2026 Notes(1) | 500 | 497 | 497 | — | —
2027 Notes(2) | 900 | 895 | 895 | — | —
2029 Notes(1) | 700 | 695 | 695 | — | —
2030 Notes(2) | 850 | 845 | 845 | — | —
Prepayments |  |  |  |  | 
2022 Term Loan B | (728) | (721) | (728) | — | (7)
Settled conversions |  |  |  |  | 
2032D Notes | (10) | (9) | (35) | (28) | 2
2033F Notes | (45) | (175) | (192) | (28) | 11
2043G Notes | (1,019) | (691) | (1,426) | (326) | (400)
Conversions not settled |  |  |  |  | 
2033F Notes(3) | — | 135 | — | (133) | (2)
 | $1,748 | $2,068 | $1,148 | $(515) | $(396)


Question: What is the ratio of the increase in carrying value of 2029 Notes to 2030 Notes?
Answer: 0.82
Calculation: 695/845
Contractual Obligations
The following table summarizes the payments due by fiscal year for our outstanding contractual obligations as of June 30, 2019:
(a) Refer to Note 11 – Debt of the Notes to Financial Statements.
(b) Refer to Note 7 – Property and Equipment of the Notes to Financial Statements.
(c) Refer to Note 15 – Leases of the Notes to Financial Statements.
(d) Refer to Note 12 – Income Taxes of the Notes to Financial Statements.
(e) Amounts represent purchase commitments, including open purchase orders and take-or-pay contracts that are not presented as construction commitments above.
(f) We have excluded long-term tax contingencies, other tax liabilities, and deferred income taxes of $14.2 billion from the amounts presented as the timing of these obligations is uncertain. We have also excluded unearned revenue and non-cash items.
Table:
(In millions) | 2020 | 2021-2022 | 2023-2024 | Thereafter | Total
Long-term debt: (a) |  |  |  |  | 
Principal payments | $ 5,518 | $ 11,744 | $ 8,000 | $ 47,519 | $ 72,781
Interest payments | 2,299 | 4,309 | 3,818 | 29,383 | 39,809
Construction commitments (b) | 3,443 | 515 | 0 | 0 | 3,958
Operating leases, including imputed interest (c) | 1,790 | 3,144 | 2,413 | 3,645 | 10,992
Finance leases, including imputed interest (c) | 797 | 2,008 | 2,165 | 9,872 | 14,842
Transition tax (d) | 1,180 | 2,900 | 4,168 | 8,155 | 16,403
Purchase commitments (e) | 17,478 | 1,185 | 159 | 339 | 19,161
Other long-term liabilities (f) | 0 | 72 | 29 | 324 | 425
Total | $  32,505 | $  25,877 | $  20,752 | $  99,237 | $  178,371


Question: Why has $14.2 billion been excluded from other long-term liabilities?
Answer: We have excluded long-term tax contingencies, other tax liabilities, and deferred income taxes of $14.2 billion from the amounts presented as the timing of these obligations is uncertain.
Consolidated Statements of Comprehensive Income (Loss)
(Amounts in thousands)
(1) Fiscal years ended March 31, 2018 and 2017 adjusted due to the adoption of ASC 606.
(2) Fiscal year ended March 31, 2018 adjusted due to the adoption of ASC 606.
See accompanying notes to consolidated financial statements.
Table:
 |  | Fiscal Years Ended March 31, | 
 | 2019 | 2018 | 2017
Net income (1) | $206,587 | $254,127 | $47,157
Other comprehensive income (loss), net of tax: |  |  | 
Foreign currency translation gains (losses) (2) | (24,065) | 35,271 | (15,284)
Defined benefit pension plans | (927) | 167 | 163
Defined benefit post-retirement plan adjustments | (86) | (255) | 20
Equity interest in investee’s other comprehensive income (loss) | (11) | 5,584 | 1,440
Foreign exchange contracts | (588) | (1,753) | 3,274
Excluded component of fair value hedges | (2,249) | — | —
Other comprehensive income (loss) (2) | (27,926) | 39,014 | (10,387)
Total comprehensive income (1) | $178,661 | $293,141 | $36,770


Question: Which years does the table provide information for the Consolidated Statements of Comprehensive Income (Loss)?
Answer: 2019, 2018, 2017
Defined Benefit Pension Plans
We recognize the funded status of each defined pension benefit plan as the difference between the fair value of plan assets and the projected benefit obligation of the employee benefit plans in the Consolidated Balance Sheets, with a corresponding adjustment to accumulated other comprehensive loss, net of taxes. Each overfunded plan is recognized as an asset and each underfunded plan is recognized as a liability on our Consolidated Balance Sheets. Subsequent changes in the funded status are reflected on the Consolidated Balance Sheets in unrecognized pension items, a component of AOCL, which are included in total stockholders’ deficit. The amount of unamortized pension items is recorded net of tax.
We have amortized actuarial gains or losses over the average future working lifetime (or remaining lifetime of inactive participants if there are no active participants). We have used the corridor method, where the corridor is the greater of ten percent of the projected benefit obligation or fair value of assets at year end. If actuarial gains or losses do not exceed the corridor, then there is no amortization of gain or loss.
During the year ended December 31, 2017, several of our pension plans transferred in the sale of Diversey. Two international plans were split between Diversey and Sealed Air at the close of the sale. Unless noted, the tables in this disclosure show only activity related to plans retained by Sealed Air.
The following table shows the components of our net periodic benefit cost for the three years ended December 31, for our pension plans charged to operations:
(1) The amount recorded in inventory for the years ended December 31, 2019, 2018 and 2017 was not material.
Table:
 |  | Year Ended December 31, | 
(In millions) | 2019 | 2018 | 2017
Net periodic benefit (income) cost: |  |  | 
U.S. and international net periodic benefit cost included in cost of sales(1) | $ 1.1 | $ 0.8 | $ 1.4
U.S. and international net periodic benefit cost included in selling, general and administrative expenses | 2.8 | 3.5 | 5.6
U.S. and international net periodic benefit (income) included in other (income) expense | (4.4) | (8.4) | (6.0)
Total benefit (income) cost | (0.5 ) | (4.1 ) | $ 1.0


Question: What is the percentage difference of the U.S. and international net periodic benefit cost included in cost of sales for year 2017 to year 2019?
Answer: -21.43
Calculation: (1.1-1.4)/1.4
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)
29. Earnings/(losses) per share (‘‘EPS’’)
Basic earnings/(losses) per share was calculated by dividing the profit/(loss) for the year attributable to the owners of the common shares after deducting the dividend on Preference Shares by the weighted average number of common shares issued and outstanding during the year.
Diluted EPS is calculated by dividing the profit/(loss) for the year attributable to the owners of the Group adjusted for the effects of all dilutive potential ordinary shares by the weighted average number of all potential ordinary shares assumed to have been converted into common shares, unless such potential ordinary shares have an antidilutive effect.
The following reflects the earnings/(losses) and share data used in the basic and diluted earnings/ (losses) per share computations:
The Group excluded the effect of 2,630,173 SARs and 367,162 RSUs in calculating diluted EPS for the year ended December 31, 2019, as they were anti-dilutive (December 31, 2018: 555,453 SARs and 0 RSUs, December 31, 2017: 998,502 SARs and 0 RSUs).
Table:
 |  | For the year ended December 31, | 
 | 2017 | 2018 | 2019
Basic earnings/(loss) per share |  |  | 
Profit/(loss) for the year attributable to owners of the Group | 15,506 | 47,683 | (100,661)
Less: Dividends on Preference Shares | (10,064) | (10,063) | (10,063)
Profit/(loss) for the year available to owners of the Group | 5,442 | 37,620 | (110,724)
Weighted average number of shares outstanding, basic | 80,622,788 | 80,792,837 | 80,849,818
Basic earnings/(loss) per share | 0.07 | 0.47 | (1.37)
Diluted earnings/(loss) per share |  |  | 
Profit/(loss) for the year available to owners of the Group used in the calculation of diluted EPS | 5,442 | 37,620 | (110,724)
Weighted average number of shares outstanding, basic | 80,622,788 | 80,792,837 | 80,849,818
Dilutive potential ordinary shares | 643,342 | 844,185 | —
Weighted average number of shares used in the calculation of diluted EPS | 81,266,130 | 81,637,022 | 80,849,818
Diluted earnings/(loss) per share | 0.07 | 0.46 | (1.37)


Question: What was the change in basic EPS from 2018 to 2019?
Answer: -1.84
Calculation: (1.37) - 0.47
Note 8. Goodwill and Intangible Assets, Net
The changes in goodwill by reportable segment are outlined below (in thousands):
On October 21, 2019, we acquired 85% of the issued and outstanding capital stock of OpenEye and recorded $41.4 million of goodwill in the Alarm.com segment. There were no impairments of goodwill recorded during the years ended December 31, 2019, 2018 or 2017. As of December 31, 2019, the accumulated balance of goodwill impairments was $4.8 million, which is related to our acquisition of EnergyHub in 2013.
Table:
 | Alarm.com | Other | Total
Balance as of January 1, 2018 | $63,591 | $— | $63,591
Goodwill acquired | — | — | —
Balance as of December 31, 2018 | 63,591 | — | 63,591
Goodwill acquired | 41,372 | — | 41,372
Balance as of December 31, 2019 | $104,963 | $— | $104,963


Question: What was the goodwill acquired in 2019?
Answer: 41,372
1.2 Data Centres
Note: 1. Due to its business nature, the significant air emissions of the Group are GHG emissions, arising mainly from fuels and purchased electricity produced from fossil fuels.
2. The Group’s GHG inventory includes carbon dioxide, methane and nitrous oxide. GHG emissions data for the year ended 31 December 2019 is presented in carbon dioxide equivalent and is calculated based on the “2017 Baseline Emission Factors for Regional Power Grids in China for CDM and CCER Projects” issued by the Ministry of Ecology and Environment of China, and the “2006 IPCC Guidelines for National Greenhouse Gas Inventories” issued by the Intergovernmental Panel on Climate Change (IPCC).
3. Diesel is consumed by backup power generators.
4. Hazardous waste produced by the Group’s office buildings mainly includes waste toner cartridge and waste ink cartridge from printing equipment. Waste toner cartridge and waste ink cartridge are centralised and disposed of by printing suppliers. Such data covers all office buildings of the Group in Mainland China.
5. Non-hazardous waste produced by the Group’s office buildings mainly includes domestic waste and non-hazardous office waste. Domestic waste is disposed of by the property management companies and kitchen waste recycling vendors, and its data is not available, therefore estimation of domestic waste is made with reference to “Handbook on Domestic Discharge Coefficients for Towns in the First Nationwide Census on Contaminant Discharge” published by the State Council. Non-hazardous office waste is centralised for disposal by vendors; hence such data covers all office buildings of the Group in Mainland China.
6. Hazardous waste produced by the Group’s data centres mainly includes waste lead-acid accumulators. Waste lead-acid accumulators are disposed of by qualified waste recycling vendors.
7. Non-hazardous waste produced by the Group’s data centres mainly includes waste servers and waste hard drives. Waste servers and destroyed waste hard drives are centralised and recycled by waste recycling vendors. Such data covers all the Group’s data centres.
Table:
Indicators | For the year ended 31 December | 
 | 2019 | 2018
Total GHG emissions (Scopes 1 and 2) (tonnes) | 743,287.01 | 612,521.16
Direct GHG emissions (Scope 1) (tonnes) | 316.35 | 36.76
Including: Diesel (tonnes) | 316.35 | 36.76
Indirect GHG emissions (Scope 2) (tonnes) | 742,970.66 | 612,484.40
Including: Purchased electricity (tonnes) | 742,970.66 | 612,484.40
Hazardous waste (tonnes) | 8.00 | –
Non-hazardous waste (tonnes) | 1,811.27 | 1,350.76


Question: What is the change between 2018 and 2019 direct GHG emissions in tonnes?
Answer: 279.59
Calculation: 316.35-36.76