please show excel work

A C D E F 1 Year 2 2007 B Dividend 0.02 0.03 0.04 3 $ $ $ $ 2008 2009 2010 2011 4 5 6 0.05 0.06 $ 7 8 current stock price 9 Number of stock shares 10 Debt/Equity ratio 11 Interest Paid $10.00 400,000 0.75 240,000 36% 12 tax rate 13 Part A. Estimate the constant annual compounding growth rate based on the dividends 14 2007 through 2011. 15 Compound Growth rate 16 17 Part B. Use the Gordon dividend model to estimate the cost of equity 18 Cost of equity 19 20 Part C. Calculate the WACC 21 Cost of debt 22 WACC 23 24 25 26