Prepare a schedule of expected cash collections from sales

Assignment Help Auditing
Reference no: EM131914657

Problem

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

11,400

Accounts receivable

75,000

Inventory

41,000

Buildings and equipment, net of depreciation

224,000

Total assets

351,400

Liabilities and Stockholders' Equity

 

Accounts payable

70,000

Note payable

15,500

Common stock

180,000

Retained earnings

85,900

Total liabilities and stockholders' equity

351,400

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, $66,000 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 May.

b. Purchases of inventory are expected to total $128,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 $56,000.

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

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

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

g. During May, the company will borrow $25,300 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.

Reference no: EM131914657

Questions Cloud

How might the baseball team defend itself : On September 8, 2009, Coomer went to the Kansas City Royals baseball game with his father. Instead of sitting in their ticketed seats.
Understanding of corporate culture : With an understanding of corporate culture, and the variables that impact it, how would you characterize an ethically effective culture-one
Subsidiary role in development policy : State your position and argue if you agree on the statement that "Agriculture is often given a subsidiary role in development policy even though it is vital.
Was the tylenol packaging defective in design : Diane Elsroth was visiting her boyfriend, Michael Notarnicola, in the home of his parents. Diane complained of a headache, and Michael provided a Tylenol.
Prepare a schedule of expected cash collections from sales : Prepare a schedule of expected cash collections from sales and a schedule of expected cash disbursements for merchandise purchases.
How has evolution shaped motivation : How has evolution shaped motivation? How might we apply our understanding of evolution to the problem of addiction?
Factors behind ethics and the management skills : Research the background of the 2015 doping scandal at the IAAF paying particular attention to the way senior management handled the crisis
Describe the impact that technology : Describe the impact that technology has on business communication. Provide at least two examples.
Did the radio station cause strange death : Jennifer Strange, a 28-year-old mother of three living in Sacramento, California, entered a 2007 KDND-FM radio contest to drink as much water as possible.

Reviews

Write a Review

Auditing Questions & Answers

  Internal audit

Describe and evaluate this type of internal audit. What types of organisation would it be most useful for?

  Accounting professional and ethical standards

Code of Ethics for Professional Accountants

  Prepare swag''s consolidated balance sheet

Prepare Swag's consolidated balance sheet

  Auditing and assurance

Notable operational challenges for 4X Heavy Ltd faced in 2012/2013 were but not limited to

  State of the company’s industry and associated risk factors

Audit partner is concerned about his lack of knowledge of the industry the company is operating in, state of the company's industry and associated risk factors

  Prepare a memo to the audit partner

Prepare a memo to the audit partner on the ‘state of the company's industry' and associated risk factors.

  Adjusting or non- adjusting events

State whether Event is adjusting or non-adjusting event.

  Audit financial data

As a consequence an accounts payable clerk and financial accountant were made redundant from the business during the year.

  Identify principal audit risk

To identify principal audit risk and corresponding audit procedures

  Auditing and assurance

Show the audit inherent risk and rate the risk as low, medium or high.

  National health reform

Explain the role of the following three 'bodies' in National Health Reform

  Prepare a memo on the state of the company''s industry

Prepare a memo on the 'state of the company's industry' and associated risk factors.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd