{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Cash Flow Tracker","Chart"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart","index":1,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Cash Flow Tracker","index":0,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,2,1,6],[5,2,5,4],[7,2,7,4],[2,2,2,5],[4,2,4,4]],"flags":["formulas_cached_only"]}
[]
[null,null,"Cash Flow Tracker"]
[null,null,"Dark gray cells will be calculated for you. You do not need to enter anything into them."]
[null,null,"Cash flow summary",null,null,"Initial Cash Balance"]
[]
[null,null,"Initial cash balance",null,null,78925.34]
[]
[null,null,"Final cash balance",null,null,403473.33999999997]
[]
[null,null,"Operating cash flow"]
[null,null,"Operating income"]
[null,null,"Customer receipts",null,null,416528]
[null,null,"Miscellaneous receipts",null,null,8213]
[null,null,"        Total operating income",null,null,424741]
[null,null,"Operating expenses"]
[null,null,"Inventory costs",null,null,16528]
[null,null,"Insurance",null,null,8213]
[null,null,"Lease",null,null,16528]
[null,null,"Advertising",null,null,8213]
[null,null,"Payroll",null,null,239257]
[null,null,"Other",null,null,7458]
[null,null,"Interest paid",null,null,1112]
[null,null,"Taxes",null,null,7458]
[null,null,"        Total operating expenses",null,null,304767]
[null,null,null,null,"Operating Cash Flow",119974]
[null,null,"Investment cash flow"]
[null,null,"Investment income"]
[null,null,"Sale of property",null,null,216528]
[null,null,"Liquidation of investments",null,null,8213]
[null,null,"     Total investment income",null,null,224741]
[null,null,"Investment expenses"]
[null,null,"Payments",null,null,5528]
[null,null,"Capital expenditures",null,null,8213]
[null,null,"Purchases",null,null,6528]
[null,null,"Other",null,null,8213]
[null,null,"     Total investment expenses",null,null,28482]
[null,null,null,null,"Investment Cash Flow",196259]
[null,null,"Financing cash flow"]
[null,null,"Financing income"]
[null,null,"New borrowing",null,null,16528]
[null,null,"Stock issuance",null,null,8213]
[null,null,"Capital contributions",null,null,16528]
[null,null,"     Total financing income",null,null,41269]
[null,null,"Financing expenses"]
[null,null,"Loan repayments",null,null,8213]
[null,null,"Dividends paid",null,null,16528]
[null,null,"Other distributions",null,null,8213]
[null,null,"     Total financing expenses",null,null,32954]
[null,null,null,null,null,8315]