NEED HELP WITH QUESTION 6 Please calculate using Excel and attatch the sheet

Google has one bond outstanding that matures in 20 years. This bond has a coupon rate of 8%, paid semiannually. The bond currently sells for $1,124. What is the pre-tax cost of debt of Google?

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%.