Regent University Capital Asset Pricing Model Worksheet

User Generated

ZnqnzrJryyf

Business Finance

Regent University

Description

Take it to the Bank

Daryl Bank is an investment broker with Bank, Tank, & Shank a full service financial services firm serving the regional area of southern West Virginia. From the corporate offices in Beckley, Daryl manages a large number of clients throughout the southern part of the state.

Daryl is very customer service oriented and makes a personal effort to visit every client at least twice a year, even if it means traveling to his or her hometown. He usually travels to different county seats throughout the state and stays a couple of days in a local hotel so clients can visit him in these various locations. With his laptop Daryl can access account information and the latest information about traded securities using any number of software programs. His clients also enjoy seeing the demonstrations of portfolio programs for their specific accounts.

Daryl also uses these trips to visit West Virginia companies for potential investment possibilities. He likes to know the companies he invests in, and wants to get a competitive advantage in any investment decision. Since not many investment brokers are taking the time to visit some of the smaller publicly traded West Virginia companies, Daryl feels that he knows substantially more about these companies and their potential for excess returns than the general market. He is always looking for undervalued opportunities for investment purposes so that his customers can also enjoy many happy returns on their portfolios.

On a recent trip to Curveintheroad in the far southwestern part of the state, Daryl had the opportunity to visit three companies. He has been able to maintain a friendship with the top management of these companies and was given access to important financial data, which he planned to use to determine stock valuation.

The first company is Dig Deep, a regional coal mining company. They have been in operation for over 20 years and have the mining rights to over 100 square miles of land. Most of the coal they mine is the more clean burning anthracite coal. Even though they are a relatively small, company, they possess modern equipment and a very efficient mining operation.

The stock price for Dig Deep was $32 on January 1, 20x0, $36 on December 31, 20x0, $33 for 12/31/x1, $35 for 12/31/x2, $42 for 12/31/x3 and $44 for 12/31/x4. In the year 20x0 they paid a

dividend of $1.00, the same for 20x1, $1.10 in 20x2, $1.25 in 20x3 and that amount again in 20x4. The standard deviation for their stock is 6%, beta is 0.80, and correlation coefficient is .60.

The second company is Moon Shine, a regional medicinal spirits company. This company got its start about 75 years ago and has been very successful establishing a niche market in all natural herbal remedies. What makes this company especially appealing to Daryl is its ability to do well during times when the general economy is in a depression or recession.

The stock price for Moon Shine was $14 on January 1, 20x0, $18 on December 31, 20x0, $15 for 12/31/x1, $22 for 12/31/x2, $32 for 12/31/x3 and $28 for 12/31/x4. The company does not pay a dividend. The standard deviation for their stock is 14%, beta is 1.25, and correlation coefficient is -0.30.

Finally Daryl met the management team at Pork, Byrd and Belly. In spite of the name, this was not an agricultural company, but a heavy construction company with major government contracts for roads and bridges. The company has had some very successful contracts in the past which have led to great growth, but their rate of growth has slowed a little in the last couple of years.

The stock price for Pork, Byrd and Belly was $10 on January 1, 20x0, $15 on December 31, 20x0, $25 for 12/31/x1, $30 for 12/31/x2, $28 for 12/31/x3 and $25 for 12/31/x4. In the year 20x0 they paid a dividend of $0.80, $0.90 in 20x1, $1.20 in 20x2, $0.50 in 20x3 and that amount again in 20x4. The standard deviation for their stock is 20%, beta is 1.05, and correlation coefficient is .45.

Since these are all small regional companies, Daryl uses the Russell 4000 index as a measure of the market standard. He likes to compare the performance of his companies against this index along with other criteria to determine if a company stock price offers a good value.

The index price for the Russell 4000 was 1200 on January 1, 20x0, 1400 on December 31, 20x0, 1800 for 12/31/x1, 1750 for 12/31/x2, 1600 for 12/31/x3 and 1700 for 12/31/x4. The standard deviation for the index is 5%, beta is 1.0, and correlation coefficient is 1.00. Currently the rate of return on a Treasury bill is 5.0%.

Required:

  1. (20 points) Compute the annual holding period return for each of the stocks, and also for the market for each of 20x0, 20x1, 20x2, 20x3, 20x4, and then also a return for the total 5 year period of time.
  2. (20 points) Use the Capital Asset Pricing Model to compute the expected return for the five year period for each stock, and the market. Assume the expected return on the market is 8.0%
  3. (10 points) Compute the coefficient of variation for each stock and the market for the total 5 year period from 20x0 to 20x4. Use the effective annual rate of return (EAR) for a measure of a stock’s average return.
  4. (10 points) Determine whether Daryl should buy or sell any of the stocks based on your quantitative analysis.
  5. (20 points) Are there other issues Daryl should consider before buying any of the stocks, or buying a market index?
  6. (20 points) Briefly research a definition of insider trading, and SEC regulation fair disclosure (‘reg FD’) https://www.sec.gov/fast- answers/answers-regfdhtm.html. How are reg FD or Insider Trading issues relevant for what Daryl does to gather investment information, if at all?

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey, am through. find attached and feel free to seek clarification. Thanks

Stock
Intel

Year

Beginning Price
2010
2011
2012
2013
2014

Dividend
25.50
28.37
33.46
49.66
43.03

1.00
1.04
1.20
1.26
1.32
5.82

32
36
33
35
42

1
1
1.1
1.25
1.25
5.6

10
15
25
30
28

0.8
0.9
1.2
0.5
0.5
3.9

14
18
15
22
32

0
0
0
0
0
0

5 Year HPR
5 Year HPR per Year
5 Year EAR
5 Year Converted EAR
Repeat for Each Stock or Index, across all years.
Dig Deep
2010
2011
2012
2013
2014
5 Year HPR
5 Year HPR per Year
5 Year EAR
Pork, Byrd & Belly

2010
2011
2012
2013
2014
5 Year HPR
5 Year HPR per Year
5 Year EAR

Moon Shine
2010
2011
2012
2013
2014
5 Year HPR
5 Year HPR per Year
5 Year EAR
Market Index (Russell 4000)

2010
2011
2012
2013
2014

1200
1400
1800
1750
1600

5 Year HPR
5 Year HPR per Year
5 Year EAR

Capital Asset Pricing Model
E(R) = Rf + Beta*(Rm - Rf)
Rf
Rm
Dig Deep E(R)?
Beta
Standard Dev
Corr Coeff

5%
8%
7.4%
0.80
6%
0.60

Expected Return For Dig Deep:

Rf
Rm
moon shine E(R)?
Beta
Standard Dev
Corr Coeff

7.40%

5%
8%
8.8%
1.25
14%
-0.30

Expecte...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags