Estimated Accounts Receivable
and Sales Collection Schedule
For Three Month Period
Return To Tutorial
Collection Information From Collection Analysis
A/R and Cash Sales Collections as a % of Sales  
Cash Sales  
% of Cash Sales 10.0%
   
Sales On Account  
% Collected Month of Sale 20.0%
% Collected One Month After Sale 70.0%
% Collected Two Months After Sale 0.0%
% Collected Three Months After Sale 0.0%
% Uncollected 0.00%
Customer Balances Owed At Beginning
as Of the  Beginning Of Estimate
Accounts Receivable Collections For Prior Period                  
                   
Beginning Accounts Receivable Net  Balance         35000 Amounts Collected By Month[1]      
            Month 1 Month 2 Month 3 Month 4
Estimated Current Balances         35000 30000 5000 0  
Estimated 1-30 Days Late         0 0 0 0 0
Estimated Over 30 Days Late         0 0 0 0 0
Estimated Collections By Period Schedule
Totals Month 1 Month 2 Month 3
Estimated Sales From Sales Forecast Worksheet 109,564 32,756 36,145 40,663
   Calculated Sales Tax 3,506 1,048 1,157 1,301
       
 Sales Including Sales Tax       33,804     37,302     41,964
         
         
 Collections Totals  Month 1  Month 2  Month 3
         
 Accounts Recivable Collections Prior Period 35,000 30,000 5,000 0
         
 Current Year Cash Sales        
 Cash Sales Including Tax 11,306 3,380 3,730 4,196
         
 Current Year Sales On Account Collections        
Collect Month Of Sale 22,614 6,761 7,460 8,393
Collect One Month after Sale 49,774   23,663 26,111
Collect Two months after Sale 0   0
Collect Three months after Sale 0  
Uncollectible Amounts 0 0 0 0
Total Current Accounts Receivable Collections 72,388 6,761 31,123 34,504
         
Total Cash Collections on Sales and Accounts 118,694 40,141 39,853 38,700
Return To Tutorial

[1]
This table must be filled in if you have entered any Beginning Accounts Receivable  in the Cell I73.