{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Financial Plan (Transport)","+10% Scenario (Transport)","-10% Scenario (Transport)"],"not_rendered":{"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Financial Plan (Transport)","index":0,"n_rows":60,"n_cols":38,"rows_kept":60,"merged":[[0,0,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[4,0,4,37],[6,1,6,7],[7,1,7,7],[10,0,10,37],[21,0,21,37],[26,0,26,37],[32,0,32,37]]}
["Northern Development Initiative Trust"]
["Connecting British Columbia Program - Phase Two"]
["Intake 3 - Transport Infrastructure"]
["TEMPLATE 3 - FINANCIAL OPERATIONAL PLAN (Part 1)"]
["Baseline Service Costing"]
[]
["Project Name:"]
["Prepared By:"]
[]
["Item","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 13","Month 14","Month 15","Month 16","Month 17","Month 18","Month 19","Month 20","Month 21","Month 22","Month 23","Month 24","Month 25","Month 26","Month 27","Month 28","Month 29","Month 30","Month 31","Month 32","Month 33","Month 34","Month 35","Month 36","TOTALS"]
["Revenues"]
["Number of estimated Residential Clients (Cumulative)"]
["Monthly estimated revenue per Residential Client"]
["Residential Client Monthly Recurring Revenue",{"$f":"+B12*B13","v":{"v":0,"d":"0.00"}},{"$f":"+C12*C13","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"+AK12*AK13","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B14:AK14)","v":{"v":0,"d":"0.00"}}]
["Residential Client Installation Revenues",{"$nulls":36},{"$f":"SUM(B15:AK15)","v":{"v":0,"d":"0.00"}}]
["Number of estimated business clients (Cumulative)"]
["Monthly estimated revenue per Business Client"]
["Business Client Monthly Recurring Revenue",{"$f":"+B16*B17","v":{"v":0,"d":"0.00"}},{"$f":"+C16*C17","v":{"v":0,"d":"0.00"}},{"$f":"+D16*D17","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B18:AK18)","v":{"v":0,"d":"0.00"}}]
["Business Client Installation Revenues",{"$nulls":36},{"v":0,"d":"0.00"}]
["Gross Revenue",{"$f":"+B14+B18+B19+B15","v":{"v":0,"d":"0.00"}},{"$f":"+C14+C18+C19+C15","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B20:AK20)","v":{"v":0,"d":"0.00"}}]
[]
["Cost of Service"]
["Residential Client Installation Cost",{"$nulls":36},{"$f":"SUM(B23:AK23)","v":{"v":0,"d":"0.00"}}]
["Business Client Installation Cost",{"$nulls":36},{"$f":"SUM(B24:AK24)","v":{"v":0,"d":"0.00"}}]
["Total Cost of Service",{"$f":"SUM(B23:B24)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C23:C24)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B25:AK25)","v":{"v":0,"d":"0.00"}}]
[]
["Implementation Expenses"]
["Training",{"$nulls":36},{"$f":"SUM(B28:AK28)","v":{"v":0,"d":"0.00"}}]
["Other",{"$nulls":36},{"$f":"SUM(B29:AK29)","v":{"v":0,"d":"0.00"}}]
["Other",{"$nulls":36},{"$f":"SUM(B30:AK30)","v":{"v":0,"d":"0.00"}}]
["Total Implementation Expenses",{"$f":"SUM(B28:B30)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C28:C30)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D28:D30)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B31:AK31)","v":{"v":0,"d":"0.00"}}]
[]
["Operating Expenses"]
["Advertising",{"$nulls":36},{"$f":"SUM(B34:AK34)","v":{"v":0,"d":"0.00"}}]
["Bad Debt",{"$nulls":36},{"$f":"SUM(B35:AK35)","v":{"v":0,"d":"0.00"}}]
["Bank Fees",{"$nulls":36},{"v":0,"d":"0.00"}]
["Billing Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Business Insurance",{"$nulls":36},{"v":0,"d":"0.00"}]
["Business License",{"$nulls":36},{"v":0,"d":"0.00"}]
["Churn cost",{"$nulls":36},{"v":0,"d":"0.00"}]
["Contractor Costs",{"$nulls":36},{"$f":"SUM(B41:AK41)","v":{"v":0,"d":"0.00"}}]
["Courier Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Customer Care",{"$nulls":36},{"v":0,"d":"0.00"}]
["Equipment Leases",{"$nulls":36},{"v":0,"d":"0.00"}]
["Office Rental",{"$nulls":36},{"v":0,"d":"0.00"}]
["Loan Interest",{"$nulls":36},{"v":0,"d":"0.00"}]
["Miscellaneous",{"$nulls":36},{"v":0,"d":"0.00"}]
["Miscellaneous Network Charges",{"$nulls":36},{"v":0,"d":"0.00"}]
["Office Supplies",{"$nulls":36},{"v":0,"d":"0.00"}]
["Telecommunications ",{"$nulls":36},{"v":0,"d":"0.00"}]
["Transport Wholesale Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Professional Fees",{"$nulls":36},{"v":0,"d":"0.00"}]
["Salaries & Benefits",{"$nulls":36},{"v":0,"d":"0.00"}]
["Utilities",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Total Operating Expenses",{"$f":"SUM(B34:B57)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C34:C57)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B58:AK58)","v":{"v":0,"d":"0.00"}}]
[]
["Net from Operations",{"$f":"B20-(B25+B31+B58)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]

{"sheet":"+10% Scenario (Transport)","index":1,"n_rows":60,"n_cols":38,"rows_kept":60,"merged":[[0,0,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[4,0,4,37],[6,1,6,7],[7,1,7,7],[10,0,10,37],[21,0,21,37],[26,0,26,37],[32,0,32,37]]}
["Northern Development Initiative Trust"]
["Connecting British Columbia Program - Phase Two"]
["Intake 3 - Transport Infrastructure"]
["TEMPLATE 3 - FINANCIAL OPERATIONAL PLAN (Part 2)"]
["Best Case Costing (+10%) For this scenario, assume no competition is present and you are able to increase your service fees by 10%."]
[]
["Project Name:"]
["Prepared By:"]
[]
["Item","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 13","Month 14","Month 15","Month 16","Month 17","Month 18","Month 19","Month 20","Month 21","Month 22","Month 23","Month 24","Month 25","Month 26","Month 27","Month 28","Month 29","Month 30","Month 31","Month 32","Month 33","Month 34","Month 35","Month 36","TOTALS"]
["Revenues"]
["Number of estimated Residential Clients (Cumulative)"]
["Monthly estimated revenue per Residential Client"]
["Residential Client Monthly Recurring Revenue",{"$f":"+B12*B13","v":{"v":0,"d":"0.00"}},{"$f":"+C12*C13","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"+AK12*AK13","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B14:AK14)","v":{"v":0,"d":"0.00"}}]
["Residential Client Installation Revenues",{"$nulls":36},{"$f":"SUM(B15:AK15)","v":{"v":0,"d":"0.00"}}]
["Number of estimated business clients (Cumulative)"]
["Monthly estimated revenue per Business Client"]
["Business Client Monthly Recurring Revenue",{"$f":"+B16*B17","v":{"v":0,"d":"0.00"}},{"$f":"+C16*C17","v":{"v":0,"d":"0.00"}},{"$f":"+D16*D17","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B18:AK18)","v":{"v":0,"d":"0.00"}}]
["Business Client Installation Revenues",{"$nulls":36},{"v":0,"d":"0.00"}]
["Gross Revenue",{"$f":"+B14+B18+B19+B15","v":{"v":0,"d":"0.00"}},{"$f":"+C14+C18+C19+C15","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B20:AK20)","v":{"v":0,"d":"0.00"}}]
[]
["Cost of Service"]
["Residential Client Installation Cost",{"$nulls":36},{"$f":"SUM(B23:AK23)","v":{"v":0,"d":"0.00"}}]
["Business Client Installation Cost",{"$nulls":36},{"$f":"SUM(B24:AK24)","v":{"v":0,"d":"0.00"}}]
["Total Cost of Service",{"$f":"SUM(B23:B24)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C23:C24)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B25:AK25)","v":{"v":0,"d":"0.00"}}]
[]
["Implementation Expenses"]
["Training",{"$nulls":36},{"$f":"SUM(B28:AK28)","v":{"v":0,"d":"0.00"}}]
["Other",{"$nulls":36},{"$f":"SUM(B29:AK29)","v":{"v":0,"d":"0.00"}}]
["Other",{"$nulls":36},{"$f":"SUM(B30:AK30)","v":{"v":0,"d":"0.00"}}]
["Total Implementation Expenses",{"$f":"SUM(B28:B30)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C28:C30)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D28:D30)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B31:AK31)","v":{"v":0,"d":"0.00"}}]
[]
["Operating Expenses"]
["Advertising",{"$nulls":36},{"$f":"SUM(B34:AK34)","v":{"v":0,"d":"0.00"}}]
["Bad Debt",{"$nulls":36},{"$f":"SUM(B35:AK35)","v":{"v":0,"d":"0.00"}}]
["Bank Fees",{"$nulls":36},{"v":0,"d":"0.00"}]
["Billing Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Business Insurance",{"$nulls":36},{"v":0,"d":"0.00"}]
["Business License",{"$nulls":36},{"v":0,"d":"0.00"}]
["Churn cost",{"$nulls":36},{"v":0,"d":"0.00"}]
["Contractor Costs",{"$nulls":36},{"$f":"SUM(B41:AK41)","v":{"v":0,"d":"0.00"}}]
["Courier Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Customer Care",{"$nulls":36},{"v":0,"d":"0.00"}]
["Equipment Leases",{"$nulls":36},{"v":0,"d":"0.00"}]
["Office Rental",{"$nulls":36},{"v":0,"d":"0.00"}]
["Loan Interest",{"$nulls":36},{"v":0,"d":"0.00"}]
["Miscellaneous",{"$nulls":36},{"v":0,"d":"0.00"}]
["Miscellaneous Network Charges",{"$nulls":36},{"v":0,"d":"0.00"}]
["Office Supplies",{"$nulls":36},{"v":0,"d":"0.00"}]
["Telecommunications ",{"$nulls":36},{"v":0,"d":"0.00"}]
["Transport Wholesale Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Professional Fees",{"$nulls":36},{"v":0,"d":"0.00"}]
["Salaries & Benefits",{"$nulls":36},{"v":0,"d":"0.00"}]
["Utilities",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Total Operating Expenses",{"$f":"SUM(B34:B57)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C34:C57)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B58:AK58)","v":{"v":0,"d":"0.00"}}]
[]
["Net from Operations",{"$f":"B20-(B25+B31+B58)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]

{"sheet":"-10% Scenario (Transport)","index":2,"n_rows":60,"n_cols":38,"rows_kept":60,"merged":[[0,0,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[4,0,4,37],[6,1,6,7],[7,1,7,7],[10,0,10,37],[21,0,21,37],[26,0,26,37],[32,0,32,37]]}
["Northern Development Initiative Trust"]
["Connecting British Columbia Program - Phase Two"]
["Intake 3 - Transport Infrastructure"]
["TEMPLATE 3 - FINANCIAL OPERATIONAL PLAN (Part 3)"]
["Worst Case Costing (-10%) For this scenario, assume strong competition is present and you have to decrease your service fees by 10%."]
[]
["Project Name:"]
["Prepared By:"]
[]
["Item","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 13","Month 14","Month 15","Month 16","Month 17","Month 18","Month 19","Month 20","Month 21","Month 22","Month 23","Month 24","Month 25","Month 26","Month 27","Month 28","Month 29","Month 30","Month 31","Month 32","Month 33","Month 34","Month 35","Month 36","TOTALS"]
["Revenues"]
["Number of estimated Residential Clients (Cumulative)"]
["Monthly estimated revenue per Residential Client"]
["Residential Client Monthly Recurring Revenue",{"$f":"+B12*B13","v":{"v":0,"d":"0.00"}},{"$f":"+C12*C13","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"+AK12*AK13","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B14:AK14)","v":{"v":0,"d":"0.00"}}]
["Residential Client Installation Revenues",{"$nulls":36},{"$f":"SUM(B15:AK15)","v":{"v":0,"d":"0.00"}}]
["Number of estimated business clients (Cumulative)"]
["Monthly estimated revenue per Business Client"]
["Business Client Monthly Recurring Revenue",{"$f":"+B16*B17","v":{"v":0,"d":"0.00"}},{"$f":"+C16*C17","v":{"v":0,"d":"0.00"}},{"$f":"+D16*D17","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B18:AK18)","v":{"v":0,"d":"0.00"}}]
["Business Client Installation Revenues",{"$nulls":36},{"v":0,"d":"0.00"}]
["Gross Revenue",{"$f":"+B14+B18+B19+B15","v":{"v":0,"d":"0.00"}},{"$f":"+C14+C18+C19+C15","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B20:AK20)","v":{"v":0,"d":"0.00"}}]
[]
["Cost of Service"]
["Residential Client Installation Cost",{"$nulls":36},{"$f":"SUM(B23:AK23)","v":{"v":0,"d":"0.00"}}]
["Business Client Installation Cost",{"$nulls":36},{"$f":"SUM(B24:AK24)","v":{"v":0,"d":"0.00"}}]
["Total Cost of Service",{"$f":"SUM(B23:B24)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C23:C24)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B25:AK25)","v":{"v":0,"d":"0.00"}}]
[]
["Implementation Expenses"]
["Training",{"$nulls":36},{"$f":"SUM(B28:AK28)","v":{"v":0,"d":"0.00"}}]
["Other",{"$nulls":36},{"$f":"SUM(B29:AK29)","v":{"v":0,"d":"0.00"}}]
["Other",{"$nulls":36},{"$f":"SUM(B30:AK30)","v":{"v":0,"d":"0.00"}}]
["Total Implementation Expenses",{"$f":"SUM(B28:B30)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C28:C30)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D28:D30)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B31:AK31)","v":{"v":0,"d":"0.00"}}]
[]
["Operating Expenses"]
["Advertising",{"$nulls":36},{"$f":"SUM(B34:AK34)","v":{"v":0,"d":"0.00"}}]
["Bad Debt",{"$nulls":36},{"$f":"SUM(B35:AK35)","v":{"v":0,"d":"0.00"}}]
["Bank Fees",{"$nulls":36},{"v":0,"d":"0.00"}]
["Billing Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Business Insurance",{"$nulls":36},{"v":0,"d":"0.00"}]
["Business License",{"$nulls":36},{"v":0,"d":"0.00"}]
["Churn cost",{"$nulls":36},{"v":0,"d":"0.00"}]
["Contractor Costs",{"$nulls":36},{"$f":"SUM(B41:AK41)","v":{"v":0,"d":"0.00"}}]
["Courier Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Customer Care",{"$nulls":36},{"v":0,"d":"0.00"}]
["Equipment Leases",{"$nulls":36},{"v":0,"d":"0.00"}]
["Office Rental",{"$nulls":36},{"v":0,"d":"0.00"}]
["Loan Interest",{"$nulls":36},{"v":0,"d":"0.00"}]
["Miscellaneous",{"$nulls":36},{"v":0,"d":"0.00"}]
["Miscellaneous Network Charges",{"$nulls":36},{"v":0,"d":"0.00"}]
["Office Supplies",{"$nulls":36},{"v":0,"d":"0.00"}]
["Telecommunications ",{"$nulls":36},{"v":0,"d":"0.00"}]
["Transport Wholesale Costs",{"$nulls":36},{"v":0,"d":"0.00"}]
["Professional Fees",{"$nulls":36},{"v":0,"d":"0.00"}]
["Salaries & Benefits",{"$nulls":36},{"v":0,"d":"0.00"}]
["Utilities",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Other",{"$nulls":36},{"v":0,"d":"0.00"}]
["Total Operating Expenses",{"$f":"SUM(B34:B57)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C34:C57)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B58:AK58)","v":{"v":0,"d":"0.00"}}]
[]
["Net from Operations",{"$f":"B20-(B25+B31+B58)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]