Prepare a well labeled schedule of expected cash collections

Assignment Help Accounting Basics
Reference no: EM131918465

PROBLEM - Hillyard Company prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter of 2014:

a. As of December 31, 2013, the company's balance sheet showed the following account balances:

Cash                                     $48,000                    Accounts Payable    $93,000

Accounts Receivable                156,800                   Capital Stock          400,000

Less: Allowance for bad debt   (4,480)   $152,320     Retained Earnings   137,320   Inventory     60,000

Plant & Equipment (net)                        370,000

                                                         $630,320                                  $630,320

b. Actual sales for December and budgeted sales for the next four months are as follows:

Dec.-$280,000 Jan.-$400,000 Feb.-$600,000 Mar.-$300,000 Apr.-$200,000

c. Sales are 20 percent for cash and 80 percent on credit. The collection pattern for credit sales, which is not expected to change over the next six months, is 30 percent in the month of sale, 68 percent one month after the month of sale, and 2 percent uncollectible.

d. The monthly gross profit rate is 40 percent of sales.

e. Monthly expenses are budgeted as follows: salaries and wages, $27,000 per month; advertising, $50,000 per month plus 4 percent of previous month's sales; and other expenses, 3% of sales. These expenses are paid for in the month in which they are incurred. Depreciation expense is $14,000 per month.

f. At the end of each month, inventory is to be on hand equal to 25 percent of the following month's sales needs stated at cost.

g. One half of a month's inventory purchases are paid for in the month of purchase; the other half is paid for in the following month.

h. During January, the company will purchase a new copy machine for $1,700 cash. During February, other equipment will be purchased for $80,000 (25% cash down payment with the remaining balance to be paid in four equal installments beginning one month after the date of purchase).

i. During January, the company will declare and pay $45,000 in cash dividends.

A. Prepare a well labeled Schedule of Expected Cash Collections (not an entire cash budget) for each month (January, February, and March) of the first quarter of 2014.

B. Prepare a well labeled Inventory Purchases Budget (in $) for each month (January, February, and March) of the first quarter of 2014.

C. Prepare a well labeled Schedule of Cash Disbursements (not an entire cash budget) for each month (January, February, and March) of the first quarter of 2014.

D. Assume that at the end of January, 2014, Hillyard Company's Cash Budget indicates a negative cash balance. Other than borrowing money, list at least three distinctly different recommendations for alleviating this expected negative cash balance.

Reference no: EM131918465

Questions Cloud

How much money will he have at the end of four years : Terry is calculating the present value of a bonus he will receive next year. The process he is using is called ?
Read each of the five cases in health administration : Read each of the five cases in health administration. Explanation for each case that explains why the case represents its particular ACHE competency domain.
What is the firm gain or loss-what is break-even point : What is the firm's gain or loss at sales of 5,000 watches? Enter loss (if any) as negative value. What is the break-even point (unit sales)?
What are barriers to effective cross-cultural communication : What are the barriers to effective cross-cultural communication? How might these be surmounted? Identify 1 global location where this barrier is relevant.
Prepare a well labeled schedule of expected cash collections : Prepare a well labeled Schedule of Expected Cash Collections for each month of the first quarter of 2014. Prepare a well labeled Inventory Purchases Budget
Challenges associated with employee feedback : Assess the challenges of managers providing accurate, timely, and effective feedback to employees. Recommend how managers can overcome
Semi-conductor manufacturing firm with three divisions : Quipta is a semi-conductor manufacturing firm with three divisions. These are Tools, which constitutes 40 percent of the assets of the firm, Digital Equipment.
Difference between bookkeeping and accounting : What is the accounting equation? Why is this important to the practice of accounting? Please provide an example of how the accounting equation works.
Individual taxpayer of certain aspect of tax law : Advise an individual taxpayer of a certain aspect of tax law.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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