Cash Projection Worksheet   The Cash Projection Worksheet contains the following information:                  
                                 
    (a) Cash Summary Section that summarizes all the estimated cash                 
Introduction   receipts and payments.                        
Sales Forecast Worksheet   (b) Basic Financial Information Section                      
Cash Payments Worksheet   (c) Sales and Payment information summarized and calculated                   
Weekly Forecast Worksheet   from the other two sheets - SalesForecast and CashPayments.                  
Charts Worksheet   (d) Estimated purchases and inventory calculations for businesses                   
    that buy and sell product.                        
                                 
    Instructions:                          
                                 
    Enter the number of periods that you want to prepare                    
    an estimate for from one to 12 months (1 - 12).                    
                                 
    Enter your basic financial information, collection and                    
    payment patterns, and beginning balances in                      
    the Basic Financial Information Section.                      
                                 
    Gray Highlighted Section                        
                                 
    Enter the number of weeks contained in each month                    
    that you want to estimate collections and payments for.                    
                                 
To Print the Main Worksheet select File and Print from the Menu. All areas that require user input are highlighted in yellow.                  
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Plus:                                
  Cash Collections                                
Accounts Receivable-Collections Prior Period 0 0 0 0 0 0 0 0 0 0 0 0 0      
Accounts Receivable-Collections Current Periods 0 0 0 0 0 0 0 0 0 0 0 0 0      
Cash Sales 0 0 0 0 0 0 0 0 0 0 0 0 0      
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Less:                                
  Cash Payments                                
Accounts Payable Payments-Prior Periods 0 0 0 0 0 0 0 0 0 0 0 0 0      
Other Amounts Owed Prior Period 0 0 0 0                        
Accounts Payable Payments-Current Periods 0 0 0 0 0 0 0 0 0 0 0 0 0      
Cash Purchases 0 0 0 0 0 0 0 0 0 0 0 0 0      
Payroll Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0      
Operating  Expense Payments 0 0 0 0 0 0 0 0 0 0 0 0 0      
Sales Tax 0 0 0 0 0 0 0 0 0 0 0 0 0      
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Ending Cash 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Increase / <Decrease> For Period 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Additional Cash Needed 0 0 0 0 0 0 0 0 0 0 0 0 0      
  Supplied By:                                
Short Term Borrowing Needs 0 0 0 0 0 0 0 0 0 0 0 0 0      
 Short Term Repayments  0   0 0 0 0 0 0 0 0 0 0 0      
                                 
Current Loan Balance 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
Cost Of Sales 0 0 0 0 0 0 0 0 0 0 0 0 0      
Gross Profit 0 0 0 0 0 0 0 0 0 0 0 0 0      
Payroll Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0      
Operating Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0      
Estimated Profit / (Loss)  0 0 0 0 0 0 0 0 0 0 0 0 0      
  (Prior To Income Tax, Depreciation, Interest                                 
and Business Taxes)                                
Owner Draws / Dividends 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Key Balance Sheet Balances                                
Cash 0 0 0 0 0 0 0 0 0 0 0 0 0      
Inventory Balance 0 0 0 0 0 0 0 0 0 0 0 0 0      
Accounts Receivable Balance 0 0 0 0 0 0 0 0 0 0 0 0 0      
Accounts Payable Balance 0 0 0 0 0 0 0 0 0 0 0 0 0      
Sales Tax Payable 0 0 0 0 0 0 0 0 0 0 0 0 0      
Short Term Borrowings 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
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 0.0%   Beginning Accounts Receivable Net  Balance   0 Amounts Collected By Month          
                  Month 1 Month 2 Month 3 Month 4   Check Total    
Sales On Account     Estimated Current Balances     0 0 0 0 0   0    
% Collected Month of Sale 0.0%   Estimated 1-30 Days Late     0 0 0 0 0   0    
% Collected One Month After Sale 0.0%   Estimated Over 30 Days Late     0 0 0 0 0   0    
% Collected Two Months After Sale 0.0%                              
% Collected Three Months After Sale 0.0%     Check Total       0 0 0 0 0   0    
% Uncollected 0.0%                              
                                 
                                 
Total Should Equal  100% 0.0%   Future Sales (Extra 3 Months)   Future 1 Future 2 Future 3              
      Estimated Sales Additional 3 Months 0 0 0              
                                 
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 0   If no amounts are entered in the Estimated Sales Additional 3 Months              
Actual Sales Prior Year 0   the months are automatically calculated for you.                  
Actual Cost Of Goods Sold Prior Year 0                              
      Accounts Payable Payments     Totals                
Calculated Cost Of Goods % of Sales 0.00%   Beginning Accounts Payable  Balance   0 Amounts Paid By Month          
Calculated Inventory Turnover 0.00               Month 1 Month 2 Month 3 Month 4   Check Total    
      Estimated Current Balances     0 0 0 0 0   0    
Calculated Number Of Months Sales in Inventory 0.00   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       0 0 0 0 0   0    
   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       0                
Cash Purchase                                
Cash Purchases in the Current Month 0.0%   Sales Tax Owed        0                
                                 
Purchases On Account     Sales Tax Rate (Percentage)     0.00%                
% of Payments in the Month Of Purchase 0.0%   Percentage of Exempt Sales     0.00%                
% of Payment One Month After Purchase 0.0%   Percentage of Taxable Sales         100.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% 0.0%   Other Amounts Owed        0 0         0    
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
 Future Sales (Used For Purchases Calculation)      0 0 0 0 0 0 0 0 0 0 0 0 0 0
                               
                                 
   Calculated Sales Tax  0 0 0 0 0 0 0 0 0 0 0 0 0      
                               
 Sales Including Sales Tax  0 0 0 0 0 0 0 0 0 0 0 0 0      
                               
 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  0 0 0 0 0                      
                                 
 Current Year Cash Sales                                 
 Cash Sales Including Tax  0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
 Current Year Sales On Account Collections                                 
Collect Month Of Sale 0 0 0 0 0 0 0 0 0 0 0 0 0      
Collect One Month after Sale 0   0 0 0 0 0 0 0 0 0 0 0      
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Total Cash Collections on Sales and Accounts 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Other Amounts Owed Prior Period Payments 0 0 0 0                        
                                 
Total Sales Tax and Other Liability Payments 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Accounts Payable Prior Period Payments 0 0 0 0 0                      
                                 
Cash Purchases Current Periods 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
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 0   0 0 0 0 0 0 0 0 0 0 0      
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Total Accounts Payable & Purchases Payments 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
Purchases Needed For Sales and Inventory 0 0 0 0 0 0 0 0 0 0 0 0 0      
Cost Of Goods Sold 0 0 0 0 0 0 0 0 0 0 0 0 0      
Ending Inventory 0 0 0 0 0 0 0 0 0 0 0 0 0      
                                 
Future Cost Of Goods Sold     0 0 0 0 0 0 0 0 0 0 0 0 0 0
                                 
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 0 0 0 0 0 0 0 0 0 0 0 0 0      
Employee Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0      
Social Security & Medicare 0 0 0 0 0 0 0 0 0 0 0 0 0      
Federal Unemployment 0 0 0 0 0 0 0 0 0 0 0 0 0      
State Unemployment 0 0 0 0 0 0 0 0 0 0 0 0 0      
Worker's Compensation 0 0 0 0 0 0 0 0 0 0 0 0 0      
Rent-Property 0 0 0 0 0 0 0 0 0 0 0 0 0      
Rent-Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0      
Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0      
Repairs and Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0      
Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0      
Car & Truck Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0      
Travel 0 0 0 0 0 0 0 0 0 0 0 0 0      
Entertainment 0 0 0 0 0 0 0 0 0 0 0 0 0      
Telephone 0 0 0 0 0 0 0 0 0 0 0 0 0      
Postage 0 0 0 0 0 0 0 0 0 0 0 0 0      
Office Supplies 0 0 0 0 0 0 0 0 0 0 0 0 0      
Advertising 0 0 0 0 0 0 0 0 0 0 0 0 0      
Marketing/Promotion 0 0 0 0 0 0 0 0 0 0 0 0 0      
Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 0      
Training and Development 0 0 0 0 0 0 0 0 0 0 0 0 0      
Bank Charges 0 0 0 0 0 0 0 0 0 0 0 0 0      
Credit Card Fees 0 0 0 0 0 0 0 0 0 0 0 0 0      
Miscellaneous 0 0 0 0 0 0 0 0 0 0 0 0 0      
  0 0 0 0 0 0 0 0 0 0 0 0 0      
  0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
    0 0 0 0 0 0 0 0 0 0 0 0 0      
  0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0