Download monthly data for the last 5 years

Assignment Help Finance Basics
Reference no: EM133074908

For the company that you are assigned, please complete the following: The company is Exxon!

  • Download monthly data for the last 5 years.
  • Calculate a percentage return using the formula (New-Old)/Old for each of those months. Use the close number. (You may ignore dividends for this project.)
  • Calculate the average monthly return using the Average function in Excel.
  • Calculate the standard deviation using the sample standard deviation function (STDEV.S).
  • Download monthly data for the last 5 years for the S&P 500 (GSPC). Calculate the percentage return, average, and standard deviation using the same procedures described above.

For your company, find the following data:

  • Beta
  • Market capitalization
  • Range for the stock price over the last year
  • Average volume of shares sold each day

Using your data and the calculations for the company and the stock index, how does the return and risk of the index compare to the return and risk of the individual stock? What does the beta tell you about the firm?

Reference no: EM133074908

Questions Cloud

What happens in a multi-divisional company : What happens in a multi-divisional company decides to use a companywide WACC to judge projects? Is there a remedy for this?
What is the net benefit of refinancing : You are starting to have second thoughts about moving. After going back and forth for several weeks you decide that you will make a decision based on whether or
What is expected of impact on the stock market : Holding all else constant, what is expected of its impact on the stock market? Back up your assertion using detailed transmission channels.
Calculate the distance to default : Based on the single-factor model, suppose Ki= -2.83, beta=0.5, m=-2.2 Calculate the Distance to Default.
Download monthly data for the last 5 years : For the company that you are assigned, please complete the following: The company is Exxon!
Calculate a percentage return using the formula : For the company that you are assigned, please complete the following:The company is Exxon!
How to do the journal entry : Question - Triple-A has not paid 16,570 for the advertising expense in July to Instagram As of October 31, How to do the journal entry
Various forms of investment information : Describe how various forms of investment information can lead to better investing skills and how you would develop, monitor and manage investment portfolio.
Carefully examine each of the dimensions of wellness : Carefully examine each of the dimensions of wellness in your own life. For each dimension, list as many actions you take to support that dimension in your life

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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