hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Property and Equipment, Net
Property and equipment, net, consisted of the following (in thousands):
Depreciation expense on property and equipment was $5.0 million, $6.4 million and $7.1 million for the years
ended December 31, 2019, 2018 and 2017, respectively
Table:
 | Useful life (in years) | December 31, 2019 | December 31, 2018
Equipment | 1-3 | $22,702 | $49,804
Software | 1-3 | 726 | 4,088
Furniture and fixtures | 1-3 | 459 | 967
Leasehold improvements | 2-8 | 5,440 | 3,832
Construction in progress |  | -- | 160
Property and equipment, gross |  | 29,327 | 58,581
Less: accumulated depreciation |  | (21,671) | (51,589)
Property and equipment, net |  | $7,656 | $7,262


Question: What is the depreciation expense on property and equipment as at December 31, 2017? 
Answer: $7.1
Contractual obligations and commitments
A summary of our principal contractual financial obligations and commitments at 31 March 2019 are set out below. In addition, information in relation to our participation in the current German spectrum licence auction and our commitments arising from the Group’s announcement on 9 May 2018 that it had agreed to acquire Liberty Global’s operations in Germany, the Czech Republic, Hungary and Romania (are set out in note 28 “Commitments”).
Notes: 1 This table includes obligations to pay dividends to non-controlling shareholders (see “Dividends from associates and to non-controlling shareholders” on page 160). The table excludes current and deferred tax liabilities and obligations under post employment benefit schemes, details of which are provided in notes 6 “Taxation” and 25 “Post employment benefits” respectively. The table also excludes the contractual obligations of associates and joint ventures.
2 See note 21 “Capital and financial risk management”.
3 See note 28 “Commitments”.
4 Primarily related to spectrum and network infrastructure.
5 Primarily related to device purchase obligations.
Table:
 |  |  |  |  | Payments due by period
 |  |  |  |  | €m
Contractual obligations and commitments1 | Total | < 1 year | 1–3 years | 3–5 years | >5 years
Financial liabilities2 | 86,160 | 21,953 | 11,404 | 14,881 | 37,922
Operating lease commitments3 | 10,816 | 2,834 | 2,881 | 1,689 | 3,412
Capital commitments3,4 | 3,012 | 1,514 | 1,274 | 173 | 51
Purchase commitments5 | 8,460 | 4,091 | 2,616 | 689 | 1,064
Total | 108,448 | 30,392 | 18,175 | 17,432 | 42,449


Question: What percentage of total contractual obligations and commitments is the financial liabilities?
Answer: 79.45
Calculation: 86,160/108,448
During 2019, 2018 and 2017, no income tax benefit or expense was recorded for stock options exercised as an adjustment to equity.
The change in the unrecognized income tax benefits for the years ended December 31, 2019, 2018 and 2017 is reconciled below:
As of December 31, 2019, 2018 and 2017, our total liability for unrecognized tax benefits was $1.5 million, $1.9 million and $2.4 million, respectively, of which $1.4 million, $1.7 million and $2.2 million, respectively, would reduce our effective tax rate if we were successful in upholding all of the uncertain positions and recognized the amounts recorded. We classify interest and penalties recognized on the liability for unrecognized tax benefits as income tax expense. As of December 31, 2019, 2018 and 2017, the balances of accrued interest and penalties were $0.5 million, $0.7 million and $0.8 million, respectively.
We do not anticipate a single tax position generating a significant increase or decrease in our liability for unrecognized tax benefits within 12 months of this reporting date. We file income tax returns in the U.S. for federal and various state jurisdictions and several foreign jurisdictions. We are not currently under audit by the Internal Revenue Service. Generally, we are not subject to changes in income taxes by any taxing jurisdiction for the years prior to 2016.
Table:
(In thousands) | 2019 | 2018 | 2017
Balance at beginning of period | $1,868 | $2,366 | $2,226
Increases for tax position related to: |  |  | 
Prior years | — | 3 | 465
Current year | 161 | 254 | 285
Decreases for tax positions related to: |  |  | 
Prior years | (71) | — | (14)
Expiration of applicable statute of limitations | (471) | (755) | (596)
Balance at end of period | $1,487 | $1,868 | $2,366


Question: What was the company's total liability for unrecognized tax benefits in 2019?
Answer: $1.5 million
ITEM 7. MAJOR SHAREHOLDERS AND RELATED PARTY TRANSACTIONS
A. Major Shareholders
The following table sets forth information regarding beneficial ownership of our common shares for (i) owners of more than five percent of our common shares and (ii) our directors and officers, of which we are aware of the date of this annual report.
(1) Based on 147,230,634 common shares outstanding as of the date of this annual report.
(2) The holdings of High Seas AS, which are for the economic interest of members of the Hansson family, as well as the personal holdings of our Chief Executive Officer and Chairman, Mr. Herbjorn Hansson, and our director, Alexander Hansson, are included in the amount reported herein.
* Less than 1% of our common outstanding shares.
As of April 14, 2020, we had 575 holders of record in the United States, including Cede & Co., which is the Depositary Trust Company’s nominee for holding shares on behalf of brokerage firms, as a single holder of record. We had a total of 147,230,634 Common Shares outstanding as of the date of this annual report.
Table:
Title | Identity of Person | No. of Shares | Percent of Class(1)
Common | Hansson family(2) | 4,380,659 | 2.98%
 | Jim Kelly |  | * 
 | Richard Vietor |  | * 
 | David Workman |  | * 
 | Bjørn Giæver |  | * 


Question: How many common shares were outstanding as of the date of this annual report?
Answer: 147,230,634
Lease liabilities regarding right-of-use assets are included on the balance sheet under “Borrowings”.
Extension and termination options are included in several leases in order to optimize operational flexibility in terms of managing contracts. The lease term determined by TORM is the noncancellable period of a lease, together with any extension/termination options if these are/are not reasonably certain to be exercised.
Table:
USDm | 2019 | 2018
Maturity analysis - contractual undiscounted cash flow |  | 
Less than one year | 7.5 | 5.2
One to five years | 27.6 | 25.6
More than five years | 0.1 | -
Total undiscounted lease liabilities as of 31 December | 35.2 | 30.8
Lease liabilities included under "Borrowings" as of 31 December | 30.6 | 25.3
Non-current | 10.2 | 3.2
Current | 20.4 | 22.1


Question: What are the different maturity terms under maturity analysis - contractual undiscounted cash flow?
Answer: Less than one year, One to five years, More than five years
Note 16: Quarterly Results of Operations (Unaudited)
The following table sets forth certain quarterly information for fiscal years 2019 and 2018. This information, in the opinion of the Company’s management, reflects all adjustments (consisting only of normal recurring adjustments) necessary to present fairly this information when read in conjunction with the Consolidated Financial Statements and notes thereto included elsewhere herein (amounts in thousands except per share data):
(1) Operating income (loss) as a percentage of net sales fluctuates from quarter to quarter due to a number of factors, including net sales fluctuations, foreign currency exchange, restructuring charges, product mix, the timing and expense of moving product lines to lower-cost locations, the write-down of long lived assets, the net gain/loss on sales and disposals of assets and the relative mix of sales among distributors, original equipment manufacturers, and electronic manufacturing service providers.
Table:
Fiscal Year 2019 Quarters Ended |  |  |  | 
 | Jun-30 | Sep-30 | Dec-31 | Mar-31
Net sales | $327,616 | $349,233 | $350,175 | $355,794
Gross margin | 94,821 | 113,565 | 123,750 | 126,406
Operating income (1) | 35,176 | 50,000 | 61,616 | 54,057
Net income | $35,220 | $37,141 | $40,806 | $93,420
Net income per basic share | $0.61 | $0.64 | $0.70 | $1.60
Net income per diluted share | $0.60 | $0.63 | $0.69 | $1.58


Question: What was the change in the Net sales between the Dec-31 and Mar-31 quarters?
Answer: 5619
Calculation: 355,794-350,175
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,
2018: |  |  |  |  | 
Operating revenues | $1,741.8 | $1,780.9 | $1,785.5 | $2,131.9 | $7,440.1
Costs of operations (1) | 519.9 | 560.3 | 556.7 | 540.9 | 2,177.8
Operating income | 402.9 | 546.0 | 567.2 | 388.9 | 1,905.0
Net income | 280.3 | 314.4 | 377.3 | 292.7 | 1,264.7
Net income attributable to American Tower Corporation stockholders | 285.2 | 306.7 | 366.9 | 277.6 | 1,236.4
Dividends on preferred stock | (9.4) | — | — | — | (9.4)
Net income attributable to American Tower Corporation common stockholders | 275.8 | 306.7 | 366.9 | 277.6 | 1,227.0
Basic net income per share attributable to American Tower Corporation common stockholders | 0.63 | 0.69 | 0.83 | 0.63 | 2.79
Diluted net income per share attributable to American Tower Corporation common stockholders | 0.63 | 0.69 | 0.83 | 0.62 | 2.77


Question: What was the net income at the end of March 31?
Answer: 280.3
(1)  The bonus paid in 2019, 2018 and 2017 was approved by the compensation Committee and Supervisory Board with respect to the 2018, 2017 and 2016 financial year, respectively, based on the evaluation and assessment of the actual fulfillment of a number of pre-defined objectives for such year.
(2)  Including stock awards, employer social contributions, company car allowance, pension contributions, complementary pension contributions, miscellaneous allowances as well as one-off contractually obligated deferred compensation paid to Mr. Bozotti in 2019.
In accordance with the resolutions adopted at our AGM held on May 30, 2012, the bonus of our former President and Chief Executive Officer, Mr. Bozotti, in 2018 and 2017 included a portion of a bonus payable in stock awards and corresponding to 86,782 and 59,435 vested shares, respectively, based on fulfillment of a number of pre-defined objectives.
In addition, our sole member of our Managing Board, President and Chief Executive Officer, Mr. Chery, was granted, in accordance with the compensation policy adopted by our General Meeting of Shareholders and subsequent shareholder authorizations, up to 100,000 unvested Stock Awards. The vesting of such stock awards is conditional upon the sole member of our Managing Board, President and Chief Executive Officer’s, continued service with us.
(3) In 2019, the total compensation of the sole member of our Managing Board, President and Chief Executive Officer was 46% fixed to 54% variable, compared to 12% fixed to 88% variable in 2018 and 44% fixed to 56% variable in 2017.
Table:
 | 2019 | 2018 | 2017
Salary | $896,297 | $927,820 | $903,186
Bonus(1) | $1,280,173 | $3,214,578 | $1,044,514
Charges and Non-cash Benefits(2) | $5,618,382 | $6,971,946 | $1,828,814
Total(3) | $7,794,852 | $11,114,344 | $3,776,514


Question: What was the total compensation of the sole member of our Managing Board, President and Chief Executive Officer in 2018?
Answer: 12% fixed to 88% variable
Gross Profit
Gross profit increased $269.4 million, or 45.2%, for the year ended December 31, 2019 compared to the same period in 2018. As a percentage of total revenues, gross profit decreased from 55.6% in the year ended December 31, 2018 to 54.9% in the year ended December 31, 2019, due to Shopify Payments representing a larger percentage of total revenue and an increase in amortization of technology related to the 6RS acquisition as well as other platform enhancements. This was partly offset by lower third-party infrastructure and hosting costs and employee-related costs as a percentage of revenues as well as the relative growth of higher-margin merchant solutions products, namely Shopify Capital and referral fees from partners.
Gross profit increased $216.0 million, or 56.8%, for the year ended December 31, 2018 compared to the same period in 2017. As a percentage of total revenues, gross profit decreased from 56.5% in the year ended December 31, 2017 to 55.6% in the year ended December 31, 2018, due to Shopify Payments representing a larger percentage of total revenue, increasing the functionality and flexibility of our hosting infrastructure, and higher product costs associated with expanding our product offerings. This was partly offset by the relative growth of higher-margin merchant solutions products, namely referral fees from partners, Shopify Capital, and Shopify Shipping.
Table:
 | Years ended December 31 |  |  | 2019 vs 2018 | 2018 vs 2017
 | 2019 | 2018 | 2017 | % Change | % Change
 | (in thousands, except percentages) |  |  |  | 
Gross profit | $ 865,643 | $ 596,267 | $ 380,253 | 45.2 % | 56.8 %
Percentage of total revenues | 54.9 % | 55.6 % | 56.5 % |  | 


Question: What is the gross profit as at year ended December 31, 2017?
Answer: $ 380,253
(a) GitHub has been included in our consolidated results of operations starting on the October 25, 2018 acquisition date.
(b) Includes a $2.6 billion net income tax benefit related to intangible property transfers and a $157 million net charge related to the enactment of the Tax Cuts and Jobs Act (“TCJA”), which together increased net income and diluted earnings per share (“EPS”) by $2.4 billion and $0.31, respectively. Refer to Note 12 – Income Taxes of the Notes to Financial Statements for further discussion.
(c) Includes a $13.7 billion net charge related to the enactment of the TCJA, which decreased net income and diluted EPS by $13.7 billion and $1.75, respectively. Refer to Note 12 – Income Taxes of the Notes to Financial Statements for further discussion.
(d) Reflects the impact of the adoption of new accounting standards in fiscal year 2018 related to revenue recognition and leases.
(e) LinkedIn has been included in our consolidated results of operations starting on the December 8, 2016 acquisition date.
(f) Includes $306 million of employee severance expenses primarily related to our sales and marketing restructuring plan, which decreased operating income, net income, and diluted EPS by $306 million, $243 million, and $0.04, respectively.
(g) Includes $630 million of asset impairment charges related to our Phone business and $480 million of restructuring charges associated with our Phone business restructuring plans, which together decreased operating income, net income, and diluted EPS by $1.1 billion, $895 million, and $0.11, respectively.
(h) Includes $7.5 billion of goodwill and asset impairment charges related to our Phone business and $2.5 billion of integration and restructuring expenses, primarily associated with our Phone business restructuring plans, which together decreased operating income, net income, and diluted EPS by $10.0 billion, $9.5 billion, and $1.15, respectively.
Table:
(In millions, except per share amounts) |  |  |  |  | 
Year Ended June 30, | 2019 (a) | 2018 | 2017 (d)(e) | 2016 (d) | 2015
Revenue | $ 125,843 | $ 110,360 | $ 96,571 | $ 91,154 | $ 93,580
Gross margin | 82,933 | 72,007 | 62,310 | 58,374 | 60,542
Operating income | 42,959 | 35,058 | 29,025 (f) | 26,078 (g) | 18,161(h)
Net income | 39,240(b) | 16,571(c) | 25,489 (f) | 20,539 (g) | 12,193(h)
Diluted earnings per share | 5.06 (b) | 2.13(c) | 3.25 (f) | 2.56 (g) | 1.48(h)
Cash dividends declared per share | 1.84 | 1.68 | 1.56 | 1.44 | 1.24
Cash, cash equivalents, and short-term |  |  |  |  | 
investments | 133,819 | 133,768 | 132,981 | 113,240 | 96,526
Total assets | 286,556 | 258,848 | 250,312 | 202,897 | 174,303
Long-term obligations | 114,806 | 117,642 | 106,856 | 66,705 | 44,574
Stockholders’ equity | 102,330 | 82,718 | 87,711 | 83,090 | 80,083


Question: What was the average revenue over the 3 year period from 2017 to 2019?
Answer: 110924.67
Calculation: (125,843+110,360+96,571)/(2019-2017+1)
CASH FLOW STATEMENT1
1 Abridged version. The complete version is shown in the consolidated financial statements.
Table:
€ million | 2017/18 | 2018/19
Cash flow from operating activities of continuing operations | 766 | 796
Cash flow from operating activities of discontinued operations | 139 | 157
Cash flow from operating activities | 905 | 953
Cash flow from investing activities of continuing operations | −292 | 46
Cash flow from investing activities of discontinued operations | −89 | −136
Cash flow from investing activities | −381 | −90
Cash flow before financing activities of continuing operations | 474 | 842
Cash flow before financing activities of discontinued operations | 50 | 21
Cash flow before financing activities | 524 | 863
Cash flow from financing activities of continuing operations | −587 | −1,122
Cash flow from financing activities of discontinued operations | −74 | −109
Cash flow from financing activities | −661 | −1,231
Total cash flows | −137 | −368
Currency effects on cash and cash equivalents | −30 | 17
Total change in cash and cash equivalents | −167 | −351


Question: What was the change in cash flow from operating activities in FY2019 from FY2018?
Answer: 48
Calculation: 953-905
The increase in Global Financing total revenue was driven by an increase in internal revenue, partially offset by a decrease in external revenue. Internal revenue grew 9.5 percent driven by increases in internal financing (up 17.6 percent) and internal used equipment sales (up 6.8 percent).
External revenue declined 6.3 percent due to a decrease in external used equipment sales (down 30.8 percent), partially offset by an increase in external financing (up 4.9 percent).
The increase in Global Financing pre-tax income was primarily driven by an increase in gross profit and a decrease in total expense.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2018 | 2017 | Yr.-to-Yr. Percent Change
Results of Operations |  |  | 
External revenue | $1,590 | $1,696 | (6.3)%
Internal revenue | 1,610 | 1,471 | 9.5
Total revenue | $3,200 | $3,168 | 1.0%
Pre-tax income | $1,361 | $1,278 | 6.5%


Question: What is the increase/ (decrease) in External revenue from 2017 to 2018
Answer: -106
Calculation: 1,590-1,696
Our net sales to significant customers as a percentage of total net sales were as follows:
We sell parts to these three transportation customers for certain vehicle platforms under purchase agreements that have no volume commitments and are subject to purchase orders issued from time to time.
No other customer accounted for 10% or more of total net sales during these periods. We continue to focus on broadening our customer base to diversify our end market exposure.
Changes in the level of our customers' orders have, in the past, had a significant impact on our operating results. If a major customer reduces the amount of business it does with us, or substantially changes the terms of that business, there could be an adverse impact on our operating results
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Cummins Inc. | 16.1% | 15.2% | 13.4%
Honda Motor Co. | 11.6% | 10.5% | 11.2%
Toyota Motor Corporation | 9.6% | 10.5% | 10.2%


Question: What was the change in the percentage of total net sales from Honda Motor Co. between 2017 and 2018?
Answer: -0.7
Calculation: 10.5-11.2
(8) Accounts Receivable
The following table presents details of our accounts receivable balances:
We are exposed to concentrations of credit risk from residential and business customers. We generally do not require collateral to secure our receivable balances. We have agreements with other communications service providers whereby we agree to bill and collect on their behalf for services rendered by those providers to our customers within our local service area. We purchase accounts receivable from other communications service providers primarily on a recourse basis and include these amounts in our accounts receivable balance. We have not experienced any significant loss associated with these purchased receivables.
Table:
 | As of December 31, | 
 | 2019 | 2018
 | (Dollars in millions) | 
Trade and purchased receivables | $1,971 | 2,094
Earned and unbilled receivables | 374 | 425
Other | 20 | 21
Total accounts receivable | 2,365 | 2,540
Less: allowance for doubtful accounts | (106) | (142)
Accounts receivable, less allowance | $2,259 | 2,398


Question: What is the percentage change in the earned and unbilled receivables?
Answer: -12
Calculation: (374-425)/425
NOTE 13 – INCOME TAX
The domestic and foreign components of loss before income taxes from operations for the years ended December 31, 2019, 2018 and 2017 are as follows:
Table:
 |  | For the Years Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (in thousands) | 
Domestic | $(22,708) | $29,110 | $17,120
Foreign | — | (320) | (469)
 | $(22,708) | $28,790 | $16,651


Question: What are the respective foreign income loss before income taxes in 2017 and 2018?
Answer: 469, 320
EBITDA and EBITDA Margin
The following tables set forth EBITDA (in millions) and EBITDA Margin by segment for the periods presented:
Software Solutions
EBITDA was $567.2 million in 2018 compared to $516.5 million in 2017, an increase of $50.7 million, or 10%, with an EBITDA Margin of 59.0%, an increase of 190 basis points from the prior year. The increase was primarily driven by incremental margins on revenue growth.
Data and Analytics
EBITDA was $39.5 million in 2018 compared to $38.4 million in 2017, an increase of $1.1 million, or 3%, with an EBITDA Margin of 25.6%, an increase of 30 basis points from the prior year. The EBITDA Margin increase was primarily driven by incremental margins on revenue growth.
Table:
 | Year ended December 31, |  | Variance | 
 | 2018 | 2017 | $ | %
Software Solutions | $567.2 | $516.5 | $50.7 | 10%
Data and Analytics | 39.5 | 38.4 | 1.1 | 3%


Question: What was the sum of the EBITDA in 2018?
Answer: 606.7
Calculation: 567.2+39.5