Please show work in excel formulas, thank you! A1 2 4 5 6 7 fx Accessibility tab

Please show work in excel formulas, thank you!
 
 
 

Transcribed Image Text:

A1 2 4 5 6 7 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. A B C D E F G H I J K Given the following information for Lightning Power Co., find the WACC. Assume the company's tax rate is 21 percent. Debt: 12,000 bonds with a 4.6 percent coupon outstanding, $1,000 par value, 25 years to maturity, selling for 105 percent of par; the bonds make semiannual payments. Common stock: 575,000 shares outstanding, selling for $81 per share; the beta is 1.04. Preferred stock: 30,000 shares of 3.4 percent preferred stock outstanding, a $100 par value, currently selling for $94 per share. Market: 7 percent market risk premium and 3.2 percent risk-free rate. Input Area: Tax rate Debt Bonds outstanding 8 9 Settlement date 10 Maturity date 11 Annual coupon rate 12 Coupons per year 13 14 Bond price (% of par) Redemption (% of par) 21% 12,000 1/1/2020 1/1/2045 4.60% 2 105 100 A1 2 4 5 6 7 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. A B C D E F G H I J K Given the following information for Lightning Power Co., find the WACC. Assume the company's tax rate is 21 percent. Debt: 12,000 bonds with a 4.6 percent coupon outstanding, $1,000 par value, 25 years to maturity, selling for 105 percent of par; the bonds make semiannual payments. Common stock: 575,000 shares outstanding, selling for $81 per share; the beta is 1.04. Preferred stock: 30,000 shares of 3.4 percent preferred stock outstanding, a $100 par value, currently selling for $94 per share. Market: 7 percent market risk premium and 3.2 percent risk-free rate. Input Area: Tax rate Debt Bonds outstanding 8 9 Settlement date 10 Maturity date 11 Annual coupon rate 12 Coupons per year 13 14 Bond price (% of par) Redemption (% of par) 21% 12,000 1/1/2020 1/1/2045 4.60% 2 105 100

Answer rating: 100% (QA)

SOLUTION IN DETAILS To calculate the weighted average cost of capital WACC for Lightning Power Co we ... View the full answer