X hits on this document

485 views

0 shares

1 downloads

0 comments

18 / 26

Chapter 5, Solutions        Cornett, Adair, and Nofsinger

5-51 Excel Problem Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65.  For the first ten years, she contributes $3,000 per year.  She increases the contribution rate to $5,000 per year in years 11 through 20.  This is followed by increases to $10,000 per year in years 21 through 31 and to $15,000 per year for the last ten years.  This money earns a 9 percent return, first compute the value of the retirement plan when she turns age 65.  Then compute the annual payment she would receive over the next 40 years if the wealth was converted to an annuity payment at 8 percent.

End of

Age

Contribution

Total Wealth

25

$3,000.00

$3,000.00

26

$3,000.00

$6,270.00

27

$3,000.00

$9,834.30

28

$3,000.00

$13,719.39

29

$3,000.00

$17,954.13

30

$3,000.00

$22,570.00

31

$3,000.00

$27,601.30

32

$3,000.00

$33,085.42

33

$3,000.00

$39,063.11

34

$3,000.00

$45,578.79

35

$5,000.00

$54,680.88

36

$5,000.00

$64,602.16

37

$5,000.00

$75,416.35

38

$5,000.00

$87,203.83

39

$5,000.00

$100,052.17

40

$5,000.00

$114,056.87

41

$5,000.00

$129,321.98

42

$5,000.00

$145,960.96

43

$5,000.00

$164,097.45

44

$5,000.00

$183,866.22

45

$10,000.00

$210,414.18

46

$10,000.00

$239,351.45

47

$10,000.00

$270,893.08

48

$10,000.00

$305,273.46

49

$10,000.00

$342,748.07

50

$10,000.00

$383,595.40

51

$10,000.00

$428,118.99

52

$10,000.00

$476,649.70

53

$10,000.00

$529,548.17

Document info
Document views485
Page views629
Page last viewedWed Dec 07 11:01:36 UTC 2016
Pages26
Paragraphs801
Words7019

Comments