Compute the return for each year on a portfolio

Assignment Help Financial Accounting
Reference no: EM131450997

Assignemnt: Risk and Return Study

Attached is a excel spreadsheet that has the annual return measured for 12 different stock investments. The spreadsheet shows the average return and standard deviation of the return for the past 15 years. Use this spreadsheet and spreadsheet commands to do the following:

1. Compute the return for each year on a portfolio that contains an equal investment in all 12 securities.

2. Compute the 15-year average return and standard deviation of return for the portfolio that consists of all 12 securities with equally weighted investment.

3. Compute the correlation and covariance between the return on company #12 and the return on the equally-weighted portfolio. Hint: There is a spreadsheet command that does this calculation.

4. Compute the beta of Company #12 using the information you have collected.

5. Now using the beta you created for Company #12, compute the required rate of return using the Capital Asset Pricing Model (CAPM), assuming that the average market return is the return of your equally-weighted portfolio and the risk-free rate of return is 2.5%.

6. If you were told analysts estimate that Company #12 will have a 5% rate of return next year, would you buy the stock? Why or why not?

Your submission should meet the following requirements:

• Complete your work on the Excel sheet provided.
• Be sure to keep your formulas or commands in the cellson your Excel sheet.
• Include any brief explanatory remarks needed, on the Excel sheet.

Attachment:- Annual_Return_Measured.xlsx

Reference no: EM131450997

Questions Cloud

Explain sensation seeking and overconfidence : Differentiate the following terms/concepts: Indirect and direct tests of relationship between overconfidence and trading activity.
What is the secs guidance concerning netting : What is the SEC's guidance concerning netting? What other characteristics of potential misstatements should auditors consider when evaluating their materiality?
Create a paneled brochure describing the anatomy of neurons : PSY 340 : create a paneled brochure describing the anatomy of neurons, synaptic transmissions, and the functions of neurotransmitters.
What is regret and disappointment : Differentiate the following terms/concepts: Regret and disappointment, House money and break-even effects.
Compute the return for each year on a portfolio : Compute the return for each year on a portfolio that contains an equal investment in all 12 securities. Compute the beta of Company #12 using the information.
What is a mystical experience : what does religion emphasize? what does spirituality emphasize? can they be connected, if yes, how?Give three descriptions of a healthy.
Differentiate the dictator and ultimatum games : Differentiate the following terms/concepts: Dictator and ultimatum games, Trust and reciprocity, Conformity and groupthink.
Discuss the merits of the given statement : Discuss the merits of the following statement: The evidence clearly indicates that proposers in dictator games care about fairness.
Analysis of ways in which employees express motivation : Select a theory from your worksheet. Define motivation, and provide a brief analysis of ways in which employees express motivation

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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