ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Mortgage Payoff Tracker
3
4
Instructions - Fill in the amounts in the YELLOW cells.
5
6
INPUTS
7
Current Loan Balance$500,000.00
8
Annual Interest Rate6.375%
9
Minimum Required Monthly Payment$3,196.71
10
Principal Portion of Last Payment (info)$1,923.68
11
Interest Portion of Last Payment (info)$1,273.03
12
As-of Date07/30/2026
13
Default Monthly Extra Payment$1,000.00
14
15
SUMMARY
16
Projected Payoff Date (with extra)Apr 2042
17
Months Remaining Until Payoff190
18
Total Monthly Payment4,197
19
Total Interest Remaining$293,824.97
20
Baseline Payoff Date (no extra)Jun 2054
21
Baseline Total Interest (no extra)$572,396.18
22
Interest Saved$278,571.21
23
Months Saved146
24
25
Tip: On the Amortization Schedule, the Extra Payment column (blue) defaults to the amount above. Overwrite any month's cell with a different number (or 0) to model skipping or adding extra payments.
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