Question: please answer with correct excel formulas thank you!!! Johnny Cake Lid has 8 million shares of stock outstanding selling at $22 per share and an

please answer with correct excel formulas thank you!!!

Johnny Cake Lid 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.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Answers must be posted with formulas so please provide the formulas, thank you!! Johnny Cake Ltd. has 8 million shares of stock outstanding selling at $22 per share and an issue of $40 million in 10...

please add formulas in the answers!!! thank you :) 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...

Need help entering in excel! thank you! 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...

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...

O 10 points eBook weighted-average tax rate is 21 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...

Johnny Cake Limited has 8 million shares of stock outstanding selling at \$ \\$ 17 \$ per share and an issue of \$ \\$ 40 \$ million in 10 percent coupon bonds with a maturity of 18 years,...

1. Calculate the WACC. WACC (Weighted-Average Cost of Capital) Excel X HOME INSERT Sign In PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 A A Conditional Format as Cell Alignment Number Cells...

must be in FORMULA form!! the first one is correct but answers that i have gotten for the others are all wrong - Les Clipboard Fant Formatting Table Styles Styles D21 X =D14/D8+D15 A B C E F G 5 5 6...

*******All answers must be entered in by a formula. Please display the complete formulas (including cell ranges). Thanks! Johnny Cake Ltd. has 8 million shares of stock outstanding selling at $22 per...

POST THE FORMULAS FOR EACH CELL PLEASE!!!!! 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...

A furniture manufacturing company working on a 40 hour per week basis makes 100 chairs. The sales price is 70 each, and the company has the following costs: Direct materials 700 Direct labor 300 ...

D = { 1, 2, 4, 5, 8) E = {-2, 2, 3, 4, 6) Find the union of D and E. Find the intersection of D and E. Write your answers using set notation (in roster DUE= DnE=

Summary and paraphrase the key points of the post below Hello Class, Throughout this course, I have grown in my understanding of yield curve dynamics. This is another important financial tool that...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

1. Tell the trainees the objective of the task and ask them to watch you demonstrate it.

1. A policy statement that describes the purpose of OJT and emphasizes the companys support for it.

2. A clear specification of who is accountable for conducting OJT. If managers conduct OJT, this is mentioned in their job descriptions and is part of their performance evaluations.