Шаблон_финмодели_опт-розница.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Суммы в EUR	Янв	Фев	Мар	Апр	Май	Июн	Июл	Авг	Сен	Окт	Ноя	Дек	Год
3	период	2025-01	2025-02	2025-03	2025-04	2025-05	2025-06	2025-07	2025-08	2025-09	2025-10	2025-11	2025-12	2025

4	ВЫРУЧКА
5	Выручка опт	336,000	336,000	384,000	384,000	384,000	432,000	384,000	384,000	432,000	432,000	432,000	480,000	4,800,000
6	Выручка розница	168,000	168,000	192,000	192,000	192,000	216,000	192,000	192,000	216,000	216,000	216,000	240,000	2,400,000
7	Выручка итого	504,000	504,000	576,000	576,000	576,000	648,000	576,000	576,000	648,000	648,000	648,000	720,000	7,200,000
8
9	СЕБЕСТОИМОСТЬ
10	Себестоимость опт	(275,520)	(275,520)	(314,880)	(314,880)	(314,880)	(354,240)	(314,880)	(314,880)	(354,240)	(354,240)	(354,240)	(393,600)	(3,936,000)
11	Себестоимость розница	(114,240)	(114,240)	(130,560)	(130,560)	(130,560)	(146,880)	(130,560)	(130,560)	(146,880)	(146,880)	(146,880)	(163,200)	(1,632,000)
12	Себестоимость итого	(389,760)	(389,760)	(445,440)	(445,440)	(445,440)	(501,120)	(445,440)	(445,440)	(501,120)	(501,120)	(501,120)	(556,800)	(5,568,000)
13	Валовая прибыль	114,240	114,240	130,560	130,560	130,560	146,880	130,560	130,560	146,880	146,880	146,880	163,200	1,632,000
14	Валовая маржа, %	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%	22.7%
15
16	ОПЕРАЦИОННЫЕ РАСХОДЫ
17	Аренда	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(18,000)	(216,000)
18	ФОТ	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(65,000)	(780,000)
19	Прочие постоянные	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(8,000)	(96,000)
20	Логистика	(15,120)	(15,120)	(17,280)	(17,280)	(17,280)	(19,440)	(17,280)	(17,280)	(19,440)	(19,440)	(19,440)	(21,600)	(216,000)
21	Маркетинг	(10,080)	(10,080)	(11,520)	(11,520)	(11,520)	(12,960)	(11,520)	(11,520)	(12,960)	(12,960)	(12,960)	(14,400)	(144,000)
22	Опер. расходы итого	(116,200)	(116,200)	(119,800)	(119,800)	(119,800)	(123,400)	(119,800)	(119,800)	(123,400)	(123,400)	(123,400)	(127,000)	(1,452,000)
23	EBITDA	(1,960)	(1,960)	10,760	10,760	10,760	23,480	10,760	10,760	23,480	23,480	23,480	36,200	180,000
24	EBITDA, %	-0.4%	-0.4%	1.9%	1.9%	1.9%	3.6%	1.9%	1.9%	3.6%	3.6%	3.6%	5.0%	2.5%
25
26	Амортизация	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(60,000)
27	EBIT	(6,960)	(6,960)	5,760	5,760	5,760	18,480	5,760	5,760	18,480	18,480	18,480	31,200	120,000
28	Проценты	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(3,333)	(40,000)
29	Прибыль до налога	(10,293)	(10,293)	2,427	2,427	2,427	15,147	2,427	2,427	15,147	15,147	15,147	27,867	80,000
30	Налог на прибыль	1,853	1,853	(437)	(437)	(437)	(2,726)	(437)	(437)	(2,726)	(2,726)	(2,726)	(5,016)	(14,400)
31	Чистая прибыль	(8,441)	(8,441)	1,990	1,990	1,990	12,420	1,990	1,990	12,420	12,420	12,420	22,851	65,600
32	Чистая маржа, %	-1.7%	-1.7%	0.3%	0.3%	0.3%	1.9%	0.3%	0.3%	1.9%	1.9%	1.9%	3.2%	0.9%
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