Schedule of cash collections of accounts receivable

Pampered Pal Inc., a pet supplies distributor, was organized on January $1.$ Projected sales for each of the first three months of operations are as follows:

Month Amount

January $$190,000$

February $230,000$

March $340,000$

All sales are on account. Collections are expected as follows: $51\%$ of sales are expected to be collected in the month of the sale, $44\%$ in the month following the sale, and the remainder in the second month following the sale.

Prepare a schedule indicating cash collections from sales for January, February, and March.

Pampered Pal Inc.

Schedule of Cash Collections from Sales

For the Three Months Ending March $31$

Line Item Description January February March

January sales on account:

Collected in January $Collected in January

Collected in February $Collected in February

Collected in March $Collected in March

February sales on account:

Collected in February Collected in February

Collected in March Collected in March

March sales on account:

Collected in March Collected in March

Total cash collected $Total cash collected $Total cash collected $Total cash collected