hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Net Debt to Adjusted EBITDA Ratio
(UNAUDITED)
($ in millions)
(1) 2017 Adjusted EBITDA shown pro forma, assuming the Level 3 acquisition and the colocation and data center sale took place on January 1, 2017.
Table:
 | 2019 | 2018 | 2017(1)
Gross Debt | $35,039 | 36,352 | 38,053
Cash and cash equivalents | (1,690) | (488) | (551)
Net debt | $33,349 | 35,864 | 37,502
Adjusted EBITDA excluding integration and transformation costs and special items (1) | $9,070 | 9,040 | 8,686
Net Debt to Adjusted EBITDA Ratio | 3.7 | 4.0 | 4.3


Question: What is the gross debt in 2019?
Answer: $35,039
Assets and Liabilities Measured at Fair Value
The following table presents our assets and liabilities measured at fair value on a recurring or non-recurring basis (in thousands):
The carrying amount of cash equivalents approximates fair value as of each reporting date because of the short maturity of those instruments.
The Company did not have any non-financial assets or non-financial liabilities that were recognized or disclosed at fair value as of December 31, 2019 and December 31, 2018.
Table:
 | December 31, 2019 |  |  | December 31, 2018 |  | 
 | Level 1 | Level 2 | Level 3 | Level 1 | Level 2 | Level 3
Assets |  |  |  |  |  | 
Cash and cash equivalents |  |  |  |  |  | 
Money market funds | $256,915 | $ - | $ - | $254,552 | $ - | $ -
Other current assets: |  |  |  |  |  | 
Indemnification - Sale of SSL | $ - | $ - | $598 | $ - | $ - | $2,410
Liabilities |  |  |  |  |  | 
Long term liabilities |  |  |  |  |  | 
Indemnification - Globalstar do Brasil S.A. | $ - | $ - | $145 | $ - | $ - | $184


Question: What is the value of the company's net assets in 2018?
Answer: 256778
Calculation: 254,552 + 2,410 - 184
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
Information about receivables, contract assets and contract liabilities from contracts with tenants is as follows:
(1) Prior-period amounts adjusted with the adoption of the new lease accounting guidance, as applicable.
(2) Excludes $56.7 million and $55.0 million of capital contributions related to DAS networks as of December 31, 2019 and 2018, respectively.
(3) Excludes $300.2 million and $313.6 million of capital contributions related to DAS networks as of December 31, 2019 and 2018, respectively.
The Company records unearned revenue when payments are received from tenants in advance of the completion of the Company’s performance obligations. Long-term unearned revenue is included in Other non-current liabilities. During the year ended December 31, 2019, the Company recognized $62.2 million of revenue that was included in the Unearned revenue balance as of December 31, 2018. During the year ended December 31, 2018, the Company recognized $44.4 million of revenue that was included in the Unearned revenue balance as of January 1, 2018. The Company also recognized revenues of $59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during each of the years ended December 31, 2019 and 2018. $59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during each of the years ended December 31, 2019 and 2018.
$59.2 million and $55.4 million during the years ended December 31, 2019 and December 31, 2018, respectively, for capital
contributions related to DAS networks. There was $0.4 million of revenue recognized from Other non-current liabilities during
each of the years ended December 31, 2019 and 2018.
Table:
 | December 31, 2019 | December 31, 2018 (1)
Accounts receivable | $80.5 | $92.6
Prepaids and other current assets | 8.3 | 7.7
Notes receivable and other non-current assets | 21.3 | 22.2
Unearned revenue (2) | 35.0 | 35.0
Other non-current liabilities (3) | 79.0 | 54.1


Question: What was the change in Prepaids and other current assets between 2018 and 2019?
Answer: 0.6
Calculation: 8.3-7.7
Software Development Costs
We capitalize purchased software upon acquisition if it is accounted for as internal-use software or if it meets the future alternative use criteria. We capitalize incurred labor costs for software development from the time technological feasibility of the software is established, or when the preliminary project phase is completed in the case of internal-use software, until the software is available for general release. Research and development costs and other computer software maintenance costs related to software development are expensed as incurred.
We estimate the useful life of our capitalized software and amortize its value over that estimated life. If the actual useful life is shorter than our estimated useful life, we will amortize the remaining book value over the remaining useful life or the asset may be deemed to be impaired and, accordingly, a write-down of the value of the asset may be recorded as a charge to earnings.
Upon the availability for general release, we commence amortization of the capitalized software costs on a product by product basis. Amortization of capitalized software is recorded using the greater of (i) the ratio of current revenues to total and anticipated future revenues for the applicable product or (ii) the straightline method over the remaining estimated economic life, which is estimated to be three to five years.
At each balance sheet date, the unamortized capitalized costs of a software product are compared with the net realizable value of that product. The net realizable value is the estimated future gross revenues from that product reduced by the estimated future costs of completing and disposing of that product, including the costs of performing maintenance and client support required to satisfy our responsibility set forth at the time of sale.
The amount by which the unamortized capitalized costs of a software product exceed the net realizable value of that asset is written off. If we determine that the value of the capitalized software could not be recovered, a write-down of the value of the capitalized software to its recoverable value is recorded as a charge to earnings. The unamortized balances of capitalized software were as follows:
Table:
 | December 31, | 
(In thousands) | 2019 | 2018
Software development costs | $428,641 | $317,637
Less: accumulated amortization | (184,712) | (107,977)
Software development costs, net | $243,929 | $209,660


Question: When is the purchased software capitalized?
Answer: upon acquisition if it is accounted for as internal-use software or if it meets the future alternative use criteria
The table below summarizes our cash flows from continuing operations activities for each of the last two fiscal years (in thousands):
Operating Activities. Operating cash flows increased $64.4 million in 2019 compared with 2018 primarily due to favorable changes in working capital of  $37.0 million, primarily due to lower income tax payments of$41.3 million, and higher net income adjusted for non-cash items of $27.3 million
Pension and Postretirement Contributions — Our policy is to fund our pension plans at or above the minimum required by law. As of January 1, 2019, the date of our last actuarial funding valuation for our qualified pension plan, there was no minimum contribution funding requirement. In 2019 and 2018, we contributed $6.2 million and $5.5 million, respectively, to our pension and postretirement plans. We do not anticipate making any contributions to our qualified defined benefit pension plan in fiscal 2020. For additional information, refer to Note 12, Retirement Plans, of the notes to the consolidated financial statements.
Table:
 | 2019 | 2018
Total cash provided by (used in) continuing operations: |  | 
Operating activities | $168,405 | $104,055
Investing activities | (13,819) | 65,661
Financing activities | (5,730) | (445,529)
Net increase (decrease) in cash from continuing operations | $148,856 | $(275,813)


Question: How much money was contributed to the pension and postretirement plan in 2018?
Answer: $5.5 million
Actuarial assumptions
The Group’s scheme liabilities are measured using the projected unit credit method using the principal actuarial assumptions set out below:
Notes: 1 Figures shown represent a weighted average assumption of the individual schemes.
2 The rate of increases in pensions in payment and deferred revaluation are dependent on the rate of inflation.
Table:
 | 2019 % | 2018 % | 2017 %
Weighted average actuarial assumptions used at 31 March1: |  |  | 
Rate of inflation2 | 2.9 | 2.9 | 3.0
Rate of increase in salaries | 2.7 | 2.7 | 2.6
Discount rate | 2.3 | 2.5 | 2.6


Question: What is the 2019 average rate of increase in salaries?
Answer: 2.7
Calculation: (2.7+2.7)/2
28. FINANCIAL INSTRUMENTS (cont.)
(1) Other current and long-term financial assets classified as fair value through profit or loss were calculated using level 2 of the fair value hierarchy. All other balances were calculated using level 1 of the fair value hierarchy. (1) Other current and long-term financial assets classified as fair value through profit or loss were calculated using level 2 of the fair value hierarchy. All other balances were calculated using level 1 of the fair value hierarchy.
(2) Indebtedness excludes deferred financing costs and prepayment options (December 31, 2018 – deferred financing costs, interest rate floor, prepayment option and net gain on repricing/repayment). (2) Indebtedness excludes deferred financing costs and prepayment options (December 31, 2018 – deferred financing costs, interest rate floor, prepayment option and net gain on repricing/repayment).
(3) Trade and other receivables and trade and other payables approximate fair value due to the short-term maturity of these instruments.
Table:
As at December 31, 2018 | FVTPL | Amortised cost | Total | Fair Value | Fair Value hierarchy
Cash and cash equivalents | $ - | $768,433 | $768,433 | $768,433 | Level 1
Trade and other receivables | - | 45,631 | 45,631 | 45,631 | (3)
Other current financial assets (1) | 18,632 | 147 | 18,779 | 18,779 | Level 1, Level 2
Other long-term financial assets (1) | 33,796 | 21,959 | 55,755 | 55,755 | Level 1, Level 2
Trade and other payables | - | (30,659) | (30,659) | (30,659) | (3)
Other current financial liabilities | (6) | (26,380) | (26,386) | (29,131) | Level 2
Other long-term financial liabilities | (5,627) | (48,894) | (54,521) | (54,733) | Level 2
Indebtedness (2) | - | (3,853,883) | (3,853,883) | (3,709,695) | Level 2
 | $46,795 | $(3,123,646) | $(3,076,851) | $(2,935,620) | 


Question: What is the value of the the company's cash and cash equivalents as a percentage of its total financial instruments?
Answer: -24.97
Calculation: 768,433/(-3,076,851)
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: What is the average lease term?
Answer: 4.3 years
Note 16. Accrued Employee Compensation and Benefits
Accrued employee compensation and benefits consisted of the following (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Accrued compensation | $38,186 | $34,095
Accrued bonus and commissions | 27,039 | 19,835
Accrued vacation | 20,647 | 19,019
Accrued employment taxes | 16,468 | 15,598
Accrued severance and related costs (Note 5) | 485 | 793
Other | 6,766 | 6,473
 | $109,591 | $95,813


Question: In which years were the Accrued employee compensation and benefits calculated?
Answer: 2019, 2018
Note 11: Property and Equipment
Property and equipment, net, consist of the following:
Depreciation expense, including amortization of capital leases, during fiscal years 2019, 2018, and 2017, was $182.1 million, $165.2 million, and $152.3 million, respectively.
Table:
 | June 30, 2019 | June 24, 2018
 | (in thousands) | 
Manufacturing and engineering equipment | $1,039,454 | $911,140
Building sand improvements | 664,061 | 530,032
Computer and computer-related equipment | 190,974 | 182,451
Office equipment, furniture and fixtures | 82,115 | 66,378
Land | 46,155 | 46,155
 | 2,022,759 | 1,736,156
Less: accumulated depreciation and amortization | (963,682) | (833,609)
 | $1,059,077 | $902,547


Question: What is the depreciation expense, including amortization of capital leases, during fiscal year 2019?
Answer: $182.1 million
Realized and unrealized (losses) gains on non-designated derivative instruments. Realized and unrealized (losses) gains related to derivative instruments that are not designated as hedges for accounting purposes are included as a separate line item in the consolidated statements of loss. Net realized and unrealized losses on non-designated derivatives were $13.7 million for 2019, compared to $14.9 million for 2018, as detailed in the table below:
The realized losses relate to amounts we actually realized for settlements related to these derivative instruments in normal course and amounts paid to terminate interest rate swap agreement terminations.
During 2019 and 2018, we had interest rate swap agreements with aggregate average net outstanding notional amounts of approximately $1.1 billion and $1.3 billion, respectively, with average fixed rates of approximately 3.0% and 2.9%, respectively. Short-term variable benchmark interest rates during these periods were generally less than 3.0% and, as such, we incurred realized losses of $8.3 million and $13.9 million during 2019 and 2018, respectively, under the interest rate swap agreements.
We did not incur any realized losses related to the termination of interest rate swaps in 2019, compared to realized losses of $13.7 million during 2018. Primarily as a result of significant changes in long-term benchmark interest rates during 2019 and 2018, we recognized unrealized losses of $7.9 million in 2019 compared to unrealized gains of $33.7 million in 2018 under the interest rate swap agreements.
During the year ended December 31, 2019, we recognized a reversal of previously unrealized losses of $26.9 million on all the warrants held by Teekay to purchase common units of Altera (or the Warrants) as a result of the sale of the Warrants to Brookfield, and we concurrently recognized a realized loss of $25.6 million during the same period. During the year ended December 31, 2018, we recognized unrealized losses of $21.1 million on the Warrants. Please read “Item 18 – Financial Statements: Note 12 – Fair Value Measurements and Financial Instruments.”
Table:
 | Year Ended | Year Ended
 | December 31, 2019 | December 31, 2018
 | $ | $
Realized (losses) gains relating to: |  | 
Interest rate swap agreements | (8,296) | (13,898)
Interest rate swap agreement terminations | — | (13,681)
Foreign currency forward contracts | (147) | —
Stock purchase warrants | (25,559) | —
Forward freight agreements | 1,490 | 137
 | (32,512) | (27,442)
Unrealized (losses) gains relating to: |  | 
Interest rate swap agreements | (7,878) | 33,700
Foreign currency forward contracts | (200) | —
Stock purchase warrants | 26,900 | (21,053)
Forward freight agreements | (29) | (57)
 | 18,793 | 12,590
Total realized and unrealized losses on derivative instruments | (13,719) | (14,852)


Question: What is the increase/ (decrease) in Realized (losses) gains relating to Forward freight agreements from Year Ended December 31, 2019 to December 31, 2018?
Answer: 1353
Calculation: 1,490-137
item 1b . unresolved staff comments item 2 . properties we employ a variety of assets in the management and operation of our rail business . our rail network covers 23 states in the western two-thirds of the u.s . our rail network includes 32084 route miles . we own 26064 miles and operate on the remainder pursuant to trackage rights or leases . the following table describes track miles at december 31 , 2015 and 2014. .

Table:
 | 2015 | 2014
route | 32084 | 31974
other main line | 7012 | 6943
passing lines and turnouts | 3235 | 3197
switching and classification yard lines | 9108 | 9058
total miles | 51439 | 51172
headquarters building we own our headquarters building in omaha , nebraska .
the facility has 1.2 million square feet of space for approximately 4000 employees. .

Question: what percentage of total miles were other main line in 2015?
Answer: 14%
Calculation: divide(7012, 51439)
CASH FLOW ANALYSIS
(1) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy as well as to reclassify results from Cogeco Peer 1 as discontinued operations. For further details, please consult the "Accounting policies" and "Discontinued operations" sections. (2) For further details on the Corporation's cash flow attributable to discontinued operations, please consult the "Discontinued operations" section.
OPERATING ACTIVITIES Fiscal 2019 fourth-quarter cash flow from operating activities increased by 19.3% compared to the same period of the prior year mainly from: • higher adjusted EBITDA; • the decreases in income taxes paid and financial expense paid; and • the increase in changes in non-cash operating activities primarily due to changes in working capital.
INVESTING ACTIVITIES Fiscal 2019 fourth-quarter investing activities decreased by 25.8% compared to the same period of the prior year mainly due to the acquisition of spectrum licenses in the Canadian broadband services segment in the comparable period of the prior year combined with a decrease in acquisitions of property, plant and equipment.
Table:
Three months ended August 31, | 2019 | 2018 (1) | Change
(in thousands of dollars, except percentages) | $ | $ | %
Cash flow from operating activities | 304,702 | 255,438 | 19.3
Cash flow from investing activities | (144,332) | (194,474) | (25.8)
Cash flow from financing activities | (50,198) | (52,127) | (3.7)
Effect of exchange rate changes on cash and cash equivalents denominated in a foreign currency | (1,405) | (63) | —
Net change in cash and cash equivalents from continuing operations | 108,767 | 8,774 | —
Net change in cash and cash equivalent from discontinued operations(2) | — | 13,133 | (100.0)
Cash and cash equivalents, beginning of the period | 447,737 | 62,818 | —
Cash and cash equivalents, end of the period | 556,504 | 84,725 | —


Question: What was the increase in the operating activities in fourth-quarter 2019?
Answer: 19.3%
Product Warranties
The following table summarizes accrued warranty activities for fiscal 2019, 2018 and 2017:
In some cases, we may offer customers the option to purchase extended warranties to ensure protection beyond the standard warranty period. In those circumstances, the warranty is considered a distinct service and we account for the extended warranty as a performance obligation and allocate a portion of the transaction price to that performance obligation. More frequently, customers do not purchase a warranty separately. In those situations, we account for the warranty as an assurance-type warranty, which provides customers with assurance that the product complies with agreed-upon specifications, and this does not represent a separate performance obligation. Such warranties are recorded separately as liabilities and presented within ‘‘accrued liabilities’’ and ‘‘other long-term liabilities’’ on our consolidated balance sheets (see Note 5. Balance Sheet Components).
Table:
 |  | Fiscal Year Ended | 
(In thousands) | December 29, 2019 | December 30, 2018 | December 31, 2017
Balance at the beginning of the period | $172,266 | $181,303 | $161,209
Accruals for warranties issued during the period | 27,717 | 31,628 | 29,689
Settlements and adjustments during the period | (61,538) | (40,665) | (9,595)
Balance at the end of the period | $138,445 | $172,266 | $181,303


Question: Which year has the highest balance at the end of the period?
Answer: 2017
Calculation: $181,303 > $172,266 > $138,445
Plan Summaries
As of January 3, 2020, the Company had stock-based compensation awards outstanding under the following plans: the 2017 Omnibus Incentive Plan, 2006 Equity Incentive Plan, as amended, and the 2006 Employee Stock Purchase Plan, as amended ("ESPP"). Leidos issues new shares upon the issuance of the vesting of stock units or exercising of stock options under these plans.
In fiscal 2017, stockholders approved the 2017 Omnibus Incentive Plan which provides the Company and its affiliates' employees, directors and consultants the opportunity to receive various types of stock-based compensation awards, such as stock options, restricted stock units and performance-based awards, as well as cash awards.
The Company grants service-based awards that generally vest or become exercisable 25% a year over four years or cliff vest in three years. As of January 3, 2020, 4.4 million shares of Leidos' stock were reserved for future issuance under the 2017 Omnibus Incentive Plan and the 2006 Equity Incentive Plan.
The Company offers eligible employees the opportunity to defer restricted stock units into an equity-based deferred equity compensation plan, the Key Executive Stock Deferral Plan ("KESDP"). Prior to 2013, the Company offered an additional opportunity for deferrals into the Management Stock Compensation Plan ("MSCP"). Benefits from these plans are payable in shares of Leidos' stock that are held in a trust for the purpose of funding shares to the plans' participants.
Restricted stock units deferred under the KESDP are counted against the total shares available for future issuance under the 2017 Omnibus Incentive Plan. All awards under the MSCP are fully vested and the plan does not provide for a maximum number of shares available for future issuance.
The Company's ESPP allows eligible employees to purchase shares of Leidos' stock at a discount of up to 15% of the fair market value on the date of purchase. During the first half of fiscal 2018 and 2017, the discount was 5% of the fair market value on the date of purchase, thereby resulting in the ESPP being non-compensatory. Effective the second half of fiscal 2018, the Company increased the discount to 10% of the fair market value on the date of purchase, resulting in the ESPP being compensatory.
During fiscal 2019, 2018 and 2017, $25 million, $11 million and $10 million, respectively, was received from ESPP plan participants for the issuance of Leidos' stock. A total of 4.2 million shares remain available for future issuance under the ESPP.
Stock-based compensation and related tax benefits recognized under all plans were as follows:
Table:
 |  | Year Ended | 
 | January 3, 2020 | December 28, 2018 | December 29, 2017
 |  | (in millions) | 
Total stock-based compensation expense | $52 | $44 | $43
Tax benefits recognized from stock-based compensation | 13 | 11 | 17


Question: What was the number of Leidos' stock were reserved for future issuance under the 2017 Omnibus Incentive Plan and the 2006 Equity Incentive Plan?
Answer: 4.4 million