DCF Interest 10% Year 0 1 2 3 4 Cash 10 10 10 10 PV 9.09090909 8.26446281 7.51314801 6.83013455 NPV 98.4908867
DCF Interest 10% Year 0 1 2 3 4 Cash 10 10 10 10 PV 9.09090909 8.26446281 7.51314801 6.83013455 NPV 98.4908867
DCF Interest 10% Year 0 1 2 3 4 Cash 10 10 10 10 PV 9.09090909 8.26446281 7.51314801 6.83013455 NPV 98.4908867
Interest
Year
Cash
PV
NPV
10%
0
98.4908867
1
2
3
4
10
10
10
10
9.09090909 8.26446281 7.51314801 6.83013455
5
10
6.20921323
6
7
10
10
5.6447393 5.13158118
8
9
10
10
10
10
4.6650738 4.24097618 3.85543289
11
12
10
10
3.50493899 3.18630818
13
14
15
16
10
10
10
10
2.8966438 2.63331254 2.39392049 2.17629136
17
10
1.97844669
18
19
20
21
22
10
10
10
10
10
1.7985879 1.63507991 1.48643628 1.35130571 1.22845974
23
24
25
26
27
28
10
10
10
10
10
10
1.11678158 1.01525598 0.92295998 0.83905453 0.76277684 0.69343349
29
30
31
32
33
34
10
10
10
10
10
10
0.63039409 0.57308553 0.52098685 0.47362441 0.43056764 0.39142513
35
36
37
38
39
40
10
10
10
10
10
10
0.35584103 0.32349184 0.29408349 0.26734863 0.24304421 0.22094928
41
42
43
44 x
10
10
10
10 x
0.20086298 0.18260271 0.16600247 0.15091133 x
x