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)
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 Basic net income per share attributable to American Tower Corporation common stockholders in Three Months Ended  September?
Answer: 1.13
Our net sales by market sector for the indicated fiscal years were as follows (in millions):
Healthcare/Life Sciences. Net sales for fiscal 2019 in the Healthcare/Life Sciences sector increased $180.1 million, or 17.3%, as compared to fiscal 2018. The increase was driven by overall net increased customer end-market demand, a $32.7 million increase in production ramps of new products for existing customers and a $26.9 million increase in production ramps for new customers.
Industrial/Commercial. Net sales for fiscal 2019 in the Industrial/Commercial sector increased $63.5 million, or 6.9%, as compared to fiscal 2018. The increase was driven by a $64.8 million increase in production ramps of new products for existing customers and a $33.2 million increase in production ramps for new customers. The increase was partially offset by a $7.3 million decrease due to end-of-life products, a $4.2 million decrease due to a disengagement with a customer and overall net decreased customer end-market demand.
Aerospace/Defense. Net sales for fiscal 2019 in the Aerospace/Defense sector increased $143.5 million, or 32.2%, as compared to fiscal 2018. The increase was driven by a $120.2 million increase in production ramps of new products for existing customers, a $9.9 million increase in production ramps for new customers and overall net increased customer end-market demand.
Communications. Net sales for fiscal 2019 in the Communications sector decreased $96.2 million, or 20.4%, as compared to fiscal 2018. The decrease was driven by a $37.3 million reduction due to disengagements with customers, a $15.3 million decrease due to end-of-life products and overall net decreased customer endmarket demand. The decrease was partially offset by an $18.1 million increase in production ramps of new products for existing customers and a $4.5 million increase in production ramps for new customers.
Table:
Market Sector  | 2019 | 2018
Healthcare/Life Sciences  | $1,220.0 | $1,039.9
Industrial/Commercial  | 981.2 | 917.7
Aerospace/Defense  | 588.6 | 445.1
Communications  | 374.6 | 470.8
Total net sales | 3,164.4 | 2,873.5


Question: What was the net sales in the healthcare/life sciences sector in 2019?
Answer: 1,220.0
table of contents other areas in which we do business . depending on the scope of such regulation , certain of our facilities and operations , or the operations of our suppliers , may be subject to additional operating and other permit requirements , potentially resulting in increased operating costs . future regulatory developments future regulatory developments and actions could affect operations and increase operating costs for the airline industry , including our airline subsidiaries . see part i , item 1a . risk factors 2013 201cif we are unable to obtain and maintain adequate facilities and infrastructure throughout our system and , at some airports , adequate slots , we may be unable to operate our existing flight schedule and to expand or change our route network in the future , which may have a material adverse impact on our operations , 201d 201cour business is subject to extensive government regulation , which may result in increases in our costs , disruptions to our operations , limits on our operating flexibility , reductions in the demand for air travel , and competitive disadvantages 201d and 201cwe are subject to many forms of environmental regulation and may incur substantial costs as a result 201d for additional information . employees and labor relations the airline business is labor intensive . in 2015 , salaries , wages and benefits were our largest expenses and represented approximately 31% ( 31 % ) of our operating expenses . the table below presents our approximate number of active full-time equivalent employees as of december 31 , 2015 . mainline operations wholly-owned regional carriers total .

Table:
 | mainline operations | wholly-owned regional carriers | total
pilots and flight crew training instructors | 13100 | 3200 | 16300
flight attendants | 24100 | 1900 | 26000
maintenance personnel | 14400 | 1800 | 16200
fleet service personnel | 16100 | 3200 | 19300
passenger service personnel | 16500 | 7100 | 23600
administrative and other | 14700 | 2400 | 17100
total | 98900 | 19600 | 118500
.

Question: what is the percent of the mainline operations full-time equivalent employees to the total number of full-time equivalent employees
Answer: 83.5%
Calculation: divide(98900, 118500)
Item 16C. PRINCIPAL ACCOUNTANT FEES AND SERVICES
Aggregate audit fees, audit-related fees, tax fees and the aggregate of all other fees billed to us by Ernst & Young LLP for the fiscal years ended June 30, 2019 and 2018 were as follows:
(1) Audit Fees consist of fees incurred for professional services rendered for the integrated audit of our annual consolidated financial statements, review of the quarterly consolidated financial statements and foreign statutory audits and services that are normally provided by Ernst & Young LLP in connection with statutory and regulatory filings or engagements. Audit fees also include accounting consultations, research related to the integrated audit and comfort letter services in relation to our exchangeable senior notes.
(2) Audit-Related Fees consist of fees billed for assurance and related services that are reasonably related to the performance of the audit or review of the Company’s consolidated financial statements and are not reported under “Audit Fees.” This primarily consists of fees for service organization control audits and due diligence on acquisitions.
(3) Tax fees relate to assistance with tax compliance, tax planning and various tax advisory services.
(4) Other fees are any additional amounts for products and services provided by the principal accountants.
Our audit committee has adopted a pre-approval policy for the engagement of our independent accountant to perform certain audit and non-audit services. Pursuant to this policy, which is designed to assure that such engagements do not impair the independence of our auditors, the audit committee pre-approves annually all audit services, audit related services, tax services and other services as described above, that may be performed by our independent accountants. All of the audit and non-audit services provided by our principal accountants have been pre-approved by our Audit Committee.
Table:
 | 2019 | 2018
 | (U.S. $ in thousands) | 
Audit fees (1) | $2,980 | $3,469
Audit-related fees (2) | 648 | 447
Tax fees (3) | 220 | 238
Other fees (4) | 8 | 3
Total | $3,856 | $4,157


Question: What does tax fees refer to?
Answer: Assistance with tax compliance, tax planning and various tax advisory services.
Contractual Obligations and Commitments
The following table summarizes our contractual cash obligations and other commercial commitments as of December 31, 2019.
(1) These amounts include interest and principal payment obligations on our €135.0 million of 2024 Notes through the maturity date of June 30, 2024, interest and principal payments on our $445.0 million of 2022 Notes through the maturity date of March 1, 2022, interest and principal payments on our $189.2 million of 2021 Notes through the maturity date of April 15, 2021 and $12.5 million due under an installment payment agreement with a vendor.
(2) The amounts include principal and interest payments under our finance lease obligations. Our finance lease obligations were incurred in connection with IRUs for inter-city and intra-city dark fiber underlying substantial portions of our network. These finance leases are presented on our balance sheet at the net present value of the future minimum lease payments, or $169.8 million at December 31, 2019. These leases generally have initial terms of 15 to 20 years.
(3) These amounts include amounts due under our facilities, operating leases, colocation obligations and carrier neutral data center obligations. Certain of these operating lease liabilities are presented on our balance sheet at the net present value of the future minimum lease payments, or $96.8 million at December 31, 2019.
(4) These amounts include amounts due under unconditional purchase obligations including dark fiber IRU operating and finance lease agreements entered into but not delivered and accepted prior to December 31, 2019.
Table:
 |  |  | Payments due by period |  | 
 | Total | Less than 1 year | 1 - 3 years | 3 - 5 years | After 5 years
 |  |  | (in thousands) |  | 
Debt(1) | 903,696 | 50,601 | 691,748 | 161,347 | —
Finance lease obligations(2) | 340,188 | 25,459 | 48,693 | 45,311 | 220,725
Operating leases, colocation and data center obligations(3) | 205,087 | 36,119 | 42,344 | 26,138 | 100,486
Unconditional purchase obligations(4) | 27,885 | 12,154 | 1,346 | 1,307 | 13,078
Total contractual cash obligations | $1,476,856 | $124,333 | $784,131 | $234,103 | $334,289


Question: What is the company's total finance lease obligations due within 3 years?
Answer: 74152
Calculation: (48,693 + 25,459)
The following table summarizes the activity related to the Company's gross unrecognized tax benefits from April 1, 2016 to March 31, 2019 (amounts in millions):
As of March 31, 2019 and March 31, 2018, the Company had accrued interest and penalties related to tax contingencies of $88.1 million and $80.8 million, respectively. Interest and penalties charged to operations for the years ended March 31, 2018 and 2017 related to the Company's uncertain tax positions were $5.4 million and $5.8 million, respectively. Previously accrued interest and penalties that were released during the year ended March 31, 2019 were $37.5 million.
The total amount of gross unrecognized tax benefits was $763.4 million and $436.0 million as of March 31, 2019 and March 31, 2018, respectively, of which $664.4 million and $436.0 million is estimated to impact the Company's effective tax rate, if recognized. The Company estimates that it is reasonably possible unrecognized tax benefits as of March 31, 2019 could decrease by approximately $50.0 million in the next 12 months. Positions that may be resolved include various U.S. and non-U.S. matters.
Table:
 |  | Year Ended March 31, | 
 | 2019 | 2018 | 2017
Beginning balance | $436.0 | $398.5 | $220.7
Increases related to acquisitions | 329.7 | — | 193.3
Decreases related to settlements with tax authorities | (8.3) | (0.1) | (11.7)
Decreases related to statute of limitation expirations | (16.2) | (10.9) | (7.6)
Increases related to current year tax positions | 27.8 | 30.3 | 26.3
Increases (decreases) related to prior year tax positions | (5.6) | 18.2 | (22.5)
Ending balance | $763.4 | $436.0 | $398.5


Question: What was the company's accrued interest and penalties related to tax contingencies in 2018?
Answer: 80.8
GasLog Ltd. and its Subsidiaries
Notes to the consolidated financial statements (Continued)
For the years ended December 31, 2017, 2018 and 2019
(All amounts expressed in thousands of U.S. Dollars, except share and per share data)
8. Cash and Cash Equivalents
Cash and cash equivalents consist of the following:
Ship management client accounts represent amounts provided by the clients of GasLog LNG Services Ltd. in order to enable the Group to cover obligations of vessels under management. A compensating balance is held as a current liability.
Table:
 | As of December 31, | 
 | 2018 | 2019
Current accounts | 220,089 | 113,655
Time deposits (with original maturities of three months or less). | 121,925 | 149,491
Ship management client accounts | 580 | 601
Total | 342,594 | 263,747


Question: In which year was the time deposits higher?
Answer: 2019
Calculation: 149,491 > 121,925
Allowance for Doubtful Accounts
The Company bases its allowance for doubtful accounts on its historical collection experience and a review in each period of the status of the then outstanding accounts receivable.
A reconciliation of the beginning and ending amount of allowance for doubtful accounts is as follows (in thousands):
The Company recognized bad debt expense of $0.5 million, $0.8 million, and $1.4 million for the years ended December 31, 2019, 2018, and 2017, respectively.
Table:
 | 2019 | 2018 | 2017
Beginning balance, January 1 | $2,429 | $7,478 | $3,532
Additions and adjustments | 1,074 | 1,691 | 7,680
Write-offs | (2,128) | (6,740) | (3,734)
Ending balance, December 31 | $1,375 | $2,429 | $7,478


Question: What was the ending balance in December 31 2017?
Answer: $7,478
Item 6. Selected Financial Data
The following table sets forth selected consolidated financial data for each of the fiscal years ended June 30, 2019, 2018, 2017, 2016 and 2015 derived from the Company’s audited financial statements (in thousands, except per share amounts). The consolidated financial data as of and for the years ended June 30, 2015 are derived from the audited financial statements which have not been adjusted for the adoption of Accounting Standards update 2014- 09, Revenue from Contracts with Customers (Topic 606). These tables should be reviewed in conjunction with the Consolidated Financial Statements in Item 8 and related Notes, as well as Item 7, “Management’s Discussion and Analysis of Financial Condition and Results of Operations.” Historical results may not be indicative of future results.
(1) Operating income (loss) include the following operating expenses (in thousands):
(2)  The significant increase in net revenues during the year ended June 30, 2018 was primarily due to the acquisitions of the Campus Fabric and Data Center Businesses.
Table:
 |  | Year Ended June 30, |  |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
Consolidated Statements of Operations Data:                     |  |  |  |  | 
Net revenues | $995,789 | $983,142 (2) | $607,084 | $519,834 | $552,940
Operating income (loss) (1) | $(14,726) | $(38,210) | $6,040 | $(30,029) | $(62,994)
Net loss | $(25,853) | $(46,792) | $(1,744) | $(36,363) | $(71,643)
Net loss per share – basic | $(0.22) | $(0.41) | $(0.02) | $(0.35) | $(0.72)
Net loss per share – diluted | $(0.22) | $(0.41) | $(0.02) | $(0.35) | $(0.72)
Shares used in per share calculation – basic | 117,954 | 114,221 | 108,273 | 103,074 | 99,000
Shares used in per share calculation – diluted | 117,954 | 114,221 | 108,273 | 103,074 | 99,000


Question: Which years does the table provide information for the company's audited financial statements?
Answer: 2019, 2018, 2017, 2016, 2015
The following table provides the company’s operating (non-GAAP) earnings for 2019 and 2018. See page 46 for additional information.
* 2019 results were impacted by Red Hat purchase accounting and acquisition-related activity.
** Includes charges of $2.0 billion in 2018 associated with U.S. tax reform.
Table:
($ in millions except per share amounts) |  |  | 
For the year ended December 31:* | 2019 | 2018 | Yr.-to-Yr. Percent Change
Net income as reported | $ 9,431 | 8,728* | 8.1%
Income/(loss) from discontinued operations, net of tax | (4) | 5 | NM
Income from continuing operations | $ 9,435 | 8,723* | 8.2%
Non-operating adjustments (net of tax) |  |  | 
Acquisition-related charges | 1,343 | 649 | 107.0
Non-operating retirement-related costs/(income) | 512 | 1,248 | (58.9)
U.S. tax reform charge | 146 | 2,037 | (92.8)
Operating (non-GAAP) earnings | $11,436 | $12,657 | (9.6)%
Diluted operating (non-GAAP) earnings per share | $ 12.81 | $ 13.81 | (7.2)%


Question: What was the increase / (decrease) in Net income from 2018 to 2019?
Answer: 703
Calculation: 9,431 - 8,728
Free Cash Flow
Free cash flow is a non-IFRS financial measure that we calculate as net cash provided by operating activities less net cash used in investing activities for capital expenditures.
Free cash flow increased by $140.9 million during the fiscal year ended June 30, 2019 due to a $154.9 million increase of net cash provided by operating activities, offset by a $14.0 million increase of capital expenditures as we continue to invest in our facilities.
For more information about net cash provided by operating activities, please see “Liquidity and Capital Resources”.
Table:
 |  | Fiscal Year Ended June 30, | 
 | 2019 | 2018 | 2017
Net cash provided by operating activities | $466,342 | $311,456 | $199,381
Less: Capital expenditures | (44,192) | (30,209) | (15,129)
Free cash flow | $422,150 | $281,247 | $184,252


Question: What is the average net cash provided by operating activities from 2017-2019?
Answer: 325726.33
Calculation: (466,342+311,456+199,381)/3
stock performance graph * $ 100 invested on 11/17/11 in our stock or 10/31/11 in the relevant index , including reinvestment of dividends . fiscal year ending december 31 , 2013 . ( 1 ) delphi automotive plc ( 2 ) s&p 500 2013 standard & poor 2019s 500 total return index ( 3 ) automotive supplier peer group 2013 russell 3000 auto parts index , including american axle & manufacturing , borgwarner inc. , cooper tire & rubber company , dana holding corp. , delphi automotive plc , dorman products inc. , federal-mogul corp. , ford motor co. , fuel systems solutions inc. , general motors co. , gentex corp. , gentherm inc. , genuine parts co. , johnson controls inc. , lkq corp. , lear corp. , meritor inc. , remy international inc. , standard motor products inc. , stoneridge inc. , superior industries international , trw automotive holdings corp. , tenneco inc. , tesla motors inc. , the goodyear tire & rubber co. , tower international inc. , visteon corp. , and wabco holdings inc . company index november 17 , december 31 , december 31 , december 31 .

Table:
company index | november 17 2011 | december 31 2011 | december 31 2012 | december 31 2013
delphi automotive plc ( 1 ) | $ 100.00 | $ 100.98 | $ 179.33 | $ 285.81
s&p 500 ( 2 ) | 100.00 | 100.80 | 116.93 | 154.80
automotive supplier peer group ( 3 ) | 100.00 | 89.27 | 110.41 | 166.46
dividends on february 26 , 2013 , the board of directors approved the initiation of dividend payments on the company's ordinary shares .
the board of directors declared a regular quarterly cash dividend of $ 0.17 per ordinary share that was paid in each quarter of 2013 .
in addition , in january 2014 , the board of directors declared a regular quarterly cash dividend of $ 0.25 per ordinary share , payable on february 27 , 2014 to shareholders of record at the close of business on february 18 , 2014 .
in october 2011 , the board of managers of delphi automotive llp approved a distribution of approximately $ 95 million , which was paid on december 5 , 2011 , principally in respect of taxes , to members of delphi automotive llp who held membership interests as of the close of business on october 31 , 2011. .

Question: what was the percentage total return for delphi automotive plc for the three years ended december 31 2013?\\n
Answer: 185.81%
Calculation: subtract(285.81, const_100), divide(#0, const_100)
ALTERNATIVE PERFORMANCE MEASURES
Gross profit:
TORM defines Gross profit, a performance measure, as revenue less port expenses, bunkers and commissions, charter hire and operating expenses. The Company reports Gross profit because we believe it provides additional meaningful information to investors, as Gross profit measures the net earnings from shipping activities. Gross profit is calculated as follows:
Table:
USDm | 2019 | 2018 | 2017
Reconciliation to revenue |  |  | 
Revenue | 692.6 | 635.4 | 657.0
Port expenses, bunkers and commissions | -267.7 | -283.0 | -259.9
Charter hire | - | -2.5 | -8.5
Operating expenses | -173.0 | -180.4 | -188.4
Gross profit | 251.9 | 169.5 | 200.2


Question: In which year was the amount of operating expenses the largest?
Answer: 2017
Calculation: |188.4|>|180.4|>|173.0|
Research and Development
The increase in research and development expenses in fiscal 2019 compared to fiscal 2018 was primarily driven by an increase in employee compensation costs caused by increases in headcount, annual compensation and benefit adjustments and employee performance-based compensation, partially offset by a decrease in project material costs.
Table:
Fiscal Year Ended |  |  |  | 
 | December 28, 2019 | December 29, 2018 | $ Change | % Change
(Dollars in thousands) |  |  |  | 
Research and development | $81,499 | $74,976 | $6,523 | 8.7 %
% of revenues | 13.8 % | 14.2 % |  | 
Fiscal Year Ended |  |  |  | 
 | December 29, 2018 | December 30, 2017 | $ Change | % Change
(Dollars in thousands) |  |  |  | 
Research and development | $74,976 | $73,807 | $1,169 | 1.6 %
% of revenues | 14.2 % | 13.5 % |  | 


Question: What is the average Research and development for the Fiscal Year Ended December 28, 2019 to December 29, 2018?  
Answer: 78237.5
Calculation: (81,499+74,976) / 2
The funded status of the plans was as follows:
(in thousands)
Table:
 | Years Ended March 31, | 
 | 2019 | 2018
Fair value of plan assets | $90,365 | $84,718
Less: projected benefit obligations | 143,662 | 128,915
Underfunded status | $(53,297) | $(44,197)


Question: What is the increase in the fair value of plan assets from 2018 to 2019?
Answer: 5647
Calculation: $90,365 - $84,718
The following table details the Company’s sales by operating segment for fiscal years ended September 30, 2019 and 2018. The Company’s sales by geographic area based on the location of where the products were shipped or services rendered are as follows:
Substantially all Americas amounts are United States.
Table:
2019 | Americas | Europe | Asia | Total | % of total
 |  | (Amounts in thousands) |  |  | 
TS | $67,728 | $3,285 | $646 | $71,159 | 90%
HPP | 5,294 | 771 | 1,837 | 7,902 | 10%
Total | $72,522 | $4,056 | $2,483 | $79,061 | 100%
% of total | 92% | 5% | 3% | 100% | 
2018 |  |  |  |  | 
TS | $52,034 | $9,059 | $1,344 | $62,437 | 86%
HPP | 8,424 | 1,266 | 789 | 10,479 | 14%
Total | $60,458 | $10,325 | $2,133 | $72,916 | 100%
% of total | 83% | 14% | 3% | 100% | 


Question: How does the company determine its sales by geographic area?
Answer: Based on the location of where the products were shipped or services rendered