Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. you are considering two stocks with the following

You are considering two stocks with the following characteristics: Expected return of stock 1 (1)...

80.2K

Verified Solution

Question

Finance

You are considering two stocks with the following characteristics: Expected return of stock 1 (1) = 0.17, Expected return of stock 2 (2) = 0.04, Standard deviation of stock 1's returns ( 1) = 0.09, Standard deviation of stock 2's returns ( 2) = 0.03, and Covariance between the rates of returns of stock 1 and stock 2 (21 or 21) = 0.06. If you invest 0.17 percent of your total investment on stock 1 and 0.83 percent on stock 2, what would be the standard deviation of the portfolio consisting of these two stocks?

Please show me how to do this in excel with all the formulas visable, thank you!

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Question 12 1 A table of marital status for males and fe person picked at...

Mechanical Engineering
1.2K views

How to calculate overall fuel economy of hydraulic hybrid vehicle? Know that fuel economy formula is...

Psychology
1.2K views

Name, define, and explain the three barriers to effective communication. Your post should be substantial, and...

Basic Math
1.2K views

In a study at a large hospital the researcher wants to assure that male nurses are...

Physics
1.2K views

The superposition takes place between two waves of frequency f and amplitude a The maximum...

Basic Math
1.2K views

Z W Z W W X X y y Z 1 The multiplication table above...

Algebra
1.2K views

Solve the system of equations by using the addition method Write the answer in simplest...

Accounting
1.2K views

The Benker Compary is prepanng its cash paymers...

Accounting
1.2K views

Please answer the following question: c. Describe a minimum of two ways in...

Accounting
1.2K views

Security Technology Incorporated (STI) is a manufacturer of an electronic control system used in the...

Accounting
1.2K views

How much of St. Judes revenue is from patient services

Finance
1.2K views

A $100,000 bond bearing interest at 5% payable annually is bought eight years before maturity...