Attached are financial problems I'm having some trouble with. Please assist with the 4 questions in the attachment. Request work be shown in excel to also see how to perform the functions in a spreadsheet.

Calculating Yields & Returns Suppose a stock had an initial price of $64 per share, paid a dividend of $1.20 per share during the year, and had an ending share price of $73. What was the dividend yield? The capital gains yield? Calculating Returns and Variability Using the following returns, calculate the average returns, the variances, and the standard deviations for X and Y: Returns Year X Y 1 9% 12% 2 21 27 3 27 32 4 15 14 5 23 36 Arithmetic and Geometric Returns A stock has had the following year-end prices and dividends: Year Price Dividend 1 $73.18 2 77.98 $ 1.15 3 69.13 1.25 4 84.65 1.36 5 91.37 1.47 6 103.66 1.60 What are the arithmetic and geometric returns for the stock? Finding the WACC Given the following information for Huntington Power Co., find the WACC. Assume the company's tax rate is 35 percent. Debt: 10,000 5.6 percent coupon bonds outstanding, $1,000 par value, 25 years to maturity, selling for 97 percent of par; the bonds make semiannual payments. Common 425,000 shares outstanding, selling for $61 per share; the beta is .95. stock: Market: 7 percent market risk premium and 3.8 percent risk-free rate