Financial ManagementSpring 2014Assignment 490 points1. The returns on a stock for the last 5 years have been 25%, 6%, -11%, 2%, and -20%.a. Assuming that you purchased the stock for $31.50 five years ago and that allreturns have come in the form of either capital gains or losses (i.e., there havebeen no dividends), what is the price of the stock today? (3 points)b. Compute the average (arithmetic) return. (3 points)c. Compute the geometric average return. (3 points)d. What is the yearly return standard deviation? (3 points)2. The following describes the probability distribution of future returns for 2 stocks:State of the EconomyHigh growthLow growthNo growthRecessionProbability.15.20.40.25Stock A return30%13%6%-5%Stock B return10%8%4%-2%The beta of stock A is 1.3 and the beta of stock B is 0.4.a. Compute the expected return and standard deviation for both stocks. (3 points)b. Compute the expected return, standard deviation, and beta of a portfolioconsisting of 50% in stock A and 50% in stock B. (6 points)c. Which risk measure is more appropriate for determining a stockâs contribution tothe riskiness of a well-diversified portfolio, its return standard deviation, or itsbeta? Clearly explain your reasoning (3 points)To answer Question 3, you need to download the spreadsheet with stock price data fromthe âassignmentâ section of lesson 7 in Angel. This file contains monthly stock prices,dividends, and stock split information for Advanced Micro Devices, Green MountainCoffee Roasters, and UnitedHealth Group for the period spanning from December 2008through December 2013. For each company, there are 61 monthly closing prices, fromwhich you will be able to calculate 60 months of stock returns.3. Calculate the monthly returns for each of the stocks:a. Calculate the arithmetic average monthly return for each stock. (3 points)b. Calculate the geometric average monthly return for each stock. (3 points)c. Calculate the monthly return standard deviation for each stock. (3 points)d. Calculate the total percentage return (this would be what is referred to in the textas the holding period return) for each stock based on purchasing a share at the endof December 2008 and holding it through the end of December 2013. In your calculations assume that any dividends are reinvested immediately in the stockrather than being stuffed under a mattress where they would earn no furtherreturns. (3 points)e. If you constructed a portfolio at the end of December 2008 consisting of 50 sharesof each of the stocks and held this portfolio through the end of December 2013(once again, reinvesting all dividends), what would be the total percentage return(holding period return) on the portfolio? What would the portfolioâs geometricaverage monthly return be? (3 points)To answer questions 4 through 6, you will to access the tab labeled âstock return datafor Q4-6â in the previously downloaded spreadsheet. The tab contains monthly stockreturns for Polaris Industries (PII), Emmis Communications (EMMS), and Johnson &Johnson (JNJ), for the months from January 2009 through December 2013, along withmonthly stock returns for the S&P Composite Index over the same period.4. a. Using the returns on the S&P 500 Composite Index as the proxy for the overallstock market return, estimate a beta for each stock listed above in Excel. Report thebetas and comment on your level of confidence in each of the beta estimates given thesignificance level (p-values) of the t-statistics for the beta estimates in the regressionmodels. Clearly demonstrate your understanding of beta calculations and statisticalestimates. (15 points)b. What beta estimates do you find at Yahoo Finance (the links below)? Why mightthe beta estimates from Yahoo Finance differ from the beta estimates that youcalculated? (3 points)http://finance.yahoo.com/q/ks?s=PIIhttp://finance.yahoo.com/q/ks?s=EMMShttp://finance.yahoo.com/q/ks?s=JNJ5. Which of the three stocks (PII, EMMS, and JNJ) has the most total risk if held inisolation? Clearly convey what measure you used to identify the amount of risk of astock held in isolation. (3 points)6. Which of the three stocks (PII, EMMS, and JNJ) has the most systematic risk?Clearly convey what measure you used to identify the amount of systematic risk. (3points)7. a. Based on the following beta estimates, what would be the portfolio beta for aportfolio invested as follows? (3 points)2nd National BankChesapeake EnergyPentairPegasusSodastreamPortfolioWeights20%15%30%15%20%100%Beta0.50.60.90.51.6b. Based on the Beta estimates in part a, a Treasury bond rate of 2.97% and anexpected market risk premium of 7%, what would be the expected return on theportfolio described in part a (assuming the stocks are fairly priced based on theCAPM)? (3 points)8. Vaughn Manufacturing (VM) has 720 bonds outstanding with a 5.75 percent couponrate (semi-annual coupon payments) and 15 years left to maturity. The bonds sell for$927.50. VMâs common stock has a beta of 1.24. The 10-year Treasury-Bond rate iscurrently 2.75 percent, and historically, the market has earned 7% more per year thanthe 10-year Treasury rate. The firm has 147,000 shares of common stock outstandingat a market price of $21.50 a share (book value of $9 per share). There are 40,000shares of preferred stock outstanding at a market price of $30 a share (book value of$40 per share). The preferred stock pays a $2.50 annual dividend. The companyâsmarginal tax rate is 38 percent.a.b.c.d.What is the after-tax cost of debt? (3 points)What is the cost of preferred stock? (3 points)What is the cost of common stock? (3 points)What is the weighted average cost of capital for Vaughn Manufacturing? (3points)9. SL Jones Corporation, an all equity-financed company, has traditionally employed afirm wide discount rate for capital budgeting purposes. However, its two divisions âpublishing and entertainment, have different degrees of risk given by ÃP = 1.0, ÃE =2.0, and the beta for the overall firm is 1.3. Use 6% as the risk-free rate and 12% asthe expected return on the market. The firm is considering the following capitalexpenditures:PublishingEntertainmentProposed ProjectP1P2P3Initial Investment$1M$3M$2MIRR.130.121.090E1E2E3$4M$6M$5M.160.170.140a. Which projects would the firm accept if it uses the opportunity cost of capital forthe entire company? (3 points)b. Which projects would it accept if it estimates cost of capital separately for eachdivision? (3 points)c. If SL Jones Corporation only uses the cost of capital for the entire firm, what willhappen to the riskiness of the firm, compared to using the appropriate divisionalcost of capital? (3 points)