Prepare a monthly cash budget

Assignment Help Financial Management
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?

Reference no: EM131445276

Questions Cloud

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?

Reviews

Write a Review

 

Financial Management Questions & Answers

  Target debt equity ratio

Sixx AM Manufacturing has a target (market value) debt equity ratio of 0.6. Its cost of equity is 19 percent, and its cost of debt is 9 percent. If the tax rate is 34 percent, what is the company's WACC?

  Considering purchasing a stock

You are considering purchasing a stock, and will sell it for $100 per share in 2 years. Dividends per share were $2 per share this year, but you expect them to increase at 20% per year for the next 2 years – and would receive them in years 1 and 2. Y..

  What is difference between rate cap and debt service cap

Most ARMs have rate caps and/or debt service caps. What’s the difference between a rate cap and a debt service cap?  In general, why do lenders front load fees and points rather than amortizing them over the life of a loan? Name three cash expenditur..

  What is the value of the levered firm

Great Lakes Shipping is an all-equity firm with anticipated earnings before interest and taxes of $439,000 annually forever. The present cost of equity is 16.4 percent. Currently, the firm has no debt but is considering borrowing $1.25 million at 8.5..

  Calculate the present value of the associated profit

Customers 1, 2, and 3 have gross values for the product of v1 = 12, v2 = 10, and v3 = 7, respectively. Consumers buy at most one unit of the good over the 2 periods. There are only 2 selling periods. If the monopolist makes no sales in the first peri..

  Interested in knowing what type of interest payment

Your broker is suggesting that you purchase a 20-year Industrial Business Machines bond that is selling for $9,120. The face value on the bond is $10,000 and your broker tells you that the bond has a yield to maturity of 10.7%. what is the coupon rat..

  Determine share price and new number of shares outstanding

Bermuda Triangle Corporation (BTC) currently has 350,000 shares of stock outstanding that sell for $98 per share. Assuming no market imperfections or tax effects exist. Required: Determine the share price and new number of shares outstanding if:

  How control weaknesses can lead to fraud

In your Discussion, you will be faced with a potentially fraudulent situation. This is something that you might face in your auditing career as well. How would you handle these types of difficult situations? As a new auditor, how would you respond to..

  Debt ratio-Gross or net profit margin and EPS

Capture and analyze key ratios/measures and speak to their value as they relate to both the past and expected future growth of the company. Please talk on ratios of ROA, ROE, Debt ratio, Gross or net profit margin and EPS.

  What was the firm end-of-year cash balance

You have just been hired as a financial analyst for Basel Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for..

  Perpetuity discounted-what is the present value

What is the present value of a $473 perpetuity discounted back to the present at 11.47 percent. The answer should be calculated to decimal places.

  Project has an initial fixed asset investment

A five-year project has an initial fixed asset investment of $330,000, an initial NWC investment of $34,000, and an annual OCF of −$33,000. The fixed asset is fully depreciated over the life of the project and has no salvage value. If the required re..

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