{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Equipment List","Start Up Costs","Forecast Sheet","Projected Income Statement","Personal Household  Budget"],"not_rendered":{"charts":0,"images":0,"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":"Equipment List","index":0,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,3],[27,0,27,3],[2,0,2,3]]}
["Equipment List"]
[]
["Equipment on Hand"]
[null,null,"Depreciation"]
["Description","Cost/Value","Rate","Depreciation Allowance","Year and Make"]
["Equipment/Machinery",null,null,{"$f":"B6*C6","v":0}]
[null,0]
[null,0]
["Total Equipment / Machinery",{"$f":"SUM(B7:B8)","v":0}]
[]
["Vehicles",null,null,{"$f":"B11*C11","v":0}]
[null,0]
["Total Vehicles",{"$f":"SUM(B12:B12)","v":0}]
[]
["Office Furnishings",null,null,0]
[" ",0,null,0]
[" ",0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
["Total Office Furniture",{"$f":"SUM(B16:B23)","v":0},null,0]
["Sub Total",{"$f":"B9+B13+B24","v":0},null,{"$f":"SUM(D6:D24)","v":0}]
[]
[]
["Equipment Required"]
[null,null,"Depreciation"]
["Description","Cost/Value","Rate","Depreciation Allowance"]
["Equipment/Machinery",null,null,{"$f":"B31*C31","v":0}]
[null,0,null,0]
[null,0,null,0]
["Total Equipment / Machinery",{"$f":"B32+B33","v":0},null,0]
[]
["Vehicles",null,null,0]
[null,0,null,0]
[null,0,null,{"$f":"SUM(D31:D37)","v":0}]
["Total Vehicles",{"$f":"SUM(B37:B38)","v":0}]
[]
["Office Furnishings",null,null,{"$f":"D38+D25","v":0}]
[" ",0]
[" ",0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
["Total Office Furniture",{"$f":"SUM(B42:B49)","v":0}]
["Sub Total",{"$f":"B34+B39+B50","v":0}]

{"sheet":"Start Up Costs","index":1,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Start Up Costs"]
[]
["Hard Costs"]
["Description","Value/Cost"]
[]
["Equipment/Machinery",{"$f":"'Equipment List'!B34","v":0}]
["Vehicles",{"$f":"'Equipment List'!B39","v":0}]
["Office Furnishings",{"$f":"'Equipment List'!B50","v":0}]
["Inventory",{"$f":"0","v":0}]
["Leasehold Improvements",{"$f":"0","v":0}]
["Total  Costs",null,{"$f":"SUM(B6:B10)","v":0}]
[]
["Soft Costs"]
["Description","Value/Cost"]
[]
["Accounting & Legal Fees",0]
["Advertising",0]
["Bank Charges",0]
["Business License",0]
["Insurance Coverage",0]
["Lease Payments",0]
["Materials & Supplies ",0]
["Office Expense",0]
["Repairs & Maintenance",0]
["Telephone ",0]
["Working Capital ",0]
["Total  Costs",null,{"$f":"SUM(B16:B26)","v":0}]
[]
["Total Start Up Costs",null,{"$f":"SUM(C27+C11)","v":0}]
[]
["Less:"]
["Owner's Investment",null,0]
[]
["Total Funding Needed",null,{"$f":"C29-C32","v":0}]

{"sheet":"Forecast Sheet","index":2,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["Cashflow Forecast"]
[null,null,"Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month"]
[null,"Start Up Period",1,2,3,4,5,6,7,8,9,10,11,12,"Total"]
[]
["Monthly Cash In"]
[]
["Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B7:N7)","v":0}]
["Term Loan Proceeds",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Personal Investment - Cash/Credit",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Cash In",{"$f":"SUM(B7:B9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Cash Out"]
[]
["Accounting & Legal Fees",{"$f":"'Start Up Costs'!B16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14:N14)","v":0}]
["Advertising",{"$f":"'Start Up Costs'!B17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15:N15)","v":0}]
["Bank Charges & Interest",{"$f":"'Start Up Costs'!B18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Insurance",{"$f":"'Start Up Costs'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Inventories",{"$f":"'Start Up Costs'!B9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Lease of Premise & Equipment",{"$f":"'Start Up Costs'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Licenses ",{"$f":"'Start Up Costs'!B19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Materials & Supplies",{"$f":"'Start Up Costs'!B22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Office Expenses",{"$f":"'Start Up Costs'!B23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Salaries & Wages",0,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Owner's Drawings",0,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Loan Payments",0,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Purchase of Equipment ",{"$f":"'Start Up Costs'!C11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Repairs & Maintenance",{"$f":"'Start Up Costs'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Telephone",{"$f":"'Start Up Costs'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Travel & Auto",{"$f":"0","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B29:N29)","v":0}]
["Utilities (heat/light/water)",0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
["Total Cash Out",{"$f":"SUM(B14:B30)","v":0},{"$f":"SUM(C14:C33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Cash Flow Reconciliation"]
[]
["Opening Cash Balance",0,{"$f":"B43","v":0},{"$f":"C43","v":0},{"$f":"D43","v":0},0,0,0,0,0,0,0,0,0,{"$f":"B38","v":0}]
["Cash In",{"$f":"B10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cash Out",{"$f":"B34","v":0},{"$f":"C34","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"O34","v":0}]
["Surplus (Deficit)",{"$f":"B39-B40","v":0},{"$f":"C39-C40","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B41:N41)","v":0}]
[]
["Ending Cash Balance",{"$f":"B38+B41","v":0},{"$f":"C38+C41","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"O38+O41","v":0}]

{"sheet":"Projected Income Statement","index":3,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Projected Income Statement"]
[]
["Income"]
["Revenue from Sales",{"$f":"'Forecast Sheet'!O7","v":0}]
["Total Income",null,{"$f":"SUM(B4:B4)","v":0}]
[]
["Cost of Goods Sold"]
["Opening inventory",0]
["Add: purchases ",0]
["Total Inventory Available",{"$f":"SUM(B8:B9)","v":0}]
["Subtract: Closing inventory",0]
["Total Cost of Goods Sold",null,{"$f":"B10-B11","v":0}]
[]
["Gross Profit",null,{"$f":"C5-C12","v":0}]
[]
["Fixed Expenses"]
["Accounting & Legal Fees",{"$f":"'Forecast Sheet'!O14","v":0}]
["Insurance",{"$f":"'Forecast Sheet'!O17","v":0}]
["Interest & Bank Charges",{"$f":"'Forecast Sheet'!O16","v":0}]
["Lease/Rent",0]
["Licenses",{"$f":"'Forecast Sheet'!O20","v":0}]
["Office Expenses",{"$f":"'Forecast Sheet'!O22","v":0}]
["Repairs & Maintenance",{"$f":"'Forecast Sheet'!O27","v":0}]
["Telephone",{"$f":"'Forecast Sheet'!O28","v":0}]
["Total Fixed Expenses",null,{"$f":"SUM(B17:B24)","v":0}]
[]
["Variable Expenses"]
["Advertising",{"$f":"'Forecast Sheet'!O15","v":0}]
["Materials & Supplies ",{"$f":"'Forecast Sheet'!O21","v":0}]
["Other Salaries & Wages",0]
["Travel & Auto",{"$f":"'Forecast Sheet'!O29","v":0}]
["Total Variable Costs",null,{"$f":"SUM(B28:B31)","v":0}]
[]
["Total Expenses",null,{"$f":"C25+C32","v":0}]
[]
[]
["Net Income (Loss)",null,{"$f":"C14-C34","v":0}]

{"sheet":"Personal Household  Budget","index":4,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Personal Household Budget"]
[]
["Annual Home Expenses"]
["Rent or Mortgage Payment",0]
["Property Taxes",0]
["Hydro",0]
["Heat",0]
["Telephone",0]
["Home Insurance",0]
["Repairs & Maintenance of Home",0]
["Sub Total",null,{"$f":"SUM(B3:B10)","v":0}]
[]
["Vehicle Expenses"]
["Vehicle Loan or Lease",0]
["Gas & Oil",0]
["Repairs",0]
["Insurance",0]
["Sub Total",null,{"$f":"SUM(B14:B17)","v":0}]
[]
["Personal Expenses"]
["Childcare",0]
["Dental",0]
["Medical",0]
["Bank Charges",0]
["Clothing",0]
["Food",0]
["Entertainment",0]
["Life Insurance",0]
["Savings ",0]
["Sub Total",null,{"$f":"SUM(B20:B29)","v":0}]
[]
["Total Expenses",null,{"$f":"C30+C18+C11","v":0}]
[]
["Less:"]
[" Income",0]
["Spouse's Net Income",0]
[null,0]
["Total (to be deducted)",null,{"$f":"SUM(B35:B37)","v":0}]
[]
["Total Required of Business",null,{"$f":"C32-C38","v":0}]