hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Effect of ASC 606 as of December 31, 2018 and for the Year Ended December 31, 2018
The following table summarizes the effect of adopting ASC 606 on our Consolidated Balance Sheet (in millions):
Table:
 | As reported December 31, 2018 | Effect of ASC 606 adoption | Amounts without adoption of ASC 606 December 31, 2018
Trade receivables, net | $172.3 | $6.9 | $179.2
Prepaid expenses and other current assets | 67.3 | (14.4) | 52.9
Receivables from related parties | 6.2 | 4.8 | 11.0
Computer software, net | 405.6 | (3.7) | 401.9
Deferred contract costs, net | 161.3 | (17.2) | 144.1
Other non-current assets | 125.6 | (7.0) | 118.6
Total assets | 3,653.4 | (30.6) | 3,622.8
Deferred revenues (current) | 52.9 | 4.1 | 57.0
Deferred revenues (non-current) | 106.8 | (4.3) | 102.5
Deferred income taxes | 220.9 | (8.1) | 212.8
Total liabilities | 1,866.9 | (8.3) | 1,858.6
Retained earnings | 381.1 | (22.3) | 358.8
Total equity | 1,786.5 | (22.3) | 1,764.2
Total liabilities and equity | 3,653.4 | (30.6) | 3,622.8


Question: What was total equity as a percentage of total liabilities and equity as reported in 2018?
Answer: 48.9
Calculation: 1,786.5/3,653.4
Note 11: Income Taxes
The provision for income tax expense (benefit) is as follows (amounts in thousands):
(1) Fiscal years ended March 31, 2018 and 2017 adjusted due to the adoption of ASC 606.
The Company realized a deferred tax expense (benefit) for fiscal years ended 2019, 2018 and 2017 of ($50.1) million, $0.6 million and $1.2 million, respectively, in U.S. and certain foreign jurisdictions based on changes in judgment about the realizability of deferred tax assets in future years.
Table:
 |  | Fiscal Years Ended March 31, | 
 | 2019 | 2018 | 2017
Current: |  |  | 
Federal | $170 | $223 | $—
State and local | 161 | 50 | 62
Foreign | 9,966 | 8,295 | 4,247
Total current income tax expense from continuing operations | 10,297 | 8,568 | 4,309
Deferred: |  |  | 
Federal | (43,804) | (807) | (6)
State and local | (773) | (96) | (97)
Foreign (1) | (5,180) | 1,467 | 88
Deferred tax expense (benefit) from continuing operations (1) | (49,757) | 564 | (15)
Provision for income tax expense (benefit) (1) | $(39,460) | $9,132 | $4,294


Question: How much was the deferred tax expense (benefit) in 2017?
Answer: $1.2 million
We engaged with Dell in the following ongoing related party transactions, which resulted in costs to us:
• We purchase and lease products and purchase services from Dell.
• From time to time, we and Dell enter into agreements to collaborate on technology projects, and we pay Dell for services provided to us by Dell related to such projects.
• In certain geographic regions where we do not have an established legal entity, we contract with Dell subsidiaries for support services and support from Dell personnel who are managed by us. The costs incurred by Dell on our behalf related to these employees are charged to us with a mark-up intended to approximate costs that would have been incurred had we contracted for such services with an unrelated third party. These costs are included as expenses on our consolidated statements of income and primarily include salaries, benefits, travel and occupancy expenses. Dell also incurs certain administrative costs on our behalf in the U.S. that are recorded as expenses on our consolidated statements of income.
• In certain geographic regions, Dell files a consolidated indirect tax return, which includes value added taxes and other indirect taxes collected by us from our customers. We remit the indirect taxes to Dell and Dell remits the tax payment to the foreign governments on our behalf.
• From time to time, we invoice end users on behalf of Dell for certain services rendered by Dell. Cash related to these services is collected from the end user by us and remitted to Dell.
• From time to time, we also enter into agency arrangements with Dell that enable us to sell our subscriptions and services, leveraging the Dell enterprise relationships and end customer contracts.
Information about our 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.
We also purchase Dell products through Dell’s channel partners. Purchases of Dell products through Dell’s channel partners were not significant during the periods presented.
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
Expected Future Pension Benefit Payments
Future benefit payments are expected to be paid as follows:
Table:
 | United States | Foreign
 | (in thousands) | 
2020 | $8,027 | $1,237
2021 | 8,416 | 985
2022 | 9,163 | 982
2023 | 9,785 | 1,258
2024 | 10,558 | 1,098
2025-2029 | 59,665 | 6,129


Question: What would the change in Expected Future Pension Benefit Payments under the United States in 2022 from 2021 be?
Answer: 747
Calculation: 9,163-8,416
Note 5. Inventory, Net
The components of inventory, net are as follows (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Raw materials | $8,921 | $6,396
Finished goods | 25,247 | 16,594
Total inventory, net | $34,168 | $22,990


Question: Which years does the table provide information for net inventory?
Answer: 2019, 2018
Item 6. Selected Financial Data
The following table summarizes our selected consolidated financial data for the periods indicated. The selected consolidated financial data should be read in conjunction with our Consolidated Financial Statements and related notes and “Management's Discussion and Analysis of Financial Condition and Results of Operations” appearing elsewhere in this Annual Report on Form 10-K. The selected consolidated statement of income and balance sheet data for each of the five fiscal years indicated below has been derived from our audited Consolidated Financial Statements. Over the last five fiscal years we have acquired a number of companies including, but not limited to Catalyst, Liaison, Hightail, Guidance, Covisint, ECD Business, CCM Business, Recommind, ANX, CEM Business, Daegis, and Actuate. The results of these companies and all of our previously acquired companies have been included herein and have contributed to the growth in our revenues, net income and net income per share and such acquisitions affect period-to-period comparability.
(1) Effective July 1, 2018, we adopted Accounting Standards Codification (ASC) Topic 606 "Revenue from Contracts with Customers" (Topic 606) using the cumulative effect approach. We applied the standard to contracts that were not completed as of the date of the initial adoption. Results for reporting periods commencing on July 1, 2018 are presented under the new revenue standard, while prior period results continue to be reported under the previous standard.
(2) Fiscal 2017 included a significant one-time tax benefit of $876.1 million recorded in the first quarter of Fiscal 2017.
Table:
 |  |  | Fiscal Year Ended June 30, |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
(In thousands, except per share data) |  |  |  |  | 
Statement of Income Data: |  |  |  |  | 
Revenues(1) | $2,868,755 | $2,815,241 | $2,291,057 | $1,824,228 | $1,851,917
Net income, attributable to OpenText(2) | $285,501 | $242,224 | $1,025,659 | $284,477 | $234,327
Net income per share, basic, attributable to OpenText(1) | $1.06 | $0.91 | $4.04 | $1.17 | $0.96
Net income per share, diluted, attributable to OpenText(1) | $1.06 | $0.91 | $4.01 | $1.17 | $0.95
Weighted average number of Common Shares outstanding, basic | 268,784 | 266,085 | 253,879 | 242,926 | 244,184
Weighted average number of Common Shares outstanding, diluted | 269,908 | 267,492 | 255,805 | 244,076 | 245,914


Question: What is the percentage change of Revenues from 2015 to 2019? 
Answer: 54.91
Calculation: (2,868,755-1,851,917)/1,851,917
18 . allowance for credit losses .

Table:
in millions of dollars | 2009 | 2008 ( 1 ) | 2007 ( 1 )
allowance for loan losses at beginning of year | $ 29616 | $ 16117 | $ 8940
gross credit losses | -32784 ( 32784 ) | -20760 ( 20760 ) | -11864 ( 11864 )
gross recoveries | 2043 | 1749 | 1938
net credit ( losses ) recoveries ( ncls ) | $ -30741 ( 30741 ) | $ -19011 ( 19011 ) | $ -9926 ( 9926 )
ncls | $ 30741 | $ 19011 | $ 9926
net reserve builds ( releases ) | 5741 | 11297 | 6550
net specific reserve builds ( releases ) | 2278 | 3366 | 356
total provision for credit losses | $ 38760 | $ 33674 | $ 16832
other net ( 2 ) | -1602 ( 1602 ) | -1164 ( 1164 ) | 271
allowance for loan losses at end of year | $ 36033 | $ 29616 | $ 16117
allowance for credit losses on unfunded lending commitments at beginning of year ( 3 ) | $ 887 | $ 1250 | $ 1100
provision for unfunded lending commitments | 244 | -363 ( 363 ) | 150
allowance for credit losses on unfunded lending commitments at end of year ( 3 ) | $ 1157 | $ 887 | $ 1250
total allowance for loans leases and unfunded lending commitments | $ 37190 | $ 30503 | $ 17367
( 1 ) reclassified to conform to the current period 2019s presentation .
( 2 ) 2009 primarily includes reductions to the loan loss reserve of approximately $ 543 million related to securitizations , approximately $ 402 million related to the sale or transfers to held-for-sale of u.s .
real estate lending loans , and $ 562 million related to the transfer of the u.k .
cards portfolio to held-for-sale .
2008 primarily includes reductions to the loan loss reserve of approximately $ 800 million related to fx translation , $ 102 million related to securitizations , $ 244 million for the sale of the german retail banking operation , $ 156 million for the sale of citicapital , partially offset by additions of $ 106 million related to the cuscatl e1n and bank of overseas chinese acquisitions .
2007 primarily includes reductions to the loan loss reserve of $ 475 million related to securitizations and transfers to loans held-for-sale , and reductions of $ 83 million related to the transfer of the u.k .
citifinancial portfolio to held-for-sale , offset by additions of $ 610 million related to the acquisitions of egg , nikko cordial , grupo cuscatl e1n and grupo financiero uno .
( 3 ) represents additional credit loss reserves for unfunded corporate lending commitments and letters of credit recorded in other liabilities on the consolidated balance sheet. .

Question: what was the percentage change in the allowance for loan losses from 2007 to 2008?
Answer: 80%
Calculation: subtract(16117, 8940), divide(#0, 8940)
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
14. STOCK-BASED COMPENSATION
Summary of Stock-Based Compensation Plans—The Company maintains equity incentive plans that provide for the grant of stock-based awards to its directors, officers and employees. The 2007 Equity Incentive Plan, as amended (the “2007 Plan”), provides for the grant of non-qualified and incentive stock options, as well as restricted stock units, restricted stock and other stock-based awards. Exercise prices for non-qualified and incentive stock options are not less than the fair value of the underlying common stock on the date of grant. Equity awards typically vest ratably, generally over four years for RSUs and stock options and three years for PSUs. Stock options generally expire 10 years from the date of grant. As of December 31, 2019, the Company had the ability to grant stock-based awards with respect to an aggregate of 7.0 million shares of common stock under the 2007 Plan. In addition, the Company maintains an employee stock purchase plan (the “ESPP”) pursuant to which eligible employees may purchase shares of the Company’s common stock on the last day of each bi-annual offering period at a 15% discount from the lower of the closing market value on the first or last day of such offering period. The offering periods run from June 1 through November 30 and from December 1 through May 31 of each year.
During the years ended December 31, 2019, 2018 and 2017, the Company recorded and capitalized the following stock-based compensation expenses:
Table:
 | 2019 | 2018 | 2017
Stock-based compensation expense - Property | $1.8 | $2.4 | $2.1
Stock-based compensation expense - Services | 1.0 | 0.9 | 0.8
Stock-based compensation expense - SG&A | 108.6 | 134.2 | 105.6
Total stock-based compensation expense | $111.4 | $137.5 | $108.5
Stock-based compensation expense capitalized as property and equipment | $1.6 | $2.0 | $1.6


Question: What was the Total stock-based compensation expense in 2017?
Answer: $108.5
On a worldwide basis, the Company's defined benefit pension plans were 88% funded as of January 31, 2019.
As of January 31, 2019, the aggregate accumulated benefit obligation was $85.1 million for the defined benefit pension plans compared to $139.5 million as of January 31, 2018. Included in the aggregate data in the following tables are the amounts applicable to the Company's defined benefit pension plans, with accumulated benefit obligations in excess of plan assets, as well as plans with projected benefit obligations in excess of plan assets. Amounts related to such plans at the end of each period were as follows: because their exercise prices are higher than the average market value of Autodesk’s stock during the fiscal year.
Table:
 | Fiscal Year Ended January 31, | 
 | 2019 | 2018
Plans with accumulated benefit obligations in excess of plan assets: |  | 
Accumulated benefit obligations | $75.6 | $130.7
Plan assets | 70.0 | 112.1
Plans with projected benefit obligations in excess of plan assets: |  | 
Projected benefit obligations | $91.6 | $158.1
Plan assets | 80.8 | 121.1


Question: How much is the percentage change in the projected benefit obligations from 2018 to 2019?
Answer: -42.06
Calculation: ((91.6-158.1)/158.1)
jpmorgan chase & co./2016 annual report 35 five-year stock performance the following table and graph compare the five-year cumulative total return for jpmorgan chase & co . ( 201cjpmorgan chase 201d or the 201cfirm 201d ) common stock with the cumulative return of the s&p 500 index , the kbw bank index and the s&p financial index . the s&p 500 index is a commonly referenced united states of america ( 201cu.s . 201d ) equity benchmark consisting of leading companies from different economic sectors . the kbw bank index seeks to reflect the performance of banks and thrifts that are publicly traded in the u.s . and is composed of leading national money center and regional banks and thrifts . the s&p financial index is an index of financial companies , all of which are components of the s&p 500 . the firm is a component of all three industry indices . the following table and graph assume simultaneous investments of $ 100 on december 31 , 2011 , in jpmorgan chase common stock and in each of the above indices . the comparison assumes that all dividends are reinvested . december 31 , ( in dollars ) 2011 2012 2013 2014 2015 2016 .

Table:
december 31 ( in dollars ) | 2011 | 2012 | 2013 | 2014 | 2015 | 2016
jpmorgan chase | $ 100.00 | $ 136.18 | $ 186.17 | $ 204.57 | $ 221.68 | $ 298.31
kbw bank index | 100.00 | 133.03 | 183.26 | 200.42 | 201.40 | 258.82
s&p financial index | 100.00 | 128.75 | 174.57 | 201.06 | 197.92 | 242.94
s&p 500 index | 100.00 | 115.99 | 153.55 | 174.55 | 176.95 | 198.10
december 31 , ( in dollars ) .

Question: based on the review of the simultaneous investments of the jpmorgan chase common stock and in each of the above indices what was the performance ratio of the jpmorgan chase compared to kbw bank index
Answer: 1.15
Calculation: divide(298.31, 258.82)
Financial risk management
The Group’s treasury function centrally manages the Group’s funding requirement, net foreign exchange exposure, interest rate management exposures and counterparty risk arising from investments and derivatives.
Treasury operations are conducted within a framework of policies and guidelines authorised and reviewed by the Board, most recently in July 2018
A treasury risk committee comprising of the Group’s Chief Financial Officer, Group General Counsel and Company Secretary, Group Financial Controller, Group Treasury Director and Group Director of Financial Controlling and Operations meets three times a year to review treasury activities and its members receive management information relating to treasury activities on a quarterly basis. The Group’s accounting function, which does not report to the Group Treasury Director, provides regular update reports of treasury activity to the Board. The Group’s internal auditor reviews the internal control environment regularly.
The Group uses a number of derivative instruments for currency and interest rate risk management purposes only that are transacted by specialist treasury personnel. The Group mitigates banking sector credit risk by the use of collateral support agreements.
Credit risk
Credit risk is the risk that a counterparty will not meet its obligations under a financial asset leading to a financial loss for the Group. The Group is exposed to credit risk from its operating activities and from its financing activities, the Group considers its maximum exposure to credit risk at 31 March to be:
Expected credit loss
The Group has financial assets classified and measured at amortised cost and fair value through other comprehensive income that are subject to the expected credit loss model requirements of IFRS 9. Cash at bank and in hand and certain other investments are both classified and measured at amortised cost and subject to these impairment requirements. However, the identified expected credit loss is considered to be immaterial.
Information about expected credit losses for trade receivables and contract assets can be found under “operating activities” on page 164.
Table:
 | 2019 €m | 2018 €m
Cash at bank and in hand | 2,434 | 2,197
Repurchase agreements and bank deposits | 2,196 | –
Money market funds | 9,007 | 2,477
Managed investment funds | 6,405 | 3,891
Government securities | 3,011 | 1,974
Other investments | 4,418 | 6,087
Derivative financial instruments | 3,634 | 2,629
Trade receivables | 5,077 | 5,402
Contract assets and other receivables | 5,155 | 3,410
 | 41,337 | 28,067


Question: How much is 2018 cash at bank and in hand ?
Answer: 2,197
Our net sales by offering category for North America for 2019 and 2018, were as follows (dollars
in thousands):
Net sales in North America increased 12%, or $661.3 million, in 2019 compared to 2018. This increase reflects the addition of PCM, which reported $716.1 million in net sales in 2019, partially offset by a decline in net sales of the core business of $51.3 million. Net sales of hardware, software and services increased 10%, 14% and 25%, respectively, year over year.
Table:
 | North America |  | 
SalesMix | 2019 | 2018 | %Change
Hardware | $3,957,507 | $3,610,356 | 10%
Software | 1,269,983 | 1,112,715 | 14%
Services | 796,815 | 639,910 | 25%
 | $6,024,305 | $5,362,981 | 12%


Question: What is the change in Sales Mix of Software between 2018 and 2019?
Answer: 157268
Calculation: 1,269,983-1,112,715
net impairment we recognized $ 14.9 million of net impairment during the year ended december 31 , 2011 , on certain securities in our non-agency cmo portfolio due to continued deterioration in the expected credit performance of the underlying loans in those specific securities . the gross other-than-temporary impairment ( 201cotti 201d ) and the noncredit portion of otti , which was or had been previously recorded through other comprehensive income , are shown in the table below ( dollars in millions ) : year ended december 31 , 2011 2010 .

Table:
 | year ended december31 2011 | 2010
other-than-temporary impairment ( 201cotti 201d ) | $ -9.2 ( 9.2 ) | $ -41.5 ( 41.5 )
less : noncredit portion of otti recognized into ( out of ) other comprehensive income ( loss ) ( before tax ) | -5.7 ( 5.7 ) | 3.8
net impairment | $ -14.9 ( 14.9 ) | $ -37.7 ( 37.7 )
other revenues other revenues decreased 15% ( 15 % ) to $ 39.3 million for the year ended december 31 , 2011 compared to 2010 .
the decrease was due primarily to the gain on sale of approximately $ 1 billion in savings accounts to discover financial services in the first quarter of 2010 , which increased other revenues during the year ended december 31 , 2010 .
provision for loan losses provision for loan losses decreased 43% ( 43 % ) to $ 440.6 million for the year ended december 31 , 2011 compared to 2010 .
the decrease in provision for loan losses was driven by improving credit trends and loan portfolio run-off , as evidenced by the lower levels of delinquent loans in the one- to four-family and home equity loan portfolios .
the provision for loan losses has declined for three consecutive years , down 72% ( 72 % ) from its peak of $ 1.6 billion for the year ended december 31 , 2008 .
we expect provision for loan losses to continue to decline in 2012 compared to 2011 , although it is subject to variability from quarter to quarter .
as we transition from the ots to the occ , we are evaluating programs and practices that were designed in accordance with guidance from the ots .
we are working to align certain policies and procedures to the guidance from the occ and have suspended certain loan modification programs that will require changes .
we increased the qualitative reserve in 2011 to reflect additional estimated losses during the period of reduced activity in our modification programs , as well as uncertainty around certain loans modified under our previous programs .
once the evaluation of the existing programs and practices is complete and any necessary changes have been implemented , we will re-assess the overall qualitative reserve. .

Question: as december 312011 what was the amount of the provision for impairment in billion
Answer: 1.152
Calculation: multiply(1.6, 72%)
Allocation of Goodwill to Reporting Segment
The following table shows our goodwill balances by reportable segment:
As noted above, it was determined under a quantitative assessment that there was no impairment of goodwill. However, if we become aware of indicators of impairment in future periods, we may be required to perform an interim assessment for some or all of our reporting units before the next annual assessment. Examples of such indicators may include a decrease in expected net earnings, adverse equity market conditions, a decline in current market multiples, a decline in our common stock price, a significant adverse change in legal factors or business climates, an adverse action or assessment by a regulator, unanticipated competition, strategic decisions made in response to economic or competitive conditions, or a more likely than not expectation that a reporting unit or a significant portion of a reporting unit will be sold or disposed of. In the event of significant adverse changes of the nature described above, we may have to recognize a non-cash impairment of goodwill, which could have a material adverse effect on our consolidated financial condition and results of operations.
Table:
(In millions) | Food Care | Product Care | Total
Gross Carrying Value at December 31, 2017 | $ 576.5 | $ 1,554.1 | $ 2,130.6
Accumulated impairment | (49.6 ) | (141.2) | (190.8)
Carrying Value at December 31, 2017 | $ 526.9 | $ 1,412.9 | $ 1,939.8
Acquisition, purchase price and other adjustments | (0.6 ) | 18.2 | 17.6
Currency translation | (6.6 ) | (3.2) | (9.8)
Gross Carrying Value at December 31, 2018 | $ 568.9 | $ 1,568.9 | $ 2,137.8
Accumulated impairment | (49.2 ) | (141.0) | (190.2)
Carrying Value at December 31, 2018 | $ 519.7 | $ 1,427.9 | $ 1,947.6
Acquisition, purchase price and other adjustments | 6.3 | 257.0 | 263.3
Currency translation | 2.0 | 4.1 | 6.1
Gross Carrying Value at December 31, 2019 | $ 577.2 | $ 1,830.0 | $ 2,407.2
Accumulated impairment | (49.3 ) | (141.0) | (190.3)
Carrying Value at December 31, 2019 | $ 527.9 | $ 1,689.0 | $ 2,216.9


Question: What does the table show?
Answer: shows our goodwill balances by reportable segment