There are two sections of this Part. First section (Part A) is to calculate Beta () (Extract) (systematic risk) of a selected ASX listed company using 10 years' quarterly data. The second section is to provide a case analysis by locating and researching the selected company's financial risk management and corporate governance. Section 1: Calculating the beta of a security [must be submitted in Excel spreadsheet on Moodle] Calculate Beta () of an ASX company using 10 years' quarterly returns of the selected share, the market index (AOI - all ordinary index) and 10-year bonds. You are required to use Excel program to complete this project. You must use formulae in Excel and must show the formulae in a separate spreadsheet that has been used in completing this part. Students in group will be provided an allocation of ASX listed company for this section. Instructions You need to answer and calculate the following for this part of the assignment:

1. 2. 3. Calculate the data of quarterly returns of the selected company share over past 10 years

(i.e., 2013 to 2023). Calculate the data of quarterly market returns (all ordinary Index) of the selected company over past 10 years (i.e., 2013 to 2023). Calculate the data of quarterly 10-year government bond returns (yield) of over past 10 years (i.e., 2013 to 2023).

1. Identify the Ex-dividend dates for selected company over last 10 years (i.e., 2013 to 2023)

and the respective dividend paid per share. Then calculate Beta for the selected company. Calculate the beta use the following formula: ( , ), = ( ) Format for calculating beta you will need the following 16 columns in the Excel spreadsheet:

1. Time (t)
2. Share price quarterly
3. All Ordinary Index (points)
4. 10-year Bond yield
5. Ex-dividend date
6. Dividend Paid per share
7. Stock return (ri,t)
8. Index return(rm,t)
9. Monthly bond return (rf.t)
10. Excess stock return (Y)
11. Excess Index return (X)
12. Variation in Excess stock Return (Y- Mean of Y)
13. Variation in Excess Index Return (X- Mean of X)
14. Product of (Y- Mean of Y)(X- Mean of X)
15. Covariance is the sum of [Product of (Y- Mean of Y)(X- Mean of X)]
16. Variance of Excess Index Return [variance (Index return(rm,t)