Develop a cash budget for his latest venture

Assignment Help Financial Management
Reference no: EM13995295

To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a cash budget for his latest venture: Cyrus Brown Manufacturing (CBM). He has estimated the following sales forecast for CBM over the next 9 months:

March        $100,000
April           $275,000
May            $320,000
June            $450,000
July             $700,000
August        $700,000
September  $825,000
October     $500,000
November   $115,000

He has also gathered the following collection estimates regarding the forecast sales:

• Payment collection within the month of sale = 25%

• Payment collection the month following sales = 55%

• Payment collection the second month following sales = 20%

Payments for direct manufacturing costs like raw materials and labor are made during the month that follows the one in which such costs have been incurred. These costs are estimated as follows:

March     $187,500
April       $206,250
May         $375,000
June        $337,500
July               $431,250
August         $640,000
September  $395,000
October  $425,000

Additional financial information is as follows:

• Administrative salaries will approximately amount to $35,000 a month.

• Lease payments around $15,000 a month.

• Depreciation charges, $15,000 a month.

• A one-time new plant investment in the amount of $95,000 is expected to be incurred and paid in June.

• Income tax payments estimated to be around $55,000 will be due in both June and September.

• And finally, miscellaneous costs are estimated to be around $10,000 a month.

• Cash on hand on March 1 will be around $50,000, and a minimum cash balance of $50,000 shall be on hand at all times.

Reference no: EM13995295


Write a Review


Financial Management Questions & Answers

  Net investment-single net cash flow

Would you recommend a project that has a net investment at time 0 of $15,500 and a single net cash flow of $28,600 at the end of the fifth year if the required rate of return is 12.5%?

  What is the premium in terms of debt that the investor pays

What is the current yield of this bond? What is the value of the bond based on the market price of the common stock? What is the value of the common stock based on the market price of the bond? What is the premium in terms of debt that the investor p..

  What is his thirty-year holding period yield

A 30-year corporate bond sold to investors at par ($1000) with a 10 percent coupon rate is called sixteen years later at a 12 percent call premium. At the time of call, prevailing rates on comparable securities were 8 percent. If the bond's holder re..

  Customer in using payment cards for purchases

A lot of customers use payment cards when purchasing items online. Identify the advantages and disadvantages for both the company and the customer in using payment cards for purchases. Due to phishing attacks online, identity theft is prevalent. Desc..

  What is the portfolios beta

Bill Dukes has $100,000 invested in a 2-stock portfolio. $77,500 is invested in Stock X and the remainder is invested in Stock Y. X's beta is 1.50 and Y's beta is 0.70. What is the portfolio's beta?

  What is the sustainable growth rate for your firm

GBK, Inc. has sales of 10,552; total assets of 6210; and a debt-equity ratio of 1.40. If its return on equity is 15%, what is its net income? What is the sustainable growth rate for Your Firm, Inc.?

  Dollar duration of the underlying in order to hedge

Explain why it is necessary to know the dollar duration of the underlying in order to hedge. One of the problems in liability-driven investing when using cash market Treasuries for hedging interest-rate risk is that the duration will produce a dollar..

  Relevant cash flows

Which of the following are relevant cash flows? You pay a lawyer $34,000 to examine the copyright issues of a new project prior to its implementation. A cell-phone company losses $10,000 of sales of an old phone model due to a new model hitting the m..

  Analysis of the investment

Analysis of the Investment,  To prepare for this Individual Assignment: Review the Anthony's Orchard case study in the unit resources.

  Photocopying for sales department-administrative department

Triton Company's copy department, which does almost all of the photocopying for the sales department and the administrative department, budgets the following costs for the year, based on the expected activity of copies:

  Last payment at an annual effective rate of interest

Consider an annuity-due with 12 annual payments. The first payment is 4000 at time 0 and each subsequent payment decreases by 5%. Find the AV of this annuity 2 years after the last payment at an annual effective rate of interest i=6%.

  Considering two alternative planes

Zappe Airlines is considering two alternative planes. Plane A has an expected life of 5 years, will cost $100 million, and will produce after-tax cash flows of $35 million per year. Plane B has a life of 10 years, will cost $138 million, and will pro..

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