Value of the investment at the end of 2010

Assignment Help Other Subject
Reference no: EM131008692

Student Comments: Could you please do it in excel and word files with show all steps

Data:

The data source for this homework is the spreadsheet HW1-Data-S2016.xls (available from D2L).

The spreadsheet contains monthly data for five asset classes: Large Stocks, Small Stocks, Long- term U.S. Government Bonds, Intermediate-Term U.S. Government Bonds, and 30-Day U.S. Treasury Bills.

Assignment:

1. A manager picks at the beginning of each month between Large Stocks and 30- Day U.S. Treasury Bills and remains invested (exclusively) into one of them for the rest of the month. Suppose that the manager is a perfect timer (that is, the choice between the two is always correct). Use the data from HW1-Data-.xls to plot the evolution of the initial $1 investment in the period from January 1926 to December 2010 (as before, assume that trading is costless). Print out the resulting plot and mark on it the value of the investment at the end of 2010.

2. A manager picks at the beginning of each month among all five asset classes and remains invested (exclusively) into one of them for the rest of the month. Suppose that the manager is a perfect rotator (that is, the choice among the five is always correct). Use the data from HW1-Data-.xls to plot the evolution of the initial $1 investment in the period from January 1926 to December 2010 (as before, assume that trading is costless). Print out the resulting plot and mark on it the value of the investment at the end of 2010.

Hint 1: You can express the correct choice between (among) asset classes by using the Excel function MAX.

Hint 2: Use the logarithmic scale for axis y!

Attachment:- HW1-Data.xls

Reference no: EM131008692

Questions Cloud

Determining the mutual fund probabilities : According to the Normal model N(0.024, 0.056) describing mutual fund returns in the 4th quarter of 2007 in Exercise 21, what percent of this group of funds would you expect to have return
Determining the cutoff value of price : Stock prices, again. According to the model in Exercise 26, what cutoff value of price would separate the
Compute the correlation between density and percent ash : The processing of raw coal involves "washing," in which coal ash (nonorganic, incombustible material) is removed. The article "Quantifying Sampling Preash to the density of a coal particle. The average percentage ash for five densities of coal par..
Currency exchange rates : For the model of the EUR/GBP exchange rate discussed in Exercise 25, what would the cutoff rates be that would separate the a) highest 16% of EUR/GBP rates?
Value of the investment at the end of 2010 : Print out the resulting plot and mark on it the value of the investment at the end of 2010 - Print out the resulting plot and mark on it the value of the investment at the end of 2010.
Problem regarding the stock prices : For the 900 trading days from January 2003 through July 2006, the daily closing price of IBM stock (in $) is well modeled by a Normal model with mean $85.60 and standard deviation $6.20. According to this model, what is the probability that on a r..
Rewrite the general prologue in modern english : Write your own original piece following the style of one piece we read. You could craft your own religious allegory using the American church or rewrite the General Prologue in Modern English
Currency exchange rates : The daily exchange rates for the five-year period 2003 to 2008 between the euro (EUR) and the British pound (GBP) are well modeled by a Normal distribution with mean 1.459 euros (to pounds) and standard deviation 0.033 euros.
Find the cutoff return value : Mutual funds, again From the 64 mutual funds in Exercise 21 with quarterly returns that are well modeled by a Normal model with a mean of 2.4% and a standard deviation of 5.6%, find the cutoff return value(s) that would separate the

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