Ma & Pa's Sales Collection Analysis Worksheet
Return To Tutorial
Total Cash % Of Credit % Of Collected Collected Collected Collected
Month Of Sale Sales Sales Cash Sales Credit Month Of % One Month % Two Months % Three Months %
Amount Amount Sales Amount Sales Sale Collected After Sale Collected After Sale Collected After Sale Collected
Period 1 31,000 3,200 10.32% 27,800 89.68% 4,200 13.55% 23,600 76.13%
Period 2 34,000 3,300 9.71% 30,700 90.29% 4,800 14.12% 25,900 76.18%
Period 3 37,000 3,800 10.27% 33,200 89.73% 5,000 13.51% 28,200 76.22%
Period 4 30,000 2,900 9.67% 27,100 90.33% 4,300 14.33% 22,800 76.00%
Period 5 40,000 3,800 9.50% 36,200 90.50% 5,600 14.00% 30,600 76.50%
Period 6 32,000 3,300 10.31% 28,700 89.69% 4,500 14.06% 24,200 75.63%
Period 7 43,000 4,400 10.23% 38,600 89.77% 5,700 13.26% 32,900 76.51%
Period 8 36,000 3,500 9.72% 32,500 90.28% 5,400 15.00% 27,100 75.28%
Period 9 31,000 3,000 9.68% 28,000 90.32% 4,400 14.19% 23,600 76.13%
Period 10 44,000 4,500 10.23% 39,500 89.77% 6,300 14.32% 33,200 75.45%
Period 11 39,000 4,000 10.26% 35,000 89.74% 5,400 13.85% 29,600 75.90%
Period 12 50,000 4,900 9.80% 45,100 90.20% 6,800 13.60% 38,300 76.60%
Totals 447,000 44,600 9.98% 402,400 90.02% 62,400 13.96% 340,000 76.06%
Return To Tutorial