{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BI Claim - By Day"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BI Claim - By Day","index":0,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":false,"merged":[[55,1,55,4],[56,1,56,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[52,0,52,4],[4,0,4,4],[15,0,15,4]]}
["(Insured's Name)"]
["Statement of Ongoing Expenses"]
["As of mm/dd/yyyy"]
[]
["From Prior Year Sales:"]
[null,"Month 1","Month 2","Month 3"]
[null,"__________","__________","__________"]
["Total Receipts"]
["Additional Income"]
["Less Cost of Goods"]
["Less Operating Expense"]
["Net Profit",{"$f":"B8+B9-B10-B11","v":0},{"$f":"C8+C9-C10-C11","v":0},{"$f":"D8+D9-D10-D11","v":0}]
["Net Profit",{"$f":"B12","v":0},{"$f":"C12","v":0},{"$f":"D12","v":0}]
[]
[]
["From Current Operating Expenses:"]
[]
["Continuing Expenses (list below)"]
["Accounting Services"]
["Advertising"]
["Cable/Satellite"]
["Contract Services"]
["Electric"]
["Employee Payroll"]
["Insurance"]
["Leased Equipment"]
["Licenses"]
["Mortgage/Rent"]
["Officer Payroll"]
["Payroll Tax"]
["Phone"]
["Property Tax"]
["Trash"]
["Water"]
["______________"]
["______________"]
["______________"]
["Total:",{"$f":"SUM(B19:B37)","v":0},{"$f":"SUM(C19:C37)","v":0},{"$f":"SUM(D19:D37)","v":0}]
["Total:",{"$f":"B38","v":0},{"$f":"C38","v":0},{"$f":"D38","v":0}]
[]
[]
["Net Profit",{"$f":"B13","v":0},{"$f":"C13","v":0},{"$f":"D13","v":0}]
["Continuing Expenses",{"$f":"B39","v":0},{"$f":"C39","v":0},{"$f":"D39","v":0}]
["Days in Month",31,31,30]
["Average Income per Day",{"$f":"((B42+B43)/B44)","v":0},{"$f":"((C42+C43)/C44)","v":0},{"$f":"((D42+D43)/D44)","v":0}]
["Average Income per Day",{"$f":"B45","v":0},{"$f":"C45","v":0},{"$f":"D45","v":0}]
[]
["Days Closed"]
[]
["Total Estimated Business Income Loss",{"$f":"SUM(B46:D46)/3*B48","v":0},{"$f":"SUM(C46:E46)/3*C48","v":0},{"$f":"SUM(D46:F46)/3*D48","v":0}]
["Total Estimated Business Income Loss",{"$f":"B50","v":0},{"$f":"C50","v":0},{"$f":"D50","v":0}]
[]
["Complete the boxes in yellow, all other calculations will be done automatically off of the data you input."]
[]
[]
[null,"Worksheet created and provided courtesy of Bret Dixon Insurance"]
[null,"Unauthorized use, copy or duplication is prohibited."]