Investment Planner1

Questions? Email us at [email protected]

Investment Calculator & Planner - Overview Savin gs & Contri bution s

Instructions You may move from worksheet to worksheet by clicking on the dark blue buttons located at the top of each worksheet or the blue tabs at the bottom of this workbook. Each sheet is password protected in order to avoid inadvertent deletion of key formulas. Enter data in the white cells with gray borders: $400 Use the drop down boxes IRA to chart different investment and time periods (401k, Roth IRA, Monthly, Qu

Savings & Contributions Enter your current age and the age at which you would like to meet your "Investment Goal" Enter the amount you contribute to your investment plan(s) on an annual basis. You may adjust/increase future contributions for inflation (401k/Other) or match that of the maximum allowable (IRA/R by checking the boxes to the right of the dollar amounts. You may determine the timing of your investment contributions by using the drop down box at the bottom of the sheet.

Asset Allocation This sheet determines the rate at which your investments will grow. Use the drop down boxes provided to select the types of investments. Six options are provided along with their approp Use the smaller arrow keys directly to the right of the investment options to increase or decrease the allocation levels. You may customize the investment choices by checking the box to the left of: "Use investment options below instead o

Investment Detail This page details your annual financial contributions and investment return throughout your investment period. Here you will see how your future contributions are adjusted/increased for inflation (401k/Other) or to match that of the Enter your one time investments (inheritance, real estate sale, etc.) in the "Lump Sum Contribution" column.

Scenario Calculator This sheet calculates 154 possible scenarios assuming slightly higher and lower rates of return as well as alternative a Choose to display: Total Investment Value, Capital Gains or Total Contributions *The calculations assume that annual contributions remain constant over the investment period.

Investment Tracker We've provided this sheet for those interested in tracking their individual investments on a periodic basis. -First select how frequently you would like to track your investments, then the 1st tracking period and then the period in the valuation calculated and charted. -Type in four "Investment Types" in the white boxes with grey borders (these will determine the choices available to yo Tracking" area below. In the "Investment Tracking" section, you will enter in all the appropriate information pertaining each individual investm The "Purchase Price" & "Valuation as of PERIOD" columns are locked as they are calculated for you. The "Annualized Return" figures on this sheet are NOT used in the calculation of the "Results" on the Savings & Contr Results are based off of the Investment return determined on the Asset Allocation tab. Financial Calculators available at www.simpleplanning.com

- Budget Planner - Investment Calculator - Retirement Planner

- Mortgage Calculator - Tax Calculator - 401k Calculator

- Complete Planner (includes all six calculators & pla

Software License Agreement Simpleplannings.com grants usage of this financial planning "software" under the following terms and conditions: After the purchasing and downloading of this software from Simpleplanning.com, the purchaser is granted a "license" t The "licensee" may make copies of this product in an amount that does not exceed the number of licenses originally p Simpleplanning.com, or for the purpose of creating a backup copy. This file or the software contained in this file shall not be transferred to a non-licensee without the written consent from

Limitation of Liability Simpleplanning.com will not be held liable for damages in the event of, but not limited to inaccurate assumptions, calcu software, hardware, data and network failure and profit/savings losses as a result of using this software.

Questions? Email us at [email protected]

Invest ment Tracki ng

Scena rio Calcul ator

Invest ment Detail

Asset Allocat ion

Savin gs & Contri bution s

s (401k, Roth IRA, Monthly, Quarterly, etc.)

he maximum allowable (IRA/Roth IRA).

box at the bottom of the sheet.

provided along with their appropriate historical returns. decrease the allocation levels. stment options below instead of default options"

your investment period. k/Other) or to match that of the maximum allowable (IRA's). Contribution" column.

of return as well as alternative annual contribution amounts.

n a periodic basis. ng period and then the period in which you would like

mine the choices available to you in the "Investment

taining each individual investment. ulated for you. esults" on the Savings & Contributions tab.

401k IRA Roth IRA Other

includes all six calculators & planners)

wing terms and conditions: urchaser is granted a "license" to use this product. number of licenses originally purchased from

without the written consent from Simpleplanning.com.

o inaccurate assumptions, calculation errors, ng this software.

Overvi ew/ Help

Invest ment Tracki ng

Scena rio Calcul ator

Invest ment Detail

Asset Allocat ion

Savin gs & Contri bution s

Investment Calculator - Savings & Contributions Solve for: ●

How much will my investment be worth?

Results: $-

$1 $1 $1 $1 $1 $0 $0 $0 $0 $0 $0

Am I saving enough today? When will my investment goal be met?

Personal Information 40 Current Age 55

Desired age at which Investment Goal is met Annual Salary Increase Investment Goal

Investment Savings

Row 1

Savings & Contributions Investment Plan

Savings

Annual Contribution

IRA

Increase future contribution to maximum allowable?

Other

Adjust future contributions 0% annually?

Other

Adjust future contributions 0% annually?

Total Assume contributions are made:

$-

$-

At the beginning of each year

tment Savings

Solve

Invest Years

Plan #

Plan Option

1

15

1 2

401k IRA

Chart

3

Roth IRA

0

4

Other

$-

ow 1

Asset Allocation

Plan

Savings

Contribution

Increase

1

2 4

IRA Other

$$-

$$-

FALSE FALSE

At the beginning of each year Throughout the year

4

Other

$-

$-

FALSE

At the end of each year

Next

Overvi ew/ Help

Invest ment Tracki ng

Scena rio Calcul ator

Invest ment Detail

Asset Allocat ion

Savin gs & Contri bution s

Asset Allocation Asset Allocation Investment

Asset Allocation Allocation

Return*

Large Cap Stocks (S&P 500)

30%

10.2%

Small Cap Stocks

20%

12.2%

International Stocks (EAFE)

10%

12.4%

Corporate Bonds (AAA)

10%

7.6%

Long-term Government Bonds

10%

5.4%

Other

20%

2.2%

Total

100%

8.5%

Use investment options below instead of default options

Investment Vehicle Mutual Fund A Mutual Fund B Stock A Stock B Bond A Bond B

Return 9.0% 10.0% 12.0% 12.0% 6.0% 7.0%

30.00%

20.00% 10.00% 10.00%

20.00% 10.00%

Large Cap Stocks (S&P 500) Corporate Bonds (AAA)

Small Cap Stocks

International Stocks (EAFE)

Long-term Government Bonds

Other

Savings & Contributions

return

Allocation

30.00% 20.00%

all Cap cks

International Stocks (EAFE)

g-term vernment nds

Other

Savings & Contributions

Investment Detail

1 Large Cap Stocks (S&P 500)

10.2%

1 Large Cap Stocks (S&P 500)

2 Small Cap Stocks

12.2%

2 Small Cap Stocks

3 International Stocks (EAFE)

12.4%

3 International Stocks (EAFE)

4 Corporate Bonds (AAA)

7.6%

4 Corporate Bonds (AAA)

5 Long-term Government Bonds 6 U.S. Treasury Bills

5.4% 3.7%

5 Long-term Government Bonds Other

10.2% 12.2% 12.4% 7.6% 5.4% 2.2%

30% 20% 10% 10% 10% 20%

30 20 10 10 10

FALSE

4

Invest ment Tracki ng

Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Overvi ew/ Help

Scena rio Calcul ator

Invest ment Detail

Asset Allocat ion

Savin gs & Contri bution s

Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Projection Detail 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Age 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79

Inv. Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Beginning Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

IRA $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Lump Sum Contribution

Total Annual Contribution $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Return $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Ending Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Future Cont Ind

FALSE

IRA Ind

1 1

2

Beginning Balance Return

Contribution Return

IRA

8.5%

8.5%

FALSE

FALSE

0

0

4

4

Other

Other

0%

0%

Max Allow

Inv Goal

$$4,000 $4,000 $4,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000

Overvi ew/ Help

Invest ment Tracki ng

Scena rio Calcul ator

Invest ment Detail

Asset Allocat ion

Savin gs & Contri bution s

Scenario Calculator Current Savings

Display: Total Investment Value Contributions made: At the beginning of each year Annual Contribution $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

8.0%

8.1%

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 *Calculations assume constant annual contributions

$-

Annual Contribution*

Investment Rate of Re

Increment by 8.2%

8.3%

8.4%

8.5%

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Years

15

Investment Rate of Return

8.5%

Increment by

0.1%

8.6%

8.7%

8.8%

8.9%

9.0%

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

1 Total Investment Value Capital Gains Total Contributions

1

1

At of year each year At the the beginning end of each

Display Valuation as of: March

2008 2009

Overvi ew/ Help

1st Tracking Period: December

Invest ment Tracki ng

Scena rio Calcul ator

Invest ment Detail

Asset Allocat ion

Savin gs & Contri bution s

Track Investments: Monthly

Investment Type Stocks Mutual Fund Bonds Other Total

Purchase Price $0 $0 $0 $0 $0

March Valuation $0 $0 $0 $0 $0

Purchase Date

----------------------- Enter Unit Pr -------------------------December

Investment Tracking Investment Name

Investment Type

Units

Unit Price

Purchase Price (calc) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$1 $1

Capital Gains $0 $0 $0 $0 $0

Annualized $1 PriceMarch Valuation Return Purchase Capital Gains #DIV/0! $0 $0 $0 $0 #DIV/0! $0 #DIV/0! #DIV/0! $0 Purchase March Capital #DIV/0!

----------------------- Enter Unit Price -------------------------January February

Price

March

Valuation

April

Gains

Valuation as of March 2009 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

0 Stocks 0 Mutual Fund 0 Bonds 0 Other 0 Total

Month Month

Month #

1 December

Track: 12

47 1

12

2 January

1 Monthly

1 Monthly

December

3 February

2 Quarterly

2 Quarterly

4Q 2006

4 March

3 Semiannually

3 Semiannually 2H 2010

5 April

4 Annually

4 Annually

2015 December

Ma arch March 3

Monthly

Err:502

Quarterly

Err:502

0

Semiannually Annually

December

1311.0

Err:502

Err:502

(22,788.0) Stocks

#DIV/0!

1311.0

Err:502

Err:502

(22,788.0) Mutual Fund

#DIV/0!

1311.0

Err:502

Err:502

(22,788.0) Bonds

#DIV/0!

1311.0

Err:502

Err:502

(22,788.0) Other

#DIV/0!

1311.0

Err:502

Err:502

(22,788.0) Total

#DIV/0!

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

1311.0

Err:502

Err:502

(22,788.0)

Err:502

Err:502

#DIV/0!

Err:502

Err:502

#DIV/0!

#DIV/0!

Err:502

Err:502

#DIV/0!

#DIV/0!

Err:502

Err:502

#DIV/0!

#DIV/0!

Err:502

Err:502

#DIV/0!

#DIV/0!

Err:502

Err:502

#DIV/0!

#DIV/0!

Err:502

Err:502

#DIV/0!

-

-

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

0

January

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

0

February

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

Year 2008 13 January

14

#N/A

15

16

1

2

3

4

April

1 January

1Q 2005

1H 2005

2004 2004

#N/A 3Q 2007

4Q 2007

2 February

1Q 2005

2Q 2005

2005 2005

#N/A 1H 2012

February

March

2H 2012

3 March

1Q 2005

2006 2006

2016

2017

Err:502

Err:502

4 April

2Q 2005

2007 2007

January

February

March

April

5 May

2Q 2005

2008 2008

6 June

2Q 2005

2009 2009

7 July

3Q 2005

2010 2010

8 August

3Q 2005

2011 2011

9 September

3Q 2005

2012 2012

10 October

4Q 2005

2013 2013

11 November

4Q 2005

2014 2014

12 December

4Q 2005

2015 2015

13 January

1Q 2006

2016

14 February

1Q 2006

2017

15 March

1Q 2006

16 April

2Q 2006

17 May

2Q 2006

18 June

2Q 2006

19 July

3Q 2006

20 August

3Q 2006

21 September

3Q 2006

22 October

4Q 2006

23 November

4Q 2006

24 December

4Q 2006

25 January

1Q 2007

26 February

1Q 2007

27 March

1Q 2007

28 April

2Q 2007

29 May

2Q 2007

30 June

2Q 2007

31 July

3Q 2007

32 August

3Q 2007

33 September

3Q 2007

34 October

4Q 2007

35 November

4Q 2007

36 December

4Q 2007

#N/A

Display 0

March

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

0

April

4

December

FALSE January FALSE February FALSE March FALSE April FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

1

2

3

4

1 January

1Q 2004

1H 2005

2004

2 February

2Q 2004

2H 2005

2005

3 March

3Q 2004

1H 2006

2006

4 April

4Q 2004

2H 2006

2007

5 May

1Q 2005

1H 2007

2008

6 June

2Q 2005

2H 2007

2009

7 July

3Q 2005

1H 2008

2010

8 August

4Q 2005

2H 2008

2011

9 September

1Q 2006

1H 2009

2012

10 October

2Q 2006

2H 2009

2013

11 November

3Q 2006

1H 2010

2014

12 December

4Q 2006

2H 2010

2015

13

1Q 2007

1H 2011

14

2Q 2007

2H 2011

15

3Q 2007

1H 2012

16

4Q 2007

2H 2012

January February

1 2

March April May June July August September October November

3 4 5 6 7 8 9 10 11

December Err:502 Err:502 Err:502 Err:502

12