Schedules of expected cash collections

Assignment Help Financial Accounting
Reference no: EM131292935

Miken Company:

The following data relate to the operations of Miken Comapny, a distributor of consumer goods.

Accounts as of March 31:

         Cash                                $8,000

         A/R                                  $20,000

         Inventory                         $36,000

         Building & Equip (net)        $120,000

         A/P                                  $21,750

         Capital stock                    $150,000

         Retained Earnings             $12,250

A. The gross margin is 25% of sales

B. Actual and budgeted sales data:

            March (actual)         $50,000

            April                       $60,000

            May                        $72,000

            June                       $90,000

            July                        $48,000

C. Sales are 60% cash and 40% credit. Credit sales are collected in the month following sale. The A/R at March 31 are a result of March credit sales.

D. Each month's ending inventory should equal 80% of the following month's budgeted COGS

E. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The A/P at March 31 are the result of March purchases of inventory

F. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month.

G. Equipment costing $1,500 will be purchased for cash in April

H. The company must maintain a minimum cash balance of $4,000. An open line of credit is available at a local bank. All borrowing is done at the beginning of a month, and all repayments are made at the end of the month; borrowing must be in multiples of $1,000. The annual interest rate is 12%. Interst is paid only at the time of repayment of principal. (figure interest in whole months 1/12, 3/12, etc.)

Using this information complete the following schedules:

1. Schedules of expected cash collections

2. Merchandise purchase budget

3. Schedule of cash disbursments (merchandise)

4. Schedule of cash disbursments (operating expenses)

5. Cash budget

Reference no: EM131292935

Questions Cloud

Seasonal or cyclical patterns : Holt-Winter's double exponential smoothing would be an appropriate method to use to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns.
What challenges did you and your team face : What challenges did you and your team face? What actions did you take to address and resolve the challenges? Describe in detail.In your judgment, was your team's training program effective in meeting the written objectives? Explain.How effective were..
Describe the effect of each payment basis on output : Four common bases of payment for physicians are salary,fee for service,fee per case,and capitation. Describe the effect of each payment basis on output. Discuss studies that have examined the relative costs and benefits of each payment system.
Discuss the role of the delphi technique in product research : Explain how marketing research can be used in product generating and testing.- Discuss the role of the Delphi technique in product research.
Schedules of expected cash collections : The following data relate to the operations of Miken Comapny, a distributor of consumer goods. Using this information complete the following schedules: Schedules of expected cash collections. Merchandise purchase budget. Schedule of cash disbursments..
Department for a tire manufacturing company : The manager of the quality department for a tire manufacturing company wants to know the average tensile strength of rubber used in making a certain brand of radial tire. She knows the population standard deviation and uses a Z test to test the nu..
How firms obtain information about competitors strategy : Discuss the problems involved in identifying competitors and indicate how firms might obtain information about competitors' strategies and intended strategies.
Condorcet paradox and arrow impossibility theorem : What is the Condorcet paradox and arrow's impossibility theorem in the political economy?
Suggest a research proposal that could be implemented : How the concepts of market segmentation, targeting and positioning and the marketing mix might be profitably applied to re-establish Bukhara as a tourist destination rather than merely an overnight stop in the minds of tourists.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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