### 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

### Instructions: Due Tuesday 02/28 At least 3 paragraphs long with 3 peer-reviewed references. Where do you think sustainability reporting is heading in the

Instructions: Due Tuesday 02/28 At least 3 paragraphs long with 3 peer-reviewed references. Where do you think sustainability reporting is heading in the future? Will companies become more transparent, or is sustainability reporting going to be mostly on internal reports? How important do you think this issue is?

### Instructions: Due Tuesday 03/1 At least 2 pages long with 2 peer-reviewed references. Veronica is an intern in the Accounting Department at Kessler

Instructions: Due Tuesday 03/1 At least 2 pages long with 2 peer-reviewed references. Veronica is an intern in the Accounting Department at Kessler Industries, a manufacturer of precision medical instruments. She is anxious to make a good impression because she wants to be offered a full-time position at this company

### Instructions: Due Tuesday 03/3 At least 2 pages long with 3 peer-reviewed references. Mini Cases A14-53. Calculating

Instructions: Due Tuesday 03/3 At least 2 pages long with 3 peer-reviewed references. Mini Cases A14-53. Calculating ratios for companies within the same industry Select an industry you are interested in and select three companies within that industry. Obtain their annual reports by going to each company’s website and downloading

### Instructions: Due Tuesday 02/27 At least 3 paragraphs long with 3 peer-reviewed references. Stakeholders are frequently the reason that companies adopt

Instructions: Due Tuesday 02/27 At least 3 paragraphs long with 3 peer-reviewed references. Stakeholders are frequently the reason that companies adopt sustainable practices. Think of an organization you are familiar with. List as many stakeholders as you can think of for this organization. For each stakeholder listed, describe why that

### Discuss the financial reporting environment and financial statements. 1- What is the purpose of accounting? What impact does the AICPA, FASB, and SEC play in

Discuss the financial reporting environment and financial statements. 1- What is the purpose of accounting? What impact does the AICPA, FASB, and SEC play in accounting, particularly with regards to the financial statements? 2- why do we call accounting “the language of business”? Hint: Think in terms of the purpose

### 1. In 2010 Casey made a taxable gift of \$5.8 million to both Stephanie and Linda (a total of \$11.6 million in taxable gifts). Calculate the amount of gift tax

1. In 2010 Casey made a taxable gift of \$5.8 million to both Stephanie and Linda (a total of \$11.6 million in taxable gifts). Calculate the amount of gift tax due this year and Casey’s unused applicable credit under the following alternatives. (Refer to  Exhibit 25-1 and  Exhibit 25-2.) a. This

### Assessment Brief 1 Academic year 2023/24, SPRING Course BBA 323 TOTAL QUALITY MANAGEMENT (3 ECTS) Instructor ALEJANDRO BOUTIN /ANTONIA

Assessment Brief 1 Academic year 2023/24, SPRING Course BBA 323 TOTAL QUALITY MANAGEMENT (3 ECTS) Instructor ALEJANDRO BOUTIN /ANTONIA KOMPROGLOU Participation in all assessment activities stated in this document is required. An overall course total of 70 points is required to pass the course. Due dates and times are always

### Instructions: Due Tuesday 02/28 At least 2 pages long with 3 peer-reviewed references. You will expand your discussion of how your selected corporation

Instructions: Due Tuesday 02/28 At least 2 pages long with 3 peer-reviewed references. You will expand your discussion of how your selected corporation measures up to the industry averages both financially and ethically. Present whether your selected corporation performed above average, average, or below average. Include an explanation of why

### MODULE ASSESSMENT ASSESSMENT BRIEF FMAN3000 FASHION COMSUMER AND MARKETPLACE CREDIT VALUE: 30 Credits WORTH: 100% of module TYPE: Written

MODULE ASSESSMENT ASSESSMENT BRIEF FMAN3000 FASHION COMSUMER AND MARKETPLACE CREDIT VALUE: 30 Credits WORTH: 100% of module TYPE: Written Report 4000 words and 500 word reflective synopsis +/- 10% ASSESSORS: Claire Marsh & Karen Hickinbotham HAND IN: Week 25 Monday 18th March 2024 12pm midday via Turnitin BUYING CYCLE REPORT

### Individual Report (3000 words) Individual Essay (3000 words) Please write an essay on any one of the

Individual Report (3000 words) Individual Essay (3000 words) Please write an essay on any one of the following titles: 1. Capital is difficult for small businesses to access for several reasons. It’s not that banks are against lending to small businesses – they want to – but traditional financial institutions

### 6.1 Discussion. Inside Out Getting Started You are on the side of a mountain listening intently to a man named Jesus. You hear the

6.1 Discussion. Inside Out Getting Started You are on the side of a mountain listening intently to a man named Jesus. You hear the grumblings of the people all around you. You are fearful of an uprising. There are so many, many people here! Who is this man? What is

### Course Material Why It Matters: Control Control in the Business Setting The

Course Material Why It Matters: Control Control in the Business Setting The Control Process Levels and Types of Control The Need for a Balanced Scorecard Financial and Non-financial Controls Putting It Together: Control Total Quality Management (TQM)

### Practice1 INPUT DATA Forecasted annual sales growth 10% COGS/SALES 55% SG&A/SALES 20% DEPRECIATION/Gross PPE 8% INTEREST RATE 10% TAX

Practice1 INPUT DATA Forecasted annual sales growth 10% COGS/SALES 55% SG&A/SALES 20% DEPRECIATION/Gross PPE 8% INTEREST RATE 10% TAX RATE 35% CASH/SALES Plug ACCOUNT RECEIVABLE/SALES 35% INVENTORY/SALES 85% ACCOUNTS PAYABLE/SALES 14% OTHER CURRENT LIAB/SALES 25% GROSS PPE 70% of sales if Sales <=45000 27000+0.7(Sales-40000) if 45000< Sales <= 50000 38500+0.3(Sales-50000)

### Case Study Write-up Questions: Sears, Roebuck and Co. vs. Wal-Mart Stores, Inc. The Sears/Wal-Mart case is a good opportunity for you to dive into financial

Case Study Write-up Questions: Sears, Roebuck and Co. vs. Wal-Mart Stores, Inc. The Sears/Wal-Mart case is a good opportunity for you to dive into financial statements and begin looking closely at corporations. Put yourself in the shoes of Don Edwards, who we learn is a newly hired analyst at a

### BUS139 Pitch Deck Project For this project, students must submit a PowerPoint (PPT) presentation (not Google Slides or Key) that will serve as a pitch deck

BUS139 Pitch Deck Project For this project, students must submit a PowerPoint (PPT) presentation (not Google Slides or Key) that will serve as a pitch deck that an entrepreneur would present to potential investors. Here are your assumptions: you are an entrepreneur that is going in person to pitch to

### M&M Case Study: Break-Even Analysis This exercise provides you the opportunity to apply break-even analysis concepts and Excel skills

M&M Case Study: Break-Even Analysis This exercise provides you the opportunity to apply break-even analysis concepts and Excel skills to a case study problem. The activity continues our work with Mars Inc. M&M candies. Assignment Your company is a wholesaler of Mars candies, and you are responsible for the M&M

### Business Finance – Accounting Process Mapping Assignment

Business Finance – Accounting Process Mapping Assignment

### Discussion Question: For what type of cost would it be best to apply which of the methods of estimating cost covered in Chapter 15, and why? Provide a few

Discussion Question: For what type of cost would it be best to apply which of the methods of estimating cost covered in Chapter 15, and why? Provide a few specific examples. Essential Activities: Reading Chapter 15, sections 1-6 in Blank & Tarquin will assist you in writing this discussion forum.