hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
shareowner return performance graph the following performance graph and related information shall not be deemed 201csoliciting material 201d or to be 201cfiled 201d with the securities and exchange commission , nor shall such information be incorporated by reference into any future filing under the securities act of 1933 or securities exchange act of 1934 , each as amended , except to the extent that the company specifically incorporates such information by reference into such filing . the following graph shows a five year comparison of cumulative total shareowners 2019 returns for our class b common stock , the standard & poor 2019s 500 index , and the dow jones transportation average . the comparison of the total cumulative return on investment , which is the change in the quarterly stock price plus reinvested dividends for each of the quarterly periods , assumes that $ 100 was invested on december 31 , 2005 in the standard & poor 2019s 500 index , the dow jones transportation average , and our class b common stock . comparison of five year cumulative total return $ 40.00 $ 60.00 $ 80.00 $ 100.00 $ 120.00 $ 140.00 $ 160.00 201020092008200720062005 s&p 500 ups dj transport .

Table:
 | 12/31/05 | 12/31/06 | 12/31/07 | 12/31/08 | 12/31/09 | 12/31/10
united parcel service inc . | $ 100.00 | $ 101.76 | $ 98.20 | $ 78.76 | $ 84.87 | $ 110.57
standard & poor 2019s 500 index | $ 100.00 | $ 115.79 | $ 122.16 | $ 76.96 | $ 97.33 | $ 111.99
dow jones transportation average | $ 100.00 | $ 109.82 | $ 111.38 | $ 87.52 | $ 103.79 | $ 131.59
.

Question: what was the percentage cumulative total shareowners 2019 returns for united parcel service inc . for the five years ended 12/31/10?
Answer: 10.57%
Calculation: subtract(110.57, const_100), divide(#0, const_100)
Assets and Liabilities Measured at Fair Value
The following table presents our assets and liabilities measured at fair value on a recurring or non-recurring basis at December 31,
2019:
The carrying amount of money market funds approximates fair value as of each reporting date because of the short maturity of those
instruments.
The Company did not have any non-financial assets or non-financial liabilities that were recognized or disclosed at fair value as of
December 31, 2019.
Table:
 | Level 1 | Level 2 | Level 3
 | (In thousands) |  | 
Assets |  |  | 
Cash equivalents: Money market funds | $256,915 | $ - | $ -
Other current assets: |  |  | 
Indemnification - Sale of SSL | $ - | $ - | $ 598
Liabilities |  |  | 
Long term liabilities: |  |  | 
Indemnification - Globalstar do Brasil S.A. | $ - | $ - | $145


Question: What are the company's Level 2 and 3 long term liabilities as at December 31, 2019?
Answer: 0, $145
A reconciliation of the beginning and ending balance of unrecognized tax benefits is as follows:
Included in the total unrecognized tax benefits at December 31, 2019, 2018 and 2017 is $2.4 billion, $2.3 billion and $1.9 billion, respectively, that if recognized, would favorably affect the effective income tax rate.
Table:
 |  |  | (dollars in millions)
 | 2019 | 2018 | 2017
Balance at January 1, | $ 2,871 | $2,355 | $ 1,902
Additions based on tax positions related to the current year | 149 | 160 | 219
Additions for tax positions of prior years | 297 | 699 | 756
Reductions for tax positions of prior years | (300) | (248) | (419)
Settlements | (58) | (40) | (42)
Lapses of statutes of limitations | (89) | (55) | (61)
Balance at December 31, | $ 2,870 | $ 2,871 | $ 2,355


Question: What was the amount that would favorably affect the effective income tax rate if included in 2018?
Answer: $2.3 billion
issuer purchases of equity securities during the three months ended december 31 , 2007 , we repurchased 8895570 shares of our class a common stock for an aggregate of $ 385.1 million pursuant to the $ 1.5 billion stock repurchase program publicly announced in february 2007 , as follows : period total number of shares purchased ( 1 ) average price paid per share total number of shares purchased as part of publicly announced plans or programs approximate dollar value of shares that may yet be purchased under the plans or programs ( in millions ) .

Table:
period | total number of shares purchased ( 1 ) | average price paid per share | total number of shares purchased as part of publicly announced plans or programs | approximate dollar value of shares that may yet be purchased under the plans or programs ( in millions )
october 2007 | 3493426 | $ 43.30 | 3493426 | $ 449.9
november 2007 | 2891719 | $ 44.16 | 2891719 | $ 322.2
december 2007 | 2510425 | $ 44.20 | 2510425 | $ 216.2
total fourth quarter | 8895570 | $ 43.27 | 8895570 | $ 216.2
( 1 ) issuer repurchases pursuant to the $ 1.5 billion stock repurchase program publicly announced in february 2007 .
under this program , our management was authorized through february 2008 to purchase shares from time to time through open market purchases or privately negotiated transactions at prevailing prices as permitted by securities laws and other legal requirements , and subject to market conditions and other factors .
to facilitate repurchases , we typically made purchases pursuant to trading plans under rule 10b5-1 of the exchange act , which allow us to repurchase shares during periods when we otherwise might be prevented from doing so under insider trading laws or because of self-imposed trading blackout periods .
subsequent to december 31 , 2007 , we repurchased 4.3 million shares of our class a common stock for an aggregate of $ 163.7 million pursuant to this program .
in february 2008 , our board of directors approved a new stock repurchase program , pursuant to which we are authorized to purchase up to an additional $ 1.5 billion of our class a common stock .
purchases under this stock repurchase program are subject to us having available cash to fund repurchases , as further described in item 1a of this annual report under the caption 201crisk factors 2014we anticipate that we may need additional financing to fund our stock repurchase programs , to refinance our existing indebtedness and to fund future growth and expansion initiatives 201d and item 7 of this annual report under the caption 201cmanagement 2019s discussion and analysis of financial condition and results of operations 2014liquidity and capital resources . 201d .

Question: in q1 2008 , what was the average cost per share for repurchased shares in that quarter?
Answer: 38.07
Calculation: multiply(163.7, const_1000000), multiply(4.3, const_1000000), divide(#0, #1)
Item 6. Selected Financial Data
The following tables set forth our selected financial data for the periods and at the dates indicated. The selected financial data from the consolidated statements of operations and consolidated statements of cash flows for the years ended December 31, 2019, 2018, and 2017 and the selected financial data from the consolidated balance sheets as of December 31, 2019 and 2018 have been derived from the audited consolidated financial statements included in this Annual Report on Form 10-K. The selected financial data from the consolidated statements of operations and consolidated statements of cash flows for the years ended December 31, 2016 and 2015 and the selected financial data from the consolidated balance sheets as of December 31, 2017, 2016, and 2015 have been derived from audited consolidated financial statements not included in this Annual Report on Form 10-K. The information presented below should also be read in conjunction with our consolidated financial statements and the related notes thereto and Item 7. “Management’s Discussion and Analysis of Financial Condition and Results of Operations.”
Table:
 |  |  | Years Ended December 31, |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
 |  |  | (In thousands, except per share amounts) |  | 
Net sales . | $3,063,117 | $2,244,044 | $2,941,324 | $2,904,563 | $4,112,650
Gross profit | 549,212 | 392,177 | 548,947 | 638,418 | 1,132,762
Operating (loss) income . | (161,785) | 40,113 | 177,851 | (568,151) | 730,159
Net (loss) income | (114,933) | 144,326 | (165,615) | (416,112) | 593,406
Net (loss) income per share: |  |  |  |  | 
Basic . | $(1.09) | $1.38 | $(1.59) | $(4.05) | $5.88
Diluted . | $(1.09) | $1.36 | $(1.59) | $(4.05) | $5.83
Cash dividends declared per common share. | $— | $— | $— | $— | $—
Net cash provided by (used in) operating |  |  |  |  | 
activities | $174,201 | $(326,809) | $1,340,677 | $206,753 | $(325,209)
Net cash (used in) provided by investing |  |  |  |  | 
activities | (362,298) | (682,714) | (626,802) | 144,520 | (156,177)
Net cash provided by (used in) financing |  |  |  |  | 
activities | 74,943 | 255,228 | 192,045 | (136,393) | 101,207
 |  |  | December 31, |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
 |  |  | (In thousands) |  | 
Cash and cash equivalents . | $1,352,741 | $1,403,562 | $2,268,534 | $1,347,155 | $1,126,826
Marketable securities . | 811,506 | 1,143,704 | 720,379 | 607,991 | 703,454
Total assets . | 7,515,689 | 7,121,362 | 6,864,501 | 6,824,368 | 7,360,392
Total long-term debt | 471,697 | 466,791 | 393,540 | 188,388 | 289,415
Total liabilities | 2,418,922 | 1,908,959 | 1,765,804 | 1,606,019 | 1,741,996
Total stockholders’ equity . | 5,096,767 | 5,212,403 | 5,098,697 | 5,218,349 | 5,618,396


Question: What was the amount of marketable securities in 2019?
Answer: 811,506
Note 12 – Income Taxes
The provision for income taxes consists of the following for the fiscal years ended December 27, 2019, December 28, 2018 and December 29, 2017:
Table:
 | December 27, 2019  | December 28, 2018  | December 29, 2017
Current income tax expense: |  |  | 
Federal  | $4,003 | $2,945 | $3,342
State  | 2,144 | 1,943 | 1,403
Total current income tax expense  | 6,147 | 4,888 | 4,745
Deferred income tax expense (benefit): |  |  | 
Federal  | 1,617 | 2,363 | (1,059)
Foreign  | 17 | (472) | 215
State  | 429 | 663 | 141
Total deferred income tax expense (benefit) | 2,063 | 2,554 | (703)
Total income tax expense | $8,210 | $7,442 | $4,042


Question: Which year has the highest Total income tax expense?
Answer: 2019
Calculation: 8,210> 7,442> 4,042
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
Disaggregated Revenue
The following table presents revenues disaggregated by the major markets we serve:
Table:
 | Twelve Months Ended December 31, | 
 | 2019 | 2018
Transportation | $299,005 | $300,124
Industrial | 78,369 | 86,968
Medical | 41,901 | 40,663
Aerospace & Defense | 32,569 | 23,323
Telecom & IT | 17,155 | 19,405
Total | $468,999 | $470,483


Question: What was the revenue from Telecom & IT in 2018?
Answer: 19,405
Figure 29. 2016/2018 LTIP Award Grants
(1) All of the Market-based PRSUs and one-third of the stock options and service-based RSUs granted to Mr. Anstice under the 2016/2018 LTIP that were scheduled to vest in February 2019 were canceled upon his termination of employment with the Company as of December 5, 2018.
(2) The number of Market-based PRSUs awarded is reflected at target. The final number of shares that may have been earned is 0% to 150% of target.
In February 2019, the committee determined the payouts for the calendar year 2016/2018 LTIP Awards of Market-based PRSUs. The number of shares represented by the Marketbased PRSUs earned over the performance period was based on our stock price performance compared to the market price performance of the SOX index.
Based on the above formula and Market-based PRSU Vesting Summary set forth in Figures 26 and 27, the Company’s stock price performance over the three-year performance period was equal to 89.93% and performance of the SOX index (based on market price) over the same three-year performance period was equal to 84.47%. Lam’s stock price outperformed the SOX index by 5.46%, which resulted in a performance payout of 110.93% to target number of Marketbased PRSUs granted to each NEO. Based on such results, the committee made the following payouts to each NEO for the 2016/2018 LTIP Award of Market-based PRSUs.
Table:
Named Executive Officer (1)(2) (1)(2) (1)(2) | Target Award Opportunity ($) | Market-based PRSUs award (#) | Stock Options Award (#) | Service-based RSUs Award (#)
Timothy M.Archer | 4,000,000 | 28,935 | 34,722 | 17,361
Douglas R.Bettinger | 2,750,000 | 19,892 | 23,871 | 11,935
Richard A.Gottscho | 3,250,000 | 23,509 | 28,209 | 14,105
Patrick J. Lord | 1,100,000 | 7,957 | — | 7,957
Vahid Vahedi | 1,100,000 | 7,957 | — | 7,957
Seshasayee(Sesha) Varadarajan | 1,100,000 | 7,957 | — | 7,957


Question: Which named executive officer has the highest Stock Options Award?
Answer: Timothy M.Archer
Calculation: Find the named executive officer with the highest Stock Options Award
Sales and marketing expenses consist primarily of personnel expenses and costs associated with advertising, marketing events and trade shows.
Sales and marketing expenses decreased by $11.1 million during the year ended June 30, 2019 as compared to the prior fiscal year. This was primarily due to (i) a decrease in commissions expense of $6.6 million, of which approximately $8.9 million is the net result of the Company capitalizing more commission expense under Topic 606, whereas previously, under Topic 605, such costs would have been expensed as incurred, (ii) a decrease in marketing expenses of $5.7 million and (iii) a decrease in travel and communication expenses of $1.1 million. These were partially offset by (i) an increase in bad debt expense of $3.5 million as certain low dollar receivables were provided for entirely as they became aged greater than one year. Overall, our sales and marketing expenses, as a percentage of total revenues, decreased to approximately 18% from approximately 19% in the prior fiscal year.
Our sales and marketing labour resources increased by 103 employees, from 1,948 employees at June 30, 2018 to 2,051 employees at June 30, 2019.
Table:
increase (decrease) | Change between Fiscal increase (decrease) | 
(In thousands) | 2019 and 2018 | 2018 and 2017
Payroll and payroll-related benefits | $(48) | $48,717
Commissions | (6,588) | 16,993
Contract labour and consulting | (871) | 609
Share-based compensation | (752) | (454)
Travel and communication | (1,113) | 271
Marketing expenses | (5,742) | 3,880
Facilities | 808 | 8,373
Bad debt expense | 3,519 | 4,013
Other miscellaneous | (319) | 2,285
Total change in sales and marketing expenses | $(11,106) | $84,687


Question: How many employees are there at June 30, 2019?
Answer: 2,051
Liquidity
The following table presents selected financial information on liquidity (in thousands):
(1) We define working capital as current assets less current liabilities. Fiscal year 2019 includes the impact of recognizing operating lease right-of-use assets and liabilities as a result of our adoption of Accounting Standards Codification Topic 842, “Leases,” as of December 29, 2018.
We believe our existing balances of cash and cash equivalents, working capital and the availability under our asset-based loan facility, are sufficient to satisfy our working capital needs, capital expenditures, debt service and other liquidity requirements associated with our current operations over the next 12 months.
Our capital expenditures, excluding cash paid for acquisitions, were approximately $16.1 million for fiscal 2019. We believe our capital expenditures, excluding cash paid for acquisitions, for fiscal 2020 will be approximately $38.0 million to $42.0 million. The increase in projected capital expenditures in fiscal 2020 as compared to fiscal 2019 is the result of planned expansions of several of our distribution facilities. Our planned capital projects will provide both new and expanded facilities and improvements to our technology that we believe will produce increased efficiency and the capacity to continue to support the growth of our customer base.
Table:
 |  | Fiscal Year Ended | 
 | December 27, 2019  | December 28, 2018  | December 29, 2017
Cash and cash equivalents | $140,233 | $42,410 | $41,504
Working capital,(1) excluding cash and cash equivalents | $162,772 | $160,783 | $147,063
Availability under asset-based loan facility | $133,359 | $90,015 | $64,805


Question: What is the average value for the Cash and cash equivalents for fiscal years 2019, 2018 and 2017?
Answer: 74715.67
Calculation: (140,233+ 42,410+ 41,504)/3
NOTE 11 – STOCK COMPENSATION
The Company sponsors a stock-based incentive compensation plan known as the 2013 Equity Compensation Plan (the “Plan”), which was established by the Board of Directors of the Company in June 2013. A total of 500,000 shares were initially reserved for issuance under the Plan. The Plan was amended several times since then to eventually increase the authorized shares to 2,500,000 as of December 31, 2019. A total of 1,624,221 shares of common stock underlying options were outstanding at December 31, 2019. The Company had 236,614 remaining shares available to grant under the Plan at December 31, 2019.
The Plan allows the Company to grant incentive stock options, non-qualified stock options, stock appreciation rights, or restricted stock. The incentive stock options are exercisable for up to ten years, at an option price per share not less than the fair market value on the date the option is granted. The incentive stock options are limited to persons who are regular full-time employees of the Company at the date of the grant of the option. Non-qualified options may be granted to any person, including, but not limited to, employees, independent agents, consultants and attorneys, who the Company’s Board or Compensation Committee believes have contributed, or will contribute, to the success of the Company. Non-qualified options may be issued at option prices of less than fair market value on the date of grant and may be exercisable for up to ten years from date of grant. The option vesting schedule for options granted is determined by the Compensation Committee of the Board of Directors at the time of the grant. The Plan provides for accelerated vesting of unvested options if there is a change in control, as defined in the Plan.
The compensation cost that has been charged against income related to options for the years ended December 31, 2019 and 2018, was $1,687,745 and $1,317,904, respectively. No income tax benefit was recognized in the income statement and no compensation was capitalized in any of the years presented.
The Company had the following option activity during the years ended December 31, 2019 and 2018:
Of the options outstanding at December 31, 2019, 1,143,637 were exercisable with a weighted average contractual life of 1.9 years.
Table:
 | Number of Options | Weighted average exercise price | Weighted average remaining contractual life (years) | Aggregate intrinsic value $
Outstanding, January 1, 2018 | 1,368,772 | $3.12 |  | 
Granted – 2018 | 401,099 | $9.27 |  | 
Exercised – 2018 | (165,169) | $3.16 |  | 
Expired – 2018 | (50,002) | $5.48 |  | 
Outstanding, December 31, 2018 | 1,554,700 | $4.63 | 3.0 | 
Granted – 2019 | 410,134 | $12.28 |  | 
Exercised – 2019 | (251,063) | $3.73 |  | 
Expired – 2019 | (89,550) | $12.55 |  | 
Outstanding, December 31, 2019 | 1,624,221 | $6.27 | 2.6 | $7,925,643
Exercisable, December 31, 2019 | 1,143,637 | $4.39 | 1.9 | $7,197,053


Question: What is the total price of exercised or expired options during the fiscal year 2019?
Answer: 2060317.49
Calculation: (251,063*3.73)+(89,550*12.55)
15 Financial risk management (continued)
(c) Liquidity risk
Prudent liquidity risk management implies maintaining sufficient cash and marketable securities and the availability of funding through an adequate amount of committed credit facilities to meet obligations when due.
Management also actively monitors rolling forecasts of the Group’s cash and cash equivalents.
(i) Maturities of financial liabilities
The table below analyses the Group’s financial liabilities into relevant maturity groupings based on their contractual maturities for all non-derivative financial liabilities.
The amounts disclosed in the table are the contractual undiscounted cash flows.
The cash flows for unsecured notes assume that the early redemption options would not be exercised by the Group.
Table:
Contractual Maturities of Financial Liabilities | Within 12 months | Between 1 and 5 years | Over 5 years | Total contractual cash flows | Carrying amount
2019 | $'000 | $'000 | $'000 | $'000 | $'000
Trade payables | 44,840 | - | - | 44,840 | 44,840
Unsecured notes | 46,634 | 900,046 | - | 946,680 | 793,849
Lease liabilities | 5,008 | 26,709 | 167,214 | 198,931 | 73,328
Total non-derivatives | 96,482 | 926,755 | 167,214 | 1,190,451 | 912,017
2018 |  |  |  |  | 
Trade payables | 27,640 | - | - | 27,640 | 27,640
Unsecured notes | 18,750 | 342,000 | - | 360,750 | 296,912
Lease liabilities | 641 | 2,565 | 5,451 | 8,657 | 6,042
Total non-derivatives | 47,031 | 344,565 | 5,451 | 397,047 | 330,594


Question: What was the 2019 percentage change in carrying amount of total non-derivatives?
Answer: 175.87
Calculation: (912,017 - 330,594) / 330,594
Note 2: Net Income Per Share
Basic net income per share is computed using the weighted-average number of common shares outstanding for the period. Diluted net income per share is computed by adjusting the weighted-average number of common shares outstanding for the effect of dilutive potential common shares outstanding during the period. Potential common shares included in the diluted calculation consist of incremental shares issuable upon the exercise of outstanding stock options calculated using the treasury stock method.
The following table sets forth the calculation of basic and diluted net income per share (in thousands, except per share amounts):
For the years ended December 31, 2019 and 2018, options to purchase 200,000 and 200,000 shares of common stock, respectively, were not included in the computation of diluted net income per share because the effect would have been anti-dilutive.
Table:
Year Ended December 31, |  | 
 | 2019 | 2018
Net income | $4,155 | $4,661
Weighted average common shares—basic | 11,809 | 12,323
Effect of dilutive securities: stock options | 226 | 187
Weighted average common shares—diluted | 12,035 | 12,510
Net income per share—basic | $0.35 | $0.38
Net income per share—diluted | $0.35 | $0.37


Question: What is the change in net income between 2018 and 2019?
Answer: -506
Calculation: 4,155 -4,661
Note 4. Accounts Receivable, Net
The components of accounts receivable, net are as follows (in thousands):
For the years ended December 31, 2019, 2018 and 2017, we recorded a provision for doubtful accounts of $1.2 million, $0.1 million and $0.5 million, respectively.
For the year ended December 31, 2019, we recorded a reduction to the reserve for product returns of $0.1 million. For the years ended December 31, 2018 and 2017, we recorded a $0.3 million and $2.1 million reserve for product returns in our hardware and other revenue, respectively. Historically, we have not experienced write-offs for uncollectible accounts or sales returns that have differed significantly from our estimates.
Table:
December 31, |  | 
 | 2019 | 2018
Accounts receivable | $80,032 | $52,850
Allowance for doubtful accounts | (2,584) | (1,425)
Allowance for product returns | (1,075) | (1,915)
Accounts receivable, net | $76,373 | $49,510


Question: How many years did net accounts receivable exceed $50,000 thousand?
Answer: 1
Calculation: 2019
4.6 Adjusted EBITDA
BCE
BCE’s adjusted EBITDA grew by 6.0% in 2019, compared to 2018, attributable to growth from all three of our segments. Higher revenues coupled with reduced operating expenses drove the year-over-year growth in adjusted EBITDA. This corresponded to an adjusted EBITDA margin of 42.2% in 2019, up 1.6 pts over last year, mainly driven by the favourable impact from the adoption of IFRS 16 in 2019, and greater service revenue flow-through, moderated by greater low-margin product sales in our total revenue base.
Table:
 | 2019 | 2018 | $ CHANGE | % CHANGE
Bell Wireless | 3,842 | 3,521 | 321 | 9.1%
Bell Wireline | 5,414 | 5,321 | 93 | 1.7%
Bell Media | 850 | 693 | 157 | 22.7%
Total BCE adjusted EBITDA | 10,106 | 9,535 | 571 | 6.0%


Question: What is the total Adjusted EBITDA for Bell Wireless in 2018 and 2019?
Answer: 7363
Calculation: 3,842+3,521