Print out the resulting plot and mark

Reference no: EM131007658

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-S2016.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-S2016.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:- Data.xls

Reference no: EM131007658

Questions Cloud

Shares of common stock outstanding : The Hardigree Hamburger chain is a closely held corporation with 400,000 shares of common stock outstanding. The owners would like to take the company public by issuing another 600,000 shares and selling them to the general public in an initial pu..

What methods of controlling corrosion are suggested : Search www.corrosion-doctors.org, and under the "Information Modules" section select "Corrosion by Environments." Choose one of the listed topics and write a summary of the information covered. Include if costs are addressed, types of materials af..

Balances in the capital accounts : The tax rate is 40%, and Prahm's cost of capital is 11%. Calculate Prahm's EVA® during the year, and comment on that performance relative to ROE. Make your calculations using average balances in the capital accounts.

What influence would this have on total rate of corrosion : The environment involves moisture and some salt. Consider two cases: (1) iron plates with nickel-copper alloy rivets, and (2) nickel-copper alloy plates with iron rivets. For each case, which metal will corrode?

Print out the resulting plot and mark : 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.

Compute the mva : Compute the MVA as of 12/31/X0, and compute EVA®, the change in MVA, as a result of each subsequent year's activity. (Assume that all shares issued during any given year received the dividends declared that year.)

Current items of equal size on the balance sheet : What is the maximum amount of inventory Nelson can obtain in this manner? (Hint: The note and the inventory are both current items of equal size on the balance sheet.)

Maximum inventory level : What is the maximum inventory level the firm can carry to maintain an inven- tory turnover (based on COGS) of 8.0? If the inventory contains $1.2 million of obsolete and damaged goods that don't turn over at all, how fast would the active inventory ..

Perform a pareto analysis of the data collected : Discussion Questions- From the conversation Between Tim and his staff, draw a cause-and-effect diagram. Perform a Pareto analysis of the data collected

User Account

All Pages