Prepare a cash budget for the month of march

Assignment Help Accounting Basics
Reference no: EM133031039

Question - A Company's projected sales, in units, for the first 4 months of 2015 are as follows:

Month Units

January 130,000

February 100,000

March 180,000

April 220,000

Each unit sells for $25 and costs $10 to acquire from a supplier. The company's cash collection pattern is as follows:

Month of sale: 60%

Month following sale: 25%

2nd month following sale: 12%

Uncollectible: 3%

The company's policy is to have enough goods on hand at the end of each month to meet 30% of the next month's sales.

Payments to suppliers are made as follows:

Month of purchase: 65%

Month following purchase: 35%

Other operating expenses for the month of March are expected to be $2,300,000, including $230,000 of amortization expense. All operating expenses are paid in the month they occur.

The company expects to have $35,000 cash on hand at the beginning of March and wants a minimum cash balance of $25,000. The company has access to a line of credit, and the controller is very interested to know if there will be requirements to draw down the line of credit at any time.

Required - Prepare a cash budget for the month of March addressing the controller's query regarding line of credit.

Reference no: EM133031039

Questions Cloud

What was the depreciation for the first year : Question - Equipment was acquired at the beginning of the year at a cost of $662,500. What was the depreciation for the first year
Determine the amount of the initial investment : Annual cost savings were: $15000 for year 1; 13000 for year 2; and $11000 for year 3. Determine the amount of the initial investment
Summarise the historical development of computer systems : Explore a range of hardware and related software and will learn to configure and install these. A range of networking technologies will be explored
Calculate the cash payback period : The company estimates that annual cash inflows would increase by $208,000. Calculate the cash payback period
Prepare a cash budget for the month of march : Other operating expenses for the month of March are expected to be $2,300,000, Prepare a cash budget for the month of March
What is the regular selling price : At the end of the season, the unsold sets were advertised at a discount of of the new regular selling price.
How many usd do you have : If you return with EUR 850, NZD 1,000, and GBP 750, and the exchange rates are unchanged, how many USD do you have
How is spotify taking advantage of mobile devices : How is Spotify taking advantage of mobile devices? How is Spotify a Music as a Service business?
Explain organizational integrity : 1) What each department of the organization can do to support the organization's published code of ethics

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