Minden Company is a wholesale distributor of premium European chocolates. The co
ID: 2569392 • Letter: M
Question
Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 30 is given below: Minden Company Balance Sheet April 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation $ 18,700 70,250 41,250 230,000 Total assets $ 360,200 Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings $ 72,250 13,700 180,000 94,250 Total liabilities and stockholders' equity $ 360,200 The company is in the process of preparing a budget for May and has assembled the following data a. Sales are budgeted at $214,000 for May. Of these sales, S64,200 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder is collected in the following month. All of the April 30 accounts receivable will be collected in b. Purchases of inventory are expected to total $122,000 during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the April 30 accounts payable to suppliers will be paid during May c. The May 31 inventory balance is budgeted at $47,500 d. Selling and administrative expenses for May are budgeted at $85,500, exclusive of depreciation. These e. The note payable on the April 30 balance sheet will be paid during May, with $390 in interest. (All of the f. New refrigerating equipment costing $16,300 will be purchased for cash during May expenses will be paid in cash. Depreciation is budgeted at $2,050 for the month interest relates to May.) g. During May, the company will borrow $24,500 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one vearExplanation / Answer
Cash balance during May Cash balance in beginning 18700 Add: Colllections from accounts receivable Account receivable of April 70250 Cash sales of may( 64200 Credit sales of may (214000-64200 *1/2) 74900 209350 Less: Cash disbursement Cash paid to accounts payable 72250 Credit purchase of may paid(122000*45%) 54900 127150 Less: Selling and admin expense 85500 Less: Note payable with interest(13700+390) 14090 Less: refregerator purchased 16300 Add: Borrow from bank 24500 Closing cash balance 9510 Accounts recievable (Half of may credit sales i.e. $149800) 74900 Account payable (55% of may credit purchase i.e. 122,000) 67100 Balance in retained earnings Opening balance in RE 94250 Add: Net income during the month 10310 104560 MINDEN COMPANY BALANCE SHEET AS ON 31.05 Assets: Cash 9510 Accounts receivable 74900 Inventory 47500 Building less accumulated dep (230,000-2050) 227950 Refrigerator 16300 TOTAL ASSETS 376160 Liabilities: Accounts payable 67100 Note payable 24500 Common Stock 180000 Retained earnings 104560 TOTAL LIABILITIES 376160