Explain the main characteristics of the funds

Assignment Help Portfolio Management
Reference no: EM131474669

PORTFOLIO MANAGEMENT AND ANALYSIS

Instructions:

Open a new Excel file. Name it [YOUR-NAME_YourFirstName.xlsx]. Create Tabs named "A1", "A2", "A3", "S1", "S2", "S3", "S4", "S5", "S6", "G1", "G1", "A2", "M1"

In tab "A1", explain the main characteristics of the funds in which investors can invest within your assigned Morningstar's category (strategies, sector and country allocations, company size, recommended holding period, diversification,...). That step requires some research for you (you may need other sources than Morningstar!). Also assess the level of risk and the return potential of the category. By reviewing all the funds in all categories (not necessarily your assigned category), indicate which fund could be considered as risk-free and identify a proxy for the market portfolio. Justify your choices.

Among the list of the funds of your assigned category, select five funds. Report the selection and the related information on tab "A2". Indicate which funds are dominated by one or several others (indicate which ones) in the mean-variance framework. Explain in detail your answer.

On the same tab, indicate which information is missing at this point to construct the frontier of efficient portfolios with these 5 funds.

Download (from Bloomberg, Reuters, Yahoo Finance, the fund's website or any other online source) historical weekly returns corresponding to 3 time horizons (1 year, 2 years and 5 years) for each of the 5 funds, plus the proxy for the market portfolio. Report this dataset on tab "A3". For each fund, build:

  • the vector of means (on tab "S1")
  • the covariance matrix (on tab "S2")
  • the correlation matrix (on tab "S3")
  • the vector of Sharpe ratios (on tab "S4")
  • the vector of market betas (on tab "S5")

On a new tab called "G1", plot the funds in the mean-standard deviation space, and construct the frontier of efficient portfolios (from a dataset on tab "S6" Use the five funds to construct the efficient frontier). Assume no short sale is allowed.

In tab "G2", determine what is the composition of the optimal risky portfolio (consisting of your five funds) for each time horizon and for each of the following risk profiles (coefficients of risk aversion):

  • 3 if you're a strongly risk-averse investor,
  • 1 if you are less risk-averse,
  • the appropriate coefficient of risk aversion when you are risk-neutral.

Represent graphically where each portfolio plots for each time horizon and comment the potential similarities and differences in the asset allocation. If you were also allowed to invest in the proxy for the market portfolio (in addition to the 5 funds), how would change your results? Show it graphically.

Add the fund that you determined as being the risk-free one and determine what is the optimal combination with the optimal risky portfolio (consisting of the 5 funds) for each risk profile listed in the previous question and for each time horizon. Represent them graphically on tab "G3" and comment the potential similarities and differences in the capital allocation.

If each investor decides to invest in only one fund, in which one would it be (assuming (s)he holds no other risky investment)? Report your answer and arguments in tab "A4". Is it consistent with Morningstar's star ranking (the best fund has five stars, the worst one star)? That is, would it be in the higher ranked fund?

What if an investor already invests in many other assets belonging to each Momingstar's category? Report your answer and arguments in tab "A4". Are the best star ranked funds by Morningstar the most attractive for this investor? Are they "cheap"? "expensive"?

Would you classify the funds you selected in the same category as Morningstar (in their "Style" category, or through their star ranking) for the 1-year time horizon? Which indicators would you use to justify your answer? Report your answer and arguments in tab "Ml". If you adopted your classification, what would change in your previous work if you only considered historical data on a 1-year time-horizon? List the changes, show your calculations, results, graphs, answers and conclusions in the tab "M1".

Output needs to be in excel format.

Attachment:- Assignment Files.rar

Reference no: EM131474669

Questions Cloud

Write about tsa verses privately contracted airport security : Write about Pros and Cons of Transportation Security Administration verses privately contracted airport security. Review what others did regarding the case?
Questions when thinking about setting a limit : According to the text, you should ask yourself three of the following questions when thinking about setting a limit. Which question should you not ask?
What is the buffer explain briefly : Assume that ASC memory is built using eight interleaved blocks of 8 Kwords each. Include an instruction buffer eight words long into the ASC control unit.
Contest for the world greatest salesman : In 2010, the Ogilvy advertising agency had a contest for the World's Greatest Salesman in honor of their founder David Ogilvy.
Explain the main characteristics of the funds : In tab "A1", explain the main characteristics of the funds in which investors can invest within your assigned Morningstar's category
A continuous process layout : For which key organizational functions are tasks and responsibilities identified for all the steps of the generic product development process?
Develop the micro operations needed to manage the buffer : Assume that ASC memory is built using eight interleaved blocks of 8 Kwords each. Include an instruction buffer eight words long into the ASC control unit.
What is the average access time : The characteristics of a four-level memory hierarchy are shown below: What is the average access time?
Explain description of overall and specific goal for project : Description of the overall and specific goals for the project, including an explanation of the overall goal and the approximate scope of the project.

Reviews

Write a Review

Portfolio Management Questions & Answers

  Compute the variance-covariance matrix

Compute the sample mean, variance, and standard deviation of these shares and compute the variance-covariance matrix V and Plot the daily share prices and daily returns for each individual asset.

  Identify and briefly explain two cfa institute standards

Briefly describe two CFA Institute Standards of Professional Conduct that apply to Clark. Identify and briefly explain two CFA Institute Standards of Professional Conduct that apply to this situation.

  Justify the commitment of project d using the portfolio proc

Justify the commitment of Project D using the portfolio process

  What the paired trade suggests to you about implied view

Briefly discuss what this paired trade suggests to you about the manager's implied view as to: (1) the general direction of future interest rate movement.

  What is the total value of the company

What is the expected stream of dividends per share for an investor who plans to retain his shares rather than sell them back to the company? Check your estimate of share value by discounting this stream of dividends per share.

  What is the treynor portfolio performance measure

What is the Treynor portfolio performance measure? What is the Jensen portfolio performance measure, and how can it be adapted to include multifactor models of risk and expected return?

  Build a portfolio designed for a wealth management client

Objectives of portfolio: build a portfolio designed for a wealth management client and Client: HNWI = high net worth individuals, FO = family offices and standard

  Create organization chart for two or three level of employee

Create an organization chart for two or three levels of employees. Then add arrows to identify the three directions of the formal communication network.

  What additional information is provided by a comparison

Under what circumstances would it make sense to use both measures to compare the performance of a given set of portfolios? What additional information is provided by a comparison of the rankings achieved using the two measures?

  Jiminys cricket farm issued a 30-year 6 percent semiannual

jiminys cricket farm issued a 30-year 6 percent semiannual bond 8 years ago. the bond currently sells for 97 percent of

  Calculate the net asset value for a share of the focus fund

Calculate the net asset value for a share of the Focus Fund at the end of Year 1, being sure to include the cash position in the net total portfolio value.

  Calculate the short term interest rate target

FIN 443 - Do basic research (Google?) on how you would become a licensed portfolio manager in a developed market (your choice of US, Hong Kong, Japan, Taiwan, etc).

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!

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