Reference no: EM131448251
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 lineof 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? Please show the calculation and formulas step by step clearer. This is the seond time I sent this question but I could not make out the calculations and formulas on the spreadsheet.
|
Effect of tax rate on WACC
: Effect of tax rate on WACC
|
|
How many years do these bonds have left until they mature
: Backwater Corp. has 6 percent coupon bonds making annual payments with a YTM of 5.3 percent. The current yield on these bonds is 5.65 percent. How many years do these bonds have left until they mature?
|
|
Why are dividends relevant to firm valuation
: Why are dividends relevant to firm valuation? What is cost of equity (and not WACC) the appropriate discount rate to use in dividend based valuation model? Can you use the dividend discount model to value a firm that do not pay periodic dividends? Wh..
|
|
Firm wishes to maintain an internal growth rate
: A firm wishes to maintain an internal growth rate of 9.5 percent and a dividend payout ratio of 42 percent. The current profit margin is 6.4 percent and the firm uses no external financing sources. What must total asset turnover be?
|
|
Prepare a monthly cash budget for cyrus brown
: 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..
|
|
Sell convexity-which bond will be preferred by investors
: Suppose bonds Y and Z are identical in terms of duration and coupon but bond Z is more convex. Market participants expect interest rates to fall sharply. Which bond will be preferred by investors? Which bond will have a higher required yield? How muc..
|
|
The price-yield relationship for bonds is convex
: It is said that the price-yield relationship for bonds is convex. What does this mean? What role does convexity play in determining the rate of change in a bond price in response to changes in the required yield? Determine the percentage change in th..
|
|
Is this mortgage conventional mortgage
: You are considering buying a house close to the university so that you can devote more time to your academic career. You have estimated that you can afford $3500 per month as a mortgage payment because you plan to rent rooms out to your friends. What..
|
|
Calculate the periodic rate and the effective rate
: Assume that you are paying $1,000 to buy an asset that will pay $100 at the end of year one, $300 at the end of each of the following three years, and $500 at the end of the fifth year. Compute the rate of return on the investment. Suppose an investm..
|