hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Revenue by Market The table below presents disaggregated net revenues by market (in thousands):
(1) Due to the adoption of ASC 606 on January 1, 2018 using the modified retrospective method, amounts prior to 2018 have not been adjusted to reflect the change to recognize certain distributor sales upon sale to the distributor, or the sell-in method, from recognition upon the Company's sale to the distributors' end customers, or the sellthrough method, which required the deferral of revenue and profit on such distributor sales.
Revenues from sales to the Company’s distributors accounted for 52%, 42% and 34% of net revenue for the years ended December 31, 2019, 2018 and 2017, respectively.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017(1)
Connected home | $152,674 | $207,336 | $288,610
% of net revenue | 48% | 54% | 69%
Infrastructure | 85,369 | 82,388 | 71,779
% of net revenue | 27% | 21% | 17%
Industrial and multi-market | 79,137 | 95,273 | 59,929
% of net revenue | 25% | 25% | 14%
Total net revenue | $317,180 | $384,997 | $420,318


Question: What was the Connected home revenue in 2019?
Answer: $152,674
The actual return on plan assets amounted to €125 million in the reporting period (2017/ 18: €45 million).
For financial year 2019/20, the company expects employer payments to external pension providers totalling approximately €18 million and employee contributions of €9 million in plan assets, with contributions in the Netherlands, Belgium and Germany accounting for the major share of this total. Expected contributions from payment contribution commitments in Germany are not included in expected payments.
The fair value of plan assets developed as follows:
At one Dutch company, plan assets exceeded the value of commitments as of the closing date. Since the company cannot draw any economic benefits from this overfunding, the balance sheet amount was reduced to €0 in line with IAS 19.64 (b).
Table:
€ million | 2017/2018 | 2018/2019
Change in plan assets |  | 
Fair value of plan assets as of beginning of period | 905 | 940
Recognised under | 21 | 23
Interest income | 21 | 23
Recognised outside of profit or loss under ‘remeasurement of defined benefit pension plans’ in other comprehensive income | 24 | 102
Gains/losses from plan assets excl. interest income (+/−) | 24 | 102
Other effects | −10 | 0
Benefit payments (incl. tax payments) | −34 | −27
Settlement payments | −6 | 0
Employer contributions | 35 | 18
Contributions from plan participants | 11 | 9
Change in consolidation group / transfers | 0 | 0
Reclassification in accordance with IFRS5 | −16 | 0
Currency effects | 0 | 1
Fair value of plan assets as of end of period | 940 | 1,066


Question: For which years was the Fair value of plan assets as of end of period calculated in?
Answer: 2018, 2019
12. Derivative Instruments
(a) Summary of Derivative Instruments
We use derivative instruments primarily to manage exposures to foreign currency exchange rate, interest rate, and equity price risks. Our primary objective in holding derivatives is to reduce the volatility of earnings and cash flows associated with changes in foreign currency exchange rates, interest rates, and equity prices. Our derivatives expose us to credit risk to the extent that the counterparties may be unable to meet the terms of the agreement. We do, however, seek to mitigate such risks by limiting our counterparties to major financial institutions. In addition, the potential risk of loss with any one counterparty resulting from this type of credit risk is monitored. Management does not expect material losses as a result of defaults by counterparties.
The notional amounts of our outstanding derivatives are summarized as follows (in millions):
Table:
 | July 27, 2019 | July 28, 2018
Derivatives designated as hedging instruments: |  | 
Foreign currency derivatives—cash flow hedges | $663 | $147
Interest rate derivatives | 4,500 | 6,750
Net investment hedging instruments | 309 | 250
Derivatives not designated as hedging instruments: |  | 
Foreign currency derivatives | 2,708 | 2,298
Total return swaps—deferred compensation | 574 | 566
Total | $8,754 | $10,011


Question: What was the change in the Net investment hedging instruments between 2018 and 2019?
Answer: 59
Calculation: 309-250
The net contract acquisition expense deferred within the Consolidated Statement of Profit or Loss was $0.9M of the total $259.9M of Sales and Marketing costs (2018: $8.4M / $239.9M).
At 31 March 2019, trade receivables at a nominal value of $1.2M (2018: $0.9M) were impaired and fully provided for. Movements in the provision for impairment of receivables were as follows: 31
Table:
 | 31 March 2019 | 31 March 2018
 | $M | $M
At 1 April | 0.9 | 0.4
Charge for the year | 0.6 | 0.6
Amounts written off | (0.2) | (0.1)
Effects of movements in exchange rates | (0.1) | –
At 31 March | 1.2 | 0.9


Question: What was the  Charge for the year for 2019?
Answer: 0.6
ACI WORLDWIDE, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (in thousands)
The accompanying notes are an integral part of the consolidated financial statements.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Net income | $67,062 | $68,921 | $5,135
Other comprehensive income (loss): |  |  | 
Foreign currency translation adjustments | 1,034 | -15,261 | 16,744
Total other comprehensive income (loss) | 1,034 | (15,261 ) | 16,744
Comprehensive income | $68,096 | $53,660 | $21,879


Question: What was the net income in 2017?
Answer: $5,135
Free cash flow
The Free cash flow for the Industrial Businesses amounted to €8,000 millions, resulting in a cash conversation rate of 0.89.
Beginning with fiscal 2020, Siemens adopts IFRS 16, Leases, applying
the modified retrospective approach as described in more detail in NOTE 2 in B.6 NOTES TO CONSOLIDATED FINANCIAL STATEMENTS. As a result, the shift of lease payments from cash flows from operating activities to cash flows from financing activities will have a positive effect on Free cash flow.
With our ability to generate positive operating cash flows, our total liquidity (defined as cash and cash equivalents plus current interest-bearing debt securities) of €13.7 billion, our unused lines of credit, and our credit ratings at year-end, we believe that we have sufficient flexibility to fund our capital requirements. Also in our opinion, our operating net working capital is sufficient for our present requirements.
Table:
 |  |  | Fiscal Year 2019
(in millions of €) | Continuing operations | Discontinued operations | Continuing and discontinued operations
Cash flows from operating activities | 8,482 | (27) | 8,456
Additions to intangible assets and property, plant and equipment | (2,610) | − | (2,610)
Free cash flow | 5,872 | (27) | 5,845


Question: What was the Free cash flow for the Industrial Businesses?
Answer: €8,000 millions
Indebtedness
The following table presents selected financial information on our indebtedness (in thousands):
As of December 27, 2019, we have various floating- and fixed-rate debt instruments with varying maturities for an aggregate principal amount of $392.1 million. See Note 9 “Debt Obligations” to our consolidated financial statements for a full description of our debt instruments.
On November 22, 2019, we issued $150.0 million aggregate principal amount of 1.875% Convertible Senior Notes (the “Senior Notes”). Approximately $43.2 million of the net proceeds were used to repay all outstanding borrowings then outstanding under our ABL and we intend to use the remainder for working capital and general corporate purposes, which may include future acquisitions.
On July 25, 2018, the holders of the $36.8 million principal amount of convertible subordinated notes that were issued in connection with our acquisition of Del Monte converted these notes and related accrued interest of $0.3 million into 1,246,272 shares of the Company’s common stock.
On June 29, 2018, we entered into an asset-based loan facility (“ABL”) that increased our borrowing capacity from $75.0 million to $150.0 million. Additionally, we reduced the fixed-rate portion of interest charged on our senior secured term loan (“Term Loan”) from 475 basis points to 350 basis points over Adjusted LIBOR as a result of repricings executed on December 14, 2017 and November 16, 2018.
A portion of the interest rate charged on our Term Loan is currently based on LIBOR and, at our option, a component of the interest charged on the borrowings outstanding on our ABL, if any, may bear interest rates based on LIBOR. LIBOR has been the subject of reform and is expected to phase out by the end of fiscal 2021. The consequences of the discontinuation of LIBOR cannot be entirely predicted but could impact the interest expense we incur on these debt instruments. We will negotiate alternatives to LIBOR with our lenders before LIBOR ceases to be a widely available reference rate.
Table:
 |  | Fiscal Year Ended | 
 | December 27, 2019 | December 28, 2018 | December 29, 2017
Senior secured term loan | $238,129 | $239,745 | $238,435
Total Convertible debt | $154,000 | $— | $36,750
Borrowings outstanding on asset-based loan facility | $— | $44,185 | $—
Finance leases and other financing obligations | $3,905 | $193 | $664


Question: What is the value of senior secured term loan for fiscal years 2019 and 2018 respectively?
Answer: $238,129, $239,745
american tower corporation and subsidiaries notes to consolidated financial statements ( 3 ) consists of customer-related intangibles of approximately $ 75.0 million and network location intangibles of approximately $ 72.7 million . the customer-related intangibles and network location intangibles are being amortized on a straight-line basis over periods of up to 20 years . ( 4 ) the company expects that the goodwill recorded will be deductible for tax purposes . the goodwill was allocated to the company 2019s international rental and management segment . on september 12 , 2012 , the company entered into a definitive agreement to purchase up to approximately 348 additional communications sites from telef f3nica mexico . on september 27 , 2012 and december 14 , 2012 , the company completed the purchase of 279 and 2 communications sites , for an aggregate purchase price of $ 63.5 million ( including value added tax of $ 8.8 million ) . the following table summarizes the preliminary allocation of the aggregate purchase consideration paid and the amounts of assets acquired and liabilities assumed based upon their estimated fair value at the date of acquisition ( in thousands ) : preliminary purchase price allocation .

Table:
 | preliminary purchase price allocation
current assets | $ 8763
non-current assets | 2332
property and equipment | 26711
intangible assets ( 1 ) | 21079
other non-current liabilities | -1349 ( 1349 )
fair value of net assets acquired | $ 57536
goodwill ( 2 ) | 5998
( 1 ) consists of customer-related intangibles of approximately $ 10.7 million and network location intangibles of approximately $ 10.4 million .
the customer-related intangibles and network location intangibles are being amortized on a straight-line basis over periods of up to 20 years .
( 2 ) the company expects that the goodwill recorded will be deductible for tax purposes .
the goodwill was allocated to the company 2019s international rental and management segment .
on november 16 , 2012 , the company entered into an agreement to purchase up to 198 additional communications sites from telef f3nica mexico .
on december 14 , 2012 , the company completed the purchase of 188 communications sites , for an aggregate purchase price of $ 64.2 million ( including value added tax of $ 8.9 million ) . .

Question: for the december 14 , 2012 purchase , what was the average cost of the communications sites acquired?
Answer: 341489
Calculation: multiply(64.2, const_1000000), divide(#0, 188)
GreenSky, Inc. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS — (Continued) (United States Dollars in thousands, except per share data, unless otherwise stated)
Disaggregated revenue
Revenue disaggregated by type of service was as follows for the periods presented:
(1) For the year ended December 31, 2019, includes a $30,459 change in fair value of our servicing asset primarily associated with increases to the contractually specified fixed servicing fees for certain Bank Partners. Refer to Note 3 for additional information.
(2) Other revenue includes miscellaneous revenue items that are individually immaterial. Other revenue is presented separately herein in order to clearly present merchant, interchange and servicing fees, which are more integral to our primary operations and better enable financial statement users to calculate metrics such as servicing and merchant fee yields.
No assets were recognized from the costs to obtain or fulfill a contract with a customer as of December 31,
2019 and 2018. We recognized bad debt expense arising from our contracts with customers of $950, $1,294 and
$817 during the years ended December 31, 2019, 2018 and 2017, respectively, which is recorded within general and
administrative expense in our Consolidated Statements of Operations.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Merchant fees | $361,755 | $297,776 | $234,548
Interchange fees | 44,150 | 51,128 | 44,410
Transaction fees | 405,905 | 348,904 | 278,958
Servicing fees(1) | 123,697 | 65,597 | 46,575
Other(2) | 44 | 172 | 354
Servicing and other | 123,741 | 65,769 | 46,929
Total revenue | $529,646 | $414,673 | $325,887


Question: What was the change in the transaction fees between 2017 and 2019?
Answer: 126947
Calculation: 405,905-278,958
NOTE 3. PROPERTY AND EQUIPMENT
The classification of property and equipment, together with their estimated useful lives is as follows:
(1) Excludes assets held for sale
(2) Lesser of lease term or estimated useful life
The change in property and equipment in accrued liabilities was $14,315 and $15,674 for the fiscal years ended June 30, 2019 and 2018, respectively. These amounts were excluded from capital expenditures on the statements of cash flows.
No impairments of property and equipment were recorded in fiscal 2019 or 2018.
During the third quarter of fiscal 2019, the Company received an unsolicited offer to purchase its Houston, TX, facility. At June 30, 2019, the facility included assets with a carrying value of approximately $5,055. Although management has not committed to the sale, a sale of the facility during fiscal 2020 is likely and the Company expects to record a gain on the sale upon closing, since the offer represents full appraisal value for the facility. Therefore, the assets are considered held for sale at June 30, 2019. Also held for sale at June 30, 2019, was the Company’s Elizabethtown, KY facility. During the third quarter of fiscal 2018, the Company reached a definitive agreement to sell the property for $1,300 pending an expected closing date during the second quarter of fiscal 2020. An impairment loss was recorded on this facility during fiscal 2017 as disclosed in Note 2 to the Company’s consolidated financial statements. Total assets held for sale by the Company at June 30, 2019 and 2018 were $6,355 and $1,300, respectively, and were included in assets held for sale on the Company’s consolidated balance sheet for each year. Those balances are not included on the above table.
Table:
 | June 30, |  | 
 | 2019 | 2018 | Estimated Useful Life
Land (1) | $23,243 | $24,845 | 
Land improvements (1) | 25,209 | 25,383 | 5 - 20 years
Buildings (1) | 147,220 | 143,918 | 20 - 30 years
Leasehold improvements | 48,478 | 48,060 | 5 - 30 years(2)
Equipment and furniture | 365,101 | 328,864 | 3 - 10 years
Aircraft and equipment | 39,293 | 38,761 | 4 - 10 years
Construction in progress | 12,411 | 39,872 | 
 | 660,955 | 649,703 | 
Less accumulated depreciation | 388,481 | 364,153 | 
Property and equipment, net | $272,474 | $285,550 | 


Question: What is the average buildings amount for 2018 and 2019?
Answer: 145569
Calculation: (147,220+143,918)/2
7. OTHER BALANCE SHEET AMOUNTS
The components of property and equipment, net is as follows (in thousands):
Depreciation expense for the years ended December 31, 2019, 2018, and 2017 was $11.8 million, $10.2 million, and $10.3 million, respectively.
Table:
 |  | December 31, | 
 | Useful Life | 2019 | 2018
Computer equipment and software | 3 – 5 years | $57,474 | $52,055
Furniture and fixtures | 7 years | 6,096 | 4,367
Leasehold improvements | 2 – 6 years | 22,800 | 9,987
Renovation in progress | n/a | 8 | 1,984
Build-to-suit property | 25 years | — | 51,058
Total property and equipment, gross |  | 86,378 | 119,451
Less: accumulated depreciation and amortization |  | (49,852) | (42,197)
Total property and equipment, net |  | $36,526 | $77,254


Question: What was the depreciation expenses for 2018?
Answer: $10.2 million
15 Goodwill and other intangible assets continued
Impairment
In accordance with the requirements of IAS 36 (Impairment of Assets), goodwill is allocated to the Group’s cash-generating units, or groups of cash-generating units, that are expected to benefit from the synergies of the business combination that gave rise to the goodwill.
During 2019, we performed a review on the basis of identification of our individual CGUs. As a result of this review, we have consolidated a number of our current individual CGUs into groups of CGUs that represent the lowest level to which goodwill is monitored for internal management purposes, being each operating segment as disclosed in Note 3. As a result, we performed an impairment review at an operating segment CGU level, the breakdown of the goodwill value at 31st December across these is shown below:
In order to complete the transition to performing goodwill impairment reviews at an operating segment level, we also performed a goodwill impairment review as at 31st December 2019 under the historical CGU basis. The result of this impairment review led to an impairment of £4.2m being recognised in respect of Watson-Marlow FlowSmart. No other impairment was recognised.
The goodwill balance has been tested for annual impairment on the following basis:
• the carrying values of goodwill have been assessed by reference to value in use. These have been estimated using cash flows based on forecast information for the next financial year which have been approved by the Board and then extended up to a further 9 years based on the most recent forecasts prepared by management; • pre-tax discount rates range from 11-12% (2018: 10-15%); • short to medium-term growth rates vary between 3-8% depending on detailed forecasts (2018: 2-8%). The range in rates excludes the annualised impact of owning Thermocoax for a first full year in 2020. The short to medium-term is defined as not more than 10 years; and • long-term growth rates are set using IMF forecasts and vary between 1.8-2.5% (2018: 0.8-3.0%).
Table:
 | 2019 Goodwill | 2018 Goodwill
 | £m | £m
Steam Specialties | 113.0 | 119.3
Electric Thermal Solutions | 244.7 | 183.0
Watson-Marlow | 60.0 | 65.7
Total goodwill | 417.7 | 368.0


Question: What was the percentage change in total goodwill in 2019 from 2018?
Answer: 13.51
Calculation: (417.7-368.0)/368.0
15. ASSET UNDER DEVELOPMENT
In May 2018, upon the completion of the Hilli FLNG conversion and commissioning, we reclassified $1,296 million to "Vessels and equipment, net" in our consolidated balance sheet as of December 31, 2018.
In December 2018, we entered into agreements with Keppel for the conversion of the Gimi to a FLNG and consequently reclassified the carrying value of the Gimi of $20.0 million from "Vessels and equipment, net" to "Asset under development".
In February 2019, Golar entered into an agreement with BP for the employment of a FLNG unit, Gimi, to service the Greater Tortue Ahmeyim project for a 20-year period expected to commence in 2022.
In April 2019, we issued the shipyard with a Final Notice to Proceed with conversion works that had been initiated under the Limited Notice to Proceed. We also completed the sale of 30% of the total issued ordinary share capital of Gimi MS Corp to First FLNG Holdings (see note 5). The estimated conversion cost of the Gimi is approximately $1.3 billion.
Table:
(in thousands of $) | 2019 | 2018
As of January 1 | 20,000 | 1,177,489
Additions | 372,849 | 118,942
Transfer to vessels and equipment, net (note 16) | — | (1,296,431)
Transfer from vessels and equipment, net (note 16) | — | 20,000
Transfer from other non-current assets (note 17) | 31,048 | —
Interest costs capitalized | 10,351 | —
As of December 31 | 434,248 | 20,000


Question: What was the reason for entering into agreements with Keppel in 2018?
Answer: For the conversion of the Gimi to a FLNG
The following table summarizes stock-based compensation expense in the Company’s consolidated statements of operations:
For the year ended September 30, 2019, the Company granted 33,000 nonvested shares to certain key employees, 55,000 nonvested shares to certain officers including 35,000 shares granted to the Chief Executive Officer, and 20,000 nonvested shares
to its non-employee directors. For the year ended September 30, 2018, the Company granted 12,000 nonvested shares to certain key employees, 40,000 nonvested shares to certain officers including 30,000 to its Chief Executive Officer and 20,000 nonvested
shares to its non-employee directors.
The Company measures the fair value of nonvested stock awards based upon the market price of its common stock as of the date of grant. The Company used the Black-Scholes option-pricing model to value stock options. The Black-Scholes model requires the use of a number of assumptions including volatility of the Company’s stock price, the weighted average risk-free interest rate and the weighted average expected life of the options, at the time of grant. The expected dividend yield is equal to the divided per share declared, divided by the closing share price on the date the options were granted. All equity compensation awards granted for the years ended September 30, 2019 and September 30, 2018 were nonvested stock awards.
Table:
 | Years Ended | 
 | September 30, 2019 | September 30, 2018
 | (Amounts in thousands) | 
Cost of sales | $7 | $5
Engineering and development | 49 | 32
Selling, general and administrative | 736 | 654
Total | $792 | $691


Question: How does the company measure the value of the nonvested stock awards?
Answer: Based upon the market price of its common stock as of the date of grant.
Items Not Resulting in a Deferred Tax Asset
Of the unused tax losses, €187 million (2018: €213 million; 2017: €263 million) relate to U.S. state tax loss carryforwards.
We have not recognized a deferred tax liability on approximately €17.41 billion (2018: €14.04 billion) for undistributed profits of our subsidiaries, because we are in a position to control the timing of the reversal of the temporary difference and it is probable that such differences will not reverse in the foreseeable future.
Table:
€ millions | 2019 | 2018 | 2017
Unused tax losses |  |  | 
Not expiring | 688 | 575 | 375
Expiring in the following year | 63 | 7 | 9
Expiring after the following year | 373 | 476 | 535
Total unused tax losses | 1,124 | 1,058 | 919
Deductible temporary differences | 538 | 509 | 524
Unused research and development and foreign tax credits |  |  | 
Not expiring | 28 | 54 | 38
Expiring in the following year | 0 | 0 | 2
Expiring after the following year | 17 | 18 | 34
Total unused tax credits | 45 | 72 | 74


Question: How much of unused tax losses relate to U.S. state tax loss carryforwards in 2019?
Answer: €187 million