• The file C16_01.xlsx contains annual returns
of the S&P 500 and 3-month Treasury bills from 1960. Suppose that in each of the next 72 months (six years), it is equally likely that any of the his- torical returns will occur. Develop a spreadsheet model to simulate the two suggested investment strategies over the six-year period. Plot the value of each strategy over time for a single iteration of the simulation. What is the total value of each strategy after six years? Do either of the strate- gies reach the target?

  
  

 

Answer rating: 100% (QA)

QUESTION The file C1601xlsx contains annual returnsof the SP 500 and 3month Treasury bills from 1960 ... View the full answer