(Excel Formulas) Chen Chocolate Company's stock is currently valued at $40. Its dividend payment is 51.2 per share for the current year, and will grow by 10% each year. The Flotation costs for new equity will be 5% The company's investment banker estimates that it could sell 10-year semiannual bonds with a coupon rate of 5%. The face value and issue 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 firm faces a 21% tax rate B Chen Chocolate Company 10% S40 5% $1.2 A 1 2 Growth Rate 3 Stock Price Flotation Costs (Equity) 5 Dividende 6 7 Bond Face Value 8 Bond Price 9 Bond Coupon Rate 10 Bond Term to Maturity 11 Bond Payment Frequency 12 Flotation Costs (Bonds) 13 Tax Rate 14 15 Capital Structure 16 Debt 17 Equity $1.000 $1,000 5% 10 2 21% 30% 70% 16 Debt 309 17 Equity 70 18 19 Cost of Retained Earnings 13 309 20 b. Cost of New Equity 21 c. After-tax Cost of Debt 22 23 WACC d. With Retained Emin 25 e. With New Equity Type in the Excel formulas you should enter to the cells with bold borders in the table to the following problems. a Calculate the firm's cost of new equity 12 points) b: Calculate the firm's after tax cost of new debit. 12 Points c. Calculate the fem WACC titres retained earnings and debt and wants to maintain the current structure 12 points) ContView stomatol 1200 Paren