Prepare budgeted income statement

Assignment Help Financial Accounting
Reference no: EM131202282

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 $ 18,000 Accounts receivable 76,000 Inventory 32,500 Buildings and equipment, net of depreciation 243,000 Total assets $ 369,500 Liabilities and Stockholders’ Equity Accounts payable $ 80,250 Note payable 13,200 Common stock 180,000 Retained earnings 96,050 Total liabilities and stockholders’ equity $ 369,500 The company is in the process of preparing a budget for May and has assembled the following data:

a. Sales are budgeted at $238,000 for May. Of these sales, $71,400 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 $124,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 $24,000. d. Selling and administrative expenses for May are budgeted at $86,100, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $4,450 for the month.

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

f. New refrigerating equipment costing $15,100 will be purchased for cash during May. g. During May, the company will borrow $23,800 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: EM131202282

Questions Cloud

Prepare a schedule of expected cash collections : The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Prepare a schedule of expected cash collections ..
Overstatement and understatement of retained earnings : Elliot Corp failed to record accrued salaries for 2013, of $2,000, for 2014 of $2,100 and for 2015 of $3,900. What is the amount of the overstatement and understatement of Retained earnings at December 31, 2016? Management has decided to switch from ..
The investment was accounted for using the equity method : Simmons Corporation owns stock of Armstrong, Inc. Prior to 2014, the investment was accounted for using the equity method. In early 23014, Simmons sold part of its investment in Armstrong, and began using the fair value method. In 2014, Armstrong ear..
Two accounting treatments on the financial statements : The 2012 annual report of Cisco Systems discloses that the company expenses all advertising and research and development costs, while capitalizing all software development cost. Describe the effect of these two accounting treatments on the financial ..
Prepare budgeted income statement : Minden Company is a wholesale distributor of premium European chocolates. The May 31 inventory balance is budgeted at $24,000. d. Selling and administrative expenses for May are budgeted at $86,100, exclusive of depreciation. These expenses will be p..
Decrease in cash from operating activities : Montgomery Company reported net income for the current year, but the company's Statement of Cash Flows reported a decrease in cash from operating activities. Which of the following could help explain this?
When should the company harvest the forest : Bunyan Lumber, LLC, harvests timber and delivers logs to timber mills for sale. The company was founded 70 years ago by Pete Bunyan. The current CEO is Paula Bunyan, the granddaughter of the founder. The table here shows the current price per MBF for..
Straight-line depreciation method : Gidley Inc. purchased a piece of equipment on January 1,2014. The following information is available for this purchase: Purchase Price - $950,000 Transportation - $100,000 Installation - $130,00 Salvage Value - $50,000 Useful Life - 4 years Included ..
What is the easter bunny breakeven in units : During the month of March, the Easter Bunny produced 10,000 chocolate eggs. What is the Easter Bunny’s breakeven in units? In dollars? How many units would the Easter Bunny need to sell if he wanted to make target profit of $10,000? What would his sa..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Shares outstanding

The annual dividend on $4.20 cumulative preferred, 500,000 shares authorized, 160,000 shares issued, 137,400 shares outstanding. Last year's dividend has not been paid.

  About the financial performance or health

If you were to get a physical from your doctor and he or she only took your blood pressure prior to stating that you are in good health, would you be concerned? If you have noticed in your readings, starting in Chapter 3, there has been explanation o..

  Inventory valuation method

10th Generation Electronics had two transformers in its inventory, one purchased in February for $11,800 and the other acquired in September for $13,300. In December, they sold one of the transformers to Ram Enterprises for $16,400 and reported a gro..

  Data related to the acquisition of timber rights

Data related to the acquisition of timber rights and intangible assets during the current year ended December

  The role of internal audit in the organization

Do you agree with the CFO? If so describe how SOX 404 and CEO/CFO certification removes the need for an internal audit function. If you don't agree, describe what an internal audit function adds beyond SOX 404 and CEO/CFO certification.

  Calculate the total present value of the cash flows

Price Mart is considering outsourcing its billing operations. A consultant estimates that outsourcing should result in after-tax cash savings of $9,000 the first year, $15,000 for the next two years, and $18,000 for the next two years. Interest is at..

  Identify the type of account as an asset

For each of the following (1) identify the type of account as an asset, liability, equity, revenue, or expense, (2) enter debit (Dr.) or credit (Cr.) to identify the kind of entry that would increase the account balance, and (3) identify the norma..

  Analyzing the strength and weakness from ratios

Analyzing The Strength and weakness from Ratios and  What would you learn from examining the incomestatement for the year ended 2008

  About same as its income measured under variable costing

Samanta Shoes, which was launched by entrepreneurs Samanta and Kelvin Joseph, produces high-quality shoes in unique styles and limited quantities. The founders of Samanta Shoes use variable costing in their business decisions. If Samanta Shoes used a..

  Calculate statement of cash flows using the indirect method

Barton Company uses the indirect method of preparing the Statement of Cash Flows and reports the following comparative balance sheet information. Prepare a Cash Flow Statement using the indirect method.

  What were the standard hours allowed for the units produced

Kansas Company uses a standard cost accounting system. In 2014, the company produced 27,500 units. Each unit took several pounds of direct materials and 1.6 standard hours of direct labor at a standard hourly rate of $12.00. What were the standard ho..

  Semiannual straight-line amortization on premium

If the amount of a newly issued 13%, 5-year, $100,000 bond on premium is $11,581.00. What is the semiannual straight-line amortization on premium?

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