I hope you can use the above data as an example to give a detailed calculation process

2. Calculate the monthly realised returns for your stocks and market index. [3 marks] Instructions! a. We learnt in Lecture 4 that realised return at t can be calculated as Rt = Pt-Pt-1 + Div Pe-1 b. As you are using prices adjusted for dividends, you do not need to consider a dividend component in return calculation. c. In the spreadsheet produced above, three additional columns should be created for computing monthly realised returns for your two stocks and the market index. Monthly returns should be available from 01/09/2016 as you don't have price data on 01/07/2016 for the calculation of returns for 01/08/2016. d. In the end, 60 individual monthly returns should be generated for your stocks and for the market index. Date Adj Close Adj Close ASX200 2016/8/1 10. 489191 6. 703776 5433 2016/9/1 10. 199718 6. 429973 5435.899902 2016/10/1 9. 935355 5. 997186 5317.700195 2016/11/1 10. 150778 5. 90003 5440.5 2016/12/1 10. 68503 6.297487 5665.799805 2017/1/1 8. 970255 6. 221442 5620.899902 2017/2/1 8. 02239 6. 787845 5712.200195 2017/3/1 8. 056858 6. 958665 5864.899902 2017/4/1 9. 050593 7. 291314 5924.100098 2017/5/1 9. 076853 7. 641945 5724.600098 2017/6/1 8. 51666 7. 075541 5721.5 2017/7/1 8. 087766 7. 273253 5720.600098 2017/8/1 8. 149036 7.574782 5714.5 2017/9/1 7.877692 7. 529096 5681.600098 2017/10/1 8. 413959 7.638743 5909 2017/11/1 9. 089923 7. 940272 5969.899902 2017/12/1 8. 956509 7. 693566 6065.100098 2018/1/1 8. 805306 7. 512571 6037.700195 2018/2/1 8. 53848 7. 624006 6016 2018/3/1 8. 876458 7. 828304 5759.399902 2018/4/1 8. 914689 8. 422624 5982.700195