In: Finance
Part (a)
Face value of the bonds not given. I have assumed the same to be $ 1,000 which is a customary assumption consistent with debt capital markets.
Price of the bond, Pb = - PV (Rate, Nper, PMT, FV) = - PV (9%, 5, 10% x 1000, 1000) = 1,038.90
Price of the preferred stock, Pp = annual dividend / required return = 20% x 150 / 12% = 250.00
Cost of common equity, Ke = Rf + Beta x (Rm - Rf) = 5% + 1.5 x (13% - 5%) = 17.00%
Price of common stock, Pe = D1 / (Ke - g) = 5 / (17% - 9%) = 62.50
Part (b)
Please see the table below. All financials are in $. Please see the second row to understand the mathematics. The cells colored in yellow contain your answer.
Instrument | Price | Number | Value | Weight | Pre tax cost | Post tax cost | Weighted cost |
P | N | V = P x N | w = V / total V | K | K* (see note below) | w x K* | |
Debt | 1,038.90 | 5,000.00 | 5,194,482.56 | 82.20% | 9.00% | 6.30% | 5.18% |
Preferred stock | 250.00 | 2,000.00 | 500,000.00 | 7.91% | 12.00% | 12.00% | 0.95% |
Common equity | 62.50 | 10,000.00 | 625,000.00 | 9.89% | 17.00% | 17.00% | 1.68% |
Total | 6,319,482.56 | 100.00% | WACC = | 7.81% |
*Note: Post tax cost = K x (1 - T) = 9% x (1 - 30%) = 6.30% for debt; for other instruments, post tax cost = pre tax cost.
Part (c)
Year, n | Linkage | 0 | 1 | 2 | 3 | 4 |
Initial cost | A | -3,000,000 | ||||
Inflow | B | 500,000 | 4,500,000 | 6,600,000 | 4,000,000 | |
Outflow | C | -1,000,000 | -900,000 | -700,000 | ||
Net cash flows | D = A + B + C | -3,000,000 | -500,000 | 3,600,000 | 5,900,000 | 4,000,000 |
WACC | r | 7.81% | ||||
Discount factor | DF = (1 + r)^(-n) | 1.0000 | 0.9276 | 0.8604 | 0.7981 | 0.7402 |
PV of cash flows | E = D x DF | -3,000,000.00 | -463,782.22 | 3,097,352.83 | 4,708,518.48 | 2,960,985.96 |
NPV | Sum of all E | 7,303,075.06 |
Since the project has positive NPV, it is a feasible project and should be accepted.