ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Loan Payment Amortization ScheduleBlended
2
Loan Amount$2,625,000
3
Annual interest rate6.29%
4
Amortization term25
5
Regular payment amount$211,037.54
6
Total Payments over period$5,275,938
7
Total Interest Cost over period $2,650,938
8
9
10
YearOpening BalancePaymentPrincipal Interest Closing Balance
11
1 2,625,000.00 211,037.54 45,925.04 165,112.50 2,579,074.96
12
2 2,579,074.96 211,037.54 48,813.72 162,223.82 2,530,261.24
13
3 2,530,261.24 211,037.54 51,884.11 159,153.43 2,478,377.13
14
4 2,478,377.13 211,037.54 55,147.62 155,889.92 2,423,229.51
15
5 2,423,229.51 211,037.54 58,616.40 152,421.14 2,364,613.11
16
6 2,364,613.11 211,037.54 62,303.38 148,734.16 2,302,309.73
17
7 2,302,309.73 211,037.54 66,222.26 144,815.28 2,236,087.47
18
8 2,236,087.47 211,037.54 70,387.64 140,649.90 2,165,699.84
19
9 2,165,699.84 211,037.54 74,815.02 136,222.52 2,090,884.82
20
10 2,090,884.82 211,037.54 79,520.88 131,516.66 2,011,363.93
21
11 2,011,363.93 211,037.54 84,522.75 126,514.79 1,926,841.18
22
12 1,926,841.18 211,037.54 89,839.23 121,198.31 1,837,001.96
23
13 1,837,001.96 211,037.54 95,490.12 115,547.42 1,741,511.84
24
14 1,741,511.84 211,037.54 101,496.44 109,541.09 1,640,015.39
25
15 1,640,015.39 211,037.54 107,880.57 103,156.97 1,532,134.82
26
16 1,532,134.82 211,037.54 114,666.26 96,371.28 1,417,468.56
27
17 1,417,468.56 211,037.54 121,878.77 89,158.77 1,295,589.80
28
18 1,295,589.80 211,037.54 129,544.94 81,492.60 1,166,044.86
29
19 1,166,044.86 211,037.54 137,693.32 73,344.22 1,028,351.54
30
20 1,028,351.54 211,037.54 146,354.23 64,683.31 881,997.31
31
21 881,997.31 211,037.54 155,559.91 55,477.63 726,437.40
32
22 726,437.40 211,037.54 165,344.63 45,692.91 561,092.77
33
23 561,092.77 211,037.54 175,744.80 35,292.74 385,347.97
34
24 385,347.97 211,037.54 186,799.15 24,238.39 198,548.82
35
25 198,548.82 211,037.54 198,548.82 12,488.72 (0.00)
36
Totals 5,275,938.49 2,625,000.00 2,650,938.49
37
38
39
40
Loan Payment Amortization ScheduleP+I
41
Loan Amount$2,625,000
42
Annual interest rate6.29%
43
Amortization term25
44
Total Payments over period$4,771,463
45
Total Interest Cost over period $2,146,463
46
47
48
YearOpening BalancePaymentPrincipalInterestClosing Balance
49
1 2,625,000 $270,113 $105,000 165,113 2,520,000
50
2 2,520,000 $263,508 $105,000 158,508 2,415,000
51
3 2,415,000 $256,904 $105,000 151,904 2,310,000
52
4 2,310,000 $250,299 $105,000 145,299 2,205,000
53
5 2,205,000 $243,695 $105,000 138,695 2,100,000
54
6 2,100,000 $237,090 $105,000 132,090 1,995,000
55
7 1,995,000 $230,486 $105,000 125,486 1,890,000
56
8 1,890,000 $223,881 $105,000 118,881 1,785,000
57
9 1,785,000 $217,277 $105,000 112,277 1,680,000
58
10 1,680,000 $210,672 $105,000 105,672 1,575,000
59
11 1,575,000 $204,068 $105,000 99,068 1,470,000
60
12 1,470,000 $197,463 $105,000 92,463 1,365,000
61
13 1,365,000 $190,859 $105,000 85,859 1,260,000
62
14 1,260,000 $184,254 $105,000 79,254 1,155,000
63
15 1,155,000 $177,650 $105,000 72,650 1,050,000
64
16 1,050,000 $171,045 $105,000 66,045 945,000
65
17 945,000 $164,441 $105,000 59,441 840,000
66
18 840,000 $157,836 $105,000 52,836 735,000
67
19 735,000 $151,232 $105,000 46,232 630,000
68
20 630,000 $144,627 $105,000 39,627 525,000
69
21 525,000 $138,023 $105,000 33,023 420,000
70
22 420,000 $131,418 $105,000 26,418 315,000
71
23 315,000 $124,814 $105,000 19,814 210,000
72
24 210,000 $118,209 $105,000 13,209 105,000
73
25 105,000 $111,605 $105,000 6,605 -
74
Totals$4,771,463 $2,625,000 $2,146,463
75
76
77
78
79
Interest Cost Savings in favor of P+I vs. Blended$504,475.99
80
19%
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100