Please show the formulas needed for excel calculations.

Problem 1 1. Compute the return per period 2. Compute the Total Return over the entire time 3. Compute the Annualized Return (Compound Annual Return) 4. Graph the closing prices 5. Graph the returns Return DATE 2015 2016 2017 2018 2019 2020 Total Return Compound Annual Return XYZ Corp CLOSE 37.5 39.72 44.64 47.8 54.04 54.81