hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Liquidity and Capital Resources
We believe our ability to generate cash flows from operating activities is one of our fundamental financial strengths. In the near term, we expect our business and financial condition to remain strong and to continue to generate significant operating cash flows, which, we believe, in combination with our existing balance of cash and cash equivalents and short-term investments of $5.9 billion, our access to capital, and the availability of our $1.5 billion revolving credit facility, will be sufficient to finance our operational and financing requirements for the next 12 months. Our primary sources of liquidity, which are available to us to fund cash outflows such as potential dividend payments or share repurchases, and scheduled debt maturities, include our cash and cash equivalents, short-term investments, and cash flows provided by operating activities.
As of December 31, 2019, the amount of cash and cash equivalents held outside of the U.S. by our foreign subsidiaries was $2.8 billion, as compared to $1.4 billion as of December 31, 2018. These cash balances are generally available for use in the U.S., subject in some cases to certain restrictions.
Our cash provided from operating activities is somewhat impacted by seasonality. Working capital needs are impacted by weekly sales, which are generally highest in the fourth quarter due to seasonal and holiday-related sales patterns. We consider, on a continuing basis, various transactions to increase shareholder value and enhance our business results, including acquisitions, divestitures, joint ventures, share repurchases, and other structural changes. These transactions may result in future cash proceeds or payments.
Sources of Liquidity (amounts in millions)
Table:
 | For the Years Ended | December 31, | 
 | 2019 | 2018 | Increase (Decrease)
Net cash provided by operating activities | $1,831 | $1,790 | $41
Net cash used in investing activities | (22) | (230) | 208
Net cash used in financing activities | (237) | (2,020) | 1,783
Effect of foreign exchange rate changes | (3) | (31) | 28
Net increase (decrease) in cash and cash equivalents and restricted cash | $1,569 | $(491) | $2,060


Question: What was the percentage change in Net cash provided by operating activities between 2018 and 2019?
Answer: 2.29
Calculation: ($1,831-$1,790)/$1,790
RSU Activity We grant RSUs, which represent the right to receive shares of our common stock. Vesting for RSUs is contingent upon the holders’ continued employment with us and may be subject to other conditions (which may include the satisfaction of a performance measure). Also, certain of our performance-based RSUs include a range of shares that may be released at vesting which are above or below the targeted number of RSUs based on actual performance relative to the grant date performance measure. If the vesting conditions are not met, unvested RSUs will be forfeited. Upon vesting of the RSUs, we may withhold shares otherwise deliverable to satisfy tax withholding requirements.
The following table summarizes our RSU activity with performance-based RSUs presented at the maximum potential shares that could be earned and issued at vesting (amounts in thousands except per share amounts):
Certain of our performance-based RSUs did not have an accounting grant date as of December 31, 2019, as there is not a mutual understanding between the Company and the employee of the performance terms. Generally, these performance terms relate to operating income performance for future years where the performance goals have not yet been set. As of December 31, 2019, there were 3.2 million performance-based RSUs outstanding for which the accounting grant date has not been set, of which 1.9 million were 2019 grants. Accordingly, no grant date fair value was established and the weighted average grant date fair value calculated above for 2019 grants excludes these RSUs.
At December 31, 2019, approximately $96 million of total unrecognized compensation cost was related to RSUs and is expected to be recognized over a weighted-average period of 1.64 years. Of the total unrecognized compensation cost, $50 million was related to performance-based RSUs, which is expected to be recognized over a weighted-average period of 1.63 years. The total grant date fair value of vested RSUs was $147 million, $120 million and $64 million for the years ended December 31, 2019, 2018, and 2017, respectively.
The income tax benefit from stock option exercises and RSU vestings was $47 million, $94 million, and $160 million for the years ended December 31, 2019, 2018, and 2017, respectively.
Table:
 | Number of shares | Weighted-Average Grant Date Fair Value
Unvested RSUs at December 31, 2018 | 10,623 | $40.39
Granted | 4,426 | 45.55
Vested | (2,758) | 47.86
Forfeited | (2,963) | 54.61
Unvested RSUs at December 31, 2019 | 9,328 | $32.60


Question: What was the total grant date fair value of vested RSUs in 2018?
Answer: $120 million
Acquisition-Related Expenses
We have incurred acquisition-related expenses related to our acquisition of Level 3. The table below summarizes our acquisition-related expenses, which consist of integration and transformation-related expenses, including severance and retention compensation expenses, and transaction-related expenses:
At December 31, 2019, we had incurred cumulative acquisition-related expenses of $950 million for Level 3. The total amounts of these expenses are included in our selling, general and administrative expenses.
Level 3 incurred transaction-related expenses of $47 million on the date of acquisition. This amount is not included in our results of operations.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (Dollars in millions) | 
Transaction-related expenses | $— | 2 | 174
Integration and transformation-related expenses | 234 | 391 | 97
Total acquisition-related expenses | $234 | 393 | 271


Question: What was the amount of transaction-related expenses incurred for Level 3 on the date of acquisition?
Answer: $47 million
performance graph this graph compares the return on lilly stock with that of the standard & poor 2019s 500 stock index and our peer group for the years 2014 through 2018 . the graph assumes that , on december 31 , 2013 , a person invested $ 100 each in lilly stock , the s&p 500 stock index , and the peer groups' common stock . the graph measures total shareholder return , which takes into account both stock price and dividends . it assumes that dividends paid by a company are reinvested in that company 2019s stock . value of $ 100 invested on last business day of 2013 comparison of five-year cumulative total return among lilly , s&p 500 stock index , peer group ( 1 ) .

Table:
 | lilly | peer group | s&p 500
dec-13 | $ 100.00 | $ 100.00 | $ 100.00
dec-14 | $ 139.75 | $ 114.39 | $ 113.69
dec-15 | $ 175.21 | $ 116.56 | $ 115.26
dec-16 | $ 157.03 | $ 112.80 | $ 129.05
dec-17 | $ 185.04 | $ 128.90 | $ 157.22
dec-18 | $ 259.88 | $ 136.56 | $ 150.33
( 1 ) we constructed the peer group as the industry index for this graph .
it comprises the companies in the pharmaceutical and biotech industries that we used to benchmark the compensation of our executive officers for 2018 : abbvie inc. ; amgen inc. ; astrazeneca plc ; baxter international inc. ; biogen idec inc. ; bristol-myers squibb company ; celgene corporation ; gilead sciences inc. ; glaxosmithkline plc ; johnson & johnson ; medtronic plc ; merck & co. , inc. ; novartis ag. ; pfizer inc. ; roche holdings ag ; sanofi ; and shire plc. .

Question: as of december 312017 what was the ratio of the value of the lilly to the peer group
Answer: 1.44
Calculation: divide(185.04, 128.90)
Stock-Based Compensation
A summary of our stock-based compensation expense is as follows (in thousands):
(1) Amount for the year ended December 31, 2018 includes $4.1 million of accelerated stock-based compensation expense. In March 2018, as
a result of a suspension of the 2014 Purchase Plan due to our non-timely filing status, all unrecognized stock-based compensation expense
related to ESPP under the 2014 Purchase Plan was accelerated and recognized within the consolidated statement of operations.
As of December 31, 2019, we had $29.5 million of unrecognized stock-based compensation expense related to
unvested stock-based awards, including ESPP under our Amended 2014 Purchase Plan, which will be recognized
over a weighted-average period of 2.6 years.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Stock-based compensation by type of award: |  |  | 
Stock options | $648 | $1,353 | $2,705
Stock awards | 14,882 | 10,445 | 11,421
Employee stock purchase rights(1) | 999 | 5,240 | 3,077
Total | $16,529 | $17,038 | $17,203
Stock-based compensation by category of expense: |  |  | 
Cost of revenue | $1,500 | $1,602 | $1,362
Sales and marketing | 5,765 | 5,667 | 6,075
Research and development | 6,039 | 6,631 | 6,343
General and administrative | 3,225 | 3,138 | 3,423
Total | $16,529 | $17,038 | $17,203


Question: What is the amount of employee stock purchase rights including accelerated stock-based compensation expense at the end of 2017?
Answer: 3,077
5. Software Development and Intellectual Property Licenses
The following table summarizes the components of our capitalized software development costs (amounts in millions):
As of both December 31, 2019 and December 31, 2018, capitalized intellectual property licenses were not material.
Table:
 | At December 31, | 
 | 2019 | 2018
Internally-developed software costs | $345 | $291
Payments made to third-party software developers | 31 | 38
Total software development costs | $376 | $329


Question: What was the total software development costs in 2018?
Answer: 329
Operating Expenses
Research and Development Expenses
Research and development expenses increased $47 million, or 30%, in 2019 compared to 2018. The overall increase was primarily due to increased employee compensation-related costs of $34 million, driven by headcount growth, and increased allocated shared costs of $8 million.
Research and development expenses increased $45 million, or 39%, in 2018 compared to 2017. The overall increase was primarily due to increased employee compensation-related costs of $36 million, driven by headcount growth, and increased allocated shared costs of $6 million.
Table:
 |  | Year Ended December 31, |  |  | 
 | 2019 | 2018 | 2017 | 2018 to 2019 % change | 2017 to 2018 % change
 |  |  | (In thousands, except percentages) |  | 
Research and Development | $ 207,548 | $ 160,260 | $ 115,291 | 30% | 39%


Question: What are the primary components in the increase of Research and Development from 2017 to 2018? 
Answer: The overall increase was primarily due to increased employee compensation-related costs of $36 million, driven by headcount growth, and increased allocated shared costs of $6 million.
notes to consolidated financial statements ( continued ) note 8 2014commitments and contingencies ( continued ) provide renewal options for terms of 3 to 7 additional years . leases for retail space are for terms of 5 to 20 years , the majority of which are for 10 years , and often contain multi-year renewal options . as of september 29 , 2007 , the company 2019s total future minimum lease payments under noncancelable operating leases were $ 1.4 billion , of which $ 1.1 billion related to leases for retail space . rent expense under all operating leases , including both cancelable and noncancelable leases , was $ 151 million , $ 138 million , and $ 140 million in 2007 , 2006 , and 2005 , respectively . future minimum lease payments under noncancelable operating leases having remaining terms in excess of one year as of september 29 , 2007 , are as follows ( in millions ) : fiscal years .

Table:
2008 | $ 155
2009 | 172
2010 | 173
2011 | 160
2012 | 148
thereafter | 617
total minimum lease payments | $ 1425
accrued warranty and indemnifications the company offers a basic limited parts and labor warranty on its hardware products .
the basic warranty period for hardware products is typically one year from the date of purchase by the end-user .
the company also offers a 90-day basic warranty for its service parts used to repair the company 2019s hardware products .
the company provides currently for the estimated cost that may be incurred under its basic limited product warranties at the time related revenue is recognized .
factors considered in determining appropriate accruals for product warranty obligations include the size of the installed base of products subject to warranty protection , historical and projected warranty claim rates , historical and projected cost-per-claim , and knowledge of specific product failures that are outside of the company 2019s typical experience .
the company assesses the adequacy of its preexisting warranty liabilities and adjusts the amounts as necessary based on actual experience and changes in future estimates .
for products accounted for under subscription accounting pursuant to sop no .
97-2 , the company recognizes warranty expense as incurred .
the company periodically provides updates to its applications and system software to maintain the software 2019s compliance with specifications .
the estimated cost to develop such updates is accounted for as warranty costs that are recognized at the time related software revenue is recognized .
factors considered in determining appropriate accruals related to such updates include the number of units delivered , the number of updates expected to occur , and the historical cost and estimated future cost of the resources necessary to develop these updates. .

Question: what percentage of future minimum lease payments under noncancelable operating leases having remaining terms in excess of one year are due in 2010?
Answer: 13%
Calculation: divide(173, 1425)
Disaggregation of Revenue
We generate revenue from the sale of services and sale of software for end-user software products provided through direct customer downloads and through the sale of these end-user software products via partners. The following table depicts the disaggregation of revenue (in thousands) according to revenue type and is consistent with how we evaluate our financial performance:
Revenue from Contracts with Customers:
Table:
 | Twelve months ended December 31, | 
 | 2019 | 2018
Services  | $59,545 | $64,476
Software and other   | 3,788 | 5,073
             Total revenue  | $63,333 | $69,549


Question: In which years was the revenue from contracts with customers recorded for?
Answer: 2019, 2018
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 amount of discount for Customer Advances?
Answer: 2.1
entergy corporation and subsidiaries management 2019s financial discussion and analysis the volume/weather variance is primarily due to an increase of 1402 gwh , or 1% ( 1 % ) , in billed electricity usage , including an increase in industrial usage and the effect of more favorable weather . the increase in industrial sales was primarily due to expansion in the chemicals industry and the addition of new customers , partially offset by decreased demand primarily due to extended maintenance outages for existing chemicals customers . the waterford 3 replacement steam generator provision is due to a regulatory charge of approximately $ 32 million recorded in 2015 related to the uncertainty associated with the resolution of the waterford 3 replacement steam generator project . see note 2 to the financial statements for a discussion of the waterford 3 replacement steam generator prudence review proceeding . the miso deferral variance is primarily due to the deferral in 2014 of non-fuel miso-related charges , as approved by the lpsc and the mpsc . the deferral of non-fuel miso-related charges is partially offset in other operation and maintenance expenses . see note 2 to the financial statements for further discussion of the recovery of non-fuel miso-related charges . the louisiana business combination customer credits variance is due to a regulatory liability of $ 107 million recorded by entergy in october 2015 as a result of the entergy gulf states louisiana and entergy louisiana business combination . consistent with the terms of the stipulated settlement in the business combination proceeding , electric customers of entergy louisiana will realize customer credits associated with the business combination ; accordingly , in october 2015 , entergy recorded a regulatory liability of $ 107 million ( $ 66 million net-of-tax ) . see note 2 to the financial statements for further discussion of the business combination and customer credits . entergy wholesale commodities following is an analysis of the change in net revenue comparing 2015 to 2014 . amount ( in millions ) .

Table:
 | amount ( in millions )
2014 net revenue | $ 2224
nuclear realized price changes | -310 ( 310 )
vermont yankee shutdown in december 2014 | -305 ( 305 )
nuclear volume excluding vermont yankee effect | 20
other | 37
2015 net revenue | $ 1666
as shown in the table above , net revenue for entergy wholesale commodities decreased by approximately $ 558 million in 2016 primarily due to : 2022 lower realized wholesale energy prices , primarily due to significantly higher northeast market power prices in 2014 , and lower capacity prices in 2015 ; and 2022 a decrease in net revenue as a result of vermont yankee ceasing power production in december 2014 .
the decrease was partially offset by higher volume in the entergy wholesale commodities nuclear fleet , excluding vermont yankee , resulting from fewer refueling outage days in 2015 as compared to 2014 , partially offset by more unplanned outage days in 2015 as compared to 2014. .

Question: what is the net change in net revenue during 2015?
Answer: -558
Calculation: subtract(1666, 2224)
The following table sets forth the components of identifiable intangible assets acquired and their estimated useful lives as of the date of acquisition.
The amount recorded for developed technology represents the estimated fair value of Trello’s project management and organization technology. The amount recorded for customer relationships represents the fair values of the underlying relationship with Trello customers.
Table:
 | Fair Value | Useful Life
 | (U.S. $ in thousands) | (years)
Developed technology | $50,600 | 3
Customer relationships | 56,900 | 2
Trade names | 19,900 | 3
Total intangible assets subject to amortization | $127,400 | 


Question: What are the intangible assets that have a fair value of above $20,000 thousands?
Answer: Developed technology, Customer relationships
Calculation: For COL 3 rows 3-5 if value is >20,000 input the corresponding intangible asset component in COL2 as answer
Net Income (Loss) Per Share: Basic net income (loss) per share (EPS) is computed by dividing the net income (loss) attributable to Cubic for the period by the weighted average number of common shares outstanding during the period, including vested RSUs.
In periods with a net income from continuing operations attributable to Cubic, diluted EPS is computed by dividing the net income for the period by the weighted average number of common and common equivalent shares outstanding during the period. Common equivalent shares consist of dilutive RSUs. Dilutive RSUs are calculated based on the average share price for each fiscal period using the treasury stock method. For RSUs with performance-based vesting, no common equivalent shares are included in the computation of diluted EPS until the related performance criteria have been met. For RSUs with performance and market-based vesting, no common equivalent shares are included in the computation of diluted EPS until the performance criteria have been met, and once the criteria are met the dilutive restricted stock units are calculated using the treasury stock method, modified by the multiplier that is calculated at the end of the accounting period as if the vesting date was at the end of the accounting period. The multiplier on RSUs with performance and market-based vesting is further described in Note 16.
In periods with a net loss from continuing operations attributable to Cubic, common equivalent shares are not included in the computation of diluted EPS, because to do so would be anti-dilutive.
The weighted-average number of shares outstanding used to compute net income (loss) per common share were as follows (in thousands):
Table:
 |  | Years Ended September 30, | 
 | 2019 | 2018 | 2017
Weighted average shares - basic | 30,495 | 27,229 | 27,106
Effect of dilutive securities | 111 | 122 | —
Weighted average shares - diluted | 30,606 | 27,351 | 27,106
Number of anti-dilutive securities | — | — | 967


Question: How is basic net income (loss) per share (EPS) computed?
Answer: by dividing the net income (loss) attributable to Cubic for the period by the weighted average number of common shares outstanding during the period, including vested RSUs
* Recast to reflect segment changes.
** 2019 results were impacted by Red Hat purchase accounting and acquisition-related activity.
The Cloud & Cognitive Software gross profit margin decreased 0.9 points to 76.7 percent in 2019 compared to the prior year. The gross profit margin decline was driven by the purchase price accounting impacts from the Red Hat acquisition.
Pre-tax income of $7,952 million decreased 10.5 percent compared to the prior year with a pre-tax margin decline of 4.4 points to 30.6 percent which reflects the acquisition of Red Hat, ongoing investments in key strategic areas and lower income from IP partnership agreements.
Table:
($ in millions) |  |  | 
For thee year ended December 31: | 2019 | 2018* | Yr.-to-Yr. Percent/ Margin Change**
Cloud & Cognitive Software |  |  | 
External gross profit | $17,790 | $17,224 | 3.3%
External gross profit margin | 76.7% | 77.6% | (0.9)pts.
Pre-tax income | $ 7,952 | $ 8,882 | (10.5)%
Pre-tax margin | 30.6% | 35.0% | (4.4)pts.


Question: What caused the gross profit margin decline in 2019?
Answer: The gross profit margin decline was driven by the purchase price accounting impacts from the Red Hat acquisition.