ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Dividend Rate:8%https://exceltable.com/
2
Required Investment Amount: $ 300 000,00
3
DatePlanned Profit
4
12/312021 $ 100 000,00
5
12/312022 $ 119 000,58
6
12/312023 $ 141 610,07
7
12/312024 $ 169 930,20
8
12/312025 $ 186 920,52
9
12/312026 $ 205 610,77
10
12/312027 $ 236 460,04
11
Company Revenue over 7 Years: $ 1 159 532,18 =SUM(B4:B10)
12
Company Profit over 7 Years: $ 526 691,61
13
Investor Profit over 7 Years: $ 332 840,57 =B11-B12-B2
14
15
16
17
18
19
20
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