One year ago, you brought a stock for $37.25 per share. You received a dividend of $1.27 per share last month and sold the stock today for $39.75 per share. What is the capital gains yield on this...

One year ago, you brought a stock for $37.25 per share. You received a dividend of $1.27 per share last month and sold the stock today for $39.75 per share. What is the capital gains yield on this investment?

Can the calculator and excel solution be provided?