Develop a cash budget for cyrus brown manufacturing venture

Assignment Help Corporate Finance
Reference no: EM131120122

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 nine months:

March 2004 $250,000

April 275,000

May 320,000

June 450,000

July 575,000

August 700,000

September 825,000

October 350,000

November 285,000 He has also gathered the following collection estimates regarding the forecast sales: Collection within the month of sale, 10%; collection the month following sales, 65%, and collection the second month following sales, 25%. 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 2004 $187,500

April 206,250

May 240,000

June 337,500

July 431,250

August 525,000

September 618,750

October 262,500

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 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

a. Prepare a monthly cash budget for Cyrus Brown Manufacturing for the nine month period, March through November.

b. Based on your findings in part b, will the company need any outside financing?

Reference no: EM131120122

Questions Cloud

Work of art created to express : If you were to have a work of art created to express your experiences as a student, what would it be? What would it look like? How would it communicate your experience in terms of its composition?
Who are the major players in health policies : What is the premise of healthcare policies? (consider the following: past/current policies that impact provider-insurer shift) Is healthcare access a "human right" or a "privilege"? Provide a rationale.
The company depreciates all assets using the half year : Complete the table for the year ended December 31, 2011. The company depreciates all assets using the half-year convention.
Explaining the arts : Imagine a scenario where you are the last surviving member of the human species and you find yourself on another planet. The people of the planet do not have performing or visual arts of any kind. Living on a planet without the arts is dull, so yo..
Develop a cash budget for cyrus brown manufacturing venture : 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).
Characterization of characters in film : In the second paragraph, you should state some insight about the characterization of the characters in the film. (Use the following questions to guide your response).
Religion site visit assignment : Attend a religious service or ritual from a spiritual tradition that is significantly different from your own personal experience of religion. In other words, if you are Catholic, find a Jewish, Muslim, Buddhist, or perhaps Pentecostal Christian s..
Depreciation computations five methods : Depreciation Computations-Five Methods, Partial Periods Agazzi Company purchased equipment for $304,000 on October 1, 2010.
Identify problem which exist in ferguson and son mfg company : Identify the problems which appear to exist in Ferguson & Son Mfg. Company's budgetary control system and explain how the problems are likely to reduce the effectiveness of the system.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Find lowest acceptable transfer price

The commando motorcycle corporation has decided to become decentralized and split its operations into 2 divisions. Motor and Assembly. Both divisions will be treated as investment centers.

  Investment appraisal and analysis suppose you are planning

suppose you are planning to buy a new machine popo corn machine. the machine will cost 450000 and would last for three

  Describe the key elements of the securities markets

Describe the key elements of the securities markets, and how the markets drive financial transactions, decision making, and risk analysis.

  Determine the financial feasibility of the project

Compute the NPV in the IRR to determine the financial feasibility of the project. What is the project's net present value (NPV) at a discount rate of 8%, and what is the project's IRR?

  Evaluate share of the common stock

Which do you think will have the higher price (and why), a share of the preferred stock or a share of the common stock?

  Crafts boat shop for several years now and have been very

crafts boat shop for several years now and have been very successful. you have come to the point where you expect sales

  Explain sensitivity analysis

What role does this type of analysis play in your work environment or in your home environment and also explain  sensitivity analysis.

  Calculation of ebit-eps indifference pointemco products has

calculation of ebit-eps indifference point.emco products has a present capital structure consisting only of common

  Evaluate a french subsidiarys free cash flow

Evaluate a French subsidiary's Free Cash Flow in Year 1, using the following information - Year 1 depreciation = 25,000 Euros

  Financial statement ratio analysis

Financial Statement ratio analysis-Project Due at the end of the Post week - Prepare common sized statements for the 3 years and Prepare a trend analysis for both the balance sheet (classification totals only) and the income statement.

  What is the holding period return to an investor

What is the holding period return to an investor who bought 100 shares of Charter Oil nine months ago for $36 a share, received two $50 dividend checks, and sold the stock today at $38 a share?

  Prepare a dcf valuation of the selected company

Prepare a DCF Valuation of the selected company using the eVal model and the projections developed in Week 2. Compare the intrinsic value of the company's stock (valuation) compared to the current stock price.

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