Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. by using the excel spreadsheet, compute the expect

By using the excel spreadsheet, compute the expected return and standard deviation of the returns...

80.2K

Verified Solution

Question

Finance

By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the portfolio is $95,000, where $33,000 of this amount of money is invested in stock A and $20,000 is invested in stock B, the rest were invested in stock C.

State of Economy

Probability of state of Economy

Return if state Occurs

Stock A

Stock B

Stock C

Boom

10%

17%

6%

22%

Normal

35%

8%

10%

15%

Recession

-3%

12%

-19%

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

(a) Find expressions for each side of the right triangle that uses x, 8, or...

Calculus
Q

300 words explain: Disorders of the large intestine What is one example of a disorder that...

Medical Sciences
Q

Give five examples and show how phychiometry play an important role in your daily life routine.

Mechanical Engineering
Q

a) Select all solutions of (d^2/dx^2)y(x)+64y(x)=0. y(x)=3cos(8x) y(x)=3cos(4x) y(x)=C1sin(8x)+C2cos(8x) y(x)=?4sin(8x) y(x)=C2cos(8x) b) Select all solutions of (d^2/dx^2)y(x)+36y(x)=0. y(x)=C2cos(3x) y(x)=C1sin(3x) y(x)=3cos(3x) y(x)=3cos(6x) y(x)=3sin(3x)+8cos(3x)

Advance Math
Q

Find the missing values by solving the parallelogram shown in the figure The lengths of...

Geometry
Q

Write an equation for the polynomial graphed below 5 3 2 1 6 5 4...

Algebra
Q

Dave Gordon FCA, Senior Partner in one of the large public accounting firms, is in...

Accounting
Q

In the Month of March, Chester received orders of 87 units at a price of...

Accounting
Q

1. If X Company makes the part next year instead of buying it, and production...

Accounting
Q

Use the following to answer questions 47 (Round answers to the nearest dollar) The company...

Accounting
Q

Determine whether the following transactions are taxable. If a transaction is not taxable, indicate what...

Accounting
Q

Magnolia, Inc., manufactures bedding sets. The budgeted production is for 16,500 comforters this year. Each...

Accounting