Bond Amortization Schedule

Build a level-payment amortization schedule for a fixed-rate bond/loan.

Principal Annual rate (decimal, e.g. 0.05 for 5%) Years Payments per year

Schedule

Payment: 536.82

#	Payment	Interest	Principal	Balance
1	536.82	416.67	120.15	99,879.85
2	536.82	416.17	120.66	99,759.19
3	536.82	415.66	121.16	99,638.03
4	536.82	415.16	121.66	99,516.37
5	536.82	414.65	122.17	99,394.20
6	536.82	414.14	122.68	99,271.52
7	536.82	413.63	123.19	99,148.33
8	536.82	413.12	123.70	99,024.62
9	536.82	412.60	124.22	98,900.41
10	536.82	412.09	124.74	98,775.67
11	536.82	411.57	125.26	98,650.41
12	536.82	411.04	125.78	98,524.63
13	536.82	410.52	126.30	98,398.33
14	536.82	409.99	126.83	98,271.50
15	536.82	409.46	127.36	98,144.15
16	536.82	408.93	127.89	98,016.26
17	536.82	408.40	128.42	97,887.84
18	536.82	407.87	128.96	97,758.88
19	536.82	407.33	129.49	97,629.39
20	536.82	406.79	130.03	97,499.36
21	536.82	406.25	130.57	97,368.78
22	536.82	405.70	131.12	97,237.66
23	536.82	405.16	131.66	97,106.00
24	536.82	404.61	132.21	96,973.79
25	536.82	404.06	132.76	96,841.02
26	536.82	403.50	133.32	96,707.71
27	536.82	402.95	133.87	96,573.83
28	536.82	402.39	134.43	96,439.40
29	536.82	401.83	134.99	96,304.41
30	536.82	401.27	135.55	96,168.86
31	536.82	400.70	136.12	96,032.74
32	536.82	400.14	136.69	95,896.05
33	536.82	399.57	137.25	95,758.80
34	536.82	398.99	137.83	95,620.97
35	536.82	398.42	138.40	95,482.57
36	536.82	397.84	138.98	95,343.59
37	536.82	397.26	139.56	95,204.04
38	536.82	396.68	140.14	95,063.90
39	536.82	396.10	140.72	94,923.18
40	536.82	395.51	141.31	94,781.87
41	536.82	394.92	141.90	94,639.97
42	536.82	394.33	142.49	94,497.48
43	536.82	393.74	143.08	94,354.40
44	536.82	393.14	143.68	94,210.72
45	536.82	392.54	144.28	94,066.45
46	536.82	391.94	144.88	93,921.57
47	536.82	391.34	145.48	93,776.09
48	536.82	390.73	146.09	93,630.00
49	536.82	390.12	146.70	93,483.30
50	536.82	389.51	147.31	93,335.99
51	536.82	388.90	147.92	93,188.07
52	536.82	388.28	148.54	93,039.53
53	536.82	387.66	149.16	92,890.38
54	536.82	387.04	149.78	92,740.60
55	536.82	386.42	150.40	92,590.20
56	536.82	385.79	151.03	92,439.17
57	536.82	385.16	151.66	92,287.51
58	536.82	384.53	152.29	92,135.22
59	536.82	383.90	152.92	91,982.29
60	536.82	383.26	153.56	91,828.73
61	536.82	382.62	154.20	91,674.53
62	536.82	381.98	154.84	91,519.69
63	536.82	381.33	155.49	91,364.20
64	536.82	380.68	156.14	91,208.06
65	536.82	380.03	156.79	91,051.27
66	536.82	379.38	157.44	90,893.83
67	536.82	378.72	158.10	90,735.73
68	536.82	378.07	158.76	90,576.98
69	536.82	377.40	159.42	90,417.56
70	536.82	376.74	160.08	90,257.48
71	536.82	376.07	160.75	90,096.73
72	536.82	375.40	161.42	89,935.31
73	536.82	374.73	162.09	89,773.22
74	536.82	374.06	162.77	89,610.45
75	536.82	373.38	163.44	89,447.01
76	536.82	372.70	164.13	89,282.88
77	536.82	372.01	164.81	89,118.07
78	536.82	371.33	165.50	88,952.58
79	536.82	370.64	166.19	88,786.39
80	536.82	369.94	166.88	88,619.51
81	536.82	369.25	167.57	88,451.94
82	536.82	368.55	168.27	88,283.67
83	536.82	367.85	168.97	88,114.69
84	536.82	367.14	169.68	87,945.02
85	536.82	366.44	170.38	87,774.63
86	536.82	365.73	171.09	87,603.54
87	536.82	365.01	171.81	87,431.73
88	536.82	364.30	172.52	87,259.21
89	536.82	363.58	173.24	87,085.97
90	536.82	362.86	173.96	86,912.00
91	536.82	362.13	174.69	86,737.31
92	536.82	361.41	175.42	86,561.90
93	536.82	360.67	176.15	86,385.75
94	536.82	359.94	176.88	86,208.87
95	536.82	359.20	177.62	86,031.25
96	536.82	358.46	178.36	85,852.89
97	536.82	357.72	179.10	85,673.79
98	536.82	356.97	179.85	85,493.95
99	536.82	356.22	180.60	85,313.35
100	536.82	355.47	181.35	85,132.00
101	536.82	354.72	182.10	84,949.89
102	536.82	353.96	182.86	84,767.03
103	536.82	353.20	183.63	84,583.40
104	536.82	352.43	184.39	84,399.01
105	536.82	351.66	185.16	84,213.85
106	536.82	350.89	185.93	84,027.92
107	536.82	350.12	186.71	83,841.22
108	536.82	349.34	187.48	83,653.74
109	536.82	348.56	188.26	83,465.47
110	536.82	347.77	189.05	83,276.42
111	536.82	346.99	189.84	83,086.59
112	536.82	346.19	190.63	82,895.96
113	536.82	345.40	191.42	82,704.54
114	536.82	344.60	192.22	82,512.32
115	536.82	343.80	193.02	82,319.30
116	536.82	343.00	193.82	82,125.47
117	536.82	342.19	194.63	81,930.84
118	536.82	341.38	195.44	81,735.40
119	536.82	340.56	196.26	81,539.14
120	536.82	339.75	197.08	81,342.06

(showing first 120 of 360 periods)