Using the share price returns calculatedfor three company in conjunction with the targeted return predicted by the CAPM, determine the abnormal returns (extra or excess returns) earned over the seven years of the shares. Investigate the results or findings. The findings may justify from a technical analysis perspective, in line with the facts and figures from various researches, articles, and resources on selected shares.

• Selection of appropriate risk-free rates over the latest seven years (justify their risk-free rate choices (either 3-month, 6-month, 9-month, or 1-year) that used for estimation.)
• Selection of appropriate equity risk premium over the latest seven years (calculate the appropriate "equity risk premium" from the formula: (R_m-R_f))
• Selection of appropriate equity betas over the LATEST seven years
• Calculation of required returns (Use the CAPM [E(Ri) = Rf + i(E(RM) - Rf)])
• Calculation of an abnormal return for overall seven years period (analyze both the size and sign of the abnormal returns or alpha (Actual (TSR) return - CAPM derived return)

Investigate the findings. Justify findings based on technical analysis perspective in line with the researches from various articles and resources (evaluate these abnormal returns' theoretical and practical implications to investors. Judge whether the optimal portfolio's abnormal returns can match the buy signal from various technical charts in technical analysis.)

The company data and any supporting data are in the link below (suggest to download the excel file):

Company Data

https://drive.google.com/file/d/1DySiTPjEzWxRXbcdqnGy0UomPad9Iyzq/view?usp=sharing

https://drive.google.com/file/d/1tzKWyH1iIMWcccPNbGiQHH7OaU8QO15c/view?usp=sharing

https://drive.google.com/file/d/1yyCjhsiGRE9yc949dciebKEoSXLFeLxd/view?usp=sharing

Supporting Data / Calculation

https://drive.google.com/file/d/1V9oeh676kPCVOQ9TgIjUpuNxj6fGiLTt/view?usp=sharing

https://drive.google.com/file/d/1uacWWcr1pT166F39I8QlOstzM5tig3z4/view?usp=sharing

Please help me to solve above the question and send the link file (excel file) to make it easier. Thank you.

All working, formula and explanation can be noted in the excel file.