Not what you're looking for?
Baxter Bagels has requested that you prepare a cash budget for the month of June. The following information has been provided:
The beginning cash balance is $10,000. The budgeted sales for
March,April,May, and June are as follows:
March April May June
Cash Sales $14,000 $16,500 $15,500 $17,500
Sales on Acct 29,000 30,000 40,000 50,000
Total Sales 43,000 46,500 55,500 50,000
Sales on account are collected over a two-month period, with 70 percent being collected in the first month and the remainder being collected in the second month.
Inventory purchases are budgeted to be 60 percent of budgeted sales each month. The company pays for inventory purchases in the month following the purchase.
Selling and administrative expenses are budgeted to be 30percent of each month's sales. Of that amount,50percent is depreciation. Equipment costing $24,00 will be purchased in April for cash, and dividends will be paid in the amount of $12,500 in the same month.
The company wants to maintain a minimum cash balance of $10,000 and has set up a line of credit to cover any shortage. If the company must borrow, the loan will be made at the beginning of the month, and any repayment will be made at the end of the month of repayment.
Answers to following must be in EXCEL format.
A) Prepare a cash receipts budget for April, May, and June.
B) Prepare a cash disbursements budget for April, May, and June.
C) Using the preceding budgets, prepare a schedule of any financing
needed for the months of April, May, and June.
Purchase this Solution
This solution is comprised of a simple explanation of how to prepare a cash budget.
Purchase this Solution
Free BrainMass Quizzes
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
These questions will test you on your knowledge of finance.
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.