HangHor/FinQA_Normalized_ALL huggingface dataset:
movement in exit cost liabilities the movement in exit cost liabilities for pmi was as follows : ( in millions ) .
[['liability balance january 1 2014', '$ 308'], ['charges net', '391'], ['cash spent', '-360 ( 360 )'], ['currency/other', '-69 ( 69 )'], ['liability balance december 31 2014', '$ 270'], ['charges net', '68'], ['cash spent', '-232 ( 232 )'], ['currency/other', '-52 ( 52 )'], ['liability balance december 31 2015', '$ 54']]
cash payments related to exit costs at pmi were $ 232 million , $ 360 million and $ 21 million for the years ended december 31 , 2015 , 2014 and 2013 , respectively .future cash payments for exit costs incurred to date are expected to be approximately $ 54 million , and will be substantially paid by the end of 2017 .the pre-tax asset impairment and exit costs shown above are primarily a result of the following : the netherlands on april 4 , 2014 , pmi announced the initiation by its affiliate , philip morris holland b.v .( 201cpmh 201d ) , of consultations with employee representatives on a proposal to discontinue cigarette production at its factory located in bergen op zoom , the netherlands .pmh reached an agreement with the trade unions and their members on a social plan and ceased cigarette production on september 1 , 2014 .during 2014 , total pre-tax asset impairment and exit costs of $ 489 million were recorded for this program in the european union segment .this amount includes employee separation costs of $ 343 million , asset impairment costs of $ 139 million and other separation costs of $ 7 million .separation program charges pmi recorded other pre-tax separation program charges of $ 68 million , $ 41 million and $ 51 million for the years ended december 31 , 2015 , 2014 and 2013 , respectively .the 2015 other pre-tax separation program charges primarily related to severance costs for the organizational restructuring in the european union segment .the 2014 other pre-tax separation program charges primarily related to severance costs for factory closures in australia and canada and the restructuring of the u.s .leaf purchasing model .the 2013 pre-tax separation program charges primarily related to the restructuring of global and regional functions based in switzerland and australia .contract termination charges during 2013 , pmi recorded exit costs of $ 258 million related to the termination of distribution agreements in eastern europe , middle east & africa ( due to a new business model in egypt ) and asia .asset impairment charges during 2014 , pmi recorded other pre-tax asset impairment charges of $ 5 million related to a factory closure in canada. .

Question: what was the difference in cash payments related to exit costs at pmi from 2013 to 2014 in millions?
Answer: 339
table of contents company stock performance the following graph shows a comparison of cumulative total shareholder return , calculated on a dividend reinvested basis , for the company , the s&p 500 index , the s&p information technology index and the dow jones u.s .technology supersector index for the five years ended september 26 , 2015 .the graph assumes $ 100 was invested in each of the company 2019s common stock , the s&p 500 index , the s&p information technology index and the dow jones u.s .technology supersector index as of the market close on september 24 , 2010 .note that historic stock price performance is not necessarily indicative of future stock price performance .* $ 100 invested on 9/25/10 in stock or index , including reinvestment of dividends .data points are the last day of each fiscal year for the company 2019scommon stock and september 30th for indexes .copyright a9 2015 s&p , a division of mcgraw hill financial .all rights reserved .copyright a9 2015 dow jones & co .all rights reserved .september september september september september september .
[['', 'september 2010', 'september 2011', 'september 2012', 'september 2013', 'september 2014', 'september 2015'], ['apple inc .', '$ 100', '$ 138', '$ 229', '$ 170', '$ 254', '$ 294'], ['s&p 500 index', '$ 100', '$ 101', '$ 132', '$ 157', '$ 188', '$ 187'], ['s&p information technology index', '$ 100', '$ 104', '$ 137', '$ 147', '$ 190', '$ 194'], ['dow jones u.s . technology supersector index', '$ 100', '$ 103', '$ 134', '$ 141', '$ 183', '$ 183']]
apple inc .| 2015 form 10-k | 21 .

Question: what was the change in the s&p 500 index between 2010 and 2015?
Answer: 87
14 .accounting for certain long-lived assets eog reviews its proved oil and gas properties for impairment purposes by comparing the expected undiscounted future cash flows at a depreciation , depletion and amortization group level to the unamortized capitalized cost of the asset .the carrying rr values for assets determined to be impaired were adjusted to estimated fair value using the income approach described in the fair value measurement topic of the asc .in certain instances , eog utilizes accepted offers from third-party purchasers as the basis for determining fair value .during 2017 , proved oil and gas properties with a carrying amount of $ 370 million were written down to their fair value of $ 146 million , resulting in pretax impairment charges of $ 224 million .during 2016 , proved oil and gas properties with a carrying rr amount of $ 643 million were written down to their fair value of $ 527 million , resulting in pretax impairment charges of $ 116 million .impairments in 2017 , 2016 and 2015 included domestic legacy natural gas assets .amortization and impairments of unproved oil and gas property costs , including amortization of capitalized interest , were $ 211 million , $ 291 million and $ 288 million during 2017 , 2016 and 2015 , respectively .15 .asset retirement obligations the following table presents the reconciliation of the beginning and ending aggregate carrying amounts of short-term and long-term legal obligations associated with the retirement of property , plant and equipment for the years ended december 31 , 2017 and 2016 ( in thousands ) : .
[['', '2017', '2016'], ['carrying amount at beginning of period', '$ 912926', '$ 811554'], ['liabilities incurred ( 1 )', '54764', '212739'], ['liabilities settled ( 2 )', '-61871 ( 61871 )', '-94800 ( 94800 )'], ['accretion', '34708', '32306'], ['revisions', '-9818 ( 9818 )', '-38286 ( 38286 )'], ['foreign currency translations', '16139', '-10587 ( 10587 )'], ['carrying amount at end of period', '$ 946848', '$ 912926'], ['current portion', '$ 19259', '$ 18516'], ['noncurrent portion', '$ 927589', '$ 894410']]
( 1 ) includes $ 164 million in 2016 related to yates transaction ( see note 17 ) .( 2 ) includes settlements related to asset sales .the current and noncurrent portions of eog's asset retirement obligations are included in current liabilities - other and other liabilities , respectively , on the consolidated balance sheets. .

Question: considering the years 2016 and 2017 , what is the increase observed in accretion?
Answer: 7.435%
Explanation: it is the 2017's accretion divided by the 2016's , then subtracted 1 and turned into a percentage .
sources and uses of cash ( in millions ) in summary , our cash flows for each period were as follows : years ended ( in millions ) dec 29 , dec 30 , dec 31 .
[['years ended ( in millions )', 'dec 292018', 'dec 302017', 'dec 312016'], ['net cash provided by operating activities', '$ 29432', '$ 22110', '$ 21808'], ['net cash used for investing activities', '-11239 ( 11239 )', '-15762 ( 15762 )', '-25817 ( 25817 )'], ['net cash provided by ( used for ) financing activities', '-18607 ( 18607 )', '-8475 ( 8475 )', '-5739 ( 5739 )'], ['net increase ( decrease ) in cash and cash equivalents', '$ -414 ( 414 )', '$ -2127 ( 2127 )', '$ -9748 ( 9748 )']]
md&a consolidated results and analysis 40 .

Question: what was the percentage change in net cash provided by operating activities between 2016 and 2017?
Answer: 1%
the following table provides the weighted average assumptions used in the black-scholes option-pricing model for grants and the resulting weighted average grant date fair value per share of stock options granted for the years ended december 31: .
[['', '2018', '2017', '2016'], ['intrinsic value', '$ 9', '$ 10', '$ 18'], ['exercise proceeds', '7', '11', '15'], ['income tax benefit realized', '2', '3', '6']]
stock units during 2018 , 2017 and 2016 , the company granted rsus to certain employees under the 2007 plan and 2017 omnibus plan , as applicable .rsus generally vest based on continued employment with the company over periods ranging from one to three years. .

Question: by how much did the intrinsic value decrease from 2016 to 2018?
Answer: -50.0%
stock performance graph the following performance graph compares the cumulative total return ( including dividends ) to the holders of our common stock from december 31 , 2002 through december 31 , 2007 , with the cumulative total returns of the nyse composite index , the ftse nareit composite reit index ( the 201call reit index 201d ) , the ftse nareit healthcare equity reit index ( the 201chealthcare reit index 201d ) and the russell 1000 index over the same period .the comparison assumes $ 100 was invested on december 31 , 2002 in our common stock and in each of the foregoing indices and assumes reinvestment of dividends , as applicable .we have included the nyse composite index in the performance graph because our common stock is listed on the nyse .we have included the other indices because we believe that they are either most representative of the industry in which we compete , or otherwise provide a fair basis for comparison with ventas , and are therefore particularly relevant to an assessment of our performance .the figures in the table below are rounded to the nearest dollar. .
[['', '12/31/2002', '12/31/2003', '12/31/2004', '12/31/2005', '12/31/2006', '12/31/2007'], ['ventas', '$ 100', '$ 206', '$ 270', '$ 331', '$ 457', '$ 512'], ['nyse composite index', '$ 100', '$ 132', '$ 151', '$ 166', '$ 200', '$ 217'], ['all reit index', '$ 100', '$ 138', '$ 181', '$ 196', '$ 262', '$ 215'], ['healthcare reit index', '$ 100', '$ 154', '$ 186', '$ 189', '$ 273', '$ 279'], ['russell 1000 index', '$ 100', '$ 130', '$ 145', '$ 154', '$ 178', '$ 188']]
ventas nyse composite index all reit index healthcare reit index russell 1000 index .

Question: what was the 5 year return on ventas common stock?
Answer: 412%
american tower corporation and subsidiaries notes to consolidated financial statements acquisition accounting upon closing of the acquisition .based on current estimates , the company expects the value of potential contingent consideration payments required to be made under these agreements to be between zero and $ 4.4 million .during the year ended december 31 , 2014 , the company ( i ) recorded a decrease in fair value of $ 1.7 million in other operating expenses in the accompanying consolidated statements of operations , ( ii ) recorded settlements under these agreements of $ 3.5 million , ( iii ) reduced its contingent consideration liability by $ 0.7 million as a portion of the company 2019s obligations was assumed by the buyer in conjunction with the sale of operations in panama and ( iv ) recorded additional liability of $ 0.1 million .as a result , the company estimates the value of potential contingent consideration payments required under these agreements to be $ 2.3 million using a probability weighted average of the expected outcomes as of december 31 , 2014 .other u.s . 2014in connection with other acquisitions in the united states , the company is required to make additional payments if certain pre-designated tenant leases commence during a specified period of time .during the year ended december 31 , 2014 , the company recorded $ 6.3 million of contingent consideration liability as part of the preliminary acquisition accounting upon closing of certain acquisitions .during the year ended december 31 , 2014 , the company recorded settlements under these agreements of $ 0.4 million .based on current estimates , the company expects the value of potential contingent consideration payments required to be made under these agreements to be between zero and $ 5.9 million and estimates it to be $ 5.9 million using a probability weighted average of the expected outcomes as of december 31 , 2014 .for more information regarding contingent consideration , see note 12 .7 .accrued expenses accrued expenses consists of the following as of december 31 , ( in thousands ) : .
[['', '2014', '2013 ( 1 )'], ['accrued property and real estate taxes', '$ 61206', '$ 54529'], ['payroll and related withholdings', '57110', '50843'], ['accrued construction costs', '46024', '52446'], ['accrued rent', '34074', '28456'], ['other accrued expenses', '219340', '234914'], ['balance as of december 31,', '$ 417754', '$ 421188']]
( 1 ) december 31 , 2013 balances have been revised to reflect purchase accounting measurement period adjustments. .

Question: how much of the of contingent consideration for acquisitions was actually settled in 2014?
Answer: 6.3%
stock performance graph : the graph below shows the cumulative total shareholder return assuming the investment of $ 100 , on december 31 , 2012 , and the reinvestment of dividends thereafter , if any , in the company 2019s common stock versus the standard and poor 2019s s&p 500 retail index ( 201cs&p 500 retail index 201d ) and the standard and poor 2019s s&p 500 index ( 201cs&p 500 201d ) . .
[['company/index', 'december 31 , 2012', 'december 31 , 2013', 'december 31 , 2014', 'december 31 , 2015', 'december 31 , 2016', 'december 31 , 2017'], ['o 2019reilly automotive inc .', '$ 100', '$ 144', '$ 215', '$ 283', '$ 311', '$ 269'], ['s&p 500 retail index', '100', '144', '158', '197', '206', '265'], ['s&p 500', '$ 100', '$ 130', '$ 144', '$ 143', '$ 157', '$ 187']]
.

Question: what is the roi of an investment in s&p500 from 2016 to 2017?
Answer: 19.1%
18 .allowance for credit losses .
[['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%
issuer purchases of equity securities the following table provides information about purchases by us during the three months ended december 31 , 2013 of equity securities that are registered by us pursuant to section 12 of the exchange act : 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 ( 1 ) ( 2 ) dollar value of shares that may yet be purchased under the plans or programs ( 1 ) .
[['period', 'total number of shares purchased ( 1 )', 'average price paid per share', 'total number of shares purchased as part of publicly announcedplans or programs ( 1 ) ( 2 )', 'dollar value of shares that may yet be purchased under the plans orprograms ( 1 )'], ['october 2013', '0', '$ 0', '0', '$ 781118739'], ['november 2013', '1191867', '98.18', '1191867', '664123417'], ['december 2013', '802930', '104.10', '802930', '580555202'], ['total', '1994797', '$ 100.56', '1994797', '']]
( 1 ) as announced on may 1 , 2013 , in april 2013 , the board of directors replaced its previously approved share repurchase authorization of up to $ 1 billion with a current authorization for repurchases of up to $ 1 billion of our common shares exclusive of shares repurchased in connection with employee stock plans , expiring on june 30 , 2015 .under the current share repurchase authorization , shares may be purchased from time to time at prevailing prices in the open market , by block purchases , or in privately-negotiated transactions , subject to certain regulatory restrictions on volume , pricing , and timing .as of february 1 , 2014 , the remaining authorized amount under the current authorization totaled approximately $ 580 million .( 2 ) excludes 0.1 million shares repurchased in connection with employee stock plans. .

Question: what was the percent of the total number of shares purchased ( 1 ) in november 2013 to the total
Answer: 59.7%
the following is a schedule of future minimum rental payments required under long-term operating leases at october 29 , 2011 : fiscal years operating leases .
[['fiscal years', 'operating leases'], ['2012', '$ 17590'], ['2013', '12724'], ['2014', '6951'], ['2015', '5649'], ['2016', '3669'], ['later years', '19472'], ['total', '$ 66055']]
12 .commitments and contingencies from time to time in the ordinary course of the company 2019s business , various claims , charges and litigation are asserted or commenced against the company arising from , or related to , contractual matters , patents , trademarks , personal injury , environmental matters , product liability , insurance coverage and personnel and employment disputes .as to such claims and litigation , the company can give no assurance that it will prevail .the company does not believe that any current legal matters will have a material adverse effect on the company 2019s financial position , results of operations or cash flows .13 .retirement plans the company and its subsidiaries have various savings and retirement plans covering substantially all employees .the company maintains a defined contribution plan for the benefit of its eligible u.s .employees .this plan provides for company contributions of up to 5% ( 5 % ) of each participant 2019s total eligible compensation .in addition , the company contributes an amount equal to each participant 2019s pre-tax contribution , if any , up to a maximum of 3% ( 3 % ) of each participant 2019s total eligible compensation .the total expense related to the defined contribution plan for u.s .employees was $ 21.9 million in fiscal 2011 , $ 20.5 million in fiscal 2010 and $ 21.5 million in fiscal 2009 .the company also has various defined benefit pension and other retirement plans for certain non-u.s .employees that are consistent with local statutory requirements and practices .the total expense related to the various defined benefit pension and other retirement plans for certain non-u.s .employees was $ 21.4 million in fiscal 2011 , $ 11.7 million in fiscal 2010 and $ 10.9 million in fiscal 2009 .non-u.s .plan disclosures the company 2019s funding policy for its foreign defined benefit pension plans is consistent with the local requirements of each country .the plans 2019 assets consist primarily of u.s .and non-u.s .equity securities , bonds , property and cash .the benefit obligations and related assets under these plans have been measured at october 29 , 2011 and october 30 , 2010 .analog devices , inc .notes to consolidated financial statements 2014 ( continued ) .

Question: what is the growth rate in the total expense related to the defined contribution plan for non-u.s.employees in 2011?
Answer: 82.9%
american tower corporation and subsidiaries notes to consolidated financial statements the valuation allowance increased from $ 47.8 million as of december 31 , 2009 to $ 48.2 million as of december 31 , 2010 .the increase was primarily due to valuation allowances on foreign loss carryforwards .at december 31 , 2010 , the company has provided a valuation allowance of approximately $ 48.2 million which primarily relates to state net operating loss carryforwards , equity investments and foreign items .the company has not provided a valuation allowance for the remaining deferred tax assets , primarily its federal net operating loss carryforwards , as management believes the company will have sufficient taxable income to realize these federal net operating loss carryforwards during the twenty-year tax carryforward period .valuation allowances may be reversed if related deferred tax assets are deemed realizable based on changes in facts and circumstances relevant to the assets 2019 recoverability .the recoverability of the company 2019s remaining net deferred tax asset has been assessed utilizing projections based on its current operations .the projections show a significant decrease in depreciation in the later years of the carryforward period as a result of a significant portion of its assets being fully depreciated during the first fifteen years of the carryforward period .accordingly , the recoverability of the net deferred tax asset is not dependent on material improvements to operations , material asset sales or other non-routine transactions .based on its current outlook of future taxable income during the carryforward period , management believes that the net deferred tax asset will be realized .the company 2019s deferred tax assets as of december 31 , 2010 and 2009 in the table above do not include $ 122.1 million and $ 113.9 million , respectively , of excess tax benefits from the exercises of employee stock options that are a component of net operating losses .total stockholders 2019 equity as of december 31 , 2010 will be increased by $ 122.1 million if and when any such excess tax benefits are ultimately realized .at december 31 , 2010 , the company had net federal and state operating loss carryforwards available to reduce future federal and state taxable income of approximately $ 1.2 billion , including losses related to employee stock options of $ 0.3 billion .if not utilized , the company 2019s net operating loss carryforwards expire as follows ( in thousands ) : .
[['years ended december 31,', 'federal', 'state', 'foreign'], ['2011 to 2015', '$ 2014', '$ 2014', '$ 503'], ['2016 to 2020', '2014', '331315', '5509'], ['2021 to 2025', '774209', '576780', '2014'], ['2026 to 2030', '423398', '279908', '92412'], ['total', '$ 1197607', '$ 1188003', '$ 98424']]
in addition , the company has mexican tax credits of $ 5.2 million which if not utilized would expire in 2017. .

Question: at december 31 , 2010 what was the percent of the total net operating loss carry forwards set to expire between 2021 and 2025
Answer: 64.6%