ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1
2
Before 30th March 2017
3
0123456789101112131415161718192021222324252627282930
4
£1,052,500
£1,041,443.75
£1,029,283.45
£1,015,972.75
£1,001,463.68£985,706.64£968,650.34£950,241.73£930,425.95£909,146.29£886,344.11£861,958.80£835,927.69£808,186.03£778,666.88£747,301.07£714,017.12£678,741.16£641,396.88£601,905.45£560,185.40£516,152.61£469,720.15£420,798.27£369,294.25£315,112.35£258,153.70£198,316.20£135,494.44£69,579.57£459.22
5
Cashflow-40,000-40,800-41,616-42,448-43,297-44,163-45,046-45,947-46,866-47,804-48,760-49,735-50,730-51,744-52,779-53,835-54,911-56,010-57,130-58,272-59,438-60,627-61,839-63,076-64,337-65,624-66,937-68,275-69,641-71,034
6
7
8
OLD Lump Sum£1,052,500
9
Discount1.0275
10
Inflation1.02
11
12
After 30th March 2017
13
0123456789101112131415161718192021222324252627282930
14
£1,850,000£1,796,125£1,741,854£1,687,174£1,632,072£1,576,534£1,520,547£1,464,096£1,407,168£1,349,748£1,291,821£1,233,373£1,174,388£1,114,850£1,054,744£994,055£932,764£870,857£808,316£745,124£681,263£616,716£551,464£485,489£418,771£351,293£283,034£213,975£144,094£73,373£1,789
15
Cashflow-40,000-40,800-41,616-42,448-43,297-44,163-45,046-45,947-46,866-47,804-48,760-49,735-50,730-51,744-52,779-53,835-54,911-56,010-57,130-58,272-59,438-60,627-61,839-63,076-64,337-65,624-66,937-68,275-69,641-71,034
16
17
18
NEW Lump Sum£1,850,000
19
Discount0.9925
20
Inflation1.02
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