Purchase Solution

Cyrus Brown's Cash Budget Mar-Nov

Not what you're looking for?

Ask Custom Question

Cyrus Brown Manufacturing has estimated the following sales forecast over next 9 mo.:

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.

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 are made during the month that follows the one in which such costs have been incurred as follows:

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

Additional financial info:

Administration salaries will approximately amount to $35,000 a month;
lease payments around $15,000 a month;
Depreciation-$15,000 a month;
a one-time plant investment 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 June and September;
miscellaneous $10,000 a month.

Cash on hand March 1st will be around $50,000 and a minimum cash balance of $50,000 shall be on hand at all times. Show all work, formulas and calculations. Based on information:
1) will the company need any outside financing;
2) what is the minimum line of credit will CBM need?
3)what is CBM's cash position during the budget period?Is there any concerns for the family in this regard?If you were a bank manager would you want CBM as your client? Why or Why not?

Purchase this Solution

Solution Summary

Your tutorial discusses the cash flow analysis from Mar to Nov, including the insights about borrowings and repayments and whether a bank might like a client like this firm. Your cash budget is in excel (click in cells to see computations).

Solution Preview

Will the company need any outside financing?

Yes, they need to borrow in five of the nine months per the cash budget (yellow cells).
What is the minimum line of credit that CBM will need?

The largest amount of borrowings during the year, without considering interest payments, is $415,250 (pink cell). So, the line should be at least that plus perhaps a cushion because ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media