0% found this document useful (0 votes)
32 views4 pages

Retirement Planner1

Uploaded by

sh317243
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
32 views4 pages

Retirement Planner1

Uploaded by

sh317243
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Chart Title

Retirement planner
CONGRATULATIONS! At age 84, you will have a savings balance of $2,63,84,65,956.

$12

$10

$8

$6

$4

$2

$0
$20 $21 $22 $23 $24 $25 $26 $27 $28 $29

Input
Now At retirement Uncertainty
Your current age 20 Annual pension benefit ($) 0 Investment return uncertainty (%) 2.00%

Annual income ($) 48,000 Annual pension benefit increases (%) 0.00% Annual savings amount uncertainty (%) 0.00%

Annual inflation and income increases (%) 6.00% Desired retirement age 65 Annual savings increases uncertainty (%) 0.00%

Retirement savings balance ($) 5,000,000 Number of years of retirement income 20 Annual pension benefit amount uncertainty (%) 0.00%

Annual savings amount ($) 20,000 Income replacement (%) 75.00% Annual pension benefit increases uncertainty (%) 0.00%

Annual savings increases (%) 5.00% Investment return (%) 6.25%

Investment return (%) 10.00%

Page 2 of 4
Chart details
Desired
Year ending
Age Salary Balance Interest Yearly savings retirement Pension income Notes
balance
income
20 $48,000 $5,000,000 $500,000 $20,000 $0 $0 $5,520,000

21 $50,880 $5,520,000 $552,000 $21,000 $0 $0 $6,093,000

22 $53,933 $6,093,000 $609,300 $22,050 $0 $0 $6,724,350

23 $57,169 $6,724,350 $672,435 $23,153 $0 $0 $7,419,938

24 $60,599 $7,419,938 $741,994 $24,310 $0 $0 $8,186,241

25 $64,235 $8,186,241 $818,624 $25,526 $0 $0 $9,030,391

26 $68,089 $9,030,391 $903,039 $26,802 $0 $0 $9,960,232

27 $72,174 $9,960,232 $996,023 $28,142 $0 $0 $10,984,397

28 $76,505 $10,984,397 $1,098,440 $29,549 $0 $0 $12,112,386

29 $81,095 $12,112,386 $1,211,239 $31,027 $0 $0 $13,354,651

30 $85,961 $13,354,651 $1,335,465 $32,578 $0 $0 $14,722,694

31 $91,118 $14,722,694 $1,472,269 $34,207 $0 $0 $16,229,171

32 $96,585 $16,229,171 $1,622,917 $35,917 $0 $0 $17,888,005

33 $102,381 $17,888,005 $1,788,800 $37,713 $0 $0 $19,714,518

34 $108,523 $19,714,518 $1,971,452 $39,599 $0 $0 $21,725,569

35 $115,035 $21,725,569 $2,172,557 $41,579 $0 $0 $23,939,704

36 $121,937 $23,939,704 $2,393,970 $43,657 $0 $0 $26,377,332

37 $129,253 $26,377,332 $2,637,733 $45,840 $0 $0 $29,060,906

38 $137,008 $29,060,906 $2,906,091 $48,132 $0 $0 $32,015,129

39 $145,229 $32,015,129 $3,201,513 $50,539 $0 $0 $35,267,181

40 $153,943 $35,267,181 $3,526,718 $53,066 $0 $0 $38,846,965

41 $163,179 $38,846,965 $3,884,696 $55,719 $0 $0 $42,787,380

42 $172,970 $42,787,380 $4,278,738 $58,505 $0 $0 $47,124,624

43 $183,348 $47,124,624 $4,712,462 $61,430 $0 $0 $51,898,516

44 $194,349 $51,898,516 $5,189,852 $64,502 $0 $0 $57,152,870

45 $206,010 $57,152,870 $5,715,287 $67,727 $0 $0 $62,935,884

46 $218,370 $62,935,884 $6,293,588 $71,113 $0 $0 $69,300,586

47 $231,473 $69,300,586 $6,930,059 $74,669 $0 $0 $76,305,314

Page 3 of 4
Desired
Year ending
Age Salary Balance Interest Yearly savings retirement Pension income Notes
balance
income
48 $245,361 $76,305,314 $7,630,531 $78,403 $0 $0 $84,014,248

49 $260,083 $84,014,248 $8,401,425 $82,323 $0 $0 $92,497,995

50 $275,688 $92,497,995 $9,249,800 $86,439 $0 $0 $101,834,234

51 $292,229 $101,834,234 $10,183,423 $90,761 $0 $0 $112,108,418

52 $309,763 $112,108,418 $11,210,842 $95,299 $0 $0 $123,414,558

53 $328,348 $123,414,558 $12,341,456 $100,064 $0 $0 $135,856,078

54 $348,049 $135,856,078 $13,585,608 $105,067 $0 $0 $149,546,753

55 $368,932 $149,546,753 $14,954,675 $110,320 $0 $0 $164,611,748

56 $391,068 $164,611,748 $16,461,175 $115,836 $0 $0 $181,188,760

57 $414,532 $181,188,760 $18,118,876 $121,628 $0 $0 $199,429,264

58 $439,404 $199,429,264 $19,942,926 $127,710 $0 $0 $219,499,900

59 $465,768 $219,499,900 $21,949,990 $134,095 $0 $0 $241,583,985

60 $493,714 $241,583,985 $24,158,398 $140,800 $0 $0 $265,883,183

61 $523,337 $265,883,183 $26,588,318 $147,840 $0 $0 $292,619,341

62 $554,738 $292,619,341 $29,261,934 $155,232 $0 $0 $322,036,507

63 $588,022 $322,036,507 $32,203,651 $162,993 $0 $0 $354,403,151

64 $623,303 $354,403,151 $35,440,315 $171,143 $0 $0 $390,014,609

Page 4 of 4

You might also like