PLEASE SHOW EXCEL FORMULAS USED TO SOLVE

Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. What was the dividend yield? The capital gains yield? nitial price Dividend paid Ending share prices Complete the following analysis. Do not hard code values in your calculations. Dividend yield Capital gains yield Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. Compute the percentage total return Initial price $ Dividend paid $ Ending share price $ 79 1.45 88 Complete the following analysis. Do not hard code values in your calculations. Total return Suppose you bought a bond with an annual coupon of 7 percent one year ago for $970. The bond sells for $940 today. a. Assuming a $1,000 face value, what was your total dollar return on this investment over the past year? b. What was your total nominal rate of return on this investment over the past year? c. If the inflation rate last year was 3 percent, what was your total real rate of return on this investment? 70 970 Coupon paid Initial price Ending price Inflation rate By Complete the following analysis. Do not hard code values in your calculations. a. Dollar return b. Nominal return c. Real return