Question: Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index:

Year

Apple Stock Price

Alphabet Stock Price

S&P 500 Market Index

2017

$174.09

$1,072.01

2,601.42

2016

$115.82

$807.80

2,238.83

2015

$105.26

$765.84

2,043.94

2014

$113.99

$521.51

2,058.90

2013

$80.01

$559.76

1,848.36

2012

$72.80

$358.17

1,426.19
Market risk premium: RPM = 4.01%
Risk-free rate: rRF = 1.30%
  1. If you formed a portfolio that consisted of 50% Apple stock and 50% Alphabet stock, what would be its beta? (9 Points)
Beta Portfolio Weight
Apple
Alphabet
Portfolio Beta

***Please provide the Excel Functions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index: Year Apple Stock Price Alphabet Stock Price...

Q:

CoursHeroTranscribedText: FINC 3304 - Business Finance Project 4 Risk and Return The goal of this project is to explore the topic of risk and return. The project requires you to work in Excel with...

Q:

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index: Year Apple Stock Price Alphabet Stock Price...

Q:

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index: Year Apple Stock Price Alphabet Stock Price...

Q:

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index: Year Apple Stock Price Alphabet Stock Price...

Q:

Risk and Return Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Year Apple Stock Price Kroger Stock...

Q:

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index: Year Apple Stock Price Alphabet Stock Price...

Q:

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Year Apple Stock Price Kroger Stock Price S&P 500...

Q:

Risk and Return Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Year Apple Stock Price Kroger Stock...

Q:

Risk and Return Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Year Apple Stock Price Kroger Stock...

Q:

Mark, a 15-year-old Hispanic male, lives in a low-income area where it is common for youth to join gangs and become involved in criminal activity. His family is religious and Mark is a youth leader...

Q:

The point (-3, 1) is on the transformed graph of f(x) original point on the graph of y f(x). - [2(x + 1)] 5. Find the

Q:

8 . ABC Corp. must withhold and pay FICA taxes on its employees wages. for the 2 0 2 4 tax year, what percentage of anemplyee wages is withheld for social security tax up to the wage limit , and what...

Q:

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...