Projected Cash and Accounts Payable
MonthJan.Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Nov.Dec.Projected Sales$10,000Cash Sales (line 1)$9,500Coll. Of Sales 1 mo. Prior$5,000Coll. Of Sales 2 mo. Prior$2,000Coll. Of Sales Over 2 mo.$500Total Accts. Rec. (line 2)$27,00000000000000Projected Accounts ReceivableMonthJan.Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Nov.Dec.Planned Purchases$2,000Pay On Current Mo. Purch.$1,000Pay On Purch. 1 Mo. Prior$200Pay On Purch. 2 Mo. Prior$200Pay On Purch. Over 2 Mo.$100Total Accts. Payable(line 22)$3,5000000000000035