Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. Prepare a cash budget for Atlas Products, Inc. for the rst quarter of 2011 based on the following information. (20 points] Total Sales Credit

image text in transcribed
image text in transcribed
4. Prepare a cash budget for Atlas Products, Inc. for the rst quarter of 2011 based on the following information. (20 points] Total Sales Credit Sales December 2010 $825,000 $220,000 January 2011 230,000 000,000 February 2011 840,000 200,000 March 2011 920,000 855,000 The company found that on average, about 25% of its credit sales are collected during the month when the sale is made, and the remaining 25% of the credit sales are collected during the month following the sale. The company estimates its purchases at 00% of the next month's sales and payments for those purchases are budgeted to lag the purchases by 1 month. Other disbursements have been estimated as follows: January February March Wages and salaries $250,000 $200,000 $290,000 Rent 2?,000 2?,000 2?,000 Other expenses 10,000 12,000 14,000 In addition, a tax payment of $105,000 is due in January, and a $40,000 dividend will be declared in January and paid in March. Also, the company has ordered a $25,000 piece of equipment. Delivery is scheduled for January and payment will be made in February. The company's projected cash balance at the end of December is $100,000 and they desire to maintain a balance of $100,000 at the end of each month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Carl S. Warren, Christine Jonick, Jennifer Schneider

16th Edition

1337913103, 9781337913102

More Books

Students also viewed these Accounting questions

Question

Compute todays call option price in this two- period tree.

Answered: 1 week ago

Question

1. What will happen in the future

Answered: 1 week ago

Question

3. Avoid making mistakes when reaching our goals

Answered: 1 week ago