hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
ADVANCED ENERGY INDUSTRIES, INC.
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued)
(in thousands, except per share amounts)
In 2019, Advanced Energy finalized the assessment of fair value for the assets acquired and liabilities assumed related to the LumaSense acquisition. The following table summarizes the fair values of the assets acquired and liabilities assumed from the LumaSense acquisition, including measurement period adjustments.
During 2019, we adjusted the estimated values of the assets acquired and liabilities assumed based upon the final valuation report. These adjustments included additional liabilities, changes to deferred taxes and changes in the allocation of excess purchase price between goodwill and intangibles.
Table:
 | Preliminary: December 31, 2018 | Measurement Period Adjustments | Adjusted: December 31, 2019
Accounts and other receivable, net | $  7,167 | $ - | $  7,167
Inventories | 9,372 | - | 9,372
Property and equipment | 1,353 | - | 1,353
Goodwill | 48,032 | (11,774) | 36,258
Intangible assets | 26,000 | 17,240 | 43,240
Deferred income tax assets | 8,116 | (1,785) | 6,331
Other assets | 5,126 | 878 | 6,004
Total assets acquired | 105,166 | 4,559 | 109,725
Accounts payable | 5,734 | - | 5,734
Deferred income tax liabilities | 7,984 | 3,715 | 11,699
Other liabilities | 6,764 | 844 | 7,608
Total liabilities assumed | 20,482 | 4,559 | 25,041
Total fair value of net assets acquired | $  84,684 | $  - | $  84,684


Question: What did the company's adjustment to the estimated values of the assets acquired and liabilities assumed  in 2019 include?
Answer: additional liabilities, changes to deferred taxes and changes in the allocation of excess purchase price between goodwill and intangibles.
2019 financial year guidance
The adjusted EBITDA and free cash flow guidance measures for the year ended 31 March 2019 were forward-looking alternative performance measures based on the Group’s assessment of the global macroeconomic outlook and foreign exchange rates of €1:£0.87, €1:ZAR 15.1, €1:TRY 5.1 and €1:EGP 22.1. These guidance measures exclude the impact of licence and spectrum payments, material one-off tax-related payments, restructuring payments, changes in shareholder recharges from India and any fundamental structural change to the Eurozone. They also assume no material change to the current structure of the Group. We believe it is both useful and necessary to report these guidance measures to give investors an indication of the Group’s expected future performance, the Group’s sensitivity to foreign exchange movements and to report actual performance against these guidance measures.
Reconciliations of adjusted EBITDA and free cash flow to the 2019 financial year guidance basis is shown below.
Table:
 |  | Adjusted EBITDA |  | Free cash flow (pre-spectrum)
 | 2019 €m | 2018 €m | Growth | 2019 €m
Reported (IAS 18 basis) | 14,139 | 14,737 | (4.1)% | 5,443
Other activity (including M&A) | (95) | (341) |  | –
Foreign exchange | – | (288) |  | –
Handset financing and settlements | (198) | (674) |  | –
Guidance basis | 13,846 | 13,434 | 3.1% | 5,443


Question: What is the 2019 average adjusted EBITDA, guidance basis?
Answer: 13640
Calculation: (13,846+13,434)/2
(1) No dividend is proposed by the Board of Directors related to the financial year 2019.
(2) Includes net sales to other segments.
The figures are derived from our consolidated financial
statements prepared in accordance with IFRS. Year-on-year
change is in parenthesis.
All Nokia Technologies IPR and Licensing net sales are allocated to Finland.
Table:
Financial highlights |  |  | 
For the year ended December 31, | 2019 | 2018 | 2017
Continuing operations | EURm | EURm | EURm
Net sales | 23,315 | 22,563 | 23,147
Gross profit | 8,326 | 8,446 | 9,139
Gross margin | 35.7% | 37.4% | 39.5%
Operating profit/(loss) | 485 | (59) | 16
Operating margin | 2.1% | (0.3)% | 0.1%
Profit/(loss) for the year | 18 | (549) | (1,437)
 | EUR | EUR | EUR
Earnings per share, diluted | 0.00 | (0.10) | (0.26)
Dividend per share(1) | 0.00 | 0.10 | 0.19
 | 2019 | 2018 | 2017
As of December 31 | EURm | EURm | EURm
Net cash and current financial investments | 1,730 | 3,053 | 4,517


Question: What is the increase / (decrease) in Gross profit from 2018 to 2019?
Answer: -120
Calculation: 8,326 - 8,446
performance graph the performance graph below shows the five-year cumulative total stockholder return on applied common stock during the period from october 31 , 2010 through october 25 , 2015 . this is compared with the cumulative total return of the standard & poor 2019s 500 stock index and the rdg semiconductor composite index over the same period . the comparison assumes $ 100 was invested on october 31 , 2010 in applied common stock and in each of the foregoing indices and assumes reinvestment of dividends , if any . dollar amounts in the graph are rounded to the nearest whole dollar . the performance shown in the graph represents past performance and should not be considered an indication of future performance . comparison of 5 year cumulative total return* among applied materials , inc. , the s&p 500 index and the rdg semiconductor composite index *assumes $ 100 invested on 10/31/10 in stock or index , including reinvestment of dividends . indexes calculated on month-end basis . 201cs&p 201d is a registered trademark of standard & poor 2019s financial services llc , a subsidiary of the mcgraw-hill companies , inc. .

Table:
 | 10/31/2010 | 10/30/2011 | 10/28/2012 | 10/27/2013 | 10/26/2014 | 10/25/2015
applied materials | 100.00 | 104.54 | 90.88 | 155.43 | 188.13 | 150.26
s&p 500 index | 100.00 | 108.09 | 124.52 | 158.36 | 185.71 | 195.37
rdg semiconductor composite index | 100.00 | 110.04 | 104.07 | 136.15 | 172.41 | 170.40
dividends during each of fiscal 2015 and 2014 , applied's board of directors declared four quarterly cash dividends of $ 0.10 per share .
during fiscal 2013 , applied 2019s board of directors declared three quarterly cash dividends of $ 0.10 per share and one quarterly cash dividend of $ 0.09 per share .
dividends paid during fiscal 2015 , 2014 and 2013 amounted to $ 487 million , $ 485 million and $ 456 million , respectively .
applied currently anticipates that cash dividends will continue to be paid on a quarterly basis , although the declaration of any future cash dividend is at the discretion of the board of directors and will depend on applied 2019s financial condition , results of operations , capital requirements , business conditions and other factors , as well as a determination by the board of directors that cash dividends are in the best interests of applied 2019s stockholders .
104 136 10/31/10 10/30/11 10/28/12 10/27/13 10/26/14 10/25/15 applied materials , inc .
s&p 500 rdg semiconductor composite .

Question: how many outstanding shares received dividends in 2013 , ( in millions ) ?
Answer: 1248.7
Calculation: multiply(0.10, const_3), add(#0, 0.09), divide(487, #1)
Acquisition of AFP
On August 1, 2018, the Company acquired AFP, Inc., a privately held fabricator of foam, corrugated, molded pulp and wood packaging solutions, to join its Product Care division. This acquisition expands our protective packaging offerings in the electronic, transportation and industrial markets with custom engineered applications. We acquired 100% of AFP shares for an estimated consideration of $74.1 million, excluding $3.3 million of cash acquired.
The following table summarizes the consideration transferred to acquire AFP and the final allocation of the purchase price among the assets acquired and liabilities assumed.
Table:
 | Preliminary | Measurement | 
 | Allocation | Period | Final Allocation
(In millions) | As of August 1, 2018 | Adjustments | As of September 30, 2019
Total consideration transferred | $ 70.8 | $ 3.3 | $ 74.1
Assets: |  |  | 
Cash and cash equivalents | 2.9 | 0.4 | 3.3
Trade receivables, net | 30.8 | — | 30.8
Inventories, net | 7.1 | — | 7.1
Prepaid expenses and other current assets | 0.7 | — | 0.7
Property and equipment, net | 3.5 | (0.4) | 3.1
Identifiable intangible assets, net | 18.6 | 0.7 | 19.3
Goodwill | 21.6 | 1.0 | 22.6
Other non-current assets | 0.7 | (0.4) | 0.3
Total assets | $ 85.9 | $ 1.3 | $ 87.2
Liabilities: |  |  | 
Current portion of long-term debt | — | 0.1 | 0.1
Accounts payable | 13.8 | (2.2) | 11.6
Other current liabilities | 1.3 | (0.1) | 1.2
Long-term debt, less current portion | — | 0.2 | 0.2
Total liabilities | $ 15.1 | $ (2.0) | $ 13.1


Question: What is the adjustment in assets between August 1, 2018 and September 30, 2019?
Answer: $ 3.3
The following unaudited pro forma financial information is presented as if the acquisitions had taken place at the beginning of the periods presented and should not be taken as representative of the Company’s future consolidated results of operations. The following unaudited pro forma information includes adjustments for the amortization expense related to the identified intangible assets.
The following table summarizes the Company’s unaudited pro forma financial information is presented as if the acquisitions occurred on October 1, 2017 (amounts shown in thousands):
For the year ended September 30, 2018, revenue of $9.1 million and a net loss of $5.3 million related to the A2iA and ICAR businesses since the respective acquisition dates are included in the Company's consolidated statements of operations.
Table:
 | For the years ended September 30, | 
 | 2019 | 2018
Pro forma revenue | $86,206 | $78,130
Pro forma net income (loss) | $889 | $(12,268)


Question: What does the table provide for us?
Answer: the Company’s unaudited pro forma financial information is presented as if the acquisitions occurred on October 1, 2017
Note 12. Liabilities
The components of accounts payable, accrued expenses and other current liabilities are as follows (in thousands):
Table:
 | December 31, 2019 | December 31, 2018
Accounts payable | $32,878 | $20,214
Accrued expenses | 10,092 | 34,557
Subsidiary unit awards | 141 | 200
Other current liabilities | 5,616 | 3,459
Accounts payable, accrued expenses and other current liabilities | $48,727 | $58,430


Question: What were the subsidiary unit awards in 2019?
Answer: 141
Dividends
The following table shows our total cash dividends paid in the years ended December 31:
On February 13, 2020, our Board of Directors declared a quarterly cash dividend of $0.16 per common share payable on March 20, 2020 to stockholders of record at the close of business on March 6, 2020. The estimated amount of this dividend payment is $24.8 million based on 154.7 million shares of our common stock issued and outstanding as of February 21, 2020.
The dividend payments discussed above are recorded as reductions to cash and cash equivalents and retained earnings on our Consolidated Balance Sheets. Our credit facility and our senior notes contain covenants that restrict our ability to declare or pay dividends and repurchase stock. However, we do not believe these covenants are likely to materially limit the future payment of quarterly cash dividends on our common stock. From time to time, we may consider other means of returning value to our stockholders based on our consolidated financial condition and results of operations. There is no guarantee that our Board of Directors will declare any further dividends.
Table:
(In millions, except per share amounts) | Total Cash Dividends Paid | Total Cash Dividends Paid Per Common Share
2017 | $119.7 | $0.64
2018 | 102.9 | 0.64
2019 | 99.1 | 0.64
Total | $321.7 | 


Question: What is the Total Cash Dividends Paid for 2017?
Answer: $119.7
13. Other investments
The Group holds a number of other listed and unlisted investments, mainly comprising managed funds, loan notes, deposits and government bonds.
Accounting policies
Other investments comprising debt and equity instruments are recognised and derecognised on a trade date where a purchase or sale of an investment is under a contract whose terms require delivery of the investment within the timeframe established by the market concerned, and are initially measured at fair value, including transaction costs.
Debt securities that are held for collection of contractual cash flows where those cash flows represent solely payments of principal and interest are measured at amortised cost using the effective interest method, less any impairment. Debt securities that do not meet the criteria for amortised cost are measured at fair value through profit and loss.
Equity securities are classified and measured at fair value through other comprehensive income, there is no subsequent reclassification of fair value gains and losses to profit or loss following derecognition of the investment. See note 1 “Basis of preparation” for previous measurement categories applicable to the comparative balances at 31 March 2018
Debt securities include loan notes of US$nil (2018: US$2.5 billion (€2.0 billion) issued by Verizon Communications Inc. as part of the Group’s disposal of its interest in Verizon Wireless all of which is recorded within non-current assets and €0.8 billion (2018: €0.9 billion) issued by VodafoneZiggo Holding B.V.
1  Items are measured at fair value and the valuation basis is level 2 classification, which comprises items where fair value is determined from inputs other than quoted prices that are observable for the asset or liability, either directly or indirectly.
2  Items are measured at amortised cost and the carrying amount approximates fair value.
Table:
 | 2019 | 2018
 | €m | €m
Included within non-current assets: |  | 
Equity securities1 | 48 | 47
Debt securities2 | 822 | 3,157
 | 870 | 3,204


Question: What is the difference between average equity securities and average debt securities ?
Answer: 1942
Calculation: [(822+3,157)/2] - [(48+47)/2]
A.4.2 Income
As a result of the development described for the segments, Income from continuing operations before income taxes declined 7 %. Severance charges for continuing operations were € 619 million, of which € 492 million were in Industrial Businesses. Accordingly, Adjusted EBITA margin Industrial Businesses excluding severance charges was 11.5 % in fiscal 2019. In fiscal 2018, severance charges for continuing operations were € 923 million, of which € 669 million were in Industrial Businesses.
The tax rate of 25% for fiscal 2019 was below the tax rate of 26% for the prior year, benefiting mainly from the reversal of income tax provisions outside Germany. As a result, Income from continuing operations declined 6%.
Income from discontinued operations, net of income taxes in the prior year included positive effects from the release of a provision related to former Communications activities.
The decline in basic earnings per share reflects the decrease of Net income attributable to Shareholders of Siemens AG, which was € 5,174 million in fiscal 2019 compared to € 5,807 million in fiscal 2018, partially offset by a lower number of weighted average shares outstanding. Basic earnings per share excluding severance charges was € 6.93.
As expected, ROCE at 11.1 % was below the target range set in our Siemens Financial Framework, reflecting in particular the effects from portfolio transactions in recent years, including the acquisitions of Mentor and Mendix at Digital Industries and the merger of Siemens’ wind power business with Gamesa Corporación Tecnológica, S. A. that created SGRE. The decline year-over-year was due both to lower income before interest after tax and to higher average capital employed.
Table:
 |  | Fiscal year | 
(in millions of €, earnings per share in €) | 2019 | 2018 | % Change
Digital Industries | 2,880 | 2,898 | (1) %
Smart Infrastructure | 1,500 | 1,574 | (5) %
Gas and Power | 679 | 722 | (6) %
Mobility | 983 | 958 | 3 %
Siemens Healthineers | 2,461 | 2,221 | 11 %
Siemens Gamesa Renewable Energy | 482 | 483 | 0 %
Industrial Businesses | 8,986 | 8,857 | 1 %
Adjusted EBITA margin Industrial Businesses | 10.9 % | 11.1 % | 
Financial Services | 632 | 633 | 0 %
Portfolio Companies | (71) | (305) | 77 %
Reconciliation to Consolidated Financial Statements | (2,028) | (1,135) | (79) %
Income from continuing operations before income taxes | 7,518 | 8,050 | (7) %
Income tax expenses | (1,872) | (2,054) | 9 %
Income from continuing operations | 5,646 | 5,996 | (6) %
Income from discontinued operations, net of income taxes | 3 | 124 | (98) %
Net income | 5,648 | 6,120 | (8) %
Basic earnings per share | 6.41 | 7.12 | (10) %
ROCE | 11.1 % | 12.6 % | 


Question: What was the impact of development described for the segments?
Answer: As a result of the development described for the segments, Income from continuing operations before income taxes declined 7 %
We continue to experience challenging trends in both the high-end smartphone market and in the broadband market. However, with leading mobile and fixed networks, improving customer experience, three strong brands and further enhancements to BT Plus, with 5G coming imminently, we are well placed for the future.
Adjusteda revenue growth of 3% for the year was driven by the continued increase in handset costs for customers, growth in the SIMonly base across all brands and the impact of price increases, partially offset by solus voice price reductions.
Adjusteda EBITDA grew 7% for the year as the revenue growth was partially offset by increased trading costs.
Capital expenditure growth of 8% was driven by increased network spend as preparations were made for the EE 5G launch in 2019. Normalised free cash flowb was £1,323m, down 5% on last year as the increase in EBITDA was offset by the settlement at the start of the year of the Phones4U dispute relating to the retail trading agreement, and increased capital expenditure.
Mobile churnc was stable at 1.2% for the year, whilst fixed churnc was up from 1.3% to 1.4% reflecting the impact of price increases in the year.
a Adjusted measures exclude specific items, as explained in the Additional Information on page 185. b Free cash flow after net interest paid, before pension deficit payments (including the cash tax benefit of pension deficit payments) and specific items.
Table:
Consumer |  |  |  | 
Adjusteda revenue £10,695m |  | Adjusteda operating profit £1,510m |  | 
 | 2019 (IFRS 15) | 2018 (IAS 18) | Change | 
Year to 31 March | £m | £m | £m | %
Adjusteda revenue | 10,695 | 10,360 | 335 | 3
Adjusteda operating costs | 8,161 | 7,984 | 177 | 2
Adjusteda EBITDA | 2,534 | 2,376 | 158 | 7
Depreciation & amortisation | 1,024 | 992 | 32 | 3
Adjusted a operating profit | 1,510 | 1,384 | 126 | 9
Capital expenditure | 994 | 919 | 75 | 8
Normalised free cash flowb | 1,323 | 1,389 | (66) | (5


Question: What was the Adjusted revenue change?
Answer: 3%
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
3. PROPERTY AND EQUIPMENT
Property and equipment (including assets held under finance leases) consisted of the following:
(1) Assets on leased land are depreciated over the shorter of the estimated useful life of the asset or the term of the corresponding ground lease taking into consideration lease renewal options and residual value.
(2) Includes fiber and DAS assets.
(3) Estimated useful lives apply to improvements only.
Table:
 | Estimated Useful Lives (years) (1) | December 31, 2019 | December 31, 2018
Towers | Up to 20 | $13,930.7 | $12,777.9
Equipment (2) | 2 - 20 | 1,897.3 | 1,667.3
Buildings and improvements | 3 - 32 | 638.9 | 628.5
Land and improvements (3) | Up to 20 | 2,486.1 | 2,285.4
Construction-in-progress |  | 372.6 | 358.1
Total |  | 19,325.6 | 17,717.2
Less accumulated depreciation |  | (7,241.2) | (6,470.1)
Property and equipment, net |  | $12,084.4 | $11,247.1


Question: What was the change in Construction-in-progress between 2018 and 2019?
Answer: 14.5
Calculation: 372.6-358.1
Accumulated other comprehensive income (loss)
Components and activities of AOCI, net of tax, were as follows:
During fiscal 2018, a net foreign currency translation loss of $8 million related to foreign entities sold in the divestiture of our WSS and PKI solutions was reclassified to Gain on divestiture, and a net gain of $3 million related to liquidated foreign entities was reclassified to Other income (expense), net. A realized gain of $7 million on securities sold in connection with the divestiture of our WSS and PKI solutions was reclassified to Gain on divestiture. The tax effect of $3 million was reclassified to Income tax expense (benefit).
Table:
(In millions) | Foreign Currency Translation Adjustments | Unrealized Gain (Loss) On Available- For-Sale Securities | Equity Method Investee | Total AOCI
Balance as of March 31, 2017 | $7 | $5 | $— | $12
Other comprehensive loss before reclassifications | (4) | (5) | — | (9)
Reclassification to net income (loss) | 5 | (4) | — | 1
Balance as of March 30, 2018 | 8 | (4) | — | 4
Other comprehensive income (loss) before reclassifications | (13) | 3 | (1) | (11)
Balance as of March 29, 2019 | $(5) | $(1) | $(1) | $(7)


Question: As of March 31, 2017, what is the difference between the value of foreign currency translation adjustments and the unrealized gain on available-for-sale securities?  
Answer: 2
Calculation: 7-5
Note 3: Debt
A summary of debt is as follows (amounts in thousands):
(1) Amount shown is net of discount, bank issuance costs and other indirect issuance costs of $13.3 million as of March 31, 2018.
(2) Amount shown is net of discount, bank issuance costs and other indirect issuance costs of $8.7 million as of March 31, 2019.
(3) Amount shown is net of discount of $2.1 million as of March 31, 2019.
(4) Amounts shown are net of discounts of $0.6 million and $0.5 million as of March 31, 2019 and 2018, respectively.
Table:
 | March 31, | 
 | 2019 | 2018
Term Loan Credit Agreement (1) | $— | $318,782
TOKIN Term Loan Facility (2) | 276,808 | —
Customer Advances (3) | 11,270 | —
Other, net (4) | 6,393 | 5,841
Total debt | 294,471 | 324,623
Current maturities | (28,430) | (20,540)
Total long-term debt | $266,041 | $304,083


Question: What was the change in Total debt between 2018 and 2019?
Answer: -30152
Calculation: 294,471-324,623
Property and Equipment, net
Property and equipment consist of the following (in thousands):
As of July 31, 2019 and 2018, no property and equipment was pledged as collateral. Depreciation expense, excluding the amortization of software development costs, was $9.7 million, $7.7 million, and $6.6 million for the fiscal years ended July 31, 2019, 2018, and 2017, respectively.
The Company capitalizes software development costs for technology applications that the Company will offer solely as cloud-based subscriptions, which is primarily comprised of compensation for employees who are directly associated with the software development projects. The Company begins amortizing the capitalized software development costs once the technology applications are available for general release over the estimated lives of the applications, ranging from three to five years.
The Company recognized approximately $1.0 million and $0.4 million in amortization expense in cost of revenue - license and subscription on the accompanying consolidated statements of operations during the fiscal years ended July 31, 2019 and 2018, respectively. There was no such amortization during the fiscal year ended July 31, 2017.
Table:
 | July 31, 2019  | July 31, 2018
Computer hardware | $17,799 | $20,614
Software | 6,741 | 4,664
Capitalized software development costs | 7,374 | 3,978
Equipment and machinery | 10,455 | 4,265
Furniture and fixtures | 8,137 | 4,217
Leasehold improvements | 48,191 | 10,751
    Total property and equipment | 98,697 | 48,489
Less accumulated depreciation | (32,888) | (29,894)
    Property and equipment, net  | $65,809 | $18,595


Question: What was the value of Computer hardware in 2019?
Answer: $17,799