ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBO
1
2
3
4
5
6
7
8
9
10
Table 1
11
Initial data for the project
12
13
IndexValue
14
Calculation horizon 17 sq.
15
Start of project implementation (investment)
16
Settlement currency - monetary unit of the projectUSD
17
Date of compilation of the financial model
18
Information display step in calculations 1st quarter
19
Discount rate (WACC)25,48%
20
Tax environmentHTP
21
22
23
table 2
24
Macroeconomic environment
25
26
IndexUnit.-1234567891011121314151617
27
Inflation
28
Estimated Annual Inflation Rate (USD)%2,5%2,5%2,5%2,0%2,0%2,0%2,0%2,0%2,0%2,0%2,0%2,0%2,0%2,0%2,0%2,0%2,0%
29
Inflation rate in quarterly equivalent%0,00%0,63%0,63%0,63%0,50%0,50%0,50%0,50%0,50%0,50%0,50%0,50%0,50%0,50%0,50%0,50%0,50%0,50%
30
Cumulative inflation1,001,011,011,021,021,031,031,041,041,051,061,061,071,071,081,081,091,09
31
Tax environment
32
VAT
33
domestic market%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
34
export%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
35
Insurance deductions
36
social contributions% of avg. RFP for RB34%34%34%34%34%34%34%34%34%34%34%34%34%34%34%34%34%34%
37
compulsory insurance contributions% of avg. RFP for RB0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%0,6%
38
Income tax%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
41
42
43
Table 3
44
Calculation of the number of users for the project
45
46
IndexUnit.-1234567891011121314151617
47
Basic indicators of Unit-economy in the context of the number of users
48
New Paid Users
49
Cisunits25 000100 000100 000100 000110 000121 000133 100146 410161 051177 156194 872214 359235 795259 374285 312313 843
50
EU/USAUnits.0000100 000120 000144 000172 800207 360248 832298 598358 318429 982515 978619 174743 008
51
% of Organic users
52
Cis%125%125%125%125%100%100%100%100%75%75%75%75%75%75%75%75%
53
EU/USA%0%0%0%0%125%125%125%125%100%100%100%100%75%75%75%75%
54
Organic user
55
CisUnits.31 250125 000125 000125 000110 000121 000133 100146 410120 788132 867146 154160 769176 846194 531213 984235 382
56
EU/USAUnits.0000125 000150 000180 000216 000207 360248 832298 598358 318322 486386 984464 380557 256
57
User LT
58
Cissq.1,01,02,02,03,03,04,04,04,04,04,04,04,04,04,04,0
59
EU/USASq.0,00,00,00,01,01,02,02,03,03,04,04,04,04,04,04,0
60
Active users in the period, taking into account their life cycle
61
CisUnits.56 250225 000225 000450 000445 000462 000608 144648 122651 520961 5431 036 3681 118 6761 249 4781 393 3601 551 6301 725 726
62
EU/USAUnits.0000225 000270 000324 000712 800803 520912 3841 354 3691 577 8181 734 3302 637 2923 123 6493 707 277
63
Churn (retirement, removal)
64
Cis%60%40%30%20%20%20%20%20%20%20%20%20%20%20%20%20%
65
EU/USA%0%0%0%0%60%40%30%20%20%20%20%20%20%20%20%20%
66
SOURCE Number of Active Users in the Period
67
CisUnits.11 25067 50078 750202 500200 500206 800277 452294 779297 576449 769484 082521 825583 475651 289725 885807 941
68
EU/USAUnits.000067 500121 500170 100476 280540 432609 638926 1971 075 8681 187 8781 842 5252 180 2042 585 418
69
70
71
72
Table 4
73
Unit economics
74
75
IndexUnit.-1234567891011121314151617
76
Key assumptions of the monetization program
77
Purchases
78
Average purchase check for one active user, USD
79
CisUSD40,040,040,040,045,045,045,045,050,050,050,050,050,050,050,050,0
80
EU/USAUSD0,00,00,00,080,080,080,080,090,090,090,090,0100,0100,0100,0100,0
81
Average number of checks per user per period
82
Cisunits1,01,01,01,01,01,01,01,01,01,01,01,01,01,01,01,0
83
EU/USAUnits.0,00,00,00,01,01,01,01,01,01,01,01,01,01,01,01,0
84
Average commission from purchase
85
Cis%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%
86
EU/USA%0%0%0%0%10%10%10%10%10%10%10%10%10%10%10%10%
87
ARPU (purchases), USD
88
CisUSD4,04,04,04,04,54,54,54,55,05,05,05,05,05,05,05,0
89
EU/USAUSD0,00,00,00,08,08,08,08,09,09,09,09,010,010,010,010,0
90
Additional services for the user
91
Paying share , %
92
Cis%3%3%3%3%3%4%4%4%4%4%4%4%4%4%4%5%
93
EU/USA%0%0%0%0%4%4%4%4%4%4%4%4%4%4%5%5%
94
Average cost of monthly subscriptions for the user (chips, access, disabling advertising, etc.), USD/month
95
CisUSD2,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,0
96
EU/USAUSD0,00,00,00,03,03,03,03,03,03,03,03,03,03,03,03,0
97
ARPU (services), USD/quarter
98
CisUSD/quarter0,180,190,190,200,200,210,220,220,230,230,240,250,250,260,260,27
99
EU/USAUSD/quarter0,000,000,000,000,320,320,330,340,350,360,370,380,390,400,410,41
100
Advertising
101
Average eCPM for mobile devices
102
CisUSD3,03,03,03,03,03,03,03,03,03,03,03,03,03,03,03,0