{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Start","Overview","Start-Up Costs Template","Start-Up Costs Example","P&L Template","P&L Example"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[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":7,"n_cols":2,"rows_kept":7}
["This worksheet provides an overview of business financial plan, estimating guidelines, and instructions on how to use the templates to calculate Start-up Costs and Profit or Loss. Title of the worksheet is in cell at right. Other helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.","BUSINESS START-UP FINANCIAL PLAN"]
["An overview of business plan is in cell at right.","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. "]
["An overview of Projected Start-Up Costs is in cell at right.","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.  "]
["An overview of Projected Profit and Loss Model is in cell at right.","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. "]
["Few guidelines are in cell at right.","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: "]
["Guidelines on estimating Revenues are in cell at right.","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. "]
["Guidelines on estimating Costs of Goods Sold are in cell at right.","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 Template","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,2,1,5]]}
["This worksheet contains a template to calculate Start-up costs and Estimated Start-up Budget. Title of the worksheet is in cell at right. Other helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.","START-UP COSTS"]
["Business name is in cell at right and Date in cell C2. Next instruction is in cell A4.","Your Coffee Shop",{"$f":"TODAY()","v":"2018-06-26"}]
[]
["Enter details in Start Up table starting in cell at right to calculate the Estimated Start-up Budget.","COST ITEMS","MONTHS","COST/ MONTH","ONE-TIME COST","TOTAL COST"]
[null,"Advertising/Marketing",{"$nulls":3},{"$f":"(C5*D5)+IF(E5>0,E5,0)","v":{"v":0,"d":"$0"}}]
[null,"Employee Salaries",{"$nulls":3},{"$f":"(C6*D6)+IF(E6>0,E6,0)","v":{"v":0,"d":"$0"}}]
[null,"Employee Payroll Taxes and Benefits",{"$nulls":3},{"v":0,"d":"$0"}]
[null,"Rent/Lease Payments/Utilities",{"$nulls":3},{"v":0,"d":"$0"}]
[null,"Postage/Shipping",{"$nulls":3},{"v":0,"d":"$0"}]
[null,"ESTIMATED START-UP BUDGET",{"$nulls":3},{"$f":"SUBTOTAL(109,StartUp[TOTAL COST])","v":0}]

{"sheet":"Start-Up Costs Example","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,2,1,5],[2,1,2,5]]}
["This worksheet contains sample data in the template from previous worksheet. Title of the worksheet is in cell at right. Other helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.","START-UP COSTS"]
["Business name is in cell at right and Date in cell C2. Next instruction is in cell A4.",{"$f":"'Start-Up Costs Template'!B2","v":"Your Coffee Shop"},{"$f":"TODAY()","v":"2018-06-26"}]
[]
["Cost Items, Months, Cost per Month, and One-time Cost are in Start Up table starting in cell at right. Total Cost and Estimated Start-up Budget are auto calculated.","COST ITEMS","MONTHS","COST/ MONTH","ONE-TIME COST","TOTAL COST"]
[null,"Advertising/Marketing",3,{"v":300,"d":"$300"},{"v":2000,"d":"$2,000"},{"$f":"(C5*D5)+IF(E5>0,E5,0)","v":{"v":2900,"d":"$2,900"}}]
[null,"Employee Salaries",4,{"v":3500,"d":"$3,500"},{"v":2,"d":"$2"},{"$f":"(C6*D6)+IF(E6>0,E6,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(F6:F9)","v":{"v":24052,"d":"$24,052"}}]

{"sheet":"P&L Template","index":4,"n_rows":24,"n_cols":15,"rows_kept":24,"merged":[[1,2,1,14],[2,1,2,14],[11,1,11,14],[21,1,21,14],[23,1,23,14]]}
["This worksheet contains a template to calculate Total Expenses and Net Income. Title of the worksheet is in cell at right. Other helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.","START-UP COSTS"]
["Business name is in cell at right and Date in cell C2. Next instruction is in cell A4.",{"$f":"'Start-Up Costs Template'!B2","v":"Your Coffee Shop"},{"$f":"TODAY()","v":"2018-06-26"}]
[]
["Enter details in Sample Revenue table starting in cell at right to calculate Net Sales, Costs of Goods Sold and Gross Profit. Next instruction is in cell A10.","REVENUE","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YTD"]
[null,"Estimated Product Sales",{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(C5:N5)","v":{"v":0,"d":"$0"}}]
[null,"Less Sales Returns & Discounts",{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(C6:N6)","v":{"v":0,"d":"$0"}}]
[null,"Service 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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Net Sales",{"$f":"SUBTOTAL(109,SampleRevenue[JAN])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[FEB])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[MAR])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[APR])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[MAY])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[JUN])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[JUL])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[AUG])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[SEP])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[OCT])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[NOV])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,SampleRevenue[DEC])","v":{"v":0,"d":"$0"}},{"$f":"SUM(SampleRevenue[[#Totals],[JAN]:[DEC]])","v":{"v":0,"d":"$0"}}]
["Cost of Goods Sold label is in cell at right. Cost of Goods Sold for each month and Year to Date are auto calculated in cells C10 through O10.","Cost of Goods Sold",{"$f":"C5*0.4","v":{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Gross Profit label is in cell at right. Gross Profit for each month and Year to Date are auto calculated in cells C11 through O11. Next instruction is in cell A13.","Gross Profit",{"$f":"IFERROR(SampleRevenue[[#Totals],[JAN]]-C10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[FEB]]-D10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[MAR]]-E10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[APR]]-F10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[MAY]]-G10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[JUN]]-H10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[JUL]]-I10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[AUG]]-J10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[SEP]]-K10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[OCT]]-L10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[NOV]]-M10,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SampleRevenue[[#Totals],[DEC]]-N10,\"\")","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[]
["Enter details in Sample Expenses table starting in cell at right to calculate Total Expenses, Income Before Taxes and Income Tax Expense. Next instruction is in cell A20.","EXPENSES","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YTD"]
[null,"Salaries & Wages",{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(C14:N14)","v":{"v":0,"d":"$0"}}]
[null,"Marketing/Advertising",{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(C15:N15)","v":{"v":0,"d":"$0"}}]
[null,"Sales Commissions",{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Rent",{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Other 1",{"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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Total Expenses",{"$f":"IF(SUM(C14:C18)=0,\"\",SUM(C14:C18))","v":""},"","","","","","","","","","","",{"$f":"SUM(SampleExpenses[[#Totals],[JAN]:[DEC]])","v":{"v":0,"d":"$0"}}]
["Income Before Taxes label is in cell at right. Income Before Taxes for each month and Year to Date are auto calculated in cells C20 through O20.","Income Before Taxes",{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[JAN]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[FEB]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[MAR]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[APR]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[MAY]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[JUN]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[JUL]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[AUG]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[SEP]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[OCT]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[NOV]],\"\")","v":""},{"$f":"IFERROR('P&L Template'!$C$11-SampleExpenses[[#Totals],[DEC]],\"\")","v":""},{"v":0,"d":"$0"}]
["Income Tax Expense label is in cell at right. Income Tax Expense for each month and Year to Date are auto calculated in cells C21 through O21. Next instruction is in cell A23.","Income Tax Expense",{"$f":"IFERROR(C20*0.15,\" \")","v":" "},{"$f":"IFERROR(D20*0.15,\" \")","v":" "},{"$f":"IFERROR(E20*0.15,\" \")","v":" "}," "," "," "," "," "," "," "," "," ",{"$f":"SUM('P&L Template'!$C$21:$N$21)","v":{"v":0,"d":"$0"}}]
[]
["Net Income label is in cell at right. Net Income for each month and Year to Date are auto calculated in cells C23 through O23.","NET INCOME",{"$f":"IFERROR(C20-'P&L Template'!$C$21,\"\")","v":""},{"$f":"IFERROR(D20-'P&L Template'!$D$21,\"\")","v":""},{"$f":"IFERROR(E20-'P&L Template'!$E$21,\"\")","v":""},{"$f":"IFERROR(F20-'P&L Template'!$F$21,\"\")","v":""},{"$f":"IFERROR(G20-'P&L Template'!$G$21,\"\")","v":""},{"$f":"IFERROR(H20-'P&L Template'!$H$21,\"\")","v":""},{"$f":"IFERROR(I20-'P&L Template'!$I$21,\"\")","v":""},{"$f":"IFERROR(J20-'P&L Template'!$J$21,\"\")","v":""},{"$f":"IFERROR(K20-'P&L Template'!$K$21,\"\")","v":""},{"$f":"IFERROR(L20-'P&L Template'!$L$21,\"\")","v":""},{"$f":"IFERROR(M20-'P&L Template'!$M$21,\"\")","v":""},{"$f":"IFERROR(N20-'P&L Template'!$N$21,\"\")","v":""},{"$f":"IFERROR(O20-'P&L Template'!$O$21,\"\")","v":{"v":0,"d":"$0"}}]
["Net Income label is in cell at right. Net Income for each month and Year to Date are auto calculated in cells C25 through O25."]

{"sheet":"P&L Example","index":5,"n_rows":22,"n_cols":15,"rows_kept":22,"merged":[[1,2,1,14],[2,1,2,14],[11,1,11,14],[20,1,20,14],[22,1,22,14]]}
["This worksheet contains sample data in the template from previous worksheet. Title of the worksheet is in cell at right. Other helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.","START-UP COSTS"]
["Business name is in cell at right and Date in cell C2. Next instruction is in cell A4.",{"$f":"'Start-Up Costs Template'!B2","v":"Your Coffee Shop"},{"$f":"TODAY()","v":"2018-06-26"}]
[]
["Revenue items with values for each month are in Actual Revenue table starting in cell at right. Net Sales for each month, and Year to Date are auto calculated. Next instruction is in cell A10.","REVENUE","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YTD"]
[null,"Estimated Product Sales",{"v":5000,"d":"$5,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(C5:N5)","v":{"v":216423,"d":"$216,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(C6:N6)","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,ActualRevenue[JAN])","v":{"v":5000,"d":"$5,000"}},{"$f":"SUBTOTAL(109,ActualRevenue[FEB])","v":{"v":12650,"d":"$12,650"}},{"$f":"SUBTOTAL(109,ActualRevenue[MAR])","v":{"v":16000,"d":"$16,000"}},{"$f":"SUBTOTAL(109,ActualRevenue[APR])","v":{"v":6794,"d":"$6,794"}},{"$f":"SUBTOTAL(109,ActualRevenue[MAY])","v":{"v":14266,"d":"$14,266"}},{"$f":"SUBTOTAL(109,ActualRevenue[JUN])","v":{"v":16650,"d":"$16,650"}},{"$f":"SUBTOTAL(109,ActualRevenue[JUL])","v":{"v":22850,"d":"$22,850"}},{"$f":"SUBTOTAL(109,ActualRevenue[AUG])","v":{"v":24445,"d":"$24,445"}},{"$f":"SUBTOTAL(109,ActualRevenue[SEP])","v":{"v":23349,"d":"$23,349"}},{"$f":"SUBTOTAL(109,ActualRevenue[OCT])","v":{"v":20400,"d":"$20,400"}},{"$f":"SUBTOTAL(109,ActualRevenue[NOV])","v":{"v":26245,"d":"$26,245"}},{"$f":"SUBTOTAL(109,ActualRevenue[DEC])","v":{"v":26309,"d":"$26,309"}},{"$f":"SUM(ActualRevenue[[#Totals],[JAN]:[DEC]])","v":{"v":214958,"d":"$214,958"}}]
["Cost of Goods Sold label is in cell at right. Cost of Goods Sold for each month and Year to Date are auto calculated in cells C10 through O10.","Cost of Goods Sold",{"$f":"C5*0.4","v":{"v":2000,"d":"$2,000"}},{"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"},{"v":86569.20000000001,"d":"$86,569"}]
["Gross Profit label is in cell at right. Gross Profit for each month and Year to Date are auto calculated in cells C11 through O11. Next instruction is in cell A13.","Gross Profit",{"$f":"IFERROR(ActualRevenue[[#Totals],[JAN]]-C10,\"\")","v":{"v":3000,"d":"$3,000"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[FEB]]-D10,\"\")","v":{"v":7450,"d":"$7,450"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[MAR]]-E10,\"\")","v":{"v":9600,"d":"$9,600"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[APR]]-F10,\"\")","v":{"v":3994,"d":"$3,994"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[MAY]]-G10,\"\")","v":{"v":8466,"d":"$8,466"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[JUN]]-H10,\"\")","v":{"v":10090,"d":"$10,090"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[JUL]]-I10,\"\")","v":{"v":13850,"d":"$13,850"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[AUG]]-J10,\"\")","v":{"v":15195,"d":"$15,195"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[SEP]]-K10,\"\")","v":{"v":13529.4,"d":"$13,529"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[OCT]]-L10,\"\")","v":{"v":11600,"d":"$11,600"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[NOV]]-M10,\"\")","v":{"v":16245,"d":"$16,245"}},{"$f":"IFERROR(ActualRevenue[[#Totals],[DEC]]-N10,\"\")","v":{"v":15369.4,"d":"$15,369"}},{"v":128388.79999999999,"d":"$128,389"}]
[]
["Expenses items with values for each month are in Actual Expenses table starting in cell at right. Year to Date, and Total Expenses are auto calculated. Next instruction is in cell A19.","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(C14:N14)","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(C15:N15)","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(C14:C17)=0,\"\",SUM(C14:C17))","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(ActualExpenses[[#Totals],[JAN]:[DEC]])","v":{"v":111871.15,"d":"$111,871"}}]
["Income Before Taxes label is in cell at right. Income Before Taxes for each month and Year to Date are auto calculated in cells C19 through O19.","Income Before Taxes",{"$f":"IFERROR('P&L Example'!$C$11-ActualExpenses[[#Totals],[JAN]],\"\")","v":{"v":-1400,"d":"($1,400)"}},{"$f":"IFERROR('P&L Example'!$D$11-ActualExpenses[[#Totals],[FEB]],\"\")","v":{"v":2600,"d":"$2,600"}},{"$f":"IFERROR('P&L Example'!$E$11-ActualExpenses[[#Totals],[MAR]],\"\")","v":{"v":3600,"d":"$3,600"}},{"$f":"IFERROR('P&L Example'!$F$11-ActualExpenses[[#Totals],[APR]],\"\")","v":{"v":-3056,"d":"($3,056)"}},{"$f":"IFERROR('P&L Example'!$G$11-ActualExpenses[[#Totals],[MAY]],\"\")","v":{"v":591,"d":"$591"}},{"$f":"IFERROR('P&L Example'!$H$11-ActualExpenses[[#Totals],[JUN]],\"\")","v":{"v":2120,"d":"$2,120"}},{"$f":"IFERROR('P&L Example'!$I$11-ActualExpenses[[#Totals],[JUL]],\"\")","v":{"v":2575,"d":"$2,575"}},{"$f":"IFERROR('P&L Example'!$J$11-ActualExpenses[[#Totals],[AUG]],\"\")","v":{"v":2888.75,"d":"$2,889"}},{"$f":"IFERROR('P&L Example'!$K$11-ActualExpenses[[#Totals],[SEP]],\"\")","v":{"v":1151.949999999999,"d":"$1,152"}},{"$f":"IFERROR('P&L Example'!$L$11-ActualExpenses[[#Totals],[OCT]],\"\")","v":{"v":-650,"d":"($650)"}},{"$f":"IFERROR('P&L Example'!$M$11-ActualExpenses[[#Totals],[NOV]],\"\")","v":{"v":3545,"d":"$3,545"}},{"$f":"IFERROR('P&L Example'!$N$11-ActualExpenses[[#Totals],[DEC]],\"\")","v":{"v":2551.949999999999,"d":"$2,552"}},{"$f":"SUM(C19:N19)","v":{"v":16517.649999999998,"d":"$16,518"}}]
["Income Tax Expense label is in cell at right. Income Tax Expense for each month and Year to Date are auto calculated in cells C20 through O20. Next instruction is in cell A22.","Income Tax Expense",{"$f":"C19*0.15","v":{"v":-210,"d":"($210)"}},{"v":390,"d":"$390"},{"$f":"E19*0.15","v":{"v":540,"d":"$540"}},{"$f":"F19*0.15","v":{"v":-458.4,"d":"($458)"}},{"$f":"G19*0.15","v":{"v":88.64999999999999,"d":"$89"}},{"$f":"H19*0.15","v":{"v":318,"d":"$318"}},{"$f":"I19*0.15","v":{"v":386.25,"d":"$386"}},{"$f":"J19*0.15","v":{"v":433.3125,"d":"$433"}},{"$f":"K19*0.15","v":{"v":172.79249999999982,"d":"$173"}},{"$f":"L19*0.15","v":{"v":-97.5,"d":"($98)"}},{"$f":"M19*0.15","v":{"v":531.75,"d":"$532"}},{"$f":"N19*0.15","v":{"v":382.79249999999985,"d":"$383"}},{"$f":"SUM('P&L Example'!$C$20:$N$20)","v":{"v":2477.6474999999996,"d":"$2,478"}}]
[]
["Net Income label is in cell at right. Net Income for each month and Year to Date are auto calculated in cells C22 through O22.","NET INCOME",{"$f":"IFERROR(C19-'P&L Example'!$C$20,\" \")","v":{"v":-1190,"d":"($1,190)"}},{"$f":"IFERROR(D19-'P&L Example'!$D$20,\" \")","v":{"v":2210,"d":"$2,210"}},{"$f":"IFERROR(E19-'P&L Example'!$E$20,\"\")","v":{"v":3060,"d":"$3,060"}},{"$f":"IFERROR(F19-'P&L Example'!$F$20,\"\")","v":{"v":-2597.6,"d":"($2,598)"}},{"$f":"IFERROR(G19-'P&L Example'!$G$20,\"\")","v":{"v":502.35,"d":"$502"}},{"$f":"IFERROR(H19-'P&L Example'!$H$20,\"\")","v":{"v":1802,"d":"$1,802"}},{"$f":"IFERROR(I19-'P&L Example'!$I$20,\"\")","v":{"v":2188.75,"d":"$2,189"}},{"$f":"IFERROR(J19-'P&L Example'!$J$20,\"\")","v":{"v":2455.4375,"d":"$2,455"}},{"$f":"IFERROR(K19-'P&L Example'!$K$20,\"\")","v":{"v":979.1574999999991,"d":"$979"}},{"$f":"IFERROR(L19-'P&L Example'!$L$20,\"\")","v":{"v":-552.5,"d":"($553)"}},{"$f":"IFERROR(M19-'P&L Example'!$M$20,\"\")","v":{"v":3013.25,"d":"$3,013"}},{"$f":"IFERROR(N19-'P&L Example'!$N$20,\"\")","v":{"v":2169.157499999999,"d":"$2,169"}},{"$f":"IFERROR(O19-'P&L Example'!$O$20,\"\")","v":{"v":14040.002499999999,"d":"$14,040"}}]