ABCDEFGHIJKLMNOPQRSTUVWXYZAA
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£994
7
Monthly savings£250
(or overpayments, investments)
8
Expected investment returns (per year)7.0%
9
10
Scenario 1Scenario 2Scenario 3
11
Pay mortgage on schedule (£744pm).
Save £250pm at 0%.
Use monthly savings to overpay mortgage (£994 pm).
When mortgage ends, save that full monthly payment instead.
Pay mortgage on schedule (£744pm).
Invest £250pm with an expected return of 7%
12
YearMortgageSavingsMortgageSavingsMortgageSavings
13
0-£200,000£0-£200,000£0-£200,000£0
14
5-£174,344£15,000-£158,732£0-£174,344£17,252
15
10-£146,018£30,000-£113,169£0-£146,018£41,449
16
15-£114,744£45,000-£62,863£0-£114,744£75,387
17
20-£80,214£60,000-£7,322£0-£80,214£122,986
18
25-£42,091£75,000£0£59,650-£42,091£189,747
19
30£0£90,000£0£119,300£0£283,382
20
21
Mortgage ends in year
302030
22
Total cost of mortgage
£267,900£238,600£267,900
23
24
25
1-£195,070£3,000-£192,070£0-£195,070£3,000
26
2-£190,041£6,000-£183,981£0-£190,041£6,210
27
3-£184,912£9,000-£175,731£0-£184,912£9,645
28
4-£179,681£12,000-£167,316£0-£179,681£13,320
29
5-£174,344£15,000-£158,732£0-£174,344£17,252
30
6-£168,901£18,000-£149,977£0-£168,901£21,460
31
7-£163,349£21,000-£141,046£0-£163,349£25,962
32
8-£157,686£24,000-£131,937£0-£157,686£30,779
33
9-£151,910£27,000-£122,646£0-£151,910£35,934
34
10-£146,018£30,000-£113,169£0-£146,018£41,449
35
11-£140,008£33,000-£103,502£0-£140,008£47,351
36
12-£133,879£36,000-£93,642£0-£133,879£53,665
37
13-£127,626£39,000-£83,585£0-£127,626£60,422
38
14-£121,249£42,000-£73,327£0-£121,249£67,651
39
15-£114,744£45,000-£62,863£0-£114,744£75,387
40
16-£108,109£48,000-£52,191£0-£108,109£83,664
41
17-£101,341£51,000-£41,305£0-£101,341£92,521
42
18-£94,438£54,000-£30,201£0-£94,438£101,997
43
19-£87,396£57,000-£18,875£0-£87,396£112,137
44
20-£80,214£60,000-£7,322£0-£80,214£122,986
45
21-£72,889£63,000£0£11,930-£72,889£134,596
46
22-£65,416£66,000£0£23,860-£65,416£147,017
47
23-£57,795£69,000£0£35,790-£57,795£160,308
48
24-£50,021£72,000£0£47,720-£50,021£174,530
49
25-£42,091£75,000£0£59,650-£42,091£189,747
50
26-£34,003£78,000£0£71,580-£34,003£206,029
51
27-£25,753£81,000£0£83,510-£25,753£223,451
52
28-£17,338£84,000£0£95,440-£17,338£242,093
53
29-£8,755£87,000£0£107,370-£8,755£262,040
54
30£0£90,000£0£119,300£0£283,382
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