0% ont trouvé ce document utile (0 vote)
4 vues15 pages

Tableau de prêt et d'amortissement

Le document présente un tableau d'amortissement pour un prêt de ₹ 100,000 sur une période de 360 mois avec un taux d'intérêt de 0,010833333. Chaque mois, un paiement de ₹ 1,106.20 est effectué, dont une partie est allouée aux intérêts et l'autre au principal. Le tableau détaille les soldes de début et de fin de chaque mois ainsi que les montants d'intérêts et de principal remboursés.

Transféré par

neptiao
Copyright
© All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd
0% ont trouvé ce document utile (0 vote)
4 vues15 pages

Tableau de prêt et d'amortissement

Le document présente un tableau d'amortissement pour un prêt de ₹ 100,000 sur une période de 360 mois avec un taux d'intérêt de 0,010833333. Chaque mois, un paiement de ₹ 1,106.20 est effectué, dont une partie est allouée aux intérêts et l'autre au principal. Le tableau détaille les soldes de début et de fin de chaque mois ainsi que les montants d'intérêts et de principal remboursés.

Transféré par

neptiao
Copyright
© All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd

LOAN AND AMORTISATION TABLE

AMOUNT
BORROWED ₹ 100,000.00
PERIODS 360
RATE 0.010833333
PAYMENT ₹ 1,106.20

ENDING
MONTHS BEGINNING PMT INTERESTPRINCIPAL BALANCE
1 ₹ 100,000.00 ₹ 1,106.20 ₹ 1,083.33 ₹ 22.87 ₹ 99,977.13
2 ₹ 99,977.13 ₹ 1,106.20 ₹ 1,083.09 ₹ 23.11 ₹ 99,954.02
3 ₹ 99,954.02 ₹ 1,106.20 ₹ 1,082.84 ₹ 23.36 ₹ 99,930.66
4 ₹ 99,930.66 ₹ 1,106.20 ₹ 1,082.58 ₹ 23.62 ₹ 99,907.04
5 ₹ 99,907.04 ₹ 1,106.20 ₹ 1,082.33 ₹ 23.87 ₹ 99,883.16
6 ₹ 99,883.16 ₹ 1,106.20 ₹ 1,082.07 ₹ 24.13 ₹ 99,859.03
7 ₹ 99,859.03 ₹ 1,106.20 ₹ 1,081.81 ₹ 24.39 ₹ 99,834.64
8 ₹ 99,834.64 ₹ 1,106.20 ₹ 1,081.54 ₹ 24.66 ₹ 99,809.98
9 ₹ 99,809.98 ₹ 1,106.20 ₹ 1,081.27 ₹ 24.92 ₹ 99,785.06
10 ₹ 99,785.06 ₹ 1,106.20 ₹ 1,081.00 ₹ 25.19 ₹ 99,759.86
11 ₹ 99,759.86 ₹ 1,106.20 ₹ 1,080.73 ₹ 25.47 ₹ 99,734.39
12 ₹ 99,734.39 ₹ 1,106.20 ₹ 1,080.46 ₹ 25.74 ₹ 99,708.65
13 ₹ 99,708.65 ₹ 1,106.20 ₹ 1,080.18 ₹ 26.02 ₹ 99,682.63
14 ₹ 99,682.63 ₹ 1,106.20 ₹ 1,079.90 ₹ 26.30 ₹ 99,656.32
15 ₹ 99,656.32 ₹ 1,106.20 ₹ 1,079.61 ₹ 26.59 ₹ 99,629.74
16 ₹ 99,629.74 ₹ 1,106.20 ₹ 1,079.32 ₹ 26.88 ₹ 99,602.86
17 ₹ 99,602.86 ₹ 1,106.20 ₹ 1,079.03 ₹ 27.17 ₹ 99,575.69
18 ₹ 99,575.69 ₹ 1,106.20 ₹ 1,078.74 ₹ 27.46 ₹ 99,548.23
19 ₹ 99,548.23 ₹ 1,106.20 ₹ 1,078.44 ₹ 27.76 ₹ 99,520.47
20 ₹ 99,520.47 ₹ 1,106.20 ₹ 1,078.14 ₹ 28.06 ₹ 99,492.40
21 ₹ 99,492.40 ₹ 1,106.20 ₹ 1,077.83 ₹ 28.37 ₹ 99,464.04
22 ₹ 99,464.04 ₹ 1,106.20 ₹ 1,077.53 ₹ 28.67 ₹ 99,435.37
23 ₹ 99,435.37 ₹ 1,106.20 ₹ 1,077.22 ₹ 28.98 ₹ 99,406.38
24 ₹ 99,406.38 ₹ 1,106.20 ₹ 1,076.90 ₹ 29.30 ₹ 99,377.09
25 ₹ 99,377.09 ₹ 1,106.20 ₹ 1,076.59 ₹ 29.61 ₹ 99,347.47
26 ₹ 99,347.47 ₹ 1,106.20 ₹ 1,076.26 ₹ 29.94 ₹ 99,317.54
27 ₹ 99,317.54 ₹ 1,106.20 ₹ 1,075.94 ₹ 30.26 ₹ 99,287.28
28 ₹ 99,287.28 ₹ 1,106.20 ₹ 1,075.61 ₹ 30.59 ₹ 99,256.69
29 ₹ 99,256.69 ₹ 1,106.20 ₹ 1,075.28 ₹ 30.92 ₹ 99,225.77
30 ₹ 99,225.77 ₹ 1,106.20 ₹ 1,074.95 ₹ 31.25 ₹ 99,194.52
31 ₹ 99,194.52 ₹ 1,106.20 ₹ 1,074.61 ₹ 31.59 ₹ 99,162.93
32 ₹ 99,162.93 ₹ 1,106.20 ₹ 1,074.27 ₹ 31.93 ₹ 99,130.99
33 ₹ 99,130.99 ₹ 1,106.20 ₹ 1,073.92 ₹ 32.28 ₹ 99,098.71
34 ₹ 99,098.71 ₹ 1,106.20 ₹ 1,073.57 ₹ 32.63 ₹ 99,066.08
35 ₹ 99,066.08 ₹ 1,106.20 ₹ 1,073.22 ₹ 32.98 ₹ 99,033.10
36 ₹ 99,033.10 ₹ 1,106.20 ₹ 1,072.86 ₹ 33.34 ₹ 98,999.76
37 ₹ 98,999.76 ₹ 1,106.20 ₹ 1,072.50 ₹ 33.70 ₹ 98,966.05
38 ₹ 98,966.05 ₹ 1,106.20 ₹ 1,072.13 ₹ 34.07 ₹ 98,931.99
39 ₹ 98,931.99 ₹ 1,106.20 ₹ 1,071.76 ₹ 34.44 ₹ 98,897.55
40 ₹ 98,897.55 ₹ 1,106.20 ₹ 1,071.39 ₹ 34.81 ₹ 98,862.74
41 ₹ 98,862.74 ₹ 1,106.20 ₹ 1,071.01 ₹ 35.19 ₹ 98,827.55
42 ₹ 98,827.55 ₹ 1,106.20 ₹ 1,070.63 ₹ 35.57 ₹ 98,791.99
43 ₹ 98,791.99 ₹ 1,106.20 ₹ 1,070.25 ₹ 35.95 ₹ 98,756.03
44 ₹ 98,756.03 ₹ 1,106.20 ₹ 1,069.86 ₹ 36.34 ₹ 98,719.69
45 ₹ 98,719.69 ₹ 1,106.20 ₹ 1,069.46 ₹ 36.74 ₹ 98,682.96
46 ₹ 98,682.96 ₹ 1,106.20 ₹ 1,069.07 ₹ 37.13 ₹ 98,645.82
47 ₹ 98,645.82 ₹ 1,106.20 ₹ 1,068.66 ₹ 37.54 ₹ 98,608.28
48 ₹ 98,608.28 ₹ 1,106.20 ₹ 1,068.26 ₹ 37.94 ₹ 98,570.34
49 ₹ 98,570.34 ₹ 1,106.20 ₹ 1,067.85 ₹ 38.35 ₹ 98,531.99
50 ₹ 98,531.99 ₹ 1,106.20 ₹ 1,067.43 ₹ 38.77 ₹ 98,493.22
51 ₹ 98,493.22 ₹ 1,106.20 ₹ 1,067.01 ₹ 39.19 ₹ 98,454.03
52 ₹ 98,454.03 ₹ 1,106.20 ₹ 1,066.59 ₹ 39.61 ₹ 98,414.41
53 ₹ 98,414.41 ₹ 1,106.20 ₹ 1,066.16 ₹ 40.04 ₹ 98,374.37
54 ₹ 98,374.37 ₹ 1,106.20 ₹ 1,065.72 ₹ 40.48 ₹ 98,333.89
55 ₹ 98,333.89 ₹ 1,106.20 ₹ 1,065.28 ₹ 40.92 ₹ 98,292.98
56 ₹ 98,292.98 ₹ 1,106.20 ₹ 1,064.84 ₹ 41.36 ₹ 98,251.62
57 ₹ 98,251.62 ₹ 1,106.20 ₹ 1,064.39 ₹ 41.81 ₹ 98,209.81
58 ₹ 98,209.81 ₹ 1,106.20 ₹ 1,063.94 ₹ 42.26 ₹ 98,167.55
59 ₹ 98,167.55 ₹ 1,106.20 ₹ 1,063.48 ₹ 42.72 ₹ 98,124.83
60 ₹ 98,124.83 ₹ 1,106.20 ₹ 1,063.02 ₹ 43.18 ₹ 98,081.65
61 ₹ 98,081.65 ₹ 1,106.20 ₹ 1,062.55 ₹ 43.65 ₹ 98,038.01
62 ₹ 98,038.01 ₹ 1,106.20 ₹ 1,062.08 ₹ 44.12 ₹ 97,993.88
63 ₹ 97,993.88 ₹ 1,106.20 ₹ 1,061.60 ₹ 44.60 ₹ 97,949.29
64 ₹ 97,949.29 ₹ 1,106.20 ₹ 1,061.12 ₹ 45.08 ₹ 97,904.20
65 ₹ 97,904.20 ₹ 1,106.20 ₹ 1,060.63 ₹ 45.57 ₹ 97,858.63
66 ₹ 97,858.63 ₹ 1,106.20 ₹ 1,060.14 ₹ 46.06 ₹ 97,812.57
67 ₹ 97,812.57 ₹ 1,106.20 ₹ 1,059.64 ₹ 46.56 ₹ 97,766.00
68 ₹ 97,766.00 ₹ 1,106.20 ₹ 1,059.13 ₹ 47.07 ₹ 97,718.94
69 ₹ 97,718.94 ₹ 1,106.20 ₹ 1,058.62 ₹ 47.58 ₹ 97,671.36
70 ₹ 97,671.36 ₹ 1,106.20 ₹ 1,058.11 ₹ 48.09 ₹ 97,623.27
71 ₹ 97,623.27 ₹ 1,106.20 ₹ 1,057.59 ₹ 48.61 ₹ 97,574.65
72 ₹ 97,574.65 ₹ 1,106.20 ₹ 1,057.06 ₹ 49.14 ₹ 97,525.51
73 ₹ 97,525.51 ₹ 1,106.20 ₹ 1,056.53 ₹ 49.67 ₹ 97,475.84
74 ₹ 97,475.84 ₹ 1,106.20 ₹ 1,055.99 ₹ 50.21 ₹ 97,425.63
75 ₹ 97,425.63 ₹ 1,106.20 ₹ 1,055.44 ₹ 50.76 ₹ 97,374.87
76 ₹ 97,374.87 ₹ 1,106.20 ₹ 1,054.89 ₹ 51.31 ₹ 97,323.57
77 ₹ 97,323.57 ₹ 1,106.20 ₹ 1,054.34 ₹ 51.86 ₹ 97,271.71
78 ₹ 97,271.71 ₹ 1,106.20 ₹ 1,053.78 ₹ 52.42 ₹ 97,219.28
79 ₹ 97,219.28 ₹ 1,106.20 ₹ 1,053.21 ₹ 52.99 ₹ 97,166.29
80 ₹ 97,166.29 ₹ 1,106.20 ₹ 1,052.63 ₹ 53.56 ₹ 97,112.73
81 ₹ 97,112.73 ₹ 1,106.20 ₹ 1,052.05 ₹ 54.14 ₹ 97,058.58
82 ₹ 97,058.58 ₹ 1,106.20 ₹ 1,051.47 ₹ 54.73 ₹ 97,003.85
83 ₹ 97,003.85 ₹ 1,106.20 ₹ 1,050.88 ₹ 55.32 ₹ 96,948.53
84 ₹ 96,948.53 ₹ 1,106.20 ₹ 1,050.28 ₹ 55.92 ₹ 96,892.60
85 ₹ 96,892.60 ₹ 1,106.20 ₹ 1,049.67 ₹ 56.53 ₹ 96,836.07
86 ₹ 96,836.07 ₹ 1,106.20 ₹ 1,049.06 ₹ 57.14 ₹ 96,778.93
87 ₹ 96,778.93 ₹ 1,106.20 ₹ 1,048.44 ₹ 57.76 ₹ 96,721.17
88 ₹ 96,721.17 ₹ 1,106.20 ₹ 1,047.81 ₹ 58.39 ₹ 96,662.78
89 ₹ 96,662.78 ₹ 1,106.20 ₹ 1,047.18 ₹ 59.02 ₹ 96,603.76
90 ₹ 96,603.76 ₹ 1,106.20 ₹ 1,046.54 ₹ 59.66 ₹ 96,544.11
91 ₹ 96,544.11 ₹ 1,106.20 ₹ 1,045.89 ₹ 60.31 ₹ 96,483.80
92 ₹ 96,483.80 ₹ 1,106.20 ₹ 1,045.24 ₹ 60.96 ₹ 96,422.84
93 ₹ 96,422.84 ₹ 1,106.20 ₹ 1,044.58 ₹ 61.62 ₹ 96,361.22
94 ₹ 96,361.22 ₹ 1,106.20 ₹ 1,043.91 ₹ 62.29 ₹ 96,298.94
95 ₹ 96,298.94 ₹ 1,106.20 ₹ 1,043.24 ₹ 62.96 ₹ 96,235.98
96 ₹ 96,235.98 ₹ 1,106.20 ₹ 1,042.56 ₹ 63.64 ₹ 96,172.33
97 ₹ 96,172.33 ₹ 1,106.20 ₹ 1,041.87 ₹ 64.33 ₹ 96,108.00
98 ₹ 96,108.00 ₹ 1,106.20 ₹ 1,041.17 ₹ 65.03 ₹ 96,042.97
99 ₹ 96,042.97 ₹ 1,106.20 ₹ 1,040.47 ₹ 65.73 ₹ 95,977.24
100 ₹ 95,977.24 ₹ 1,106.20 ₹ 1,039.75 ₹ 66.45 ₹ 95,910.79
101 ₹ 95,910.79 ₹ 1,106.20 ₹ 1,039.03 ₹ 67.17 ₹ 95,843.62
102 ₹ 95,843.62 ₹ 1,106.20 ₹ 1,038.31 ₹ 67.89 ₹ 95,775.73
103 ₹ 95,775.73 ₹ 1,106.20 ₹ 1,037.57 ₹ 68.63 ₹ 95,707.10
104 ₹ 95,707.10 ₹ 1,106.20 ₹ 1,036.83 ₹ 69.37 ₹ 95,637.73
105 ₹ 95,637.73 ₹ 1,106.20 ₹ 1,036.08 ₹ 70.12 ₹ 95,567.60
106 ₹ 95,567.60 ₹ 1,106.20 ₹ 1,035.32 ₹ 70.88 ₹ 95,496.72
107 ₹ 95,496.72 ₹ 1,106.20 ₹ 1,034.55 ₹ 71.65 ₹ 95,425.07
108 ₹ 95,425.07 ₹ 1,106.20 ₹ 1,033.77 ₹ 72.43 ₹ 95,352.64
109 ₹ 95,352.64 ₹ 1,106.20 ₹ 1,032.99 ₹ 73.21 ₹ 95,279.43
110 ₹ 95,279.43 ₹ 1,106.20 ₹ 1,032.19 ₹ 74.01 ₹ 95,205.42
111 ₹ 95,205.42 ₹ 1,106.20 ₹ 1,031.39 ₹ 74.81 ₹ 95,130.62
112 ₹ 95,130.62 ₹ 1,106.20 ₹ 1,030.58 ₹ 75.62 ₹ 95,055.00
113 ₹ 95,055.00 ₹ 1,106.20 ₹ 1,029.76 ₹ 76.44 ₹ 94,978.56
114 ₹ 94,978.56 ₹ 1,106.20 ₹ 1,028.93 ₹ 77.27 ₹ 94,901.30
115 ₹ 94,901.30 ₹ 1,106.20 ₹ 1,028.10 ₹ 78.10 ₹ 94,823.19
116 ₹ 94,823.19 ₹ 1,106.20 ₹ 1,027.25 ₹ 78.95 ₹ 94,744.25
117 ₹ 94,744.25 ₹ 1,106.20 ₹ 1,026.40 ₹ 79.80 ₹ 94,664.44
118 ₹ 94,664.44 ₹ 1,106.20 ₹ 1,025.53 ₹ 80.67 ₹ 94,583.77
119 ₹ 94,583.77 ₹ 1,106.20 ₹ 1,024.66 ₹ 81.54 ₹ 94,502.23
120 ₹ 94,502.23 ₹ 1,106.20 ₹ 1,023.77 ₹ 82.43 ₹ 94,419.81
121 ₹ 94,419.81 ₹ 1,106.20 ₹ 1,022.88 ₹ 83.32 ₹ 94,336.49
122 ₹ 94,336.49 ₹ 1,106.20 ₹ 1,021.98 ₹ 84.22 ₹ 94,252.27
123 ₹ 94,252.27 ₹ 1,106.20 ₹ 1,021.07 ₹ 85.13 ₹ 94,167.13
124 ₹ 94,167.13 ₹ 1,106.20 ₹ 1,020.14 ₹ 86.06 ₹ 94,081.08
125 ₹ 94,081.08 ₹ 1,106.20 ₹ 1,019.21 ₹ 86.99 ₹ 93,994.09
126 ₹ 93,994.09 ₹ 1,106.20 ₹ 1,018.27 ₹ 87.93 ₹ 93,906.16
127 ₹ 93,906.16 ₹ 1,106.20 ₹ 1,017.32 ₹ 88.88 ₹ 93,817.28
128 ₹ 93,817.28 ₹ 1,106.20 ₹ 1,016.35 ₹ 89.85 ₹ 93,727.43
129 ₹ 93,727.43 ₹ 1,106.20 ₹ 1,015.38 ₹ 90.82 ₹ 93,636.61
130 ₹ 93,636.61 ₹ 1,106.20 ₹ 1,014.40 ₹ 91.80 ₹ 93,544.81
131 ₹ 93,544.81 ₹ 1,106.20 ₹ 1,013.40 ₹ 92.80 ₹ 93,452.01
132 ₹ 93,452.01 ₹ 1,106.20 ₹ 1,012.40 ₹ 93.80 ₹ 93,358.21
133 ₹ 93,358.21 ₹ 1,106.20 ₹ 1,011.38 ₹ 94.82 ₹ 93,263.39
134 ₹ 93,263.39 ₹ 1,106.20 ₹ 1,010.35 ₹ 95.85 ₹ 93,167.54
135 ₹ 93,167.54 ₹ 1,106.20 ₹ 1,009.32 ₹ 96.88 ₹ 93,070.66
136 ₹ 93,070.66 ₹ 1,106.20 ₹ 1,008.27 ₹ 97.93 ₹ 92,972.73
137 ₹ 92,972.73 ₹ 1,106.20 ₹ 1,007.20 ₹ 98.99 ₹ 92,873.73
138 ₹ 92,873.73 ₹ 1,106.20 ₹ 1,006.13 ₹ 100.07 ₹ 92,773.66
139 ₹ 92,773.66 ₹ 1,106.20 ₹ 1,005.05 ₹ 101.15 ₹ 92,672.51
140 ₹ 92,672.51 ₹ 1,106.20 ₹ 1,003.95 ₹ 102.25 ₹ 92,570.27
141 ₹ 92,570.27 ₹ 1,106.20 ₹ 1,002.84 ₹ 103.35 ₹ 92,466.91
142 ₹ 92,466.91 ₹ 1,106.20 ₹ 1,001.72 ₹ 104.47 ₹ 92,362.44
143 ₹ 92,362.44 ₹ 1,106.20 ₹ 1,000.59 ₹ 105.61 ₹ 92,256.83
144 ₹ 92,256.83 ₹ 1,106.20 ₹ 999.45 ₹ 106.75 ₹ 92,150.08
145 ₹ 92,150.08 ₹ 1,106.20 ₹ 998.29 ₹ 107.91 ₹ 92,042.17
146 ₹ 92,042.17 ₹ 1,106.20 ₹ 997.12 ₹ 109.08 ₹ 91,933.10
147 ₹ 91,933.10 ₹ 1,106.20 ₹ 995.94 ₹ 110.26 ₹ 91,822.84
148 ₹ 91,822.84 ₹ 1,106.20 ₹ 994.75 ₹ 111.45 ₹ 91,711.39
149 ₹ 91,711.39 ₹ 1,106.20 ₹ 993.54 ₹ 112.66 ₹ 91,598.73
150 ₹ 91,598.73 ₹ 1,106.20 ₹ 992.32 ₹ 113.88 ₹ 91,484.85
151 ₹ 91,484.85 ₹ 1,106.20 ₹ 991.09 ₹ 115.11 ₹ 91,369.73
152 ₹ 91,369.73 ₹ 1,106.20 ₹ 989.84 ₹ 116.36 ₹ 91,253.37
153 ₹ 91,253.37 ₹ 1,106.20 ₹ 988.58 ₹ 117.62 ₹ 91,135.75
154 ₹ 91,135.75 ₹ 1,106.20 ₹ 987.30 ₹ 118.90 ₹ 91,016.86
155 ₹ 91,016.86 ₹ 1,106.20 ₹ 986.02 ₹ 120.18 ₹ 90,896.67
156 ₹ 90,896.67 ₹ 1,106.20 ₹ 984.71 ₹ 121.49 ₹ 90,775.19
157 ₹ 90,775.19 ₹ 1,106.20 ₹ 983.40 ₹ 122.80 ₹ 90,652.38
158 ₹ 90,652.38 ₹ 1,106.20 ₹ 982.07 ₹ 124.13 ₹ 90,528.25
159 ₹ 90,528.25 ₹ 1,106.20 ₹ 980.72 ₹ 125.48 ₹ 90,402.78
160 ₹ 90,402.78 ₹ 1,106.20 ₹ 979.36 ₹ 126.84 ₹ 90,275.94
161 ₹ 90,275.94 ₹ 1,106.20 ₹ 977.99 ₹ 128.21 ₹ 90,147.73
162 ₹ 90,147.73 ₹ 1,106.20 ₹ 976.60 ₹ 129.60 ₹ 90,018.13
163 ₹ 90,018.13 ₹ 1,106.20 ₹ 975.20 ₹ 131.00 ₹ 89,887.13
164 ₹ 89,887.13 ₹ 1,106.20 ₹ 973.78 ₹ 132.42 ₹ 89,754.70
165 ₹ 89,754.70 ₹ 1,106.20 ₹ 972.34 ₹ 133.86 ₹ 89,620.85
166 ₹ 89,620.85 ₹ 1,106.20 ₹ 970.89 ₹ 135.31 ₹ 89,485.54
167 ₹ 89,485.54 ₹ 1,106.20 ₹ 969.43 ₹ 136.77 ₹ 89,348.77
168 ₹ 89,348.77 ₹ 1,106.20 ₹ 967.94 ₹ 138.25 ₹ 89,210.51
169 ₹ 89,210.51 ₹ 1,106.20 ₹ 966.45 ₹ 139.75 ₹ 89,070.76
170 ₹ 89,070.76 ₹ 1,106.20 ₹ 964.93 ₹ 141.27 ₹ 88,929.49
171 ₹ 88,929.49 ₹ 1,106.20 ₹ 963.40 ₹ 142.80 ₹ 88,786.70
172 ₹ 88,786.70 ₹ 1,106.20 ₹ 961.86 ₹ 144.34 ₹ 88,642.35
173 ₹ 88,642.35 ₹ 1,106.20 ₹ 960.29 ₹ 145.91 ₹ 88,496.45
174 ₹ 88,496.45 ₹ 1,106.20 ₹ 958.71 ₹ 147.49 ₹ 88,348.96
175 ₹ 88,348.96 ₹ 1,106.20 ₹ 957.11 ₹ 149.09 ₹ 88,199.87
176 ₹ 88,199.87 ₹ 1,106.20 ₹ 955.50 ₹ 150.70 ₹ 88,049.17
177 ₹ 88,049.17 ₹ 1,106.20 ₹ 953.87 ₹ 152.33 ₹ 87,896.84
178 ₹ 87,896.84 ₹ 1,106.20 ₹ 952.22 ₹ 153.98 ₹ 87,742.86
179 ₹ 87,742.86 ₹ 1,106.20 ₹ 950.55 ₹ 155.65 ₹ 87,587.20
180 ₹ 87,587.20 ₹ 1,106.20 ₹ 948.86 ₹ 157.34 ₹ 87,429.87
181 ₹ 87,429.87 ₹ 1,106.20 ₹ 947.16 ₹ 159.04 ₹ 87,270.82
182 ₹ 87,270.82 ₹ 1,106.20 ₹ 945.43 ₹ 160.77 ₹ 87,110.06
183 ₹ 87,110.06 ₹ 1,106.20 ₹ 943.69 ₹ 162.51 ₹ 86,947.55
184 ₹ 86,947.55 ₹ 1,106.20 ₹ 941.93 ₹ 164.27 ₹ 86,783.28
185 ₹ 86,783.28 ₹ 1,106.20 ₹ 940.15 ₹ 166.05 ₹ 86,617.23
186 ₹ 86,617.23 ₹ 1,106.20 ₹ 938.35 ₹ 167.85 ₹ 86,449.39
187 ₹ 86,449.39 ₹ 1,106.20 ₹ 936.54 ₹ 169.66 ₹ 86,279.72
188 ₹ 86,279.72 ₹ 1,106.20 ₹ 934.70 ₹ 171.50 ₹ 86,108.22
189 ₹ 86,108.22 ₹ 1,106.20 ₹ 932.84 ₹ 173.36 ₹ 85,934.86
190 ₹ 85,934.86 ₹ 1,106.20 ₹ 930.96 ₹ 175.24 ₹ 85,759.62
191 ₹ 85,759.62 ₹ 1,106.20 ₹ 929.06 ₹ 177.14 ₹ 85,582.49
192 ₹ 85,582.49 ₹ 1,106.20 ₹ 927.14 ₹ 179.06 ₹ 85,403.43
193 ₹ 85,403.43 ₹ 1,106.20 ₹ 925.20 ₹ 181.00 ₹ 85,222.43
194 ₹ 85,222.43 ₹ 1,106.20 ₹ 923.24 ₹ 182.96 ₹ 85,039.48
195 ₹ 85,039.48 ₹ 1,106.20 ₹ 921.26 ₹ 184.94 ₹ 84,854.54
196 ₹ 84,854.54 ₹ 1,106.20 ₹ 919.26 ₹ 186.94 ₹ 84,667.60
197 ₹ 84,667.60 ₹ 1,106.20 ₹ 917.23 ₹ 188.97 ₹ 84,478.63
198 ₹ 84,478.63 ₹ 1,106.20 ₹ 915.19 ₹ 191.01 ₹ 84,287.62
199 ₹ 84,287.62 ₹ 1,106.20 ₹ 913.12 ₹ 193.08 ₹ 84,094.53
200 ₹ 84,094.53 ₹ 1,106.20 ₹ 911.02 ₹ 195.18 ₹ 83,899.36
201 ₹ 83,899.36 ₹ 1,106.20 ₹ 908.91 ₹ 197.29 ₹ 83,702.07
202 ₹ 83,702.07 ₹ 1,106.20 ₹ 906.77 ₹ 199.43 ₹ 83,502.64
203 ₹ 83,502.64 ₹ 1,106.20 ₹ 904.61 ₹ 201.59 ₹ 83,301.05
204 ₹ 83,301.05 ₹ 1,106.20 ₹ 902.43 ₹ 203.77 ₹ 83,097.28
205 ₹ 83,097.28 ₹ 1,106.20 ₹ 900.22 ₹ 205.98 ₹ 82,891.30
206 ₹ 82,891.30 ₹ 1,106.20 ₹ 897.99 ₹ 208.21 ₹ 82,683.09
207 ₹ 82,683.09 ₹ 1,106.20 ₹ 895.73 ₹ 210.47 ₹ 82,472.62
208 ₹ 82,472.62 ₹ 1,106.20 ₹ 893.45 ₹ 212.75 ₹ 82,259.88
209 ₹ 82,259.88 ₹ 1,106.20 ₹ 891.15 ₹ 215.05 ₹ 82,044.83
210 ₹ 82,044.83 ₹ 1,106.20 ₹ 888.82 ₹ 217.38 ₹ 81,827.45
211 ₹ 81,827.45 ₹ 1,106.20 ₹ 886.46 ₹ 219.74 ₹ 81,607.71
212 ₹ 81,607.71 ₹ 1,106.20 ₹ 884.08 ₹ 222.12 ₹ 81,385.60
213 ₹ 81,385.60 ₹ 1,106.20 ₹ 881.68 ₹ 224.52 ₹ 81,161.07
214 ₹ 81,161.07 ₹ 1,106.20 ₹ 879.24 ₹ 226.95 ₹ 80,934.12
215 ₹ 80,934.12 ₹ 1,106.20 ₹ 876.79 ₹ 229.41 ₹ 80,704.71
216 ₹ 80,704.71 ₹ 1,106.20 ₹ 874.30 ₹ 231.90 ₹ 80,472.81
217 ₹ 80,472.81 ₹ 1,106.20 ₹ 871.79 ₹ 234.41 ₹ 80,238.40
218 ₹ 80,238.40 ₹ 1,106.20 ₹ 869.25 ₹ 236.95 ₹ 80,001.45
219 ₹ 80,001.45 ₹ 1,106.20 ₹ 866.68 ₹ 239.52 ₹ 79,761.93
220 ₹ 79,761.93 ₹ 1,106.20 ₹ 864.09 ₹ 242.11 ₹ 79,519.82
221 ₹ 79,519.82 ₹ 1,106.20 ₹ 861.46 ₹ 244.73 ₹ 79,275.08
222 ₹ 79,275.08 ₹ 1,106.20 ₹ 858.81 ₹ 247.39 ₹ 79,027.70
223 ₹ 79,027.70 ₹ 1,106.20 ₹ 856.13 ₹ 250.07 ₹ 78,777.63
224 ₹ 78,777.63 ₹ 1,106.20 ₹ 853.42 ₹ 252.78 ₹ 78,524.85
225 ₹ 78,524.85 ₹ 1,106.20 ₹ 850.69 ₹ 255.51 ₹ 78,269.34
226 ₹ 78,269.34 ₹ 1,106.20 ₹ 847.92 ₹ 258.28 ₹ 78,011.06
227 ₹ 78,011.06 ₹ 1,106.20 ₹ 845.12 ₹ 261.08 ₹ 77,749.98
228 ₹ 77,749.98 ₹ 1,106.20 ₹ 842.29 ₹ 263.91 ₹ 77,486.07
229 ₹ 77,486.07 ₹ 1,106.20 ₹ 839.43 ₹ 266.77 ₹ 77,219.30
230 ₹ 77,219.30 ₹ 1,106.20 ₹ 836.54 ₹ 269.66 ₹ 76,949.65
231 ₹ 76,949.65 ₹ 1,106.20 ₹ 833.62 ₹ 272.58 ₹ 76,677.07
232 ₹ 76,677.07 ₹ 1,106.20 ₹ 830.67 ₹ 275.53 ₹ 76,401.54
233 ₹ 76,401.54 ₹ 1,106.20 ₹ 827.68 ₹ 278.52 ₹ 76,123.02
234 ₹ 76,123.02 ₹ 1,106.20 ₹ 824.67 ₹ 281.53 ₹ 75,841.49
235 ₹ 75,841.49 ₹ 1,106.20 ₹ 821.62 ₹ 284.58 ₹ 75,556.90
236 ₹ 75,556.90 ₹ 1,106.20 ₹ 818.53 ₹ 287.67 ₹ 75,269.24
237 ₹ 75,269.24 ₹ 1,106.20 ₹ 815.42 ₹ 290.78 ₹ 74,978.46
238 ₹ 74,978.46 ₹ 1,106.20 ₹ 812.27 ₹ 293.93 ₹ 74,684.52
239 ₹ 74,684.52 ₹ 1,106.20 ₹ 809.08 ₹ 297.12 ₹ 74,387.41
240 ₹ 74,387.41 ₹ 1,106.20 ₹ 805.86 ₹ 300.34 ₹ 74,087.07
241 ₹ 74,087.07 ₹ 1,106.20 ₹ 802.61 ₹ 303.59 ₹ 73,783.48
242 ₹ 73,783.48 ₹ 1,106.20 ₹ 799.32 ₹ 306.88 ₹ 73,476.60
243 ₹ 73,476.60 ₹ 1,106.20 ₹ 796.00 ₹ 310.20 ₹ 73,166.40
244 ₹ 73,166.40 ₹ 1,106.20 ₹ 792.64 ₹ 313.56 ₹ 72,852.84
245 ₹ 72,852.84 ₹ 1,106.20 ₹ 789.24 ₹ 316.96 ₹ 72,535.87
246 ₹ 72,535.87 ₹ 1,106.20 ₹ 785.81 ₹ 320.39 ₹ 72,215.48
247 ₹ 72,215.48 ₹ 1,106.20 ₹ 782.33 ₹ 323.87 ₹ 71,891.62
248 ₹ 71,891.62 ₹ 1,106.20 ₹ 778.83 ₹ 327.37 ₹ 71,564.24
249 ₹ 71,564.24 ₹ 1,106.20 ₹ 775.28 ₹ 330.92 ₹ 71,233.32
250 ₹ 71,233.32 ₹ 1,106.20 ₹ 771.69 ₹ 334.51 ₹ 70,898.82
251 ₹ 70,898.82 ₹ 1,106.20 ₹ 768.07 ₹ 338.13 ₹ 70,560.69
252 ₹ 70,560.69 ₹ 1,106.20 ₹ 764.41 ₹ 341.79 ₹ 70,218.89
253 ₹ 70,218.89 ₹ 1,106.20 ₹ 760.70 ₹ 345.49 ₹ 69,873.40
254 ₹ 69,873.40 ₹ 1,106.20 ₹ 756.96 ₹ 349.24 ₹ 69,524.16
255 ₹ 69,524.16 ₹ 1,106.20 ₹ 753.18 ₹ 353.02 ₹ 69,171.14
256 ₹ 69,171.14 ₹ 1,106.20 ₹ 749.35 ₹ 356.85 ₹ 68,814.30
257 ₹ 68,814.30 ₹ 1,106.20 ₹ 745.49 ₹ 360.71 ₹ 68,453.58
258 ₹ 68,453.58 ₹ 1,106.20 ₹ 741.58 ₹ 364.62 ₹ 68,088.97
259 ₹ 68,088.97 ₹ 1,106.20 ₹ 737.63 ₹ 368.57 ₹ 67,720.40
260 ₹ 67,720.40 ₹ 1,106.20 ₹ 733.64 ₹ 372.56 ₹ 67,347.83
261 ₹ 67,347.83 ₹ 1,106.20 ₹ 729.60 ₹ 376.60 ₹ 66,971.24
262 ₹ 66,971.24 ₹ 1,106.20 ₹ 725.52 ₹ 380.68 ₹ 66,590.56
263 ₹ 66,590.56 ₹ 1,106.20 ₹ 721.40 ₹ 384.80 ₹ 66,205.76
264 ₹ 66,205.76 ₹ 1,106.20 ₹ 717.23 ₹ 388.97 ₹ 65,816.79
265 ₹ 65,816.79 ₹ 1,106.20 ₹ 713.02 ₹ 393.18 ₹ 65,423.60
266 ₹ 65,423.60 ₹ 1,106.20 ₹ 708.76 ₹ 397.44 ₹ 65,026.16
267 ₹ 65,026.16 ₹ 1,106.20 ₹ 704.45 ₹ 401.75 ₹ 64,624.41
268 ₹ 64,624.41 ₹ 1,106.20 ₹ 700.10 ₹ 406.10 ₹ 64,218.31
269 ₹ 64,218.31 ₹ 1,106.20 ₹ 695.70 ₹ 410.50 ₹ 63,807.81
270 ₹ 63,807.81 ₹ 1,106.20 ₹ 691.25 ₹ 414.95 ₹ 63,392.86
271 ₹ 63,392.86 ₹ 1,106.20 ₹ 686.76 ₹ 419.44 ₹ 62,973.41
272 ₹ 62,973.41 ₹ 1,106.20 ₹ 682.21 ₹ 423.99 ₹ 62,549.43
273 ₹ 62,549.43 ₹ 1,106.20 ₹ 677.62 ₹ 428.58 ₹ 62,120.85
274 ₹ 62,120.85 ₹ 1,106.20 ₹ 672.98 ₹ 433.22 ₹ 61,687.62
275 ₹ 61,687.62 ₹ 1,106.20 ₹ 668.28 ₹ 437.92 ₹ 61,249.71
276 ₹ 61,249.71 ₹ 1,106.20 ₹ 663.54 ₹ 442.66 ₹ 60,807.04
277 ₹ 60,807.04 ₹ 1,106.20 ₹ 658.74 ₹ 447.46 ₹ 60,359.59
278 ₹ 60,359.59 ₹ 1,106.20 ₹ 653.90 ₹ 452.30 ₹ 59,907.28
279 ₹ 59,907.28 ₹ 1,106.20 ₹ 649.00 ₹ 457.20 ₹ 59,450.08
280 ₹ 59,450.08 ₹ 1,106.20 ₹ 644.04 ₹ 462.16 ₹ 58,987.92
281 ₹ 58,987.92 ₹ 1,106.20 ₹ 639.04 ₹ 467.16 ₹ 58,520.76
282 ₹ 58,520.76 ₹ 1,106.20 ₹ 633.97 ₹ 472.22 ₹ 58,048.53
283 ₹ 58,048.53 ₹ 1,106.20 ₹ 628.86 ₹ 477.34 ₹ 57,571.19
284 ₹ 57,571.19 ₹ 1,106.20 ₹ 623.69 ₹ 482.51 ₹ 57,088.68
285 ₹ 57,088.68 ₹ 1,106.20 ₹ 618.46 ₹ 487.74 ₹ 56,600.94
286 ₹ 56,600.94 ₹ 1,106.20 ₹ 613.18 ₹ 493.02 ₹ 56,107.92
287 ₹ 56,107.92 ₹ 1,106.20 ₹ 607.84 ₹ 498.36 ₹ 55,609.56
288 ₹ 55,609.56 ₹ 1,106.20 ₹ 602.44 ₹ 503.76 ₹ 55,105.79
289 ₹ 55,105.79 ₹ 1,106.20 ₹ 596.98 ₹ 509.22 ₹ 54,596.57
290 ₹ 54,596.57 ₹ 1,106.20 ₹ 591.46 ₹ 514.74 ₹ 54,081.84
291 ₹ 54,081.84 ₹ 1,106.20 ₹ 585.89 ₹ 520.31 ₹ 53,561.53
292 ₹ 53,561.53 ₹ 1,106.20 ₹ 580.25 ₹ 525.95 ₹ 53,035.58
293 ₹ 53,035.58 ₹ 1,106.20 ₹ 574.55 ₹ 531.65 ₹ 52,503.93
294 ₹ 52,503.93 ₹ 1,106.20 ₹ 568.79 ₹ 537.41 ₹ 51,966.52
295 ₹ 51,966.52 ₹ 1,106.20 ₹ 562.97 ₹ 543.23 ₹ 51,423.29
296 ₹ 51,423.29 ₹ 1,106.20 ₹ 557.09 ₹ 549.11 ₹ 50,874.18
297 ₹ 50,874.18 ₹ 1,106.20 ₹ 551.14 ₹ 555.06 ₹ 50,319.12
298 ₹ 50,319.12 ₹ 1,106.20 ₹ 545.12 ₹ 561.08 ₹ 49,758.04
299 ₹ 49,758.04 ₹ 1,106.20 ₹ 539.05 ₹ 567.15 ₹ 49,190.89
300 ₹ 49,190.89 ₹ 1,106.20 ₹ 532.90 ₹ 573.30 ₹ 48,617.59
301 ₹ 48,617.59 ₹ 1,106.20 ₹ 526.69 ₹ 579.51 ₹ 48,038.08
302 ₹ 48,038.08 ₹ 1,106.20 ₹ 520.41 ₹ 585.79 ₹ 47,452.29
303 ₹ 47,452.29 ₹ 1,106.20 ₹ 514.07 ₹ 592.13 ₹ 46,860.16
304 ₹ 46,860.16 ₹ 1,106.20 ₹ 507.65 ₹ 598.55 ₹ 46,261.61
305 ₹ 46,261.61 ₹ 1,106.20 ₹ 501.17 ₹ 605.03 ₹ 45,656.58
306 ₹ 45,656.58 ₹ 1,106.20 ₹ 494.61 ₹ 611.59 ₹ 45,044.99
307 ₹ 45,044.99 ₹ 1,106.20 ₹ 487.99 ₹ 618.21 ₹ 44,426.78
308 ₹ 44,426.78 ₹ 1,106.20 ₹ 481.29 ₹ 624.91 ₹ 43,801.87
309 ₹ 43,801.87 ₹ 1,106.20 ₹ 474.52 ₹ 631.68 ₹ 43,170.19
310 ₹ 43,170.19 ₹ 1,106.20 ₹ 467.68 ₹ 638.52 ₹ 42,531.67
311 ₹ 42,531.67 ₹ 1,106.20 ₹ 460.76 ₹ 645.44 ₹ 41,886.23
312 ₹ 41,886.23 ₹ 1,106.20 ₹ 453.77 ₹ 652.43 ₹ 41,233.80
313 ₹ 41,233.80 ₹ 1,106.20 ₹ 446.70 ₹ 659.50 ₹ 40,574.30
314 ₹ 40,574.30 ₹ 1,106.20 ₹ 439.55 ₹ 666.64 ₹ 39,907.65
315 ₹ 39,907.65 ₹ 1,106.20 ₹ 432.33 ₹ 673.87 ₹ 39,233.79
316 ₹ 39,233.79 ₹ 1,106.20 ₹ 425.03 ₹ 681.17 ₹ 38,552.62
317 ₹ 38,552.62 ₹ 1,106.20 ₹ 417.65 ₹ 688.55 ₹ 37,864.07
318 ₹ 37,864.07 ₹ 1,106.20 ₹ 410.19 ₹ 696.01 ₹ 37,168.07
319 ₹ 37,168.07 ₹ 1,106.20 ₹ 402.65 ₹ 703.55 ₹ 36,464.52
320 ₹ 36,464.52 ₹ 1,106.20 ₹ 395.03 ₹ 711.17 ₹ 35,753.35
321 ₹ 35,753.35 ₹ 1,106.20 ₹ 387.33 ₹ 718.87 ₹ 35,034.48
322 ₹ 35,034.48 ₹ 1,106.20 ₹ 379.54 ₹ 726.66 ₹ 34,307.82
323 ₹ 34,307.82 ₹ 1,106.20 ₹ 371.67 ₹ 734.53 ₹ 33,573.29
324 ₹ 33,573.29 ₹ 1,106.20 ₹ 363.71 ₹ 742.49 ₹ 32,830.80
325 ₹ 32,830.80 ₹ 1,106.20 ₹ 355.67 ₹ 750.53 ₹ 32,080.27
326 ₹ 32,080.27 ₹ 1,106.20 ₹ 347.54 ₹ 758.66 ₹ 31,321.61
327 ₹ 31,321.61 ₹ 1,106.20 ₹ 339.32 ₹ 766.88 ₹ 30,554.73
328 ₹ 30,554.73 ₹ 1,106.20 ₹ 331.01 ₹ 775.19 ₹ 29,779.54
329 ₹ 29,779.54 ₹ 1,106.20 ₹ 322.61 ₹ 783.59 ₹ 28,995.95
330 ₹ 28,995.95 ₹ 1,106.20 ₹ 314.12 ₹ 792.08 ₹ 28,203.87
331 ₹ 28,203.87 ₹ 1,106.20 ₹ 305.54 ₹ 800.66 ₹ 27,403.21
332 ₹ 27,403.21 ₹ 1,106.20 ₹ 296.87 ₹ 809.33 ₹ 26,593.88
333 ₹ 26,593.88 ₹ 1,106.20 ₹ 288.10 ₹ 818.10 ₹ 25,775.78
334 ₹ 25,775.78 ₹ 1,106.20 ₹ 279.24 ₹ 826.96 ₹ 24,948.82
335 ₹ 24,948.82 ₹ 1,106.20 ₹ 270.28 ₹ 835.92 ₹ 24,112.90
336 ₹ 24,112.90 ₹ 1,106.20 ₹ 261.22 ₹ 844.98 ₹ 23,267.92
337 ₹ 23,267.92 ₹ 1,106.20 ₹ 252.07 ₹ 854.13 ₹ 22,413.79
338 ₹ 22,413.79 ₹ 1,106.20 ₹ 242.82 ₹ 863.38 ₹ 21,550.41
339 ₹ 21,550.41 ₹ 1,106.20 ₹ 233.46 ₹ 872.74 ₹ 20,677.67
340 ₹ 20,677.67 ₹ 1,106.20 ₹ 224.01 ₹ 882.19 ₹ 19,795.48
341 ₹ 19,795.48 ₹ 1,106.20 ₹ 214.45 ₹ 891.75 ₹ 18,903.73
342 ₹ 18,903.73 ₹ 1,106.20 ₹ 204.79 ₹ 901.41 ₹ 18,002.32
343 ₹ 18,002.32 ₹ 1,106.20 ₹ 195.03 ₹ 911.17 ₹ 17,091.15
344 ₹ 17,091.15 ₹ 1,106.20 ₹ 185.15 ₹ 921.05 ₹ 16,170.10
345 ₹ 16,170.10 ₹ 1,106.20 ₹ 175.18 ₹ 931.02 ₹ 15,239.08
346 ₹ 15,239.08 ₹ 1,106.20 ₹ 165.09 ₹ 941.11 ₹ 14,297.97
347 ₹ 14,297.97 ₹ 1,106.20 ₹ 154.89 ₹ 951.30 ₹ 13,346.67
348 ₹ 13,346.67 ₹ 1,106.20 ₹ 144.59 ₹ 961.61 ₹ 12,385.06
349 ₹ 12,385.06 ₹ 1,106.20 ₹ 134.17 ₹ 972.03 ₹ 11,413.03
350 ₹ 11,413.03 ₹ 1,106.20 ₹ 123.64 ₹ 982.56 ₹ 10,430.47
351 ₹ 10,430.47 ₹ 1,106.20 ₹ 113.00 ₹ 993.20 ₹ 9,437.27
352 ₹ 9,437.27 ₹ 1,106.20 ₹ 102.24 ₹ 1,003.96 ₹ 8,433.30
353 ₹ 8,433.30 ₹ 1,106.20 ₹ 91.36 ₹ 1,014.84 ₹ 7,418.47
354 ₹ 7,418.47 ₹ 1,106.20 ₹ 80.37 ₹ 1,025.83 ₹ 6,392.63
355 ₹ 6,392.63 ₹ 1,106.20 ₹ 69.25 ₹ 1,036.95 ₹ 5,355.69
356 ₹ 5,355.69 ₹ 1,106.20 ₹ 58.02 ₹ 1,048.18 ₹ 4,307.51
357 ₹ 4,307.51 ₹ 1,106.20 ₹ 46.66 ₹ 1,059.53 ₹ 3,247.97
358 ₹ 3,247.97 ₹ 1,106.20 ₹ 35.19 ₹ 1,071.01 ₹ 2,176.96
359 ₹ 2,176.96 ₹ 1,106.20 ₹ 23.58 ₹ 1,082.62 ₹ 1,094.34
360 ₹ 1,094.34 ₹ 1,106.20 ₹ 11.86 ₹ 1,094.34 ₹ 0.00
₹ 100,000.00
INTEREST ONLY LOAN SCHEDULE
PER MONTH
PRINCIPAL ₹ 1,000,000.00
INTEREST RATE 4.00% 0.33%

INTEREST ONLY
DURATION (YEARS
) 1 12

MONTH INTEREST PRINCIPAL PAYMENT


1 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
2 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
3 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
4 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
5 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
6 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
7 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
8 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
9 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
10 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
11 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
12 ₹ 3,333.33 ₹ 0.00 ₹ 3,333.33
13 ₹ 1,000,000.00 ₹ 1,000,000.00
BOND VALUATION

COUPON RATE 6%
YIELD 8%
PAR VALUE ₹ 1,000.00
NO. OF YEARS 5

YEARS CF PV FACTOR PV CF
1 ₹ 60.00 0.92592592592593 ₹ 55.56
2 ₹ 60.00 0.85733882030178 ₹ 51.44
3 ₹ 60.00 0.79383224102017 ₹ 47.63
4 ₹ 60.00 0.73502985279645 ₹ 44.10
5 ₹ 60.00 0.68058319703375 ₹ 40.83
5 ₹ 1,000.00 0.68058319703375 ₹ 680.58
₹ 920.15

₹ -920.15
YIELD TO MATURITY
question :- suppose a bond maturing in 6 years with a coupon ra

COUPON RATE 8.00% 0


PAR VALUE ### 1
TIME TO MATURITY 6 YEARS 2
COUPON PER YEAR 1 3
BOND PRICE ₹ 955.14 4
5
COUPON PAYMENT ₹ 80.00 6
NO. OF TIME
PERIODS (NPER ) 6

YTM (RATE ) 9%
YTM (IRR) 9%
rs with a coupon rate of 8%(paid annually) is priced to sell for rs. 955.14. wha

-955.14
80
80
80
80
80
1080
or rs. 955.14. what is bond's yield to maturity (YTM)?
MACAULAY DURATION

YIELD TO MATURITY 6%
TIME TO MATURITY 8
COUPON RATE 5%
FACE VALUE 1000

PRESENT PERIOD*
PERIOD CASH FLOW VALUE WEIGHT WEIGHT
1 ₹ 50.00 47.17 5.03% 0.05
2 ₹ 50.00 44.50 4.74% 0.09
3 ₹ 50.00 41.98 4.48% 0.13
4 ₹ 50.00 39.60 4.22% 0.17
5 ₹ 50.00 37.36 3.98% 0.20
6 ₹ 50.00 35.25 3.76% 0.23
7 ₹ 50.00 33.25 3.55% 0.25
8 ₹ 1,050.00 658.78 70.24% 5.62
937.90 100.00% 6.74

MACAULAY
DURATION 6.74

Vous aimerez peut-être aussi