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