trismik/FinRAG huggingface dataset:
Fiscal 2018 Acquisitions
Allocation of the purchase consideration for acquisitions completed in fiscal 2018 is summarized as follows (in millions):
On July 31, 2017, we completed our acquisition of privately held Viptela Inc. (“Viptela”), a provider of software-defined wide area networking products. Revenue from the Viptela acquisition has been included in our Infrastructure Platforms product category.
On September 22, 2017, we completed our acquisition of privately held Springpath, Inc. (“Springpath”), a hyperconvergence software company. Revenue from the Springpath acquisition has been included in our Infrastructure Platforms product category.
On February 1, 2018, we completed our acquisition of publicly held BroadSoft, Inc. (“BroadSoft”), a cloud calling and contact center solutions company. Revenue from the BroadSoft acquisition has been included in our Applications product category.
On May 10, 2018, we completed our acquisition of privately held Accompany, a provider of an AI-driven relationship intelligence platform. Results from the Accompany acquisition has been included in our Applications product category.
The total purchase consideration related to our acquisitions completed during fiscal 2018 consisted of cash consideration and vested share-based awards assumed. The total cash and cash equivalents acquired from these acquisitions was approximately $187 million.

Fiscal 2018
Purchase Consideration
Net Tangible Assets Acquired (Liabilities Assumed)
Purchased Intangible Assets
Goodwill
Viptela
$497
$(18)
$180
$335
Springpath
248
(11)
160
99
BroadSoft
2,179
353
430
1,396
Accompany
222
6
55
161
Others (four in total)
72
4
42
26
Total
$3,218
$334
$867
$2,017


Question: Analyse this data from a financial earnings document. What was the difference in Purchase Consideration between Springpath and Broadsoft?
Choices:
1931
2019
248
1957
540392
Correct choice index: 0
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 sec , 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 , 2007 in the standard & poor 2019s 500 index , the dow jones transportation average , and our class b common stock. .

12/31/2007
12/31/2008
12/31/2009
12/31/2010
12/31/2011
12/31/2012
United Parcel Service, Inc.
$100.00
$80.20
$86.42
$112.60
$116.97
$121.46
Standard & Poor’s 500 Index
$100.00
$63.00
$79.67
$91.68
$93.61
$108.59
Dow Jones Transportation Average
$100.00
$78.58
$93.19
$118.14
$118.15
$127.07

.

Question: Analyse this data from a financial earnings document. what was the percentage total cumulative return on investment for united parcel service inc . for the five years ended 12/31/2012?
Choices:
0.2303
-0.37
121.46
0.2146
-91.4654
Correct choice index: 3
Our net sales by offering category for EMEA for 2019 and 2018, were as follows (dollars in thousands):
Net sales in EMEA remained flat (increased 5% excluding the effects of fluctuating foreign currency exchange rates), or down $3.6 million, in 2019 compared to 2018. Net sales of hardware declined 5%, year to year, while net sales of software and services were up 2% and 7%, respectively, year over year. The changes were the result of the following:
• Lower volume of net sales of networking solutions, partially offset by higher volume of net sales of devices, to large enterprise and public sector clients in hardware net sales. • Higher volume of software net sales to large enterprise and public sector clients.
• Higher volume of net sales of cloud solution offerings and increased software referral fees that are recorded on a net sales recognition basis. In addition, there was an increase in the volume of Insight delivered services.

EMEA
Sales Mix
2019
2018
%Change
Hardware
$622,949
$653,499
(5%)
Software
753,729
736,509
2%
Services
149,966
140,233
7%
$1,526,644
$1,530,241
—


Question: Analyse this data from a financial earnings document. What is the change in Sales Mix of Software between 2018 and 2019?
Choices:
17220
-772915
1490238
-17220
-113560
Correct choice index: 0
part ii item 5 : market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities motorola 2019s common stock is listed on the new york and chicago stock exchanges .
the number of stockholders of record of motorola common stock on january 31 , 2008 was 79907 .
information regarding securities authorized for issuance under equity compensation plans is incorporated by reference to the information under the caption 201cequity compensation plan information 201d of motorola 2019s proxy statement for the 2008 annual meeting of stockholders .
the remainder of the response to this item incorporates by reference note 16 , 201cquarterly and other financial data ( unaudited ) 201d of the notes to consolidated financial statements appearing under 201citem 8 : financial statements and supplementary data 201d .
the following table provides information with respect to acquisitions by the company of shares of its common stock during the quarter ended december 31 , 2007 .
issuer purchases of equity securities period ( a ) total number of shares purchased ( 1 ) ( 2 ) ( b ) average price paid per share ( 1 ) ( 3 ) ( c ) total number of shares purchased as part of publicly announced plans or programs ( 2 ) ( d ) maximum number ( or approximate dollar value ) of shares that may yet be purchased under the plans or programs ( 2 ) .

<i>Period</i>
<i>(a) Total Number</i> <i>of Shares</i> <i>Purchased<sup>(1)(2)</sup></i>
<i>(b) Average Price</i> <i>Paid per</i> <i>Share<sup>(1)(3)</sup></i>
<i>(c) Total Number</i> <i>of Shares Purchased</i> <i>as Part of Publicly</i> <i>Announced Plans</i> <i>or Programs<sup>(2)</sup></i>
<i>(d) Maximum Number</i> <i>(or Approximate Dollar</i> <i>Value) of Shares that</i> <i>May Yet Be Purchased</i> <i>Under the Plans or</i> <i>Programs<sup>(2)</sup></i>
9/30/07 to 10/26/07
2,972,951
$18.84
2,964,225
$4,267,375,081
10/27/07 to 11/23/07
5,709,917
$17.23
5,706,600
$4,169,061,854
11/24/07 to 12/31/07
25,064,045
$16.04
25,064,045
$3,767,061,887
Total
33,746,913
$16.49
33,734,870

( 1 ) in addition to purchases under the 2006 stock repurchase program ( as defined below ) , included in this column are transactions under the company 2019s equity compensation plans involving the delivery to the company of 12043 shares of motorola common stock to satisfy tax withholding obligations in connection with the vesting of restricted stock granted to company employees .
( 2 ) through actions taken on july 24 , 2006 and march 21 , 2007 , the board of directors has authorized the company to repurchase an aggregate amount of up to $ 7.5 billion of its outstanding shares of common stock over a period ending in june 2009 , subject to market conditions ( the 201c2006 stock repurchase program 201d ) .
( 3 ) average price paid per share of common stock repurchased under the 2006 stock repurchase program is execution price , excluding commissions paid to brokers. .

Question: Analyse this data from a financial earnings document. in 2007 what was the percent of the total number of shares purchased after 11/24/07
Choices:
-25064045
0.74297
25064044.25729
1.34643
0.74271
Correct choice index: 4
(a) EBITDA is calculated as operating profit less interest income and other gains/losses, net and adding back depreciation of property, plant and equipment, investment properties as well as right-of-use assets, and amortisation of intangible assets. Adjusted EBITDA is calculated as EBITDA plus equity-settled share-based compensation expenses.
(b) Adjusted EBITDA margin is calculated by dividing Adjusted EBITDA by revenues.
(c) Net debt represents period end balance and is calculated as cash and cash equivalents, plus term deposits and others, minus borrowings and notes payable.
(d) Capital expenditures consist of additions (excluding business combinations) to property, plant and equipment, construction in progress, investment properties, land use rights and intangible assets (excluding video and music contents, game licences and other contents).

Unaudited
Three months ended
Year ended
31 December
30 September
31 December
31 December
31 December
2019
2019
2018
2019
2018
(RMB in millions, unless specified)
EBITDA (a)
35,675
35,378
27,180
137,268
110,404
Adjusted EBITDA (a)
38,572
38,123
29,701
147,395
118,273
Adjusted EBITDA margin (b)
36%
39%
35%
39%
38%
Interest and related expenses
2,348
2,086
1,345
7,690
4,898
Net debt (c)
(15,552)
(7,173)
(12,170)
(15,552)
(12,170)
Capital expenditures (d)
16,869
6,632
4,564
32,369
23,941


Question: Analyse this data from a financial earnings document. What is the difference between EBITDA and adjusted EBITDA for three months ended 30 September 2019?
Choices:
2745
-8198
38093
-3009
-2745
Correct choice index: 0
volume declines in cement , some agricultural products , and newsprint shipments partially offset the increases .
operating expenses millions of dollars 2008 2007 2006 % (  % ) change 2008 v 2007 % (  % ) change 2007 v 2006 .

<i>Millions of Dollars</i>
<i>2008</i>
<i>2007</i>
<i>2006</i>
<i>% Change 2008 v 2007</i>
% Change 2007 v 2006
Compensation and benefits
$4,457
$4,526
$4,535
(2)%
-%
Fuel
3,983
3,104
2,968
28
5
Purchased services and materials
1,902
1,856
1,756
2
6
Depreciation
1,387
1,321
1,237
5
7
Equipment and other rents
1,326
1,368
1,396
(3)
(2)
Other
840
733
802
15
(9)
Total
$13,895
$12,908
$12,694
8 %
2%

operating expenses increased $ 987 million in 2008 .
our fuel price per gallon rose 39% ( 39 % ) during the year , increasing operating expenses by $ 1.1 billion compared to 2007 .
wage , benefit , and materials inflation , higher depreciation , and costs associated with the january cascade mudslide and hurricanes gustav and ike also increased expenses during the year .
cost savings from productivity improvements , better resource utilization , and lower volume helped offset these increases .
operating expenses increased $ 214 million in 2007 versus 2006 .
higher fuel prices , which rose 9% ( 9 % ) during the period , increased operating expenses by $ 242 million .
wage , benefit and materials inflation and higher depreciation expense also increased expenses during the year .
productivity improvements , better resource utilization , and a lower fuel consumption rate helped offset these increases .
compensation and benefits 2013 compensation and benefits include wages , payroll taxes , health and welfare costs , pension costs , other postretirement benefits , and incentive costs .
productivity initiatives in all areas , combined with lower volume , led to a 4% ( 4 % ) decline in our workforce for 2008 , saving $ 227 million compared to 2007 .
conversely , general wage and benefit inflation and higher pension and postretirement benefits increased expenses in 2008 , partially offsetting these reductions .
operational improvements and lower volume levels in 2007 led to a 1% ( 1 % ) decline in our workforce , saving $ 79 million in 2007 compared to 2006 .
a smaller workforce and less need for new train personnel reduced training costs during the year , which contributed to the improvement .
general wage and benefit inflation mostly offset the reductions , reflecting higher salaries and wages and the impact of higher healthcare and other benefit costs .
fuel 2013 fuel includes locomotive fuel and gasoline for highway and non-highway vehicles and heavy equipment .
diesel fuel prices , which averaged $ 3.15 per gallon ( including taxes and transportation costs ) in 2008 compared to $ 2.27 per gallon in 2007 , increased expenses by $ 1.1 billion .
a 4% ( 4 % ) improvement in our fuel consumption rate resulted in $ 136 million of cost savings due to the use of newer , more fuel 2008 operating expenses .

Question: Analyse this data from a financial earnings document. what percent of total operating expenses was fuel in 2008?
Choices:
-0.28665
569
0.28665
850.77683
1
Correct choice index: 2
Adjusted Gross Margin. Adjusted gross margin represents gross profit plus amortization of acquired intangibles and stock-based compensation. Adjusted gross margin is a measure used by management to understand and evaluate our core operating performance and trends and to generate future operating plans. The exclusion of stock-based compensation expense and amortization of acquired intangibles facilitates comparisons of our operating performance on a period-to-period basis.
In the near term, we expect these expenses to continue to negatively impact our gross profit. Adjusted gross margin is not a measure calculated in accordance with GAAP. We believe that adjusted gross margin provides useful information to investors and others in understanding and evaluating our operating results in the same manner as our management and board of directors.
Nevertheless, our use of adjusted gross margin has limitations as an analytical tool, and you should not consider it in isolation or as a substitute for analysis of our financial results as reported under GAAP. You should consider adjusted gross margin alongside our other GAAP-based financial performance measures, gross profit and our other GAAP financial results. The following table presents a reconciliation of adjusted gross margin to gross profit, the most directly comparable GAAP measure, for each of the periods indicated (in thousands):

Year Ended December 31,
2019
2018
2017
Gross profit
$137,347
$100,284
$72,849
Amortization of acquired intangibles
2,114
1,268
1,614
Stock-based compensation
1,966
2,306
578
Adjusted gross margin
$141,427
$103,858
$75,041


Question: Analyse this data from a financial earnings document. What is the average Gross Profit for 2017-2019?
Choices:
103493.33
10349333.33
5770393573
95079
104853.33
Correct choice index: 0
Overview of 2019
Total revenues for 2019 were $36.0 million, a decrease of $75.0 million, or 68%, versus 2018. The decrease was primarily driven by the $70.9 million decrease in fixed fee license revenue and the $4.0 million decrease in per-unit royalty revenue.
For 2019, we had a net loss of $20.0 million as compared to $54.3 million of net income for 2018. The $74.4 million decrease in net income was mainly related to the $75.0 million decrease in total revenue partially offset by a $0.5 million decrease in cost and operating expenses for 2019 compared to 2018.
We adopted ASC 606, effective January 1, 2018. Consistent with the modified retrospective transaction method, our results of operations for periods prior to the adoption of ASC 606 remain unchanged. As a result, the change in total revenues from 2018 to 2019 included a component of accounting policy change arising from the adoption of ASC 606.
The following table sets forth our consolidated statements of income data as a percentage of total revenues:

Years Ended December 31,
2019
2018
2017
Revenues:     
Fixed fee license revenue
35.1 % 
75.3 % 
36.0 %
Per-unit royalty revenue
64.0
24.3
61.4
Total royalty and license revenue
99.1
99.6
97.4
Development, services, and other
0.9
0.4
2.6
Total revenues
100.0
100.0
100.0
Costs and expenses:
Cost of revenues
0.5
0.2
0.6
Sales and marketing
17.9
5.5
38.6
Research and development
21.8
8.8
33.6
General and administrative
119.4
37.7
152.4
Restructuring costs
—
—
4.6
Total costs and expenses
159.6
52.2
229.8
Operating income (loss)
(59.6)
47.8
(129.8)
Interest and other income
5.0
1.7
1.0
Other expense
0.2
(0.2)
0.9
Income (loss) before provision for income taxes
(54.4)
49.3
(127.9)
Provision for income taxes
(1.3)
(0.4)
(1.4)
Net income (loss)
(55.7)%
48.9 %
(129.3)%


Question: Analyse this data from a financial earnings document. What is the change in Per-unit royalty revenue between 2018 and 2019?
Choices:
-39.7
42.2
39.7
3970
0
Correct choice index: 2
Free cash flow
The Free cash flow for the Industrial Businesses amounted to €8,000 millions, resulting in a cash conversation rate of 0.89.
Beginning with fiscal 2020, Siemens adopts IFRS 16, Leases, applying
the modified retrospective approach as described in more detail in NOTE 2 in B.6 NOTES TO CONSOLIDATED FINANCIAL STATEMENTS. As a result, the shift of lease payments from cash flows from operating activities to cash flows from financing activities will have a positive effect on Free cash flow.
With our ability to generate positive operating cash flows, our total liquidity (defined as cash and cash equivalents plus current interest-bearing debt securities) of €13.7 billion, our unused lines of credit, and our credit ratings at year-end, we believe that we have sufficient flexibility to fund our capital requirements. Also in our opinion, our operating net working capital is sufficient for our present requirements.

Fiscal Year 2019
(in millions of €)
Continuing operations
Discontinued operations
Continuing and discontinued operations
Cash flows from operating activities
8,482
(27)
8,456
Additions to intangible assets and property, plant and equipment
(2,610)
−
(2,610)
Free cash flow
5,872
(27)
5,845


Question: Analyse this data from a financial earnings document. What is the increase / (decrease) of continuing operations compared to the discontinued operations for Additions to intangible assets and property, plant and equipment?
Choices:
8456
5872
-5872
2610
-3235
Correct choice index: 3
five-year performance comparison 2013 the following graph provides an indicator of cumulative total shareholder returns for the corporation as compared to the peer group index ( described above ) , the dj trans , and the s&p 500 .
the graph assumes that $ 100 was invested in the common stock of union pacific corporation and each index on december 31 , 2006 and that all dividends were reinvested .
purchases of equity securities 2013 during 2011 , we repurchased 15340810 shares of our common stock at an average price of $ 96.08 .
the following table presents common stock repurchases during each month for the fourth quarter of 2011 : period total number of shares purchased [a] average price paid per share total number of shares purchased as part of a publicly announced plan or program [b] maximum number of shares that may yet be purchased under the plan or program [b] .

<i>Period</i>
<i>Total Number ofSharesPurchased [a]</i>
<i>AveragePrice PaidPer Share</i>
<i>Total Number of SharesPurchased as Part ofaPublicly Announced Planor Program [b]</i>
<i>Maximum Number ofShares That May Yet</i><i>Be Purchased Under the Planor Program [b]</i>
Oct. 1 through Oct. 31
379,488
87.46
371,639
31,370,427
Nov. 1 through Nov. 30
1,748,964
98.41
1,733,877
29,636,550
Dec. 1 through Dec. 31
1,787,343
100.26
1,780,142
27,856,408
Total
3,915,795
$98.19
3,885,658
N/A

[a] total number of shares purchased during the quarter includes approximately 30137 shares delivered or attested to upc by employees to pay stock option exercise prices , satisfy excess tax withholding obligations for stock option exercises or vesting of retention units , and pay withholding obligations for vesting of retention shares .
[b] on april 1 , 2011 , our board of directors authorized the repurchase of up to 40 million shares of our common stock by march 31 , 2014 .
these repurchases may be made on the open market or through other transactions .
our management has sole discretion with respect to determining the timing and amount of these transactions. .

Question: Analyse this data from a financial earnings document. for the 4th quarter of 2011 approximately how much was spent on stock repurchases?
Choices:
384491911.05
3844919.11
117473850
-384491911.05
15333450482025
Correct choice index: 0
The components of our income tax provision for the years ended December 31, 2019, 2018 and 2017 are as follows (in thousands):
As a result of a loss in a foreign location, we have a net operating loss carry-forward (“NOL”) of approximately $0.3 million
available to offset future income. All $0.3 million of the NOL expires in 2025. We have established a valuation allowance for this
NOL because the ability to utilize it is not more likely than not.
We have tax credit carry-forwards of approximately $5.1 million available to offset future state tax. These tax credit carry-forwards
expire in 2020 to 2029. These credits represent a deferred tax asset of $4.0 million after consideration of the federal benefit of state tax
deductions. A valuation allowance of $1.8 million has been established for these credits because the ability to use them is not more
likely than not.
At December 31, 2019 we had approximately $58.2 million of undistributed earnings and profits. The undistributed earnings and
profits are considered previously taxed income and would not be subject to U.S. income taxes upon repatriation of those earnings, in
the form of dividends. The undistributed earnings and profits are considered to be permanently reinvested, accordingly no provision
for local withholdings taxes have been provided, however, upon repatriation of those earnings, in the form of dividends, we could be
subject to additional local withholding taxes.

Year Ended December 31,   
2019
2018
2017
Current:                         
Federal   
$ 18,682
$ 22,606
$ 53,998
State     
5,711
6,182
6,595
Foreign     
7,323
7,018
6,185
31,716
35,806
66,778
Deferred:                         
Federal     
(863 )    
(3,127 )    
1,590
State     
(326 )    
(674 )    
35
Foreign     
(212 )    
(464 )    
(51 ) 
(1,401 )    
(4,265 )    
1,574
Total  
$ 30,315
$ 31,541
$ 68,352


Question: Analyse this data from a financial earnings document. What is the change in tax payable between 2017 and 2018?
Choices:
-24523
35237
99893
36811
65225
Correct choice index: 3
We do not allocate to our operating segments certain operating expenses that we manage separately at the corporate level and are not used in evaluating the results of, or in allocating resources to, our segments. These unallocated expenses consist primarily of stock-based compensation expense; amortization of intangible assets; restructuring, transition and other costs; and acquisition-related costs.
The following table provides a reconciliation of our total reportable segments’ operating income to our total operating income (loss):

Year Ended
(In millions)
March 29, 2019
March 30, 2018
March 31, 2017
Total segment operating income
$1,414
$1,584
$1,026
Reconciling items:
Stock-based compensation expense
352
610
440
Amortization of intangible assets
443
453
293
Restructuring, transition and other costs
241
410
273
Acquisition-related costs
3
60
120
Other
(5)
2
-
Total consolidated operating income (loss) from continuing operations
$380
$49
$(100)


Question: Analyse this data from a financial earnings document. What is the average  Total consolidated operating income (loss) from continuing operations for the fiscal years 2019, 2018 and 2017?
Choices:
100.33
176.33
1
109.67
159.33
Correct choice index: 3