In preparing the cash budget assume that the 40000 loan

Reference no: EM13587659

Herbal care corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales occur. the company has requested a $40,000 90 -day loan from its bank to help meet cash requirements during the quarter. since farber has experienced difficulty in paying off its loans in the past, the loan officer at the bank has asked the company to prepare a cash budget for the quarter.

Since Herbal Care has experienced difficulty in paying off its loans in the past, the loan officer at the bank has asked the company to prepare a cash budget for the quarter. In response to this request, the following data have been assembled:

a.	On July 1, the beginning of the third quarter, the company will have a cash balance of $44,500.

b.	Actual sales for the last two months and budgeted sales for the third quarter follow (all sales are on account):


May (actual)	$	250,000
June (actual)	$	300,000
July (budgeted)	$	400,000
August (budgeted)	$	600,000
September (budgeted)	$	320,000

Past experience shows that 25% of a month's sales are collected in the month of sale, 70% in the month following sale, and 3% in the second month following sale. The remainder is uncollectible.

c.	Budgeted merchandise purchases and budgeted expenses for the third quarter are given below:

	July		August		September
Merchandise purchases	$	240,000	$	350,000	$	175,000
Salaries and wages	$	45,000	$	50,000	$	40,000
Advertising	$	130,000	$	145,000	$	80,000
Rent payments	$	9,000	$	9,000	$	9,000
Depreciation	$	10,000	$	10,000	$	10,000

Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases on June 30, which will be paid during July, total $180,000.

Equipment costing $10,000 will be purchased for cash during July.

In preparing the cash budget, assume that the $40,000 loan will be made in July and repaid in September. Interest on the loan will total $1,200.

2. Prepare a cash budget, by month and in total, for the third quarter. (Cash deficiency, repayments and interest should be indicated by a minus sign.)

Reference no: EM13587659

Questions Cloud

In the month of april a department had 500 units in the : in the month of april a department had 500 units in the beginning work in process inventory that were 60 complete.

What was the total amount of manufacturing costs assigned : materials costs of 500000 and conversion costs of 535500 were charged to a processing department in the month of

If 590 nm light falls on a slit 440times102 mm wide what is : if 590 nm light falls on a slit 4.40times10?2 mm wide what is the full angular width of the central diffraction

Create a financial statement or document that a business : create a financial statement or document that a business might use to account for losses damaged goods and stolen

In preparing the cash budget assume that the 40000 loan : herbal care corp. a distributor of herb-based sunscreens is ready to begin its third quarter in which peak sales occur.

After a spacewalk a 121 kg tool is left 559 m from the : after a spacewalk a 1.21 kg tool is left 55.9 m from the center of gravity of a 33.7 metric ton space station orbiting

Consider the galvanic cell with sn2sn and agag both : consider the galvanic cell with sn2sn and agag both prepared with no3- as their anion and all solutions prepared at 1.0

What type of company may have large positive net cash : what type of company may have large positive net cash provided by operating activities?what type of company may have

Draw a diagram of the electrochemical cell labeling all : the half-cell tl tl1 mol l-1 is connected to a pt h h21 atm half-cell in which the concentration of h is unknown.

User Account

All Pages