Prepare a cash budget for atlas products

Assignment Help Financial Management
Reference no: EM131339890

Prepare a cash budget for Atlas Products, Inc., for the first quarter of 2006, based on the following information.

The budgeting section of the corporate finance department of Atlas Products has received the following sales estimates from the marketing department:

 

Total Sales

Credit Sales

December 2005

$825,000

$770,000

January 2006

730,000

690,000

February 2006

840,000

780,000

February 2006

920,000

855,000

The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting.

The company estimates its purchases at 60 percent of next month's sales, and payments for those purchases are budgeted to lag the purchases by one month.

Various disbursements have been estimated as follows:

 

January

February

March

Wages and Salaries

$250,000

$290,000

$290,000

Rent

27,000

27,000

27,000

Other Expenses

10,000

12,000

14,000

In addition, a tax payment of $105,000 is due on January 15, and $40,000 in dividends will be declared in January and paid in March. Also, the company has ordered a $75,000 piece of equipment. Delivery is scheduled for early January, and payment will be due in February.

The company's projected cash balance at the beginning of January is $100,000, and the company desires to maintain a balance of $100,000 at the end of each month.

Reference no: EM131339890

Questions Cloud

Requirements of case and slp assignments : To accomplish the requirements of Case and SLP assignments, it is crucial to study materials in Background section to gain knowledge of the concepts introduced in this module.
Use all available methods to evaluate projects : Assume you use all available methods to evaluate projects. If there is a conflict in the indicated decision between two mutually exclusive projects due to the IRR-based indicator, you should:
Identify common challenges and issues arise in workplace : Conduct a 30-minute, semi-structured interview with a manager: Identify common challenges and issues that arise in the workplace, Evaluate strategies for addressing these challenges
Find an analytic approximation for the function : Find an analytic approximation for the function P(T) along the liquid-gas phase boundary. Sketch your answer and compare it to a phase diagram of water that you can find on the Web.
Prepare a cash budget for atlas products : Prepare a cash budget for Atlas Products, Inc., for the first quarter of 2006, based on the given  information.
The weighted average cost of capital for a firm : The weighted average cost of capital for a firm with a 60% debt and 40% equity in its capital structure, an 8% cost of debt, a 15% cost of equity, and a 35% tax rate would be: a. 7.02% b. 9.12% c. 10.80% d. 11.08% e. 13.80%
The discounted payback rule may cause : The discounted payback rule may cause:
What is the firm pretax cost of debt : JL Lumber has a debt-equity ratio of .62. The firm's required return on assets is 12 percent and its current cost of equity is 15.60 percent. What is the firm's pretax cost of debt? Ignore taxes. In the decline stage, we know that both profit and cas..
Develop an inventory management system : Case Study Presentation - Systems Project Management (COMP 0383) - Develop your proposal as a group of three members into a professional document of not more than 12 to 15 Pages, and create a PowerPoint presentation to discuss the Case study requir..

Reviews

Write a Review

Financial Management Questions & Answers

  What are the annual net cash flows associated with purchase

What are the annual net cash flows associated with the purchase of this machine? Also compute the net investment (NINV) for this project.

  Purchase one share of stock in lion equity

Lion Equity paid an annual dividend of $3.25 per share last month, and it is anticipated that future dividends will increase by 4% annually. As a shareholder, if you require a 12% return on your investment in Lion Equity, how much are you willing pay..

  How much is coefficient of variation for the new portfolio

An investor holds a porfolio of stocks and is consider in investing in the DBB Company. The firm's prospects look neutral and you estimate the following probability distribution of possible returns. How much is the coefficient of variation for the ne..

  What proceeds did sheffield company receive

On Oct. 14, Sheffield Company discounted at Sunshine Bank a $9,000 (maturity value), 113-day note dated July 13. Sunshine’s discount rate was 11%. (Use Days in a year table.) What proceeds did Sheffield Company receive?

  How much net working capital does the firm need to fund

Dandee Lions, Inc. has a cash balance of $105,000; accounts payable of $290,000; inventory of $213,000; accounts receivable of $310,000; notes payable of $95,000; and accrued wages and taxes of $65,000. How much net working capital does the firm need..

  Assuming annual payments-what is the value of the bond

Jane issued five-year bonds that pay a coupon of 6.5 percent semi annually. The current market rate for similar bonds is 5.5 percent. How much will you be willing to pay for Jane's bond today? Jane is issuing a 10-year bond with a coupon rate of 6.76..

  Financial institutions have developed variety of methods

Financial institutions have developed a variety of methods a company to use receivables to obtain immediate cash. The methods differ with respect to which rights and risks are retained by the transferor. Discuss the alternative accounting treatments ..

  Nominal and effective cost of trade credit under credit term

What is the nominal and effective cost of trade credit under the credit terms of 3/10, net 35? Assume 365 days in a year for your calculations.

  Evaluate the fcf valuation

Explain results of your Market Multiples analysis and reconcile the FCF Valuation results with the Market Multiples Valuation results

  Does good corporate governance matter

Does good corporate governance matter? The Sarbanes-Oxley Act (SOX) was passed in 2002 by the U.S. Congress to address corporate governance reform. SOX has not been without controversy to put it mildly. Identify and discuss several positive and negat..

  What will these bonds sell for at insurance

Imagination Dragons Corporation needs to raise funds to finance a plant expansion, and it has decided to issue 20-year zero coupon bonds with a par value of $1,000 each to raise the money. The required return on the bonds will be 7 percent. Assume se..

  How much should he pay taxes on his social security benefits

John is receiving $1,000 each month from Social Security, and he works at a local store as a part-time worker to earn extra $1,000 each month. He has very small amounts (less than $1,000 a year) of interest and dividends income. He is a single filer...

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