Estimate cash collections for march

Assignment Help Accounting Basics
Reference no: EM13511723

The treasurer of John Loyde Company plans for the company to have a cash balance of $91,000 on March 1. Sales during March are estimated at $900,000. February sales amounted to $600,000, and January sales amounted to $500,000. Cash payments for March have been budgeted at $580,000. Cash collections have been estimated as follows:

-Sixty percent of the sales for the month to be collected during the month.

-Thirty percent of the sales for the preceding month to be collected during the month.

-Eight percent of the sales for the second preceding month to be collected during the month.

The treasurer plans to accelerate collections by allowing a 2 percent discount for prompt payment. With the discount policy, she expects to collect 70 percent of the current sales and will permit the discount reduction on these collections. Sales of the preceding month will be collected to the extent of 15 percent with no discount allowed, and 10 percent of the sales of the second preceding month will be collected with no discount allowed. This pattern of collection can be expected in subsequent months. During the transitional month of March, collections may run somewhat higher. However, the treasurer prefers to estimate collections on the basis of the new pattern so that the estimates will be somewhat conservative.

1. Estimate cash collections for March and the cash balance at March 31 under the present policy and under the discount policy.

2. Is the discount policy desirable?

1.


Under the present policy

Under the discount policy

Balance, March 1

$ 91,000

$ 91,000

Collections:



From March sales

540,000 ($900,000 X 60%:

617,400""

From Feb. sales

180,000 ($600,000 X 30%;

90,000 ($600,000 X 15%)

From Jan. sales

40,000 ($500,000X 8%)

50,000 ($500,000 X 10%)

Total cash available

$85 1,000

$848,400

Less: Disbursements

580,000

580,000

Balance, March 31

$271,000

$268,400

*$900,000 X 70% X 98% $617,400

2.No, cause under the discount policy, the March 31 cash balance will be smaller.

The following information pertains to merchandise purchased by Westwood Plumbing Company for July, August, September, and October. During the month, 60 percent of the merchandise to be sold during the following month is purchased. The balance of the merchandise is purchased during the month. Gross margin averages 20 percent of sales.


Purchases


For the following

For the current month

July

$ 87,000

$ 92,000

August

96,000

100,000

September

120,000

89,000

October

110,000

92,000

Estimate the sales revenue for August, September, and October.

Reference no: EM13511723

Questions Cloud

Determine cost for such a service : Do you agree with the customer? Discuss fully the problems involved in determining cost for such a service, including the limitations of the cost figures obtained.
How to be managing cash needs : Establishing a department whose responsibility is to approve customer's credit.
Evaluate the expected average molecular weight : calculate the expected average molecular weight of the resultant living polymer chains if you could introduce exactly 500 molecules n-butyllithium. Assume no termination and total usage of the monomer and initiator.
What is the arrow range : The speed of an arrow fired from a compound bow is about 29 m/s. An archer sits astride his horse and launches an arrow into the air elevating the bow at an angle of 35 degrees above the horizontal, What is the arrow range
Estimate cash collections for march : Estimate the sales revenue for August, September, and October - Estimate cash collections for March and the cash balance at March 31 under the present policy and under the discount policy.
What beat frequency does this person perceive : a person leaning over a 126 m deep well accidentally drops a siren emitting sound of frequency 2450 hz. Just before this siren hits the bottom of the well, What beat frequency does this person perceive
Choose a nationally recognized franchise : Choose a nationally recognized franchise (e.g., Subway, Curves, 7-Eleven, Quizno's, REMAX, Choice Hotels International, and Dunkin' Donuts), and visit that company's Web site to learn about its contractual marketing system, as well as informat..
Evaluate the difference in activation energy : Calculate the difference in activation energy between disproportionation and combination. At what temperature will termination be 90% by combination
What do you think accounts for rise of conspiracy theories : What do you think accounts for the rise of conspiracy theories that are offered as explanations for the assassinations of the great leaders of the 1960s?

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