Beta Company
Not what you're looking for?
Prepare a cash budget for XYZ Company for the first three months of 2004 based on the following information:
Month Estimated Sales Estimated Factory Overhead Estimated Selling, General and Admin Expenses (SG&A)
December $ 2,800,000 $ 320,000 $ 625,000
January 4,000,000 325,000 637,500
February 5,600,000 335,000 642,500
March 4,200,000 335,000 655,000
April 3,500,000 340,000 650,000
Past experience has indicated that 25 percent of sales are collected during the month of the sale and the remaining 75 percent are collected in the month immediately following the sale. Material purchases are 30 percent of the next month's estimated sales and payments lag purchases by one month. Labor costs are 35 percent of next month's sales and are paid during the month incurred. Factory overhead and SG&A expenses are paid during the month they are incurred. The company has purchased a new piece of equipment for $600,000 and is planning to pay for the equipment in February. A tax payment of $750,000 to the IRS is due in January and a dividend payment of $400,000 is due in March.
The company's projected cash balance at the beginning of January is $1.25 million. XYZ Company wants to maintain a minimum cash balance of $750,000 as of the end of each month. As part of the cash budget, determine how much money Beta Company needs to borrow each month or if they will have excess cash to begin repaying their loan.
Purchase this Solution
Solution Summary
This job determines how much money Beta Company needs to borrow each month or if they will have excess cash to begin repaying their loan.
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Basics of corporate finance
These questions will test you on your knowledge of finance.
Team Development Strategies
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.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.