{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MENU","Introduction","Cover Page","Business Income Worksheet","Payroll Limitation Worksheet","Cost of Goods Sold","Extra Expense","Coinsurance & Agreed Value","Notes"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":0,"defined_names":10,"comments":5,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cover Page","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,2,25,3],[18,2,18,4],[19,2,19,4],[10,2,10,4],[13,2,13,4],[14,2,14,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,"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 if the Agreed Value Coverage Option is not in effect at the time of the loss, 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,"Yellow shaded cells are for user entry throughout the worksheets.",null,"Other colored cells indicate calculations are performed."]
[null,null,null,null,"Other colored cells indicate calculations are performed."]
[]
[]
[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":138,"n_cols":34,"rows_kept":138,"cut":false,"hidden":false,"merged":[[31,22,31,26],[22,1,22,3],[20,1,20,3],[21,1,21,3],[24,1,24,3],[25,1,25,3],[23,2,23,3],[31,1,31,3],[32,1,32,3],[34,1,34,3],[26,1,26,5],[29,1,29,3],[30,1,30,3]]}
[]
[null,"Business Income:  Hospitals, Clinics and Health Care Centers",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,0,"A.","Inpatient Services",null,0]
[null,0,"B.","Outpatient Services",null,0]
[null,0,"C.","Emergency Room Services",null,0]
[null,0,"D.","Ambulance Charges",null,0]
[null,0,"E.","Educational Programs (tuition, fees, related income)",null,0]
[null,0,"F.","Commissions or rents from leased departments, operations or concessionaires",null,0]
[null,0,"G.","Cafeteria, Gift Shop, Parking, Pharmacy (any operated by you)",null,0]
[null,0,"H.","Grants and Research Contracts",null,0]
[null,0,"I.","Other Income (excluding donations, fund raising and investment income)",null,0]
[null,{"$f":"SUM(B5:B13)","v":0},"J.","Total Annual Gross Sales (A thru I)",null,{"$f":"SUM(F5:F13)","v":0}]
[null,0,"K.","Less: Contractual adjustments, bad debts, collection expenses and free services",null,0]
[null,{"$f":"'Cost of Goods Sold'!B13","v":0},"L.","Less: Total Cost of Goods Sold including drugs, food, chemicals, linens, gases, film, cafeteria, cleaning supplies, etc.",null,{"$f":"'Cost of Goods Sold'!F13","v":0}]
[null,0,"M.","Less: Services purchased from outsiders (not employees) that do not continue under contract after a loss.  This includes laboratory, food and laundry services, building maintenance services and fees paid to doctors and technicians (not employed under contract) on a per-diem basis (non-salaried consultants).  Costs that contine are NOT deducted.",null,0]
[null,{"$f":"'Payroll Limitation Worksheet'!F33","v":0},"N.","Less: All \"Ordinary Payroll\" Expenses if they are to be excluded or limited. Payroll Limitation worksheet item PL5",null,{"$f":"'Payroll Limitation Worksheet'!F33","v":0}]
[null,{"$f":"B14-B15-B16-B17-B18","v":0},"O.","Business Income Exposure for 12 Mos (J-K-L-M-N)",null,{"$f":"F14-F15-F16-F17-F18","v":0}]
[]
[null,"P. 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 6 to 24.",null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In cases where the POR is for > 12 months, then if Box H > 0, then use +E12 - E13 - E14 - E53  If Box H = 0 then +E12 -E13 -E14",null,{"$f":"IF(F28>0,+F14-F16-F17-'Payroll Limitation Worksheet'!F33,+F14-F16-F17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"the number in X19 is used below.  We have either taken all ordinary payroll out of this number"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.2,null,null,7,17,"if POR<12",{"$f":"IF(W26>12,IF(W26<25, \"A\", IF(W26<37, \"B\", IF(W26<49, \"C\", IF(W26<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(S28:S46,W25)","v":12},{"$f":"INDEX(T25:T41,X25)","v":1},13]
[null,{"$f":"IF(V28,\"\", IF(W26>11,\"\", IF(V29+V30=2, \"\", W29)))","v":""},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,{"$f":"F28","v":0},"Q.","You may limit coverage for \"Ordinary Payroll\".  Use the Payroll Worksheet to limit or exclude \"Ordinary Payroll\".  If you are not limiting nor excluding \"Ordinary Payroll\", Box N should remain at $0.",null,{"$f":"+'Payroll Limitation Worksheet'!F35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,6,0.35,null,true,null,{"$f":"IF(W26>11,\"N/A\",IF(V28,\"N/A\",W26/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.4,{"$f":"IF(F25=\"yes\",1,0)","v":0},{"$f":"IF(V27,1,0)","v":0},"ERROR ! The % selected is too small - modify to make it > than minimum pct above.",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,"R. Minimum Amount of Business Income Insurance needed for your estimated Period of Restoration.  Based on O. and pro rata portion up/down from that based on POR.",null,null,null,{"$f":"Z31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,8,0.45,null,{"$f":"IF(X26>#REF!,1,0)","v":{"$error":"#REF!"}},null,null,null,"Box below computes loss amount for all periods"]
[null,"S1. 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,9,0.5,null,null,"A",null,null,{"$f":"IF(W26>11,F19*W26/12, IF(V28,(+W26/12)*F19, +F19*X26))+F28","v":0},null,null,"B",null,"C",null,"D"]
[null,"S2. Additional amount of estimated reduced income for the full period of months indicated in S1 above.",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,10,0.55000000000000004,null,null,"Your Period of Restoration is greater than 12 months, you MUST compute the business income exposure for the second 12 months that follows the effective date or anniversary date of this policy.  This amount is computed based upon what is in Box I above.  You will select a % from the drop down list and that % will be used to project a figure for the second 12 months from the amount currently in Box I.  Input your estimated growth, (+/-), for the second 12 months.",null,null,null,null,null,"Your Period of Restoration is greater than 24 months, you MUST compute the business income exposure for years two and three that follow the effective date or anniversary date of this policy.  This amount is computed based upon what is in Box I above.  You will select a % from the drop down list and that % will be used to project a figure for years two and three from the amount currently in Box I.  Input your estimated growth, (+/-), for years two & three.",null,"Your Period of Restoration is greater than 36 months, you MUST compute the business income exposure for years two three and four that follow the effective date or anniversary date of this policy.  This amount is computed based upon what is in Box I above.  You will select a % from the drop down list and that % will be used to project a figure for years two three and four from the amount currently in Box I.  Input your estimated growth, (+/-), for years two thru four.",null,"Your Period of Restoration is greater than 48 months, you MUST compute the business income exposure for years two through five that follow the effective date or anniversary date of this policy.  This amount is computed based upon what is in Box I above.  You will select a % from the drop down list and that % will be used to project a figure for years two through five from the amount currently in Box I.  Input your estimated growth, (+/-), for years two thru five."]
[null,"T. Are Extra Expenses to be insured AND included in your Business Income Limit of Insurance? If YES, make sure Extra Expense worksheet is completed; if NO, leave $0.",null,null,null,{"$f":"'Extra Expense'!G21","v":0},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($Z25=\"A\",+((+$F21-12)/12)*$Y22*(1+#REF!),0)","v":0},null,null,{"$f":"IF($Z25=\"B\",+(((+$F21-24)/12)*$Y22*(1+#REF!)^2) +$Y22*(1+#REF!),0)","v":0},null,{"$f":"IF($Z25=\"C\",+((((+$F21-36)/12)*$Y22*(1+#REF!)^3) +$Y22*(1+#REF!)^2) +$Y22*(1+#REF!),0)","v":0},null,{"$f":"IF($Z25=\"D\",+(((((+$F21-48)/12)*$Y22*(1+#REF!)^4) +$Y22*(1+#REF!)^3)+$Y22*(1+#REF!)^2) +$Y22*(1+#REF!),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0.65,null,null,{"$f":"IF(#REF!=H63,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,"U. YOUR ESTIMATED AMOUNT OF NEEDED BUSINESS INCOME & EXTRA EXPENSE ( R + S + T )",null,null,null,{"$f":"IF(B27=\"\", F33+F32+F30, \"Seasonality error\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,13,0.7,null,{"$f":"IF(#REF!<F19,1,0)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(Z25 = \"A\", 1, IF(Z25 = \"B\", 2, IF(Z25= \"C\", 3, IF(Z25= \"D\", 4, 0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0.75,null,{"$f":"IF(#REF!<F19,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(F21>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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0.9,null,null,null,null,null,null,null,null,null,null,null,"if e49=12","if e49=24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0.95,null,null,null,null,null,null,null,null,"if seasonality = yes  below will be 10","if POR<12 below is 1","if POR>12 below is 2","if POR=12 below is 3","if POR=24 below is 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,1]
[null,null,null,null,null,null,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":"+F19","v":0},"por = 12",null,null,{"$f":"IF(F25=\"YES\",10,0)","v":0},{"$f":"IF(F21<12,1,0)","v":1},{"$f":"IF(F21=24, 0, IF(F21>12,2,0))","v":0},{"$f":"IF(F21=12,3,0)","v":0},{"$f":"IF(F21=24,4,0)","v":0},{"$f":"SUM(AC42:AG42)","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":"+F19*(F21/12)*F26/(F21/12)","v":{"$error":"#DIV/0!"}},"por<12","seasonality = yes",null,{"$f":"10+1","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,null,null,"If there is seasonality then if POR< 12, e53/e49/12         or if POR >12 e53/e52/12 ",null,{"$f":"+(F19*(F21/12))","v":0},"por<12","seasonality = NO",null,{"$f":"0+1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,null,null,"POR<12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,null,null,"POR>12",null,{"$f":"IF(#REF!<200, \"Error, input needed in K4\", F19+#REF!*(#REF!/12)*F26/(#REF!/12))","v":{"$error":"#REF!"}},"POR>12","seasonality = yes",null,{"$f":"10+2","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,null,null,null,{"$f":"IF(#REF!<200, \"Error, input needed in K4\", F19+#REF!*((+F21-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,26,null,null,null,null,null,{"$f":"IF(#REF!<200, \"Error, input needed in K4\", F19+#REF!)","v":{"$error":"#REF!"}},"por=24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+F21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,12]
[null,null,null,null,null,null,null,"If POR > 12, Enter a %",null,null,null,null,null,null,null,null,null,null,41,null,13]
[null,null,null,null,null,null,null,-0.7,null,null,null,null,null,null,null,null,null,null,42,null,14]
[null,null,null,null,null,null,null,-0.65,null,null,null,null,null,null,null,null,null,null,43,null,15]
[null,null,null,null,null,null,null,-0.6,null,null,null,null,null,null,null,null,null,null,44,null,16]
[null,null,null,null,null,null,null,-0.55000000000000004,null,null,null,null,null,null,null,null,null,null,45,null,17]
[null,null,null,null,null,null,null,-0.5,null,null,null,null,null,null,null,null,null,null,46,null,18]
[null,null,null,null,null,null,null,-0.45,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,-0.4,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,-0.35,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,-0.3,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,-0.25,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,-0.2,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,-0.18,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,-0.16,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,-0.14000000000000001,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,-0.12,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,-0.11,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,-0.1,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,-0.09,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,-0.08,null,null,null,null,null,null,null,null,null,null,60]
[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":"+H90+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":"Payroll Limitation Worksheet","index":4,"n_rows":35,"n_cols":28,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,1,6,5],[4,1,4,5],[1,1,3,5],[22,1,22,5],[26,2,29,2],[20,1,20,5],[9,1,9,5],[26,3,29,3],[24,1,33,1],[26,5,29,5],[19,1,19,5],[21,1,21,5]]}
[]
[null,"In the event of a catastrophic loss the business may not be operating at all or at full capacity.  Will you continue to pay your \"Ordinary Payroll\" while the business is closed?  If you plan to continue to pay all of your workers, and you want this included in your insurance coverage, then you do not want to limit \"Ordinary Payroll\".  Do not fill in the Payroll Worksheet below."]
[]
[]
[null,"By not filling in the worksheet below, you have chosen to insure for all payroll. "]
[]
[null,"Ordinary payroll expenses include payroll, employee benefits if directly related to payroll, FICA and Medicare Payments, union dues, and Workers Compensation premiums. Some points to consider in deciding whether to exclude or include \"Ordinary Payroll\" (i.e. other than officers, executives, dept. mgrs and employees under contract): Would you lay off all your other employees in the event of a short interruption? Could you get them back when you re-open for business or would they have gone elsewhere? Do you have skilled or specialized labor?"]
[]
[null,null,null,"\"ORDINARY\" PAYROLL LIMITATION WORKSHEET"]
[null,"Use this payroll worksheet ONLY IF you are limiting or excluding \"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,"PW1.","Enter: 100% of all salaries and wages",null,0]
[null,0,"PW2.","Add: All employment taxes",null,0]
[null,0,"PW3.","Add: Workers Compensation Premiums",null,0]
[null,0,"PW4.","Add: Fringe benefits (see comment)",null,0]
[null,0,"PW5.","Add: Other _____________________",null,0]
[null,{"$f":"SUM(B13:B17)","v":0},"PW6.","EQUALS: TOTAL PAYROLL EXPOSURE",null,{"$f":"SUM(F13:F17)","v":0}]
[]
[]
[null,"You may limit \"Ordinary Payroll\", but not payroll for executives, officers, managers, contractual employees and employees necessary to the survival of the business after a catastrophic loss.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"Payroll limitation portion of the Payroll Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[null,null,null,"Do you choose to limit or exclude \"Ordinary Payroll\"?"]
[null,"The program assumes the limitation in the prospective policy period pertains to the prior period as well.","PL1.","Necessary salary",null,0]
[null,null,"PL2.","Ordinary salary  ( PW1 - PL1 )",null,{"$f":"+F13-F25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"INDEX(AB31:AB33,Y26)","v":0}]
[null,null,"PL3","If you limit \"Ordinary Payroll\", then you are choosing to have insurance coverage for these workers for only 180 days, 90 days, or no coverage.  Select the appropriate period of days."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select the coverage you wish to have:"]
[null,null,"PL4.","You will have this % of \"Ordinary Payroll\"",null,{"$f":"+Z26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"180 Days = 6 months coverage",null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 Days = 3 months coverage",null,null,0.25]
[null,null,"PL5.","This is your total exposure for \"Ordinary Payroll\" including taxes and benefits.",null,{"$f":"IF(F13=0,0,ROUND((1+(+F14+F15+F16+F17)/F13)*F26, 0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 Days = all \"Ordinary Payroll\" is excluded",null,null,0]
[null,null,"PL6.","This is the amount of payroll you selected to not cover under this policy.",null,{"$f":"IF(V22, 0,IF(F13=0,0, ROUND((1+(+F14+F15+F16+F17)/F13)*F26*(1-(F31)), 0)))","v":0}]
[null,null,"PL7.","This is the amount of payroll you selected to cover under this policy.  It will go into Box Q of the Business Income worksheet and increases the Business Income Exposure, Box U.",null,{"$f":"IF(V22,0,+F33-F34)","v":0}]

{"sheet":"Cost of Goods Sold","index":5,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,5,13,5]]}
[]
[]
[null,null,null,"COST OF GOODS SOLD WORKSHEET",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,"Do NOT include labor or overhead.",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.","Beginning Inventory",null,0]
[null,0,"CW2.","ADD: Net Cost of merchandise and tangible supplies purchased during the year (including transportation charges).",null,0]
[null,0,"CW3.","DEDUCT: Ending inventory",null,0]
[null,{"$f":"B10+B11-B12","v":0},"CW4.","EQUALS: TOTAL COST OF GOODS SOLD",null,{"$f":"F10+F11-F12","v":0}]
[null,null,null,"( CW1 + CW2 - CW3 )"]

{"sheet":"Extra Expense","index":6,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,1,7,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",0,0,0,0,{"$f":"SUM(C4:F4)","v":0}]
[null,"Labor, Altering and Equipping",0,0,0,0,0]
[null,"Light, Power, Heat",0,0,0,0,0]
[null,"Rent",0,0,0,0,0]
[null,"OTHER ADDITIONAL EXPENSES"]
[null,"Bonus for Quick Services",0,0,0,0,0]
[null,"Janitorial and Security",0,0,0,0,0]
[null,"Laboratory Costs",0,0,0,0,{"$f":"SUM(C11:F11)","v":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,{"$f":"SUM(C14:F14)","v":0}]
[null,"Purchase of Goods and Materials",0,0,0,0,0]
[null,"Rent or Leasing of Equipment and Machinery",0,0,0,0,0]
[null,"Telephone/Data Lines",0,0,0,0,0]
[null,"Services Purchased from Others",0,0,0,0,{"$f":"SUM(C18:F18)","v":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:C20)","v":0},{"$f":"SUM(D3:D20)","v":0},{"$f":"SUM(E3:E20)","v":0},{"$f":"SUM(F3:F20)","v":0},{"$f":"SUM(G3:G20)","v":0}]

{"sheet":"Coinsurance & Agreed Value","index":7,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[19,1,19,9],[21,1,21,9],[3,1,3,9],[4,1,4,9],[7,1,7,9]]}
[]
[]
[]
[null,"COINSURANCE: Coinsurance is a REQUIRED policy condition for Business Income Insurance.  Agreed Value is an optional coverage that suspends, but does NOT eliminate the Coinsurance provision.  SEE NOTES TO BETTER UNDERSTAND COINSURANCE AND AGREED VALUE."]
[null,"Consult your agent or broker to help you determine an appropriate Coinsurance percentage to be stated on your policy.  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.5]
[null,"Your valid options for Coinsurance percentages are shown below.  When selecting the most appropriate option 'round down'.  Enter your selected percentage in the appropriate box below :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.9]
[null,"If Agreed Value does NOT apply:        25%     30%      40%    50%      60%     70%       80%     90%     100%     125%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,1]
[null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,0.8,1.25]
[null,"DO NOT REDUCE ANY NUMBERS IN THIS WORKSHEET BY THE COINSURANCE PERCENTAGE.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"ERROR!! ONLY ONE OF THE TWO BOXES SHOULD HAVE \"N/A\" SELECTED"]
[null,{"$f":"IF(J21=\"N/A\", IF(J13=\"N/A\",X15,\"  \"),IF(J13<>\"N/A\",X16,\"  \" ))","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.25,null,"ERROR!!  ONE OF THE TWO BOXES MUST HAVE \"N/A\" SELECTED"]
[]
[]
[]
[null,"USE THIS BOX ONLY IF         AGREED VALUE COVERAGE OPTION APPLIES - Signature is Required"]
[null,"                If Agreed Value applies:     50%     60%     70%     80%     90%     100%     125%",null,null,null,null,null,null,null,"N/A"]
[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,"   for the period of coverage is",null,0,"            The coinsurance percentage to be used is",null,null,null,{"$f":"J21","v":"N/A"},"Minimum is 50%"]
[null,"Insured's Signature:",null,null,null,"Official Title:"]
[]
[null,"Date: "]
[]
[]
[null,{"$f":"IF(D23>0, IF(J21=0, X31, \"  \"), \"  \")","v":"  "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CORRECT THE ERROR ABOVE, YOU CAN NOT SUBMIT THIS PAGE THIS WAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YOU MUST CHOOSE A % ON LINE 9 ! AGREED VALUE CANNOT BE APPLIED FOR WITHOUT THAT %"]

{"sheet":"Notes","index":8,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"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],[45,11,45,12],[48,11,48,12],[51,11,51,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 of the 12 month policy period.  (In effect, the insurer will calculate Box O of this worksheet, (if ordinary payroll is limited, that will be adjusted for), but will have the benefit of some actual figures as well as seeing during the POR which expenses continue and which ones do not continue).  This more current annual amount will be multiplied by the Coinsurance percentage you selected for your policy.  If the policy limit you carry is less than this more current required amount of insurance, your loss payment will be reduced."]
[]
[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.     Key source of patient referrals.",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,"Royalties - Do you receive royalties on any products or services you developed?",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,null,null,null,null,null,null,"NO"]
[null,null,"damaged while away from your premises? e.g. mobile units"]
[]
[null,5,"Leasehold Interest - If you are a tenant, do you have a favorable long term lease compared to current",null,null,null,null,null,null,null,null,"NO"]
[null,null,"market rental rates?"]
[]
[null,null," Business income exposure means Net income before income taxes plus all operating expenses."]