meafunchic
Feb 10, 2008, 12:15 PM
The January 31, 2006 balance sheet of a company follows:
Assets:
Cash $12,000
Accounts Receivable (net of
Allowance for Uncollectibles
Of $1,440) = $34,560
Inventory $52,400
Plant Assets (net of accum depre of $1,440) = $36,000
Total Assets = $134,960
Liabilities and Stockholders Equity:
Accounts Payable: $70,200
Common Stock: $25,000
Retained Earnings: $39,760
Total Liabilities and Stockholders Equity: $134,960
Additional information about the company follows:
• Expected sales for February and March are $120,000 and $130,000, respectively.
• The collection pattern from the month of sale forward is 50%, 48%, and 2% uncollectible.
• Cost of Goods Sold is 65% of sales.
• Purchases each month are 60% of the current month’s sales and 30% of the next month’s projected sales. All purchases are paid for in the month following purchase.
• Selling and administrative expenses each month are $21,500, of which $4,000 is depreciation.
a. What are the budgeted cash collections for February 2006?
b. What will be the Inventory account balance at February 28, 2006?
c. What will be the projected balance in the Retained Earnings account at February 28, 2006?
d. If the company wishes to maintain a minimum cash balance of $8,000, how much will be available for investment or need to be borrowed at the end of February 2006?
Assets:
Cash $12,000
Accounts Receivable (net of
Allowance for Uncollectibles
Of $1,440) = $34,560
Inventory $52,400
Plant Assets (net of accum depre of $1,440) = $36,000
Total Assets = $134,960
Liabilities and Stockholders Equity:
Accounts Payable: $70,200
Common Stock: $25,000
Retained Earnings: $39,760
Total Liabilities and Stockholders Equity: $134,960
Additional information about the company follows:
• Expected sales for February and March are $120,000 and $130,000, respectively.
• The collection pattern from the month of sale forward is 50%, 48%, and 2% uncollectible.
• Cost of Goods Sold is 65% of sales.
• Purchases each month are 60% of the current month’s sales and 30% of the next month’s projected sales. All purchases are paid for in the month following purchase.
• Selling and administrative expenses each month are $21,500, of which $4,000 is depreciation.
a. What are the budgeted cash collections for February 2006?
b. What will be the Inventory account balance at February 28, 2006?
c. What will be the projected balance in the Retained Earnings account at February 28, 2006?
d. If the company wishes to maintain a minimum cash balance of $8,000, how much will be available for investment or need to be borrowed at the end of February 2006?