5

6
7
8

2
2
2
2
5
4
3
2
1
0

2
0.55
0.5
0.454545455
0.41322314
0.3756574

Discounted cash flow

Nominal Cash
PV Factor flow
1
0.909091
0.826446
0.751315
0.683013
0.620921
200000
0.564474
200000
0.513158
200000
0.466507
200000

Discounted cash
flow

pv factor

Cash I get
Rs.
100,000.00
Rs.
108,000.00 Rs. 208,000.00
Rs.
118,800.00
Rs.
130,680.00
Rs.
143,748.00
Rs.
158,122.80
Rs.
173,935.08
Rs.
191,328.59
Rs.
210,461.45
Rs.
231,507.59
Rs.
Rs.
1,566,583.51
Rs.
1,691,910.19
Rs.
1,827,263.00
Rs.
1,973,444.04
Rs.
2,131,319.57
Rs.
2,301,825.13

124184.2646
112894.786
102631.6236
93301.47604
433012.1503

Dena Bank
Year
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

1
1.08
1.188
1.3068
1.43748
1.581228
1.739351
1.913286
2.104614
2.315076
2.546584

Nominal cash
100000
100000
100000
100000
100000
100000
100000
100000
100000
100000

16
17
18
19
20

Year

Rs.
Rs.
Rs.
Rs.
Rs.
Rs.

open Bal
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

0
108000
224640
350611.2
486660.1
633592.9
792280.3
963662.8
1148756
1348656
1564549
1689713
1824890
1970881
2128551
2298835
2482742
2681362
2895871
3127540
3377743
3323963
3265880
3203150
3135402
3062234
2983213
2897870
2805700
2706156
2598648
2482540
2357144
2221715
2075452
1917488
1746887
1562638
1363650
1148741

cash flow
100000
100000
100000
100000
100000
100000
100000
100000
100000
100000

-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000
-300000

2,485,971.14
2,684,848.83
2,899,636.74
3,131,607.68
3,382,136.29
26,076,546.11

Interest

Clos Bal
8000
16640
25971.2
36048.896
46932.80768
58687.43229
71382.42688
85093.02103
99900.46271
115892.4997
125163.8997
135177.0117
145991.1726
157670.4664
170284.1037
183906.832
198619.3786
214508.9289
231669.6432
250203.2147
246219.4718
241917.0296
237270.3919
232252.0233
226832.1852
220978.76
214657.0608
207829.6256
200455.9957
192492.4753
183891.8734
174603.2232
164571.4811
153737.1996
142036.1756
129399.0696
115750.9952
101011.0748
85091.96076
67899.31762

108000
224640
350611.2
486660.096
633592.9037
792280.336
963662.7629
1148755.784
1348656.247
1564548.746
1689712.646
1824889.658
1970880.83
2128551.297
2298835.4
2482742.233
2681361.611
2895870.54
3127540.183
3377743.398
3323962.87
3265879.899
3203150.291
3135402.315
3062234.5
2983213.26
2897870.32
2805699.946
2706155.942
2598648.417
2482540.29
2357143.514
2221714.995
2075452.194
1917488.37
1746887.44
1562638.435
1363649.509
1148741.47
916640.7878

41
42
43
44

916640.8
665972.1
395249.8
102869.8

-300000
-300000
-300000
-299999

49331.26303
29277.76407
7619.985195
-15770.33599

665972.0509
395249.8149
102869.8001
-212899.5359

0.85%
Month
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

Cash flow
2000000
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633

intrest
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633
19633

17000
16833.1195
16666.239
16499.3585
16332.478
16165.5975
15998.717
15831.8365
15664.956
15498.0755
15331.195
15164.3145
14997.434
14830.5535
14663.673
14496.7925
14329.912
14163.0315
13996.151
13829.2705
13662.39
13495.5095
13328.629
13161.7485
12994.868
12827.9875
12661.107
12494.2265
12327.346
12160.4655
11993.585
11826.7045
11659.824
11492.9435
11326.063
11159.1825
10992.302
10825.4215
10658.541

princ repaid
2633
2799.8805
2966.761
3133.6415
3300.522
3467.4025
3634.283
3801.1635
3968.044
4134.9245
4301.805
4468.6855
4635.566
4802.4465
4969.327
5136.2075
5303.088
5469.9685
5636.849
5803.7295
5970.61
6137.4905
6304.371
6471.2515
6638.132
6805.0125
6971.893
7138.7735
7305.654
7472.5345
7639.415
7806.2955
7973.176
8140.0565
8306.937
8473.8175
8640.698
8807.5785
8974.459

princ bal
2000000
1980367
1960734
1941101
1921468
1901835
1882202
1862569
1842936
1823303
1803670
1784037
1764404
1744771
1725138
1705505
1685872
1666239
1646606
1626973
1607340
1587707
1568074
1548441
1528808
1509175
1489542
1469909
1450276
1430643
1411010
1391377
1371744
1352111
1332478
1312845
1293212
1273579
1253946
1234313

40
41
42
43
44
45

option
0
1
2
3
4
5
6
7
8
9
10
11
12

19633
19633
19633
19633
19633
19633

19633
19633
19633
19633
19633
19633

10491.6605
10324.78
10157.8995
9991.019
9824.1385
9657.258

Buy cashdown
use loan
diff
67200
18899
0
0
0
0
5833
0
5833
0
5833
0
5833
0
5833
0
5833
0
5833
0
5833
0
5833

9141.3395
9308.22
9475.1005
9641.981
9808.8615
9975.742

Mrp
Discount
Cash down
Tenor
EMI
Proc

48301
0
0
0
-5833
-5833
-5833
-5833
-5833
-5833
-5833
-5833
-5833
1.051%

Insurance
Endowment
Annualpre
Sum insure
tenor

111000
2700000
15

Term plan
Annual premium
Sum assured
Tenor

6500
2700000
15

PPF

Endowment plan
111000

premium
0
1

-111000
-111000

12

Which is better?

8.50%

Term Plan+PPF
111000
104500
1.04500E+05
1.13383E+07

1214680
1195047
1175414
1155781
1136148
1116515

8.50%

12.62%

2
3
4
5
6
7
8
9
10
11
12
13
14
15

-111000
-111000
-111000
-111000
-111000
-111000
-111000
-111000
-111000
-111000
-111000
-111000
-111000
2700000

1.23020E+09
1.33477E+11
1.44822E+13
1.57132E+15
1.70488E+17
1.84980E+19
2.00703E+21
2.17763E+23
2.36273E+25
2.56356E+27
2.78146E+29
3.01789E+31
3.27441E+33

6%

110%

108%

Rs.
13*

13.11
86.92

0.85

month

cash
cash paid intrest
principal closing
0 2000000
19633
17000
2633 1980367
1 1980367
2
3
4
5
6

70000
4%
67200
12 month
5833
2%
1400