Docstoc

401K

Document Sample
401K Powered By Docstoc
					                   A               B              C      D
 1   WONDERFUL SOFTWARE'S PENSION CONVERSION
 2
 3   CONSTANTS                    2006           2007   2008
 4   CURRENT 401K MATCHING %              0.04    NA     NA
 5   NUMBER OF RETIREES                 10000     NA     NA
 6
 7   INPUTS                       2006           2007   2008
 8   NEW 401K MATCHING %                          NA     NA
 9   % INCREASE IN EMPLOYEES                      NA     NA
10   % INCREASE IN AVG SALARY                     NA     NA
11   RETIREE DEATH RATE           NA
12   401K MAKEUP                                 NA     NA
13
14   CALCULATIONS                 2006           2007   2008
15   CURRENT PLAN COMPENSATION:     --            --     --
16    PENSION                      NA
17    401K                         NA
18    TOTAL                        NA
19
20   NEW PLAN COMPENSATION:        --             --     --
21    PENSION                     NA
22    401K                        NA
23    TOTAL                       NA
24
25   INVESTMENT / SAVINGS
26
27   CUMULATIVE SAVINGS
      E      F      G      H      I      J
 1
 2
 3   2009   2010   2011   2012   2013   2014
 4    NA     NA     NA     NA     NA     NA
 5    NA     NA     NA     NA     NA     NA
 6
 7   2009   2010   2011   2012   2013   2014
 8    NA     NA     NA     NA     NA     NA
 9    NA     NA     NA     NA     NA     NA
10    NA     NA     NA     NA     NA     NA
11
12   NA     NA     NA     NA     NA     NA
13
14   2009   2010   2011   2012   2013   2014
15    --     --     --
16
17
18
19
20    --     --     --     --     --     --
21
22
23
24
25
26
27
      K      L
 1
 2
 3   2015   2016
 4    NA     NA
 5    NA     NA
 6
 7   2015   2016
 8    NA     NA
 9    NA     NA
10    NA     NA
11
12   NA     NA
13
14   2015   2016
15
16
17
18
19
20    --     --
21
22
23
24
25
26
27
                 A               B        C      D      E      F
 1   WONDERFUL SOFTWARE'S PENSION CONVERSION
 2
 3   CONSTANTS                  2006     2007   2008   2009   2010
 4   CURRENT 401K MATCHING %              NA     NA     NA     NA
 5
 6   INPUTS                     2006     2007   2008   2009   2010
 7   NEW 401K MATCHING %                  NA     NA     NA     NA
 8   % INCREASE IN EMPLOYEES              NA     NA     NA     NA
 9   % INCREASE IN AVG SALARY             NA     NA     NA     NA
10
11   CALCULATIONS               2006     2007   2008   2009   2010
12   NUMBER OF EMPLOYEES         50000
13   AVERAGE SALARY              60000
14   SALARY EXPENSE              NA
15   CURRENT 401K EXPENSE        NA
16   NEW PLAN 401K EXPENSE       NA
      G      H      I      J      K      L
 1
 2
 3   2011   2012   2013   2014   2015   2016
 4    NA     NA     NA     NA     NA     NA
 5
 6   2011   2012   2013   2014   2015   2016
 7    NA     NA     NA     NA     NA     NA
 8    NA     NA     NA     NA     NA     NA
 9    NA     NA     NA     NA     NA     NA
10
11   2011   2012   2013   2014   2015   2016
12
13
14
15
16
                           A                 B        C         D         E
 1   WONDERFUL SOFTWARE'S PENSION CONVERSION
 2
 3   CONSTANTS                              2006     2007      2008      2009
 4   CURRENT 401K MATCHING %                          NA        NA        NA
 5   NEW RETIREES EACH YEAR                 NA          1500      1500      1500
 6   EXPECTED PAYMENT TO RETIREE            NA         40000     41000     42000
 7
 8   INPUTS                                 2006     2007      2008      2009
 9   NEW 401K MATCHING %                              NA        NA        NA
10   DEATH RATE                             NA
11
12   CALCULATIONS                           2006     2007      2008      2009
13   NUMBER OF RETIREES -- EXISTING PLAN:    --       --        --        --
14    ADD: NEW RETIREES IN PLAN              NA
15    LESS: DEATHS OF RETIREES               NA
16    NUMBER OF RETIREES IN PLAN             10000
17
18   NUMBER OF RETIREES -- NEW PLAN:        --        --        --        --
19    ADD: NEW RETIREES IN PLAN             NA
20    LESS: DEATHS OF RETIREES              NA
21    NUMBER OF RETIREES IN PLAN            10000
22
23   PENSION EXPENSE:                       --        --        --        --
24    EXISTING PLAN                         NA
25    NEW PLAN                              NA
      F         G         H         I         J         K         L
 1
 2
 3   2010      2011      2012      2013      2014      2015      2016
 4    NA        NA        NA        NA        NA        NA        NA
 5      2000      2000      2000      2000      2000      2000      2000
 6     43000     44000     45000     46000     47000     48000     49000
 7
 8   2010      2011      2012      2013      2014      2015      2016
 9    NA        NA        NA        NA        NA        NA        NA
10
11
12   2010      2011      2012      2013      2014      2015      2016
13    --        --        --        --        --        --        --
14
15
16
17
18    --        --        --        --        --        --        --
19
20
21
22
23    --        --        --        --        --        --        --
24
25

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:7/25/2011
language:English
pages:7