Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

answer all a, b, and c please Q3. An investor wants to form a portfolio of two securities that should give minimum risk. He identified

answer all a, b, and c please image text in transcribed
Q3. An investor wants to form a portfolio of two securities that should give minimum risk. He identified five securities- A, B, C, D, and E to select two out of these. Year ending share prices of the securities and the market index are shown in the following table. Year Market Index 8,542 8,956 9,584 9,254 9,658 9,245 9,365 9,784 9,784 9,965 Share price: Share price: Share price: Share price: Share price: BANC D 472572 50 150 3082 | 60 1443284 48 482877 503582 453088 57 504590 70 6247 78 78 1168398075 1744088 80 Transfer this data set into MSExcel and answer the following questions: a. Suggest the two securities for the portfolio so that the portfolio should have the minimum risk. b. Calculate portfolio return and risk. c. Suggest the proportion of investment in each security so that the portfolio has the minimum risk

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

Step: 3

blur-text-image

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

Real Estate Finance And Investments

Authors: William Brueggeman, Jeffrey Fisher

13th Edition

0073524719, 9780073524719

More Books

Students also viewed these Finance questions

Question

In what way can a business strategy motivate and inspire employees?

Answered: 1 week ago

Question

zyLab - Variables, input, and casting

Answered: 1 week ago