Question:
(Cash budget) Stabler Co.'s projected March 31, 2011, balance sheet follows.
|
|
Liabilities and
|
|
|
|
Assets
|
|
Stockholders' Equity
|
|
|
|
Cash
|
$ 24,000
|
Accounts Payable
|
|
$140,400
|
|
Accounts Receivable (net of
|
|
|
|
|
|
Allowance for Uncollectibles
|
|
|
|
|
|
of $2,880)
|
69,120
|
|
|
|
|
Merchandise Inventory
|
104,800
|
Common Stock
|
$50,000
|
|
|
Plant Assets (net of Accumulated
|
|
|
|
|
|
Depreciation of $120,000)
|
72,000
|
Retained Earnings
|
79,520
|
129,520
|
|
|
Total Liabilities and
|
|
|
|
Total Assets
|
$269,920
|
Stockholders'Equity
|
|
$269,920
|
Additional information about the company is as follows:
- Expected sales for April and May are $240,000 and $260,000, respectively. All sales are made on account.
- The monthly collection pattern from the month of sale forward is 50 percent, 48 percent, and 2 percent uncollectible. Accounts Receivable and the Allowance for Uncollectibles reflect only accounts for March.
- Cost of goods sold is 65 percent of sales.
- Purchases each month are 60 percent of the current month's sales and 30 percent of the next month's projected sales. All purchases are paid for in full in the month following purchase.
- Dividends of $20,000 will be declared and paid in April 2011.
- Selling and administrative expenses each month are $43,000, of which $8,000 is depreciation.
- Investments and borrowings must be made in $1,000 amounts.
a. What were March 2011 sales?
b. What will be budgeted cash collections for April 2011?
c. What will be the Merchandise Inventory balance at April 30, 2011?
d. What will be the projected balance in the Retained Earnings account at April 30,2011?
e. If the company wishes to maintain a minimum cash balance of $16,000, how much will be available for investment, or be borrowed at the end of April 2011?