Reference no: EM131339890
Prepare a cash budget for Atlas Products, Inc., for the first quarter of 2006, based on the following information.
The budgeting section of the corporate finance department of Atlas Products has received the following sales estimates from the marketing department:
|
Total Sales
|
Credit Sales
|
December 2005
|
$825,000
|
$770,000
|
January 2006
|
730,000
|
690,000
|
February 2006
|
840,000
|
780,000
|
February 2006
|
920,000
|
855,000
|
The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting.
The company estimates its purchases at 60 percent of next month's sales, and payments for those purchases are budgeted to lag the purchases by one month.
Various disbursements have been estimated as follows:
|
January
|
February
|
March
|
Wages and Salaries
|
$250,000
|
$290,000
|
$290,000
|
Rent
|
27,000
|
27,000
|
27,000
|
Other Expenses
|
10,000
|
12,000
|
14,000
|
In addition, a tax payment of $105,000 is due on January 15, and $40,000 in dividends will be declared in January and paid in March. Also, the company has ordered a $75,000 piece of equipment. Delivery is scheduled for early January, and payment will be due in February.
The company's projected cash balance at the beginning of January is $100,000, and the company desires to maintain a balance of $100,000 at the end of each month.
Requirements of case and slp assignments
: To accomplish the requirements of Case and SLP assignments, it is crucial to study materials in Background section to gain knowledge of the concepts introduced in this module.
|
Use all available methods to evaluate projects
: Assume you use all available methods to evaluate projects. If there is a conflict in the indicated decision between two mutually exclusive projects due to the IRR-based indicator, you should:
|
Identify common challenges and issues arise in workplace
: Conduct a 30-minute, semi-structured interview with a manager: Identify common challenges and issues that arise in the workplace, Evaluate strategies for addressing these challenges
|
Find an analytic approximation for the function
: Find an analytic approximation for the function P(T) along the liquid-gas phase boundary. Sketch your answer and compare it to a phase diagram of water that you can find on the Web.
|
Prepare a cash budget for atlas products
: Prepare a cash budget for Atlas Products, Inc., for the first quarter of 2006, based on the given information.
|
The weighted average cost of capital for a firm
: The weighted average cost of capital for a firm with a 60% debt and 40% equity in its capital structure, an 8% cost of debt, a 15% cost of equity, and a 35% tax rate would be: a. 7.02% b. 9.12% c. 10.80% d. 11.08% e. 13.80%
|
The discounted payback rule may cause
: The discounted payback rule may cause:
|
What is the firm pretax cost of debt
: JL Lumber has a debt-equity ratio of .62. The firm's required return on assets is 12 percent and its current cost of equity is 15.60 percent. What is the firm's pretax cost of debt? Ignore taxes. In the decline stage, we know that both profit and cas..
|
Develop an inventory management system
: Case Study Presentation - Systems Project Management (COMP 0383) - Develop your proposal as a group of three members into a professional document of not more than 12 to 15 Pages, and create a PowerPoint presentation to discuss the Case study requir..
|