In preparing the cash budget assume that the 52000 loan

Reference no: EM13482445

Faces Au Natural Corp., a distributor of natural cosmetics, is ready to begin its third quarter, in which peak sales occur. The company has requested a $52,000, 90-day loan from its bank to help meet cash requirements during the quarter. Because the company has experienced difficulty in paying off its loans in the past, the bank's loan officer 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 $42,000.

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

May (actual)	$330,000
June (actual)	$290,000
July (budgeted)	$330,000
August (budgeted)	$490,000
September (budgeted)	$330,000

Past experience shows that 20% of a month's sales are collected in the month of sale, 65% 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	$161,000	$151,000	$161,000
Salaries and wages	$68,000	$68,000	$58,000
Advertising	$70,000	$80,000	$90,000
Rent payments	$28,000	$28,000	$28,000
Depreciation	$35,000	$35,000	$35,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 $166,000.

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

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

Required:

1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total.

2. Prepare a cash budget, by month and in total, for the third quarter.

3. If the company needs a minimum cash balance of $20,000 to start each month, can the loan be repaid as planned? Explain.

Reference no: EM13482445

Questions Cloud

During the fiscal year ended september302009 worrell inc : calculate eps reported before stock split andstock dividend.during the fiscal year ended september302009 worrell inc.

Create the adjusting entry to record the bonds at fairvalue : presented below is information taken from a bond investmentamortization schedule with related fair values provided.

Analyze the account balances for account receivable : analyze the account balances for account receivable inentory and shortcurrent long-term deb. describe any observations

Calculate the amount of total current assets that abc : abc company began operations in april 2007 by selling common stockto owners in exchange for 70000. during 2007 abc

In preparing the cash budget assume that the 52000 loan : faces au natural corp. a distributor of natural cosmetics is ready to begin its third quarter in which peak sales

Prepare a schedule that discloses the individual costs that : on january 1 2008 blair corporation purchased for 500000 atract of land site number 101 with a building. blair paid a

Aunt ethels fancy cookie company manufactures and sells : problem 1. aunt ethels fancy cookie company manufactures and sells three flavors of cookies macaroon sugar and

What is cost of goods sold per unit using variable costing : peggys pillows produces and sells a decorative pillow for 75.00 per unit. in the first month of operation 2000 units

The incremental change to the current sales forecast for : the deleca plastice company is considering a machine that has a cost of 25000. the machine will permit an output

User Account

All Pages