Present Value = Future value / (1 + R)T
T = Time in years
R = Interest rate
Present Value = $8,000/(1.08)1]+ [$9,000/(1.08)2]+ [$10,000/(1.08)3]+ [$10,000/(1.08)4]+ [$10,000/(1.08)5]+ [$10,000/(1.08)6]+ [$10,000/(1.08)7]+ [$10,000/(1.08)8]+ [$10,000/(1.08)9]+ [$10,000/(1.08)10]
Present Value = [$8,000 * 0.9259] + [$9,000 * 0.8573] + [$10,000 *0.7938 ] + [$10,000 * 0.735] + [$10,000 * 0.6806] + [$10,000 * 0.6302] + [$10,000 * 0.5835] + [$10,000 *0.5403 ] + [$10,000 * 0.5002] + [$10,000 * 0.4632]
Present Value = $64,391.62
So, Present Value of all future benefits = $64,391.62.
In Excel.
Get Answers For Free
Most questions answered within 1 hours.