{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Data Entry","Income Statement","Balance Sheet","Cash Flow Statement","Cash Flow Projections","Data Chart","Asset Chart","Income Chart"],"not_rendered":{"charts":3,"external_links":1,"defined_names":185,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Data Entry","index":0,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[3,3,3,12],[5,3,5,12],[6,3,6,12],[45,3,45,12]]}
[]
[]
[]
[{"$nulls":3},"Corporate Analysis"]
[]
[{"$nulls":3},"The shaded cells contain formulas and are automatically calculated by Excel. DO NOT enter any information into them. Enter numbers where they are BLUE."]
[{"$nulls":3},"This sheet serves to collect fundamental information not included on the balance sheet or income statement.  Note that changing data in one place may alter other data in the sheet. This allows you to immediately see the effect on future figures by making  a change in current figures. Use the Screen Split function to view changes."]
{"$rows_empty":7}
[{"$nulls":4},"Year of Projection",null,2006]
[{"$nulls":4},"Corporation Type (C or S)? ",null,"C",{"$f":"IF(data2ab=\"C\",\"'C' Corporation format selected; income taxes WILL be computed\",\"'S' Corporation format selected; income taxes WILL NOT be computed\")","v":"'C' Corporation format selected; income taxes WILL be computed"}]
[{"$nulls":4},"Enter Period",null,1,"Enter Period: 1 = Quarter, 2 = Year"]
[{"$nulls":4},"Operating Data",{"$nulls":3},{"$f":"IF($G$17=1,CONCATENATE(\"1st \",\"Qtr\"),IF($G$17=2,CONCATENATE(\"1st \",\"Year\"),\"Incorrect Entry\"))","v":"1st Qtr"},{"$f":"IF($G$17=1,CONCATENATE(\"2nd \",\"Qtr\"),IF($G$17=2,CONCATENATE(\"2nd \",\"Year\"),\"Incorrect Entry\"))","v":"2nd Qtr"},{"$f":"IF($G$17=1,CONCATENATE(\"3rd \",\"Qtr\"),IF($G$17=2,CONCATENATE(\"3rd \",\"Year\"),\"Incorrect Entry\"))","v":"3rd Qtr"},{"$f":"IF($G$17=1,CONCATENATE(\"4th \",\"Qtr\"),IF($G$17=2,CONCATENATE(\"4th \",\"Year\"),\"Incorrect Entry\"))","v":"4th Qtr"}]
[{"$nulls":5},"Days sales in accounts receivable",null,null,30,30,30,30]
[{"$nulls":5},"Days materials cost in inventory",null,null,30,30,30,30]
[{"$nulls":5},"Days finished goods in inventory",null,null,45,45,45,45]
[{"$nulls":5},"Days materials cost in payables",null,null,60,60,60,60]
[{"$nulls":5},"Days payroll expense accrued",null,null,7,7,7,7]
[{"$nulls":5},"Days operating expense accrued",null,null,20,20,20,20]
[]
[{"$nulls":4},"Expense Data"]
[{"$nulls":5},"Direct labor as % of sales",{"v":0.16,"d":"16.00%"},"of sales",{"$f":"'Income Statement'!H15*$G27","v":{"v":320000,"d":"$320,000"}},{"$f":"'Income Statement'!I15*$G27","v":{"v":240000,"d":"$240,000"}},{"$f":"'Income Statement'!J15*$G27","v":{"v":208000,"d":"$208,000"}},{"$f":"'Income Statement'!K15*$G27","v":{"v":321616,"d":"$321,616"}}]
[{"$nulls":5},"Other payroll as % of sales",{"v":0.12,"d":"12.00%"},"of sales",{"$f":"'Income Statement'!H15*$G28","v":{"v":240000,"d":"$240,000"}},{"$f":"'Income Statement'!I15*$G28","v":{"v":180000,"d":"$180,000"}},{"$f":"'Income Statement'!J15*$G28","v":{"v":156000,"d":"$156,000"}},{"$f":"'Income Statement'!K15*$G28","v":{"v":241212,"d":"$241,212"}}]
[{"$nulls":5},"Payroll taxes as % of payroll",{"v":0.1,"d":"10.00%"},"of payroll",{"$f":"SUM(I$27:I$28)*$G29","v":{"v":56000,"d":"$56,000"}},{"v":42000,"d":"$42,000"},{"v":36400,"d":"$36,400"},{"v":56282.8,"d":"$56,283"}]
[{"$nulls":5},"Insurance as % of payroll",{"v":0.05,"d":"5.00%"},"of payroll",{"v":28000,"d":"$28,000"},{"v":21000,"d":"$21,000"},{"v":18200,"d":"$18,200"},{"v":28141.4,"d":"$28,141"}]
[{"$nulls":5},"Legal/accounting as % of sales",{"v":0.02,"d":"2.00%"},"of sales",{"$f":"'Income Statement'!H15*$G31","v":{"v":40000,"d":"$40,000"}},{"$f":"'Income Statement'!I15*$G31","v":{"v":30000,"d":"$30,000"}},{"$f":"'Income Statement'!J15*$G31","v":{"v":26000,"d":"$26,000"}},{"$f":"'Income Statement'!K15*$G31","v":{"v":40202,"d":"$40,202"}}]
[{"$nulls":5},"Office overhead as % of sales",{"v":0.03,"d":"3.00%"},"of sales",{"$f":"'Income Statement'!H15*$G32","v":{"v":60000,"d":"$60,000"}},{"$f":"'Income Statement'!I15*$G32","v":{"v":45000,"d":"$45,000"}},{"$f":"'Income Statement'!J15*$G32","v":{"v":39000,"d":"$39,000"}},{"$f":"'Income Statement'!K15*$G32","v":{"v":60303,"d":"$60,303"}}]
[]
[{"$nulls":4},{"$f":"\"Financing Data (\"&FIXED(H18,0,TRUE)&\" on)\"","v":"Financing Data (0 on)"},null,null,"Depreciation","Capital","Current Portion","LT Portion","Rate"]
[{"$nulls":5},"Long term debt",{"$nulls":3},{"v":100000,"d":"$100,000"},{"v":500000,"d":"$500,000"},{"v":0.1,"d":"10.00%"}]
[{"$nulls":5},"Short-term debt",{"$nulls":3},{"v":50000,"d":"$50,000"},null,{"v":0.1,"d":"10.00%"}]
[{"$nulls":5},"Capital stock issued",null,null,{"v":100000,"d":"$100,000"}]
[{"$nulls":5},"Additional paid-in capital",null,null,{"v":50000,"d":"$50,000"}]
[{"$nulls":5},"Accumulated depreciation",null,{"v":400000,"d":"$400,000"}]

{"sheet":"Income Statement","index":1,"n_rows":61,"n_cols":12,"rows_kept":61,"merged":[[66,3,66,12]]}
[]
[]
[]
[]
[{"$nulls":3},"The information necessary to fill in this sheet can be found on any standard income statement. "]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"'Balance Sheet'!F13","v":" "},null,"Forecasted",{"$nulls":3},"Total"]
[{"$nulls":7},{"$f":"'Data Entry'!I18","v":"1st Qtr"},{"$f":"'Data Entry'!J18","v":"2nd Qtr"},{"$f":"'Data Entry'!K18","v":"3rd Qtr"},{"$f":"'Data Entry'!L18","v":"4th Qtr"},{"$f":"IF('Data Entry'!$G$17=1,\"4 Quarters\",IF('Data Entry'!$G$17=2,\"4 Years\",\"No Entry\"))","v":"4 Quarters"}]
[{"$nulls":4},"Sales"]
[{"$nulls":5},"Sales",null,{"v":2000000,"d":"$2,000,000"},{"v":1500000,"d":"$1,500,000"},{"v":1300000,"d":"$1,300,000"},{"v":2010100,"d":"$2,010,100"},{"$f":"SUM(H15:K15)","v":{"v":6810100,"d":"$6,810,100"}}]
[{"$nulls":5},"Cost of sales",null,{"$f":"SUM(H51:H53)","v":{"v":945000,"d":"$945,000"}},{"$f":"SUM(I51:I53)","v":{"v":865000,"d":"$865,000"}},{"$f":"SUM(J51:J53)","v":{"v":833000,"d":"$833,000"}},{"$f":"SUM(K51:K53)","v":{"v":1071616,"d":"$1,071,616"}},{"$f":"SUM(H16:K16)","v":{"v":3714616,"d":"$3,714,616"}}]
[]
[{"$nulls":6},"Gross profit  ",{"$f":"H15-H16","v":{"v":1055000,"d":"$1,055,000"}},{"$f":"I15-I16","v":{"v":635000,"d":"$635,000"}},{"$f":"J15-J16","v":{"v":467000,"d":"$467,000"}},{"$f":"K15-K16","v":{"v":938484,"d":"$938,484"}},{"$f":"SUM(H18:K18)","v":{"v":3095484,"d":"$3,095,484"}}]
[]
[{"$nulls":4},"Expenses"]
[{"$nulls":5},"Operating expenses",null,{"$f":"SUM('Data Entry'!I28:I32)","v":{"v":424000,"d":"$424,000"}},{"$f":"SUM('Data Entry'!J28:J32)","v":{"v":318000,"d":"$318,000"}},{"$f":"SUM('Data Entry'!K28:K32)","v":{"v":275600,"d":"$275,600"}},{"$f":"SUM('Data Entry'!L28:L32)","v":{"v":426141.2,"d":"$426,141"}},{"$f":"SUM(H21:K21)","v":{"v":1443741.2,"d":"$1,443,741"}}]
[{"$nulls":5},"Interest",null,{"$f":"H60+H61","v":{"v":16250,"d":"$16,250"}},{"$f":"I60+I61","v":{"v":16250,"d":"$16,250"}},{"$f":"J60+J61","v":{"v":16250,"d":"$16,250"}},{"$f":"K60+K61","v":{"v":16250,"d":"$16,250"}},{"$f":"SUM(H22:K22)","v":{"v":65000,"d":"$65,000"}}]
[{"$nulls":5},"Depreciation",null,{"$f":"H56+H57","v":{"v":32500,"d":"$32,500"}},{"$f":"I56+I57","v":{"v":33958,"d":"$33,958"}},{"$f":"J56+J57","v":{"v":33958,"d":"$33,958"}},{"$f":"K56+K57","v":{"v":33958,"d":"$33,958"}},{"$f":"SUM(H23:K23)","v":{"v":134374,"d":"$134,374"}}]
[{"$nulls":5},"Amortization",null,{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"v":1250,"d":"$1,250"},{"$f":"SUM(H24:K24)","v":{"v":5000,"d":"$5,000"}}]
[{"$nulls":6},"Total expenses  ",{"$f":"SUM(H21:H24)","v":{"v":474000,"d":"$474,000"}},{"$f":"SUM(I21:I24)","v":{"v":369458,"d":"$369,458"}},{"$f":"SUM(J21:J24)","v":{"v":327058,"d":"$327,058"}},{"$f":"SUM(K21:K24)","v":{"v":477599.2,"d":"$477,599"}},{"$f":"SUM(H25:K25)","v":{"v":1648115.2,"d":"$1,648,115"}}]
[]
[{"$nulls":6},"Operating income  ",{"$f":"H18-H25","v":{"v":581000,"d":"$581,000"}},{"$f":"I18-I25","v":{"v":265542,"d":"$265,542"}},{"$f":"J18-J25","v":{"v":139942,"d":"$139,942"}},{"$f":"K18-K25","v":{"v":460884.8,"d":"$460,885"}},{"$f":"SUM(H27:K27)","v":{"v":1447368.8,"d":"$1,447,369"}}]
[]
[{"$nulls":4},"Other income and expenses"]
[{"$nulls":5},"Gain (loss) on sale of assets",null,{"v":100000,"d":"$100,000"},{"v":10000,"d":"$10,000"},{"v":3000,"d":"$3,000"},{"v":405700,"d":"$405,700"},{"$f":"SUM(H30:K30)","v":{"v":518700,"d":"$518,700"}}]
[{"$nulls":5},"Other (net)",null,{"v":20000,"d":"$20,000"},{"v":50000,"d":"$50,000"},{"v":100000,"d":"$100,000"},{"v":200000,"d":"$200,000"},{"$f":"SUM(H31:K31)","v":{"v":370000,"d":"$370,000"}}]
[{"$nulls":6},"Subtotal  ",{"$f":"SUM(H30:H31)","v":{"v":120000,"d":"$120,000"}},{"$f":"SUM(I30:I31)","v":{"v":60000,"d":"$60,000"}},{"$f":"SUM(J30:J31)","v":{"v":103000,"d":"$103,000"}},{"$f":"SUM(K30:K31)","v":{"v":605700,"d":"$605,700"}},{"$f":"SUM(H32:K32)","v":{"v":888700,"d":"$888,700"}}]
[]
[]
[{"$nulls":6},"Income before tax  ",{"$f":"H27+H32","v":{"v":701000,"d":"$701,000"}},{"$f":"I27+I32","v":{"v":325542,"d":"$325,542"}},{"$f":"J27+J32","v":{"v":242942,"d":"$242,942"}},{"$f":"K27+K32","v":{"v":1066584.8,"d":"$1,066,585"}},{"$f":"SUM(H35:K35)","v":{"v":2336068.8,"d":"$2,336,069"}}]
[{"$nulls":5},"Please enter  a tax percentage"]
[{"$nulls":5},"Taxes @",{"v":0.3,"d":"30%"},{"$f":"IF(data2ab=\"C\",+H35*data125,0)","v":{"v":210300,"d":"$210,300"}},{"$f":"IF(data2ab=\"C\",+I35*data125,0)","v":{"v":97662.59999999999,"d":"$97,663"}},{"$f":"IF(data2ab=\"C\",+J35*data125,0)","v":{"v":72882.59999999999,"d":"$72,883"}},{"$f":"IF(data2ab=\"C\",+K35*data125,0)","v":{"v":319975.44,"d":"$319,975"}},{"$f":"SUM(H37:K37)","v":{"v":700820.6399999999,"d":"$700,821"}}]
[]
[{"$nulls":6},"Net income  ",{"$f":"H35-H37","v":{"v":490700,"d":"$490,700"}},{"$f":"I35-I37","v":{"v":227879.40000000002,"d":"$227,879"}},{"$f":"J35-J37","v":{"v":170059.40000000002,"d":"$170,059"}},{"$f":"K35-K37","v":{"v":746609.3600000001,"d":"$746,609"}},{"$f":"SUM(H39:K39)","v":{"v":1635248.1600000001,"d":"$1,635,248"}}]
[]
[{"$nulls":5},{"$f":"IF(data2ab=\"C\",\"Retained earnings-beginning\",\"Undistributed earnings-beginning \")","v":"Retained earnings-beginning"},null,{"$f":"'Balance Sheet'!H62","v":{"v":1400000,"d":"$1,400,000"}},{"$f":"'Balance Sheet'!I62","v":{"v":1890700,"d":"$1,890,700"}},{"$f":"'Balance Sheet'!J62","v":{"v":2118579,"d":"$2,118,579"}},{"$f":"'Balance Sheet'!K62","v":{"v":2288638,"d":"$2,288,638"}},{"$f":"'Balance Sheet'!H62","v":{"v":1400000,"d":"$1,400,000"}}]
[]
[{"$nulls":5},{"$f":"IF(data2ab=\"C\",\"Dividends paid\",\"Distributions to owners \")","v":"Dividends paid"},null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":50000,"d":"$50,000"},{"$f":"SUM(H43:K43)","v":{"v":50000,"d":"$50,000"}}]
[]
[{"$nulls":5},{"$f":"IF(data2ab=\"C\",\"Retained earnings-ending\",\"Undistributed earnings-ending \")","v":"Retained earnings-ending"},null,{"$f":"ROUND(H39+H41-H43,0)","v":{"v":1890700,"d":"$1,890,700"}},{"$f":"ROUND(I39+I41-I43,0)","v":{"v":2118579,"d":"$2,118,579"}},{"$f":"ROUND(J39+J41-J43,0)","v":{"v":2288638,"d":"$2,288,638"}},{"$f":"ROUND(K39+K41-K43,0)","v":{"v":2985247,"d":"$2,985,247"}},{"$f":"ROUND(L39+L41-L43,0)","v":{"v":2985248,"d":"$2,985,248"}}]
[]
[]
[{"$nulls":4},"Detailed Supporting Information"]
[]
[{"$nulls":4},"Cost of sales"]
[{"$nulls":6},"Direct labor  ",{"$f":"'Data Entry'!I27","v":{"v":320000,"d":"$320,000"}},{"$f":"'Data Entry'!J27","v":{"v":240000,"d":"$240,000"}},{"$f":"'Data Entry'!K27","v":{"v":208000,"d":"$208,000"}},{"$f":"'Data Entry'!L27","v":{"v":321616,"d":"$321,616"}},{"$f":"SUM(H51:K51)","v":{"v":1089616,"d":"$1,089,616"}}]
[{"$nulls":6},"Materials  ",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"$f":"SUM(H52:K52)","v":{"v":2000000,"d":"$2,000,000"}}]
[{"$nulls":6},"Other costs  ",{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":250000,"d":"$250,000"},{"$f":"SUM(H53:K53)","v":{"v":625000,"d":"$625,000"}}]
[]
[{"$nulls":4},"Depreciation: Enter the numbers of years."]
[{"$nulls":5},30,"year Buildings",{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!H25,0,$F$56)/4,0)),0,ROUND(SLN('Balance Sheet'!H25,0,$F$56)/4,0))","v":{"v":12500,"d":"$12,500"}},{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!I25,0,$F$56)/4,0)),0,ROUND(SLN('Balance Sheet'!I25,0,$F$56)/4,0))","v":{"v":12083,"d":"$12,083"}},{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!J25,0,$F$56)/4,0)),0,ROUND(SLN('Balance Sheet'!J25,0,$F$56)/4,0))","v":{"v":12083,"d":"$12,083"}},{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!K25,0,$F$56)/4,0)),0,ROUND(SLN('Balance Sheet'!K25,0,$F$56)/4,0))","v":{"v":12083,"d":"$12,083"}},{"$f":"SUM(H56:K56)","v":{"v":48749,"d":"$48,749"}}]
[{"$nulls":5},10,"year Equipment",{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!H26,0,$F$57)/4,0)),0,ROUND(SLN('Balance Sheet'!H26,0,$F$57)/4,0))","v":{"v":20000,"d":"$20,000"}},{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!I26,0,$F$57)/4,0)),0,ROUND(SLN('Balance Sheet'!I26,0,$F$57)/4,0))","v":{"v":21875,"d":"$21,875"}},{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!J26,0,$F$57)/4,0)),0,ROUND(SLN('Balance Sheet'!J26,0,$F$57)/4,0))","v":{"v":21875,"d":"$21,875"}},{"$f":"IF(ISERR(ROUND(SLN('Balance Sheet'!K26,0,$F$57)/4,0)),0,ROUND(SLN('Balance Sheet'!K26,0,$F$57)/4,0))","v":{"v":21875,"d":"$21,875"}},{"$f":"SUM(H57:K57)","v":{"v":85625,"d":"$85,625"}}]
[]
[{"$nulls":4},"Interest: Percentages from Data sheet"]
[{"$nulls":5},{"$f":"data39","v":{"v":0.1,"d":"10.00%"}},"Long-Term",{"$f":"$F$60*'Balance Sheet'!I44/4","v":{"v":1250,"d":"$1,250"}},{"$f":"$F$60*'Balance Sheet'!J44/4","v":{"v":1250,"d":"$1,250"}},{"$f":"$F$60*'Balance Sheet'!K44/4","v":{"v":1250,"d":"$1,250"}},{"$f":"$F$60*'Balance Sheet'!L44/4","v":{"v":1250,"d":"$1,250"}},{"$f":"SUM(H60:K60)","v":{"v":5000,"d":"$5,000"}}]
[{"$nulls":5},{"$f":"data40","v":{"v":0.1,"d":"10.00%"}},"Short-Term",{"$f":"$F$61*('Balance Sheet'!I52+'Balance Sheet'!I45)/4","v":{"v":15000,"d":"$15,000"}},{"$f":"$F$61*('Balance Sheet'!J52+'Balance Sheet'!J45)/4","v":{"v":15000,"d":"$15,000"}},{"$f":"$F$61*('Balance Sheet'!K52+'Balance Sheet'!K45)/4","v":{"v":15000,"d":"$15,000"}},{"$f":"$F$61*('Balance Sheet'!L52+'Balance Sheet'!L45)/4","v":{"v":15000,"d":"$15,000"}},{"$f":"SUM(H61:K61)","v":{"v":60000,"d":"$60,000"}}]

{"sheet":"Balance Sheet","index":2,"n_rows":71,"n_cols":12,"rows_kept":71,"merged":[[4,3,4,11],[76,3,76,11]]}
[]
[]
[]
[]
[{"$nulls":3},"The information required for this sheet can be found on a standard balance sheet.  NOTE: Enter the data sequentially from top to bottom on this form. Incorrect figures will result in errors in your cash flow calculations. "]
{"$rows_empty":7}
[{"$nulls":5}," ",null,"Actual","Forecast"]
[{"$nulls":7},{"$f":"IF(data1ab<>\"\",data1ab-1,\"No Entry\")","v":2005},{"$f":"'Data Entry'!I18","v":"1st Qtr"},{"$f":"'Data Entry'!J18","v":"2nd Qtr"},{"$f":"'Data Entry'!K18","v":"3rd Qtr"},{"$f":"'Data Entry'!L18","v":"4th Qtr"}]
[{"$nulls":4},"ASSETS"]
[{"$nulls":4},"Current Assets"]
[{"$nulls":5},"Cash and cash equivalents",null,{"v":451000,"d":"$451,000"},{"$f":"ROUND(H17+H18+H19+H20+H24+H25+H26+H32+H36+I43+I44+I45+I46+I47+I48+I52+I53+I54+I55-I18-I19-I20-I24-I25-I26-I32-I36-H43-H44-H45-H46-H47-H48-H52-H53-H54-H55+I62-H62+'Income Statement'!H23+'Income Statement'!H24+I60-H60+I61-H61,0)","v":{"v":90360,"d":"$90,360"}},{"$f":"IF(ISERR(ROUND(I17+I18+I19+I20+I24+I25+I26+I32+I36+J43+J44+J45+J46+J47+J48+J52+J53+J54+J55-J18-J19-J20-J24-J25-J26-J32-J36-I43-I44-I45-I46-I47-I48-I52-I53-I54-I55+J62-I62+'Income Statement'!I23+'Income Statement'!I24+J60-I60+J61-I61,0)),\"\",ROUND(I17+I18+I19+I20+I24+I25+I26+I32+I36+J43+J44+J45+J46+J47+J48+J52+J53+J54+J55-J18-J19-J20-J24-J25-J26-J32-J36-I43-I44-I45-I46-I47-I48-I52-I53-I54-I55+J62-I62+'Income Statement'!I23+'Income Statement'!I24+J60-I60+J61-I61,0))","v":{"v":289233,"d":"$289,233"}},{"$f":"IF(ISERR(ROUND(J17+J18+J19+J20+J24+J25+J26+J32+J36+K43+K44+K45+K46+K47+K48+K52+K53+K54+K55-K18-K19-K20-K24-K25-K26-K32-K36-J43-J44-J45-J46-J47-J48-J52-J53-J54-J55+K62-J62+'Income Statement'!J23+'Income Statement'!J24+K60-J60+K61-J61,0)),\"\",ROUND(J17+J18+J19+J20+J24+J25+J26+J32+J36+K43+K44+K45+K46+K47+K48+K52+K53+K54+K55-K18-K19-K20-K24-K25-K26-K32-K36-J43-J44-J45-J46-J47-J48-J52-J53-J54-J55+K62-J62+'Income Statement'!J23+'Income Statement'!J24+K60-J60+K61-J61,0))","v":{"v":614196,"d":"$614,196"}},{"$f":"IF(ISERR(ROUND(K17+K18+K19+K20+K24+K25+K26+K32+K36+L43+L44+L45+L46+L47+L48+L52+L53+L54+L55-L18-L19-L20-L24-L25-L26-L32-L36-K43-K44-K45-K46-K47-K48-K52-K53-K54-K55+L62-K62+'Income Statement'!K23+'Income Statement'!K24+L60-K60+L61-K61,0)),\"\",ROUND(K17+K18+K19+K20+K24+K25+K26+K32+K36+L43+L44+L45+L46+L47+L48+L52+L53+L54+L55-L18-L19-L20-L24-L25-L26-L32-L36-K43-K44-K45-K46-K47-K48-K52-K53-K54-K55+L62-K62+'Income Statement'!K23+'Income Statement'!K24+L60-K60+L61-K61,0))","v":{"v":1267364,"d":"$1,267,364"}}]
[{"$nulls":5},"Accounts receivable",null,{"v":350000,"d":"$350,000"},{"$f":"ROUND(('Income Statement'!H15/(365*0.25))*'Data Entry'!I19,0)","v":{"v":657534,"d":"$657,534"}},{"$f":"ROUND(('Income Statement'!I15/(365*0.25))*'Data Entry'!J19,0)","v":{"v":493151,"d":"$493,151"}},{"$f":"ROUND(('Income Statement'!J15/(365*0.25))*'Data Entry'!K19,0)","v":{"v":427397,"d":"$427,397"}},{"$f":"ROUND(('Income Statement'!K15/(365*0.25))*'Data Entry'!L19,0)","v":{"v":660855,"d":"$660,855"}}]
[{"$nulls":5},"Inventory",null,{"v":400000,"d":"$400,000"},{"$f":"ROUND((('Income Statement'!H52/(365*0.25))*'Data Entry'!I20)+((SUM('Income Statement'!H51:H53)/(365*0.25))*'Data Entry'!I21),0)","v":{"v":630411,"d":"$630,411"}},{"$f":"ROUND((('Income Statement'!I52/(365*0.25))*'Data Entry'!J20)+((SUM('Income Statement'!I51:I53)/(365*0.25))*'Data Entry'!J21),0)","v":{"v":590959,"d":"$590,959"}},{"$f":"ROUND((('Income Statement'!J52/(365*0.25))*'Data Entry'!K20)+((SUM('Income Statement'!J51:J53)/(365*0.25))*'Data Entry'!K21),0)","v":{"v":575178,"d":"$575,178"}},{"$f":"ROUND((('Income Statement'!K52/(365*0.25))*'Data Entry'!L20)+((SUM('Income Statement'!K51:K53)/(365*0.25))*'Data Entry'!L21),0)","v":{"v":692852,"d":"$692,852"}}]
[{"$nulls":5},"Other current assets",null,{"v":10000,"d":"$10,000"},{"v":60000,"d":"$60,000"},{"v":45090,"d":"$45,090"},{"v":76320,"d":"$76,320"},{"v":50000,"d":"$50,000"}]
[{"$nulls":6},"Total Current Assets  ",{"$f":"SUM(H17:H20)","v":{"v":1211000,"d":"$1,211,000"}},{"$f":"SUM(I17:I20)","v":{"v":1438305,"d":"$1,438,305"}},{"$f":"SUM(J17:J20)","v":{"v":1418433,"d":"$1,418,433"}},{"$f":"SUM(K17:K20)","v":{"v":1693091,"d":"$1,693,091"}},{"$f":"SUM(L17:L20)","v":{"v":2671071,"d":"$2,671,071"}}]
[]
[{"$nulls":4},"Fixed Assets"]
[{"$nulls":5},"Land",null,{"v":100000,"d":"$100,000"},{"v":112500,"d":"$112,500"},{"v":125000,"d":"$125,000"},{"v":137500,"d":"$137,500"},{"v":150000,"d":"$150,000"}]
[{"$nulls":5},"Buildings",null,{"v":1500000,"d":"$1,500,000"},{"v":1450000,"d":"$1,450,000"},{"v":1450000,"d":"$1,450,000"},{"v":1450000,"d":"$1,450,000"},{"v":1450000,"d":"$1,450,000"}]
[{"$nulls":5},"Equipment",null,{"v":800000,"d":"$800,000"},{"v":875000,"d":"$875,000"},{"v":875000,"d":"$875,000"},{"v":875000,"d":"$875,000"},{"v":875000,"d":"$875,000"}]
[{"$nulls":6},"Subtotal  ",{"$f":"SUM(H24:H26)","v":{"v":2400000,"d":"$2,400,000"}},{"$f":"SUM(I24:I26)","v":{"v":2437500,"d":"$2,437,500"}},{"$f":"SUM(J24:J26)","v":{"v":2450000,"d":"$2,450,000"}},{"$f":"SUM(K24:K26)","v":{"v":2462500,"d":"$2,462,500"}},{"$f":"SUM(L24:L26)","v":{"v":2475000,"d":"$2,475,000"}}]
[{"$nulls":5},"Less-accumulated depreciation",null,{"$f":"'Data Entry'!H39","v":{"v":400000,"d":"$400,000"}},{"$f":"H28+SUM('Income Statement'!H56:H57)","v":{"v":432500,"d":"$432,500"}},{"$f":"I28+SUM('Income Statement'!I56:I57)","v":{"v":466458,"d":"$466,458"}},{"$f":"J28+SUM('Income Statement'!J56:J57)","v":{"v":500416,"d":"$500,416"}},{"$f":"K28+SUM('Income Statement'!K56:K57)","v":{"v":534374,"d":"$534,374"}}]
[{"$nulls":6},"Total Fixed Assets  ",{"$f":"H27-H28","v":{"v":2000000,"d":"$2,000,000"}},{"$f":"I27-I28","v":{"v":2005000,"d":"$2,005,000"}},{"$f":"J27-J28","v":{"v":1983542,"d":"$1,983,542"}},{"$f":"K27-K28","v":{"v":1962084,"d":"$1,962,084"}},{"$f":"L27-L28","v":{"v":1940626,"d":"$1,940,626"}}]
[]
[{"$nulls":4},"Intangible Assets"]
[{"$nulls":5},"Cost",null,{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[{"$nulls":5},"Less-accumulated amortization",null,{"v":20000,"d":"$20,000"},{"v":21250,"d":"$21,250"},{"v":22500,"d":"$22,500"},{"v":23750,"d":"$23,750"},{"v":25000,"d":"$25,000"}]
[{"$nulls":6},"Total Intangible Assets  ",{"$f":"H32-H33","v":{"v":30000,"d":"$30,000"}},{"$f":"I32-I33","v":{"v":28750,"d":"$28,750"}},{"$f":"J32-J33","v":{"v":27500,"d":"$27,500"}},{"$f":"K32-K33","v":{"v":26250,"d":"$26,250"}},{"$f":"L32-L33","v":{"v":25000,"d":"$25,000"}}]
[]
[{"$nulls":4},"Other assets",null,null,{"v":25000,"d":"$25,000"},{"v":33000,"d":"$33,000"},{"v":120000,"d":"$120,000"},{"v":5000,"d":"$5,000"},{"v":23000,"d":"$23,000"}]
[{"$nulls":6},"Total Assets  ",{"$f":"H21+H29+H34+H36","v":{"v":3266000,"d":"$3,266,000"}},{"$f":"ROUND(I21+I29+I34+I36,0)","v":{"v":3505055,"d":"$3,505,055"}},{"$f":"ROUND(J21+J29+J34+J36,0)","v":{"v":3549475,"d":"$3,549,475"}},{"$f":"ROUND(K21+K29+K34+K36,0)","v":{"v":3686425,"d":"$3,686,425"}},{"$f":"ROUND(L21+L29+L34+L36,0)","v":{"v":4659697,"d":"$4,659,697"}}]
[]
[{"$nulls":7},"Actual","Forecast"]
[{"$nulls":4},"LIABILITIES AND",null,null,{"$f":"H14","v":2005},{"$f":"'Data Entry'!I18","v":"1st Qtr"},{"$f":"'Data Entry'!J18","v":"2nd Qtr"},{"$f":"'Data Entry'!K18","v":"3rd Qtr"},{"$f":"'Data Entry'!L18","v":"4th Qtr"}]
[{"$nulls":4},{"$f":"IF(H68=\"Y\",\"STOCKHOLDERS' EQUITY\",\"OWNERS' EQUITY\")","v":"STOCKHOLDERS' EQUITY"}]
[{"$nulls":4},"Current Liabilities"]
[{"$nulls":5},"Accounts payable",null,{"v":600000,"d":"$600,000"},{"$f":"ROUND(('Income Statement'!H52/(365*0.25))*'Data Entry'!I22,0)","v":{"v":328767,"d":"$328,767"}},{"$f":"ROUND(('Income Statement'!I52/(365*0.25))*'Data Entry'!J22,0)","v":{"v":328767,"d":"$328,767"}},{"$f":"ROUND(('Income Statement'!J52/(365*0.25))*'Data Entry'!K22,0)","v":{"v":328767,"d":"$328,767"}},{"$f":"ROUND(('Income Statement'!K52/(365*0.25))*'Data Entry'!L22,0)","v":{"v":328767,"d":"$328,767"}}]
[{"$nulls":5},"Notes payable",null,{"v":100000,"d":"$100,000"},{"$f":"'Data Entry'!J36","v":{"v":50000,"d":"$50,000"}},{"$f":"'Data Entry'!J36","v":{"v":50000,"d":"$50,000"}},{"$f":"'Data Entry'!J36","v":{"v":50000,"d":"$50,000"}},{"$f":"'Data Entry'!J36","v":{"v":50000,"d":"$50,000"}}]
[{"$nulls":5},"Current portion of long-term debt",null,{"v":100000,"d":"$100,000"},{"$f":"'Data Entry'!J35","v":{"v":100000,"d":"$100,000"}},{"$f":"'Data Entry'!J35","v":{"v":100000,"d":"$100,000"}},{"$f":"'Data Entry'!J35","v":{"v":100000,"d":"$100,000"}},{"$f":"'Data Entry'!J35","v":{"v":100000,"d":"$100,000"}}]
[{"$nulls":5},"Income taxes",null,{"v":30000,"d":"$30,000"},{"$f":"IF($H68=\"Y\",ROUND(('Income Statement'!H37-I54),0),0)","v":{"v":183300,"d":"$183,300"}},{"$f":"IF($H68=\"Y\",ROUND(('Income Statement'!I37-J54),0),0)","v":{"v":70663,"d":"$70,663"}},{"$f":"IF($H68=\"Y\",ROUND(('Income Statement'!J37-K54),0),0)","v":{"v":45883,"d":"$45,883"}},{"$f":"IF($H68=\"Y\",ROUND(('Income Statement'!K37-L54),0),0)","v":{"v":292975,"d":"$292,975"}}]
[{"$nulls":5},"Accrued expenses",null,{"v":90000,"d":"$90,000"},{"$f":"ROUND(((('Data Entry'!I27+'Data Entry'!I28)/(365*0.25))*'Data Entry'!I23)+((SUM('Data Entry'!I29:I32))/(365*0.25))*'Data Entry'!I24,0)","v":{"v":83288,"d":"$83,288"}},{"$f":"ROUND(((('Data Entry'!J27+'Data Entry'!J28)/(365*0.25))*'Data Entry'!J23)+((SUM('Data Entry'!J29:J32))/(365*0.25))*'Data Entry'!J24,0)","v":{"v":62466,"d":"$62,466"}},{"$f":"ROUND(((('Data Entry'!K27+'Data Entry'!K28)/(365*0.25))*'Data Entry'!K23)+((SUM('Data Entry'!K29:K32))/(365*0.25))*'Data Entry'!K24,0)","v":{"v":54137,"d":"$54,137"}},{"$f":"ROUND(((('Data Entry'!L27+'Data Entry'!L28)/(365*0.25))*'Data Entry'!L23)+((SUM('Data Entry'!L29:L32))/(365*0.25))*'Data Entry'!L24,0)","v":{"v":83708,"d":"$83,708"}}]
[{"$nulls":5},"Other current liabilities",null,{"v":16000,"d":"$16,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"}]
[{"$nulls":6},"Total Current Liabilities  ",{"$f":"SUM(H43:H48)","v":{"v":936000,"d":"$936,000"}},{"$f":"SUM(I43:I48)","v":{"v":757355,"d":"$757,355"}},{"$f":"SUM(J43:J48)","v":{"v":623896,"d":"$623,896"}},{"$f":"SUM(K43:K48)","v":{"v":590787,"d":"$590,787"}},{"$f":"SUM(L43:L48)","v":{"v":867450,"d":"$867,450"}}]
[]
[{"$nulls":4},"Non-Current Liabilities"]
[{"$nulls":5},"Long-term debt",null,{"v":600000,"d":"$600,000"},{"$f":"'Data Entry'!K35","v":{"v":500000,"d":"$500,000"}},{"$f":"'Data Entry'!K35","v":{"v":500000,"d":"$500,000"}},{"$f":"'Data Entry'!K35","v":{"v":500000,"d":"$500,000"}},{"$f":"'Data Entry'!K35","v":{"v":500000,"d":"$500,000"}}]
[{"$nulls":5},"Deferred income",null,{"v":100000,"d":"$100,000"},{"v":90000,"d":"$90,000"},{"v":90000,"d":"$90,000"},{"v":90000,"d":"$90,000"},{"v":90000,"d":"$90,000"}]
[{"$nulls":5},"Deferred income taxes",null,{"v":30000,"d":"$30,000"},{"v":27000,"d":"$27,000"},{"v":27000,"d":"$27,000"},{"v":27000,"d":"$27,000"},{"v":27000,"d":"$27,000"}]
[{"$nulls":5},"Other long-term liabilities",null,{"v":50000,"d":"$50,000"},{"v":90000,"d":"$90,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"}]
[]
[{"$nulls":6},"Total Liabilities  ",{"$f":"SUM(H49:H55)","v":{"v":1716000,"d":"$1,716,000"}},{"$f":"SUM(I49:I55)","v":{"v":1464355,"d":"$1,464,355"}},{"$f":"SUM(J49:J55)","v":{"v":1280896,"d":"$1,280,896"}},{"$f":"SUM(K49:K55)","v":{"v":1247787,"d":"$1,247,787"}},{"$f":"SUM(L49:L55)","v":{"v":1524450,"d":"$1,524,450"}}]
[]
[{"$nulls":4},{"$f":"IF(H68=\"Y\",\"Stockholders' Equity\",\"Owners' Equity\")","v":"Stockholders' Equity"}]
[{"$nulls":5},"Capital stock issued",null,{"v":100000,"d":"$100,000"},{"$f":"'Data Entry'!I37","v":{"v":100000,"d":"$100,000"}},{"$f":"'Data Entry'!I37","v":{"v":100000,"d":"$100,000"}},{"$f":"'Data Entry'!I37","v":{"v":100000,"d":"$100,000"}},{"$f":"'Data Entry'!I37","v":{"v":100000,"d":"$100,000"}}]
[{"$nulls":5},{"$f":"IF(H68=\"Y\",\"Additional paid in capital\",\"Additional capital invested\")","v":"Additional paid in capital"},null,{"v":50000,"d":"$50,000"},{"$f":"'Data Entry'!I38","v":{"v":50000,"d":"$50,000"}},{"$f":"'Data Entry'!I38","v":{"v":50000,"d":"$50,000"}},{"$f":"'Data Entry'!I38","v":{"v":50000,"d":"$50,000"}},{"$f":"'Data Entry'!I38","v":{"v":50000,"d":"$50,000"}}]
[{"$nulls":5},{"$f":"IF(H68=\"Y\",\"Retained earnings\",\"Undistributed earnings\")","v":"Retained earnings"},null,{"v":1400000,"d":"$1,400,000"},{"$f":"'Income Statement'!H45","v":{"v":1890700,"d":"$1,890,700"}},{"$f":"'Income Statement'!I45","v":{"v":2118579,"d":"$2,118,579"}},{"$f":"'Income Statement'!J45","v":{"v":2288638,"d":"$2,288,638"}},{"$f":"'Income Statement'!K45","v":{"v":2985247,"d":"$2,985,247"}}]
[{"$nulls":5},"Other",null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[{"$nulls":7},{"$f":"SUM(H60:H63)","v":{"v":1550000,"d":"$1,550,000"}},{"$f":"SUM(I60:I63)","v":{"v":2040700,"d":"$2,040,700"}},{"$f":"SUM(J60:J63)","v":{"v":2268579,"d":"$2,268,579"}},{"$f":"SUM(K60:K63)","v":{"v":2438638,"d":"$2,438,638"}},{"$f":"SUM(L60:L63)","v":{"v":3135247,"d":"$3,135,247"}}]
[]
[{"$nulls":6},"Total Liabilities and Equity  ",{"$f":"ROUND(H57+H64,0)","v":{"v":3266000,"d":"$3,266,000"}},{"$f":"ROUND(I57+I64,0)","v":{"v":3505055,"d":"$3,505,055"}},{"$f":"ROUND(J57+J64,0)","v":{"v":3549475,"d":"$3,549,475"}},{"$f":"ROUND(K57+K64,0)","v":{"v":3686425,"d":"$3,686,425"}},{"$f":"ROUND(L57+L64,0)","v":{"v":4659697,"d":"$4,659,697"}}]
[]
[{"$nulls":5},"\"C\" Corporation (Y/N)",null,{"$f":"IF(data2ab=\"C\",\"Y\",\"N\")","v":"Y"}]
[{"$nulls":5},"Cash balance positive or (negative)",null,{"$f":"IF(H17>=0,\"Positive \",\"(Negative) \")","v":"Positive "},{"$f":"IF(I17>=0,\"Positive \",\"(Negative) \")","v":"Positive "},{"$f":"IF(J17>=0,\"Positive \",\"(Negative) \")","v":"Positive "},{"$f":"IF(K17>=0,\"Positive \",\"(Negative) \")","v":"Positive "},{"$f":"IF(L17>=0,\"Positive \",\"(Negative) \")","v":"Positive "}]
[{"$nulls":5},"Amount sheet is out-of-balance",null,{"$f":"H37-H66","v":{"v":0,"d":"$0"}},{"$f":"I37-I66","v":{"v":0,"d":"$0"}},{"$f":"J37-J66","v":{"v":0,"d":"$0"}},{"$f":"K37-K66","v":{"v":0,"d":"$0"}},{"$f":"L37-L66","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"Amount cash flow out-of-balance",null,null,{"$f":"I17-'Cash Flow Statement'!I60","v":{"v":0,"d":"$0"}},{"$f":"J17-'Cash Flow Statement'!J60","v":{"v":0,"d":"$0"}},{"$f":"K17-'Cash Flow Statement'!K60","v":{"v":0,"d":"$0"}},{"$f":"L17-'Cash Flow Statement'!L60","v":{"v":0,"d":"$0"}}]

{"sheet":"Cash Flow Statement","index":3,"n_rows":60,"n_cols":13,"rows_kept":60,"merged":[[5,3,5,13],[64,3,64,13]]}
[]
[]
[]
[]
[]
[{"$nulls":3},"This sheet displays all the information normally found on a standard cash flow statement. It is entirely calculated from the information on the Data Entry, Income Statement, and Balance worksheets. "]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"'Balance Sheet'!F13","v":" "},{"$nulls":3},"Forecasted",{"$nulls":3},"Total"]
[{"$nulls":8},{"$f":"'Balance Sheet'!I14","v":"1st Qtr"},{"$f":"'Balance Sheet'!J14","v":"2nd Qtr"},{"$f":"'Balance Sheet'!K14","v":"3rd Qtr"},{"$f":"'Balance Sheet'!L14","v":"4th Qtr"},{"$f":"IF('Data Entry'!$G$17=1,\"4 Quarters\",IF('Data Entry'!$G$17=2,\"4 Years\",\"No Entry\"))","v":"4 Quarters"}]
[{"$nulls":4},"Cash from operations"]
[{"$nulls":5},"Net earnings (loss)",null,null,{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!H39,0),ROUND('Income Statement'!H35,0))","v":{"v":490700,"d":"$490,700"}},{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!I39,0),ROUND('Income Statement'!I35,0))","v":{"v":227879,"d":"$227,879"}},{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!J39,0),ROUND('Income Statement'!J35,0))","v":{"v":170059,"d":"$170,059"}},{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!K39,0),ROUND('Income Statement'!K35,0))","v":{"v":746609,"d":"$746,609"}},{"$f":"SUM(I16:L16)","v":{"v":1635247,"d":"$1,635,247"}}]
[{"$nulls":5},"Add-depreciation and amortization",null,null,{"$f":"ROUND('Income Statement'!H23+'Income Statement'!H24,0)","v":{"v":33750,"d":"$33,750"}},{"$f":"ROUND('Income Statement'!I23+'Income Statement'!I24,0)","v":{"v":35208,"d":"$35,208"}},{"$f":"ROUND('Income Statement'!J23+'Income Statement'!J24,0)","v":{"v":35208,"d":"$35,208"}},{"$f":"ROUND('Income Statement'!K23+'Income Statement'!K24,0)","v":{"v":35208,"d":"$35,208"}},{"$f":"SUM(I17:L17)","v":{"v":139374,"d":"$139,374"}}]
[]
[{"$nulls":7},"Net cash from operations  ",{"$f":"ROUND(SUM(I16:I17),0)","v":{"v":524450,"d":"$524,450"}},{"$f":"ROUND(SUM(J16:J17),0)","v":{"v":263087,"d":"$263,087"}},{"$f":"ROUND(SUM(K16:K17),0)","v":{"v":205267,"d":"$205,267"}},{"$f":"ROUND(SUM(L16:L17),0)","v":{"v":781817,"d":"$781,817"}},{"$f":"SUM(I19:L19)","v":{"v":1774621,"d":"$1,774,621"}}]
[]
[{"$nulls":4},"Cash provided (used) by "]
[{"$nulls":4},"operating activities"]
[{"$nulls":5},"Accounts Receivable",null,null,{"$f":"ROUND('Balance Sheet'!H18-'Balance Sheet'!I18,0)","v":{"v":-307534,"d":"($307,534)"}},{"$f":"ROUND('Balance Sheet'!I18-'Balance Sheet'!J18,0)","v":{"v":164383,"d":"$164,383"}},{"$f":"ROUND('Balance Sheet'!J18-'Balance Sheet'!K18,0)","v":{"v":65754,"d":"$65,754"}},{"$f":"ROUND('Balance Sheet'!K18-'Balance Sheet'!L18,0)","v":{"v":-233458,"d":"($233,458)"}},{"$f":"SUM(I23:L23)","v":{"v":-310855,"d":"($310,855)"}}]
[{"$nulls":5},"Inventory",null,null,{"$f":"ROUND('Balance Sheet'!H19-'Balance Sheet'!I19,0)","v":{"v":-230411,"d":"($230,411)"}},{"$f":"ROUND('Balance Sheet'!I19-'Balance Sheet'!J19,0)","v":{"v":39452,"d":"$39,452"}},{"$f":"ROUND('Balance Sheet'!J19-'Balance Sheet'!K19,0)","v":{"v":15781,"d":"$15,781"}},{"$f":"ROUND('Balance Sheet'!K19-'Balance Sheet'!L19,0)","v":{"v":-117674,"d":"($117,674)"}},{"v":-292852,"d":"($292,852)"}]
[{"$nulls":5},"Other current assets",null,null,{"$f":"ROUND('Balance Sheet'!H20-'Balance Sheet'!I20,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!I20-'Balance Sheet'!J20,0)","v":{"v":14910,"d":"$14,910"}},{"$f":"ROUND('Balance Sheet'!J20-'Balance Sheet'!K20,0)","v":{"v":-31230,"d":"($31,230)"}},{"$f":"ROUND('Balance Sheet'!K20-'Balance Sheet'!L20,0)","v":{"v":26320,"d":"$26,320"}},{"v":-40000,"d":"($40,000)"}]
[{"$nulls":5},"Other non-current assets",null,null,{"$f":"ROUND('Balance Sheet'!H36-'Balance Sheet'!I36,0)","v":{"v":-8000,"d":"($8,000)"}},{"$f":"ROUND('Balance Sheet'!I36-'Balance Sheet'!J36,0)","v":{"v":-87000,"d":"($87,000)"}},{"$f":"ROUND('Balance Sheet'!J36-'Balance Sheet'!K36,0)","v":{"v":115000,"d":"$115,000"}},{"$f":"ROUND('Balance Sheet'!K36-'Balance Sheet'!L36,0)","v":{"v":-18000,"d":"($18,000)"}},{"v":2000,"d":"$2,000"}]
[{"$nulls":5},"Accounts payable",null,null,{"$f":"ROUND('Balance Sheet'!I43-'Balance Sheet'!H43,0)","v":{"v":-271233,"d":"($271,233)"}},{"$f":"ROUND('Balance Sheet'!J43-'Balance Sheet'!I43,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K43-'Balance Sheet'!J43,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L43-'Balance Sheet'!K43,0)","v":{"v":0,"d":"$0"}},{"v":-271233,"d":"($271,233)"}]
[{"$nulls":5},"Current portion of long-term debt",null,null,{"$f":"ROUND('Balance Sheet'!I45-'Balance Sheet'!H45,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!J45-'Balance Sheet'!I45,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K45-'Balance Sheet'!J45,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L45-'Balance Sheet'!K45,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},"Income taxes",null,null,{"$f":"ROUND('Balance Sheet'!I46-'Balance Sheet'!H46,0)","v":{"v":153300,"d":"$153,300"}},{"$f":"ROUND('Balance Sheet'!J46-'Balance Sheet'!I46,0)","v":{"v":-112637,"d":"($112,637)"}},{"$f":"ROUND('Balance Sheet'!K46-'Balance Sheet'!J46,0)","v":{"v":-24780,"d":"($24,780)"}},{"$f":"ROUND('Balance Sheet'!L46-'Balance Sheet'!K46,0)","v":{"v":247092,"d":"$247,092"}},{"v":262975,"d":"$262,975"}]
[{"$nulls":5},"Accrued expenses",null,null,{"$f":"ROUND('Balance Sheet'!I47-'Balance Sheet'!H47,0)","v":{"v":-6712,"d":"($6,712)"}},{"$f":"ROUND('Balance Sheet'!J47-'Balance Sheet'!I47,0)","v":{"v":-20822,"d":"($20,822)"}},{"$f":"ROUND('Balance Sheet'!K47-'Balance Sheet'!J47,0)","v":{"v":-8329,"d":"($8,329)"}},{"$f":"ROUND('Balance Sheet'!L47-'Balance Sheet'!K47,0)","v":{"v":29571,"d":"$29,571"}},{"v":-6292,"d":"($6,292)"}]
[{"$nulls":5},"Other current liabilities",null,null,{"$f":"ROUND('Balance Sheet'!I48-'Balance Sheet'!H48,0)","v":{"v":-4000,"d":"($4,000)"}},{"$f":"ROUND('Balance Sheet'!J48-'Balance Sheet'!I48,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K48-'Balance Sheet'!J48,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L48-'Balance Sheet'!K48,0)","v":{"v":0,"d":"$0"}},{"v":-4000,"d":"($4,000)"}]
[{"$nulls":5},{"$f":"IF('Balance Sheet'!H68=\"y\",\"Dividends paid\",\"Distributions to shareholders\")","v":"Dividends paid"},null,null,{"$f":"ROUND('Income Statement'!H43*-1,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Income Statement'!I43*-1,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Income Statement'!J43*-1,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Income Statement'!K43*-1,0)","v":{"v":-50000,"d":"($50,000)"}},{"v":-50000,"d":"($50,000)"}]
[]
[{"$nulls":7},"Net cash from operations  ",{"$f":"ROUND(SUM(I23:I32),0)","v":{"v":-724590,"d":"($724,590)"}},{"$f":"ROUND(SUM(J23:J32),0)","v":{"v":-1714,"d":"($1,714)"}},{"$f":"ROUND(SUM(K23:K32),0)","v":{"v":132196,"d":"$132,196"}},{"$f":"ROUND(SUM(L23:L32),0)","v":{"v":-116149,"d":"($116,149)"}},{"$f":"SUM(I34:L34)","v":{"v":-710257,"d":"($710,257)"}}]
[]
[{"$nulls":4},"Investment transactions"]
[{"$nulls":4},"Increases (decreases)"]
[{"$nulls":5},"Land ",null,null,{"$f":"ROUND('Balance Sheet'!I24-'Balance Sheet'!H24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND('Balance Sheet'!J24-'Balance Sheet'!I24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND('Balance Sheet'!K24-'Balance Sheet'!J24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND('Balance Sheet'!L24-'Balance Sheet'!K24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"SUM(I38:L38)","v":{"v":50000,"d":"$50,000"}}]
[{"$nulls":5},"Buildings and improvements",null,null,{"$f":"ROUND('Balance Sheet'!I25-'Balance Sheet'!H25,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!J25-'Balance Sheet'!I25,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K25-'Balance Sheet'!J25,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L25-'Balance Sheet'!K25,0)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I39:L39)","v":{"v":-50000,"d":"($50,000)"}}]
[{"$nulls":5},"Equipment",null,null,{"$f":"ROUND('Balance Sheet'!I26-'Balance Sheet'!H26,0)","v":{"v":75000,"d":"$75,000"}},{"$f":"ROUND('Balance Sheet'!J26-'Balance Sheet'!I26,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K26-'Balance Sheet'!J26,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L26-'Balance Sheet'!K26,0)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I40:L40)","v":{"v":75000,"d":"$75,000"}}]
[{"$nulls":5},"Intangible assets",null,null,{"$f":"ROUND('Balance Sheet'!I32-'Balance Sheet'!H32,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!J32-'Balance Sheet'!I32,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K32-'Balance Sheet'!J32,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L32-'Balance Sheet'!K32,0)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I41:L41)","v":{"v":0,"d":"$0"}}]
[]
[{"$nulls":7},"Net cash from investments  ",{"$f":"ROUND(SUM(I38:I41),0)","v":{"v":37500,"d":"$37,500"}},{"$f":"ROUND(SUM(J38:J41),0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND(SUM(K38:K41),0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND(SUM(L38:L41),0)","v":{"v":12500,"d":"$12,500"}},{"$f":"SUM(I43:L43)","v":{"v":75000,"d":"$75,000"}}]
[]
[{"$nulls":4},"Financing transactions"]
[{"$nulls":4},"Increases (decreases)"]
[{"$nulls":5},"Short term notes payable",null,null,{"$f":"ROUND('Balance Sheet'!I44-'Balance Sheet'!H44,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!J44-'Balance Sheet'!I44,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K44-'Balance Sheet'!J44,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L44-'Balance Sheet'!K44,0)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I47:L47)","v":{"v":-50000,"d":"($50,000)"}}]
[{"$nulls":5},"Long term debt",null,null,{"$f":"ROUND('Balance Sheet'!I52-'Balance Sheet'!H52,0)","v":{"v":-100000,"d":"($100,000)"}},{"$f":"ROUND('Balance Sheet'!J52-'Balance Sheet'!I52,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K52-'Balance Sheet'!J52,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L52-'Balance Sheet'!K52,0)","v":{"v":0,"d":"$0"}},{"v":-100000,"d":"($100,000)"}]
[{"$nulls":5},"Deferred income",null,null,{"$f":"ROUND('Balance Sheet'!I53-'Balance Sheet'!H53,0)","v":{"v":-10000,"d":"($10,000)"}},{"$f":"ROUND('Balance Sheet'!J53-'Balance Sheet'!I53,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K53-'Balance Sheet'!J53,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L53-'Balance Sheet'!K53,0)","v":{"v":0,"d":"$0"}},{"v":-10000,"d":"($10,000)"}]
[{"$nulls":5},"Deferred income taxes",null,null,{"$f":"ROUND('Balance Sheet'!I54-'Balance Sheet'!H54,0)","v":{"v":-3000,"d":"($3,000)"}},{"$f":"ROUND('Balance Sheet'!J54-'Balance Sheet'!I54,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K54-'Balance Sheet'!J54,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L54-'Balance Sheet'!K54,0)","v":{"v":0,"d":"$0"}},{"v":-3000,"d":"($3,000)"}]
[{"$nulls":5},"Other long-term liabilities",null,null,{"$f":"ROUND('Balance Sheet'!I55-'Balance Sheet'!H55,0)","v":{"v":40000,"d":"$40,000"}},{"$f":"ROUND('Balance Sheet'!J55-'Balance Sheet'!I55,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!K55-'Balance Sheet'!J55,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L55-'Balance Sheet'!K55,0)","v":{"v":0,"d":"$0"}},{"v":-10000,"d":"($10,000)"}]
[{"$nulls":5},{"$f":"IF('Balance Sheet'!H68=\"y\",\"Capital stock and paid in capital\",\"Capital invested\")","v":"Capital stock and paid in capital"},null,null,{"$f":"ROUND(('Balance Sheet'!I60+'Balance Sheet'!I61)-('Balance Sheet'!H60+'Balance Sheet'!H61),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(('Balance Sheet'!J60+'Balance Sheet'!J61)-('Balance Sheet'!I60+'Balance Sheet'!I61),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(('Balance Sheet'!K60+'Balance Sheet'!K61)-('Balance Sheet'!J60+'Balance Sheet'!J61),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(('Balance Sheet'!L60+'Balance Sheet'!L61)-('Balance Sheet'!K60+'Balance Sheet'!K61),0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[]
[{"$nulls":7},"Net cash from financing  ",{"$f":"ROUND(SUM(I47:I52),0)","v":{"v":-123000,"d":"($123,000)"}},{"$f":"ROUND(SUM(J47:J52),0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND(SUM(K47:K52),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(SUM(L47:L52),0)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I54:L54)","v":{"v":-173000,"d":"($173,000)"}}]
[]
[{"$nulls":7},"Net increase (decrease) in cash  ",{"$f":"ROUND(I19+I34-I43+I54,0)","v":{"v":-360640,"d":"($360,640)"}},{"$f":"ROUND(J19+J34-J43+J54,0)","v":{"v":198873,"d":"$198,873"}},{"$f":"ROUND(K19+K34-K43+K54,0)","v":{"v":324963,"d":"$324,963"}},{"$f":"ROUND(L19+L34-L43+L54,0)","v":{"v":653168,"d":"$653,168"}},{"$f":"SUM(I56:L56)","v":{"v":816364,"d":"$816,364"}}]
[]
[{"$nulls":7},"Cash at beginning of period  ",{"$f":"ROUND('Balance Sheet'!H17,0)","v":{"v":451000,"d":"$451,000"}},{"$f":"ROUND('Balance Sheet'!I17,0)","v":{"v":90360,"d":"$90,360"}},{"$f":"ROUND('Balance Sheet'!J17,0)","v":{"v":289233,"d":"$289,233"}},{"$f":"ROUND('Balance Sheet'!K17,0)","v":{"v":614196,"d":"$614,196"}},{"$f":"I58","v":{"v":451000,"d":"$451,000"}}]
[]
[{"$nulls":7},"Cash at the end of period  ",{"$f":"ROUND(SUM(I56:I58),0)","v":{"v":90360,"d":"$90,360"}},{"$f":"ROUND(SUM(J56:J58),0)","v":{"v":289233,"d":"$289,233"}},{"$f":"ROUND(SUM(K56:K58),0)","v":{"v":614196,"d":"$614,196"}},{"$f":"ROUND(SUM(L56:L58),0)","v":{"v":1267364,"d":"$1,267,364"}},{"$f":"SUM(M56:M58)","v":{"v":1267364,"d":"$1,267,364"}}]

{"sheet":"Cash Flow Projections","index":4,"n_rows":60,"n_cols":16,"rows_kept":60,"merged":[[5,3,5,16],[64,3,64,16]]}
[]
[]
[]
[]
[]
[{"$nulls":3},"This sheet displays all the information normally found on a standard cash flow statement.  It is entirely calculated from the information on the Data Entry, Income Statement, and Balance worksheets. "]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"'Balance Sheet'!F13","v":" "},{"$nulls":3},"Current",{"$nulls":3},"Forecasted-Linear Regression Analysis"]
[{"$nulls":8},{"$f":"'Balance Sheet'!I14","v":"1st Qtr"},{"$f":"'Balance Sheet'!J14","v":"2nd Qtr"},{"$f":"'Balance Sheet'!K14","v":"3rd Qtr"},{"$f":"'Balance Sheet'!L14","v":"4th Qtr"},{"$f":"IF('Data Entry'!$G$17=1,CONCATENATE(\"5th \",\"Qtr\"),IF('Data Entry'!$G$17=2,CONCATENATE(\"5th \",\"Year\"),\"Incorrect Entry\"))","v":"5th Qtr"},{"$f":"IF('Data Entry'!$G$17=1,CONCATENATE(\"6th \",\"Qtr\"),IF('Data Entry'!$G$17=2,CONCATENATE(\"6th \",\"Year\"),\"Incorrect Entry\"))","v":"6th Qtr"},{"$f":"IF('Data Entry'!$G$17=1,CONCATENATE(\"7th \",\"Qtr\"),IF('Data Entry'!$G$17=2,CONCATENATE(\"7th \",\"Year\"),\"Incorrect Entry\"))","v":"7th Qtr"},{"$f":"IF('Data Entry'!$G$17=1,CONCATENATE(\"8th \",\"Qtr\"),IF('Data Entry'!$G$17=2,CONCATENATE(\"8th \",\"Year\"),\"Incorrect Entry\"))","v":"8th Qtr"}]
[{"$nulls":4},"Cash from operations",{"$nulls":3},1,2,3,4,5,6,7,8]
[{"$nulls":5},"Net earnings (loss)",null,null,{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!H39,0),ROUND('Income Statement'!H35,0))","v":{"v":490700,"d":"$490,700"}},{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!I39,0),ROUND('Income Statement'!I35,0))","v":{"v":227879,"d":"$227,879"}},{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!J39,0),ROUND('Income Statement'!J35,0))","v":{"v":170059,"d":"$170,059"}},{"$f":"IF('Balance Sheet'!H68=\"y\",ROUND('Income Statement'!K39,0),ROUND('Income Statement'!K35,0))","v":{"v":746609,"d":"$746,609"}},{"$f":"FORECAST($M$15,I16:L16,$I$15:$L$15)","v":{"v":586288.5,"d":"$586,289"}},{"$f":"FORECAST($N$15,I16:M16,$I$15:$M$15)","v":{"v":657279.2,"d":"$657,279"}},{"$f":"FORECAST($O$15,I16:N16,$I$15:$N$15)","v":{"v":728269.9,"d":"$728,270"}},{"$f":"FORECAST($P$15,I16:O16,$I$15:$O$15)","v":{"v":799260.6,"d":"$799,261"}}]
[{"$nulls":5},"Add-depreciation and amortization",null,null,{"$f":"ROUND('Income Statement'!H23+'Income Statement'!H24,0)","v":{"v":33750,"d":"$33,750"}},{"$f":"ROUND('Income Statement'!I23+'Income Statement'!I24,0)","v":{"v":35208,"d":"$35,208"}},{"$f":"ROUND('Income Statement'!J23+'Income Statement'!J24,0)","v":{"v":35208,"d":"$35,208"}},{"$f":"ROUND('Income Statement'!K23+'Income Statement'!K24,0)","v":{"v":35208,"d":"$35,208"}},{"$f":"FORECAST($M$15,I17:L17,$I$15:$L$15)","v":{"v":35937,"d":"$35,937"}},{"$f":"FORECAST($N$15,I17:M17,$I$15:$M$15)","v":{"v":36374.4,"d":"$36,374"}},{"$f":"FORECAST($O$15,I17:N17,$I$15:$N$15)","v":{"v":36811.8,"d":"$36,812"}},{"$f":"FORECAST($P$15,I17:O17,$I$15:$O$15)","v":{"v":37249.200000000004,"d":"$37,249"}}]
[]
[{"$nulls":7},"Net cash from operations  ",{"$f":"ROUND(SUM(I16:I17),0)","v":{"v":524450,"d":"$524,450"}},{"$f":"ROUND(SUM(J16:J17),0)","v":{"v":263087,"d":"$263,087"}},{"$f":"ROUND(SUM(K16:K17),0)","v":{"v":205267,"d":"$205,267"}},{"$f":"ROUND(SUM(L16:L17),0)","v":{"v":781817,"d":"$781,817"}},{"$f":"FORECAST($M$15,I19:L19,$I$15:$L$15)","v":{"v":622225.5,"d":"$622,226"}},{"$f":"FORECAST($N$15,I19:M19,$I$15:$M$15)","v":{"v":693653.6000000001,"d":"$693,654"}},{"$f":"FORECAST($O$15,I19:N19,$I$15:$N$15)","v":{"v":765081.7000000002,"d":"$765,082"}},{"$f":"FORECAST($P$15,I19:O19,$I$15:$O$15)","v":{"v":836509.8,"d":"$836,510"}}]
[]
[{"$nulls":4},"Cash provided (used) by "]
[{"$nulls":4},"operating activities"]
[{"$nulls":5},"Accounts Receivable",null,null,{"$f":"ROUND('Balance Sheet'!H18-'Balance Sheet'!I18,0)","v":{"v":-307534,"d":"($307,534)"}},{"$f":"ROUND('Balance Sheet'!I18-'Balance Sheet'!J18,0)","v":{"v":164383,"d":"$164,383"}},{"$f":"ROUND('Balance Sheet'!J18-'Balance Sheet'!K18,0)","v":{"v":65754,"d":"$65,754"}},{"$f":"ROUND('Balance Sheet'!K18-'Balance Sheet'!L18,0)","v":{"v":-233458,"d":"($233,458)"}},{"$f":"FORECAST($M$15,I23:L23,$I$15:$L$15)","v":{"v":-46814,"d":"($46,814)"}},{"$f":"FORECAST($N$15,I23:M23,$I$15:$M$15)","v":{"v":-34454.09999999999,"d":"($34,454)"}},{"$f":"FORECAST($O$15,I23:N23,$I$15:$N$15)","v":{"v":-22094.199999999997,"d":"($22,094)"}},{"$f":"FORECAST($P$15,I23:O23,$I$15:$O$15)","v":{"v":-9734.299999999988,"d":"($9,734)"}}]
[{"$nulls":5},"Inventory",null,null,{"$f":"ROUND('Balance Sheet'!H19-'Balance Sheet'!I19,0)","v":{"v":-230411,"d":"($230,411)"}},{"$f":"ROUND('Balance Sheet'!I19-'Balance Sheet'!J19,0)","v":{"v":39452,"d":"$39,452"}},{"$f":"ROUND('Balance Sheet'!J19-'Balance Sheet'!K19,0)","v":{"v":15781,"d":"$15,781"}},{"$f":"ROUND('Balance Sheet'!K19-'Balance Sheet'!L19,0)","v":{"v":-117674,"d":"($117,674)"}},{"v":5422,"d":"$5,422"},{"v":36876,"d":"$36,876"},{"v":68330,"d":"$68,330"},{"v":99784,"d":"$99,784"}]
[{"$nulls":5},"Other current assets",null,null,{"$f":"ROUND('Balance Sheet'!H20-'Balance Sheet'!I20,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!I20-'Balance Sheet'!J20,0)","v":{"v":14910,"d":"$14,910"}},{"$f":"ROUND('Balance Sheet'!J20-'Balance Sheet'!K20,0)","v":{"v":-31230,"d":"($31,230)"}},{"$f":"ROUND('Balance Sheet'!K20-'Balance Sheet'!L20,0)","v":{"v":26320,"d":"$26,320"}},{"v":35705,"d":"$35,705"},{"v":53987,"d":"$53,987"},{"v":72269,"d":"$72,269"},{"v":90551,"d":"$90,551"}]
[{"$nulls":5},"Other non-current assets",null,null,{"$f":"ROUND('Balance Sheet'!H36-'Balance Sheet'!I36,0)","v":{"v":-8000,"d":"($8,000)"}},{"$f":"ROUND('Balance Sheet'!I36-'Balance Sheet'!J36,0)","v":{"v":-87000,"d":"($87,000)"}},{"$f":"ROUND('Balance Sheet'!J36-'Balance Sheet'!K36,0)","v":{"v":115000,"d":"$115,000"}},{"$f":"ROUND('Balance Sheet'!K36-'Balance Sheet'!L36,0)","v":{"v":-18000,"d":"($18,000)"}},{"v":43500,"d":"$43,500"},{"v":60700,"d":"$60,700"},{"v":77900,"d":"$77,900"},{"v":95100,"d":"$95,100"}]
[{"$nulls":5},"Accounts payable",null,null,{"$f":"ROUND('Balance Sheet'!I43-'Balance Sheet'!H43,0)","v":{"v":-271233,"d":"($271,233)"}},{"$f":"ROUND('Balance Sheet'!J43-'Balance Sheet'!I43,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K43-'Balance Sheet'!J43,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L43-'Balance Sheet'!K43,0)","v":{"v":0,"d":"$0"}},{"v":135616.5,"d":"$135,617"},{"v":216986.39999999997,"d":"$216,986"},{"v":298356.29999999993,"d":"$298,356"},{"v":379726.2,"d":"$379,726"}]
[{"$nulls":5},"Current portion of long-term debt",null,null,{"$f":"ROUND('Balance Sheet'!I45-'Balance Sheet'!H45,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!J45-'Balance Sheet'!I45,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K45-'Balance Sheet'!J45,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L45-'Balance Sheet'!K45,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[{"$nulls":5},"Income taxes",null,null,{"$f":"ROUND('Balance Sheet'!I46-'Balance Sheet'!H46,0)","v":{"v":153300,"d":"$153,300"}},{"$f":"ROUND('Balance Sheet'!J46-'Balance Sheet'!I46,0)","v":{"v":-112637,"d":"($112,637)"}},{"$f":"ROUND('Balance Sheet'!K46-'Balance Sheet'!J46,0)","v":{"v":-24780,"d":"($24,780)"}},{"$f":"ROUND('Balance Sheet'!L46-'Balance Sheet'!K46,0)","v":{"v":247092,"d":"$247,092"}},{"v":158052,"d":"$158,052"},{"v":194975.3,"d":"$194,975"},{"v":231898.59999999998,"d":"$231,899"},{"v":268821.89999999997,"d":"$268,822"}]
[{"$nulls":5},"Accrued expenses",null,null,{"$f":"ROUND('Balance Sheet'!I47-'Balance Sheet'!H47,0)","v":{"v":-6712,"d":"($6,712)"}},{"$f":"ROUND('Balance Sheet'!J47-'Balance Sheet'!I47,0)","v":{"v":-20822,"d":"($20,822)"}},{"$f":"ROUND('Balance Sheet'!K47-'Balance Sheet'!J47,0)","v":{"v":-8329,"d":"($8,329)"}},{"$f":"ROUND('Balance Sheet'!L47-'Balance Sheet'!K47,0)","v":{"v":29571,"d":"$29,571"}},{"v":28762.5,"d":"$28,763"},{"v":40896.700000000004,"d":"$40,897"},{"v":53030.90000000001,"d":"$53,031"},{"v":65165.100000000006,"d":"$65,165"}]
[{"$nulls":5},"Other current liabilities",null,null,{"$f":"ROUND('Balance Sheet'!I48-'Balance Sheet'!H48,0)","v":{"v":-4000,"d":"($4,000)"}},{"$f":"ROUND('Balance Sheet'!J48-'Balance Sheet'!I48,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K48-'Balance Sheet'!J48,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L48-'Balance Sheet'!K48,0)","v":{"v":0,"d":"$0"}},{"v":2000,"d":"$2,000"},{"v":3200,"d":"$3,200"},{"v":4400,"d":"$4,400"},{"v":5600,"d":"$5,600"}]
[{"$nulls":5},{"$f":"IF('Balance Sheet'!H68=\"y\",\"Dividends paid\",\"Distributions to shareholders\")","v":"Dividends paid"},null,null,{"$f":"ROUND('Income Statement'!H43*-1,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Income Statement'!I43*-1,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Income Statement'!J43*-1,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Income Statement'!K43*-1,0)","v":{"v":-50000,"d":"($50,000)"}},{"v":-50000,"d":"($50,000)"},{"v":-65000,"d":"($65,000)"},{"v":-80000,"d":"($80,000)"},{"v":-95000,"d":"($95,000)"}]
[]
[{"$nulls":7},"Net cash from operations  ",{"$f":"ROUND(SUM(I23:I32),0)","v":{"v":-724590,"d":"($724,590)"}},{"$f":"ROUND(SUM(J23:J32),0)","v":{"v":-1714,"d":"($1,714)"}},{"$f":"ROUND(SUM(K23:K32),0)","v":{"v":132196,"d":"$132,196"}},{"$f":"ROUND(SUM(L23:L32),0)","v":{"v":-116149,"d":"($116,149)"}},{"$f":"FORECAST($M$15,I34:L34,$I$15:$L$15)","v":{"v":312244,"d":"$312,244"}},{"$f":"FORECAST($N$15,I34:M34,$I$15:$M$15)","v":{"v":508167.29999999993,"d":"$508,167"}},{"$f":"FORECAST($O$15,I34:N34,$I$15:$N$15)","v":{"v":704090.5999999999,"d":"$704,091"}},{"$f":"FORECAST($P$15,I34:O34,$I$15:$O$15)","v":{"v":900013.9,"d":"$900,014"}}]
[]
[{"$nulls":4},"Investment transactions"]
[{"$nulls":4},"Increases (decreases)"]
[{"$nulls":5},"Land ",null,null,{"$f":"ROUND('Balance Sheet'!I24-'Balance Sheet'!H24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND('Balance Sheet'!J24-'Balance Sheet'!I24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND('Balance Sheet'!K24-'Balance Sheet'!J24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND('Balance Sheet'!L24-'Balance Sheet'!K24,0)","v":{"v":12500,"d":"$12,500"}},{"$f":"FORECAST($M$15,I38:L38,$I$15:$L$15)","v":{"v":12500,"d":"$12,500"}},{"$f":"FORECAST($N$15,I38:M38,$I$15:$M$15)","v":{"v":12500,"d":"$12,500"}},{"$f":"FORECAST($O$15,I38:N38,$I$15:$N$15)","v":{"v":12500,"d":"$12,500"}},{"$f":"FORECAST($P$15,I38:O38,$I$15:$O$15)","v":{"v":12500,"d":"$12,500"}}]
[{"$nulls":5},"Buildings and improvements",null,null,{"$f":"ROUND('Balance Sheet'!I25-'Balance Sheet'!H25,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!J25-'Balance Sheet'!I25,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K25-'Balance Sheet'!J25,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L25-'Balance Sheet'!K25,0)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($M$15,I39:L39,$I$15:$L$15)","v":{"v":25000,"d":"$25,000"}},{"$f":"FORECAST($N$15,I39:M39,$I$15:$M$15)","v":{"v":40000,"d":"$40,000"}},{"$f":"FORECAST($O$15,I39:N39,$I$15:$N$15)","v":{"v":55000,"d":"$55,000"}},{"$f":"FORECAST($P$15,I39:O39,$I$15:$O$15)","v":{"v":70000,"d":"$70,000"}}]
[{"$nulls":5},"Equipment",null,null,{"$f":"ROUND('Balance Sheet'!I26-'Balance Sheet'!H26,0)","v":{"v":75000,"d":"$75,000"}},{"$f":"ROUND('Balance Sheet'!J26-'Balance Sheet'!I26,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K26-'Balance Sheet'!J26,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L26-'Balance Sheet'!K26,0)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($M$15,I40:L40,$I$15:$L$15)","v":{"v":-37500,"d":"($37,500)"}},{"$f":"FORECAST($N$15,I40:M40,$I$15:$M$15)","v":{"v":-60000,"d":"($60,000)"}},{"$f":"FORECAST($O$15,I40:N40,$I$15:$N$15)","v":{"v":-82500,"d":"($82,500)"}},{"$f":"FORECAST($P$15,I40:O40,$I$15:$O$15)","v":{"v":-105000,"d":"($105,000)"}}]
[{"$nulls":5},"Intangible assets",null,null,{"$f":"ROUND('Balance Sheet'!I32-'Balance Sheet'!H32,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!J32-'Balance Sheet'!I32,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K32-'Balance Sheet'!J32,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L32-'Balance Sheet'!K32,0)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($M$15,I41:L41,$I$15:$L$15)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($N$15,I41:M41,$I$15:$M$15)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($O$15,I41:N41,$I$15:$N$15)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($P$15,I41:O41,$I$15:$O$15)","v":{"v":0,"d":"$0"}}]
[]
[{"$nulls":7},"Net cash from investments  ",{"$f":"ROUND(SUM(I38:I41),0)","v":{"v":37500,"d":"$37,500"}},{"$f":"ROUND(SUM(J38:J41),0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND(SUM(K38:K41),0)","v":{"v":12500,"d":"$12,500"}},{"$f":"ROUND(SUM(L38:L41),0)","v":{"v":12500,"d":"$12,500"}},{"$f":"FORECAST($M$15,I43:L43,$I$15:$L$15)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($N$15,I43:M43,$I$15:$M$15)","v":{"v":-7500,"d":"($7,500)"}},{"$f":"FORECAST($O$15,I43:N43,$I$15:$N$15)","v":{"v":-15000,"d":"($15,000)"}},{"$f":"FORECAST($P$15,I43:O43,$I$15:$O$15)","v":{"v":-22500,"d":"($22,500)"}}]
[]
[{"$nulls":4},"Financing transactions"]
[{"$nulls":4},"Increases (decreases)"]
[{"$nulls":5},"Short term notes payable",null,null,{"$f":"ROUND('Balance Sheet'!I44-'Balance Sheet'!H44,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!J44-'Balance Sheet'!I44,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K44-'Balance Sheet'!J44,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L44-'Balance Sheet'!K44,0)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($M$15,I47:L47,$I$15:$L$15)","v":{"v":25000,"d":"$25,000"}},{"$f":"FORECAST($N$15,I47:M47,$I$15:$M$15)","v":{"v":40000,"d":"$40,000"}},{"$f":"FORECAST($O$15,I47:N47,$I$15:$N$15)","v":{"v":55000,"d":"$55,000"}},{"$f":"FORECAST($P$15,I47:O47,$I$15:$O$15)","v":{"v":70000,"d":"$70,000"}}]
[{"$nulls":5},"Long term debt",null,null,{"$f":"ROUND('Balance Sheet'!I52-'Balance Sheet'!H52,0)","v":{"v":-100000,"d":"($100,000)"}},{"$f":"ROUND('Balance Sheet'!J52-'Balance Sheet'!I52,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K52-'Balance Sheet'!J52,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L52-'Balance Sheet'!K52,0)","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000"},{"v":80000,"d":"$80,000"},{"v":110000,"d":"$110,000"},{"v":140000,"d":"$140,000"}]
[{"$nulls":5},"Deferred income",null,null,{"$f":"ROUND('Balance Sheet'!I53-'Balance Sheet'!H53,0)","v":{"v":-10000,"d":"($10,000)"}},{"$f":"ROUND('Balance Sheet'!J53-'Balance Sheet'!I53,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K53-'Balance Sheet'!J53,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L53-'Balance Sheet'!K53,0)","v":{"v":0,"d":"$0"}},{"v":5000,"d":"$5,000"},{"v":8000,"d":"$8,000"},{"v":11000,"d":"$11,000"},{"v":14000,"d":"$14,000"}]
[{"$nulls":5},"Deferred income taxes",null,null,{"$f":"ROUND('Balance Sheet'!I54-'Balance Sheet'!H54,0)","v":{"v":-3000,"d":"($3,000)"}},{"$f":"ROUND('Balance Sheet'!J54-'Balance Sheet'!I54,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!K54-'Balance Sheet'!J54,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L54-'Balance Sheet'!K54,0)","v":{"v":0,"d":"$0"}},{"v":1500,"d":"$1,500"},{"v":2400,"d":"$2,400"},{"v":3300,"d":"$3,300"},{"v":4200,"d":"$4,200"}]
[{"$nulls":5},"Other long-term liabilities",null,null,{"$f":"ROUND('Balance Sheet'!I55-'Balance Sheet'!H55,0)","v":{"v":40000,"d":"$40,000"}},{"$f":"ROUND('Balance Sheet'!J55-'Balance Sheet'!I55,0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND('Balance Sheet'!K55-'Balance Sheet'!J55,0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND('Balance Sheet'!L55-'Balance Sheet'!K55,0)","v":{"v":0,"d":"$0"}},{"v":-20000,"d":"($20,000)"},{"v":-27000,"d":"($27,000)"},{"v":-34000,"d":"($34,000)"},{"v":-41000,"d":"($41,000)"}]
[{"$nulls":5},{"$f":"IF('Balance Sheet'!H68=\"y\",\"Capital stock and paid in capital\",\"Capital invested\")","v":"Capital stock and paid in capital"},null,null,{"$f":"ROUND(('Balance Sheet'!I60+'Balance Sheet'!I61)-('Balance Sheet'!H60+'Balance Sheet'!H61),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(('Balance Sheet'!J60+'Balance Sheet'!J61)-('Balance Sheet'!I60+'Balance Sheet'!I61),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(('Balance Sheet'!K60+'Balance Sheet'!K61)-('Balance Sheet'!J60+'Balance Sheet'!J61),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(('Balance Sheet'!L60+'Balance Sheet'!L61)-('Balance Sheet'!K60+'Balance Sheet'!K61),0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[{"$nulls":7},"Net cash from financing  ",{"$f":"ROUND(SUM(I47:I52),0)","v":{"v":-123000,"d":"($123,000)"}},{"$f":"ROUND(SUM(J47:J52),0)","v":{"v":-50000,"d":"($50,000)"}},{"$f":"ROUND(SUM(K47:K52),0)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(SUM(L47:L52),0)","v":{"v":0,"d":"$0"}},{"$f":"FORECAST($M$15,I54:L54,$I$15:$L$15)","v":{"v":61500,"d":"$61,500"}},{"$f":"FORECAST($N$15,I54:M54,$I$15:$M$15)","v":{"v":103400,"d":"$103,400"}},{"$f":"FORECAST($O$15,I54:N54,$I$15:$N$15)","v":{"v":145300,"d":"$145,300"}},{"$f":"FORECAST($P$15,I54:O54,$I$15:$O$15)","v":{"v":187200,"d":"$187,200"}}]
[]
[{"$nulls":7},"Net increase (decrease) in cash  ",{"$f":"ROUND(I19+I34-I43+I54,0)","v":{"v":-360640,"d":"($360,640)"}},{"$f":"ROUND(J19+J34-J43+J54,0)","v":{"v":198873,"d":"$198,873"}},{"$f":"ROUND(K19+K34-K43+K54,0)","v":{"v":324963,"d":"$324,963"}},{"$f":"ROUND(L19+L34-L43+L54,0)","v":{"v":653168,"d":"$653,168"}},{"$f":"FORECAST($M$15,I56:L56,$I$15:$L$15)","v":{"v":995969.5,"d":"$995,970"}},{"$f":"FORECAST($N$15,I56:M56,$I$15:$M$15)","v":{"v":1312720.9000000001,"d":"$1,312,721"}},{"$f":"FORECAST($O$15,I56:N56,$I$15:$N$15)","v":{"v":1629472.3000000003,"d":"$1,629,472"}},{"$f":"FORECAST($P$15,I56:O56,$I$15:$O$15)","v":{"v":1946223.7000000002,"d":"$1,946,224"}}]
[]
[{"$nulls":7},"Cash at beginning of period  ",{"$f":"ROUND('Balance Sheet'!H17,0)","v":{"v":451000,"d":"$451,000"}},{"$f":"ROUND('Balance Sheet'!I17,0)","v":{"v":90360,"d":"$90,360"}},{"$f":"ROUND('Balance Sheet'!J17,0)","v":{"v":289233,"d":"$289,233"}},{"$f":"ROUND('Balance Sheet'!K17,0)","v":{"v":614196,"d":"$614,196"}},{"$f":"FORECAST($M$15,I58:L58,$I$15:$L$15)","v":{"v":533312.5,"d":"$533,313"}},{"$f":"FORECAST($N$15,I58:M58,$I$15:$M$15)","v":{"v":602158.6,"d":"$602,159"}},{"$f":"FORECAST($O$15,I58:N58,$I$15:$N$15)","v":{"v":671004.7000000001,"d":"$671,005"}},{"$f":"FORECAST($P$15,I58:O58,$I$15:$O$15)","v":{"v":739850.8,"d":"$739,851"}}]
[]
[{"$nulls":7},"Cash at the end of period  ",{"$f":"ROUND(SUM(I56:I58),0)","v":{"v":90360,"d":"$90,360"}},{"$f":"ROUND(SUM(J56:J58),0)","v":{"v":289233,"d":"$289,233"}},{"$f":"ROUND(SUM(K56:K58),0)","v":{"v":614196,"d":"$614,196"}},{"$f":"ROUND(SUM(L56:L58),0)","v":{"v":1267364,"d":"$1,267,364"}},{"$f":"FORECAST($M$15,I60:L60,$I$15:$L$15)","v":{"v":1529282,"d":"$1,529,282"}},{"$f":"FORECAST($N$15,I60:M60,$I$15:$M$15)","v":{"v":1914879.5,"d":"$1,914,880"}},{"$f":"FORECAST($O$15,I60:N60,$I$15:$N$15)","v":{"v":2300477,"d":"$2,300,477"}},{"$f":"FORECAST($P$15,I60:O60,$I$15:$O$15)","v":{"v":2686074.5,"d":"$2,686,075"}}]

{"sheet":"Data Chart","index":5,"n_rows":6,"n_cols":4,"rows_kept":6,"merged":[[34,3,34,13]]}
[]
[]
[]
[]
[]
[{"$nulls":3},"This sheet displays quarterly operating turnover information from the Data Sheet."]

{"sheet":"Asset Chart","index":6,"n_rows":6,"n_cols":4,"rows_kept":6,"merged":[[34,3,34,13]]}
[]
[]
[]
[]
[]
[{"$nulls":3},"This sheet shows the distribution of assets per quarter for the company. "]

{"sheet":"Income Chart","index":7,"n_rows":6,"n_cols":4,"rows_kept":6,"merged":[[35,3,35,13]]}
[]
[]
[]
[]
[]
[{"$nulls":3},"This sheet displays the quarterly distribution of income for the company. "]