| Sources and Uses of Cash | |||||||||||||||||||||||||||||||||||||||
| (Indirect Cash Flow Method) | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Year 2 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||
| Sources of Cash | |||||||||||||||||||||||||||||||||||||||
| Net Income | ($648) | ($356) | $3,442 | $3,121 | ($404) | $795 | $4,209 | $3,956 | $3,801 | $3,345 | $2,506 | $2,236 | $26,004 | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($608) | $31,584 | $32,002 | ($224) | ($224) | |||||||||
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Increase in Accounts Payable | $1,148 | $1,086 | $8,036 | $0 | $0 | $496 | $7,355 | $0 | $0 | $173 | $0 | $0 | $18,295 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,959 | $209 | $0 | $0 | |||||||||
| Decrease in Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Decrease in Inventory | $160 | $0 | $0 | $924 | $318 | $1,305 | $0 | $646 | $580 | $107 | $880 | $355 | $5,275 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| New Loans | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| New Investment | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $200 | $200 | $200 | $200 | $200 | $1,200 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Sales Taxes (VAT/GST) Collected | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Sale of Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Subtotal Sources of Cash | $660 | $730 | $11,479 | $4,045 | ($87) | $2,596 | $11,764 | $4,802 | $4,581 | $3,826 | $3,586 | $2,791 | $50,774 | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($608) | $33,543 | $32,211 | ($224) | ($224) | |||||||||
| Use of Cash | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Year 2 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||
| Decrease in Accounts Payable | $0 | $0 | $0 | $5,481 | $4,029 | $0 | $0 | $3,346 | $512 | $0 | $1,869 | $246 | $15,483 | $2,763 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,763 | $0 | $0 | $4,961 | $0 | |||||||||
| Increase in Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Increase in Inventory | $0 | $255 | $3,267 | $0 | $0 | $0 | $2,118 | $0 | $0 | $0 | $0 | $0 | $5,640 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,291 | $416 | $0 | $0 | |||||||||
| Repay Loans | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $2,400 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,400 | $2,400 | $0 | $0 | |||||||||
| Purchase Other Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Distributions | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Sales Tax Payment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Subtotal Uses of Cash | $200 | $455 | $3,467 | $5,681 | $4,229 | $200 | $2,318 | $3,546 | $712 | $200 | $2,069 | $446 | $23,522 | $2,763 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,763 | $4,691 | $2,816 | $4,961 | $0 | |||||||||
| Net Cash Flow | $460 | $275 | $8,012 | ($1,636) | ($4,316) | $2,396 | $9,447 | $1,257 | $3,870 | $3,626 | $1,517 | $2,345 | $27,252 | ($2,814) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($51) | ($3,371) | $28,852 | $29,396 | ($5,185) | ($224) | |||||||||
| Cash Balance | $13,960 | $14,235 | $22,247 | $20,611 | $16,295 | $18,691 | $28,138 | $29,395 | $33,265 | $36,890 | $38,407 | $40,752 | $40,752 | $37,938 | $37,888 | $37,837 | $37,786 | $37,736 | $37,685 | $37,634 | $37,584 | $37,533 | $37,482 | $37,432 | $37,381 | $37,381 | $69,604 | $99,000 | $93,814 | $93,590 | |||||||||