Discount rate |
6.0000% |
|
|
Cash flows |
Year |
Discounted CF= cash flows/(1+rate)^year |
Cumulative cash flow |
          Â
(2,000,000.000) |
0 |
                  Â
(2,000,000.00) |
              Â
(2,000,000.00) |
                Â
105,000.000 |
1 |
                          Â
99,056.60 |
              Â
(1,900,943.40) |
                Â
105,000.000 |
2 |
                          Â
93,449.63 |
            Â
(1,807,493.770) |
                Â
105,000.000 |
3 |
                          Â
88,160.02 |
            Â
(1,719,333.745) |
                Â
105,000.000 |
4 |
                          Â
83,169.83 |
            Â
(1,636,163.911) |
                Â
105,000.000 |
5 |
                          Â
78,462.11 |
              Â
(1,557,701.80) |
                  Â
55,000.000 |
6 |
                          Â
38,772.83 |
            Â
(1,518,928.973) |
                Â
105,000.000 |
7 |
                          Â
69,831.00 |
              Â
(1,449,097.98) |
                Â
105,000.000 |
8 |
                          Â
65,878.30 |
              Â
(1,383,219.68) |
                Â
105,000.000 |
9 |
                          Â
62,149.34 |
              Â
(1,321,070.34) |
                Â
105,000.000 |
10 |
                          Â
58,631.45 |
              Â
(1,262,438.89) |
                Â
105,000.000 |
11 |
                          Â
55,312.69 |
              Â
(1,207,126.20) |
                  Â
55,000.000 |
12 |
                          Â
27,333.31 |
              Â
(1,179,792.88) |