User Account

All Pages

Develop efficient frontier for risky portfolios constructed

Assignment Help Finance Basics
Reference no: EM132886094

You are assigned with five stocks (See the excel file titled "Companies assigned to students") and you are expected to build the investment portfolios using those five stocks. Note that I showed you an example of a three-stock portfolio in the attached excel file. You are expected to apply the same concepts to the five-stock portfolios.

Please collect monthly stock price for the five companies that you are assigned from FINANCE.YAHOO.COM and employ the data time range from Jan 1, 2015 to April 30, 2021. Then using the risk-free rate of 0.35%, you are expected to develop the complete portfolio and develop the efficient frontier of these six securities (T-bill and five stocks).

Following are the procedure in details:

Collect monthly stock price data from Finance.YAHOO.COM. The time range for the date should be from Jan 1, 2015 to April 30, 2021.

Question 1: Compute monthly stock returns for each stock ( monthly rate of return = (P1 - P0) /P0; P is monthly adjusted close price). Then compute mean and standard deviation of stock returns for each company (See my excel example with the sheet entitled ‘Data')

Question 2: Develop Table of Covariance of these five stocks (See my excel example with the sheet entitled ‘Data')

Question 3: Develop Efficient Frontier for all risky portfolios constructed with 5 assigned stocks (See my excel example with the sheet entitled ‘EF' and ‘Graph')

Question 4: Find the Minimum-Variance risky portfolio (See my excel example with the sheet entitled ‘MVP')

Question 5: Find the Efficient portfolios including a risk free asset with risk free rate of 0.35% (See my excel example with the sheet entitled ‘Sharpe Ratio for CML' )

Question 6: Draw the capital market line (CML) (See my example with the sheet entitled ‘Sharpe Ratio for CML' and ‘Graph')

Attachment:- CML.zip

Reference no: EM132886094

Questions Cloud

Outline key hrm strategies : 1) Briefly summarise what measures should be considered to support the business on possible long-term skills shortages.
Why should the pension fund not invest on stock market : You might want to ask yourself when you work through the case is what allocation of stocks would be appropriate and are international securities to risky?
Compute the loss on reclassification : On January 1, 2022, the fair value of the bonds was P2,845,000 at an effective rate of 11%. Compute the loss on reclassification
Crisis communications plan : Develop a crisis communications plan for your stakeholders, including a social media policy. The plan should include ideas you have offered in essays
Develop efficient frontier for risky portfolios constructed : Develop Efficient Frontier for all risky portfolios constructed with 5 assigned stocks (See my excel example with the sheet entitled ‘EF' and ‘Graph')
Encourage the growth of trade unions : The National Labor Relations Act, better known as the Wagner Act, was passed in 1935 to encourage the growth of trade unions and keep management
What is the crossover point for the two projects : Consider two projects with the following cash flows: What is the Payback period of project 1? What is the crossover point for the two projects
Explain current or possible global marketing efforts : Provide a description of the product/service and a brief history of the firm. Explain your current or possible global marketing efforts.
Rule of law and finally make conclusion on problem : Analyze the problem using both the facts of the case and the rule of law and finally make a Conclusion on the problem.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd