1.ai) Please compute the Aggregate Return and Aggregate Dispersion for Table 1 using Formula. (with accuracy up to 3 decimal places in %) [4 marks] Table 1. 2017 2018 2019 2020 2021 8% 6% 7% 5% 4% 2% 7% 5% 4% 2% 8% 6% 99 3 5% 3% End of Year Returns Client A Client B Client Client D End of Period Assets (S millions) Client A Client B Client C Client D TOTAL Number of Portfolios Aggregate Return Aggregate Dispersion 40 80 160 180 460 42.800 84.000 166.400 183.600 476.800 46.224 89.040 174.720 189.108 499.092 49.460 93.492 181.709 192.890 517.551 53.416 99.102 198.063 198.677 549.257 4 4 4 4 4 R2018 R2019 R2020 R2021 2018 2019 OXO 21 Show your working. Provide answers alone will not get you full marks. Answer: 1.ai) End of Year 2017 2018 2019 2020 2021 Aggregate Return NA Aggregate Dispersion NA 1.ail) State what kind of weighting methods that you use to calculate the Aggregate Return and Aggregate Dispersion above. [2 marks] 1.ai) Please compute the Aggregate Return and Aggregate Dispersion for Table 1 using Formula. (with accuracy up to 3 decimal places in %) [4 marks] Table 1. 2017 2018 2019 2020 2021 8% 6% 7% 5% 4% 2% 7% 5% 4% 2% 8% 6% 99 3 5% 3% End of Year Returns Client A Client B Client Client D End of Period Assets (S millions) Client A Client B Client C Client D TOTAL Number of Portfolios Aggregate Return Aggregate Dispersion 40 80 160 180 460 42.800 84.000 166.400 183.600 476.800 46.224 89.040 174.720 189.108 499.092 49.460 93.492 181.709 192.890 517.551 53.416 99.102 198.063 198.677 549.257 4 4 4 4 4 R2018 R2019 R2020 R2021 2018 2019 OXO 21 Show your working. Provide answers alone will not get you full marks. Answer: 1.ai) End of Year 2017 2018 2019 2020 2021 Aggregate Return NA Aggregate Dispersion NA 1.ail) State what kind of weighting methods that you use to calculate the Aggregate Return and Aggregate Dispersion above. [2 marks]