Assume you are investing $1,000,000 for a 40 year old friend who wants to retire at 60 years old.

Fill out a spreadsheet showing what you would choose to invest in and break down the totals by year.

As a quick hint, the year 1 "Ending Value" and Year 2 "Starting Value" should be the same. Also, based on your knowledge, use an appropriate ROl for the investment you have chosen. You can have more than 3 or 4 investments, just add additional lines to the spreadsheet. I've only listed 3 years on the spreadsheet but it should go all the way to 20 years since your friend wants to retire at 60.