1. (20 points) a. Compute and show the annual holding period return for each of the stocks, and also for the market for each of 20x0, 20x1, 20x2, 20x3, 20x4. b. compute and show a total return...

1 answer below »
1. (20 points) a. Compute and show the annual holding period return for each of the stocks, and also for the market for each of 20x0, 20x1, 20x2, 20x3, 20x4. b. compute and show a total return including dividends, for each stock for the entire 5 year period of time. c. Convert the 5-year total return into an annual simple average return, and into an effective annual rate (EAR) compound return. 2. (20 points) Use the Capital Asset Pricing Model to compute the expected return for each stock, and the market. Assume the expected return on the market (”Rm”) is 7.0% 3. (10 points) Compute the coefficient of variation (“cv”) 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. The cv indicates the amount of risk incurred on an investment, per unit of 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/fastanswers/answers-regfdhtm.html. How are reg FD or Insider Trading issues relevant for what Daryl does to gather investment information, if at all?


Case 12-3 Take it to the Bank 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 (stock ticker “DD”), 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 DD was $32 on January 1, 20x0, $35 on December 31, 20x0, $31 for 12/31/x1, $36 for 12/31/x2, $40 for 12/31/x3 and $41 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 5%, beta is 0.75, and correlation coefficient is .60. The second company is Moon Shine, a regional naturopathic medicine company (stock ticker “MS”). MS 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 $10 on January 1, 20x0, $18 on December 31, 20x0, $13 for 12/31/x1, $21 for 12/31/x2, $35 for 12/31/x3 and $32 for 12/31/x4. The company does not pay a dividend. The standard deviation for their stock is 19%, beta is 1.70, 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 and infrastructure engineering 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 $15 on January 1, 20x0, $22 on December 31, 20x0, $40 for 12/31/x1, $38 for 12/31/x2, $37 for 12/31/x3 and $32 for 12/31/x4. In the year 20x0 they paid a dividend of $0.80, $1.50 in 20x1, $1.50 in 20x2, $0.50 in 20x3 and that amount again in 20x4. The standard deviation for their stock is 15%, beta is 1.25, 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 Treasury bill is 1.25%. Required: 1. (20 points) a. Compute and show the annual holding period return for each of the stocks, and also for the market for each of 20x0, 20x1, 20x2, 20x3, 20x4. b. compute and show a total return including dividends, for each stock for the entire 5 year period of time. c. Convert the 5-year total return into an annual simple average return, and into an effective annual rate (EAR) compound return. 2. (20 points) Use the Capital Asset Pricing Model to compute the expected return for each stock, and the market. Assume the expected return on the market (”Rm”) is 7.0% 3. (10 points) Compute the coefficient of variation (“cv”) 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. The cv indicates the amount of risk incurred on an investment, per unit of 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? https://www.sec.gov/fast-answers/answers-regfdhtm.html https://www.sec.gov/fast-answers/answers-regfdhtm.html
Answered Same DayApr 02, 2023

Answer To: 1. (20 points) a. Compute and show the annual holding period return for each of the stocks, and also...

Prince answered on Apr 03 2023
22 Votes
Answer 1 (Calculations in attached excel):
    Stock
    Year
    Beginning Price
    Dividend
    Ending Price
    Holding Period Return
    DD
    2010
    $32.00
    $1.00
    $35.00
    12.50%
     
    2011
    $35.00
    $1.00
    $31.00

    -8.57%
     
    2012
    $31.00
    $1.10
    $36.00
    19.68%
     
    2013
    $36.00
    $1.25
    $40.00
    14.58%
     
    2014
    $40.00
    $1.25
    $41.00
    5.63%
     
     
    5 Year HPR
     
     
    45.63%
     
     
    Annual Return
     
     
    9.13%
     
     
    EAR
     
     
    7.807%
    
    
    
    
    
    
    Stock
    Year
    Beginning Price
    Dividend
    Ending Price
    Holding Period Return
    MS
    2010
    $10.00
    $0.00
    $18.00
    80.00%
     
    2011
    $18.00
    $0.00
    $13.00
    -27.78%
     
    2012
    $13.00
    $0.00
    $21.00
    61.54%
     
    2013
    $21.00
    $0.00
    $35.00
    66.67%
     
    2014
    $35.00
    $0.00
    $32.00
    -8.57%
     
     
    5 Year HPR
     
     
    220.00%
     
     
    Annual Return
     
     
    44.00%
     
     
    EAR
     
     
    26.191%
    
    
    
    
    
    
    Stock
    Year
    Beginning Price
    Dividend
    Ending Price
    Holding Period Return
    PBB
    2010
    $15.00
    $0.80
    $22.00
    52.00%
     
    2011
    $22.00
    $1.50
    $40.00
    88.64%
     
    2012
    $40.00
    $1.50
    $38.00
    -1.25%
     
    2013
    $38.00
    $0.50
    $37.00
    -1.32%
     
    2014
    $37.00
    $0.50
    $32.00
    -12.16%
     
     
    5 Year HPR
     
     
    145.33%
     
     
    Annual Return
     
     
    29.07%
     
     
    EAR
     
     
    19.661%
    
    
    
    
    
    
    
    
    
    
    
    
    Stock
    Year
    Beginning Price
    Dividend
    Ending Price
    Holding Period Return
    Market
    2010
    $1,200.00
     
    $1,400.00
    16.67%
     
    2011
    $1,400.00
     
    $1,800.00
    28.57%
     
    2012
    $1,800.00
     
    $1,750.00
    -2.78%
     
    2013
    $1,750.00
     
    $1,600.00
    -8.57%
     
    2014
    $1,600.00
     
    $1,700.00
    6.25%
     
     
    5 Year HPR
     
     
    41.67%
     
     
    Annual Return
     
     
    8.33%
     
     
    EAR
     
     
    7.215%
Answer 2(Calculations in attached excel):
    CAPM Formula
     
    E(R) = Rf + Beta*(Rm - Rf)
     
    Rf
    1.25%
    Rm
    7%
     
     
    Company - DD
     
    Beta
    0.75
    E ( R )
    5.5625%
     
     
    Company - MS
     
    Beta
    1.7
    E ( R )
    11.0250%
     
     
    Company - PBB
     
    Beta
    1.25
    E ( R...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here