Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use the following data to answer the questions. The ticker symbols are for Tesla Inc (TSLA), Barrick Gold Corporation (GOLD) and Apple Inc (AAPL).

Please use the following data to answer the questions. The ticker symbols are for Tesla Inc (TSLA), Barrick Gold Corporation (GOLD) and Apple Inc (AAPL). The prices shown are the closing stock prices for the date shown. Your first task is to compute the monthly holding period returns for each stock for each month, using the Holding Period Return formula, which is HPR = (P1-P0)/P0, where P1 is the end of period price and P0 is the start of period price. Be very careful to not mix up your dates. After you have computed the HPRs, then answer the following ten questions.

Date

TSLA

TSLA

GOLD

GOLD

AAPL

AAPL

2019-11-01

$ 65.99

$ 16.80

$ 66.81

2019-12-01

$ 83.67

$ 18.59

$ 73.41

2020-01-01

$ 130.11

$ 18.52

$ 77.38

2020-02-01

$ 133.60

$ 19.04

$ 68.34

2020-03-01

$ 104.80

$ 18.32

$ 63.57

2020-04-01

$ 156.38

$ 25.72

$ 73.45

2020-05-01

$ 167.00

$ 24.00

$ 79.49

2020-06-01

$ 215.96

$ 26.94

$ 91.20

2020-07-01

$ 286.15

$ 28.91

$ 106.26

2020-08-01

$ 498.32

$ 29.65

$ 129.04

2020-09-01

$ 429.01

$ 28.11

$ 115.81

2020-10-01

$ 448.16

$ 28.26

$ 116.79

Arithmetic Mean

Geometric Mean

Variance (Sample)

Standard Deviation

Correlation TSLA, GOLD

Correlation TSLA, AAPL

Correlation GOLD, AAPL

Assume you have a portfolio of $20,000, invested 60% in TSLA and 40% in GOLD. What was the sample standard deviation of the portfolio?

17.1%

15.6%

20.8%

16.8%

18.9%

Assume you have a portfolio of $20,000, invested 60% in TSLA and 40% in GOLD. What return would you expect for the portfolio, using the formula for portfolio return?

15.6%

11.5%

11.0%

12.2%

Now assume that your portfolio is invested 40% in TSLA, 30% in GOLD and 30% in AAPL. What return would you expect for this portfolio?

9.4%

10.6%

12.24%

2.3%

What is the sample standard deviation of the portfolio comprised of 40% TSLA, 30% GOLD and 30% AAPL? Use the Variance/Covariance Matrix to assist in this calculation. You can find it on the last page.

17.1%

13.8%

13.5%

14.9%

12.4%

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

Fundamentals Of Financial Planning

Authors: Michael A Dalton, Joseph Gillice

3rd Edition

1936602091, 9781936602094

More Books

Students also viewed these Finance questions

Question

=+7. For the cost matrix of Exercise 3,

Answered: 1 week ago

Question

Is the style consistent?

Answered: 1 week ago

Question

Does your strategic intent play to your strengths?

Answered: 1 week ago