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

  Develop critical analysis skills in relation

ACCT20040 - Auditing and Ethical Practice ACCT20075 - Auditing and Ethics - Develop critical analysis skills in relation to auditor independence and issues in accepting audit engagements.

  Evaluate the audit findings

Evaluate the audit findings - Determine planning materiality, and tolerable misstatement

  Identify the relevant stakeholders

Explain the ethical dilemma that may exist in the debate above re auditors' independence and the impact on the credibility and reliability of financial reporting given the recent global financial crisis.

  Reforms to enhance audit quality

What each of the above actually refers to and what it means and what is your view, giving a rational explanation to your view (you may use other sources to support your view, properly referencing).

  Determine ebays gaap eps for the quarter

How much did INTC's report as the third quarter EPS computed according to GAAP - Identify the reason(s) for the difference between the actual EPS numbers reported by the analyst tracking services and the EPS number computed according to GAAP.

  Identify implications for the audit

Analyse the ratios in conjunction with the additional information and identify implications for the audit and any particular audit steps that need to be undertaken to reduce audit risk

  Issues in accepting audit engagements

The object of this assignment is to assist students to develop critical analysis skills in relation to auditor independence and issues in accepting audit engagements

  Assess how the sarbanes-oxley act has affected auditing

Assess how the Sarbanes-Oxley Act has affected auditing. Evaluate objectives for conducting audits, and compare management's and auditors' responsibilities.

  Discuss how each situation would affect your audit report

Discuss how each situation would affect your audit report on financial statements. Be thorough in covering all sections of the audit report that would be affected.

  Explain accounts receivable-sec site

Your company's accounts payable clerk is asked to fill in for your accounts receivable clerk. Many things look unfamiliar to her, and she needs some explanations. You start by saying, "Accounts receivable is claims from monies due to the company."..

  What sections of the act are bought into question

What is the issue in this situation and what sections of the Act are bought into question? Is there something that should be in place with the audit firm?

  For each of the subsequent independent situations show the

for each of the subsequent independent situations show the reason for and the type of audit report that you would

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