In: Finance
Kirksville Inc. has 1,500 bonds outstanding that are selling for $932 each. The bonds carry a 5.0 percent coupon, pay interest semi-annually, and mature in 12.5 years. The company also has 11,500 shares of 6% preferred stock at a market price of $30 per share. This month, the company paid an annual dividend in the amount of $1.50 per share. The dividend growth rate is 4.0 percent. The common stock is priced at $30 a share and there are 35,500 shares outstanding. The company is considering a project that is equally as risky as the overall company. This project has initial costs of $600,000 and operating cash flows of $150,000 a year for the next 10 years and salvage value of $15,000 at the end of 10 years. The initial costs will be financed externally with the flotation costs of 6%. The net working capital (NWC) is expected to increase by $10,000 a year until the end of the project life. The project will be depreciated straight-line to zero over the project’s 10-year life. The tax rate is 20%.
a. The cost of debt is calculated by employing the RATE function in excel as follows:
PV =$932
FV = $1,000
PMT = $1,000 X 2.5% = $25
NPER = 12.5 years X 2 = 25
Therefore, RATE (NPER, PMT, -PV, FV, 0) = RATE (25, 25, -932, 1000, 0) = 2.89%.
As the bond is semi-annual, annual cost of bond = 2.89% X 2 = 5.77%.
Therefore, after tax cost of bond = 5.77% X (1-.20) = 4.62%.
Cost of preference capital is 6% (given)
Cost of equity capital is computed as below:
D1 / P0 + G = ($1.50 x 104%) / $30 + 4% = $1.56 / $30 + 4%= 9.20%.
The weights of different components of capital are computed as below:
Market value of debt capital = 1,500 X $932 = $13,98,000
Market value of preferred capital = 11,500 X $30 = $345,000
Market value of equity capital = 35,500 X $30 = $10,65,000
Therefore, total capital = $13,98,000 + $345,000 + $10,65,000 = $28,08,000.
Weight of debt capital = $13,98,000 / $28,08,000 = 0.50
Weight of preferred capital = $345,000 / $28,08,000 = 0.12
Weight of equity capital = $10,65,000 / $28,08,000 = 0.38
Hence, weighted average cost of capital (WACC) = Respective costs of capital X respective weights = 4.62% X 0.50 + 6% X 0.12 + 9.20% X 0.38 = 6.53%.
b. Revised cost of capital = WACC / (1- Floatation cost) = 6.53% / (1- 0.06) = 6.94%.
| 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
 6  | 
 7  | 
 8  | 
 9  | 
 10  | 
|
| 
 Operating cash flows  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
| 
 (+) Salvage value  | 
 $0  | 
 $0  | 
 $0  | 
 $0  | 
 $0  | 
 $0  | 
 $0  | 
 $0  | 
 $0  | 
 $15,000  | 
| 
 Total cash flows  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,50,000  | 
 $1,65,000  | 
| 
 (-) Increase in working capital  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
 $10,000  | 
| 
 (-) Depreciation  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
| 
 EBIT  | 
 $80,000  | 
 $80,000  | 
 $80,000  | 
 $80,000  | 
 $80,000  | 
 $80,000  | 
 $80,000  | 
 $80,000  | 
 $80,000  | 
 $95,000  | 
| 
 (-) taxes @ 20%  | 
 $16,000  | 
 $16,000  | 
 $16,000  | 
 $16,000  | 
 $16,000  | 
 $16,000  | 
 $16,000  | 
 $16,000  | 
 $16,000  | 
 $19,000  | 
| 
 Cash flow after taxes  | 
 $64,000  | 
 $64,000  | 
 $64,000  | 
 $64,000  | 
 $64,000  | 
 $64,000  | 
 $64,000  | 
 $64,000  | 
 $64,000  | 
 $76,000  | 
| 
 (+) Depreciation  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
 $60,000  | 
| 
 Free cash flows  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,24,000  | 
 $1,36,000  | 
| 
 Present value discounting factor [1 / (1 + 6.94%)^n], n= 1,2,...10  | 
 0.94  | 
 0.87  | 
 0.82  | 
 0.76  | 
 0.71  | 
 0.67  | 
 0.63  | 
 0.58  | 
 0.55  | 
 0.51  | 
| 
 Present value of free cash flows (Free cash flows X Discount factor)  | 
 $1,15,951  | 
 $1,08,425  | 
 $1,01,387  | 
 $94,806  | 
 $88,652  | 
 $82,898  | 
 $77,517  | 
 $72,485  | 
 $67,780  | 
 $69,514  | 
| 
 Sum of present values  | 
 $8,79,415  | 
|||||||||
| 
 (-) Initial investment  | 
 $6,00,000  | 
|||||||||
| 
 NPV  | 
 $2,79,415  | 
As the NPV is positive, the project should be accepted.