Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

inden Company is a wholesale distributor of premium European chocolates. The companys balance sheet as of April 30 is given below: Minden Company Balance Sheet

inden Company is a wholesale distributor of premium European chocolates. The companys balance sheet as of April 30 is given below:

Minden Company Balance Sheet April 30
Assets
Cash $ 9,000
Accounts receivable 54,000
Inventory 30,000
Buildings and equipment, net of depreciation 207,000

Total assets $ 300,000

Liabilities and Stockholders Equity
Accounts payable $ 63,000
Note payable 14,500
Common stock 180,000
Retained earnings 42,500

Total liabilities and stockholders equity $ 300,000

The company is in the process of preparing a budget for May and has assembled the following data:

a.

Sales are budgeted at $220,000 for May. Of these sales, $60,000 will be for cash; the remainder will be credit sales. Each months credit sales are collected 60% in the month of sale and 40% in the month following the sale. All of the April 30 accounts receivable will be collected in May.

b.

Purchases of inventory are expected to total $120,000 during May. These purchases will all be on account. The company pays for 50% of its merchandise purchases in the month of the purchase and the remaining 50% in the month following the purchase. All of the April 30 accounts payable to suppliers will be paid during May.

c. The May 31 inventory balance is budgeted at $40,000.
d.

Selling and administrative expenses for May are budgeted at $72,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,000 for the month.

e.

The note payable on the April 30 balance sheet will be paid during May, with $100 in interest. (All of the interest relates to May.)

f. New refrigerating equipment costing $6,500 will be purchased for cash during May.
g.

During May, the company will borrow $20,000 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.

Required:
1-a.

Prepare a schedule of expected cash collections from sales and a schedule of expected cash disbursements for merchandise purchases..

1-b.

Prepare a cash budget for May. (Cash deficiency, repayments and interest should be indicated by a minus sign.)

2. Prepare a budgeted income statement for May.

3. Prepare a budgeted balance sheet as of May 31.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Medical Audit In Primary Health Care

Authors: Martin Lawrence, Theo Schofield

1st Edition

0192622676, 978-0192622679

More Books

Students also viewed these Accounting questions

Question

Effective Delivery Effective

Answered: 1 week ago