Embed
Email

retirement

Document Sample

Shared by: huanghengdong
Categories
Tags
Stats
views:
0
posted:
12/16/2011
language:
pages:
14
Age 22 23 24 25 26 27

Salary $67,000$67,670 $68,347 $69,030 $69,720 $70,418

Tax $14,150$14,318 $14,487 $14,658 $14,830 $15,004

Post-Tax Salary $52,850$53,353 $53,860 $54,373 $54,890 $55,413

Spending $25,000$26,500 $27,295 $28,114 $28,957 $29,826

Savings $27,850$26,853 $26,565 $26,259 $25,933 $25,587

Accumulated Savings $27,850$54,703 $81,268 ####### ####### #######

With Interest $27,850$56,374 $86,321 ####### ####### #######

Minus Inflation $27,850$55,538 $83,769 ####### ####### #######

Years Left 63 62 61 60 59 58

Able to Retire? FALSE FALSE FALSE FALSE FALSE FALSE

85 85 85 85 85 85



Retirement Age

Initial Salary (Pretax) $67,000 46

Initial Spending $25,000 Yearly Tax Input

Salary Multiplier 1.00% $67,000

Spending Multiplier 3.00% Inflation Adjusted

Interest Rate 6.00% #######

Inflation 3.00%

Death Age 85

Retirement Percentage 60.00%

$46 3.00% 3.50% 4.00%

Spend Start -1.00% -1.00% 34 34 34

Spend Increment 0.50% -0.50% 35 34 34

Salary Start 3.00% 0.00% 35 35 34

Salary Increment 0.50% 0.50% 36 35 35

Spending Growth (without Inflation)









1.00% 36 36 35

1.50% 37 37 36

2.00% 38 37 37

2.50% 39 38 38

3.00% 40 39 38

3.50% 41 40 39

4.00% 43 42 41

4.50% 46 44 42

5.00% 49 46 44

5.50% 55 50 47

6.00% 85 57 51

28 29 30 31 32 33 34 35 36 37 38

$71,122 $71,833 $72,551 $73,277 $74,010 $74,750 $75,497 $76,252 $77,015 $77,785 $78,563

$15,180 $15,358 $15,538 $15,719 $15,902 $16,087 $16,274 $16,463 $16,654 $16,846 $17,041

$55,941 $56,475 $57,014 $57,558 $58,107 $58,662 $59,223 $59,789 $60,361 $60,939 $61,522

$30,721 $31,642 $32,592 $33,569 $34,576 $35,614 $36,682 $37,783 $38,916 $40,084 $41,286

$25,221 $24,832 $24,422 $23,988 $23,531 $23,049 $22,541 $22,007 $21,445 $20,855 $20,236

####### ####### ####### ####### ####### ####### ####### ####### ####### ####### #######

####### ####### ####### ####### ####### ####### ####### ####### ####### ####### #######

####### ####### ####### ####### ####### ####### ####### ####### ####### ####### #######

57 56 55 54 53 52 51 50 49 48 47

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

85 85 85 85 85 85 85 85 85 85 85









Salary Growth

4.50% 5.00% 5.50% 6.00% 6.50% 7.00% 7.50% 8.00% 8.50% 9.00% 9.50%

33 33 33 33 32 32 32 32 32 31 31

34 33 33 33 33 32 32 32 32 32 32

34 34 34 33 33 33 33 32 32 32 32

35 34 34 34 33 33 33 33 32 32 32

35 35 34 34 34 33 33 33 33 33 32

36 35 35 34 34 34 34 33 33 33 33

36 36 35 35 35 34 34 34 33 33 33

37 36 36 36 35 35 34 34 34 34 33

38 37 37 36 36 35 35 35 34 34 34

39 38 37 37 36 36 35 35 35 34 34

40 39 38 38 37 36 36 36 35 35 34

41 40 39 38 38 37 37 36 36 35 35

43 41 40 40 39 38 37 37 36 36 36

45 43 42 41 40 39 38 38 37 37 36

48 45 44 42 41 40 39 39 38 37 37

39 40 41 42 43 44 45

$79,348 $80,142 $80,943 $81,753 $82,570 $83,396 $84,230

$17,237 $17,435 $17,636 $17,838 $18,043 $18,249 $27,101

$62,111 $62,706 $63,307 $63,915 $64,528 $65,147 $57,129

$42,525 $43,800 $45,114 $46,468 $47,862 $49,298 $50,777

$19,587 $18,906 $18,193 $17,447 $16,666 $15,849 $6,352

####### $449,665 $467,858 $485,305 $501,970 $517,819 $524,171

####### $825,478 $893,200 $964,239 $1,038,759 $1,116,934 $1,190,301

####### $604,645 $640,977 $677,653 $714,649 $751,937 $780,847

46 45 44 43 42 41 40

FALSE FALSE FALSE FALSE FALSE FALSE FALSE

85 85 85 85 85 85 85









10.00%

31

31

32

32

32

32

33

33

33

34

34

35

35

36

36

46 47 48 49 50 51

$85,072 $85,923 $86,782 $87,650 $88,526 $89,412

$27,337 $27,575 $27,816 $28,059 $28,304 $28,552

$57,735 $58,348 $58,966 $59,591 $60,222 $60,859

$52,300 $53,869 $55,485 $57,150 $58,864 $60,630

$5,435 $4,478 $3,481 $2,441 $1,358 $229

$529,606 $534,085 $537,566 $540,007 $541,365 $541,594

$1,267,154 $1,347,662 $1,432,003 $1,520,364 $1,612,944 $1,709,950

$809,707 $838,477 $867,113 $895,567 $923,792 $951,735

39 38 37 36 35 34

TRUE TRUE TRUE TRUE TRUE TRUE

46 47 48 49 50 51

52 53 54 55 56 57

$90,306 $91,209 $92,121 $93,042 $93,973 $94,912

$28,803 $29,056 $29,311 $29,569 $29,829 $30,092

$61,503 $62,153 $62,810 $63,473 $64,143 $64,820

$62,449 $64,322 $66,252 $68,240 $70,287 $72,395

-$946 -$2,169 -$3,442 -$4,766 -$6,144 -$7,576

$540,649 $538,480 $535,038 $530,271 $524,128 $516,552

$1,811,602 $1,918,129 $2,029,774 $2,146,795 $2,269,459 $2,398,051

$979,342 $1,006,553 $1,033,307 $1,059,540 $1,085,183 $1,110,163

33 32 31 30 29 28

TRUE TRUE TRUE TRUE TRUE TRUE

52 53 54 55 56 57

58 59 60 61 62 63

$95,862 $96,820 $97,788 $98,766 $99,754 $100,751

$30,358 $30,627 $30,898 $31,172 $31,448 $31,727

$65,503 $66,193 $66,891 $67,595 $68,306 $69,024

$74,567 $76,804 $79,109 $81,482 $83,926 $86,444

-$9,064 -$10,611 -$12,218 -$13,887 -$15,620 -$17,420

$507,488 $496,877 $484,659 $470,772 $455,152 $437,732

$2,532,870 $2,674,231 $2,822,467 $2,977,928 $3,140,983 $3,312,022

$1,134,404 $1,157,825 $1,180,342 $1,201,865 $1,222,301 $1,241,550

27 26 25 24 23 22

TRUE TRUE TRUE TRUE TRUE TRUE

58 59 60 61 62 63

64 65 66 67 68 69 70 71

$101,759 $102,777 $103,804 $104,842 $105,891 $106,950 $108,019 $109,099

$32,009 $32,294 $32,582 $32,873 $205,150 $205,150 $205,150 $205,150

$69,749 $70,482 $71,222 $71,969 -$99,259 -$98,200 -$97,130 -$96,050

$89,037 $91,708 $94,460 $97,293 $100,212 $103,219 $106,315 $109,505

-$19,288 -$21,226 -$23,238 -$25,324 -$199,471 -$201,419 -$203,446 -$205,555

$418,444 $397,218 $373,980 $348,656 $149,185 -$52,234 -$255,679 -$461,234

$3,491,455 $3,679,716 $3,877,262 $4,084,573 ######## ######## ######## ########

$1,259,508 $1,276,067 $1,291,111 $1,304,521 ######## $977,092 $802,959 $621,493

21 20 19 18 17 16 15 14

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

64 65 66 67 68 69 70 71

72 73 74 75 76 77 78 79 80

$110,190 $111,292 $112,405 $113,529 $114,665 $115,811 $116,969 $118,139 $119,320

$205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150

-$94,959 -$93,857 -$92,744 -$91,620 -$90,485 -$89,338 -$88,180 -$87,011 -$85,829

$112,790 $116,174 $119,659 $123,248 $126,946 $130,754 $134,677 $138,717 $142,879

-$207,749 -$210,031 -$212,403 -$214,869 -$217,431 -$220,093 -$222,857 -$225,728 -$228,708

-$668,983 -$879,014 ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

$432,389 $235,330 $29,987 -$183,983 -$406,933 -$639,234 -$881,268 ######## ########

13 12 11 10 9 8 7 6 5

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

72 73 74 75 76 77 78 79 80

81 82 83 84 85 86 87 88 89

$120,514 $121,719 $122,936 $124,165 $125,407 $126,661 $127,928 $129,207 $130,499

$205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150

-$84,636 -$83,431 -$82,214 -$80,984 -$79,743 -$78,489 -$77,222 -$75,943 -$74,651

$147,165 $151,580 $156,127 $160,811 $165,636 $170,605 $175,723 $180,995 $186,424

-$231,801 -$235,011 -$238,341 -$241,796 -$245,378 -$249,093 -$252,945 -$256,937 -$261,075

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

4 3 2 1 0 -1 -2 -3 -4

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

81 82 83 84 85 86 87 88 89

90 91 92 93 94 95 96 97 98

$131,804 $133,122 $134,453 $135,798 $137,156 $138,527 $139,912 $141,312 $142,725

$205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150

-$73,346 -$72,028 -$70,696 -$69,352 -$67,994 -$66,622 -$65,237 -$63,838 -$62,425

$192,017 $197,778 $203,711 $209,822 $216,117 $222,600 $229,278 $236,157 $243,242

-$265,363 -$269,805 -$274,407 -$279,174 -$284,111 -$289,223 -$294,516 -$299,995 -$305,666

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

-5 -6 -7 -8 -9 -10 -11 -12 -13

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

90 91 92 93 94 95 96 97 98

99 100 101 102 103 104 105 106 107

$144,152 $145,593 $147,049 $148,520 $150,005 $151,505 $153,020 $154,550 $156,096

$205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150

-$60,998 -$59,556 -$58,100 -$56,630 -$55,144 -$53,644 -$52,129 -$50,599 -$49,054

$250,539 $258,055 $265,797 $273,770 $281,984 $290,443 $299,156 $308,131 $317,375

-$311,536 -$317,611 -$323,897 -$330,400 -$337,128 -$344,088 -$351,286 -$358,730 -$366,429

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

-14 -15 -16 -17 -18 -19 -20 -21 -22

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

99 100 101 102 103 104 105 106 107

108 109 110 111 112 113 114 115 116

$157,657 $159,233 $160,826 $162,434 $164,058 $165,699 $167,356 $169,030 $170,720

$205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150 $205,150

-$47,493 -$45,916 -$44,324 -$42,716 -$41,091 -$39,451 -$37,794 -$36,120 -$34,430

$326,896 $336,703 $346,804 $357,208 $367,925 $378,962 $390,331 $402,041 $414,102

-$374,389 -$382,619 -$391,128 -$399,924 -$409,016 -$418,413 -$428,125 -$438,161 -$448,532

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

######## ######## ######## ######## ######## ######## ######## ######## ########

-23 -24 -25 -26 -27 -28 -29 -30 -31

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

108 109 110 111 112 113 114 115 116

117 118

$172,427 $174,151

$205,150 $205,150

-$32,723 -$30,998

$426,525 $439,321

-$459,248 -$470,320

######## ########

######## ########

######## ########

-32 -33

TRUE TRUE

117 118

Yearly Income 67000

0 8500 0.1 850 58500

8500 34500 0.15 5175 32500

34500 83600 0.25 8125 0

83600 174400 0.28 0 0

174400 379150 0.33 0 0

379150 99999999 0.35 0 0

Tax Paid 14150



Related docs
Other docs by huanghengdong
2012_Vendor_Form_Wedding_Expo
Views: 0  |  Downloads: 0
SCOPE 1 GP letter v2.0 12Mar2007
Views: 0  |  Downloads: 0
Boston_immigration_records
Views: 2  |  Downloads: 0
PSC MATRIX of achievement 080709
Views: 0  |  Downloads: 0
Summary - CIRCA
Views: 0  |  Downloads: 0
ieee_wiley_ebooks_library_customer_title_list
Views: 0  |  Downloads: 0
2009-2010_ACC0044_fishers_772_07-dec-2009
Views: 1  |  Downloads: 0
FSP20111216-EN
Views: 0  |  Downloads: 0
Workshops
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!