Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The spreadsheet below contains the monthly stock returns for several different stocks, the S&P 500 , and Treasuries between 2015 and 2019 . Using these

image text in transcribed

The spreadsheet below contains the monthly stock returns for several different stocks, the S\&P 500 , and Treasuries between 2015 and 2019 . Using these data and Excel estimate the beta for Alphabet Inc over this time period. Round your answer to two decimals. You can download the spreadsheet here: QUESTION 3 The beta for Netflix's stock is 0.8, the current risk-free rate (rf) is 1.9%, the expected return on the market porftolio (E(rm)) is 6%. If the expected return on the market portfolio decreases by 0.43%, by how much will the expected return on Netflix's stock change? Express your result in percent and round to two decimals (do not include the \%-symbol in your answer). Enter increases as positive numbers, decreases as negative numbers. The spreadsheet below contains the monthly stock returns for several different stocks, the S\&P 500 , and Treasuries between 2015 and 2019 . Using these data and Excel estimate the beta for Alphabet Inc over this time period. Round your answer to two decimals. You can download the spreadsheet here: QUESTION 3 The beta for Netflix's stock is 0.8, the current risk-free rate (rf) is 1.9%, the expected return on the market porftolio (E(rm)) is 6%. If the expected return on the market portfolio decreases by 0.43%, by how much will the expected return on Netflix's stock change? Express your result in percent and round to two decimals (do not include the \%-symbol in your answer). Enter increases as positive numbers, decreases as negative numbers

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_2

Step: 3

blur-text-image_3

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

Risk Management And Financial Institution

Authors: John C. Hull

2nd Edition

0136102956, 9780136102953

More Books

Students also viewed these Finance questions