hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Information about VMware’s payments for such arrangements during the periods presented consisted of the following (table in millions):
1) Amount includes indirect taxes that were remitted to Dell during the periods presented.
VMware also purchases Dell products through Dell’s channel partners. Purchases of Dell products through Dell’s channel partners were not significant during the periods presented.
From time to time, VMware and Dell also enter into joint marketing, sales, branding and product development arrangements, for which both parties may incur costs.
During the fourth quarter of fiscal 2020, VMware entered into an arrangement with Dell to transfer approximately 250 professional services employees from Dell to VMware. These employees are experienced in providing professional services delivering VMware technology and this transfer centralizes these resources within the Company in order to serve its customers more efficiently and effectively. The transfer was substantially completed during the fourth quarter of fiscal 2020 and did not have a material impact to the consolidated financial statements. VMware also expects that Dell will resell VMware consulting solutions.
During the third quarter of fiscal 2019, VMware acquired technology and employees related to the Dell EMC Service Assurance Suite, which provides root cause analysis management software for communications service providers, from Dell. The purchase of the Dell EMC Service Assurance Suite was accounted for as a transaction by entities under common control. The amount of the purchase price in excess of the historical cost of the acquired assets was recognized as a reduction to retained earnings on the consolidated balance sheets. Transition services were provided by Dell over a period of 18 months, starting from the date of the acquisition, which were not significant.
During the second quarter of fiscal 2018, VMware acquired Wavefront, Inc. (“Wavefront”). Upon closing of the acquisition, Dell was paid $20 million in cash for its non-controlling ownership interest in Wavefront.
Table:
 |  | For the Year Ended | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Purchases and leases of products and purchases of services(1) | $242 | $200 | $142
Dell subsidiary support and administrative costs | 119 | 145 | 212


Question: What was the change in Purchases and leases of products and purchases of services between 2018 and 2019?
Answer: 58
Calculation: 200-142
(3) Accounts Receivable, Net
Accounts receivable, net, is as follows (in thousands):
Bad debt expense for the years ended December 31, 2019, 2018 and 2017 was $0.7 million, $0.1 million and $0.6 million, respectively.
Table:
 | As of December 31, | 
 | 2019 | 2018
Accounts receivable | $69,767 | $41,818
Allowance for doubtful accounts | (1,125) | (711)
Net accounts receivable | $68,642 | $41,107


Question: How much was the Bad debt expense for the years ended December 31, 2018?
Answer: $0.1 million
allowance for doubtful accounts is as follows: .

Table:
 | 2010 | 2009 | 2008
balance at beginning of year | $ 160 | $ 133 | $ 86
provision | 38 | 54 | 65
amounts written off | -13 ( 13 ) | -27 ( 27 ) | -18 ( 18 )
balance at end of year | $ 185 | $ 160 | $ 133
discontinued operations during the fourth quarter of 2009 , schlumberger recorded a net $ 22 million charge related to the resolution of a customs assessment pertaining to its former offshore contract drilling business , as well as the resolution of certain contingencies associated with other previously disposed of businesses .
this amount is included in income ( loss ) from discontinued operations in the consolidated statement of income .
during the first quarter of 2008 , schlumberger recorded a gain of $ 38 million related to the resolution of a contingency associated with a previously disposed of business .
this gain is included in income ( loss ) from discon- tinued operations in the consolidated statement of income .
part ii , item 8 .

Question: what was the net change in the allowance in doubtful accounts in 2009
Answer: 27
Calculation: add(54, -27)
In the first quarter of 2019, the Company determined that certain revenue in the IT Services and Hardware segment associated with nonrecurring projects is better aligned with Infrastructure Solutions, rather than Consulting, where it was previously reported.  As a result, the Company reclassed revenue of $26.6 million and $12.3 million from Consulting to Infrastructure Solutions for the twelve months ended December 31, 2018 and 2017, respectively.  This reclassification of revenue had no impact on the Consolidated Statements of Operations
The following table presents revenues disaggregated by contract type
Table:
Year ended December 31, |  |  | 
(dollars in millions) | 2019 | 2018 | 2017
Entertainment and Communications |  |  | 
Products and services transferred at a point in time | $31.7 | $25.3 | $20.6
Products and services transferred over time | 942.4 | 805.8 | 664.3
Intersegment revenue | 21.6 | 22.3 | 21.2
Total Entertainment and Communications | 995.7 | 853.4 | 706.1
IT Services and Hardware |  |  | 
Products and services transferred at a point in time | 138.7 | 142.9 | 80.8
Products and services transferred over time | 423.9 | 404.2 | 300.0
Intersegment revenue | 4.8 | 3.8 | 4.3
Total IT Services and Hardware | 567.4 | 550.9 | 385.1
Total Revenue |  |  | 
Total products and services transferred at a point in time | 170.4 | 168.2 | 101.4
Total products and services transferred over time | 1,366.3 | 1210.0 | 964.3
Total revenue | $1,536.7 | $1,378.2 | $1,065.7


Question: What is the total revenue between 2017 to 2019?
Answer: 3980.6
Calculation: 1,536.7+1,378.2+1,065.7
DEVELOPMENT OF GROSS DOMESTIC PRODUCT IN IMPORTANT WORLD REGIONS AND GERMANY
Year-on-year change in %
Real GDP growth corrected for purchasing power. Source: Oxford Economics
1 The previous year’s figures may slightly deviate from the Annual Report 2017/18, since retrospective corrections are being made by the data provider.
2 Outlook.
Table:
 | 20181 | 20192
World | 3.6 | 2.9
Germany | 1.5 | 0.6
Western Europe (excl.Germany) | 1.9 | 1.3
Russia | 2.3 | 1.1
Eastern Europe (excl.Russia) | 4.1 | 3.6
Asia | 5.6 | 4.9


Question: Which regions in the table are listed in the analysis of GDP?
Answer: World, Germany, Western Europe (excl.Germany), Russia, Eastern Europe (excl.Russia), Asia
(c) Summary of Share-Based Compensation Expense
Share-based compensation expense consists primarily of expenses for stock options, stock purchase rights, restricted stock, and RSUs granted to employees. The following table summarizes share-based compensation expense (in millions):
As of July 27, 2019, the total compensation cost related to unvested share-based awards not yet recognized was $3.3 billion, which is expected to be recognized over approximately 2.8 years on a weighted-average basis.
Table:
Years Ended | July 27, 2019 | July 28, 2018 | July 29, 2017
Cost of sales—product | $90 | $94 | $85
Cost of sales—service | 130 | 133 | 134
Share-based compensation expense in cost of sales . | 220 | 227 | 219
Research and development . | 540 | 538 | 529
Sales and marketing | 519 | 555 | 542
General and administrative | 250 | 246 | 236
Restructuring and other charges | 62 | 33 | 3
Share-based compensation expense in operating expenses | 1,371 | 1,372 | 1,310
Total share-based compensation expense | $1,591 | $1,599 | $1,529
Income tax benefit for share-based compensation . | $542 | $558 | $451


Question: What was the change in the product cost of sales between 2017 and 2018?
Answer: 9
Calculation: 94-85
Non-Management Director Compensation in Fiscal 2019
The non-management directors received the following compensation during fiscal 2019:
(1) This column represents the fair value of the stock award on the grant date determined in accordance with the provisions of ASC 718. As per SEC rules relating to executive compensation disclosure, the amounts shown exclude the impact of forfeitures related to service based vesting conditions. For additional information regarding assumptions made in calculating the amount reflected in this column, please refer to Note 10 to our audited consolidated financial statements, included in our Annual Report on Form 10-K for fiscal 2019.
(2) Dividend equivalent payments on unvested restricted stock.
Table:
Name | Fees Earned or Paid in Cash ($) | Stock Awards ($) (1) | Option Awards ($) | All Other Compensation ($) (2) | Total ($)
Robert D. Rosenthal | 95,000 | 40,000 | - | 25,900 | 160,900
Chad M. Lindbloom | 95,00 | 40,000 | - | 13,800 | 148,800
Paul S. Pearlman | 65,000 | 40,000 | - | 850 | 105,850
Lawrence Reinhold | 65,000 | 40,000 | - | 850 | 105,850


Question: What is the total compensation received by Paul S. Pearlman and Lawrence Reinhold respectively during fiscal 2019?
Answer: 105,850, 105,850
12 . brokerage receivables and brokerage payables citi has receivables and payables for financial instruments sold to and purchased from brokers , dealers and customers , which arise in the ordinary course of business . citi is exposed to risk of loss from the inability of brokers , dealers or customers to pay for purchases or to deliver the financial instruments sold , in which case citi would have to sell or purchase the financial instruments at prevailing market prices . credit risk is reduced to the extent that an exchange or clearing organization acts as a counterparty to the transaction and replaces the broker , dealer or customer in question . citi seeks to protect itself from the risks associated with customer activities by requiring customers to maintain margin collateral in compliance with regulatory and internal guidelines . margin levels are monitored daily , and customers deposit additional collateral as required . where customers cannot meet collateral requirements , citi may liquidate sufficient underlying financial instruments to bring the customer into compliance with the required margin level . exposure to credit risk is impacted by market volatility , which may impair the ability of clients to satisfy their obligations to citi . credit limits are established and closely monitored for customers and for brokers and dealers engaged in forwards , futures and other transactions deemed to be credit sensitive . brokerage receivables and brokerage payables consisted of the following: .

Table:
in millions of dollars | december 31 , 2017 | december 31 , 2016
receivables from customers | $ 19215 | $ 10374
receivables from brokers dealers and clearing organizations | 19169 | 18513
total brokerage receivables ( 1 ) | $ 38384 | $ 28887
payables to customers | $ 38741 | $ 37237
payables to brokers dealers and clearing organizations | 22601 | 19915
total brokerage payables ( 1 ) | $ 61342 | $ 57152
payables to brokers , dealers and clearing organizations 22601 19915 total brokerage payables ( 1 ) $ 61342 $ 57152 ( 1 ) includes brokerage receivables and payables recorded by citi broker- dealer entities that are accounted for in accordance with the aicpa accounting guide for brokers and dealers in securities as codified in asc 940-320. .

Question: as of december 31 2017 what is the ratio of receivables from brokers dealers and clearing organizations to payables to brokers dealers and clearing organizations?
Answer: .85
Calculation: divide(19169, 22601)
4.2 Equity (continued)
Share buy-back
A buy-back is the purchase by a company of its existing shares. Refer to note 4.3 for further details.
Share-based payment reserve
This reserve records the value of shares under the Long Term Incentive Plan, and historical Employee and CEO Share Option plans offered to the CEO, Executives and employees as part of their remuneration. Refer to note 5.2 for further details of these plans.
Business combination reserve
The internal group restructure performed in the 2007 financial year, which interposed the holding company, iSelect Limited, into the consolidated group was exempted by AASB 3 Business Combinations as it precludes entities or businesses under common control. The carry-over basis method of accounting was used for the restructuring of the iSelect Group. As such, the assets and liabilities were reflected at their carrying amounts. No adjustments were made to reflect fair values, or recognise any new assets or liabilities. No goodwill was recognised as a result of the combination and any difference between the consideration paid and the ‘equity’ acquired was reflected within equity as an equity reserve titled “Business Combination Reserve”.
Foreign currency translation reserve
Refer to Note 1.5 for further details.
Table:
 | CONSOLIDATED | 
 | 2019 $’000 | 2018 $’000
Reserves |  | 
Share-based payment reserve | 3,960 | 3,198
Business combination reserve | 5,571 | 5,571
Foreign currency translation reserve | (12) | (24)
 | 9,519 | 8,745


Question: What are the components of reserves?
Answer: Share-based payment reserve, Business combination reserve, Foreign currency translation reserve
The following table summarizes activity for the interest rate swap:
There were no transfers between Level 1, Level 2 or Level 3 fair value hierarchy categories of financial instruments in the years ended December 31, 2019 and 2018.
Financial Instruments Not Recorded at Fair Value on a Recurring Basis
Some of the Company’s financial instruments are not measured at fair value on a recurring basis but are recorded at amounts that approximate fair value due to their liquid or short-term nature. Such financial assets and financial liabilities include: cash and cash equivalents, restricted cash, net receivables, certain other assets, accounts payable, accrued price protection liability, accrued expenses, accrued compensation costs, and other current liabilities. The Company’s long-term debt is not recorded at fair value on a recurring basis, but is measured at fair value for disclosure purposes (Note8 ).
Table:
 | Fair Value at December 31, | 
 | 2019 | 2018
 | (in thousands) | 
Interest rate swap |  | 
Beginning balance | $1,623 | $734
Unrealized gain (loss) recognized in other comprehensive income (loss) | (1,660) | 889
Ending balance | $(37) | 1,623


Question: How is the company's long-term debt recorded?
Answer: measured at fair value for disclosure purposes (Note8 )
Item 2. PROPERTIES
We operate 31 distributions centers located in the United States and Canada totaling approximately 1.7 million square feet. We own a 59,500 square foot distribution center in Cincinnati, Ohio and a 10,000 square foot protein processing facility and distribution center in Chicago, Illinois. All of our other properties are leased. The following table sets forth our distribution, protein processing, corporate and other support facilities by state or province and their approximate aggregate square footage as of February 21, 2020 (1).
(1)  Excludes the impact of our recent acquisitions of Sid Wainer & Son and Cambridge Packing Co, Inc. more fully described in 'Management's Discussion and Financial Condition and Results of Operations — Overview and Recent Developments."
(2)  Represents our corporate headquarters in Ridgefield, Connecticut.
We consider our properties to be in good condition generally and believe our facilities are adequate for our operations and provide sufficient capacity to meet our anticipated requirements.
Table:
State / Province | Number of Facilities | Aggregate Size
California | 10 | 618,900
New York | 1 | 231,100
Texas | 3 | 214,300
Illinois | 3 | 144,200
Ohio | 2 | 120,400
Maryland | 3 | 115,300
Nevada | 1 | 74,000
Oregon | 1 | 55,500
Ontario | 1 | 51,300
Florida | 2 | 48,300
New Jersey | 1 | 38,400
Connecticut(2) | 1 | 29,200
British Columbia | 1 | 24,900
Alberta | 2 | 16,500
Arizona | 1 | 14,500
Washington | 1 | 10,500
Total | 34 | 1,807,300


Question: What is the number of facilities in Texas and Illinois respectively?
Answer: 3, 3
(5) Earnings Per Share
Basic earnings per share is computed by dividing Net earnings attributable to Black Knight by the weighted-average number of shares of common stock outstanding during the period.
For the periods presented, potentially dilutive securities include unvested restricted stock awards and the shares of BKFS Class B common stock prior to the Distribution. For the year ended December 31, 2017, the numerator in the diluted net earnings per share calculation is adjusted to reflect our income tax expense at an expected effective tax rate assuming the conversion of the shares of BKFS Class B common stock into shares of BKFS Class A common stock on a one-for-one basis prior to the Distribution. The effective tax rate for the year ended December 31, 2017 was (16.7)%, including the effect of the benefit related to the revaluation of our net deferred income tax liability and certain other discrete items recorded during 2017. For the year ended December 31, 2017, the denominator includes approximately 63.1 million shares of BKFS Class B common stock outstanding prior to the Distribution. The denominator also includes the dilutive effect of approximately 0.9 million, 0.6 million and 0.6 million shares of unvested restricted shares of common stock for the years ended December 31, 2019, 2018 and 2017, respectively.
The shares of BKFS Class B common stock did not share in the earnings or losses of Black Knight and were, therefore, not participating securities. Accordingly, basic and diluted net earnings per share of BKFS Class B common stock have not been presented.
The computation of basic and diluted earnings per share is as follows (in millions, except per share amounts):
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Basic: |  |  | 
Net earnings attributable to Black Knight | $108.8 | $168.5 | $182.3
Shares used for basic net earnings per share: |  |  | 
Weighted average shares of common stock outstanding | 147.7 | 147.6 | 88.7
Basic net earnings per share | $0.74 | $1.14 | $2.06
Diluted: |  |  | 
Earnings before income taxes and equity in losses of unconsolidated affiliates |  |  | $192.4
Income tax benefit excluding the effect of noncontrolling interests |  |  | (32.2)
Net earnings |  |  | $224.6
Net earnings attributable to Black Knight | $108.8 | $168.5 | 
Shares used for diluted net earnings per share: |  |  | 
Weighted average shares of common stock outstanding | 147.7 | 147.6 | 88.7
Dilutive effect of unvested restricted shares of common |  |  | 
stock | 0.9 | 0.6 | 0.6
Weighted average shares of BKFS Class B common stock outstanding | — | — | 63.1
Weighted average shares of common stock, diluted | 148.6 | 148.2 | 152.4
Diluted net earnings per share | $0.73 | $1.14 | $1.47


Question: What were the basic Net earnings attributable to Black Knight in 2017?
Answer: 182.3
The following table reconciles the expected income tax expense, computed by applying our combined German tax rate of 26.4% (2018: 26.4%; 2017: 26.4%), to the actual income tax expense. Our 2019 combined German tax rate includes a corporate income tax rate of 15.0% (2018: 15.0%; 2017: 15.0%), plus a solidarity surcharge of 5.5% (2018: 5.5%; 2017: 5.5%) thereon, and trade taxes of 10.6% (2018: 10.6%; 2017: 10.6%).
Relationship Between Tax Expense and Profit Before Tax
Table:
€ millions, unless otherwise stated | 2019 | 2018 | 2017
Profit before tax | 4,596 | 5,600 | 5,029
Tax expense at applicable tax rate of 26.4% rate of 26.4% (2018: 26.4%; 2017: 26.4%) | 1,212 | 1,478 | 1,327
Tax effect of: |  |  | 
Foreign tax rates | –209 | –147 | –403
Changes in tax laws and tax rates | 10 | 0 | –212
Non-deductible expenses | 116 | 106 | 82
Tax-exempt income | –93 | –38 | –95
Withholding taxes | 138 | 91 | 131
Research and development and foreign tax credits | –89 | –33 | –26
Prior-year taxes | 80 | –17 | –26
Reassessment of deferred tax assets, research and development tax credits, and foreign tax credits | 48 | 58 | 185
Other | 13 | 13 | 20
Total income tax expense | 1,226 | 1,511 | 983
Effective tax rate (in %) | 26.7 | 27.0 | 19.5


Question: What was the change in Other in 2019 from 2018?
Answer: 0
Calculation: 13-13
( 1 ) includes shares repurchased through our publicly announced share repurchase program and shares tendered to pay the exercise price and tax withholding on employee stock options . 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 s&p 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 , 2004 in the s&p 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 2004 20092008200720062005 s&p 500 ups dj transport .

Table:
 | 12/31/04 | 12/31/05 | 12/31/06 | 12/31/07 | 12/31/08 | 12/31/09
united parcel service inc . | $ 100.00 | $ 89.49 | $ 91.06 | $ 87.88 | $ 70.48 | $ 75.95
s&p 500 index | $ 100.00 | $ 104.91 | $ 121.48 | $ 128.15 | $ 80.74 | $ 102.11
dow jones transportation average | $ 100.00 | $ 111.65 | $ 122.61 | $ 124.35 | $ 97.72 | $ 115.88
.

Question: what is the roi of an investment in s&p500 in 2004 and sold in 2006?
Answer: 21.5%
Calculation: subtract(121.48, const_100), divide(#0, const_100)
vornado realty trust notes to consolidated financial statements ( continued ) 10 . redeemable noncontrolling interests - continued redeemable noncontrolling interests on our consolidated balance sheets are recorded at the greater of their carrying amount or redemption value at the end of each reporting period . changes in the value from period to period are charged to 201cadditional capital 201d in our consolidated statements of changes in equity . below is a table summarizing the activity of redeemable noncontrolling interests . ( amounts in thousands ) .

Table:
balance at december 31 2008 | $ 1177978
net income | 25120
distributions | -42451 ( 42451 )
conversion of class a units into common shares at redemption value | -90955 ( 90955 )
adjustment to carry redeemable class a units at redemption value | 167049
other net | 14887
balance at december 31 2009 | $ 1251628
net income | 55228
distributions | -53515 ( 53515 )
conversion of class a units into common shares at redemption value | -126764 ( 126764 )
adjustment to carry redeemable class a units at redemption value | 191826
redemption of series d-12 redeemable units | -13000 ( 13000 )
other net | 22571
balance at december 31 2010 | $ 1327974
as of december 31 , 2010 and 2009 , the aggregate redemption value of redeemable class a units was $ 1066974000 and $ 971628000 , respectively .
redeemable noncontrolling interests exclude our series g convertible preferred units and series d-13 cumulative redeemable preferred units , as they are accounted for as liabilities in accordance with asc 480 , distinguishing liabilities and equity , because of their possible settlement by issuing a variable number of vornado common shares .
accordingly the fair value of these units is included as a component of 201cother liabilities 201d on our consolidated balance sheets and aggregated $ 55097000 and $ 60271000 as of december 31 , 2010 and 2009 , respectively. .

Question: what was the percentage change in the redeemable non controlling interests balance at december 31 2009 from 2008
Answer: 6.3%
Calculation: subtract(1251628, 1177978), divide(#0, 1177978)