Open the source doc to make a copy and edit
Loan Information Summary Frequency
Loan Amount 300,000 Rate (per period) 0.250% Annual
Annual Interest Rate 3.00% Scheduled # of Payments 300 Semi-Annual
Term of Loan in Years 25 Actual # of Payments 300 Quarterly
First Payment Date 1/1/2020 Total Payments 426,790.75 Bi-Monthly
Payment Frequency Monthly Total Interest 126,790.75 Monthly
Compound Period Monthly Est. Interest Savings - Semi-Monthly
Payment Type End of Period . Bi-Weekly
Rounding On .
[42]
Monthly Payment 1,422.63
Yearly Summary
Year Payments Additional Payments Interest Paid Principal Paid Year-End Balance
300,000.00
2020 17,072 0 8,888 8,183 291,817 Periods Per Year 12
2021 17,072 0 8,639 8,432 283,384 Compound Period 12
2022 17,072 0 8,383 8,689 274,695 Payment Type 0
2023 17,072 0 8,118 8,953 265,742 Months Per Period 1
2024 17,072 0 7,846 9,225 256,517 Rounding Option TRUE
2025 17,072 0 7,566 9,506 247,011
2026 17,072 0 7,276 9,795 237,215
2027 17,072 0 6,978 10,093 227,122
2028 17,072 0 6,671 10,400 216,722
2029 17,072 0 6,355 10,716 206,006
2030 17,072 0 6,029 11,042 194,963
2031 17,072 0 5,693 11,378 183,585
2032 17,072 0 5,347 11,724 171,861
2033 17,072 0 4,991 12,081 159,780
2034 17,072 0 4,623 12,448 147,331
2035 17,072 0 4,245 12,827 134,504
2036 17,072 0 3,854 13,217 121,287
2037 17,072 0 3,452 13,619 107,668
2038 17,072 0 3,038 14,033 93,634
2039 17,072 0 2,611 14,460 79,174
2040 17,072 0 2,171 14,900 64,274
2041 17,072 0 1,718 15,353 48,921
2042 17,072 0 1,251 15,820 33,101
2043 17,072 0 770 16,301 16,799
2044 17,073 0 274 16,799 0
2045 0 0 0 0 0
2046 0 0 0 0 0
2047 0 0 0 0 0
2048 0 0 0 0 0
2049 0 0 0 0 0
2050 0 0 0 0 0
Amortization Schedule
No. Due Date Year Payment Due Additional Payment (add) Interest Principal Balance
300,000.00
1 1/1/20 20 1,423 750 673 299,327
2 2/1/20 20 1,423 748 674 298,653
3 3/1/20 20 1,423 747 676 297,977
4 4/1/20 20 1,423 745 678 297,299
5 5/1/20 20 1,423 743 679 296,620
6 6/1/20 20 1,423 742 681 295,939
7 7/1/20 20 1,423 740 683 295,256
8 8/1/20 20 1,423 738 684 294,572
9 9/1/20 20 1,423 736 686 293,885
10 10/1/20 20 1,423 735 688 293,198
11 11/1/20 20 1,423 733 690 292,508
12 12/1/20 20 1,423 731 691 291,817
13 1/1/21 21 1,423 730 693 291,123
14 2/1/21 21 1,423 728 695 290,429
15 3/1/21 21 1,423 726 697 289,732
16 4/1/21 21 1,423 724 698 289,034
17 5/1/21 21 1,423 723 700 288,334
18 6/1/21 21 1,423 721 702 287,632
19 7/1/21 21 1,423 719 704 286,928
20 8/1/21 21 1,423 717 705 286,223
21 9/1/21 21 1,423 716 707 285,516
22 10/1/21 21 1,423 714 709 284,807
23 11/1/21 21 1,423 712 711 284,097
24 12/1/21 21 1,423 710 712 283,384
25 1/1/22 22 1,423 708 714 282,670
26 2/1/22 22 1,423 707 716 281,954
27 3/1/22 22 1,423 705 718 281,236
28 4/1/22 22 1,423 703 720 280,517
29 5/1/22 22 1,423 701 721 279,795
30 6/1/22 22 1,423 699 723 279,072
31 7/1/22 22 1,423 698 725 278,347
32 8/1/22 22 1,423 696 727 277,621
33 9/1/22 22 1,423 694 729 276,892
34 10/1/22 22 1,423 692 730 276,162
35 11/1/22 22 1,423 690 732 275,429
36 12/1/22 22 1,423 689 734 274,695
37 1/1/23 23 1,423 687 736 273,959
38 2/1/23 23 1,423 685 738 273,222
39 3/1/23 23 1,423 683 740 272,482
40 4/1/23 23 1,423 681 741 271,741
41 5/1/23 23 1,423 679 743 270,997
42 6/1/23 23 1,423 677 745 270,252
43 7/1/23 23 1,423 676 747 269,505
44 8/1/23 23 1,423 674 749 268,756
45 9/1/23 23 1,423 672 751 268,006
46 10/1/23 23 1,423 670 753 267,253
47 11/1/23 23 1,423 668 755 266,498
48 12/1/23 23 1,423 666 756 265,742
49 1/1/24 24 1,423 664 758 264,984
50 2/1/24 24 1,423 662 760 264,224
51 3/1/24 24 1,423 661 762 263,462
52 4/1/24 24 1,423 659 764 262,698
53 5/1/24 24 1,423 657 766 261,932
54 6/1/24 24 1,423 655 768 261,164
55 7/1/24 24 1,423 653 770 260,394
56 8/1/24 24 1,423 651 772 259,623
57 9/1/24 24 1,423 649 774 258,849
58 10/1/24 24 1,423 647 776 258,073
59 11/1/24 24 1,423 645 777 257,296
60 12/1/24 24 1,423 643 779 256,517
61 1/1/25 25 1,423 641 781 255,735
62 2/1/25 25 1,423 639 783 254,952
63 3/1/25 25 1,423 637 785 254,167
64 4/1/25 25 1,423 635 787 253,380
65 5/1/25 25 1,423 633 789 252,590
66 6/1/25 25 1,423 631 791 251,799
67 7/1/25 25 1,423 630 793 251,006
68 8/1/25 25 1,423 628 795 250,211
69 9/1/25 25 1,423 626 797 249,414
70 10/1/25 25 1,423 624 799 248,615
71 11/1/25 25 1,423 622 801 247,814
72 12/1/25 25 1,423 620 803 247,011
73 1/1/26 26 1,423 618 805 246,205
74 2/1/26 26 1,423 616 807 245,398
75 3/1/26 26 1,423 614 809 244,589
76 4/1/26 26 1,423 611 811 243,778
77 5/1/26 26 1,423 609 813 242,965
78 6/1/26 26 1,423 607 815 242,150
79 7/1/26 26 1,423 605 817 241,332
80 8/1/26 26 1,423 603 819 240,513
81 9/1/26 26 1,423 601 821 239,692
82 10/1/26 26 1,423 599 823 238,868
83 11/1/26 26 1,423 597 825 238,043
84 12/1/26 26 1,423 595 828 237,215
85 1/1/27 27 1,423 593 830 236,386
86 2/1/27 27 1,423 591 832 235,554
87 3/1/27 27 1,423 589 834 234,720
88 4/1/27 27 1,423 587 836 233,885
89 5/1/27 27 1,423 585 838 233,047
90 6/1/27 27 1,423 583 840 232,207
91 7/1/27 27 1,423 581 842 231,365
92 8/1/27 27 1,423 578 844 230,520
93 9/1/27 27 1,423 576 846 229,674
94 10/1/27 27 1,423 574 848 228,826
95 11/1/27 27 1,423 572 851 227,975
96 12/1/27 27 1,423 570 853 227,122
97 1/1/28 28 1,423 568 855 226,267
98 2/1/28 28 1,423 566 857 225,410
99 3/1/28 28 1,423 564 859 224,551
100 4/1/28 28 1,423 561 861 223,690
101 5/1/28 28 1,423 559 863 222,827
102 6/1/28 28 1,423 557 866 221,961
103 7/1/28 28 1,423 555 868 221,093
104 8/1/28 28 1,423 553 870 220,224
105 9/1/28 28 1,423 551 872 219,351
106 10/1/28 28 1,423 548 874 218,477
107 11/1/28 28 1,423 546 876 217,601
108 12/1/28 28 1,423 544 879 216,722
109 1/1/29 29 1,423 542 881 215,841
110 2/1/29 29 1,423 540 883 214,958
111 3/1/29 29 1,423 537 885 214,073
112 4/1/29 29 1,423 535 887 213,186
113 5/1/29 29 1,423 533 890 212,296
114 6/1/29 29 1,423 531 892 211,404
115 7/1/29 29 1,423 529 894 210,510
116 8/1/29 29 1,423 526 896 209,614
117 9/1/29 29 1,423 524 899 208,715
118 10/1/29 29 1,423 522 901 207,814
119 11/1/29 29 1,423 520 903 206,911
120 12/1/29 29 1,423 517 905 206,006
121 1/1/30 30 1,423 515 908 205,098
122 2/1/30 30 1,423 513 910 204,188
123 3/1/30 30 1,423 510 912 203,276
124 4/1/30 30 1,423 508 914 202,362
125 5/1/30 30 1,423 506 917 201,445
126 6/1/30 30 1,423 504 919 200,526
127 7/1/30 30 1,423 501 921 199,605
128 8/1/30 30 1,423 499 924 198,681
129 9/1/30 30 1,423 497 926 197,755
130 10/1/30 30 1,423 494 928 196,827
131 11/1/30 30 1,423 492 931 195,896
132 12/1/30 30 1,423 490 933 194,963
133 1/1/31 31 1,423 487 935 194,028
134 2/1/31 31 1,423 485 938 193,091
135 3/1/31 31 1,423 483 940 192,151
136 4/1/31 31 1,423 480 942 191,208
137 5/1/31 31 1,423 478 945 190,264
138 6/1/31 31 1,423 476 947 189,317
139 7/1/31 31 1,423 473 949 188,367
140 8/1/31 31 1,423 471 952 187,416
141 9/1/31 31 1,423 469 954 186,462
142 10/1/31 31 1,423 466 956 185,505
143 11/1/31 31 1,423 464 959 184,546
144 12/1/31 31 1,423 461 961 183,585
145 1/1/32 32 1,423 459 964 182,621
146 2/1/32 32 1,423 457 966 181,655
147 3/1/32 32 1,423 454 968 180,687
148 4/1/32 32 1,423 452 971 179,716
149 5/1/32 32 1,423 449 973 178,743
150 6/1/32 32 1,423 447 976 177,767
151 7/1/32 32 1,423 444 978 176,789
152 8/1/32 32 1,423 442 981 175,808
153 9/1/32 32 1,423 440 983 174,825
154 10/1/32 32 1,423 437 986 173,839
155 11/1/32 32 1,423 435 988 172,851
156 12/1/32 32 1,423 432 991 171,861
157 1/1/33 33 1,423 430 993 170,868
158 2/1/33 33 1,423 427 995 169,872
159 3/1/33 33 1,423 425 998 168,874
160 4/1/33 33 1,423 422 1,000 167,874
161 5/1/33 33 1,423 420 1,003 166,871
162 6/1/33 33 1,423 417 1,005 165,865
163 7/1/33 33 1,423 415 1,008 164,857
164 8/1/33 33 1,423 412 1,010 163,847
165 9/1/33 33 1,423 410 1,013 162,834
166 10/1/33 33 1,423 407 1,016 161,818
167 11/1/33 33 1,423 405 1,018 160,800
168 12/1/33 33 1,423 402 1,021 159,780
169 1/1/34 34 1,423 399 1,023 158,757
170 2/1/34 34 1,423 397 1,026 1