In: Finance
Project |
Level of Risk |
IRR |
A |
Low |
9.50% |
B |
Average |
8.50% |
C |
Average |
7.50% |
D |
Low |
9.50% |
E |
High |
14.50% |
F |
High |
17.50% |
G |
Average |
11.50% |
a. Market Value of Preferred Stock =Price of Preferred
Stock*Number of preferred stocks =67*5000000=335,000,000
Market Value of Equity =Price of Equity*Number of stocks
=32*8000000=256,000,000
Market Value of Debt =Number of units*Par Value*91%
=100000*1000*91% =91,000,000
Total Value =335,000,000+256,000,000+91,000,000 =682,000,000
b. Cost of Preferred Stock =Dividend/Price of Preferred Stock =6/67
=8.9552%
Cost of Equity =Risk free Rate+Beta*(Market Return-Risk Free Rate)
=5%+1.15*10% =16.50%
Price of Bond=91%*1000 =910
Par Value =1000
Coupon =9%*1000/2 =45
Number of Periods=15*2=30
Cost of Debt using rate function of excel =2*RATE(30,45,-910,1000)
=10.1832%
Discount rate =Weight of Preferred Stock*Cost of Preferred
Stock+Weight of Equity*Cost of Equity+Weight of Debt*Cost of Debt
=335,000,000/682,000,000*8.9552%+256,000,000/682,000,000*16.50%+91,000,000/682,000,000*10.1832%*(1-35%)
=11.95%
2, Option c. ADEFG is correct option because in these cases IRR is
greater than cost of capital. IF IRR is greater than cost of
capital it should be accepted.