hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Profit or loss for the period after taxes
The current result of METRO China was reclassified in the consolidated income statement under the item ‘profit or loss for the period from discontinued operations after taxes’, taking into account necessary consolidation measures. To increase the economic meaningfulness of the earnings statement of the continuing sector, its shares in the consolidation effects were also included in the discontinued section of the earnings statement as far as they were related to business relations that are to be upheld in the long term even after the planned disposal. The previous year’s figures of the income statement were adjusted accordingly.
Profit or loss for the period from discontinued operations after taxes is attributable to the shareholders of METRO AG in the amount of €118 million (2017/18: €87 million). Noncontrolling interests account for €5 million of earnings (2017/18: €1 million).
In connection with the divestment process, expenses in the low 2-digit million euros range have been incurred to date.
As a result, profit or loss for the period from discontinued operations after taxes is made up as follows for METRO China:
Table:
€ million | 2017/2018 | 2018/2019
Sales | 2,680 | 2,901
Expenses | −2,563 | −2,736
Current earnings from discontinued operations before taxes | 117 | 165
Income taxes on gains/losses on the current result | −29 | −43
Current earnings from discontinued operations after taxes | 88 | 122
Gains/losses from the remeasurement or disposal of discontinued operations before taxes | 0 | 0
Gains/losses from the remeasurement or disposal of discontinued operations after taxes | 0 | 0
Profit or loss for the period from discontinued operations after taxes | 88 | 122


Question: What was the percentage change in Sales in FY2019 from FY2018?
Answer: 8.25
Calculation: (2,901-2,680)/2,680
Fiscal 2019 Restructuring Plan
During Fiscal 2019, we began to implement restructuring activities to streamline our operations (Fiscal 2019 Restructuring Plan), including in connection with our recent acquisitions of Catalyst and Liaison, to take further steps to improve our operational efficiency. The Fiscal 2019 Restructuring Plan charges relate to workforce reductions and facility consolidations. These charges require management to make certain judgments and estimates regarding the amount and timing of restructuring charges or recoveries. Our estimated liability could change subsequent to its recognition, requiring adjustments to the expense and the liability recorded. On a quarterly basis, we conduct an evaluation of the related liabilities and expenses and revise our assumptions and estimates as appropriate.
As of June 30, 2019, we expect total costs to be incurred in conjunction with the Fiscal 2019 Restructuring Plan to be approximately $30.0 million, of which $28.3 million has already been recorded within "Special charges (recoveries)" to date. We do not expect to incur any further significant charges relating to this plan.
A reconciliation of the beginning and ending liability for the year ended June 30, 2019 is shown below.
Table:
Fiscal 2019 Restructuring Plan | Workplace reduction | Facility costs | Total
Balance payable as at June 30, 2018 | $— | $— | $—
Accruals and adjustments | 12,460 | 15,858 | 28,318
Cash payments | (10,420) | (4,739) | (15,159)
Non-cash adjustments | — | (3,393) | (3,393)
Foreign exchange | (221) | (2,438) | (2,659)
Balance payable as at June 30, 2019 | $1,819 | $5,288 | $7,107


Question: For Accruals and adjustments, What is difference between Workplace reduction & Facility costs?
Answer: -3398
Calculation: 12,460-15,858
Property and Equipment
Property and equipment are as follows (in thousands):
(1) In the fourth quarter 2019, the Company announced its decision to exit the San Jose California facility (“SJ Facility”) by March 31, 2020. The Company accelerated the amortization of its SJ Facility leasehold improvements over the remaining estimated life which is estimated to be through March 31, 2020. As of December 31, 2019, the net book value of the SJ Facility leasehold improvements was $0.9 million and will be fully amortized by March 31, 2020.
Table:
December 31, |  | 
 | 2019 | 2018
Computer equipment and purchased software | $3,011 | $3,167
Machinery and equipment | 699 | 821
Furniture and fixtures | 1,115 | 1,113
Leasehold improvements (1) | 3,897 | 3,897
Total | 8,722 | 8,998
Less accumulated depreciation and amortization (1) | (7,496) | (6,655)
Property and equipment, net | $1,226 | $2,343


Question: What was the net book value of SJ Facility leasehold improvements in 2019?
Answer: $0.9 million
COMPENSATION DISCUSSION AND ANALYSIS
IV. Our 2019 Compensation Program and Components of Pay The table below shows (i) the length of the “protected period” afforded to officers following a change of control and (ii) the multiple of salary and bonus payment and years of welfare benefits to which officers will be entitled if change of control benefits become payable under our agreements and related policies:
For more information on change of control arrangements applicable to our executives, including our rationale for
providing these benefits, see “Executive Compensation—Potential Termination Payments—Payments Made
Upon a Change of Control.” For information on change of control severance benefits payable to our junior
officers and managers, see “—Severance Benefits” in the next subsection below.
Table:
 | Protected Period | Multiple of Annual Cash Compensation | Years of Welfare Benefits
CEO | 2 years | 3 times | 3 years
Other Executives | 1.5 years | 2 times | 2 years
Other Officers | 1 year | 1 time | 1 year


Question: What is the average protected period?
Answer: 1.5
Calculation: (2+1.5+1)/3
Note: 1 See “Alternative performance measures” on page 231 for further details and reconciliations to the respective closest equivalent GAAP measure.
The Group’s adjusted effective tax rate for its controlled businesses for the year ended 31 March 2019 was 24.4% compared to 20.6% for the last financial year. The higher rate in the current year is primarily due to a change in the mix of the Group’s profit, driven by the financing for the Liberty Global transaction. The tax rate in the prior year also reflected the consequences of closing tax audits in Germany and Romania. We expect the Group’s adjusted effective tax rate to remain in the low-mid twenties range for the medium term.
The Group’s adjusted effective tax rate for both years does not include the following items: the derecognition of a deferred tax asset in Spain of €1,166 million (2018: €nil); deferred tax on the use of Luxembourg losses of €320 million (2018: €304 million); an increase in the deferred tax asset of €488 million (2018: €330 million) arising from a revaluation of investments based upon the local GAAP financial statements and tax returns.
The Group’s adjusted effective tax rate for the year ended 31 March 2018 does not include the recognition of a deferred tax asset of €1,603 million due to higher interest rates; and a tax charge in respect of capital gains on the transfer of share in Vodafone Kenya Limited to the Vodacom Group of €110 million.
Table:
Taxation |  | 
 | 2019 €m | 2018 €m
Income tax (expense)/credit: | (1,496) | 879
Tax on adjustments to derive adjusted profit before tax | (206) | (188)
Deferred tax following revaluation of investments in Luxembourg | (488) | (330)
Luxembourg deferred tax asset recognised | – | (1,603)
Deferred tax on use of Luxembourg losses in the year | 320 | 304
Tax on the Safaricom transaction | – | 110
Derecognition of a deferred tax asset in Spain | 1,166 | –
Adjusted income tax expense for calculating adjusted tax rate1 | (704) | (828)
Loss)/profit before tax | (2,613) | 3,878
Adjustments to derive adjusted profit before tax (see earnings per share) | 5,149 | 530
Adjusted profit before tax1 | 2,536 | 4,408
Share of adjusted results in associates and joint ventures | 348 | (389)
Adjusted profit before tax for calculating adjusted effective tax rate | 2,884 | 4,019
Adjusted effective tax rate1 | 24.4% | 20.6%


Question: What is the average adjusted profit before tax?
Answer: 3472
Calculation: (2,536+4,408)/2
Comparison of Years Ended December 31, 2019 to December 31, 2018
The following tables in this section set forth our selected consolidated statements of operations (in thousands), data for the percentage change and data as a percentage of revenue for the years ended December 31, 2019 and 2018. Certain previously reported amounts in the consolidated statements of operations for the year ended December 31, 2018 have been reclassified to conform to our current presentation to reflect interest income as a separate line item, which was previously included in other income, net.
Revenue
The $81.9 million increase in total revenue in 2019 as compared to 2018 was the result of a $46.3 million, or 16%, increase in our SaaS and license revenue and a $35.6 million, or 27%, increase in our hardware and other revenue. Our software license revenue included within SaaS and license revenue increased $2.1 million to $43.4 million in 2019 as compared to $41.3 million during 2018. The increase in our Alarm.com segment SaaS and license revenue in 2019 was primarily due to growth in our subscriber base, including the revenue impact from subscribers we added in 2018. To a lesser extent, SaaS and license revenue increased in the period due to an increase in license fees. The increase in hardware and other revenue in 2019 compared to 2018 was due to an increase in the volume of video cameras sold. Our Other segment contributed 15% of the increase in SaaS and license revenue in 2019 as compared to 2018. The increase in SaaS and license revenue for our Other segment in 2019 as compared to 2018 was due to an increase in sales of our energy management and demand response solutions and our property management and HVAC solutions. Hardware and other revenue in our Other segment decreased 13% in 2019 as compared to 2018, primarily due to the timing of sales related to our remote access management solution.
Table:
 |  | Year Ended December 31, | 
Revenue: |  |  | % Change
 | 2019 | 2018 | 2019 vs. 2018
SaaS and license revenue | $337,375 | $291,072 | 16%
Hardware and other revenue | 164,988 | 129,422 | 27%
Total revenue | $502,363 | $420,494 | 19%


Question: How many components of revenue exceeded $200,000 thousand in 2018?
Answer: 1
Calculation: SaaS and license revenue
As at 31 December 2019, the Group had net debt of RMB15,552 million, compared to net debt of RMB7,173 million as at 30 September 2019. The sequential increase in indebtedness mainly reflected payments for M&A initiatives and media contents, as well as the consolidation of indebtedness at Halti, partly offset by strong free cash flow generation.
As at 31 December 2019, the Group had net debt of RMB15,552 million, compared to net debt of RMB7,173 million as at 30 September 2019. The sequential increase in indebtedness mainly reflected payments for M&A initiatives and media contents, as well as the consolidation of indebtedness at Halti, partly offset by strong free cash flow generation.
For the fourth quarter of 2019, the Group had free cash flow of RMB37,896 million. This was a result of net cash flow generated from operating activities of RMB50,604 million, offset by payments for capital expenditure of RMB12,708 million.
Table:
 | Audited | Unaudited
 | 31 December | 30 September
 | 2019 | 2019
 | (RMB in millions) | 
Cash and cash equivalents | 132,991 | 145,607
Term deposits and others | 72,270 | 54,499
 | 205,261 | 200,106
Borrowings | (126,952) | (112,148)
Notes payable | (93,861) | (95,131)
Net debt | (15,552) | (7,173)
Fair value of our stakes in listed investee companies (excluding subsidiaries) | 419,818 | 352,656


Question: What is the group's net debt as at 30 September 2019?
Answer: RMB7,173 million
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 operating revenue in Three Months Ended  June?
Answer: $1,889.6
In the Communications Solutions segment, operating income decreased $79 million in fiscal 2019 as compared to fiscal 2018. The Communications Solutions segment’s operating income included the following:
Excluding these items, operating income decreased in fiscal 2019 due primarily to lower volume.
Table:
 |  | Fiscal
 | 2019 | 2018
 |  | (in millions)
Restructuring and other charges, net | $  48 | $  13
Other items | 1 | —
Total | $  49 | $  13


Question: What are the items under the operating income in the Communications Solutions segment?
Answer: Restructuring and other charges, net, Other items
Sources and Uses of Cash
Our primary source of liquidity from operations was the collection of revenue in advance from our customers, accounts receivable from our customers, and the management of the timing of payments to our vendors and service providers.
Investing activities in 2019 consist of $284.6 million, net of cash acquired, used in the acquisitions of AppRiver and DeliverySlip and $11.7 million for capital expenditures, which include $8.2 million in internal-use software costs, and $3.5 million for computer and networking equipment. These investments in new equipment and cloud hosting infrastructure are to renovate our business processes and product offerings.
Investing activities in 2018 consist of $11.8 million, net of cash acquired, used in the acquisition of Erado and $4.2 million for capital expenditures, which include $2.1 million for computer and networking equipment, $1.5 million in internal-use software costs, and $500 thousand for other activities including the acquisition of other internal use software. These investments in new equipment and cloud hosting infrastructure were to modernize our business processes and product offerings.
Financing activities in 2019 includes proceeds from long term debt of $179.2 million, net of issuance costs of $6.4 million and repayment of $1.4 million, as well as $96.6 million, net of issuance costs, raised through the private purchase of preferred stock, and $415 thousand received from the exercise of stock options. The proceeds from our debt and preferred stock issuances were used to fund our AppRiver acquisition in February 2019 and our DeliverySlip acquisition in May 2019. We also used $3.8 million for contingent consideration payments associated with our acquisitions of Greenview, Erado and DeliverySlip. In addition to these items, we paid $1.7 million to satisfy finance lease liabilities and $1.9 million to repurchase common stock related to the tax impact of vesting restricted awards in 2019.
Financing activities in 2018 relate primarily to $5.4 million used in a $10 million share repurchase program authorized by our Board of Directors on April 24, 2017, and $656 thousand used in the repurchase of common stock related to the tax impact of vesting restricted stock awards, and a $605 thousand earn-out payment associated with our acquisition of Greenview. Financing activities in 2017 include $3.8 million used in the same share repurchase program and $762 thousand used in the repurchase of common stock related to the tax impact of vesting restricted awards offset by the receipt of $4.2 million from the exercise of stock options.
Table:
Years Ended December 31, |  |  | 
(In thousands) | 2019 | 2018 | 2017
Net cash provided by operations | $ 13,951 | $ 16,671 | $ 18,204
Net cash used in investing activities | $ (296,243 ) | $ (15,952 ) | $ (11,285 )
Net cash provided by (used in) financing activities | $ 268,740 | $ (6,593 ) | $ (367 )


Question: For how many years was the Net cash used in financing activities more than $100,000?
Answer: 1
Calculation: 2019
The following table presents a rollforward of our restructuring liability as of September 30, 2019, which is included within accrued compensation and other current liabilities within our Consolidated Balance Sheet, (in millions):
Certain restructuring costs are based upon estimates. Actual amounts paid may ultimately differ from these estimates. If additional costs are incurred or recognized amounts exceed costs, such changes in estimates will be recognized when incurred.
Table:
 | Restructuring Liability Employee Separation and other | Restructuring Liability Consulting Costs
Balance as of October 1, 2017 | $ 1.0 | $  —
Accrued costs | 4.2 | 0.8
Cash payments | (4.6) | (0.5)
Balance as of September 30, 2018 | $  0.6 | $  0.3
Accrued costs | 7.5 | 7.9
Cash payments | (6.1) | (7.4)
Balance as of September 30, 2019 | $  2.0 | $  0.8


Question: Where is the restructuring liability included within?
Answer: accrued compensation and other current liabilities within our Consolidated Balance Sheet, (in millions)
Contractual Obligations and Commercial Commitments
The following table summarizes our non-cancelable contractual obligations and commercial commitments as of the end of 2019 and the effect such obligations and commitments are expected to have on our liquidity and cash flows in future fiscal periods (in thousands):
(1) Certain of our wafer manufacturers require us to forecast wafer starts several months in advance. We are committed to take delivery of and pay for a portion of forecasted wafer volume.
(2) Other commercial commitments are included as liabilities on our consolidated balance sheets as of the end of 2019.
(3) Does not include unrecognized tax benefits of $2.1 million as of the end of 2019. See Note 10 of the Consolidated Financial Statements.
Table:
 |  |  |  | Payments Due by Period | 
 | Total | Less than 1 year | 1-3 Years | 4-5 Years | More than 5 Years
Contractual cash obligations: |  |  |  |  | 
Operating leases | $2,040 | $611 | $902 | $527 | $—
Finance software lease obligations | 514 | 214 | 300 | — | —
Wafer purchases (1) | 57 | 57 | — | — | —
Other purchase commitments | 413 | 386 | 27 | — | —
Total contractual cash obligations | 3,024 | 1,268 | 1,229 | 527 | —
Other commercial commitments (2): |  |  |  |  | 
Revolving line of credit | 15,000 | 15,000 | — | — | —
Total commercial commitments | 15,000 | 15,000 | — | — | —
Total contractual obligations and commercial commitments (3) | $18,024 | $16,268 | $1,229 | $527 | —


Question: What are the respective values of finance software lease obligations due in less than 1 year and between 1 to 3 years?
Answer: 214, 300
Interest Cost
The following table presents the amount of interest cost recognized relating to both the contractual interest coupon and amortization of the debt discount, issuance costs, and effective portion of interest rate contracts with respect to the Senior Notes, convertible notes, the term loan agreement, commercial paper, and the revolving credit facility during the fiscal years ended June 30, 2019, June 24, 2018, and June 25, 2017.
The increase in interest expense during the 12 months ended June 30, 2019, is primarily the result of the issuance of $2.5 billion of Senior Notes in March 2019.
Table:
 |  | YearEnded | 
 | June 30, 2019 | June 24, 2018 | June 25, 2017
 |  | (in thousands) | 
Contractual interest coupon | $100,712 | $77,091 | $95,195
Amortization of interest discount | 3,937 | 12,225 | 22,873
Amortization of issuance costs | 1,426 | 2,034 | 2,414
Effect of interest rate contracts, net | 4,086 | 3 | (4,756)
Total interest cost recognized | $110,161 | $91,353 | $115,726


Question: What is the percentage change in the Amortization of interest discount from 2018 to 2019?
Answer: -67.8
Calculation: (3,937-12,225)/12,225
Year Ended December 31, 2019 Compared to Year Ended December 31, 2018
Revenues
Our Products and Licensing segment included revenues from sales of test and measurement systems, primarily representing sales of our Optical Backscatter Reflectometer, ODiSI, and Optical Vector Analyzer platforms, optical components and sub-assemblies and sales of our Hyperion and Terahertz sensing platforms. Our Products and Licensing segment revenues increased $22.5 million to $44.5 million for the year ended December 31, 2019 compared to $21.9 million for the year ended December 31, 2018.
The increase resulted primarily from $10.8 million of revenues realized from the legacy business of MOI and $10.5 million of revenues realized from the legacy business of GP during the year ended December 31, 2019. Continued growth in sales of our fiber-optic sensing products, including our ODiSI products directed toward the expanding use of composite materials and the need for improved means of testing their structural integrity, and our communications test instruments also contributed to this increase.
Our Technology Development segment revenues increased $5.1 million to $26.0 million for the year ended December 31, 2019 compared to $21.0 million for the year ended December 31, 2018. Revenues within this segment increased due to additional contract awards, including higher value Phase 2 SBIR contracts. The increase continues a growth trend experienced over the past two years largely driven by successes in Phase 2 SBIR awards. The increase was realized primarily in our intelligent systems, advanced materials, optical systems and terahertz research groups. As Phase 2 SBIR contracts generally have a performance period of a year or more, we currently expect Technology Development segment revenues to remain at a similar level for the near term.
Table:
 | Years ended December 31, |  |  | 
 | 2019 | 2018 | $ Difference  | % Difference
Products and licensing revenues | $44,491,041 | $21,949,689 | $22,541,352 | 102.7%
Technology development revenues | 26,024,674 | 20,967,556 | 5,057,118 | 24.1%
Total revenues | $70,515,715 | $42,917,245 | $27,598,470 | 64.3%


Question: What is the average Products and licensing revenues for December 31, 2018 and 2019?
Answer: 33220365
Calculation: (44,491,041+21,949,689) / 2
The following table sets forth the breakdown of revenues by category and segment. Travel revenue includes travel publications (Top 20, Website, Newsflash, Travelzoo Network), Getaway vouchers and hotel platform. Local revenue includes Local Deals vouchers and entertainment offers (vouchers and direct bookings) (in thousands).
Revenue by geography is based on the billing address of the advertiser. Long-lived assets attributed to the U.S. and international geographies are based upon the country in which the asset is located or owned.
Table:
Year Ended December 31, |  | 
 | 2019 | 2018
Asia Pacific |  | 
Travel | $6,274 | $7,351
Local | 216 | 508
Total Asia Pacific revenues | 6,490 | 7,859
Europe |  | 
Travel | 32,081 | 30,856
Local | 4,817 | 5,293
Total Europe revenues | 36,898 | 36,149
North America |  | 
Travel | 57,863 | 56,145
Local | 10,161 | 11,169
Total North America revenues | 68,024 | 67,314
Consolidated |  | 
Travel | 96,218 | 94,352
Local | 15,194 | 16,970
Total revenues | $111,412 | 111,322


Question: What is revenue by geography based on?
Answer: billing address of the advertiser