Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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$9,000
Accounts receivable54,000
Inventory30,000
Buildings and equipment, net of depreciation207,000

Total assets$300,000

Liabilities and Stockholders’ Equity
Accounts payable$63,000
Note payable14,500
Common stock180,000
Retained earnings42,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 month’s 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

3.48 Rating (158 Votes )

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

Step: 3

blur-text-image

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

Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz

4th edition

978-0133428469, 013342846X, 133428370, 978-0133428377

More Books

Students also viewed these Economics questions