Investment Model

	C	D	E	F	G
1
2	Property cost
3
4		USD	Lagos (NGN)	Johannesburg (Rand)	Nairobi (KES)
5	Property price	$100,000	₦36,000,000.00	R1,500,000.00	Ksh10,000,000.00
6
7	Opportunity cost
8
9	Investment Model	10% interest rate	10%
10	Year	USD	Lagos (NGN)	Johannesburg (Rand)	Nairobi (KES)
11	0	$100,000	₦36,000,000.00	R1,500,000.00	Ksh10,000,000.00
12	1	$110,000	₦39,600,000.00	R1,650,000.00	Ksh11,000,000.00
13	2	$121,000	₦43,560,000.00	R1,815,000.00	Ksh12,100,000.00
14	3	$133,100	₦47,916,000.00	R1,996,500.00	Ksh13,310,000.00
15	4	$146,410	₦52,707,600.00	R2,196,150.00	Ksh14,641,000.00
16	5	$161,051	₦57,978,360.00	R2,415,765.00	Ksh16,105,100.00
17	6	$177,156	₦63,776,196.00	R2,657,341.50	Ksh17,715,610.00
18	7	$194,872	₦70,153,815.60	R2,923,075.65	Ksh19,487,171.00
19	8	$214,359	₦77,169,197.16	R3,215,383.22	Ksh21,435,888.10
20	9	$235,795	₦84,886,116.88	R3,536,921.54	Ksh23,579,476.91
21	10	$259,374	₦93,374,728.56	R3,890,613.69	Ksh25,937,424.60
22	11	$285,312	₦102,712,201.42	R4,279,675.06	Ksh28,531,167.06
23	12	$313,843	₦112,983,421.56	R4,707,642.57	Ksh31,384,283.77
24	13	$345,227	₦124,281,763.72	R5,178,406.82	Ksh34,522,712.14
25	14	$379,750	₦136,709,940.09	R5,696,247.50	Ksh37,974,983.36
26	15	$417,725	₦150,380,934.10	R6,265,872.25	Ksh41,772,481.69
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