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”,
type in the name of your company allocated to your group.
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”
7. Select “Apply” 8. Select “Download Data”
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:
• File/Options/Add-Ins/Analysis Toolpak/Go/OK
• 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.
project management assignment help, business management assignment help, business management assignment, management assignment help services, strategic management assignment help, management accounting assignment, management homework help, marketing management assignment help, human resource assignment help, human resource management assignment help, managerial accounting assignment help, management accounting assignment help, financial management assignment help, it management assignment help, project management homework help, hospitality management assignment help, hr management assignment help, operations management homework help, brand management assignment help, database management homework help
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