hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
17. OTHER OPERATING EXPENSE
Other operating expense consists primarily of impairment charges, net losses on sales or disposals of assets and other operating expense items. The Company records impairment charges to write down certain assets to their net realizable value after an indicator of impairment is identified and subsequent analysis determines that the asset is either partially recoverable or not recoverable. These assets consisted primarily of towers and related assets, which are typically assessed on an individual basis, network location intangibles, which relate directly to towers, and tenant-related intangibles, which are assessed on a tenant basis. Net losses on sales or disposals of assets primarily relate to certain non-core towers, other assets and miscellaneous items. Other operating expenses includes acquisition-related costs and integration costs.
Impairment charges included the following for the years ended December 31,:
(1) For the year ended December 31, 2018, impairment charges on tower and network location intangible assets included $258.3 million in India primarily related to carrier consolidation-driven churn events. In addition, the Company fully impaired the tenant relationship for Aircel Ltd., which resulted in an impairment charge of $107.3 million.
(2) During the year ended December 31, 2017, $81.0 million of impairment charges on tower and network location intangible assets and all impairment charges on tenant relationships were related to carrier consolidation-driven churn in India.
(3) For the year ended December 31, 2019, amount includes impairment charges related to right-of-use assets and land easements.
Table:
 | 2019 | 2018 (1) | 2017 (2)
Tower and network location intangible assets | $77.4 | $284.9 | $108.7
Tenant relationships | — | 107.3 | 100.1
Other (3) | 16.8 | 1.8 | 2.6
Total impairment charges | $94.2 | $394.0 | $211.4


Question: How many years were the Tower and network location intangible assets above $100 million?
Answer: 2
Calculation: 2018##2017
purchases of equity securities the following table provides information about our repurchases of our common stock registered pursuant to section 12 of the securities exchange act of 1934 during the quarter ended december 31 , 2014 . period ( a ) number of shares purchased average price paid per share total number of shares purchased as part of publicly announced plans or programs ( b ) amount available for future share repurchases under the plans or programs ( b ) ( in millions ) .

Table:
period ( a ) | total number of shares purchased | average price paid per share | total number of shares purchased as part of publicly announced plans or programs ( b ) | amount available for future share repurchases under the plans or programs ( b ) ( in millions )
september 29 2014 2013 october 26 2014 | 399259 | $ 176.96 | 397911 | $ 3825
october 27 2014 2013 november 30 2014 | 504300 | $ 187.74 | 456904 | $ 3739
december 1 2014 2013 december 31 2014 | 365683 | $ 190.81 | 357413 | $ 3671
total | 1269242 ( c ) | $ 185.23 | 1212228 | $ 3671
total 1269242 ( c ) $ 185.23 1212228 $ 3671 ( a ) we close our books and records on the last sunday of each month to align our financial closing with our business processes , except for the month of december , as our fiscal year ends on december 31 .
as a result , our fiscal months often differ from the calendar months .
for example , september 29 , 2014 was the first day of our october 2014 fiscal month .
( b ) in october 2010 , our board of directors approved a share repurchase program pursuant to which we are authorized to repurchase our common stock in privately negotiated transactions or in the open market at prices per share not exceeding the then-current market prices .
on september 25 , 2014 , our board of directors authorized a $ 2.0 billion increase to the program .
under the program , management has discretion to determine the dollar amount of shares to be repurchased and the timing of any repurchases in compliance with applicable law and regulation .
we also may make purchases under the program pursuant to rule 10b5-1 plans .
the program does not have an expiration date .
( c ) during the quarter ended december 31 , 2014 , the total number of shares purchased included 57014 shares that were transferred to us by employees in satisfaction of minimum tax withholding obligations associated with the vesting of restricted stock units .
these purchases were made pursuant to a separate authorization by our board of directors and are not included within the program. .

Question: what is the growth rate in the average price of the purchased shares from october to november 2014?
Answer: 6.1%
Calculation: subtract(187.74, 176.96), divide(#0, 176.96)
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 did operating cash flows increased by from 2018 to 2019?
Answer: $64.4 million
NON-GAAP FINANCIAL MEASURES
Non-GAAP operating income, net income, and diluted EPS are non-GAAP financial measures which exclude the net tax impact of transfer of intangible properties, the net tax impact of the TCJA, and restructuring expenses. We believe these non-GAAP measures aid investors by providing additional insight into our operational performance and help clarify trends affecting our business. For comparability of reporting, management considers non-GAAP measures in conjunction with GAAP financial results in evaluating business performance. These non-GAAP financial measures presented should not be considered a substitute for, or superior to, the measures of financial performance prepared in accordance with GAAP.
The following table reconciles our financial results reported in accordance with GAAP to non-GAAP financial results:
* Not meaningful.
Table:
(In millions, except percentages and per share amounts) | 2019 | 2018 | 2017 | Percentage Change 2019 Versus 2018 | Percentage Change 2018 Versus 2017
Operating income | $42,959 | $35,058 | $  29,025 | 23% | 21%
Net tax impact of transfer of intangible properties | 0 | 0 | 0 | * | *
Net impact of the TCJA | 0 | 0 | 0 | * | *
Restructuring expenses | 0 | 0 | 306 | * | *
Non-GAAP operating income | $42,959 | $35,058 | $ 29,331 | 23% | 20%
Net income | $39,240 | $16,571 | $ 25,489 | 137% | (35)%
Net tax impact of transfer of intangible properties | (2,567) | 0 | 0 | * | *
Net tax impact of the TCJA | 157 | 13,696 | 0 |  | 
Restructuring expenses | 0 | 0 | 243 | * | *
Non-GAAP net income | $36,830 | $30,267 | $ 25,732 | 22% | 18%
Diluted earnings per share | $5.06 | $2.13 | $ 3.25 | 138% | (34)%
Net tax impact of transfer of intangible properties | (0.33) | 0 | 0 | * | *
Net tax impact of the TCJA | 0.02 | 1.75 | 0 | * | *
Restructuring expenses | 0 | 0 | 0.04 | * | *
Non-GAAP diluted earnings per share | $4.75 | $3.88 | $ 3.29 | 22% | 18%
* not meaningful |  |  |  |  | 


Question: What is the percentage change in operating income from 2017 to 2019?
Answer: 48.01
Calculation: (42,959-29,025)/29,025
Net debt
Net debt is a measure that provides valuable additional information on the summary presentation of the Group’s net financial liabilities and is a measure in common use elsewhere.
Prior to this quarter, all financial asset derivatives were current financial assets and so reduced net debt. Following a recent review we now also have financial asset derivatives that are non-current in nature. As all of these derivatives relate to financial liabilities, we continue to exclude them for the purposes of our net debt calculation and have expanded our definition to reflect this.
Net debt is now defined as the excess of total financial liabilities, excluding trade payables and other current liabilities, over cash, cash equivalents and other current financial assets, excluding trade and other current receivables, and non-current financial asset derivatives that relate to financial liabilities.
(a) Restated following adoption of IFRS 16. See note 1 and note 24 for further details.
Table:
 | € million | € million
 | 2019 | 2018
 |  | (Restated)(a)
Total financial liabilities | (28,257) | (26,738)
Current financial liabilities | (4,691) | (3,613)
Non-current financial liabilities | (23,566) | (23,125)
Cash and cash equivalents as per balance sheet | 4,185 | 3,230
Cash and cash equivalents as per cash flow statement | 4,116 | 3,090
Add bank overdrafts deducted therein | 69 | 140
Other current financial assets | 907 | 874
Non-current financial assets derivatives that relate to financial liabilities | 114 | –
Net debt | (23,051) | (22,634)


Question: What is the change in the Cash and cash equivalents as per balance sheet from 2018 to 2019?
Answer: 955
Calculation: (4,185 - 3,230)
VMware and Pivotal Stock Options
The following table summarizes stock option activity for VMware and Pivotal since February 3, 2017 (shares in thousands):
(1) The weighted-average exercise price of options outstanding as of February 1, 2019 reflects the adjustments to the options as a result of the Special Dividend.
(2) Stock option granted under the VMware equity plan includes 0.6 million options issued for unvested options assumed as part of the Pivotal acquisition.
(3) Stock options forfeited under the Pivotal equity plan includes 6.2 million options converted to VMware options as part of the Pivotal acquisition, using a conversion ratio of 0.1.
(4) Stock options exercised under the Pivotal equity plan includes 22.4 million of vested options that were settled in cash as part of the Pivotal acquisition.
The above table includes stock options granted in conjunction with unvested stock options assumed in business combinations. As a result, the weighted-average exercise price per share may vary from the VMware stock price at time of grant
The stock options outstanding as of January 31, 2020 had an aggregate intrinsic value of $239 million based on VMware’s closing stock price as of January 31, 2020.
Table:
 |  | VMware Stock Options |  | Pivotal Stock Options
 | Number of Shares | Weighted-Average Exercise Price (per share) | Number of Shares | Weighted-Average Exercise Price (per share)
Outstanding, February 3, 2017 | 1,991 | $69.38 | 39,361 | $6.72
Granted | 745 | 13.79 | 20,323 | 9.73
Forfeited | (36) | 55.44 | (2,380) | 8.13
Expired | (3) | 93.87 | (1,290) | 6.24
Exercised | (1,050) | 53.50 | (1,626) | 5.99
Outstanding, February 2, 2018 | 1,647 | 54.63 | 54,388 | 7.82
Granted | 574 | 16.07 | 2,832 | 14.03
Special Dividend adjustment | 348 | n/a | n/a | n/a
Forfeited | (31) | 24.44 | (2,028) | 9.35
Expired | — | — | (273) | 7.02
Exercised | (569) | 46.73 | (9,018) | 6.89
Outstanding, February 1, 2019(1) | 1,969 | 36.50 | 45,901 | 8.31
Granted(2) | 1,571 | 73.19 | — | —
Forfeited(3) | (149) | 52.83 | (10,822) | 10.65
Expired | — | — | (128) | 10.10
Exercised(4) | (776) | 39.94 | (34,951) | 7.59
Outstanding, January 31, 2020 | 2,615 | 56.58 | — | —


Question: What was the change in outstanding number of shares for VMware Stock Options between 2017 and 2018?
Answer: -344
Calculation: 1,647-1,991
Short-term borrowings and current portion of long-term obligations consist of the following (in thousands):
(1) Net of debt issuance costs of $4.6 million and $4.7 million at September 28, 2019 and September 29, 2018, respectively.
Table:
 | Fiscal year-end | 
 | 2019 | 2018
Current portion of Euro Term Loan(1) | $2,748 | $3,092
1.3% Term loan due 2024 | 1,367 | 1,448
1.0% State of Connecticut term loan due 2023 | 378 | 374
Capital lease obligations | 370 | 158
Line of credit borrowings | 10,000 | —
Total current portion of long-term obligations | $14,863 | $5,072


Question: What does the Current portion of Euro Term Loan consist of?
Answer: (1) Net of debt issuance costs of $4.6 million and $4.7 million at September 28, 2019 and September 29, 2018, respectively.
Stock Repurchases. On August 22, 2011, we established a share repurchase program ("Share Repurchase Program"). On June 11, 2019, our Board of Directors authorized an extension and increase of the Share Repurchase Program to repurchase up to $5,000,000 of shares of our common stock over the subsequent 24 month period (for a total authorization of approximately $22,000,000 since inception of the program in August 2011). The common stock may be repurchased from time to time in open market transactions or privately negotiated transactions in our discretion. The timing and amount of the shares repurchased is determined by management based on its evaluation of market conditions and other factors. The Share Repurchase Program may be increased, suspended or discontinued at any time.
During the months of October, November and December 2019, we repurchased common stock pursuant to our Share Repurchase Program as indicated below:
During the year ended December 31, 2019, we repurchased an aggregate of 335,372 shares of our common stock pursuant to our Share Repurchase Program at a cost of approximately $764,606 (exclusive of commissions) or an average price per share of $2.28.
During the year ended December 31, 2019, we repurchased an aggregate of 335,372 shares of our common stock pursuant to our Share Repurchase Program at a cost of approximately $764,606 (exclusive of commissions) or an average price per share of $2.28.
Since inception of our Share Repurchase Program (August 2011) to December 31, 2019, we repurchased an aggregate of 8,489,770 shares of our common stock at a cost of approximately $15,906,846 (exclusive of commissions) or an average per share price of $1.87.
Table:
Period | Total Number of Shares Purchased | Average Price Paid Per Share | Total Number of Shares Purchased as Part of Publicly Announced Plans or Programs | Maximum Number (or Approximate Dollar Value) of Shares) that May Yet Be Purchased Under the Plans or Programs
October 1, 2019 to October 31, 2019 | — | — | — | $4,803,723
November 1, 2019 to November 30, 2019 | 11,386 | $2.12 | 11,386 | $4,779,620
December 1, 2019 to December 31, 2019 | 153,431 | $2.18 | 153,431 | $4,445,258
Total | 164,817 | $2.17 | 164,817 | 


Question: How many shares did the company repurchase during the year ended December 31, 2019?
Answer: 335,372 shares
The credit quality and credit concentration of cash equivalents, current asset investments and derivative financial assets are detailed in the tables below. Where the opinion of Moody’s and Standard & Poor’s (S&P) differ, the lower rating is used.
a We hold cash collateral of £638m (2017/18: £492m, 2016/17: £702m) in respect of derivative financial assets with certain counterparties.
The concentration of credit risk for our trading balances is provided in note 17, which analyses outstanding balances by customerfacing unit. Where multiple transactions are undertaken with a single financial counterparty or group of related counterparties, we enter into netting arrangements to reduce our exposure to credit risk by making use of standard International Swaps and Derivatives Association (ISDA) documentation.
We have also entered into credit support agreements with certain swap counterparties whereby, on a daily, weekly and monthly basis, the fair value position on notional £3,289m of long dated cross-currency swaps and interest rate swaps is collateralised. The related net cash inflow during the year was £129m (2017/18: outflow £220m, 2016/17: inflow £100m). The collateral paid and received is recognised within current asset investments and loans and other borrowings, respectively.
Table:
 | 2019 | 2018 | 2017
Moody’s / S&P credit rating of counterparty | £m | £m | £m
Aa2/AA and above | 2,522 | 2,575 | 1,444
Aa3/AA– | 1,376 | 313 | 208
A1/A+a | 1,145 | 651 | 952
A2/Aa | 649 | 628 | 370
A3/A–a | 50 | 180 | 204
Baa1/BBB+a | 75 | 59 | 561
Baa2/BBB and below a | 160 | 207 | 86
 | 5,977 | 4,613 | 3,825


Question: What are the years that Moody’s / S&P credit rating of counterparty is provided?
Answer: 2017, 2018, 2019
G. PROPERTY, PLANT AND EQUIPMENT
Property, plant and equipment, net consisted of the following at December 31, 2019 and 2018:
Depreciation of property, plant and equipment for the years ended December 31, 2019, 2018, and 2017 was $70.8 million, $67.4 million, and $66.1 million, respectively. As of December 31, 2019 and 2018, the gross book value included in machinery and equipment for internally manufactured test systems being leased by customers was $5.4 million and $5.5 million, respectively. As of December 31, 2019 and 2018, the accumulated depreciation on these test systems was $5.1 million and $5.2 million, respectively.
Table:
 | 2019 | 2018
 | (in thousands) | 
Land | $16,561 | $16,561
Buildings | 107,282 | 105,935
Machinery, equipment and software | 834,970 | 752,722
Furniture and fixtures | 29,157 | 27,432
Leasehold improvements | 59,378 | 52,536
Construction in progress | 2,537 | 6,276
 | 1,049,885 | 961,462
Less: accumulated depreciation | 729,669 | 681,641
 | $320,216 | $279,821


Question: What was the accumulated depreciation on the test systems in 2019?
Answer: $5.1 million
Fiscal 2019 compared to fiscal 2018
The following table sets forth our Consolidated Statements of Operations data as a percentage of net revenues for the periods indicated:
Note: The percentages may not add due to rounding.
Table:
 | Fiscal Year | 
 | 2019 | 2018
Net revenues | 100% | 100%
Cost of revenues | 22 | 21
Gross profit | 78 | 79
Operating expenses: |  | 
Sales and marketing | 32 | 33
Research and development | 19 | 20
General and administrative | 9 | 12
Amortization of intangible assets | 4 | 5
Restructuring, transition and other costs | 5 | 8
Total operating expenses | 70 | 78
Operating income | 8 | 1
Interest expense | (4) | (5)
Gain on divestiture | — | 14
Other expense, net | (1) | —
Income from continuing operations before income taxes | 2 | 9
Income tax expense (benefit) | 2 | (14)
Income from continuing operations | — | 23
Income from discontinued operations, net of income taxes | — | —
Net income | 1% | 24%


Question: What is the change in Total operating expenses from fiscal year 2018 to fiscal year 2019?
Answer: -8
Calculation: 70-78
Seasonality
The Company’s sales, income and cash flow from operations vary between quarters, and are generally lowest in the first quarter of the from operations vary between quarters, and are generally lowest in the first quarter of the year and highest in the fourth quarter. This is mainly a result of the seasonal purchase patterns of network operators.
Table:
Most recent three-year average seasonality |  |  |  | 
 | First quarter | Second quarter | Third quarter | Fourth quarter
Sequential change, sales | -25% | 11% | 4% | 17%
Share of annual sales | 22% | 24% | 25% | 29%


Question: What is the share of annual sales in fourth quarter?
Answer: 29%
NOTE 17. FINANCIAL INSTRUMENTS AND FINANCIAL RISK MANAGEMENT
FINANCIAL INSTRUMENTS
Financial instruments include:
The carrying amounts of cash and cash equivalents, accounts receivable and accounts payable equal their fair values because of the short-term nature of these instruments.
Table:
 | December 31, | 
 | 2018 | 2019
Financial assets: |  | 
Cash and cash equivalents | 285,907 | 497,874
Accounts receivable | 173,450 | 199,535
Financial liabilities: |  | 
Accounts payable | 80,640 | 119,712


Question: Why is the carrying amounts of the segments of financial instrustments equal to their fair values?
Answer: because of the short-term nature of these instruments
6. Called up share capital
Accounting policies
Equity instruments issued by the Company are recorded at the amount of the proceeds received, net of direct issuance costs.
Notes: 1 At 31 March 2019 there were 50,000 (2018: 50,000) 7% cumulative fixed rate shares of £1 each in issue
2 At 31 March 2019 the Group held 1,584,882,610 (2018: 2,139,038,029) treasury shares with a nominal value of €264 million (2018: €356 million). The market value of shares held was €2,566 million (2018: €4,738 million). During the year, 45,657,750 (2018: 53,026,317) treasury shares were reissued under Group share schemes. On 25 August 2017, 729,077,001 treasury shares were issued in settlement of tranche 1 of a maturing subordinated mandatory convertible bond issued on 19 February 2016. On 25 February 2019, 799,067,749 treasury shares were issued in settlement of tranche 2 of the maturing subordinated mandatory convertible bond. On 5 March 2019 the Group announced the placing of subordinated mandatory convertible bonds totalling £1.72 billion with a 2 year maturity date in 2021 and £1.72 billion with a 3 year maturity date due in 2022. The bonds are convertible into a total of 2,547,204,739 ordinary shares with a conversion price of £1.3505 per share. For further details see note 20 “Borrowings and capital resources” in the consolidated financial statements.
3 Represents US share awards and option scheme awards.
Table:
 |  | 2019 |  | 2018
 | Number | €m | Number | €m
Ordinary shares of 2020⁄21 US cents each allotted, issued and fully paid:1, 2 |  |  |  | 
1 April | 28,814,803,308 | 4,796 | 28,814,142,848 | 4,796
Allotted during the year3 | 454,870 | – | 660,460 | –
31 March | 28,815,258,178 | 4,796 | 28,814,803,308 | 4,796


Question: What is the 2019 average amount of ordinary shares allotted during the year?
Answer: 557665
Calculation: (454,870+660,460)/2
2 0 0 8 a n n u a l r e p o r t stock performance graph the following graph sets forth the performance of our series a common , series b common stock , and series c common stock for the period september 18 , 2008 through december 31 , 2008 as compared with the performance of the standard and poor 2019s 500 index and a peer group index which consists of the walt disney company , time warner inc. , cbs corporation class b common stock , viacom , inc . class b common stock , news corporation class a common stock , and scripps network interactive , inc . the graph assumes $ 100 originally invested on september 18 , 2006 and that all subsequent dividends were reinvested in additional shares . september 18 , september 30 , december 31 , 2008 2008 2008 .

Table:
 | september 18 2008 | september 30 2008 | december 31 2008
disca | $ 100.00 | $ 103.19 | $ 102.53
discb | $ 100.00 | $ 105.54 | $ 78.53
disck | $ 100.00 | $ 88.50 | $ 83.69
s&p 500 | $ 100.00 | $ 96.54 | $ 74.86
peer group | $ 100.00 | $ 92.67 | $ 68.79
s&p 500 peer group .

Question: how much did the s&p 500 index decline in the fourth quarter?
Answer: 29%
Calculation: subtract(96.54, 74.86), divide(#0, 74.86)