{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Three-Yr Profit Projection"],"not_rendered":{"images":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Three-Yr Profit Projection","index":0,"n_rows":35,"n_cols":12,"rows_kept":35}
[]
["Profit and Loss Projection (3 Years)"]
["Enter your Company Name here"]
[]
[null,2015,null,"%",null,{"$f":"B5+1","v":2016},null,"%",null,{"$f":"B5+2","v":2017},null,"%"]
[]
["Sales",0,null,{"v":1,"d":"100.00%"},null,0,null,{"v":1,"d":"100.00%"},null,0,null,{"v":1,"d":"100.00%"}]
["Cost/ Goods Sold (COGS)",0,null,{"$f":"IF(B7=0,\"-\",B8/B7)","v":"-"},null,0,null,{"$f":"IF(F7=0,\"-\",F8/F7)","v":"-"},null,0,null,{"$f":"IF(J7=0,\"-\",J8/J7)","v":"-"}]
["Gross Profit",{"$f":"B7-B8","v":0},null,{"$f":"IF(B7=0,\"-\",B9/B7)","v":"-"},null,{"$f":"F7-F8","v":0},null,{"$f":"IF(F7=0,\"-\",F9/F7)","v":"-"},null,{"$f":"J7-J8","v":0},null,{"$f":"IF(J7=0,\"-\",J9/J7)","v":"-"}]
[]
["Operating Expenses"]
["Salary (Office & Overhead)",0,null,{"$f":"IF($B$7=0,\"-\",B12/$B$7)","v":"-"},null,0,null,{"$f":"IF($F$7=0,\"-\",F12/$F$7)","v":"-"},null,0,null,{"$f":"IF($J$7=0,\"-\",J12/$J$7)","v":"-"}]
["Payroll (taxes etc.)",0,null,{"$f":"IF($B$7=0,\"-\",B13/$B$7)","v":"-"},null,0,null,{"$f":"IF($F$7=0,\"-\",F13/$F$7)","v":"-"},null,0,null,{"$f":"IF($J$7=0,\"-\",J13/$J$7)","v":"-"}]
["Outside Services",0,null,{"$f":"IF($B$7=0,\"-\",B14/$B$7)","v":"-"},null,0,null,"-",null,0,null,"-"]
["Supplies (off and operation)",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Repairs/ Maintenance",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Advertising",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Car, Delivery and Travel",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Accounting and Legal",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Rent ",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Telephone",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Utilities",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Insurance",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Taxes (real estate etc.)",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Interest",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Depreciation",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Other expense (specify)",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Other expense (specify)",0,null,"-",null,0,null,"-",null,0,null,"-"]
["Total Expenses",{"$f":"SUM(B12:B28)","v":0},null,"-",null,{"$f":"SUM(F12:F28)","v":0},null,"-",null,{"$f":"SUM(J12:J28)","v":0},null,"-"]
[]
["Net Profit Before Tax",{"$f":"B9-B29","v":0},{"$nulls":3},{"$f":"F9-F29","v":0},{"$nulls":3},{"$f":"J9-J29","v":0}]
["Income Taxes",0,{"$nulls":3},0,{"$nulls":3},0]
["Net Profit After Tax",{"$f":"B31-B32","v":0},{"$nulls":3},{"$f":"F31-F32","v":0},{"$nulls":3},{"$f":"J31-J32","v":0}]
["Owner Draw/ Dividends",0,{"$nulls":3},0,{"$nulls":3},0]
["Adj. to Retained Earnings",{"$f":"B33-B34","v":0},{"$nulls":3},{"$f":"F33-F34","v":0},{"$nulls":3},{"$f":"J33-J34","v":0}]