PV = 8500( 1 - 1.07^-15)/.07
= $77,417.27
I have no idea how you got your answer.
If we had found the value of her trust fund at the end of 15 years it would have been
8500( 1.07^15 - 1)/.07 = $213,596.69
Jean will receive $8,500 per year for the next 15 years from her trust. If a 7% interest rate is applied, what is the current value of the future payments? I get a rounded sum of $200,180.
3 answers
Proof:
Time interest withdrawal balance
------------------------77,417.27
1 5419.2089 8500 74,336.48
2 5203.553523 8500 71,040.03
3 4972.80227 8500 67,512.83
4 4725.898428 8500 63,738.73
5 4461.711318 8500 59,700.44
6 4179.031111 8500 55,379.48
7 3876.563289 8500 50,756.04
8 3552.922719 8500 45,808.96
9 3206.627309 8500 40,515.59
10 2836.091221 8500 34,851.68
11 2439.617606 8500 28,791.30
12 2015.390839 8500 22,306.69
13 1561.468197 8500 15,368.16
14 1075.770971 8500 7,943.93
15 556.074939 8500 0 0.00
Time interest withdrawal balance
------------------------77,417.27
1 5419.2089 8500 74,336.48
2 5203.553523 8500 71,040.03
3 4972.80227 8500 67,512.83
4 4725.898428 8500 63,738.73
5 4461.711318 8500 59,700.44
6 4179.031111 8500 55,379.48
7 3876.563289 8500 50,756.04
8 3552.922719 8500 45,808.96
9 3206.627309 8500 40,515.59
10 2836.091221 8500 34,851.68
11 2439.617606 8500 28,791.30
12 2015.390839 8500 22,306.69
13 1561.468197 8500 15,368.16
14 1075.770971 8500 7,943.93
15 556.074939 8500 0 0.00
Well, those numbers did not line up nicely at all
should have formatted to 2 decimal places ...
The first row would be
1 -- 5419.21 -- 8500 -- 74,336.48
but you can see that after the last payment of $8500, the balance is 0.00
(above done on Excel , and then cut and pasted.)
should have formatted to 2 decimal places ...
The first row would be
1 -- 5419.21 -- 8500 -- 74,336.48
but you can see that after the last payment of $8500, the balance is 0.00
(above done on Excel , and then cut and pasted.)