please do it in 10 minutes will upvote

B6AF104 QUESTION 4: INDEX NUMBERS (Total 25 marks) I. A financial manager maintains a portfolio of shares and a property portfolio. The table shows the values of the two portfolios (in millions of euro) at the end of each year. Year Shares 2015 2016 2017 2018 2019 2020 2021 35.14 37.38 39.45 43.26 46.08 50.33 51.55 329.43 325.64 348.54 360.69 387.41 436.55489.92 Property a. Calculate a simple index for the Shares portfolio. Use 2015 as the base year and use 100 as the base value. (3 marks) b. Calculate a simple index for the Property portfolio. Use 2015 as the base year and use 100 as the base value. (3 marks) c. Create a line chart showing the two index series. Label the chart appropriately. (3 marks) d. List two advantages to using a simple index instead of the underlying data (in millions of euro). (2 marks) e. Using the simple index, calculate the percentage change from 2015 to 2021 for each portfolio. (2 marks)