Sample Uses
Loan Amortization Schedule
Loan Amortization Schedule
Generate and analyze a loan amortization schedule from basic loan terms
Loan Terms
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
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
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
$26,454.80
Amortization Table
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
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.