Part 2: Fund performance evaluation Activity: Assume today is 1 January 2021. You plan to evaluate the Australian foundation investment company's (ASX: AFI) performance in the past twelve months. The dividends and pricing information on AFI, the index levels of ASX200 (used as the benchmark of AFI), and the risk-free interest rates are presented in the worksheet titled "AFI". In this performance evaluation exercise, you will apply the CAPM model using ASX200 as the market portfolio. Show your workings on calculating AFI's performance metrics using annualized data: Sharpe Ratio, M?, Treynor Ratio, Tracking Error, and Information Ratio; and summarize your results in a table. B F F B D E Date AFI Dividend AFI Closing price ASX 200 Index Risk-free rate 2 2020/1/1 5.86 7017.20 0.00017 B 2020/2/1 6.36 6441.20 0.00017 - 2020/3/1 0.10 5.65 5076.80 0.00017 5 5 2020/4/1 5.54 552240 0.00017 5 2020/5/1 5.02 5755.70 0.00017 2020/6/1 5.16 5897.90 0.00017 B 2020/7/1 5.19 5927.80 0.00017 3 2020/8/1 6.28 6060.50 0.00017 0 2020/9/1 0.14 6.31 5815.90 0.00017 1 2020/10/1 6.51 5927.60 0.00017 2 2020/11/1 7.21 6517.80 0.00017 3 2020/12/1 7.30 6587.10 0.00017 4 2021/1/1 7.50 6824.70 0.00017 5 Part 2: Fund performance evaluation Activity: Assume today is 1 January 2021. You plan to evaluate the Australian foundation investment company's (ASX: AFI) performance in the past twelve months. The dividends and pricing information on AFI, the index levels of ASX200 (used as the benchmark of AFI), and the risk-free interest rates are presented in the worksheet titled "AFI". In this performance evaluation exercise, you will apply the CAPM model using ASX200 as the market portfolio. Show your workings on calculating AFI's performance metrics using annualized data: Sharpe Ratio, M?, Treynor Ratio, Tracking Error, and Information Ratio; and summarize your results in a table. B F F B D E Date AFI Dividend AFI Closing price ASX 200 Index Risk-free rate 2 2020/1/1 5.86 7017.20 0.00017 B 2020/2/1 6.36 6441.20 0.00017 - 2020/3/1 0.10 5.65 5076.80 0.00017 5 5 2020/4/1 5.54 552240 0.00017 5 2020/5/1 5.02 5755.70 0.00017 2020/6/1 5.16 5897.90 0.00017 B 2020/7/1 5.19 5927.80 0.00017 3 2020/8/1 6.28 6060.50 0.00017 0 2020/9/1 0.14 6.31 5815.90 0.00017 1 2020/10/1 6.51 5927.60 0.00017 2 2020/11/1 7.21 6517.80 0.00017 3 2020/12/1 7.30 6587.10 0.00017 4 2021/1/1 7.50 6824.70 0.00017 5