ONLY NEED HELP WITH QUESTION 6 PLEASE USE EXCEL AND ATTACH EXCEL SHEET. THANK YOU

DIVIDENDS

2008 =20%

2009 = 22.22%

2010 =13.64%

2011 = 8%

2012 = 11.11%

Average Dividend Growth Rate =15%

Cost of Equity = 18.33%

Cost of Equity = 9.20%

Average Cost of Equity of Google =13.70%

Cost of Preferred Stock = 6/100*100 = 6%

PV = $1,124

FV = $1,000

Coupon rate = 8%

Payment = Semiannual

PMT = 1000*8%*1/2 = $40

Using RATE function,

=RATE((40,40,-1124,1000)

Cost of debt (semiannual) = 3.43%

Pre-tax cost of debt = 3.43%* 2= 6.85%

6- Google currently has a 5 million common shares outstanding, and a 1 million preferred shares outstanding, and 100,000 bonds outstanding. Use your answers in #3, #4, and #5 to calculate Google Weighted Average Cost of Capital (WACC) if the corporate tax rate is 35%.