Purchase Solution

Estimating the Index Model using Historical Data

Not what you're looking for?

Ask Custom Question

See the attached file.

Estimating The Index Model Using Historical Data
a. Using the "excess returns" for ABC, XYZ, and Market listed in the table near-by, compute the following statistical values:
1. Average
2. Variance
3. Std Deviation
4. Correlation (ABC:Market)
5. Covariance (Covariance.P, ABC:Market)
6. Beta

I have attached the historical data.

Excess Returns
Week ABC XYZ MRK Rf ABC XYZ Market
1 $59.92 -$19.84 $64.40 5.23 $54.69 -$25.07 $59.17
2 $47.69 $27.67 $24.00 4.76 $42.93 $22.91 $19.24
3 -$28.35 -$5.68 $9.15 6.22 -$34.57 -$11.90 $2.93
4 -$13.92 -$45.00 -$35.57 3.78 -$17.70 -$48.78 -$39.35
5 $64.98 $29.73 $11.59 4.43 $60.55 $25.30 $7.16
6 $99.19 $29.00 $23.13 3.78 $95.41 $25.22 $19.35
7 -$23.15 $61.77 $8.54 3.87 -$27.02 $57.90 $4.67
8 $46.44 $24.31 $25.87 4.15 $42.29 $20.16 $21.72
9 -$33.50 -$42.94 -$13.15 3.99 -$37.49 -$46.93 -$17.14
10 -$38.82 $46.31 $20.21 4.01 -$42.83 $42.30 $16.20.

Attachments
Purchase this Solution
Solution Summary

The solution estimates the index model using historical data.

Solution provided by:
Elisa Valdez, PhD
Education
  • Bachelor of Science in Business Administration, University of the Philippines
  • Master in Business Administration, Saint Mary's University
  • Doctor of Philosophy in Education, University of the Philippines
  • Doctor in Business Adminstration (IP), Polytechnic University of the Philippines
Recent Feedback
  • "Excellent information thanks for the input"
  • "Thank you"
  • "Very thorough and informative. Thank you."
  • "Good response. Very detailed"
  • "This solution is excellent. Thank you"
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

View More Free Quizzes
Related BrainMass Solutions

  • Intrinsic value for Harley-Davidson

    275789 Harley Davidson Stock Beta compared to the S&P 500 index; intrinsic value # Using Microsoft Excel and historical daily data from http://finance.yahoo.com, calculate the beta for Harley-Davidson in comparison to the S&P 500 Index over the past year

  • Analysis of Stock and Index Prices for Ross Stores

    DISCOUNTED CASH FLOW MODEL Estimate the expected return on equity using the DCF model: rS = D1/P0 + g.

  • Forecasing Definition and Market Demand

    There are various techniques of forecasting: Qualitative techniques involve primarily judgment, and quantitative, involving primarily historical data and mathematical models.

  • Beta: general description of the theory, current examples and the way in which the theory impacts the business decisions of either the domestic or global financial manager.

    Unlike Sharpe's diagonal model, which simply uses relationships in historical data to describe the way things are, the CAPM is developed from capital market theory, and describes the way things would be in the theorist's highly idealized world of rational

  • Intrinsic Value

    Using Microsoft Excel and historical daily data from http://finance.yahoo.com, calculate the beta for Harley-Davidson in comparison to the S&P 500 Index over the past year.

  • Forecasting

    45343 Estimating revenues and costs Once you have the revenue and cost data, you can determine the MR and the MC. How would you estimate the revenue and cost data? Use historical information? The various ways of estimating current revenue: 1.

  • Forecasting methods (e.g., seasonal, Delphi, technological)

    Estimating Economy's growth Revenues= No. of expected buyer*quantity purchased by an average buyer*price of an average unit The various ways of estimating current cost: 1. Historical Cost structure 2.

  • CAPM vs. DDM vs. APT

    Calculating the cost of equity using CAPM model is often more difficult than using the dividend discount model. The companiesâ?? financial statements do not show the cost of equity.

  • The Beta for Colgate-Palmolive

    Use the adjusted closing price, which adjusts for dividend payments and stock splits. Next, download the ending value of the S&P 500 index over the same period. For the historical risk-free rate, go to the St.

View More Related Solutions