hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
(18) Quarterly Financial Data (Unaudited)
During the first quarter of 2019, we recorded a non-cash, non-tax-deductible goodwill impairment charge of $6.5 billion for goodwill, see Note 4—Goodwill, Customer Relationships and Other Intangible Assets for further details.
During the fourth quarter of 2018, we recorded a non-cash, non-tax-deductible goodwill impairment charge of $2.7 billion for goodwill see Note 4—Goodwill, Customer Relationships and Other Intangible Assets for further details.
During the first quarter of 2018, we recognized $71 million of expenses related to our acquisition of Level 3 followed by acquisition-related expenses of $162 million, $43 million and $117 million in the second, third and fourth quarters of 2018, respectively. During 2019, we recognized expenses related to our acquisition of Level 3 of $34 million, $39 million, $38 million and $123 million in the first, second, third and fourth quarters of 2019, respectively.
Table:
 | First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total
 |  |  | (Dollars in millions, except per share amounts) |  | 
2019 |  |  |  |  | 
Operating revenue | $5,647 | 5,578 | 5,606 | 5,570 | 22,401
Operating (loss) income | (5,499) | 976 | 950 | 847 | (2,726)
Net (loss) income | (6,165) | 371 | 302 | 223 | (5,269)
Basic (loss) earnings per common share | (5.77) | 0.35 | 0.28 | 0.21 | (4.92)
Diluted (loss) earnings per common share | (5.77) | 0.35 | 0.28 | 0.21 | (4.92)
2018 |  |  |  |  | 
Operating revenue | $5,945 | 5,902 | 5,818 | 5,778 | 23,443
Operating income (loss) | 750 | 767 | 894 | (1,841) | 570
Net income (loss) | 115 | 292 | 272 | (2,412) | (1,733)
Basic earnings (loss) per common share | 0.11 | 0.27 | 0.25 | (2.26) | (1.63)
Diluted earnings (loss) per common share | 0.11 | 0.27 | 0.25 | (2.26) | (1.63)


Question: What is the total Operating (loss) income recorded in 2018?
Answer: 570
Net Cash Provided By Operating Activities and Free Cash Flow
The following table presents a reconciliation of net cash provided by operating activities to free cash flow (in thousands, except for percentages):
Net cash provided by operating activities for the twelve months ended December 31, 2019 was $115.5 million as compared to $90.3 million during the same period in 2018. The increase was primarily due to improved profitability, improved collections, and other working capital changes in 2019 when compared to the same period in 2018.
Free cash flow for the twelve months ended December 31, 2019 was $72.8 million, resulting in a free cash flow margin of 12.6%, as compared to free cash flow of $49.8 million and a free cash flow margin of 9.3% for the same period in 2018. The increase was primarily due to both improved profitability and collections, and is partially offset by cash paid for interest on our convertible notes of $17.4 million in the twelve months ended December 31, 2019. Refer to the section titled “Liquidity and Capital Resources” for additional information on the convertible notes.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Reconciliation of free cash flow: |  |  | 
Net cash provided by operating activities | $115,549 | $90,253 | $67,510
Capital expenditures | (18,034) | (14,895) | (7,100)
Capitalized software costs | (24,668) | (25,515) | (20,571)
Free cash flow | $72,847 | $49,843 | $39,839
Free cash flow margin | 12.6% | 9.3% | 8.3%


Question: What was the free cash flow in 2019?
Answer: $72,847
3. Operating (loss)/profit
Detailed below are the key amounts recognised in arriving at our operating (loss)/profit
Notes: 1 The year ended 31 March 2019 included €nil (2018: €80 million credit, 2017: €127 million charge) reported in other income and expense in the consolidated income statement
2 Reported in other income and expense in the consolidated income statement.
Table:
 | 2019 | 2018 | 2017
 | €m | €m | €m
Net foreign exchange losses/(gains)1 | 1 | (65) | 133
Depreciation of property, plant and equipment (note 11): |  |  | 
Owned assets | 5,795 | 5,963 | 6,253
Leased assets | 59 | 47 | 12
Amortisation of intangible assets (note 10) | 3,941 | 4,399 | 4,821
Impairment of goodwill in subsidiaries, associates and joint arrangements (note 4) | 3,525 | – | –
Staff costs (note 23) | 5,267 | 5,295 | 5,519
Amounts related to inventory included in cost of sales | 5,886 | 6,045 | 6,464
Operating lease rentals payable | 3,826 | 3,788 | 3,976
Loss on disposal of property, plant and equipment and intangible assets | 33 | 36 | 22
Own costs capitalised attributable to the construction or acquisition of property, plant and equipment | (844) | (829) | (800)
Net gain on formation of VodafoneZiggo (note 26)2 | – | – | (1,275)


Question: How much is the 2019 net foreign exchange losses?
Answer: 1
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
14. STOCK-BASED COMPENSATION
Summary of Stock-Based Compensation Plans—The Company maintains equity incentive plans that provide for the grant of stock-based awards to its directors, officers and employees. The 2007 Equity Incentive Plan, as amended (the “2007 Plan”), provides for the grant of non-qualified and incentive stock options, as well as restricted stock units, restricted stock and other stock-based awards. Exercise prices for non-qualified and incentive stock options are not less than the fair value of the underlying common stock on the date of grant. Equity awards typically vest ratably, generally over four years for RSUs and stock options and three years for PSUs. Stock options generally expire 10 years from the date of grant. As of December 31, 2019, the Company had the ability to grant stock-based awards with respect to an aggregate of 7.0 million shares of common stock under the 2007 Plan. In addition, the Company maintains an employee stock purchase plan (the “ESPP”) pursuant to which eligible employees may purchase shares of the Company’s common stock on the last day of each bi-annual offering period at a 15% discount from the lower of the closing market value on the first or last day of such offering period. The offering periods run from June 1 through November 30 and from December 1 through May 31 of each year.
During the years ended December 31, 2019, 2018 and 2017, the Company recorded and capitalized the following stock-based compensation expenses:
Table:
 | 2019 | 2018 | 2017
Stock-based compensation expense - Property | $1.8 | $2.4 | $2.1
Stock-based compensation expense - Services | 1.0 | 0.9 | 0.8
Stock-based compensation expense - SG&A | 108.6 | 134.2 | 105.6
Total stock-based compensation expense | $111.4 | $137.5 | $108.5
Stock-based compensation expense capitalized as property and equipment | $1.6 | $2.0 | $1.6


Question: What was the Stock-based compensation expense - Property in 2019?
Answer: $1.8
Contractual Obligations
Following is a summary of our contractual cash obligations as of February 28, 2019 (in thousands):
Purchase obligations consist primarily of inventory purchase commitments.
Table:
 |  |  | Future Estimated Cash Payments Due by Period |  | 
 | Less than | 1 - 3 | 3 - 5 |  | 
Contractual Obligations | 1 year | years | years | > 5 years | Total
Convertible senior notes principal | $- | $122,527 | $- | $230,000 | $352,527
Convertible senior notes stated interest | 6,591 | 10,196 | 9,200 | 6,900 | 32,887
Operating leases | 7,565 | 12,628 | 12,325 | 7,659 | 40,177
Purchase obligations | 39,390 | - | - | - | 39,390
Total contractual obligations | $53,546 | $145,351 | $21,525 | $244,559 | $464,981


Question: What are the Operating Leases as a percentage of the total contractual obligations? 
Answer: 8.64
Calculation: (40,177/464,981)
Note 3: Debt
The line item “Interest expense” on the Consolidated Statements of Operations for the fiscal years 2019, 2018 and 2017, respectively, is as follows (amounts in thousands):
Table:
 |  | Fiscal Years Ended March 31, | 
 | 2019 | 2018 | 2017
Contractual interest expense | $19,471 | $30,323 | $38,825
Capitalized interest | (232) | (141) | (154)
Amortization of debt issuance costs | 334 | 511 | 1,390
Amortization of debt (premium) discount | 1,481 | 1,843 | (788)
Imputed interest on acquisition related obligations | 57 | 113 | 159
Interest expense on capital leases | 128 | 233 | 323
Total interest expense | $21,239 | $32,882 | $39,755


Question: How many years did Interest expense on capital leases exceed $200 thousand?
Answer: 2
Calculation: 2018##2017
Our 2019 net revenues decreased 1.1% compared to the prior year, primarily due to a decrease in volumes of approximately 8%, partially compensated by an increase in average selling prices of approximately 7%. The increase in the average selling prices was driven by favorable product mix of approximately 10%, partially offset by a negative pricing effect of approximately 3%.
Our 2018 net revenues increased 15.8% compared to the prior year, primarily due to increase in average selling prices of approximately 16%, while volumes remained substantially flat. The increase in the average selling prices was driven by favorable product mix of approximately 18%, partially offset by a negative pricing effect of approximately 2%. Our net revenues registered double-digit growth across all product groups and geographies.
In 2019, 2018 and 2017, our largest customer, Apple, accounted for 17.6%, 13.1% and 10.5% of our net revenues, respectively, reported within our three product groups.
Table:
 | Year Ended December 31, | Year Ended December 31, | Year Ended December 31, | % Variation | % Variation
 | 2019 | 2018 | 2017 | 2019 vs 2018 | 2018 vs 2017
 | (in millions) | (in millions) | (in millions) |  | 
Net sales | $9,529 | $9,612 | $8,308 | (0.9)% | 15.7%
Other revenues | 27 | 52 | 39 | (49.0) | 36.1
Net revenues | $9,556 | $9,664 | $8,347 | (1.1)% | 15.8%


Question: What are the average other revenues?
Answer: 39.33
Calculation: (27+52+39) / 3
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
23. SELECTED QUARTERLY FINANCIAL DATA (UNAUDITED)
Selected quarterly financial data for the years ended December 31, 2019 and 2018 is as follows (in millions, except per share data):
(1) Represents Operating expenses, exclusive of Depreciation, amortization and accretion, Selling, general, administrative and development expense, and Other operating expenses.
Table:
 |  | Three Months Ended |  |  | 
 | March 31, | June 30, | September 30, | December 31, | Year Ended, December 31,
2019: |  |  |  |  | 
Operating revenues | $1,813.4 | $1,889.6 | $1,953.6 | $1,923.7 | $7,580.3
Costs of operations (1) | 543.4 | 563.3 | 559.9 | 550.2 | 2,216.8
Operating income | 614.9 | 683.9 | 728.3 | 661.3 | 2,688.4
Net income | 407.6 | 434.3 | 505.3 | 569.4 | 1,916.6
Net income attributable to American Tower Corporation stockholders | 397.4 | 429.1 | 498.6 | 562.7 | 1,887.8
Net income attributable to American Tower Corporation common stockholders | 397.4 | 429.1 | 498.6 | 562.7 | 1,887.8
Basic net income per share attributable to American Tower Corporation common stockholders | 0.90 | 0.97 | 1.13 | 1.27 | 4.27
Diluted net income per share attributable to American Tower Corporation common stockholders | 0.89 | 0.96 | 1.12 | 1.26 | 4.24


Question: What was the change in net income between Three Months Ended  June and September?
Answer: 71
Calculation: 505.3-434.3
Quantitative effect of ASC Topics 606 and 340-40 adoption
(1) While not shown here, gross margin, loss from operations, and loss before income taxes have consequently been affected as a result of the net effect of the adjustments noted above.
(2) The impact on the Consolidated Statements of Comprehensive Loss is limited to the net effects of the impacts noted above on the Consolidated Statements of Operations, specifically on the line item "Net loss."
Table:
 |  | For the Fiscal Year ended January 31, 2019 | 
 | As reported | Impact from the adoption of ASC 606 and 340-40 | As adjusted
Net revenue (1) |  |  | 
Subscription | $1,802.3 | $(16.6) | $1,785.7
Maintenance | 635.1 | 5.7 | 640.8
Other | 132.4 | (11.3) | 121.1
Cost of revenue (1) |  |  | 
Cost of subscription and maintenance revenue | 216.0 | (0.1) | 215.9
Cost of other revenue | 54.4 | 1.1 | 55.5
Operating expenses (1): |  |  | 
Marketing and sales | 1,183.9 | (17.9) | 1,166.0
Provision for income taxes | (38.1) | (4.8) | (42.9)
Net loss (2) | $(80.8) | $(10.1) | $(90.9)
Basic net loss per share | $(0.37) | $(0.05) | $(0.42)
Diluted net loss per share | $(0.37) | $(0.05) | $(0.42)


Question: What was the adjustment amount as a % of subscription net revenue?
Answer: 0.92
Calculation: (16.6/1,802.3)
lkq corporation and subsidiaries notes to consolidated financial statements ( continued ) note 5 . long-term obligations ( continued ) as part of the consideration for business acquisitions completed during 2007 , 2006 and 2005 , we issued promissory notes totaling approximately $ 1.7 million , $ 7.2 million and $ 6.4 million , respectively . the notes bear interest at annual rates of 3.0% ( 3.0 % ) to 6.0% ( 6.0 % ) , and interest is payable at maturity or in monthly installments . we also assumed certain liabilities in connection with a business acquisition during the second quarter of 2005 , including a promissory note with a remaining principle balance of approximately $ 0.2 million . the annual interest rate on the note , which was retired during 2006 , was note 6 . commitments and contingencies operating leases we are obligated under noncancelable operating leases for corporate office space , warehouse and distribution facilities , trucks and certain equipment . the future minimum lease commitments under these leases at december 31 , 2007 are as follows ( in thousands ) : years ending december 31: .

Table:
2008 | $ 42335
2009 | 33249
2010 | 25149
2011 | 17425
2012 | 11750
thereafter | 28581
future minimum lease payments | $ 158489
rental expense for operating leases was approximately $ 27.4 million , $ 18.6 million and $ 12.2 million during the years ended december 31 , 2007 , 2006 and 2005 , respectively .
we guaranty the residual values of the majority of our truck and equipment operating leases .
the residual values decline over the lease terms to a defined percentage of original cost .
in the event the lessor does not realize the residual value when a piece of equipment is sold , we would be responsible for a portion of the shortfall .
similarly , if the lessor realizes more than the residual value when a piece of equipment is sold , we would be paid the amount realized over the residual value .
had we terminated all of our operating leases subject to these guaranties at december 31 , 2007 , the guarantied residual value would have totaled approximately $ 24.0 million .
litigation and related contingencies on december 2 , 2005 , ford global technologies , llc ( 2018 2018ford 2019 2019 ) filed a complaint with the united states international trade commission ( 2018 2018usitc 2019 2019 ) against keystone and five other named respondents , including four taiwan-based manufacturers .
on december 12 , 2005 , ford filed an amended complaint .
both the complaint and the amended complaint contended that keystone and the other respondents infringed 14 design patents that ford alleges cover eight parts on the 2004-2005 .

Question: in 2007 what was the percent of the the total future minimum lease commitments and contingencies for operating leases that was due in 2009
Answer: 21%
Calculation: divide(33249, 158489)
Stock Repurchase Program
As of April 26, 2019, our Board of Directors has authorized the repurchase of up to $13.6 billion of our common stock under our stock repurchase program . Under this program, which we may suspend or discontinue at any time, we may purchase shares of our outstanding common stock through solicited or unsolicited transactions in the open market, in privately negotiated transactions, through accelerated share repurchase programs, pursuant to a Rule 10b5-1 plan or in such other manner as deemed appropriate by our management.
The following table summarizes activity related to this program (in millions, except per share amounts):
The aggregate purchase price of our stock repurchases for fiscal 2019 consisted of $2.1 billion of open market purchases of which $1.0 billion and $1.1 billion were allocated to additional paid-in capital and retained earnings (accumulated deficit), respectively.
Since the May 13, 2003 inception of our stock repurchase program through April 26, 2019, we repurchased a total of 313 million shares of our common stock at an average price of $37.46 per share, for an aggregate purchase price of $11.7 billion.
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
Number of shares repurchased | 29 | 15 | 22
Average price per share | $ 72.87 | $ 51.57 | $ 32.72
Aggregate purchase price | $ 2,111 | $ 794 | $ 705
Remaining authorization at end of period | $ 1,889 | $ 4,000 | $ 794


Question: What was the percentage change in the Remaining authorization at end of period between 2018 and 2019?
Answer: -52.78
Calculation: (1,889-4,000)/4,000
Other intangible assets at fiscal year ends 2019 and 2018 consisted of the following:
Goodwill, trademarks and tradenames are considered to have indefinite useful lives and therefore no amortization has been taken on these assets. The Company’s retail reporting unit recorded intangible asset (trademarks and tradenames) impairment charges of approximately $2.9 million during fiscal 2019 and goodwill impairment charges of approximately $1.9 million during fiscal 2018 when it was determined that the carrying values of these assets exceeded their fair values. These impairment charges arose from a range of considerations including, but not limited to, heightened competition in the industry, retail sector market conditions, and earning shortfalls which impacted the Company’s projections of future cash flows to be generated. These impairment charges were recorded in the Company’s consolidated statement of operations as a component of operating income.
Goodwill recorded on the Company’s consolidated balance sheet represents amounts allocated to its wholesale reporting unit which totaled $4.4 million at both September 2019 and September 2018. The Company determined that the estimated fair value of its wholesale reporting unit exceeded its carrying value at both September 2019 and September 2018.
Table:
 | September 2019 | September 2018
Trademarks and tradenames (Retail Segment) | $500,000 | $3,373,269
ustomer relationships (Wholesale Segment) (less accumulated amortization of approximately $2.1 million at both September 2019 and September 2018) | — | 41,667
 | $  500,000 | $3,414,936


Question: What is the value of the company's trademarks and tradenames as a percentage of its total intangible assets in 2018?
Answer: 98.78
Calculation: 3,373,269/3,414,936
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.
The following tables summarize the unrealized gains and losses related to our available-for-sale marketable securities, by major security type, as of December 31, 2019 and 2018 (in thousands):
As of December 31, 2019, we had no investments in a loss position for a period of time greater than 12 months. As of December 31, 2018, we identified 15 investments totaling $207.2 million that had been in a loss position for a period of time greater than 12 months with unrealized losses of $1.8 million. The unrealized losses were primarily due to increases in interest rates relative to rates at the time of purchase. Based on the underlying credit quality of the investments, we generally hold such securities until we recover our cost basis. Therefore, we did not consider these securities to be other-than-temporarily impaired.
Table:
 |  | As of December 31, 2019 |  | 
 | Amortized | Unrealized | Unrealized | Fair
 | Cost | Gains | Losses | Value
Foreign debt . | $387,775 | $551 | $506 | $387,820
Foreign government obligations | 21,991 | 20 | — | 22,011
U.S. debt | 65,970 | 176 | 12 | 66,134
Time deposits | 335,541 | — | — | 335,541
Total . | $811,277 | $747 | $518 | $811,506


Question: What amount of proceeds was derived from selling marketable securities in 2019?
Answer: 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.
10. Income Taxes:
For financial reporting purposes, income before income taxes included the following components:
Table:
 |  | Fiscal Year Ended March 31 | 
 | 2017 | 2018 | 2019
Domestic | $75,659 | $85,263 | $215,573
Foreign | 99,290 | 107,050 | 117,670
Total | $174,949 | $192,313 | $333,243


Question: What is the proportion of the domestic income as a percentage of the total income in 2019?
Answer: 64.69
Calculation: 215,573/333,243
incentive compensation cost the following table shows components of compensation expense , relating to certain of the incentive compensation programs described above : in a0millions a0of a0dollars 2018 2017 2016 charges for estimated awards to retirement-eligible employees $ 669 $ 659 $ 555 amortization of deferred cash awards , deferred cash stock units and performance stock units 202 354 336 immediately vested stock award expense ( 1 ) 75 70 73 amortization of restricted and deferred stock awards ( 2 ) 435 474 509 .

Table:
in millions of dollars | 2018 | 2017 | 2016
charges for estimated awards to retirement-eligible employees | $ 669 | $ 659 | $ 555
amortization of deferred cash awards deferred cash stock units and performance stock units | 202 | 354 | 336
immediately vested stock award expense ( 1 ) | 75 | 70 | 73
amortization of restricted and deferred stock awards ( 2 ) | 435 | 474 | 509
other variable incentive compensation | 640 | 694 | 710
total | $ 2021 | $ 2251 | $ 2183
( 1 ) represents expense for immediately vested stock awards that generally were stock payments in lieu of cash compensation .
the expense is generally accrued as cash incentive compensation in the year prior to grant .
( 2 ) all periods include amortization expense for all unvested awards to non-retirement-eligible employees. .

Question: in 2018 what was the percent of the incentive compensation associated with charges for estimated awards to retirement-eligible employees
Answer: 33.1%
Calculation: divide(669, 2021)
Other Assets
Other assets consist of the following (in thousands):
The Company’s other assets includes a strategic equity investment in a privately-held company. The strategic investment is a non-marketable equity security, in which the Company does not have a controlling interest or the ability to exert significant influence. This investment does not have a readily determinable market value. The Company records this strategic investment at cost less impairment and adjusts cost for subsequent observable price changes. During the years ended July 31, 2019 and 2018, there were no changes in the investment’s carrying value of $10.7 million.
Table:
 | July 31, 2019  | July 31, 2018
Prepaid expenses | $2,640 | $2,476
Contract costs | 23,375 | —
Deferred costs | 8,867 | 9,377
Strategic investments | 10,672 | 10,672
Other assets | $45,554 | 22,525


Question: What does the company's other assets include?
Answer: a strategic equity investment in a privately-held company.