Using the data in the following table,, estimate the:a. Average return and volatility for each stock.b. Covariance between the stocks.c. Correlation between these two stocks.a. Estimate the average return and volatility for each stock.The average return of stock A is%. (Round to two decimal places.)Data table(Click on the following icon in order to copy its contents into a spreadsheet.)YearStock A201020112012201320142015- 1%6%2%-5%4%6%Stock B20%9%8%-3%- 5%21%PrintDone☑Clear

Given Data: YearStock AStock B2010-1%20%20116%9%20122%8%2013-5%-3%20144%-5%20156%21%

a. Average return and volatility 5. Covariance between the sto C. Correlation between these tw ■. Estimate the average return The average return of stock Ai Data table (Click on the following ice Year Stock A 201 - 1 Stock B 20

a. Average return and volatility 5. Covariance between the sto C. Correlation between these tw ■. Estimate the average return The average return of stock Ai Data table (Click on the following ice Year Stock A 201 - 1 Stock B 20

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 2MAD

See similar textbooks

Related questions

Q: Wontaby Ltd. is extending its credit terms from 30 to 45 days. Sales are expected to increase from…

A: Annual financing cost is the annual expense of borrowing funds that the company incurs on a periodic…

Q: You expect to enroll in a four-year medical school six years from today, and you are planning…

Q: One retailer charges $1038 for a certain computer. A firm of tax accountants buys 7 of these…

A: Cost per computer: $1038Number of computers purchased: 7Down payment: $1300Interest rate: 12%Number…

Q: Start - Up Industries is a new firm that has raised $210 million by selling shares of stock.…

A: Market value to book value ratio refers to the ratio which shows the comparison between the market…

Q: A corporate bond has 23 years to maturity, a face value of $1,000, a coupon rate of 5.5% and pays…

A: The value of a bond is the current market price, determined by discounting all future cash flows…

Q: Esfandairi Enterprises is considering a new three-year expansion project that requires an initial…

A: Operating cash flows are the net cash brought in with daily operations.Depreciation is a systematic…

Q: At the end of each of the next 8 years, you planto put $25,000 of your annual salary in thebank. If…

A: The objective of this question is to calculate the present value of the planned savings stream and…

Q: what is the aftertax salvage value of the asset? (MACRS schedule) (Do not round intermediate…

A: The after-tax salvage value is finding the amount you will receive for selling something after you…

Q: If the annual interest rate is 2%, what is the present value of this opportunity?

A: The present value assists in determining the current value of a future sum of money. It accounts for…

Q: Average Rate of Return The following data are accumulated by Watershed Inc. in evaluating two…

A: Average rate of return:-It is the average annual return (profit) from an investment. The ARR is…

Q: Compute the total and annual returns on the described investment. Four years after buying 50 shares…

A: Therefore, the total return on the investment is $1300, and the annualized return is approximately…

Q: For firms that have debt on their balance sheets, interest expense is commonly seen as an expense on…

A: The correct answer is:A) Because the cost of debt is already included in the WACC, and including…

Q: Suppose that Lena, who has an account at SunTrust Bank, writes a check for $140 to Jose, who has an…

A: Assets : Reserves = -$140Liabilities : Chekable deposits = -$140

Q: Suppose you observe that 90-day interest rate across the eurozone is 5%, while the interest rate in…

Q: a. What is the NPV of the project? (Do not round intermediate calculations and round your answer to…

A: The net present value is the amount that an investment will profit or lose in current dollars. It…

Q: You are the financial analyst for a tennis racket manufacturer. The company is considering using a…

A: Life of project = 5 yearsDiscount rate = 14%Tax rate = 21%To find: NPV of the project under all 3…

Q: Rust Industrial Systems Company is trying to decide between two different conveyor belt systems.…

A: Net Present Value is used to evaluate the investment and financing decisions that involve cash flows…

Q: A proposed cost-saving device has an installed cost of $730,000. The device will be used in a…

A: Step 1: Calculate Annual Depreciation using MACRSYearMACRS Rate (%)Depreciation…

Q: Sarasota Inc. has a project that requires a $50,400 after-tax initial investment and produces these…

A: Net Present Value (NPV) difference between the present values of the future cash flows and the…

Q: Problem 9-11 Calculating Project Cash Flow from Assets [LO 2] Esfandairi Enterprises is considering…

A: NPV net present value refers to the capital budgeting technique helps to evaluate the feasibility…

Q: A firm can lease a truck for 5 years at a cost of $49,000 annually. It can instead buy a truck at a…

A: When the assets under consideration have different lives or different cash flow structures, the NPV…

Q: Consider a 30-year bond with a 10% coupon rate (annual payments) and a $100 face va the initial…

A: The objective of this question is to calculate the initial price of a bond given its coupon rate,…

Q: Consider the following information: State of Economy Probability of State of Economy Boom Bust .67…

A: Expected Return assesses the average gains anticipated from a portfolio. Variance gauges the level…

Q: The common stock of the P.U.T.T. Corporation has been trading in a narrow price range for the past…

A: Part A: Price of a 6-month Put Option To find the price of a 6-month put option using the…

Q: Problem 2-7 Answer the following questions based on the information in the table. Assume a tax rate…

A: The return on equity is the financial ratio that evaluates the return of the company relative the…

Q: Xenia has had access to credit since she was 17 because her parents made her an authorized user on…

A: A credit card score, or credit score as it is more widely called, is a number that indicates a…

Q: You bought an artwork 28 years ago, the current estimated price is $17,601, which reflects an annual…

A: Time = t = 28Current Price of Artwork = $17,601Rate of Return = r = 8%

Q: You want to borrow $36,832. You must repay the loan in 6 years in equal monthly payments and a…

Q: a. Complete the below tables to calculate NPV. b. Should it operate the new business directly or…

A: The net present value is a useful tool for determining the value of an investment. It looks at the…

Q: Bayou Okra Farms just paid a dividend of $3.60 on its stock. The growth rate individends is expected…

A: The objective of the question is to calculate the current share price of Bayou Okra Farms given the…

Q: Where did you find the formlulas for this solution?

A: Here,CurrentDividend is $1.50Stock Price is $9.50 per ShareGrowth rate is 3%Cost of Loan is…

Q: Suppose that the index model for stocks A and B is estimated from excess returns with the following…

A: ParticularsStock AStock BBeta1.201.50R-square0.250.15σM16%Weight0.700.30

Q: You are considering a new product launch. The project will cost $2,375,000, have a year life, and…

A: Net Present Value is used to evaluate the investment and financing decisions that involve cash flows…

Q: Under the NBA deferred compensation plan, payments made at the end of each year accumulate up to…

A: Time value of money is a financial concept which is used to analyze various investments and…

Q: beatrice invest 1350 $ in an account that pays 4 percent simple interest how much more could she…

A: Simple interest future balance and compound interest future balance are calculated using the…

Q: a. Compute the cost of capital for the individual components in the capital structure. Note: Do not…

A: The weighted average cost of capital is similar to calculating the average cost of all the capital…

Q: Atlantic corporations ebit 440 debt 290 equity 960 Pacific corporation ebit 520 debt 1540 equity 370

A: To analyze the financial position of Atlantic Corporation and Pacific Corporation using the provided…

Q: explain me with the steps, computations and the manual formulas !! how to get the results in the…

A: The objective of this question is to understand the calculations involved in a defined benefit…

Q: You estimate that a 1-year zero-coupon bond (face value = $1000) has a probability of default equal…

A: A zero ccoupon bond is a bond that does not pay any coupons. Rather there bonds are issued at…

Q: You find the following Treasury bond quotes. To calculate the number of years until maturity, assume…

A: A bond is a fixed-income capital market security that offers the lenders a fixed set of periodic…

Q: Langford ��. issued 14 -year bonds a year ago at a coupon fate of 7.2%. The bonds make semiannual…

A: The objective of this question is to calculate the current price of a bond issued by Langford Co.…

Q: Ray Dolby started Dolby Laboratories and since then has been a leader in the entertainment industry…

A: To find the midpoint of the price range, we add $13.5 and $15.5 and then divide the sum by 2,…

Q: QUESTION 2 The following table contains data on the returns of stock A and stock B from 2021 to…

A: YearsStock AStock B202161320228102023101420241211

Q: Find the EAR in each of the following cases. Note: Do not round intermediate calculations and enter…

A: An effective annual rate of interest or E.A.R. is the interest which is earned in real times over a…

Q: Mittuch Corp. is evaluating a project with the following cash flows. The company uses a discount…

A: YearCash flow0 $ -15,900.001 $ 7,000.002 $ 8,200.003 $ 7,800.004 $ 6,600.005 $…

Q: Consider the following table: Scenario Severe recession Mild recession Normal growth Boom Required:…

A: Given values:To find: Mean return, variance of stock fund, and covariance between stock and bond…

Q: Compute the FCF for years 1 through 7 8. Compute the NPV and IRR 9. Should the project be…

A: The procedures supplied must be followed in order to solve this issue, and the information provided…

Q: YYou expect your retirement fund to be able to afford $40,000 a year, adjusted for 3% annual growth…

A: Payment = p = $40,000Growth Rate = g = 3%Time = t = 20Rate of Return = r = 10%

Q: Fifty cities provided information on vacancy rates (in %) in local apartments in the following…

A: Part (a-1)Vacancy Rate (%)Frequency0 ≤ x < 3193 ≤ x < 6156 ≤ x < 979 ≤ x < 12512 ≤ x…

Q: Consider the characteristics of the following three stocks: Expected Return Standard Deviation Thumb…

A: A trade-off is when a person chooses to forego one thing in favor of another. Making a decision…

Question

Using the data in the following table,, estimate the:
a. Average return and volatility for each stock.
b. Covariance between the stocks.
c. Correlation between these two stocks.
a. Estimate the average return and volatility for each stock.
The average return of stock A is
%. (Round to two decimal places.)
Data table
(Click on the following icon in order to copy its contents into a spreadsheet.)
Year
Stock A
2010
2011
2012
2013
2014
2015
- 1%
6%
2%
-5%
4%
6%
Stock B
20%
9%
8%
-3%
- 5%
21%
Print
Done
☑
Clear

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Defining the variables

VIEW

Step 2: Calculation of Average Return, Volatility, Covariance, Correlation

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

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?
The scatter chart in the following figure was created using sample data for profits and market capitalizations from a sample of firms in the Fortune 500. a. Discuss what the scatter chart indicates about the relationship between profits and market capitalization? b. The data used to produce this are contained in the file Fortune500. Calculate the covariance between profits and market capitalization. Discuss what the covariance indicates about the relationship between profits and market capitalization? c. Calculate the correlation coefficient between profits and market capitalization. What does the correlations coefficient indicate about the relationship between profits and market capitalization?
The file Fortune500 contains data for profits and market capitalizations from a recent sample of firms in the Fortune 500 a. Prepare a scatter diagram to show the relationship between the variables Market Capitalization and Profit in which Market Capitalization is on the vertical axis and Profit is on the horizontal axis. Comment on any relationship between the variables. b. Create a trendline for the relationship between Market Capitalization and Profit. What does the trendline indicate about this relationship?
Morningstar publishes ratings data on 1,208 company stocks. A sample of 40 of these stocks is contained in the file named Morningstar. Use the Morningstar data set to answer the following questions. a. Develop a point estimate of the proportion of the stocks that receive Morningstars highest rating of 5 Stars. b. Develop a point estimate of the proportion of the Morningstar stocks that are rated Above Average with respect to business risk. c. Develop a point estimate of the proportion of the Morningstar stocks that are rated 2 Stars or less.
From the information attached below, calculate: a. the average stock return from 20x1- 20x3. b. The standard deviation over the same period.
The attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. Estimate Goodman’s and Landry’s betas as the slopes of regression lines with stock returns on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). (Hint: use Excel’s SLOPE function.) Are these betas consistent with your graph?
You are given the following probability distribution of returns for a stock. Use the data to calculate the expected return, standard deviation of returns, and coefficient of variation of returns for the stock. Report the CV to 4 decimal places (13.36% = 0.1336). Return Probability 8.0% 0.20 10.0% 0.10 12.0% 0.40 15.0% 0.20 16.0% 0.10
You are given the following information regarding prices for a sample of stocks.a. Construct a price-weighted index for these three stocks, and compute the percentagechange in the index for the period from T to T + 1. b. Construct a value-weighted index for these three stocks, and compute the percentagechange in the index for the period from T to T + 1. c. Briefly discuss the difference in the results for the two indexes.
Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA= 5.0% + 1.30RM + eA RB= -2.0% + 1.6RM + eB sigmaM= 20% ; R-squareA= 0.20 ; R-squareB= 0.12 What is the standard deviation of each stock (write as percentage, rounded to 2 decimal places)?
The attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. Calculate the standard deviation of the returns for Goodman, Landry, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.)
Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA = 3.8% + 1.25RM + eA RB = –1.8% + 1.60RM + eB σM = 18%; R-squareA = 0.24; R-squareB = 0.18 What are the covariance and correlation coefficient between the two stocks? (Do not round intermediate calculations. Calculate using numbers in decimal form, not percentages. Round your answers to 4 decimal places.)
Please complete in Excel (and show work): If returns of S&P 500 stocks are normally distributed, what range of returns would you expect to see 95% of the time? Base your answer on Figures 11.3 (left) and 11.4 (right).