ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Loan Amount$300,000.00
2
Annual Interest Rate6.00%
3
Enter loan amount and interest rate above, then compare terms below
4
5
Loan Term (Years)Number of MonthsMonthly PaymentTotal Payments
Total Interest Paid
Equity After 5 YearsEquity After 10 YearsEquity After 15 Years
6
15180$2,531.57$455,682.69$155,682.69$71,972.70$169,053.10$300,000.00
7
20240$2,149.29$515,830.36$215,830.36$45,301.20$106,405.74$188,826.61
8
30360$1,798.65$647,514.57$347,514.57$20,836.93$48,942.83$86,853.47
9
50600$1,579.21$947,528.63$647,528.63$5,526.79$12,981.60$23,037.02
10
11
12
Mortgage term comparison spreadsheet provided by:
13
BibleMoneyMatters.com
14
15
16
17
18
19
20
Go to "File/Make a copy" menu to make your own copy of this spreadsheet.
21
22
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