Gallery
About Financial Essentials
Share
Explore
Sample Uses

icon picker
Loan Amortization Schedule

Generate and analyze a loan amortization schedule from basic loan terms

Loan Terms

All calculations on this page are based on the loan terms entered below
Loan Amount
Annual Interest Rate
Term in Months
Payment
1
$200,000.00
5.00%
60
$3,774.25
There are no rows in this table
Info on Selected Loan Period
2
Selected Period
Payment
Interest
Principal
Ending Balance
1
60
$3,774.25
$15.66
$3,758.59
$0.00
There are no rows in this table
Loan Analysis
2
Start Period
End Period
Cum Interest Over Range
Cum Principal Over Range
1
13
24
$7,332.40
$37,958.56
There are no rows in this table
The total interest to be paid on the loan is
$26,454.80

Amortization Table

If the “Term in Months” of the above loan changes, the amortization table below will turn gray and may not be valid until the “Update Number of Terms in Amortization Table” button is pressed to generate a new table with the correct number of terms.
Update Number of Terms in Amortization Table
Period
Beginning Balance
Payment
Interest
Principal
Ending Balance
1
1
$200,000.00
$3,774.25
$833.33
$2,940.91
$197,059.09
2
2
$197,059.09
$3,774.25
$821.08
$2,953.17
$194,105.92
3
3
$194,105.92
$3,774.25
$808.77
$2,965.47
$191,140.45
4
4
$191,140.45
$3,774.25
$796.42
$2,977.83
$188,162.62
5
5
$188,162.62
$3,774.25
$784.01
$2,990.24
$185,172.38
6
6
$185,172.38
$3,774.25
$771.55
$3,002.70
$182,169.69
7
7
$182,169.69
$3,774.25
$759.04
$3,015.21
$179,154.48
8
8
$179,154.48
$3,774.25
$746.48
$3,027.77
$176,126.71
9
9
$176,126.71
$3,774.25
$733.86
$3,040.39
$173,086.33
10
10
$173,086.33
$3,774.25
$721.19
$3,053.05
$170,033.27
11
11
$170,033.27
$3,774.25
$708.47
$3,065.77
$166,967.50
12
12
$166,967.50
$3,774.25
$695.70
$3,078.55
$163,888.95
13
13
$163,888.95
$3,774.25
$682.87
$3,091.38
$160,797.57
14
14
$160,797.57
$3,774.25
$669.99
$3,104.26
$157,693.32
15
15
$157,693.32
$3,774.25
$657.06
$3,117.19
$154,576.13
16
16
$154,576.13
$3,774.25
$644.07
$3,130.18
$151,445.95
17
17
$151,445.95
$3,774.25
$631.02
$3,143.22
$148,302.72
18
18
$148,302.72
$3,774.25
$617.93
$3,156.32
$145,146.41
19
19
$145,146.41
$3,774.25
$604.78
$3,169.47
$141,976.93
20
20
$141,976.93
$3,774.25
$591.57
$3,182.68
$138,794.26
21
21
$138,794.26
$3,774.25
$578.31
$3,195.94
$135,598.32
22
22
$135,598.32
$3,774.25
$564.99
$3,209.25
$132,389.07
23
23
$132,389.07
$3,774.25
$551.62
$3,222.63
$129,166.44
24
24
$129,166.44
$3,774.25
$538.19
$3,236.05
$125,930.39
25
25
$125,930.39
$3,774.25
$524.71
$3,249.54
$122,680.85
26
26
$122,680.85
$3,774.25
$511.17
$3,263.08
$119,417.78
27
27
$119,417.78
$3,774.25
$497.57
$3,276.67
$116,141.10
28
28
$116,141.10
$3,774.25
$483.92
$3,290.33
$112,850.78
29
29
$112,850.78
$3,774.25
$470.21
$3,304.04
$109,546.74
30
30
$109,546.74
$3,774.25
$456.44
$3,317.80
$106,228.94
31
31
$106,228.94
$3,774.25
$442.62
$3,331.63
$102,897.31
32
32
$102,897.31
$3,774.25
$428.74
$3,345.51
$99,551.81
33
33
$99,551.81
$3,774.25
$414.80
$3,359.45
$96,192.36
34
34
$96,192.36
$3,774.25
$400.80
$3,373.45
$92,818.91
35
35
$92,818.91
$3,774.25
$386.75
$3,387.50
$89,431.41
36
36
$89,431.41
$3,774.25
$372.63
$3,401.62
$86,029.80
37
37
$86,029.80
$3,774.25
$358.46
$3,415.79
$82,614.01
38
38
$82,614.01
$3,774.25
$344.23
$3,430.02
$79,183.99
39
39
$79,183.99
$3,774.25
$329.93
$3,444.31
$75,739.67
40
40
$75,739.67
$3,774.25
$315.58
$3,458.66
$72,281.01
41
41
$72,281.01
$3,774.25
$301.17
$3,473.08
$68,807.93
42
42
$68,807.93
$3,774.25
$286.70
$3,487.55
$65,320.38
43
43
$65,320.38
$3,774.25
$272.17
$3,502.08
$61,818.31
44
44
$61,818.31
$3,774.25
$257.58
$3,516.67
$58,301.64
45
45
$58,301.64
$3,774.25
$242.92
$3,531.32
$54,770.31
46
46
$54,770.31
$3,774.25
$228.21
$3,546.04
$51,224.28
47
47
$51,224.28
$3,774.25
$213.43
$3,560.81
$47,663.46
48
48
$47,663.46
$3,774.25
$198.60
$3,575.65
$44,087.81
49
49
$44,087.81
$3,774.25
$183.70
$3,590.55
$40,497.27
50
50
$40,497.27
$3,774.25
$168.74
$3,605.51
$36,891.76
51
51
$36,891.76
$3,774.25
$153.72
$3,620.53
$33,271.23
52
52
$33,271.23
$3,774.25
$138.63
$3,635.62
$29,635.61
53
53
$29,635.61
$3,774.25
$123.48
$3,650.77
$25,984.85
54
54
$25,984.85
$3,774.25
$108.27
$3,665.98
$22,318.87
55
55
$22,318.87
$3,774.25
$93.00
$3,681.25
$18,637.62
56
56
$18,637.62
$3,774.25
$77.66
$3,696.59
$14,941.03
57
57
$14,941.03
$3,774.25
$62.25
$3,711.99
$11,229.04
58
58
$11,229.04
$3,774.25
$46.79
$3,727.46
$7,501.58
59
59
$7,501.58
$3,774.25
$31.26
$3,742.99
$3,758.59
60
60
$3,758.59
$3,774.25
$15.66
$3,758.59
$0.00
There are no rows in this table

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.