hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Return on invested capital (ROIC)
ROIC measures the after tax return on the total capital invested in the business. It is calculated as adjusted operating profit after tax divided by average invested capital.
An analysis of the components is as follows:
Table:
 | 2019 | 2018
 | £m | £m
Total equity | 826.3 | 766.9
Net debt | 334.1 | 235.8
Total invested capital | 1,160.4 | 1,002.7
Average invested capital | 1,081.6 | 992.9
Average invested capital (excluding IFRS 16) | 1,061.2 | 992.9
Operating profit as reported under IFRS | 245.0 | 299.1
Adjustments (see adjusted operating profit) | 37.7 | (34.2)
Adjusted operating profit | 282.7 | 264.9
Taxation | (80.6) | (73.1)
Adjusted operating profit after tax | 202.1 | 191.8
Adjusted operating profit after tax (excluding IFRS 16) | 201.2 | 191.8
Return in invested capital | 18.7% | 19.3%
Return in invested capital (excluding IFRS 16) | 19.0% | 19.3%


Question: What is the percentage change in net debt in 2019 from 2018?
Answer: 41.69
Calculation: (334.1-235.8)/235.8
Assets Measured at Fair Value on a Recurring Basis
Assets measured at fair value on a recurring basis at March 31, 2018 are as follows (amounts in millions):
There were no transfers between Level 1 or Level 2 during fiscal 2019 or fiscal 2018. There were no assets measured on a recurring basis during fiscal 2019 or fiscal 2018 using significant unobservable inputs (Level 3).
Table:
 | Quoted Prices in Active Markets for Identical Instruments (Level 1) | Significant Other Observable Inputs (Level 2) | Total Balance
Assets |  |  | 
Cash and cash equivalents: |  |  | 
Money market mutual funds | $121.0 | $— | $121.0
Deposit accounts | — | 641.6 | 641.6
Commercial Paper | — | 118.7 | 118.7
Government agency bonds | — | 20.0 | 20.0
Short-term investments: |  |  | 
Marketable equity securities | 2.8 | — | 2.8
Corporate bonds and debt | — | 542.9 | 542.9
Time deposits | — | 11.5 | 11.5
Government agency bonds | — | 723.2 | 723.2
Municipal bonds - taxable | — | 14.9 | 14.9
Total assets measured at fair value | $123.8 | $2,072.8 | $2,196.6


Question: What was the total balance for Money market mutual funds?
Answer: 121.0
DSUs
Eligible bonuses and RSUs/PSUs may be paid in the form of DSUs when executives or other eligible employees elect to or are required to participate in the plan. The value of a DSU at the issuance date is equal to the value of one BCE common share. For non-management directors, compensation is paid in DSUs until the minimum share ownership requirement is met; thereafter, at least 50% of their compensation is paid in DSUs. There are no vesting requirements relating to DSUs. Dividends in the form of additional DSUs are credited to the participant’s account on each dividend payment date and are equivalent in value to the dividends paid on BCE common shares. DSUs are settled when the holder leaves the company.
The following table summarizes the status of outstanding DSUs at December 31, 2019 and 2018.
(1) The weighted average fair value of the DSUs issued was $59 in 2019 and $55 in 2018.
Table:
NUMBER OF DSUs | 2019 | 2018
Outstanding, January 1 | 4,391,997 | 4,309,528
Issued (1) | 84,588 | 94,580
Settlement of RSUs/PSUs | 146,960 | 112,675
Dividends credited | 236,079 | 240,879
Settled | (236,525) | (365,665)
Outstanding, December 31 | 4,623,099 | 4,391,997


Question: Which years does the table summarize the status of outstanding DSUs?
Answer: 2019, 2018
Issuer Purchases of Equity Securities
(i) Includes 3,416 shares that have been withheld by the Company to satisfy its tax withholding and remittance obligations in connection with the vesting of restricted stock awards. In addition, the Company exercised a pro-rata portion of the 2022 convertible note hedges (described in Note 12, Indebtedness, of the Notes to the Consolidated Financial Statements) to offset the shares of the Company’s Class A common stock issued to settle the conversion of certain 2022 Notes. The note hedges were net share settled and the Company received 3,643,165 shares of the Company’s Class A common stock from the counterparties in October of 2018.
(ii) Excludes the shares received through the exercise of the note hedges.
(iii) The Company exercised a pro-rata portion of the 2022 convertible note hedges to offset the shares of the Company’s Class A common stock issued to settle the conversion of certain 2022 Notes. The note hedges were net share settled and the Company received 1,096,773 shares of the Company’s Class A common stock from the counterparties in November of 2018.
Table:
Period | Total number of Shares purchased | Average price paid per share | Total number of shares purchased as part of publicly announced plans or programs | Maximum number (or approximate dollar value) of shares that may yet be purchased under the plans or programs
October 1 to October 31 | 3,646,581 (i) | 97.28 (ii) | — | —
November 1 to November 30 | 1,096,773 (iii) | — (ii) | — | —
December 1 to December 31 | — | — | — | —
Total | 4,743,354 | 97.28 (ii) | — | —


Question: What are the months provided in the period column?
Answer: October, November, December
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
NOTE 23. SUPPLEMENTAL QUARTERLY FINANCIAL DATA (UNAUDITED)
The following tables present unaudited quarterly results for each of the eight quarters in the periods ended December 31, 2019 and 2018, in thousands. We believe that all necessary adjustments have been included in the amounts stated below to present fairly such quarterly information. Due to the volatility of the industries in which our customers operate, the operating results for any quarter are not necessarily indicative of results for any subsequent period.
Table:
 |  | Quarter Ended |  | 
 | December 31, | September 30, | June 30, | March 31,
 | 2018 | 2018 | 2018 | 2018
Sales, net | $154,161 | $173,082 | $196,032 | $195,617
Gross Profit | $  75,188 | $  85,539 | $ 101,235 | $ 103,645
Restructuring Expense | $  3,836 | $  403 | $ — | $ —
Operating income | $  19,570 | $  39,862 | $ 56,018 | $ 56,103
Income from continuing operations, net of income taxes | $  19,222 | $  35,157 | $ 46,400 | $ 46,370
Loss (income) from discontinued operations, net of income taxes | $  188 | $  (371) | $ 5 | $ 140
Net Income | $19,410 | $34,786 | $46,405 | $46,510
Income from continuing operations attributable to noncontrolling interest | $  4 | $  7 | $ 44 | $ 31
Net income attributable to Advanced Energy Industries, Inc. | $  19,406 | $34,779 | $46,361 | $ 46,479
Earnings (Loss) Per Share: |  |  |  | 
Continuing Operations: |  |  |  | 
Basic earnings per share | $0.50 | $0.90 | $1.18 | $1.17
Diluted earnings per share | $0.50 | $0.90 | $1.17 | $1.16
Discontinued Operations: |  |  |  | 
Basic loss per share | $  — | $  (0.01) | $ — | $ —
Diluted loss per share | $  — | $  (0.01) | $ — | $ —
Net Income: |  |  |  | 
Basic earnings per share | $ 0.51 | $  0.89 | $ 1.18 | $1.17
Diluted earnings per share | $0.50 | $0.89 | $1.17 | $1.16


Question: What was the diluted earnings per share of Continuing Operations in Quarter Ended  September?
Answer: $0.90
The following table disaggregates our revenue by major source for the year ended December 31, 2018:
(1) Subscriber Solutions & Experience was formerly reported as Customer Devices. With the increasing focus on enhancing the customer experience for both our business and consumer broadband customers and the addition of SmartRG during the fourth quarter of 2018, Subscriber Solutions & Experience more accurately represents this revenue category.
Table:
(In thousands) | Network Solutions | Services & Support | Total
Access & Aggregation | $301,801 | $57,069 | $358,870
Subscriber Solutions & Experience (1) | 129,067 | 5,393 | 134,460
Traditional & Other Products | 27,364 | 8,583 | 35,947
Total | $458,232 | $71,045 | $529,277


Question: What does the table show?
Answer: disaggregates our revenue by major source for the year ended December 31, 2018
Foreign Currencies
As a multinational business, the Company's transactions are denominated in a variety of currencies. When appropriate, the Company uses forward foreign currency contracts to reduce its overall exposure to the effects of currency fluctuations on its results of operations and cash flows. The Company's policy prohibits trading in currencies for which there are no underlying exposures and entering into trades for any currency to intentionally increase the underlying exposure.
The Company primarily hedges existing assets and liabilities associated with transactions currently on its balance sheet, which are undesignated hedges for accounting purposes.
As of December 31, 2019 and 2018, the Company had net outstanding foreign exchange contracts with net notional amounts of $183.3 million and $157.3 million, respectively. Such contracts were obtained through financial institutions and were scheduled to mature within one to three months from the time of purchase.
Management believes that these financial instruments should not subject the Company to increased risks from foreign exchange movements because gains and losses on these contracts should offset losses and gains on the underlying assets, liabilities and transactions to which they are related.
The following schedule summarizes the Company's net foreign exchange positions in U.S. dollars (in millions):
Amounts receivable or payable under the contracts are included in other current assets or accrued expenses in the accompanying Consolidated Balance Sheets. For the years ended December 31, 2019, 2018 and 2017, realized and unrealized foreign currency transactions totaled a loss of $5.0 million, $8.0 million and $6.3 million, respectively. The realized and unrealized foreign currency transactions are included in other income and expenses in the Company's Consolidated Statements of Operations and Comprehensive Income.
Table:
 |  | As of December 31, |  | 
 | 2019 |  | 2018 | 
 | Buy (Sell) | Notional Amount | Buy (Sell) |  Notional Amount
Japanese Yen | $49.8 | $49.8 | $29.9 | $29.9
Philippine Peso | 36.4 | 36.4 | 30.1 | 30.1
Malaysian Ringgit | 20.4 | 20.4 | — | —
Chinese Yuan | 20.2 | 20.2 | 20.4 | 20.4
Korean Won | 18.1 | 18.1 | 20.8 | 20.8
Czech Koruna | 11.9 | 11.9 | 9.2 | 9.2
Euro | — | — | 13.1 | 13.1
Other currencies - Buy | 21.9 | 21.9 | 26.3 | 26.3
Other currencies - Sell | (4.6) | 4.6 | (7.5) | 7.5
 | $174.1 | $183.3 | $142.3 | $157.3


Question: What is the average Japanese Yen Buy position for December 31, 2018 and 2019?
Answer: 39.85
Calculation: (49.8+29.9) / 2
ITEM 7. MANAGEMENT'S DISCUSSION AND ANALYSIS OF FINANCIAL CONDITION AND RESULTS OF OPERATIONS (United States Dollars in thousands, except per share data and unless otherwise indicated)
Fair value change in FCR liability
The following table reconciles the beginning and ending measurements of our FCR liability and highlights the activity that drove the fair value change in FCR liability included in our cost of revenue.
(1) Includes: (i) incentive payments from Bank Partners, which is the surplus of finance charges billed to borrowers over an agreedupon portfolio yield, a fixed servicing fee and realized net credit losses, (ii) cash received from recoveries on previously charged-off Bank Partner loans, and (iii) the proceeds received from transferring our rights to Charged-Off Receivables (as defined below) attributable to previously charged-off Bank Partner loans. We consider all monthly incentive payments from Bank Partners during the period to be related to billed finance charges on deferred interest products until monthly incentive payments exceed total billed finance charges on deferred products, which did not occur during any of the periods presented.
(2) Represents the reversal of previously billed finance charges associated with deferred payment loan principal balances that were repaid within the promotional period.
(3) A fair value adjustment is made based on the expected reversal percentage of billed finance charges (expected settlements), which is estimated at each reporting date. The fair value adjustment is recognized in cost of revenue in the Consolidated Statements of Operations.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Beginning balance | $138,589 | $94,148 | $68,064
Receipts(1) | 159,527 | 129,153 | 109,818
Settlements(2) | (262,449) | (181,590) | (127,029)
Fair value changes recognized in cost of revenue(3) | 170,368 | 96,878 | 43,295
Ending balance | $206,035 | $138,589 | $94,148


Question: What was the change in the amount of Settlements between 2017 and 2019?
Answer: -135420
Calculation: -262,449-(-127,029)
Sales and Marketing Expense
Sales and marketing expense increased by $22.6 million in 2018 compared to 2017. The increase was primarily due to a $20.0 million increase in employee- related costs, which includes stock-based compensation, associated with our increased headcount from 215 employees as of December 31, 2017 to 286 employees as of December 31, 2018. The remaining increase was principally the result of a $1.8 million increase in trade show and advertising costs and a $0.8 million increase attributed to office related expenses to support the sales team. The adoption of ASC 606 did not have a material impact on the change in commission expense when compared to year over year.
Table:
 | Year Ended December 31, |  | Change | 
 | 2018 | 2017 | $ | %
 |  | (dollars in thousands) |  | 
Sales and marketing | $ 69,608 | $ 46,998 | $ 22,610 | 48.1%
% of revenue | 47% | 45% |  | 


Question: What was the Sales and marketing expense in 2018 and 2017?
Answer: 69,608, 46,998
2018 Compensation
The following table provides information regarding the total compensation that was earned by each of our non-employee directors in 2018.
(1) The amounts included in the “Stock Awards” column represent the aggregate grant date fair value of RSU awards calculated in accordance with Financial Accounting Standards Board Accounting Standards Codification Topic 718 (“ASC 718”). The amount does not necessarily correspond to the actual value recognized by the non-employee director. The valuation assumptions used in determining such amounts are described in the Notes to the Consolidated Financial Statements included in our Annual Report on Form 10-K for the fiscal year ended December 31, 2018.
(2) The amounts included in the “Stock Awards” column representing the annual awards or initial awards, as applicable, granted to our non-employee directors in 2018 are detailed below. Each of these awards vests and settles on the earlier of the first anniversary of the grant date or the date of our Annual Meeting, subject to the director’s continued service through the vesting date.
(3) The amounts included in the “Stock Awards” column representing the awards of RSUs granted to our non-employee directors in lieu of cash retainers in 2018 are described below. Each of these awards vested and settled in full on the grant date.
(4)  As of December 31, 2018, Dr. Simmons also held a fully vested option to purchase 38,000 shares of our Class B common stock.
(5)  As of December 31, 2018, Mr. Viniar also held 8,750 RSUs granted in 2015 to be settled in shares of our Class B common stock, which shares vest in full on the earlier of June 21, 2019 or the 2019 annual meeting subject to Mr. Viniar’s continued service with us through such vesting date. As of December 31, 2018, Mr. Viniar also held a fully vested option to purchase 326,950 shares of our Class B common stock.
Table:
Director | Fees Earned or Paid in Cash($) | Stock Awards ($)(1)(2)(3) | Total ($)
Roelof Botha | — | 305,119 | 305,119
Paul Deighton | 45,000 | 249,998 | 294,998
Randy Garutti | 42,500 | 249,998 | 292,488
James McKelvey | — | 290,041 | 290,041
Mary Meeker | — | 305,119 | 305,119
Anna Patterson | 50,000 | 249,988 | 299,988
Naveen Rao | 45,000 | 249,988 | 294,988
Ruth Simmons (4) | — | 300,132 | 300,132
Lawrence Summers | 50,903 | 249,988 | 300,891
David Viniar (5) | — | 382,610 | 382,610


Question: Which director(s) earned the largest amount of total compensation?
Answer: David Viniar
Calculation: From COL5 find the largest number and the corresponding name(s) in COL2
Note 5. Inventory, Net
The components of inventory, net are as follows (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Raw materials | $8,921 | $6,396
Finished goods | 25,247 | 16,594
Total inventory, net | $34,168 | $22,990


Question: What was the change in raw materials between 2018 and 2019?
Answer: 2525
Calculation: 8,921-6,396
we believe that the presentation of adjusted diluted earnings per share , which excludes withdrawal costs 2013 multiemployer pension funds , restructuring charges , loss on extinguishment of debt , and ( gain ) loss on business dispositions and impairments , net , provides an understanding of operational activities before the financial effect of certain items . we use this measure , and believe investors will find it helpful , in understanding the ongoing performance of our operations separate from items that have a disproportionate effect on our results for a particular period . we have incurred comparable charges and costs in prior periods , and similar types of adjustments can reasonably be expected to be recorded in future periods . our definition of adjusted diluted earnings per share may not be comparable to similarly titled measures presented by other companies . property and equipment , net in 2017 , we anticipate receiving approximately $ 975 million of property and equipment , net of proceeds from sales of property and equipment , as follows: .

Table:
trucks and equipment | $ 350
landfill | 330
containers | 160
facilities and other | 150
property and equipment received during 2017 | 990
proceeds from sales of property and equipment | -15 ( 15 )
property and equipment received net of proceeds during 2017 | $ 975
results of operations revenue we generate revenue primarily from our solid waste collection operations .
our remaining revenue is from other services , including transfer station , landfill disposal , recycling , and energy services .
our residential and small- container commercial collection operations in some markets are based on long-term contracts with municipalities .
certain of our municipal contracts have annual price escalation clauses that are tied to changes in an underlying base index such as a consumer price index .
we generally provide small-container commercial and large-container industrial collection services to customers under contracts with terms up to three years .
our transfer stations , landfills and , to a lesser extent , our recycling facilities generate revenue from disposal or tipping fees charged to third parties .
in general , we integrate our recycling operations with our collection operations and obtain revenue from the sale of recycled commodities .
our revenue from energy services consists mainly of fees we charge for the treatment of liquid and solid waste derived from the production of oil and natural gas .
other revenue consists primarily of revenue from national accounts , which represents the portion of revenue generated from nationwide or regional contracts in markets outside our operating areas where the associated waste handling services are subcontracted to local operators .
consequently , substantially all of this revenue is offset with related subcontract costs , which are recorded in cost of operations. .

Question: as part of the sales proceeds net what was the percent of the trucks and equipment
Answer: 35.9%
Calculation: divide(350, 975)
Share-Based Compensation Expense
The following table sets forth the total share-based compensation expense included in our consolidated statements of operations (amounts in millions):
Table:
 |  | For the Years Ended December 31, | 
 | 2019 | 2018 | 2017
Cost of revenues—product sales: Software royalties, amortization, and intellectual property licenses | $19 | $13 | $10
Cost of revenues—subscription, licensing, and other revenues: Game Operations and Distribution Costs | 1 | 2 | 1
Cost of revenues—subscription, licensing, and other revenues: Software royalties, amortization, and intellectual property licenses | 1 | 3 | 3
Product development | 53 | 61 | 57
Sales and marketing | 10 | 15 | 15
General and administrative | 82 | 115 | 92
Share-based compensation expense before income taxes | 166 | 209 | 178
Income tax benefit | (29) | (46) | (34)
Total share-based compensation expense, net of income tax benefit | $137 | $163 | $144


Question: What was the change in product development between 2018 and 2019?
Answer: -8
Calculation: 53-61
NOTE 3. PROPERTY AND EQUIPMENT
The classification of property and equipment, together with their estimated useful lives is as follows:
(1) Excludes assets held for sale
(2) Lesser of lease term or estimated useful life
The change in property and equipment in accrued liabilities was $14,315 and $15,674 for the fiscal years ended June 30, 2019 and 2018, respectively. These amounts were excluded from capital expenditures on the statements of cash flows.
No impairments of property and equipment were recorded in fiscal 2019 or 2018.
During the third quarter of fiscal 2019, the Company received an unsolicited offer to purchase its Houston, TX, facility. At June 30, 2019, the facility included assets with a carrying value of approximately $5,055. Although management has not committed to the sale, a sale of the facility during fiscal 2020 is likely and the Company expects to record a gain on the sale upon closing, since the offer represents full appraisal value for the facility. Therefore, the assets are considered held for sale at June 30, 2019. Also held for sale at June 30, 2019, was the Company’s Elizabethtown, KY facility. During the third quarter of fiscal 2018, the Company reached a definitive agreement to sell the property for $1,300 pending an expected closing date during the second quarter of fiscal 2020. An impairment loss was recorded on this facility during fiscal 2017 as disclosed in Note 2 to the Company’s consolidated financial statements. Total assets held for sale by the Company at June 30, 2019 and 2018 were $6,355 and $1,300, respectively, and were included in assets held for sale on the Company’s consolidated balance sheet for each year. Those balances are not included on the above table.
Table:
 | June 30, |  | 
 | 2019 | 2018 | Estimated Useful Life
Land (1) | $23,243 | $24,845 | 
Land improvements (1) | 25,209 | 25,383 | 5 - 20 years
Buildings (1) | 147,220 | 143,918 | 20 - 30 years
Leasehold improvements | 48,478 | 48,060 | 5 - 30 years(2)
Equipment and furniture | 365,101 | 328,864 | 3 - 10 years
Aircraft and equipment | 39,293 | 38,761 | 4 - 10 years
Construction in progress | 12,411 | 39,872 | 
 | 660,955 | 649,703 | 
Less accumulated depreciation | 388,481 | 364,153 | 
Property and equipment, net | $272,474 | $285,550 | 


Question: What is the estimated useful life of leasehold improvements?
Answer: 5 - 30 years