Purchase Solution

Beta calculation

Not what you're looking for?

Ask Custom Question

I need to learn how to calculate the current Beta for each security (use .3 Beta for bonds and 0 for money market instruments for these companies)

GE, Wal-Mart, Citibank, Ford, and Dell

Excel or Word would be fine, thanks.

Purchase this Solution
Solution Summary

The solution explains how to calculate the stock beta using stock prices

Solution Preview

Please see ** ATTACHED ** file(s) for complete solutions and details!!
----------------------
The securities that a company would have would be debt and common stock. Debt beta is already given as 0.3.

The common stock beta is calculated as:

1. We take the stock price for the company and an index (usually S&P 500) for 37 months (so as to get 36 data points ...

Purchase this Solution
Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

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.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

View More Free Quizzes
Related BrainMass Solutions

  • Calculating beta from raw data using regression

    Download the data provided and calculate the measure of risk for this company (defined as Beta in the Capital Asset Pricing Model - CAPM) and explain why this calculation is a measure of risk.

  • Stock Analysis- Calculation of Beta in EXCEL

    Stock Analysis- Calculation of Beta in EXCEL

  • Beta Calculation for IBM, Oracle & Philip Morris

    This solution gives you a detailed discussion on Capital Asset Pricing and beta calculation for sevral companies.

  • Stock and Risk Free Rate

    The solution explains the step-by-step calculation of the price of the stock at the end of the year and the calculation of stock beta.

  • Calculatin of a stock's beta and required rate of return

    Assume the risk-free rate and the beta remain unchanged. Open attachment for solution. The solution is a step-by-step calculation of the stock's beta and the stock's required rate of return.

  • Beta and required return calculation

    So a stock like CG with 2.4 beta should yield a required return of E = 0.06 + 0.0375(2.4) = 0.15. Beta and required return calculation are provided.

  • Required rate of return

    Using the CAPM equation with beta = 2 rA = 5% + (10%-5%) 2 rA= 15% The solution explains the calculation of required rate of return

  • Expected Return

    77124 Formula and Calculation for Expected Return Explain and work in Excel. Expected return on the market portfolio is 17.7 percent and risk free rate is 4.1 percent. Edward Jones has a beta of 1.6. Under CAPM A.

  • Calculation of Beta of the portfolio

    473754 Calculation of Beta of the portfolio You hold a portfolio of stocks consisting of the following: Stock Beta Current Value Blackwater Gas 0.5 $10,000 Tidy Tom's Cleaners

  • Portfolio of Stocks

    If the calculation was in error, explain how to correct that calculation and please show all of your work.

View More Related Solutions