Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The company is Amazon. Number of Daily observations: 365 Number of Monthly observations: 12 Please find r square, intercept, and beta for question 1 and

image text in transcribed

The company is Amazon.

Number of Daily observations: 365

Number of Monthly observations: 12

Please find r square, intercept, and beta for question 1 and all of question 2.

image text in transcribed
1 . Please use the Regression function in Data Analysis Tool Pak in Excel In Find the beta of the stock you are tracking . ( Note : Steps to add in the Data Analysis Toolpak : File Lab > Options = Add-ins = Excel Add. ins " to" = choose* Analysis ToolPak "! ! Please calculate the beta using bath daily and monthly returns and fill in the corresponding information in the tables below . Company Name Almazan Bela based on daily returns Number of Observations R. Square* Coefficients I Star Intercept Dicta Bela based on monthly returns Number of Observations R. Square* 1015 1 Coefficients Intercep "! beta 2. Assume risk - free rate = 1% and market risk premium is 796 , based on the bela number you calculated using monthly returns , what is the expected return of the stock you are lacking

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Financial Management

Authors: William R. Lasher

8th edition

1305637542, 978-1305887237, 1305887239, 978-1305637542

More Books

Students also viewed these Finance questions