4. Prepare a cash budget for the Ace Manufacturing Company, indicating receipts

Question

4. Prepare a cash budget for the Ace Manufacturing Company, indicating receipts and dis- bursements for May, June, and July. The firm wishes to maintain at all times a minimum cash balance of $20,000. Determine whether or not borrowing will be necessary during the period, and if it is, when and for how much. As of April 30, the firm had a balance of $20,000 in cash. ACTUAL SALES FORECASTED SALES May June January February March ri $50,000 50,000 60,000 60,000 70,000 80,000 100,000 100,000 August Accounts receivable: 50 percent of total sales are for cash. The remaining 50 percent will be collected equally during the following two months (the firm incurs a negligible bad-debt loss). Cost of goods manufactured: 70 percent of sales: 90 percent of this cost is paid the fol- lowing month and the remaining 10 percent one more month later. . Selling, general, and administrative expenses: $10,000 per month plus 10 percent of sales. All of these expenses are paid during the month of incurrence. Interest payments: A semiannual interest payment on $150,000 of bonds outstanding (12 percent coupon) is paid during July. An annual $50,000 sinking-fund payment is also made at that time. o Dividends: A $10,000 dividend payment will be declared and made in July. o Capital expenditures: $40,000 will be invested in plant and equipment in June. Taxes: Income tax payments of $1,000 will be made in July.

Explanation / Answer

Solution:

Computation of Cash collection from cash sale & Accounts receivables, Payments of cost of goods manufactured & Selling, General & Administrative Expenses (May, June and July) Particulars March April May June July Actual and forecasted sales $60,000.00 $60,000.00 $70,000.00 $80,000.00 $100,000.00 Cash Sales (50%) $30,000.00 $30,000.00 $35,000.00 $40,000.00 $50,000.00 Credit Sales (50%) $30,000.00 $30,000.00 $35,000.00 $40,000.00 $50,000.00 Cash Collection from credit sales (50% in following month, 50% in 2nd month after sale) $30,000.00 $32,500.00 $37,500.00 Cost of goods manufactured (70% of Sales) $42,000.00 $42,000.00 $49,000.00 $56,000.00 $70,000.00 Cash payment for cost of goods manufactured (90% in following month, 10% in 2nd month) $42,000.00 $48,300.00 $55,300.00 Payment of selling, general and administrative expenses ($10,000 + 10% of Sales) $17,000.00 $18,000.00 $20,000.00

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.