Time Value Of Money



Alice saves some amount of money every year for eight years. After that she just lets her money sit and collect interest.

Bill spends his money for the first eight years and then decides to save the same amount that Alice had been saving and continues to save it through age 65.

The assumption is that they both get the same constant rate of return.

Who ends up with more money?

Play with the spreadsheet and see how much differing amounts and different rates of return make.

How much money would you like to see Alice and Bill save every year? What rate of return do they get? Input amounts below.
(You may need to hit the recalculate button to see data):

 

 

 

 

 

 

 

Amount Saved 

 

Interest Rate 

 

AgeAliceBill 

18

$0.00 

 

19

$0.00 

20

$0.00 

21

$0.00 

22

$0.00 

23

$0.00 

24

$0.00 

25

$0.00 

26

 

27

 

28

 

29

 

30

 

31

 

32

 

33

 

34

 

35

 

36

 

37

 

38

 

39

 

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

 

A difference of