The president of the retailer Prime Products has just approachedthe company’s bank with a request for a $67,000, 90-day loan. Thepurpose of the loan is to assist the company in acquiringinventories. Because the company has had some difficulty in payingoff its loans in the past, the loan officer has asked for a cashbudget to help determine whether the loan should be made. Thefollowing data are available for the months April through June,during which the loan will be used:
On April 1, the start of the loan period, the cash balance willbe $18,000. Accounts receivable on April 1 will total $173,600, ofwhich $148,800 will be collected during April and $19,840 will becollected during May. The remainder will be uncollectible.
Past experience shows that 30% of a month’s sales are collectedin the month of sale, 60% in the month following sale, and 8% inthe second month following sale. The other 2% is bad debts that arenever collected. Budgeted sales and expenses for the three-monthperiod follow:
| April | May | June |
| Sales (all on account) | $ | 452,000 | $ | 544,000 | $ | 323,000 |
| Merchandise purchases | $ | 328,000 | $ | 242,000 | $ | 177,500 |
| Payroll | $ | 31,000 | $ | 31,000 | $ | 19,200 |
| Lease payments | $ | 34,600 | $ | 34,600 | $ | 34,600 |
| Advertising | $ | 69,400 | $ | 69,400 | $ | 27,680 |
| Equipment purchases | | ? | | ? | $ | 113,000 |
| Depreciation | $ | 24,800 | $ | 24,800 | $ | 24,800 |
|
Merchandise purchases are paid in full during the monthfollowing purchase. Accounts payable for merchandise purchasesduring March, which will be paid in April, total $170,500.
In preparing the cash budget, assume that the $67,000 loan willbe made in April and repaid in June. Interest on the loan willtotal $1,020.
Required:
1. Calculate the expected cash collections for April, May, andJune, and for the three months in total.
2. Prepare a cash budget, by month and in total, for thethree-month period.
