| Number Of Periods To Forecast | 12 | ||||||||||||
| (Enter a number between 1-12.) | |||||||||||||
| Cash Projection Summary | Totals | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |
| Enter Beginning Cash Amount | |||||||||||||
| Beginning Cash | 6,322 | 6,322 | (6,890) | (3,154) | (4,196) | (4,429) | (6,310) | (4,247) | (5,663) | (3,699) | (4,541) | (9,193) | (4,886) |
| Plus: | |||||||||||||
| Cash Collections | |||||||||||||
| Accounts Receivable-Collections Prior Period | 35,000 | 30,000 | 5,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Receivable-Collections Current Periods | 407,459 | 4,733 | 30,913 | 34,225 | 36,870 | 33,303 | 39,085 | 33,629 | 41,510 | 35,459 | 33,431 | 43,328 | 40,973 |
| Cash Sales | 49,948 | 3,380 | 3,730 | 4,196 | 3,555 | 4,488 | 3,555 | 4,721 | 4,022 | 3,497 | 4,896 | 4,371 | 5,537 |
| Sale Of Equipment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Owner's Investments / Stock Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Receipts and Collections | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Cash Collections | 492,407 | 38,113 | 39,643 | 38,421 | 40,425 | 37,791 | 42,640 | 38,350 | 45,532 | 38,956 | 38,327 | 47,699 | 46,510 |
| Less: | |||||||||||||
| Cash Payments | |||||||||||||
| Accounts Payable Payments-Prior Periods | 22,800 | 22,800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Amounts Owed Prior Period | 5,500 | 5,500 | 0 | 0 | |||||||||
| Accounts Payable Payments-Current Periods | 220,373 | 0 | 16,343 | 19,383 | 19,361 | 19,201 | 21,065 | 17,196 | 23,248 | 20,132 | 20,350 | 22,555 | 21,539 |
| Cash Purchases | 27,316 | 1,816 | 2,154 | 2,151 | 2,133 | 2,341 | 1,911 | 2,583 | 2,237 | 2,261 | 2,506 | 2,393 | 2,830 |
| Payroll Expenses | 56,068 | 5,391 | 4,313 | 4,313 | 5,391 | 4,313 | 4,313 | 5,391 | 4,313 | 4,313 | 5,391 | 4,313 | 4,313 |
| Operating Expense Payments | 109,450 | 8,818 | 8,550 | 8,959 | 8,971 | 9,215 | 8,396 | 9,995 | 8,806 | 8,345 | 10,148 | 9,113 | 10,136 |
| Sales Tax | 17,270 | 3,500 | 1,048 | 1,157 | 1,301 | 1,102 | 1,392 | 1,102 | 1,464 | 1,247 | 1,084 | 1,518 | 1,355 |
| Note Payments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Equipment Purchases | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Owner's Draws / Dividends | 42,000 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 |
| Income and Other Taxes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Miscellaneous Payments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Cash Payments | 500,777 | 51,325 | 35,908 | 39,463 | 40,657 | 39,672 | 40,577 | 39,767 | 43,568 | 39,798 | 42,979 | 43,392 | 43,673 |
| Ending Cash | (2,048) | (6,890) | (3,154) | (4,196) | (4,429) | (6,310) | (4,247) | (5,663) | (3,699) | (4,541) | (9,193) | (4,886) | (2,048) |
| Increase / <Decrease> For Period | (8,370) | (13,212) | 3,735 | (1,042) | (232) | (1,881) | 2,063 | (1,417) | 1,964 | (842) | (4,652) | 4,307 | 2,837 |
| Additional Cash Needed | 41,222 | 6,890 | 0 | 4,196 | 4,429 | 6,310 | 0 | 5,663 | 0 | 4,541 | 9,193 | 0 | 0 |
| Supplied By: | |||||||||||||
| Short Term Borrowing Needs | 16,956 | 6,890 | 0 | 1,042 | 232 | 1,881 | 0 | 1,417 | 0 | 842 | 4,652 | 0 | 0 |
| Short Term Repayments | 14,907 | 3,735 | 0 | 0 | 0 | 2,063 | 0 | 1,964 | 0 | 0 | 4,307 | 2,837 | |
| Current Loan Balance | 2,048 | 6,890 | 3,154 | 4,196 | 4,429 | 6,310 | 4,247 | 5,663 | 3,699 | 4,541 | 9,193 | 4,886 | 2,048 |
| Cash Including Short Term Loans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |