Assume you are investing $1,000,000 for a 40 year old friend who wants to retire at 60 years old. Please fill out the attached 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 ROI 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.