Schedule of Cash Collections Cash Sales $788,319 $804,085 $820,167 $836,570 Collections Previous Year Q3 $146,552 Collections Previous Year Q4 $560,700 $149,520 Collections from Current Year Q1 $1,103,647 $551,823 $147,153 Collections from Current Year Q2 $1,125,720 $562,860 $150,096 Collections from Current Year Q3 $1,148,234 $574,117 Collections from Current Year Q4 $1,171,199 $2,599,218 $2,631,148 $2,678,414 $2,731,982 Estimated Bad Debt Expense $36,788 $37,524 $38,274 $39,040 Proof: $11,687,245 Total Sales + Beg. A/R $10,640,761 - Total Collections Note: Hide these $151,627 - Bad Debt rows when budget is $894,857 = Ending A/R completed