Question: Create a scatter plot (Chart 1) of your results from parts a) through c) with risk on the horizontal axis and expected return on the

Create a scatter plot (Chart 1) of your results from parts a) through c) with risk on the horizontal axis and expected return on the vertical axis. Plot AMZN, IBM, MSFT, the minimum risk portfolio and the 25% risk portfolio. Make sure you label each data point on the graph. If you were presenting this chart to clients, what conclusions would you draw for them? Assume that incorporating the risk-free rate is not an option. (13 points)

Create a scatter plot (Chart 1) of your results from parts a) e. For Chart 2, plot the minimum-variance frontier of the 3-asset portfolio and the 3 data points of the risk/return for the individual securities, assuming short sales are permitted.

1 a. \begin{tabular}{lccc} \hline \multicolumn{4}{l}{ Annualized parameter estimates } \\ \hline & AMZN & IBM & MSFT \\ \cline { 2 - 4 } Mean & 0.0513 & 0.0474 & 0.2240 \\ Variance & 0.1182 & 0.0746 & 0.0479 \\ Standard deviation & 0.3438 & 0.2732 & 0.2188 \end{tabular} Variance-covariance \begin{tabular}{lccc} \hline & AMZN & IBM & MSFT \\ \cline { 2 - 4 } AMZN & 0.1182 & 0.0267 & 0.0540 \\ IBM & 0.0267 & 0.0746 & 0.0178 \\ MSFT & 0.0540 & 0.0178 & 0.0479 \end{tabular} 1b. \begin{tabular}{lccc} Minimum risk portfolio & AMZN & IBM & MSFT \\ \hline Weights & -0.1220 & 0.3500 & 0.7719 \\ Sum weights & 1.0000 & 0 & 0 \\ Expected return & 0.1832 & 0 & 0 \\ Risk & 0.1913 & 0.0000 & 0.0000 \end{tabular} \begin{tabular}{llcc} Minimum risk portfolio & AMZN & IBM & MSFT \\ \hline Weights & 0.3333 & 0.3333 & 0.3333 \\ Sum weights & 1.0000 & 0 & 0 \\ Expected return & 0.1076 & 0 & 0 \\ Risk & 0.2206 & 0.0000 & 0.0000 \end{tabular} 1c. \begin{tabular}{lccc} Portfolio for risk of 25\% & AMZN & IBM & MSFT \\ \hline Weights & 0.5350 & 0.2307 & 0.2343 \\ Sum weights & 1.0000 & & \\ Expected return & 0.0909 & & \\ Risk & 0.2500 & & \end{tabular} 1 a. \begin{tabular}{lccc} \hline \multicolumn{4}{l}{ Annualized parameter estimates } \\ \hline & AMZN & IBM & MSFT \\ \cline { 2 - 4 } Mean & 0.0513 & 0.0474 & 0.2240 \\ Variance & 0.1182 & 0.0746 & 0.0479 \\ Standard deviation & 0.3438 & 0.2732 & 0.2188 \end{tabular} Variance-covariance \begin{tabular}{lccc} \hline & AMZN & IBM & MSFT \\ \cline { 2 - 4 } AMZN & 0.1182 & 0.0267 & 0.0540 \\ IBM & 0.0267 & 0.0746 & 0.0178 \\ MSFT & 0.0540 & 0.0178 & 0.0479 \end{tabular} 1b. \begin{tabular}{lccc} Minimum risk portfolio & AMZN & IBM & MSFT \\ \hline Weights & -0.1220 & 0.3500 & 0.7719 \\ Sum weights & 1.0000 & 0 & 0 \\ Expected return & 0.1832 & 0 & 0 \\ Risk & 0.1913 & 0.0000 & 0.0000 \end{tabular} \begin{tabular}{llcc} Minimum risk portfolio & AMZN & IBM & MSFT \\ \hline Weights & 0.3333 & 0.3333 & 0.3333 \\ Sum weights & 1.0000 & 0 & 0 \\ Expected return & 0.1076 & 0 & 0 \\ Risk & 0.2206 & 0.0000 & 0.0000 \end{tabular} 1c. \begin{tabular}{lccc} Portfolio for risk of 25\% & AMZN & IBM & MSFT \\ \hline Weights & 0.5350 & 0.2307 & 0.2343 \\ Sum weights & 1.0000 & & \\ Expected return & 0.0909 & & \\ Risk & 0.2500 & & \end{tabular}

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!

5. The following series of questions explores the relationship between the standard dot product on R" (geometry) and linear operators on R" (linear algebra). Let U be a n x n matrix, and think of it...

1 . ( 3 5 points ) The variable smokes is a binary variable equal to one if a person smokes, and zero otherwise. Using the data in SMOKE, we estimate a linear probability model for smokes: Using data...

Provide sufficient questions to the attached questions. 3. (a) Below are a countour map of a function f and a curve with equation g(r, y) = 15. Estimate the maximum and minimum values of f subject to...

The value of a sports franchise is directly related to the amount of revenue that a franchise can generate. The accompanying data table gives the value and the annual revenue for 15 major sport...

A box office analyst seeks to predict opening weekend box office gross for movies. Toward this goal, the analyst plans to use online trailer views as a predictor. For each of the 66 movies, the...

A magazine publishes restaurant ratings for various locations around the world. The magazine rates the restaurants for food, decor, service, and the cost per person. Develop a regression model to...

An agent for a residential real estate company in a suburb located outside a major city has the business objective of developing more accurate estimates of the monthly rental cost for apartments....

In this project you will learn to create data visualizations in R , an open source software environment for statistics computing and graphics. For more information on R, visit this page , which...

In this assignment , you will examine what happens when different sample sizes are used to once ? What if you rolled the die 10 times or 100 times ? You will be given a data file that contains the...

Write an equation of the graphed function by using transformations of the graphs of one of the functions. 10- 9 8 7 f(x) = 654 321 10-9-8-7-6-5-4-3-2-1 -2 -3 --4- -6 -7 -8 -9 -10- 2 3 6 7 8 9 10

During a session with her psychiatrist, Dr. Robert Willis, Joan Weill mentioned in confidence the imminent merger of the company headed by her husband, Sanford Weill, with another company. Willis,...

Chad has offered to take Miles into his accounting firm as a partner upon payment of $ 5 , 0 0 0 cash. In response, Miles says, "I'll give you $ 3 , 0 0 0 cash now and I will pay you the remainder in...

Suppose you are the money manager of a $ 4 . 2 8 million investment fund. The fund consists of four stocks with the following investments and betas: Stock Investment Beta A $ 5 4 0 , 0 0 0 1 . 5 0 B...