Problem: The company predicts that 4 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 56 percent will be collected in the following month. Credit purchases will be paid for in the month following the purchase. In September credit sales were $7,500,000 and credit purchases were $3,500,000. The ending cash balance for September was $12,000,000. Using this information, complete a cash budget for Acme for the three months above, with the ending cash balance for each month clearly shown.
Consider the following budget information for the fourth quarter for Acme Corporation: |
|
October |
November |
December |
Credit sales |
$8,000,000 |
$9,000,000 |
$13,000,000 |
Credit purchases |
3,500,000 |
5,000,000 |
4,000,000 |
Cash disbursements |
|
|
|
Wages, taxes, and expenses |
1,400,000 |
1,600,000 |
2,000,000 |
Interest |
600,000 |
600,000 |
600,000 |
Equipment purchases |
300,000 |
400,000 |
0 |