Reference no: EM131445276
Prepare a monthly cash budget for Cyrus Brown Mfg for a 9-month period March through November using the data below in excel:
March - $100,000, April $275,000, May - $320,000, June - $450,000, July - $700,000, August - $700,000, Sept - $825,000, October - $500,000, November - $115,000.
Collected estimates of the forecasts sates: Pymt Collection within the month sale = 25%, Pymt collection the month following sales = 55%, pymt collection the second month following sales = 20%
Payment for direct mfg. costs like raw materials and labor are made during the month that follows the onein which such costs have incurred: March - $187,500, April - $206,250, May - $375,000, June - $337,500, July - $431,250, August - $640,000, Sept - $295,000, October - $425,000. Admin salaries approximate $35,000 a month, lease payments around $15,000 a month, depreciation charges $15,000 a month, a one time new plant investment for $95,000 is expected to be incurred and paid in June, income tax payments estimated to be $55,000 in June and Sept, miscellaneous cost estimated $10,000 a month
Based on the cash budget findings answer these questions. 1. Will the company need outside financing?. 2. What is the minium line of credit that CMB will need? 3. What doe you think of CBM's cash position during the budget period? 4. If you wre a bank manager, would wou want CBM as your cliet? Why or why not?
|
What are the expected future cash flow regarding the project
: Titan Inc. is considering introducing a new type of toy for cats. Titan expects the toys to become obsolete after five years when it will be discovered that toys only encourage cats to get anxious. What are the expected future cash flow regarding the..
|
|
How fast can sales grow before any new fixed assets
: Southern Mfg., Inc., is currently operating at only 87 percent of fixed asset capacity. Current sales are $660,000. How fast can sales grow before any new fixed assets are needed?
|
|
What is the external financing needed
: The most recent financial statements for Reply, Inc., are shown here: Income Statement Balance Sheet Sales $ 34,000 Assets $ 57,700 Debt $ 22,500 Costs 24,500 Equity 35,200 Taxable income $ 9,500 Total $ 57,700 Total $ 57,700 Taxes (40%) 3,800 Net in..
|
|
What is the sustainable growth rate
: Assume the following ratios are constant: Total asset turnover 2.0 Profit margin 5.1 % Equity multiplier 1.2 Payout ratio 25 % What is the sustainable growth rate?
|
|
Prepare a monthly cash budget
: Prepare a monthly cash budget for Cyrus Brown Mfg for a 9-month period March through November using the data below in excel: March - $100,000, April $275,000, May - $320,000, June - $450,000, July - $700,000, August - $700,000, Sept - $825,000, Octob..
|
|
An inflation-indexed treasury bond
: An inflation-indexed Treasury bond has a par value of $1,000 and a coupon rate of 2 percent. An investor purchases this bond and holds it for one year. During the year, the consumer price index increases by .25 percent every six months. What are the ..
|
|
Planning large anniversary party
: You and your sister are planning a large anniversary party 3 years from today for your parents' 50th wedding anniversary. You have estimated that you will need $6,500 for this party. You can earn 2.6 percent compounded annually on your savings. How m..
|
|
The cost of the product and fixed operating expenses
: Accents Associates sells only one product, with a current selling price of $200 per unit. Variable costs are 20% of this selling price, and fixed costs are $50,000 per month. Management has decided to reduce the selling price to $195 per unit in an e..
|
|
The power of rippling effect of adding money
: The power of a "rippling effect" of adding money to the financial system is measured by the ________. Which of the following will decrease the present value of a perpetuity, other things equal?
|