wandb/finqa-data-processed huggingface dataset:
provision for income taxes increased $ 1791 million in 2012 from 2011 primarily due to the increase in pretax income from continuing operations , including the impact of the resumption of sales in libya in the first quarter of 2012 . the following is an analysis of the effective income tax rates for 2012 and 2011: .

****************************************
	2012	2011
statutory rate applied to income from continuing operations before income taxes	35% ( 35 % )	35% ( 35 % )
effects of foreign operations including foreign tax credits	18	6
change in permanent reinvestment assertion	2014	5
adjustments to valuation allowances	21	14
tax law changes	2014	1
effective income tax rate on continuing operations	74% ( 74 % )	61% ( 61 % )
****************************************

the effective income tax rate is influenced by a variety of factors including the geographic sources of income and the relative magnitude of these sources of income . the provision for income taxes is allocated on a discrete , stand-alone basis to pretax segment income and to individual items not allocated to segments . the difference between the total provision and the sum of the amounts allocated to segments appears in the "corporate and other unallocated items" shown in the reconciliation of segment income to net income below . effects of foreign operations 2013 the effects of foreign operations on our effective tax rate increased in 2012 as compared to 2011 , primarily due to the resumption of sales in libya in the first quarter of 2012 , where the statutory rate is in excess of 90 percent . change in permanent reinvestment assertion 2013 in the second quarter of 2011 , we recorded $ 716 million of deferred u.s . tax on undistributed earnings of $ 2046 million that we previously intended to permanently reinvest in foreign operations . offsetting this tax expense were associated foreign tax credits of $ 488 million . in addition , we reduced our valuation allowance related to foreign tax credits by $ 228 million due to recognizing deferred u.s . tax on previously undistributed earnings . adjustments to valuation allowances 2013 in 2012 and 2011 , we increased the valuation allowance against foreign tax credits because it is more likely than not that we will be unable to realize all u.s . benefits on foreign taxes accrued in those years . see item 8 . financial statements and supplementary data - note 10 to the consolidated financial statements for further information about income taxes . discontinued operations is presented net of tax , and reflects our downstream business that was spun off june 30 , 2011 and our angola business which we agreed to sell in 2013 . see item 8 . financial statements and supplementary data 2013 notes 3 and 6 to the consolidated financial statements for additional information. .

Question: what were total adjustments to valuation allowances in millions?
Program: add(21, 14)
Answer: 35.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 growth rate of the ventas stock as of 12/31/2003
Program: subtract(206, const_100), divide(#0, const_100)
Answer: 1.06
notes to consolidated financial statements ( continued ) note 8 2014commitments and contingencies ( continued ) provide renewal options for terms of 3 to 7 additional years . leases for retail space are for terms of 5 to 20 years , the majority of which are for 10 years , and often contain multi-year renewal options . as of september 29 , 2007 , the company 2019s total future minimum lease payments under noncancelable operating leases were $ 1.4 billion , of which $ 1.1 billion related to leases for retail space . rent expense under all operating leases , including both cancelable and noncancelable leases , was $ 151 million , $ 138 million , and $ 140 million in 2007 , 2006 , and 2005 , respectively . future minimum lease payments under noncancelable operating leases having remaining terms in excess of one year as of september 29 , 2007 , are as follows ( in millions ) : fiscal years .

****************************************
2008 | $ 155
2009 | 172
2010 | 173
2011 | 160
2012 | 148
thereafter | 617
total minimum lease payments | $ 1425
****************************************

accrued warranty and indemnifications the company offers a basic limited parts and labor warranty on its hardware products . the basic warranty period for hardware products is typically one year from the date of purchase by the end-user . the company also offers a 90-day basic warranty for its service parts used to repair the company 2019s hardware products . the company provides currently for the estimated cost that may be incurred under its basic limited product warranties at the time related revenue is recognized . factors considered in determining appropriate accruals for product warranty obligations include the size of the installed base of products subject to warranty protection , historical and projected warranty claim rates , historical and projected cost-per-claim , and knowledge of specific product failures that are outside of the company 2019s typical experience . the company assesses the adequacy of its preexisting warranty liabilities and adjusts the amounts as necessary based on actual experience and changes in future estimates . for products accounted for under subscription accounting pursuant to sop no . 97-2 , the company recognizes warranty expense as incurred . the company periodically provides updates to its applications and system software to maintain the software 2019s compliance with specifications . the estimated cost to develop such updates is accounted for as warranty costs that are recognized at the time related software revenue is recognized . factors considered in determining appropriate accruals related to such updates include the number of units delivered , the number of updates expected to occur , and the historical cost and estimated future cost of the resources necessary to develop these updates. .

Question: what percentage of future minimum lease payments under noncancelable operating leases having remaining terms in excess of one year are due in 2010?
Program: divide(173, 1425)
Answer: 0.1214
performance graph the annual changes for the period shown december 1 , 2013 ( when our ordinary shares began trading ) to december 31 , 2017 in the graph on this page are based on the assumption that $ 100 had been invested in allegion plc ordinary shares , the standard & poor 2019s 500 stock index ( "s&p 500" ) and the standard & poor's 400 capital goods index ( "s&p 400 capital goods" ) on december 1 , 2013 , and that all quarterly dividends were reinvested . the total cumulative dollar returns shown on the graph represent the value that such investments would have had on december 31 , 2017 . december 1 , december 31 , december 31 , december 31 , december 31 , december 31 .

****************************************
Row 1: , december 1 2013, december 31 2013, december 31 2014, december 31 2015, december 31 2016, december 31 2017
Row 2: allegion plc, 100.00, 102.20, 129.03, 154.37, 150.97, 189.19
Row 3: s&p 500, 100.00, 102.53, 116.57, 118.18, 132.31, 161.20
Row 4: s&p 400 capital goods, 100.00, 104.58, 104.84, 99.07, 130.70, 162.97
****************************************

.

Question: considering the final year of the investment , what was the highest return for the initial 100$ ?
Program: subtract(189.19, 100)
Answer: 89.19
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?
Program: subtract(187, 157), divide(#0, 157)
Answer: 0.19108
the following table provides a summary of our historical capital expenditures related to the upgrading of our infrastructure and systems: .

Row 1: ( in millions ), for the years ended december 31 , 2018, for the years ended december 31 , 2017, for the years ended december 31 , 2016
Row 2: transmission and distribution, $ 572, $ 551, $ 568
Row 3: treatment and pumping, 231, 171, 151
Row 4: services meter and fire hydrants, 303, 281, 297
Row 5: general structure and equipment, 371, 281, 202
Row 6: sources of supply, 26, 54, 59
Row 7: wastewater, 83, 96, 34
Row 8: total capital expenditures, $ 1586, $ 1434, $ 1311

in 2018 , our capital expenditures increased $ 152 million , or 10.6% ( 10.6 % ) , primarily due to investment across the majority of our infrastructure categories . in 2017 , our capital expenditures increased $ 123 million , or 9.4% ( 9.4 % ) , primarily due to investment in our general structure and equipment and wastewater categories . we also grow our business primarily through acquisitions of water and wastewater systems , as well as other water-related services . these acquisitions are complementary to our existing business and support continued geographical diversification and growth of our operations . generally , acquisitions are funded initially with short- term debt , and later refinanced with the proceeds from long-term debt . the following is a summary of the acquisitions and dispositions affecting our cash flows from investing activities : 2022 the majority of cash paid for acquisitions pertained to the $ 365 million purchase of pivotal within our homeowner services group . 2022 paid $ 33 million for 15 water and wastewater systems , representing approximately 14000 customers . 2022 received $ 35 million for the sale of assets , including $ 27 million for the sale of the majority of the o&m contracts in our contract services group during the third quarter of 2018 . 2022 the majority of cash paid for acquisitions pertained to the $ 159 million purchase of the wastewater collection and treatment system assets of the municipal authority of the city of mckeesport , pennsylvania ( the 201cmckeesport system 201d ) , excluding a $ 5 million non-escrowed deposit made in 2016 . 2022 paid $ 18 million for 16 water and wastewater systems , excluding the mckeesport system and shorelands ( a stock-for-stock transaction ) , representing approximately 7000 customers . 2022 received $ 15 million for the sale of assets . 2022 paid $ 199 million for 15 water and wastewater systems , representing approximately 42000 customers . 2022 made a non-escrowed deposit of $ 5 million related to the mckeesport system acquisition . 2022 received $ 9 million for the sale of assets . as previously noted , we expect to invest between $ 8.0 billion to $ 8.6 billion from 2019 to 2023 , with $ 7.3 billion of this range for infrastructure improvements in our regulated businesses . in 2019 , we expect to .

Question: what percentage of total capital expenditures were related to general structure and equipment in 2018?
Program: divide(371, 1586)
Answer: 0.23392
notes to consolidated financial statements ( continued ) note 2 2014financial instruments ( continued ) typically , the company hedges portions of its forecasted foreign currency exposure associated with revenue and inventory purchases over a time horizon of up to 6 months . derivative instruments designated as cash flow hedges must be de-designated as hedges when it is probable the forecasted hedged transaction will not occur in the initially identified time period or within a subsequent 2 month time period . deferred gains and losses in other comprehensive income associated with such derivative instruments are immediately reclassified into earnings in other income and expense . any subsequent changes in fair value of such derivative instruments are also reflected in current earnings unless they are re-designated as hedges of other transactions . the company recognized net gains of approximately $ 672000 and $ 421000 in 2007 and 2006 , respectively , and a net loss of $ 1.6 million in 2005 in other income and expense related to the loss of hedge designation on discontinued cash flow hedges due to changes in the company 2019s forecast of future net sales and cost of sales and due to prevailing market conditions . as of september 29 , 2007 , the company had a net deferred gain associated with cash flow hedges of approximately $ 468000 , net of taxes , substantially all of which is expected to be reclassified to earnings by the end of the second quarter of fiscal 2008 . the net gain or loss on the effective portion of a derivative instrument designated as a net investment hedge is included in the cumulative translation adjustment account of accumulated other comprehensive income within shareholders 2019 equity . for the years ended september 29 , 2007 and september 30 , 2006 , the company had a net loss of $ 2.6 million and a net gain of $ 7.4 million , respectively , included in the cumulative translation adjustment . the company may also enter into foreign currency forward and option contracts to offset the foreign exchange gains and losses generated by the re-measurement of certain assets and liabilities recorded in non-functional currencies . changes in the fair value of these derivatives are recognized in current earnings in other income and expense as offsets to the changes in the fair value of the related assets or liabilities . due to currency market movements , changes in option time value can lead to increased volatility in other income and expense . note 3 2014consolidated financial statement details ( in millions ) other current assets .

----------------------------------------
, 2007, 2006
vendor non-trade receivables, $ 2392, $ 1593
nand flash memory prepayments, 417, 208
other current assets, 996, 469
total other current assets, $ 3805, $ 2270
----------------------------------------

.

Question: what percentage of total other current assets in 2006 was comprised of nand flash memory prepayments?
Program: divide(208, 2270)
Answer: 0.09163
the company further presents total net 201ceconomic 201d investment exposure , net of deferred compensation investments and hedged investments , to reflect another gauge for investors as the economic impact of investments held pursuant to deferred compensation arrangements is substantially offset by a change in compensation expense and the impact of hedged investments is substantially mitigated by total return swap hedges . carried interest capital allocations are excluded as there is no impact to blackrock 2019s stockholders 2019 equity until such amounts are realized as performance fees . finally , the company 2019s regulatory investment in federal reserve bank stock , which is not subject to market or interest rate risk , is excluded from the company 2019s net economic investment exposure . ( dollar amounts in millions ) december 31 , december 31 .

****************************************
Row 1: ( dollar amounts in millions ), december 31 2012, december 31 2011
Row 2: total investments gaap, $ 1750, $ 1631
Row 3: investments held by consolidated sponsored investmentfunds ( 1 ), -524 ( 524 ), -587 ( 587 )
Row 4: net exposure to consolidated investment funds, 430, 475
Row 5: total investments as adjusted, 1656, 1519
Row 6: federal reserve bank stock ( 2 ), -89 ( 89 ), -328 ( 328 )
Row 7: carried interest, -85 ( 85 ), -21 ( 21 )
Row 8: deferred compensation investments, -62 ( 62 ), -65 ( 65 )
Row 9: hedged investments, -209 ( 209 ), -43 ( 43 )
Row 10: total 201ceconomic 201d investment exposure, $ 1211, $ 1062
****************************************

total 201ceconomic 201d investment exposure . . . $ 1211 $ 1062 ( 1 ) at december 31 , 2012 and december 31 , 2011 , approximately $ 524 million and $ 587 million , respectively , of blackrock 2019s total gaap investments were maintained in sponsored investment funds that were deemed to be controlled by blackrock in accordance with gaap , and , therefore , are consolidated even though blackrock may not economically own a majority of such funds . ( 2 ) the decrease of $ 239 million related to a lower holding requirement of federal reserve bank stock held by blackrock institutional trust company , n.a . ( 201cbtc 201d ) . total investments , as adjusted , at december 31 , 2012 increased $ 137 million from december 31 , 2011 , resulting from $ 765 million of purchases/capital contributions , $ 185 million from positive market valuations and earnings from equity method investments , and $ 64 million from net additional carried interest capital allocations , partially offset by $ 742 million of sales/maturities and $ 135 million of distributions representing return of capital and return on investments. .

Question: what is the percentage change in the balance of total investments gaap from 2011 to 2012?
Program: subtract(1750, 1631), divide(#0, 1631)
Answer: 0.07296
s c h e d u l e i v ace limited and subsidiaries s u p p l e m e n t a l i n f o r m a t i o n c o n c e r n i n g r e i n s u r a n c e premiums earned for the years ended december 31 , 2009 , 2008 , and 2007 ( in millions of u.s . dollars , except for percentages ) direct amount ceded to companies assumed from other companies net amount percentage of amount assumed to .

========================================
for the years ended december 31 2009 2008 and 2007 ( in millions of u.s . dollars except for percentages ) | direct amount | ceded to other companies | assumed from other companies | net amount | percentage of amount assumed to net
----------|----------|----------|----------|----------|----------
2009 | $ 15415 | $ 5943 | $ 3768 | $ 13240 | 28% ( 28 % )
2008 | $ 16087 | $ 6144 | $ 3260 | $ 13203 | 25% ( 25 % )
2007 | $ 14673 | $ 5834 | $ 3458 | $ 12297 | 28% ( 28 % )
========================================

.

Question: in 2009 what was the ratio of the direct amount to the amount ceded to other companies
Program: divide(15415, 5943)
Answer: 2.59381
part ii . item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities our common stock is traded on the nasdaq global select market under the symbol cdns . as of february 2 , 2019 , we had 523 registered stockholders and approximately 56000 beneficial owners of our common stock . stockholder return performance graph the following graph compares the cumulative 5-year total stockholder return on our common stock relative to the cumulative total return of the nasdaq composite index , the s&p 500 index and the s&p 500 information technology index . the graph assumes that the value of the investment in our common stock and in each index on december 28 , 2013 ( including reinvestment of dividends ) was $ 100 and tracks it each year thereafter on the last day of our fiscal year through december 29 , 2018 and , for each index , on the last day of the calendar year . comparison of 5 year cumulative total return* among cadence design systems , inc. , the nasdaq composite index , the s&p 500 index and the s&p 500 information technology index 12/29/181/2/16 12/30/1712/28/13 12/31/161/3/15 *$ 100 invested on 12/28/13 in stock or index , including reinvestment of dividends . fiscal year ending december 29 . copyright a9 2019 standard & poor 2019s , a division of s&p global . all rights reserved . nasdaq compositecadence design systems , inc . s&p 500 s&p 500 information technology .

****************************************
Row 1: , 12/28/2013, 1/3/2015, 1/2/2016, 12/31/2016, 12/30/2017, 12/29/2018
Row 2: cadence design systems inc ., $ 100.00, $ 135.18, $ 149.39, $ 181.05, $ 300.22, $ 311.13
Row 3: nasdaq composite, 100.00, 112.60, 113.64, 133.19, 172.11, 165.84
Row 4: s&p 500, 100.00, 110.28, 109.54, 129.05, 157.22, 150.33
Row 5: s&p 500 information technology, 100.00, 115.49, 121.08, 144.85, 201.10, 200.52
****************************************

the stock price performance included in this graph is not necessarily indicative of future stock price performance. .

Question: what was the percentage cumulative 5-year total stockholder return for cadence design systems inc . for the period ending 12/29/2018?
Program: subtract(311.13, const_100), divide(#0, const_100)
Answer: 2.1113
comparison of cumulative return among lkq corporation , the nasdaq stock market ( u.s. ) index and the peer group .

****************************************
Row 1: , 12/31/2011, 12/31/2012, 12/31/2013, 12/31/2014, 12/31/2015, 12/31/2016
Row 2: lkq corporation, $ 100, $ 140, $ 219, $ 187, $ 197, $ 204
Row 3: s&p 500 index, $ 100, $ 113, $ 147, $ 164, $ 163, $ 178
Row 4: peer group, $ 100, $ 111, $ 140, $ 177, $ 188, $ 217
****************************************

this stock performance information is "furnished" and shall not be deemed to be "soliciting material" or subject to rule 14a , shall not be deemed "filed" for purposes of section 18 of the securities exchange act of 1934 or otherwise subject to the liabilities of that section , and shall not be deemed incorporated by reference in any filing under the securities act of 1933 or the securities exchange act of 1934 , whether made before or after the date of this report and irrespective of any general incorporation by reference language in any such filing , except to the extent that it specifically incorporates the information by reference . information about our common stock that may be issued under our equity compensation plans as of december 31 , 2016 included in part iii , item 12 of this annual report on form 10-k is incorporated herein by reference. .

Question: what was the percentage cumulative return for lkq corporation for the five years ended 12/31/2016?
Program: subtract(204, 100), divide(#0, 100)
Answer: 1.04