hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
PSUs, RSUs and restricted stock
Under the 2015 Plan, awards other than stock options, including PSUs, RSUs and restricted stock, may be granted to certain employees and officers.
Under our market-based PSU program, the number of shares of common stock earned by a recipient is subject to a market condition based on ADTRAN’s relative total shareholder return against all companies in the NASDAQ Telecommunications Index at the end of a three-year performance period. Depending on the relative total shareholder return over the performance period, the recipient may earn from 0% to 150% of the shares underlying the PSUs, with the shares earned distributed upon the vesting. The fair value of the award is based on the market price of our common stock on the date of grant, adjusted for the expected outcome of the impact of market conditions using a Monte Carlo Simulation valuation method. A portion of the granted PSUs vests and the underlying shares become deliverable upon the death or disability of the recipient or upon a change of control of ADTRAN, as defined by the 2015 Plan. The recipients of the PSUs receive dividend credits based on the shares of common stock underlying the PSUs. The dividend credits vest and are earned in the same manner as the PSUs and are paid in cash upon the issuance of common stock for the PSUs.
During the first quarter of 2017, the Compensation Committee of the Board of Directors approved a one-time PSU grant of 0.5 million shares that contained performance conditions and would have vested at the end of a three-year period if such performance conditions were met. The fair value of these performance-based PSU awards was equal to the closing price of our stock on the date of grant. These awards were forfeited during the first quarter of 2020 as the performance conditions were not achieved.
The fair value of RSUs and restricted stock is equal to the closing price of our stock on the business day immediately preceding the grant date. RSUs and restricted stock vest ratably over four-year and one-year periods, respectively.
We will continue to assess the assumptions and methodologies used to calculate the estimated fair value of stock-based compensation. If circumstances change, and additional data becomes available over time, we may change our assumptions and methodologies, which may materially impact our fair value determination.
The following table is a summary of our PSUs, RSUs and restricted stock outstanding as of December 31, 2018 and 2019 and the changes that occurred during 2019:
Table:
(In thousands, except per share amounts) | Number of Shares | Weighted Average Grant Date Fair Value
Unvested PSUs, RSUs and restricted stock outstanding, December 31, 2018 | 1,570 | $18.52
PSUs, RSUs and restricted stock granted | 897 | $9.63
PSUs, RSUs and restricted stock vested | (368) | $17.23
PSUs, RSUs and restricted stock forfeited | (208) | $18.24
Unvested RSUs and restricted stock outstanding, December 31, 2019 | 1,891 | $14.58


Question: What was the Weighted Average Grant Date Fair Value of unvested stocks in 2018 as a ratio of the fair value in 2019?
Answer: 1.27
Calculation: $18.52/$14.58
Note 11: Share-Based Compensation
Total share-based compensation expense related to the Company's stock options, RSUs, stock grant awards and ESPP were recorded within the Consolidated Statements of Operations and Comprehensive Income as follows (in millions):
(1) Recognition of related income tax benefits are the result of the adoption of ASU 2016-09 during the first quarter of 2017 through a cumulative effect adjustment of $68.1 million recorded as a credit to retained earnings as of January 1, 2017. Tax benefit is calculated using the federal statutory rate of 21% during the years ended December 31, 2019 and December 31, 2018, and 35% for the year ended December 31, 2017.
At December 31, 2019, total unrecognized share-based compensation expense, net of estimated forfeitures, related to non-vested RSUs with service, performance and market conditions was $74.9 million, which is expected to be recognized over a weighted-average period of 1.3 years. The total intrinsic value of stock options exercised during the year ended December 31, 2019 was $3.9 million.
The Company received cash of $1.7 million and $26.2 million from the exercise of stock options and the issuance of shares under the ESPP, respectively. Upon option exercise, vesting of RSUs, stock grant awards, or completion of a purchase under the ESPP, the Company issues new shares of common stock.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Cost of revenue | $10.6 | $7.0 | $6.0
Research and development | 17.0 | 14.3 | 12.5
Selling and marketing | 14.8 | 14.1 | 11.7
General and administrative | 37.0 | 42.9 | 39.6
Share-based compensation expense | 79.4 | 78.3 | 69.8
Related income tax benefits at federal rate (1) | (16.7) | (16.4) | (24.4)
Share-based compensation expense, net of taxes | $62.7 | $61.9 | $45.4


Question: How much was the total intrinsic value of stock options exercised during the year ended December 31, 2019?
Answer: $3.9 million
Free Cash Flow
We monitor our free cash flow, as a key measure of our overall business performance, which enables us to analyze our financial performance without the effects of certain non-cash items such as depreciation, amortization, and stock-based compensation expenses. Additionally, free cash flow takes into account the impact of changes in deferred revenue, which reflects the receipt of cash payment for products before they are recognized as revenue, and unbilled accounts receivable, which reflects revenue that has been recognized that has yet to be invoiced to our customers.
Our net cash provided by (used in) operating activities is significantly impacted by the timing of invoicing and collections of accounts receivable, the timing and amount of annual bonus payments, as well as payroll and tax payments. Our capital expenditures consisted of purchases of property and equipment, most of which were computer hardware, software, capitalized software development costs, and leasehold improvements.
In fiscal year 2019, free cash flow was impacted by $23.6 million related to the build out and furnishing of our new corporate headquarters in San Mateo, California. For a further discussion of our operating cash flows, see “Liquidity and Capital Resources - Cash Flows.”(in thousands)
Table:
 | Fiscal years ended July 31, | 
 | 2019 | 2018
Net cash provided by operating activities | $116,126 | $140,459
Net cash used for capital expenditures | (48,857) | (12,011)
Free cash flow | $67,269 | $128,448


Question: What was the average Net cash used for capital expenditures for 2018 and 2019?
Answer: -30434
Calculation: -(48,857 + 12,011) / 2
Services Business
We offer services to customers and partners to help to maximize the performance of their investments in Oracle applications and infrastructure technologies. Services revenues are generally recognized as the services are performed. The cost of providing our services consists primarily of personnel related expenses, technology infrastructure expenditures, facilities expenses and external contractor expenses.
(1) Excludes stock-based compensation and certain expense allocations. Also excludes amortization of intangible assets and certain other GAAP-based expenses, which were not allocated to our operating segment results for purposes of reporting to and review by our CODMs, as further described under “Presentation of Operating Segments and Other Financial Information” above.
Excluding the effects of currency rate fluctuations, our total services revenues decreased in fiscal 2019 relative to fiscal 2018 primarily due to revenue declines in our education services and, to a lesser extent, our consulting services. During fiscal 2019, constant currency increases in our EMEA-based services revenues were offset by constant currency services revenue decreases in the Americas and the Asia Pacific regions.
In constant currency, total services expenses increased in fiscal 2019 compared to fiscal 2018 primarily due to an increase in employee related expenses and external contractor expenses associated with investments in our consulting services that support our cloud offerings. In constant currency, total margin and total margin as a percentage of total services revenues decreased during fiscal 2019 relative to fiscal 2018 due to decreased revenues and increased expenses for this business.
Table:
 |  |  | Percent Change | 
(Dollars in millions) | 2019 | Actual | Constant | 2018
Services Revenues: |  |  |  | 
Americas | $1,576 | -5% | -3% | $1,654
EMEA | 1,021 | -2% | 2% | 1,046
Asia Pacific | 643 | -7% | -4% | 695
Total revenues | 3,240 | -5% | -2% | 3,395
Total Expenses (1) | 2,703 | -1% | 2% | 2,729
Total Margin | $537 | -19% | -18% | $666
Total Margin % | 17% |  |  | 20%
% Revenues by Geography: |  |  |  | 
Americas | 49% |  |  | 49%
EMEA | 31% |  |  | 31%
Asia Pacific | 20% |  |  | 20%


Question: How much less was the total margin in 2019 then in 2018?
Answer: 129
Calculation: 666-537
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The following table summarizes long-lived assets by geographic area as of December 31, 2019 and December 31, 2018:
Long-lived assets include property and equipment, operating lease right-of-use assets, goodwill and other intangible assets.
Table:
 | December 31, | 
 | 2019 | 2018
United States | $239,511 | $115,869
Asia | 301,020 | 12,274
Europe | 59,925 | 59,936
Total | $600,456 | $188,079


Question: What was the amount of long-lived assets in United States in 2019?
Answer: 239,511
The following table summarizes the change in the valuation allowance (in thousands):
As of December 31, 2019, net operating loss (NOL) carryforwards for U.S. federal tax purposes totaled $31.4 million. Effective with the 2017 Tax Act in December 2017, NOLs generated after December 31, 2017, do not expire. Federal NOLs of $9.9 million expire at various dates from 2020 through 2037 and federal NOLs of $21.5 million do not expire. NOL carryforwards for state tax purposes totaled $40.6 million at December 31, 2019 and expire at various dates from 2020 through 2039.
Table:
Year Ended December 31 |  | 
 | 2019 | 2018
Vaulation allowances, beginning of year | $5,398 | $13,872
Net operating loss | 3,284 | 1,920
Expiration of net operating losses and limitations | (7) | (9,939)
Adjustment to deferred taxes | 29 | (321)
Impact of state tax rate change | 26 | (146)
Other adjusments | 9 | 12
Valuation allowance, end of year | $8,739 | $5,398


Question: What is the change in net operating loss between 2018 and 2019?
Answer: 1364
Calculation: 3,284 - 1,920
Financial position and cash flow
Capital expenditure and cash flow
Net operating cash inflow was $4,709,000, which was $4,081,000 lower than last year. The reduction in operating revenue was offset by lower operational costs. However, net cash was impacted by the increase in trail to upfront revenue mix. In addition, as a result of the loss position reported for FY18, the Group received a net tax refund of $2,327,000 during the year, compared to the prior year net tax paid of $172,000.
Net investing cash outflows for the year was $12,337,000. The $7,755,000 decrease in spend in investing activities relates to the Group’s controlling interest acquisition of iMoney in December 2017.
Net financing cash outflows for the 2019 year totalled $3,471,000. This included $2,839,000 lease payments and $497,000 interest expense related to leases. The material decrease against the prior year comparative period relates to $32,918,000 paid in share buy-backs and dividends in the prior period.
Table:
CASH FLOW SUMMARY | 2019 $’000 | 2018 $’000 RESTATED | CHANGE
Net cash provided  from operating  activities | 4,709 | 8,790 | 46%
Net cash used in  investing activities | (12,337) | (20,092) | (39%)
Net cash used in financing activities | (3,471) | (36,014) | (90%)
Net change in cash and cash equivalent | (11,099) | (47,316) | (77%)


Question: What is the change in the net cash provided from operating activities from 2018 to 2019?
Answer: -4081
Calculation: 4,709-8,790
stock performance graph : the graph below shows the cumulative total shareholder return assuming the investment of $ 100 , on december 31 , 2013 , and the reinvestment of dividends thereafter , if any , in the company 2019s common stock versus the standard and poor 2019s s&p 500 retail index ( 201cs&p 500 retail index 201d ) and the standard and poor 2019s s&p 500 index ( 201cs&p 500 201d ) . .

Table:
company/index | december 31 , 2013 | december 31 , 2014 | december 31 , 2015 | december 31 , 2016 | december 31 , 2017 | december 31 , 2018
o 2019reilly automotive inc . | $ 100 | $ 150 | $ 197 | $ 216 | $ 187 | $ 268
s&p 500 retail index | 100 | 110 | 137 | 143 | 184 | 208
s&p 500 | $ 100 | $ 111 | $ 111 | $ 121 | $ 145 | $ 136
.

Question: what is the roi of an investment in s&p500 from 2013 to 2017?
Answer: 45%
Calculation: subtract(145, 100), divide(#0, 100)
Note 23 Other (Expense) Income, net
The following table provides details of other (expense) income, net:
(1) Cryovac Brasil Ltda., a Sealed Air subsidiary, received a final decision from the Brazilian court regarding a claim in which Sealed Air contended that certain indirect taxes paid were calculated on an incorrect amount. As a result, for the year ended December 31, 2019, we recorded income of $4.8 million to Other, net for a claim of overpaid taxes related to 2015 through 2018.
Table:
 |  | Year Ended December 31, | 
(In millions) | 2019 | 2018 | 2017
Net foreign exchange transaction loss | $ (7.7) | $ (16.7) | $ (5.9)
Bank fee expense | (5.0) | (4.4 ) | (5.8)
Pension income other than service costs | 1.0 | 3.9 | 16.7
Loss on debt redemption and refinancing activities | (16.1) | (1.9 ) | —
Other, net(1) | 8.3 | 1.0 | 1.2
Other (expense) income, net | $ (19.5) | $ (18.1) | $ 6.2


Question: What is the Net foreign exchange transaction loss expressed as a percentage of othe expense, net for 2019?
Answer: 39.49
Calculation: 7.7/19.5
Other Income/Expense
The following table details our other income/expenses for the years ended September 30, 2019 and 2018:
The decrease to other income (expenses) for the fiscal year ended September 30, 2019 as compared to the fiscal year ended September 30, 2018 was primarily driven by a decrease in Other income, net of $0.3 mil.
Table:
 | For the year ended |  | 
 | September 30, 2019 | September 30, 2018 | Increase (Decrease)
 | (Amounts in thousands) |  | 
Interest expense | $(99) | $(85) | $(14)
Interest income | 323 | 20 | 303
Foreign exchange gain (loss) | 157 | 263 | (106)
Other income, net | 3 | 297 | (294)
Total other income (expense), net | $384 | $495 | $(111)


Question: What is the company's total net income in 2019?
Answer: $384
14 . leases we lease certain locomotives , freight cars , and other property . the consolidated statement of financial position as of december 31 , 2009 and 2008 included $ 2754 million , net of $ 927 million of accumulated depreciation , and $ 2024 million , net of $ 869 million of accumulated depreciation , respectively , for properties held under capital leases . a charge to income resulting from the depreciation for assets held under capital leases is included within depreciation expense in our consolidated statements of income . future minimum lease payments for operating and capital leases with initial or remaining non-cancelable lease terms in excess of one year as of december 31 , 2009 were as follows : millions of dollars operating leases capital leases .

Table:
millions of dollars | operatingleases | capital leases
2010 | $ 576 | $ 290
2011 | 570 | 292
2012 | 488 | 247
2013 | 425 | 256
2014 | 352 | 267
later years | 2901 | 1623
total minimum lease payments | $ 5312 | $ 2975
amount representing interest | n/a | -914 ( 914 )
present value of minimum lease payments | n/a | $ 2061
the majority of capital lease payments relate to locomotives .
rent expense for operating leases with terms exceeding one month was $ 686 million in 2009 , $ 747 million in 2008 , and $ 810 million in 2007 .
when cash rental payments are not made on a straight-line basis , we recognize variable rental expense on a straight-line basis over the lease term .
contingent rentals and sub-rentals are not significant .
15 .
commitments and contingencies asserted and unasserted claims 2013 various claims and lawsuits are pending against us and certain of our subsidiaries .
we cannot fully determine the effect of all asserted and unasserted claims on our consolidated results of operations , financial condition , or liquidity ; however , to the extent possible , where asserted and unasserted claims are considered probable and where such claims can be reasonably estimated , we have recorded a liability .
we do not expect that any known lawsuits , claims , environmental costs , commitments , contingent liabilities , or guarantees will have a material adverse effect on our consolidated results of operations , financial condition , or liquidity after taking into account liabilities and insurance recoveries previously recorded for these matters .
personal injury 2013 the cost of personal injuries to employees and others related to our activities is charged to expense based on estimates of the ultimate cost and number of incidents each year .
we use third-party actuaries to assist us in measuring the expense and liability , including unasserted claims .
the federal employers 2019 liability act ( fela ) governs compensation for work-related accidents .
under fela , damages are assessed based on a finding of fault through litigation or out-of-court settlements .
we offer a comprehensive variety of services and rehabilitation programs for employees who are injured at .

Question: what portion of 2009 capital leases are current liabilities?
Answer: 17.9%
Calculation: divide(290, 1623)
Short-Term Debt
The weighted-average interest rate for commercial paper at December 31, 2019 and 2018 was 1.6 percent and 2.5 percent, respectively. The weighted-average interest rates for short-term loans were 6.1 percent and 4.3 percent at December 31, 2019 and 2018, respectively.
Table:
($ in millions) |  | 
At December 31: | 2019 | 2018
Commercial paper | $  304 | $ 2,995
Short-term loans | 971 | 161
Long-term debt—current maturities | 7,522 | 7,051
Total | $8,797 | $10,207


Question: What was the increase / (decrease) in the short term loan from 2018 to 2019?
Answer: 810
Calculation: 971 - 161
Opening Balance Sheet Adjustments
The following summarizes the effect of adopting the above new accounting standards:
(1) The balance as of March 30, 2018, includes income tax receivable and prepaid income taxes of $107 million and short-term deferred commissions of $94 million. The opening balance as of March 31, 2018, includes income tax receivable and prepaid income taxes of $99 million and short-term deferred commissions of $86 million.
(2) The balance as of March 30, 2018, includes long-term deferred commissions of $35 million, long-term income tax receivable and prepaid income taxes of $61 million and deferred income tax assets of $46 million. The opening balance as of March 31, 2018, includes long-term deferred commissions of $92 million, long-term income tax receivable and prepaid income taxes of $29 million, and deferred income tax assets of $828 million.
Table:
(in millions) | Balance as of March 30, 2018 | Revenue Recognition Guidance | Accounting for Income Taxes Guidance | Opening Balance as of March 31, 2018
Accounts receivable, net | $809 | $24 | $— | $833
Other current assets (1) | $522 | $(8) | $(8) | $506
Other long-term assets (2) | $526 | $57 | $750 | $1,333
Total assets | $15,759 | $73 | $742 | $16,574
Short-term contract liabilities | $2,368 | $(107) | $— | $2,261
Other current liabilities | $372 | $(2) | $— | $370
Long-term contract liabilities | $735 | $(62) | $— | $673
Deferred income tax liabilities | $592 | $47 | $— | $639
Total liabilities | $10,736 | $(124) | $— | $10,612
Retained earnings | $328 | $197 | $742 | $1,267


Question: What is the percentage increase in Total assets from Balance as of March 30, 2018 to Opening balance as of March 31, 2018?
Answer: 5.17
Calculation: (73+742)/15,759
16. SHARE-BASED PAYMENTS continued
c. Employee Share Option Plan
The Employee Share Option Plan (the Option Plan) was approved by shareholders at the Company’s AGM on 9 November 2001 and reaffirmed at the AGM on 24 November 2011.The Employee Share Option Plan (the Option Plan) was approved by shareholders at the Company’s AGM on 9 November 2001 and reaffirmed at the AGM on 24 November 2011. Under the Option Plan, awards are made to eligible executives and other management personnel who have an impact on the Group’s performance. Option Plan awards are delivered in the form of options over shares, which vest over a period of three years subject to meeting performance measures and continuous employment with the Company. Each option is to subscribe for one ordinary share when the option is exercised and, when issued, the shares will rank equally with other shares.
Unless the terms on which an option was offered specified otherwise, an option may be exercised at any time after the vesting date on satisfaction of the relevant performance criteria.
Options issued under the Employee Share Option Plan are valued on the same basis as those issued to KMP, which is described in Note 16(d).
There were no new options issued under the Option Plan during the 30 June 2019 and 30 June 2018 financial years, as the Option Plan was replaced with the Rights Plan as described in Note 16(b).
Movement of options during the year ended 30 June 2019:
1. The original expiry date for this tranche of options was 2 July 2018. However, due to extraordinary circumstances, the remaining 75,000 options could not be exercised during the prior financial year. Therefore, the Board had exercised its discretion during the year to extend the expiry date for the remaining options to 30 September 2018.
2. Options associated with an EPS hurdle are not expected to vest on 31 August 2019 as the minimum performance target will not be met. Options associated with a TSR hurdle will vest on 31 August 2019 in accordance with accounting standards. However, because the minimum target was not met, these options will be restricted and unexercisable. Refer to Section 3b) of the audited Remuneration Report for further details.
Table:
Grant Date | Vesting Date | Expiry Date | Exercise Price $ | No. of Options at Beg. of Year | Options Exercised or Lapsed | No. of Options at End of Year
2 Jul 2013 | 2 Jul 2016 | 30 Sept 2018 1 | 0.92 | 75,000 | (75,000) | -
2 Jul 2014 | 2 Jul 2017 | 2 Jul 2019 | 1.30 | 470,000 | (205,000) | 265,000
2 Jul 2015 | 2 Jul 2018 | 2 Jul 2020 | 2.67 | 1,000,000 | (75,000) | 925,000
22 Dec 2016 | 31 Aug 2019 2 | 22 Dec 2021 | 3.59 | 1,323,730 | - | 1,323,730
Total |  |  |  | 2,868,730 | (355,000) | 2,513,730
Weighted average exercise price |  |  |  |  | $1.51 | $3.01


Question: How many options granted on 2 July 2015 were exercised or lapsed?
Answer: 75,000