Ma & Pa's Purchases Payments Analysis Worksheet
Return To Tutorial
Total Cash % Of Credit % Of Paid Paid Paid Paid
Month Of Purchases Purchases Cash Purchases Credit Month Of % One Month % Two Months % Three Months %
Purchase Amount Amount Purchases Amount Purchases Purchase Paid After Purchase Paid After Purchase Paid After Purchase Paid
Period 1 17,000 1,600 9.41% 15,400 90.59% 0 0.00% 15,400 90.59%
Period 2 20,000 1,900 9.50% 18,100 90.50% 0 0.00% 18,100 90.50%
Period 3 19,000 2,000 10.53% 17,000 89.47% 0 0.00% 17,000 89.47%
Period 4 17,000 1,800 10.59% 15,200 89.41% 0 0.00% 15,200 89.41%
Period 5 23,000 2,200 9.57% 20,800 90.43% 0 0.00% 20,800 90.43%
Period 6 17,000 1,600 9.41% 15,400 90.59% 0 0.00% 15,400 90.59%
Period 7 24,000 2,500 10.42% 21,500 89.58% 0 0.00% 21,500 89.58%
Period 8 19,000 1,800 9.47% 17,200 90.53% 0 0.00% 17,200 90.53%
Period 9 16,000 1,700 10.63% 14,300 89.38% 0 0.00% 14,300 89.38%
Period 10 26,000 2,700 10.38% 23,300 89.62% 0 0.00% 23,300 89.62%
Period 11 21,000 2,000 9.52% 19,000 90.48% 0 0.00% 19,000 90.48%
Period 12 31,300 3,200 10.22% 28,100 89.78% 0 0.00% 28,100 89.78%
Totals 250,300 25,000 9.99% 225,300 90.01% 0 0.00% 225,300 90.01%
Return To Tutorial