(Cash budget) The January 31, 1999, balance sheet of Saras Plaques follows: Liabilities and Assets Stockholders Equity...
Question:
(Cash budget) The January 31, 1999, balance sheet of Sara’s Plaques follows:
Liabilities and Assets Stockholders’ Equity Cash $ 12,000 Accounts Payable $ 70,200 Accounts Receivable (Net of Allowance for Uncollectibles of $1,440) 34,560 Inventory 52,400 Common Stock $90,000 Plant Assets (Net of Accumulated Retained Earnings Depreciation of $60,000) 36,000 (Deficit) (25,240) 64,760 Total Liabilities and Total Assets $134,960 Stockholders’ Equity $134,960 Additional information about the company includes the following:
• Expected sales for February and March are $120,000 and $130,000, respectively.
• The collection pattern from the month of sale forward is 50 percent, 48 percent, and 2 percent uncollectible.
• Cost of goods sold is 75 percent of sales.
• Purchases each month are 55 percent of the current month’s sales and 45 percent of the next month’s projected sales. All purchases are paid for in full in the month following purchase.
• Other cash expenses each month are $21,500. The only noncash expense each month is $4,000 of depreciation.
a. What are budgeted cash collections for February 2000?
b. What will be the Inventory balance at February 29, 2000?
c. What will be the projected balance in Retained Earnings at February 29, 2000?
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 2000?
Step by Step Answer:
Cost Accounting Traditions And Innovations
ISBN: 9780324180909
5th Edition
Authors: Jesse T. Barfield, Cecily A. Raiborn, Michael R. Kinney