hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
The following table provides a reconciliation of cash, cash equivalents, and restricted cash reported within our consolidated balance sheets as of December 31, 2019 and 2018 to the total of such amounts as presented in the consolidated statements of cash flows (in thousands):
(1) See Note 7. “Restricted Cash and Investments” to our consolidated financial statements for discussion of our “Restricted cash” arrangements.
During the year ended December 31, 2019, we sold marketable securities for proceeds of $52.0 million and realized no gain or loss on such sales. During the years ended December 31, 2018 and 2017, we sold marketable securities for proceeds of $10.8 million and $118.3 million, respectively, and realized gains of less than $0.1 million on such sales in each respective period. See Note 11. “Fair Value Measurements” to our consolidated financial statements for information about the fair value of our marketable securities.
Table:
 | Balance Sheet Line Item | 2019 | 2018
Cash and cash equivalents | Cash and cash equivalents | $ 1,352,741 | $ 1,403,562
Restricted cash – current (1) | Prepaid expenses and other current assets | 13,697 | 19,671
Restricted cash – noncurrent (1) . | Restricted cash and investments | 80,072 | 139,390
Total cash, cash equivalents, and restricted cash |  | $ 1,446,510 | $ 1,562,623


Question: What amount of marketable securities were sold in 2017?
Answer: $118.3 million
Note 8: Balance Sheet Information
Certain significant amounts included in the Company's Consolidated Balance Sheets consist of the following (in millions):
Assets classified as held-for-sale, consisting primarily of properties, are required to be recorded at the lower of carrying value or fair value less any costs to sell. The carrying value of these assets as of December 31, 2019 was $1.4 million, and is reported as other current assets on the Company’s Consolidated Balance Sheet.
Depreciation expense for property, plant and equipment, including amortization of finance leases, totaled $409.7 million, $359.3 million and $325.2 million for 2019, 2018 and 2017, respectively.
Included within sales related reserves are ship and credit reserves for distributors amounting to $178.7 million and $230.8 million as of December 31, 2019 and 2018, respectively.
Table:
 | As of | 
 | December 31, 2019 | December 31, 2018
Inventories: |  | 
Raw materials | $138.4 | $137.3
Work in process | 772.9 | 760.7
Finished goods | 321.1 | 327.2
 | $1,232.4 | $1,225.2
Property, plant and equipment, net: |  | 
Land | $125.2 | $125.5
Buildings | 860.6 | 820.4
Machinery and equipment | 4,275.2 | 3,980.2
Property, plant and equipment, gross | 5,261.0 | 4,926.1
Less: Accumulated depreciation | (2,669.4) | (2,376.5)
 | $2,591.6 | $2,549.6
Accrued expenses: |  | 
Accrued payroll and related benefits | $153.4 | $240.8
Sales related reserves | 247.3 | 294.8
Income taxes payable | 22.5 | 38.2
Other | 115.6 | 85.3
 | $538.8 | $659.1


Question: What is the change in Inventories: Finished goods from year ended December 31, 2018 to 2019?
Answer: -6.1
Calculation: 321.1-327.2
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
3. PROPERTY AND EQUIPMENT
Property and equipment (including assets held under finance leases) consisted of the following:
(1) Assets on leased land are depreciated over the shorter of the estimated useful life of the asset or the term of the corresponding ground lease taking into consideration lease renewal options and residual value.
(2) Includes fiber and DAS assets.
(3) Estimated useful lives apply to improvements only.
Table:
 | Estimated Useful Lives (years) (1) | December 31, 2019 | December 31, 2018
Towers | Up to 20 | $13,930.7 | $12,777.9
Equipment (2) | 2 - 20 | 1,897.3 | 1,667.3
Buildings and improvements | 3 - 32 | 638.9 | 628.5
Land and improvements (3) | Up to 20 | 2,486.1 | 2,285.4
Construction-in-progress |  | 372.6 | 358.1
Total |  | 19,325.6 | 17,717.2
Less accumulated depreciation |  | (7,241.2) | (6,470.1)
Property and equipment, net |  | $12,084.4 | $11,247.1


Question: What was the value of buildings and improvements in 2019?
Answer: 638.9
3.4 FINANCIAL EXPENSE
(1) Fiscal 2018 was restated to reclassify results from Cogeco Peer 1 as discontinued operations. For further details, please consult the "Discontinued operations" section.
Fiscal 2019 financial expense decreased by 5.4% mainly due to:
• the reimbursement at maturity of the Senior Secured Notes Series B on October 1, 2018; • the reimbursements of $65 million and US$35 million under the Canadian Revolving Facility during the second quarter of fiscal 2019 and of US$328 million during the third quarter of fiscal 2019 following the sale of Cogeco Peer 1; and
• early reimbursement of the US$400 million Senior Unsecured Notes during the third quarter of fiscal 2018 which resulted in a $6.2 million redemption premium and the write-off of the unamortized deferred transaction costs of $2.5 million; partly offset by • higher interest cost on the First Lien Credit Facilities resulting from the full year impact of the financing of the MetroCast acquisition; and • the appreciation of the US dollar against the Canadian dollar compared to the prior year.
Table:
Years ended August 31, | 2019 | 2018 (1) | Change
(in thousands of dollars, except percentages) | $ | $ | %
Interest on long-term debt | 176,798 | 179,680 | (1.6)
Net foreign exchange gains | (2,744) | (2,134) | 28.6
Amortization of deferred transaction costs | 1,836 | 1,884 | (2.5)
Capitalized borrowing costs | (690) | (2,074) | (66.7)
Other | 302 | 8,100 | (96.3)
 | 175,502 | 185,456 | (5.4)


Question: What was the increase / (decrease) in the amortization of deferred transactions costs from 2018 to 2019?
Answer: -48
Calculation: 1,836 - 1,884
the diluted earnings per share calculation excludes stock options , sars , restricted stock and units and performance units and stock that were anti-dilutive . shares underlying the excluded stock options and sars totaled 2.6 million , 10.3 million and 10.2 million for the years ended december 31 , 2017 , 2016 and 2015 , respectively . for the year ended december 31 , 2016 , 4.5 million shares of restricted stock and restricted stock units and performance units and performance stock were excluded . 10 . supplemental cash flow information net cash paid for interest and income taxes was as follows for the years ended december 31 , 2017 , 2016 and 2015 ( in thousands ) : .

Table:
 | 2017 | 2016 | 2015
interest net of capitalized interest | $ 275305 | $ 252030 | $ 222088
income taxes net of refunds received | $ 188946 | $ -39293 ( 39293 ) | $ 41108
eog's accrued capital expenditures at december 31 , 2017 , 2016 and 2015 were $ 475 million , $ 388 million and $ 416 million , respectively .
non-cash investing activities for the year ended december 31 , 2017 included non-cash additions of $ 282 million to eog's oil and gas properties as a result of property exchanges .
non-cash investing activities for the year ended december 31 , 2016 included $ 3834 million in non-cash additions to eog's oil and gas properties related to the yates transaction ( see note 17 ) .
11 .
business segment information eog's operations are all crude oil and natural gas exploration and production related .
the segment reporting topic of the asc establishes standards for reporting information about operating segments in annual financial statements .
operating segments are defined as components of an enterprise about which separate financial information is available and evaluated regularly by the chief operating decision maker , or decision-making group , in deciding how to allocate resources and in assessing performance .
eog's chief operating decision-making process is informal and involves the chairman of the board and chief executive officer and other key officers .
this group routinely reviews and makes operating decisions related to significant issues associated with each of eog's major producing areas in the united states , trinidad , the united kingdom and china .
for segment reporting purposes , the chief operating decision maker considers the major united states producing areas to be one operating segment. .

Question: what is the increase observed in the interest net of capitalized interest during 2016 and 2017?
Answer: 9.235%
Calculation: divide(275305, 252030), subtract(#0, const_1)
18. Other Income (Expense), Net
Other income (expense), net consists of the following:
Table:
 |  | Years Ended June 30, | 
($ in millions) | 2019 | 2018 | 2017
Unrealized gains on company owned life insurance contracts and investments held in rabbi trusts | $0.8 | $1.5 | $1.7
Interest income | 0.1 | 0.3 | 0.3
Foreign exchange | (0.4) | (0.7) | (0.4)
Pension earnings, interest and deferrals | (0.1) | (2.1) | (23.8)
Pension curtailment | — | — | (0.5)
Other | 0.2 | 0.2 | 1.2
Total other income (expense), net | $0.6 | $(0.8) | $(21.5)


Question: In which years is total Other Income (Expense), Net calculated?
Answer: 2019, 2018, 2017
through the certegy merger , the company has an obligation to service $ 200 million ( aggregate principal amount ) of unsecured 4.75% ( 4.75 % ) fixed-rate notes due in 2008 . the notes were recorded in purchase accounting at a discount of $ 5.7 million , which is being amortized over the term of the notes . the notes accrue interest at a rate of 4.75% ( 4.75 % ) per year , payable semi-annually in arrears on each march 15 and september 15 . on april 11 , 2005 , fis entered into interest rate swap agreements which have effectively fixed the interest rate at approximately 5.4% ( 5.4 % ) through april 2008 on $ 350 million of the term loan facilities ( or its replacement debt ) and at approximately 5.2% ( 5.2 % ) through april 2007 on an additional $ 350 million of the term loan . the company has designated these interest rate swaps as cash flow hedges in accordance with sfas no . 133 . the estimated fair value of the cash flow hedges results in an asset to the company of $ 4.9 million and $ 5.2 million , as of december 31 , 2006 and december 31 , 2005 , respectively , which is included in the accompanying consolidated balance sheets in other noncurrent assets and as a component of accumulated other comprehensive earnings , net of deferred taxes . a portion of the amount included in accumulated other comprehensive earnings is reclassified into interest expense as a yield adjustment as interest payments are made on the term loan facilities . the company 2019s existing cash flow hedges are highly effective and there is no current impact on earnings due to hedge ineffectiveness . it is the policy of the company to execute such instruments with credit-worthy banks and not to enter into derivative financial instruments for speculative purposes . principal maturities at december 31 , 2006 ( and at december 31 , 2006 after giving effect to the debt refinancing completed on january 18 , 2007 ) for the next five years and thereafter are as follows ( in thousands ) : december 31 , january 18 , 2007 refinancing .

Table:
 | december 31 2006 | january 18 2007 refinancing
2007 | $ 61661 | $ 96161
2008 | 257541 | 282041
2009 | 68129 | 145129
2010 | 33586 | 215586
2011 | 941875 | 165455
thereafter | 1646709 | 2105129
total | $ 3009501 | $ 3009501
fidelity national information services , inc .
and subsidiaries and affiliates consolidated and combined financial statements notes to consolidated and combined financial statements 2014 ( continued ) .

Question: what was the change , in thousands , of principal maturities due in 2007 after the the debt refinancing completed on january 18 , 2007?
Answer: -34500
Calculation: subtract(61661, 96161)
Our Net Financial Position as of December 31, 2019 was a net cash position of $672 million, decreasing compared to the net cash position of $686 million at December 31, 2018.
At December 31, 2019, our financial debt was $2,072 million, composed of (i) $173 million of current portion of long-term debt and (ii) $1,899 million of long-term debt. The breakdown of our total financial debt included: (i) $1,354 million in the senior unsecured convertible bonds issued in 2017, (ii) $706 million in European Investment Bank loans (the “EIB Loans”), and (iii) $12 million in loans from other funding programs and other long-term loans.
The EIB Loans are comprised of three long-term amortizing credit facilities as part of our R&D funding programs. The first, signed in 2010, is a €350 million multi-currency loan to support our industrial and R&D programs. It was drawn mainly in U.S. dollars for an amount of $321 million and only partially in Euros for an amount of €100 million, of which $55 million remained outstanding as of December 31, 2019.
The second, signed in 2013, is a €350 million multi-currency loan which also supports our R&D programs. It was drawn in U.S. dollars for an amount of $471 million, of which $118 million is outstanding as of December 31, 2019. The third, signed in August 2017 for a total aggregate amount of €500 million in relation to R&D and capital expenditure investments in the European Union. It was fully drawn in Euros corresponding to $533 million outstanding as of December 31, 2019.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (In millions) | 
Cash and cash equivalents | $2,597 | $2,266 | $1,759
Restricted cash | 10 | — | —
Short-term deposits | 4 | — | —
Marketable securities | 133 | 330 | 431
Total financial resources | 2,744 | 2,596 | 2,190
Short-term debt, including bank overdrafts | (173) | (146) | (118)
Long-term debt | (1,899) | (1,764) | (1,583)
Total financial debt | (2,072) | (1,910) | (1,701)
Net Financial Position | $672 | $686 | $489


Question: What was the first EIB loan amount that was signed?
Answer: €350 million
Quarterly Financial Data (Unaudited)
Quarterly sales and earnings results are normally influenced by seasonal factors. Historically, the first two fiscal quarters (three months ending September 30 and December 31) are typically the lowest principally because of annual plant vacation and maintenance shutdowns by the Company and by many of its customers. However, the timing of major changes in the general economy or the markets for certain products can alter this pattern.
During the quarter ended December 31, 2017, the Company recorded an income tax benefit. See Note 17, Income Taxes to Notes to Consolidated Financial Statements included in Item 8. “Financial Statements and Supplementary Data”.
Table:
($ in millions) | First Quarter | Second Quarter | Third Quarter | Fourth Quarter
Results of Operations |  |  |  | 
Fiscal Year 2019 |  |  |  | 
Net sales | $572.4 | $556.5 | $609.9 | $641.4
Gross profit | $91.7 | $107.0 | $123.2 | $122.9
Operating income | $45.0 | $55.4 | $73.2 | $67.9
Net income | $31.5 | $35.5 | $51.1 | $48.9
Fiscal Year 2018 |  |  |  | 
Net sales | $479.8 | $487.8 | $572.2 | $618.0
Gross profit | $85.6 | $85.7 | $96.1 | $114.9
Operating income | $42.2 | $41.4 | $45.7 | $60.0
Net income | $23.4 | $92.1 | $30.2 | $42.8


Question: What was the change in net income in First Quarter in 2019 from 2018?
Answer: 8.1
Calculation: 31.5-23.4
The ESPP provides for annual increases in the number of shares available for issuance under the ESPP on the first day of each fiscal year beginning in fiscal 2014, equal to the least of: (i) 1% of the outstanding shares of all classes of common stock on the last day of the immediately preceding year; (ii) 1,250,000 shares; or (iii) such other amount as may be determined by the board of directors. During the year ended December 31, 2019, a total of 810,459 shares of Class A common stock were added to the ESPP Plan in connection with the annual increase provision. At December 31, 2019, a total of 3,918,712 shares were available for issuance under the ESPP.
The weighted-average assumptions used to value ESPP rights under the Black-Scholes-Merton option-pricing model and the resulting offering grant date fair value of ESPP rights granted in the periods presented were as follows:
As of December 31, 2019 and 2018, there was approximately $2.3 million and $1.5 million of unrecognized share-based compensation expense, net of estimated forfeitures, related to ESPP, which will be recognized on a straight-line basis over the remaining weighted-average vesting periods of approximately 0.4 years, respectively
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Expected term (in years) | 0.5 | 0.5 | 0.5
Expected volatility | 47% | 42% | 34%
Risk-free interest rate | 2.01% | 2.31% | 1.20%
Expected dividend yield | 0% | 0% | 0%
Offering grant date fair value of ESPP rights | $33.66 | $18.07 | $9.52


Question: What is the average offering grant date fair value of ESPP rights between 2017 to 2019?
Answer: 20.42
Calculation: (33.66 + 18.07 + 9.52)/3
14 Leases
Right-of-use assets
The vast majority of the right-of-use asset value relates to leased property where the Group leases a number of office and warehouse sites in a number of geographical locations. The remaining leases are largely made up of leased motor vehicles, where the Group makes use of leasing cars for sales and service engineers at a number of operating company locations. The average lease term is 4.3 years.
Table:
 | Leased land and buildings | Leased plants and machinery | Leased fixtures, fittings, tools and equipment | Total right-of-use assets
 | £m | £m | £m | £m
Cost: |  |  |  | 
Transition adjustment at 1st January 2019 | 27.2 | 7.0 | 1.9 | 36.1
Reclassification from long-term prepayments | 5.1 | – | – | 5.1
Additions | 7.2 | 4.2 | 0.3 | 11.7
Acquisitions | 0.8 | 0.3 | – | 1.1
Disposals | (0.2) | (0.1) | – | (0.3)
Exchange adjustments | (1.5) | (0.4) | (0.1) | (2.0)
At 31st December 2019 | 38.6 | 11.0 | 2.1 | 51.7
Depreciation: |  |  |  | 
Charged in the year | 7.0 | 3.7 | 0.6 | 11.3
Disposals | (0.1) | – | – | (0.1)
Exchange adjustments | (0.2) | (0.1) | – | (0.3)
At 31st December 2019 | 6.7 | 3.6 | 0.6 | 10.9
Net book value: |  |  |  | 
At 31st December 2019 | 31.9 | 7.4 | 1.5 | 40.8


Question: Which type of lease had the largest amount of Acquisitions?
Answer: Leased land and buildings
Calculation: 0.8>0.3>0
Other Income/Expense
The following table details our other income/expenses for the years ended September 30, 2019 and 2018:
The decrease to other income (expenses) for the fiscal year ended September 30, 2019 as compared to the fiscal year ended September 30, 2018 was primarily driven by a decrease in Other income, net of $0.3 mil.
Table:
 | For the year ended |  | 
 | September 30, 2019 | September 30, 2018 | Increase (Decrease)
 | (Amounts in thousands) |  | 
Interest expense | $(99) | $(85) | $(14)
Interest income | 323 | 20 | 303
Foreign exchange gain (loss) | 157 | 263 | (106)
Other income, net | 3 | 297 | (294)
Total other income (expense), net | $384 | $495 | $(111)


Question: When does the company's fiscal year end?
Answer: September 30
Equity Incentive Plan
Our board of directors administers the plan, determines vesting schedules on plan awards and may accelerate the vesting schedules for award recipients. The stock options granted under the plan have terms of up to 10 years. As of December 31, 2019, awards for the purchase of 4,236,719 shares have been granted and remain outstanding (common stock options, common stock and restricted stock units) and 2,063,281 shares are reserved for future grants under the 2014 Plan.
Share-based compensation expenses related to stock options, stock and restricted stock units issued to employees and directors are included in selling, general and administrative expenses. The following table provides a detail of share-based compensation expense (in thousands).
Table:
Year Ended December 31 |  | 
 | 2019 | 2018
Common stock, vested at issuance and nonvested at issuance | $721 | $555
Stock options | 354 | 132
Restricted stock units | 225 | 103
Compensation expense related to common stock awards issued under equity incentive plan | $          1,300 | $            790


Question: What are the respective values of common stock in 2018 and 2019?
Answer: $555, $721
The Credit Agreement and 2026 Notes contain certain customary affirmative covenants and negative covenants that limit or restrict, subject to certain exceptions, the incurrence of liens, indebtedness of subsidiaries, mergers, advances, investments, acquisitions, transactions with affiliates, change in nature of business, and the sale of the assets. In addition, the Credit Agreement and 2026 Notes contain certain customary mandatory prepayment provisions. The Company is also required to maintain a consolidated leverage ratio at or below a specified amount and an interest coverage ratio at or above a specified amount. As specified in the Credit Agreement and 2026 Notes agreement, if certain events occur and continue, the Company may be required to repay all amounts outstanding under the Credit Facility and 2026 Notes. As of December 31, 2019, and at all times during the period, the Company was in compliance with its financial debt covenants.
Total debt is comprised of the following (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Term loans | $756,060 | $284,959
Revolving credit facility | 239,000 | —
5.750% Senior Notes, due August 2026 | 400,000 | 400,000
Debt issuance costs | (21,905 ) | (13,203 )
Total debt | 1,373,155 | 671,756
Less current portion of term credit facility | 38,950 | 23,747
Less current portion of debt issuance costs | (4,802 ) | (2,980 )
Total long-term debt | $1,339,007 | $650,989


Question: What was the change in total debt between 2018 and 2019?
Answer: 701399
Calculation: 1,373,155-671,756