Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Expected return and standard deviation graph

15/10/2021 Client: muhammad11 Deadline: 2 Day

Investment And Security Market

Group Project FIN 320 – Fall 2020 Part I Total Points: 37.5 This part of the project deals with portfolio return/risk calculations. To complete the project, you will hand in a set of answers to the questions listed below along with any supporting calculations and graphs. This project should be neat and well organized so that I can easily find your answers to each of the questions. 1. Data: This project makes use of annual data for two risky securities: the S&P 500 Index and Gold.

Annual values for each of these securities during the 29-year period from 1975-2003 are provided in a spreadsheet named GroupProject1Data.xls. The spreadsheet is available on the class web page. You will also need an estimate of the annual risk-free rate. To get this rate, you should take the most recent annual rate on U.S. Government Securities (note: select the Treasury Security you feel is most relevant for a one-year investment horizon). These rates can be found on the following web page: http://www.federalreserve.gov/releases/H15/update/

List your estimate of the annual Risk-Free rate here: ______________________ What date did you use to identify this interest rate? ______________________ What U.S. Treasury category did you use to identify this rate? ______________________

2. Return Calculations: Calculate annual returns for each of the two securities for each of the 28 years from 1976 through 2003. Calculate the average annual return, the standard deviation of annual returns, and the correlation between the returns of the two securities during this period and fill in the table provided. (Note: all of these calculations are based on annual security returns not index values). Attach the spreadsheet showing all of the relevant calculations as Exhibit 1.

S&P 500 Gold

Average Annual Return Standard Deviation of Annual Returns Return Correlation(S&P,Gold)

http://www.federalreserve.gov/releases/H15/update/
2

3. Capital Allocation Lines: Assume that the mean return, standard deviation, and correlation estimates you calculated above provide a reasonable forecast of the expected returns and risks of these securities for the coming year. Based on these forecasts, plot the two risky securities on an expected return – standard deviation graph. Also, plot the risk-free security. Be sure to label all three securities on the graph. Draw the Capital Allocation Line for each of the risky securities (S&P and Gold). Attach the graph as Exhibit 2.

4. Risky Portfolios: Calculate the expected returns and standard deviations of portfolios that combine the

two risky securities (S&P and Gold), varying weights from 0% to 100% in increments of 5% (note: this should result in 21 portfolios). Attach the spreadsheet showing all relevant calculations as Exhibit 3.

5. The Opportunity Set and the Optimal Risky Portfolio: Plot the risk-free security and the 21 portfolios

described in question 4 on an expected return – standard deviation graph. Be sure to clearly label the S&P 500, Gold, and the risk-free security on the graph. Identify and label the Minimum Variance Portfolio on the graph. Identify and label the Optimal Risky Portfolio on the graph and draw the Capital Allocation Line (CAL) for this portfolio. Attach the graph as Exhibit 4. What are the portfolio weights in the Optimal Risky Portfolio? ____________________________

What is the standard deviation of the Minimum Variance Portfolio? ____________________________ 6. Capital Allocation using the Optimal Risky Portfolio: Pick a target annual return between 2% and 10%.

Using the risk-free security you identified above and the Optimal Risky Portfolio you found in question 5, calculate the portfolio weights (in the risky and risk-free) that would be required to achieve this target annual return. Calculate the standard deviation of this portfolio. Label this point on the graph in Exhibit 4 and fill in the table below.

Optimal Risky Portfolio

Target Annual Return Weight in the Optimal Risky Portfolio

Weight in the risk-free security

Portfolio standard deviation

3

7. Sensitivity Analysis: (a) Repeat questions 4 and 5 assuming the correlation between the two risky securities is ρ=0.30 (but

using the same expected return and standard deviation forecasts). Attach the spreadsheet showing all relevant calculations as Exhibit 5 and the expected return – standard deviation graph as Exhibit 6.

What are the portfolio weights in the Optimal Risky Portfolio? ______________________

What is the standard deviation of the Minimum Variance Portfolio? ______________________

How do the Minimum Variance Portfolio, the Optimal Risky Portfolio, and the CAL for the Optimal Risky Portfolio compare to those from question 5?

(b) Repeat question 6 assuming using the Optimal Risky Portfolio from question 7(a). Fill in the table

below. (Note: Use the same target return as in question 6.)

Optimal Risky Portfolio

Target Annual Return Weight in the Optimal Risky Portfolio

Weight in the risk-free security

Portfolio standard deviation

How does the standard deviation of this portfolio compare to that from question 6? (c) What do the results from questions 7(a) and 7(b) tell us about the relation between security

correlations and diversification?

4

Group Project FIN 320 – Fall 2020 Part II Total Points: 37.5

The second part of the project deals with the Capital Asset Pricing Model and Market Model estimation of the CAPM. To complete the project, you will hand in a set of answers to the questions listed below along with any supporting calculations and graphs. 1. Data: This project makes use of weekly returns for one year on a market index (the S&P 500) and two

international Exchange Traded Funds (ETFs) listed on the American Stock Exchange. You will use the S&P 500 as a proxy for the “market portfolio”. You will then choose two international ETFs from among the international funds listed on the American Stock Exchange web page (go to http://www.amex.com/etf/prodInf/EtPiMain.jsp and select “international” to see a list of these ETFs). Weekly prices for each of the ETFs with sufficient data are provided in a spreadsheet named GroupProject2Data.xls. The spreadsheet is available on the class web page. You can use the data from the spreadsheet or obtain the data from the AMEX web site. Throughout the project, you will assume an annual risk-free rate of 1.5%. You can estimate the weekly risk-free rate by dividing the annual rate by 52.

2. Return Calculations: Calculate weekly returns for the S&P500 and each of the international funds for each of the 52 weeks during the sample period (note: there are 53 weekly prices to calculate 52 weekly returns). For each security, calculate the mean return, standard deviation, and variance of weekly returns, and fill in the relevant data in the table below. Be sure to list the ticker symbols for the international funds you have chosen. (Note: these summary calculations are based on weekly returns not prices). Attach the spreadsheet showing all relevant calculations as Exhibit 1.

Summary Statistics for Weekly Returns Mean Return Standard Deviation Variance

S&P 500 International Security 1: Ticker = International Security 2: Ticker = Risk-free rate - -

3. The Capital Market Line: Using the mean returns and standard deviations you calculated in question 2, plot the S&P 500 (the market) and the two international funds on an expected return – standard deviation graph. Using the weekly risk-free rate given above, draw the capital market line (CML). Be sure to label all of the securities (including the risk-free security) on the graph. Attach the graph and related calculations as Exhibit 2. Are the positions of the international securities on the graph consistent with CAPM? Why or why not?

http://www.amex.com/etf/prodInf/EtPiMain.jsp
5

4. The Market Model: Calculate weekly excess returns for each of the international funds and the S&P 500 (the market) by subtracting the weekly risk-free rate from each weekly return. For each of the two international funds, create an X-Y scatterplot with the excess returns of the international fund on the Y- axis and the excess returns of the market (S&P) on the X-axis. Add a trendline (security characteristic line) to each graph. Using either the trendline options or other excel functions, calculate the Alpha and Beta for each of the international funds and fill in the related information in the table below. Attach the graph and related calculations as Exhibit 3.

Market Model Estimates Alpha Beta R2

S&P 500 International Security 1: Ticker = International Security 2: Ticker =

5. Market vs. Firm-Specific Risks: One of the benefits of the market model is that it allows us to decompose

total risk (variance) into two components. Using the equation we discussed in class, calculate the market component of risk and the firm-specific component of risk for each of the securities. Fill in the related table below and Attach any related calculations as Exhibit 4.

Decomposition of Risk Total Risk Market Risk Firm-Specific

Risk S&P 500 International Security 1: Ticker = International Security 2: Ticker =

Which of the three securities is the riskiest based on total risk? How does your answer change if you consider only systematic risk? How does your answer change if you consider only firm-specific risk?

6. The Security Market Line: Using the risk-free rate and the mean returns and Betas of the international

securities and the market (S&P), create an expected return – beta graph. Be sure to label all of the securities on the graph (including the risk-free security). Draw the Security Market Line (SML) for this set of securities. Attach the graph and related calculations as Exhibit 5. Are the international funds priced correctly according to CAPM? If not, what would be your buy/sell recommendations for these international funds?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Class Engineers
Engineering Solutions
Top Grade Essay
Assignment Hut
Unique Academic Solutions
Coursework Assignment Help
Writer Writer Name Offer Chat
Top Class Engineers

ONLINE

Top Class Engineers

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$15 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$23 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$20 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$46 Chat With Writer
Unique Academic Solutions

ONLINE

Unique Academic Solutions

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$18 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$46 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Exponential smoothing problems and solutions - The glass castle discussion questions and answers - Plant vs animal cell venn diagram - Mary poppins script free - Decision making process assignment - Krell industries has a share price of - Perth zoo annual report - Ode on a distant prospect of eton college paraphrase - Area of a sector calculator radians - Acting on Trends - 55.7 kg in stone - Drake precision dental lab - Az animals com white tiger - Microbiology lab report gram stain - The quick brown fox poem - Greek tragedian who rewrote myths to suit his subject - Clinical services building rnsh - Https lc grad2 gcu edu learningplatform user login html - WEEK 5 discussion - As a caregiver being a good neighbor means - An angel appeared to mary - 2005 toyota corolla clock fuse - How to draw a cartoon castle - Assignment on marketing mix of pepsi - Selection pressure peppered moths - 20 units is how many ml - Thistley hough academy uniform - Go ming whitwell menu - Brand eqity model and brand identity of brand ( onion model) missoni - Mgt 3810 - American history 6th ed.vol.2 Eric foner - How to report a tukey post hoc test apa - Poem barbie doll marge piercy analysis - The gauge pressure in each of the four tires - Story of chicken licken - 12 gauge buckshot aim it at your dreadlocks - Two types of audit working papers - Irony in the crucible - Ipod duplicate filename was specified - Medical law and ethics chapter 5 answers - Avaya cms report definitions - Itm navi mumbai scholarship - Brick nogging partition wall - Your interpersonal communication mottet pdf - A research journal can help you keep notes - Match the forecasting method to the appropriate classification. - Csec english sba reflection sample - Assessment item marks - Bubble diagram interior design - Week 7 - Endocrine Case Study - k - Walden castlebranch - 3rd Essay - Clive eats alligators activities - Roland barthes the language of fashion summary - Essay using gibbs reflective cycle - Initiating the Project - Problem Set 3 - Example of letter of advice for a client - Business Ethics Assignment 2 Week 4 - Cri du chat brochure - Research and Evidence-Based Practice - Synthesis of fe acac 3 from fecl3 - 2 PART ESSAY - Infinitivo seguir (1) yo (2) morí tú seguiste (3) nosotras seguimos (4) ellos (5) murieron - Gregorian chant hildegard von bingen - 5/9 tristania street rivett - Chemical and mechanical digestion - Bma australia trading docklands - DR Discussion 1 & 2 No Plagiarism - Conclusion chapter of thesis - 7 steps to successful writing - Imagery in birches - Edheads virtual hip surgery - Social relations - 1 peter 3 15 nkjv - Double strength chloroform water - Social media in business communication ppt - Cloud Computing Week 2 Assignment: IaaS redundancy and load balancing - AC/FI A4 - Basic networking terms and definitions pdf - Graph of ln x - Ifsm 300 stage 2 cic hiring process - Discussion - Penny from heaven chapter summary - Starbucks bankers hall plus 15 - How to make power with a potato - Horrid henry pe teacher - Dell sc420 spec sheet - Acc treatment injury form - Colombo frozen yogurt case study solution - What is the competitive advantage of jeep cherokee - Vincent wildlife trust polecat - Kk7b micro r2 receiver - Hsu's lactobacillus pediococcus medium - Tangent ratio worksheet answer key - Line of best fit algebra 1 - Tesco's international growth strategy case analysis - Nursing - Microsoft Power Point Assignments 3 - Hal and me nicholas carr