Sample

CALCULATE BETA Assignment Help

CALCULATE BETA Assignment Help

Rating:

EXAMPLE OF HOW TO CALCULATE BETA (and others) USING EXCEL

1. Go to https://au.finance.yahoo.com

2. On the right-hand side, under “Quote Lookup”,

3. Make sure that you choose a company that is listed in the Australian Security Exchange.   This is usually shown as XYZ.AX if the company is XYZ.

4. Select Historical Data

5. Type in the time period.  e.g. Start Date: 8/9/2018, End Date: 8/9/2019.

The date convention (Australia or US) will depend on the computer you are using.

6. Under frequency, choose “weekly”

9. Open with “Microsoft Excel”

10. Save as - File Name: XYZ, and type : Excel Workbook

11. Repeat Step 2 to Step 9 for ^AORD.  This index represents the price of the market portfolio.

12. Save as - File Name: AORD, and type: Excel Workbook

13. For both files (10 and 12)

keep only the Date and the Adj Close columns.  Delete other columns.  14.

Copy the Adj Close data in AORD to the XYZ file.  Refer to the attached Excel example.  15. Label Y-Axis Security Return, and X-Axis Market Retu

TO INSTALL DATA ANALYSIS IN YOUR COMPUTER

1. Go to:

• Tick “Analysis Toolpak”  2. Click Data, and you should see “Data Analysis” on the top right-hand side of the screen.

TO CARRY OUT REGRESSION ANALYSIS

1. Select “Data Analysis”, then “Regression”.

2. Input Y range-type in the cell references for all the data under Y-Axis.   e.g. \$D\$5:\$D\$52  3. Input X range-type in the cell references for all the data under X-Axis.  e.g. \$E\$5:\$E\$52  (For multiple regression, select the data under all the four ratios)

4. Choose Output Range.  e.g. \$G\$4

5. Press OK, and the Regression Summary Output will show up from column G to O.  6. For TFIN 501 students, carry out multiple regression and correlation as well.

7. Repeat the work from 2005 to 2019.

8. Record Beta, R-square and p-value.  See green highlight in the Excel example.  rn.  16. Calculate Security Return and Market Return on a weekly basis.

BROWSE

Our Top Experts

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders

JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders

Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders