{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Start","Overview","Start-up costs","Profit & loss "],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":9,"n_cols":2,"rows_kept":9}
[]
[null,"ABOUT THIS TEMPLATE"]
[null,"Create a Business Start-up Financial Plan using this template. "]
[null,"Get an overview of a financial plan in Overview worksheet. "]
[null,"Use the Start-up Costs Template and P&L Template worksheets to keep account of Start-up Costs and Profit & Loss. "]
[null,"Start-Up Costs Example and P&L Example worksheets contain sample data in tables."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in all worksheets. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font color."]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Overview","index":1,"n_rows":8,"n_cols":2,"rows_kept":8}
[]
[null,"BUSINESS START-UP FINANCIAL PLAN"]
[null,"Creating a financial plan is where all of the business planning comes together. Once you have identified your product, the target market, and target customers, along with pricing, you are ready to begin forecasting costs, sales, and profit. These items along with your assumptions, will help you estimate your sales forecast. The other side of the business will be what expenses you expect to incur. This is important on an ongoing basis to see when you are profitable. It is also important as you start your business, to know what expenses you will need to fund before customer sales or the cash they generate is received. "]
[null,"Projected Start-Up Costs: The table in the next tab, Start-Up Costs Template, provides a blank template with some instructions for getting started. The next tab, Start-Up Costs Example, shows a sample of ongoing and one-time cost items that you might need to open your business. Many businesses are paid on credit over time and don’t have cash coming in immediately. It is important to estimate when cash will begin to flow into the company by making an assumption about how many months of recurring items, in addition to one-time expense, you will have to fund out of savings or an initial investment."]
[null,"Projected Profit and Loss Model: In the tab, label P&L Template, you will find a blank template to do Sales Forecasting and a Profit and Loss Model. The next tab, P&L Example, shows a sample of the projections a small business is forecasting for their first 12 months of operations. The top portion of the table in each model shows projected sales and gross profit. This is a good place to begin creating your sales forecast. The next section, below, itemizes the recurring expenses you are projecting for the same months. These should be consistent with the estimated start-up costs you completed in the prior section. At the bottom of this model, you will begin to see when you are becoming profitable and what expense items are the most impactful to your profitability. "]
[null,"Keep track of your assumptions that you make for estimating Revenues and Cost of Goods Sold. For businesses that have not begun to operate yet, you should have an understanding of how to estimate these for your product or service. Some estimating guidelines are below: "]
[null,"Revenues: Begin by determining from your target market (the group of prospective customers, businesses or consumers) how many of these would be targets in the first year. What percentage of these do you expect to close? What is an average transaction for them to purchase your product or service? How many can you do in the first month, the second, and so on? You may want to start with a number in the first month and grow it by a percentage, say 10%. As an example, if you sell cleaning services to small businesses in your town and there are 500 businesses that you think need the service. If the average contract is for $250/month, then you need to estimate how many businesses you can sign to a contract in each month for the first year. "]
[null,"Cost of Goods Sold (COGS): This should be calculated for products and some services. It is the included cost to produce the product. For instance, if you sell clothing, the COGS would be what price you paid to buy the clothing from a manufacturer. If you make them yourself, it would be the cost of the materials and labour to make them. For services, it would be the direct labour cost for an hour of billable work. Everything below Gross Profit on the P&L are fixed or overhead costs for the overall business, such as rent or telephone or even marketing. "]

{"sheet":"Start-up costs","index":2,"n_rows":12,"n_cols":6,"rows_kept":12}
[]
[null,"START-UP COSTS"]
[null,{"$f":"TODAY()","v":"2023-06-07"}]
[]
[null,"COST ITEMS","MONTHS","COST/ MONTH","ONE-TIME COST","TOTAL COST"]
[null,"Advertising/marketing",3,{"v":300,"d":"$300"},{"v":2000,"d":"$2,000"},{"$f":"(C6*D6)+IF(E6>0,E6,0)","v":{"v":2900,"d":"$2,900"}}]
[null,"Employee salaries",4,{"v":3500,"d":"$3,500"},{"v":2,"d":"$2"},{"$f":"(C7*D7)+IF(E7>0,E7,0)","v":{"v":14002,"d":"$14,002"}}]
[null,"Employee payroll taxes and benefits",4,{"v":500,"d":"$500"},{"v":2000,"d":"$2,000"},{"v":4000,"d":"$4,000"}]
[null,"Rent/lease payments/utilities",4,{"v":750,"d":"$750"},{"v":3000,"d":"$3,000"},{"v":6000,"d":"$6,000"}]
[null,"Postage/shipping",1,{"v":25,"d":"$25"},{"v":25,"d":"$25"},{"v":50,"d":"$50"}]
[]
[null,"ESTIMATED START-UP BUDGET",{"$nulls":3},{"$f":"SUM(F7:F10)","v":{"v":24052,"d":"$24,052"}}]

{"sheet":"Profit & loss ","index":3,"n_rows":23,"n_cols":15,"rows_kept":23}
[]
[null,"START-UP COSTS"]
[null,{"$f":"TODAY()","v":"2023-06-07"}]
[]
[null,"REVENUE","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YTD"]
[null,"Estimated product sales",{"v":8000,"d":"$8,000"},{"v":13000,"d":"$13,000"},{"v":16000,"d":"$16,000"},{"v":7000,"d":"$7,000"},{"v":14500,"d":"$14,500"},{"v":16400,"d":"$16,400"},{"v":22500,"d":"$22,500"},{"v":23125,"d":"$23,125"},{"v":24549,"d":"$24,549"},{"v":22000,"d":"$22,000"},{"v":25000,"d":"$25,000"},{"v":27349,"d":"$27,349"},{"$f":"SUM(C6:N6)","v":{"v":219423,"d":"$219,423"}}]
[null,"Less sales returns & discounts",{"v":0,"d":"$0"},{"v":-350,"d":"($350)"},{"v":0,"d":"$0"},{"v":-206,"d":"($206)"},{"v":-234,"d":"($234)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":-280,"d":"($280)"},{"v":-1200,"d":"($1,200)"},{"v":-1600,"d":"($1,600)"},{"v":0,"d":"$0"},{"v":-2400,"d":"($2,400)"},{"$f":"SUM(C7:N7)","v":{"v":-6270,"d":"($6,270)"}}]
[null,"Service revenue",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":250,"d":"$250"},{"v":350,"d":"$350"},{"v":100,"d":"$100"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":1245,"d":"$1,245"},{"v":1360,"d":"$1,360"},{"v":3305,"d":"$3,305"}]
[null,"Other revenue ",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":1500,"d":"$1,500"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":1500,"d":"$1,500"}]
[null,"Net sales",{"$f":"SUBTOTAL(109,'Profit & loss '!$C$6:$C$9)","v":{"v":8000,"d":"$8,000"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$D$6:$D$9)","v":{"v":12650,"d":"$12,650"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$E$6:$E$9)","v":{"v":16000,"d":"$16,000"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$F$6:$F$9)","v":{"v":6794,"d":"$6,794"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$G$6:$G$9)","v":{"v":14266,"d":"$14,266"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$H$6:$H$9)","v":{"v":16650,"d":"$16,650"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$I$6:$I$9)","v":{"v":22850,"d":"$22,850"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$J$6:$J$9)","v":{"v":24445,"d":"$24,445"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$K$6:$K$9)","v":{"v":23349,"d":"$23,349"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$L$6:$L$9)","v":{"v":20400,"d":"$20,400"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$M$6:$M$9)","v":{"v":26245,"d":"$26,245"}},{"$f":"SUBTOTAL(109,'Profit & loss '!$N$6:$N$9)","v":{"v":26309,"d":"$26,309"}},{"$f":"SUM('Profit & loss '!$C$10:$N$10)","v":{"v":217958,"d":"$217,958"}}]
[null,"Cost of goods sold",{"$f":"C6*0.4","v":{"v":3200,"d":"$3,200"}},{"v":5200,"d":"$5,200"},{"v":6400,"d":"$6,400"},{"v":2800,"d":"$2,800"},{"v":5800,"d":"$5,800"},{"v":6560,"d":"$6,560"},{"v":9000,"d":"$9,000"},{"v":9250,"d":"$9,250"},{"v":9819.6,"d":"$9,820"},{"v":8800,"d":"$8,800"},{"v":10000,"d":"$10,000"},{"v":10939.6,"d":"$10,940"},{"$f":"SUM(C11:N11)","v":{"v":87769.20000000001,"d":"$87,769"}}]
[null,"Gross profit",{"$f":"IFERROR('Profit & loss '!$C$10-C11,\"\")","v":{"v":4800,"d":"$4,800"}},{"$f":"IFERROR('Profit & loss '!$D$10-D11,\"\")","v":{"v":7450,"d":"$7,450"}},{"$f":"IFERROR('Profit & loss '!$E$10-E11,\"\")","v":{"v":9600,"d":"$9,600"}},{"$f":"IFERROR('Profit & loss '!$F$10-F11,\"\")","v":{"v":3994,"d":"$3,994"}},{"$f":"IFERROR('Profit & loss '!$G$10-G11,\"\")","v":{"v":8466,"d":"$8,466"}},{"$f":"IFERROR('Profit & loss '!$H$10-H11,\"\")","v":{"v":10090,"d":"$10,090"}},{"$f":"IFERROR('Profit & loss '!$I$10-I11,\"\")","v":{"v":13850,"d":"$13,850"}},{"$f":"IFERROR('Profit & loss '!$J$10-J11,\"\")","v":{"v":15195,"d":"$15,195"}},{"$f":"IFERROR('Profit & loss '!$K$10-K11,\"\")","v":{"v":13529.4,"d":"$13,529"}},{"$f":"IFERROR('Profit & loss '!$L$10-L11,\"\")","v":{"v":11600,"d":"$11,600"}},{"$f":"IFERROR('Profit & loss '!$M$10-M11,\"\")","v":{"v":16245,"d":"$16,245"}},{"$f":"IFERROR('Profit & loss '!$N$10-N11,\"\")","v":{"v":15369.4,"d":"$15,369"}},{"$f":"SUM(C12:N12)","v":{"v":130188.79999999999,"d":"$130,189"}}]
[]
[null,"EXPENSES","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YTD"]
[null,"Salaries & wages",{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},{"v":3500,"d":"$3,500"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":8000,"d":"$8,000"},{"v":9000,"d":"$9,000"},{"v":9000,"d":"$9,000"},{"v":9000,"d":"$9,000"},{"v":9000,"d":"$9,000"},{"v":9000,"d":"$9,000"},{"$f":"SUM(C15:N15)","v":{"v":76500,"d":"$76,500"}}]
[null,"Marketing/advertising",{"v":400,"d":"$400"},{"v":450,"d":"$450"},{"v":450,"d":"$450"},{"v":450,"d":"$450"},{"v":900,"d":"$900"},{"v":900,"d":"$900"},{"v":900,"d":"$900"},{"v":900,"d":"$900"},{"v":900,"d":"$900"},{"v":900,"d":"$900"},{"v":1200,"d":"$1,200"},{"v":1200,"d":"$1,200"},{"$f":"SUM(C16:N16)","v":{"v":9550,"d":"$9,550"}}]
[null,"Sales commissions",{"v":250,"d":"$250"},{"v":650,"d":"$650"},{"v":800,"d":"$800"},{"v":350,"d":"$350"},{"v":725,"d":"$725"},{"v":820,"d":"$820"},{"v":1125,"d":"$1,125"},{"v":1156.25,"d":"$1,156"},{"v":1227.45,"d":"$1,227"},{"v":1100,"d":"$1,100"},{"v":1250,"d":"$1,250"},{"v":1367.45,"d":"$1,367"},{"v":10821.150000000001,"d":"$10,821"}]
[null,"Rent",{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":15000,"d":"$15,000"}]
[null,"Total expenses",{"$f":"IF(SUM(C15:C18)=0,\"\",SUM(C15:C18))","v":{"v":4400,"d":"$4,400"}},{"v":4850,"d":"$4,850"},{"v":6000,"d":"$6,000"},{"v":7050,"d":"$7,050"},{"v":7875,"d":"$7,875"},{"v":7970,"d":"$7,970"},{"v":11275,"d":"$11,275"},{"v":12306.25,"d":"$12,306"},{"v":12377.45,"d":"$12,377"},{"v":12250,"d":"$12,250"},{"v":12700,"d":"$12,700"},{"v":12817.45,"d":"$12,817"},{"$f":"SUM('Profit & loss '!$C$19:$N$19)","v":{"v":111871.15,"d":"$111,871"}}]
[null,"Income before taxes",{"$f":"IFERROR('Profit & loss '!$C$12-'Profit & loss '!$C$19,\"\")","v":{"v":400,"d":"$400"}},{"$f":"IFERROR('Profit & loss '!$D$12-'Profit & loss '!$D$19,\"\")","v":{"v":2600,"d":"$2,600"}},{"$f":"IFERROR('Profit & loss '!$E$12-'Profit & loss '!$E$19,\"\")","v":{"v":3600,"d":"$3,600"}},{"$f":"IFERROR('Profit & loss '!$F$12-'Profit & loss '!$F$19,\"\")","v":{"v":-3056,"d":"($3,056)"}},{"$f":"IFERROR('Profit & loss '!$G$12-'Profit & loss '!$G$19,\"\")","v":{"v":591,"d":"$591"}},{"$f":"IFERROR('Profit & loss '!$H$12-'Profit & loss '!$H$19,\"\")","v":{"v":2120,"d":"$2,120"}},{"$f":"IFERROR('Profit & loss '!$I$12-'Profit & loss '!$I$19,\"\")","v":{"v":2575,"d":"$2,575"}},{"$f":"IFERROR('Profit & loss '!$J$12-'Profit & loss '!$J$19,\"\")","v":{"v":2888.75,"d":"$2,889"}},{"$f":"IFERROR('Profit & loss '!$K$12-'Profit & loss '!$K$19,\"\")","v":{"v":1151.949999999999,"d":"$1,152"}},{"$f":"IFERROR('Profit & loss '!$L$12-'Profit & loss '!$L$19,\"\")","v":{"v":-650,"d":"($650)"}},{"$f":"IFERROR('Profit & loss '!$M$12-'Profit & loss '!$M$19,\"\")","v":{"v":3545,"d":"$3,545"}},{"$f":"IFERROR('Profit & loss '!$N$12-'Profit & loss '!$N$19,\"\")","v":{"v":2551.949999999999,"d":"$2,552"}},{"$f":"SUM(C20:N20)","v":{"v":18317.649999999998,"d":"$18,318"}}]
[null,"Income tax expense",{"$f":"C20*0.15","v":{"v":60,"d":"$60"}},{"v":390,"d":"$390"},{"$f":"E20*0.15","v":{"v":540,"d":"$540"}},{"$f":"F20*0.15","v":{"v":-458.4,"d":"($458)"}},{"$f":"G20*0.15","v":{"v":88.64999999999999,"d":"$89"}},{"$f":"H20*0.15","v":{"v":318,"d":"$318"}},{"$f":"I20*0.15","v":{"v":386.25,"d":"$386"}},{"$f":"J20*0.15","v":{"v":433.3125,"d":"$433"}},{"$f":"K20*0.15","v":{"v":172.79249999999982,"d":"$173"}},{"$f":"L20*0.15","v":{"v":-97.5,"d":"($98)"}},{"$f":"M20*0.15","v":{"v":531.75,"d":"$532"}},{"$f":"N20*0.15","v":{"v":382.79249999999985,"d":"$383"}},{"$f":"SUM('Profit & loss '!$C$21:$N$21)","v":{"v":2747.6474999999996,"d":"$2,748"}}]
[]
[null,"NET INCOME",{"$f":"IFERROR(C20-'Profit & loss '!$C$21,\" \")","v":{"v":340,"d":"$340"}},{"$f":"IFERROR(D20-'Profit & loss '!$D$21,\" \")","v":{"v":2210,"d":"$2,210"}},{"$f":"IFERROR(E20-'Profit & loss '!$E$21,\"\")","v":{"v":3060,"d":"$3,060"}},{"$f":"IFERROR(F20-'Profit & loss '!$F$21,\"\")","v":{"v":-2597.6,"d":"($2,598)"}},{"$f":"IFERROR(G20-'Profit & loss '!$G$21,\"\")","v":{"v":502.35,"d":"$502"}},{"$f":"IFERROR(H20-'Profit & loss '!$H$21,\"\")","v":{"v":1802,"d":"$1,802"}},{"$f":"IFERROR(I20-'Profit & loss '!$I$21,\"\")","v":{"v":2188.75,"d":"$2,189"}},{"$f":"IFERROR(J20-'Profit & loss '!$J$21,\"\")","v":{"v":2455.4375,"d":"$2,455"}},{"$f":"IFERROR(K20-'Profit & loss '!$K$21,\"\")","v":{"v":979.1574999999991,"d":"$979"}},{"$f":"IFERROR(L20-'Profit & loss '!$L$21,\"\")","v":{"v":-552.5,"d":"($553)"}},{"$f":"IFERROR(M20-'Profit & loss '!$M$21,\"\")","v":{"v":3013.25,"d":"$3,013"}},{"$f":"IFERROR(N20-'Profit & loss '!$N$21,\"\")","v":{"v":2169.157499999999,"d":"$2,169"}},{"$f":"IFERROR(O20-'Profit & loss '!$O$21,\"\")","v":{"v":15570.002499999999,"d":"$15,570"}}]