Prepare a cash budget for the month of september

Reference no: EM132447422

ACDC Pty Ltd needs a cash budget for the month of September 2019. The following information is available:

The cash balance on September 1 is $7,500
Actual sales for July and August, and expected sales for September are:
July August September
Cash sales $5,000 $5,250 $6,500
Credit sales 25,000 30,000 35,000
Total sales 30,000 35,250 41,500
Credit sales are collected over a three-month period in the ratio of 60 percent, 30 percent, 9 percent, with 1 percent uncollectible.

Purchases of inventory will total $18,000 for September. Seventy percent of a month's purchases are paid during the month of purchase. Accounts payable for August purchases total $6,150, which will be paid in September.
Selling and administration expenses are budgeted at $14,000 for September. Of this $5,000 is for depreciation.
Dividends of $5,000 will be paid during September, and equipment costing $12,000 will be purchased.
The company must maintain a minimum of cash balance of $5,000. An overdraft facility is available from the company's bank to bolster the cash position as needed.

Required:

Question 1: Prepare a cash budget for the month of September showing your supporting calculations and heading. Indicate in the financing section any borrowing that will be necessary during the month.

Reference no: EM132447422

Questions Cloud

What sources did you use to locate the articles : What key words did you use for your literature search? What sources/databases did you use to locate the articles and/or information?

Explain why cash flow forecast budget important : Explain why cash flow forecast budgets are so important for a manufacturing company? What are the costs of holding too high a level of inventory?

Calculate the net profit margin : Calculate the Net profit margin, Rate of return on owners' equity, Current ratio, Acid test ratio, Gearing Inventory turnover period

Cyber attacks using common cyber security resources : Tech companies prepare for cyber attacks using common cyber security resources. Select one of the resources listed and explain how you could implement

Prepare a cash budget for the month of september : Prepare a cash budget for the month of September showing your supporting calculations and heading. Indicate in the financing section any borrowing

Roles help mitigate and deal with these systems threats : How could changes to authorization, authentication and roles help mitigate and deal with these systems threats? How will your recommendations alleviate threat.

Discuss the advantages and disadvantages of decision : The bank will give you an interest only loan of 6% each year for five years. At the end of this time, you can pay the $250,000 back

Were the correct people involved in the process : Were the correct people involved in the process? Whom would you have included and why? What errors did Woodland make with her own staff?

Industry experts believe blockchain is technology : Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years.

User Account

All Pages