{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["Print","Title Page","i","1","2","91440F1D0FFA4902BC14BDE93F7637F","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","BS Equity Parentheticals","Development","Proof-THG","Proof-BS","BS Retrieve","Essbase - P&C BS","Proof-P&C","Proof-Inv.","Proof-History","Ver Doc 2.2","Ver Doc 2.1","Ver Doc 2.0","Ver Doc 1.0","Ver Doc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":12,"defined_names":3147,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Print","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Title Page","index":1,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,"PERIOD","Product Qualifier","Summary Centers","VERSION","Consolidated BU Rollup","All Products"]

{"sheet":"i","index":2,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"THE HANOVER INSURANCE GROUP"]
[null,"FINANCIAL SUPPLEMENT"]
[]
[]
[]
[]
[null,"TABLE OF CONTENTS"]
[]
[]
[null,"Business Descriptions..........................................................................................","1"]
[null,"Financial Highlights..........................................................................................","2"]
[null,"Consolidated Financial Statements"]
[null,"Income Statements..........................................................................................","3"]
[null,"Balance Sheets..................................................................................................","4"]
[null,"GAAP Underwriting Results"]
[null,"Consolidated..............................................................................................","5-7"]
[null,"Commercial Lines..............................................................................................","8-10"]
[null,"Personal Lines..............................................................................................","11-13"]
[null,"Chaucer..............................................................................................................","14-16"]
[null,"Investments"]
[null,"Net Investment Income and Yields..................................................................................",17]
[null,"Investment Portfolio..........................................................................................",18]
[null,"Credit Quality and Duration of Fixed Maturities..................................................................................................",19]
[null,"Top 10 Corporate and Municipal Fixed Maturity Holdings..................................................................................................",20]
[null,"Reconciliation of Operating Income to Net Income..........................................................................................",21]
[null,"Other Information","  "]
[null,"Non-GAAP Financial Measures..............................................................................................",22]
[null,"Corporate Information..............................................................................................",23]
[null,"Market and Dividend Information..............................................................................................",23]
[null,"Financial Strength and Debt Ratings..............................................................................................",23]

{"sheet":"1","index":3,"n_rows":44,"n_cols":1,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,0,43,37],[13,0,13,37],[10,0,10,37],[11,0,11,37],[15,0,15,37],[17,0,17,37],[21,0,21,37],[33,0,33,37],[31,0,31,37],[37,0,37,37],[35,0,35,37],[39,0,39,37],[29,0,29,37],[0,0,0,37],[2,0,2,37],[25,0,25,37],[23,0,23,37],[4,0,5,37]]}
["THE HANOVER INSURANCE GROUP"]
[]
["BASIS OF PRESENTATION"]
[]
["Prior periods were restated for the effect of the Company's adoption of ASC Update No 2015-03, (Subtopic 835-30) Interest - Imputation of Interest: Simplify the Presentation of Debt Issuance Costs, on the Balance Sheet and Income Statement. "]
[]
[]
["BUSINESS DESCRIPTIONS"]
[]
["COMMERCIAL LINES"]
[]
["Commercial multiple peril coverage insures businesses against third party liability from accidents occurring on their premises or arising out of their operations, such as injuries sustained from products sold. It also insures business property for damage, such as that caused by fire, wind, hail, water damage (except for flooding), theft and vandalism."]
[]
["Commercial automobile coverage insures businesses against losses incurred from personal bodily injury, bodily injury to third parties, property damage to an insured’s vehicle, and property damage to other vehicles and property."]
[]
["Workers’ compensation coverage insures employers against employee medical and indemnity claims resulting from injuries related to work. Workers’ compensation policies are often written in conjunction with other commercial policies."]
[]
["Other Commercial Lines is comprised of inland marine, which insures businesses against physical losses to property, such as contractor’s equipment, builders’ risk and goods in transit. We also offer underwriting and managing of program business, including to under-served markets where there are specialty coverage or risk management needs. Other Commercial Lines also includes bonds, which provides businesses with contract surety coverage in the event of performance or payment claims, and commercial surety coverage related to fiduciary or regulatory obligations. Also included in Other Commercial Lines coverages are umbrella, general liability, fire, specialty property, and professional and management liability."]
[]
["PERSONAL LINES"]
[]
["Personal automobile coverage insures individuals against losses incurred from personal bodily injury, bodily injury to third parties, property damage to an insured’s vehicle, and property damage to other vehicles and other property."]
[]
["Homeowners coverage insures individuals for losses to their residences and personal property, such as those caused by fire, wind, hail, water damage (except for flooding), theft and vandalism, and against third party liability claims."]
[]
["Other Personal Lines are comprised of personal inland marine (jewelry, art, etc.), umbrella, fire, personal watercraft, earthquake and other miscellaneous coverages."]
[]
["CHAUCER"]
[]
["The Chaucer reporting segment represents THG's international business written through Lloyd's and includes international property, marine and aviation, energy, UK motor and international casualty and other coverages."]
[]
["Marine and Aviation includes coverages that insure marine hull, excess of loss, liability, cargo and specie, in addition to political risk and war business coverages. It also includes aviation coverages that insure airline hull and liability, general aviation, refuellers, aviation products and satellite."]
[]
["Property coverage, including direct, facultative and treaty property accounts, insures property, including commercial, auto, and industrial businesses, against physical loss or damage and business interruption. The property treaty account comprises mainly catastrophe and per risk excess contract acceptances, with a small amount of proportional treaty and reinsurance assumed business."]
[]
["Energy coverage, encompassing exploration and production, construction, liabilities downstream and renewables, insures energy businesses against physical damage, business interruption, control of well, seepage and pollution and liabilities. Energy also includes Nuclear, which predominantly provides coverage relating to power generation at nuclear power stations."]
[]
["Casualty and Other Lines includes coverages that insure financial institutions crime and professional indemnity, medical malpractice, workers' compensation and professional, managerial and general liability, as well as syndicate participations. "]
[]
["UK Motor coverage insures the UK private car and fleet markets. In addition, it writes specialist classes including commercial vehicle, taxi, motorcycle, motor trade and classic/specialist vehicles, as well as other UK small commercial products. The Company exited this business effective June 30, 2015."]
[]
["OTHER "]
[]
["Included in Other are Opus, which provides investment advisory services to affiliates and also manages assets for unaffiliated institutions such as insurance companies, retirement plans and foundations; earnings on holding company assets; and a discontinued voluntary pools business."]

{"sheet":"2","index":4,"n_rows":63,"n_cols":22,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,21],[1,0,1,21]]}
["THE HANOVER INSURANCE GROUP"]
["FINANCIAL HIGHLIGHTS"]
[]
[]
[null,null,null,"Q2",null,null,"Q3",null,null,"Q4",null,null,"Q1",null,null,"Q2",null,null,"Jun-YTD",null,null,"Jun-YTD"]
["(In millions, except earnings per share)",null,null,"2015",null,null,"2015",null,null,"2015",null,null,"2016",null,null,"2016",null,null,"2015",null,null,"2016"]
["PREMIUMS"]
["Gross premiums written ",null,"$",1434500000,null,"$",1379700000,null,"$",1174300000,null,"$",1375000000,null,"$",1402000000,null,"$",2890500000,null,"$",2777000000]
[]
["Net premiums written (1)",null,null,1293400000,null,null,1199600000,null,null,1046100000,null,null,1144300000,null,null,1221600000,null,null,2508500000,null,null,2365900000]
[]
["Net premiums earned",null,null,1205800000,null,null,1150100000,null,null,1137900000,null,null,1151300000,null,null,1145500000,null,null,2416800000,null,null,2296800000]
[]
["EARNINGS"]
["Operating income before interest and taxes",null,"$",119500000,null,"$",122600000,null,"$",123600000,null,"$",120400000,null,"$",94700000,null,"$",219900000,null,"$",215100000]
["Operating income after taxes",null,null,70400000,null,null,72200000,null,null,80300000,null,null,71500000,null,null,54000000,null,null,127500000,null,null,125500000]
[]
["Income from continuing operations",null,null,120900000,null,null,77200000,null,null,77800000,null,null,78100000,null,null,1900000,null,null,175800000,null,null,80000000]
[]
["Net income",null,null,120700000,null,null,78300000,null,null,77600000,78200000,null,78200000,null,null,2000000,null,null,175600000,null,null,80200000]
[]
["PER SHARE DATA (DILUTED) "]
[]
["Operating income after taxes",null,"$",1560000,null,"$",1610000,null,"$",1820000,null,"$",1640000,null,"$",1240000,null,"$",2830000,null,"$",2890000]
[]
["Income from continuing operations",null,null,2.69,null,null,1.72,null,null,1.76,null,null,1.79,null,null,0.04,null,null,3.9,null,null,1.84]
[]
["Net income ",null,null,2.68,null,null,1.74,null,null,1.76,null,null,1.8,null,null,0.05,null,null,3.9,null,null,1.84]
[]
["Weighted average shares outstanding",null,null,45000000,null,null,44900000,null,null,44100000,null,null,43500000,null,null,43400000,null,null,45100000,null,null,43500000]
[]
[]
[]
["BALANCE SHEET"]
[null,null,null,"June 30",null,null,"September 30",null,null,"December 31",null,null,"March 31",null,null,"June 30"]
["(In millions, except per share data)",null,null,"2015",null,null,"2015",null,null,"2015",null,null,"2016",null,null,"2016"]
[]
["Total assets",null,"$",14134600000,null,"$",14031200000,null,"$",13781200000,null,"$",14027700000,null,"$",14163600000]
["Total loss and loss adjustment expense reserves",null,null,6591300000,null,null,6606300000,null,null,6574400000,null,null,6722300000,null,null,6778000000]
["Total shareholders' equity",null,null,2908500000,null,null,2877500000,null,null,2844400000,null,null,2957000000,null,null,3009700000]
["Total shareholders' equity, excluding net unrealized appreciation"]
["depreciation on investments and derivative instruments, net of tax (2)",null,null,2675500000,null,null,2679600000,null,null,2694500000,null,null,2710600000,null,null,2686200000]
[]
["U.S. Property and Casualty Companies "]
["Statutory surplus",null,"$",2126.6,null,"$",2129.4,null,"$",2192.8000000000002,null,"$",2276.6999999999998,null,"$",2152.6]
["Premium to surplus ratio",null,null,"1.72:1",null,null,"1.74:1",null,null,"1.70:1",null,null,"1.65:1",null,null,"1.76:1"]
[]
["Book value per share",null,"$",66280000,null,"$",66550000,null,"$",66210000,null,"$",69300000,null,"$",70580000]
["Book value per share, excluding net unrealized appreciation"]
["depreciation on investments and derivative instruments, net of tax (2)",null,"$",60.96,null,"$",61.97,null,"$",62.72,null,"$",63.52,null,"$",62.99]
["Tangible book value per share (total book value excluding goodwill"]
["and intangibles)",null,"$",59790000,null,"$",60050000,null,"$",59580000,null,"$",62700000,null,"$",64110000]
[]
["Shares outstanding",null,null,43900000,null,null,43200000,null,null,43000000,null,null,42700000,null,null,42700000]
[]
["Total debt/equity",null,null,0.28399999999999997,null,null,0.27900000000000003,null,null,0.28199999999999997,null,null,0.27200000000000002,null,null,0.26500000000000001]
["Total debt/total capital",null,null,0.221,null,null,0.218,null,null,0.22,null,null,0.214,null,null,0.21]
[]
["(1) Net premiums written for Chaucer do not reflect the June 30, 2015 transfer of $137.4 million of unearned premium reserves previously written by the U.K. motor business. "]
["This transfer of unearned premium reserves is part of the disposal of the U.K. motor business and has no impact on net premiums earned."]
[]
["(2) The calculation of this measure has been updated, including prior periods, to include all values contained within the caption of net unrealized appreciation (depreciation) on investments and"]
[" derivative instruments, net of tax, as reported in the consolidated statements of shareholders’ equity in THG’s Form 10Q and Form 10K. "]

{"sheet":"91440F1D0FFA4902BC14BDE93F7637F","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"3","index":6,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,16]]}
["THE HANOVER INSURANCE GROUP"]
["CONSOLIDATED INCOME STATEMENTS"]
[]
[]
[]
[null,null,null,"Three Months ended June 30",null,null,null,null,null,null,null,"Six Months ended June 30"]
["(In millions)",null,null,"2016",null,null,"2015",null,"% Change",null,null,"2016",null,null,"2015",null,"% Change"]
[]
["REVENUES"]
["Premiums earned",null,"$",1145500000,null,"$",1205800000,null,-5,null,"$",2296800000,null,"$",2416800000,null,-5]
["Net investment income",null,null,69100000,null,null,70700000,null,-2.2999999999999998,null,null,137400000,null,null,140800000,null,-2.4]
["Net realized investment (losses) gains ",null,null,-700000,null,null,12600000,null,-105.6,null,null,800000,null,null,22000000,null,-96.4]
["Fees and other income",null,null,8100000,null,null,8000000,null,1.3,null,null,14600000,null,null,16200000,null,-9.9]
["Total revenues",null,null,1222000000,null,null,1297100000,null,-5.8,null,null,2449600000,null,null,2595800000,null,-5.6]
[" "]
["LOSSES AND EXPENSES"]
["Losses and loss adjustment expenses",null,null,729700000,null,null,744900000,null,-2,null,null,1429300000,null,null,1518000000,null,-5.8]
["Amortization of deferred acquisition costs",null,null,254400000,null,null,262000000,null,-2.9,null,null,513500000,null,null,522600000,null,-1.7]
["Interest expense",null,null,15600000,null,null,15000000,null,4,null,null,30300000,null,null,31100000,null,-2.6]
["Gain on disposal of U.K. motor business",null,null,-400000,null,null,-37700000,null,"N/M",null,null,-1200000,null,null,-37700000,null,"N/M"]
["Net loss from repayment of debt",null,null,86100000,null,null,1800000,null,"N/M",null,null,86100000,null,null,18500000,null,"N/M"]
["Other operating expenses",null,null,143700000,null,null,158500000,null,-9.3000000000000007,null,null,290600000,null,null,313700000,null,-7.4]
["Total losses and expenses",null,null,1229100000,null,null,1144500000,null,7.4,null,null,2348600000,null,null,2366200000,null,-0.7]
[" "]
[]
["Income (loss) from continuing operations before income taxes",null,null,-7100000,null,null,152600000,null,-104.7,null,null,101000000,null,null,229600000,null,-56]
["Income tax (benefit) expense",null,null,-9000000,null,null,31700000,null,-128.4,null,null,21000000,null,null,53800000,null,-61]
[" "]
["Income from continuing operations",null,null,1900000,null,null,120900000,null,-98.4,null,null,80000000,null,null,175800000,null,-54.5]
[null,null,null,null,null,null,null,null,"-    "]
["Discontinued operations",null,null,100000,null,null,-200000,null,"N/M",null,null,200000,null,null,-200000,null,"N/M"]
[]
["Net income",null,"$",2000000,null,"$",120700000,null,-98.3,null,"$",80200000,null,"$",175600000,null,-54.3]
[" "]

{"sheet":"4","index":7,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8]]}
["THE HANOVER INSURANCE GROUP"]
["CONSOLIDATED BALANCE SHEETS"]
[]
[]
[]
[null,null,null,"June 30",null,null,"December 31"]
["(In millions, except per share data)",null,null,"2016",null,null,"2015",null,"% Change"]
["ASSETS"]
["Investments:"]
["Fixed maturities, at fair value (amortized cost of $6,842.8 and $6,934.0)",null,"$",7142000000,null,"$",6983400000,null,2.2999999999999998]
["Equity securities, at fair value (cost of $507.8 and $528.5)",null,null,582700000,null,null,576600000,null,1.1000000000000001]
["Other investments",null,null,454800000,null,null,393400000,null,15.6]
["Total investments",null,null,8179500000,null,null,7953400000,null,2.8]
["Cash and cash equivalents",null,null,361600000,null,null,338800000,null,6.7]
["Accrued investment income",null,null,60600000,null,null,62900000,null,-3.7,null,null,null,null," "]
["Premiums and accounts receivable, net",null,null,1509800000,null,null,1391700000,null,8.5]
["Reinsurance recoverable on paid and unpaid losses and unearned premiums",null,null,2688100000,null,null,2635000000,null,2]
["Deferred acquisition costs",null,null,522500000,null,null,508800000,null,2.7]
["Deferred income taxes",null,null,50400000,null,null,137900000,null,-63.5]
["Goodwill",null,null,185200000,null,null,186000000,null,-0.4]
["Other assets",null,null,525700000,null,null,483700000,null,8.6999999999999993]
["Assets of discontinued operations",null,null,80200000,null,null,83000000,null,-3.4]
["Total assets",null,"$",14163600000,null,"$",13781200000,null,2.8]
[" ",null,null," ",null,null," "]
["LIABILITIES AND SHAREHOLDERS' EQUITY",null,null," ",null,null," ",null," "]
[]
["LIABILITIES"]
["Loss and loss adjustment expense reserves",null,"$",6778000000,null,"$",6574400000,null,3.1]
["Unearned premiums",null,null,2620500000,null,null,2540800000,null,3.1]
["Expenses and taxes payable",null,null,594000000,null,null,724900000,null,-18.100000000000001]
["Reinsurance premiums payable",null,null,274700000,null,null,205200000,null,33.9]
["Debt",null,null,797800000,null,null,803100000,null,-0.7]
["Liabilities of discontinued operations",null,null,88900000,null,null,88400000,null,0.6]
["Total liabilities",null,null,11153900000,null,null,10936800000,null,2]
[]
["SHAREHOLDERS' EQUITY"]
["Preferred stock, par value $0.01 per share;"]
["20.0 million shares authorized; none issued",null,null,0,null,null,0,null,"-    "]
["Common stock, par value $0.01 per share; 300.0 million shares"]
["authorized; 60.5 million shares issued",null,null,600000,null,null,600000,null,"-    "]
["Additional paid-in capital",null,null,1835200000,null,null,1833500000,null,0.1]
["Accumulated other comprehensive income",null,null,229400000,null,null,53900000,null,325.60000000000002]
["Retained earnings",null,null,1841500000,null,null,1803500000,null,2.1]
["Treasury stock at cost (17.8 and 17.5 million shares)",null,null,-897000000,null,null,-847100000,null,5.9]
["Total shareholders' equity",null,null,3009700000,null,null,2844400000,null,5.8]
["Total liabilities and shareholders' equity",null,"$",14163600000,null,"$",13781200000,null,2.8]

{"sheet":"5","index":8,"n_rows":77,"n_cols":32,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,31],[1,0,1,31],[3,0,3,31],[5,0,5,31],[9,3,9,16],[9,18,9,31]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["CONSOLIDATED"]
[]
["Three Months ended June 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,"2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015"]
[]
[null," "]
[null,null,null,null,"Commercial ",null,null,"Personal",null,null,null,null,null,null,null,null,null,null,null,"Commercial ",null,null,"Personal"]
["(In millions, except percentage data)",null,null,null,"Lines",null,null,"Lines",null,null,"Chaucer",null,null,"Other",null,null,"Total",null,null,"Lines",null,null,"Lines",null,null,"Chaucer",null,null,"Other",null,null,"Total"]
[]
[]
[null,"Gross premiums written",null,"$",662900000,null,"$",416600000,null,"$",322500000,null,"$",0,null,"$",1402000000,null,"$",642700000,null,"$",401800000,null,"$",390000000,null,"$",0,null,"$",1434500000]
[]
[null,"Net premiums written (1)",null,"$",579900000,null,"$",395300000,null,"$",246400000,null,"$",0,null,"$",1221600000,null,"$",569100000,null,"$",378300000,null,"$",346000000,null,"$",0,null,"$",1293400000]
[]
[null,"Net premiums earned",null,"$",574700000,null,"$",364700000,null,"$",206100000,null,"$",0,null,"$",1145500000,null,"$",557000000,null,"$",356700000,null,"$",292100000,null,"$",0,null,"$",1205800000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,312900000,null,null,221200000,null,null,129600000,null,null,0,null,null,663700000,null,null,317200000,null,null,222800000,null,null,186900000,null,null,100000,null,null,727000000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,22100000,null,null,900000,null,null,-8300000,null,null,300000,null,null,15000000,null,null,6000000,null,null,-1900000,null,null,-33000000,null,null,300000,null,null,-28600000]
[]
[null,"Current accident year catastrophe losses",null,null,26600000,null,null,9700000,null,null,26000000,null,null,0,null,null,62300000,null,null,23800000,null,null,16400000,null,null,7000000,null,null,0,null,null,47200000]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-700000,null,null,1500000,null,null,-12100000,null,null,0,null,null,-11300000,null,null,-600000,null,null,4500000,null,null,-4600000,null,null,0,null,null,-700000]
[]
[null,"Total losses and LAE",null,null,360900000,null,null,233300000,null,null,135200000,null,null,300000,null,null,729700000,null,null,346400000,null,null,241800000,null,null,156300000,null,null,400000,null,null,744900000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,208700000,null,null,102100000,null,null,77400000,null,null,300000,null,null,388500000,null,null,202100000,null,null,101900000,null,null,108300000,null,null,300000,null,null,412600000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"GAAP underwriting profit (loss) ",null,null,5100000,null,null,29300000,null,null,-6500000,null,null,-600000,null,null,27300000,null,null,8500000,null,null,13000000,null,null,27500000,null,null,-700000,null,null,48300000]
[]
[null,"Net investment income",null,null,39100000,null,null,17100000,null,null,11300000,null,null,1600000,null,null,69100000,null,null,39400000,null,null,18300000,null,null,12000000,null,null,1000000,null,null,70700000]
[]
[null,"Other income",null,null,2300000,null,null,2700000,null,null,2400000,null,null,700000,null,null,8100000,null,null,2400000,null,null,2700000,null,null,2200000,null,null,700000,null,null,8000000]
[]
[null,"Other operating expenses",null,null,-2500000,null,null,-1700000,null,null,-1700000,null,null,-3900000,null,null,-9800000,null,null,-2100000,null,null,-1900000,null,null,300000,null,null,-3800000,null,null,-7500000]
[]
[null,"Operating income (loss) before income taxes",null,"$",44000000,null,"$",47400000,null,"$",5500000,null,"$",-2200000,null,"$",94700000,null,"$",48200000,null,"$",32100000,null,"$",42000000,null,"$",-2800000,null,"$",119500000]
[]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,0.54500000000000004,null,null,0.60699999999999998,null,null,0.629,null,null,"N/M",null,null,0.57899999999999996,null,null,0.56899999999999995,null,null,0.624,null,null,0.64,null,null,"N/M",null,null,0.60299999999999998]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,3.7999999999999999E-2,null,null,2E-3,null,null,-0.04,null,null,"N/M",null,null,1.2999999999999999E-2,null,null,1.0999999999999999E-2,null,null,-5.0000000000000001E-3,null,null,-0.113,null,null,"N/M",null,null,-2.4E-2]
[]
[null,"Current accident year catastrophe losses",null,null,4.5999999999999999E-2,null,null,2.7E-2,null,null,0.126,null,null,"N/M",null,null,5.5E-2,null,null,4.2999999999999997E-2,null,null,4.5999999999999999E-2,null,null,2.4E-2,null,null,"N/M",null,null,3.9E-2]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-1E-3,null,null,4.0000000000000001E-3,null,null,-5.8999999999999997E-2,null,null,"N/M",null,null,-0.01,null,null,-1E-3,null,null,1.2999999999999999E-2,null,null,-1.6E-2,null,null,"N/M",null,null,0]
[null,"Total loss and LAE ratio",null,null,0.628,null,null,0.64,null,null,0.65600000000000003,null,null,"N/M",null,null,0.63700000000000001,null,null,0.622,null,null,0.67800000000000005,null,null,0.53500000000000003,null,null,"N/M",null,null,0.61799999999999999]
[]
[null,"Expense ratio",null,null,0.36099999999999999,null,null,0.27300000000000002,null,null,0.376,null,null,"N/M",null,null,0.33600000000000002,null,null,0.36099999999999999,null,null,0.27900000000000003,null,null,0.371,null,null,"N/M",null,null,0.33900000000000002]
[]
[null,"Combined ratio",null,null,0.98899999999999999,null,null,0.91300000000000003,null,null,1.032,null,null,"N/M",null,null,0.97299999999999998,null,null,0.98299999999999998,null,null,0.95699999999999996,null,null,0.90600000000000003,null,null,"N/M",null,null,0.95699999999999996]
[]
[]
[null,"(1)  Net premiums written for Chaucer do not reflect the June 30, 2015 transfer of $137.4 million of unearned premium reserves previously written by the U.K. motor business. "]
[null,"This transfer of unearned premium reserves is part of the disposal of the U.K. motor business and has no impact on net premiums earned."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"6","index":9,"n_rows":76,"n_cols":32,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,31],[1,0,1,31],[3,0,3,31],[5,0,5,31],[9,2,9,16],[9,18,9,31]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["CONSOLIDATED"]
[]
["Six Months ended June 30"]
[]
[]
[]
[null,null,"2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015"]
[]
[null," "]
[null,null,null,null,"Commercial ",null,null,"Personal",null,null,null,null,null,null,null,null,null,null,null,"Commercial ",null,null,"Personal"]
[null,"(In millions, except percentage data)",null,null,"Lines",null,null,"Lines",null,null,"Chaucer",null,null,"Other",null,null,"Total",null,null,"Lines",null,null,"Lines",null,null,"Chaucer",null,null,"Other",null,null,"Total"]
[]
[null,"Gross premiums written",null,"$",1343000000,null,"$",773400000,null,"$",660600000,null,"$",0,null,"$",2777000000,null,"$",1298900000,null,"$",750900000,null,"$",840700000,null,"$",0,null,"$",2890500000]
[]
[null,"Net premiums written (1)",null,"$",1184200000,null,"$",732300000,null,"$",449400000,null,"$",0,null,"$",2365900000,null,"$",1151000000,null,"$",704700000,null,"$",652800000,null,"$",0,null,"$",2508500000]
[]
[null,"Net premiums earned",null,"$",1146100000,null,"$",723300000,null,"$",427400000,null,"$",0,null,"$",2296800000,null,"$",1103200000,null,"$",709600000,null,"$",604000000,null,"$",0,null,"$",2416800000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,633700000,null,null,436900000,null,null,271500000,null,null,0,null,null,1342100000,null,null,635900000,null,null,448800000,null,null,378200000,null,null,100000,null,null,1463000000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,42200000,null,null,200000,null,null,-38000000,null,null,600000,null,null,5000000,null,null,6900000,null,null,-4100000,null,null,-57200000,null,null,600000,null,null,-53800000]
[]
[null,"Current accident year catastrophe losses",null,null,45800000,null,null,20200000,null,null,36200000,null,null,0,null,null,102200000,null,null,63200000,null,null,39300000,null,null,10200000,null,null,0,null,null,112700000]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-1000000,null,null,2800000,null,null,-21800000,null,null,0,null,null,-20000000,null,null,-6100000,null,null,7100000,null,null,-4900000,null,null,0,null,null,-3900000]
[]
[null,"Total losses and LAE",null,null,720700000,null,null,460100000,null,null,247900000,null,null,600000,null,null,1429300000,null,null,699900000,null,null,491100000,null,null,326300000,null,null,700000,null,null,1518000000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,416600000,null,null,205300000,null,null,163500000,null,null,700000,null,null,786100000,null,null,400700000,null,null,202100000,null,null,214600000,null,null,700000,null,null,818100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"GAAP underwriting profit (loss) ",null,null,8800000,null,null,57900000,null,null,16000000,null,null,-1300000,null,null,81400000,null,null,2600000,null,null,16400000,null,null,63100000,null,null,-1400000,null,null,80700000]
[]
[null,"Net investment income",null,null,78500000,null,null,34500000,null,null,22000000,null,null,2400000,null,null,137400000,null,null,78000000,null,null,36200000,null,null,24300000,null,null,2300000,null,null,140800000]
[]
[null,"Other income",null,null,4200000,null,null,5500000,null,null,3500000,null,null,1400000,null,null,14600000,null,null,4300000,null,null,5900000,null,null,4500000,null,null,1500000,null,null,16200000]
[]
[null,"Other operating expenses",null,null,-4800000,null,null,-3400000,null,null,-2300000,null,null,-7800000,null,null,-18300000,null,null,-5500000,null,null,-4100000,null,null,-700000,null,null,-7500000,null,null,-17800000]
[]
[null,"Operating income (loss) before income taxes",null,"$",86700000,null,"$",94500000,null,"$",39200000,null,"$",-5300000,null,"$",215100000,null,"$",79400000,null,"$",54400000,null,"$",91200000,null,"$",-5100000,null,"$",219900000]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,0.55200000000000005,null,null,0.60399999999999998,null,null,0.63500000000000001,null,null,"N/M",null,null,0.58499999999999996,null,null,0.57599999999999996,null,null,0.63300000000000001,null,null,0.627,null,null,"N/M",null,null,0.60499999999999998]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,3.6999999999999998E-2,null,null,0,null,null,-8.8999999999999996E-2,null,null,"N/M",null,null,2E-3,null,null,6.0000000000000001E-3,null,null,-6.0000000000000001E-3,null,null,-9.5000000000000001E-2,null,null,"N/M",null,null,-2.1999999999999999E-2]
[]
[null,"Current accident year catastrophe losses",null,null,0.04,null,null,2.8000000000000001E-2,null,null,8.5000000000000006E-2,null,null,"N/M",null,null,4.4999999999999998E-2,null,null,5.8000000000000003E-2,null,null,5.5E-2,null,null,1.7000000000000001E-2,null,null,"N/M",null,null,4.7E-2]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-1E-3,null,null,4.0000000000000001E-3,null,null,-5.0999999999999997E-2,null,null,"N/M",null,null,-8.9999999999999993E-3,null,null,-6.0000000000000001E-3,null,null,0.01,null,null,-8.0000000000000002E-3,null,null,"N/M",null,null,-2E-3]
[null,"Total loss and LAE ratio",null,null,0.628,null,null,0.63600000000000001,null,null,0.57999999999999996,null,null,"N/M",null,null,0.623,null,null,0.63400000000000001,null,null,0.69199999999999995,null,null,0.54100000000000004,null,null,"N/M",null,null,0.628]
[]
[null,"Expense ratio",null,null,0.36199999999999999,null,null,0.27700000000000002,null,null,0.38300000000000001,null,null,"N/M",null,null,0.33900000000000002,null,null,0.36199999999999999,null,null,0.27800000000000002,null,null,0.35499999999999998,null,null,"N/M",null,null,0.33600000000000002]
[]
[null,"Combined ratio",null,null,0.99,null,null,0.91300000000000003,null,null,0.96299999999999997,null,null,"N/M",null,null,0.96199999999999997,null,null,0.996,null,null,0.97,null,null,0.89600000000000002,null,null,"N/M",null,null,0.96399999999999997]
[]
[]
[null,"(1)   Net premiums written for Chaucer do not reflect the June 30, 2015 transfer of $137.4 million of unearned premium reserves previously written by the U.K. motor business."]
[null,"This transfer of unearned premium reserves is part of the disposal of the U.K. motor business and has no impact on net premiums earned."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"7","index":10,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,16],[4,0,4,16]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING INFORMATION AND RELATED RATIOS"]
[]
[]
["CONSOLIDATED"]
[]
[]
[]
[null," "]
[null," ",null,null,"Q2",null,"Q3",null,"Q4",null,"Q1",null,"Q2",null,"Jun-YTD",null,"Jun-YTD"]
[null,"(In millions, except percentage data)",null,null,"2015",null,"2015",null,"2015",null,"2016",null,"2016",null,"2015",null,"2016"]
[]
[]
[]
[null,"Gross premiums written ",null,"$",1434500000,"$",1379700000,"$",1174300000,"$",1375000000,"$",1402000000,"$",2890500000,"$",2777000000]
[]
[null,"Net premiums written (1)",null,"$",1293400000,"$",1199600000,"$",1046100000,"$",1144300000,"$",1221600000,"$",2508500000,"$",2365900000]
[]
[null,"Net premiums earned",null,"$",1205800000,"$",1150100000,"$",1137900000,"$",1151300000,"$",1145500000,"$",2416800000,"$",2296800000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,727000000,null,667300000,null,666800000,null,678400000,null,663700000,null,1463000000,null,1342100000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,-28600000,null,-22400000,null,-18100000,null,-10000000,null,15000000,null,-53800000,null,5000000]
[]
[null,"Current accident year catastrophe losses",null,null,47200000,null,58200000,null,32200000,null,39900000,null,62300000,null,112700000,null,102200000]
[]
[null,"Prior accident year favorable catastrophe loss development",null,null,-700000,null,-12400000,null,-5500000,null,-8700000,null,-11300000,null,-3900000,null,-20000000]
[]
[null,"Total losses and LAE",null,null,744900000,null,690700000,null,675400000,null,699600000,null,729700000,null,1518000000,null,1429300000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,412600000,null,404500000,null,409200000,null,397600000,null,388500000,null,818100000,null,786100000]
[]
[null,"GAAP underwriting profit ",null,"$",48300000,"$",54900000,"$",53300000,"$",54100000,"$",27300000,"$",80700000,"$",81400000]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,0.60299999999999998,null,0.57999999999999996,null,0.58699999999999997,null,0.59,null,0.57899999999999996,null,0.60499999999999998,null,0.58499999999999996]
[]
[null,"Prior accident year reserve unfavorable (favorable) development, excluding catastrophe losses",null,null,-2.4E-2,null,-1.9E-2,null,-1.6E-2,null,-8.9999999999999993E-3,null,1.2999999999999999E-2,null,-2.1999999999999999E-2,null,2E-3]
[]
[null,"Current accident year catastrophe losses",null,null,3.9E-2,null,5.0999999999999997E-2,null,2.8000000000000001E-2,null,3.5000000000000003E-2,null,5.5E-2,null,4.7E-2,null,4.4999999999999998E-2]
[]
[null,"Prior accident year favorable catastrophe loss development",null,null,0,null,-1.0999999999999999E-2,null,-5.0000000000000001E-3,null,-8.0000000000000002E-3,null,-0.01,null,-2E-3,null,-8.9999999999999993E-3]
[]
[null,"Total loss and LAE ratio",null,null,0.61799999999999999,null,0.60099999999999998,null,0.59399999999999997,null,0.60799999999999998,null,0.63700000000000001,null,0.628,null,0.623]
[]
[null,"Expense ratio",null,null,0.33900000000000002,null,0.34799999999999998,null,0.35599999999999998,null,0.34200000000000003,null,0.33600000000000002,null,0.33600000000000002,null,0.33900000000000002]
[]
[null,"Combined ratio",null,null,0.95699999999999996,null,0.94899999999999995,null,0.95,null,0.95,null,0.97299999999999998,null,0.96399999999999997,null,0.96199999999999997]
[]
[]
[]
[null,"Combined ratio, excluding catastrophe losses",null,null,0.91800000000000004,null,0.90900000000000003,null,0.92700000000000005,null,0.92300000000000004,null,0.92800000000000005,null,0.91900000000000004,null,0.92600000000000005]
[]
[null,"Current accident year combined ratio, excluding catastrophe losses",null,null,0.94199999999999995,null,0.92800000000000005,null,0.94299999999999995,null,0.93200000000000005,null,0.91500000000000004,null,0.94099999999999995,null,0.92400000000000004]
[]
[]
[null,"(1)  Net premiums written for Chaucer do not reflect the June 30, 2015 transfer of $137.4 million of unearned premium reserves previously written by the U.K. motor business. "]
[null,"This transfer of unearned premium reserves is part of the disposal of the U.K. motor business and has no impact on net premiums earned."]

{"sheet":"8","index":11,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,0,1,22],[3,0,3,22],[5,0,5,22],[9,2,9,11],[9,13,9,22]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["COMMERCIAL LINES"]
[]
["Three Months ended June 30"]
[]
[]
[]
[null,null,"2016",null,null,null,null,null,null,null,null,null,null,"2015"]
[]
[null," "]
[null," ",null,"Multiple",null,null,null,"Workers'",null,null,null,null,null,null,"Multiple",null,null,null,"Workers'"]
[null,"(In millions, except percentage data)",null,"Peril",null,"Auto",null,"Comp",null,"Other",null,"Total ",null,null,"Peril",null,"Auto",null,"Comp",null,"Other",null,"Total "]
[]
[]
[null,"Net premiums written","$",191600000,"$",78000000,"$",66700000,"$",243600000,"$",579900000,null,"$",182700000,"$",76800000,"$",62100000,"$",247500000,"$",569100000]
[]
[null,"Net premiums earned","$",191600000,"$",76300000,"$",67900000,"$",238900000,"$",574700000,null,"$",180400000,"$",76100000,"$",65900000,"$",234600000,"$",557000000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,89800000,null,52700000,null,46500000,null,123900000,null,312900000,null,null,91000000,null,53700000,null,45700000,null,126800000,null,317200000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,13900000,null,4200000,null,-6500000,null,10500000,null,22100000,null,null,1300000,null,1800000,null,-2300000,null,5200000,null,6000000]
[]
[null,"Current accident year catastrophe losses",null,17600000,null,400000,null,0,null,8600000,null,26600000,null,null,13100000,null,900000,null,0,null,9800000,null,23800000]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,-100000,null,0,null,0,null,-600000,null,-700000,null,null,-1300000,null,0,null,0,null,700000,null,-600000]
[]
[null,"Total losses and LAE",null,121200000,null,57300000,null,40000000,null,142400000,null,360900000,null,null,104100000,null,56400000,null,43400000,null,142500000,null,346400000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,null,null,null,null,null,null,null,208700000,null,null,null,null,null,null,null,null,null,null,202100000]
[]
[null,"GAAP underwriting profit",null,null,null,null,null,null,null,null,null,5100000,null,null,null,null,null,null,null,null,null,null,8500000]
[]
[null,"Net investment income",null,null,null,null,null,null,null,null,null,39100000,null,null,null,null,null,null,null,null,null,null,39400000]
[]
[null,"Other income",null,null,null,null,null,null,null,null,null,2300000,null,null,null,null,null,null,null,null,null,null,2400000]
[]
[null,"Other operating expenses",null,null,null,null,null,null,null,null,null,-2500000,null,null,null,null,null,null,null,null,null,null,-2100000]
[]
[null,"Operating income before income taxes",null,null,null,null,null,null,null,null,"$",44000000,null,null,null,null,null,null,null,null,null,"$",48200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,0.46899999999999997,null,0.69099999999999995,null,0.68600000000000005,null,0.51900000000000002,null,0.54500000000000004,null,null,0.505,null,0.70499999999999996,null,0.69399999999999995,null,0.54,null,0.56899999999999995]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,7.2999999999999995E-2,null,5.5E-2,null,-9.6000000000000002E-2,null,4.3999999999999997E-2,null,3.7999999999999999E-2,null,null,7.0000000000000001E-3,null,2.4E-2,null,-3.5000000000000003E-2,null,2.1999999999999999E-2,null,1.0999999999999999E-2]
[]
[null,"Current accident year catastrophe losses",null,9.1999999999999998E-2,null,5.0000000000000001E-3,null,"-",null,3.5999999999999997E-2,null,4.5999999999999999E-2,null,null,7.1999999999999995E-2,null,1.2E-2,null,"-",null,4.2000000000000003E-2,null,4.2999999999999997E-2]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,-1E-3,null,"-",null,"-",null,-3.0000000000000001E-3,null,-1E-3,null,null,-7.0000000000000001E-3,null,"-",null,"-",null,3.0000000000000001E-3,null,-1E-3]
[null,"Total loss and LAE ratio",null,0.63300000000000001,null,0.751,null,0.59,null,0.59599999999999997,null,0.628,null,null,0.57699999999999996,null,0.74099999999999999,null,0.65900000000000003,null,0.60699999999999998,null,0.622]
[]
[null,"Expense ratio",null,null,null,null,null,null,null,null,null,0.36099999999999999,null,null,null,null,null,null,null,null,null,null,0.36099999999999999]
[]
[null,"Combined ratio",null,null,null,null,null,null,null,null,null,0.98899999999999999,null,null,null,null,null,null,null,null,null,null,0.98299999999999998]
[]
[]
[]
[null,"Change in policies in force",null,5.1999999999999998E-2,null,-3.2000000000000001E-2,null,-0.03,null,4.1000000000000002E-2,null,2.5999999999999999E-2,null,null,0.06,null,-3.7999999999999999E-2,null,-2.8000000000000001E-2,null,5.5E-2,null,3.3000000000000002E-2]
[]
[null,"Retention",null,0.85899999999999999,null,0.79800000000000004,null,0.79300000000000004,null,"N/M",null,0.83499999999999996,null,null,0.85699999999999998,null,0.80800000000000005,null,0.77400000000000002,null,"N/M",null,0.83199999999999996]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"9","index":12,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,0,1,22],[3,0,3,22],[5,0,5,22],[9,2,9,11],[9,13,9,22]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["COMMERCIAL LINES"]
[]
["Six Months ended June 30"]
[]
[]
[]
[null,null,"2016",null,null,null,null,null,null,null,null,null,null,"2015"]
[]
[null," "]
[null," ",null,"Multiple",null,null,null,"Workers'",null,null,null,null,null,null,"Multiple",null,null,null,"Workers'"]
[null,"(In millions, except percentage data)",null,"Peril",null,"Auto",null,"Comp",null,"Other",null,"Total ",null,null,"Peril",null,"Auto",null,"Comp",null,"Other",null,"Total "]
[]
[]
[null,"Net premiums written","$",389600000,"$",157200000,"$",148800000,"$",488600000,"$",1184200000,null,"$",368500000,"$",155900000,"$",141500000,"$",485100000,"$",1151000000]
[]
[null,"Net premiums earned","$",379600000,"$",152500000,"$",134500000,"$",479500000,"$",1146100000,null,"$",358600000,"$",152300000,"$",131900000,"$",460400000,"$",1103200000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,184000000,null,106500000,null,90700000,null,252500000,null,633700000,null,null,187100000,null,108700000,null,90500000,null,249600000,null,635900000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,21400000,null,7200000,null,-10900000,null,24500000,null,42200000,null,null,200000,null,4800000,null,-6700000,null,8600000,null,6900000]
[]
[null,"Current accident year catastrophe losses",null,31400000,null,900000,null,0,null,13500000,null,45800000,null,null,42900000,null,900000,null,0,null,19400000,null,63200000]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,-1900000,null,0,null,0,null,900000,null,-1000000,null,null,-6600000,null,-100000,null,0,null,600000,null,-6100000]
[]
[null,"Total losses and LAE",null,234900000,null,114600000,null,79800000,null,291400000,null,720700000,null,null,223600000,null,114300000,null,83800000,null,278200000,null,699900000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,null,null,null,null,null,null,null,416600000,null,null,null,null,null,null,null,null,null,null,400700000]
[]
[null,"GAAP underwriting profit",null,null,null,null,null,null,null,null,null,8800000,null,null,null,null,null,null,null,null,null,null,2600000]
[]
[null,"Net investment income",null,null,null,null,null,null,null,null,null,78500000,null,null,null,null,null,null,null,null,null,null,78000000]
[]
[null,"Other income",null,null,null,null,null,null,null,null,null,4200000,null,null,null,null,null,null,null,null,null,null,4300000]
[]
[null,"Other operating expenses",null,null,null,null,null,null,null,null,null,-4800000,null,null,null,null,null,null,null,null,null,null,-5500000]
[]
[null,"Operating income before income taxes",null,null,null,null,null,null,null,null,"$",86700000,null,null,null,null,null,null,null,null,null,"$",79400000]
[]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,0.48499999999999999,null,0.69899999999999995,null,0.67400000000000004,null,0.52600000000000002,null,0.55200000000000005,null,null,0.52200000000000002,null,0.71299999999999997,null,0.68600000000000005,null,0.54300000000000004,null,0.57599999999999996]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,5.6000000000000001E-2,null,4.7E-2,null,-8.1000000000000003E-2,null,5.0999999999999997E-2,null,3.6999999999999998E-2,null,null,1E-3,null,3.2000000000000001E-2,null,-5.0999999999999997E-2,null,1.9E-2,null,6.0000000000000001E-3]
[]
[null,"Current accident year catastrophe losses",null,8.3000000000000004E-2,null,6.0000000000000001E-3,null,"-",null,2.8000000000000001E-2,null,0.04,null,null,0.11899999999999999,null,6.0000000000000001E-3,null,"-",null,4.2000000000000003E-2,null,5.8000000000000003E-2]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,-5.0000000000000001E-3,null,"-",null,"-",null,2E-3,null,-1E-3,null,null,-1.7999999999999999E-2,null,-1E-3,null,"-",null,1E-3,null,-6.0000000000000001E-3]
[null,"Total loss and LAE ratio",null,0.61899999999999999,null,0.752,null,0.59299999999999997,null,0.60699999999999998,null,0.628,null,null,0.624,null,0.75,null,0.63500000000000001,null,0.60499999999999998,null,0.63400000000000001]
[]
[null,"Expense ratio",null,null,null,null,null,null,null,null,null,0.36199999999999999,null,null,null,null,null,null,null,null,null,null,0.36199999999999999]
[]
[null,"Combined ratio",null,null,null,null,null,null,null,null,null,0.99,null,null,null,null,null,null,null,null,null,null,0.996]
[]
[]
[]
[null,"Change in policies in force",null,5.1999999999999998E-2,null,-3.2000000000000001E-2,null,-0.03,null,4.1000000000000002E-2,null,2.5999999999999999E-2,null,null,0.06,null,-3.7999999999999999E-2,null,-2.8000000000000001E-2,null,5.5E-2,null,3.3000000000000002E-2]
[]
[null,"Retention",null,0.85899999999999999,null,0.79800000000000004,null,0.77800000000000002,null,"N/M",null,0.83099999999999996,null,null,0.86,null,0.81100000000000005,null,0.78100000000000003,null,"N/M",null,0.83399999999999996]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"10","index":13,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,16],[4,0,4,16]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING INFORMATION AND RELATED RATIOS"]
[]
[]
["COMMERCIAL LINES"]
[]
[]
[]
[null," "]
[null," ",null,null,"Q2",null,"Q3",null,"Q4",null,"Q1",null,"Q2",null,"Jun-YTD",null,"Jun-YTD"]
[null,"(In millions, except percentage data)",null,null,"2015",null,"2015",null,"2015",null,"2016",null,"2016",null,"2015",null,"2016"]
[]
[]
[null,"Gross premiums written ",null,"$",642700000,"$",701200000,"$",592400000,"$",680100000,"$",662900000,"$",1298900000,"$",1343000000]
[]
[null,"Net premiums written",null,"$",569100000,"$",617600000,"$",513300000,"$",604300000,"$",579900000,"$",1151000000,"$",1184200000]
[]
[null,"Net premiums earned",null,"$",557000000,"$",560400000,"$",563400000,"$",571400000,"$",574700000,"$",1103200000,"$",1146100000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,317200000,null,324600000,null,330700000,null,320800000,null,312900000,null,635900000,null,633700000]
[]
[null,"Prior accident year unfavorable reserve development, excluding catastrophe losses",null,null,6000000,null,11800000,null,26500000,null,20100000,null,22100000,null,6900000,null,42200000]
[]
[null,"Current accident year catastrophe losses",null,null,23800000,null,10000000,null,13400000,null,19200000,null,26600000,null,63200000,null,45800000]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-600000,null,3800000,null,4400000,null,-300000,null,-700000,null,-6100000,null,-1000000]
[]
[null,"Total losses and LAE",null,null,346400000,null,350200000,null,375000000,null,359800000,null,360900000,null,699900000,null,720700000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,202100000,null,201900000,null,212000000,null,207900000,null,208700000,null,400700000,null,416600000]
[null,null,null,null,0]
[null,"GAAP underwriting profit (loss) ",null,"$",8500000,"$",8300000,"$",-23600000,"$",3700000,"$",5100000,"$",2600000,"$",8800000]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,0.56899999999999995,null,0.57899999999999996,null,0.58699999999999997,null,0.56200000000000006,null,0.54500000000000004,null,0.57599999999999996,null,0.55200000000000005]
[]
[null,"Prior accident year unfavorable reserve development, excluding catastrophe losses",null,null,1.0999999999999999E-2,null,2.1000000000000001E-2,null,4.7E-2,null,3.5000000000000003E-2,null,3.7999999999999999E-2,null,6.0000000000000001E-3,null,3.6999999999999998E-2]
[]
[null,"Current accident year catastrophe losses",null,null,4.2999999999999997E-2,null,1.7999999999999999E-2,null,2.4E-2,null,3.4000000000000002E-2,null,4.5999999999999999E-2,null,5.8000000000000003E-2,null,0.04]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-1E-3,null,7.0000000000000001E-3,null,8.0000000000000002E-3,null,-1E-3,null,-1E-3,null,-6.0000000000000001E-3,null,-1E-3]
[]
[null,"Total loss and LAE ratio",null,null,0.622,null,0.625,null,0.66600000000000004,null,0.63,null,0.628,null,0.63400000000000001,null,0.628]
[]
[null,"Expense ratio",null,null,0.36099999999999999,null,0.35799999999999998,null,0.374,null,0.36199999999999999,null,0.36099999999999999,null,0.36199999999999999,null,0.36199999999999999]
[]
[null,"Combined ratio",null,null,0.98299999999999998,null,0.98299999999999998,null,1.04,null,0.99199999999999999,null,0.98899999999999999,null,0.996,null,0.99]
[]
[]
[]
[null,"Combined ratio, excluding catastrophe losses",null,null,0.94099999999999995,null,0.95799999999999996,null,1.008,null,0.95899999999999996,null,0.94399999999999995,null,0.94399999999999995,null,0.95099999999999996]
[]
[null,"Current accident year combined ratio, excluding catastrophe losses",null,null,0.93,null,0.93700000000000006,null,0.96099999999999997,null,0.92400000000000004,null,0.90600000000000003,null,0.93799999999999994,null,0.91400000000000003]

{"sheet":"11","index":14,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,0,1,19],[3,0,3,19],[5,0,5,19],[9,3,9,10],[9,12,9,19]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["PERSONAL LINES"]
[]
["Three Months ended June 30"]
[]
[]
[]
[null,null,null,"2016",null,null,null,null,null,null,null,null,"2015"]
[]
[null," "]
[null," "]
["(In millions, except percentage data)",null,null,null,"Auto",null,"Home",null,"Other",null,"Total ",null,null,"Auto",null,"Home",null,"Other",null,"Total "]
[]
[]
[null,"Net premiums written",null,"$",245100000,"$",140100000,"$",10100000,"$",395300000,null,"$",232900000,"$",135100000,"$",10300000,"$",378300000]
[]
[null,"Net premiums earned",null,"$",226400000,"$",128600000,"$",9700000,"$",364700000,null,"$",221000000,"$",125900000,"$",9800000,"$",356700000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,157800000,null,59300000,null,4100000,null,221200000,null,null,153600000,null,65600000,null,3600000,null,222800000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,-1300000,null,800000,null,1400000,null,900000,null,null,-1800000,null,0,null,-100000,null,-1900000]
[]
[null,"Current accident year catastrophe losses",null,null,1100000,null,8500000,null,100000,null,9700000,null,null,1000000,null,15200000,null,200000,null,16400000]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-200000,null,1600000,null,100000,null,1500000,null,null,0,null,4500000,null,0,null,4500000]
[]
[null,"Total losses and LAE",null,null,157400000,null,70200000,null,5700000,null,233300000,null,null,152800000,null,85300000,null,3700000,null,241800000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,null,null,null,null,null,null,102100000,null,null,null,null,null,null,null,null,101900000]
[]
[null,"GAAP underwriting profit ",null,null,null,null,null,null,null,null,29300000,null,null,null,null,null,null,null,null,13000000]
[]
[null,"Net investment income",null,null,null,null,null,null,null,null,17100000,null,null,null,null,null,null,null,null,18300000]
[]
[null,"Other income",null,null,null,null,null,null,null,null,2700000,null,null,null,null,null,null,null,null,2700000]
[]
[null,"Other operating expenses",null,null,null,null,null,null,null,null,-1700000,null,null,null,null,null,null,null,null,-1900000]
[]
[null,"Operating income before income taxes",null,null,null,null,null,null,null,"$",47400000,null,null,null,null,null,null,null,"$",32100000]
[]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,0.69699999999999995,null,0.46100000000000002,null,0.42199999999999999,null,0.60699999999999998,null,null,0.69399999999999995,null,0.52200000000000002,null,0.36699999999999999,null,0.624]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,-6.0000000000000001E-3,null,6.0000000000000001E-3,null,0.14399999999999999,null,2E-3,null,null,-8.0000000000000002E-3,null,"-",null,-0.01,null,-5.0000000000000001E-3]
[]
[null,"Current accident year catastrophe losses",null,null,5.0000000000000001E-3,null,6.7000000000000004E-2,null,1.0999999999999999E-2,null,2.7E-2,null,null,5.0000000000000001E-3,null,0.12,null,0.02,null,4.5999999999999999E-2]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-1E-3,null,1.2E-2,null,0.01,null,4.0000000000000001E-3,null,null,"-",null,3.5999999999999997E-2,null,"-",null,1.2999999999999999E-2]
[null,"Total loss and LAE ratio",null,null,0.69499999999999995,null,0.54600000000000004,null,0.58699999999999997,null,0.64,null,null,0.69099999999999995,null,0.67800000000000005,null,0.377,null,0.67800000000000005]
[]
[null,"Expense ratio",null,null,null,null,null,null,null,null,0.27300000000000002,null,null,null,null,null,null,null,null,0.27900000000000003]
[]
[null,"Combined ratio",null,null,null,null,null,null,null,null,0.91300000000000003,null,null,null,null,null,null,null,null,0.95699999999999996]
[]
[]
[]
[null,"Change in policies in force",null,null,-2.3E-2,null,-8.9999999999999993E-3,null,-0.124,null,-0.02,null,null,-1.7000000000000001E-2,null,-1.7999999999999999E-2,null,-0.11600000000000001,null,-2.1999999999999999E-2]
[]
[null,"Retention",null,null,0.84199999999999997,null,0.82699999999999996,null,"N/M",null,0.83499999999999996,null,null,0.83099999999999996,null,0.81699999999999995,null,"N/M",null,0.82499999999999996]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"12","index":15,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,0,1,19],[3,0,3,19],[5,0,5,19],[9,3,9,10],[9,12,9,19]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["PERSONAL LINES"]
[]
["Six Months ended June 30"]
[]
[]
[]
[null,null,null,"2016",null,null,null,null,null,null,null,null,"2015"]
[]
[null," "]
[null," "]
["(In millions, except percentage data)",null,null,null,"Auto",null,"Home",null,"Other",null,"Total ",null,null,"Auto",null,"Home",null,"Other",null,"Total "]
[]
[]
[null,"Net premiums written",null,"$",467600000,"$",246500000,"$",18200000,"$",732300000,null,"$",449200000,"$",237100000,"$",18400000,"$",704700000]
[]
[null,"Net premiums earned",null,"$",448200000,"$",255900000,"$",19200000,"$",723300000,null,"$",438800000,"$",251100000,"$",19700000,"$",709600000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,317200000,null,111700000,null,8000000,null,436900000,null,null,313700000,null,127900000,null,7200000,null,448800000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,-2100000,null,800000,null,1500000,null,200000,null,null,-2800000,null,-1400000,null,100000,null,-4100000]
[]
[null,"Current accident year catastrophe losses",null,null,1600000,null,18400000,null,200000,null,20200000,null,null,1100000,null,37800000,null,400000,null,39300000]
[]
[null,"Prior accident year unfavorable (favorable) catastrophe loss development",null,null,-100000,null,2800000,null,100000,null,2800000,null,null,0,null,7100000,null,0,null,7100000]
[]
[null,"Total losses and LAE",null,null,316600000,null,133700000,null,9800000,null,460100000,null,null,312000000,null,171400000,null,7700000,null,491100000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,null,null,null,null,null,null,205300000,null,null,null,null,null,null,null,null,202100000]
[]
[null,"GAAP underwriting profit",null,null,null,null,null,null,null,null,57900000,null,null,null,null,null,null,null,null,16400000]
[]
[null,"Net investment income",null,null,null,null,null,null,null,null,34500000,null,null,null,null,null,null,null,null,36200000]
[]
[null,"Other income",null,null,null,null,null,null,null,null,5500000,null,null,null,null,null,null,null,null,5900000]
[]
[null,"Other operating expenses",null,null,null,null,null,null,null,null,-3400000,null,null,null,null,null,null,null,null,-4100000]
[]
[null,"Operating income before income taxes",null,null,null,null,null,null,null,"$",94500000,null,null,null,null,null,null,null,"$",54400000]
[]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,0.70799999999999996,null,0.436,null,0.41599999999999998,null,0.60399999999999998,null,null,0.71399999999999997,null,0.51,null,0.36599999999999999,null,0.63300000000000001]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,-5.0000000000000001E-3,null,3.0000000000000001E-3,null,7.8E-2,null,0,null,null,-6.0000000000000001E-3,null,-6.0000000000000001E-3,null,5.0000000000000001E-3,null,-6.0000000000000001E-3]
[]
[null,"Current accident year catastrophe losses",null,null,3.0000000000000001E-3,null,7.1999999999999995E-2,null,1.0999999999999999E-2,null,2.8000000000000001E-2,null,null,3.0000000000000001E-3,null,0.151,null,0.02,null,5.5E-2]
[]
[null,"Prior accident year unfavorable catastrophe loss development",null,null,0,null,1.0999999999999999E-2,null,5.0000000000000001E-3,null,4.0000000000000001E-3,null,null,"-",null,2.8000000000000001E-2,null,"-",null,0.01]
[null,"Total loss and LAE ratio",null,null,0.70599999999999996,null,0.52200000000000002,null,0.51,null,0.63600000000000001,null,null,0.71099999999999997,null,0.68300000000000005,null,0.39100000000000001,null,0.69199999999999995]
[]
[null,"Expense ratio",null,null,null,null,null,null,null,null,0.27700000000000002,null,null,null,null,null,null,null,null,0.27800000000000002]
[]
[null,"Combined ratio",null,null,null,null,null,null,null,null,0.91300000000000003,null,null,null,null,null,null,null,null,0.97]
[]
[]
[]
[null,"Change in policies in force",null,null,-2.3E-2,null,-8.9999999999999993E-3,null,-0.124,null,-0.02,null,null,-1.7000000000000001E-2,null,-1.7999999999999999E-2,null,-0.11600000000000001,null,-2.1999999999999999E-2]
[]
[null,"Retention",null,null,0.84299999999999997,null,0.82099999999999995,null,"N/M",null,0.83299999999999996,null,null,0.83799999999999997,null,0.80800000000000005,null,"N/M",null,0.82599999999999996]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"13","index":16,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,16],[4,0,4,16]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING INFORMATION AND RELATED RATIOS"]
[]
[]
["PERSONAL LINES"]
[]
[]
[]
[null," "]
[null," ",null,null,"Q2",null,"Q3",null,"Q4",null,"Q1",null,"Q2",null,"Jun-YTD",null,"Jun-YTD"]
["(In millions, except percentage data)",null,null,null,"2015",null,"2015",null,"2015",null,"2016",null,"2016",null,"2015",null,"2016"]
[]
[]
[]
[null,"Gross premiums written ",null,"$",401800000,"$",403000000,"$",376600000,"$",356800000,"$",416600000,"$",750900000,"$",773400000]
[]
[null,"Net premiums written",null,"$",378300000,"$",383300000,"$",357600000,"$",337000000,"$",395300000,"$",704700000,"$",732300000]
[]
[null,"Net premiums earned",null,"$",356700000,"$",358600000,"$",358400000,"$",358600000,"$",364700000,"$",709600000,"$",723300000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,222800000,null,219400000,null,217600000,null,215700000,null,221200000,null,448800000,null,436900000]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,-1900000,null,-2500000,null,-13100000,null,-700000,null,900000,null,-4100000,null,200000]
[]
[null,"Current accident year catastrophe losses",null,null,16400000,null,18900000,null,8500000,null,10500000,null,9700000,null,39300000,null,20200000]
[]
[null,"Prior accident year unfavorable catastrophe loss development",null,null,4500000,null,1200000,null,800000,null,1300000,null,1500000,null,7100000,null,2800000]
[]
[null,"Total losses and LAE",null,null,241800000,null,237000000,null,213800000,null,226800000,null,233300000,null,491100000,null,460100000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,101900000,null,103700000,null,106900000,null,103200000,null,102100000,null,202100000,null,205300000]
[]
[null,"GAAP underwriting profit",null,"$",13000000,"$",17900000,"$",37700000,"$",28600000,"$",29300000,"$",16400000,"$",57900000]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,0.624,null,0.61199999999999999,null,0.60799999999999998,null,0.60199999999999998,null,0.60699999999999998,null,0.63300000000000001,null,0.60399999999999998]
[]
[null,"Prior accident year unfavorable (favorable) reserve development, excluding catastrophe losses",null,null,-5.0000000000000001E-3,null,-7.0000000000000001E-3,null,-3.6999999999999998E-2,null,-2E-3,null,2E-3,null,-6.0000000000000001E-3,null,0]
[]
[null,"Current accident year catastrophe losses",null,null,4.5999999999999999E-2,null,5.2999999999999999E-2,null,2.4E-2,null,2.9000000000000001E-2,null,2.7E-2,null,5.5E-2,null,2.8000000000000001E-2]
[]
[null,"Prior accident year unfavorable catastrophe loss development",null,null,1.2999999999999999E-2,null,3.0000000000000001E-3,null,2E-3,null,4.0000000000000001E-3,null,4.0000000000000001E-3,null,0.01,null,4.0000000000000001E-3]
[]
[null,"Total loss and LAE ratio",null,null,0.67800000000000005,null,0.66100000000000003,null,0.59699999999999998,null,0.63300000000000001,null,0.64,null,0.69199999999999995,null,0.63600000000000001]
[]
[null,"Expense ratio",null,null,0.27900000000000003,null,0.28100000000000003,null,0.29099999999999998,null,0.28100000000000003,null,0.27300000000000002,null,0.27800000000000002,null,0.27700000000000002]
[]
[null,"Combined ratio",null,null,0.95699999999999996,null,0.94199999999999995,null,0.88800000000000001,null,0.91400000000000003,null,0.91300000000000003,null,0.97,null,0.91300000000000003]
[]
[]
[]
[null,"Combined ratio, excluding catastrophe losses",null,null,0.89800000000000002,null,0.88600000000000001,null,0.86199999999999999,null,0.88100000000000001,null,0.88200000000000001,null,0.90500000000000003,null,0.88100000000000001]
[]
[null,"Current accident year combined ratio, excluding catastrophe losses",null,null,0.90300000000000002,null,0.89300000000000002,null,0.89900000000000002,null,0.88300000000000001,null,0.88,null,0.91100000000000003,null,0.88100000000000001]

{"sheet":"14","index":17,"n_rows":74,"n_cols":28,"rows_kept":74,"cut":false,"hidden":false,"merged":[[66,1,67,27],[0,0,0,27],[1,0,1,27],[3,0,3,27],[5,0,5,27],[9,3,9,14],[9,16,9,27]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["CHAUCER"]
[]
["Three Months ended June 30"]
[]
[]
[]
[null,null,null,"2016",null,null,null,null,null,null,null,null,null,null,null,null,"2015"]
[null," "]
[null,null,null,null,null,null," Marine & ",null,null,null,"UK",null,"Casualty",null,null,null,null,null,null," Marine & ",null,null,null,"UK",null,"Casualty"]
[null,"(In millions, except percentage data)",null,null,"Property",null,"Aviation",null,"Energy",null,"Motor",null,"& Other",null,"Total ",null,null,"Property",null,"Aviation",null,"Energy",null,"Motor",null,"& Other",null,"Total "]
[]
[]
[null,"Gross premiums written",null,"$",91400000,"$",85800000,"$",63100000,"$",400000,"$",82200000,"$",322500000,null,"$",88300000,"$",81800000,"$",68000000,"$",65900000,"$",86000000,"$",390000000]
[]
[null,"Net premiums written (1)",null,"$",61500000,"$",66400000,"$",45100000,"$",0,"$",73400000,"$",246400000,null,"$",67700000,"$",69400000,"$",54800000,"$",76700000,"$",77400000,"$",346000000]
[]
[null,"Net premiums earned",null,"$",36600000,"$",62700000,"$",30600000,"$",0,"$",76200000,"$",206100000,null,"$",43000000,"$",69900000,"$",43100000,"$",65200000,"$",70900000,"$",292100000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,129600000,null,null,null,null,null,null,null,null,null,null,null,null,186900000]
[]
[null,"Prior accident year favorable reserve development, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,-8300000,null,null,null,null,null,null,null,null,null,null,null,null,-33000000]
[]
[null,"Current accident year catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,26000000,null,null,null,null,null,null,null,null,null,null,null,null,7000000]
[]
[null,"Prior accident year favorable catastrophe loss development",null,null,null,null,null,null,null,null,null,null,null,null,-12100000,null,null,null,null,null,null,null,null,null,null,null,null,-4600000]
[]
[null,"Total losses and LAE",null,null,null,null,null,null,null,null,null,null,null,null,135200000,null,null,null,null,null,null,null,null,null,null,null,null,156300000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,null,null,null,null,null,null,null,null,null,null,77400000,null,null,null,null,null,null,null,null,null,null,null,null,108300000]
[]
[null,"GAAP underwriting profit (loss)",null,null,null,null,null,null,null,null,null,null,null,null,-6500000,null,null,null,null,null,null,null,null,null,null,null,null,27500000]
[]
[null,"Net investment income",null,null,null,null,null,null,null,null,null,null,null,null,11300000,null,null,null,null,null,null,null,null,null,null,null,null,12000000]
[]
[null,"Other income",null,null,null,null,null,null,null,null,null,null,null,null,2400000,null,null,null,null,null,null,null,null,null,null,null,null,2200000]
[]
[null,"Other operating expenses",null,null,null,null,null,null,null,null,null,null,null,null,-1700000,null,null,null,null,null,null,null,null,null,null,null,null,300000]
[]
[null,"Operating income before income taxes",null,null,null,null,null,null,null,null,null,null,null,"$",5500000,null,null,null,null,null,null,null,null,null,null,null,"$",42000000]
[]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,0.629,null,null,null,null,null,null,null,null,null,null,null,null,0.64]
[]
[null,"Prior accident year favorable reserve development, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,-0.04,null,null,null,null,null,null,null,null,null,null,null,null,-0.113]
[]
[null,"Current accident year catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,0.126,null,null,null,null,null,null,null,null,null,null,null,null,2.4E-2]
[]
[null,"Prior accident year favorable catastrophe loss development",null,null,null,null,null,null,null,null,null,null,null,null,-5.8999999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,-1.6E-2]
[null,"Total loss and LAE ratio",null,null,null,null,null,null,null,null,null,null,null,null,0.65600000000000003,null,null,null,null,null,null,null,null,null,null,null,null,0.53500000000000003]
[]
[null,"Expense ratio",null,null,null,null,null,null,null,null,null,null,null,null,0.376,null,null,null,null,null,null,null,null,null,null,null,null,0.371]
[]
[null,"Combined ratio",null,null,null,null,null,null,null,null,null,null,null,null,1.032,null,null,null,null,null,null,null,null,null,null,null,null,0.90600000000000003]
[]
[]
[]
[]
[null,"(1)  Net premiums written for Chaucer do not reflect the June 30, 2015 transfer of $137.4 million of unearned premium reserves previously written by the U.K. motor business. This transfer of unearned premium reserves is part of the disposal of the U.K. motor business and has no impact on net premiums earned."]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"15","index":18,"n_rows":74,"n_cols":28,"rows_kept":74,"cut":false,"hidden":false,"merged":[[64,1,65,27],[0,0,0,27],[1,0,1,27],[3,0,3,27],[5,0,5,27],[9,3,9,14],[9,16,9,27]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING AND OPERATING INCOME INFORMATION AND RATIOS"]
[]
["CHAUCER"]
[]
["Six Months ended June 30"]
[]
[]
[]
[null,null,null,"2016",null,null,null,null,null,null,null,null,null,null,null,null,"2015"]
[null," "]
[null,null,null,null,null,null," Marine & ",null,null,null,"UK",null,"Casualty",null,null,null,null,null,null," Marine & ",null,null,null,"UK",null,"Casualty"]
[null,"(In millions, except percentage data)",null,null,"Property",null,"Aviation",null,"Energy",null,"Motor",null,"& Other",null,"Total ",null,null,"Property",null,"Aviation",null,"Energy",null,"Motor",null,"& Other",null,"Total "]
[]
[]
[null,"Gross premiums written",null,"$",175100000,"$",196200000,"$",102900000,"$",-1300000,"$",186400000,"$",660600000,null,"$",180300000,"$",196100000,"$",133800000,"$",139600000,"$",190900000,"$",840700000]
[]
[null,"Net premiums written (1)",null,"$",93100000,"$",138200000,"$",57400000,"$",0,"$",160700000,"$",449400000,null,"$",113700000,"$",153800000,"$",85700000,"$",129100000,"$",170500000,"$",652800000]
[]
[null,"Net premiums earned",null,"$",71100000,"$",128200000,"$",75600000,"$",0,"$",152500000,"$",427400000,null,"$",83200000,"$",142800000,"$",98900000,"$",135400000,"$",143700000,"$",604000000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,271500000,null,null,null,null,null,null,null,null,null,null,null,null,378200000]
[]
[null,"Prior accident year favorable reserve development, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,-38000000,null,null,null,null,null,null,null,null,null,null,null,null,-57200000]
[]
[null,"Current accident year catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,36200000,null,null,null,null,null,null,null,null,null,null,null,null,10200000]
[]
[null,"Prior accident year favorable catastrophe loss development",null,null,null,null,null,null,null,null,null,null,null,null,-21800000,null,null,null,null,null,null,null,null,null,null,null,null,-4900000]
[]
[null,"Total losses and LAE",null,null,null,null,null,null,null,null,null,null,null,null,247900000,null,null,null,null,null,null,null,null,null,null,null,null,326300000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,null,null,null,null,null,null,null,null,null,null,null,163500000,null,null,null,null,null,null,null,null,null,null,null,null,214600000]
[]
[null,"GAAP underwriting profit ",null,null,null,null,null,null,null,null,null,null,null,null,16000000,null,null,null,null,null,null,null,null,null,null,null,null,63100000]
[]
[null,"Net investment income",null,null,null,null,null,null,null,null,null,null,null,null,22000000,null,null,null,null,null,null,null,null,null,null,null,null,24300000]
[]
[null,"Other income",null,null,null,null,null,null,null,null,null,null,null,null,3500000,null,null,null,null,null,null,null,null,null,null,null,null,4500000]
[]
[null,"Other operating expenses",null,null,null,null,null,null,null,null,null,null,null,null,-2300000,null,null,null,null,null,null,null,null,null,null,null,null,-700000]
[]
[null,"Operating income before income taxes",null,null,null,null,null,null,null,null,null,null,null,"$",39200000,null,null,null,null,null,null,null,null,null,null,null,"$",91200000]
[]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,0.63500000000000001,null,null,null,null,null,null,null,null,null,null,null,null,0.627]
[]
[null,"Prior accident year favorable reserve development, excluding catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,-8.8999999999999996E-2,null,null,null,null,null,null,null,null,null,null,null,null,-9.5000000000000001E-2]
[]
[null,"Current accident year catastrophe losses",null,null,null,null,null,null,null,null,null,null,null,null,8.5000000000000006E-2,null,null,null,null,null,null,null,null,null,null,null,null,1.7000000000000001E-2]
[]
[null,"Prior accident year favorable catastrophe loss development",null,null,null,null,null,null,null,null,null,null,null,null,-5.0999999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,-8.0000000000000002E-3]
[null,"Total loss and LAE ratio",null,null,null,null,null,null,null,null,null,null,null,null,0.57999999999999996,null,null,null,null,null,null,null,null,null,null,null,null,0.54100000000000004]
[]
[null,"Expense ratio",null,null,null,null,null,null,null,null,null,null,null,null,0.38300000000000001,null,null,null,null,null,null,null,null,null,null,null,null,0.35499999999999998]
[]
[null,"Combined ratio",null,null,null,null,null,null,null,null,null,null,null,null,0.96299999999999997,null,null,null,null,null,null,null,null,null,null,null,null,0.89600000000000002]
[]
[]
[null,"(1)  Net premiums written for Chaucer do not reflect the June 30, 2015 transfer of $137.4 million of unearned premium reserves previously written by the U.K. motor business. This transfer of unearned premium reserves is part of the disposal of the U.K. motor business and has no impact on net premiums earned."]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"16","index":19,"n_rows":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[4,0,4,15],[62,1,63,15]]}
["THE HANOVER INSURANCE GROUP"]
["GAAP UNDERWRITING INFORMATION AND RELATED RATIOS"]
[]
[]
["CHAUCER"]
[]
[]
[]
[null," "]
[null," ",null,"Q2",null,"Q3",null,"Q4",null,"Q1",null,"Q2",null,"Jun-YTD",null,"Jun-YTD"]
[null,"(In millions, except percentage data)",null,"2015",null,"2015",null,"2015",null,"2016",null,"2016",null,"2015",null,"2016"]
[]
[]
[]
[null,"Gross premiums written ","$",390000000,"$",275500000,"$",205300000,"$",338100000,"$",322500000,"$",840700000,"$",660600000]
[]
[null,"Net premiums written (1)","$",346000000,"$",198700000,"$",175200000,"$",203000000,"$",246400000,"$",652800000,"$",449400000]
[]
[null,"Net premiums earned","$",292100000,"$",231100000,"$",216100000,"$",221300000,"$",206100000,"$",604000000,"$",427400000]
[]
[null,"Losses and LAE:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,186900000,null,123300000,null,118500000,null,141900000,null,129600000,null,378200000,null,271500000]
[]
[null,"Prior accident year favorable reserve development, excluding catastrophe losses",null,-33000000,null,-32100000,null,-30800000,null,-29700000,null,-8300000,null,-57200000,null,-38000000]
[]
[null,"Current accident year catastrophe losses",null,7000000,null,29200000,null,10300000,null,10200000,null,26000000,null,10200000,null,36200000]
[]
[null,"Prior accident year favorable catastrophe loss development",null,-4600000,null,-17300000,null,-10700000,null,-9700000,null,-12100000,null,-4900000,null,-21800000]
[]
[null,"Total losses and LAE",null,156300000,null,103100000,null,87300000,null,112700000,null,135200000,null,326300000,null,247900000]
[]
[null,"Amortization of deferred acquisition costs and other underwriting expenses",null,108300000,null,98400000,null,90000000,null,86100000,null,77400000,null,214600000,null,163500000]
[]
[null,"GAAP underwriting profit (loss)","$",27500000,"$",29600000,"$",38800000,"$",22500000,"$",-6500000,"$",63100000,"$",16000000]
[]
[]
[]
[null,"Loss and LAE ratio:"]
[]
[null,"Current accident year, excluding catastrophe losses",null,0.64,null,0.53400000000000003,null,0.54900000000000004,null,0.64100000000000001,null,0.629,null,0.627,null,0.63500000000000001]
[]
[null,"Prior accident year favorable reserve development, excluding catastrophe losses",null,-0.113,null,-0.13900000000000001,null,-0.14299999999999999,null,-0.13400000000000001,null,-0.04,null,-9.5000000000000001E-2,null,-8.8999999999999996E-2]
[]
[null,"Current accident year catastrophe losses",null,2.4E-2,null,0.126,null,4.8000000000000001E-2,null,4.5999999999999999E-2,null,0.126,null,1.7000000000000001E-2,null,8.5000000000000006E-2]
[]
[null,"Prior accident year favorable catastrophe loss development",null,-1.6E-2,null,-7.4999999999999997E-2,null,-0.05,null,-4.3999999999999997E-2,null,-5.8999999999999997E-2,null,-8.0000000000000002E-3,null,-5.0999999999999997E-2]
[]
[null,"Total loss and LAE ratio",null,0.53500000000000003,null,0.44600000000000001,null,0.40400000000000003,null,0.50900000000000001,null,0.65600000000000003,null,0.54100000000000004,null,0.57999999999999996]
[]
[null,"Expense ratio",null,0.371,null,0.42599999999999999,null,0.41599999999999998,null,0.38900000000000001,null,0.376,null,0.35499999999999998,null,0.38300000000000001]
[]
[null,"Combined ratio",null,0.90600000000000003,null,0.872,null,0.82,null,0.89800000000000002,null,1.032,null,0.89600000000000002,null,0.96299999999999997]
[]
[]
[]
[null,"Combined ratio, excluding catastrophe losses",null,0.89800000000000002,null,0.82099999999999995,null,0.82199999999999995,null,0.89600000000000002,null,0.96499999999999997,null,0.88700000000000001,null,0.92900000000000005]
[]
[null,"Current accident year combined ratio, excluding catastrophe losses",null,1.0109999999999999,null,0.96,null,0.96499999999999997,null,1.03,null,1.0049999999999999,null,0.98199999999999998,null,1.018]
[]
[]
[]
[null,"(1)  Net premiums written for Chaucer do not reflect the June 30, 2015 transfer of $137.4 million of unearned premium reserves previously written by the U.K. motor business. This transfer of unearned premium reserves is part of the disposal of the U.K. motor business and has no impact on net premiums earned."]

{"sheet":"17","index":20,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[23,0,24,15]]}
["THE HANOVER INSURANCE GROUP"]
["NET INVESTMENT INCOME AND YIELDS"]
[]
[]
[]
[null,null,null,"Q2",null,"Q3",null,"Q4",null,"Q1",null,"Q2",null,"YTD",null,"YTD"]
["(In millions, except yields)",null,null,"2015",null,"2015",null,"2015",null,"2016",null,"2016",null,"2015",null,"2016"]
[]
["Net Investment Income"]
["Fixed maturities",null,null,63.6,null,62.5,null,63,null,61.1,null,61.3,null,128.30000000000001,null,122.4]
["Equity securities",null,null,4.8,null,4.2,null,4.5999999999999996,null,4.3,null,4.8,null,8.6999999999999993,null,9.1]
["Other investments",null,null,4.7,null,4,null,5.2,null,5.6,null,5.7,null,8.9,null,11.3]
["Investment expenses",null,null,-2.4,null,-2.4,null,-2.8,null,-2.7,null,-2.7,null,-5.0999999999999996,null,-5.4]
["Total",null,null,70.7,null,68.3,null,70,null,68.3,null,69.099999999999994,null,140.80000000000001,null,137.4]
[]
[]
["Pre-tax Yields"]
[]
["Fixed maturities",null,null,3.5999999999999997E-2,null,3.6400000000000002E-2,null,3.6299999999999999E-2,null,3.5400000000000001E-2,null,3.56E-2,null,3.61E-2,null,3.5499999999999997E-2]
["Total ",null,null,3.4799999999999998E-2,null,3.4500000000000003E-2,null,3.4700000000000002E-2,null,3.4000000000000002E-2,null,3.39E-2,null,3.4299999999999997E-2,null,3.3799999999999997E-2]
[]
[]
[]
["Pre-tax yields are calculated as annualized net investment income divided by the average of investment balances, excluding unrealized capital gains and losses, at the end of each month during the period."]
[]
[]
[]
[]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               "]

{"sheet":"18","index":21,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,3,6,7],[0,1,0,9],[1,1,1,9],[2,1,2,9]]}
[null,"THE HANOVER INSURANCE GROUP"]
[null,"INVESTMENT PORTFOLIO"]
[null,"June 30, 2016  "]
[]
[]
[]
[null,"(In millions)"]
[null,null,null,null,null,null,null,null,"Change in","Change in"]
[null,null,null,"Weighted",null,null,null,"Net","Net ","Net "]
[null,null,null,"Average ","Amortized","Fair","% of","Unrealized","Unrealized","Unrealized"]
[null,"Investment Type",null,"Quality","Cost or Cost","Value","Total","Gain","During Q2 ","YTD"]
[]
[null,"Fixed maturities:"]
[null,"U.S. Treasury and government agencies",null,"AAA",364.9,376.5,4.3999999999999997E-2,11.6,1.5,9.6]
[null,"Foreign government",null,"AA+",229.4,236.6,2.8000000000000001E-2,7.2,2.2999999999999998,6.1]
[null,"Municipals:"]
[null,null,"Taxable","AA",972.2,1042.5999999999999,0.122,70.400000000000006,10.9,27.5]
[null,null,"Tax exempt","AA",112.4,117.3,1.4E-2,4.9000000000000004,1.4,2]
[null,"Corporate:"]
[null,"NAIC 1","NAIC 1","A",1622.2,1701.6,0.2,79.400000000000006,15.7,47.5]
[null,"NAIC 2","NAIC 2","BBB",1683.9,1755,0.20499999999999999,71.099999999999994,33.700000000000003,72.5]
[null,"NAIC 3 and below","NAIC 3 and below","B+",422.7,426.1,0.05,3.4,21.3,42.8]
[null,"Total corporate",null,"BBB+",3728.8,3882.7,0.45500000000000002,153.9,70.7,162.80000000000001]
[null,"Asset backed:"]
[null,null,"Residential mortgage-backed","AA+",849,874.2,0.10199999999999999,25.2,4.0999999999999996,16.7]
[null,null,"Commercial mortgage-backed ","AAA",507.5,532.9,6.2E-2,25.4,8.5,23.9]
[null,null,"Asset-backed ","AA+",78.599999999999994,79.2,8.9999999999999993E-3,0.6,0.3,1.2]
[null,"Total fixed maturities ",null,"A+",6842.8,7142,0.83599999999999997,299.2,99.7,249.8]
[null,"Equity securities",null,null,507.8,582.70000000000005,6.8000000000000005E-2,74.900000000000006,22.7,26.8]
[null,"Other investments",null,null,451.4,454.8,5.3999999999999999E-2,3.4,0,0]
[null,"Total investments",null,null,7802,8179.5,0.95799999999999996,377.5,122.4,276.60000000000002]
[null,"Cash and cash equivalents ",null,null,361.6,361.6,4.2000000000000003E-2,0,0,0]
[null,"Total ",null,null,8163.6,8541.1,1,377.5,122.4,276.60000000000002]

{"sheet":"19","index":22,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8]]}
["THE HANOVER INSURANCE GROUP"]
["CREDIT QUALITY AND DURATION OF FIXED MATURITIES"]
["June 30, 2016 "]
[]
["(In millions)"]
[]
["CREDIT QUALITY OF FIXED MATURITIES"]
[]
[null,null,"Rating Agency","Amortized",null,null,"Fair",null,"% of Total"]
[null,"NAIC Designation","Equivalent Designation","Cost",null,null,"Value",null,"Fair Value"]
[]
[null,1,"Aaa/Aa/A",null,4703,null,4926.3999999999996,null,0.69]
[null,2,"Baa",null,1708.6,null,1780.1,null,0.249]
[null,3,"Ba",null,216.9,null,220.5,null,3.1E-2]
[null,4,"B",null,195.8,null,193.5,null,2.7E-2]
[null,5,"Caa and lower",null,12.8,null,13.6,null,2E-3]
[null,6,"In or near default",null,5.7,null,7.9,null,1E-3]
["Total fixed maturities ",null,null,null,6842.8,null,7142,null,1]
[]
[]
[]
[null,"DURATION OF FIXED MATURITIES"]
[]
[null,null,null,"Amortized",null,null,"Fair",null,"% of Total"]
[null,null,null,"Cost",null,null,"Value",null,"Fair Value"]
[]
[null,null,"0-2 Years",null,1460.2,null,1493.7,null,0.20899999999999999]
[null,null,"2-4 Years",null,2171.3000000000002,null,2266.6,null,0.317]
[null,null,"4-6 Years",null,1829.2,null,1917.6,null,0.26900000000000002]
[null,null,"6-8 Years",null,1064.9000000000001,null,1124.8,null,0.158]
[null,null,"8-10 Years",null,258.89999999999998,null,273.60000000000002,null,3.7999999999999999E-2]
[null,null,"10+ Years",null,58.3,null,65.7,null,8.9999999999999993E-3]
[null,null,"Total fixed maturities",null,6842.8,null,7142,null,1]
[]
[null,null,"Weighted Average Duration",null,4.0199999999999996]

{"sheet":"20","index":23,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6]]}
[null,"THE HANOVER INSURANCE GROUP"]
[null,"TOP 10 CORPORATE AND MUNICIPAL FIXED MATURITY HOLDINGS"]
[null,"June 30, 2016 "]
[]
[]
[null,null,"(In millions, except percentage data)"]
[null,null,"Issuer","Amortized Cost","Fair Value","As a Percent of  Invested Assets","S&P Ratings"]
[null,null,"Royal Bank of Scotland: (1)"]
[null,null,"Term deposits",48.8,82.1,9.5999999999999992E-3,"A-"]
[null,null,"Notes ",7.6,9,1.1000000000000001E-3,"A"]
[null,null,"Anheuser-Busch",31.7,33.1,3.8999999999999998E-3,"A-"]
[null,null,"Bank of America",27.2,28.6,3.3E-3,"BBB+"]
[null,null,"Morgan Stanley",26.5,26.8,3.0999999999999999E-3,"BBB+"]
[null,null,"Glencore Funding ",24.8,24.6,2.8999999999999998E-3,"BBB-"]
[null,null,"Capital One",24.3,24.9,2.8999999999999998E-3,"BBB"]
[null,null,"US Bancorp",24.1,25.2,3.0000000000000001E-3,"A"]
[null,null,"Bank of New York Mellon",24,25.2,3.0000000000000001E-3,"A"]
[null,null,"AbbVie",24,24.8,2.8999999999999998E-3,"A-"]
[null,null,"PNC Bank",23.6,24.2,2.8E-3,"A-"]
[null,null,"AT&T",23.6,24.4,2.8999999999999998E-3,"BBB+"]
[null,null,"     Top 10 Corporate and Municipal Fixed",253.8,261.8,3.0700000000000002E-2]
[]
[null,null,"(1) UK government owns 79% of bank equity; term deposits mature in the fourth quarter of 2014."]

{"sheet":"21","index":24,"n_rows":34,"n_cols":21,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,9,9,10],[9,4,9,5],[9,14,9,15],[9,19,9,20],[1,0,1,20],[2,0,2,20],[7,2,7,10],[7,12,7,20],[8,2,8,5],[8,7,8,10],[8,12,8,15],[8,17,8,20]]}
[]
["THE HANOVER INSURANCE GROUP"]
["RECONCILIATION OF OPERATING INCOME TO NET INCOME "]
[]
[]
[]
[]
[null,null,"Three Months ended June 30",null,null,null,null,null,null,null,null,null,"Six Months ended June 30"]
[null,null,"2016",null,null,null,null,"2015",null,null,null,null,"2016",null,null,null,null,"2015"]
["(In millions, except per share data)",null,null,"$","Per\nShare (Diluted)",null,null,null,"$","Per\nShare (Diluted)",null,null,null,"$","Per\nShare (Diluted)",null,null,null,"$","Per\nShare (Diluted)"]
["OPERATING INCOME (LOSS)"]
["Commercial Lines",null,"$",44000000,null,null,null,"$",48200000,null,null,null,"$",86700000,null,null,null,"$",79400000]
["Personal Lines",null,null,47400000,null,null,null,null,32100000,null,null,null,null,94500000,null,null,null,null,54400000]
["Chaucer",null,null,5500000,null,null,null,null,42000000,null,null,null,null,39200000,null,null,null,null,91200000]
["Other ",null,null,-2200000,null,null,null,null,-2800000,null,null,null,null,-5300000,null,null,null,null,-5100000]
["Total",null,null,94700000,null,null,null,null,119500000,null,null,null,null,215100000,null,null,null,null,219900000]
[]
["Interest expense ",null,null,-15600000,null,null,null,null,-15000000,null,null,null,null,-30300000,null,null,null,null,-31100000]
[]
["Operating income before income taxes",null,null,79100000,"$",1.82,null,null,104500000,"$",2.3199999999999998,null,null,184800000,"$",4.25,null,null,188800000,"$",4.1900000000000004]
[]
["Income tax expense on operating income",null,null,-25100000,null,-0.57999999999999996,null,null,-34100000,null,-0.76,null,null,-59300000,null,-1.36,null,null,-61300000,null,-1.36]
[]
["Operating income after income taxes",null,null,54000000,null,1.24,null,null,70400000,null,1.56,null,null,125500000,null,2.89,null,null,127500000,null,2.83]
["Gain on disposal of U.K. motor business, net of tax",null,null,300000,null,0.01,null,null,40300000,null,0.91,null,null,900000,null,0.02,null,null,40300000,null,0.9]
["Other non-operating items:"]
["Net realized investment (losses) gains",null,null,-700000,null,-0.02,null,null,12600000,null,0.28000000000000003,null,null,800000,null,0.02,null,null,22000000,null,0.49]
["Loss from repurchase of debt",null,null,-86100000,null,-1.98,null,null,-1800000,null,-0.04,null,null,-86100000,null,-1.98,null,null,-18500000,null,-0.41]
["Other ",null,null,200000,null,0,null,null,-400000,null,-0.01,null,null,300000,null,0,null,null,-400000,null,-0.01]
["Income tax benefit on other non-operating items",null,null,34200000,null,0.79,null,null,-200000,null,-0.01,null,null,38600000,null,0.89,null,null,4900000,null,0.1]
["Income from continuing operations, net of taxes",null,null,1900000,null,0.04,null,null,120900000,null,2.69,null,null,80000000,null,1.84,null,null,175800000,null,3.9]
[]
["Discontinued operations, net of taxes",null,null,100000,null,0.01,null,null,-200000,null,-0.01,null,null,200000,null,0,null,null,-200000,null,0]
["NET INCOME",null,"$",2000000,"$",0.05,null,"$",120700000,"$",2.68,null,"$",80200000,"$",1.84,null,"$",175600000,"$",3.9]

{"sheet":"22","index":25,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[]
["   Non-GAAP Financial Measures"]
[]
[null,"The Hanover uses non-GAAP financial measures as important measures of the Company’s operating performance, which we believe provide investors with additional information regarding management’s evaluation of our results of operations and financial performance. The Company's non-GAAP measures include operating income before interest expense and taxes, total operating income after taxes, total operating income after taxes per share, total book value per share, total book value per share excluding net unrealized gains and losses related to investments, net of tax, tangible book value per share and measures of operating income and loss and combined ratios excluding catastrophe losses (catastrophe losses as discussed here and in all other measures include catastrophe loss development) and reserve development. After-tax operating income EPS (sometimes referred to as “after-tax operating income per share”) is a non-GAAP measure. It is defined as net income (loss) excluding the after-tax impact of net realized investment gains (losses), as well as results from discontinued operations for a period divided by the average number of diluted shares of common stock. "]
[]
[null,"Operating income before interest expense and taxes is net income, excluding interest expense on debt, income taxes and net realized investment gains and losses, because fluctuations in these gains and losses are determined by interest rates, financial markets and the timing of sales.  Operating income before interest expense and taxes also excludes net gains and losses on disposals of businesses, discontinued operations, restructuring costs, extraordinary items, the cumulative effect of accounting changes and certain other items. Operating income before interest expense and taxes is the sum of the operating income from:  Commercial Lines, Personal Lines, Chaucer, and Other.  The Hanover believes that measures of operating income before interest expense and taxes provide investors with a valuable measure of the performance of the Company’s ongoing businesses because they highlight net income attributable to the core operations of the business.  "]
[]
[null,"Book value per share is total shareholders’ equity divided by the number of common shares outstanding. Book value per share excluding net unrealized gains and losses related to investments, net of tax is total shareholders’ equity excluding the after-tax effect of unrealized investment gains and losses divided by the number of common shares outstanding.  Tangible book value per share is total shareholders' equity, excluding goodwill, divided by the number of common shares outstanding."]
[]
[null,"The Hanover also provides measures of operating income and loss ratios that exclude the effects of catastrophe losses.  A catastrophe is a severe loss, resulting from natural or manmade events, including risks such as fire, hurricane, earthquake, windstorm, explosion, terrorism or other similar events. Each catastrophe has unique characteristics. Catastrophes are not predictable as to timing or loss amount in advance. The Hanover believes that providing certain financial metrics and trends excluding the effects of catastrophes is meaningful for investors to understand the variability of periodic earnings and loss ratios.                                               "]
[]
[null,"Prior year reserve development, which can be favorable or unfavorable, represents changes in our estimate of the costs to pay claims from prior years. We believe that a discussion of operating income excluding prior year reserve development is helpful to investors since it provides insight into both our estimate of current year accident results and changes to prior-year reserve estimates."]
[]
[null,"Operating income before and after interest expense and taxes and measures of operating income that exclude the effects of catastrophe losses or reserve development should not be construed as substitutes for net income determined in accordance with GAAP. A reconciliation of income from continuing operations to operating income before interest expense and taxes and income from continuing operations per share to operating income after taxes per share for the three and six months ended June 30, 2016 and 2015 is set forth on page 21 of this document. The presentation of loss ratios calculated excluding the effects of reserve development and/or catastrophe losses should not be construed as a substitute for loss ratios determined in accordance with GAAP."]

{"sheet":"23","index":26,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[30,2,30,3],[39,2,39,3],[38,2,38,4],[29,2,29,4]]}
[]
[]
[null,"CORPORATE OFFICES AND",null,null,null,null,null,null,"INDUSTRY RATINGS AS OF JULY 28, 2016",null,null,null,null,null,null,"TRANSFER AGENT"]
[null,"PRINCIPAL SUBSIDIARIES"]
[]
[null,"THE HANOVER INSURANCE GROUP, INC.",null,null,null,null,null,null,null," ","A.M.","Standard",null,null,null,"Computershare Investor Services"]
[null,"440 Lincoln Street",null,null,null,null,null,null,"Financial Strength Ratings",null,"Best","& Poor's","Moody's",null,null,"PO Box 30170"]
[null,"Worcester, MA 01653",null,null,null,null,null,null,null,"The Hanover Insurance",null,null,null,null,null,"College Station, TX  77842-3170"]
[null,null,null,null,null,null,null,null,null,"Company","A","A","A3",null,null,"1-800-317-4454"]
[null,"The Hanover Insurance Company",null,null,null,null,null,null,null,"Citizens Insurance Company"]
[null,"440 Lincoln Street",null,null,null,null,null,null,null,"of America","A","A","-"]
[null,"Worcester, MA 01653"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMMON STOCK"]
[null,"Citizens Insurance Company of America",null,null,null,null,null,null,null,null,"A.M.","Standard"]
[null,"808 North Highlander Way",null,null,null,null,null,null,"Debt Ratings",null,"Best","& Poor's","Moody's",null,null,"Common stock of The Hanover Insurance Group is traded on the New"]
[null,"Howell, MI 48843",null,null,null,null,null,null,null,"The Hanover Insurance Group, Inc.",null,null,null,null,null,"York Stock Exchange under the symbol \"THG\"."]
[null,null,null,null,null,null,null,null,null,"Senior Debt","bbb","BBB","Baa3"]
[null,"Chaucer Holdings Limited",null,null,null,null,null,null,null,"Subordinated Debentures","bb+","BB+","Ba1"]
[null,"Plantation Place",null,null,null,null,null,null,null,null,null,null,null,null,null,"INQUIRIES "]
[null,"30 Fenchurch Street"]
[null,"London",null,null,null,null,null,null,null,null,null,null,null,null,null,"Oksana Lukasheva"]
[null,"EC3M 3AD",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vice President"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Investor Relations"]
[null,"MARKET AND DIVIDEND INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"(508) 855-2063"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"olukasheva@hanover.com"]
[null,"The following tables set forth the high and low closing "]
[null,"sales prices of our common stock and cash dividends ",null,null,null,null,null,null,null,null,null,null," "]
[null,"for the periods indicated:",null,null,null,null,null,null,null,null,null,null,null,null,null,"INVESTOR INFORMATION LINE"]
[]
[null,"Quarter Ended","2016",null,null,null,null,null,null,null,null,null,null,null,null,"Dial 1-800-407-5222 to receive additional printed information,"]
[null,null,"Price Range",null,"Dividends",null,null,null,null,null,null,null,null,null,null,"fax-on-demand services or other prerecorded messages."]
[null,null,"High","Low","Per Share",null," "]
[null,{"$f":"\"March 31\"","v":"March 31"},90.68,76.900000000000006,0.46,null,null,null,null,null,null,null,null,null,null,"Please visit our internet site at http:// www.Hanover.com"]
[null,{"$f":"\"June 30\"","v":"June 30"},91.15,80.41,0.46]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"Quarter Ended","2015"]
[null,null,"Price Range",null,"Dividends"]
[null,null,"High","Low","Per Share",null," "]
[null,{"$f":"\"March 31\"","v":"March 31"},73.349999999999994,68.180000000000007,0.41]
[null,{"$f":"\"June 30\"","v":"June 30"},74.87,68.569999999999993,0.41]
[null,{"$f":"\"September 30\"","v":"September 30"},82.82,75.39,0.41]
[null,{"$f":"\"December 31\"","v":"December 31"},86.58,77.400000000000006,0.46]
[]
[null,null,null," "]
[null," ",null," "," "]
[null," "]
[null," "]
[null," "]
[null," "]
[null," "]

{"sheet":"BS Equity Parentheticals","index":27,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
["FOOTNOTE INPUT"]
[{"$f":"FORMQTR&\", \"&VALUE(CV)","v":{"$error":"#REF!"}}]
[]
[]
["Page #","Footnote",null,null,null,null,{"$f":"\"YTD \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,null,{"$f":"\"YTD \"&RIGHT(PV,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,"CENTER-SUM",null,null,{"$f":"+G9","v":"CENTER-SUM"}]
[null,null,null,null,null,null,"PRODUCT",null,null,{"$f":"+G10","v":"PRODUCT"}]
[null,null,null,null,null,null,"LEGAL",null,null,"LEGAL"]
[null,null,null,null,null,null,"PROD-Q",null,null,"PROD-Q"]
[null,null,null,null,null,null,{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},null,null,{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"CY","v":{"$error":"#REF!"}},null,null,{"$f":"PYE","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"BOOK TYPE",null,null,"BOOK TYPE"]
[]
[3,"Commons Stock Issued"]
[null,"Commons Stock Issued",{"$f":"+CSISSUE_CY","v":60.5},null,null,"ICSTOCK",{"$f":"ROUND(G19/1000000,1)","v":60.5},null,"ICSTOCK",{"$f":"ROUND(J19/1000000,1)","v":60.5}]
[null,null,null,null,null,"ICSTOCK",60475872,null,"ICSTOCK",60475872]
[3,"Treasury Stock Shares Outstanding"]
[null,"Treasury Stock Shares Outstanding - per essbase",{"$f":"+TSOUT_CY","v":17.8},null,null,"TSTOCKOUT",{"$f":"(ROUND(G22/1000000,1))+(M21/1000000)","v":16.7},null,"TSTOCKOUT",{"$f":"(ROUND(J22/1000000,1))+(P21/1000000)","v":16.8}]
[null,"Common shares outstanding",{"$f":"ROUND('2'!P54/1000000,1)","v":42.7},null,null,"TSTOCKOUT",16733094,null,"TSTOCKOUT",16820438]
[null,"Treasury Stock Shares Outstanding - rounded for balance sheet",{"$f":"+C18-C22","v":17.8}]

{"sheet":"Development","index":28,"n_rows":19,"n_cols":22,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"BOOK TYPE","Product Qualifier","Summary Centers","Consolidated BU Rollup"]
[null,{"$f":"CQ","v":{"$error":"#REF!"}},{"$f":"CQ","v":{"$error":"#REF!"}},{"$f":"CQ","v":{"$error":"#REF!"}},{"$f":"_TEB2","v":{"$error":"#REF!"}},{"$f":"_TEB2","v":{"$error":"#REF!"}},{"$f":"_TEB2","v":{"$error":"#REF!"}},{"$f":"_TEB3","v":{"$error":"#REF!"}},{"$f":"_TEB3","v":{"$error":"#REF!"}},{"$f":"_TEB3","v":{"$error":"#REF!"}},{"$f":"_TEB4","v":{"$error":"#REF!"}},{"$f":"_TEB4","v":{"$error":"#REF!"}},{"$f":"_TEB4","v":{"$error":"#REF!"}},{"$f":"CQ","v":{"$error":"#REF!"}},{"$f":"CQ","v":{"$error":"#REF!"}},{"$f":"CQ","v":{"$error":"#REF!"}},{"$f":"CY","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR2)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR2)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR2)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR3)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR3)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR3)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR4)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR4)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(_TYR4)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}}]
[null,"PY-Loss-Dev(Fav)Unfav","PY-LAE-Dev(Fav)Unfav","PYLOSS-LAE DEV (Fav)Unfav","PY-Loss-Dev(Fav)Unfav","PY-LAE-Dev(Fav)Unfav","PYLOSS-LAE DEV (Fav)Unfav","PY-Loss-Dev(Fav)Unfav","PY-LAE-Dev(Fav)Unfav","PYLOSS-LAE DEV (Fav)Unfav","PY-Loss-Dev(Fav)Unfav","PY-LAE-Dev(Fav)Unfav","PYLOSS-LAE DEV (Fav)Unfav","PY-Loss-Dev(Fav)Unfav","PY-LAE-Dev(Fav)Unfav","PYLOSS-LAE DEV (Fav)Unfav","PY-Loss-Dev(Fav)Unfav","PY-LAE-Dev(Fav)Unfav","PYLOSS-LAE DEV (Fav)Unfav","PY-Loss-Dev(Fav)Unfav","PY-LAE-Dev(Fav)Unfav","PYLOSS-LAE DEV (Fav)Unfav"]
["Workers' Compensation",-3500000,"-",-3500000,-5100000,700000,-4400000,-1800000,200000,-1600000,-500000,200000,-300000,"-","-","-",-11100000,100000,-11000000,-2300000,400000,-1900000]
["Commercial Automobile",1900000,600000,2500000,2000000,600000,2600000,2700000,700000,3400000,3900000,200000,4100000,"-","-","-",6500000,1400000,7900000,6600000,900000,7500000]
["Commercial Multiple Peril",-1100000,1100000,0,-2300000,300000,-2000000,100000,-800000,-700000,-4400000,300000,-4100000,"-","-","-",-5200000,1200000,-4000000,-4300000,-500000,-4800000]
["Other Property & Casualty",4200000,-900000,3300000,2600000,1500000,4100000,-1300000,800000,-500000,900000,1200000,2100000,"-","-","-",9600000,500000,10100000,-400000,2000000,1600000]
["Total Commercial",1500000,800000,2300000,-2800000,3100000,300000,-300000,900000,600000,-100000,1900000,1800000,"-","-","-",-200000,3200000,3000000,-400000,2800000,2400000]
["Personal Automobile",2700000,400000,3100000,2300000,900000,3200000,-700000,-300000,-1000000,-2600000,-400000,-3000000,"-","-","-",9700000,700000,10400000,-3300000,-700000,-4000000]
["Homeowners",-1000000,"-",-1000000,100000,-100000,0,400000,-400000,0,1400000,-400000,1000000,"-","-","-",300000,-300000,0,1800000,-800000,1000000]
["Personal Other","-","-","-",100000,-100000,0,100000,-100000,0,-300000,100000,-200000,"-","-","-",100000,0,100000,-200000,0,-200000]
["Total Personal",1700000,400000,2100000,2500000,700000,3200000,-200000,-800000,-1000000,-1500000,-700000,-2200000,"-","-","-",10100000,400000,10500000,-1700000,-1500000,-3200000]
["Opus Investment Mgmt","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["AMGRO-PROD","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["VOLPROD",-200000,"-",-200000,400000,"-",400000,300000,0,300000,300000,100000,400000,"-","-","-",200000,700000,900000,600000,100000,700000]
["CORP-OTHER","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["OTHERP&C",-200000,"-",-200000,400000,"-",400000,300000,0,300000,300000,100000,400000,"-","-","-",200000,700000,900000,600000,100000,700000]
["P&C Products",-24800000,1200000,-23600000,-22700000,3800000,-18900000,-19800000,100000,-19700000,-30500000,1300000,-29200000,"-","-","-",-61700000,4300000,-57400000,-50300000,1400000,-48900000]

{"sheet":"Proof-THG","index":29,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
["Financial Highlights"]
[{"$f":"FORMQTR&\", \"&VALUE(CV)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"CQ&\"' \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"CQ&\"' \"&RIGHT(PV,2)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"\"YTD\"&\" \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"\"YTD\"&\" \"&RIGHT(PV,2)","v":{"$error":"#REF!"}}]
[null,"Page #'s",null,null,"Variance",null,"Variance",null,"Page #'s",null,null,"Variance",null,"Variance"]
[]
["SEGMENT INCOME "]
["    Property and Casualty"]
["         Personal Lines",1,9,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$9","v":1},10,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["        Commercial Lines ",{"$f":"+B$9","v":1},9,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$9","v":1},{"$f":"+J9","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["        Other",1,9,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$9","v":1},{"$f":"+J9","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Total Property and Casualty",1,9,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$9","v":1},{"$f":"+J9","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["Life Companies",{"$f":"+B9","v":1},13,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+B9","v":1},13,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["Income Reconciliation"]
["Income from continuing operations, net of taxes",{"$f":"+B9","v":1},4,null,{"$f":"+#REF!-'3'!D29","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!G29","v":{"$error":"#REF!"}},null,{"$f":"+$B$17","v":1},{"$f":"+$C$17","v":4},null,{"$f":"+#REF!-'3'!L29","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!O29","v":{"$error":"#REF!"}}]
["(Loss) Income from operations of discontinued FAFLIC"]
["   business, net of taxes",{"$f":"+B$17","v":1},{"$f":"+C$17","v":4},null,{"$f":"+#REF!-'3'!D31","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!G31","v":{"$error":"#REF!"}},null,{"$f":"+$B$17","v":1},{"$f":"+$C$17","v":4},null,{"$f":"+#REF!-'3'!L31","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}}]
["Income from operations of AMGRO, net of taxes",1,4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,1,4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}}]
["Gain on disposal of variable business",{"$f":"+B$17","v":1},4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,1,4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}}]
[" Income before cumulative effect of accounting change",1,4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,1,4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}}]
["Other",1,4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,1,4,null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!#REF!","v":{"$error":"#REF!"}}]
["Net (loss) income ",1,4,null,{"$f":"+#REF!-'3'!D33","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!G33","v":{"$error":"#REF!"}},null,1,4,null,{"$f":"+#REF!-'3'!L33","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'3'!O33","v":{"$error":"#REF!"}}]
[]
["Shareholders' Equity"]
["   The Hanover Insurance Company (consolidated)",3,8,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxx","xxxxxxx",null,"xxxxxxxxxxx",null,"xxxxxxxxxxx"]
["   First Allmerica Financial Life Ins Company (consolidated) ",{"$f":"+B27","v":3},14,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxx","xxxxxxx",null,"xxxxxxxxxxx",null,"xxxxxxxxxxx"]
["   THG Holding Company debt (1)",{"$f":"+B27","v":3},"PQ",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!+499.5*1000000","v":{"$error":"#REF!"}},null,"xxxxxxxxxx","xxxxxxx",null,"xxxxxxxxxxx",null,"xxxxxxxxxxx"]
["Total shareholders' equity",{"$f":"+B27","v":3},6,null,{"$f":"+#REF!-'4'!D45","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'4'!G45","v":{"$error":"#REF!"}},null,"xxxxxxxxxx","xxxxxxx",null,"xxxxxxxxxxx",null,"xxxxxxxxxxx"]
[]
["PER SHARE DATA (DILUTED):"]
["Income from continuing operations, net of taxes",2,5,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["(Loss) Income from operations of discontinued FAFLIC"]
["   business, net of taxes",{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Income from operations of AMGRO, net of taxes",{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Gain on disposal of variable business",{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Other",{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Cumulative effect of change in accounting "]
["   principle, net of taxes",{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Net income ",{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+$B$33","v":2},{"$f":"+$C$33","v":5},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Proof-BS","index":30,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["CONSOLIDATED BALANCE SHEETS"]
[null,null,null,null,null,null,"THG"]
[null,null,"THG",null,"P&C",null,"less P&C",null,"Ref #",null,"Variance","Comments"]
["ASSETS",null,"SS Page #6",null,"SS Page #8",null,null,null,null,null,null," "]
["Investments:"]
["     Fixed maturities, at fair value",null,{"$f":"+'4'!D10","v":7142000000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C6-E6","v":{"$error":"#REF!"}},null,1,null,{"$f":"SUM(G6)-SUM(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"\"     Equity securities, at fair value\"","v":"     Equity securities, at fair value"},null,{"$f":"+'4'!D11","v":582700000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C7-E7","v":{"$error":"#REF!"}},null,2,null,{"$f":"SUM(G7)-SUM(#REF!)","v":{"$error":"#REF!"}},"Rounding must go to P&C or Life"]
["     Mortgage loans",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C8-E8","v":{"$error":"#REF!"}},null,3,null,{"$f":"SUM(G8)-SUM(#REF!)","v":{"$error":"#REF!"}},"ok - mtg elim"]
["     Policy loans",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"+C9-E9","v":{"$error":"#REF!"}},null,4,null,{"$f":"SUM(G9)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["     Other long-term investments",null,{"$f":"+'4'!D12","v":454800000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C10-E10","v":{"$error":"#REF!"}},null,5,null,{"$f":"SUM(G10)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["          Total investments",null,{"$f":"+'4'!D13","v":8179500000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxxxxxxxx"]
["Cash and cash equivalents",null,{"$f":"+'4'!D14","v":361600000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C12-E12","v":{"$error":"#REF!"}},null,6,null,{"$f":"SUM(G12)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["Accrued investment income",null,{"$f":"+'4'!D15","v":60600000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,7,null,{"$f":"SUM(G13)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["Premiums, accounts and notes receivable, net",null,{"$f":"+'4'!D16","v":1509800000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,8,null,{"$f":"SUM(G14)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["Reinsurance receivable on paid and unpaid",null," ",null," "]
["     losses, benefits and unearned premiums",null,{"$f":"+'4'!D17","v":2688100000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,9,null,{"$f":"SUM(G16)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["Deferred policy acquistion costs",null,{"$f":"+'4'!D18","v":522500000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,10,null,{"$f":"SUM(G17)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["Deferred federal income taxes",null,{"$f":"+'4'!D19","v":50400000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,11,null,{"$f":"SUM(G18)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["Goodwill",null,{"$f":"+'4'!D20","v":185200000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,12,null,{"$f":"SUM(G19)-SUM(#REF!)","v":{"$error":"#REF!"}}]
["Other assets",null,{"$f":"+'4'!D21","v":525700000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,13,null,{"$f":"SUM(G20)-SUM(#REF!-#REF!-#REF!)","v":{"$error":"#REF!"}}]
["Separate account assets",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},null,"n/a",null," "]
["     Total assets",null,{"$f":"+'4'!D23","v":14163600000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxxxxxxxx",null,null,null,{"$f":"SUM(K6:K20)","v":{"$error":"#REF!"}}]
[" "]
["LIABILITIES AND SHAREHOLDERS' EQUITY"]
[]
["LIABILITIES"]
["Policy liabilities and accruals:"]
["     Future policy benefits",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"+C28-E28","v":{"$error":"#REF!"}},null,14,null,{"$f":"SUM(G28)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["     Outstanding claims, losses and loss adjustment expenses",null,{"$f":"+'4'!D28","v":6778000000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C29-E29","v":{"$error":"#REF!"}},null,15,null,{"$f":"SUM(G29)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["     Unearned premiums",null,{"$f":"+'4'!D29","v":2620500000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C30-E30","v":{"$error":"#REF!"}},null,16,null,{"$f":"SUM(G30)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["     Contractholder deposit funds and other policy liabilities",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C31-E31","v":{"$error":"#REF!"}},null,17,null,{"$f":"SUM(G31)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["          Total policy liabilities and accruals",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxxxxxxxx"]
["Expenses and taxes payable",null,{"$f":"+'4'!D30","v":594000000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C33-E33","v":{"$error":"#REF!"}},null,18,null,{"$f":"SUM(G33)+SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},"Rounding is okay here."]
["Reinsurance premiums payable",null,{"$f":"+'4'!D31","v":274700000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C34-E34","v":{"$error":"#REF!"}},null,19,null,{"$f":"SUM(G34)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["Trust instruments supported by funding obligations",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"+C35-E35","v":{"$error":"#REF!"}},null,20,null,{"$f":"SUM(G35)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["Long-term debt",null,{"$f":"+'4'!D32","v":797800000},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C36-E36","v":{"$error":"#REF!"}},null,21,null,{"$f":"SUM(G36)+SUM(#REF!)","v":{"$error":"#REF!"}},"PDI"]
["Separate account liabilities",null,{"$f":"+'4'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"+C37-E37","v":{"$error":"#REF!"}},null,22,null,{"$f":"SUM(G37)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["     Total liabilities",null,{"$f":"+'4'!D34","v":11153900000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxxxxxxxx"]
[]
["SHAREHOLDERS' EQUITY"]
["Preferred stock, par value $xx per share;"]
["     authorized xxx million shares; issued none",null,{"$f":"+'4'!D38","v":0},null,null,null,{"$f":"+C42-E42","v":0},null,23,null,{"$f":"SUM(G42)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["Common stock, par value $.xx per share; authorized xxx.0 million"]
[{"$f":"\"     shares; issued\"","v":"     shares; issued"},null,{"$f":"+'4'!D40","v":600000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,24,null,{"$f":"SUM(G44)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["Additional paid-in capital",null,{"$f":"+'4'!D41","v":1835200000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,25,null,{"$f":"SUM(G45)+SUM(#REF!+#REF!)","v":{"$error":"#REF!"}}]
["Accumulated other comprehensive (loss) income",null,{"$f":"+'4'!D42","v":229400000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,26,null,{"$f":"SUM(G46)+SUM(#REF!)","v":{"$error":"#REF!"}},"rounding ok here…assume variance is other P&C"]
["Retained earnings",null,{"$f":"+'4'!D43","v":1841500000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,27,null,{"$f":"SUM(G47)+SUM(#REF!)","v":{"$error":"#REF!"}},"rounding ok here…assume variance is other P&C"]
[{"$f":"\"Treasury stock at cost\"","v":"Treasury stock at cost"},null,{"$f":"+'4'!D44","v":-897000000},null,null,null,-897000000,null,28,null,{"$f":"SUM(G48)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["     Total shareholders' equity",null,{"$f":"+'4'!D45","v":3009700000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxxxxxxxx"]
["     Total liabilities and shareholders' equity",null,{"$f":"+'4'!D46","v":14163600000},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"xxxxxxxxxxxxxxxx"]
[]
[]
[]
[]
[null,null,null,"= Items highlighted are not applicable to the individual business unit noted."]
[]
[null,null,null,"= Items that should be zero (no reconciliation necessary)."]

{"sheet":"BS Retrieve","index":31,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,"BOOK TYPE","Product Qualifier","Corporate-Capacity","2010 Non Rounded",{"$f":"CY","v":{"$error":"#REF!"}},"All Products"]
[null,"SMAFCO Consolidated","Campania Consolidated","Verlan Consolidated","Benchmark Professionals Ins Svcs","Educators Insurance Agency, Inc.","Benchmark Purchasing Acctg Adj","The Hanover Insurance Group Total",null,"Rounded"]
["Fixed Maturities",4581634874.5699997,0,"-    ","-    ","-    ","-    ",{"$f":"SUM(B3:G3)","v":4581634874.5699997},null,{"$f":"ROUND((H3+H4),)","v":4586400000}]
["S.T. Fixed Maturities",4803100.91,"-    ",0,"-    ","-    ","-    ",4803100.91]
["Equity Securities",124677939.73999999,"-    ","-    ","-    ","-    ","-    ",124677939.73999999,null,{"$f":"+H5","v":124700000}]
["Mortgage Loans Receivable",5665879.2999999998,"-    ","-    ","-    ","-    ","-    ",5665879.2999999998,null,{"$f":"+H6","v":5700000}]
["Policy Loans Receivable","-    ","-    ","-    ","-    ","-    ","-    ",0,null,{"$f":"+H7","v":0}]
["Real Estate",8872141.8100000005,"-    ","-    ","-    ","-    ","-    ",8872141.8100000005,null,{"$f":"+H8+H9","v":31900000}]
["Other Long Term Investments",23031525.02,"-    ","-    ","-    ","-    ","-    ",23031525.02]
["Cash & Cash Equivalents",235154256.08000001,832049.63,1538081.32,133440.12,1604867.52,"-    ",239262694.66999999,null,{"$f":"+H10","v":239300000}]
["Accrued Investment Income Receivable",50705359.140000001,0,0,"-    ","-    ","-    ",50705359.140000001,null,50700000]
["Premiums, Accounts, & Notes Receivable",807813790.62,27205.66,"-    ",-6754.78,188223.02,"-    ",808022464.51999998,null,808000000]
["Total Reinsurance Receivables",1230299516.23,"-    ","-    ","-    ","-    ","-    ",1230299516.23,null,1230300000]
["Deferred Policy Acquistion Costs",347163997.50999999,"-    ","-    ","-    ","-    ","-    ",347163997.50999999,null,347200000]
["Deferred FIT","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Deferred FIT Asset",119114560,44367.91,-69038.63,"-    ",-0.01,-300437.21999999997,118789452.05,null,118800000]
["Goodwill",176180464.38,"-    ",2572667.64,"-    ",194000,428228,179375360.02000001,null,179400000]
["Property & Equipment",95925543.319999993,164253.29,"-    ","-    ","-    ","-    ",96089796.609999999,null,{"$f":"ROUND((H18+H21),-1)","v":375300000}]
["Other Assets (Receivable)",446477822.94,74291.66,3628827.04,12857.22,7150000,1286620.8600000001,458630419.72000003]
["Goodwill",176180464.38,"-    ",2572667.64,"-    ",194000,428228,179375360.02000001,null,{"$f":"+H20","v":179400000}]
[null,null,null,null,null,null,null,{"$f":"SUM(H19)-SUM(H20)","v":279255059.69999999}]
["Assets of Discontinued Operations",134127301.23,"-    ","-    ","-    ","-    ","-    ",{"$f":"SUM(B22:G22)","v":134127301.23},null,{"$f":"+H22","v":134100000}]
["ASSET",8215467608.4099998,1142168.1499999999,5097869.7300000004,139542.56,8943090.5299999993,986183.64,{"$f":"SUM(B23:G23)","v":8231776463.0200005},null,{"$f":"+H23","v":8231800000}]
[]
[]
[]
["Future Policy Benefits Payable","-    ","-    ","-    ","-    ","-    ","-    ",{"$f":"SUM(B27:G27)","v":0},null,{"$f":"+H27","v":0}]
["Outstanding Claims, Losses & LAE",-3230006824.7199998,"-    ","-    ","-    ","-    ","-    ",-3230006824.7199998,null,{"$f":"ROUND((H28+H30),)","v":-3232100000}]
["Unearned Premiums Payable",-1553550175.8399999,"-    ","-    ","-    ","-    ","-    ",-1553550175.8399999,null,{"$f":"+H29","v":-1553600000}]
["Other Policy Funds & Liabilities",-2087722.36,"-    ","-    ","-    ","-    ","-    ",-2087722.36]
["Expenses & Taxes Payable",-508976097.88,82531.199999999997,-1320768.68,-44886.96,-1505943.53,"-    ",-511765165.85000002,null,{"$f":"ROUND((H31+H32),-1)","v":-524800000}]
["Net Inter-Company",-12824542.93,41510.43,-85008.61,-33382.050000000003,-139918.17000000001,"-    ",-13041341.33]
["Reinsurance Premiums Payable",-33172296.41,"-    ","-    ","-    ","-    ","-    ",-33172296.41,null,{"$f":"+H33","v":-33200000}]
["Trust Instruments Supported by Funding Obligations","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Long-Term Debt",-154045837.15000001,0,"-    ","-    ","-    ","-    ",-154045837.15000001,null,-154000000]
["Deferred FIT","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Separate Account Liabilities","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Liabilities of Discontinued Operations",-135253959.50999999,"-    ","-    ","-    ","-    ","-    ",-135253959.50999999,null,-135300000]
["LIABILITY",-5629917456.8000002,124041.63,-1405777.29,-78269.009999999995,-1645861.7,"-    ",-5632923323.1700001,null,-5632900000]
[]
["Capital Stock Preferred",0,"-    ","-    ","-    ","-    ","-    ",{"$f":"SUM(B41:G41)","v":0},null,{"$f":"+H41","v":0}]
["Capital Stock Common",-1045.22,574617.84,0,"-    ",-1000,"-    ",572572.62,null,600000]
["Additional Paid-In Capital",-786608243.37,-2585520.98,-21240437.780000001,"-    ",-7150000,-1063928,-818648130.13,null,-818600000]
["Treasury Stock Additional Paid-In Capital","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Unrealized Capital Gains(Losses)",-164926688.31999999,"-    ",0.08,"-    ",0.01,"-    ",-164926688.22999999,null,-164900000]
["Retained Earnings",-1634014174.71,744693.36,17548345.260000002,-61273.55,-146228.84,77744.36,-1615850894.1199999,null,-1615900000]
["Treasury Stock",0,"-    ","-    ","-    ","-    ","-    ",0,null,0]
["Total Stockholders Equity",-2585550151.6199999,-1266209.78,-3692092.44,-61273.55,-7297228.8300000001,-986183.64,-2598853139.8600001,null,-2598900000]

{"sheet":"Essbase - P&C BS","index":32,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[null,"BOOK TYPE","Product Qualifier","Corporate-Capacity",null,"2010 Non Rounded",{"$f":"CY","v":{"$error":"#REF!"}},"All Products"]
[null,"SMAFCO Consolidated","Campania Consolidated","Verlan Consolidated","Educators Insurance Agency, Inc.","Benchmark Professionals Ins Svcs","Benchmark Purchasing Acctg Adj","The Hanover Insurance Group Total",null,"Rounded"]
["Fixed Maturities",4409339433.7700005,0,"-    ","-    ","-    ","-    ",{"$f":"SUM(B3:G3)","v":4409339433.7700005},null,{"$f":"ROUND((H3+H4),)","v":4417300000}]
["S.T. Fixed Maturities",7935675.5999999996,"-    ",0,"-    ","-    ","-    ",7935675.5999999996]
["Equity Securities",127623741.8,"-    ","-    ","-    ","-    ","-    ",127623741.8,null,{"$f":"+H5","v":127600000}]
["Mortgage Loans Receivable",5454367.29,"-    ","-    ","-    ","-    ","-    ",5454367.29,null,{"$f":"+H6","v":5500000}]
["Policy Loans Receivable","-    ","-    ","-    ","-    ","-    ","-    ",0,null,{"$f":"+H7","v":0}]
["Real Estate",10384960.279999999,"-    ","-    ","-    ","-    ","-    ",10384960.279999999]
["Other Long Term Investments",23585156.469999999,"-    ","-    ","-    ","-    ","-    ",23585156.469999999,null,{"$f":"ROUND((H9+H8),-1)","v":34000000}]
["Cash & Cash Equivalents",218869711,522117.91,1530130.83,1471047.1,64741.73,"-    ",222457748.56999999,null,{"$f":"+H10","v":222500000}]
["Accrued Investment Income Receivable",50428063.939999998,0,0,"-    ","-    ","-    ",50428063.939999998,null,{"$f":"+H11","v":50400000}]
["Premiums, Accounts, & Notes Receivable",770447419.33000004,37308.839999999997,"-    ",217709.27,0,"-    ",770702437.44000006,null,{"$f":"+H12","v":770700000}]
["Future Policy Benefits Receivable","-    ","-    ","-    ","-    ","-    ","-    "]
["OSL-LIFEADJ","-    ","-    ","-    ","-    ","-    ","-    "]
["OSL-PCADJ",1064780707.37,"-    ","-    ","-    ","-    ","-    "]
["Outstanding Claims, Losses, & LAE Receivable",1064780707.37,"-    ","-    ","-    ","-    ","-    "]
["UNPREM-PC",77849755.519999996,"-    ","-    ","-    ","-    ","-    "]
["UNPREM-LIFE","-    ","-    ","-    ","-    ","-    ","-    "]
["Unearned Premiums Receivable",77849755.519999996,"-    ","-    ","-    ","-    ","-    "]
["Exhibit8-FG LIAB Reclass","-    ","-    ","-    ","-    ","-    ","-    "]
["Reinsurance Recoverables",1119102937.23,"-    ","-    ","-    ","-    ","-    "]
["ORR-PCADJ",-1064780707.37,"-    ","-    ","-    ","-    ","-    "]
["Ceded Reinsurance Recover Affiliates",5613938.7400000002,"-    ","-    ","-    ","-    ","-    "]
["Ceded Reinsurance Receivable",0,"-    ","-    ","-    ","-    ","-    "]
["Group Conv Charges Receivable","-    ","-    ","-    ","-    ","-    ","-    "]
["Amounts Recoverable On Reinsurance",0,"-    ","-    ","-    ","-    ","-    "]
["Commission & Expense Allowance Due-Reinsurance",1708850.17,"-    ","-    ","-    ","-    ","-    "]
["Experience Refund Receivable","-    ","-    ","-    ","-    ","-    ","-    "]
["Other Reinsurance Receivable",61645018.770000003,"-    ","-    ","-    ","-    ","-    "]
["Total Reinsurance Receivables",1204275481.6600001,"-    ","-    ","-    ","-    ","-    ",{"$f":"SUM(B30:G30)","v":1204275481.6600001},null,{"$f":"+H30","v":1204300000}]
["Deferred Policy Acquistion Costs",346674708.10000002,"-    ","-    ","-    ","-    ","-    ",346674708.10000002,null,{"$f":"+H31","v":346700000}]
["Deferred FIT","-    ","-    ","-    ","-    ","-    ","-    ",0,null,{"$f":"+H32","v":0}]
["Deferred FIT Asset",154785750.75999999,17960.91,-48826.13,-0.01,"-    ",-286483.06,154468402.47,null,{"$f":"+H33","v":154500000}]
["Goodwill",175772914.38,"-    ",2572667.64,194000,"-    ",428228,178967810.02000001,null,{"$f":"+H34","v":179000000}]
["Property & Equipment",96621651.560000002,0,"-    ","-    ","-    ","-    ",96621651.560000002,null,{"$f":"ROUND((H35+H38),-1)","v":402100000}]
["Other Assets (Receivable)",473547849.50999999,66713.56,3201496.91,6421447,9642.9599999999991,1246751.82,484493901.75999999]
["Goodwill",175772914.38,"-    ",2572667.64,194000,"-    ",428228,178967810.02000001,null,{"$f":"+H37","v":179000000}]
[null,null,null,null,null,null,null,{"$f":"SUM(H36)-SUM(H37)","v":305526091.74000001}]
["Assets of Discontinued Operations",133633081.77,"-    ","-    ","-    ","-    ","-    ",{"$f":"SUM(B39:G39)","v":133633081.77},null,{"$f":"+H39","v":133600000}]
["ASSET",8033607052.8299999,644101.22,4682801.6100000003,8110203.3600000003,74384.69,960268.76,{"$f":"SUM(B40:G40)","v":8048078812.4700003},null,{"$f":"+H40","v":8048100000}]
[]
[]
[]
["Future Policy Benefits Payable","-    ","-    ","-    ","-    ","-    ","-    ",{"$f":"SUM(B44:G44)","v":0},null,{"$f":"-H44","v":0}]
["Outstanding Claims, Losses & LAE",-3227564281,"-    ","-    ","-    ","-    ","-    ",-3227564281,null,{"$f":"-ROUND((H45+H47),)","v":3229400000}]
["Unearned Premiums Payable",-1522745682.28,"-    ","-    ","-    ","-    ","-    ",-1522745682.28,null,{"$f":"-H46","v":1522700000}]
["Other Policy Funds & Liabilities",-1846090.61,"-    ","-    ","-    ","-    ","-    ",-1846090.61]
["Expenses & Taxes Payable",-451059498.94,475424.94,-928965.21,-1157979.3400000001,-321.41000000000003,"-    ",-452671339.95999998,null,{"$f":"-ROUND((H48+H49),-1)","v":465500000}]
["Net Inter-Company",-12759281.74,111058.69,-67662.17,-80006.95,-14248.73,"-    ",-12810140.9]
["Reinsurance Premiums Payable",-33941820.219999999,"-    ","-    ","-    ","-    ","-    ",-33941820.219999999,null,{"$f":"-H50","v":33900000}]
["Trust Instruments Supported by Funding Obligations","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Long-Term Debt",-156008510.99000001,0,"-    ","-    ","-    ","-    ",-156008510.99000001,null,156000000]
["Deferred FIT","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Separate Account Liabilities","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Liabilities of Discontinued Operations",-129400337.61,"-    ","-    ","-    ","-    ","-    ",-129400337.61,null,129400000]
["LIABILITY",-5535325503.3999996,586483.63,-996627.38,-1237986.29,-14570.14,"-    ",-5536988203.5799999,null,5537000000]
[]
["Capital Stock Preferred",0,"-    ","-    ","-    ","-    ","-    ",{"$f":"SUM(B58:G58)","v":0},null,{"$f":"-H58","v":0}]
["Capital Stock Common",-1045.22,574617.84,0,-1000,"-    ","-    ",572572.62,null,-600000]
["Additional Paid-In Capital",-786608243.37,-2585520.98,-21240437.780000001,-7150000,"-    ",-1063928,-818648130.13,null,818600000]
["Treasury Stock Additional Paid-In Capital","-    ","-    ","-    ","-    ","-    ","-    ",0,null,0]
["Unrealized Capital Gains(Losses)",-97235801.530000001,"-    ",0.08,0.01,"-    ","-    ",-97235801.439999998,null,97200000]
["Retained Earnings",-1614436459.3099999,780318.29,17554263.469999999,278782.92,-59814.55,103659.24,-1595779249.9400001,null,1595800000]
["Treasury Stock",0,"-    ","-    ","-    ","-    ","-    ",0,null,0]
["Total Stockholders Equity",-2498281549.4400001,-1230584.8500000001,-3686174.23,-6872217.0700000003,-59814.55,-960268.76,-2511090608.9000001,null,2511100000]

{"sheet":"Proof-P&C","index":33,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
["Property and Casualty"]
[{"$f":"FORMQTR&\", \"&VALUE(CV)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"CQ&\"' \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"CQ&\"' \"&RIGHT(PV,2)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"\"YTD\"&\" \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"\"YTD\"&\" \"&RIGHT(PV,2)","v":{"$error":"#REF!"}}]
[null,"Page #'s",null,null,"Variance",null,"Variance",null,"Page #'s",null,null,"Variance",null,"Variance"]
[]
["Net investment income   ",7,9,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,7,10,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["Segment Income Before Taxes:"]
["     Personal Lines",1,9,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+B10","v":1},10,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["     Commercial Lines",1,{"$f":"+C$10","v":9},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,1,{"$f":"+J10","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["     Other P&C",1,{"$f":"+C$10","v":9},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,1,{"$f":"+J10","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["     Total P&C segment income",1,{"$f":"+C$10","v":9},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,1,{"$f":"+J10","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["Segment income before taxes",{"$f":"+C7","v":9},{"$f":"+C10","v":9},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+B15","v":9},{"$f":"+J10","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["GAAP to Stat: Prior year reserve development:"]
["  Personal auto",{"$f":"+C10","v":9},"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+J10","v":10},"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["  Homeowners",{"$f":"+B$18","v":9},"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I$18","v":10},"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["  Other personal",9,"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,10,"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["  Total personal",9,"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,10,"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["  Workers compensation",{"$f":"+B$18","v":9},"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I$18","v":10},"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["  Commercial Automobile",9,"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,10,"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["  Commercial multiple peril",9,"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,10,"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["  Other commercial lines",9,"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,10,"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["  Total commericial",9,"Calc 20",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,10,"calc 21",null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["  Other property and casualty",{"$f":"+B$18","v":9},{"$f":"+C$18","v":"Calc 20"},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I$18","v":10},{"$f":"+J$18","v":"calc 21"},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["  Total Property and Casualty",{"$f":"+B$18","v":9},{"$f":"+C$18","v":"Calc 20"},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I$18","v":10},{"$f":"+J$18","v":"calc 21"},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
["Net premiums written",7,9,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,7,10,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Net premiums earned",{"$f":"+B33","v":7},{"$f":"+C33","v":9},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I33","v":7},{"$f":"+J33","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Other Income",{"$f":"+B33","v":7},{"$f":"+C33","v":9},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I33","v":7},{"$f":"+J33","v":10},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
["Policy benefits, claims, losses and LAE",{"$f":"+B33","v":7},{"$f":"+C33","v":9},null,{"$f":"+#REF!-#REF!-#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!-#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I33","v":7},{"$f":"+J33","v":10},null,{"$f":"+#REF!-#REF!-#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-#REF!-#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
["Policy acquisition and other op ex",{"$f":"+B33","v":7},{"$f":"+C33","v":9},null,{"$f":"+#REF!+#REF!-#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!+#REF!-#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+I33","v":7},{"$f":"+J33","v":10},null,{"$f":"+#REF!+#REF!-#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!+#REF!-#REF!+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Proof-Inv.","index":34,"n_rows":33,"n_cols":22,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
["Investments"]
[{"$f":"FORMQTR&\", \"&VALUE(CV)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CQ&\"' \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"CQ&\"' \"&RIGHT(PV,2)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"\"YTD\"&\" \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"\"YTD\"&\" \"&RIGHT(PV,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Page #'s",null,null,"Variance",null,"Variance",null,"Page #'s",null,null,"Variance",null,"Variance",null,"Notes"]
["Net Investment Income:",null,null,null,null,null,null," ",null," ",null,null,null,null," ",null," ",null,null,null,null,"Uses retrieves to verify the NII for the period."]
["         Total Company",null,null,null,null,null,null,4,"13, 14-Q1",null,{"$f":"+'3'!D11-'17'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'3'!G11-'17'!N13","v":70700000},null,4,13,null,{"$f":"+'3'!L11-'17'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'3'!O11-'17'!N13","v":140800000}]
[null,null,{"$f":"CY","v":{"$error":"#REF!"}},null,{"$f":"CY","v":{"$error":"#REF!"}},null,{"$f":"CY","v":{"$error":"#REF!"}}]
[null,null,{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},null,{"$f":"VALUE(CV)&\" Actuals\"","v":{"$error":"#REF!"}},null,{"$f":"VALUE(PV)&\" Actuals\"","v":{"$error":"#REF!"}}]
[null,null,"Net Investment  Income-",null,"Net Investment  Income-",null,"Net Investment  Income-"]
[null,null,"GAAP",null,"GAAP",null,"GAAP"]
[null,null,"Product Qualifier",null,"Product Qualifier",null,"Product Qualifier"]
[null,null,"Corporate-Capacity",null,"Corporate-Capacity",null,"Corporate-Capacity"]
[null,null,"THG Consolidated",null,"THG Consolidated",null,"THG Consolidated"]
[null,"Corporate Segment","-","Eliminations",0,"Eliminations",0]
[null,null,{"$f":"(+C15)*-1","v":{"$error":"#VALUE!"}}]
[]
["         Property and Casualty",null,null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx",null,"xxxxxxxxxxxxx",null,"xxxxxxxxxxxxx",null,5,{"$f":"+P7","v":13},null,{"$f":"+#REF!-'17'!#REF!-'Proof-Inv.'!E15+'Proof-Inv.'!C16","v":{"$error":"#REF!"}},null,{"$f":"+#REF!/1000000-'Proof-Inv.'!G15/1000000+'17'!N13/10000000","v":{"$error":"#REF!"}},null,"P&C plus corp seg less elims = page 19"]
["         Life Companies",null,null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx",null,"xxxxxxxxxxxxx",null,"xxxxxxxxxxxxx",null,12,{"$f":"+P7","v":13},null,{"$f":"+#REF!-'17'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'17'!#REF!","v":{"$error":"#REF!"}}]
[]
["Net realized investment gains",null,null,null,null,null,null,{"$f":"+O7","v":4},14,null,{"$f":"+'3'!D12-#REF!*1000000","v":{"$error":"#REF!"}},null,{"$f":"+'3'!G12-#REF!*1000000","v":{"$error":"#REF!"}},null,{"$f":"+H21","v":4},14,null,{"$f":"+'3'!L12-#REF!*1000000","v":{"$error":"#REF!"}},null,{"$f":"+'3'!O12-#REF!*1000000","v":{"$error":"#REF!"}}]
[]
["Fixed maturities amortized cost:"]
["    Life companies",null,null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx",null,"xxxxxxxxxxxxx",null,"xxxxxxxxxxxxx",null,"OLD14",16,null,{"$f":"+#REF!-'19'!#REF!","v":{"$error":"#REF!"}},null,"n/a"]
["     Total",null,null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx",null,"xxxxxxxxxxxxx",null,"xxxxxxxxxxxxx",null,6,16,null,{"$f":"+#REF!-'19'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'19'!#REF!","v":{"$error":"#REF!"}}]
[]
["Fixed maturities fair value:"]
["    Life companies",null,null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx",null,"xxxxxxxxxxxxx",null,"xxxxxxxxxxxxx",null,"OLD14",16,null,{"$f":"+#REF!-'19'!#REF!*1000000","v":{"$error":"#REF!"}},null,"n/a"]
["     Total",null,null,null,null,null,null,"xxxxxxxxx","xxxxxxxxx",null,"xxxxxxxxxxxxx",null,"xxxxxxxxxxxxx",null,6,16,null,{"$f":"+'4'!D10-('19'!#REF!-'19'!#REF!)*1000000","v":{"$error":"#REF!"}},null,{"$f":"+'4'!G10-'19'!#REF!*1000000","v":{"$error":"#REF!"}}]
[]
[]
["updated 08/03/2006 by SHA"]
["updated 7/24/08 by JPH"]

{"sheet":"Proof-History","index":35,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[]
["Historical Financial Highlights"]
[{"$f":"FORMQTR&\", \"&VALUE(CV)","v":{"$error":"#REF!"}},null,"MANUALLY UPDATE CELL REFERENCES FOR QTR COLUMNS!!"]
[null,null,null,null,{"$f":"CQ&\"' \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"CQ&\"' \"&RIGHT(PV,2)","v":{"$error":"#REF!"}},null,{"$f":"CY&\"' \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,{"$f":"CY&\"' \"&RIGHT(PV,2)","v":{"$error":"#REF!"}}]
[null,"Page #'s",null,null,"Variance",null,"Variance",null,"Variance",null,"Variance"]
["SEGMENT INCOME:"," ",null," ",null,null,null,null,null,null," ",null," "]
["Property and Casualty"]
["       Personal Lines",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!P13","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F13:Q13)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["       Commercial Lines",1,{"$f":"+C8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!P12","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F12:Q12)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["       Other",1,{"$f":"+C8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!P15","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F15:Q15)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Total Property and Casualty",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!P16","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F16:Q16)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Life Companies",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Corporate Debt ",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!P18","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F18:Q18)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
[]
["Total segment income before federal income taxes",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!P20","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F20:Q20)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
[]
["Federal income tax (expense) benefit on segment income",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!P22","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F22:Q22)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Total segment income after federal income taxes",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-SUM('21'!P24)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F24:Q24)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Change in prior years tax reserves",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Net realized investment gains (losses), net of amortization and taxes",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!P27","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F27:Q27)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["(Losses) gains from retirement of funding agreements and trust"]
["     instruments supported by funding obligations, net of taxes",1,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"SUM(#REF!)-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Restructuring costs, net of taxes",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Federal income tax expense on non-segment income",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!P30","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F30:Q30)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["  Income from continuing operations, net of taxes",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!P31","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F31:Q31)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
[]
["Income from discontinued variable life insurance and"]
["annuity business, net of taxes",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["(Loss) income from operations of discontiued FAFLIC",1,"19, 15Q1",null,{"$f":"#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!-'21'!#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!-'21'!#REF!-'21'!#REF!","v":{"$error":"#REF!"}}]
["Income from operations of AMGRO",1,"19, 15Q1",null,{"$f":"#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!-'21'!#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!-'21'!#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"Amgro sale "]
["Loss on disposal of variable life insurance and annuity"]
["    business, net of taxes",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Other",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
[" Income before cumulative effect of accounting change",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Cumulative effect of change in accounting "]
["principle, net of taxes",1,"19, 15Q1",null,{"$f":"SUM(#REF!)-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!-'21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
["Net income ",1,"19, 15Q1",null,{"$f":"+#REF!-'21'!P34","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!F34:Q34)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-SUM('21'!#REF!)","v":{"$error":"#REF!"}}]
[]
["PER SHARE DATA (DILUTED)"]
["     INCOME (LOSS) FROM CONTINUING OPERATIONS",2,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
["     (LOSS) INCOME FROM DISCONTINUED OPERATIONS,"]
["       NET OF TAXES",2,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
["     NET INCOME (LOSS) ",2,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
[]
["WEIGHTED AVERAGE SHARES"]
["     OUTSTANDING (DILUTED)",5,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
[]
["BALANCE SHEET:",null,null,null,{"$f":"CQ&\"' \"&RIGHT(CV,2)","v":{"$error":"#REF!"}},null,"PY End"]
["     Total investments",6,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+'4'!D13-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'4'!G13-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
["     Separate account assets",6,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+'4'!#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'4'!#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
["     Total assets",6,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+'4'!D23-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'4'!G23-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
["     Total shareholders' equity",6,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"+'4'!D45-'21'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'4'!G45-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
["     Book value per share",3,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"SUM(#REF!)-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
["     Book value per share, excluding accumulated "]
["         other comprehensive income",3,{"$f":"+C$8","v":"19, 15Q1"},null,{"$f":"SUM(#REF!)-SUM('21'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!-'21'!#REF!","v":{"$error":"#REF!"}},null,"n/a",null,"n/a"]
[]
["updated Q4-07 &06 columns,  CP 12-14-07"]

{"sheet":"Ver Doc 2.2","index":36,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
["Name of Spreadsheet",null,"Stat Supp Working File - Pages 3(P&L) and 4(BS), 5(P&C Segment Income)"]
[null,null,"12(Life Segment Income) are used for SEC External Reporting"]
[]
["Drive & Directory Location",null,"Homcfaf1\\vol5\\Stat Supp\\Year\\Quarter"]
[]
["Date Created; Most Recent Change Date",null,"2001-04-20","2006-03-30"]
[]
["Version #",null,2.2000000000000002]
[]
["Spreadsheet Owner; Contact Info",null,"Sandra Aramony; saramony@allmerica.com"]
[]
["Total # of Users; # of Users outside Dept.",null,"8; none"]
[]
["Frequency of Change:"]
[null,"Formula/Calculations","quarterly"]
[null,"Input/Data Changes","quarterly"]
[]
["Purpose of model logic/formulas:",null,"Summarizes financial information from the general ledger and formats"]
[null,null,"it for the Statistical Supplement.  Also used to produce the Balance Sheet"]
[null,null,"P&L and other financial statement disclosures"]
[]
["Operating instructions for use/input:",null,"The pages are updated through an Essbase retrieve program.  Use \"Run\" tab to"]
[null,null,"select pages for which you want to retrieve information by entering \"y\" in the Run cell."]
[null,null,"After retrieve, compare information to Product Reports, Production Reports.  Enter"]
[null,null,"rounding in the shaded columns to the right of the page, if necessary."]
[null,null,"All manual input of information is entered on Input, Calc, or Footnote tabs.  There is no manual "]
[null,null,"input on actual stat supp pages."]
[null,null," Use Proof tabs to check balancing."]
[]
["Historical/Standing data",null,"Prior Quarter\\Prior Year"]
[]
["Complex Functions or Links",null,"Macros are used to retrieve information from the ledger and to print the entire document."]
[]
["Input Integrity Checks",null,"Same as output integrity checks below"]
[]
["Output Integrity Checks",null,"Reviewed by 2 individuals; beginning balances agreed to prior period analysis;"]
[null,null,"data agreed to the general ledger; manual recalculations performed on a test basis"]
[]
["Cell & Formula Protection",null,"None"]
[]
["Access Protection",null,"Access restricted to Afgaap on Homcfaf1\\Vol 5"]

{"sheet":"Ver Doc 2.1","index":37,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
["Name of Spreadsheet",null,"Stat Supp Working File - Pages 3(P&L) and 4(BS), 5(P&C Segment Income)"]
[null,null,"12(Life Segment Income) are used for SEC External Reporting"]
[]
["Drive & Directory Location",null,"Homcfaf1\\vol5\\Stat Supp\\Year\\Quarter"]
[]
["Date Created; Most Recent Change Date",null,"2001-04-20","2005-12-30"]
[]
["Version #",null,2.1]
[]
["Spreadsheet Owner; Contact Info",null,"Sandra Aramony; saramony@allmerica.com"]
[]
["Total # of Users; # of Users outside Dept.",null,"8; none"]
[]
["Frequency of Change:"]
[null,"Formula/Calculations","quarterly"]
[null,"Input/Data Changes","quarterly"]
[]
["Purpose of model logic/formulas:",null,"Summarizes financial information from the general ledger and formats"]
[null,null,"it for the Statistical Supplement.  Also used to produce the Balance Sheet"]
[null,null,"P&L and other financial statement disclosures"]
[]
["Operating instructions for use/input:",null,"The pages are updated through an Essbase retrieve program.  Use \"Run\" tab to"]
[null,null,"select pages for which you want to retrieve information by entering \"y\" in the Run cell."]
[null,null,"After retrieve, compare information to Product Reports, Production Reports.  Enter"]
[null,null,"rounding in the shaded columns to the right of the page, if necessary."]
[null,null,"All manual input of information is entered on Input, Calc, or Footnote tabs.  There is no manual "]
[null,null,"input on actual stat supp pages."]
[null,null," Use Proof tabs to check balancing."]
[]
["Historical/Standing data",null,"Prior Quarter\\Prior Year"]
[]
["Complex Functions or Links",null,"Macros are used to retrieve information from the ledger and to print the entire document."]
[]
["Input Integrity Checks",null,"Same as output integrity checks below"]
[]
["Output Integrity Checks",null,"Reviewed by 2 individuals; beginning balances agreed to prior period analysis;"]
[null,null,"data agreed to the general ledger; manual recalculations performed on a test basis"]
[]
["Cell & Formula Protection",null,"None"]
[]
["Access Protection",null,"Access restricted to Afgaap on Homcfaf1\\Vol 5"]

{"sheet":"Ver Doc 2.0","index":38,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
["Name of Spreadsheet",null,"Stat Supp Working File - Pages 3(P&L) and 4(BS), 5(P&C Segment Income)"]
[null,null,"12(Life Segment Income) are used for SEC External Reporting"]
[]
["Drive & Directory Location",null,"Homcfaf1\\vol5\\Stat Supp\\Year\\Quarter"]
[]
["Date Created; Most Recent Change Date",null,"2001-04-20","2005-01-19"]
[]
["Version #",null,2]
[]
["Spreadsheet Owner; Contact Info",null,"Sandra Aramony; saramony@allmerica.com"]
[]
["Total # of Users; # of Users outside Dept.",null,"8; none"]
[]
["Frequency of Change:"]
[null,"Formula/Calculations","quarterly"]
[null,"Input/Data Changes","quarterly"]
[]
["Purpose of model logic/formulas:",null,"Summarizes financial information from the general ledger and formats"]
[null,null,"it for the Statistical Supplement.  Also used to produce the Balance Sheet"]
[null,null,"P&L and other financial statement disclosures"]
[]
["Operating instructions for use/input:",null,"The pages are updated through an Essbase retrieve program.  Use \"Run\" tab to"]
[null,null,"select pages for which you want to retrieve information by entering \"y\" in the Run cell."]
[null,null,"After retrieve, compare information to Product Reports, Production Reports.  Enter"]
[null,null,"rounding in the shaded columns to the right of the page, if necessary."]
[null,null,"All manual input of information is entered on Input, Calc, or Footnote tabs.  There is no manual "]
[null,null,"input on actual stat supp pages."]
[null,null," Use Proof tabs to check balancing."]
[]
["Historical/Standing data",null,"Prior Quarter\\Prior Year"]
[]
["Complex Functions or Links",null,"Macros are used to retrieve information from the ledger and to print the entire document."]
[]
["Input Integrity Checks",null,"Same as output integrity checks below"]
[]
["Output Integrity Checks",null,"Reviewed by 2 individuals; beginning balances agreed to prior period analysis;"]
[null,null,"data agreed to the general ledger; manual recalculations performed on a test basis"]
[]
["Cell & Formula Protection",null,"None"]
[]
["Access Protection",null,"Access restricted to Afgaap on Homcfaf1\\Vol 5"]

{"sheet":"Ver Doc 1.0","index":39,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
["Name of Spreadsheet",null,"Stat Supp Working File - Pages 3(P&L) and 4(BS), 5(P&C Segment Income)"]
[null,null,"12(Life Segment Income) are used for SEC External Reporting"]
[]
["Drive & Directory Location",null,"Homcfaf1\\vol5\\Stat Supp\\Year\\Quarter"]
[]
["Date Created; Most Recent Change Date",null,"2001-04-20"," "]
[]
["Version #",null,1]
[]
["Spreadsheet Owner; Contact Info",null,"Sandra Aramony; saramony@allmerica.com"]
[]
["Total # of Users; # of Users outside Dept.",null,"8; none"]
[]
["Frequency of Change:"]
[null,"Formula/Calculations","quarterly"]
[null,"Input/Data Changes","quarterly"]
[]
["Purpose of model logic/formulas:",null,"Summarizes financial information from the general ledger and formats"]
[null,null,"it for the Statistical Supplement.  Also used to produce the Balance Sheet"]
[null,null,"P&L and other financial statement disclosures"]
[]
["Operating instructions for use/input:",null,"The pages are updated through an Essbase retrieve program with limited"]
[null,null,"manual manipulation of numbers."]
[]
["Historical/Standing data",null,"Prior Quarter\\Prior Year"]
[]
["Complex Functions or Links",null,"Macros are used to retrieve information from the ledger"]
[]
["Input Integrity Checks",null,"Same as output integrity checks below"]
[]
["Output Integrity Checks",null,"Reviewed by 2 individuals; beginning balances agreed to prior period analysis;"]
[null,null,"data agreed to the general ledger; manual recalculations performed on a test basis"]
[]
["Cell & Formula Protection",null,"None"]
[]
["Access Protection",null,"Access restricted to Afgaap on Homcfaf1\\Vol 5"]

{"sheet":"Ver Doc","index":40,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
["Name of Spreadsheet",null,"Stat Supp Working File - Pages 3(P&L) and 4(BS), 5(P&C Segment Income)"]
[null,null,"12(Life Segment Income) are used for SEC External Reporting"]
[]
["Drive & Directory Location",null,"Homcfaf1\\vol5\\Stat Supp\\Year\\Quarter"]
[]
["Date Created; Most Recent Change Date",null,"2001-04-20"]
[]
["Version #",null,"1.0"]
[]
["Spreadsheet Owner; Contact Info",null,"Sandra Aramony; saramony@allmerica.com"]
[]
["Total # of Users; # of Users outside Dept.",null,"8; none"]
[]
["Frequency of Change:"]
[null,"Formula/Calculations","quarterly"]
[null,"Input/Data Changes","quarterly"]
[]
["Purpose of model logic/formulas:",null,"Summarizes financial information from the general ledger and formats"]
[null,null,"it for the Statistical Supplement.  Also used to produce the Balance Sheet"]
[null,null,"P&L and other financial statement disclosures"]
[]
["Operating instructions for use/input:",null,"The pages are updated through an Essbase retrieve program with limited"]
[null,null,"manual manipulation of numbers."]
[]
["Historical/Standing data",null,"Prior Quarter\\Prior Year"]
[]
["Complex Functions or Links",null,"Macros are used to retrieve information from the ledger"]
[]
["Input Integrity Checks",null,"Same as output integrity checks below"]
[]
["Output Integrity Checks",null,"Reviewed by 2 individuals; beginning balances agreed to prior period analysis;"]
[null,null,"data agreed to the general ledger; manual recalculations performed on a test basis"]
[]
["Cell & Formula Protection",null,"None"]
[]
["Access Protection",null,"Access restricted to Afgaap on Homcfaf1\\Vol 5"]