Mortgage Repayment Calculator Spreadsheet
ADVERTISEMENT
1PAYMENT CALCULATOR
$100
Monthly payment in dollars per $100 financed.
Rate (Percentage)
3%
4%
5%
6%
7%
8%
9%
10%
11%
12%
13%
1
8.47
8.51
8.56
8.61
8.65
8.70
8.75
8.79
8.84
8.88
8.93
2
4.30
4.34
4.39
4.43
4.48
4.52
4.57
4.61
4.66
4.71
4.75
3
2.91
2.95
3.00
3.04
3.09
3.13
3.18
3.23
3.27
3.32
3.37
4
2.21
2.26
2.30
2.35
2.39
2.44
2.49
2.54
2.58
2.63
2.68
5
1.80
1.84
1.89
1.93
1.98
2.03
2.08
2.12
2.17
2.22
2.28
6
1.52
1.56
1.61
1.66
1.70
1.75
1.80
1.85
1.90
1.96
2.01
7
1.32
1.37
1.41
1.46
1.51
1.56
1.61
1.66
1.71
1.77
1.82
8
1.17
1.22
1.27
1.31
1.36
1.41
1.47
1.52
1.57
1.63
1.68
9
1.06
1.10
1.15
1.20
1.25
1.30
1.35
1.41
1.46
1.52
1.58
10
0.97
1.01
1.06
1.11
1.16
1.21
1.27
1.32
1.38
1.43
1.49
11
0.89
0.94
0.99
1.04
1.09
1.14
1.20
1.25
1.31
1.37
1.43
12
0.83
0.88
0.92
0.98
1.03
1.08
1.14
1.20
1.25
1.31
1.37
13
0.77
0.82
0.87
0.92
0.98
1.03
1.09
1.15
1.21
1.27
1.33
14
0.73
0.78
0.83
0.88
0.94
0.99
1.05
1.11
1.17
1.23
1.30
15
0.69
0.74
0.79
0.84
0.90
0.96
1.01
1.07
1.14
1.20
1.27
16
0.66
0.71
0.76
0.81
0.87
0.92
0.98
1.05
1.11
1.17
1.24
17
0.63
0.68
0.73
0.78
0.84
0.90
0.96
1.02
1.09
1.15
1.22
18
0.60
0.65
0.70
0.76
0.82
0.87
0.94
1.00
1.07
1.13
1.20
19
0.58
0.63
0.68
0.74
0.79
0.85
0.92
0.98
1.05
1.12
1.18
20
0.55
0.61
0.66
0.72
0.78
0.84
0.90
0.97
1.03
1.10
1.17
21
0.54
0.59
0.64
0.70
0.76
0.82
0.88
0.95
1.02
1.09
1.16
22
0.52
0.57
0.63
0.68
0.74
0.81
0.87
0.94
1.01
1.08
1.15
23
0.50
0.55
0.61
0.67
0.73
0.79
0.86
0.93
1.00
1.07
1.14
24
0.49
0.54
0.60
0.66
0.72
0.78
0.85
0.92
0.99
1.06
1.13
25
0.47
0.53
0.58
0.64
0.71
0.77
0.84
0.91
0.98
1.05
1.13
26
0.46
0.52
0.57
0.63
0.70
0.76
0.83
0.90
0.97
1.05
1.12
27
0.45
0.51
0.56
0.62
0.69
0.75
0.82
0.89
0.97
1.04
1.12
28
0.44
0.50
0.55
0.62
0.68
0.75
0.82
0.89
0.96
1.04
1.11
29
0.43
0.49
0.54
0.61
0.67
0.74
0.81
0.88
0.96
1.03
1.11
30
0.42
0.48
0.54
0.60
0.67
0.73
0.80
0.88
0.95
1.03
1.11
Use this chart to calculate your approximate monthly payment. Read down the left column to find the term of your loan in years and
across the top row to find your finance rate. Your payment per $100 financed is where the two intersect.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Financial