{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["MENU","Introduction","Cover Page","Business Income Worksheet","Direct Material Cost","Extra Expense","Other Considerations","Notes"],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":3,"defined_names":9,"comments":4,"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":"MENU","index":0,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Business Income and Extra Expense Calculator"]
[]
[null,null,"Navigate throughout this workbook calculator tool by clicking on desired button below."]
[null,null,"Each module you enter has a button to bring you back to this main Menu screen or"]
[null,null,"to the main Business Income Worksheet."]
[null,null,"( In addition you can navigate within the workbook using the workbook tabs at the bottom of the screen. )"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Business Income/Extra Expense Calculator"]

{"sheet":"Introduction","index":1,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,1,41,10],[43,1,43,10],[10,16,10,19],[11,16,11,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Protecting Your Business"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business Continuity Risk Management"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"http://www.travelers.com/business/iwcm/RiskControl/emergencyprep/index.aspx"]

{"sheet":"Cover Page","index":2,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,2,38,4],[10,2,10,4],[13,2,13,4],[15,2,15,4],[18,2,18,4],[20,2,20,4],[22,3,22,4],[28,2,28,4],[30,2,30,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[68,2,68,4],[70,2,70,4],[72,3,72,4],[78,2,79,3],[40,3,40,4],[46,2,47,3],[60,2,60,4],[62,2,62,4],[66,2,66,4],[67,2,67,4]]}
[]
[]
[null,null,null,"Insured Name:"]
[null,null,null,"Brief Description of Operations:"]
[null,null,null,"Location(s) included in this Projection:"]
[]
[]
[null,null,"Number of Locations:"]
[]
[null,"Purpose:"]
[null,null,"This worksheet is a tool to help you estimate the amount of Business Income insurance you will need to cover your Business Income exposure in the event of a major covered loss.  If the coverage you are purchasing includes Extra Expense, this worksheet also helps you estimate the additional amount of insurance needed to cover your Extra Expense exposure in the event of a covered loss.  "]
[]
[null,"Which numbers to use:"]
[null,null,"The Business Income Worksheet requires you to provide figures for the most recent twelve month period of your business, and your estimate of the figures for the next twelve month period that commences with the effective date or anniversary date of your Business Income insurance.  You will need to adjust your estimates for reasonably predictable changes from the preceding time period.  Some items to consider may include: a new union wage agreement, the planned launch of a new product line, a change in the cost of items purchased for resale or a change in the amount of rent."]
[]
[null,null,"The Business Income Worksheet provides you an estimated limit. You will decide if your limit is on Agreed Value or on Coinsurance Percentage. Please select Yes below if you need coinsurance:"]
[null,null,"Yes","No"]
[]
[null,null,"Please note that if, during the policy year, you experience unexpected changes in income and/or expenses, you should recalculate the worksheet and submit these new figures, along with a request for any needed increase in your amount of business income insurance, to us.  If you do not, and you experience a loss, you might not have enough insurance to cover your loss.   "]
[]
[null,null,"Signature"]
[null,null," I certify that this is a true and correct report of values as required under this policy for the periods indicated and that the Agreed Value"]
[null,null," for the period of coverage is",0]
[null,null,"Insured's Signature:"]
[null,null,"Date:"]
[null,null,"Official Title:"]
[]
[]
[null,null,"See Notes section to better understand agreed value and coinsurance."]
[]
[null,null,"Please note that if, during the policy year, you experience unexpected changes in income and/or expenses, you should recalculate the worksheet and submit these new figures, along with a request for any needed increase in your amount of business income insurance, to us.  If you do not, and you experience a loss, you might not have enough insurance to cover your loss or your loss payment might be subject to a coinsurance penalty (as described below).   "]
[]
[null,"Coinsurance:"]
[]
[null,null,"The Business Income insurance you are purchasing is subject to a coinsurance condition, so it is important that you understand how it works.  A coinsurance condition requires you to carry a minimum amount of insurance, (your Business Income Limit.).  This minimum amount is an agreed-upon percentage of your business income exposure (the sum of your net income and all operating expenses) for the 12 months following the effective date or last anniversary date of your insurance policy.   If, at the time of loss, the amount of your Business Income limit is less than this amount, the amount we pay for the loss will be reduced.  Subject to your amount of insurance, the most we will pay will be the proportion of your covered loss determined by dividing the Business Income Limit by the minimum amount of insurance you were required to carry. "]
[null,null,"Please note that when you complete this worksheet, you are estimating future amounts.  Following a covered loss, we will perform a similar calculation but will have the benefit of the passage of time.  We will use figures that are the actual results of your business operations from the effective date or last anniversary date of your Business Income insurance to the date of the loss.  It is important to keep your figures up to date with unanticipated changes in your income and expenses during the policy year or you could be subject to the coinsurance penalty described above.  "]
[null,null,"Consult your agent or broker to help you determine an appropriate coinsurance percentage to be stated on your policy. The valid options for coinsurance percentages are in the dropdown menu below. "]
[]
[null,null,"Signature"]
[null,null," I certify that this is a true and correct report of values as required under this policy for the periods indicated and that the coinsurance"]
[null,null," percentage to be used is",null,null,0.25]
[null,null,"Insured's Signature:",null,null,0.3]
[null,null,"Date:",null,null,0.4]
[null,null,"Official Title:",null,null,0.5]
[null,null,null,null,null,0.6]
[null,null,null,null,null,0.7]
[null,null,"Yellow shaded cells are for user entry throughout the worksheets.",null,"Other colored cells indicate calculations are performed.",0.8]
[null,null,null,null,"Other colored cells indicate calculations are performed.",0.9]
[]
[]
[null,null,"For easiest use choose your highest Desktop screen resolution. For Microsoft Word this is 1280 X 1024 pixels"]

{"sheet":"Business Income Worksheet","index":3,"n_rows":137,"n_cols":34,"rows_kept":137,"cut":false,"hidden":false,"merged":[[15,2,17,2],[25,1,25,3],[26,1,26,3],[21,3,22,4],[21,2,22,2],[21,1,22,1],[21,5,22,5],[42,1,42,5],[41,1,41,5],[36,1,36,3],[39,1,39,3],[35,1,35,3],[27,1,27,3],[29,1,29,3],[30,1,30,3],[28,2,28,3],[31,1,31,5],[33,1,33,3],[34,1,34,3]]}
[]
[null,"Business Income:  Public Entity Operations such as towns, cities, counties and municipalities",null,null,null,{"$f":"IF('Cover Page'!E3=\"\",\"\",\"Insured: \"&'Cover Page'!E3)","v":""}]
[null,"Most Recent 12 Month Period Ending: (mm/dd/yyyy)",null,"Income and Expenses",null,"Estimated 12 Month Policy Period Beginning: (mm/dd/yyyy)"]
[null,"1/0/2000",null,null,null,"1/0/2000"]
[null,null,"A.","Gross Revenue (excludes revenue for Real Estate and Personal Property taxes )"]
[null,0,null,"1.  Golf Course fees including Golf Cart Rental/Pro Shop",null,0]
[null,0,null,"2.  Park and Recreation Fees",null,0]
[null,0,null,"3.  Fees, licenses, permits",null,0]
[null,0,null,"4. Municipal Owned or Operated utilities-sanitation-sewer and refuse, water, Landfill services",null,0]
[null,0,null,"5. Convention/civic center operations",null,0]
[null,0,null,"6. Health department (charge for immuizations",null,0]
[null,0,null,"7.  Rental property income",null,0]
[null,null,null,"8. Museum & entertainment admissions"]
[null,0,null,"9. Other Income: ",null,0]
[null,{"$f":"SUM(B6:B14)","v":0},null,"Equals: Gross Revenue (Sum 1-5)",null,{"$f":"SUM(F6:F14)","v":0}]
[null,0,"B","Less: Bad Debts ",null,0]
[null,0,null,"Less: Collection Expenses",null,0]
[null,0,null,"Less: Other",null,0]
[null,{"$f":"+B15-SUM(B16:B18)","v":0},"C.","EQUALS: Net Revenue (A minus B)",null,{"$f":"+F15-SUM(F16:F18)","v":0}]
[null,{"$f":"'Direct Material Cost'!B12","v":0},"D.","Less: Direct materials/ services sold",null,{"$f":"'Direct Material Cost'!F12","v":0}]
[null,{"$f":"B19-B20","v":0},"E.","Business Income Value (C - D)",null,{"$f":"F19-F20","v":0}]
[null,0,"F.","Add: Extra Expense Determination",null,{"$f":"'Extra Expense'!G20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"H. Period of Restoration (POR): Adjust for maximum time to rebuild, repair or replace property damaged by serious loss at an existing location or to move to a new permanent location and resume your normal operations. Select the number of months from the drop-down box to the right.",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.2,null,null,11,14,"if POR<12",{"$f":"IF(W27>12,IF(W27<25, \"A\", IF(W27<37, \"B\", IF(W27<49, \"C\", IF(W27<61, \"D\", \"SKIP\")))), \"One year or less\")","v":"One year or less"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.25,null,null,{"$f":"INDEX(S24:S44,W26)","v":12},{"$f":"INDEX(T26:T39,X26)","v":1},13]
[null,{"$f":"IF(W27>12,\"I. Business Seasonality section   --   does not get used since POR >12\",\"I. Business Seasonality section  --  use if POR is fewer than 12 months\")","v":"I. Business Seasonality section  --  use if POR is fewer than 12 months"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0.3,null,false,null,null,null,"K. Do you have Seasonal Variations in your operations? Enter YES or NO.","K. Based upon the number of months estimated to rebuild, SKIP THIS SEASONALITY SECTION."]
[null,null,"Do you have Seasonal Variations in your operations?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0.35,null,true,null,{"$f":"IF(W27>11,\"N/A\",IF(V29,\"N/A\",W27/12))","v":"N/A"},null,"K1. The period of restoration selected is less than one year.  For seasonality to apply, the % of sales that can occur in the Period of Restoration must exceed the % shown to the right."]
[null,"For seasonality adjustment to apply, the % of sales (as selected below) that can occur in the Period of Restoration must exceed the % shown to the right.",null,null,null,{"$f":"X29","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,7,0.4,{"$f":"IF(F29=\"yes\",1,0)","v":0},{"$f":"IF(V28,1,0)","v":0},{"$f":"\"ERROR! The % selected is too small - it must be greater than \"&ROUND(100*F30,0)&\"% (the minimum calculated above).\"","v":{"$error":"#VALUE!"}},null,"In Box K NO has been selected.  Skip this step, or select YES in Box K.","Seasonality has been selected. Select a % that represents sales that could occur in the Period of Restoration number of months.  The % selected must be greater than that in the above calculated box."]
[null,"Select a % that represents sales that could occur in the Period of Restoration months.  The % selected must be greater than that in the above calculated box.",null,null,null,{"$f":"IF(B32=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,8,0.45,null,{"$f":"IF(X27>F30,1,0)","v":0},null,null,null,"Box below computes loss amount for all periods"]
[null,{"$f":"IF(V29,\"\", IF(W27>11,\"\", IF(V30+V31=2, \"\", W30)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.5,null,null,"A",null,null,{"$f":"IF(W27>11,F21*W27/12, IF(V29,(+W27/12)*F21, +F21*X27))","v":0},null,null,"B",null,"C",null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.6,null,null,{"$f":"IF(#REF!>0,1,2)","v":{"$error":"#REF!"}},null,null,{"$f":"IF($Z26=\"A\",+((+$F26-12)/12)*#REF!*(1+#REF!),0)","v":0},null,null,{"$f":"IF($Z26=\"B\",+(((+$F26-24)/12)*#REF!*(1+#REF!)^2) +#REF!*(1+#REF!),0)","v":0},null,{"$f":"IF($Z26=\"C\",+((((+$F26-36)/12)*#REF!*(1+#REF!)^3) +#REF!*(1+#REF!)^2) +#REF!*(1+#REF!),0)","v":0},null,{"$f":"IF($Z26=\"D\",+(((((+$F26-48)/12)*#REF!*(1+#REF!)^4) +#REF!*(1+#REF!)^3)+#REF!*(1+#REF!)^2) +#REF!*(1+#REF!),0)","v":0}]
[null,"J. Minimum Amount of Business Income Insurance needed for your estimated Period of Restoration.  Based on F and modified by I.",null,null,null,{"$f":"IF(B32=\"\", +Z32, \"Input above required\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,12,0.65,null,null,{"$f":"IF(#REF!=H62,1,3)","v":{"$error":"#REF!"}},null,"Input a growth factor for year two.",null,null,null,"Input a growth factor for years two and three.",null,"Input a growth factor for years two through four.",null,"Input a growth factor for years two through five."]
[null,"K1. Extended Business Income: Select number of months you anticipate reduced income after resuming normal operations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0.7,null,{"$f":"IF(#REF!<#REF!,1,0)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(Z26 = \"A\", 1, IF(Z26 = \"B\", 2, IF(Z26= \"C\", 3, IF(Z26= \"D\", 4, 0))))","v":0}]
[null,"K2. Additional amount of estimated reduced income for the full period of months indicated in K1 above.",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,14,0.75,null,{"$f":"IF(#REF!<#REF!,1,0)","v":{"$error":"#REF!"}},"Warning: You have entered a negative growth factor.  This means you expect that sales will decrease after the next 12 months.  Do not estimate as if there was a loss, assume no loss occurs.",null,"Computed amount appears here for months 13 through the number selected in Box J.",null,null,null,"Computed amount appears here for months 13 through the number selected in Box J.",null,"Computed amount appears here for months 13 through the number selected in Box J.",null,"Computed amount appears here for months 13 through the number selected in Box J."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0.8,null,{"$f":"IF(F26>12,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0.85,null,null,"You need to enter a % into Box K4 to compute the projected amount for the 2nd twelve month period."]
[null,"L.  Other Considerations",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,19,1]
[null,"M. YOUR ESTIMATED AMOUNT OF NEEDED BUSINESS INCOME & EXTRA EXPENSE (F + J + K + L)",null,null,null,{"$f":"IF(B32=\"\", F36+F34+F22+F39, \"Seasonality error\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,null,"If \"Ordinary Payroll\" is limited to _____ 90 days or _____ 180 days, ADD BACK the largest payroll amount associated with the # of days checked above (consider seasonal peaks in your payroll)",null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"por = 12",null,null,{"$f":"IF(F29=\"YES\",10,0)","v":0},{"$f":"IF(F26<12,1,0)","v":1},{"$f":"IF(F26=24, 0, IF(F26>12,2,0))","v":0},{"$f":"IF(F26=12,3,0)","v":0},{"$f":"IF(F26=24,4,0)","v":0},{"$f":"SUM(AC40:AG40)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,null,null,null,null,{"$f":"+#REF!*(F26/12)*F31/(F26/12)","v":{"$error":"#REF!"}},"por<12","seasonality = yes",null,{"$f":"10+1","v":11}]
[null,"Signature is Required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,"   I certify that this is a true and correct report of values as required under this policy for the periods indicated and that the Agreed Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,null,null,"If there is seasonality then if POR< 12, e53/e49/12         or if POR >12 e53/e52/12 ",null,{"$f":"+(#REF!*(F26/12))","v":{"$error":"#REF!"}},"por<12","seasonality = NO",null,{"$f":"0+1","v":1}]
[null,"   for the period of coverage is",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,null,null,"POR<12"]
[null,"Insured's Signature:",null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,null,"POR>12",null,{"$f":"IF(#REF!<200, \"Error, input needed in K4\",#REF!+#REF!*( F30/12)*F31/(F30/12))","v":{"$error":"#REF!"}},"POR>12","seasonality = yes",null,{"$f":"10+2","v":12}]
[null,"Official Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,null,null,null,null,null,{"$f":"IF(#REF!<200, \"Error, input needed in K4\",#REF!+#REF!*((+ F26-12)/12))","v":{"$error":"#REF!"}},"POR>12","seasonality = NO",null,{"$f":"0+2","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,null,null,null,null,{"$f":"IF(#REF!<200, \"Error, input needed in K4\",#REF! +#REF!)","v":{"$error":"#REF!"}},"por=24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,null,null,null,null,null,null,null,{"$f":"+F30","v":"N/A"},{"$f":"+F26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,null,12]
[null,null,null,null,null,null,null,"If POR > 12, Enter a %",null,null,null,null,null,null,null,null,null,null,42,null,13]
[null,null,null,null,null,null,null,-0.7,null,null,null,null,null,null,null,null,null,null,43,null,14]
[null,null,null,null,null,null,null,-0.65,null,null,null,null,null,null,null,null,null,null,44,null,15]
[null,null,null,null,null,null,null,-0.6,null,null,null,null,null,null,null,null,null,null,45,null,16]
[null,null,null,null,null,null,null,-0.55000000000000004,null,null,null,null,null,null,null,null,null,null,46,null,17]
[null,null,null,null,null,null,null,-0.5,null,null,null,null,null,null,null,null,null,null,47,null,18]
[null,null,null,null,null,null,null,-0.45,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,-0.4,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,-0.35,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,-0.3,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,-0.25,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,-0.2,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,-0.18,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,-0.16,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,-0.14000000000000001,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,-0.12,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,-0.11,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,-0.1,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,-0.09,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,-0.08]
[null,null,null,null,null,null,null,-7.0000000000000007E-2]
[null,null,null,null,null,null,null,-0.06]
[null,null,null,null,null,null,null,-0.05]
[null,null,null,null,null,null,null,-0.04]
[null,null,null,null,null,null,null,-0.03]
[null,null,null,null,null,null,null,-0.02]
[null,null,null,null,null,null,null,-0.01]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"+H89+0.01","v":0.01}]
[null,null,null,null,null,null,null,0.02]
[null,null,null,null,null,null,null,0.03]
[null,null,null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,0.05]
[null,null,null,null,null,null,null,6.0000000000000005E-2]
[null,null,null,null,null,null,null,7.0000000000000007E-2]
[null,null,null,null,null,null,null,0.08]
[null,null,null,null,null,null,null,0.09]
[null,null,null,null,null,null,null,9.9999999999999992E-2]
[null,null,null,null,null,null,null,0.10999999999999999]
[null,null,null,null,null,null,null,0.11999999999999998]
[null,null,null,null,null,null,null,0.12999999999999998]
[null,null,null,null,null,null,null,0.13999999999999999]
[null,null,null,null,null,null,null,0.15]
[null,null,null,null,null,null,null,0.16]
[null,null,null,null,null,null,null,0.17]
[null,null,null,null,null,null,null,0.18000000000000002]
[null,null,null,null,null,null,null,0.19000000000000003]
[null,null,null,null,null,null,null,0.20000000000000004]
[null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,0.45]
[null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,0.55000000000000004]
[null,null,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,1.25]
[null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,1.75]
[null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,2.25]
[null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,2.75]
[null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,3.25]
[null,null,null,null,null,null,null,3.5]
[null,null,null,null,null,null,null,3.75]
[null,null,null,null,null,null,null,4]

{"sheet":"Direct Material Cost","index":4,"n_rows":13,"n_cols":25,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,12,1],[11,5,12,5],[2,1,2,5]]}
[]
[]
[null,"WORKSHEET: Direct Material Cost: does not  include Labor and Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"or left it all in.  The number itself is year one BI value, but adjusted"]
[]
[null,null,null,"This is NOT the GAAP figure.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If no payroll limitation, it is year one BI value"]
[null,null,null,"This is Direct Material Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if payroll is limited, it is year one BI value with NO ordinary payroll"]
[]
[null,"Most Recent 12 Month Period Ending:",null,null,null,"Estimated 12 Month Policy Period Beginning:"]
[null,{"$f":"'Business Income Worksheet'!B4","v":"1/0/2000"},null,null,null,{"$f":"'Business Income Worksheet'!F4","v":"1/0/2000"}]
[null,0,"CW1.","Material/Services sold- not mfg by you",null,0]
[null,0,"CW2.","Materials directly consumed in production",null,0]
[null,{"$f":"SUM(B10:B11)","v":0},"CW3.","EQUALS: TOTAL COST OF GOODS SOLD   THERE IS NO LABOR OR OVERHEAD ALLOWED IN THIS FIGURE",null,{"$f":"SUM(F10:F11)","v":0}]
[null,null,null,"(CW1 + CW2)"]

{"sheet":"Extra Expense","index":5,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,1,9,6]]}
[]
[null,"ADDITIONAL EXPENSES AT TEMPORARY PREMISES","1st Month","2nd Month","3rd Month","Additional Months","TOTAL"]
[null,"Expense of Moving Equipment to and from Former Premises",0,0,0,0,{"$f":"SUM(C3:F3)","v":0}]
[null,"Insurance Expenses for Temporary Location",0,0,0,0,{"$f":"SUM(C4:F4)","v":0}]
[null,"Rent or Leasing of Equipment and Machinery",0,0,0,0,0]
[null,"Janitorial and Security",0,0,0,0,0]
[null,"Hot Site Expenses",0,0,0,0,0]
[null,"Light, Power, Heat",0,0,0,0,0]
[null,"Rent (Housing and Educational Facilities)",0,0,0,0,0]
[null,"OTHER ADDITIONAL EXPENSES"]
[null,"Bonus for Quick Services",0,0,0,0,0]
[null,"Legal and Other Professional Fees",0,0,0,0,0]
[null,"Overtime Labor of Employees or Additional Staff or Temporary Labor",0,0,0,0,0]
[null,"Public Service Announcements / Advertising / Postage Expense",0,0,0,0,0]
[null,"Outsource of Services",0,0,0,0,0]
[null,"Purchase of Goods and Materials",0,0,0,0,0]
[null,"Telephone/Data Lines",0,0,0,0,0]
[null,"Travel Expenses",0,0,0,0,0]
[null,"Other  ______________________________",0,0,0,0,0]
[null,"TOTAL EXTRA EXPENSES TO BE INSURED",{"$f":"SUM(C3:C19)","v":0},{"$f":"SUM(D3:D19)","v":0},{"$f":"SUM(E3:E19)","v":0},{"$f":"SUM(F3:F19)","v":0},{"$f":"SUM(G3:G19)","v":0}]

{"sheet":"Other Considerations","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[]
[]
[null,"Other Considerations WORKSHEET (Hover above each Category to get help on issues to consider)"]
[null,"   Combined Limit"]
[null,"   Interdependency"]
[null,"   Foreign Exposure"]
[null,"   Building Ordinance or Laws"]
[null,"   Demand Surge"]
[null,"   Extended Period of Indemnity"]
[null,"   Loss of Utility services"]
[null,"   Dependent Properties"]
[null,"   Research & Development"]

{"sheet":"Notes","index":7,"n_rows":56,"n_cols":23,"rows_kept":56,"cut":false,"hidden":true,"merged":[[30,1,30,12],[34,1,34,12],[1,1,1,5],[3,1,3,11],[4,1,4,12],[28,1,28,12],[35,11,35,12],[46,11,46,12],[50,11,50,12],[53,11,53,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[43,11,43,12]]}
[]
[null,"NOTES"]
[]
[null,"COINSURANCE - INSURANCE TO VALUE REQUIREMENT"]
[null,"In the event of loss during the policy period, we will determine the actual business income exposure from policy year inception to the date of loss.  To this actual amount we will add an appropriately projected amount of income exposure for the remainder "]
[]
[null,null,"Example:",null,"Policy Period = 01/01/20_ _  to  01/01/20_ _",null,null,null,null,"Date of Loss = 08/01/20_ _"]
[null,null,null,null,"Policy Limit   = $3,000,000",null,null,null,null,"Coinsurance  = 50%"]
[null,null,null,null,"Loss             = $1,000,000"]
[]
[null,null,null,null,"Actual Business Income from"]
[null,null,null,null,"01/01/_ _ to 07/31/20_ _           =",null,null,null,5000000]
[]
[null,null,"       Projected Business income from 08/01/_ _ to"]
[null,null,null,null,null,"      01/01/20_ _      =",null,"+ ",3000000]
[null,null,null,null,"More Current Annual Amount "]
[null,null,null,null,"         of Needed Insurance  =",null,null,null,8000000]
[]
[null,null,null,null,null,null,"$8,000,000 x 50% coinsurance = ",null,4000000]
[]
[null,null,"Policy Limit of $3,000,000 < $4,000,000 required"]
[null,null,"                 Therefore, $3,000,000 / $4,000,000  =",null,null,null,null,null,"    .75 factor"]
[]
[null,null,null,null,"          .75 x $1,000,000 loss   =",null,null,null,"$750,000 payable"]
[]
[null,null,null,null,"      Coinsurance Penalty     =",null,null,"        $250,000 of loss not payable"]
[]
[null,"AGREED VALUE"]
[null,"This provision suspends the Coinsurance provision, but does not eliminate it.  In order for Agreed Value to be in effect, a signed business income worksheet must be submitted to and accepted by us prior to a loss."]
[]
[null,"A new Agreed Value worksheet must be submitted (1) no later than two weeks prior to the end of each twelve-month policy period, or (2) if you change the limit of Business Income insurance mid-term.  Failure to submit a signed current worksheet will automatically reinstate the Coinsurance provision for the period going forward."]
[]
[null,"OTHER COVERAGE OPTIONS"]
[]
[null,"These exposures are Not Covered under standard industry Business Income Coverage forms.  Consult with your agent or broker if you answer \"YES\" to any of the following."]
[null,null,null,null,null,null,null,null,null,null,null,"respond YES or NO"]
[null,1,"Dependent Properties - If any of the below types of properties you depend on suffered loss or"]
[null,null,"damage from a covered cause of loss, would you incur a loss of income or extra expense as a result"]
[null,null,"of their loss?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
[null,null,"a.     Key supplier(s) could not produce goods or services you depend on.",null,null,null,null,null,null,null,null,"NO",null,null,null,null,null,null,null,null,null,null,"NO"]
[null,null,"b.     Key customer(s) could not receive your goods or services.",null,null,null,null,null,null,null,null,"NO"]
[null,null,"c.     Properties which attract customers, e.g. stadiums, anchor stores.",null,null,null,null,null,null,null,null,"NO"]
[]
[null,2,"Ordinance or Law - Would complying with building ordinances or laws delay your repair or rebuilding?",null,null,null,null,null,null,null,null,"NO"]
[]
[null,3,"Contract Penalties - Do you have any contracts with customers which contain penalty clauses if you"]
[null,null,"cannot supply them with goods or services?",null,null,null,null,null,null,null,null,"NO"]
[]
[null,4,"Loss to Personal Property Away From Your Premises - Would you lose significant income or incur"]
[null,null,"significant extra expenses if your business personal property or property of others was lost or"]
[null,null,"damaged while away from your premises? An example might be sales at an exhibit or trade show.",null,null,null,null,null,null,null,null,"NO"]
[]
[null,5,"Leasehold Interest - If you are a tenant, do you have a favorable long term lease compared to current"]
[null,null,"market rental rates?",null,null,null,null,null,null,null,null,"NO"]
[]
[null,null," Business income exposure means Net income before income taxes plus all operating expenses."]