Return To Tutorial                              
                                   
                                   
    The Cash Projection Worksheet contains the following information:                    
                                   
    (a) Cash Summary Section that summarizes all the estimated cash                  
    receipts and payments.                          
    (b) Basic Financial Information Section                        
    (c) Sales and Payment information summarized and calculated                    
    from the other two sheets - SalesForecast and CashPayments.                    
    (d) Estimated purchases and inventory calculations for businesses                    
Cash Projection Worksheet   that buy and sell product.                          
                                   
    Instructions:                            
Introduction                                  
Sales Forecast Worksheet   Enter the number of periods that you want to prepare                      
Cash Payments Worksheet   an estimate for from one to 12 months (1 - 12).                      
Weekly Forecast Worksheet                                  
Charts Worksheet   Enter your basic financial information, collection and                      
    payment patterns, and beginning balances in                        
    the Basic Financial Information Section.                        
To Print the Main Worksheet select File and Print from the Menu.                                
    Enter the number of weeks contained in each month                      
    that you want to estimate collections and payments for.                      
                                   
    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      
% 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%     Check Total       0 0 0 0 0   0      
% Collected Three Months After Sale 0.0%                                
% Uncollected 0.00%                                
                                   
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   any amounts 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                  
% of Payments in the Month Of Purchase 0.0%   Percentage of Exempt Sales     0                  
% of Payment One Month After Purchase 0.0%   Percentage of Taxable Sales         0                  
% 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%     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        
                                 
 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        
Uncollectible Amounts 0 0 0 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        
                                   
                                   
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                        
                                   
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        
                                   
                                   
Return To Tutorial