HangHor/FinQA_Normalized_ALL huggingface dataset:
2022 base rate increases at entergy texas beginning may 2011 as a result of the settlement of the december 2009 rate case and effective july 2012 as a result of the puct 2019s order in the december 2011 rate case .see note 2 to the financial statements for further discussion of the rate cases .these increases were partially offset by formula rate plan decreases at entergy new orleans effective october 2011 and at entergy gulf states louisiana effective september 2012 .see note 2 to the financial statements for further discussion of the formula rate plan decreases .the grand gulf recovery variance is primarily due to increased recovery of higher costs resulting from the grand gulf uprate .the net wholesale revenue variance is primarily due to decreased sales volume to municipal and co-op customers and lower prices .the purchased power capacity variance is primarily due to price increases for ongoing purchased power capacity and additional capacity purchases .the volume/weather variance is primarily due to decreased electricity usage , including the effect of milder weather as compared to the prior period on residential and commercial sales .hurricane isaac , which hit the utility 2019s service area in august 2012 , also contributed to the decrease in electricity usage .billed electricity usage decreased a total of 1684 gwh , or 2% ( 2 % ) , across all customer classes .the louisiana act 55 financing savings obligation variance results from a regulatory charge recorded in 2012 because entergy gulf states louisiana and entergy louisiana agreed to share the savings from an irs settlement related to the uncertain tax position regarding the hurricane katrina and hurricane rita louisiana act 55 financing with customers .see note 3 to the financial statements for additional discussion of the tax settlement .entergy wholesale commodities following is an analysis of the change in net revenue comparing 2012 to 2011 .amount ( in millions ) .
[['', 'amount ( in millions )'], ['2011 net revenue', '$ 2045'], ['nuclear realized price changes', '-194 ( 194 )'], ['nuclear volume', '-33 ( 33 )'], ['other', '36'], ['2012 net revenue', '$ 1854']]
as shown in the table above , net revenue for entergy wholesale commodities decreased by $ 191 million , or 9% ( 9 % ) , in 2012 compared to 2011 primarily due to lower pricing in its contracts to sell power and lower volume in its nuclear fleet resulting from more unplanned and refueling outage days in 2012 as compared to 2011 which was partially offset by the exercise of resupply options provided for in purchase power agreements whereby entergy wholesale commodities may elect to supply power from another source when the plant is not running .amounts related to the exercise of resupply options are included in the gwh billed in the table below .partially offsetting the lower net revenue from the nuclear fleet was higher net revenue from the rhode island state energy center , which was acquired in december 2011 .entergy corporation and subsidiaries management's financial discussion and analysis .

Question: what is the growth rate in net revenue for entergy wholesale commodities in 2012?
Answer: -9.3%
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 2019s 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: what is the roi of an investment in s&p500 from 2008 to 2009?
Answer: 26.5%
.
[['currency', '2012', '2011', '2010'], ['real', '$ 40.4', '$ 42.4', '$ 32.5'], ['euro', '27.1', '26.4', '18.6'], ['pound sterling', '18.5', '17.6', '9.0'], ['indian rupee', '4.3', '3.6', '2.6'], ['total impact', '$ 90.3', '$ 90.0', '$ 62.7']]
the impact on earnings of the foregoing assumed 10% ( 10 % ) change in each of the periods presented would not have been significant .revenue included $ 100.8 million and operating income included $ 9.0 million of unfavorable foreign currency impact during 2012 resulting from a stronger u.s .dollar during 2012 compared to 2011 .our foreign exchange risk management policy permits the use of derivative instruments , such as forward contracts and options , to reduce volatility in our results of operations and/or cash flows resulting from foreign exchange rate fluctuations .our international operations' revenues and expenses are generally denominated in local currency , which limits the economic exposure to foreign exchange risk in those jurisdictions .we do not enter into foreign currency derivative instruments for trading purposes .we have entered into foreign currency forward exchange contracts to hedge foreign currency exposure to intercompany loans .as of december 31 , 2012 , the notional amount of these derivatives was approximately $ 115.6 million and the fair value was nominal .these derivatives are intended to hedge the foreign exchange risks related to intercompany loans , but have not been designated as hedges for accounting purposes. .

Question: what is the percentage change in the impact of euro from 2011 to 2012?
Answer: 2.7%
stock performance graph the graph depicted below shows a comparison of our cumulative total stockholder returns for our common stock , the nasdaq stock market index , and the nasdaq pharmaceutical index , from the date of our initial public offering on july 27 , 2000 through december 26 , 2003 .the graph assumes that $ 100 was invested on july 27 , 2000 , in our common stock and in each index , and that all dividends were reinvested .no cash dividends have been declared on our common stock .stockholder returns over the indicated period should not be considered indicative of future stockholder returns .comparison of total return among illumina , inc. , the nasdaq composite index and the nasdaq pharmaceutical index december 26 , 2003december 27 , 2002december 28 , 2001december 29 , 2000july 27 , 2000 illumina , inc .nasdaq composite index nasdaq pharmaceutical index july 27 , december 29 , december 28 , december 27 , december 26 , 2000 2000 2001 2002 2003 .
[['', 'july 27 2000', 'december 29 2000', 'december 28 2001', 'december 27 2002', 'december 26 2003'], ['illumina inc .', '100.00', '100.39', '71.44', '19.50', '43.81'], ['nasdaq composite index', '100.00', '63.84', '51.60', '35.34', '51.73'], ['nasdaq pharmaceutical index', '100.00', '93.20', '82.08', '51.96', '74.57']]
.

Question: at december 292000 what was the ratio of the nasdaq composite index to the nasdaq pharmaceutical index
Answer: 0.685
Explanation: the ratio of the nasdaq composite index to the nasdaq pharmaceutical index in december 2000 was 0.685 to 1
other items on our consolidated financial statements have been appropriately adjusted from the amounts provided in the earnings release , including a reduction of our full year 2016 gross profit and income from operations by $ 2.9 million , and a reduction of net income by $ 1.7 million. .
[['( in thousands )', 'at december 31 , 2016', 'at december 31 , 2015', 'at december 31 , 2014', 'at december 31 , 2013', 'at december 31 , 2012'], ['cash and cash equivalents', '$ 250470', '$ 129852', '$ 593175', '$ 347489', '$ 341841'], ['working capital ( 1 )', '1279337', '1019953', '1127772', '702181', '651370'], ['inventories', '917491', '783031', '536714', '469006', '319286'], ['total assets', '3644331', '2865970', '2092428', '1576369', '1155052'], ['total debt including current maturities', '817388', '666070', '281546', '151551', '59858'], ['total stockholders 2019 equity', '$ 2030900', '$ 1668222', '$ 1350300', '$ 1053354', '$ 816922']]
( 1 ) working capital is defined as current assets minus current liabilities. .

Question: what was the percentage change in working capital from 2015 to 2016?
Answer: 25%
at december 31 , 2013 , the aggregate amount of investment grade funded loans was $ 6.5 billion and the aggregate amount of non-investment grade funded loans was $ 7.9 billion .in connection with these corporate lending activities ( which include corporate funded and unfunded lending commitments ) , the company had hedges ( which include 201csingle name , 201d 201csector 201d and 201cindex 201d hedges ) with a notional amount of $ 9.0 billion related to the total corporate lending exposure of $ 93.0 billion at december 31 , 2013 .201cevent-driven 201d loans and lending commitments at december 31 , 2013 .included in the total corporate lending exposure amounts in the table above at december 31 , 2013 were 201cevent- driven 201d exposures of $ 9.5 billion composed of funded loans of $ 2.0 billion and lending commitments of $ 7.5 billion .included in the 201cevent-driven 201d exposure at december 31 , 2013 were $ 7.3 billion of loans and lending commitments to non-investment grade borrowers .the maturity profile of the 201cevent-driven 201d loans and lending commitments at december 31 , 2013 was as follows : 33% ( 33 % ) will mature in less than 1 year , 17% ( 17 % ) will mature within 1 to 3 years , 32% ( 32 % ) will mature within 3 to 5 years and 18% ( 18 % ) will mature in over 5 years .industry exposure 2014corporate lending .the company also monitors its credit exposure to individual industries for credit exposure arising from corporate loans and lending commitments as discussed above .the following table shows the company 2019s credit exposure from its primary corporate loans and lending commitments by industry at december 31 , 2013 : industry corporate lending exposure ( dollars in millions ) .
[['industry', 'corporate lending exposure ( dollars in millions )'], ['energy', '$ 12240'], ['utilities', '10410'], ['healthcare', '10095'], ['consumer discretionary', '9981'], ['industrials', '9514'], ['funds exchanges and other financial services ( 1 )', '7190'], ['consumer staples', '6788'], ['information technology', '6526'], ['telecommunications services', '5658'], ['materials', '4867'], ['real estate', '4171'], ['other', '5593'], ['total', '$ 93033']]
( 1 ) includes mutual funds , pension funds , private equity and real estate funds , exchanges and clearinghouses and diversified financial services .institutional securities other lending activities .in addition to the primary corporate lending activity described above , the institutional securities business segment engages in other lending activity .these loans primarily include corporate loans purchased in the secondary market , commercial and residential mortgage loans , asset-backed loans and financing extended to institutional clients .at december 31 , 2013 , approximately 99.6% ( 99.6 % ) of institutional securities other lending activities held for investment were current ; less than 0.4% ( 0.4 % ) were on non- accrual status because the loans were past due for a period of 90 days or more or payment of principal or interest was in doubt. .

Question: how much of the december 31 , 2013 201cevent- driven 201d loans and commitments will mature in 2014 , in billions?
Answer: 3.1
supplementary information on oil and gas producing activities ( unaudited ) c o n t i n u e d summary of changes in standardized measure of discounted future net cash flows relating to proved oil and gas reserves ( in millions ) 2004 2003 2002 sales and transfers of oil and gas produced , net of production , transportation , and administrative costs $ ( 2715 ) $ ( 2487 ) $ ( 1983 ) net changes in prices and production , transportation and administrative costs related to future production 950 1178 2795 .
[['( in millions )', '2004', '2003', '2002'], ['sales and transfers of oil and gas produced net of production transportation and administrative costs', '$ -2715 ( 2715 )', '$ -2487 ( 2487 )', '$ -1983 ( 1983 )'], ['net changes in prices and production transportation and administrative costs related to future production', '950', '1178', '2795'], ['extensions discoveries and improved recovery less related costs', '1352', '618', '1032'], ['development costs incurred during the period', '711', '802', '499'], ['changes in estimated future development costs', '-556 ( 556 )', '-478 ( 478 )', '-297 ( 297 )'], ['revisions of previous quantity estimates', '494', '348', '311'], ['net changes in purchases and sales of minerals in place', '33', '-531 ( 531 )', '737'], ['net change in exchanges of minerals in place', '2013', '403', '2013'], ['accretion of discount', '790', '807', '417'], ['net change in income taxes', '-529 ( 529 )', '65', '-1288 ( 1288 )'], ['timing and other', '-62 ( 62 )', '-165 ( 165 )', '2'], ['net change for the year', '468', '560', '2225'], ['beginning of year', '6001', '5441', '3216'], ['end of year', '$ 6469', '$ 6001', '$ 5441'], ['net change for the year from discontinued operations', '$ 2013', '$ -384 ( 384 )', '$ 212']]
.

Question: what was the average ending balance in the discounted ending cash flow balance?
Answer: 5970
2007 annual report 21 five-year stock performance graph the graph below illustrates the cumulative total shareholder return on snap-on common stock since 2002 , assuming that dividends were reinvested .the graph compares snap-on 2019s performance to that of the standard & poor 2019s 500 stock index ( 201cs&p 500 201d ) and a peer group .snap-on incorporated total shareholder return ( 1 ) 2002 2003 2004 2005 2006 2007 snap-on incorporated peer group s&p 500 fiscal year ended ( 2 ) snap-on incorporated peer group ( 3 ) s&p 500 .
[['fiscal year ended ( 2 )', 'snap-on incorporated', 'peer group ( 3 )', 's&p 500'], ['december 31 2002', '$ 100.00', '$ 100.00', '$ 100.00'], ['december 31 2003', '118.80', '126.16', '128.68'], ['december 31 2004', '130.66', '152.42', '142.69'], ['december 31 2005', '146.97', '157.97', '149.70'], ['december 31 2006', '191.27', '185.10', '173.34'], ['december 31 2007', '198.05', '216.19', '182.87']]
( 1 ) assumes $ 100 was invested on december 31 , 2002 and that dividends were reinvested quarterly .( 2 ) the company's fiscal year ends on the saturday closest to december 31 of each year ; the fiscal year end is assumed to be december 31 for ease of calculation .( 3 ) the peer group includes : the black & decker corporation , cooper industries , ltd. , danaher corporation , emerson electric co. , fortune brands , inc. , genuine parts company , newell rubbermaid inc. , pentair , inc. , spx corporation , the stanley works and w.w .grainger , inc. .

Question: what is the roi in snap-on if the investment was made at the end of 2005 and sold at the end of 2007?
Answer: 34.8%
item 4 .mine safety disclosures not applicable part ii item 5 .market for registrant 2019s common equity , related stockholder matters , and issuer purchases of equity securities our common stock ( ticker symbol apd ) is listed on the new york stock exchange .our transfer agent and registrar is broadridge corporate issuer solutions , inc. , p.o .box 1342 , brentwood , new york 11717 , telephone ( 844 ) 318-0129 ( u.s. ) or ( 720 ) 358-3595 ( all other locations ) ; website , http://shareholder.broadridge.com/ airproducts ; and e-mail address , shareholder@broadridge.com .as of 31 october 2018 , there were 5391 record holders of our common stock .cash dividends on the company 2019s common stock are paid quarterly .it is our expectation that we will continue to pay cash dividends in the future at comparable or increased levels .the board of directors determines whether to declare dividends and the timing and amount based on financial condition and other factors it deems relevant .dividend information for each quarter of fiscal years 2018 and 2017 is summarized below: .
[['', '2018', '2017'], ['first quarter', '$ .95', '$ .86'], ['second quarter', '1.10', '.95'], ['third quarter', '1.10', '.95'], ['fourth quarter', '1.10', '.95'], ['total', '$ 4.25', '$ 3.71']]
purchases of equity securities by the issuer on 15 september 2011 , the board of directors authorized the repurchase of up to $ 1.0 billion of our outstanding common stock .this program does not have a stated expiration date .we repurchase shares pursuant to rules 10b5-1 and 10b-18 under the securities exchange act of 1934 , as amended , through repurchase agreements established with one or more brokers .there were no purchases of stock during fiscal year 2018 .at 30 september 2018 , $ 485.3 million in share repurchase authorization remained .additional purchases will be completed at the company 2019s discretion while maintaining sufficient funds for investing in its businesses and growth opportunities. .

Question: what is the increase observed in the payment of dividends during 2017 and 2018?
Answer: 14.55%
Explanation: it is the value of 2018 divided by the 2017's , then turned into a percentage .
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 2019s 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: what was the percentage total cumulative return on investment for united parcel service inc . for the five years ended 12/31/2012?
Answer: 21.46%
notes to consolidated financial statements the components of accumulated other comprehensive loss , net of related tax , are as follows: .
[['( millions ) as of december 31', '2007', '2006', '2005'], ['net derivative gains ( losses )', '$ 24', '$ 15', '$ -11 ( 11 )'], ['net unrealized investment gains', '76', '73', '52'], ['net foreign exchange translation', '284', '118', '-119 ( 119 )'], ['postretirement plans', '-1110 ( 1110 )', '-1216 ( 1216 )', '-1077 ( 1077 )'], ['accumulated other comprehensive loss', '$ -726 ( 726 )', '$ -1010 ( 1010 )', '$ -1155 ( 1155 )']]
aon corporation .

Question: what is the percentual increase observed in the net derivative gains during 2006 and 2007?
Answer: 60%
Explanation: it is the net derivative value of 2007 divided by the 2006's , then transformed into a percentage .
entergy corporation and subsidiaries management 2019s financial discussion and analysis regulatory asset associated with new nuclear generation development costs as a result of a joint stipulation entered into with the mississippi public utilities staff , subsequently approved by the mpsc , in which entergy mississippi agreed not to pursue recovery of the costs deferred by an mpsc order in the new nuclear generation docket .see note 2 to the financial statements for further discussion of the new nuclear generation development costs and the joint stipulation .net revenue utility following is an analysis of the change in net revenue comparing 2015 to 2014 .amount ( in millions ) .
[['', 'amount ( in millions )'], ['2014 net revenue', '$ 5735'], ['retail electric price', '187'], ['volume/weather', '95'], ['louisiana business combination customer credits', '-107 ( 107 )'], ['miso deferral', '-35 ( 35 )'], ['waterford 3 replacement steam generator provision', '-32 ( 32 )'], ['other', '-14 ( 14 )'], ['2015 net revenue', '$ 5829']]
the retail electric price variance is primarily due to : 2022 formula rate plan increases at entergy louisiana , as approved by the lpsc , effective december 2014 and january 2015 ; 2022 an increase in energy efficiency rider revenue primarily due to increases in the energy efficiency rider at entergy arkansas , as approved by the apsc , effective july 2015 and july 2014 , and new energy efficiency riders at entergy louisiana and entergy mississippi that began in the fourth quarter 2014 .energy efficiency revenues are largely offset by costs included in other operation and maintenance expenses and have a minimal effect on net income ; and 2022 an annual net rate increase at entergy mississippi of $ 16 million , effective february 2015 , as a result of the mpsc order in the june 2014 rate case .see note 2 to the financial statements for a discussion of rate and regulatory proceedings .the volume/weather variance is primarily due to an increase of 1402 gwh , or 1% ( 1 % ) , in billed electricity usage , including an increase in industrial usage and the effect of more favorable weather .the increase in industrial sales was primarily due to expansion in the chemicals industry and the addition of new customers , partially offset by decreased demand primarily due to extended maintenance outages for existing chemicals customers .the louisiana business combination customer credits variance is due to a regulatory liability of $ 107 million recorded by entergy in october 2015 as a result of the entergy gulf states louisiana and entergy louisiana business combination .consistent with the terms of an agreement with the lpsc , electric customers of entergy louisiana will realize customer credits associated with the business combination ; accordingly , in october 2015 , entergy recorded a regulatory liability of $ 107 million ( $ 66 million net-of-tax ) .see note 2 to the financial statements for further discussion of the business combination and customer credits. .

Question: based on the analysis of the change in net revenue from 2014 to 2015 what was the percent of the change
Answer: 1.64%