Fixed Rate Mortgage Versus Lump Sum

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Retirement Age	55			Amount Invested after 12 years
2	Pension Given Up	£1,000.00			£13,521.90
3	Tax Free Lump Sum Gained	£12,000.00
4	Tax Rate on Pension	20.00%
5
6	Fixed Rate Mortgage	4.60%
7	Term	15
8	Monthly Payment	£84.00
9	Annual Payment	£1,008.00
10	Fees	£995.00
11	TOTAL PAYMENT	£16,560.00
12
13	Assumed Annual Inflation	2.00%
14
15		Pension Given Up				Different Inflation Rates
16	Year After Retirement	Per Year	Cumulative Total	Age	Year After Retirement	2%		3%		4%		5%		6%		7%		8%		Year After Retirement
17						Pension	Total Rec'd	Pension	Total Rec'd	Pension	Total Rec'd	Pension	Total Rec'd	Pension	Total Rec'd	Pension	Total Rec'd	Pension	Total Rec'd
18	1	£800.00	£800.00	56	1	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	£800.00	1
19	2	£880.00	£1,680.00	57	2	£812.80	£1,612.80	£819.20	£1,619.20	£825.60	£1,625.60	£832.00	£1,632.00	£838.40	£1,638.40	£844.80	£1,644.80	£851.20	£1,651.20	2
20	3	£894.08	£2,574.08	58	3	£825.80	£2,438.60	£838.86	£2,458.06	£852.02	£2,477.62	£865.28	£2,497.28	£878.64	£2,517.04	£892.11	£2,536.91	£905.68	£2,556.88	3
21	4	£908.39	£3,482.47	59	4	£839.02	£3,277.62	£858.99	£3,317.05	£879.28	£3,356.90	£899.89	£3,397.17	£920.82	£3,437.86	£942.07	£3,478.98	£963.64	£3,520.52	4
22	5	£922.92	£4,405.38	60	5	£852.44	£4,130.06	£879.61	£4,196.66	£907.42	£4,264.32	£935.89	£4,333.06	£965.02	£4,402.88	£994.82	£4,473.80	£1,025.31	£4,545.83	5
23	6	£937.69	£5,343.07	61	6	£866.08	£4,996.15	£900.72	£5,097.38	£936.46	£5,200.78	£973.32	£5,306.38	£1,011.34	£5,414.22	£1,050.53	£5,524.33	£1,090.93	£5,636.76	6
24	7	£952.69	£6,295.76	62	7	£879.94	£5,876.08	£922.34	£6,019.72	£966.43	£6,167.21	£1,012.26	£6,318.64	£1,059.88	£6,474.10	£1,109.36	£6,633.69	£1,160.75	£6,797.52	7
25	8	£967.93	£7,263.69	63	8	£894.02	£6,770.10	£944.47	£6,964.19	£997.35	£7,164.56	£1,052.75	£7,371.38	£1,110.76	£7,584.86	£1,171.49	£7,805.18	£1,235.04	£8,032.56	8
26	9	£983.42	£8,247.11	64	9	£908.32	£7,678.42	£967.14	£7,931.33	£1,029.27	£8,193.82	£1,094.86	£8,466.24	£1,164.07	£8,748.93	£1,237.09	£9,042.27	£1,314.08	£9,346.64	9
27	10	£999.15	£9,246.27	65	10	£922.85	£8,601.28	£990.35	£8,921.69	£1,062.20	£9,256.03	£1,138.65	£9,604.89	£1,219.95	£9,968.88	£1,306.37	£10,348.64	£1,398.19	£10,744.83	10
28	11	£1,015.14	£10,261.41	66	11	£937.62	£9,538.90	£1,014.12	£9,935.81	£1,096.19	£10,352.22	£1,184.20	£10,789.08	£1,278.51	£11,247.38	£1,379.52	£11,728.16	£1,487.67	£12,232.49	11
29	12	£1,031.38	£11,292.79	67	12	£952.62	£10,491.52	£1,038.46	£10,974.27	£1,131.27	£11,483.49	£1,231.56	£12,020.64	£1,339.87	£12,587.26	£1,456.78	£13,184.94	£1,582.88	£13,815.37	12
30	13	£1,047.88	£12,340.67	68	13	£967.86	£11,459.38	£1,063.38	£12,037.65	£1,167.47	£12,650.96	£1,280.83	£13,301.47	£1,404.19	£13,991.45	£1,538.36	£14,723.29	£1,684.18	£15,499.56	13
31	14	£1,064.65	£13,405.32	69	14	£983.35	£12,442.73	£1,088.90	£13,126.55	£1,204.83	£13,855.79	£1,332.06	£14,633.53	£1,471.59	£15,463.04	£1,624.50	£16,347.80	£1,791.97	£17,291.53	14
32	15	£1,081.69	£14,487.01	70	15	£999.08	£13,441.82	£1,115.04	£14,241.59	£1,243.39	£15,099.18	£1,385.34	£16,018.87	£1,542.23	£17,005.26	£1,715.48	£18,063.28	£1,906.66	£19,198.19	15
33	16	£1,098.99	£15,586.00	71	16	£1,015.07	£14,456.89	£1,141.80	£15,383.39	£1,283.17	£16,382.35	£1,440.75	£17,459.62	£1,616.25	£18,621.51	£1,811.54	£19,874.82	£2,028.68	£21,226.87	16
34	17	£1,116.58	£16,702.58	72	17	£1,031.31	£15,488.20	£1,169.20	£16,552.59	£1,324.24	£17,706.59	£1,498.38	£18,958.01	£1,693.83	£20,315.35	£1,912.99	£21,787.81	£2,158.52	£23,385.39	17
35	18	£1,134.44	£17,837.02	73	18	£1,047.81	£16,536.01	£1,197.26	£17,749.85	£1,366.61	£19,073.20	£1,558.32	£20,516.33	£1,775.14	£22,090.48	£2,020.12	£23,807.93	£2,296.67	£25,682.06	18
36	19	£1,152.59	£18,989.61	74	19	£1,064.58	£17,600.59	£1,226.00	£18,975.85	£1,410.34	£20,483.54	£1,620.65	£22,136.98	£1,860.34	£23,950.83	£2,133.24	£25,941.17	£2,443.65	£28,125.71	19
37	20	£1,171.03	£20,160.64	75	20	£1,081.61	£18,682.19	£1,255.42	£20,231.27	£1,455.47	£21,939.01	£1,685.48	£23,822.46	£1,949.64	£25,900.47	£2,252.71	£28,193.88	£2,600.05	£30,725.75	20
38	21	£1,189.77	£21,350.41	76	21	£1,098.92	£19,781.11	£1,285.55	£21,516.82	£1,502.05	£23,441.06	£1,752.90	£25,575.36	£2,043.22	£27,943.69	£2,378.86	£30,572.73	£2,766.45	£33,492.20	21
39	22	£1,208.81	£22,559.22	77	22	£1,116.50	£20,897.61	£1,316.40	£22,833.22	£1,550.11	£24,991.18	£1,823.01	£27,398.38	£2,141.30	£30,084.99	£2,512.07	£33,084.81	£2,943.50	£36,435.70	22
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