Reference no: EM131176578
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
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.
|
Forward rate for one us dollar in terms of canadian dollars
: If the spot rate for Candian dollars is 1.25 = 1 USD and the annual interest rate on fixed rate one year depostis of Canadian dollars is 2.5% and for US$ is 1.5%, what is the 9 month forward rate for one US dollar in terms of Canadian dollars? Is thi..
|
|
Experienced an explosion in demand
: Sports Novelties, Inc., has experienced an explosion in demand for its feathered football novelties. The firm currently (time 0) pays a dividend of $0.25 per share. This dividend is expected to increase to $0.75 per share 1 year from now. What is the..
|
|
Calculate estimate of percent price change due to durration
: A 6.5% coupon bearing bond that pays interest semi-annually has a yield to maturity of 4.8% per year. If the bond has a duration of 11.4 years and the market yield decreases 90 basis points, calculate an estimate of the percent price change due to du..
|
|
Dissatisfied with the performance of current management
: Suppose you have accumulated a sizable investment (100,000 common shares) in Alpine Land and Development Company. You are dissatisfied with the performance of the current management and are considering running for the board of directors. If the votin..
|
|
Weighted average cost of capital and debt
: 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. Current..
|
|
Fixed-rate mortgages with average interest rate
: A savings institution (SI) has funded $12 million of 30-year fixed-rate mortgages with an average interest rate of 5.75%. These assets are funded with time deposits with an average maturity of six months. The deposits are currently paying 3.50%. In s..
|
|
At the end of each year a self-employed person deposits
: At the end of each year a self-employed person deposits $1,500 in a retirement account that earns 10 percent annually. How much will be in the account when the individual retires at the age of 65 if the contributions start when the person is 45 years..
|
|
What conclusion do these percentage returns imply
: Investor A makes a cash purchase of 100 shares of AB&C common stock for $55 a share. Investor B also buys 100 shares of AB&C but uses margin. Each holds the stock for one year, during which dividends of $5 a share are distributed. what would have bee..
|
|
What is the cash flow from disposal
: Reversing Rapids Co. purchases an asset for $169,585. This asset qualifies as a five-year recovery asset under MACRS. The five-year expense percentages for years 1, 2, 3, and 4 are 20.00%, 32.00%, 19.20%, and 11.52% respectively. what is the cash flo..
|