Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
12th Edition
ISBN: 9781259144387
Author: Richard A Brealey, Stewart C Myers, Franklin Allen
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 9, Problem 1SQ
(VAR.P and STDEV.P) Choose two well-known stocks and download the latest 61 months of adjusted prices from finance.yahoo.com. Calculate the monthly returns for each stock. Now find the variance and standard deviation of the returns for each stock by using VAR.P and STDEV.P. Annualize the variance by multiplying by 12 and the standard deviation by multiplying by the square root of 12.
Expert Solution & Answer
Summary Introduction
To determine: The variance and standard deviation of two stocks.
Answer to Problem 1SQ
Company AL’s variance is 0.0008497 and standard deviation is 2.91%. Company NX’s variance is 0.0014812 and standard deviation is 3.85%.
Explanation of Solution
Determine the variance and standard deviation of Company AL
Excel Spreadsheet:
Excel Workings:
Therefore the Company AL’s variance is 0.0008497 and standard deviation is 2.91%. Company NX’s variance is 0.0014812 and standard deviation is 3.85%.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Here are the percentage returns on two stocks.
Digital
Executive
Fruit
Cheese
14%
4%
Month
January
February
March
April
May
June
July
August
6
8
Variance
Standard deviation %
Digital Cheese
2
4
14
a-1. Calculate the monthly variance and standard deviation of each stock. (Do not round intermediate calculations. Round your
answers to 1 decimal places.)
-3
47.5
69X
Executive Fruit
23 2
4.8 X
Solve it correctly please. I will rate accordingly with 2-3 votes.
Calculate this please
Only typed solution
Chapter 9 Solutions
Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
Ch. 9 - (VAR.P and STDEV.P) Choose two well-known stocks...Ch. 9 - (AVERAGE, VAR.P and STDEV.P) Now calculate the...Ch. 9 - (SLOPE) Download the Standard Poors index for the...Ch. 9 - Company cost of capital Suppose a firm uses its...Ch. 9 - Prob. 2PSCh. 9 - Definitions Define the following terms: a. Cost of...Ch. 9 - Asset betas EZCUBE Corp. is 50% financed with...Ch. 9 - Prob. 6PSCh. 9 - Fudge factors John Barleycorn estimates his firms...Ch. 9 - Asset betas Which of these projects is likely to...
Ch. 9 - True/false True or false? a. The company cost of...Ch. 9 - Certainty equivalents A project has a forecasted...Ch. 9 - Company cost of capital The total market value of...Ch. 9 - Company cost of capital Nero Violins has the...Ch. 9 - Measuring risk The following table shows estimates...Ch. 9 - Company cost of capital You are given the...Ch. 9 - Measuring risk Look again at Table 9.1. This time...Ch. 9 - Prob. 16PSCh. 9 - WACC Binomial Tree Farms financing includes 5...Ch. 9 - Prob. 18PSCh. 9 - Prob. 19PSCh. 9 - Prob. 20PSCh. 9 - Certainty equivalents A project has the following...Ch. 9 - Prob. 22PSCh. 9 - Beta of costs Suppose that you are valuing a...Ch. 9 - Fudge factors An oil company executive is...
Additional Business Textbook Solutions
Find more solutions based on key concepts
Problems encountered while comparing companies based on the ratios. Introduction: Ratio establishes the relatio...
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
Whether callable bonds have a higher or lower yield than otherwise identical bonds without a call feature. Intr...
Corporate Finance (4th Edition) (Pearson Series in Finance) - Standalone book
The value of the shareholders equity account of a firm. Introduction: Shareholders’ equity refers to the residu...
Corporate Finance (The Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
CHAPTER CASE
S&S Air’s Mortgage
Mark Sexton and Todd Story, the owners of S&S Air, Inc., were impressed by the ...
Essentials of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
The current stock price. Introduction: Stock price is a price of a share on the number of saleable stock of a c...
Fundamentals of Corporate Finance
Knowledge Booster
Similar questions
- An analyst gathered daily stock returns for Feburary 1 through March 31, calculated the Fama-French factors for each day in the sample (SMBt and HMLt), and estimated the Fama-French regression model shown in Equation 6-21. The estimated coefficients were ai = 0, bi = 1.2, ci = 0.4, and di = 1.3. On April 1, the market return was 10%, the return on the SMB portfolio (rSMB) was 3.2%, and the return on the HML portfolio (rHML) was 4.8%. Using the estimated model, what was the stocks predicted return for April 1?arrow_forwardYou want to estimate the monthly alpha and beta of AXON stock, using the index model. Suppose AXON has a beta of 0.95 and a monthly alpha of 0.5 (representing half a percent). If you set up the regression model correctly, the index model equation should be (remember in index model formulas, we use R instead of r to denote excess returns): Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answer. b с d Rmarket = Rmarket = 0.5 x Rstock +0.95 Raxon 0.95 x Rstock +0.5 = 0.5 x Rmarket +0.95 Raxon = 0.95 x Rmarket +0.5arrow_forwardExample 5: Stock Price (S) = 50 Exercise Price (E) = 45 Risk-free rate (r) = 0.06 Variance (sd) = 0.2 Time in years (t) = 0.25 Using Example 5 as the base case, find the value of the call for a range of maturities say from 1 month to 12 months. Plot these values in excel.arrow_forward
- Pls answer all questions with explanations. Rounded to four decimal places. Thxarrow_forwardSuppose that the annual return for particular stock follows the same distribution every year, and that the return for any given year is independent of the returns for any prior years. Based on an analysis of the stock's annual returns over an 12 year period, it is determined that the 95% confidence interval for the stock's expected annual return is given by (-0.1724, 0.2861). Find the volatility of the stock. Use the approximation formula from Berk and DeMarzo. 38.52% 40.90% 42.09% 37.32% 39.71%arrow_forward1)Find the forecast for 2012 using the time series trend method. Period Demand 2007 200 2008 150 2009 125 2010 100 2011 50 2) Find the forecast for all possible periods N=3, using the data and the moving average method.arrow_forward
- A challenge we run into when forecasting future stock returns is that stock returns compound. So, when using historical averages to forecast the future, we need to average together the arithmetic and geometric average returns using Blume's Formula: R(T) = T GeoAvg + NT Arith Avg N-1 In this formula, N is the number of historical annual returns you are using to calculate your averages and T is the number of future annual returns you are forecasting. Suppose you gather the following prices for a stock in order to calculate the last 10 (N = 10) annual returns. The stock does not pay dividends. Time 0 1 Time 0 calculate the last 10 (N=10) annual returns. The stock does not pay dividends. 1 2 3 4 5 10 6 . 7 8 9 10 Price $23.16 $32.81 Price $23.16 $32.81 $33.63 $36.83 $41.95 $41.04 $33.83 $37.45 $30.56 $29.90 $47.93 Using Blume's formula, what is the expected return per year for the next 4 years (T = 4)? Enter your answer as a percentage, rounded to the nearest 0.0001. For example, for…arrow_forwardSuppose Tom invests W0=$10000W0=$10000 on a stock. The monthly return RR follows a normal distribution with mean 0.1 and variance 0.22, i.e. R∼N(0.1,0.22). Find the 95% VaR on the investment in one month.arrow_forwardCalculate the arithmetic average for the following returns: Year Return O 2.4 % O 2.2% O 3.1% O 3.4% Calculate the geometric average for the following returns: Year Return O 2.2% O 2.4% O 3.1% O 3.4% Calculate the standard deviation for the following returns: Year Return O 8.4% O 8.1% O 7.6% O 7.3% 2017 12.03% 2017 12.03% 2017 12.03% 2018 -8.24% 2018 -8.24% 2018 -8.24% 2019 1.34% 2019 1.34% 2019 1.34% 2020 4.55% 2020 4.55% 2020 4.55%arrow_forward
- Consider the following five monthly returns: 0.04 −0.03 0.03 0.07 −0.02 a. Calculate the arithmetic average monthly return over this period. b. Calculate the geometric average monthly return over this period. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period.arrow_forwardSub : Finance Please dnt use CHATGPT.Please type the answer with good and detailed explanation.Thank Youarrow_forwardPlease solve this question in 2 hours to get a thumbs uparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
