Provide what formula to use in excel and how to use it. Using the prices provided, calculate the monthly returns for MSFT and SPY, where rt = (Pt/Pt-1) 1; which is the same as [(Pt-Pt-1)/ Pt-1]. For example, R1 = (P1/P0) - 1 Note that the monthly data is listed from June 2013 to June 2023So be careful with your return formula! There are 121 monthly prices given so you can calculate 120 monthly returns. You must post monthly returns as decimals to 6 places or as percentages to 4 places. For example, average return for MSFT may be written as either: .009999 or .9999%.

Excel data -

MSFT SPY Return Adj Price Adj Price Obser. 28.721907 132.358185 0 26.476721 139.93454 1 27.773941 135.737564 2 27.869164 139.353989 3