hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
schlumberger limited and subsidiaries shares of common stock ( stated in millions ) issued in treasury shares outstanding .

Table:
 | issued | in treasury | shares outstanding
balance january 1 2009 | 1334 | -140 ( 140 ) | 1194
shares sold to optionees less shares exchanged | 2013 | 4 | 4
vesting of restricted stock | 2013 | 1 | 1
shares issued under employee stock purchase plan | 2013 | 4 | 4
stock repurchase program | 2013 | -8 ( 8 ) | -8 ( 8 )
balance december 31 2009 | 1334 | -139 ( 139 ) | 1195
acquisition of smith international inc . | 100 | 76 | 176
shares sold to optionees less shares exchanged | 2013 | 6 | 6
shares issued under employee stock purchase plan | 2013 | 3 | 3
stock repurchase program | 2013 | -27 ( 27 ) | -27 ( 27 )
issued on conversions of debentures | 2013 | 8 | 8
balance december 31 2010 | 1434 | -73 ( 73 ) | 1361
shares sold to optionees less shares exchanged | 2013 | 6 | 6
vesting of restricted stock | 2013 | 1 | 1
shares issued under employee stock purchase plan | 2013 | 3 | 3
stock repurchase program | 2013 | -37 ( 37 ) | -37 ( 37 )
balance december 31 2011 | 1434 | -100 ( 100 ) | 1334
see the notes to consolidated financial statements .

Question: what was the net change in shares outstanding during 2011?
Answer: 0
Calculation: subtract(1434, 1434)
Interest Expense and Interest Income and Other Expense, net
The table below sets forth the changes in interest expense and interest income and other expense, net, for the fiscal year ended December 29, 2019, as compared to fiscal year ended December 30, 2018 (in thousands, except percentage data):
The $242,000 increase in interest expense was attributable to higher line of credit balance in 2019 compared to 2018. The $112,000 increase in interest income and other expenses was attributable to increase in interest income from money market account with Heritage Bank.
Table:
 | Fiscal Years |  | Year-Over-Year Change | 
 | 2019 | 2018 | Amount | Percentage
Interest expense | $(350) | $(108) | $(242) | 224%
Interest income and other expense, net | 189 | 77 | 112 | 145%
 | $(161) | $(31) | $(130) | 419%


Question: What is the average total interest expense and interest income and other expense, net, in 2018 and 2019?
Answer: -96
Calculation: -(31 + 161)/2
For purposes of reconciling the Company’s provision for income taxes at the statutory rate and the Company’s provision (benefit) for income taxes at the effective tax rate, a notional 26% tax rate was applied as follows (in thousands):
The difference between the statutory federal income tax rate and the Company’s effective tax rate in 2019, 2018 and 2017 is primarily attributable to the effect of state income taxes, difference between the U.S. and foreign tax rates, deferred tax state rate adjustment, share-based compensation, true up of deferred taxes, other non-deductible permanent items, and change in valuation allowance. In addition, the Company’s foreign subsidiaries are subject to varied applicable statutory income tax rates for the periods presented.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Income tax at federal statutory rate | $(10,883) | $(9,811) | $(6,659)
Increase (decrease) in tax resulting from: |  |  | 
State income tax expense, net of federal tax effect | (3,657) | (2,749) | (421)
Nondeductible permanent items | 3,522 | (1,522) | 1,506
Foreign rate differential | (367) | 552 | 599
Tax rate change | — | 134 | 7,226
Adjustment to deferred taxes | (1,904) | 307 | 37
Change in valuation allowance | 22,481 | 15,805 | (2,291)
Uncertain tax positions | 128 | 143 | 76
Nonqualified stock option and performance award windfall upon exercise | (9,128) | (1,983) | —
Other | 233 | (80) | (26)
Total | $425 | $796 | $47


Question: What was the average Tax rate change from 2017-2019?
Answer: 2453.33
Calculation: (0 + 134 + 7,226) / 3
Results of Continuing Operations
The following table sets forth certain operational data as a percentage of net sales for the fiscal years indicated:
Table:
 |  | Year Ended March 31, | 
 | 2019 | 2018 | 2017
Net sales | 100.0% | 100.0% | 100.0%
Cost of sales | 45.2 | 39.2 | 48.4
Gross profit | 54.8 | 60.8 | 51.6
Research and development | 15.4 | 13.3 | 16.0
Selling, general and administrative | 12.8 | 11.4 | 14.7
Amortization of acquired intangible assets | 12.6 | 12.2 | 9.9
Special charges and other, net | 0.6 | 0.4 | 2.9
Operating income | 13.4% | 23.5% | 8.1%


Question: Which years does the table provide information for certain operational data as a percentage of net sales?
Answer: 2019, 2018, 2017
Note 19 – Summarized Quarterly Financial Data (Unaudited)
The following table presents unaudited quarterly operating results for each of our last eight fiscal quarters. This information has been prepared on a basis consistent with our audited financial statements and includes all adjustments, consisting only of normal recurring adjustments, considered necessary for a fair presentation of the data.
UNAUDITED QUARTERLY OPERATING RESULTS
(In thousands, except for per share amounts)
(1) Assumes exercise of dilutive securities calculated under the treasury stock method.
Table:
Three Months Ended | March 31, 2019 | June 30, 2019 | September 30, 2019 | December 31, 2019
Net sales | $143,791 | $156,391 | $114,092 | $115,787
Gross profit | $60,612 | $65,015 | $46,331 | $47,209
Operating income (loss) | $(6,167) | $562 | $(20,288) | $(14,070)
Net income (loss) | $770 | $3,995 | $(46,123) | $(11,624)
Earnings (loss) per common share - basic | $0.02 | $0.08 | $(0.96) | $(0.25)
Earnings (loss) per common share - diluted | $0.02(1) | $0.08(1) | $(0.96) | $(0.25)


Question: What is the total net sales of the 3 highest earning quarters in 2019?
Answer: 415969
Calculation:  $143,791 + $156,391 + $115,787
table of contents the following performance graph is not 201csoliciting material , 201d is not deemed filed with the sec , and is not to be incorporated by reference into any of valero 2019s filings under the securities act of 1933 or the securities exchange act of 1934 , as amended , respectively . this performance graph and the related textual information are based on historical data and are not indicative of future performance . the following line graph compares the cumulative total return 1 on an investment in our common stock against the cumulative total return of the s&p 500 composite index and an index of peer companies ( that we selected ) for the five-year period commencing december 31 , 2007 and ending december 31 , 2012 . our peer group consists of the following ten companies : alon usa energy , inc. ; bp plc ( bp ) ; cvr energy , inc. ; hess corporation ; hollyfrontier corporation ; marathon petroleum corporation ; phillips 66 ( psx ) ; royal dutch shell plc ( rds ) ; tesoro corporation ; and western refining , inc . our peer group previously included chevron corporation ( cvx ) and exxon mobil corporation ( xom ) but they were replaced with bp , psx , and rds . in 2012 , psx became an independent downstream energy company and was added to our peer group . cvx and xom were replaced with bp and rds as they were viewed as having operations that more closely aligned with our core businesses . comparison of 5 year cumulative total return1 among valero energy corporation , the s&p 500 index , old peer group , and new peer group .

Table:
 | 12/2007 | 12/2008 | 12/2009 | 12/2010 | 12/2011 | 12/2012
valero common stock | $ 100.00 | $ 31.45 | $ 25.09 | $ 35.01 | $ 32.26 | $ 53.61
s&p 500 | 100.00 | 63.00 | 79.67 | 91.67 | 93.61 | 108.59
old peer group | 100.00 | 80.98 | 76.54 | 88.41 | 104.33 | 111.11
new peer group | 100.00 | 66.27 | 86.87 | 72.84 | 74.70 | 76.89
____________ 1 assumes that an investment in valero common stock and each index was $ 100 on december 31 , 2007 .
201ccumulative total return 201d is based on share price appreciation plus reinvestment of dividends from december 31 , 2007 through december 31 , 2012. .

Question: what was the mathematical range for all four groups in 12/2010 , assuming investments of $ 100 initially in 2008?
Answer: 56.66
Calculation: subtract(91.67, 35.01)
Management makes allowance for expected credit loss based on the simplified approach to provide for expected credit losses, which permits the use of the lifetime expected loss provision for all trade receivables. Expected credit loss for receivables overdue more than 180 days is 25%-100%, depending on category. Expected credit loss for receivables overdue more than one year is 100%.
Movements in provisions for impairment of freight receivables during the year are as follows:
Allowance for expected credit loss of freight receivables have been recognized in the income statement under "Port expenses, bunkers and commissions".
Allowance for expected credit loss of freight receivables is calculated using an ageing factor as well as a specific customer knowledge and is based on a provision matrix on days past due.
Table:
USDm | 2019 | 2018 | 2017
Allowance for expected credit loss |  |  | 
Balance as of 1 January | 1.7 | 1.3 | 2.6
Adjustment to prior years | 1.5 | - | -
Provisions for the year | 2.4 | 1.7 | 0.6
Provisions reversed during the year | -1.9 | -1.0 | -1.9
Provisions utilized during the year | - | -0.3 | -
Balance as of 31 December | 3.7 | 1.7 | 1.3


Question: What is recognized in the income statement under Port expenses, bunkers and commissions?
Answer: Allowance for expected credit loss of freight receivables
the table below summarizes activity of rsus with performance conditions for the year ended december 31 , shares ( in thousands ) weighted average grant date fair value ( per share ) .

Table:
 | shares ( in thousands ) | weightedaverage grantdate fair value ( per share )
non-vested total as of december 31 2016 | 309 | $ 55.94
granted | 186 | 63.10
vested | -204 ( 204 ) | 46.10
forfeited | -10 ( 10 ) | 70.50
non-vested total as of december 31 2017 | 281 | $ 67.33
as of december 31 , 2017 , $ 6 million of total unrecognized compensation cost related to the nonvested rsus , with and without performance conditions , is expected to be recognized over the weighted-average remaining life of 1.5 years .
the total fair value of rsus , with and without performance conditions , vested was $ 16 million , $ 14 million and $ 12 million for the years ended december 31 , 2017 , 2016 and 2015 , respectively .
if dividends are paid with respect to shares of the company 2019s common stock before the rsus are distributed , the company credits a liability for the value of the dividends that would have been paid if the rsus were shares of company common stock .
when the rsus are distributed , the company pays the participant a lump sum cash payment equal to the value of the dividend equivalents accrued .
the company accrued dividend equivalents totaling less than $ 1 million , $ 1 million and $ 1 million to accumulated deficit in the accompanying consolidated statements of changes in stockholders 2019 equity for the years ended december 31 , 2017 , 2016 and 2015 , respectively .
employee stock purchase plan the company maintains a nonqualified employee stock purchase plan ( the 201cespp 201d ) through which employee participants may use payroll deductions to acquire company common stock at the lesser of 90% ( 90 % ) of the fair market value of the common stock at either the beginning or the end of a three-month purchase period .
on february 15 , 2017 , the board adopted the american water works company , inc .
and its designated subsidiaries 2017 nonqualified employee stock purchase plan , which was approved by stockholders on may 12 , 2017 and took effect on august 5 , 2017 .
the prior plan was terminated as to new purchases of company stock effective august 31 , 2017 .
as of december 31 , 2017 , there were 2.0 million shares of common stock reserved for issuance under the espp .
the espp is considered compensatory .
during the years ended december 31 , 2017 , 2016 and 2015 , the company issued 93 thousand , 93 thousand and 98 thousand shares , respectively , under the espp. .

Question: as of december 31 , 2017 what was the percent of shares forfeited
Answer: 3.6%
Calculation: divide(const_10, 281)
The following table summarizes restricted stock-based award activity, including service-based awards and performance-based awards, granted pursuant to Oracle-based stock plans and stock plans assumed from our acquisitions for our last three fiscal years ended May 31, 2019 :
The total grant date fair value of restricted stock-based awards that were vested and issued in fiscal 2019, 2018 and 2017 was $1.3 billion, $1.0 billion and $715 million, respectively. As of May 31, 2019, total unrecognized stock-based compensation expense related to non-vested restricted stock-based awards was $2.8 billion and is expected to be recognized over the remaining weighted-average vesting period of 2.68 years.
No PSUs were granted in each of fiscal 2019 and 2018. In fiscal 2017, 1.7 million PSUs were granted which vest upon the attainment of certain performance metrics and service-based vesting. Based upon actual attainment relative to the “target” performance metric, certain participants have the ability to be issued up to 150% of the target number of PSUs originally granted, or to be issued no PSUs at all. In fiscal 2019, 2.4 million PSUs vested and 1.3 million PSUs remained outstanding as of May 31, 2019.
Table:
 |  | Restricted Stock-Based Awards Outstanding
(in millions, except fair value) | Number of Shares | Weighted-Average Grant Date Fair Value
Balance, May 31, 2016 | 52 | $39.29
Granted | 42 | $39.40
Assumed | 14 | $37.83
Vested and Issued | (18) | $40.39
Canceled | (7) | $39.73
Balance, May 31, 2017 | 83 | $39.18
Granted | 44 | $47.42
Vested and Issued | (27) | $39.10
Canceled | (11) | $41.97
Balance, May 31, 2018 | 89 | $42.93
Granted | 53 | $42.47
Vested and Issued | (31) | $41.85
Canceled | (12) | $42.97
Balance, May 31, 2019 | 99 | $43.01


Question: How many PSUs remained outstanding as of May 31, 2019?
Answer: In fiscal 2019, 2.4 million PSUs vested and 1.3 million PSUs remained outstanding as of May 31, 2019.
Cash Flows
The following table summarizes our cash flows for the years ended December 31, 2019, 2018 and 2017 (in thousands):
At December 31, 2019, $6.7 million of the $539.7 million of cash, cash equivalents and restricted cash was held by foreign subsidiaries. Our intention is to indefinitely reinvest foreign earnings in our foreign subsidiaries. If these earnings were used to fund domestic operations, they would be subject to additional income taxes upon repatriation.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Cash, cash equivalents and restricted cash at beginning of period | $60,068 | $103,051 | $60,765
Cash provided by operating activities | 10,317 | 3,295 | 4,863
Cash used in investing activities | (24,574) | (48,413) | (70,972)
Cash provided by financing activities | 494,101 | 3,099 | 108,475
Effects of exchange rates on cash, cash equivalents and restricted cash | (250) | (964) | (80)
Cash, cash equivalents and restricted cash at end of period | $539,662 | $60,068 | $103,051


Question: How much cash, cash equivalents and restricted cash was held by foreign subsidiaries at December 31, 2019?
Answer: $6.7 million of the $539.7 million of cash, cash equivalents and restricted cash
TREASURY SHARES
On December 31, 2019, we had 48,866,220 outstanding common shares excluding 2,431,174 treasury shares. This compared to 49,318,898 outstanding common shares and 6,978,496 treasury shares at year-end 2018. Besides the cancellation of 5 million treasury shares in July 2019, the change in the number of treasury shares in 2019 was the result of approximately 950,000 repurchased shares and approximately 498,000 treasury shares that were used as part of share based payments.
Table:
 | 2018 | 2019
As per January 1: |  | 
Issued shares | 62,297,394 | 56,297,394
Treasury shares | 6,157,241 | 6,978,496
Outstanding shares | 56,140,153 | 49,318,898
Changes during the year: |  | 
Cancellation of treasury shares | 6,000,000 | 5,000,000
Share buybacks | 7,242,734 | 950,902
Treasury shares used for share based performance programs | 421,479 | 498,224
As per December 31: |  | 
Issued shares | 56,297,394 | 51,297,394
Treasury shares | 6,978,496 | 2,431,174
Outstanding shares | 49,318,898 | 48,866,220


Question: What is the percentage change in outstanding shares  As per December 31 from 2018 to 2019?
Answer: -0.92
Calculation: (48,866,220- 49,318,898)/ 49,318,898
16. INCOME TAXES
The components of (loss) income before (benefit from) income taxes are:
Table:
(in thousands) | 2019 | 2018 | 2017
Domestic | $(51,396) | (27,494) | 57,493
Foreign | (83,450) | 15,951 | 28,742
(Loss) income before (benefit from) income taxes | $(134,846) | $(11,543) | $86,235


Question: What are the respective domestic and foreign losses before income tax benefits in 2019?
Answer: 51,396, 83,450
9. Debtors
The Directors consider that the carrying amount of trade and other debtors approximates their fair value.
The Company has no significant concentration of credit risk attributable to its trade debtors as the exposure is spread over a large number of customers.
Assets recognised from costs to obtain a contract relate to capitalised incremental costs to obtain a contract, being sales commissions arising on contracts with customers of more than one year in length. No assets were impaired or derecognised during the current year or prior year.
Table:
 |  | 2019 | 2018
 | Notes | £ million | £ million
Due within one year |  |  | 
Trade debtors |  | 5.2 | 7.0
Owed by subsidiaries |  | 13.7 | 9.6
Other debtors |  | 0.2 | 0.7
Prepayments |  | 0.4 | 0.6
Current tax asset |  | 1.0 | 0.6
Deferred tax | 13 | – | 1.3
Assets recognised from costs to obtain a contract |  | 0.1 | 0.1
 |  | 20.6 | 19.9
Due after one year |  |  | 
Defined benefit pension plan surplus | 3 | 8.8 | 2.0


Question: What was the change in the amount owed by subsidiaries?
Answer: 4.1
Calculation: 13.7-9.6
depending upon our senior unsecured debt ratings . the facilities require the maintenance of a minimum net worth and a debt to net worth coverage ratio . at december 31 , 2006 , we were in compliance with these covenants . the facilities do not include any other financial restrictions , credit rating triggers ( other than rating-dependent pricing ) , or any other provision that could require the posting of collateral . in addition to our revolving credit facilities , we had $ 150 million in uncommitted lines of credit available , including $ 75 million that expires in march 2007 and $ 75 million expiring in may 2007 . neither of these lines of credit were used as of december 31 , 2006 . we must have equivalent credit available under our five-year facilities to draw on these $ 75 million lines . dividend restrictions 2013 we are subject to certain restrictions related to the payment of cash dividends to our shareholders due to minimum net worth requirements under the credit facilities referred to above . the amount of retained earnings available for dividends was $ 7.8 billion and $ 6.2 billion at december 31 , 2006 and 2005 , respectively . we do not expect that these restrictions will have a material adverse effect on our consolidated financial condition , results of operations , or liquidity . we declared dividends of $ 323 million in 2006 and $ 316 million in 2005 . shelf registration statement 2013 under a current shelf registration statement , we may issue any combination of debt securities , preferred stock , common stock , or warrants for debt securities or preferred stock in one or more offerings . at december 31 , 2006 , we had $ 500 million remaining for issuance under the current shelf registration statement . we have no immediate plans to issue any securities ; however , we routinely consider and evaluate opportunities to replace existing debt or access capital through issuances of debt securities under this shelf registration , and , therefore , we may issue debt securities at any time . 6 . leases we lease certain locomotives , freight cars , and other property . 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 , 2006 were as follows : millions of dollars operating leases capital leases .

Table:
millions of dollars | operatingleases | capital leases
2007 | $ 624 | $ 180
2008 | 546 | 173
2009 | 498 | 168
2010 | 456 | 148
2011 | 419 | 157
later years | 2914 | 1090
total minimum lease payments | $ 5457 | $ 1916
amount representing interest | n/a | -680 ( 680 )
present value of minimum lease payments | n/a | $ 1236
rent expense for operating leases with terms exceeding one month was $ 798 million in 2006 , $ 728 million in 2005 , and $ 651 million in 2004 .
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. .

Question: what percentage of total minimum lease payments are operating leases as of december 31 , 2006?
Answer: 74%
Calculation: add(5457, 1916), divide(5457, #0)
2. Revenue
The Company is a global manufacturer of component and subsystem devices whose components are found in the primary end-markets of the aerospace, appliance, automotive, commercial vehicle, construction, consumer and industrial equipment, communications (including information processing and storage, networking equipment and wireless and terrestrial voice/data systems), medical, rail and other transportation industries. On April 29, 2018, the Company adopted ASC 606 along with the related amendments using a modified retrospective approach to all contracts open as of that date.
Upon adoption, the Company recognized a $0.1 million increase to opening retained earnings. This adjustment was a result of modifying the METHODE ELECTRONICS, INC. AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS F-14 Company's revenue recognition pattern for highly customized goods with no alternative use to over time recognition instead of point in time and for deferring revenue related to material rights that we provide to our customers. The overall impact to the Company's financial statements was immaterial. The Company has modified its controls to address the risks present under ASC 606.
As the Company has adopted ASC 606 using the modified retrospective approach, prior periods have not been restated, and as such they are presented under ASC 605. The impact of the changes in accounting policy on fiscal 2019 is provided below.
Table:
 |  | Fiscal Year Ended April 27, 2019 | 
(Dollars in Millions) | As Reported | Adjustments | Balance Under ASC 605
Net Sales | $1,000.3 | $(24.2) | $1,024.5
Cost of Products Sold | $734.5 | $(24.2) | $758.7
Total Inventories | $116.7 | $(0.5) | $117.2
Contract Assets | $0.8 | $0.8 | $—
Contract Liabilities | $0.3 | $0.3 | $—
Retained Earnings | $545.2 | $0.1 | $545.1


Question: What percentage of retained earnings was total inventories as reported?
Answer: 21.4
Calculation: 116.7 / 545.2