Place your answer in the corresponding green answer cell for each question. The answer cell must contain a formula that references one or more cells in the work box or -- no hard-coded numbers in the answer cell or the cell it references. 4. An investor bought a stock for $29.15 one year ago. Last month, the stock paid a dividend of $1.04 a share. Today the investor sold the shares for $28.80 a share. What was the capital gains yield on this investment