{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Profit & Loss"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Profit & Loss","index":0,"n_rows":67,"n_cols":7,"rows_kept":67}
["Profit and Loss Statement",null,"For the [Month or Year] ending [Month-Day-Year]"]
["Company Name",null,"Stated in 000s"]
["Gross margin  [L/J]",null,{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",D21/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"}]
["Return on sales  [T/J]",null,{"$f":"IFERROR(IF(D67=0,\"-\",D67/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"}]
[]
[null,"Prior Period","Budget","Current Period","Current Period as % of Sales","% Change from Prior Period","% Change from Budget"]
["Sales Revenue"]
["Product/Service 1",{"$nulls":3},{"$f":"IFERROR(tblSalesRevenue[[#This Row],[Current Period]]/SUBTOTAL(109,tblSalesRevenue[Current Period]),\"\")","v":""},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Budget]]-1)","v":"-"}]
["Product/Service 2",{"$nulls":3},{"$f":"IFERROR(tblSalesRevenue[[#This Row],[Current Period]]/SUBTOTAL(109,tblSalesRevenue[Current Period]),\"\")","v":""},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Budget]]-1)","v":"-"}]
["Product/Service 3",{"$nulls":3},{"$f":"IFERROR(tblSalesRevenue[[#This Row],[Current Period]]/SUBTOTAL(109,tblSalesRevenue[Current Period]),\"\")","v":""},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Budget]]-1)","v":"-"}]
["Product/Service 4",{"$nulls":3},{"$f":"IFERROR(tblSalesRevenue[[#This Row],[Current Period]]/SUBTOTAL(109,tblSalesRevenue[Current Period]),\"\")","v":""},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblSalesRevenue[[#This Row],[Current Period]]=0,\"-\",tblSalesRevenue[[#This Row],[Current Period]]/tblSalesRevenue[[#This Row],[Budget]]-1)","v":"-"}]
["Total Sales Revenue  [J]",{"$f":"SUBTOTAL(109,tblSalesRevenue[Prior Period])","v":0},{"$f":"SUBTOTAL(109,tblSalesRevenue[Budget])","v":0},{"$f":"SUBTOTAL(109,tblSalesRevenue[Current Period])","v":0},{"$f":"IFERROR(SUBTOTAL(109,tblSalesRevenue[Current Period])/tblSalesRevenue[[#Totals],[Current Period]],\"-\")","v":"-"},{"$f":"IFERROR(tblSalesRevenue[[#Totals],[Current Period]]/tblSalesRevenue[[#Totals],[Prior Period]]-1,\"-\")","v":"-"},{"$f":"IFERROR(tblSalesRevenue[[#Totals],[Current Period]]/tblSalesRevenue[[#Totals],[Budget]]-1,\"-\")","v":"-"}]
[]
["Cost of Sales"]
["Product/Service 1",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Budget]]-1)","v":"-"}]
["Product/Service 2",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Budget]]-1)","v":"-"}]
["Product/Service 3",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Budget]]-1)","v":"-"}]
["Product/Service 4",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblCostOfSales[[#This Row],[Current Period]]=0,\"-\",tblCostOfSales[[#This Row],[Current Period]]/tblCostOfSales[[#This Row],[Budget]]-1)","v":"-"}]
["Total Cost of Sales  [K]",{"$f":"SUBTOTAL(109,tblCostOfSales[Prior Period])","v":0},{"$f":"SUBTOTAL(109,tblCostOfSales[Budget])","v":0},{"$f":"SUBTOTAL(109,tblCostOfSales[Current Period])","v":0},{"$f":"IFERROR(SUBTOTAL(109,tblCostOfSales[Current Period as % of Sales]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(SUBTOTAL(101, tblCostOfSales[% Change from Prior Period] ),\"-\")","v":"-"},{"$f":"IFERROR(SUBTOTAL(101,tblCostOfSales[% Change from Budget]),\"-\")","v":"-"}]
[]
["Gross Profit  [L=J-K]",{"$f":"tblSalesRevenue[[#Totals],[Prior Period]]-tblCostOfSales[[#Totals],[Prior Period]]","v":0},{"$f":"tblSalesRevenue[[#Totals],[Budget]]-tblCostOfSales[[#Totals],[Budget]]","v":0},{"$f":"tblSalesRevenue[[#Totals],[Current Period]]-tblCostOfSales[[#Totals],[Current Period]]","v":0},{"$f":"IFERROR(D21/tblSalesRevenue[[#Totals],[Current Period]],\"-\")","v":"-"},{"$f":"IFERROR(IF(B21=D21,0,IF(D21>B21,ABS((D21/B21)-1),IF(AND(D21<B21,B21<0),-((D21/B21)-1),(D21/B21)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(C21=D21,0,IF(D21>C21,ABS((D21/C21)-1),IF(AND(D21<C21,C21<0),-((D21/C21)-1),(D21/C21)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[]
["Operating Expenses"]
["Sales and Marketing"]
["Advertising",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Budget]]-1)","v":"-"}]
["Direct marketing",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Budget]]-1)","v":"-"}]
["Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Budget]]-1)","v":"-"}]
["Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblOperatingExpenses[[#This Row],[Current Period]]=0,\"-\",tblOperatingExpenses[[#This Row],[Current Period]]/tblOperatingExpenses[[#This Row],[Budget]]-1)","v":"-"}]
["Total Sales and Marketing Expenses  [M]",{"$f":"SUBTOTAL(109,tblOperatingExpenses[Prior Period])","v":0},{"$f":"SUBTOTAL(109,tblOperatingExpenses[Budget])","v":0},{"$f":"SUBTOTAL(109,tblOperatingExpenses[Current Period])","v":0},{"$f":"IFERROR(SUBTOTAL(109,tblOperatingExpenses[Current Period as % of Sales]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(SUBTOTAL(101, tblOperatingExpenses[% Change from Prior Period] ),\"-\")","v":"-"},{"$f":"IFERROR(SUBTOTAL(101,tblOperatingExpenses[% Change from Budget]),\"-\")","v":"-"}]
[]
["Research and Development"]
["Technology licenses",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Budget]]-1)","v":"-"}]
["Patents ",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Budget]]-1)","v":"-"}]
["Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Budget]]-1)","v":"-"}]
["Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblRandD[[#This Row],[Current Period]]=0,\"-\",tblRandD[[#This Row],[Current Period]]/tblRandD[[#This Row],[Budget]]-1)","v":"-"}]
["Total Research and Development Expenses  [N]",{"$f":"SUBTOTAL(109,tblRandD[Prior Period])","v":0},{"$f":"SUBTOTAL(109,tblRandD[Budget])","v":0},{"$f":"SUBTOTAL(109,tblRandD[Current Period])","v":0},{"$f":"IFERROR(SUBTOTAL(109,tblRandD[Current Period as % of Sales]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(SUBTOTAL(101, tblRandD[% Change from Prior Period] ),\"-\")","v":"-"},{"$f":"IFERROR(SUBTOTAL(101,tblRandD[% Change from Budget]),\"-\")","v":"-"}]
[]
["General and Adminstrative"]
["Wages and salaries",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Outside services",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Supplies",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Meals and entertainment",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Rent",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Telephone",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Utilities",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Depreciation",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Insurance",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Repairs and maintenance",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Prior Period]]-1)","v":"-"},{"$f":"IF(tblGenAdmin[[#This Row],[Current Period]]=0,\"-\",tblGenAdmin[[#This Row],[Current Period]]/tblGenAdmin[[#This Row],[Budget]]-1)","v":"-"}]
["Total General and Adminstrative Expenses  [O]",{"$f":"SUBTOTAL(109,tblGenAdmin[Prior Period])","v":0},{"$f":"SUBTOTAL(109,tblGenAdmin[Budget])","v":0},{"$f":"SUBTOTAL(109,tblGenAdmin[Current Period])","v":0},{"$f":"IFERROR(SUBTOTAL(109,tblGenAdmin[Current Period as % of Sales]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(SUBTOTAL(101, tblGenAdmin[% Change from Prior Period] ),\"-\")","v":"-"},{"$f":"IFERROR(SUBTOTAL(101,tblGenAdmin[% Change from Budget]),\"-\")","v":"-"}]
[]
["Total Operating Expenses  [P=M+N+O]",{"$f":"tblOperatingExpenses[[#Totals],[Prior Period]]+tblRandD[[#Totals],[Prior Period]]+tblGenAdmin[[#Totals],[Prior Period]]","v":0},{"$f":"tblOperatingExpenses[[#Totals],[Budget]]+tblRandD[[#Totals],[Budget]]+tblGenAdmin[[#Totals],[Budget]]","v":0},{"$f":"tblOperatingExpenses[[#Totals],[Current Period]]+tblRandD[[#Totals],[Current Period]]+tblGenAdmin[[#Totals],[Current Period]]","v":0},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",D53/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF($D53=0,\"-\",$D53/B53-1)","v":"-"},{"$f":"IF($D53=0,\"-\",$D53/C53-1)","v":"-"}]
[]
["Income from Operations  [Q=L-P]",{"$f":"B21-B53","v":0},{"$f":"C21-C53","v":0},{"$f":"D21-D53","v":0},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",D55/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(B55=0,\"-\",IF(B55=$D55,\"0.0%\",IF($D55>B55,ABS(($D55/B55)-1),IF(AND($D55<B55,B55<0),-(($D55/B55)-1),($D55/B55)-1))))","v":"-"},{"$f":"IF(C55=0,\"-\",IF(C55=$D55,\"0.0%\",IF($D55>C55,ABS(($D55/C55)-1),IF(AND($D55<C55,C55<0),-(($D55/C55)-1),($D55/C55)-1))))","v":"-"}]
[]
["Other Income  [R]",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",D57/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF($D57=0,\"-\",$D57/B57-1)","v":"-"},{"$f":"IF($D57=0,\"-\",$D57/C57-1)","v":"-"}]
[]
["Taxes"]
["Income taxes",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblTaxes[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Prior Period]]-1,\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Budget]]-1,\"-\")","v":"-"}]
["Payroll taxes",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblTaxes[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Prior Period]]-1,\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Budget]]-1,\"-\")","v":"-"}]
["Real estate taxes",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblTaxes[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Prior Period]]-1,\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Budget]]-1,\"-\")","v":"-"}]
["Other taxes (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblTaxes[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Prior Period]]-1,\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Budget]]-1,\"-\")","v":"-"}]
["Other taxes (specify)",{"$nulls":3},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",tblTaxes[[#This Row],[Current Period]]/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Prior Period]]-1,\"-\")","v":"-"},{"$f":"IFERROR(tblTaxes[[#This Row],[Current Period]]/tblTaxes[[#This Row],[Budget]]-1,\"-\")","v":"-"}]
["Total Taxes  [S]",{"$f":"SUBTOTAL(109,tblTaxes[Prior Period])","v":0},{"$f":"SUBTOTAL(109,tblTaxes[Budget])","v":0},{"$f":"SUBTOTAL(109,tblTaxes[Current Period])","v":0},{"$f":"IFERROR(SUBTOTAL(109,tblTaxes[Current Period as % of Sales]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(SUBTOTAL(101, tblTaxes[% Change from Prior Period] ),\"-\")","v":"-"},{"$f":"IFERROR(SUBTOTAL(101,tblTaxes[% Change from Budget]),\"-\")","v":"-"}]
[]
["Net Profit  [T=Q+R-S]",{"$f":"B55+B57-tblTaxes[[#Totals],[Prior Period]]","v":0},{"$f":"C55+C57-tblTaxes[[#Totals],[Budget]]","v":0},{"$f":"D55+D57-tblTaxes[[#Totals],[Current Period]]","v":0},{"$f":"IFERROR(IF(tblSalesRevenue[[#Totals],[Current Period]]=0,\"-\",D67/tblSalesRevenue[[#Totals],[Current Period]]),\"-\")","v":"-"},{"$f":"IF(B67=0,\"-\",IF(B67=$D67,\"0.0%\",IF($D67>B67,ABS(($D67/B67)-1),IF(AND($D67<B67,B67<0),-(($D67/B67)-1),($D67/B67)-1))))","v":"-"},{"$f":"IF(C67=0,\"-\",IF(C67=$D67,\"0.0%\",IF($D67>C67,ABS(($D67/C67)-1),IF(AND($D67<C67,C67<0),-(($D67/C67)-1),($D67/C67)-1))))","v":"-"}]