Chapter 10 problem 1 Financial Analysis with Microsoft Excel (7th Edition) The textbook solutions were giving step by step instructions up to chapter 8. I do not seem to find the step by step instructions for the chapters after chapter 8. I needed a step by step instruction for chapter 10 problem 1. Also, please send me a link if there is another edition of the textbook solutions manual which includes the chapters after 8. Thanks in advance!

The Dempere Imports EPS in 2014 was $1.85 and in 2009 was $1.12. The company payout ratio is 40% and the stock is currently valued at $62.35. Floatation costs for new equity will be 12%. Net income is expected to be $15 milion. The company's investement banker estimates that it could sell a 10 yr semiannual bonds with a coupon rate of 7%. The face value would be $1000 and the floatation costs for a bond issue would be 3%. The market-value weights of the firm's debt and equity are 30% and 70% respectvely. The firm faces 35% tax rate.

A) Based on the 5 year track record what's the Dempere's EPS growth rate?What the divident in 2015 will be?

B) Calculate the firm's cost of retained earnings and the cost of new equity.

C) Calculate the break-point associated with retained earnings

D) what's the firm's after-tax cost of new debt

E) If DEmpere's after-tax cost of debt is 6% what is teh WACC with retained earnings? With new common equity?

F)Create a scatter chart that shows the firm marginal WACC as a step function. The X-axis should go to at least $20 million. Be sure to fully label the chart, including a data label with leader lines that shows the value of break-point.