Prepare budgeted balance sheet and statement of cash flows (Learning Objective 3)

The Music Box has applied for a loan. First Central Bank has requested a budgeted balance sheet at June 30, 2009, and a budgeted statement of cash flows for June. As the controller (chief accounting officer) of The Music Box, you have assembled the following information:

a. May 31 equipment balance, $80,800; accumulated depreciation, $12,400.

b. June capital expenditures of $16,400 budgeted for cash purchase of equipment.

c. June depreciation expense, $400.

d. Cost of goods sold, 50% of sales.

e. Other June operating expenses, including income tax, total $34,000, 75% of which will be paid in cash and the remainder accrued at June 30.

f. May 31 owners’ equity, $137,500.

g. May 31 cash balance, $50,200.

h. June budgeted sales, $85,000, 40% of which is for cash. Of the remaining 60%, half will be collected in June and half in July.

i. June cash collections on May sales, $15,300.

j. June cash payments of liabilities for May inventory purchases on credit, $8,300.

k. May 31 inventory balance, $11,900.

l. June purchases of inventory, $11,000 for cash and $37,200 on credit. Half the credit purchases will be paid in June and half in July.

Requirements 1. Prepare the budgeted balance sheet for The Music Box at June 30, 2009.

Show separate computations for cash, inventory, and owners’ equity balances.

2. Prepare the budgeted statement of cash flows for June.

3. On the basis of this data, if you were a First Central Bank loan officer, would you grant The Music Box a loan? Give your reasoli.