commision varying

	A	B	C	D	F	G	H	I	J
1	9818.17
2	BASE TABLE (princ 9818, 8% intt, 10% inflation				TABLE (Commission earned vs INFLAPRO scheme), 8% intt, 10% inflation
3	year	interest	pay-out	balance	year	Earned Commission	interest	pay-out	balance
4	1	785.45	254.55	10,349.07	1	100,000	8,000.00	2,592.64	105,407.36
5	2	827.93	280.01	10,896.99	2	104,000	16,752.59	5,665.84	220,494.11
6	3	871.76	308.01	11,460.74	3	106,000	26,119.53	9,228.55	343,385.09
7	4	916.86	338.81	12,038.79	4	106,000	35,950.81	13,285.02	472,050.88
8	5	963.10	372.69	12,629.20	5	110,200	46,580.07	18,024.99	610,805.96
9	6	1,010.34	409.96	13,229.58	6	112,400	57,856.48	23,476.19	757,586.25
10	7	1,058.37	450.96	13,836.99	7	112,400	69,598.90	29,655.44	909,929.71
11	8	1,106.96	496.06	14,447.89	8	116,900	82,146.38	36,812.14	1,072,163.95
12	9	1,155.83	545.67	15,058.05	9	119,100	95,301.12	44,991.83	1,241,573.24
13	10	1,204.64	600.24	15,662.45	10	119,100	108,853.86	54,238.80	1,415,288.30
14	11	1,253.00	660.26	16,255.19	11	123,900	123,135.06	64,885.41	1,597,437.95
15	12	1,300.42	726.29	16,829.32	12	126,200	137,891.04	77,013.00	1,784,515.99
16	13	1,346.35	798.92	17,376.75	13	126,200	152,857.28	90,705.34	1,972,867.93
17	14	1,390.14	878.81	17,888.08	14	131,200	168,325.43	106,410.92	2,165,982.44
18	15	1,431.05	966.69	18,352.44	15	133,800	183,982.60	124,282.58	2,359,482.46
19	16	1,468.20	1,063.36	18,757.28	16	133,800	199,462.60	144,463.45	2,548,281.61
20	17	1,500.58	1,169.70	19,088.16	17	139,200	214,998.53	167,590.78	2,734,889.36
21	18	1,527.05	1,286.67	19,328.54	18	141,800	230,135.15	193,908.16	2,912,916.35
22	19	1,546.28	1,415.34	19,459.48	19	141,800	244,377.31	223,682.82	3,075,410.84
23	20	1,556.76	1,556.87	19,459.37	20	147,500	257,832.87	257,851.35	3,222,892.36
24	Adjustment			-1.51		2,451,500
25	Further pension		1,556.87			Tot. commission		1,688,765.25
26	Maturity/final settlement			19460.88		Yield			10.02%
27
28						Adjustment			-249.52
29						Further pension		257,851.35
30						Maturity/final settlement			3223141.88
31	Table of Yield
32	code	Start Base payment	Yield
33	nil,1	1000.00	7.65%
34	nil,4	442.87	8.48%
35	defa,1	785.45	9.20%
36	defa,4	347.86	9.54%
37	defa,7	254.55	10.41%
38	half,1	879.84	8.61%
39	half,4	395.37	9.04%
40	half,10	323.29	9.78%
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