Problem 6 (28 points) The owner of American Goods, Inc. provides you the following data: Current assets as of March 31: S8,000 Cash S20,000 Accounts receivable S36,000 Invento Building and equipment, net $120,000 Accounts payable S21,750 Common stock $150,000 Retained earnings $12,250 The gross margin is 35% of sales. Thus, the cost of goods sold is 65% of sales Actual and budgeted sales data: March (actual) S50,000 April S65.000 S70,000 June S90,000 Jul $100,000 Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. Forty percent of a month's inventory purchases is paid for in the month of purchase; the other sixty percent is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. Monthly expenses are as follows: commissions, 10% of sale rent, s4,000 per month; other expenses (excluding depreciation), 5% of sales. These expenses are paid monthly. Depreciation is $1,000 per month (includes depreciation on new assets). Equipment costing S6,000 will be purchased for cash in April. Management would like to maintain a minimum cash balance of at least s5,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of si,000 at the beginning of each month, up to a total loan balance of s20,000. The interest rate on these loans is 1% per month and interest is not compounded. The company would, insofar as it is able to do so, repay any loans plus accumulated interest at the end of the quarter This problem is continued on page 8