4. Fast Enterprises is preparing a cash budget for the second quarter of the com

Question

4. Fast Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: April May Sales.... Merchandise purchases Operating expenses S160,000 177,500 117,000 122,400 Payroll.. 13,600 5,400 2,500 7,500 14,280 5,700 2,500 7,500 End of April balances: 30,000 Bank loan payabl 26,000 (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $140,000. (2) Purchases are all on credit, with 30% paid in the month of purchase and the balance paid in the following month. (3) Operating expenses are paid in the month they are incurred. (4) A minimum cash balance of $25,000 is required at the end of each month. (5) Loans are used to maintain the minimum cash balance. At the end of each month, interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made whenever excess cash is available. are the company's cash budget for May. Show the ending loan balance at Mav 0 Show details, (15 Points)

Explanation / Answer

Schedule of Expected Cash Collections Cash sales—May (40%*177500) 71000 Collections on account receivable: March (140000*60%*50%) 42000 April 30 (160000*60%*50%) 48000 Total cash receipts 161000 Schedule of Expected Cash Disbursements April 30 (117000*.7) 117001 May purchases (122400*30%) 36720 Total cash payments 153720 Minden Company Cash Budget For the Month of May Beginning cash balance 30000 Add collections from customers 161000 Total cash available 191000 Less cash disbursements: Purchase of inventory 153720 Operating expenses (14280+5700+2500) 22480 Total cash disbursements 176200 Excess of cash available over disbursements 14800 Financing: Borrowing—note 10200 Repayments—note 0 Interest 0 Total financing 10200 Ending cash balance 25000 Answer is rounded off. If any doubt please comment

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

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