Calgon products a distributor of organic beverages needs a

Reference no: EM13483026

Calgon Products, a distributor of organic beverages, needs a cash budget for September. The following information is available:

a.	The cash balance at the beginning of September is $12,300.
b.	Actual sales for July and August and expected sales for September are as follows:

	July		August		September
Cash sales	$	6,900	$	4,400	$	7,300
Sales on account		23,000		28,000		44,000

Total sales	$	29,900	$	32,400	$	51,300

	Sales on account are collected over a three-month period as follows: 10% collected in the month of sale, 65% collected in the month following sale, and 21% collected in the second month following sale. The remaining 4% is uncollectible.
c.	Purchases of inventory will total $30,000 for September. Thirty percent of a month's inventory purchases are paid for during the month of purchase. The accounts payable remaining from August's inventory purchases total $17,000, all of which will be paid in September.
d.	Selling and administrative expenses are budgeted at $14,000 for September. Of this amount, $5,000 is for depreciation.
e.	Equipment costing $17,000 will be purchased for cash during September, and dividends totaling $5,000 will be paid during the month.
f.	The company maintains a minimum cash balance of $8,300. An open line of credit is available from the company's bank to bolster the cash balance as needed.

Required:
1.	Prepare a schedule of expected cash collections for September. (Do not round intermediate calculations. Omit the "$" sign in your response.)

Schedule of Expected Cash Collections
September cash sales	$
September collections on account:
July sales
August sales
September sales

Total cash collections	$

2.	Prepare a schedule of expected cash disbursements for inventory purchases for September. (Do not round intermediate calculations. Omit the "$" sign in your response.)

Schedule of Expected Cash Disbursements
Payments to suppliers:
August purchases	$
September purchases

Total cash payments	$

Prepare a cash budget for September. Indicate in the financing section any borrowing that will be needed during September. Assume that any interest will not be paid until the following month. (Input all amounts as positive values except cash deficiency, repayments and interest which should be indicated by a minus sign. Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Calgon Products Cash Budget For the Month of September
Cash balance, beginning		$
Add cash receipts:
Collections from customers

Total cash available before current financing
Less disbursements:
Payments to suppliers for inventory	$
Selling and administrative expenses
Equipment purchases
Dividends paid

Total disbursements

Excess (deficiency) of cash available over disbursements

Financing:
Borrowings
Repayments
Interest

Total financing

Cash balance, ending		$

Reference no: EM13483026

Questions Cloud

Suppose further that the interest rate remained at 6 : suppose hillard manufacturing sold an issue of bonds with a 10-year maturity a 1000 par value a 10 percent coupon rate

The customer signs and completes all paperwork for the sale : given the following scenario on what date would you recognize revenue if preparing financials under u.s. gaap? would

Ryans operations are divided into metal casting and metal : ryans operations are divided into metal casting and metal finishing. the casting department uses a departmental

He has been told that raising the money through debt will : jon baird the founder of water boots inc. needs to raise 500000 to expand his companys operations. he has been told

Calgon products a distributor of organic beverages needs a : calgon products a distributor of organic beverages needs a cash budget for september. the following information is

Company a and company b are identical except that company : company a and company b are identical except that company as costs are mostly variable whereas company bs costs are

When will a bond trade at a discount par at a premium which : please provide original answers to the following questions. your answers should be no longer than 100 words long in a

Generally accepted accounting principles are a set of : generally accepted accounting principles area a set of standards and rules that are recognized as a general guide for

Determine whether rachels basket weaving shop should carry : e7-9 rachel ray recently opened her own basket weaving studio. she sells finished baskets in addition to the raw

User Account

All Pages