5.2.1 HOME * ard A Arial B INSERT D % BIU A Alignment Number *** Font PAGE LAYOUT 12 T WACC (Weighted-Average Cost of Capital) - Excel DATA fx C T FORMULAS M D REVIEW Cell Conditional Format as Formatting Table Styles Styles f Shares outstanding Price per share Face value of outstanding bond issue Coupon rate on bonds VIEW E 8,000,000 22.00 $ $ 40,000,000 F 10% ? G IN M Cells Editing Johnny Cake Ltd. has 8 million shares of stock outstanding selling at $22 per share and an issue of $40 million in 10 percent annual coupon bonds with a maturity of 17 years, selling at 94.0 percent of par. Assume Johnny Cake's weighted-average tax rate is 34 percent, its next dividend is expected to be $3 per share, and all future dividends are expected to grow at 5 percent per year, indefinitely. What is its WACC? (Do not round intermediate calculations and round your final answer to 2 decimal places.) H - E Sign I

i need the excel formulas too not just the answer

Johnny Cake Ltd. has 8 million shares of stock outstanding selling at \$22 per share and an issue of $40 million in 10 percent annual coupon bonds with a maturity of 17 - years, selling at 94.0 percent of par. Assume Johnny Cake's weighted-average tax rate is 34 percent, its next dividend is expected to be $3 per share, and all future dividends are expected to grow at 5 percent per year, indefinitely. What is its WACC? (Do not round intermediate calculations and round your final answer to 2 decimal places.) What is its WACC? (Do not round intermediate calculations and round your fina answer to 2 decimal places.) \&