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
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
|