Reference no: EM13728181
Blue Bottling, Inc. (BBI), is a bottling company and is considering expanding into filling 16-ounce bottles. In order to do so, BBI must purchase a new bottling machine. The machine would not replace the machine used to fill 32-ounce bottles. The risk of this project is similar to the current risk of the company. BBI uses Net Present Value as its investment decision method. Therefore, BBI executives have decided that their weighted average cost of capital would be an appropriate discount rate to use when analyzing the project.
About the Machine
BBI managers estimate the cost of the machine to be $260,000. In order for the machine to be usable for BBI, it must be modified, costing $40,000. The machine will be depreciated using straight-line depreciation, assuming a 7-year life and $30,500 salvage value. BBI managers believe that the machine will be replaced at the end of 7 years at which time it will be sold for its salvage value. During the 7 years of its use, managers estimate annual earnings before interest, depreciation and taxes (EBITDA) to be $60,000. There will be an increase in net working capital of $5000 with the new press, due to increased accounts receivable and inventory costs.
Weighted Average Cost of Capital
Current investigation shows that the firm has a 40% marginal tax rate. (Round all numbers to one-hundredth of one percent).
Debt
The firm has 7000 of its $1000 par, 18-year, 5% semi-annual bonds that are currently outstanding and being quoted at 104:8.
Common Stock
BBI common stock is currently trading for $50 per share and there are 100,000 shares issued and outstanding. There are two methods of computing the cost of capital, and you should average the two values for your final cost of common stock.
The firm will pay annual dividends of $3.00 per share in the coming year. The firm’s dividends and earnings have been growing at an annual rate of 3.5%, and this is expected to continue in the future. Lang’s beta is currently .8 and the current 90-day t-bill rate is 2.5%, while the historic market average is 10%.
Requirements of the Assignment
1. Using Excel, create a spreadsheet that calculates all relevant cash flows (i.e., initial investment, periodic cash flows, and terminal value). Note: The spreadsheet should have data at the top and the cash flow calculations completely in equations, or picking up numbers from a previous cell. The instructor should be able to change inputs. The spreadsheet automatically adjusts to those changes. Round all numbers to the nearest dollar.
2. Compute the weighted-average cost of capital (WACC) for the chosen firm on your spreadsheet. Take this number out to the nearest hundredth of a percent (e.g. 33.33%). There is no preferred stock in the company. Determine the weight of debt and common equity by the current market value.
|
Units of production depreciation method
: Oil Company may calculate depreciation using the “units of production” method of depreciation. Consider a depreciable asset costing $100,000 that is expected to have a useful life of 120,000 units. Salvage value is estimated to be $20,000. Estimated ..
|
|
What would be your total return on the investment
: You bought a 7 percent coupon bond one year ago for $1,080.50. These bonds make annual payments and mature six years from now. Suppose you decide to sell your bond today when the required rate of return on the bond is 5.5%.If the inflation rate was 3..
|
|
Information summarizes charge and cost data
: Assume that Dr. Jones’ patients pay an average 80 percent of charges. Also assume cost to charge ratios of 0.90 in Nursing, 0.80 in Lab, 0.50 in Pharmacy, and 0.70 in Radiology. What is the total profit earned on Dr. Jones’ patients?
|
|
Mutual life insurance has a risk-based capital ratio
: Ashley is an actuary who is employed by the Nebraska Department of Insurance. Her duties include monitoring the financial position of insurance companies doing business in Nebraska. Based on an analysis of annual financial statements that insurers ar..
|
|
Weight of debt and common equity by the current market value
: Compute the weighted-average cost of capital (WACC) for the chosen firm on your spreadsheet. Take this number out to the nearest hundredth of a percent (e.g. 33.33%). There is no preferred stock in the company. Determine the weight of debt and common..
|
|
Suppose the sharpe ratio is intended to measure
: What advantages/disadvantages do the mutual fins offer compared to company stock for your retirement investing? Notice that, for every dollar you invest, S&S Air also invests a dollar. What return on your investment does this represent? What does you..
|
|
Relationships between customers and workers
: Comparison of similarities and differences of this establishment and other similar establishments you know about Nature of the treatment of customers in the establishment Relationships between customers and workers
|
|
Write an essay comparing the perspective issues and concerns
: Write an essay comparing the perspectives, issues and concerns of Aztec of Inca peoples and their contact with Europe.
|
|
What was the source of power and leadership motives
: Out of all the leaders you were influenced by, who stands out the most. What was the source of power, leadership motive(s), and influencing tactics of this individual.
|