### Our Services

Get 15% Discount on your First Order

# risk-return Assignment 2 a. Use the year-end stock price data given to calculate annual returns for Bartman, Reynolds, and the Market Index, and the

## risk-return

Assignment 2
a. Use the year-end stock price data given to calculate annual returns for Bartman, Reynolds, and the Market Index, and then calculate average returns over the five-year period. Remember, returns are calculated by subtracting the beginning price (previous year year-end price) from the ending price (current year year-end price) to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price (previous year year-end price). Assume that dividends are already included in the index., so in your calculation of index return, you don’t need to add the dividend. Also, you cannot calculate the rate of return for 2002 because you do not have 2001 data.)
Data as given in the problem are shown below:
Bartman Industries Reynolds Incorporated Market Index
Year Stock Price Dividend Stock Price Dividend Includes Divs.
2007 \$17.250 \$1.150 \$48.750 \$3.000 11,663.98
2006 14.750 1.060 52.300 2.900 8,785.70
2005 16.500 1.000 48.750 2.750 8,679.98
2004 10.750 0.950 57.250 2.500 6,434.03
2003 11.375 0.900 60.000 2.250 5,602.28
2002 7.625 0.850 55.750 2.000 4,705.97
We now calculate the rates of return for the two companies and the index:
Bartman Reynolds Index
2007

Kenneth D. Jackson: Change in stock price plus any dividends, divided by the previous stock price
2006
2005
2004
2003
Average
Note: To get the average, you could get the column sum and divide by 5, but you could also use the function wizard, fx. Click fx, then statistical, then Average, and then use the mouse to select the proper range. Do this for Bartman and then copy the cell for the other items.
b. Calculate the standard deviation of the returns for Bartman, Reynolds, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.)
Use the function wizard to calculate the standard deviations.
Bartman Reynolds Index
Standard deviation of returns
c. Now calculate the coefficients of variation Bartman, Reynolds, and the Market Index.
Bartman Reynolds Index
Coefficient of Variation
d. Estimate Bartman’s and Reynolds’s betas as the slope of a regression with stock return on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). (Hint: use Excel’s SLOPE function.)
Bartman’s beta =
Reynolds’ beta =
e. The risk-free rate on long-term Treasury bonds is 6.04%. Assume that the market risk premium is 5%. What is the expected return on the market? Now use the SML equation to calculate the two companies required returns.
Risk-free rate = 6.040%
Expected return on market = Risk-free rate + Market risk premium
= +
=
Bartman:
Required return = + x
=
Reynolds:
Required return = + x
=
f. If you formed a portfolio that consisted of 50% Bartman and 50% Reynolds, what would be its beta and its required return?
The beta of a portfolio is simply a weighted average of the betas of the stocks in the portfolio, so this portfolio’s beta
would be:
Portfolio beta =
g. Suppose an investor wants to include Bartman Industries’ stock in his or her portfolio. Stocks A, B, and C are currently in the portfolio, and their betas are 0.769, 0.985, and 1.423, respectively. Calculate the new portfolio’s required return if it consists of 25 percent of Bartman, 15 percent of Stock A, 40 percent of Stock B, and 20 percent of Stock C.
Beta Portfolio Weight
Bartman 25%
Stock A 0.769 15%
Stock B 0.985 40%
Stock C 1.423 20%
100%
Portfolio Beta =
Required return on portfolio: = Risk-free rate + Market Risk Premium * * Beta
=
=

Order a Similar Paper and get 15% Discount on your First Order

## Related Questions

### Wright Journal 1 Completion requirements  Directions Write a one-paragraph summary of key lessons and takeaways

Wright Journal 1 Completion requirements  Directions Write a one-paragraph summary of key lessons and takeaways from the Wright text this week.  The goal of the summary is to connect the reading with your area of ministry.  You will submit journal entries 1 – 3 at the end of Week 4.

### Business Finance – Operations Management OPMT 620: Operations Management – Case Study McDonalds Assignment

Business Finance – Operations Management OPMT 620: Operations Management – Case Study McDonalds Assignment

### Assignment: Prepare a brief for the  Hamer v. Sidway case

Assignment: Prepare a brief for the  Hamer v. Sidway case . (On Page 2) Use the FIRAC format. Facts, Issue, Rule, Analysis, and Conclusion The FIRAC method is a  systematic approach used to summarize legal information 1 2 3 .  FIRAC stands for Facts, Issue, Rule, Analysis, and Conclusion 2

### Please submit a short 250-300 word “Written Assignment.” Use these questions as prompts with an introductory opinion or thesis that explains to your readers why

Please submit a short 250-300 word “Written Assignment.” Use these questions as prompts with an introductory opinion or thesis that explains to your readers why people can or cannot always practice so

### Navigating a Crisis Due: Week 6 (20%) Overview As a leader, you will face multiple crises.

Navigating a Crisis Due: Week 6 (20%) Overview As a leader, you will face multiple crises. While you will easily weather many bad situations, there may be some that will seriously threaten your company and your reputation. How you respond to crises, especially crises of trust, will determine your fate.

### Assignmment Week 7

Assignmment Week 7 image1.png image2.png image3.png

### Module Four Short Paper Guidelines and Rubric.html ENG 220 Module Four Short Paper Guidelines and Rubric Overview For this assignment, you will observe and a

Module Four Short Paper Guidelines and Rubric.html ENG 220 Module Four Short Paper Guidelines and Rubric Overview For this assignment, you will observe and analyze nonverbal cues and consider the implications for business communication. Prompt Choose a sitcom (e.g., The Big Bang Theory (A captioned version of the video is

### FEEDBACK FROMASSIGNMENT 5 Offers a competent analysis of the competitors, but it may lack depth or miss some key aspects. Developed a

FEEDBACK FROMASSIGNMENT 5 Offers a competent analysis of the competitors, but it may lack depth or miss some key aspects. Developed a plan that includes how you compare yourself to your competitors currently and how you will differentiate yourself from the competition in the future, but the plan is incomplete.

### Select one film from the course list and write 750-1,000 words as an analysis of three literary elements (plot, characterization, dialogue, setting, irony,

Select one film from the course list and write 750-1,000 words as an analysis of three literary elements (plot, characterization, dialogue, setting, irony, etc.) as they relate to an overarching theme

### Hellfire Pistons Motorcycle Gang Study [Note: To complete this template, replace the bracketed text with your own content. Remove this note before you submit

Hellfire Pistons Motorcycle Gang Study [Note: To complete this template, replace the bracketed text with your own content. Remove this note before you submit your presentation.] [Your Name] CJ 340: Criminology [Date] Crimes [Identify crimes in relation to this gang.] Offenders [Describe the offenders who commit crimes.] Sociology → Criminology

### I need help with my assignment. A case study that needs a PowerPoint. Don’t worry about the Part II video. I will do the video part but I need help explaining

I need help with my assignment. A case study that needs a PowerPoint. Don’t worry about the Part II video. I will do the video part but I need help explaining the details in the PowerPoint, you could

### Week 5 Discussion   Respond to both discussion topics. Please create a new thread for each discussion topic and identify in the subject line the

Week 5 Discussion   Respond to both discussion topics. Please create a new thread for each discussion topic and identify in the subject line the topic to which you are responding. In responding to the discussions and to other students, please be sure to use the course material using in-text citations

### 100 word response 1 reference/intext citation due 2/7/2024 Patton Should every weapon be test-fired at the factory and entered into a database (NIBIN) with its

100 word response 1 reference/intext citation due 2/7/2024 Patton Should every weapon be test-fired at the factory and entered into a database (NIBIN) with its serial number so that it can be linked to the owner who purchased it? What would be the pros and cons of this? Yes because

### “Cindy Sherman’s Untitled Film Stills is a suite of 70 black-and-white photographs made over the course of three years in which the artist posed in the guises

“Cindy Sherman’s Untitled Film Stills is a suite of 70 black-and-white photographs made over the course of three years in which the artist posed in the guises of various generic female film characters

### REPOND TO RESPONCE BELOW WITH AT LEAST 250 WORDS CITATION AND REFRENCE Pricing and Economic Strategies: Odd Pricing Odd pricing is a psychological

REPOND TO RESPONCE BELOW WITH AT LEAST 250 WORDS CITATION AND REFRENCE Pricing and Economic Strategies: Odd Pricing Odd pricing is a psychological pricing strategy that involves ending pri

### Major Case Analysis Presentation Instructions As students complete the required Major Case Analysis, they are also responsible for completing a PowerPoint or

Major Case Analysis Presentation Instructions As students complete the required Major Case Analysis, they are also responsible for completing a PowerPoint or Prezi presentation (or presentation that uses another appropriate technology) highlighting their findings. This is a follow-up to the Major Case Analysis and must be submitted to the assignment

### 2 Week2 Healthcare Policy and Finance Assignment Heidi Lugo Galen College of Nursing Course Name Instructor’s Name Date

2 Week2 Healthcare Policy and Finance Assignment Heidi Lugo Galen College of Nursing Course Name Instructor’s Name Date Week2 Healthcare Policy and Finance Assignment The selected pending Healthcare Bill is S.1297 – Let Doctors Provide Reproductive Health Care Act. Link: bill/1297?q=%7B%22search%22%3A%22healthcare+pending+bills%22%7D&s=1&r=2 Why the Bill is Important S.1297 – Let Doctors

### Please answer each question with citation and reference at least 200 words 1.How do the concepts of adverse selection and moral hazards affect financial and

Please answer each question with citation and reference at least 200 words 1.How do the concepts of adverse selection and moral hazards affect financial and labor markets? Which of these effects is t