What is your expected return on this investment

Assignment Help Other Subject
Reference no: EM13666140

QUESTION 1

1. This problem set is designed to give you an opportunity to exercise with excel program to compute returns and risks. Read carefully the instructions and practice step by step.

You purchased one share of the stock in Microsoft Corporation,fiveyears ago and sold the stock at thebeginning of this month. You want to figure out the monthly returns andthevolatility of the returns using an Excel spreadsheet.

Click onthe 'Historical Prices'tab on the left menu.

Go to the Set Data Range area. Set the 'Start Date' as on 'January1, 2010' and the 'End Date' as on 'January 9, 2015'. Monthly data must be retrieved.Click onthe'Monthly'circlein the right column.

Then, click the Get Prices tab.

Now scroll down thewebpage and click the 'Download to Spreadsheet' tab.

You may find an excel spreadsheet, named ‘table', in the download area of your computer.

Open the spreadsheetthat contains monthly prices of theMicrosoftstock.

Sort the whole data by the‘Date'in an ascending order, that is, oldest to newest.

After set the range so all the cells are selected, click the Data tab in the top menu bar, click the Sort tab, then check on ‘My data has headers'.

Select the ‘Date' by clicking the right scroll menu of the ‘Sort by' tab.
Select the ‘Values' from the ‘Sort on' menu.
Select the ‘Oldest to Newest' from the ‘Order' menu.

Createa column named'HPR' to the right of 'Adj Close'by typing ‘HPR' in the cell H1 if the'Adj Close' is in the row 'G'.

Typea function in the cell H3 such that '=G3/G2-1'.

Copythis functionand paste itto the next rows and repeat this to the endinthe‘HPR'column.

You may use the ctrl + C key to copy a cell and ctrl + V keys to paste.

In thiswayyoucan compute the monthly returns. You shouldhave.0219for the first monthly returnin the H3 cell, and .0218 for the second monthly return in the H4 cell.

Total 60 monthly returns should be identified.Thenanswer the following questions.

(Hint: You may want to refer to an excel reference for Apple stock posted on Blackboard)

(1) To compute the arithmeticaverage returnof the monthly returns, add every monthly return in the HPR column. Use a function by typing ‘=SUM(H3:H62)' in the H63 cell. What is the sum of the monthly returns?

(2) Find the number of returns by typing a function ‘=count(H3:H62)' in the H64 cell. How many monthly returns exist during the holding period?

(3) Divide the sum computed in the part (1) by the number of monthly returns found in the part (2). Type ‘=H63/H64' in the H65 cell. What is the arithmetic average return?

(4) Create a column named ‘Deviation' to the right of the HPR column by typing ‘Deviation' in the ‘I1' cell. Use a function by typing ‘=H3-$H$65' in the I3 cell. Copy the function in the I3 cell and paste it to the cells I4 through I62. Compute the sum of every deviation from mean in the ‘Deviation' column by typing ‘=SUM(I3:I62)' in the I63 cell. What is the sum of the deviations from mean?

(5) Create a column named ‘Squared Deviation' to the right of the ‘Deviation' column by typing ‘Squared Deviation' in the ‘J1' cell. Use a function by typing ‘=I3^2' in the J3 cell. Copy the function in the J3 cell and paste it to the cells J4 through J62. Compute the sum of every squared deviations in the ‘Squared Deviation' column by typing ‘=SUM(J3:J62)' in the J63 cell. What is the sum of the squared deviations?

(6) To compute the variance of the monthly returns, type a function ‘=J63/(H64-1)' in the J64 cell. What is the variance of the returns?

(7) To compute the volatility of the monthly returns, type a function ‘=SQRT(J64)' in the J65 cell. What is the standard deviation of the returns?

(8) In order to confirm your answers, type a function '=AVERAGE(H3:H62)' in the H66 cell. Is this average return the same to the arithmetic return computed in the part (3)?

Additionally, type a function ‘=STDEV(H3:H62)' in the J66 cell. Is this standard deviation the same to the standard deviation of the returns computed in the part (7)?

(9) To compute the geometric return, type a function‘=(G62/G2)^(1/H64) - 1' in the cell G67. What is the geometric return?

QUESTION 2

1. You purchased a share of stock for $25. One year later you received $1.25 as dividend and sold the share for $30.

(1) Your capital gains yield (CGY) was _____.

(2) Your dividend yield (DY) was _____.

(3) Your holding-period return (HPR) was _____.

QUESTION 3

A stock had year-end prices of $42, $37, $44, and $46 over the past four years, respectively. Ignore the dividends.

(1) What are annual holding period returns for each year?

(2) What is the arithmetic average rate of return?

(3) What is the variance of the annual returns?

(4) What is the volatility of the annual returns (measured by the standard deviation)?

(5) What is the geometric average rate of return?

QUESTION 4

An investment earns 12.5% the first year, earns 20% the second year, and loses 15% the third year.

(1) Suppose that you invest $1 three years ago. What will be the amount you earn in three years? Then, the total compound return over the 3 years is _____.

(2) What is the geometric average return over the 3 years?

QUESTION 5

Your investment has a 20% chance of earning a 35% rate of return at a boom economy, a 50% chance of earning a 10% rate of return at a normal economy, and a 30% chance of losing 15% at a recessionary economy. What is your expected return on this investment?

Reference no: EM13666140

Questions Cloud

Coyote and bird run the acme fireworks company : Coyote and Bird run the Acme Fireworks Company
Why is it required for governments to record the budget : Why is it required for governments to record the budget using standard journal entries?
Funding and accounting for the different colleges and unive : Funding, and accounting for the different colleges and universities
Evaluate the companys profitability and financial stability : Prepare a statement of cash flows for the year ended 30 June 2017 in accordance with the direct method and evaluate the companys profitability and financial stability by calculating and analysing the relevant ratios.
What is your expected return on this investment : What will be the amount you earn in three years? Then, the total compound return over the 3 years and what is your expected return on this investment?
Do apollo and rocky have an arguable defence : Have the directors of Citrus Ltd breached their directors' duties (in particular duty to act for good faith in the best interests of the company and for a proper purpose) in relation to the loan that has been advanced to Lang?
Think an event with space-time coordinates : Think an event with space-time coordinates t=2.0s x=2.5*10^8 m/s relative to frame S. Discover the value γ that will be required to transform coordinates among frames S and S'. Use c=3*10^8 m/s for the speed of light in vacuum
Discover momentum and speed of electron whose kinetic energy : Discover the momentum and speed of an electron whose kinetic energy equals its rest energy? The mass of the electron is 789MeV/C^2?
The force constant of a spring : The force constant of a spring is 800 N/m and the unscratched length is 0.63 m. A 4.6 kg block is suspended from the spring. An external force slowly pulls the block down, until the spring has been stretched to a length of 0.76 m.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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