bevaya/FinQA huggingface dataset:
other expense , net : the company's other expense consists of the following: .

Table: ( in thousands ) year ended december 31 , 2013 year ended december 31 , 2012 foreign currency losses net $ -1115 ( 1115 ) $ -1401 ( 1401 ) other income ( expense ) net 69 -4 ( 4 ) total other expense net $ -1046 ( 1046 ) $ -1405 ( 1405 )

income tax provision : the company recorded income tax expense of $ 77.2 million and had income before income taxes of $ 322.5 million for the year ended december 31 , 2013 , representing an effective tax rate of 23.9% ( 23.9 % ) . during the year ended december 31 , 2012 , the company recorded income tax expense of $ 90.1 million and had income before income taxes of $ 293.5 million , representing an effective tax rate of 30.7% ( 30.7 % ) . in december 2013 , the company received notice from the irs that the joint committee on taxation took no exception to the company's tax returns that were filed for 2009 and 2010 . an $ 11.0 million tax benefit was recognized in the company's 2013 financial results as the company had effectively settled uncertainty regarding the realization of refund claims filed in connection with the 2009 and 2010 returns . in the u.s. , which is the largest jurisdiction where the company receives such a tax credit , the availability of the research and development credit expired at the end of the 2011 tax year . in january 2013 , the u.s . congress passed legislation that reinstated the research and development credit retroactive to 2012 . the income tax provision for the year ended december 31 , 2013 includes approximately $ 2.3 million related to the reinstated research and development credit for 2012 activity . the decrease in the effective tax rate from the prior year is primarily due to the release of an uncertain tax position mentioned above , the reinstatement of the u.s . research and development credit mentioned above , and cash repatriation activities . when compared to the federal and state combined statutory rate , the effective tax rates for the years ended december 31 , 2013 and 2012 were favorably impacted by lower statutory tax rates in many of the company 2019s foreign jurisdictions , the domestic manufacturing deduction and tax benefits associated with the merger of the company 2019s japan subsidiaries in 2010 . net income : the company 2019s net income for the year ended december 31 , 2013 was $ 245.3 million as compared to net income of $ 203.5 million for the year ended december 31 , 2012 . diluted earnings per share was $ 2.58 for the year ended december 31 , 2013 and $ 2.14 for the year ended december 31 , 2012 . the weighted average shares used in computing diluted earnings per share were 95.1 million and 95.0 million for the years ended december 31 , 2013 and 2012 , respectively . table of contents .

Question: what was the percentage change in the foreign currency losses net from 2012 to 2013
Answer: -20.4%
Calculation: divide(subtract(1115, 1401), 1401)
entergy louisiana , llc management's financial discussion and analysis 2007 compared to 2006 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges ( credits ) . following is an analysis of the change in net revenue comparing 2007 to 2006 . amount ( in millions ) .

Table: amount ( in millions ) 2006 net revenue $ 942.1 base revenues 78.4 volume/weather 37.5 transmission revenue 9.2 purchased power capacity -80.0 ( 80.0 ) other 3.9 2007 net revenue $ 991.1

the base revenues variance is primarily due to increases effective september 2006 for the 2005 formula rate plan filing to recover lpsc-approved incremental deferred and ongoing capacity costs . see "state and local rate regulation" below and note 2 to the financial statements for a discussion of the formula rate plan filing . the volume/weather variance is due to increased electricity usage , including electricity sales during the unbilled service period . billed retail electricity usage increased a total of 666 gwh in all sectors compared to 2006 . see "critical accounting estimates" below and note 1 to the financial statements for further discussion of the accounting for unbilled revenues . the transmission revenue variance is primarily due to higher rates . the purchased power capacity variance is primarily due to higher purchased power capacity charges and the amortization of capacity charges effective september 2006 as a result of the formula rate plan filing in may 2006 . a portion of the purchased power capacity costs is offset in base revenues due to a base rate increase implemented to recover incremental deferred and ongoing purchased power capacity charges , as mentioned above . see "state and local rate regulation" below and note 2 to the financial statements for a discussion of the formula rate plan filing . gross operating revenues , fuel , purchased power expenses , and other regulatory charges ( credits ) gross operating revenues increased primarily due to : an increase of $ 143.1 million in fuel cost recovery revenues due to higher fuel rates and usage ; an increase of $ 78.4 million in base revenues , as discussed above ; and an increase of $ 37.5 million related to volume/weather , as discussed above . fuel and purchased power expenses increased primarily due to an increase in net area demand and an increase in deferred fuel expense as a result of higher fuel rates , as discussed above . other regulatory credits decreased primarily due to the deferral of capacity charges in 2006 in addition to the amortization of these capacity charges in 2007 as a result of the may 2006 formula rate plan filing ( for the 2005 test year ) with the lpsc to recover such costs through base rates effective september 2006 . see note 2 to the financial statements for a discussion of the formula rate plan and storm cost recovery filings with the lpsc. .

Question: what is the percent change in net revenue between 2006 and 2007?
Answer: 5.2%
Calculation: divide(subtract(991.1, 942.1), 942.1)
the following table provides a summary of our historical capital expenditures related to the upgrading of our infrastructure and systems: .

Table: ( in millions ) for the years ended december 31 , 2018 for the years ended december 31 , 2017 for the years ended december 31 , 2016 transmission and distribution $ 572 $ 551 $ 568 treatment and pumping 231 171 151 services meter and fire hydrants 303 281 297 general structure and equipment 371 281 202 sources of supply 26 54 59 wastewater 83 96 34 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: total transmission and distribution expenses in millions for the three year period equaled what?
Answer: 1691
Calculation: table_sum(transmission and distribution, none)
sales of unregistered securities not applicable . repurchases of equity securities the following table provides information regarding our purchases of our equity securities during the period from october 1 , 2017 to december 31 , 2017 . total number of shares ( or units ) purchased 1 average price paid per share ( or unit ) 2 total number of shares ( or units ) purchased as part of publicly announced plans or programs 3 maximum number ( or approximate dollar value ) of shares ( or units ) that may yet be purchased under the plans or programs 3 .

Table: total number ofshares ( or units ) purchased1 average price paidper share ( or unit ) 2 total number ofshares ( or units ) purchased as part ofpublicly announcedplans or programs3 maximum number ( orapproximate dollar value ) of shares ( or units ) that may yet be purchasedunder the plans orprograms3 october 1 - 31 1231868 $ 20.74 1230394 $ 214001430 november 1 - 30 1723139 $ 18.89 1722246 $ 181474975 december 1 - 31 1295639 $ 20.25 1285000 $ 155459545 total 4250646 $ 19.84 4237640

1 included shares of our common stock , par value $ 0.10 per share , withheld under the terms of grants under employee stock-based compensation plans to offset tax withholding obligations that occurred upon vesting and release of restricted shares ( the 201cwithheld shares 201d ) . we repurchased 1474 withheld shares in october 2017 , 893 withheld shares in november 2017 and 10639 withheld shares in december 2017 , for a total of 13006 withheld shares during the three-month period . 2 the average price per share for each of the months in the fiscal quarter and for the three-month period was calculated by dividing the sum of the applicable period of the aggregate value of the tax withholding obligations and the aggregate amount we paid for shares acquired under our share repurchase program , described in note 5 to the consolidated financial statements , by the sum of the number of withheld shares and the number of shares acquired in our share repurchase program . 3 in february 2017 , the board authorized a share repurchase program to repurchase from time to time up to $ 300.0 million , excluding fees , of our common stock ( the 201c2017 share repurchase program 201d ) . on february 14 , 2018 , we announced that our board had approved a new share repurchase program to repurchase from time to time up to $ 300.0 million , excluding fees , of our common stock . the new authorization is in addition to any amounts remaining for repurchase under the 2017 share repurchase program . there is no expiration date associated with the share repurchase programs. .

Question: what is the percentage decrease in average price per share from october to november?
Answer: 8.92%
Calculation: multiply(divide(subtract(20.74, 18.89), 20.74), const_100)
part ii item 5 . market for registrant 2019s common equity and related stockholder matters market information our common stock has been traded on the new york stock exchange ( 2018 2018nyse 2019 2019 ) under the symbol 2018 2018exr 2019 2019 since our ipo on august 17 , 2004 . prior to that time there was no public market for our common stock . the following table sets forth , for the periods indicated , the high and low bid price for our common stock as reported by the nyse and the per share dividends declared : dividends high low declared .

Table: high low dividends declared period from august 17 2004 to september 30 2004 $ 14.38 $ 12.50 $ 0.1113 quarter ended december 31 2004 14.55 12.60 0.2275 quarter ended march 31 2005 14.30 12.55 0.2275 quarter ended june 30 2005 14.75 12.19 0.2275 quarter ended september 30 2005 16.71 14.32 0.2275 quarter ended december 31 2005 15.90 13.00 0.2275

on february 28 , 2006 , the closing price of our common stock as reported by the nyse was $ 15.00 . at february 28 , 2006 , we had 166 holders of record of our common stock . holders of shares of common stock are entitled to receive distributions when declared by our board of directors out of any assets legally available for that purpose . as a reit , we are required to distribute at least 90% ( 90 % ) of our 2018 2018reit taxable income 2019 2019 is generally equivalent to our net taxable ordinary income , determined without regard to the deduction for dividends paid , to our stockholders annually in order to maintain our reit qualifications for u.s . federal income tax purposes . unregistered sales of equity securities and use of proceeds on june 20 , 2005 , we completed the sale of 6200000 shares of our common stock , $ .01 par value , for $ 83514 , which we reported in a current report on form 8-k filed with the securities and exchange commission on june 24 , 2005 . we used the proceeds for general corporate purposes , including debt repayment . the shares were issued pursuant to an exemption from registration under the securities act of 1933 , as amended. .

Question: what was the dividend yield for the quarter ended march 31 , 2005 using the high bid price?
Answer: 6%
Calculation: divide(multiply(0.2275, const_4), 14.30)
Explanation: this gives and example of the yield for the full year based on the worst price that could have been obtained on the bid for the quarter . it also compares with the previous answer as a risk measure .
performance graph the following graph compares the yearly change in the cumulative total stockholder return for our last five full fiscal years , based upon the market price of our common stock , with the cumulative total return on a nasdaq composite index ( u.s . companies ) and a peer group , the nasdaq medical equipment-sic code 3840-3849 index , which is comprised of medical equipment companies , for that period . the performance graph assumes the investment of $ 100 on march 31 , 2010 in our common stock , the nasdaq composite index ( u.s . companies ) and the peer group index , and the reinvestment of any and all dividends. .

Table: 3/31/2010 3/31/2011 3/31/2012 3/31/2013 3/31/2014 3/31/2015 abiomed inc 100 140.79 215.02 180.91 252.33 693.60 nasdaq composite index 100 115.98 128.93 136.26 175.11 204.38 nasdaq medical equipment sic code 3840-3849 100 108.31 115.05 105.56 123.18 118.95

this graph is not 201csoliciting material 201d under regulation 14a or 14c of the rules promulgated under the securities exchange act of 1934 , is not deemed filed with the securities and exchange commission and is not to be incorporated by reference in any of our filings under the securities act of 1933 , as amended , or the exchange act whether made before or after the date hereof and irrespective of any general incorporation language in any such filing . transfer agent american stock transfer & trust company , 59 maiden lane , new york , ny 10038 , is our stock transfer agent. .

Question: did abiomed outperform the nasdaq medical equipment index over the five year period?
Answer: yes
Calculation: greater(693.60, 118.95)
equity compensation plan information the following table presents the equity securities available for issuance under our equity compensation plans as of december 31 , 2012 . equity compensation plan information plan category number of securities to be issued upon exercise of outstanding options , warrants and rights ( 1 ) weighted-average exercise price of outstanding options , warrants and rights ( 2 ) number of securities remaining available for future issuance under equity compensation plans ( excluding securities reflected in column ( a ) ) ( a ) ( b ) ( c ) equity compensation plans approved by security holders 3946111 $ 34.67 3608527 equity compensation plans not approved by security holders ( 3 ) 2014 2014 2014 .

Table: plan category number of securities to be issued upon exercise of outstanding options warrants and rights ( 1 ) ( a ) ( b ) weighted-average exercise price of outstanding optionswarrants and rights ( 2 ) number of securities remaining available for future issuance under equity compensation plans ( excluding securitiesreflected in column ( a ) ) ( c ) equity compensation plans approved by security holders 3946111 $ 34.67 3608527 equity compensation plans not approved by security holders ( 3 ) 2014 2014 2014 total 3946111 $ 34.67 3608527

( 1 ) includes grants made under the huntington ingalls industries , inc . 2012 long-term incentive stock plan ( the "2012 plan" ) , which was approved by our stockholders on may 2 , 2012 , and the huntington ingalls industries , inc . 2011 long-term incentive stock plan ( the "2011 plan" ) , which was approved by the sole stockholder of hii prior to its spin-off from northrop grumman corporation . of these shares , 1166492 were subject to stock options , 2060138 were subject to outstanding restricted performance stock rights , 641556 were restricted stock rights , and 63033 were stock rights granted under the 2011 plan . in addition , this number includes 9129 stock rights and 5763 restricted performance stock rights granted under the 2012 plan , assuming target performance achievement . ( 2 ) this is the weighted average exercise price of the 1166492 outstanding stock options only . ( 3 ) there are no awards made under plans not approved by security holders . item 13 . certain relationships and related transactions , and director independence information as to certain relationships and related transactions and director independence will be incorporated herein by reference to the proxy statement for our 2013 annual meeting of stockholders to be filed within 120 days after the end of the company 2019s fiscal year . item 14 . principal accountant fees and services information as to principal accountant fees and services will be incorporated herein by reference to the proxy statement for our 2013 annual meeting of stockholders to be filed within 120 days after the end of the company 2019s fiscal year. .

Question: what is the ratio of the number of securities to be issued to the number of securities remaining available
Answer: 1.1
Calculation: divide(3946111, 3608527)
Explanation: for every 1.1 securities to be issued there is 1 securities remaining
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 ) : .

Table: 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: what portion of the total net operating loss carryforwards is state related?
Answer: 47.8%
Calculation: divide(1188003, add(add(1197607, 1188003), 98424))