Dashboard
DemoPresentation mode
Sales Table
Year 1
Year 2
Year 3
Metric
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
Total
New Sales
–
–
–
–
–
–
680
2K
3K
3K
3K
3K
3K
3K
3K
3K
4K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
3K
89,175
Market Saturation
100%
100%
100%
100%
100%
100%
100%
100%
100%
99%
99%
99%
99%
99%
99%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
98%
97%
97%
97%
97%
98%
Base at Start
–
–
–
–
–
–
–
680
3K
5K
8K
12K
15K
18K
22K
25K
29K
32K
36K
39K
42K
45K
48K
51K
54K
57K
60K
63K
66K
69K
72K
75K
77K
80K
83K
86K
86,243
Total Clients
–
–
–
–
–
–
680
3K
5K
8K
12K
15K
18K
22K
25K
29K
32K
36K
39K
42K
45K
48K
51K
54K
57K
60K
63K
66K
69K
72K
75K
77K
80K
83K
86K
89K
89,174
Active at Start
–
–
–
–
–
–
–
510
2K
3K
4K
4K
5K
6K
6K
7K
7K
8K
8K
8K
8K
9K
9K
9K
9K
10K
10K
10K
11K
11K
11K
11K
12K
12K
12K
13K
12,665
Churn
–
–
–
–
–
–
–
306
889
1K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
53,909
Active at End
–
–
–
–
–
–
510
2K
3K
4K
4K
5K
6K
6K
7K
7K
8K
8K
8K
8K
9K
9K
9K
9K
10K
10K
10K
11K
11K
11K
11K
12K
12K
12K
13K
13K
12,971
Expenses Table
Year 1
Year 2
Year 3
Expense Item
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
Total
Operational Expenses
1.6M
1.6M
1.6M
1.6M
1.6M
1.6M
5.8M
11.3M
15.9M
17.1M
18.4M
18.5M
18.7M
19.1M
19.5M
19.6M
19.9M
19.3M
18.8M
18.3M
18.1M
17.9M
17.7M
17.7M
17.8M
17.9M
17.9M
18.0M
18.0M
18.1M
18.1M
18.2M
18.2M
18.3M
18.3M
18.4M
538,365,460 ₽
Acquisition Channels
–
–
–
–
–
–
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
1.7M
51,825,000 ₽
Team Payroll
2.3M
2.3M
3.1M
3.4M
3.4M
3.9M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
4.2M
145,629,900 ₽
Fraud Losses
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
0 ₽
Total Expenses
3.9M
3.9M
4.7M
5.0M
5.0M
5.5M
11.7M
17.3M
21.9M
23.1M
24.4M
24.5M
24.7M
25.0M
25.4M
25.6M
25.9M
25.3M
24.8M
24.3M
24.0M
23.9M
23.7M
23.7M
23.8M
23.8M
23.9M
23.9M
24.0M
24.0M
24.1M
24.1M
24.2M
24.2M
24.3M
24.4M
735,820,360 ₽
Income Table
Year 1
Year 2
Year 3
Income Item
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12
Total
Абонентская плата
–
–
–
–
–
–
459K
1.4M
2.5M
3.3M
4.0M
4.6M
5.1M
5.6M
6.0M
6.4M
6.8M
7.1M
7.3M
7.5M
7.8M
8.0M
8.2M
8.4M
8.7M
8.9M
9.2M
9.5M
9.7M
10.0M
10.3M
10.6M
10.8M
11.1M
11.4M
11.7M
222,669,227 ₽
Аренда оборудования
–
–
–
–
–
–
102K
320K
566K
737K
900K
1.0M
1.1M
1.2M
1.3M
1.4M
1.5M
1.6M
1.6M
1.7M
1.7M
1.8M
1.8M
1.9M
1.9M
2.0M
2.0M
2.1M
2.2M
2.2M
2.3M
2.3M
2.4M
2.5M
2.5M
2.6M
49,482,050 ₽
Премиум-тарифы (повышенная скорость)
–
–
–
–
–
–
76K
240K
425K
553K
675K
766K
848K
926K
1.0M
1.1M
1.1M
1.2M
1.2M
1.3M
1.3M
1.3M
1.4M
1.4M
1.4M
1.5M
1.5M
1.6M
1.6M
1.7M
1.7M
1.8M
1.8M
1.9M
1.9M
1.9M
37,111,538 ₽
Дополнительные сервисы (IPTV, VPN)
–
–
–
–
–
–
51K
160K
283K
369K
450K
511K
565K
617K
668K
714K
759K
790K
815K
838K
862K
886K
909K
937K
965K
994K
1.0M
1.1M
1.1M
1.1M
1.1M
1.2M
1.2M
1.2M
1.3M
1.3M
24,741,025 ₽
Total Income
–
–
–
–
–
–
688K
2.2M
3.8M
5.0M
6.1M
6.9M
7.6M
8.3M
9.0M
9.6M
10.2M
10.7M
11.0M
11.3M
11.6M
12.0M
12.3M
12.6M
13.0M
13.4M
13.8M
14.2M
14.6M
15.0M
15.4M
15.9M
16.3M
16.7M
17.1M
17.5M
334,003,841 ₽
Average Monthly Turnover
| Metric | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Sales | 1,254 | 3,237 | 2,940 |
| Active Clients | 1,519 | 7,801 | 11,297 |
Results Summary
Total Sales
89K
12,971 active
Total Income
334.0 M
Total Cost
735.8 M
Net Income
-401.8 M
Unit Economics
CAC
581 ₽
Weighted average Customer Acquisition Cost = total channel spend / total customers acquired
CPA
581 ₽
Cost per Client Acquisition
ARPU
1K ₽/mo.
Average Revenue Per User
ARPPU
1K ₽/mo.
Revenue per paying user (= ARPU, no free tier)
LTV
-8K ₽
Customer Lifetime Value
LTV : CAC
-14.2 x
Critical (<1)
CAC Payback
Months to recover customer acquisition cost
Payback Period
Discounted project payback period
Key Metrics
Active Clients
+8%
13K
Income / mo.
+8%
17.5 M ₽
Net Income / mo.
+13%
-6.8 M ₽
Total for period
-401.8 M ₽
Investments
NPV
-314.0 M ₽
IRR
N/A
Breakeven
N/A
Profitability Index
0 x
Market Size
TAM
57,000,000 users
≈ 923,400,000,000 ₽ / year
SAM
15,000,000 users
≈ 243,000,000,000 ₽ / year
SOM
400,000 users
≈ 6,480,000,000 ₽ / year
Market Penetration
TAM
0.02%
12,971 / 67,559,065
SAM
0.07%
12,971 / 17,778,701
SOM
2.74%
12,971 / 474,099
Saturation Factor97%
Cumulative P&L
Margins
Gross Operating Net
P&L Flows
Profit: -401,816,519 ₽
Acquisition Channels
- VK Таргет
- Контекстная реклама (ШПД запросы)
- Партнёры (застройщики, УК)
- Прямые продажи (door-to-door)
- Реферальная программа
- Розничные точки
- Яндекс Директ
CAC by Channel
Прямые продажи0 ₽
33390 sales · channel: 0 · payroll: 0
Партнёрства0 ₽
33767 sales · channel: 0 · payroll: 0
Цифровой маркетинг2,192 ₽
23645 sales · channel: 51,825,000 · payroll: 0
Average CAC571 ₽
Income Structure (Year 1)
Абонентская плата16,410,177 ₽
Аренда оборудования3,646,706 ₽
Премиум-тарифы (повышенная скорость)2,735,029 ₽
Дополнительные сервисы (IPTV, VPN)1,823,353 ₽
Total24,615,265 ₽
Expense Structure (Year 1)
Operational Expenses96,574,339 ₽
Acquisition Channels10,365,000 ₽
Team Payroll43,861,500 ₽
Fraud Losses
Total150,800,839 ₽
Income & Expense Trends
- Balance
- Cumulative Profit
- Expenses
- Income
Sales Trends
- Active Clients
- Churn
- New Sales
- Total Clients
Yearly P&L
Year 1
-126.2 M
5,105 clients
Year 2
-170.0 M
9,367 clients
Year 3
-105.7 M
12,971 clients
Yearly Forecast
| Metric | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Sales | 15,052 | 38,844 | 35,279 |
| Active Clients | 5,105 | 9,367 | 12,971 |
| Income per Client | 1,350 ₽ | 1,350 ₽ | 1,350 ₽ |
| Total Income | 24,615,265 ₽ | 126,378,586 ₽ | 183,009,989 ₽ |
| Total Expenses | 150,800,839 ₽ | 296,338,580 ₽ | 288,680,941 ₽ |
| Partner Share | |||
| Net Income | -126,185,574 ₽ | -169,959,993 ₽ | -105,670,952 ₽ |
Sales Timeline
Total Sales
89,175 clients
Active (end)
12,971 clients
Churn
53,909 clients
Activation
75%
Income vs Expenses
Income Expenses