The file C16_01.xlsx contains annual returns of the S&P 500 and 3-month Treasury bills from 1960.
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date: