{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cash Flow Forecast 12 Months"],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Cash Flow Forecast 12 Months","index":0,"n_rows":49,"n_cols":17,"rows_kept":49,"merged":[[50,2,50,16]]}
[]
[]
[]
[null,null,"Cash Flow Forecast - 12 Months"]
[]
[]
[]
[null,null,"Month:","Pre-Start",{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"v":5,"d":"5 "},{"v":6,"d":"6 "},{"v":7,"d":"7 "},{"v":8,"d":"8 "},{"v":9,"d":"9 "},{"v":10,"d":"10 "},{"v":11,"d":"11 "},{"v":12,"d":"12 "},"Totals"]
[]
[null,null,"Receipts",{"$nulls":13}," "]
[null,null,"Cash sales",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":10020,"d":"10,020 "},{"v":10855,"d":"10,855 "},{"v":12525,"d":"12,525 "},{"v":14195,"d":"14,195 "},{"v":15865,"d":"15,865 "},{"v":18370,"d":"18,370 "},{"v":21710,"d":"21,710 "},{"v":24215,"d":"24,215 "},{"v":26406,"d":"26,406 "},{"v":28808,"d":"28,808 "},{"v":33066,"d":"33,066 "},{"$f":"SUM(D11:P11)","v":{"v":216035,"d":"216,035 "}}]
[null,null,"Collections from credit sales",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":251,"d":"251 "},{"v":418,"d":"418 "},{"v":501,"d":"501 "},{"v":501,"d":"501 "},{"v":585,"d":"585 "},{"v":752,"d":"752 "},{"v":752,"d":"752 "},{"v":1002,"d":"1,002 "},{"v":1002,"d":"1,002 "},{"v":1166,"d":"1,166 "},{"$f":"SUM(D12:P12)","v":{"v":6930,"d":"6,930 "}}]
[null,null,"New equity inflow",{"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 "},{"v":0,"d":"0 "}]
[null,null,"Loans received",{"v":0,"d":"0 "},{"v":16700,"d":"16,700 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":8350,"d":"8,350 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":8350,"d":"8,350 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":8350,"d":"8,350 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":41750,"d":"41,750 "}]
[null,null,"Other",{"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 "},{"v":0,"d":"0 "}]
[null,null,"Total Receipts",{"$f":"SUM(D11:D15)","v":{"v":0,"d":"0 "}},{"v":16700,"d":"16,700 "},{"v":10020,"d":"10,020 "},{"v":11106,"d":"11,106 "},{"v":21293,"d":"21,293 "},{"v":14696,"d":"14,696 "},{"v":16366,"d":"16,366 "},{"v":27305,"d":"27,305 "},{"v":22462,"d":"22,462 "},{"v":24967,"d":"24,967 "},{"v":35758,"d":"35,758 "},{"v":29810,"d":"29,810 "},{"v":34232,"d":"34,232 "},{"v":264715,"d":"264,715 "}]
[]
[null,null,"Payments"]
[null,null,"Cash purchases",{"v":0,"d":"0 "},{"v":401,"d":"401 "},{"v":326,"d":"326 "},{"v":166,"d":"166 "},{"v":131,"d":"131 "},{"v":237,"d":"237 "},{"v":166,"d":"166 "},{"v":149,"d":"149 "},{"v":149,"d":"149 "},{"v":166,"d":"166 "},{"v":113,"d":"113 "},{"v":113,"d":"113 "},{"v":167,"d":"167 "},{"v":2284,"d":"2,284 "}]
[null,null,"Payments to creditors",{"v":0,"d":"0 "},{"v":1203,"d":"1,203 "},{"v":978,"d":"978 "},{"v":499,"d":"499 "},{"v":392,"d":"392 "},{"v":713,"d":"713 "},{"v":499,"d":"499 "},{"v":446,"d":"446 "},{"v":446,"d":"446 "},{"v":499,"d":"499 "},{"v":339,"d":"339 "},{"v":339,"d":"339 "},{"v":503,"d":"503 "},{"v":6856,"d":"6,856 "}]
[null,null,"Salaries and wages",{"v":0,"d":"0 "},{"v":6304,"d":"6,304 "},{"v":5120,"d":"5,120 "},{"v":2620,"d":"2,620 "},{"v":2058,"d":"2,058 "},{"v":3728,"d":"3,728 "},{"v":2620,"d":"2,620 "},{"v":2336,"d":"2,336 "},{"v":2336,"d":"2,336 "},{"v":2620,"d":"2,620 "},{"v":1780,"d":"1,780 "},{"v":1780,"d":"1,780 "},{"v":2631,"d":"2,631 "},{"v":35933,"d":"35,933 "}]
[null,null,"Employee benefits",{"v":0,"d":"0 "},{"v":3152,"d":"3,152 "},{"v":2560,"d":"2,560 "},{"v":1310,"d":"1,310 "},{"v":1029,"d":"1,029 "},{"v":1864,"d":"1,864 "},{"v":1310,"d":"1,310 "},{"v":1168,"d":"1,168 "},{"v":1168,"d":"1,168 "},{"v":1310,"d":"1,310 "},{"v":890,"d":"890 "},{"v":890,"d":"890 "},{"v":1315,"d":"1,315 "},{"v":17966,"d":"17,966 "}]
[null,null,"Payroll taxes",{"v":0,"d":"0 "},{"v":1051,"d":"1,051 "},{"v":853,"d":"853 "},{"v":437,"d":"437 "},{"v":343,"d":"343 "},{"v":621,"d":"621 "},{"v":437,"d":"437 "},{"v":389,"d":"389 "},{"v":389,"d":"389 "},{"v":437,"d":"437 "},{"v":297,"d":"297 "},{"v":297,"d":"297 "},{"v":438,"d":"438 "},{"v":5989,"d":"5,989 "}]
[null,null,"Rent",{"v":0,"d":"0 "},{"v":5253,"d":"5,253 "},{"v":4267,"d":"4,267 "},{"v":2183,"d":"2,183 "},{"v":1715,"d":"1,715 "},{"v":3107,"d":"3,107 "},{"v":2183,"d":"2,183 "},{"v":1947,"d":"1,947 "},{"v":1947,"d":"1,947 "},{"v":2183,"d":"2,183 "},{"v":1483,"d":"1,483 "},{"v":1483,"d":"1,483 "},{"v":2192,"d":"2,192 "},{"v":29943,"d":"29,943 "}]
[null,null,"Utiltities",{"v":0,"d":"0 "},{"v":1021,"d":"1,021 "},{"v":830,"d":"830 "},{"v":425,"d":"425 "},{"v":333,"d":"333 "},{"v":604,"d":"604 "},{"v":425,"d":"425 "},{"v":379,"d":"379 "},{"v":379,"d":"379 "},{"v":425,"d":"425 "},{"v":288,"d":"288 "},{"v":288,"d":"288 "},{"v":426,"d":"426 "},{"v":5823,"d":"5,823 "}]
[null,null,"Repairs and maintenance",{"v":0,"d":"0 "},{"v":584,"d":"584 "},{"v":474,"d":"474 "},{"v":243,"d":"243 "},{"v":191,"d":"191 "},{"v":345,"d":"345 "},{"v":243,"d":"243 "},{"v":216,"d":"216 "},{"v":216,"d":"216 "},{"v":243,"d":"243 "},{"v":165,"d":"165 "},{"v":165,"d":"165 "},{"v":244,"d":"244 "},{"v":3329,"d":"3,329 "}]
[null,null,"Insurance",{"v":0,"d":"0 "},{"v":1021,"d":"1,021 "},{"v":830,"d":"830 "},{"v":425,"d":"425 "},{"v":333,"d":"333 "},{"v":604,"d":"604 "},{"v":425,"d":"425 "},{"v":379,"d":"379 "},{"v":379,"d":"379 "},{"v":425,"d":"425 "},{"v":288,"d":"288 "},{"v":288,"d":"288 "},{"v":426,"d":"426 "},{"v":5823,"d":"5,823 "}]
[null,null,"Travel",{"v":0,"d":"0 "},{"v":1240,"d":"1,240 "},{"v":1007,"d":"1,007 "},{"v":515,"d":"515 "},{"v":405,"d":"405 "},{"v":734,"d":"734 "},{"v":515,"d":"515 "},{"v":460,"d":"460 "},{"v":460,"d":"460 "},{"v":515,"d":"515 "},{"v":350,"d":"350 "},{"v":350,"d":"350 "},{"v":518,"d":"518 "},{"v":7069,"d":"7,069 "}]
[null,null,"Telephone",{"v":0,"d":"0 "},{"v":1043,"d":"1,043 "},{"v":847,"d":"847 "},{"v":434,"d":"434 "},{"v":341,"d":"341 "},{"v":617,"d":"617 "},{"v":434,"d":"434 "},{"v":387,"d":"387 "},{"v":387,"d":"387 "},{"v":434,"d":"434 "},{"v":295,"d":"295 "},{"v":295,"d":"295 "},{"v":435,"d":"435 "},{"v":5949,"d":"5,949 "}]
[null,null,"Postage",{"v":0,"d":"0 "},{"v":438,"d":"438 "},{"v":358,"d":"358 "},{"v":182,"d":"182 "},{"v":143,"d":"143 "},{"v":259,"d":"259 "},{"v":182,"d":"182 "},{"v":162,"d":"162 "},{"v":162,"d":"162 "},{"v":182,"d":"182 "},{"v":124,"d":"124 "},{"v":124,"d":"124 "},{"v":183,"d":"183 "},{"v":2499,"d":"2,499 "}]
[null,null,"Office supplies",{"v":0,"d":"0 "},{"v":949,"d":"949 "},{"v":770,"d":"770 "},{"v":394,"d":"394 "},{"v":310,"d":"310 "},{"v":561,"d":"561 "},{"v":394,"d":"394 "},{"v":352,"d":"352 "},{"v":352,"d":"352 "},{"v":394,"d":"394 "},{"v":268,"d":"268 "},{"v":268,"d":"268 "},{"v":396,"d":"396 "},{"v":5408,"d":"5,408 "}]
[null,null,"Advertising",{"v":0,"d":"0 "},{"v":6938,"d":"6,938 "},{"v":5635,"d":"5,635 "},{"v":2883,"d":"2,883 "},{"v":2265,"d":"2,265 "},{"v":4103,"d":"4,103 "},{"v":2883,"d":"2,883 "},{"v":2571,"d":"2,571 "},{"v":2571,"d":"2,571 "},{"v":2883,"d":"2,883 "},{"v":1959,"d":"1,959 "},{"v":1959,"d":"1,959 "},{"v":2895,"d":"2,895 "},{"v":39545,"d":"39,545 "}]
[null,null,"Marketing/promotion",{"v":0,"d":"0 "},{"v":5439,"d":"5,439 "},{"v":4418,"d":"4,418 "},{"v":2261,"d":"2,261 "},{"v":1776,"d":"1,776 "},{"v":3217,"d":"3,217 "},{"v":2261,"d":"2,261 "},{"v":2016,"d":"2,016 "},{"v":2016,"d":"2,016 "},{"v":2261,"d":"2,261 "},{"v":1536,"d":"1,536 "},{"v":1536,"d":"1,536 "},{"v":2270,"d":"2,270 "},{"v":31007,"d":"31,007 "}]
[null,null,"Professional fees",{"v":0,"d":"0 "},{"v":1751,"d":"1,751 "},{"v":1422,"d":"1,422 "},{"v":728,"d":"728 "},{"v":572,"d":"572 "},{"v":1036,"d":"1,036 "},{"v":728,"d":"728 "},{"v":649,"d":"649 "},{"v":649,"d":"649 "},{"v":728,"d":"728 "},{"v":494,"d":"494 "},{"v":494,"d":"494 "},{"v":731,"d":"731 "},{"v":9982,"d":"9,982 "}]
[null,null,"Training and development",{"v":0,"d":"0 "},{"v":26,"d":"26 "},{"v":21,"d":"21 "},{"v":11,"d":"11 "},{"v":9,"d":"9 "},{"v":16,"d":"16 "},{"v":11,"d":"11 "},{"v":10,"d":"10 "},{"v":10,"d":"10 "},{"v":11,"d":"11 "},{"v":7,"d":"7 "},{"v":7,"d":"7 "},{"v":11,"d":"11 "},{"v":150,"d":"150 "}]
[null,null,"Bank charges",{"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 "},{"v":0,"d":"0 "}]
[null,null,"Miscellaneous",{"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 "},{"v":0,"d":"0 "}]
[null,null,"Owner's drawings",{"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 "},{"v":0,"d":"0 "}]
[null,null,"Loan repayments",{"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 "},{"v":0,"d":"0 "}]
[null,null,"Tax payments",{"v":0,"d":"0 "},{"v":25050,"d":"25,050 "},{"v":0,"d":"0 "},{"v":4175,"d":"4,175 "},{"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":29225,"d":"29,225 "}]
[null,null,"Capital purchases",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":10000,"d":"10,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":10000,"d":"10,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":21325,"d":"21,325 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":41325,"d":"41,325 "}]
[null,null,"Other",{"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,null,{"v":0,"d":"0 "}]
[null,null,"Total Payments",{"$f":"SUM(D19:D42)","v":{"v":0,"d":"0 "}},{"v":62864,"d":"62,864 "},{"v":30716,"d":"30,716 "},{"v":19891,"d":"19,891 "},{"v":22346,"d":"22,346 "},{"v":22366,"d":"22,366 "},{"v":15716,"d":"15,716 "},{"v":24016,"d":"24,016 "},{"v":14016,"d":"14,016 "},{"v":15716,"d":"15,716 "},{"v":32001,"d":"32,001 "},{"v":10676,"d":"10,676 "},{"v":15781,"d":"15,781 "},{"v":286105,"d":"286,105 "}]
[]
[null,null,"Cashflow Surplus/Deficit (-)",{"$f":"D16-D43","v":{"v":0,"d":"0 "}},{"v":-46164,"d":"(46,164)"},{"v":-20696,"d":"(20,696)"},{"v":-8785,"d":"(8,785)"},{"v":-1053,"d":"(1,053)"},{"v":-7670,"d":"(7,670)"},{"v":650,"d":"650 "},{"v":3289,"d":"3,289 "},{"v":8446,"d":"8,446 "},{"v":9251,"d":"9,251 "},{"v":3757,"d":"3,757 "},{"v":19134,"d":"19,134 "},{"v":18451,"d":"18,451 "},{"v":-21390,"d":"(21,390)"}]
[]
[null,null,"Opening Cash Balance",{"v":0,"d":"0 "},{"$f":"D49","v":{"v":0,"d":"0 "}},{"v":-46164,"d":"(46,164)"},{"v":-66860,"d":"(66,860)"},{"v":-75645,"d":"(75,645)"},{"v":-76698,"d":"(76,698)"},{"v":-84368,"d":"(84,368)"},{"v":-83718,"d":"(83,718)"},{"v":-80429,"d":"(80,429)"},{"v":-71983,"d":"(71,983)"},{"v":-62732,"d":"(62,732)"},{"v":-58975,"d":"(58,975)"},{"v":-39841,"d":"(39,841)"},{"v":-747413,"d":"(747,413)"}]
[]
[null,null,"Closing Cash Balance",{"$f":"D47+D45","v":{"v":0,"d":"0 "}},{"$f":"E47+E45","v":{"v":-46164,"d":"(46,164)"}},{"$f":"F47+F45","v":{"v":-66860,"d":"(66,860)"}},{"v":-75645,"d":"(75,645)"},{"v":-76698,"d":"(76,698)"},{"v":-84368,"d":"(84,368)"},{"v":-83718,"d":"(83,718)"},{"v":-80429,"d":"(80,429)"},{"v":-71983,"d":"(71,983)"},{"v":-62732,"d":"(62,732)"},{"v":-58975,"d":"(58,975)"},{"v":-39841,"d":"(39,841)"},{"v":-21390,"d":"(21,390)"},{"v":-768803,"d":"(768,803)"}]