Create a x-y scatter plot of your data

Assignment Help Finance Basics
Reference no: EM13279233

Create a Microsoft Excel workbook, and download and store the end-of-month prices for your stock for at least the last 30 months, as well as any dividend information. Name this worksheet DATA. 1. Calculate returns. Using your price and dividend information, calculate the monthly returns on the stock on the worksheet DATA. HRE ARE THE PRICES: -Jan-13 11.32 28-Feb-13 11.23 31-Jan-12 7.13 28-Feb-12 7.97 31-Mar-12 9.57 2. Calculate the returns on the market. Select a market index and download the monthly returns for the same period of time that you used for the selected stock. If returns are not available, download the level of the index and any corresponding dividends, and calculate the market's monthly returns using that information. The market returns should also be placed on the worksheet DATA. 3. Plot your data. Create a X-Y scatter plot of your data, with the return on the stock as the vertical axis and the return on the market as the horizontal axis. Name this chart as SCATTER in your workbook and be sure to label the axes.

Reference no: EM13279233

Questions Cloud

Determine what is the sampled signal x equal to : (a) Find the Fourier transform X(Ω) of x(t). (b) Is x(t) band limited. If so, find its maximum frequency Ωmax. (c) Suppose that Ts = 2π. How does Ωs relate to the Nyquist frequency 2Ωmax. Explain.
Which of the following is not a benefit of the spline method : Which of the following is not a benefit of the spline method of estimating discount functions across a spectrum of maturities?
Can we measure progress in ethical maturity of our society : Have we, as a society, become more or less ethical than we were 10 – 20 or even 50 yrs ago? Is it the media awareness that has made us appear less ethical when we really are not? Can we measure progress in ethical maturity of our society?
Explain what is its solubility at 25 °c and 1470 torr : At 25 °C and 765 Torr, carbon dioxide has a solubility of 0.0342 M in water. What is its solubility at 25 °C and 1470 Torr
Create a x-y scatter plot of your data : Create a X-Y scatter plot of your data, with the return on the stock as the vertical axis and the return on the market as the horizontal axis. Name this chart as SCATTER in your workbook and be sure to label the axes.
What type of skills do guerrilla marketers need : Briefly explain the various defense strategies that the dominate firm in a particular market can use. What type of skills do guerrilla marketers need? Describe the four types of competition that can exist within an industry.
Explain what is the maximum work that can be obtained : What is the maximum work that can be obtained from a 340 L tank of compressed air at 4350 PSI
Prepare a monthly cash receipts schedule for the firm : Prepare a monthly cash receipts schedule for the firm for March through August.
Explain benzene and toluene has a total vapor pressure : A solution of 75.0 g of benzene (C6H6) and 75.0 g of toluene (C7H8) has a total vapor pressure of 80.9 mmHg at 303 K. Another solution of 100.0 g benzene and 50.0 g toluene has a total vapor pressure of 93.9 mmHg at this temperature.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  How large should those deposits be

If I want to accumulate $15,000 in 6 years by making equal end-of-year deposits into an account paying 7% interest, how large should those deposits be?

  What is implicitly occurring in each as a result of interest

what is implicitly occurring in each as a result of interest rate parity? Is the pound selling forward at a premium or at a discount relative to the yen?

  Making decision by weighted average cost of capital approach

Neon Company's stock returns have a covariance with market portfolio of 0.031. The standard deviation of the returns on the market portfolio is 0.16, and expected market risk premium is 8.5%.

  Computation of current value of shares of a stock

computation of current value of shares of a stock under given dividend growth rate and This growth rate is expected to continue for the foreseeable future

  Finding future or present value of bill shaffer

Bill Shaffer wishes to have $200,000 in a retirement fund 20 years from now. He can create the retirement fund by making a single lump sum deposit today. What is the maximum annual withdrawal he can make over the following 15 years?

  Compute rate of return on the investment

Suppose you decide to sell short 200 shares of XCorp stock at a price of $75. Your margin deposit is 65%. Commission on the sale is 1.25 percent. While you are short, the stock pays a $1.75 per share dividend.

  What is the expected year-end dividend

Francis Inc.'s stock has a required rate of return of 10.25%, and it sells for $20.00 per share. The dividend is expected to grow at a constant rate of 6.00% per year. What is the expected year-end dividend, Dmc060-1.jpg? $0.85 $0.64 $0.89 $0.81 $..

  Computation of value of the and calculate for each bond

Computation of value of the bond and Calculate for each bond the percentage price change associated with a change of yield to maturity

  What is the project net present value

Garner-Wagner is considering investing in a project that requires an investment of $3,000,000. The project will generate a cash inflow of 500,000 per year for the next 5 years. The cost of capital is 10%. What is the project's net present value?

  Retirement of debt

Can early retirement of debt be relied upon as a cost-saving measure when incurring long-term debt? Why or why not?

  Calculation of termination fees

Calculation of termination fees and as required under the terms of the terminated merger agreement among Stone

  Computation of effective annual yield and bond value

Computation of effective annual yield and bond value and What is the yield of the 5-year bond expressed as an effective annual yield?

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