{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["First-Year Budget Calculator"],"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":"First-Year Budget Calculator","index":0,"n_rows":67,"n_cols":17,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,1,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[3,10,3,11],[4,10,4,11],[5,10,5,11],[2,13,2,16],[3,13,3,14],[3,15,3,16],[19,15,20,15],[19,16,20,16],[4,13,5,13],[4,14,5,14],[6,13,7,13],[6,14,7,14],[8,13,9,13],[8,14,9,14],[10,13,11,13],[10,14,11,14],[12,13,13,13],[12,14,13,14],[14,13,15,13],[4,16,5,16],[6,16,7,16],[10,16,11,16],[10,15,11,15],[12,15,13,15],[12,16,13,16],[4,15,5,15],[6,15,7,15],[66,1,66,16],[14,16,15,16],[16,15,17,15],[16,16,17,16],[8,15,9,15],[8,16,9,16],[14,14,15,14],[16,13,17,13],[16,14,17,14],[14,15,15,15]]}
[" ","FIRST-YEAR BUDGET CALCULATOR"]
[]
[null,"B U S I N E S S ",null,null,null,null,null,null,null,"P E R S O N A L",null,null,null,"F I R S T-Y E A R   B U D G E T   C A L C U L A T I O N S"]
[null,"BUSINESS EXPENSE","START-UP COST","MONTHLY COST",null,"ESTIMATED BUSINESS INCOME","YEARLY TOTAL",null,null,"ESTIMATED PERSONAL INCOME","YEARLY TOTAL",null,null,"BUSINESS INCOME/EXPENSES",null,"PERSONAL INCOME/EXPENSES"]
[null,"GENERAL/ADMIN",null,null,null,"ESTIMATED FIRST-YEAR INCOME",0,null,null,"ESTIMATED HOUSEHOLD INCOME",0,null,null,"TOTAL START-UP COSTS",{"$f":"SUM(C65,G30)","v":0},"TOTAL ONE-TIME COSTS",{"$f":"K59","v":0}]
[null,"BANKING FEES",0,0,null,"AVAILABLE CASH/SAVINGS/OTHER",0,null,null,"AVAILABLE CASH/SAVINGS/OTHER",0]
[null,"CONSULT FEES",0,0,null,null,null,null,null,null,null,null,null,"TOTAL RECURRING MONTHLY COSTS               (1 YR = 12 MO)",{"$f":"SUM(D65,H30)*12","v":0},"TOTAL RECURRING MONTHLY COSTS               (1 YR = 12 MO)",{"$f":"L59*12","v":0}]
[null,"OFFICE SUPPLIES",0,0,null,"EXPENSES - EMPLOYMENT","START-UP COST","MONTHLY COST",null,"PERSONAL EXPENSE","ONE-TIME COST","MONTHLY COST"]
[null,"LICENSE FEES",0,0,null,"EMPLOYMENT – PERMANENT",null,null,null,"SELF-CARE",null,null,null,"TOTAL BUSINESS EXPENSES",{"$f":"SUM(O5:O8)","v":0},"TOTAL HOUSEHOLD EXPENSES",{"$f":"SUM(Q5:Q8)","v":0}]
[null,"BUSINESS INSURANCE",0,0,null,"SALARIES/WAGES",0,0,null,"FOOD",0,0]
[null,"OTHER",0,0,null,"BONUS PAY",0,0,null,"CLOTHING",0,0,null,"ESTIMATED FIRST-YEAR BUSINESS INCOME",{"$f":"G5","v":0},"ESTIMATED FIRST-YEAR HOUSEHOLD INCOME",{"$f":"K5","v":0}]
[null,"OTHER",0,0,null,"INCREASES",0,0,null,"PERSONAL CARE",0,0]
[null,"TOTAL GENERAL/ADMIN",{"$f":"SUM(C6:C12)","v":0},{"$f":"SUM(D6:D12)","v":0},null,"BENEFITS",0,0,null,"CHILD CARE",0,0,null,"BUSINESS FIRST-YEAR PROFIT/LOSS",{"$f":"O11-O9","v":0},"HOUSEHOLD FIRST-YEAR PROFIT/LOSS",{"$f":"Q11-Q9","v":0}]
[null,"OPERATIONS",null,null,null,"INSURANCE",0,0,null,"EDUCATION",0,0]
[null,"TRAVEL",0,0,null,"RECRUITMENT",0,0,null,"ENTERTAINMENT",0,0,null,"AVAILABLE CASH/ SAVINGS/OTHER",{"$f":"G6","v":0},"AVAILABLE CASH/ SAVINGS/OTHER",{"$f":"K6","v":0}]
[null,"LAUNDRY",0,0,null,"OTHER",0,0,null,"INSURANCE",0,0]
[null,"TRANSPORTATION",0,0,null,"OTHER",0,0,null,"MEDICAL EXPENSES ",0,0,null,"BUSINESS BALANCE",{"$f":"O13+O15","v":0},"PERSONAL BALANCE",{"$f":"SUM(Q13:Q16)","v":0}]
[null,"CLEANING SERVICES & SUPPLIES",0,0,null,"TOTAL PERMANENT EMPLOYMENT",{"$f":"SUM(G10:G17)","v":0},{"$f":"SUM(H10:H17)","v":0},null,"DENTAL EXPENSES",0,0]
[null,"SUBSCRIPTIONS",0,0,null,"EMPLOYMENT – CASUAL",null,null,null,"OTHER",0,0]
[null,"KITCHENETTE/COFFEE/SNACKS",0,0,null,"SALARIES/WAGES",0,0,null,"OTHER",0,0,null,null,null,"YEAR-END BALANCE (BUSINESS + PERSONAL)",{"$f":"SUM(O17,Q17)","v":0}]
[null,"KITCHENETTE EQUIPMENT",0,0,null,"BONUS PAY",0,0,null,"OTHER",0,0]
[null,"OTHER",0,0,null,"INCREASES",0,0,null,"OTHER",0,0]
[null,"OTHER",0,0,null,"INSURANCE",0,0,null,"TOTAL GENERAL/ADMIN",{"$f":"SUM(K10:K22)","v":0},{"$f":"SUM(L10:L22)","v":0}]
[null,"TOTAL OPERATIONS",{"$f":"SUM(C15:C23)","v":0},{"$f":"SUM(D15:D23)","v":0},null,"BENEFITS",0,0,null,"HOME"]
[null,"MARKETING/PROMO",null,null,null,"RECRUITMENT",0,0,null,"RENT/LEASE",0,0]
[null,"ADVERTISING",0,0,null,"OTHER",0,0,null,"HOME PHONE",0,0]
[null,"PROMO",0,0,null,"OTHER",0,0,null,"INTERNET",0,0]
[null,"OTHER",0,0,null,"OTHER",0,0,null,"ELECTRIC",0,0]
[null,"OTHER",0,0,null,"TOTAL CASUAL EMPLOYMENT",{"$f":"SUM(G20:G28)","v":0},{"$f":"SUM(H20:H28)","v":0},null,"GAS",0,0]
[null,"TOTAL MARKETING/PROMO",{"$f":"SUM(C26:C29)","v":0},{"$f":"SUM(D26:D29)","v":0},null,"TOTAL EXPENSES – EMPLOYMENT",{"$f":"SUM(G18,G29)","v":0},{"$f":"SUM(H18,H29)","v":0},null,"WATER/SEWAGE",0,0]
[null,"WEBSITE/MOBILE APP",null,null,null,null,null,null,null,"WASTE REMOVAL",0,0]
[null,"DOMAIN",0,0,null,null,null,null,null,"REPAIR/MAINTENANCE",0,0]
[null,"HOSTING",0,0,null,null,null,null,null,"HOME/RENTAL INSURANCE",0,0]
[null,"OTHER",0,0,null,null,null,null,null,"SECURITY",0,0]
[null,"OTHER",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"TOTAL WEBSITE/MOBILE APP",{"$f":"SUM(C32:C35)","v":0},{"$f":"SUM(D32:D35)","v":0},null,null,null,null,null,"OTHER",0,0]
[null,"OCCUPANCY",null,null,null,null,null,null,null,"OTHER",0,0]
[null,"RENT/LEASE",0,0,null,null,null,null,null,"TOTAL HOME",{"$f":"SUM(K25:K37)","v":0},{"$f":"SUM(L25:L37)","v":0}]
[null,"PHONE",0,0,null,null,null,null,null,"TRANSPORTATION"]
[null,"INTERNET",0,0,null,null,null,null,null,"FUEL",0,0]
[null,"ELECTRIC",0,0,null,null,null,null,null,"SERVICE",0,0]
[null,"GAS",0,0,null,null,null,null,null,"PARTS/MAINTENANCE",0,0]
[null,"WATER/SEWAGE",0,0,null,null,null,null,null,"INSURANCE",0,0]
[null,"WASTE REMOVAL",0,0,null,null,null,null,null,"REGISTRATION",0,0]
[null,"RECYCLING/SHREDDING",0,0,null,null,null,null,null,"TOLLS/TRANSIT PASSES",0,0]
[null,"REPAIR/MAINTENANCE",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"PROPERTY INSURANCE",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"SECURITY",0,0,null,null,null,null,null,"TOTAL TRANSPORTATION",{"$f":"SUM(K40:K47)","v":0},{"$f":"SUM(L40:L47)","v":0}]
[null,"OTHER",0,0,null,null,null,null,null,"ADDITIONAL"]
[null,"OTHER",0,0,null,null,null,null,null,"VACATION",0,0]
[null,"TOTAL OCCUPANCY",{"$f":"SUM(C38:C50)","v":0},{"$f":"SUM(D38:D50)","v":0},null,null,null,null,null,"GIFTING/ CHARITY/ TITHING",0,0]
[null,"INVENTORY",null,null,null,null,null,null,null,"PETS",0,0]
[null,"STARTING INVENTORY",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"REPLACEMENT INVENTORY",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"COST OF GOODS",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"OTHER",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"OTHER",0,0,null,null,null,null,null,"OTHER",0,0]
[null,"TOTAL AUTOMOTIVE",{"$f":"SUM(C53:C57)","v":0},{"$f":"SUM(D53:D57)","v":0},null,null,null,null,null,"TOTAL ADDITIONAL",{"$f":"SUM(K50:K57)","v":0},{"$f":"SUM(L50:L57)","v":0}]
[null,"ADDITIONAL",null,null,null,null,null,null,null,"TOTAL EXPENSES – PERSONAL",{"$f":"SUM(K23,K38,K48,K58)","v":0},{"$f":"SUM(L23,L38,L48,L58)","v":0}]
[null,"OTHER",0,0]
[null,"OTHER",0,0]
[null,"OTHER",0,0]
[null,"OTHER",0,0]
[null,"TOTAL ADDITIONAL",{"$f":"SUM(C60:C63)","v":0},{"$f":"SUM(D60:D63)","v":0}]
[null,"TOTAL EXPENSES – OPERATIONAL",{"$f":"SUM(C13,C24,C30,C36,C51,C58,C64)","v":0},{"$f":"SUM(D13,D24,D30,D36,D51,D58,D64)","v":0}]
[]
[null,"CLICK HERE TO CREATE YOUR FIRST-YEAR BUDGET CALCULATOR WITH SMARTSHEET"]