Question

Following information relates to Acco Co. a. Beginning cash balance on July 1: $35,000. b. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,204,000: June (actual). $840,000; and July (budgeted) $980,000. c. Payments on merchandise purchases: 60% in the month of purchase and 40% in the month following purchase. Purchases amounts are: June (actual). $301,000; and July (budgeted). $600,000. d. Budgeted cash payments for salaries in July: $147,700. e. Budgeted depreciation expense for July: $8,400. f. Other cash expenses budgeted for July: $105,000. g. Accrued income taxes due in July: $80,000. h. Bank loan interest paid in July: $4,620. Additional Information: a. Cost of goods sold is 44% of sales. b. Inventory at the end of June is $56,000 and at the end of July is $224,800. c. Salaries payable on June 30 are $35,000 and are expected to be $28,000 on July 31. d. The equipment account balance is $1,120,000 on July 31. On June 30, the accumulated depreciation on equipment is $196,000 e. The $4,620 cash payment of interest represents the 1% monthly expense on a bank loan of $462,000. f. Income taxes payable on July 31 are $101,528, and the income tax rate is 35% g. The only other balance sheet accounts are common Stock, with a balance of $396,000 on June 30; and Retained Earnings, with a balance of $750,400 on June 30. Prepare a budgeted income statement for the month of July and a budgeted balance sheet for July 31.

Answer 1

Calculation of cash receipts from sales

	Total sales	May	June	July	July 31. Account receivables
Credit sales from:
May	$1204000	$361200 (30% of $1204000)	$602000 (50% of $1204000)	$240800 (20℅ of $1204000)
June	$840000		$252000 (30%of $840000)	$420000 (50℅ of $840000)	$168000 (20% of $840000)
July	$980000			$294000 (30% of $980000)	$686000 (70% of $980000)
Total	$3024000	$361200	$714000	$954800	$854000

Calculation of cash payment for Merchandise

	Total purchase	June	July	July 31 Account pay.
Purchases from:
June	$301000	$180600 (60% of $301000)	$120400 (40℅ of $301000)
July	$600000		$360000 (60℅ of $600000)	$240000 (40% of $600000
Totals	$901000	$180600	$480400	$240000