This Assignment consists of 4 parts. Attempt all parts. Consider the following scenario: In January 2022, you joined Tri-Star Management Pty Ltd as an intern. On your first day, your CEO asks you to analyze information about the share prices of five companies: Australia and New Zealand Banking Group Limited (ANZ.AX), Coles Group Limited (COL.AX), National Australia Bank Limited (NAB.AX), Qantas Airways Limited (QAN.AX) and Woolworths Group Limited (WOW.AX). The file FIN503 A2.xlsx contains data on these five companies' adjusted beginning-of-month share prices from January 2019 - to December 2021. In addition, you are provided with the value of the S\&P/ASX200 market index over this period. The primary data are provided in columns AG. unt=(Pt1PtPt1)10012 Wariance Standard Deuiation Covariance Beta pected return [annual] Required return Excel formulas Risk free rate [annual] 1.1 This Assignment consists of 4 parts. Attempt all parts. Consider the following scenario: In January 2022, you joined Tri-Star Management Pty Ltd as an intern. On your first day, your CEO asks you to analyze information about the share prices of five companies: Australia and New Zealand Banking Group Limited (ANZ.AX), Coles Group Limited (COL.AX), National Australia Bank Limited (NAB.AX), Qantas Airways Limited (QAN.AX) and Woolworths Group Limited (WOW.AX). The file FIN503 A2.xlsx contains data on these five companies' adjusted beginning-of-month share prices from January 2019 - to December 2021. In addition, you are provided with the value of the S\&P/ASX200 market index over this period. The primary data are provided in columns AG. unt=(Pt1PtPt1)10012 Wariance Standard Deuiation Covariance Beta pected return [annual] Required return Excel formulas Risk free rate [annual]