to be done on excel

- - I bought Tezos Crypto on June 2, 2021 for $3.85 per coin and paid $0.06 in transaction fees. On July 15th, I received $0.0009 reward per each Tezos. By August 14th, I received $0.0075 more per coin. By Sep. 16th extra $0.0185. By Oct. 15 - $0.0193. If prices on those 4 dates were correspondingly $2.57, $3.70, $6.94 & $6.84, what is my Realized Return over the period? Calculate Dividend Yield, Capital Gain Yield and Total Realized Return. Compare to Microsoft example. I PROBLEM Suppose you purchased Microsoft stock (MSFT) on Nov 1, 2004, and held it for one year, selling on Oct 31, 2005. What was your annual realized return? Date Price Dividend Nov 01 04 28.08 Nov 15 04 27.39 3.08 Feb 15 05 25.93 0.08 May 16 05 25.49 0.08 Aug 15 05 27.13 0.08 Oct 31 05 25.70 - - I bought Tezos Crypto on June 2, 2021 for $3.85 per coin and paid $0.06 in transaction fees. On July 15th, I received $0.0009 reward per each Tezos. By August 14th, I received $0.0075 more per coin. By Sep. 16th extra $0.0185. By Oct. 15 - $0.0193. If prices on those 4 dates were correspondingly $2.57, $3.70, $6.94 & $6.84, what is my Realized Return over the period? Calculate Dividend Yield, Capital Gain Yield and Total Realized Return. Compare to Microsoft example. I PROBLEM Suppose you purchased Microsoft stock (MSFT) on Nov 1, 2004, and held it for one year, selling on Oct 31, 2005. What was your annual realized return? Date Price Dividend Nov 01 04 28.08 Nov 15 04 27.39 3.08 Feb 15 05 25.93 0.08 May 16 05 25.49 0.08 Aug 15 05 27.13 0.08 Oct 31 05 25.70