Question

Blooming Ltd. currently has the following capital structure: Debt: $2,500,000 par value of outstanding bond that pays annually 12% coupon rate with an annual before-tax yield to maturity of 10%. The bond issue has face value of $1,000 and will mature in 25 years. Ordinary shares: 65,000 outstanding ordinary shares. The firm plans to pay a $7.50 dividend per share in the next financial year. The firm is maintaining 3% annual growth rate in dividend, which is expected to continue indefinitely. Preferred shares: 40 000 outstanding preferred shares with face value of $100, paying fixed dividend rate of 14%. Company tax rate is 30%. Required: Complete the following tasks: 

a) Calculate the current price of the corporate bond?  

b) Calculate the current price of the ordinary share if the average return of the shares in the same industry is 9%?  

c) Calculate the current value of the preferred share if the average return of the shares in the same industry is 12%  

d) Calculate the current market value (rounded off to the nearest whole number) and capital structure of the firm (rounded off to two decimal places). Identify the total weights of equity funding  

e) Compute the weighted average cost of capital (WACC) under the traditional tax system for the firm, using dividend constant growth model for calculation the cost of ordinary equity

Answer 1

a)

a)	face value of debt	1000
	Coupon rate	0.12
	After Tax cost	0.07
	Maturity	25
	current price of bond	=PV(C3,C4,-C1*C2,-C1)
	Dividend	7.5
	Growth rate	0.03
	Average return	0.09
	Current price of share	=C6/(C8-C7)
	Dividend on Pref. shares	14
	Average return	0.12
	Value of Prefred Share	=C10/C11
	Total value of debt	=2500000*C5/1000
	Total value of common stock	=65000*C9
	Total value of Preferred stock	=C12*40000
	Wieght of debt	=C13/(SUM($C$13:$C$15))
	Wieght of common stock	=C14/(SUM($C$13:$C$15))
	Wieght of preferred stock	=C15/(SUM($C$13:$C$15))