The owner of American Goods, Inc. provides you the followingdata:
Current assets as of March 31:
Cash
$8,000
Accounts receivable
$20,000
Inventory
$36,000
Building and equipment, net
$120,000
Accounts payable
$21,750
Common stock
$150,000
Retained earnings
$12,250
The gross margin is 35% of sales. Thus, the cost of goods soldis 65% of sales. Actual and budgeted sales data:
Sales are 60% for cash and 40% on credit. Credit sales arecollected in the month following sale. The accounts receivable atMarch 31 are a result of March credit sales.
Each monthâs ending inventory should equal 80% of the followingmonthâs budgeted cost of goods sold.
Forty percent of a monthâs inventory purchases is paid for inthe month of purchase; the other sixty percent is paid for in thefollowing month. The accounts payable at March 31 are the result ofMarch purchases of inventory.
Monthly expenses are as follows: commissions, 10% of sales;rent, $2,500 per month; other expenses (excluding depreciation), 5%of sales. These expenses are paid monthly. Depreciation is $1,000per month (includes depreciation on new assets).
Equipment costing $3,500 will be purchased for cash inApril.
Management would like to maintain a minimum cash balance of atleast $5,000 at the end of each month. The company has an agreementwith a local bank that allows the company to borrow in incrementsof $1,000 at the beginning of each month, up to a total loanbalance of $20,000. The interest rate on these loans is 1% permonth and interest is not compounded. The company would, insofar asit is able to do so, repay any loans plus accumulated interest atthe end of the quarter.
March (actual)
$50,000
April
$60,000
May
$72,000
June
$90,000
July
$48,000
With formulas - Required: Show all calculations. Aspreadsheet workbook is highly recommended. If you usespreadsheets, attach the spreadsheet workbook to the examinationfile. Use the data above.
1. Create a cash budget for April, May, June and thequarter.
2. Prepare an income statement for the quarter ended June30.
3. Prepare a balance sheet as of June 30.
4. Determine the following for American Goods, Inc. as of June30:
a. Working Capital
b. Accounts Receivable Turnover
c. Inventory Turnover
d. Net Margin
e. Total Asset Turnover
The owner of American Goods, Inc. provides you the followingdata:
Current assets as of March 31: | |
Cash | $8,000 |
Accounts receivable | $20,000 |
Inventory | $36,000 |
Building and equipment, net | $120,000 |
Accounts payable | $21,750 |
Common stock | $150,000 |
Retained earnings | $12,250 |
The gross margin is 35% of sales. Thus, the cost of goods soldis 65% of sales. Actual and budgeted sales data:
Sales are 60% for cash and 40% on credit. Credit sales arecollected in the month following sale. The accounts receivable atMarch 31 are a result of March credit sales.
Each monthâs ending inventory should equal 80% of the followingmonthâs budgeted cost of goods sold.
Forty percent of a monthâs inventory purchases is paid for inthe month of purchase; the other sixty percent is paid for in thefollowing month. The accounts payable at March 31 are the result ofMarch purchases of inventory.
Monthly expenses are as follows: commissions, 10% of sales;rent, $2,500 per month; other expenses (excluding depreciation), 5%of sales. These expenses are paid monthly. Depreciation is $1,000per month (includes depreciation on new assets).
Equipment costing $3,500 will be purchased for cash inApril.
Management would like to maintain a minimum cash balance of atleast $5,000 at the end of each month. The company has an agreementwith a local bank that allows the company to borrow in incrementsof $1,000 at the beginning of each month, up to a total loanbalance of $20,000. The interest rate on these loans is 1% permonth and interest is not compounded. The company would, insofar asit is able to do so, repay any loans plus accumulated interest atthe end of the quarter.
March (actual) | $50,000 |
April | $60,000 |
May | $72,000 |
June | $90,000 |
July | $48,000 |
With formulas - Required: Show all calculations. Aspreadsheet workbook is highly recommended. If you usespreadsheets, attach the spreadsheet workbook to the examinationfile. Use the data above.
1. Create a cash budget for April, May, June and thequarter.
2. Prepare an income statement for the quarter ended June30.
3. Prepare a balance sheet as of June 30.
4. Determine the following for American Goods, Inc. as of June30:
a. Working Capital
b. Accounts Receivable Turnover
c. Inventory Turnover
d. Net Margin
e. Total Asset Turnover