Mortgage Loan Amortization Schedule

	A	C	E	G	H	I	J	K	M	N	O
1				Click "File" then "Make a copy"
2
3		Annual
4		Semi-Annual		Loan Information					Summary
5		Quarterly		Loan Amount				300,000	Rate (per period)		0.167%
6		Bi-Monthly		Annual Interest Rate				2.00%	Scheduled # of Payments		300
7		Monthly		Term of Loan in Years				25	Actual # of Payments		300
8		Semi-Monthly		First Payment Date				1/1/2020	Total Payments		381,469.14
9		Bi-Weekly		Payment Frequency				Monthly	Total Interest		81,469.14
10				Compound Period				Monthly	Est. Interest Savings		-
11				Payment Type				End of Period			.
12	Periods Per Year		12	Rounding				On			.
13	Compound Period		12
14	Payment Type		0								[42]
15	Months Per Period		1	Monthly Payment				1,271.56
16	Rounding Option		TRUE
17				Yearly Summary
18					Year		Payments	Additional Payments	Interest Paid	Principal Paid	Year-End Balance
19											300,000.00
20					2020		15,259	0	5,915	9,344	290,656
21					2021		15,259	0	5,726	9,533	281,123
22					2022		15,259	0	5,534	9,725	271,398
23					2023		15,259	0	5,337	9,921	261,477
24					2024		15,259	0	5,137	10,122	251,355
25					2025		15,259	0	4,933	10,326	241,029
26					2026		15,259	0	4,724	10,534	230,495
27					2027		15,259	0	4,512	10,747	219,748
28					2028		15,259	0	4,295	10,964	208,784
29					2029		15,259	0	4,074	11,185	197,599
30					2030		15,259	0	3,848	11,411	186,188
31					2031		15,259	0	3,617	11,641	174,547
32					2032		15,259	0	3,382	11,876	162,670
33					2033		15,259	0	3,143	12,116	150,554
34					2034		15,259	0	2,898	12,361	138,194
35					2035		15,259	0	2,649	12,610	125,584
36					2036		15,259	0	2,394	12,865	112,719
37					2037		15,259	0	2,135	13,124	99,595
38					2038		15,259	0	1,870	13,389	86,206
39					2039		15,259	0	1,599	13,659	72,547
40					2040		15,259	0	1,324	13,935	58,611
41					2041		15,259	0	1,042	14,216	44,395
42					2042		15,259	0	755	14,503	29,892
43					2043		15,259	0	463	14,796	15,096
44					2044		15,260	0	164	15,096	0
45					2045		0	0	0	0	0
46					2046		0	0	0	0	0
47					2047		0	0	0	0	0
48					2048		0	0	0	0	0
49					2049		0	0	0	0	0
50					2050		0	0	0	0	0
51
52				Amortization Schedule
53				No.	Due Date	Year	Payment Due	Additional Payment (add)	Interest	Principal	Balance
54											300,000.00
55				1	1/1/20	20	1,272		500	772	299,228
56				2	2/1/20	20	1,272		499	773	298,456
57				3	3/1/20	20	1,272		497	774	297,681
58				4	4/1/20	20	1,272		496	775	296,906
59				5	5/1/20	20	1,272		495	777	296,129
60				6	6/1/20	20	1,272		494	778	295,351
61				7	7/1/20	20	1,272		492	779	294,572
62				8	8/1/20	20	1,272		491	781	293,791
63				9	9/1/20	20	1,272		490	782	293,009
64				10	10/1/20	20	1,272		488	783	292,226
65				11	11/1/20	20	1,272		487	785	291,442
66				12	12/1/20	20	1,272		486	786	290,656
67				13	1/1/21	21	1,272		484	787	289,869
68				14	2/1/21	21	1,272		483	788	289,080
69				15	3/1/21	21	1,272		482	790	288,291
70				16	4/1/21	21	1,272		480	791	287,500
71				17	5/1/21	21	1,272		479	792	286,707
72				18	6/1/21	21	1,272		478	794	285,913
73				19	7/1/21	21	1,272		477	795	285,118
74				20	8/1/21	21	1,272		475	796	284,322
75				21	9/1/21	21	1,272		474	798	283,524
76				22	10/1/21	21	1,272		473	799	282,725
77				23	11/1/21	21	1,272		471	800	281,925
78				24	12/1/21	21	1,272		470	802	281,123
79				25	1/1/22	22	1,272		469	803	280,320
80				26	2/1/22	22	1,272		467	804	279,516
81				27	3/1/22	22	1,272		466	806	278,710
82				28	4/1/22	22	1,272		465	807	277,903
83				29	5/1/22	22	1,272		463	808	277,095
84				30	6/1/22	22	1,272		462	810	276,285
85				31	7/1/22	22	1,272		460	811	275,474
86				32	8/1/22	22	1,272		459	812	274,661
87				33	9/1/22	22	1,272		458	814	273,848
88				34	10/1/22	22	1,272		456	815	273,033
89				35	11/1/22	22	1,272		455	817	272,216
90				36	12/1/22	22	1,272		454	818	271,398
91				37	1/1/23	23	1,272		452	819	270,579
92				38	2/1/23	23	1,272		451	821	269,758
93				39	3/1/23	23	1,272		450	822	268,936
94				40	4/1/23	23	1,272		448	823	268,113
95				41	5/1/23	23	1,272		447	825	267,288
96				42	6/1/23	23	1,272		445	826	266,462
97				43	7/1/23	23	1,272		444	827	265,635
98				44	8/1/23	23	1,272		443	829	264,806
99				45	9/1/23	23	1,272		441	830	263,976
100				46	10/1/23	23	1,272		440	832	263,144