Question

# Given the following information for Watson Power Co., find the WACC. Assume the company’s tax rate...

Given the following information for Watson Power Co., find the WACC. Assume the company’s tax rate is 21 percent. Debt: 50,000 bonds with a 4.8 percent coupon outstanding, \$1,000 par value, 15 years to maturity, selling for 105 percent of par; the bonds make semiannual payments.

Common stock: 825,000 shares outstanding, selling for \$72 per share; the beta is .99.

Preferred 65,000 shares of 3.8 percent preferred stock outstanding, currently stock: selling for \$60 per share. Assume par value is \$95.

Market: 8 percent market risk premium and 3.2 percent risk-free rate.

Can you please do this in Excel. Thank You :)

WACC (Weighted Average Cost of Capital)=( Total Equity/ value of the firm)* cost of Equity +(Total Debt/ Value)* cost of debt* (1- tax)+ Total Pref. share/ Value of Firm

OR = E/V*Re + D/V*Rd* (1-Tc) + P/V*RP

Value of firm= E+D+P

Given in the question

Tax rate= 21%

Debts= 50000 bonds* \$1000= \$50,000,000.00 (with maturity of 15 years)

Market Value of Debt= 50000 bonds* \$1050 (105% of Par)= \$52,500,000.00

Rd= 4.80%

Comman Stock= 825000* \$72 = \$59,400,000.00

Beta= 0.99

Pref. stock= 65000* \$60= \$3900000.00 (par value \$95)

RP (rate of pref. sh)=3.80%

risk premium (Rp)= (Market rate (Rm)- risk free rate (Rf)) =8%,

Rf= 3.2%

Calculation: Re (By CAPM Model) = Rf + Risk Premium*beta= 3.2% + 8*99= 3.20% + 7.92%= 11.12%

Hence Re= 11.12% (By CAPM Model)

Value of firm= E+D+P=

 \$115,800,000.00

WACC= 7.5512% (Refer Excel calculation below as per formula mentioned= E/V*Re + D/V*Rd* (1-Tc) + P/V*RP)

 CAPM Model Paticulars rate Rp 8% Rf 3.20% Beta 0.99 Re 11.12% WACC Re 11.12% Market Value of Equity \$59,400,000.00 Rd 4.80% Market Value of Debt \$52,500,000.00 E/V 0.512953 Market Value of Pref. share \$3,900,000.00 D/V 0.453368 Value of the Firm \$115,800,000.00 P/V 0.033679 Tax 21% 1-tax 79% RP (rate of pref. sh) 3.80% WACC 7.5512%

#### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### Given the following information for Watson Power Co., find the WACC. Assume the company’s tax rate...

Given the following information for Watson Power Co., find the WACC. Assume the company’s tax rate is 21 percent. Debt: 20,000 bonds with a 6.8 percent coupon outstanding, \$1,000 par value, 20 years to maturity, selling for 95 percent of par; the bonds make semiannual payments. Common stock: 625,000 shares outstanding, selling for \$54 per share; the beta is 1.20. Preferred 45,000 shares of 2.8 percent preferred stock outstanding, currently stock: selling for \$60 per share. Assume par value is...

• ### You are given the following information for Watson Power Co. Assume the company's tax rate is...

You are given the following information for Watson Power Co. Assume the company's tax rate is 40 percent. Debt: 5,000 6.6 percent coupon bonds outstanding, \$1,000 par value, 20 years to maturity, selling for 109 percent of par; the bonds make semiannual payments. 380,000 shares outstanding, selling for \$56 per share; the beta is 1.12. 16,000 shares of 3 percent preferred stock outstanding, currently selling for \$76 per Common stock: Preferred stock: share. Market: 5 percent market risk premium and...

• ### You are given the following information for Magrath Power Co. Assume the company’s tax rate is...

You are given the following information for Magrath Power Co. Assume the company’s tax rate is 35%. Debt: 10,000 6.4% coupon bonds outstanding, \$1,000 par value, 25 years to maturity, selling for 108% of par; the bonds make semiannual payments. Common stock: 495,000 shares outstanding, selling for \$63 per share; the beta is 1.15. Preferred stock: 35,000 shares of 3.5% preferred stock outstanding, currently selling for \$72 per share. Market: 7% market risk premium and 3.2% risk-free rate. What is...

• ### You are given the following information for Magrath Power Co. Assume the company’s tax rate is...

You are given the following information for Magrath Power Co. Assume the company’s tax rate is 35%. Debt: 10,000 6.4% coupon bonds outstanding, \$1,000 par value, 25 years to maturity, selling for 108% of par; the bonds make semiannual payments. Common stock: 495,000 shares outstanding, selling for \$63 per share; the beta is 1.15. Preferred stock: 35,000 shares of 3.5% preferred stock outstanding, currently selling for \$72 per share. Market: 7% market risk premium and 3.2% risk-free rate. What is...

• ### You are given the following information for Watson Power Co. Assume the company's tax rate is...

You are given the following information for Watson Power Co. Assume the company's tax rate is 22 percent. Debt: 7,000 5.6 percent coupon bonds outstanding. \$1,000 par value, 22 years to maturity, selling for 104 percent of par; the bonds make semiannual payments. Common stock: 400,000 shares outstanding, selling for \$58 per share; the beta is 1.09. Preferred stock: 17,000 shares of 3.4 percent preferred stock outstanding, currently selling for \$79 per share. The par value is \$100 per share....

• ### You are given the following information for Lightning Power Co. Assume the company’s tax rate is...

You are given the following information for Lightning Power Co. Assume the company’s tax rate is 23 percent. Debt: 13,000 6.2 percent coupon bonds outstanding, \$1,000 par value, 28 years to maturity, selling for 108 percent of par; the bonds make semiannual payments. Common stock: 460,000 shares outstanding, selling for \$64 per share; beta is 1.13. Preferred stock: 20,000 shares of 4 percent preferred stock outstanding, currently selling for \$85 per share. The par value is \$100 per share. Market:...

• ### Consider the following information for Watson Power Co.: Debt: Common stock: 5,500 6 percent coupon bonds...

Consider the following information for Watson Power Co.: Debt: Common stock: 5,500 6 percent coupon bonds outstanding, \$1,000 par value, 19 years to maturity, selling for 104 percent of par; the bonds make semiannual payments. 132,000 shares outstanding, selling for \$55 per share; the beta is 1.19. 18,000 shares of 5 percent preferred stock outstanding, currently selling for \$105 per share. 7 percent market risk premium and 4.5 percent risk-free rate. Preferred stock: Market: Assume the company's tax rate is...

• ### You are given the following information for Watson Power Co. Assume the company’s tax rate is 24 percent. Debt: 19,000 6.8 percent coupon bonds outstanding, \$1,000 par value, 24 years to maturity, selling for 111 percent of par; the bonds make semi

You are given the following information for Watson Power Co. Assume the company’s tax rate is 24 percent.   Debt:19,000 6.8 percent coupon bonds outstanding, \$1,000 par value, 24 years to maturity, selling for 111 percent of par; the bonds make semiannual payments.  Common stock:520,000 shares outstanding, selling for \$70 per share; the beta is 1.21.  Preferred stock:23,000 shares of 4.6 percent preferred stock outstanding, currently selling for \$91 per share. The par value is \$100 per share.  Market:6 percent market risk premium and 5.5...

• ### Consider the following information for Watson Power Co.: Debt: Common stock: 4,000 6 percent coupon bonds...

Consider the following information for Watson Power Co.: Debt: Common stock: 4,000 6 percent coupon bonds outstanding, \$1,000 par value, 18 years to maturity, selling for 105 percent of par; the bonds make semiannual payments. 96,000 shares outstanding, selling for \$56 per share; the beta is 1.13. 13,000 shares of 5.5 percent preferred stock outstanding, currently selling for \$107 per share. 7.5 percent market risk premium and 5 percent risk-free rate. Preferred stock: Market: Assume the company's tax rate is...

• ### You are given the following information for Lightning Power Co. Assume the company's tax rate is...

You are given the following information for Lightning Power Co. Assume the company's tax rate is 24 percent. Debt 24.000 73 percent coupon bonds outstanding. \$1,000 par value, 18 years to maturity, selling for 107 percent of par, the bonds make semiannual payments. Common stock: 570,000 shares outstanding, selling for \$75 per share; beta is 1.19. Preferred stock 25,500 shares of 5.1 percent preferred stock outstanding, currently selling for \$96 per share. The par value is \$100 per share. Market:...