hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Contractual Obligations
We have various contractual obligations impacting our liquidity. The following represents our contractual obligations as of January 31, 2020 (table in millions)
(1) Consists of principal and interest payments on the Senior Notes. Refer to “Liquidity and Capital Resources” for a discussion of the public debt offering we issued on August 21, 2017 in the aggregate principal amount of $4.0 billion.
(2) Consists of principal and interest payments on the outstanding note payable to Dell. Refer to “Liquidity and Capital Resources” for a discussion of the $270 million note payable we entered into with Dell per the note exchange agreement from January 21, 2014.
(3) Consists of the principal on the senior unsecured term loan facility (the “Term Loan”). The Term Loan can be repaid any time before October 2020. Given the variable nature of the interest on the Term Loan, including when the repayment will take place, interest payments have been excluded from the table above.
(4) Consists of both operating and finance leases. Our operating leases are primarily for facility space and land. Amounts in the table above exclude legally binding minimum lease payments for leases signed but not yet commenced of $361 million, as well as expected sublease income.
(5) Consists of future cash payments related to the Transition Tax.
(6) As of January 31, 2020, we had $479 million of gross uncertain tax benefits, excluding interest and penalties. The timing of future payments relating to these obligations is highly uncertain. Based on the timing and outcome of examinations of our subsidiaries, the result of the expiration of statutes of limitations for specific jurisdictions or the timing and result of ruling requests from taxing authorities, it is reasonably possible that within the next 12 months total unrecognized tax benefits could be potentially reduced by approximately $17 million.
Table:
 |  |  | Payments Due by Period |  | 
 | Total | Less than 1 year | 1-3 years | 3-5 years | More than 5 years
Senior Notes(1) | $4,552 | $1,372 | $1,686 | $98 | $1,396
Note payable to Dell(2) | 283 | 5 | 278 | — | —
Term Loan(3) | 1,500 | 1,500 | — | — | —
Future Lease Commitments(4) | 1,202 | 144 | 268 | 178 | 612
Purchase obligations | 255 | 168 | 87 | — | —
Tax obligations(5) | 545 | 53 | 104 | 227 | 161
Asset Retirement Obligations | 13 | 1 | 5 | 2 | 5
Sub-Total | 8,350 | 3,243 | 2,428 | 505 | 2,174
Uncertain tax positions(6) | 479 |  |  |  | 
Total | $8,829 |  |  |  | 


Question: What were the total future lease commitments?
Answer: 1,202
12. Commitments and Contingencies
The Company leases its facilities under non-cancelable operating leases and build-to-suit leases with various expiration dates through March 2029. Rent expense related to the Company’s office facilities was $5.3 million, $4.8 million and $3.2 million for the years ended March 31, 2019, 2018 and 2017, respectively. The Company has also entered into various capital lease agreements for computer equipment with non-cancelable terms through January 2022 and has non-cancelable commitments related to its data centers.
Future minimum payments for our capital leases, facility operating leases (including Lexington MA – U.S. build-to-suit lease) and data center operating leases as of March 31, 2019 are as follows:
Certain amounts included in the table above relating to data center operating leases for the Company’s servers include usage-based charges in addition to base rent.
Future lease payments in the table above do not include amounts due to the Company for future minimum sublease rental income of $0.6 million under non-cancelable subleases through 2020.
The Company has outstanding letters of credit of $3.9 million and $3.8 million related to certain operating leases as of March 31, 2019 and 2018, respectively.
Table:
Year Ending March 31, | Capital Leases | Facility Leases | Data Centers
2020 | $ 918 | $ 10,649 | $ 21,216
2021 | 1,102 | 15,186 | 17,427
2022 | 326 | 14,111 | 13,010
2023 | — | 13,825 | 2,774
2024 | — | 13,686 | 356
Thereafter   | — | 59,502 | —
Total minimum lease payments  | $ 2,346 | $ 126,959 | $ 54,783
Less: Amount representing interest   | (121) |  | 
Present value of capital lease obligations   | 2,225 |  | 
Less: Current portion   | (844) |  | 
Long-term portion of capital lease obligations  | $1,381 |  | 


Question: How much was the outstanding letters of credit related to certain operating leases as of March 31, 2018?
Answer: $3.8 million
Liquidity and Capital Resources
As of December 31, 2019, we had total current assets of approximately $27.1 million, compared with current liabilities of approximately $6.1 million, resulting in working capital of approximately $21.0 million and a current ratio of approximately 4.4 to 1. This compares with the working capital balance of approximately $11.5 million and the current ratio of 3.7 to 1 at December 31, 2018. This increase in working capital, as discussed in more detail below, is primarily the result of the capital we raised in 2019.
Following is a table with summary data from the consolidated statement of cash flows for the years ended December 31, 2019 and 2018, as presented.
Our operating activities used approximately $1.7 million in the year ended December 31, 2019, as compared with approximately $0.8 million provided by operating activities in the year ended December 31, 2018. The cash provided in 2018 was the result of our net income and non-cash expenses, partially offset by the increased working capital required to support higher revenues. The cash used in operations in 2019 was the result of increased levels of working capital required to support higher revenue levels, expenditures related to growth, and costs associated with our acquisition in 2019.
We used approximately $5.7 million in investing activities in the year ended December 31, 2018, as compared with approximately $10.6 million used in investing activities in the year ended December 31, 2019. The majority of the investing activities in 2018 related to our acquisition of CareSpeak communications in October 2018. The majority of investing in activities in 2019 related to our acquisitions of RMDY Health, Inc. in 2019, as well as a software purchase in 2019.
Financing activities provided $8.7 million in the year ended December 31, 2018, as compared with $22.2 million in the year ended December 31, 2019. The cash provided in 2018 was primarily the result of the equity raised in connection with our uplisting to Nasdaq, as well as from the proceeds of option exercises. The cash used in 2019 was the result of our underwritten offering in 2019, as well as from the proceeds of option exercises.
With our cash on hand, we have sufficient cash to operate our business for more than the next 12 months and we do not anticipate the need to raise additional equity for operating purposes.
Table:
 | 2019 | 2018
Net cash provided by (used in) operating activities | $(1,660,796) | $792,555
Net cash used in investing activities | (10,582,086) | (5,686,833)
Net cash provided by financing activities | 22,181,528 | 8,685,739
Net increase in cash and cash equivalents | $9,938,646 | $3,791,461


Question: What were the net increases in cash and cash equivalents in 2018 and 2019, respectively?
Answer: $3,791,461, $9,938,646
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The final fair values of the assets acquired and liabilities assumed from our acquisitions in 2018 are as follows:
Table:
 | Trek | Electrostatic Product Line | LumaSense | Total
Accounts and other receivable, net | $ 2,818 | $  77 | $  7,167 | $ 10,062
Inventories | 3,941 | 292 | 9,372 | 13,605
Property and equipment | 594 | 50 | 1,353 | 1,997
Goodwill | — | 1,220 | 36,258 | 37,478
Intangible assets | 788 | 1,400 | 43,240 | 45,428
Deferred income tax assets | 606 | — | 6,331 | 6,937
Other assets | 854 | — | 6,004 | 6,858
Total assets acquired | 9,601 | 3,039 | 109,725 | 122,365
Accounts payable | 747 | 39 | 5,734 | 6,520
Deferred income tax liabilities | — | — | 11,699 | 11,699
Other liabilities | 2,782 | — | 7,608 | 10,390
Total liabilities assumed | 3,529 | 39 | 25,041 | 28,609
Total fair value of net assets acquired | $ 6,072 | $  3,000 | $  84,684 | $ 93,756


Question: What is the sum of the 3 highest total assets types?
Answer: 96511
Calculation: 13,605+37,478+45,428
(3) Accounts Receivable, Net
Accounts receivable, net, is as follows (in thousands):
Bad debt expense for the years ended December 31, 2019, 2018 and 2017 was $0.7 million, $0.1 million and $0.6 million, respectively.
Table:
 | As of December 31, | 
 | 2019 | 2018
Accounts receivable | $69,767 | $41,818
Allowance for doubtful accounts | (1,125) | (711)
Net accounts receivable | $68,642 | $41,107


Question: What is the change in Accounts receivable from December 31, 2019 to December 31, 2018?
Answer: 27949
Calculation: 69,767-41,818
(11) Other Non-Current Assets
Other non-current assets consist of the following (in millions):
Table:
 | December 31, | 
 | 2019 | 2018
Property records database | $60.1 | $59.9
Contract assets | 37.8 | 17.0
Right-of-use assets | 26.4 | —
Deferred compensation plan related assets | 15.2 | 11.1
Unbilled receivables | 3.5 | 5.0
Prepaid expenses | 8.1 | 18.3
Unrealized gains on interest rate swaps | — | 6.2
Other | 7.7 | 4.3
Other non-current assets | $158.8 | $121.8


Question: Which years does the table provide information for other non-current assets of the company?
Answer: 2019, 2018
6. Financial Instruments
The composition of financial instruments is as follows:
The fair values of the Company’s financial instrument is the amount that would be received in an asset sale or paid to transfer a liability in an orderly transaction between unaffiliated market participants and is recorded using a hierarchical disclosure framework based upon the level of subjectivity of the inputs used in measuring assets and liabilities. The levels are described below:
Level 1: Quoted prices (unadjusted) in active markets that are accessible at the measurement date for assets or liabilities. Level 2: Observable prices that are based on inputs not quoted on active markets, but corroborated by market data. Level 3: Unobservable inputs are used when little or no market data is available.
The Company classifies its financial instrument within Level 2 of the fair value hierarchy on the basis of models utilizing market observable inputs. The interest rate swap has been valued on the basis of valuations provided by third-party pricing services, as derived from standard valuation or pricing models. Market-based observable inputs for the interest rate swap include one month LIBOR-based yield curves over the term of the swap. The Company reviews third-party pricing provider models, key inputs and assumptions and understands the pricing processes at its third-party providers in determining the overall reasonableness of the fair value of its Level 2 financial instruments. The Company also considers the risk of nonperformance by assessing the swap counterparty's credit risk in the estimate of fair value of the interest rate swap. As of December 31, 2019 and 2018, the Company has not made any adjustments to the valuations obtained from its third party pricing providers.
Table:
 | December 31, 2019 | December 31, 2018
(in thousands) |  | 
Assets |  | 
Interest rate swap | $— | $1,623
Liabilities |  | 
Interest rate swap | $37 | $—


Question: What was the change in the interest rate swap from 2018 to 2019?
Answer: -1623
Calculation: 0 - 1,623
3. EARNINGS PER SHARE:
Basic earnings per share available to common shareholders is calculated by dividing net income less preferred stock dividend requirements by the weighted average common shares outstanding for each period. Diluted earnings per share available to common shareholders is calculated by dividing income from operations less preferred stock dividend requirements (when anti-dilutive) by the sum of the weighted average common shares outstanding and the weighted average dilutive equity awards.
Table:
 | For Fiscal Years | 
 | 2019 Basic | 2018 Basic
Weighted average common shares outstanding | 597,961 | 660,925
Net income available to common shareholders | $3,202,943 | $3,614,610
Net earnings per share available to common shareholders | $5.36 | $5.47


Question: What is the average net earnings per share available to common basic shareholders in 2018 and 2019?
Answer: 5.42
Calculation: (5.47 + 5.36)/2
The average duration of the defined benefit obligation at the end of the reporting period is 6.8 years (2018: 6.3 years) which relates wholly to active participants.
The plan invests entirely in pooled superannuation trust products where prices are quoted daily. The asset allocation of the plan has been set taking into account the membership profile, the liquidity requirements of the plan, and risk appetite of the Group.
The percentage invested in each asset class is as follows:
Table:
 | 2019 | 2018
 | % | %
Equity instruments | 53.9 | 58.5
Debt instruments | 18.6 | 22.5
Real estate | 10.8 | 3.5
Cash and cash equivalents | 3.7 | 3.0
Other | 13.0 | 12.5
Total | 100.0 | 100.0


Question: What is the difference in equity instruments between 2018 and 2019?
Answer: 4.6
Calculation: 58.5% - 53.9%
Restricted Stock Units
The following table summarizes RSU activity in the fiscal years ended September 30, 2019, 2018, and 2017:
The cost of RSUs is determined using the fair value of the Company’s Common Stock on the award date, and the compensation expense is recognized ratably over the vesting period. The Company recognized $6.8 million, $5.9 million, and $4.0 million in stock-based compensation expense related to outstanding RSUs in the fiscal years ended September 30, 2019, 2018, and 2017, respectively. As of September 30, 2019, the Company had approximately $12.2 million of unrecognized compensation expense related to outstanding RSUs expected to be recognized over a weighted-average period of approximately 2.3 years.
Table:
 | Number of Shares | Fair Value Per Share
Outstanding at September 30, 2016 | 2,046,169 | $4.90
Granted | 1,249,224 | $6.61
Settled | (707,174) | $4.81
Canceled | (231,198) | $4.93
Outstanding at September 30, 2017 | 2,357,021 | $5.65
Granted | 1,184,906 | $8.54
Settled | (745,197) | $5.26
Canceled | (216,554) | $7.39
Outstanding at September 30, 2018 | 2,580,176 | $6.92
Granted | 1,147,976 | $9.67
Settled | (881,420) | $6.53
Canceled | (494,245) | $7.70
Outstanding at September 30, 2019 | 2,352,487 | 8.26


Question: What is the price of RSUs outstanding on September 30, 2019?
Answer: 19431542.62
Calculation: 2,352,487*8.26
Amounts in the financial statements Group income statement
The expense or income arising from all group retirement benefit arrangements recognised in the group income statement is shown below.
a Relates to the removal of future indexation obligations following changes to the benefits provided under certain pension plans operating outside the UK in 2017/18. b All employees impacted by the closure of the BTPS receive transition payments into their BTRSS pot for a period linked to the employee’s age. There was no past service cost or credit on closure due to the assumed past service benefit link as an active member being the same as that assumed for a deferred member.
c In October, a High Court judgment involving the Lloyds Banking Group’s defined benefit pension schemes was handed down, resulting in the group needing to recognise additional liability to equalise benefits between men and women due to GMPs, in common with most UK defined benefit schemes.
Table:
 | 2019 | 2018 | 2017
Year ended 31 March | £m | £m | £m
Recognised in the income statement before specific items |  |  | 
Service cost (including administration expenses & PPF levy: |  |  | 
defined benefit plans | 135 | 376 | 281
defined contribution plans | 476 | 265 | 240
Past service credit a | – | (17) | –
Subtotal | 611 | 624 | 521
Recognised in the income statement as specific items (note 10) |  |  | 
Costs to close BT Pension Scheme and provide transition paymentsb for affected employees | 23 | – | –
Cost to equalise benefits between men and women due to guaranteed minimum pension (GMP) c | 26 | – | –
Net interest expense on pensions deficit included in specific items | 139 | 218 | 209
Subtotal | 188 | 218 | 209
Total recognised in the income statement | 799 | 842 | 730


Question: What is the change in defined contribution plans from 2019 to 2018?
Answer: 211
Calculation: 476-265
4. Inventories
Inventories consisted of the following (in thousands):
We grow and maintain flocks of layers (mature female chickens), pullets (female chickens, under 18 weeks of age), and breeders (male and female chickens used to produce fertile eggs to hatch for egg production flocks). Our total flock at June 1, 2019, consisted of approximately 9.4 million pullets and breeders and 36.2 million layers.
Table:
 | June 1, 2019 | June 2, 2018
Flocks, net of accumulated amortization | $105,536 | $96,594
Eggs | 14,318 | 17,313
Feed and supplies | 52,383 | 54,737
 | $172,237 | $168,644


Question: What is the increase / (decrease) in total inventory in 2019 compared to 2018?
Answer: 3593
Calculation: 172,237 - 168,644
Item 5. Market for Registrant’s Common Equity, Related Stockholder Matters and Issuer Purchases of Equity Securities
Our common stock trades on The Nasdaq Stock Market under the symbol ZIXI. The table below shows the high and low sales prices by quarter for fiscal 2019 and 2018.
At March 4, 2020, there were 55,641,885 shares of common stock outstanding held by 399 shareholders of record. On that date, the last reported sales price of the common stock was $8.27.
We have not paid any cash dividends on our common stock and do not anticipate doing so in the foreseeable future.
For information regarding options and stock-based compensation awards outstanding and available for future grants, see “Item 12. Security Ownership of Certain Beneficial Owners and Management and Related Stockholder Matters.”
Table:
 | 2019 |  | 2018 | 
Quarter Ended | High | Low | High | Low
March 31 | $ 9.07 | $ 5.34 | $ 4.75 | $ 3.82
June 30 | $ 11.15 | $ 6.66 | $ 5.62 | $ 4.25
September 30 | $ 10.51 | $ 6.91 | $ 5.93 | $ 4.91
December 31 | $ 7.75 | $ 6.25 | $ 7.09 | $ 4.66


Question: What was the change in high value for the quarter ended september 30 in 2019 than 2018?
Answer: 4.58
Calculation: 10.51-5.93
H. Net Income Per Share
Basic net income per share is computed by dividing net income by the weighted-average number of common stock outstanding during the period. Diluted net income per share is computed by dividing net income by the weighted-average number of common stock outstanding and potentially dilutive securities outstanding during the period, as calculated using the treasury stock method. Potentially dilutive securities primarily include unvested restricted stock units (“RSUs”), including PSU awards, and stock options, including purchase options under VMware’s employee stock purchase plan, which included Pivotal’s employee stock purchase plan through the date of acquisition. Securities are excluded from the computation of diluted net income per share if their effect would be anti-dilutive. VMware uses the two-class method to calculate net income per share as both classes share the same rights in dividends; therefore, basic and diluted earnings per share are the same for both classes.
The following table sets forth the computations of basic and diluted net income per share during the periods presented (table in millions, except per share amounts and shares in thousands):
Table:
 |  | For the Year Ended | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Net income attributable to VMware, Inc. | $6,412 | $1,650 | $437
Weighted-average shares, basic for Classes A and B | 417,058 | 413,769 | 410,315
Effect of other dilutive securities | 8,177 | 7,362 | 10,572
Weighted-average shares, diluted for Classes A and B | 425,235 | 421,131 | 420,887
Net income per weighted-average share attributable to VMware, Inc. common stockholders, basic for Classes A and B | $15.37 | $3.99 | $1.07
Net income per weighted-average share attributable to VMware, Inc. common stockholders, diluted for Classes A and B | $15.08 | $3.92 | $1.04


Question: What was the change in the Effect of other dilutive securities between 2018 and 2019?
Answer: -3210
Calculation: 7,362-10,572
Basic and Diluted Net Income Per Share
Basic net income per share is computed using net income divided by the weighted average number of shares of common stock
outstanding (“Weighted Shares”) for the period presented.
Diluted net income per share is computed using net income divided by Weighted Shares and the treasury stock method effect of common equivalent shares (“CESs”) outstanding for each period presented. In the following table, we present a reconciliation of earnings per share and the shares used in the computation of earnings per share for the years ended December 31, 2019, 2018 and 2017 (in thousands, except per share data):
common equivalent shares (“CESs”) outstanding for each period presented. In the following table, we present a reconciliation of
earnings per share and the shares used in the computation of earnings per share for the years ended December 31, 2019, 2018 and
2017 (in thousands, except per share data):
The number of anti-dilutive CESs in 2019, 2018 and 2017 was immaterial. See Note 2 for further information on those securities.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (in thousands, except per share data)    | 
Net income    | $ 85,762 | $ 104,690 | $ 116,481
Earnings per share： |  |  | 
Basic    | $ 1.33 | $ 1.58 | $ 1.68
Effect of CESs      | (0.01 )    | - | -
Diluted    | $ 1.32 | $ 1.58 | $ 1.68
Weighted average number of shares: |  |  | 
Basic      | 64,397 | 66,201 | 69,175
Effect of CESs      | 706 | 233 | 249
Diluted      | 65,103 | 66,434 | 69,424


Question: What is change for basic earning per share between 2019 and 2018?
Answer: 0.25
Calculation: 1.58-1.33
Future minimum operating lease payments were as follows:
Operating lease commitments were mainly in respect of land and buildings which arose from a sale and operating leaseback transaction in 2001. Leases have an average term of 13 years (2017/18: 14 years) and rentals are fixed for an average of 13 years (2017/18: 14 years).
Other than as disclosed below, there were no contingent liabilities or guarantees at 31 March 2018 other than those arising in the ordinary course of the group’s business and on these no material losses are anticipated. We have insurance cover to certain limits for major risks on property and major claims in connection with legal liabilities arising in the course of our operations. Otherwise, the group generally carries its own risks.
Table:
Payable in the year ending 31 March: | 2019 £m | 2018 £m
2019 | - | 600
2020 | 755 | 550
2021 | 641 | 513
2022 | 599 | 486
2023 | 555 | 463
2024 | 512 | 449
Thereafter | 3,557 | 3,536
Total future minimum operating lease payments | 6,619 | 6,597


Question: Which year from 2019 to 2024 had the largest payable amount for 2018?
Answer: 2020
Calculation: Find the largest number for 2019 to 2024 for 2018 payment