wandb/finqa-data-processed huggingface dataset:
during 2014 , $ 91 million of provision recapture was recorded for purchased impaired loans compared to $ 11 million of provision expense for 2013 . the charge-offs ( which were specifically for commercial loans greater than a defined threshold ) during 2014 were $ 42 million compared to $ 104 million for 2013 . at december 31 , 2014 , the allowance for loan and lease losses was $ .9 billion on $ 4.4 billion of purchased impaired loans while the remaining $ .5 billion of purchased impaired loans required no allowance as the net present value of expected cash flows equaled or exceeded the recorded investment . as of december 31 , 2013 , the allowance for loan and lease losses related to purchased impaired loans was $ 1.0 billion . if any allowance for loan losses is recognized on a purchased impaired pool , which is accounted for as a single asset , the entire balance of that pool would be disclosed as requiring an allowance . subsequent increases in the net present value of cash flows will result in a provision recapture of any previously recorded allowance for loan and lease losses , to the extent applicable , and/or a reclassification from non-accretable difference to accretable yield , which will be recognized prospectively . individual loan transactions where final dispositions have occurred ( as noted above ) result in removal of the loans from their applicable pools for cash flow estimation purposes . the cash flow re-estimation process is completed quarterly to evaluate the appropriateness of the allowance associated with the purchased impaired loans . activity for the accretable yield during 2014 and 2013 follows : table 72 : purchased impaired loans 2013 accretable yield .

****************************************
in millions	2014	2013
january 1	$ 2055	$ 2166
accretion ( including excess cash recoveries )	-587 ( 587 )	-695 ( 695 )
net reclassifications to accretable from non-accretable ( a )	208	613
disposals	-118 ( 118 )	-29 ( 29 )
december 31	$ 1558	$ 2055
****************************************

( a ) approximately 93% ( 93 % ) of net reclassifications for the year ended december 31 , 2014 were within the commercial portfolio as compared to 37% ( 37 % ) for year ended december 31 , 2013 . note 5 allowances for loan and lease losses and unfunded loan commitments and letters of credit allowance for loan and lease losses we maintain the alll at levels that we believe to be appropriate to absorb estimated probable credit losses incurred in the portfolios as of the balance sheet date . we use the two main portfolio segments 2013 commercial lending and consumer lending 2013 and develop and document the alll under separate methodologies for each of these segments as discussed in note 1 accounting policies . a rollforward of the alll and associated loan data is presented below . the pnc financial services group , inc . 2013 form 10-k 143 .

Question: what was the dollar amount in millions for net reclassifications for the year ended december 31 , 2014 due to the commercial portfolio?
Program: multiply(208, 93%)
Answer: 193.44
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 percentage cumulative total shareholder return for the four years ended 2014?
Program: subtract(254, 100), divide(#0, 100)
Answer: 1.54
table of contents the following table discloses purchases of shares of our common stock made by us or on our behalf during the fourth quarter of 2017 . period total number of shares purchased average price paid per share total number of shares not purchased as part of publicly announced plans or programs ( a ) total number of shares purchased as part of publicly announced plans or programs approximate dollar value of shares that may yet be purchased under the plans or programs ( b ) .

****************************************
• period, total numberof sharespurchased, averageprice paidper share, total number ofshares notpurchased as part ofpublicly announcedplans or programs ( a ), total number ofshares purchased aspart of publiclyannounced plans orprograms, approximate dollarvalue of shares thatmay yet be purchasedunder the plans orprograms ( b )
• october 2017, 515762, $ 77.15, 292145, 223617, $ 1.6 billion
• november 2017, 2186889, $ 81.21, 216415, 1970474, $ 1.4 billion
• december 2017, 2330263, $ 87.76, 798, 2329465, $ 1.2 billion
• total, 5032914, $ 83.83, 509358, 4523556, $ 1.2 billion
****************************************

( a ) the shares reported in this column represent purchases settled in the fourth quarter of 2017 relating to ( i ) our purchases of shares in open-market transactions to meet our obligations under stock-based compensation plans , and ( ii ) our purchases of shares from our employees and non-employee directors in connection with the exercise of stock options , the vesting of restricted stock , and other stock compensation transactions in accordance with the terms of our stock-based compensation plans . ( b ) on september 21 , 2016 , we announced that our board of directors authorized our purchase of up to $ 2.5 billion of our outstanding common stock ( the 2016 program ) with no expiration date . as of december 31 , 2017 , we had $ 1.2 billion remaining available for purchase under the 2016 program . on january 23 , 2018 , we announced that our board of directors authorized our purchase of up to an additional $ 2.5 billion of our outstanding common stock with no expiration date. .

Question: by what percentage did the share price increase from october to november 2017?
Program: subtract(81.21, 77.15), divide(#0, 77.15)
Answer: 0.05262
intangible asset amortization expense amounted to $ 12 million , $ 4 million and $ 4 million for the years ended december 31 , 2018 , 2017 and 2016 , respectively . estimated amortization expense for the next five years subsequent to december 31 , 2018 is as follows: .

 | amount
----------|----------
2019 | $ 15
2020 | 13
2021 | 11
2022 | 10
2023 | 7

note 9 : shareholders 2019 equity common stock under the dividend reinvestment and direct stock purchase plan ( the 201cdrip 201d ) , shareholders may reinvest cash dividends and purchase additional company common stock , up to certain limits , through the plan administrator without commission fees . shares purchased by participants through the drip may be newly issued shares , treasury shares , or at the company 2019s election , shares purchased by the plan administrator in the open market or in privately negotiated transactions . purchases generally will be made and credited to drip accounts once each week . as of december 31 , 2018 , there were approximately 4.2 million shares available for future issuance under the drip . anti-dilutive stock repurchase program in february 2015 , the company 2019s board of directors authorized an anti-dilutive stock repurchase program , which allowed the company to purchase up to 10 million shares of its outstanding common stock over an unrestricted period of time . the company repurchased 0.6 million shares and 0.7 million shares of common stock in the open market at an aggregate cost of $ 45 million and $ 54 million under this program for the years ended december 31 , 2018 and 2017 , respectively . as of december 31 , 2018 , there were 5.5 million shares of common stock available for purchase under the program. .

Question: at what price per share did awk repurchase its shares of common stock in 2018?
Program: divide(45, 0.6)
Answer: 75.0
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 ) 2006 2005 2004 sales and transfers of oil and gas produced , net of production , transportation and administrative costs $ ( 5312 ) $ ( 3754 ) $ ( 2689 ) net changes in prices and production , transportation and administrative costs related to future production ( 1342 ) 6648 771 .

----------------------------------------
( in millions )	2006	2005	2004
sales and transfers of oil and gas produced net of production transportation and administrative costs	$ -5312 ( 5312 )	$ -3754 ( 3754 )	$ -2689 ( 2689 )
net changes in prices and production transportation and administrative costs related to future production	-1342 ( 1342 )	6648	771
extensions discoveries and improved recovery less related costs	1290	700	1349
development costs incurred during the period	1251	1030	609
changes in estimated future development costs	-527 ( 527 )	-552 ( 552 )	-628 ( 628 )
revisions of previous quantity estimates	1319	820	948
net changes in purchases and sales of minerals in place	30	4557	33
accretion of discount	1882	1124	757
net change in income taxes	-660 ( 660 )	-6694 ( 6694 )	-627 ( 627 )
timing and other	-14 ( 14 )	307	97
net change for the year	-2083 ( 2083 )	4186	620
beginning of year	10601	6415	5795
end of year	$ 8518	$ 10601	$ 6415
net change for the year from discontinued operations	$ -216 ( 216 )	$ 162	$ -152 ( 152 )
----------------------------------------

.

Question: what was the average upward revisions of cash flow of previous quantity estimates during the three year period , in millions?
Program: table_average(revisions of previous quantity estimates, none)
Answer: 1029.0
acquired is represented by allied 2019s infrastructure of market-based collection routes and its related integrated waste transfer and disposal channels , whose value has been included in goodwill . all of the goodwill and other intangible assets resulting from the allied acquisition are not deductible for income tax purposes . pro forma information the consolidated financial statements presented for republic include the operating results of allied from december 5 , 2008 , the date of the acquisition . the following pro forma information is presented assuming the acquisition had been completed as of january 1 , 2008 . the unaudited pro forma information presented has been prepared for illustrative purposes and is not intended to be indicative of the results of operations that would have actually occurred had the acquisition been consummated at the beginning of the periods presented or of future results of the combined operations . furthermore , the pro forma results do not give effect to all cost savings or incremental costs that occur as a result of the integration and consolidation of the acquisition ( in millions , except share and per share amounts ) . year ended december 31 , ( unaudited ) .

****************************************
 | year ended december 31 2008 ( unaudited )
revenue | $ 9362.2
net income | 285.7
basic earnings per share | 0.76
diluted earnings per share | 0.75
****************************************

the unaudited pro forma financial information includes adjustments for amortization of identifiable intangible assets , accretion of discounts to fair value associated with debt , environmental , self-insurance and other liabilities , accretion of capping , closure and post-closure obligations and amortization of the related assets , and provision for income taxes . restructuring charges as a result of the 2008 allied acquisition , we committed to a restructuring plan related to our corporate overhead and other administrative and operating functions . the plan included closing our corporate office in florida , consolidating administrative functions to arizona , the former headquarters of allied , and reducing staffing levels . the plan also included closing and consolidating certain operating locations and terminating certain leases . during the years ended december 31 , 2010 and 2009 , we incurred $ 11.4 million , net of adjustments , and $ 63.2 million , respectively , of restructuring and integration charges related to our integration of allied . these charges and adjustments primarily related to severance and other employee termination and relocation benefits and consulting and professional fees . substantially all the charges are recorded in our corporate segment . we do not expect to incur additional charges to complete our plan . we expect that the remaining charges will be paid during 2011 . republic services , inc . notes to consolidated financial statements , continued .

Question: for the year ended december 31 2008 what was the net profit margin
Program: divide(285.7, 9362.2)
Answer: 0.03052
entergy texas , inc . and subsidiaries management 2019s financial discussion and analysis results of operations net income 2016 compared to 2015 net income increased $ 37.9 million primarily due to lower other operation and maintenance expenses , the asset write-off of its receivable associated with the spindletop gas storage facility in 2015 , and higher net revenue . 2015 compared to 2014 net income decreased $ 5.2 million primarily due to the asset write-off of its receivable associated with the spindletop gas storage facility and higher other operation and maintenance expenses , partially offset by higher net revenue and a lower effective tax rate . net revenue 2016 compared to 2015 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 . following is an analysis of the change in net revenue comparing 2016 to 2015 . amount ( in millions ) .

****************************************
 | amount ( in millions )
----------|----------
2015 net revenue | $ 637.2
reserve equalization | 14.3
purchased power capacity | 12.4
transmission revenue | 7.0
retail electric price | 5.4
net wholesale | -27.8 ( 27.8 )
other | -4.3 ( 4.3 )
2016 net revenue | $ 644.2
****************************************

the reserve equalization variance is primarily due to a reduction in reserve equalization expense primarily due to changes in the entergy system generation mix compared to the same period in 2015 as a result of the execution of a new purchased power agreement and entergy mississippi 2019s exit from the system agreement , each in november 2015 , and entergy texas 2019s exit from the system agreement in august 2016 . see note 2 to the financial statements for a discussion of the system agreement . the purchased power capacity variance is primarily due to decreased expenses due to the termination of the purchased power agreements between entergy louisiana and entergy texas in august 2016 , as well as capacity cost changes for ongoing purchased power capacity contracts . the transmission revenue variance is primarily due to an increase in attachment o rates charged by miso to transmission customers and a settlement of attachment o rates previously billed to transmission customers by miso. .

Question: what is the growth rate in net revenue in 2016 for entergy texas , inc.?
Program: subtract(644.2, 637.2), divide(#0, 637.2)
Answer: 0.01099
incentive compensation cost the following table shows components of compensation expense , relating to certain of the incentive compensation programs described above : in a0millions a0of a0dollars 2018 2017 2016 charges for estimated awards to retirement-eligible employees $ 669 $ 659 $ 555 amortization of deferred cash awards , deferred cash stock units and performance stock units 202 354 336 immediately vested stock award expense ( 1 ) 75 70 73 amortization of restricted and deferred stock awards ( 2 ) 435 474 509 .

========================================
Row 1: in millions of dollars, 2018, 2017, 2016
Row 2: charges for estimated awards to retirement-eligible employees, $ 669, $ 659, $ 555
Row 3: amortization of deferred cash awards deferred cash stock units and performance stock units, 202, 354, 336
Row 4: immediately vested stock award expense ( 1 ), 75, 70, 73
Row 5: amortization of restricted and deferred stock awards ( 2 ), 435, 474, 509
Row 6: other variable incentive compensation, 640, 694, 710
Row 7: total, $ 2021, $ 2251, $ 2183
========================================

( 1 ) represents expense for immediately vested stock awards that generally were stock payments in lieu of cash compensation . the expense is generally accrued as cash incentive compensation in the year prior to grant . ( 2 ) all periods include amortization expense for all unvested awards to non-retirement-eligible employees. .

Question: what was the percentage change in the total incentive compensation from 2017 to 2018
Program: subtract(2021, 2251), divide(#0, 2251)
Answer: -0.10218
american tower corporation and subsidiaries notes to consolidated financial statements loss on retirement of long-term obligations 2014loss on retirement of long-term obligations primarily includes cash paid to retire debt in excess of its carrying value , cash paid to holders of convertible notes in connection with note conversions and non-cash charges related to the write-off of deferred financing fees . loss on retirement of long-term obligations also includes gains from repurchasing or refinancing certain of the company 2019s debt obligations . earnings per common share 2014basic and diluted 2014basic income from continuing operations per common share for the years ended december 31 , 2012 , 2011 and 2010 represents income from continuing operations attributable to american tower corporation divided by the weighted average number of common shares outstanding during the period . diluted income from continuing operations per common share for the years ended december 31 , 2012 , 2011 and 2010 represents income from continuing operations attributable to american tower corporation divided by the weighted average number of common shares outstanding during the period and any dilutive common share equivalents , including unvested restricted stock , shares issuable upon exercise of stock options and warrants as determined under the treasury stock method and upon conversion of the company 2019s convertible notes , as determined under the if-converted method . retirement plan 2014the company has a 401 ( k ) plan covering substantially all employees who meet certain age and employment requirements . the company 2019s matching contribution for the years ended december 31 , 2012 , 2011 and 2010 is 50% ( 50 % ) up to a maximum 6% ( 6 % ) of a participant 2019s contributions . for the years ended december 31 , 2012 , 2011 and 2010 , the company contributed approximately $ 4.4 million , $ 2.9 million and $ 1.9 million to the plan , respectively . 2 . prepaid and other current assets prepaid and other current assets consist of the following as of december 31 , ( in thousands ) : .

 | 2012 | 2011 ( 1 )
prepaid income tax | $ 57665 | $ 31384
prepaid operating ground leases | 56916 | 49585
value added tax and other consumption tax receivables | 22443 | 81276
prepaid assets | 19037 | 28031
other miscellaneous current assets | 66790 | 59997
balance as of december 31, | $ 222851 | $ 250273

( 1 ) december 31 , 2011 balances have been revised to reflect purchase accounting measurement period adjustments. .

Question: for 2011 , tax related assets were how much of total current assets and prepaids?
Program: add(31384, 81276), divide(#0, 250273)
Answer: 0.45015
does not believe are in our and our stockholders 2019 best interest . the rights plan is intended to protect stockholders in the event of an unfair or coercive offer to acquire the company and to provide our board of directors with adequate time to evaluate unsolicited offers . the rights plan may prevent or make takeovers or unsolicited corporate transactions with respect to our company more difficult , even if stockholders may consider such transactions favorable , possibly including transactions in which stockholders might otherwise receive a premium for their shares . item 1b . unresolved staff comments item 2 . properties as of december 31 , 2016 , our significant properties used in connection with switching centers , data centers , call centers and warehouses were as follows: .

 | approximate number | approximate size in square feet
switching centers | 57 | 1400000
data centers | 8 | 600000
call center | 16 | 1300000
warehouses | 16 | 500000

as of december 31 , 2016 , we leased approximately 60000 cell sites . as of december 31 , 2016 , we leased approximately 2000 t-mobile and metropcs retail locations , including stores and kiosks ranging in size from approximately 100 square feet to 17000 square feet . we currently lease office space totaling approximately 950000 square feet for our corporate headquarters in bellevue , washington . we use these offices for engineering and administrative purposes . we also lease space throughout the u.s. , totaling approximately 1200000 square feet as of december 31 , 2016 , for use by our regional offices primarily for administrative , engineering and sales purposes . item 3 . legal proceedings see note 12 2013 commitments and contingencies of the notes to the consolidated financial statements included in part ii , item 8 of this form 10-k for information regarding certain legal proceedings in which we are involved . item 4 . mine safety disclosures part ii . item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities market information our common stock is traded on the nasdaq global select market of the nasdaq stock market llc ( 201cnasdaq 201d ) under the symbol 201ctmus . 201d as of december 31 , 2016 , there were 309 registered stockholders of record of our common stock , but we estimate the total number of stockholders to be much higher as a number of our shares are held by brokers or dealers for their customers in street name. .

Question: what is the average space of the warehouse in square feet
Program: divide(500000, 16)
Answer: 31250.0