60               61       62        63                64               65       66
Input
                                  Now      Amount                                At Retirement
                       Your current age          60                  Annual pension benefit ($)
                       Annual income ($)   $50,000         Annual pension benefit increases (%)
Annual inflation & income increases (%)     3.00%                       Desired retirement age
        Retirement savings balance ($)     $60,000     Number of years of retirement income
            Annual savings amount ($)      $15,000                     Income replacement (%)
Annual savings increases (%)         0.00%              Investment return (%)
        Investment return (%)        6.25%
                                             Chart details
Age            Salary            Balance     Interest       Yearly savings
 60           $50,000           $60,000      $3,750            $15,000
 61           $51,500           $78,750      $4,922            $15,000
 62           $53,045           $98,672      $6,167            $15,000
 63             $0              $119,839     $7,490              $0
 64             $0              $86,352      $5,397              $0
 65             $0              $49,542      $3,096              $0
 66             $0               $9,166       $573               $0
 67             $0              -$35,039     -$2,190             $0
 68             $0              -$83,349     -$5,209             $0
 69             $0              -$136,062    -$8,504             $0
 70             $0              -$193,495    -$12,093            $0
 71             $0              -$255,985    -$15,999            $0
 72             $0              -$323,893    -$20,243            $0
 73             $0              -$397,602    -$24,850            $0
 74             $0              -$477,522    -$29,845            $0
 75             $0              -$564,090    -$35,256            $0
                             Chart details
Age   Salary    Balance       Interest   Yearly savings
 76    $0      -$657,769     -$41,111         $0
 77    $0      -$759,056     -$47,441         $0
 78    $0      -$868,479     -$54,280         $0
 79    $0      -$986,600     -$61,663         $0
 80    $0      -$1,114,019   -$69,626         $0
 81    $0      -$1,251,374   -$78,211         $0
 82    $0      -$1,399,346   -$87,459         $0
 83    $0      -$1,558,659   -$97,416         $0
 84    $0      -$1,730,085   -$108,130        $0
                         Chart details
Age   Salary   Balance   Interest   Yearly savings
                         Chart details
Age   Salary   Balance   Interest   Yearly savings
                         Chart details
Age   Salary   Balance   Interest   Yearly savings
                                                              $12
                                                              $10
                                                              $8
                                                              $6
                                                              $4
                                                              $2
                                                              $0
65   66           67               68              69
     Amount                                Uncertainty (%)
           0                 Investment return uncertainty
      0.00%             Annual savings amount uncertainty
          65           Annual savings increases uncertainty
          20    Annual pension benefit amount uncertainty
     75.00%    Annual Pension benefit increases uncertainty
                   6.25%
ails
       Desired retirement
                            Pension income   Year ending balance
             income
              $0                 $0                     $78,750
              $0                 $0                     $98,672
              $0                 $0                    $119,839
            $40,977              $0                     $86,352    142329
            $42,207              $0                     $49,542    166224
            $43,473              $0                      $9,166    191613
            $44,777              $0                    -$35,039    218589
            $46,120              $0                    -$83,349    247251
            $47,504              $0                   -$136,062    277704
            $48,929              $0                   -$193,495    310061
            $50,397              $0                   -$255,985    344440   344440
            $51,909              $0                   -$323,893    380967   380697
            $53,466              $0                   -$397,602    419777   41977
            $55,070              $0                   -$477,522    461014   461014
            $56,722              $0                   -$564,090    504827   504827
            $58,424              $0                   -$657,769    551379   551379
ails
       Desired retirement
                            Pension income   Year ending balance
             income
            $60,176              $0                   -$759,056         600840   600840
            $61,982              $0                   -$868,479         653392   653391
            $63,841              $0                   -$986,600         709229
            $65,756              $0                 -$1,114,019    76855+6
            $67,729              $0                 -$1,251,374         831591
            $69,761              $0                 -$1,399,346         898565
            $71,854              $0                 -$1,558,659         969726
            $74,009              $0                 -$1,730,085         956324
            $76,230              $0                 -$1,914,445        9835842
                                                                        504827
                                                                        551379
                                                                        600840
                                                                        653392
                                                                        709229
                                                                        358412
                                                                        831591
                                                                        898565
                                                                        969726
ails
       Desired retirement
                            Pension income   Year ending balance
             income
                                                                     956324
                                                                   23546000
ails
       Desired retirement
                            Pension income   Year ending balance
             income
ails
       Desired retirement
                            Pension income   Year ending balance
             income
Age
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
 0
 0
$0
  Salary
Calculations
     $0
     $0
     $0
     $0
     $0
     $0
     $0
     $0
     $0
     $0
     $0
    $60
    $61
    $62
    $63
    $64
    $65
    $66
    $67
    $68
    $69
    $70
    $71
    $72
    $73
    $74
    $75
    $76
    $77
    $78
    $79
    $80
    $81
    $82
    $83
    $84
$1,800
                                        Desired
                           Yearly
Balance     Interest                  retirement    Pension income
                          savings
                                        income
  $0           $0             $0         $0                $0
  $0           $0             $0         $65       Failure template:
  $0           $0       -$1,914,445      $84       Success template:
  $0           $0             $0         $0                $0
  $0           $0             $0         $65        Failure display:
  $0           $0             $0         $65        Success display:
  $0           $0             $0         $1
  $0           $0             $0         $2
  $0           $0             $0         $3
  $0           $0             $0         $4
  $0           $0             $0         $5
  $0           $0             $0         $0              $0
  $0         $60,000        $3,750     $15,000           $0
  $0         $78,750        $4,922     $15,000           $0
  $0         $98,672        $6,167     $15,000           $0
  $0       $119,839         $7,490       $0            $40,977
  $0         $86,352        $5,397       $0            $42,207
  $0         $49,542        $3,096       $0            $43,473
  $0         $9,166          $573        $0            $44,777
  $0        -$35,039       -$2,190       $0            $46,120
  $0        -$83,349       -$5,209       $0            $47,504
  $0       -$136,062       -$8,504       $0            $48,929
  $0       -$193,495      -$12,093       $0            $50,397
  $0       -$255,985      -$15,999       $0            $51,909
  $0       -$323,893      -$20,243       $0            $53,466
  $0       -$397,602      -$24,850       $0            $55,070
  $0       -$477,522      -$29,845       $0            $56,722
  $0       -$564,090      -$35,256       $0            $58,424
  $0       -$657,769      -$41,111       $0            $60,176
  $0       -$759,056      -$47,441       $0            $61,982
  $0       -$868,479      -$54,280       $0            $63,841
  $0       -$986,600      -$61,663       $0            $65,756
  $0      -$1,114,019     -$69,626       $0            $67,729
  $0      -$1,251,374     -$78,211       $0            $69,761
  $0      -$1,399,346     -$87,459       $0            $71,854
  $0      -$1,558,659     -$97,416       $0            $74,009
  $0      -$1,730,085    -$108,130       $0            $76,230
  $0
  $0
  $0
$0
$0
$0   -$12,290,106   -$768,132   $45,294   $1,251,314