Corperate Finance Midterm Practice Questions

If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we now have a high and low PE ratio for each year. We can use these ratios to calculate a high and a low stock price for the next year. Suppose we have the following information on a particular company: Year 1 Year 2 Year 3 Year 4 High $87.93 $100.35 $121.89 $133.60 Low price 69.85 83.19 79.99 110.18 EPS 6.54 8.96 8.62 10.21 Earnings are expected to grow at 5.5 percent over the next year. a. What is the high target stock price over the next year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the low target stock price over the next year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. High target price b. Low target price price

You ran a regression of the excess return on Walmart's stock on the excess return on the market. You found the following: alpha=1.5%, beta-2.818, R^2=0.623. If Walmart's total volatility was 0.310 in that same period, what must have been the markets volatility in that same period.

If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we now have a high and low PE ratio for each year. We can use these ratios to calculate a high and a low stock price for the next year. Suppose we have the following information on a particular company: High price Low price EPS Year 1 $89.09 70.61 6.58 Year 1 Year 2 Year 3 Year 4 Year 2 $103.03 84.91 9.00 High PE Earnings are projected to grow at 8 percent over the next year. What are the high and low PE ratios for each year? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Year 3 $124.81 77.87 8.66 Low PE Year 4 $136.36 112.34 10.25

Using the data in the table:, a. What was the average annual return of Microsoft stock from 2005-2017? b. What was the annual volatility for Microsoft stock from 2005-2017? a. What was the average annual return of Microsoft stock from 2005-2017? The average annual return is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Realized Return for the S&P 500, Microsoft, and Treasury Bills, 2005-2017 S&P 500 Realized Return Microsoft Realized Return Dividends Paid* Year End 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 S&P 500 Index 1211.92 1248.29 3.00% 4.80% 1418.30 1468.36 903.25 4.70% 1.50% 0.10% 0.10% 1115.10 1257.64 1257.61 0.00% 1426.19 0.10% 1848.36 0.00% 0.00% 2058.90 2043.94 0.00% 0.20% 2238.83 2673.61 0.80% *Total dividends paid by the 500 stocks in the portfolio, based on the number of shares of each stock in the index, adjusted until the end of the year, assuming they were…

1.)  Given this return data, the average realized return on Happy Dog Soap Inc.’s stock is   _______ . 2.)  The preceding data series represents a sample of Happy Dog’s historical returns. Based on this conclusion, the standard deviation of Happy Dog’s historical returns is  _______  . 3.)  If investors expect the average realized return on Happy Dog Soap Inc.’s stock from 2016 to 2020 to continue into the future, its expected coefficient of variation (CV) is expected to equal  _______  .

If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we now have a high and low PE ratio for each year. We can use these ratios to calculate a high and a low stock price for the next year. Suppose we have the following information on a particular company: High price. Low price EPS Year 1 $ 86.77 69.09 6.50 Year 2 Year 3 $97.67 $118.97 81.47 8.92 82.11 8.58 Year 4 $130.84 108.02 10.17 Earnings are expected to grow at 8 percent over the next year. a. What is the high target stock price over the next year? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. What is the low target stock price over the next year? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. > Answer is complete but not entirely correct. a. High target price $ 136.23 b. Low target price $ 101.58

If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we now have a high and low PE ratio for each year. We can use these ratios to calculate a high and a low stock price for the next year. Suppose we have the following information on a particular company over the past four years:     Year 1 Year 2 Year 3 Year 4 High price $ 99.70 $ 123.30 $ 132.70 $ 149.33 Low price 74.53 90.64 71.32 117.85 EPS 8.98 10.73 11.81 13.20   Earnings are projected to grow at 9 percent over the next year.   a. What is your high target stock price over the next year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is your low target stock price over the next year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future results. Analysts across companies use realized stock returns to estimate the risk of a stock. Five years of realized returns for Celestial Crane Cosmetics Inc. (Crane Cosmetics) are given in the following table:   2012 2013 2014 2015 2016 Stock return 23.75% 16.15% 28.50% 39.90% 12.35%   Also note that: 1. While Crane Cosmetics was started 40 years ago, its common stock has been publicly traded for the past 25 years. 2. The returns on Crane Cosmetics's equity are calculated as arithmetic returns.   Given this return data, the average realized return on Celestial Crane Cosmetics Inc.’s stock is    .   The preceding data series represents    of Crane Cosmetics’s historical returns. Based on this conclusion, the standard deviation of Crane Cosmetics’s historical returns is    .   If investors expect the…

1.) Given this return data, the average realized return on Blue Llama Mining Inc.’s stock is  _______  . 2.) The preceding data series represents a sample of Blue Llama’s historical returns. Based on this conclusion, the standard deviation of Blue Llama’s historical returns is  _______  . 3.)  If investors expect the average realized return on Blue Llama Mining Inc.’s stock from 2016 to 2020 to continue into the future, its expected coefficient of variation (CV) is expected to equal  _______  .

A security analyst has regressed the monthly returns on Exxon Mobil equity shares over the past five years against those on the Standard & Poor's 500 stock index over the same period. The resulting regression equation is rEM = 0.08 + 1.44 rSP. Use this equation to estimate Exxon Mobil's equity beta.

You want to check if GRBH stock is fairly priced in the markets by using the fundamental analysis. For this purpose, you have gathered the following information: GRBH pays dividends once a year and the next dividend payment is expected to be made in one year. You project the EPS of the first and second year to be $5 and $7 respectively. The company dividend payout ratio is stable at 0.2. At the end of the second year, you assume that the company would become the average company in the industry. The industry average PE ratio is 8. You believe that the appropriate required rate of return on GRBH stock is 10% (CCR per annum). And the current market price of GRBH stock is $45.  ind the present value of GRBH stock based on the information above. Is the stock over- or under-priced?

You want to check if GRBH stock is fairly priced in the markets by using the fundamental analysis. For this purpose, you have gathered the following information: GRBH pays dividends once a year and the next dividend payment is expected to be made in one year. You project the EPS of the first and second year to be $5 and $7 respectively. The company dividend payout ratio is stable at 0.2. At the end of the second year, you assume that the company would become the average company in the industry. The industry average PE ratio is 8. You believe that the appropriate required rate of return on GRBH stock is 10% (CCR per annum). And the current market price of GRBH stock is $45   Find the alpha ( Expected abnormal rate of return, c ) assuming the mispriced figure would be corrected in a year.

The following table, contains beta coefficient estimates for six firms. Calculate the expected increase in the value of each firm's shares if the market portfolio were to increase by 10 percent. Perform the same calculation where the market drops by 10 percent. Which set of firms has the most variable or volatile stock returns? Input the expected increase in the value of each firm's shares if the market portfolio were to increase by 10%. (Round each answer to two decimal places.) Company Apple Inc. (AAPL) Dell Inc. (DELL) Hewlett Packard (HPQ) American Electric Power Co. (AEP) Duke Energy Corp. (DUK) Centerpoint Energy (CNP) Microsoft Money Central (MSN.com) Beta Estimate Computers and Software 2.66 1.81 1.49 Utilities 0.74 0.49 0.82 Expected Increase % % % % % %

How to solve this in excel?

Assume these are the stock market and Treasury bill returns for a 5-year period: Year 2013 Stock Market Return () 31.7 T-Bill Return () 0.02 0.02 2014 2015 2016 10.9 -1.6 13.0 21.3 0.02 0.20 0.80 2017 Required: a. What was the risk premium on common stock in each year? (Negative values should be entered with a negative sign.) b. What was the average risk premium? c. What was the standard deviation of the risk premium? (Ignore that the estimation is from a sample of data.) Complete this question by entering your answers in the tabs below. Required A Required B Required C What was the average risk premium? (Do not round intermediate calculations. Enter vour answer as a percent rounded to 2 a o search

Spike earned an average return of 14.6 percent on his investments over the past 20 years while the S&P 500, a measure of the overall market, only returned an average of 13.9 percent. Explain how this can occur if the stock market is efficient.

Please include the excel formula You’ve observed the following returns on Pine Computer’s stock over the past five years: 8 percent, −12 percent, 14 percent, 21 percent, and 16 percent. Suppose the average inflation rate over this period was 3.1 percent and the average T-bill rate over the period was 3.9 percent. What was the average real return on the company’s stock? What was the average nominal risk premium on the company’s stock over this period?  Input area:                                   Year Returns               1 8%               2 -12%               3 14%               4 21%               5 16%               Average inflation 3.10%               Average T-bill rate 3.90%                                 (Use cells A6 to B13 from the given information to complete this question. You must use the built-in Excel function to answer this question. Make sure to use the “sample” Excel formula.)…

If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we now have a high and a low stock price for the next year. Suppose we have the following information on a particular company over the past four years. High price Low price EPS Year 1 $ 28.63 21.06 1.67 Year 2 $ 27.52 21.38 1.80 High target stock price b. Low target stock price Year 3 $31.62 26.85 1.93 Earnings are projected to grow at 9% over the next year. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Year 4 $38.21 27.61 2.27 a. What is your high target stock price over the next year? b. What is your low target stock price over the next year? DHE TE AUS

You are building out your 1 x 3 point and figure chart that is currently in a column of X's with the last X at $17. When you look at the high, low, close data for today you see that the high was $17.99 and the low was $14.01. The stock closed at $15.01. What do you add to the chart for today? a. A new trend line b. You add noting to the chart c. A new column of O's to the $15 level d. A new X at $18

Please help!

Each stock's rate of return in a given year consists of a dividend yield (which might be zero) plus a capital gains yield (which could be positive, negative, or zero). Such returns are calculated for all the stocks in the S&P 500. A weighted average of those returns, using each stock's total market value, is then calculated, and that average return is often used as an indicator of the "return on the market."