Calculate the firms expected rate of return

Assignment Help Corporate Finance
Reference no: EM13204999

Calculate the firm's expected rate of return using the capital asset pricing model. You will first need to calculate your company's beta and then use that in the CAPM formula to get the expected rate of return.

  1. Calculate each of the monthly returns for your stock over the 5 years of data that you have collected (i.e., percentage change in price each month). If your prices have not been adjusted for splits, you will need to adjust the calculations for those months in which a split occurred. (A 2-for-1 split will double the number of shares but not change the value of the company, so each share will be worth half as much. If P0 is the price at the end of the month before the split and P1 is the price at the end of the month in which the split occurred, then you will need to multiply P1 by 2 before you do your return calculation, since two shares at P1are equivalent to one share at P0.) If you are using the adjusted closing prices from the Yahoo site, these adjustments have been made for you.
  2. Calculate each of the monthly returns for the S&P/TSX Composite Index over the 5 years of data that you have collected. No adjustments will need to be made in these prices.
  3. Create a scatter plot using Excel that shows the return on your company's stock and the return on the market index in the same month (see Figure 11.2 in your text). Plot the characteristic line on the graph (the trendline).
  4. Calculate beta as the slope of the characteristic line on your graph (see a sample spreadsheet on page 340 of your text).
  5. Using the value of beta that you calculated, the return on a three-month treasury bill for the risk-free rate, and 7 percent as the market risk premium (the average market risk premium over the last 82 years), calculate the expected rate of return based on the capital asset pricing model.

Reference no: EM13204999

Questions Cloud

What grade did the student receive on the fifth exam : a student averages 84 on five tests. If the student received grades of 84, 82, 81 and 79 on the first four exams, what grade did the student receive on the fifth exam?
How much are the contents worth : A cubical box measures 55 centimeters on each side.  If the contents are worth $0.17 per cubic centimeter, how much are the contents worth?
Determine the dimensions to give the maximum volume : A rectangular sheet of metal having dimensions of 28cm by 10cm has squares removed from each of the four corners & the sides bent upwards to form an open box. Determine the maximum volume.
What is the payback period for project : Find the Weighted Average Cost of Capital and if Google wanted to lower their WACC, what could they do
Calculate the firms expected rate of return : Calculate the firms expected rate of return using the capital asset pricing model. You will first need to calculate your company's beta and then use that in the CAPM formula to get the expected rate of return.
What is the cost to remove 75% of the pollutant : Biologists want to set up a station to test alligators in the lake for West Nile Virus. Suppose that the costs for such a station are $2,500 for setup costs and $3.00 to administer each test.
How many dollars do both person earn in 1 yr : bill earns (m) dollars per month and ann earns (n)dollars per month. how many dollars do both person earn in 1 yr?
Calculate the annual dividends that your company paid : Calculate the annual dividends that your company paid and calculate the firm's expected rate of return using your calculated expected dividend, growth rate, and last year's unadjusted year end price.
How many people are in the group : Buying a Cottage A group of friends decides to buy a vacation home for $120,000, sharing the cost equally. If they can nd one more person to join them, each persons contribution will drop by $6000. How many people are in the group?

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd