The Most Important Lesson in High School Assumptions Investing $3000 in each of the first five years Investing $4000 in each of the next five years Investing $5000 in each of the next five years Investing $6000 in each of the next five years Investing $7000 in each of the next five years Investing $8000 in each of the next five years Investing $9000 in each of the next five years Investing $10000 in each of the last five years Investments earn 8% per annum, compounded annually Assignment 1. Create a chart / spreadsheet with the numerical values of the investment. 2. Create a bar graph of the value of the investments in the account. 3. Orientate the graph paper to landscape, with money on the y axis, and years on the x axis. 4. The scale for money is such that each square represents $50 000. The scale for years is such that each square represents one year. 5. Colour-code each group of five years. 6. Don't forget a title, axes labels, and a legend explaining the colours.