whpthomas/finqa-parquet huggingface dataset:
part ii item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities our ordinary shares have been publicly traded since november 17 , 2011 when our ordinary shares were listed and began trading on the new york stock exchange ( 201cnyse 201d ) under the symbol 201cdlph . 201d on december 4 , 2017 , following the spin-off of delphi technologies , the company changed its name to aptiv plc and its nyse symbol to 201captv . 201d as of january 25 , 2019 , there were 2 shareholders of record of our ordinary shares . the following graph reflects the comparative changes in the value from december 31 , 2013 through december 31 , 2018 , assuming an initial investment of $ 100 and the reinvestment of dividends , if any in ( 1 ) our ordinary shares , ( 2 ) the s&p 500 index and ( 3 ) the automotive peer group . historical share prices of our ordinary shares have been adjusted to reflect the separation . historical performance may not be indicative of future shareholder returns . stock performance graph * $ 100 invested on december 31 , 2013 in our stock or in the relevant index , including reinvestment of dividends . fiscal year ended december 31 , 2018 . ( 1 ) aptiv plc , adjusted for the distribution of delphi technologies on december 4 , 2017 ( 2 ) s&p 500 2013 standard & poor 2019s 500 total return index ( 3 ) automotive peer group 2013 adient plc , american axle & manufacturing holdings inc , aptiv plc , borgwarner inc , cooper tire & rubber co , cooper- standard holdings inc , dana inc , dorman products inc , ford motor co , garrett motion inc. , general motors co , gentex corp , gentherm inc , genuine parts co , goodyear tire & rubber co , lear corp , lkq corp , meritor inc , motorcar parts of america inc , standard motor products inc , stoneridge inc , superior industries international inc , tenneco inc , tesla inc , tower international inc , visteon corp , wabco holdings inc company index december 31 , december 31 , december 31 , december 31 , december 31 , december 31 .
what is the difference in percentage performance for aptiv plc versus the s&p 500 for the five year period ending december 31 2018?
.
issuer purchases of equity securities during the three months ended december 31 , 2007 , we repurchased 8895570 shares of our class a common stock for an aggregate of $ 385.1 million pursuant to the $ 1.5 billion stock repurchase program publicly announced in february 2007 , as follows : period total number of shares purchased ( 1 ) average price paid per share total number of shares purchased as part of publicly announced plans or programs approximate dollar value of shares that may yet be purchased under the plans or programs ( in millions ) .
what is the total amount spent for stock repurchase during november 2007 , in millions?
( 1 ) issuer repurchases pursuant to the $ 1.5 billion stock repurchase program publicly announced in february 2007 . under this program , our management was authorized through february 2008 to purchase shares from time to time through open market purchases or privately negotiated transactions at prevailing prices as permitted by securities laws and other legal requirements , and subject to market conditions and other factors . to facilitate repurchases , we typically made purchases pursuant to trading plans under rule 10b5-1 of the exchange act , which allow us to repurchase shares during periods when we otherwise might be prevented from doing so under insider trading laws or because of self-imposed trading blackout periods . subsequent to december 31 , 2007 , we repurchased 4.3 million shares of our class a common stock for an aggregate of $ 163.7 million pursuant to this program . in february 2008 , our board of directors approved a new stock repurchase program , pursuant to which we are authorized to purchase up to an additional $ 1.5 billion of our class a common stock . purchases under this stock repurchase program are subject to us having available cash to fund repurchases , as further described in item 1a of this annual report under the caption 201crisk factors 2014we anticipate that we may need additional financing to fund our stock repurchase programs , to refinance our existing indebtedness and to fund future growth and expansion initiatives 201d and item 7 of this annual report under the caption 201cmanagement 2019s discussion and analysis of financial condition and results of operations 2014liquidity and capital resources . 201d .
table of contents index to financial statements item 3 . legal proceedings . item 4 . mine safety disclosures . not applicable . part ii price range our common stock trades on the nasdaq global select market under the symbol 201cmktx 201d . the range of closing price information for our common stock , as reported by nasdaq , was as follows : on february 16 , 2012 , the last reported closing price of our common stock on the nasdaq global select market was $ 32.65 . holders there were 41 holders of record of our common stock as of february 16 , 2012 . dividend policy we initiated a regular quarterly dividend in the fourth quarter of 2009 . during 2010 and 2011 , we paid quarterly cash dividends of $ 0.07 per share and $ 0.09 per share , respectively . in january 2012 , our board of directors approved a quarterly cash dividend of $ 0.11 per share payable on march 1 , 2012 to stockholders of record as of the close of business on february 16 , 2012 . any future declaration and payment of dividends will be at the sole discretion of the company 2019s board of directors . the board of directors may take into account such matters as general business conditions , the company 2019s financial results , capital requirements , contractual , legal , and regulatory restrictions on the payment of dividends to the company 2019s stockholders or by the company 2019s subsidiaries to the parent and any such other factors as the board of directors may deem relevant . recent sales of unregistered securities item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities. .
for the period from april 1 2011 to june 30 2011 , what was the difference between high and low stock price?
.
in direct competition with other co2 pipelines . we also compete with other interest owners in the mcelmo dome unit and the bravo dome unit for transportation of co2 to the denver city , texas market area . terminals our terminals segment includes the operations of our refined petroleum product , crude oil , chemical , ethanol and other liquid terminal facilities ( other than those included in the products pipelines segment ) and all of our coal , petroleum coke , fertilizer , steel , ores and other dry-bulk terminal facilities . our terminals are located throughout the u.s . and in portions of canada . we believe the location of our facilities and our ability to provide flexibility to customers help attract new and retain existing customers at our terminals and provide expansion opportunities . we often classify our terminal operations based on the handling of either liquids or dry-bulk material products . in addition , terminals 2019 marine operations include jones act qualified product tankers that provide marine transportation of crude oil , condensate and refined petroleum products in the u.s . the following summarizes our terminals segment assets , as of december 31 , 2016 : number capacity ( mmbbl ) .
what is the average capacity in mmbbl of jones act tankers?
competition we are one of the largest independent operators of liquids terminals in north america , based on barrels of liquids terminaling capacity . our liquids terminals compete with other publicly or privately held independent liquids terminals , and terminals owned by oil , chemical , pipeline , and refining companies . our bulk terminals compete with numerous independent terminal operators , terminals owned by producers and distributors of bulk commodities , stevedoring companies and other industrial companies opting not to outsource terminaling services . in some locations , competitors are smaller , independent operators with lower cost structures . our jones act qualified product tankers compete with other jones act qualified vessel fleets. .
morgan stanley notes to consolidated financial statements 2014 ( continued ) the following table presents a reconciliation of the beginning and ending amount of unrecognized tax benefits for 2013 , 2012 and 2011 ( dollars in millions ) : unrecognized tax benefits .
without settlements in 2013 , what would ending unrecognized tax benefits have been , in millions?
the company is under continuous examination by the irs and other tax authorities in certain countries , such as japan and the u.k. , and in states in which the company has significant business operations , such as new york . the company is currently under review by the irs appeals office for the remaining issues covering tax years 1999 2013 2005 . also , the company is currently at various levels of field examination with respect to audits by the irs , as well as new york state and new york city , for tax years 2006 2013 2008 and 2007 2013 2009 , respectively . during 2014 , the company expects to reach a conclusion with the u.k . tax authorities on substantially all issues through tax year 2010 . the company believes that the resolution of tax matters will not have a material effect on the consolidated statements of financial condition of the company , although a resolution could have a material impact on the company 2019s consolidated statements of income for a particular future period and on the company 2019s effective income tax rate for any period in which such resolution occurs . the company has established a liability for unrecognized tax benefits that the company believes is adequate in relation to the potential for additional assessments . once established , the company adjusts unrecognized tax benefits only when more information is available or when an event occurs necessitating a change . the company periodically evaluates the likelihood of assessments in each taxing jurisdiction resulting from the expiration of the applicable statute of limitations or new information regarding the status of current and subsequent years 2019 examinations . as part of the company 2019s periodic review , federal and state unrecognized tax benefits were released or remeasured . as a result of this remeasurement , the income tax provision included a discrete tax benefit of $ 161 million and $ 299 million in 2013 and 2012 , respectively . it is reasonably possible that the gross balance of unrecognized tax benefits of approximately $ 4.1 billion as of december 31 , 2013 may decrease significantly within the next 12 months due to an expected completion of the .
notes to consolidated financial statements the amortized cost and fair value of fixed maturities by contractual maturity as of december 31 , 2007 , are as follows : amortized fair ( millions ) cost value .
what is the percentage of fairvalue of contracts due after ten years among the total?
expected maturities may differ from contractual maturities because borrowers may have the right to call or prepay obligations with or without call or prepayment penalties . for categorization purposes , aon considers any rating of baa or higher by moody 2019s investor services or equivalent rating agency to be investment grade . aon 2019s continuing operations have no fixed maturities with an unrealized loss at december 31 , 2007 . aon 2019s fixed-maturity portfolio is subject to interest rate , market and credit risks . with a carrying value of approximately $ 150 million at december 31 , 2007 , aon 2019s total fixed-maturity portfolio is approximately 96% ( 96 % ) investment grade based on market value . aon 2019s non publicly-traded fixed maturity portfolio had a carrying value of $ 9 million . valuations of these securities primarily reflect the fundamental analysis of the issuer and current market price of comparable securities . aon 2019s equity portfolio is comprised of a preferred stock not publicly traded . this portfolio is subject to interest rate , market , credit , illiquidity , concentration and operational performance risks . limited partnership securitization . in 2001 , aon sold the vast majority of its limited partnership ( lp ) portfolio , valued at $ 450 million , to peps i , a qspe . the common stock interest in peps i is held by a limited liability company which is owned by aon ( 49% ( 49 % ) ) and by a charitable trust , which is not controlled by aon , established for victims of september 11 ( 51% ( 51 % ) ) . approximately $ 171 million of investment grade fixed-maturity securities were sold by peps i to unaffiliated third parties . peps i then paid aon 2019s insurance underwriting subsidiaries the $ 171 million in cash and issued to them an additional $ 279 million in fixed-maturity and preferred stock securities . as part of this transaction , aon is required to purchase from peps i additional fixed-maturity securities in an amount equal to the unfunded limited partnership commitments , as they are requested . aon funded $ 2 million of commitments in both 2007 and 2006 . as of december 31 , 2007 , these unfunded commitments amounted to $ 44 million . these commitments have specific expiration dates and the general partners may decide not to draw on these commitments . the carrying value of the peps i preferred stock was $ 168 million and $ 210 million at december 31 , 2007 and 2006 , respectively . prior to 2007 , income distributions received from peps i were limited to interest payments on various peps i debt instruments . beginning in 2007 , peps i had redeemed or collateralized all of its debt , and as a result , began to pay preferred income distributions . in 2007 , the company received $ 61 million of income distributions from peps i , which are included in investment income . aon corporation .
available , we do not expect any transactions to have a significant impact on our reported income tax expense . in connection with the completion of the reorganization , we will reevaluate the ability to realize our deferred tax assets related to u.s . operations under the new aon uk corporate structure and we may recognize a non-cash , deferred tax expense upon the conclusion of this evaluation . based on information currently available , we do not expect the additional deferred tax expense , if any , to be significant . the reorganization will result in additional ongoing costs to us . the completion of the reorganization will result in an increase in some of our ongoing expenses and require us to incur some new expenses . some costs , including those related to employees in our u.k . offices and holding board meetings in the u.k. , are expected to be higher than would be the case if our principal executive offices were not relocated to the u.k. . we also expect to incur new expenses , including professional fees and sdrt in connection with settlement of equity-based awards under our stock or share incentive plans , to comply with u.k . corporate and tax laws . item 1b . unresolved staff comments . item 2 . properties . we have offices in various locations throughout the world . substantially all of our offices are located in leased premises . we maintain our corporate headquarters at 200 e . randolph street in chicago , illinois , where we occupy approximately 355000 square feet of space under an operating lease agreement that expires in 2013 . there are two five-year renewal options at current market rates . we own one building at pallbergweg 2-4 , amsterdam , the netherlands ( 150000 square feet ) . the following are additional significant leased properties , along with the occupied square footage and expiration. .
considering the properties with lease expiration dates in 2020 , what is the average occupied square footage?
7201 hewitt associates drive , charlotte , north carolina . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218000 2015 the locations in lincolnshire , illinois , the woodlands , texas , orlando , florida , and charlotte north carolina , each of which were acquired as part of the hewitt acquisition in 2010 , are primarily dedicated to our hr solutions segment . the other locations listed above house personnel from each of our business segments . in november 2011 , aon entered into an agreement to lease 190000 square feet in a new building to be constructed in london , united kingdom . the agreement is contingent upon the completion of the building construction . aon expects to move into the new building in 2015 when it exercises an early break option at the devonshire square location. .
s c h e d u l e i v ( continued ) 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 , 2008 , 2007 , and 2006 ( in millions of u.s . dollars ) direct amount ceded to companies assumed from other companies net amount percentage of amount assumed to .
what is the percentage of amount ceded to direct amount in 2007?
.
republic services , inc . notes to consolidated financial statements 2014 ( continued ) we determine the discount rate used in the measurement of our obligations based on a model that matches the timing and amount of expected benefit payments to maturities of high quality bonds priced as of the pension plan measurement date . when that timing does not correspond to a published high-quality bond rate , our model uses an expected yield curve to determine an appropriate current discount rate . the yields on the bonds are used to derive a discount rate for the liability . the term of our obligation , based on the expected retirement dates of our workforce , is approximately ten years . in developing our expected rate of return assumption , we have evaluated the actual historical performance and long-term return projections of the plan assets , which give consideration to the asset mix and the anticipated timing of the pension plan outflows . we employ a total return investment approach whereby a mix of equity and fixed income investments are used to maximize the long-term return of plan assets for what we consider a prudent level of risk . the intent of this strategy is to minimize plan expenses by outperforming plan liabilities over the long run . risk tolerance is established through careful consideration of plan liabilities , plan funded status and our financial condition . the investment portfolio contains a diversified blend of equity and fixed income investments . furthermore , equity investments are diversified across u.s . and non-u.s . stocks as well as growth , value , and small and large capitalizations . derivatives may be used to gain market exposure in an efficient and timely manner ; however , derivatives may not be used to leverage the portfolio beyond the market value of the underlying investments . investment risk is measured and monitored on an ongoing basis through annual liability measurements , periodic asset and liability studies , and quarterly investment portfolio reviews . the following table summarizes our target asset allocation for 2014 and actual asset allocation as of december 31 , 2014 and 2013 for our defined benefit pension plan : target allocation actual allocation actual allocation .
based on the 2014 actualassetallocation what was the debt to equity ratio
for 2015 , the investment strategy for pension plan assets is to maintain a broadly diversified portfolio designed to achieve our target of an average long-term rate of return of 6.35% ( 6.35 % ) . while we believe we can achieve a long- term average return of 6.35% ( 6.35 % ) , we cannot be certain that the portfolio will perform to our expectations . assets are strategically allocated among debt and equity portfolios to achieve a diversification level that reduces fluctuations in investment returns . asset allocation target ranges and strategies are reviewed periodically with the assistance of an independent external consulting firm. .
american tower corporation and subsidiaries notes to consolidated financial statements 2014 ( continued ) for the years ended december 31 , 2007 and 2006 , the company increased net deferred tax assets by $ 1.5 million and $ 7.2 million , respectively with a corresponding reduction of goodwill associated with the utilization of net operating and capital losses acquired in connection with the spectrasite , inc . merger . these deferred tax assets were assigned a full valuation allowance as part of the final spectrasite purchase price allocation in june 2006 , as evidence available at the time did not support that losses were more likely than not to be realized . the valuation allowance decreased from $ 308.2 million as of december 31 , 2006 to $ 88.2 million as of december 31 , 2007 . the decrease was primarily due to a $ 149.6 million reclassification to the fin 48 opening balance ( related to federal and state net operating losses acquired in connection with the spectrasite , inc . merger ) and $ 45.2 million of allowance reductions during the year ended december 31 , 2007 related to state net operating losses , capital loss expirations of $ 6.5 million and other items . the company 2019s deferred tax assets as of december 31 , 2007 and 2006 in the table above do not include $ 74.9 million and $ 31.0 million , respectively , of excess tax benefits from the exercises of employee stock options that are a component of net operating losses due to the adoption of sfas no . 123r . total stockholders 2019 equity will be increased by $ 74.9 million if and when any such excess tax benefits are ultimately realized . basis step-up from corporate restructuring represents the tax effects of increasing the basis for tax purposes of certain of the company 2019s assets in conjunction with its spin-off from american radio systems corporation , its former parent company . at december 31 , 2007 , the company had net federal and state operating loss carryforwards available to reduce future federal and state taxable income of approximately $ 1.6 billion and $ 2.1 billion , respectively . if not utilized , the company 2019s net operating loss carryforwards expire as follows ( in thousands ) : .
what is the change in balance of unrecognized tax benefits during 2007?
as described in note 1 , the company adopted the provisions of fin 48 on january 1 , 2007 . as of january 1 , 2007 , the total amount of unrecognized tax benefits was $ 183.9 million of which $ 34.3 million would affect the effective tax rate , if recognized . as of december 31 , 2007 , the total amount of unrecognized tax benefits was $ 59.2 million , $ 23.0 million of which would affect the effective tax rate , if recognized . the company expects the unrecognized tax benefits to change over the next 12 months if certain tax matters ultimately settle with the applicable taxing jurisdiction during this timeframe . however , based on the status of these items and the amount of uncertainty associated with the outcome and timing of audit settlements , the .