{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Detailed Profit & Loss","Balance Sheet","Cashflow Statement"],"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":"Detailed Profit & Loss","index":0,"n_rows":135,"n_cols":19,"rows_kept":135,"cut":false,"hidden":false,"merged":[[8,5,12,5],[8,9,12,9],[8,13,12,13],[8,17,12,17],[134,1,134,18]]}
[" ","DETAILED FINANCIAL PROJECTIONS SPREADSHEET TEMPLATE"]
[]
[null,"DETAILED PROFIT & LOSS","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"GROSS PROFIT",{"$f":"C32","v":0},{"$f":"D32","v":0},0,{"$f":"SUM(C4:E4)","v":0},{"$f":"G32","v":0},{"$f":"H32","v":0},0,{"$f":"SUM(G4:I4)","v":0},{"$f":"K32","v":0},{"$f":"L32","v":0},{"$f":"M32","v":0},{"$f":"SUM(K4:M4)","v":0},{"$f":"O32","v":0},{"$f":"P32","v":0},0,{"$f":"SUM(O4:Q4)","v":0},{"$f":"SUM(F4,J4,N4,R4)","v":0}]
[null,"TOTAL EXPENSES",4,{"$f":"D133","v":0},{"$f":"E133","v":0},{"$f":"SUM(C5:E5)","v":4},{"$f":"G133","v":0},{"$f":"H133","v":0},{"$f":"I133","v":0},{"$f":"SUM(G5:I5)","v":0},{"$f":"K133","v":0},{"$f":"L133","v":0},{"$f":"M133","v":0},{"$f":"SUM(K5:M5)","v":0},{"$f":"O133","v":0},{"$f":"P133","v":0},{"$f":"Q133","v":0},{"$f":"SUM(O5:Q5)","v":0},{"$f":"SUM(F5,J5,N5,R5)","v":4}]
[null,"MONTHLY NET PROFIT/(LOSS)",{"$f":"C4-C5","v":-4},{"$f":"D4-D5","v":0},0,{"$f":"SUM(C6:E6)","v":-4},{"$f":"G4-G5","v":0},{"$f":"H4-H5","v":0},{"$f":"I4-I5","v":0},{"$f":"SUM(G6:I6)","v":0},{"$f":"K4-K5","v":0},{"$f":"L4-L5","v":0},{"$f":"M4-M5","v":0},{"$f":"SUM(K6:M6)","v":0},{"$f":"O4-O5","v":0},{"$f":"P4-P5","v":0},{"$f":"Q4-Q5","v":0},{"$f":"SUM(O6:Q6)","v":0},{"$f":"SUM(F6,J6,N6,R6)","v":-4}]
[null,"YEAR TO DATE NET PROFIT/(LOSS)",{"$f":"C6","v":-4},{"$f":"C7+D6","v":-4},{"$f":"D7+E6","v":-4},null,{"$f":"E7+G6","v":-4},{"$f":"G7+H6","v":-4},{"$f":"H7+I6","v":-4},null,{"$f":"I7+K6","v":-4},{"$f":"K7+L6","v":-4},{"$f":"L7+M6","v":-4},null,{"$f":"M7+O6","v":-4},{"$f":"O7+P6","v":-4},{"$f":"P7+Q6","v":-4}]
[]
[null,"PROFIT & LOSS RATIOS","JAN","FEB","MAR",null,"APR","MAY","JUN",null,"JUL","AUG","SEPT",null,"OCT","NOV","DEC"]
[null,"GROSS MARGIN\n(Gross Profit/Net Income)",{"$f":"C4/C25","v":{"$error":"#DIV/0!"}},{"$f":"D4/D25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"G4/G25","v":{"$error":"#DIV/0!"}},{"$f":"H4/H25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"K4/K25","v":{"$error":"#DIV/0!"}},{"$f":"L4/L25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"O4/O25","v":{"$error":"#DIV/0!"}},{"$f":"P4/P25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"NET MARGIN\n(Net Profit/Net Income)",{"$f":"C6/C25","v":{"$error":"#DIV/0!"}},{"$f":"D6/D25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"G6/G25","v":{"$error":"#DIV/0!"}},{"$f":"H6/H25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"K6/K25","v":{"$error":"#DIV/0!"}},{"$f":"L6/L25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"O6/O25","v":{"$error":"#DIV/0!"}},{"$f":"P6/P25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"MARK-UP\n((Net Income Less Cost of Goods Sold)/(Cost of Goods Sold)) x 100",{"$f":"C4/C31","v":{"$error":"#DIV/0!"}},{"$f":"D4/D31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"G4/G31","v":{"$error":"#DIV/0!"}},{"$f":"H4/H31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"K4/K31","v":{"$error":"#DIV/0!"}},{"$f":"L4/L31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"O4/O31","v":{"$error":"#DIV/0!"}},{"$f":"P4/P31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"BREAK-EVEN\n(Expenses/((1-(Cost of Goods Sold/Net Income))",{"$f":"(C5/(1-C31/C25))","v":{"$error":"#DIV/0!"}},{"$f":"(D5/(1-D31/D25))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"(G5/(1-G31/G25))","v":{"$error":"#DIV/0!"}},{"$f":"(H5/(1-H31/H25))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"(K5/(1-K31/K25))","v":{"$error":"#DIV/0!"}},{"$f":"(L5/(1-L31/L25))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"(O5/(1-O31/O25))","v":{"$error":"#DIV/0!"}},{"$f":"(P5/(1-P31/P25))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,"MONTHLY INCOME","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"SALES"]
[null,"SALES OF GOODS/SERVICES",null,null,null,{"$f":"SUM(C17:E17)","v":0},null,null,null,{"$f":"SUM(G17:I17)","v":0},null,null,null,{"$f":"SUM(K17:M17)","v":0},null,null,null,{"$f":"SUM(O17:Q17)","v":0},{"$f":"SUM(F17,J17,N17,R17)","v":0}]
[null,"COMMISSIONS/FEES/ETC.",null,null,null,{"$f":"SUM(C18:E18)","v":0},null,null,null,{"$f":"SUM(G18:I18)","v":0},null,null,null,{"$f":"SUM(K18:M18)","v":0},null,null,null,{"$f":"SUM(O18:Q18)","v":0},{"$f":"SUM(F18,J18,N18,R18)","v":0}]
[null,"OTHER",null,null,null,{"$f":"SUM(C19:E19)","v":0},null,null,null,{"$f":"SUM(G19:I19)","v":0},null,null,null,{"$f":"SUM(K19:M19)","v":0},null,null,null,{"$f":"SUM(O19:Q19)","v":0},0]
[null,"TOTAL SALES",{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},0,0,{"$f":"SUM(G17:G19)","v":0},{"$f":"SUM(H17:H19)","v":0},{"$f":"SUM(I17:I19)","v":0},{"$f":"SUM(J17:J19)","v":0},{"$f":"SUM(K17:K19)","v":0},{"$f":"SUM(L17:L19)","v":0},{"$f":"SUM(M17:M19)","v":0},{"$f":"SUM(N17:N19)","v":0},{"$f":"SUM(O17:O19)","v":0},{"$f":"SUM(P17:P19)","v":0},{"$f":"SUM(Q17:Q19)","v":0},{"$f":"SUM(R17:R19)","v":0},0]
[null,"LESS DISCOUNTS/COMMISSIONS"]
[null,"DISCOUNTS GIVEN",null,null,null,{"$f":"SUM(C22:E22)","v":0},null,null,null,{"$f":"SUM(G22:I22)","v":0},null,null,null,{"$f":"SUM(K22:M22)","v":0},null,null,null,{"$f":"SUM(O22:Q22)","v":0},{"$f":"SUM(F22,J22,N22,R22)","v":0}]
[null,"COMMISSIONS PAID",null,null,null,{"$f":"SUM(C23:E23)","v":0},null,null,null,{"$f":"SUM(G23:I23)","v":0},null,null,null,{"$f":"SUM(K23:M23)","v":0},null,null,null,{"$f":"SUM(O23:Q23)","v":0},{"$f":"SUM(F23,J23,N23,R23)","v":0}]
[null,"TOTAL DISCOUNTS/COMMISSIONS",{"$f":"SUM(C22:C23)","v":0},{"$f":"SUM(D22:D23)","v":0},0,{"$f":"SUM(C24:E24)","v":0},{"$f":"SUM(G22:G23)","v":0},{"$f":"SUM(H22:H23)","v":0},{"$f":"SUM(I22:I23)","v":0},{"$f":"SUM(G24:I24)","v":0},{"$f":"SUM(K22:K23)","v":0},{"$f":"SUM(L22:L23)","v":0},{"$f":"SUM(M22:M23)","v":0},{"$f":"SUM(K24:M24)","v":0},{"$f":"SUM(O22:O23)","v":0},{"$f":"SUM(P22:P23)","v":0},{"$f":"SUM(Q22:Q23)","v":0},{"$f":"SUM(O24:Q24)","v":0},{"$f":"SUM(F24,J24,N24,R24)","v":0}]
[null,"TOTAL NET INCOME",{"$f":"C20-C24","v":0},{"$f":"D20-D24","v":0},0,0,{"$f":"G20-G24","v":0},{"$f":"H20-H24","v":0},{"$f":"I20-I24","v":0},{"$f":"J20-J24","v":0},{"$f":"K20-K24","v":0},{"$f":"L20-L24","v":0},{"$f":"M20-M24","v":0},{"$f":"N20-N24","v":0},{"$f":"O20-O24","v":0},{"$f":"P20-P24","v":0},{"$f":"Q20-Q24","v":0},{"$f":"R20-R24","v":0},{"$f":"SUM(F25,J25,N25,R25)","v":0}]
[null,"COGS Cost of Goods Sold"]
[null,"OPENING STOCK",null,null,null,{"$f":"SUM(C27:E27)","v":0},null,null,null,{"$f":"SUM(G27:I27)","v":0},null,null,null,{"$f":"SUM(K27:M27)","v":0},null,null,null,{"$f":"SUM(O27:Q27)","v":0},{"$f":"SUM(F27,J27,N27,R27)","v":0}]
[null,"STOCK PURCHASED",null,null,null,{"$f":"SUM(C28:E28)","v":0},null,null,null,{"$f":"SUM(G28:I28)","v":0},null,null,null,{"$f":"SUM(K28:M28)","v":0},null,null,null,{"$f":"SUM(O28:Q28)","v":0},{"$f":"SUM(F28,J28,N28,R28)","v":0}]
[null,"SUBTOTAL COGS",{"$f":"SUM(C27:C28)","v":0},{"$f":"SUM(D27:D28)","v":0},0,{"$f":"SUM(F27:F28)","v":0},{"$f":"G28-G27","v":0},{"$f":"H28-H27","v":0},0,{"$f":"J28-J27","v":0},{"$f":"K28-K27","v":0},{"$f":"L28-L27","v":0},0,{"$f":"N28-N27","v":0},{"$f":"O28-O27","v":0},{"$f":"P28-P27","v":0},0,{"$f":"R28-R27","v":0},{"$f":"SUM(F29,J29,N29,R29)","v":0}]
[null,"LESS CLOSING STOCK",null,null,null,{"$f":"SUM(C30:E30)","v":0},null,null,null,{"$f":"SUM(G30:I30)","v":0},null,null,null,{"$f":"SUM(K30:M30)","v":0},null,null,null,{"$f":"SUM(O30:Q30)","v":0},0]
[null,"TOTAL COGS",{"$f":"C29-C30","v":0},{"$f":"D29-D30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R29-R30","v":0},{"$f":"S29-S30","v":0}]
[null,"GROSS PROFIT",{"$f":"C25-C31","v":0},{"$f":"D25-D31","v":0},0,{"$f":"SUM(C32:E32)","v":0},{"$f":"G25-G31","v":0},{"$f":"H25-H31","v":0},{"$f":"I25-I31","v":0},{"$f":"SUM(G32:I32)","v":0},{"$f":"K25-K31","v":0},{"$f":"L25-L31","v":0},{"$f":"M25-M31","v":0},{"$f":"SUM(K32:M32)","v":0},{"$f":"O25-O31","v":0},{"$f":"P25-P31","v":0},{"$f":"Q25-Q31","v":0},{"$f":"SUM(O32:Q32)","v":0},{"$f":"SUM(F32,J32,N32,R32)","v":0}]
[]
[null,"EXPENSES - OPERATIONAL","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"GENERAL/ADMIN"]
[null,"BANKING FEES",null,null,null,{"$f":"SUM(C36:E36)","v":0},null,null,null,{"$f":"SUM(G36:I36)","v":0},null,null,null,{"$f":"SUM(K36:M36)","v":0},null,null,null,{"$f":"SUM(O36:Q36)","v":0},{"$f":"SUM(F36,J36,N36,R36)","v":0}]
[null,"CONSULT FEES",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F37,J37,N37,R37)","v":0}]
[null,"OFFICE SUPPLIES",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F38,J38,N38,R38)","v":0}]
[null,"LICENSE FEES",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F39,J39,N39,R39)","v":0}]
[null,"BUSINESS INSURANCE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F41,J41,N41,R41)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F42,J42,N42,R42)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F43,J43,N43,R43)","v":0}]
[null,"TOTAL GENERAL/ADMIN",{"$f":"SUM(C36:C43)","v":0},{"$f":"SUM(D36:D43)","v":0},{"$f":"SUM(E36:E43)","v":0},0,{"$f":"SUM(G36:G43)","v":0},{"$f":"SUM(H36:H43)","v":0},{"$f":"SUM(I36:I43)","v":0},0,{"$f":"SUM(K36:K43)","v":0},{"$f":"SUM(L36:L43)","v":0},{"$f":"SUM(M36:M43)","v":0},0,{"$f":"SUM(O36:O43)","v":0},{"$f":"SUM(P36:P43)","v":0},{"$f":"SUM(Q36:Q43)","v":0},0,{"$f":"SUM(F44,J44,N44,R44)","v":0}]
[null,"OPERATIONS"]
[null,"TRAVEL",null,null,null,{"$f":"SUM(C46:E46)","v":0},null,null,null,{"$f":"SUM(G46:I46)","v":0},null,null,null,{"$f":"SUM(K46:M46)","v":0},null,null,null,{"$f":"SUM(O46:Q46)","v":0},{"$f":"SUM(F46,J46,N46,R46)","v":0}]
[null,"LAUNDRY",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F47,J47,N47,R47)","v":0}]
[null,"TRANSPORTATION",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F48,J48,N48,R48)","v":0}]
[null,"CLEANING SVCS & SUPPLIES",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F49,J49,N49,R49)","v":0}]
[null,"SUBSCRIPTIONS",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"KITCHENETTE/COFFEE/SNACKS",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F51,J51,N51,R51)","v":0}]
[null,"KITCHENETTE EQUIPMENT",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F52,J52,N52,R52)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F53,J53,N53,R53)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F54,J54,N54,R54)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F55,J55,N55,R55)","v":0}]
[null,"TOTAL OPERATIONS",{"$f":"SUM(C46:C55)","v":0},{"$f":"SUM(D46:D55)","v":0},{"$f":"SUM(E46:E55)","v":0},0,{"$f":"SUM(G46:G55)","v":0},{"$f":"SUM(H46:H55)","v":0},{"$f":"SUM(I46:I55)","v":0},0,{"$f":"SUM(K46:K55)","v":0},{"$f":"SUM(L46:L55)","v":0},{"$f":"SUM(M46:M55)","v":0},0,{"$f":"SUM(O46:O55)","v":0},{"$f":"SUM(P46:P55)","v":0},{"$f":"SUM(Q46:Q55)","v":0},0,{"$f":"SUM(F56,J56,N56,R56)","v":0}]
[null,"MARKETING/PROMO"]
[null,"ADVERTISING",null,null,null,{"$f":"SUM(C58:E58)","v":0},null,null,null,{"$f":"SUM(G58:I58)","v":0},null,null,null,{"$f":"SUM(K58:M58)","v":0},null,null,null,{"$f":"SUM(O58:Q58)","v":0},{"$f":"SUM(F58,J58,N58,R58)","v":0}]
[null,"PROMO",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F59,J59,N59,R59)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F60,J60,N60,R60)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F61,J61,N61,R61)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"TOTAL MARKETING/PROMO",{"$f":"SUM(C58:C62)","v":0},{"$f":"SUM(D58:D62)","v":0},{"$f":"SUM(E58:E62)","v":0},0,{"$f":"SUM(G58:G62)","v":0},{"$f":"SUM(H58:H62)","v":0},{"$f":"SUM(I58:I62)","v":0},0,{"$f":"SUM(K58:K62)","v":0},{"$f":"SUM(L58:L62)","v":0},{"$f":"SUM(M58:M62)","v":0},0,{"$f":"SUM(O58:O62)","v":0},{"$f":"SUM(P58:P62)","v":0},{"$f":"SUM(Q58:Q62)","v":0},0,{"$f":"SUM(F63,J63,N63,R63)","v":0}]
[null,"WEBSITE/MOBILE APP"]
[null,"DOMAIN",null,null,null,{"$f":"SUM(C65:E65)","v":0},null,null,null,{"$f":"SUM(G65:I65)","v":0},null,null,null,{"$f":"SUM(K65:M65)","v":0},null,null,null,{"$f":"SUM(O65:Q65)","v":0},{"$f":"SUM(F65,J65,N65,R65)","v":0}]
[null,"HOSTING",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F66,J66,N66,R66)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F67,J67,N67,R67)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F68,J68,N68,R68)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"TOTAL WEBSITE/MOBILE APP",{"$f":"SUM(C65:C69)","v":0},{"$f":"SUM(D65:D69)","v":0},{"$f":"SUM(E65:E69)","v":0},0,{"$f":"SUM(G65:G69)","v":0},{"$f":"SUM(H65:H69)","v":0},{"$f":"SUM(I65:I69)","v":0},0,{"$f":"SUM(K65:K69)","v":0},{"$f":"SUM(L65:L69)","v":0},{"$f":"SUM(M65:M69)","v":0},0,{"$f":"SUM(O65:O69)","v":0},{"$f":"SUM(P65:P69)","v":0},{"$f":"SUM(Q65:Q69)","v":0},0,{"$f":"SUM(F70,J70,N70,R70)","v":0}]
[null,"OCCUPANCY"]
[null,"RENT/LEASE",null,null,null,{"$f":"SUM(C72:E72)","v":0},null,null,null,{"$f":"SUM(G72:I72)","v":0},null,null,null,{"$f":"SUM(K72:M72)","v":0},null,null,null,{"$f":"SUM(O72:Q72)","v":0},{"$f":"SUM(F72,J72,N72,R72)","v":0}]
[null,"PHONE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F73,J73,N73,R73)","v":0}]
[null,"INTERNET",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F74,J74,N74,R74)","v":0}]
[null,"ELECTRIC",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F75,J75,N75,R75)","v":0}]
[null,"GAS",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"WATER/SEWAGE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F77,J77,N77,R77)","v":0}]
[null,"WASTE REMOVAL",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F78,J78,N78,R78)","v":0}]
[null,"RECYCLING/SHREDDING",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F79,J79,N79,R79)","v":0}]
[null,"REPAIR/MAINTENANCE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F80,J80,N80,R80)","v":0}]
[null,"PROPERTY INSURANCE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F81,J81,N81,R81)","v":0}]
[null,"SECURITY",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F83,J83,N83,R83)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F84,J84,N84,R84)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F85,J85,N85,R85)","v":0}]
[null,"TOTAL OCCUPANCY",{"$f":"SUM(C72:C85)","v":0},{"$f":"SUM(D72:D85)","v":0},{"$f":"SUM(E72:E85)","v":0},0,{"$f":"SUM(G72:G85)","v":0},{"$f":"SUM(H72:H85)","v":0},{"$f":"SUM(I72:I85)","v":0},0,{"$f":"SUM(K72:K85)","v":0},{"$f":"SUM(L72:L85)","v":0},{"$f":"SUM(M72:M85)","v":0},0,{"$f":"SUM(O72:O85)","v":0},{"$f":"SUM(P72:P85)","v":0},{"$f":"SUM(Q72:Q85)","v":0},0,{"$f":"SUM(F86,J86,N86,R86)","v":0}]
[null,"AUTOMOTIVE"]
[null,"FUEL",null,null,null,{"$f":"SUM(C88:E88)","v":0},null,null,null,{"$f":"SUM(G88:I88)","v":0},null,null,null,{"$f":"SUM(K88:M88)","v":0},null,null,null,{"$f":"SUM(O88:Q88)","v":0},{"$f":"SUM(F88,J88,N88,R88)","v":0}]
[null,"SERVICE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F89,J89,N89,R89)","v":0}]
[null,"PARTS/MAINTENANCE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F90,J90,N90,R90)","v":0}]
[null,"INSURANCE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F91,J91,N91,R91)","v":0}]
[null,"REGISTRATION",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F93,J93,N93,R93)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F94,J94,N94,R94)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F95,J95,N95,R95)","v":0}]
[null,"TOTAL AUTOMOTIVE",{"$f":"SUM(C88:C95)","v":0},{"$f":"SUM(D88:D95)","v":0},{"$f":"SUM(E88:E95)","v":0},0,{"$f":"SUM(G88:G95)","v":0},{"$f":"SUM(H88:H95)","v":0},{"$f":"SUM(I88:I95)","v":0},0,{"$f":"SUM(K88:K95)","v":0},{"$f":"SUM(L88:L95)","v":0},{"$f":"SUM(M88:M95)","v":0},0,{"$f":"SUM(O88:O95)","v":0},{"$f":"SUM(P88:P95)","v":0},{"$f":"SUM(Q88:Q95)","v":0},0,{"$f":"SUM(F96,J96,N96,R96)","v":0}]
[null,"ADDITIONAL"]
[null,"OTHER",null,null,null,{"$f":"SUM(C98:E98)","v":0},null,null,null,{"$f":"SUM(G98:I98)","v":0},null,null,null,{"$f":"SUM(K98:M98)","v":0},null,null,null,{"$f":"SUM(O98:Q98)","v":0},{"$f":"SUM(F98,J98,N98,R98)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F99,J99,N99,R99)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F100,J100,N100,R100)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F101,J101,N101,R101)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F103,J103,N103,R103)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F104,J104,N104,R104)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F105,J105,N105,R105)","v":0}]
[null,"TOTAL ADDITIONAL",{"$f":"SUM(C98:C105)","v":0},{"$f":"SUM(D98:D105)","v":0},{"$f":"SUM(E98:E105)","v":0},0,{"$f":"SUM(G98:G105)","v":0},{"$f":"SUM(H98:H105)","v":0},{"$f":"SUM(I98:I105)","v":0},0,{"$f":"SUM(K98:K105)","v":0},{"$f":"SUM(L98:L105)","v":0},{"$f":"SUM(M98:M105)","v":0},0,{"$f":"SUM(O98:O105)","v":0},{"$f":"SUM(P98:P105)","v":0},{"$f":"SUM(Q98:Q105)","v":0},0,{"$f":"SUM(F106,J106,N106,R106)","v":0}]
[null,"TOTAL EXPENSES - OPERATIONAL",{"$f":"SUM(C44,C56,C63,C70,C86,C96,C106)","v":0},{"$f":"SUM(D44,D56,D63,D70,D86,D96,D106)","v":0},0,0,{"$f":"SUM(G44,G56,G63,G70,G86,G96,G106)","v":0},{"$f":"SUM(H44,H56,H63,H70,H86,H96,H106)","v":0},{"$f":"SUM(I44,I56,I63,I70,I86,I96,I106)","v":0},0,{"$f":"SUM(K44,K56,K63,K70,K86,K96,K106)","v":0},{"$f":"SUM(L44,L56,L63,L70,L86,L96,L106)","v":0},{"$f":"SUM(M44,M56,M63,M70,M86,M96,M106)","v":0},0,{"$f":"SUM(O44,O56,O63,O70,O86,O96,O106)","v":0},{"$f":"SUM(P44,P56,P63,P70,P86,P96,P106)","v":0},{"$f":"SUM(Q44,Q56,Q63,Q70,Q86,Q96,Q106)","v":0},0,{"$f":"SUM(F107,J107,N107,R107)","v":0}]
[]
[null,"EXPENSES - EMPLOYMENT","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"PERMANENT"]
[null,"SALARIES/WAGES",null,null,null,{"$f":"SUM(C111:E111)","v":0},null,null,null,{"$f":"SUM(G111:I111)","v":0},null,null,null,{"$f":"SUM(K111:M111)","v":0},null,null,null,{"$f":"SUM(O111:Q111)","v":0},{"$f":"SUM(F111,J111,N111,R111)","v":0}]
[null,"BONUS PAY",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F112,J112,N112,R112)","v":0}]
[null,"INCREASES",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F113,J113,N113,R113)","v":0}]
[null,"BENEFITS",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F114,J114,N114,R114)","v":0}]
[null,"INSURANCE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"RECRUITMENT",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F116,J116,N116,R116)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F117,J117,N117,R117)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F118,J118,N118,R118)","v":0}]
[null,"TOTAL PERMANENT EMPLOYMENT",{"$f":"SUM(C111:C118)","v":0},{"$f":"SUM(D111:D118)","v":0},{"$f":"SUM(E111:E118)","v":0},0,{"$f":"SUM(G111:G118)","v":0},{"$f":"SUM(H111:H118)","v":0},{"$f":"SUM(I111:I118)","v":0},0,{"$f":"SUM(K111:K118)","v":0},{"$f":"SUM(L111:L118)","v":0},{"$f":"SUM(M111:M118)","v":0},0,{"$f":"SUM(O111:O118)","v":0},{"$f":"SUM(P111:P118)","v":0},{"$f":"SUM(Q111:Q118)","v":0},0,{"$f":"SUM(F119,J119,N119,R119)","v":0}]
[null,"CASUAL"]
[null,"SALARIES/WAGES",null,null,null,{"$f":"SUM(C121:E121)","v":0},null,null,null,{"$f":"SUM(G121:I121)","v":0},null,null,null,{"$f":"SUM(K121:M121)","v":0},null,null,null,{"$f":"SUM(O121:Q121)","v":0},{"$f":"SUM(F121,J121,N121,R121)","v":0}]
[null,"BONUS PAY",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F122,J122,N122,R122)","v":0}]
[null,"INCREASES",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F123,J123,N123,R123)","v":0}]
[null,"INSURANCE",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F124,J124,N124,R124)","v":0}]
[null,"BENEFITS",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,"RECRUITMENT",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F126,J126,N126,R126)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F127,J127,N127,R127)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F128,J128,N128,R128)","v":0}]
[null,"OTHER",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$f":"SUM(F129,J129,N129,R129)","v":0}]
[null,"TOTAL CASUAL EMPLOYMENT",{"$f":"SUM(C121:C129)","v":0},{"$f":"SUM(D121:D129)","v":0},{"$f":"SUM(E121:E129)","v":0},0,{"$f":"SUM(G121:G129)","v":0},{"$f":"SUM(H121:H129)","v":0},{"$f":"SUM(I121:I129)","v":0},0,{"$f":"SUM(K121:K129)","v":0},{"$f":"SUM(L121:L129)","v":0},{"$f":"SUM(M121:M129)","v":0},0,{"$f":"SUM(O121:O129)","v":0},{"$f":"SUM(P121:P129)","v":0},{"$f":"SUM(Q121:Q129)","v":0},0,{"$f":"SUM(F130,J130,N130,R130)","v":0}]
[null,"TOTAL EXPENSES - EMPLOYMENT",{"$f":"SUM(C119,C130)","v":0},{"$f":"SUM(D119,D130)","v":0},0,0,{"$f":"SUM(G119,G130)","v":0},{"$f":"SUM(H119,H130)","v":0},{"$f":"SUM(I119,I130)","v":0},0,{"$f":"SUM(K119,K130)","v":0},{"$f":"SUM(L119,L130)","v":0},{"$f":"SUM(M119,M130)","v":0},0,{"$f":"SUM(O119,O130)","v":0},{"$f":"SUM(P119,P130)","v":0},{"$f":"SUM(Q119,Q130)","v":0},0,{"$f":"SUM(F131,J131,N131,R131)","v":0}]
[]
[null,"TOTAL EXPENSES",{"$f":"SUM(C107,C131)","v":0},{"$f":"SUM(D107,D131)","v":0},{"$f":"SUM(E107,E131)","v":0},{"$f":"SUM(C133:E133)","v":0},{"$f":"SUM(G107,G131)","v":0},{"$f":"SUM(H107,H131)","v":0},{"$f":"SUM(I107,I131)","v":0},{"$f":"SUM(G133:I133)","v":0},{"$f":"SUM(K107,K131)","v":0},{"$f":"SUM(L107,L131)","v":0},{"$f":"SUM(M107,M131)","v":0},{"$f":"SUM(K133:M133)","v":0},{"$f":"SUM(O107,O131)","v":0},{"$f":"SUM(P107,P131)","v":0},{"$f":"SUM(Q107,Q131)","v":0},{"$f":"SUM(O133:Q133)","v":0},{"$f":"SUM(F133,J133,N133,R133)","v":0}]
[]
[null,"CLICK HERE TO CREATE DETAILED FINANCIAL PROJECTIONS SPREADSHEET TEMPLATES IN SMARTSHEET"]

{"sheet":"Balance Sheet","index":1,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[" ","BALANCE SHEET"]
[]
[null,"BALANCE SHEET RATIOS","START OF FY","Q2 TOTAL","Q4 TOTAL"]
[null,"CURRENT RATIO\n(Current Assets/Current Liabilities)",{"$f":"C30/C55","v":{"$error":"#DIV/0!"}},{"$f":"D30/D55","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"QUICK RATIO\n(Current Assets Less Inventory)/(Current Liabilities Less Bank Overdraft)",{"$f":"(C30-C27)/(C55-C45)","v":{"$error":"#DIV/0!"}},{"$f":"(D30-D27)/(D55-D45)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"WORKING CAPITAL FUNDS\n(Current Assets Less Current Liabilities)",{"$f":"C30-C55","v":0},{"$f":"D30-D55","v":0},0]
[null,"LEVERAGE RATIO\n(Total Liabilities/Total Assets)",{"$f":"C64/C41","v":{"$error":"#DIV/0!"}},{"$f":"D64/D41","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"DEBT-TO-EQUITY RATIO\n(Total Liabilities / Total Shareholders Funds)",{"$f":"C64/C73","v":{"$error":"#DIV/0!"}},{"$f":"D64/D73","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,"ASSETS","START OF FY","Q2 TOTAL","Q4 TOTAL"]
[null,"CURRENT ASSETS"]
[null,"CASH ON HAND",0,0,0]
[null,"DEBTORS",0,0,0]
[null,"PREPAID EXPENSES"]
[null,"GENERAL",0,0,0]
[null,"RATES",0,0,0]
[null,"WORK COVER",0,0,0]
[null,"INSURANCE",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL PREPAID EXPENSES",{"$f":"SUM(C15:C20)","v":0},{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0}]
[null,"INVENTORY"]
[null,"ITEM CATEGORY 1",0,0,0]
[null,"ITEM CATEGORY 2",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL INVENTORY",{"$f":"SUM(C23:C26)","v":0},{"$f":"SUM(D23:D26)","v":0},0]
[null,"SHORT-TERM INVESTMENTS",0,0,0]
[null,"OTHER CURRENT ASSETS",0,0,0]
[null,"TOTAL CURRENT ASSETS",{"$f":"SUM(C12,C13,C21,C27,C28,C29)","v":0},{"$f":"SUM(D12,D13,D21,D27,D28,D29)","v":0},{"$f":"SUM(E12,E13,E21,E27,E28,E29)","v":0}]
[null,"FIXED ASSETS"]
[null,"TECHNOLOGY",0,0,0]
[null,"FURNITURE/FIXTURES",0,0,0]
[null,"EQUIPMENT",0,0,0]
[null,"LEASE",0,0,0]
[null,"BUILDINGS/IMPROVEMENTS",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL FIXED ASSETS",{"$f":"SUM(C32:C39)","v":0},{"$f":"SUM(D32:D39)","v":0},{"$f":"SUM(E32:E39)","v":0}]
[null,"TOTAL ASSETS",{"$f":"SUM(C30,C40)","v":0},{"$f":"SUM(D30,D40)","v":0},{"$f":"SUM(E30,E40)","v":0}]
[]
[null,"LIABILITIES","START OF FY","Q2 TOTAL","Q4 TOTAL"]
[null,"CURRENT LIABILITIES"]
[null,"BANK OVERDRAFT",0,0,0]
[null,"CREDIT CARD DEBT",0,0,0]
[null,"CREDITORS",0,0,0]
[null,"INCREASES",0,0,0]
[null,"TAXES",0,0,0]
[null,"BENEFITS",0,0,0]
[null,"INSURANCE",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL CURRENT LIABILITIES",{"$f":"SUM(C45:C54)","v":0},{"$f":"SUM(D45:D54)","v":0},{"$f":"SUM(E45:E54)","v":0}]
[null,"LONG-TERM LIABILITIES"]
[null,"VEHICLE LOAN",0,0,0]
[null,"EQUIPMENT FINANCE",0,0,0]
[null,"LONG-TERM LOANS",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL LONG-TERM LOANS",{"$f":"SUM(C57:C62)","v":0},{"$f":"SUM(D57:D62)","v":0},{"$f":"SUM(E57:E62)","v":0}]
[null,"TOTAL LIABILITIES",{"$f":"SUM(C55,C63)","v":0},{"$f":"SUM(D55,D63)","v":0},{"$f":"SUM(E55,E63)","v":0}]
[]
[null,"NET ASSETS\n(Assets Less Liabilities - Should Equal Total Shareholders Funds)",{"$f":"C41-C64","v":0},{"$f":"D41-D64","v":0},0]
[]
[null,"SHAREHOLDER FUNDS (EQUITY)","START OF FY","Q2 TOTAL","Q4 TOTAL"]
[null,"OWNERS' FUNDS",0,0,0]
[null,"HELD EARNINGS",0,0,0]
[null,"CURRENT-YEAR PROFIT",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL ASSETS",{"$f":"SUM(C69:C72)","v":0},{"$f":"SUM(D69:D72)","v":0},0]

{"sheet":"Cashflow Statement","index":2,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[" ","CASH FLOW STATEMENT"]
[]
[null,"CASH AT BEGINNING OF YEAR - MM/DD/YYYY",0,null,"< - - ENTER AMT"]
[null,"NET INCREASE IN CASH",{"$f":"SUM(C18,C27,C37)","v":0}]
[null,"CASH AT END OF YEAR - MM/DD/YYYY",{"$f":"SUM(C3:C4)","v":0}]
[]
[null,"CASH FLOW FROM OPERATIONS"]
[null,"CASH RECEIPTS FROM CUSTOMERS (enter positive amounts)"]
[null,"CASH SALES",0]
[null,"CASH COLLECTED FROM DEBTORS (CUSTOMERS)",0]
[null,"FUNDING FROM CREDITORS "]
[null,"STOCK PURCHASED NOT YET PAID",0]
[null,"CASH PAID FOR (enter negative amounts)"]
[null,"PROPERTY/EQUIPMENT PURCHASES",0]
[null,"INVESTMENT PURCHASES",0]
[null,"FUNDING TO DEBTORS"]
[null,"SALES MADE NOT YET COLLECTED",0]
[null,"NET CASH FLOW FROM OPERATIONS",{"$f":"SUM(C9:C17)","v":0}]
[]
[null,"INVESTING ACTIVITIES"]
[null,"CASH RECEIPTS FROM (enter positive amounts)"]
[null,"SALE OF PROPERTY/EQUIPMENT",0]
[null,"MATURED INVESTMENTS",0]
[null,"CASH PAID FOR (enter negative amounts)"]
[null,"PURCHASE OF PROPERTY/EQUIPMENT",0]
[null,"PURCHASE OF INVESTMENTS",0]
[null,"NET CASH FLOW FROM INVESTING ACTIVITIES",{"$f":"SUM(C21:C26)","v":0}]
[]
[null,"FINANCING ACTIVITIES"]
[null,"CASH RECEIPTS FROM (enter positive amounts)"]
[null,"INCREASE IN SHORT-TERM DEBT",0]
[null,"INCREASE IN LONG-TERM DEBT",0]
[null,"INCREASE IN EQUITY (proceeds from owners)",0]
[null,"CASH PAID FOR (enter negative amounts)"]
[null,"LOAN REPAYMENT",0]
[null,"DIVIDENDS",0]
[null,"NET CASH FLOW FROM FINANCING ACTIVITIES",{"$f":"SUM(C30:C36)","v":0}]