hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
The projected benefit obligation, accumulated benefit obligation and fair value of plan assets for those Pension Plans with accumulated benefit obligation in excess of fair value of plan assets is shown below:
Table:
 | As of December 31, | 
 | 2019 | 2018
Projected benefit obligation | $3,778 | $3,848
Accumulated benefit obligation | $2,999 | $3,028
Fair value of plan assets | $1,418 | $1,426


Question: What was the percentage change in the fair value of plan assets between 2018 and 2019?
Answer: -0.56
Calculation: ((1,418-1,426)/1,426) * 100
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
2018 Transactions
During the year ended December 31, 2019, the allocation of the final purchase price for the acquisition of Idea Cellular Infrastructure Services Limited was finalized with no material post-closing adjustments. During the year ended December 31, 2019, there were no material post-closing adjustments that impacted other 2018 acquisitions.
Pro Forma Consolidated Results (Unaudited)
The following table presents the unaudited pro forma financial results as if the 2019 acquisitions had occurred on January 1, 2018 and the 2018 acquisitions had occurred on January 1, 2017. The pro forma results do not include any anticipated cost synergies, costs or other integration impacts. Accordingly, such pro forma amounts are not necessarily indicative of the results that actually would have occurred had the transactions been completed on the dates indicated, nor are they indicative of the future operating results of the Company.
Table:
 | Year Ended December 31, | 
 | 2019 | 2018
Pro forma revenues | $7,904.2 | $7,936.0
Pro forma net income attributable to American Tower Corporation common stockholders | $1,844.9 | $1,122.6
Pro forma net income per common share amounts: |  | 
Basic net income attributable to American Tower Corporation common stockholders | $4.17 | $2.55
Diluted net income attributable to American Tower Corporation common stockholders | $4.14 | $2.53


Question: What was the change in the Diluted net income attributable to American Tower Corporation common stockholders between 2018 and 2019?
Answer: 1.61
Calculation: $4.14-$2.53
For the fourth quarter of 2019, we reported a net income of $392 million, compared to a net income of $302 million and $418 million in the prior and year-ago quarters, respectively. The fourth quarter 2019 net income represented diluted earnings per share of $0.43 compared to $0.34 in the prior quarter and $0.46 in the prior-year quarter.
Net income attributable to parent company
Table:
 |  | Three Months Ended | 
 | December 31, 2019 | September 29, 2019 | December 31, 2018
 |  | (Unaudited, in millions) | 
Net income attributable to parent company | $392 | $302 | $418
As percentage of net revenues | 14.2% | 11.8% | 15.8%


Question: What is the average percentage of net revenues for the period December 31, 2019 and 2018?
Answer: 15
Calculation: (14.2+15.8) / 2
9.4. Trade and other payables
Trade payables are unsecured and are usually paid within 30 days of recognition. Other payables and accruals are paid when amounts fall due. The carrying amounts of trade and other payables are assumed to be the same as their fair values, due to their short-term nature.
Table:
 | 2019 | 2018
 | $'000 | $'000
Current |  | 
Trade payables | 3,486 | 4,184
Accrued expenses | 6,706 | 2,717
GST and employment taxes payable | 2,644 | 1,256
Other payables | 6,157 | 4,161
Total | 18,993 | 12,318


Question: What is the change in GST and employment taxes payable from 2018 to 2019?
Answer: 1388
Calculation: 2,644-1,256
Accumulated Other Comprehensive Income
The following tables present the changes in the components of accumulated other comprehensive income (AOCI) for the years ended March 31, 2019 and 2018:
Table:
 | Unrealized Holding Gains (Losses) Available-for-sale Securities | Minimum Pension Liability | Foreign Currency | Total
Balance at March 31, 2017 | $0.3 | $(5.3) | $(9.4) | $(14.4)
Other comprehensive loss before reclassifications | (13.6) | (5.6) | — | (19.2)
Amounts reclassified from accumulated other comprehensive income (loss) | 15.2 | 0.8 | — | 16.0
Net other comprehensive loss | 1.6 | (4.8) | — | (3.2)
Balance at March 31, 2018 | $1.9 | $(10.1) | $(9.4) | $(17.6)


Question: How many years did the balance Unrealized Holding Gains Available-for-sale Securities exceed $1 million? 
Answer: 1
Calculation: 2018
Item 10. Directors, Executive Officers and Corporate Governance
Executive Officers of the Registrant
The following table sets forth information concerning the executive officers of Loral as of March 12, 2020.
The remaining information required under Item 10 will be presented in the Company’s 2020 definitive proxy statement which is incorporated herein by reference or by amendment to this Annual Report on Form 10‐K.
Table:
Name | Age | Position
Avi Katz | 61 | President, General Counsel and Secretary since December 2012. Senior Vice President, General Counsel and Secretary from January 2008 to December 2012.
John Capogrossi | 66 | Vice President, Chief Financial Officer and Treasurer since January 2016. Vice President, Chief Financial Officer, Treasurer and Controller from March 2013 to January 2016. Vice President and Controller from January 2008 to March 2013.
Ravinder S. Girgla | 56 | Vice President and Controller since January 2016. Deputy Controller from February 2013 to January 2016. Assistant Controller from July 2008 to February 2013.


Question: Who is the oldest executive officer in the company?
Answer: John Capogrossi
Calculation: 66>61>56
NOTE 17—SPECIAL CHARGES (RECOVERIES)
Special charges (recoveries) include costs and recoveries that relate to certain restructuring initiatives that we have undertaken from time to time under our various restructuring plans, as well as acquisition-related costs and other charges.
Table:
 |  | Year Ended June 30, | 
 | 2019 | 2018 | 2017
Fiscal 2019 Restructuring Plan | $28,318 | $— | $—
Fiscal 2018 Restructuring Plan | 515 | 10,154 | —
Fiscal 2017 Restructuring Plan | 898 | 7,207 | 33,827
Restructuring Plans prior to Fiscal 2017 Restructuring Plan | (620) | 279 | (340)
Acquisition-related costs | 5,625 | 4,805 | 15,938
Other charges (recoveries) | 983 | 6,766 | 14,193
Total | $35,719 | $29,211 | $63,618


Question: What is the difference between the total charges for fiscal year 2019 to 2018?
Answer: 6508
Calculation: 35,719-29,211
Share-based Compensation Expense The following table summarizes total compensation costs recognized for share-based payments during the years ended December 31, 2019, 2018 and 2017:
Income tax benefits related to share-based compensation of approximately $1.8 million, $1.3 million and $1.1 million were recorded for the years ended December 31, 2019, 2018 and 2017, respectively. Share-based compensation expense is included in “selling, general and administrative expenses” in the accompanying consolidated statements of operations.
As of December 31, 2019, total unrecognized compensation cost related to non-vested RSAs and PSAs was $10.6 million and will be recognized over a weighted-average period of approximately 1.7 years.
Table:
 |  | Year Ended December 31, | 
(In thousands) | 2019 | 2018 | 2017
Restricted stock | $ 4,013 | $ 3,249 | $ 1,986
Performance shares | 2,823 | 1,870 | 780
Total | $ 6,836 | $ 5,119 | $ 2,766


Question: What was the total unrecognized compensation cost related to non-vested RSAs and PSAs in 2019?
Answer: $10.6 million
29. Share-based payments continued
Share Incentive Plan
In 2015, the Group established a Share Incentive Plan (‘SIP’). All eligible employees were awarded free shares (or nil-cost options in the case of employees in Ireland) valued at £3,600 each based on the share price at the time of the Company’s admission to the Stock Exchange in March 2015, subject to a three-year service period (‘Vesting Period’). The SIP shareholders are entitled to dividends over the Vesting Period. There are no performance conditions applicable to the vesting of SIP shares. The fair value of the SIP awards at the grant date was measured to be £2.72 using the Black-Scholes model. The resulting share-based payments charge is being spread evenly over the Vesting Period.
Table:
 | Group |  | Company | 
 | 2019 | 2018 | 2019 | 2018
 | £m | £m | £m | £m
Share Incentive Plan (‘SIP’) | – | 0.8 | – | –
Sharesave scheme (‘SAYE’) | 0.3 | 0.3 | – | –
Performance Share Plan (‘PSP’) | 2.1 | 1.8 | 1.3 | 0.7
Deferred Annual Bonus and Single Incentive Plan | 2.3 | 0.4 | 0.4 | 0.2
Total share-based payment charge | 4.7 | 3.3 | 1.7 | 0.9
NI and apprenticeship levy on applicable schemes | 1.2 | 0.4 | 0.6 | 0.1
Total charge | 5.9 | 3.7 | 2.3 | 1.0


Question: In which year were the PSP payments for the Group larger?
Answer: 2019
Calculation: 2.1>1.8
performance graph the following graph and table compares the cumulative five-year total return provided to shareholders on our class a common stock relative to the cumulative total returns of the s&p 500 index and our customized peer group . the peer group includes cboe holdings , inc. , intercontinentalexchange group , inc . and nasdaq , inc . an investment of $ 100 ( with reinvestment of all dividends ) is assumed to have been made in our class a common stock , in the peer group and the s&p 500 index on december 31 , 2012 , and its relative performance is tracked through december 31 , 2017 . comparison of 5 year cumulative total return* among cme group inc. , the s&p 500 index , and a peer group 12/12 12/13 12/14 12/15 12/16 cme group inc . s&p 500 peer group * $ 100 invested on 12/31/12 in stock or index , including reinvestment of dividends . fiscal year ending december 31 . copyright a9 2018 standard & poor 2019s , a division of s&p global . all rights reserved . the stock price performance included in this graph is not necessarily indicative of future stock price performance. .

Table:
 | 2013 | 2014 | 2015 | 2016 | 2017
cme group inc . | $ 164.01 | $ 194.06 | $ 208.95 | $ 279.85 | $ 370.32
s&p 500 | 132.39 | 150.51 | 152.59 | 170.84 | 208.14
peer group | 176.61 | 187.48 | 219.99 | 249.31 | 323.23
unregistered sales of equity securities during the past three years there have not been any unregistered sales by the company of equity securities. .

Question: did the cme group outperform the s&p 500 over 5 years?
Answer: yes
Calculation: greater(370.32, 208.14)
Note 13. Investments Held in Rabbi Trust
The mutual funds held in the rabbi trust were 66% equity-based and 34% debt-based as of December 31, 2019. Net investment income (losses), included in “Other income (expense), net” in the accompanying Consolidated Statements of Operations consisted of the following (in thousands):
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Net realized gains (losses) from sales of trading securities | $143 | $10 | $195
Dividend and interest income | 419 | 635 | 422
Net unrealized holding gains (losses) | 1,817 | (1,512) | 1,002
 | $2,379 | $(867) | $1,619


Question: What was the amount of  Net unrealized holding gains (losses)  in 2018?
Answer: (1,512)
Geographic information
The Group is domiciled in the UK and the following tables detail external revenue by location of customers, trade receivables and non-current assets (excluding deferred tax) by geographic area:
Due to the large number of customers the Group serves, there are no individual customers whose revenue is greater than 10% of the Group’s total revenue in all periods presented in these financial statements.
Table:
 | 2019 | 2018
Revenue | £m | £m
UK | 349.9 | 324.9
Ireland | 5.2 | 5.2
Total revenue | 355.1 | 330.1


Question: What is the result of the Group serving a large number of customers?
Answer: no individual customers whose revenue is greater than 10% of the Group’s total revenue in all periods presented in these financial statements.
Cash Flow
Our cash flows from operating, investing and financing activities, as reflected in the Consolidated Statement of Cash Flows on page 71 are summarized in the table below. These amounts include the cash flows associated with the Global Financing business.
Net cash provided by operating activities decreased $477 million in 2019 driven by the following key factors: • An increase in cash income tax payments of $346 million; • An increase in interest payments on debt of approximately $300 million, driven by incremental debt used to fund the acquisition of Red Hat; and • Performance-related declines within net income, including lower operating cash flows due to businesses divested in 2019; partially offset by • An increase of $836 million in cash provided by financing receivables.
Net cash used in investing activities increased $22,023 million driven by: • An increase in net cash used for acquisitions of $32,491 million, primarily driven by the acquisition of Red Hat; offset by • An increase of $7,223 million in cash provided by net non-operating finance receivables primarily driven by the wind down of OEM IT commercial financing operations; • A decrease in cash used for net capital expenditures of $1,346 million; and • An increase in cash provided by divestitures of $1,076 million.
Financing activities were a net source of cash of $9,042 million in 2019 compared to a net use of cash of $10,469 million in 2018. The year-to-year increase in cash flow of $19,512 million was driven by: • An increase in net cash sourced from debt transactions of $16,584 million primarily driven by net issuances to fund the Red Hat acquisition; and • A decrease in cash used for gross common share repurchases of $3,082 million.
Table:
($ in millions) |  | 
For the year ended December 31: | 2019 | 2018
Net cash provided by/(used in) continuing operations |  | 
Operating activities | $14,770 | $15,247
Investing activities | (26,936) | (4,913)
Financing activities | 9,042 | (10,469)
Effect of exchange rate changes on cash, cash equivalents and restricted cash | (167) | (495)
Net change in cash, cash equivalents and restricted cash | $(3,290) | $(630)


Question: What caused the net cash provided by operating activities to decrease?
Answer: driven by the following key factors: • An increase in cash income tax payments of $346 million; • An increase in interest payments on debt of approximately $300 million, driven by incremental debt used to fund the acquisition of Red Hat; and • Performance-related declines within net income, including lower operating cash flows due to businesses divested in 2019; partially offset by • An increase of $836 million in cash provided by financing receivables.
Item 5. Market for Registrant’s Common Equity, Related Stockholder Matters and Issuer Purchases of Equity Securities
The Company’s common stock is traded on the NASDAQ Stock Market LLC (“NASDAQ”) under the symbol NTAP.
Price Range of Common Stock
The price range per share of common stock presented below represents the highest and lowest intraday sales prices for the Company’s common stock on the NASDAQ during each quarter of our two most recent fiscal years.
Holders
As of June 7, 2019 there were 413 holders of record of our common stock.
Table:
 |  | Fiscal 2019 |  | Fiscal 2018
 | High | Low | High | Low
First Quarter | $ 83.14 | $ 63.81 | $ 45.24 | $ 37.43
Second Quarter | $ 88.08 | $ 70.26 | $ 45.14 | $ 37.55
Third Quarter | $ 83.95 | $ 54.50 | $ 64.06 | $ 43.24
Fourth Quarter | $ 78.35 | $ 61.00 | $ 69.75 | $ 52.00


Question: What was high price per share in the first quarter of 2019?
Answer: 83.14
the company financed the acquisition with the proceeds from a $ 1.0 billion three-year term loan credit facility , $ 1.5 billion in unsecured notes , and the issuance of 61 million shares of aon common stock . in addition , as part of the consideration , certain outstanding hewitt stock options were converted into options to purchase 4.5 million shares of aon common stock . these items are detailed further in note 9 2018 2018debt 2019 2019 and note 12 2018 2018stockholders 2019 equity 2019 2019 . the transaction has been accounted for using the acquisition method of accounting which requires , among other things , that most assets acquired and liabilities assumed be recognized at their fair values as of the acquisition date . the following table summarizes the preliminary amounts recognized for assets acquired and liabilities assumed as of the acquisition date . certain estimated values are not yet finalized ( see below ) and are subject to change , which could be significant . the company will finalize the amounts recognized as information necessary to complete the analyses is obtained . the company expects to finalize these amounts as soon as possible but no later than one year from the acquisition the following table summarizes the preliminary values of assets acquired and liabilities assumed as of the acquisition date ( in millions ) : amounts recorded as of the acquisition .

Table:
 | amountsrecorded as ofthe acquisitiondate
working capital ( 1 ) | $ 391
property equipment and capitalized software | 319
identifiable intangible assets: | 
customer relationships | 1800
trademarks | 890
technology | 215
other noncurrent assets ( 2 ) | 344
long-term debt | 346
other noncurrent liabilities ( 3 ) | 361
net deferred tax liability ( 4 ) | 1035
net assets acquired | 2217
goodwill | 2715
total consideration transferred | $ 4932
( 1 ) includes cash and cash equivalents , short-term investments , client receivables , other current assets , accounts payable and other current liabilities .
( 2 ) includes primarily deferred contract costs and long-term investments .
( 3 ) includes primarily unfavorable lease obligations and deferred contract revenues .
( 4 ) included in other current assets ( $ 31 million ) , deferred tax assets ( $ 62 million ) , other current liabilities ( $ 32 million ) and deferred tax liabilities ( $ 1.1 billion ) in the company 2019s consolidated statements of financial position .
the acquired customer relationships are being amortized over a weighted average life of 12 years .
the technology asset is being amortized over 7 years and trademarks have been determined to have indefinite useful lives .
goodwill is calculated as the excess of the consideration transferred over the net assets acquired and represents the synergies and other benefits that are expected to arise from combining the operations of hewitt with the operations of aon , and the future economic benefits arising from other .

Question: what is portion of the total consideration transferred is dedicated to goodwill?
Answer: 55.0%
Calculation: divide(2715, 4932)
For the fourth quarter of 2019, we reported a net income of $392 million, compared to a net income of $302 million and $418 million in the prior and year-ago quarters, respectively. The fourth quarter 2019 net income represented diluted earnings per share of $0.43 compared to $0.34 in the prior quarter and $0.46 in the prior-year quarter.
Net income attributable to parent company
Table:
 |  | Three Months Ended | 
 | December 31, 2019 | September 29, 2019 | December 31, 2018
 |  | (Unaudited, in millions) | 
Net income attributable to parent company | $392 | $302 | $418
As percentage of net revenues | 14.2% | 11.8% | 15.8%


Question: What did the net income in the fourth quarter, 2019, represent?
Answer: The fourth quarter 2019 net income represented diluted earnings per share of $0.43 compared to $0.34 in the prior quarter and $0.46 in the prior-year quarter.
3. EARNINGS PER SHARE
Basic and diluted earnings (loss) per common share (“EPS”) are computed using the two-class method, which is an earnings allocation method that determines EPS for each class of common stock and participating securities considering dividends declared and participation rights in undistributed earnings. Certain of the Company’s restricted stock awards are considered participating securities because holders are entitled to receive non-forfeitable dividends, if declared, during the vesting term.
The potentially dilutive impact of the Company’s restricted stock awards is determined using the treasury stock method. Under the treasury stock method, if the average market price during the period exceeds the exercise price, these instruments are treated as if they had been exercised with the proceeds of exercise used to repurchase common stock at the average market price during the period. Any incremental difference between the assumed number of shares issued and repurchased is included in the diluted share computation.
Diluted EPS includes securities that could potentially dilute basic EPS during a reporting period. Dilutive securities are not included in the computation of loss per share when a company reports a net loss from continuing operations as the impact would be anti-dilutive.
The computation of basic and diluted EPS attributable to common shareholders computed using the two-class method is as follows:
Diluted EPS attributable to common shareholders for the years ended December 31, 2019, 2018 and 2017 excludes 1.1 million, 0.5 million and 0.3 million potential common shares, respectively, that could be issued under our share-based compensation plan, because the inclusion of the potential common shares would have an antidilutive effect.
Table:
(In thousands, except per share amounts) | 2019 | 2018 | 2017
Net income (loss) | $(19,931) | $(50,571) | $65,299
Less: net income attributable to noncontrolling interest | 452 | 263 | 354
Income (loss) attributable to common shareholders before allocation of earnings to participating securities | (20,383) | (50,834) | 64,945
Less: earnings allocated to participating securities | 462 | 810 | 362
Net income (loss) attributable to common shareholders, after earnings allocated to participating securities | $(20,845) | $(51,644) | $64,583
Weighted-average number of common shares outstanding | 70,837 | 70,613 | 60,373
Net income (loss) per common share attributable to common shareholders - basic and diluted | $ (0.29) | $ (0.73) | $ 1.07


Question: What is the excluded potential common shares for 2018?
Answer: 0.5 million
The following table summarizes the components of net periodic pension cost recognized in the consolidated statements of operations for the plans for the years ended December 31, 2019, 2018 and 2017:
The components of net periodic pension cost other than the service cost component are included in other, net within other income (expense) in the consolidated statements of operations.
In 2019, we purchased a group annuity contract to transfer the pension benefit obligations and annuity administration for a select group of retirees or their beneficiaries to an annuity provider. Upon issuance of the group annuity contract, the pension benefit obligation of $24.4 million for approximately 500 participants was irrevocably transferred to the annuity provider. The purchase of the group annuity was funded directly by the assets of the Pension Plans. During the year ended December 31, 2019, we recognized a pension settlement charge of $6.7 million as a result of the transfer of the pension liability to the annuity provider and other lump sum payments made during the year.
In 2018 and 2017, the Retirement Plan was amended to freeze benefit accruals under the cash balance benefit plan for certain participants under collective bargaining agreements. As a result of these amendments, we recognized a pre-tax curtailment gain of $1.2 million and $1.3 million as a component of net periodic pension cost during the years ended December 31, 2018 and 2017, respectively.
Table:
(In thousands) | 2019 | 2018 | 2017
Service cost | $ 50 | $ 5,809 | $ 3,055
Interest cost | 30,327 | 28,870 | 21,882
Expected return on plan assets | (34,627) | (38,640) | (28,459)
Amortization of: |  |  | 
Net actuarial loss | 2,890 | 6,110 | 6,244
Prior service cost (credit) | 123 | (204) | (316)
Plan curtailment | — | (1,156) | (1,337)
Plan settlement | 6,726 | 94 | 17
Net periodic pension cost | $ 5,489 | $ 883 | $ 1,086


Question: What was the service cost increase / (decrease) from 2018 to 2019?
Answer: -5759
Calculation: 50 - 5,809