Spreadsheet Analytics. Show how you arrived at the answers. If you invest $1000 a year at the beginning of each year for the next thirty years in a broadly-based stock market fund which historically has earned 6.5% per year, how much will you expect have at the end of these 30 years if you believe stock market history is an excellent guide to the future?