Today is January 1. Starting today, Sam is going to contribute $140 on the first of each month

问题描述:

Today is January 1. Starting today, Sam is going to contribute $140 on the first of each month
Today is January 1. Starting today, Sam is going to contribute $140 on
the first of each month to his retirement account. His employer
contributes an additional 50% of the amount contributed by Sam. If both
Sam and his employer continue to do this and Sam can earn a monthly rate
of ½ of 1 percent, how much will he have in his retirement account 35
years from now?

一个年金未来价值的计算题.
根据题面,每个月的年金为140*(1+50%)=210,月利率为1.5%,年限为35*12=420
用Excel的FV函数,FV(1.5%,420,-210),结果为7,216,549.17.或者用年金复利系数查也一样.����$300,685.11ѽ�����������������ˣ���ԭ���ǡ�Sam can earn a monthly rate of ½ of 1 percent����Ӧ����0.5%��Ȼ������䣬�����299,189.16������ٿ��������ڳ�������޶�һ������421ȡ��420�����Ϊ380,891.11�� ����Ϊʲô�ͱ�׼�𰸲�һ��������������������⣬�Ͼ�Excel���㱣���˺ܶ�λ����Ҫʹ�������ϵ���Ľ����λ��ͬ���¡�