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        
                                   
Other Key Financial Information                                  
                                   
Profit / Loss Information                                  
Sales 484,000 32,756 36,145 40,663 34,450 43,487 34,450 45,746 38,968 33,886 47,440 42,357 53,652        
Cost Of Sales 269,934 18,269 20,159 22,678 19,213 24,253 19,213 25,513 21,733 18,899 26,458 23,623 29,923        
Gross Profit 214,066 14,487 15,986 17,985 15,237 19,234 15,237 20,233 17,235 14,987 20,982 18,734 23,729        
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 Expenses 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        
Estimated Profit / (Loss) 48,548 278 3,123 4,713 875 5,706 2,528 4,847 4,116 2,329 5,443 5,308 9,280        
  (Prior To Income Tax, Depreciation, Interest                                  
and Business Taxes)                                  
Owner 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        
                                   
Key Balance Sheet Balances                                  
Cash 0 0 0 0 0 0 0 0 0 0 0 0 0        
Inventory Balance 24,222 20,890 22,268 21,102 23,223 22,375 22,269 22,587 23,223 26,935 25,538 25,847 24,222        
Accounts Receivable Balance 42,080 30,691 28,350 31,893 27,020 34,108 27,020 35,880 30,563 26,577 37,208 33,221 42,080        
Accounts Payable Balance 25,467 16,343 19,383 19,361 19,201 21,064 17,195 23,247 20,131 20,349 22,554 21,538 25,467        
Sales Tax Payable 1,717 1,048 1,157 1,301 1,102 1,392 1,102 1,464 1,247 1,084 1,518 1,355 1,717        
Short Term Borrowings 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        
                                   
Basic Financial Input Information Needed                                  
                                   
 Collection & Payment Information                                  
Enter Amounts Highlighted In Yellow                                  
                                   
A/R and Cash Sales Collections as a % of Sales     Accounts Receivable                           
Cash Sales     Prior Yr         Totals                  
% of Cash Sales 10.0%   Beginning Accounts Receivable Net  Balance   35000 Amounts Collected By Month            
                  Month 1 Month 2 Month 3 Month 4   Check Total      
Sales On Account     Estimated Current Balances     26000 21000 5000 0 0   26000      
% Collected Month of Sale 14.0%   Estimated 1-30 Days Late     5000 5000 0 0 0   5000      
% Collected One Month After Sale 76.0%   Estimated Over 30 Days Late     4000 4000 0 0 0   4000      
% Collected Two Months After Sale 0.0%                                
% Collected Three Months After Sale 0.0%     Check Total       35000 30000 5000 0 0   35000      
% Uncollected 0.0%                                
                                   
                                   
Total Should Equal  100% 100.0%   Future Sales (Extra 3 Months)   Future 1 Future 2 Future 3                
      Estimated Sales Additional 3 Months 40000 44000 45000                
                                   
Inventory and Cost Information     Calculated Future Sales   0 0 0                
                                   
Actual Financial  Data if Available     Note:These months are used in the calculation of purchases                  
Actual Ending Inventory Prior Year 21,000   If no amounts are entered in the Estimated Sales Additional 3 Months                
Actual Sales Prior Year 447,000   the months are automatically calculated for you.                    
Actual Cost Of Goods Sold Prior Year 249,300                                
      Accounts Payable Payments     Totals                  
Calculated Cost Of Goods % of Sales 55.77%   Beginning Accounts Payable  Balance   22800 Amounts Paid By Month            
Calculated Inventory Turnover 11.87               Month 1 Month 2 Month 3 Month 4   Check Total      
      Estimated Current Balances     22800 22800 0 0 0   22,800      
Calculated Number Of Months Sales in Inventory 1.01   Estimated 1-30 Days Late     0 0 0 0 0   0      
      Estimated Over 30 Days Late     0 0 0 0 0   0      
OR                                  
Estimated Financial Data                                  
 (Use If No Actual Information Available OR       Check Total       22800 22800 0 0 0   22,800      
   you ancipitate an Increase or Decrease in the % )                                  
Cost Of Goods Sold % (Cost Of Goods Sold / Sales) 0.00%                                
Inventory Turnover (Cost Of Goods Sold / Inventory) 0.00                                
                                   
      Other Financial Information                        
Payments on Purchases (%)     Beginning Inventory       21000                  
Cash Purchase                                  
Cash Purchases in the Current Month 10.0%   Sales Tax Owed       3500                  
                                   
Purchases On Account     Sales Tax Rate (Percentage)     8.00%                  
% of Payments in the Month Of Purchase 0.0%   Percentage of Exempt Sales     60.00%                  
% of Payment One Month After Purchase 90.0%   Percentage of Taxable Sales         40.00%                  
% of Payment Two Months After Purchase 0.0%                                
% of Payment Three Months After Purchase 0.0%               Amounts Paid By Month            
                Total Month 1 Month 2 Month 3 Month 4   Check Total      
Total Payments  Should Equal 100% 100.0%   Other Amounts Owed       5500 5500         5,500      
                                   
Payroll Tax Rates                                  
Social Security and Medicare % Rate 7.650%                                
Federal Unemployment % Rate 0.800%                                
State Unemployment  % Rate 2.700%                                
                                   
                                   
                                   
Cash Projection Calculations       Twelve Month Forecast          
        or User Specified Number Of Periods                    
                                   
  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 Next Year 1 Next Year 2 Next Year 3  
Number Of Weeks In Month   5 4 4 5 4 4 5 4 4 5 4 4      
  Enter Number Of Weeks In Each Month Listed ( 4 or 5 )                                  
                                   
Estimated Sales From Sales Forecast Worksheet 484,000 32,756 36,145 40,663 34,450 43,487 34,450 45,746 38,968 33,886 47,440 42,357 53,652        
                                   
 Future Sales (Used For Purchases Calculation)     0 0 0 0 0 0 0 0 0 0 0 40000 44000 45000  
                                 
                                   
   Calculated Sales Tax 15,487 1,048 1,157 1,301 1,102 1,392 1,102 1,464 1,247 1,084 1,518 1,355 1,717        
                                 
 Sales Including Sales Tax 499,487      33,804     37,302       41,964 35,552 44,879 35,552 47,210 40,215 34,970 48,958 43,712 55,369        
                                 
 Collections 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        
                                   
 Accounts Recivable Collections Prior Period 35,000 30,000 5,000 0 0                        
                                   
 Current Year Cash Sales                                  
 Cash Sales Including Tax 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        
                                   
 Current Year Sales On Account Collections                                  
Collect Month Of Sale 69,928 4,733 5,222 5,875 4,977 6,283 4,977 6,609 5,630 4,896 6,854 6,120 7,752        
Collect One Month after Sale 337,531   25,691 28,350 31,893 27,020 34,108 27,020 35,880 30,563 26,577 37,208 33,221        
Collect Two months after Sale 0     0 0 0 0 0 0 0 0 0 0        
Collect Three months after Sale 0       0 0 0 0 0 0 0 0 0        
       
Total Current Accounts Receivable Collections 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        
                                   
Total Cash Collections on Sales and Accounts 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        
                                   
Uncollectible Amounts 0 0 0 0 0 0 0 0 0 0 0 0 0        
                                   
                                   
Number Of Periods Needing To Entered: 12                                
  Weeks  5  4  4  5  4  4  5  4  4  5  4  4        
Other Cash Receipts (Input Required) 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        
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 Investments or Additional Equity Contributed 0 0 0 0 0 0 0 0 0 0 0 0 0        
  Other                                  
  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 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 0 0 0 0 0        
Total Other Cash Receipts 0 0 0 0 0 0 0 0 0 0 0 0 0        
                                   
Total Cash Receipts 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        
                                   
                                   
Payments                                  
                                   
Number Of Periods Needing To Entered: 12                                
  Weeks 5 4 4 5 4 4 5 4 4 5 4 4        
Other Payments  (Input Required) 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        
Note Payments (Principal & Interest) 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 Business Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0        
  Other Miscellaneous Payments                                  
  0                                
  0                                
  0                                
  0                                
  0                                
Total Other Cash Payments 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        
                                   
Calculated Payments 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        
Note: No User Input Required Below This Line                                  
                                   
Sales Tax Payments 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        
                                   
Other Amounts Owed Prior Period Payments 5,500 5,500 0 0                          
                                   
Total Sales Tax and Other Liability Payments 22,770 9,000 1,048 1,157 1,301 1,102 1,392 1,102 1,464 1,247 1,084 1,518 1,355        
                                   
Accounts Payable Prior Period Payments 22,800 22,800 0 0 0                        
                                   
Cash Purchases Current Periods 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        
                                   
Current Year Payments on  Purchases on Account                                  
                                   
Payment in the Current Month 0 0 0 0 0 0 0 0 0 0 0 0 0        
Payment One Month After Purchase 220,373   16,343 19,383 19,361 19,201 21,065 17,196 23,248 20,132 20,350 22,555 21,539        
Payment Two Months After Purchase 0     0 0 0 0 0 0 0 0 0 0        
Payment Three Months After Purchase 0       0 0 0 0 0 0 0 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        
                                   
Total Accounts Payable & Purchases Payments 270,489 24,616 18,497 21,534 21,494 21,542 22,976 19,779 25,485 22,393 22,856 24,948 24,369        
                                   
                                   
Calculated Purchases and Inventory Needed :                                  
  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 Next Year 1 Next Year 2 Next Year 3  
Beginning Inventory 21,000 21,000 20,890 22,268 21,102 23,223 22,375 22,269 22,587 23,223 26,935 25,538 25,847        
Purchases Needed For Sales and Inventory 273,156 18,159 21,537 21,512 21,334 23,405 19,107 25,831 22,369 22,611 25,061 23,932 28,298        
Cost Of Goods Sold 269,934 18,269 20,159 22,678 19,213 24,253 19,213 25,513 21,733 18,899 26,458 23,623 29,923        
Ending Inventory 24,222 20,890 22,268 21,102 23,223 22,375 22,269 22,587 23,223 26,935 25,538 25,847 24,222        
                                   
Future Cost Of Goods Sold     0 0 0 0 0 0 0 0 0 0 0 22,309 24,540 25,097  
                                   
Cash Operating  Expense Payments Weeks 5 4 4 5 4 4 5 4 4 5 4 4        
From Cash Payments Worksheet 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        
  Note: The items in blue are automatically calculated                                  
Salaries and Wages 41,600 4,000 3,200 3,200 4,000 3,200 3,200 4,000 3,200 3,200 4,000 3,200 3,200        
Employee Benefits 8,320 800 640 640 800 640 640 800 640 640 800 640 640        
Social Security & Medicare 3,184 306 245 245 306 245 245 306 245 245 306 245 245        
Federal Unemployment 336 32 26 26 32 26 26 32 26 26 32 26 26        
State Unemployment 1,120 108 86 86 108 86 86 108 86 86 108 86 86        
Worker's Compensation 1,508 145 116 116 145 116 116 145 116 116 145 116 116        
Rent-Property 26,400 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200        
Rent-Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0        
Utilities 9,200 900 700 700 900 700 700 900 700 700 900 700 700        
Repairs and Maintenance 6,486 439 484 545 462 583 462 613 522 454 636 568 719        
Insurance 7,500 625 625 625 625 625 625 625 625 625 625 625 625        
Car & Truck Expenses 4,600 450 350 350 450 350 350 450 350 350 450 350 350        
Travel 0 0 0 0 0 0 0 0 0 0 0 0 0        
Entertainment 6,486 439 484 545 462 583 462 613 522 454 636 568 719        
Telephone 5,800 550 450 450 550 450 450 550 450 450 550 450 450        
Postage 1,000 100 75 75 100 75 75 100 75 75 100 75 75        
Office Supplies 1,180 115 90 90 115 90 90 115 90 90 115 90 90        
Advertising 12,971 878 969 1,090 923 1,165 923 1,226 1,044 908 1,271 1,135 1,438        
Marketing/Promotion 0 0 0 0 0 0 0 0 0 0 0 0 0        
Professional Fees 6,200 600 475 475 600 475 475 600 475 475 600 475 475        
Training and Development 3,600 300 300 300 300 300 300 300 300 300 300 300 300        
Bank Charges 120 10 10 10 10 10 10 10 10 10 10 10 10        
Credit Card Fees 1,646 111 123 138 117 148 117 156 132 115 161 144 182        
Miscellaneous 0 0 0 0 0 0 0 0 0 0 0 0 0        
  7,599 514 567 638 541 683 541 718 612 532 745 665 842        
  8,664 586 647 728 617 778 617 819 698 607 849 758 960        
   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 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 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 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 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 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 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 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 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 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        
  Total Cash Expense Payments 165,518 14,209 12,863 13,272 14,362 13,528 12,709 15,386 13,119 12,658 15,539 13,426 14,449        
                                   
                                   
                                   
                               
                                   
                                   
                                   
                                   
Return To Tutorial