2. Spreadsheet 2: Calculate the future value of your retirement investment. Assume you have invested toward your retirement in $10,000 in stock (equities), two bonds (assume face value) and a $2,500 savings account. Calculate what these investments will be worth upon your retirement. Using function wizard, calculate the future value of your savings account and your stock investments. (Hint: stock growth rate should be higher than savings) Annual average growth Rate: You will need to make an assumption here. Nper: (years) from above STOCK BONDS SAVINGS % % % (review historic growth)) (average your 2 bonds' interest (obtain from your bank) rate) TOTAL Pymt: zero 0 0 0 PV: given $10,000 (assumes 75 $2,000 (2 bonds for team) $2,500 (amount per team) $14,500 companies in industry)) Type: 0 0 0 0 Future Value (calc)