ABCDEFGHIJK
1
Original Loan ScheduleInstructions
2
Loan Amount $ 200,000 1) Fill in the values in the gray cells on the Summary tab.

2) Fill in the gray cells for expected Additional Principal Payments each month on the Amortization Schedule tab.
3
Loan Period In Years15
4
Loan Start Date1/1/2018
5
Loan End Date1/1/2033
6
Interest Rate4.75
7
Monthly Mortgage Payment$1,555.66
8
Monthly Escrow$50.00
9
Total Monthly Payment$1,605.66
10
Scheduled Number Of Payments180
11
Total Interest$80,019.49
12
13
Accelerated Loan Schedule
14
Loan Period15 years, 0 months
15
Loan End Date1/1/2033
16
Remaining Terms162
17
Actual Number Of Payments180
18
Total Interest$80,019.49
19
Estimated Savings On Interest$0.00
20
21
Current Estimated Payoff
22
Estimated Payoff Amount$185,775.44
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100