Docstoc

401K Tax Saving Calculator

Document Sample
401K Tax Saving Calculator Powered By Docstoc
					                                                                                                    Questions?
                                                                                      Email us at admin@simpleplanning.




 Retirement Calculator - Overview

Instructions                                                                                   Savings &
You may move from worksheet to worksheet by clicking on the dark blue buttons                 Contributions
located on each worksheet or the blue tabs at the bottom of each worksheet.
Use drop down boxes Roth IRA            , arrow buttons   or white cells      $5,000 to enter in your financial assumpt
Use your mouse, return or arrow keys to move to the next input box or button.
Be conservative with your assumptions. Assuming aggressive scenarios will generate improbable answers.
Red marked boxes provide additional comments when the mouse pointer is placed over the mark.

   Savings & Contributions
1. Solve for: Through a series of financial calculations, the Retirement Calculator determines:
   a The age at which you will run out of retirement funds                     How long will my retirement funds last?
   a Whether you're contributing enough to your retirement plan                Am I saving enough today?
   a How much you can spend during retirement                                  How much can I spend during retirement?
   a The earliest year in which you can retire                                 How soon can I retire?

2. Personal Information: Enter age (you and spouse), desired retirement age (you and spouse) and life expectancy.
3. Retirement Savings & Contributions: Enter the amount you and your spouse contribute to your retirement plan(s
     You may adjust/increase future contributions for inflation (401k/Other) or match that of the maximum
     allowable (IRA/Roth IRA) by checking the boxes to the right of the dollar amounts. If you have additional investm
     you would like to add to the list, click the Need additional lines for other investments? link at the bottom of the pa
     Time your contributions: You may determine (by using the drop down box to the right of the Savings & Contribu
     the timing of your retirement plan contributions:       At the beginning of each year

      Asset Allocation
4. Pre-Retirement Asset Allocation and Retirement Asset Allocation
      Pre-Retirement Asset Allocation: Use the drop down boxes           Large Cap Stocks (S&P 500) to choose the types
      Six options are provided along with their appropriate historical returns. You may customize the choices by clicki
      on the *Want to change investment options? link on the bottom of the page.
      You may choose to gradually reallocate your assets (as you would in real life) from your Pre-Retirement allocatio
      to your Retirement allocation plan by checking the box at the bottom of the page

     Income & Spending
5. Retirement Income: Enter in your expected annual Social Security benefits, pension or other income at the age yo
     For SS benefit estimates visit: www.ssa.gov/planners/calculators).
     Retirement Tax Rate: Use the arrow button to adjust your total tax rate (federal, state, Social Security) on all yo
     This tax rate will be applied to your SS and pension income as well as taxable retirement plan distributions (401k
      Note: Distributions/withdrawals from Roth IRA plans are not taxable.

6. Retirement Spending: Enter in what you expect to spend annually during retirement. Be sure to enter 'your dollar
      today's dollars (out-year spending will automatically be adjusted for inflation).

            Results
            Results
      On the first three pages you will find a "Simple Answer" section in
      the upper right hand corner of the page. This is provided in order                  Savings at Retirement:
      to illustrate (immediately) how each variable effects the results.                  Savings will last until:
7. Results:
      How long will my retirement funds last?
      Based on your inputs this calculation solves for the age at which your funds will run out. You would want the ans
      to match or exceed your life expectancy assumption.
      Am I saving enough today?
      Based on your retirement needs, this calculation determines the amount of savings you will need by retirement,
      your "Projected Savings" and then determines the necessary adjustment to your annual/monthly contribution.
      The adjustment calculation assumes that any addition/subtraction to your annual contribution will be made to yo
      not your spouse's . You have the option to customize the calculation by selecting yes or no for the questions bel
      annual adjustment (Adjust contributions for inflation?, Funds taxable during retirement? - meaning the distributio
      How much can I spend during retirement?
      Based on all your other financial assumptions, this calculation determines the exact amount you will be able to s
      your first year of retirement (and thereafter) without running out of funds prior to the life expectancy year.
      This calculation assumes that out-year spending will be increased annually due to inflation.
      How soon can I retire?
      Based on your inputs this calculation solves for the earliest age at which you can retire so that your funds will las
      life expectancy year. If the "Ending Balance" on the "Retirement Cash Flow" page is less than zero at the age o
      expectancy assumption, this simply means that your funds will run out during the middle of that year.
8. Graphs:
      To help illustrate the results, we've included a graph (to the right of the results) where you can choose to chart:
      Retirement Savings, Retirement Income (excl. distributions), Retirement Spending and Retirement Distribution/W
      You may view an enlarged version of the graph by clicking the "Click to view Larger Graph" button to the left of t
9. Detailed Results:
      Pre-Retirement Investment Detail
      This page details your annual financial contributions and investment return throughout your "Pre-Retirement" ye
      how your future contributions are adjusted/increased for inflation (401k/Other) or to match that of the maximum
      Retirement Cash Flow
      On this page, you will see yearly figures for:
      Age, Retirement Year, Other +/- Adjustment*, Social Security, Pension and Other Income, Retirement Distributio
      Estimated Taxes and Annual Spending
      *You may make manual adjustments for one time expenses/earnings in the blue cells                     beneath "Other
       (i.e. down payments, inheritance, real estate sales, etc.)

Financial Calculators available at www.simpleplanning.com
    - Budget Planner                     - Mortgage Calculator
    - Investment Calculator              - Tax Calculator
    - Retirement Planner                 - 401k Calculator

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?
           admin@simpleplanning.com
                                                    Begin




        Savings &
       Contributions


  to enter in your financial assumptions.

 te improbable answers.
over the mark.




ng will my retirement funds last?
aving enough today?
uch can I spend during retirement?
 on can I retire?

 and spouse) and life expectancy.
ontribute to your retirement plan(s) on an annual basis.
h that of the maximum
nts. If you have additional investments
ments? link at the bottom of the page.
he right of the Savings & Contributions)




s (S&P 500)   to choose the types of investments.
 ay customize the choices by clicking

 from your Pre-Retirement allocation plan



 sion or other income at the age you specify.

 al, state, Social Security) on all your taxable income.
 retirement plan distributions (401k, Trad. IRA, etc.)


ment. Be sure to enter 'your dollar amounts in
                Simple Answer:
  Savings at Retirement:              737,234
  Savings will last until:                 95



ll run out. You would want the answer, of course,


vings you will need by retirement, compares it to
ur annual/monthly contribution.
ual contribution will be made to your account,
ing yes or no for the questions below the necessary
 irement? - meaning the distribution of those funds)

exact amount you will be able to spend during
o the life expectancy year.
e to inflation.

an retire so that your funds will last until your
age is less than zero at the age of your life
he middle of that year.

) where you can choose to chart:
 ding and Retirement Distribution/Withdrawals
arger Graph" button to the left of the graph.


oughout your "Pre-Retirement" years. Here you will see
or to match that of the maximum allowable (IRA's)


her Income, Retirement Distributions/Withdrawals

ue cells            beneath "Other +/- (adjustments)"




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

e without the written consent from Simpleplanning.com.
d to inaccurate assumptions, calculation errors,
using this software.
Large Cap Stocks (S&P 500)
Small Cap Stocks
International Stocks (EAFE)
Corporate Bonds (AAA)
Long-term Government Bonds
 Savings &           Asset            Income &               Retirement       Investment                            Overview/
                                                                                                    Results
Contributions      Allocation         Spending               Cash Flow           Detail                               Help




   Retirement Calculator - Savings & Contributions                                            Open to Demo Users


    Solve for:                                                                                                 Retirement Savings
       How long will my retirement funds last?
       Am I saving enough today?
       How much can I spend during retirement?
       How soon can I retire?

    Personal Information
     46       Current Age                            15 years to retirement
      61         Desired Retirement Age
      90         Life Expectancy
      44         Current Age - Spouse                15 years to retirement
                                                                                         46    51     56      61   66      71   76   81
      59         Desired Retirement Age - Spouse
                                                                                              Chart: Retirement Savings
    Retirement Savings & Contributions
    Retirement Plan                 Savings          Annual Contribution
    401k                        $    110,000             $     5,000          Adjust future contributions for inflation?
    IRA- Spouse                 $      60,000            $     3,000          Increase future contribution to maximum allowable?
    Other                       $      10,000                                 Adjust future contributions for inflation?
    Other- Spouse               $       5,000                                 Adjust future contributions for inflation?
    Need additional lines for other investments? Click here




    Other Investment
        Adjust future contributions for inflation?
        Withdrawals during retirement will be taxable?
    Other Investments               Savings          Annual Contribution
     Stock XYZ
     Miscellaneous 2
     Miscellaneous 3
     Miscellaneous 4
     Miscellaneous 5
    Total                       $          -             $        -
    Return to top of page
                         Simple Answer:
             Savings at Retirement:            1,101,380
                                                           See Detailed Results
             Savings will last until:                 89




ment Savings                                                                      Solve   #   Plan Option Plan #
                                                                                   1      1      401k           1
                      $1,200,000
                                                                                          2   401k- Spouse      2
                      $1,000,000                                                          3       IRA           3
                                                                                          4   IRA- Spouse       4
                      $800,000
                                                                                          5     Roth IRA        5
                      $600,000                                                            6 Roth IRA- Spouse
                                                                                          7     Other
                                                                                          8 Other- Spouse
                      $400,000

                      $200,000

                      $0
        81     86
                                                                                                        1
vings
                                                                                              At the beginning of each year

                                                                                              Throughout the year
                                                                                              At the end of each year
                     Assume contributions are made:
                    At the beginning of each year




                                               Next
                                                                                     10%


                       Plan   Plan Name       Savings       Contribution       @ Retire     Inflation? Taxable     Yrs to Retire
                        1     401k            $ 110,000     $    5,000     $     636,335     TRUE          100%        1500%
                        4     IRA- Spouse     $   60,000    $    3,000     $     404,531     TRUE          100%
                        7     Other           $   10,000    $       -      $      40,343    FALSE          100%
                        8     Other- Spouse   $    5,000    $       -      $      20,171    FALSE          100%
                              Misc            $         -   $       -      $          -      TRUE          100%        TRUE
                              Total           $ 185,000     $    8,000     $    1,101,380                 100.0%




the beginning of each year                    Am I saving enough today?                     Chart
                                                                                                    1
the end of each year
     Savings &           Asset          Income &          Retirement      Investment
                                                                                           Results
    Contributions      Allocation       Spending          Cash Flow          Detail



       Asset Allocation                                                                Closed to Demo Users

        Pre-Retirement Asset Allocation
                                                Allocation      Return*
        International Stocks (EAFE)                30%          12.4%
        Small Cap Stocks                           25%          12.2%
               6
        International Stocks (EAFE)                15%          12.4%
        Corporate Bonds (AAA)                      20%          7.6%
        Other                                      10%          2.0%
        Total                                      100%         10.4%

        Retirement Asset Allocation
                                                Allocation      Return*
        Large Cap Stocks (S&P 500)                 10%          10.2%
        Corporate Bonds (AAA)                      35%          7.6%

1       Long-term Government Bonds                 30%          5.4%
        U.S. Treasury Bills                        15%          3.7%
        Other                                      10%          0.0%
        Total                                      100%         5.9%

            Gradually reallocate assets from my "pre-retirement" allocation plan to my
        retirement allocation plan starting   5       years prior to retirement.
        *Want to change investment options? Click here




            Use investment options below for pre-retirement allocation
            Use investment options below for retirement allocation
        Investment Vehicle                                     Return
        Mutual Fund A                                            9.0%
        Mutual Fund B                                           10.0%
        Mutual Fund C                                           11.0%
        Mutual Fund D                                            8.0%
        Stock A                                                 12.0%
        Stock B                                                 12.0%
        Return to top of page
                                                Simple Answer:
                Overview/          Savings at Retirement:                    1,101,380
    Results                                                                              See Detailed Results
                  Help             Savings will last until:                         89



Closed to Demo Users



                   Pre- Retirement Allocation

                                               International Stocks (EAFE)
                                               Small Cap Stocks
                                               International Stocks (EAFE)
                                               Corporate Bonds (AAA)
                                               Other




                       Retirement Allocation

                                               Large Cap Stocks (S&P 500)
                                               Corporate Bonds (AAA)
                                               Long-term Government Bonds
                                               U.S. Treasury Bills
                                               Other




                                                             Back            Next
  Inv Type        Return           Volatility   Asset #       Pre-Retire #
                                                                         Pre-Retire Inv    Alloc        Return   Volatility
1 Large Cap Stocks (S&P 500)
                         10.2%                            1                                       30
                                                                         3 International Stocks (EAFE)     12%         0%


2 Small Cap Stocks         12.2%                          2              2 Small Cap Stocks        25      12%         0%
3 International Stocks (EAFE)
                           12.4%                          3                                       15
                                                                         3 International Stocks (EAFE)     12%         0%
4 Corporate Bonds (AAA)    7.6%                           4                                    2
                                                                         4 Corporate Bonds (AAA) 0          8%         0%
                         5.4%
5 Long-term Government Bonds                              5                Other                   10       2%         0%
6 U.S. Treasury Bills      3.7%
      FALSE




  Inv Type        Return                        Asset #       Retire #     Retire Inv      Alloc        Return   Volatility

1 Large Cap Stocks (S&P 500)
                         10.2%                            1                                    10
                                                                         1 Large Cap Stocks (S&P 500) 10%              0%

2 Small Cap Stocks         12.2%                          2                                    3
                                                                         4 Corporate Bonds (AAA) 5    8%               0%
3 International Stocks (EAFE)
                           12.4%                          3                                    30
                                                                         5 Long-term Government Bonds 5%               0%
4 Corporate Bonds (AAA)    7.6%                           4              6 U.S. Treasury Bills     15       4%         0%
                         5.4%
5 Long-term Government Bonds                              5                Other                   10       6%         0%
6 U.S. Treasury Bills      3.7%
                                                                                                   4
      FALSE




                                     TRUE        FALSE
 Savings &           Asset            Income &         Retirement          Investment                      Overview/
                                                                                                 Results
Contributions      Allocation         Spending         Cash Flow              Detail                         Help



   Retirement Income & Spending                                                           Closed to Demo Users

    Retirement Income
                                                 1st Year of                        Adjust for
                                                                    Start at Age:
                                                   Income                           inflation?
     Social Security                             $ 20,000                64         Yes
     Social Security- Spouse                     $ 12,000                68         Yes
     Pension                                     $ 10,000                64         No
     Other                                                                          No
    Total                                        $   42,000
                                                                                                           61      64     67
    Retirement Tax Rate:        25%       25
                                                                                                           Other        Pension


    Retirement Spending

    Inflation: 2.7%                              Today's $'s    After Inflation*
    Transportation                               $ 7,000            $    10,439
    Home                                         $ 12,000           $    17,895
    Utilities                                    $ 6,000            $     8,948
    Health                                       $ 5,000            $     7,456
    Entertainment                                $ 10,000           $    14,913
    Miscellaneous                                $ 5,000            $     7,456
    Total                                        $ 45,000           $    67,107
    *Spending during first year of retirement- future spending is
     adjusted for inflation
                                Simple Answer:
Overview/           Savings at Retirement:                    1,101,380
                                                                          See Detailed Results
                    Savings will last until:                        89                           1 Social Security

                                                                                                 2 Social Security- Spouse
                                                                                                 3 Pension
                                                                                                 5 Other


               Retirement Income                         $70,000

                                                         $60,000

                                                         $50,000

                                                         $40,000

                                                         $30,000

                                                         $20,000

                                                         $10,000

                                                         $0

        67     70   73    76    79    82   85     88
     Pension     Social Security- Spouse   Social Security




               Retirement Spending

                                           Transportation                                          Transportation
                                           Home                                                    Home
                                           Utilities                                               Utilities
                                           Health
                                                                                                   Health
                                           Entertainment
                                           Miscellaneous                                           Entertainment
                                                                                                   Miscellaneous




                                              Back            Results
                      8    0.027                               Yes
$   20,000   64   1   1    2.0%    1 Social Security           No

$   12,000   68   1   2    2.1%    2 Social Security- Spouse
$   10,000   64   2   3    2.2%    3 Pension
$      -      0   2   4    2.3%    4 Pension- Spouse
                      5    2.4%    5 Other


                      6    2.5%    6 Other- Spouse
                      7    2.6%
                      8    2.7%
                       9   2.8%
                      10   2.9%
                      11   3.0%
                      12   3.1%
                      13   3.2%




      16%    15
      27%
      13%
      11%
      22%
      11%
           Savings &         Asset       Income &       Retirement      Investment                          Overview/
                                                                                            Results
          Contributions    Allocation    Spending       Cash Flow          Detail                             Help



              Results
              How long will my retirement funds last?

                                                                                                                                Retirement
    90%

    80%       How long will my retirement funds last?
    70%
    60%
      1
    ###
              Savings at Retirement       $ 1,101,380
                                                                     Click to view Larger Graph
      1       Fund will last until age         89



1             Savings at Retirement                           Increase Contribution by
              Projected Savings           $ 1,101,380         Monthly         $        62
              Required Savings*           $ 1,130,102         Annually        $ 745.77
              Shortfall                   $ (28,722)
                                                              Adjust contributions for inflation?     yes    46     51     56
                                                              Funds taxable during retirement?        yes
    15%                                                                                                           Chart:
    20%       Detail Results
    25%       Current Savings             $   185,000         See Pre-Retirement Investment Detail
      1       Total Contributions         $   169,976         See Retirement Cash Flow
              Investment Gains            $   746,403         See Enlarged Graph Above
              Total Savings               $ 1,101,380
                                                       Chart Option
                                                   1   Retirement Savings
                                                   2   Retirement Income (excl. distributions)
                                                   3   Retirement Spending
                                                   4   Retirement Distribution/Withdrawals
     Retirement Savings                                                     1
                                                       Retirement Savings

                                      $1,200,000


                                      $1,000,000


                                      $800,000


                                      $600,000


                                      $400,000
                                                       Am I saving enough today? Validation
                                      $200,000         Inf Choice
                                                       Tax Choice
                                      $0
                                                       yes
56   61   66   71    76   81     86                    no
                                                       yes
Retirement Savings                                     no




                          Back
                    1 Solve                                     Age
                    1 How long will my retirement funds last?              89 $     1,101,380
                    2 Am I saving enough today?                            61 $     1,101,380   $   1,130,102      28,722
                    3 How much can I spend during retirement?                 $        65,959
                    4 How soon can I retire?                               61 $     1,130,102




aving enough today? Validation                                  Conditional Formatting
                    1                                                       0 Am I saving enough today?
                    1                                                       0 How much can I spend during retirement?
                    1                                                       0
                    2                                                       0
                                                                            1 $          -      Am I saving enough today?
                                                                            2                   How much can I spend during retirement?


                                                                                Am I saving enough today?
                                                                            0 Minimal Adjust necessary
                                                                                    2000
Am I saving enough today?
Inflation Adjustment

                                                          1
              15 Years                     At the beginning of each year
         9.45% Inv Rate              9.4% Throughout the year
$      (28,722) Shortfall/Excess           At the end of each year
            863 Without inflation adj.
            746 With inflation      2.7%                                             $   28,722
Year            Savings        ContributionSavings                                        33235
       1               1.10          863              952            10.4%   10.4%       $4,512 inflation adj.
       2               2.32          886             2029            10.4%   10.4%       11.09% Realized rate
       3               3.66          910             3243            10.4%   10.4%         $117 Inflation adjustment
       4               5.15          935             4610            10.4%   10.4%
       5               6.78          960             6147            10.4%   10.4%
       6             8.59            986             7871            10.4%   10.4%
       7             10.58          1013             9803            10.4%   10.4%
       8             12.78          1040            11965            10.4%   10.4%

       9             15.21          1068            14382            10.4%   10.4%
       10            17.88          1097            17080            10.4%   10.4%
       11            20.84          1126            20091            10.4%   10.4%
       12            23.90          1157            23256             9.5%   9.5%
       13            27.03          1188            26535             8.6%   8.6%
       14            30.18          1220            29879             7.7%   7.7%
       15            33.28          1253            33235             6.8%   6.8%
       16            36.29          1287            36543             5.9%   5.9%
       17            39.48          1322            40081             5.9%   5.9%
       18            42.84          1357            43865             5.9%   5.9%
       19            46.41          1394            47909             5.9%   5.9%
       20
       21            50.19
                     54.19          1432
                                    1470            52229
                                                    56843             5.9%
                                                                      5.9%   5.9%
                                                                             5.9%
       22            58.42          1510            61770             5.9%   5.9%
       23            62.90          1551            67028             5.9%   5.9%
       24            67.64          1593            72638             5.9%   5.9%
       25            72.65          1636            78623             5.9%   5.9%
       26            77.97          1680            85004             5.9%   5.9%
       27            83.59          1725            91807             5.9%   5.9%
       28            89.54          1772            99058             5.9%   5.9%
       29            95.84          1819          106784              5.9%   5.9%
       30           102.52          1869          115014              5.9%   5.9%
       31           109.58          1919          123779              5.9%   5.9%
       32           117.05          1971          133113              5.9%   5.9%
       33           124.96          2024          143049              5.9%   5.9%
       34           133.34          2079          153625              5.9%   5.9%
       35           142.20          2135          164880              5.9%   5.9%
       36           151.59          2193          176855              5.9%   5.9%
                   =AO5*(1+'Income & Spending'!G18-'Income & Spending'!G18*AQ5)
Tax Adjustment     =AC6*(1+'Income & Spending'!G18*AP5)

                   Savings Diff   Adj Diff     Current       New Estimate New             Old Tax NPV     New Tax NPV
Taxable Acct       $    28,722    $   28,722       100.00%      100.00%         100.00%     $184,195.71
Non Taxable Acct   $    28,722    $   21,724       100.00%       97.46%         98.07%      $184,195.71
                                   Chart                Column       Width           Height
                                     1                           7               1            44
                                                                 1               1              1       1

NPV Delta    Cont Adjustment        61     Savings              Social Security- Spouse Other
                                                    Social Security         Pension
        $0         $0.00       0    46      185,000         -           -            -        -
        $0         $0.00       0    47      212,976         -           -            -        -
                               0    48      245,099         -           -            -        -
                               0    49      280,700     20,000          -         10,000      -
                               0    50      320,143        20,540            -           10,000     -
                               0    51      364,933        21,095            -           10,000     -
                               0    52      414,525        21,664            -           10,000     -
                               0
                               0    53
                                    54      470,524
                                            532,492        22,249
                                                           22,850            -
                                                                             -           10,000
                                                                                         10,000     -
                                                                                                    -
                               0
                               0    55
                                    56      601,055
                                            676,897        23,467
                                                           24,100       12,000
                                                                        12,324           10,000
                                                                                         10,000     -
                                                                                                    -
                               0    57      760,779        24,751       12,657           10,000     -
                               0    58      846,583        25,419       12,998           10,000     -
                               0    59      932,969        26,106       13,349           10,000     -
                               0    60     1,018,438       26,810       13,710           10,000     -
                               1    61     1,101,380       27,534       14,080           10,000     -
                               1    62     1,077,070       28,278       14,460           10,000     -
                               1    63     1,048,940       29,041       14,851           10,000     -
                               1    64     1,016,700       29,825       15,252           10,000     -
                               1    65     1,011,800       30,631       15,663           10,000     -
                               1    66     1,004,589       31,458       16,086           10,000     -
                               1    67      994,875        32,307       16,521           10,000     -
                               1    68      982,456        33,179       16,967           10,000     -
                               1    69      967,116        34,075       17,425           10,000     -
                               1    70      948,624        34,995       17,895           10,000     -
                               1
                               1    71
                                    72      939,439
                                            927,683        35,940
                                                           36,911       18,378
                                                                        18,875           10,000
                                                                                         10,000     -
                                                                                                    -
                               1    73       913,150       37,907       19,384           10,000     -
                               1    74       895,621       38,931       19,908           10,000     -
                               1    75       874,863       39,982       20,445           10,000     -
                               1    76       850,628       41,061       20,997           10,000     -
                               1    77       822,651       42,170       21,564           10,000     -
                               1    78       790,649       43,308       22,146           10,000     -
                               1    79       754,324       44,478       22,744           10,000     -
                               1    80       713,355       45,679       23,358           10,000     -
                               1    81       667,404       46,912       23,989           10,000     -
                               1    82       616,107       48,179       24,637           10,000     -
                               1    83       559,081       49,479       25,302           10,000     -
                               1    84       495,917       50,815       25,985           10,000     -
                               1    85       426,180       52,187       26,687           10,000     -
                               1    86       349,406       53,596       27,407           10,000     -
                               1    87       265,106       55,044       28,147           10,000     -
                               1    88       172,755       56,530       28,907           10,000     -
                               1    89        71,798       58,056       29,688           10,000     -
                               1    90       (36,232)      59,624       30,489           10,000     -
                               1    91      (147,450)      61,233       31,312           10,000     -
                               1    92      (261,940)      62,887       32,158           10,000     -
1    93     (379,792)   64,585   33,026   10,000   -
1    94     (501,096)   66,328   33,918   10,000   -
1    95     (625,944)   68,119   34,834   10,000   -
1    96     (754,434)
1    97     (886,663)
1    98   (1,022,732)
1    99   (1,162,745)
1   100   (1,306,809)
1   101   (1,455,032)
1   102   (1,607,527)
1   103   (1,764,410)
1   104   (1,925,798)
1   105   (2,091,814)
1   106   (2,262,582)
1   107   (2,438,231)
1   108   (2,618,893)
1   109   (2,804,702)
1   110   (2,995,798)
               Move Column
                        0


              Spending
Retirement Distributions
      67,107       67,107
      68,919       68,919
      70,780       70,780
      42,691       72,691
      44,114      74,654
      45,575      76,669
      47,075      78,739
      48,616
      50,199      80,865
                  83,049
      39,824
      41,170      85,291
                  87,594
      42,551      89,959
      43,970      92,388
      45,427      94,882
      46,924      97,444
      48,461     100,075
      50,039     102,777
      51,660     105,552
      53,325     108,402
      55,035     111,329
      56,791     114,335
      58,594     117,422
      60,446     120,592
      62,348     123,848
      64,301     127,192
      66,308
      68,368     130,626
                 134,153
     70,484      137,775
     72,657      141,495
     74,889      145,316
     77,181      149,239
     79,535      153,269
     81,952      157,407
     84,435      161,657
     86,984      166,021
     89,603      170,504
     92,292      175,108
     95,054      179,836
     97,891      184,691
    100,804      189,678
    103,795      194,799
    106,868      200,059
    110,023      205,460
    113,264      211,008
    116,592      216,705
    120,010      222,556
    123,520      228,565
127,125   234,736
130,828   241,074
134,630   247,583
      Savings &          Asset            Income &           Retirement          Investment                             Overview/
                                                                                                      Results
     Contributions
        61
                       Allocation
                           1,130,102
                                          Spending           Cash Flow              Detail


           61             1,101,380
           Retirement Cash Flow
                                                                            Social
                Ret.   Beginning         Other +/-         Social          Security-
29   Age        Year    Balance        (adjustments)       Security         Spouse          Pension         Other
      61         1      $1,101,380                     $         -     $          -     $        -      $           -
0     62         2      $1,077,070                     $         -     $          -     $        -      $           -
0     63         3      $1,048,940                     $         -     $          -     $        -      $           -
0     64         4      $1,016,700                     $      20,000   $          -     $     10,000    $           -
0     65         5      $1,011,800                     $      20,540   $          -     $     10,000    $           -
0     66         6      $1,004,589                     $      21,095   $          -     $     10,000    $           -
0     67         7       $994,875                      $      21,664   $          -     $     10,000    $           -
0     68         8       $982,456                      $      22,249   $          -     $     10,000    $           -
0     69         9       $967,116                      $      22,850   $          -     $     10,000    $           -
0     70         10      $948,624                      $      23,467   $       12,000   $     10,000    $           -
0     71         11      $939,439                      $      24,100   $       12,324   $     10,000    $           -
0     72         12      $927,683                      $      24,751   $       12,657   $     10,000    $           -
0     73         13      $913,150                      $      25,419   $       12,998   $     10,000    $           -
0     74         14      $895,621                      $      26,106   $       13,349   $     10,000    $           -
0     75         15      $874,863                      $      26,810   $       13,710   $     10,000    $           -
0     76         16      $850,628                      $      27,534   $       14,080   $     10,000    $           -
0     77         17      $822,651                      $      28,278   $       14,460   $     10,000    $           -
0     78         18      $790,649                      $      29,041   $       14,851   $     10,000    $           -
0     79         19      $754,324                      $      29,825   $       15,252   $     10,000    $           -
0     80         20      $713,355                      $      30,631   $       15,663   $     10,000    $           -
0     81         21      $667,404                      $      31,458   $       16,086   $     10,000    $           -
0     82         22      $616,107                      $      32,307   $       16,521   $     10,000    $           -
0     83         23      $559,081                      $      33,179   $       16,967   $     10,000    $           -
0     84         24      $495,917                      $      34,075   $       17,425   $     10,000    $           -
0     85         25      $426,180                      $      34,995   $       17,895   $     10,000    $           -
0     86         26      $349,406                      $      35,940   $       18,378   $     10,000    $           -
0     87         27      $265,106                      $      36,911   $       18,875   $     10,000    $           -
0     88         28      $172,755                      $      37,907   $       19,384   $     10,000    $           -
1     89         29        $71,798                     $      38,931   $       19,908   $     10,000    $           -
0     90         30       ($36,232)                    $      39,982   $       20,445   $     10,000    $           -
0     91         31      ($147,450)                    $      41,061   $       20,997   $     10,000    $           -
0     92         32      ($261,940)                    $      42,170   $       21,564   $     10,000    $           -
0     93         33      ($379,792)                    $      43,308   $       22,146   $     10,000    $           -
0     94         34      ($501,096)                    $      44,478   $       22,744   $     10,000    $           -
0     95         35      ($625,944)                    $      45,679   $       23,358   $     10,000    $           -
0     96         36      ($754,434)                    $      46,912   $       23,989   $     10,000    $           -
0     97         37      ($886,663)                    $      48,179   $       24,637   $     10,000    $           -
0     98         38    ($1,022,732)                    $      49,479   $       25,302   $     10,000    $           -
0     99         39    ($1,162,745)                    $      50,815   $       25,985   $     10,000    $           -
0    100         40    ($1,306,809)                    $      52,187   $       26,687   $     10,000    $           -
0    101         41    ($1,455,032)                    $      53,596   $       27,407   $     10,000    $           -
0   102   42   ($1,607,527)   $   55,044   $   28,147   $   10,000   $   -
0   103   43   ($1,764,410)   $   56,530   $   28,907   $   10,000   $   -
0   104   44   ($1,925,798)   $   58,056   $   29,688   $   10,000   $   -
0   105   45   ($2,091,814)   $   59,624   $   30,489   $   10,000   $   -
0   106   46   ($2,262,582)   $   61,233   $   31,312   $   10,000   $   -
0   107   47   ($2,438,231)   $   62,887   $   32,158   $   10,000   $   -
0   108   48   ($2,618,893)   $   64,585   $   33,026   $   10,000   $   -
0   109   49   ($2,804,702)   $   66,328   $   33,918   $   10,000   $   -
0   110   50   ($2,995,798)   $   68,119   $   34,834   $   10,000   $   -
Overview/
  Help




 Retirement                      Investment        Ending        Annual
 Distributions   Estimated Tax      Return         Balance      Spending
     ($67,107)       ($16,777) $      59,574   $ 1,077,070        $67,107
     ($68,919)       ($17,230) $      58,018   $ 1,048,940        $68,919
     ($70,780)       ($17,695) $      56,235   $ 1,016,700        $70,780
     ($42,691)       ($18,173) $      55,964   $ 1,011,800        $72,691
     ($44,114)       ($18,663) $      55,565   $ 1,004,589        $74,654
     ($45,575)       ($19,167) $      55,028   $     994,875      $76,669   90
     ($47,075)       ($19,685) $      54,341   $     982,456      $78,739   61
     ($48,616)       ($20,216) $      53,493   $     967,116      $80,865   29
     ($50,199)       ($20,762) $      52,470   $     948,624      $83,049
     ($39,824)       ($21,323) $      51,962   $     939,439      $85,291
     ($41,170)       ($21,898) $      51,312   $     927,683      $87,594
     ($42,551)       ($22,490) $      50,508   $     913,150      $89,959
     ($43,970)       ($23,097) $      49,538   $     895,621      $92,388
     ($45,427)       ($23,721) $      48,390   $     874,863      $94,882
     ($46,924)       ($24,361) $      47,050   $     850,628      $97,444
     ($48,461)       ($25,019) $      45,502   $     822,651     $100,075
     ($50,039)       ($25,694) $      43,732   $     790,649     $102,777
     ($51,660)       ($26,388) $      41,723   $     754,324     $105,552
     ($53,325)       ($27,100) $      39,457   $     713,355     $108,402
     ($55,035)       ($27,832) $      36,915   $     667,404     $111,329
     ($56,791)       ($28,584) $      34,078   $     616,107     $114,335
     ($58,594)       ($29,355) $      30,924   $     559,081     $117,422
     ($60,446)       ($30,148) $      27,430   $     495,917     $120,592
     ($62,348)       ($30,962) $      23,573   $     426,180     $123,848
     ($64,301)       ($31,798) $      19,326   $     349,406     $127,192
     ($66,308)       ($32,657) $      14,663   $     265,106     $130,626
     ($68,368)       ($33,538) $       9,555   $     172,755     $134,153
     ($70,484)       ($34,444) $       3,971   $      71,798     $137,775
     ($72,657)       ($35,374) $         -     $     (36,232)    $141,495
     ($74,889)       ($36,329) $         -     $    (147,450)    $145,316
     ($77,181)       ($37,310) $         -     $    (261,940)    $149,239
     ($79,535)       ($38,317) $         -     $    (379,792)    $153,269
     ($81,952)       ($39,352) $         -     $    (501,096)    $157,407
     ($84,435)       ($40,414) $         -     $    (625,944)    $161,657
     ($86,984)       ($41,505) $         -     $    (754,434)    $166,021
     ($89,603)       ($42,626) $         -     $    (886,663)    $170,504
     ($92,292)       ($43,777) $         -     $ (1,022,732)     $175,108
     ($95,054)       ($44,959) $         -     $ (1,162,745)     $179,836
     ($97,891)       ($46,173) $         -     $ (1,306,809)     $184,691
   ($100,804)        ($47,419) $         -     $ (1,455,032)     $189,678
   ($103,795)        ($48,700) $         -     $ (1,607,527)     $194,799
($106,868)   ($50,015) $   -   $ (1,764,410)   $200,059
($110,023)   ($51,365) $   -   $ (1,925,798)   $205,460
($113,264)   ($52,752) $   -   $ (2,091,814)   $211,008
($116,592)   ($54,176) $   -   $ (2,262,582)   $216,705
($120,010)   ($55,639) $   -   $ (2,438,231)   $222,556
($123,520)   ($57,141) $   -   $ (2,618,893)   $228,565
($127,125)   ($58,684) $   -   $ (2,804,702)   $234,736
($130,828)   ($60,269) $   -   $ (2,995,798)   $241,074
($134,630)   ($61,896) $   -   $ (3,192,324)   $247,583
                                               Social
                                              Security-                           Age         Spending
 Starting Balance         Social Security      Spouse        Pension   Other   Differential   Today's $'s   Est. Tax
         1,101,380              64               70            64       0           2           45000        25%
                               2.7%             2.7%          0.0%     0.0%                     0.027       100.0%
                              20000            12000         10000      0                         46         25%
                                 0                1             0       0                                   25.0%

     Avg Income          Avg Withdrawl
              45,271                 21,837        67,107
               25.0%                  25.0%            25%




          1
How long will my retirement funds last?




Am I saving enough today?




How much will I be be able to withdraw?




How soon can I retire?
Retire Inv.
 Return
    6%
 Savings &            Asset           Income &         Retirement          Investment                        Overview/
                                                                                            Results
Contributions       Allocation        Spending         Cash Flow              Detail                           Help



      Pre-Retirement Investment Detail
                                                               Contributions
        Inv.        Beginning                                                      Other-                   Investment
Age     Year         Balance          401k       IRA- Spouse       Other           Spouse       Misc.          Return
 46       1     $       185,000   $     5,000    $    3,000    $       -       $        -   $       -   $        19,976
 47       2     $       212,976   $     5,135    $    4,000    $       -       $        -   $       -   $        22,988
 48       3     $       245,099   $     5,274    $    4,000    $       -       $        -   $       -   $        26,328
 49       4     $       280,700   $     5,416    $    4,000    $       -       $        -   $       -   $        30,027
 50       5     $       320,143   $     5,562    $    5,000    $       -       $        -   $       -   $        34,228
 51       6     $       364,933   $     5,712    $    5,000    $       -       $        -   $       -   $        38,879
 52       7     $       414,525   $     5,867    $    6,000    $       -       $        -   $       -   $        44,132
 53       8     $       470,524   $     6,025    $    6,000    $       -       $        -   $       -   $        49,944
 54       9     $       532,492   $     6,188    $    6,000    $       -       $        -   $       -   $        56,374
 55      10     $       601,055   $     6,355    $    6,000    $       -       $        -   $       -   $        63,488
 56      11     $       676,897   $     6,526    $    6,000    $       -       $        -   $       -   $        71,355
 57      12     $       760,779   $     6,703    $    6,000    $       -       $        -   $       -   $        73,102
 58      13     $       846,583   $     6,884    $    6,000    $       -       $        -   $       -   $        73,502
 59      14     $       932,969   $     7,069    $    6,000    $       -       $        -   $       -   $        72,400
 60      15     $     1,018,438   $     7,260    $    6,000    $       -       $        -   $       -   $        69,681
 61      16     $     1,101,380   $     7,456    $      -      $       -       $        -   $       -   $        64,922
 62      17     $     1,173,758   $     7,658    $      -      $       -       $        -   $       -   $        69,172
 63      18     $     1,250,588   $     7,864    $      -      $       -       $        -   $       -   $        73,682
 64      19     $     1,332,135   $     8,077    $      -      $       -       $        -   $       -   $        78,469
 65      20     $     1,418,681   $     8,295    $      -      $       -       $        -   $       -   $        83,549
 66      21     $     1,510,525   $     8,519    $      -      $       -       $        -   $       -   $        88,940
 67      22     $     1,607,984   $     8,749    $      -      $       -       $        -   $       -   $        94,660
 68      23     $     1,711,393   $     8,985    $      -      $       -       $        -   $       -   $       100,728
 69      24     $     1,821,106   $     9,228    $      -      $       -       $        -   $       -   $       107,166
 70      25     $     1,937,499   $     9,477    $      -      $       -       $        -   $       -   $       113,995
 71      26     $     2,060,972   $     9,733    $      -      $       -       $        -   $       -   $       121,240
 72      27     $     2,191,944   $     9,995    $      -      $       -       $        -   $       -   $       128,924
 73      28     $     2,330,863   $    10,265    $      -      $       -       $        -   $       -   $       137,073
 74      29     $     2,478,201   $    10,542    $      -      $       -       $        -   $       -   $       145,716
 75      30     $     2,634,460   $    10,827    $      -      $       -       $        -   $       -   $       154,882
 76      31     $     2,800,168   $    11,119    $      -      $       -       $        -   $       -   $       164,601
 77      32     $     2,975,889   $    11,420    $      -      $       -       $        -   $       -   $       174,907
 78      33     $     3,162,215   $    11,728    $      -      $       -       $        -   $       -   $       185,834
 79      34     $     3,359,778   $    12,045    $      -      $       -       $        -   $       -   $       197,420
 80      35     $     3,569,243   $    12,370    $      -      $       -       $        -   $       -   $       209,703
 81      36     $     3,791,316   $    12,704    $      -      $       -       $        -   $       -   $       222,725
 82      37     $     4,026,745   $    13,047    $      -      $       -       $        -   $       -   $       236,530
 83      38     $     4,276,322   $    13,399    $      -      $       -       $        -   $       -   $       251,163
 84      39     $     4,540,884   $    13,761    $      -      $       -       $        -   $       -   $       266,674
 85      40     $     4,821,319   $    14,132    $      -      $       -       $        -   $       -   $       283,116
 60
                           Check                 1             1           1           1           1
                                                 1             4           0           0           1

                                     -2       2.7%        2.7%         0.0%        0.0%        2.7%

                            Spouse=0            1          -               1       -               1
                 Max IRA     S Max
                 Contributi   IRA
Ending Balance      on      Contributi 401k          IRA- Spouse Other Other- Spouse Misc.
$     212,976                             $ 5,000     $ 3,000      $   -       $   -       $   -
$     245,099    $ 4,000    $ 4,000       $ 5,135     $ 3,081      $   -       $   -       $   -
$     280,700    $ 4,000    $ 4,000       $ 5,274     $ 3,164      $   -       $   -       $   -
$     320,143    $ 4,000    $ 4,000       $ 5,416     $ 3,250      $   -       $   -       $   -
$     364,933    $ 6,000    $ 5,000       $ 5,562     $ 3,337      $   -       $   -       $   -
$     414,525    $ 6,000    $ 5,000       $ 5,712     $ 3,427      $   -       $   -       $   -
$     470,524    $ 6,000    $ 6,000       $ 5,867     $ 3,520      $   -       $   -       $   -
$     532,492    $ 6,000    $ 6,000       $ 6,025     $ 3,615      $   -       $   -       $   -
$     601,055    $ 6,000    $ 6,000       $ 6,188     $ 3,713      $   -       $   -       $   -
$     676,897    $ 6,000    $ 6,000       $ 6,355     $ 3,813      $   -       $   -       $   -
$     760,779    $ 6,000    $ 6,000       $ 6,526     $ 3,916      $   -       $   -       $   -
$     846,583    $ 6,000    $ 6,000       $ 6,703     $ 4,022      $   -       $   -       $   -
$     932,969    $ 6,000    $ 6,000       $ 6,884     $ 4,130      $   -       $   -       $   -
$   1,018,438    $ 6,000    $ 6,000       $ 7,069     $ 4,242      $   -       $   -       $   -
$   1,101,380    $ 6,000    $ 6,000       $ 7,260     $ 4,356      $   -       $   -       $   -
$   1,173,758    $ 6,000    $    -        $ 7,456     $    -       $   -       $   -       $   -
$   1,250,588    $ 6,000    $    -        $ 7,658     $    -       $   -       $   -       $   -
$   1,332,135    $ 6,000    $    -        $ 7,864     $    -       $   -       $   -       $   -
$   1,418,681    $ 6,000    $    -        $ 8,077     $    -       $   -       $   -       $   -
$   1,510,525    $ 6,000    $    -        $ 8,295     $    -       $   -       $   -       $   -
$   1,607,984    $ 6,000    $    -        $ 8,519     $    -       $   -       $   -       $   -
$   1,711,393    $ 6,000    $    -        $ 8,749     $    -       $   -       $   -       $   -
$   1,821,106    $ 6,000    $    -        $ 8,985     $    -       $   -       $   -       $   -
$   1,937,499    $ 6,000    $    -        $ 9,228     $    -       $   -       $   -       $   -
$   2,060,972    $ 6,000    $    -        $ 9,477     $    -       $   -       $   -       $   -
$   2,191,944    $ 6,000    $    -        $ 9,733     $    -       $   -       $   -       $   -
$   2,330,863    $ 6,000    $    -        $ 9,995     $    -       $   -       $   -       $   -
$   2,478,201    $ 6,000    $    -        $ 10,265    $    -       $   -       $   -       $   -
$   2,634,460    $ 6,000    $    -        $ 10,542    $    -       $   -       $   -       $   -
$   2,800,168    $ 6,000    $    -        $ 10,827    $    -       $   -       $   -       $   -
$   2,975,889    $ 6,000    $    -        $ 11,119    $    -       $   -       $   -       $   -
$   3,162,215    $ 6,000    $    -        $ 11,420    $    -       $   -       $   -       $   -
$   3,359,778    $ 6,000    $    -        $ 11,728    $    -       $   -       $   -       $   -
$   3,569,243    $ 6,000    $    -        $ 12,045    $    -       $   -       $   -       $   -
$   3,791,316    $ 6,000    $    -        $ 12,370    $    -       $   -       $   -       $   -
$   4,026,745    $ 6,000    $    -        $ 12,704    $    -       $   -       $   -       $   -
$   4,276,322    $ 6,000    $    -        $ 13,047    $    -       $   -       $   -       $   -
$   4,540,884    $ 6,000    $    -        $ 13,399    $    -       $   -       $   -       $   -
$   4,821,319    $ 6,000    $    -        $ 13,761    $    -       $   -       $   -       $   -
$   5,118,567    $ 6,000    $    -        $ 14,132    $    -       $   -       $   -       $   -
                    6000        6000
 Savings &             Asset      Income &        Retirement     Investment                      Overview/
                                                                                  Results
Contributions        Allocation   Spending        Cash Flow         Detail                         Help


    Graph
                                                               Retirement Savings




                46          51     56        61           66          71         76         81        86
                                                                           Age
                                             Chart:      Retirement Savings
$1,200,000



$1,000,000



$800,000



$600,000



$400,000



$200,000



$0
1

				
DOCUMENT INFO
Description: 401K Tax Saving Calculator document sample