40               41       42        43              44              45       4
Input
                                  Now      Amount                             At Retirement
                       Your current age          40               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
 40           $50,000           $60,000      $3,750            $15,000
 41           $51,500           $78,750      $4,922            $15,000
 42           $53,045           $98,672      $6,167            $15,000
 43           $54,636           $119,839     $7,490            $15,000
 44           $56,275           $142,329     $8,896            $15,000
 45           $57,964           $166,224     $10,389           $15,000
 46           $59,703           $191,613     $11,976           $15,000
 47           $61,494           $218,589     $13,662           $15,000
 48           $63,339           $247,251     $15,453           $15,000
 49           $65,239           $277,704     $17,357           $15,000
 50           $67,196           $310,061     $19,379           $15,000
 51           $69,212           $344,440     $21,527           $15,000
 52           $71,288           $380,967     $23,810           $15,000
 53           $73,427           $419,777     $26,236           $15,000
 54           $75,629           $461,014     $28,813           $15,000
 55           $77,898           $504,827     $31,552           $15,000
                           Chart details
Age   Salary    Balance    Interest   Yearly savings
 56   $80,235   $551,379   $34,461      $15,000
 57   $82,642   $600,840   $37,552      $15,000
 58   $85,122   $653,392   $40,837      $15,000
 59   $87,675   $709,229   $44,327      $15,000
 60   $90,306   $768,556   $48,035      $15,000
 61   $93,015   $831,591   $51,974      $15,000
 62   $95,805   $898,565   $56,160      $15,000
 63     $0      $969,726   $60,608         $0
 64     $0      $956,324   $59,770         $0
 65     $0      $939,864   $58,742         $0
 66     $0      $920,089   $57,506         $0
 67     $0      $896,723   $56,045         $0
 68     $0      $869,469   $54,342         $0
 69     $0      $838,014   $52,376         $0
 70     $0      $802,019   $50,126         $0
 71     $0      $761,122   $47,570         $0
 72     $0      $714,940   $44,684         $0
 73     $0      $663,058   $41,441         $0
                           Chart details
Age   Salary    Balance    Interest   Yearly savings
 74    $0      $605,036    $37,815         $0
 75    $0      $540,405    $33,775         $0
 76    $0      $468,660    $29,291         $0
 77    $0      $389,266    $24,329         $0
 78    $0      $301,649    $18,853         $0
 79    $0      $205,198    $12,825         $0
 80    $0      $99,259     $6,204          $0
 81    $0      -$16,864    -$1,054         $0
 82    $0      -$143,914   -$8,995         $0
 83    $0      -$282,685   -$17,668        $0
 84    $0      -$434,022   -$27,126        $0
                         Chart details
Age   Salary   Balance   Interest   Yearly savings
                         Chart details
Age   Salary   Balance   Interest   Yearly savings
                                                                    $12
                                                                    $10
                                                                    $8
                                                                    $6
                                                                    $4
                                                                    $2
                                                                    $0
44    45   46           47               48               49
put
           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%
details
          Desired retirement
                               Pension income   Year ending balance
                income
                 $0                 $0                     $78,750
                 $0                 $0                     $98,672
                 $0                 $0                    $119,839
                 $0                 $0                    $142,329
                 $0                 $0                    $166,224
                 $0                 $0                    $191,613
                 $0                 $0                    $218,589
                 $0                 $0                    $247,251
                 $0                 $0                    $277,704
                 $0                 $0                    $310,061
                 $0                 $0                    $344,440
                 $0                 $0                    $380,967
                 $0                 $0                    $419,777
                 $0                 $0                    $461,014
                 $0                 $0                    $504,827
                 $0                 $0                    $551,379
details
          Desired retirement
                               Pension income   Year ending balance
                income
                 $0                 $0                    $600,840
                 $0                 $0                    $653,392
                 $0                 $0                    $709,229
                 $0                 $0                    $768,556
                 $0                 $0                    $831,591
                 $0                 $0                    $898,565
                 $0                 $0                    $969,726
               $74,009              $0                    $956,324
               $76,230              $0                    $939,864
               $78,517              $0                    $920,089
               $80,872              $0                    $896,723
               $83,298              $0                    $869,469
               $85,797              $0                    $838,014
               $88,371              $0                    $802,019
               $91,022              $0                    $761,122
               $93,753              $0                    $714,940
               $96,566              $0                    $663,058
               $99,463              $0                    $605,036
details
          Desired retirement
                               Pension income   Year ending balance
                income
              $102,446              $0                    $540,405
              $105,520              $0                    $468,660
              $108,685              $0                    $389,266
              $111,946              $0                    $301,649
              $115,304              $0                    $205,198
              $118,764              $0                     $99,259
              $122,326              $0                    -$16,864
              $125,996              $0                   -$143,914
              $129,776              $0                   -$282,685
              $133,669              $0                   -$434,022
              $137,679              $0                   -$598,828
details
          Desired retirement
                               Pension income   Year ending balance
                income
details
          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
    $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
$1,635
                                   Desired
                       Yearly
Balance   Interest               retirement    Pension income
                      savings
                                   income
  $0         $0          $0         $0                $0
  $0         $0          $0         $79       Failure template:
  $0         $0      -$598,828      $84       Success template:
  $0         $0          $0         $0                $0
  $0         $0          $0         $79        Failure display:
  $0         $0          $0         $79        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     $15,000           $0
  $0      $142,329     $8,896     $15,000           $0
  $0      $166,224    $10,389     $15,000           $0
  $0      $191,613    $11,976     $15,000           $0
  $0      $218,589    $13,662     $15,000           $0
  $0      $247,251    $15,453     $15,000           $0
  $0      $277,704    $17,357     $15,000           $0
  $0      $310,061    $19,379     $15,000           $0
  $0      $344,440    $21,527     $15,000           $0
  $0      $380,967    $23,810     $15,000           $0
  $0      $419,777    $26,236     $15,000           $0
  $0      $461,014    $28,813     $15,000           $0
  $0      $504,827    $31,552     $15,000           $0
  $0      $551,379    $34,461     $15,000           $0
  $0      $600,840    $37,552     $15,000           $0
  $0      $653,392    $40,837     $15,000           $0
  $0      $709,229    $44,327     $15,000           $0
  $0      $768,556    $48,035     $15,000           $0
  $0      $831,591    $51,974     $15,000           $0
  $0      $898,565    $56,160     $15,000           $0
  $0      $969,726    $60,608       $0            $74,009
  $0      $956,324    $59,770       $0            $76,230
  $0      $939,864    $58,742       $0            $78,517
  $0      $920,089    $57,506       $0            $80,872
  $0      $896,723    $56,045       $0            $83,298
$0    $869,469     $54,342       $0      $85,797
$0    $838,014     $52,376       $0      $88,371
$0   $15,425,817   $964,114   $345,336   $567,095