8. Working with your Goals

For each of your goals, you can now determine how much you would need to save each year to achieve your goal. Show how to use the formulas and/or excel to figure out how much you need to save each year to reach one of your goals (you probably want to pick one of the intermediate or longer term goals to make it worthwhile).

You can assume the following rates of return:

• Less than 2 years 4%
• 2-5 years 6%
• Greater than 5 years 7%

Timeframe	Time Horizon	Dollar Amount	Description	Action to be taken
Short-Term (within 1-2 yrs)
Intermediate Term (2-5 yrs)
Longer Term (5+ years)