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)

	STOCK	BONDS	SAVINGS	TOTAL
Annual average growth Rate: You will need to make an assumption here.	10% (review historic growth))	1.5% (average your 2 bonds interest rate)	0.06% (obtain from your bank)
Nper: (years) from above	40	40	40
Pymt: zero	0	0	0
PV: given	$10,000 (assumes75 companies in industry))	$2,000 (2 bonds for team)	$2,500 (amount per team)	$14,500
Type: 0	0	0	0
Future Value (calc)

CALCULATE FUTURE VALUE OF STOCK INVESTMENT, BOND INVESTMENT, AND SAVINGS ACCOUNT