Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 06, 2024

The return on Visa stock has a standard deviation of 30% and the return on Walmart stock has a standard deviation of 21%. Their correlation

The return on Visa stock has a standard deviation of 30% and the return on Walmart stock has a standard deviation of 21%. Their correlation is 0.67.

If you invest 80% in Visa and 20% in Walmart, what is the variance of the portfolio?

What is the standard deviation of the portfolio?

If possible, can you show how to solve in excel..Thank you!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 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

U.S. Mergers And Acquisitions Legal And Financial Aspects

Authors: Felix Lessambo

1st Edition

3030857344,3030857352

More Books

Students also viewed these Finance questions

Question

★★★★★

Determine the reactions at supports A and B. Units Used: kip = 103 lb Given: w1 = 500lb/ft w2 = 700lb/ft a = 6 ft b = 8 ft c = 9 ft d = 6 ft w2

Answered: 1 week ago

Question

★★★★★

Required information Use the following information for the Quick Study below. [The following information applies to the questions displayed below.) Carlberg Company has two manufacturing departments,...

Answered: 1 week ago

Question

★★★★★

4. Bans Bakery Ltd. has just come out with a new bread flavour that they are sure will cause sales to double between 2015 and 2016. Using the following worksheet, complete Bans Bakerys pro forma...

Answered: 1 week ago

Question

★★★★★

The blood bank wants to determine the least expensive way to transport available blood donations from Pittsburg and Staunton to hospitals in Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The...

Answered: 1 week ago

Question

★★★★★

Calculate the maturity value and date of payment of a 8 0 - day, $ 1 , 2 0 0 face value note is the money was issued on April 3 0 , 2 0 2 0 , and earning interest at 1 0 . 7 5 % . 1 6 ) A ) $ 1 , 2 7...

Answered: 1 week ago

Question

★★★★★

6(a): Assuming that no digit can be repeated, how many different three digits (5) positive whole number can be formed using the numbers 2, 3,5,7,8 ? (b): In how many ways can a party of 3 students...

Answered: 1 week ago

Question

★★★★★

Calmex is situated in North India. It specializes in manufacturing overhead water tanks. The management of Calmex has identified a niche market in certain Southern cities that need a particular size...

Answered: 1 week ago

Question

★★★★★

Two players, Amy and Beth, play the following game with a jar containing 100 pennies. The players take turns; Amy goes first. Each time it is a player's turn, she takes between 1 and 10 pennies out...

Answered: 1 week ago

Question

★★★★★

A population consists of the five numbers 2, 3, 6, 8 and 11. Consider samples of size 2 that can be drawn from this population. a. List all the possible samples and the corresponding mean. Sample Mean

Answered: 1 week ago

Question

★★★★★

The terms "normal" and "inferior" are: Multiple choice question. the same for everyone, irrespective of income. used interchangeably. subjective to the incomes of people. based on the product sales...

Answered: 1 week ago

Question

★★★★★

A company wants to investigate if the average rating of consumers for a particular product is greater than 4.5 (on a scale of 1 to 10). They collect a random sample of 35 consumers and ask them to...

Answered: 1 week ago

Previous Question Next Question