ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
TO COPY THIS SPREADSHEET GO TO FILE > MAKE A COPY. YOU WILL BE ABLE TO EDIT THE COPY. DO NOT REQUEST EDIT PERMISSIONS
2
3
Mortgage amount£200,000
4
Mortgage term (years)30
5
Mortgage interest rate2.0%
6
Monthly mortgage payment£744
7
Monthly savings (for overpayments, savings or investments)£250
8
Savings interest rate4.0%
9
Expected investment returns7.0%
10
11
Baseline scenario
Apply savings to mortgage balance
Save at 4%
Invest at 7% expected return
12
Year (end)Mortgage balance - normal paymentsAmount overpaid, saved or investedMortgage balance -
with overpayments		Difference between mortgage balancesSavings/investment balanceSavings/investment balance
13
1-£195,025£3,000-£191,997£3,028£3,056£3,098
14
2-£189,949£6,000-£183,832£6,116£6,236£6,420
15
3-£184,770£9,000-£175,503£9,268£9,545£9,983
16
4-£179,488£12,000-£167,005£12,482£12,990£13,802
17
5-£174,098£15,000-£158,336£15,762£16,575£17,898
18
6-£168,600£18,000-£149,492£19,108£20,306£22,290
19
7-£162,991£21,000-£140,470£22,521£24,189£27,000
20
8-£157,268£24,000-£131,265£26,003£28,230£32,050
21
9-£151,430£27,000-£121,875£29,556£32,435£37,465
22
10-£145,475£30,000-£112,295£33,180£36,812£43,271
23
11-£139,399£33,000-£102,521£36,877£41,368£49,497
24
12-£133,200£36,000-£92,551£40,649£46,109£56,174
25
13-£126,876£39,000-£82,379£44,497£51,043£63,333
26
14-£120,425£42,000-£72,002£48,423£56,178£71,009
27
15-£113,843£45,000-£61,415£52,428£61,523£79,241
28
16-£107,129£48,000-£50,615£56,514£67,085£88,067
29
17-£100,279£51,000-£39,596£60,683£72,874£97,532
30
18-£93,290£54,000-£28,356£64,935£78,898£107,680
31
19-£86,161£57,000-£16,888£69,273£85,168£118,563
32
20-£78,888£60,000-£5,189£73,699£91,694£130,232
33
21-£71,468£63,000£0£71,468£98,485£142,744
34
22-£63,898£66,000£0£105,553£156,161
35
23-£56,176£69,000£0£112,909£170,548
36
24-£48,297£72,000£0£120,565£185,976
37
25-£40,260£75,000£0£128,532£202,518
38
26-£32,060£78,000£0£136,825£220,256
39
27-£23,695£81,000£0£145,455£239,277
40
28-£15,161£84,000£0£154,436£259,672
41
29-£6,455£87,000£0£163,784£281,542
42
30£0£90,000£0£173,512£304,993
43
44
Baseline scenario
Apply savings to mortgage balance
Save at 4%
Invest at 7% expected return
45
Year (end)Mortgage balance - normal paymentsAmount overpaid, saved or investedMortgage balance -
with overpayments		Difference between mortgage balancesSavings/investment balanceSavings/investment balance
46
0-£200,000£0-£200,000£0£0£0
47
5-£174,098£15,000-£158,336£15,762£16,575£17,898
48
10-£145,475£30,000-£112,295£33,180£36,812£43,271
49
15-£113,843£45,000-£61,415£52,428£61,523£79,241
50
20-£78,888£60,000-£5,189£73,699£91,694£130,232
51
25-£40,260£75,000£0£40,260£128,532£202,518
52
30£0£90,000£0£0£173,512£304,993
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