Excel FormulaChen Chocolate Company's stock is currently valued at $40, is dividend payment is $1.2 per share for the current year and will grow by 10% each year. The Flotation costs for new equity wil be The company's investment Banker states that it could sell 10 year semanual bonds with a coupon rate of 5%. The face value and be price would be $1.000 and the flotation costs for a bond issue would be 1. The market value weights of the firm's debt and equity are 30% and 70%, respectively. The form faces a 35% tax rate Type in the Excel formulas you should enter in the cell with bold borders in the table on the next page to solve the following problem 2. Calculate the homs cost of retained eamings. (2 Pointe b. Calculate the cost of new equity (2 Points Calcube ther's after-tax cost of new debt a Points! d. Calculate the firm's WACC it uses retained earrings and debt and wants to maintain the current capital structure. (2 Points) e. Calculato the few's waitinues new common equity and debt and wants to maintain the current capital structure. (2 Points 1 2 3 Growth Rate Stock Price Flotation Costs (Equity) Dividende B Chen Chocolate Company 10% $40 596 S1.2 4 5 0 2 Bond Face Value $1,000 51.000 8 10 2 198 35% Bond Price 9 Bond Coupon Rate 10 Bond Term to Maturity 11 Bond Payment Frequency 12. Flotation Costa Bonds) 13 Tax Rate 14 15. Capital Structure 16 Debi 17 Equity 18 19 a Contor Retained Faris 20 b. Cost of New Equity 21. Aflorax Cost of Debt 22 21 WACC 24 d. With Retained Earnings 25 e With New quity 3096 7096