Return To Tutorial                              
                               
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    
                               
Return To Tutorial