User Account

All Pages

Calculate the mean return and standard deviation of return

Assignment Help Corporate Finance
Reference no: EM131929207

In this project, you will collect data from Yahoo Finance on monthly returns for the 30 stocks in the DJIA Index. You will also have to collect data on the S&P 500 monthly return (proxy for the market index), and the 13-week Treasury-bill rate (proxy for the risk-free rate). The sample period is 2006.1 - 2015.12 with 120 observations. Then you use Excel to do the following analysis.

1. Calculate the mean return and standard deviation of return for each of the 30 stocks, the market index and the risk-free rate. Using standard deviation as a measure of risk, rank the stocks according to their riskiness?

2. Calculate the correlation coefficients among the 30 stocks, and the correlation coefficients between the market index and each of the 30 stocks.

3. Take any two of the stocks (denoted by stock 1 and stock 2). Construct a portfolio consisting of 40% of stock 1 and 60% of stock 2. Calculate the mean and standard deviation of this portfolio. Compare the standard deviation of the portfolio with that of stocks 1 and 2. Do you find the risk of the portfolio lower than the risks of the individual stocks? Can you change the portfolio weight to further reduce the risk (standard deviation)? Find the portfolio combination that gives the lowest risk? What are this portfolio's mean return and standard deviation?

4. Form an equally weighted portfolio of the 30 stocks. Calculate the mean return and standard deviation of return for this equally-weighted portfolio. Does this portfolio appear to be less risky than the individual stocks?

5. From Yahoo Finance, collect data on the current market capitalization of equity for each of the 30 companies. Using these market capitalization data to construct the value-weighted average portfolio of the 30 stocks. Calculate the mean return and standard deviation of return for this value-weighted portfolio. Does this portfolio appear to be less risky than the individual stocks?

6. Calculate the beta coefficient for each of the 30 stocks. Rank the stocks according to their market (systematic) risks. Do you get the same ranking as in (1)?

7. Calculate the beta coefficient for (a) the portfolio constructed in (3) with 40% of stock 1 and 60% of stock 2; (b) the equally-weighted portfolio of the 30 stocks constructed in (4); and (c) the value-weighted portfolio of the 30 stocks constructed in (5).

8. Estimate the costs of equity capital for these 30 companies.

9. Now collect data from 2016.1 to 2017.12 for these 30 stocks. Compute the average return for the past 24 months and check whether stocks with higher betas in general yield higher returns.

Attachment:- Sample and project.rar

Verified Expert

This assignment deals security analysis of 30 companies with respect to DIJA Sensex . It is an excellent example to understand how security assessment can be made. For this assignment all the data is extracted from yahoo finance DIJA Sensex, and thereby applying excel formula to accomplish this assignment. For these types of assignment you must have fair knowledge about the Sensex markets and its respective components.

Reference no: EM131929207

Questions Cloud

Discuss evidence for genetic and environmental contribution : Discuss the evidence for genetic and environmental contributions to personality disorders. Identify the specific experiences that seem to underlie personality.
Calculate actual rate of return earned on bond investment : Calculate the actual rate of return earned on this bond investment, assuming FX Capital Partners holds the bonds until maturity.
What is the authors claim in the given piece : What is the author's claim in this piece? Where does the author present evidence in this piece? What is the warrant in this piece? Is it stated explicitly?
How comfortable you feel using the skill and explain why : In 3-4 paragraphs, describe a specific instance in which the skill of logical consequences can be successfully applied with a population of interest for you.
Calculate the mean return and standard deviation of return : Rutgers Business School—Newark & New Brunswick - Corporate Finance - Project Assignment - Calculate the mean return and standard deviation of return
Estimate variable and fixed cost elements of annual cost : If a truck is driven only 80,000 miles during a year, Using the high-low method, estimate variable and fixed cost elements of annual cost of truck operation
Calculate the worst-case npv : Calculate the best-case NPV. Calculate the worst-case NPV.
Constitution by legalizing immigration law : The transfer of power to the President is bad and has allowed the President to break certain laws and go against the Constitution by legalizing immigration law.
Develop a description of the leadership strategies : For this assignment, utilize the Rasmussen Business Library resource to research a business case study of an organization going through strategic change.

Reviews

len1929207

4/5/2018 3:27:54 AM

You need to report your answers to the questions which are asked in the assignment. You do not have to report the data or the intermediate results. Attached is a sample as well You will also have to collect data on the S&P 500 monthly return (proxy for the market index), and the 13-week Treasury-bill rate (proxy for the risk-free rate). The sample period is 2006.1 – 2015.12 with 120 observations.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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