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

{"sheet":"Cover Page","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,2,27,3],[17,2,17,4],[19,3,19,4],[15,2,15,4],[10,2,10,4],[13,2,13,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.   "]
[]
[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,null,null,null,null,0.8]
[null,null,"Yellow shaded cells are for user entry throughout the worksheets.",null,"Other colored cells indicate calculations are performed.",null,0.9]
[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":[[5,2,9,2],[31,22,31,26],[15,1,15,3],[16,1,16,3],[22,1,22,3],[23,1,23,3],[25,1,25,3],[17,1,17,5],[20,1,20,3],[21,1,21,3]]}
[]
[null,"Business Income:  Rental Property",null,null,null,{"$f":"IF('Cover Page'!$E$3=\"\",\"\",\"Insured: \"&'Cover Page'!$E$3)","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.","Gross Rents",null,0]
[null,0,"B.","Add: Rental Value of the portion of the building you occupy",null,0]
[null,0,null,"Add: Tenant charges which become yours in the event of a loss",null,0]
[null,0,null,"Add: Miscellaneous income from tenant occupancy",null,0]
[null,0,null,"Add: Other earnings from your business operations:",null,0]
[null,null,null,"        Describe ________________________________"]
[null,{"$f":"+B5+B6+B7+B8+B9","v":0},"C.","EQUALS: TOTAL REVENUES",null,{"$f":"+F5+F6+F7+F8+F9","v":0}]
[null,0,"D.","Less: Total Cost of Goods Sold",null,0]
[null,{"$f":"'Payroll Limitation Worksheet'!F33","v":0},"E.","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":"+B11-B12-B13","v":0},"F.","Business Income Exposure for 12 Mos. ( C-D-E )",null,{"$f":"+F11-F12-F13","v":0}]
[]
[null,"G. 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 48.",null,null,1]
[]
[null,{"$f":"IF(V28,\"\", IF(W26>11,\"\", IF(V29+V30=2, \"\", W29)))","v":""}]
[null,{"$f":"F19","v":0},"H.","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 E should remain at $0.",null,{"$f":"+'Payroll Limitation Worksheet'!F35","v":0}]
[]
[null,"I. Minimum Amount of Business Income Insurance needed for your estimated Period of Restoration.  Based on F. modified by G. and H.",null,null,null,{"$f":"Z31","v":0}]
[null,"J1. 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,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(F19>0,+#REF!-#REF!-#REF!-'Payroll Limitation Worksheet'!F33,+#REF!-#REF!-#REF!)","v":{"$error":"#REF!"}}]
[null,"J2. Additional amount of estimated reduced income for the full period of months indicated in J1. above.",null,null,null,0,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,"K. 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'!G9","v":0}]
[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,"L. YOUR ESTIMATED AMOUNT OF NEEDED BUSINESS INCOME & EXTRA EXPENSE ( I + J + K )",null,null,null,{"$f":"IF(B18=\"\", F24+F23+F21, \"Seasonality error\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,4,0.25,null,null,{"$f":"INDEX(S28:S69,W25)","v":12},{"$f":"INDEX(T25:T41,X25)","v":1},13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0.3,null,null,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,null,null,null,null,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(#REF!=\"yes\",1,0)","v":{"$error":"#REF!"}},{"$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,null,null,null,null,null,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,null,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,F14*W26/12, IF(V28,(+W26/12)*F14, +F14*X26))+F19","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,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,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($Z25=\"A\",+((+$F16-12)/12)*$Y22*(1+#REF!),0)","v":0},null,null,{"$f":"IF($Z25=\"B\",+(((+$F16-24)/12)*$Y22*(1+#REF!)^2) +$Y22*(1+#REF!),0)","v":0},null,{"$f":"IF($Z25=\"C\",+((((+$F16-36)/12)*$Y22*(1+#REF!)^3) +$Y22*(1+#REF!)^2) +$Y22*(1+#REF!),0)","v":0},null,{"$f":"IF($Z25=\"D\",+(((((+$F16-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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0.7,null,{"$f":"IF(#REF!<F14,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!<F14,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(F16>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":"+F14","v":0},"por = 12",null,null,{"$f":"IF(#REF!=\"YES\",10,0)","v":{"$error":"#REF!"}},{"$f":"IF(F16<12,1,0)","v":1},{"$f":"IF(F16=24, 0, IF(F16>12,2,0))","v":0},{"$f":"IF(F16=12,3,0)","v":0},{"$f":"IF(F16=24,4,0)","v":0},{"$f":"SUM(AC42:AG42)","v":{"$error":"#REF!"}}]
[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":"+F14*(F16/12)*#REF!/(F16/12)","v":{"$error":"#REF!"}},"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":"+(F14*(F16/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\", F14+#REF!*(#REF!/12)*#REF!/(#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\", F14+#REF!*((+F16-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\", F14+#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":"+F16","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 H of the Business Income worksheet and increases the Business Income Exposure, Box L.",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":true,"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 sold 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   THERE IS NO LABOR OR OVERHEAD ALLOWED IN THIS FIGURE",null,{"$f":"F10+F11-F12","v":0}]
[null,null,null,"( CW1 + CW2 - CW3 )"]

{"sheet":"Extra Expense","index":6,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extra Expenses","1st Month","2nd Month","3rd Month","Additional Months","TOTAL"]
[null,"Additional Expenses at Temporary Premises",0,0,0,0,{"$f":"SUM(C3:F3)","v":0}]
[null,"Bonus for Quick Services",0,0,0,0,0]
[null,"Janitorial and Security",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,"Other  ______________________________",0,0,0,0,0]
[null,"TOTAL EXTRA EXPENSES TO BE INSURED",{"$f":"SUM(C3:C8)","v":0},{"$f":"SUM(D3:D8)","v":0},{"$f":"SUM(E3:E8)","v":0},{"$f":"SUM(F3:F8)","v":0},{"$f":"SUM(G3:G8)","v":0}]