| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 месяц | 2 месяц | 3 месяц | 4 месяц | 5 месяц | 6 месяц | 7 месяц | 8 месяц | 9 месяц | 10 месяц | 11 месяц | 12 месяц | ГОД | ||||||
2 | |||||||||||||||||||
3 | Трафик | 15,000 | 25,500 | 22,000 | 33,000 | 32,175 | 37,001 | 42,551 | 48,934 | 56,274 | 64,715 | 74,423 | 85,586 | ||||||
4 | CR в лид | 2% | |||||||||||||||||
5 | Лиды | 300.0 | 510.0 | 440.0 | 660.0 | 643.5 | 740.0 | 851.0 | 978.7 | 1,125.5 | 1,294.3 | 1,488.5 | 1,711.7 | 10,743.2 | |||||
6 | CR в продажу | 15% | 10% | 10% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 25.0% | ||||
7 | Рост продаж в мес (общий) | 15% | 120% | 50% | 50% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | ||||||
8 | Всего продажи | 30.0 | 66.0 | 99.0 | 148.5 | 170.8 | 196.4 | 225.8 | 259.7 | 298.7 | 343.5 | 395.0 | 454.3 | 2,687.7 | |||||
9 | Новые продажи | 30.0 | 51.0 | 66.0 | 99.0 | 96.5 | 111.0 | 127.7 | 146.8 | 168.8 | 194.1 | 223.3 | 256.8 | ||||||
10 | Повторные продажи | 50% | 15.0 | 33.0 | 49.5 | 74.3 | 85.4 | 98.2 | 112.9 | 129.9 | 149.3 | 171.7 | 197.5 | ||||||
11 | Средний чек | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | |||||
12 | |||||||||||||||||||
13 | Выручка | 300,000.00 | 660,000.00 | 990,000.00 | 1,485,000.00 | 1,707,750.00 | 1,963,912.50 | 2,258,499.38 | 2,597,274.28 | 2,986,865.42 | 3,434,895.24 | 3,950,129.52 | 4,542,648.95 | 26,876,975 | |||||
14 | |||||||||||||||||||
15 | Себестоимость | 40% | -150,000.00 | -330,000.00 | -445,500.00 | -594,000.00 | -683,100.00 | -785,565.00 | -903,399.75 | -1,038,909.71 | -1,194,746.17 | -1,373,958.09 | -1,580,051.81 | -1,817,059.58 | |||||
16 | Управл расходы | 10% | -30,000.00 | -66,000.00 | -99,000.00 | -148,500.00 | -170,775.00 | -196,391.25 | -225,849.94 | -259,727.43 | -298,686.54 | -343,489.52 | -395,012.95 | -454,264.90 | |||||
17 | Расходы на рекламу (трафик) | 10% | -30,000.00 | -66,000.00 | -99,000.00 | -148,500.00 | -170,775.00 | -196,391.25 | -225,849.94 | -259,727.43 | -298,686.54 | -343,489.52 | -395,012.95 | -454,264.90 | |||||
18 | Расходы на маркетинг | 10% | -60,000.00 | -132,000.00 | -148,500.00 | -148,500.00 | -170,775.00 | -196,391.25 | -225,849.94 | -259,727.43 | -298,686.54 | -343,489.52 | -395,012.95 | -454,264.90 | |||||
19 | Расходы на продажи | 5% | -15,000.00 | -33,000.00 | -49,500.00 | -74,250.00 | -85,387.50 | -98,195.63 | -112,924.97 | -129,863.71 | -149,343.27 | -171,744.76 | -197,506.48 | -227,132.45 | |||||
20 | |||||||||||||||||||
21 | Операционная прибыль | 15,000.00 | 33,000.00 | 148,500.00 | 371,250.00 | 426,937.50 | 490,978.13 | 564,624.84 | 649,318.57 | 746,716.36 | 858,723.81 | 987,532.38 | 1,135,662.24 | ||||||
22 | Рентабельность | 5.0% | 5.0% | 15.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | ||||||
23 | |||||||||||||||||||
24 | Налоги | 6.0% | -18,000.00 | -39,600.00 | -59,400.00 | -89,100.00 | -102,465.00 | -117,834.75 | -135,509.96 | -155,836.46 | -179,211.93 | -206,093.71 | -237,007.77 | -272,558.94 | |||||
25 | Кредиты | 0.5% | -3,300.00 | -4,950.00 | -7,425.00 | -8,538.75 | -9,819.56 | -11,292.50 | -12,986.37 | -14,934.33 | -17,174.48 | -19,750.65 | -22,713.24 | ||||||
26 | Амортизация | 0.5% | -1,500.00 | -3,300.00 | -4,950.00 | -7,425.00 | -8,538.75 | -9,819.56 | -11,292.50 | -12,986.37 | -14,934.33 | -17,174.48 | -19,750.65 | -22,713.24 | |||||
27 | |||||||||||||||||||
28 | Чистая прибыль/убыток | -4,500.00 | -13,200.00 | 79,200.00 | 267,300.00 | 307,395.00 | 353,504.25 | 406,529.89 | 467,509.37 | 537,635.78 | 618,281.14 | 711,023.31 | 817,676.81 | 4,548,356 | |||||
29 | Рентабельность по чистой прибыли | -1.5% | -2.0% | 8.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | ||||||
30 | |||||||||||||||||||
31 | Дивиденды | 30% | -23,760.00 | -80,190.00 | -92,218.50 | -106,051.28 | -121,958.97 | -140,252.81 | -161,290.73 | -185,484.34 | -213,306.99 | -245,303.04 | -1,369,817 | ||||||
32 | |||||||||||||||||||
33 | |||||||||||||||||||
34 | |||||||||||||||||||
35 | cpc | -2.00 | -2.59 | -4.50 | -4.50 | -5.31 | -5.31 | -5.31 | -5.31 | -5.31 | -5.31 | -5.31 | -5.31 | ||||||
36 | cpl | -100.00 | -129.41 | -225.00 | -225.00 | -265.38 | -265.38 | -265.38 | -265.38 | -265.38 | -265.38 | -265.38 | -265.38 | ||||||
37 | cpo | новые продажи | -1,000.00 | -1,294.12 | -1,500.00 | -1,500.00 | -1,769.23 | -1,769.23 | -1,769.23 | -1,769.23 | -1,769.23 | -1,769.23 | -1,769.23 | -1,769.23 | |||||
38 | cac | новые продажи | -3,500.00 | -4,529.41 | -4,500.00 | -3,750.00 | -4,423.08 | -4,423.08 | -4,423.08 | -4,423.08 | -4,423.08 | -4,423.08 | -4,423.08 | -4,423.08 | |||||
39 | |||||||||||||||||||
40 | |||||||||||||||||||
41 | |||||||||||||||||||
42 | |||||||||||||||||||
43 | |||||||||||||||||||
44 | |||||||||||||||||||
45 | |||||||||||||||||||
46 | |||||||||||||||||||
47 |