Hello! I'm having some issue solving this homework problem and was hoping someone could help me solve this problem. Please provide step-by-step instructions for each part & solve within Excel, showing your formulas used

Note: Please do not attempt problem if you do not know how to solve/are unsure if your answer is correct/or if you cannot provide step-by-step instructions, or I will have to give your answer a thumbs down. I don't mean to be rude, I've just had some issues with incorrect answers/incomplete solutions previously, and I would really like to figure out how to solve these types of problems.

Thank you so much in advance if you are able to help me with this problem, I truly appreciate it!

A firm had a realized rate of return (ROR) of 26.05% over the past year. One year ago it was selling for $85.21(Po) and today it is selling for $89.43 (P1). What dividend yield has this stock paid over the past year? Answer as a decimal using 3 decimal places