Dokdoin - Convenient & Safe Web Tools

Loan Amortization Calculator

Calculate monthly loan payments based on interest and repayment type, and generate an easily copyable Excel amortization schedule.

Enter Loan Conditions
Loan Principal (KRW)
Annual Interest Rate (%)
Grace Period (Months paying only interest)
Loan Term
Select Repayment Method
Loan Repayment Cost Summary
Total Loan Interest Paid (KRW)82,406,712
Loan Principal (KRW)100,000,000
Total Repayment Amount (Principal + Interest) (KRW)182,406,712
1st Installment Estimated Payment (KRW)506,685
Monthly Repayment Expenditure Structure Change
Principal Paid Proportion
Interest Paid Proportion
Detailed Monthly Loan Repayment Schedule
Installment
Principal Paid (KRW)
Interest Paid (KRW)
Monthly Repayment (Total) (KRW)
Loan Balance (KRW)
Mo. 1
131,685
375,000
506,685
99,868,315
Mo. 2
132,179
374,506
506,685
99,736,136
Mo. 3
132,675
374,011
506,685
99,603,461
Mo. 4
133,172
373,513
506,685
99,470,288
Mo. 5
133,672
373,014
506,685
99,336,617
Mo. 6
134,173
372,512
506,685
99,202,444
Mo. 7
134,676
372,009
506,685
99,067,768
Mo. 8
135,181
371,504
506,685
98,932,586
Mo. 9
135,688
370,997
506,685
98,796,898
Mo. 10
136,197
370,488
506,685
98,660,701
Mo. 11
136,708
369,978
506,685
98,523,994
Mo. 12
137,220
369,465
506,685
98,386,773
Mo. 13
137,735
368,950
506,685
98,249,038
Mo. 14
138,251
368,434
506,685
98,110,787
Mo. 15
138,770
367,915
506,685
97,972,017
Mo. 16
139,290
367,395
506,685
97,832,727
Mo. 17
139,813
366,873
506,685
97,692,914
Mo. 18
140,337
366,348
506,685
97,552,577
Mo. 19
140,863
365,822
506,685
97,411,714
Mo. 20
141,391
365,294
506,685
97,270,323
Mo. 21
141,922
364,764
506,685
97,128,401
Mo. 22
142,454
364,232
506,685
96,985,947
Mo. 23
142,988
363,697
506,685
96,842,959
Mo. 24
143,524
363,161
506,685
96,699,435
Mo. 25
144,062
362,623
506,685
96,555,373
Mo. 26
144,603
362,083
506,685
96,410,770
Mo. 27
145,145
361,540
506,685
96,265,625
Mo. 28
145,689
360,996
506,685
96,119,936
Mo. 29
146,236
360,450
506,685
95,973,700
Mo. 30
146,784
359,901
506,685
95,826,917
Mo. 31
147,334
359,351
506,685
95,679,582
Mo. 32
147,887
358,798
506,685
95,531,695
Mo. 33
148,441
358,244
506,685
95,383,254
Mo. 34
148,998
357,687
506,685
95,234,256
Mo. 35
149,557
357,128
506,685
95,084,699
Mo. 36
150,118
356,568
506,685
94,934,581
Mo. 37
150,681
356,005
506,685
94,783,901
Mo. 38
151,246
355,440
506,685
94,632,655
Mo. 39
151,813
354,872
506,685
94,480,842
Mo. 40
152,382
354,303
506,685
94,328,460
Mo. 41
152,954
353,732
506,685
94,175,506
Mo. 42
153,527
353,158
506,685
94,021,979
Mo. 43
154,103
352,582
506,685
93,867,876
Mo. 44
154,681
352,005
506,685
93,713,195
Mo. 45
155,261
351,424
506,685
93,557,935
Mo. 46
155,843
350,842
506,685
93,402,092
Mo. 47
156,427
350,258
506,685
93,245,664
Mo. 48
157,014
349,671
506,685
93,088,650
Mo. 49
157,603
349,082
506,685
92,931,047
Mo. 50
158,194
348,491
506,685
92,772,853
Mo. 51
158,787
347,898
506,685
92,614,066
Mo. 52
159,383
347,303
506,685
92,454,684
Mo. 53
159,980
346,705
506,685
92,294,703
Mo. 54
160,580
346,105
506,685
92,134,123
Mo. 55
161,182
345,503
506,685
91,972,941
Mo. 56
161,787
344,899
506,685
91,811,154
Mo. 57
162,393
344,292
506,685
91,648,761
Mo. 58
163,002
343,683
506,685
91,485,758
Mo. 59
163,614
343,072
506,685
91,322,144
Mo. 60
164,227
342,458
506,685
91,157,917
Mo. 61
164,843
341,842
506,685
90,993,074
Mo. 62
165,461
341,224
506,685
90,827,613
Mo. 63
166,082
340,604
506,685
90,661,531
Mo. 64
166,705
339,981
506,685
90,494,826
Mo. 65
167,330
339,356
506,685
90,327,497
Mo. 66
167,957
338,728
506,685
90,159,540
Mo. 67
168,587
338,098
506,685
89,990,952
Mo. 68
169,219
337,466
506,685
89,821,733
Mo. 69
169,854
336,831
506,685
89,651,879
Mo. 70
170,491
336,195
506,685
89,481,389
Mo. 71
171,130
335,555
506,685
89,310,259
Mo. 72
171,772
334,913
506,685
89,138,487
Mo. 73
172,416
334,269
506,685
88,966,071
Mo. 74
173,063
333,623
506,685
88,793,008
Mo. 75
173,712
332,974
506,685
88,619,297
Mo. 76
174,363
332,322
506,685
88,444,934
Mo. 77
175,017
331,669
506,685
88,269,917
Mo. 78
175,673
331,012
506,685
88,094,244
Mo. 79
176,332
330,353
506,685
87,917,912
Mo. 80
176,993
329,692
506,685
87,740,919
Mo. 81
177,657
329,028
506,685
87,563,262
Mo. 82
178,323
328,362
506,685
87,384,939
Mo. 83
178,992
327,694
506,685
87,205,947
Mo. 84
179,663
327,022
506,685
87,026,284
Mo. 85
180,337
326,349
506,685
86,845,947
Mo. 86
181,013
325,672
506,685
86,664,934
Mo. 87
181,692
324,994
506,685
86,483,242
Mo. 88
182,373
324,312
506,685
86,300,869
Mo. 89
183,057
323,628
506,685
86,117,812
Mo. 90
183,744
322,942
506,685
85,934,069
Mo. 91
184,433
322,253
506,685
85,749,636
Mo. 92
185,124
321,561
506,685
85,564,512
Mo. 93
185,818
320,867
506,685
85,378,694
Mo. 94
186,515
320,170
506,685
85,192,178
Mo. 95
187,215
319,471
506,685
85,004,964
Mo. 96
187,917
318,769
506,685
84,817,047
Mo. 97
188,621
318,064
506,685
84,628,426
Mo. 98
189,329
317,357
506,685
84,439,097
Mo. 99
190,039
316,647
506,685
84,249,058
Mo. 100
190,751
315,934
506,685
84,058,307
Mo. 101
191,467
315,219
506,685
83,866,840
Mo. 102
192,185
314,501
506,685
83,674,656
Mo. 103
192,905
313,780
506,685
83,481,750
Mo. 104
193,629
313,057
506,685
83,288,122
Mo. 105
194,355
312,330
506,685
83,093,767
Mo. 106
195,084
311,602
506,685
82,898,683
Mo. 107
195,815
310,870
506,685
82,702,868
Mo. 108
196,550
310,136
506,685
82,506,318
Mo. 109
197,287
309,399
506,685
82,309,032
Mo. 110
198,026
308,659
506,685
82,111,005
Mo. 111
198,769
307,916
506,685
81,912,236
Mo. 112
199,514
307,171
506,685
81,712,722
Mo. 113
200,263
306,423
506,685
81,512,459
Mo. 114
201,014
305,672
506,685
81,311,445
Mo. 115
201,767
304,918
506,685
81,109,678
Mo. 116
202,524
304,161
506,685
80,907,154
Mo. 117
203,283
303,402
506,685
80,703,871
Mo. 118
204,046
302,640
506,685
80,499,825
Mo. 119
204,811
301,874
506,685
80,295,014
Mo. 120
205,579
301,106
506,685
80,089,435
Mo. 121
206,350
300,335
506,685
79,883,085
Mo. 122
207,124
299,562
506,685
79,675,961
Mo. 123
207,900
298,785
506,685
79,468,061
Mo. 124
208,680
298,005
506,685
79,259,381
Mo. 125
209,463
297,223
506,685
79,049,918
Mo. 126
210,248
296,437
506,685
78,839,670
Mo. 127
211,037
295,649
506,685
78,628,633
Mo. 128
211,828
294,857
506,685
78,416,805
Mo. 129
212,622
294,063
506,685
78,204,183
Mo. 130
213,420
293,266
506,685
77,990,763
Mo. 131
214,220
292,465
506,685
77,776,544
Mo. 132
215,023
291,662
506,685
77,561,520
Mo. 133
215,830
290,856
506,685
77,345,691
Mo. 134
216,639
290,046
506,685
77,129,052
Mo. 135
217,451
289,234
506,685
76,911,600
Mo. 136
218,267
288,419
506,685
76,693,333
Mo. 137
219,085
287,600
506,685
76,474,248
Mo. 138
219,907
286,778
506,685
76,254,341
Mo. 139
220,732
285,954
506,685
76,033,610
Mo. 140
221,559
285,126
506,685
75,812,051
Mo. 141
222,390
284,295
506,685
75,589,660
Mo. 142
223,224
283,461
506,685
75,366,436
Mo. 143
224,061
282,624
506,685
75,142,375
Mo. 144
224,901
281,784
506,685
74,917,474
Mo. 145
225,745
280,941
506,685
74,691,729
Mo. 146
226,591
280,094
506,685
74,465,138
Mo. 147
227,441
279,244
506,685
74,237,697
Mo. 148
228,294
278,391
506,685
74,009,403
Mo. 149
229,150
277,535
506,685
73,780,253
Mo. 150
230,009
276,676
506,685
73,550,243
Mo. 151
230,872
275,813
506,685
73,319,371
Mo. 152
231,738
274,948
506,685
73,087,634
Mo. 153
232,607
274,079
506,685
72,855,027
Mo. 154
233,479
273,206
506,685
72,621,548
Mo. 155
234,355
272,331
506,685
72,387,193
Mo. 156
235,233
271,452
506,685
72,151,960
Mo. 157
236,115
270,570
506,685
71,915,845
Mo. 158
237,001
269,684
506,685
71,678,844
Mo. 159
237,890
268,796
506,685
71,440,954
Mo. 160
238,782
267,904
506,685
71,202,172
Mo. 161
239,677
267,008
506,685
70,962,495
Mo. 162
240,576
266,109
506,685
70,721,919
Mo. 163
241,478
265,207
506,685
70,480,441
Mo. 164
242,384
264,302
506,685
70,238,058
Mo. 165
243,293
263,393
506,685
69,994,765
Mo. 166
244,205
262,480
506,685
69,750,560
Mo. 167
245,121
261,565
506,685
69,505,439
Mo. 168
246,040
260,645
506,685
69,259,399
Mo. 169
246,963
259,723
506,685
69,012,437
Mo. 170
247,889
258,797
506,685
68,764,548
Mo. 171
248,818
257,867
506,685
68,515,730
Mo. 172
249,751
256,934
506,685
68,265,979
Mo. 173
250,688
255,997
506,685
68,015,291
Mo. 174
251,628
255,057
506,685
67,763,663
Mo. 175
252,572
254,114
506,685
67,511,091
Mo. 176
253,519
253,167
506,685
67,257,572
Mo. 177
254,469
252,216
506,685
67,003,103
Mo. 178
255,424
251,262
506,685
66,747,679
Mo. 179
256,382
250,304
506,685
66,491,298
Mo. 180
257,343
249,342
506,685
66,233,955
Mo. 181
258,308
248,377
506,685
65,975,647
Mo. 182
259,277
247,409
506,685
65,716,370
Mo. 183
260,249
246,436
506,685
65,456,121
Mo. 184
261,225
245,460
506,685
65,194,897
Mo. 185
262,204
244,481
506,685
64,932,692
Mo. 186
263,188
243,498
506,685
64,669,504
Mo. 187
264,175
242,511
506,685
64,405,330
Mo. 188
265,165
241,520
506,685
64,140,164
Mo. 189
266,160
240,526
506,685
63,874,005
Mo. 190
267,158
239,528
506,685
63,606,847
Mo. 191
268,160
238,526
506,685
63,338,687
Mo. 192
269,165
237,520
506,685
63,069,522
Mo. 193
270,175
236,511
506,685
62,799,347
Mo. 194
271,188
235,498
506,685
62,528,160
Mo. 195
272,205
234,481
506,685
62,255,955
Mo. 196
273,225
233,460
506,685
61,982,729
Mo. 197
274,250
232,435
506,685
61,708,479
Mo. 198
275,279
231,407
506,685
61,433,201
Mo. 199
276,311
230,375
506,685
61,156,890
Mo. 200
277,347
229,338
506,685
60,879,543
Mo. 201
278,387
228,298
506,685
60,601,156
Mo. 202
279,431
227,254
506,685
60,321,725
Mo. 203
280,479
226,206
506,685
60,041,246
Mo. 204
281,531
225,155
506,685
59,759,716
Mo. 205
282,586
224,099
506,685
59,477,129
Mo. 206
283,646
223,039
506,685
59,193,483
Mo. 207
284,710
221,976
506,685
58,908,773
Mo. 208
285,777
220,908
506,685
58,622,996
Mo. 209
286,849
219,836
506,685
58,336,147
Mo. 210
287,925
218,761
506,685
58,048,222
Mo. 211
289,004
217,681
506,685
57,759,218
Mo. 212
290,088
216,597
506,685
57,469,129
Mo. 213
291,176
215,509
506,685
57,177,953
Mo. 214
292,268
214,417
506,685
56,885,685
Mo. 215
293,364
213,321
506,685
56,592,321
Mo. 216
294,464
212,221
506,685
56,297,857
Mo. 217
295,568
211,117
506,685
56,002,289
Mo. 218
296,677
210,009
506,685
55,705,612
Mo. 219
297,789
208,896
506,685
55,407,823
Mo. 220
298,906
207,779
506,685
55,108,917
Mo. 221
300,027
206,658
506,685
54,808,890
Mo. 222
301,152
205,533
506,685
54,507,738
Mo. 223
302,281
204,404
506,685
54,205,457
Mo. 224
303,415
203,270
506,685
53,902,042
Mo. 225
304,553
202,133
506,685
53,597,489
Mo. 226
305,695
200,991
506,685
53,291,795
Mo. 227
306,841
199,844
506,685
52,984,954
Mo. 228
307,992
198,694
506,685
52,676,962
Mo. 229
309,147
197,539
506,685
52,367,815
Mo. 230
310,306
196,379
506,685
52,057,509
Mo. 231
311,470
195,216
506,685
51,746,039
Mo. 232
312,638
194,048
506,685
51,433,402
Mo. 233
313,810
192,875
506,685
51,119,592
Mo. 234
314,987
191,698
506,685
50,804,605
Mo. 235
316,168
190,517
506,685
50,488,437
Mo. 236
317,354
189,332
506,685
50,171,083
Mo. 237
318,544
188,142
506,685
49,852,539
Mo. 238
319,738
186,947
506,685
49,532,801
Mo. 239
320,937
185,748
506,685
49,211,864
Mo. 240
322,141
184,544
506,685
48,889,723
Mo. 241
323,349
183,336
506,685
48,566,374
Mo. 242
324,561
182,124
506,685
48,241,813
Mo. 243
325,779
180,907
506,685
47,916,034
Mo. 244
327,000
179,685
506,685
47,589,034
Mo. 245
328,226
178,459
506,685
47,260,808
Mo. 246
329,457
177,228
506,685
46,931,350
Mo. 247
330,693
175,993
506,685
46,600,658
Mo. 248
331,933
174,752
506,685
46,268,725
Mo. 249
333,178
173,508
506,685
45,935,547
Mo. 250
334,427
172,258
506,685
45,601,120
Mo. 251
335,681
171,004
506,685
45,265,439
Mo. 252
336,940
169,745
506,685
44,928,499
Mo. 253
338,203
168,482
506,685
44,590,296
Mo. 254
339,472
167,214
506,685
44,250,824
Mo. 255
340,745
165,941
506,685
43,910,079
Mo. 256
342,023
164,663
506,685
43,568,057
Mo. 257
343,305
163,380
506,685
43,224,752
Mo. 258
344,592
162,093
506,685
42,880,159
Mo. 259
345,885
160,801
506,685
42,534,274
Mo. 260
347,182
159,504
506,685
42,187,093
Mo. 261
348,484
158,202
506,685
41,838,609
Mo. 262
349,791
156,895
506,685
41,488,818
Mo. 263
351,102
155,583
506,685
41,137,716
Mo. 264
352,419
154,266
506,685
40,785,297
Mo. 265
353,740
152,945
506,685
40,431,557
Mo. 266
355,067
151,618
506,685
40,076,490
Mo. 267
356,398
150,287
506,685
39,720,091
Mo. 268
357,735
148,950
506,685
39,362,356
Mo. 269
359,076
147,609
506,685
39,003,280
Mo. 270
360,423
146,262
506,685
38,642,857
Mo. 271
361,775
144,911
506,685
38,281,082
Mo. 272
363,131
143,554
506,685
37,917,951
Mo. 273
364,493
142,192
506,685
37,553,458
Mo. 274
365,860
140,825
506,685
37,187,598
Mo. 275
367,232
139,453
506,685
36,820,367
Mo. 276
368,609
138,076
506,685
36,451,758
Mo. 277
369,991
136,694
506,685
36,081,766
Mo. 278
371,379
135,307
506,685
35,710,388
Mo. 279
372,771
133,914
506,685
35,337,616
Mo. 280
374,169
132,516
506,685
34,963,447
Mo. 281
375,572
131,113
506,685
34,587,875
Mo. 282
376,981
129,705
506,685
34,210,894
Mo. 283
378,394
128,291
506,685
33,832,499
Mo. 284
379,813
126,872
506,685
33,452,686
Mo. 285
381,238
125,448
506,685
33,071,448
Mo. 286
382,667
124,018
506,685
32,688,781
Mo. 287
384,102
122,583
506,685
32,304,679
Mo. 288
385,543
121,143
506,685
31,919,136
Mo. 289
386,989
119,697
506,685
31,532,147
Mo. 290
388,440
118,246
506,685
31,143,707
Mo. 291
389,896
116,789
506,685
30,753,811
Mo. 292
391,359
115,327
506,685
30,362,453
Mo. 293
392,826
113,859
506,685
29,969,626
Mo. 294
394,299
112,386
506,685
29,575,327
Mo. 295
395,778
110,907
506,685
29,179,549
Mo. 296
397,262
109,423
506,685
28,782,287
Mo. 297
398,752
107,934
506,685
28,383,536
Mo. 298
400,247
106,438
506,685
27,983,289
Mo. 299
401,748
104,937
506,685
27,581,541
Mo. 300
403,255
103,431
506,685
27,178,286
Mo. 301
404,767
101,919
506,685
26,773,519
Mo. 302
406,285
100,401
506,685
26,367,235
Mo. 303
407,808
98,877
506,685
25,959,427
Mo. 304
409,337
97,348
506,685
25,550,089
Mo. 305
410,872
95,813
506,685
25,139,217
Mo. 306
412,413
94,272
506,685
24,726,803
Mo. 307
413,960
92,726
506,685
24,312,844
Mo. 308
415,512
91,173
506,685
23,897,331
Mo. 309
417,070
89,615
506,685
23,480,261
Mo. 310
418,634
88,051
506,685
23,061,627
Mo. 311
420,204
86,481
506,685
22,641,423
Mo. 312
421,780
84,905
506,685
22,219,643
Mo. 313
423,362
83,324
506,685
21,796,281
Mo. 314
424,949
81,736
506,685
21,371,332
Mo. 315
426,543
80,142
506,685
20,944,789
Mo. 316
428,142
78,543
506,685
20,516,646
Mo. 317
429,748
76,937
506,685
20,086,899
Mo. 318
431,359
75,326
506,685
19,655,539
Mo. 319
432,977
73,708
506,685
19,222,562
Mo. 320
434,601
72,085
506,685
18,787,961
Mo. 321
436,230
70,455
506,685
18,351,731
Mo. 322
437,866
68,819
506,685
17,913,865
Mo. 323
439,508
67,177
506,685
17,474,356
Mo. 324
441,156
65,529
506,685
17,033,200
Mo. 325
442,811
63,874
506,685
16,590,389
Mo. 326
444,471
62,214
506,685
16,145,918
Mo. 327
446,138
60,547
506,685
15,699,780
Mo. 328
447,811
58,874
506,685
15,251,968
Mo. 329
449,490
57,195
506,685
14,802,478
Mo. 330
451,176
55,509
506,685
14,351,302
Mo. 331
452,868
53,817
506,685
13,898,434
Mo. 332
454,566
52,119
506,685
13,443,868
Mo. 333
456,271
50,415
506,685
12,987,597
Mo. 334
457,982
48,703
506,685
12,529,615
Mo. 335
459,699
46,986
506,685
12,069,916
Mo. 336
461,423
45,262
506,685
11,608,493
Mo. 337
463,153
43,532
506,685
11,145,339
Mo. 338
464,890
41,795
506,685
10,680,449
Mo. 339
466,634
40,052
506,685
10,213,816
Mo. 340
468,384
38,302
506,685
9,745,432
Mo. 341
470,140
36,545
506,685
9,275,292
Mo. 342
471,903
34,782
506,685
8,803,389
Mo. 343
473,673
33,013
506,685
8,329,717
Mo. 344
475,449
31,236
506,685
7,854,268
Mo. 345
477,232
29,454
506,685
7,377,036
Mo. 346
479,021
27,664
506,685
6,898,014
Mo. 347
480,818
25,868
506,685
6,417,197
Mo. 348
482,621
24,064
506,685
5,934,576
Mo. 349
484,431
22,255
506,685
5,450,145
Mo. 350
486,247
20,438
506,685
4,963,898
Mo. 351
488,071
18,615
506,685
4,475,827
Mo. 352
489,901
16,784
506,685
3,985,926
Mo. 353
491,738
14,947
506,685
3,494,188
Mo. 354
493,582
13,103
506,685
3,000,606
Mo. 355
495,433
11,252
506,685
2,505,173
Mo. 356
497,291
9,394
506,685
2,007,882
Mo. 357
499,156
7,530
506,685
1,508,726
Mo. 358
501,028
5,658
506,685
1,007,699
Mo. 359
502,906
3,779
506,685
504,792
Mo. 360
504,792
1,893
506,685
0

Loan Amortization Method Comparison Guide

The Loan Interest Calculator is a financial simulator that helps you plan the most advantageous loan by inputting the loan amount, interest rate, term, and amortization method to calculate the monthly principal and interest to be repaid, and providing a detailed repayment schedule.

Key Features

  • Perfect Support for 3 Major Loan Repayment Methods: It accurately applies and calculates the formulas for equal payment of principal and interest, equal payment of principal, and lump-sum repayment at maturity, which are mainly used in the financial sector.
  • Interest Grace Period Reflection: You can freely set a deferment period where you pay only interest without principal repayment after the initial loan execution to understand the change in monthly cash flow.
  • Repayment Structure Visualization and Copying: It shows the relative proportion of principal and interest paid each month as the repayment progresses through a linear graph, and provides compatible data that can be immediately pasted into Excel when the copy button is clicked.

How to Use

  1. What is the difference between equal principal and interest and equal principal?: With equal principal and interest repayment, the total amount (principal + interest) paid every month until maturity is the same, making it easy to plan expenses. On the other hand, equal principal repayment pays the same amount of principal every month, so the interest burden and total payment amount gradually decrease over time. The total interest is **lowest with equal principal**.
  2. When is bullet repayment at maturity advantageous?: Bullet repayment at maturity is a method where you only pay the interest incurred each month during the loan period, and repay 100% of the principal in a lump sum on the maturity date. It is advantageous when you want to minimize fixed monthly expenses during the loan period, but **unless early repayment occurs, the total interest paid is the largest among the three methods**.
  3. Does the interest increase if I set a grace period?: Yes, it increases. The longer the grace period (period paying only interest), the more the timing of repaying the loan principal is delayed, so even under the same interest rate conditions, the total interest amount paid to the bank until final maturity swells significantly.

How about these tools? (Recommended)