Prepare a cash collections budget for the first quarter

Assignment Help Accounting Basics
Reference no: EM131734759

Case - Budgets

Sunshine Corporation has found that 60% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, the company has experienced the following collection pattern:

  • 25% received in the month of the sale
  • 50% received in the month after the sale
  • 15% received two months after the sale
  • 10% of the credit sales are never received

November sales for last year were $85,000, while December sales were $110,000. Projected sales for the next three months are as follows:

January sales $ 145,000

February sales 115,000

March sales 175,000

Requirement - Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter.

Reference no: EM131734759

Questions Cloud

What will happen to the company''s operating income : If the company decides to discontinue the product line, what will happen to the company's operating income
What are the trade-offs : What are the trade-offs? How could they be reconciled?
Elimination of trade barriers affected eu output : By 1993, nations in the European Union (EU) had eliminated all barriers to the flow of goods, services, labor, and capital across their borders.
Hdmi wires inventory does cisco sell per day : How many inventory dollars worth of HDMI wires inventory does Cisco sell per day?
Prepare a cash collections budget for the first quarter : Sunshine Corporation has found that 60% of its sales in any given month are credit sales, Prepare a cash collections budget for the first quarter
Represent the proportion of all actors : In a random sample of 65 professional actors, it was found that 41 were extroverts.(a) Let p represent the proportion of all actors who are extroverts.
Job shop systems with cellular manufacturing systems : Compare and contrast traditional job shop systems with Cellular Manufacturing Systems.
What is the actual cost per yard of fabric purchased : What is the standard direct material cost for one blanket? What is the actual cost per yard of fabric purchased
Describe examples in which data warehouses could be used : Describe four examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.

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