{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Q3 CF"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"Q3 CF","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[1,1,1,2],[1,5,1,6],[6,5,6,6],[16,1,16,2],[21,1,21,2]]}
[]
[null,"CF From Ops ",null,"pts ",null,"Check "]
[null,"NI ",{"$f":"'[1]Q3 IS '!D20","v":{"v":1560,"d":"1,560"}},0.5,null,"Change in A/D ",{"$f":"C6+G9","v":110}]
[{"$nulls":5},"Change in RE ",{"$f":"'[1]Q3 IS '!D20-'[1]Q3 BS'!D20-1000","v":60}]
[null,"Non-Cash: ",{"$nulls":3},"Change in PP&E ",{"$f":"'[1]Q3 BS'!D11-'[1]Q3 BS'!E11","v":800}]
[null,"Depreciation ",{"$f":"'[1]Q3 IS '!D9","v":210},2]
[null,"Bad Debt ",{"$f":"'[1]Q3 IS '!D8","v":300},2,null,"Events "]
[null,"Gain on sale of Property",{"$f":"-'[1]Q3 IS '!D16","v":-400},2,null,"BV of Property Sold ",400]
[{"$nulls":5},"A/D on Property Sold ",-100]
[null,"Changes in BS: ",{"$nulls":3},"2012 Dividends Declared ",500]
[null,"A/R ",{"$f":"'[1]Q3 BS'!E5-'[1]Q3 BS'!D5","v":{"v":-1700,"d":"-1,700"}},2,null,"2011 Dividends Paid ",{"$f":"'[1]Q3 IS '!D20-'Q3 CF'!G10-('[1]Q3 BS'!D33-'[1]Q3 BS'!E33)","v":{"v":1000,"d":"1,000"}},"plug ",null,20]
[null,"Inventory",{"$f":"'[1]Q3 BS'!E7-'[1]Q3 BS'!D7","v":-400},2,{"$nulls":5},30]
[null,"A/P ",{"$f":"'[1]Q3 BS'!D19-'[1]Q3 BS'!E19","v":330},2,{"$nulls":5},19.5]
[null,"Other Current Liab",{"$f":"'[1]Q3 BS'!D21-'[1]Q3 BS'!E21","v":400},2,{"$nulls":5},8]
[null,"CF from Ops ",{"$f":"SUM(C3:C14)","v":300}]
[]
[null,"CF From Investing ",{"$nulls":3},{"$f":"100/1020","v":0.09803921568627451}]
[null,"Cash from Property Sale ",{"$f":"G8+G9+'[1]Q3 IS '!D16","v":700},2,null,{"$f":"100/520","v":0.19230769230769232}]
[null,"Purchase of PP&E ",{"$f":"'[1]Q3 BS'!E11-'[1]Q3 BS'!D11-G8","v":{"v":-1200,"d":"-1,200"}},2,null,{"$f":"520/1020","v":0.5098039215686274}]
[null,"CF from Investing ",{"$f":"SUM(C18:C19)","v":-500},null,null,{"$f":"80/980","v":0.08163265306122448}]
[{"$nulls":5},{"$f":"80/480","v":0.16666666666666666}]
[null,"CF From Financing ",{"$nulls":3},{"$f":"500/980","v":0.5102040816326531}]
[null,"Div Paid ",{"$f":"-G11","v":{"v":-1000,"d":"-1,000"}},2]
[null,"Loan ",2600,2]
[null,"Cash from Stock ",2000,2]
[null,"CF from Financing ",{"$f":"SUM(C23:C25)","v":3600}]
[]
[null,"Net Change in Cash ",{"$f":"C15+C20+C26","v":{"v":3400,"d":"3,400"}},0.5]
[null,"Beg Cash Balance ",{"$f":"'[1]Q3 BS'!E4","v":{"v":4600,"d":"4,600"}}]
[null,"Ending Cash Balance ",{"$f":"'[1]Q3 BS'!D4","v":{"v":8000,"d":"8,000"}}]
[null,"Check ",{"$f":"C28-(C30-C29)","v":0},{"$f":"SUM(D3:D30)","v":25}]