2. Spreadsheet 2: Calculate the future value of your retirement investment. Assume you have invested toward your retirement in $10,00 in stock (equities), two bonds (assume face value) and a $2,500 savings account. Calculate what these investments will be worth upon your retirement in 30 or so years. 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.	__________% (review historic growth))	___________% (average your 2 bonds interest rate)	___________% (obtain from your bank)
Nper: (years) from above	_____30______	______30_____	_____30______
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)

It should be apparent that this initial investment of stocks, bonds and savings, even adjusted for stock appreciation and bond interest, will not be enough to get you to your (Part 1) calculated nest egg desired!(Unless, of course, you dont retire for a few hundred years). So lets go on. . . .

3) Spreadsheet 3: Now we know what you need, lets calculate additional annual savings required to reach this retirement goal. You have just created 3 possible retirement fund goals for yourself: low, medium, and high. Now you are able to calculate what you need to start setting aside each year (for a per month rate divide by 12) to achieve your retirement goals, in the given amount of time you have assigned yourself. Put the future value of your stock, bond and savings accounts in the table below, then calculate the rest.

	e.g.,	Low	Medium	High	Source:
a) Retirement Goal	$1,040,579				Spreadsheet 1 (varies with low, med. high )
b) Future Value of Stock, Bonds, and Savings	TOTAL:$45,858 (Stock = $36,165(assume 7% growth) Bonds = $6,051(assume 6% growth) Savings: $3,642 (assume 2% growth)				Spreadsheet 2 (same for each scenario)
c) Additional Funds needed upon retirement	$994,721				*calculation: (a-b)
d) Annual savingsrequired to build (d)	$29,464 annually				**Use function wizard and Payment function (for a rate, use 6%, n = years to retirement, PV = 0, FV = c)