Collection estimates regarding the forecast sales

Assignment Help Finance Basics

Reference no: EM13791129

Please read the relevant parts of your textbook, which refer to cash flow and financial planning.

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.

To receive full credit on this assignment, please show all work, including formulas and calculations used to arrive at the financial values.

Group Project Guidelines

As a group, prepare a monthly cash budget for Cyrus Brown Manufacturing for the 9-month period of March through November.
- Use Excel to prepare the monthly cash budget.
Based on your cash budget findings, answer the following questions:
- Will the company need any outside financing?
- What is the minimum line of credit that CBM will need?
- What do you think of CBM's cash position during the budget period? Do you see any concerns for the company in this regard?
- If you were a bank manager, would you want CBM as your client? Why or why not?
It is up to the members of the group to divide the assignment tasks evenly. You will be graded on group participation

Reference no: EM13791129

Questions Cloud

Self determination as non domination : Self determination as non domination

Individuals viewed the stock market : An explanation on how risk plays a role within financial markets and how did Bernard Madoff change the way in which individuals viewed the stock market and their investing plans.

Blunt force trauma versus sharp force injuries. : Explain how you can differentiate between injuries created from blunt force trauma versus sharp force injuries.

Explain what is meant by global sourcing of capital : Explain what is meant by global sourcing of capital. Explain what is meant by the terms Systematic risk, Unsystematic risk, and Beta as related to Investment in shares of public organizations.

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

Difference between a bullet, shell casing and a projectile. : Compare and contrast a revolver versus a semiautomatic handgun. How is the caliber of a handgun determined?

Calculate the total number of copies : Problem 1: Your finance text book sold 53,250 copies in its first year. The publishing company expects the sales to grow at a rate of 20 percent for the next three years, and by 10 percent in the fourth year. Calculate the total number of copies t..

Cross-cultural bias in employeepromotion : Cross-cultural Bias in EmployeePromotion

Individual characteristics as evidence in court : What must an investigator consider regarding the use of individual characteristics as evidence in court? Explain.

User Account

All Pages