The concept of the project is basic. If necessary, it can be easily adjusted, while all financial indicators of the project can be automatically recalculated using the attached model (see below "Features").

The implementation of the project is possible in any region of the Russian Federation; this business plan considers the option of opening a grocery store in the "near home" format in Moscow.

Project start: January 2019

Franchise: the model has a functionality that allows you to calculate the option of opening a store for a franchise; 2 schemes are considered as priority schemes of a franchise agreement: royalties and agency fees

Area: total 341 sq.m, including hall area - 250 sq.m (sales area - ... sq.m, checkout area - ... sq.m), warehouse - ... sq.m, administrative and utility rooms - ... sq.m

Departments and the share of their products in the total assortment: Grocery, tea, coffee (...%), Dairy products, eggs (...%), Household chemicals and household goods (...%), Baking, confectionery ( ...%), Meat and meat products (...%), Alcoholic beverages, beer (...%), Soft drinks and juices (...%), Tobacco, goods of dynamic demand (...%), Fish (...%), Frozen products (...%), Vegetables, fruits (2%), Preservation (...%), Products for animals (...%), Bread (...%)

Average check: 335 rubles.

Other income items of the grocery store: income from placing ATMs - ... thousand rubles / month, income from placing automatic machines for receiving payments - ... thousand rubles / month, income from the cashier area - ... thousand rubles / month. rub. for 1 sq. m / month, income from the sale of packages - ...

Card denominations for discounts: 1%, 3%, 5%

Credit: 30% of the investment budget, period - 2 years, rate - ...% / year, grace period for repayment of the principal debt - 6 months.

Staff: 17 people, organizational groups: administration, accounting, managers, cashiers, salesroom consultants, loaders, security

Working hours: daily, from 8:00 to 23:00

1) The grocery store business plan is developed in close collaboration with current executives and industry experts.

2) Financial calculations were carried out using Excel-model, which is a proprietary development of Inventica.

3) The financial model is 100% automated
• Values of project parameters can be changed.
• The total number of parameters entered into the financial model is more than 1100 (month of the start of the project, list and cost of obtaining permits, area of premises, specification of equipment and its cost, staffing, number of buyers, average bill, franchise conditions (flat fee, royalty or agency remuneration), lending parameters, etc.).
• Changing any of the project parameters leads to automatic recalculation of the model.
• The required amount of equipment is calculated automatically based on the area of departments, assortment and the planned number of customers
• The ability to quickly recalculate allows you to independently calculate various strategies and scenarios for the development of your business, even if you do not know the basics of financial modeling and investment management.

Thus, you get a universal decision-making tool, with the help of which you can correct the concept of the project, choosing the optimal values of the parameters of your future business.

The financial model is attached to the report.

Detailed information about the capabilities of the financial model of Inventica is presented in the Demo version .

Chapter 1. INTRODUCTION 11

Intellectual property rights

article 11

Risk and responsibility level when drawing up a business plan 11

Chapter 2. SUMMARY OF THE PROJECT 12

The essence of the project, description of activities 12

Main objectives of the project 13

Financial prospects and main indicators of the project 14

Chapter 3. LEGAL ISSUES 15

Organizational and legal form 15

Company registration 16

Obtaining permits 17

Constituent documents of a legal entity 17

Examination of the premises by Rospotrebnadzor 20

Business start notification 21

Registration of sanitary documentation 22

Registration of documents of the State Fire Inspection 23

Registration KKM 24

Alcohol retail license 25

Connection to EGAIS 28

Product certification 29

Trade Permit 29

Sign Permit 29

Redevelopment approval 31

Legal budget 36

Chapter 4. MARKETING RESEARCH 38

The current state of the Russian economy 42

Russian retail market 42

Market volume and dynamics 42

Market structure 43

Non-food retail market 48

Grocery retail formats in the Russian Federation 51

Supply of retail space 52

Competitive market environment 55

Change in consumer behavior 58

Analysis of trading formats 58

Cash & Carry 58

Format specification 62

Comparative characteristics of ry players

Ka 63

Hypermarket 63

General characteristics of format 65

Trade area 67

Total area 67

Assortment width 68

Average check 68

Comparative characteristics of market players 70

Supermarket 70

Format Definition 71

Area 72

Range of assortment 72

Average check and markup 73

Income 74

Generalized characteristics of format 75

Comparative characteristics of market players 76

Discounter 76

Format specifics (organization principles) 79

Sales area and assortment width 80

Average check and markup 80

Location 81

Competitive Environment 82

Generalized characteristic form

a 82

Comparative characteristics of market participants 84

Convenience store 84

Features of the 86 format

Target audience 87

Trade area 87

Range of assortment 88

Pricing 88

General characteristics of format 89

Comparative characteristics of market players 89

Analysis of the profitability of stores of various formats 91

Chapter 5. FRANCHISING PROGRAMS 96

Overview of the main programs for franchising 96

"CROSSROADS EXPRESS" 96

"CROSSROADS" 99

"PYATEROCHKA" 101

"BEAN" 103

Chapter 5. PROJECT CONCEPT 105

The essence of the project 105

Selecting a location 106

Choosing the Right Room 107

Compliance with requirements for interior decoration 108

Organization of premises and area parameters 109

Warehouse 111

Trading floor 115

Ancillary, office and household premises 117

Water supply and sewerage 117

Heating and ventilation 119

Lighting 120

Disinfection 120

Equipment 122

Reception and storage of food 122

Transport of products 126

Working conditions of store employees 127

Chapter 6. MARKETING STRATEGY 129

Marketing objectives of the project 129

Convenience store scale 129

Pricing policy 130

Advertising policy 130

Chapter 8. INVESTMENT STAGE OF THE PROJECT 131

Concept and business plan development 133

Selection of premises 133

Technological and design engineering 135

Repairs 137

Purchase and installation of equipment 139

Warehouse equipment 139

Sales area equipment 140

Store Operation Automation Equipment 147

Equipment for utility rooms 148

Recruiting 149

Advertising and Promotion 149

Getting a loan 150

Carrying out telecommunications 150

Telephone line 150

Security and fire alarm 151

Purchase of Products 152

Household expenses 152

Contingencies 152

Investment Stage 153 Cost Budget

Financing the costs of the investment stage 153

Chapter 9. OPERATIONAL STAGE OF THE PROJECT 154

Organizational structure 154

The main items of expenses of the operational phase 155

Community expenses 155

Electricity 155

Heating 155

Water supply 155

Resource Consumption Cost 156

Telephony and Internet communications 156

Garbage collection 157

Rental expenses 158

Equipment repair costs 158

Insurance expenses 158

Advertising costs 159

Purchase of goods 160

Wages fund 161

Other expenses 161

Operating Expenditure Budget 161

Borrowed funds 162

Main items of income of the operational phase 164

Operating Revenue Budget 165

Chapter 10. FINANCIAL PLAN 167

Conditions and assumptions 167

Inflation 167

Tax environment 168

Profit and Loss Statement 169

Cash flow statement 170

Tax budget 171

Chapter 11. ASSESSMENT OF PROJECT PERFORMANCE 172

Structure of operating expenses 172

Profitability Analysis 172

Net profit 172

NPV, payback period and IRR of the project 175

Project cost 176

Break-even point of the project 176

Key investment and financial indicators of the project 178

Chapter 12. RISK ANALYSIS 179

HR risks 179

Risks of interaction with suppliers 179

Technological risks 180

Organizational risks 181

Financial risks 182

Market risks 183

Circumstances of force majeure (force majeure) 185

List of tables

Table 1. Main investment and financial indicators of the project 14

Table 2. Investment budget for registration of permits and licenses for the project, thousand RUR 36

Table 3. Indicators of the retail market for food, alcohol and tobacco, 2008-2016 47

Table 4. Comparative characteristics of trade formats by main classification parameters 49

Table 5. TOP-10 companies in the food retail market, 2016-2017 52

Table 6. Characteristics of the "Cash & Carry" format 59

Table 7. Comparative characteristics of networks operating in the "Cash & Carry" format 62

Table 8. Characteristics of the "hypermarket" format 64

Table 9. Comparative characteristics of chains operating in the hypermarket format 68

Table 10. Characteristics of the "supermarket" format 74

Table 11. Comparative characteristics of chains operating in the "supermarket" format 75

Table 12. Characteristics of the "discounter" format 82

Table 13. Comparative characteristics of the networks operating in the discounter format 83

Table 14. Characteristics of the “convenience store” format 89

Table 15. Comparative characteristics of networks operating in the "near home" format 90

Table 16. Operating indicators of "Lenta", 2012-2017 91

Table 17. Operating indicators "OK", 2012-2017 92

Table 18. Operating indicators of PJSC "Magnet", 2013-2017 93

Table 19. Operating indicators of X5 Retail Group, 2013-2017 94

Table 20. Investments for opening a Perekrestok Express store for a franchise 97

Table 21. Basic parameters for calculating the income of the Perekrestok Express store, opened under a franchise 98

Table 22. Income and expenses of the Perekrestok Express store, opened under a franchise 98

Table 23. Technical requirements for the premises "Crossroads" 99

Table 24. Investment and operating parameters of the Perekrestok franchise 99

Table 25. Financial indicators of the Perekrestok franchise 100

Table 26. Technical requirements for the premises "Pyaterochka" 102

Table 27. Main financial and economic indicators of the Pyaterochka franchise 102

Table 28. Investment and operating parameters of the Pyaterochka franchise 102

Table 29. Income and expenses of the Pyaterochka store, opened under a franchise 102

Table 30. Parameters of the shop "Beans" 104

Table 31. Income and expenses of the Bean store, opened under a franchise 104

Table 32. Main parameters of the concept of "convenience store" 105

Table 33. Estimated number of unloading places 111

Table 34. Specific indicators of the minimum area of non-commercial premises of grocery stores 114

Table 35. Standards for the width of the aisles between equipment in the sales areas of stores (according to MGSN 4.13-97 "Retail enterprises") 116

Table 36. The cost of repairing grocery stores, thousand RUR / sq. m 138

Table 37. The cost of repair and construction work 138

Table 38. Costs of installing the climate system and ventilation 138

Table 39. Investment costs for the purchase of warehouse equipment 139

Table 40. Dimensions of warehouse rack 139

Table 41. Refrigerating equipment of the sales area 140

Table 42. Shelves of the sales area 142

Table 43. Checkout counters 142

Table 44. Other equipment of the sales area 144

Table 45. Use of equipment in departments 146

Table 46. Equipment for automating the activities of a convenience store 147

Table 47. Equipment for utility rooms 148

Table 48. Plumbing equipment 149

Table 49. Marketing activities of the investment stage 150

Table 50. Budget of expenses of the investment stage 152

Table 51. Financing of the investment stage of the project (in thousand rubles) 153

Table 52. Number of staff at the convenience store 154

Table 53. Parameters for calculating water consumption 156

Table 54. Cost of the main types of resources (thousand rubles) 156

Table 55. Expenses for telecommunications, thousand rubles. 157

Table 56. Expenses for garbage disposal, thousand rubles. 158

Table 57. Parameters for calculating the cost of repairing equipment 158

Table 58. Equipment insurance costs 159

Table 59. Share of customers - holders of discount cards 160

60. Advertising and promotion expenses, thousand rubles. 160

Table 61. Convenience store staffing 161

Table 62. Operating budget of expenses, thousand rubles. 162

Table 63. Payments for loan repayment 163

Table 64. Seasonality of sales 164

Table 65. Indicators of implementation 164

Table 66. Parameters for calculating additional commercial income of the store 165

Table 67. Operating budget of income, thousand rubles. 166

Table 68. Inflation rates 167

Table 69. Rates of main taxes 168

Table 70. Rates of contributions to state extra-budgetary funds 168

Table 71. Forecast of changes in marginal wages used in calculating the amount of insurance payments for the period 2019-2023, thousand RUR 169

Table 72. Profit and loss statement (in thousand rubles) 169

Table 73. Statement of cash flows (in thousand rubles) 170

Table 74. Budget of tax payments (in thousand rubles) 171

Table 75. Profitability of activities 172

Table 76. Initial data for calculating the cost of equity capital 174

Table 77. Calculation of WACC 175

Table 78. Calculation of the NPV of the project excluding the payment of interest on the loan, thousand rubles. 175

Table 79. Calculation of NPV + TV 176

Table 80. Main investment and financial indicators of the project 178

Table 81. Change in key indicators with an increase in the investment stage by 1 month 181

Table 82. Change in key indicators when the investment budget is exceeded by 1% 183

Table 83. Change in key indicators with a decrease in the planned sales volume 185

List of charts

Diagram 1. Structure of retail trade turnover by type of goods in value terms, 2008-2017 43

Diagram 2. Structure of retail trade in food products 45

Diagram 3. Structure of sales of alcoholic beverages in natural terms, 2008-2016 46

Diagram 4. Structure of sales of basic food products to the population in value terms, billion rubles, 2017 47

Chart 5. Structure of the grocery retail market by store formats in value terms, 2017, 2020F 50

Diagram 6. Structure of retail space by types of cities 51

Diagram 7. Left - Answer to the question "Which point of view is closer to you: in chain supermarkets and stores prices are lower and higher than in non-chain stores? To the right - Answer to the question" Which point of view is closer to you: chain supermarkets and shops give various discounts, promotions or rarely make discounts, hold few promotions with lower prices for products? 56

Diagram 8. Structure of hypermarket retail space by chains, 2017 66

Diagram 9. Structure of supermarket retail space by chains, 2017 72

Diagram 10. Structure of investment costs for opening a convenience store 153

Chart 11. Structure of operating expenses 172

List of charts

Graph 1. Real GDP growth in Russia (YoY),% 38

Chart 2. Dynamics of inflation and the key rate of the Central Bank of the Russian Federation,% 39

Graph 3. Dynamics of the exchange rate, RUB / USD US 39

Chart 4. Yield on government dollar bonds 40

Chart 5. Yield on ten-year government bonds and capitalization rate for premium commercial real estate 40

Chart 6. Volume of investments in commercial real estate / capital outflow 41

Chart 7. Dynamics of the price of Brent crude oil and the US dollar rate 41

Graph 8. Dynamics of retail trade turnover in the Russian Federation, 2008-2017 42

Schedule 9. Dynamics of retail trade in food products in the Russian Federation, 2008-2017 44

Chart 10. The share of modern trade formats on the market in the Russian Federation and other countries, 2017 48

Chart 11. Comparison of the level of development of the retail market in the Russian Federation with other countries 51

Schedule 12. Comparison of the dynamics of the TOP-10 development with the general rate of development of the food retail market, 2013-2017. 53

Graph 13. Comparison of the share of TOP-5 market players in the Russian Federation and other countries, 2017 54

Chart 14. Structure of the grocery retail market by types of chains, 2014-2017, 2020F 55

Graph 15. Distribution of answers to the question "Where does your family buy food most often?" (no more than 2 answers), 2016 56

Graph 16. Distribution of answers to the question "Where does your family buy food to save money?" (No more than 2 answers), 2016 57

Graph 17. Dynamics of the consumer confidence index of the population of the Russian Federation, 2011-2018 58

Chart 18. Dynamics of Metro revenue in Russia, sq. 2016-2018 61

Chart 19. Structure of Magnit's revenue by retail-wholesale formats, 2014-2017 62

Chart 20. Distribution of hypermarkets by retail space (min and max) and by share of retail space in the total, 2010 66

Chart 21. Distribution of hypermarkets by total area (min and max) 67

Schedule 22. Distribution of hypermarkets by assortment width, share of non-food products and SKU / sqm. 67

Schedule 23. Supermarket selling space (min and max) 71

Schedule 24. Trade area of discounters 79

Chart 25. Width of the assortment of discounters and SKUs / sq.m. 79

Schedule 26. Sales area of convenience stores (min and max) 87

Schedule 27. Width of Convenience Store Assortment and SKU / sqm. retail space 87

Chart 28. Change in sales, traffic, average check for comparable Lenta stores, 2017/2016 91

Chart 29. Change in sales, traffic, average check for comparable O'Key stores, 2017/2016 92

Chart 30. Change in sales, traffic, average check for comparable stores of PJSC "Magnita", 2017/2016 93

Chart 31. Change in sales, traffic, average check for comparable stores X5 Retail Group, 2017/2016 94

Chart 32. Change in sales, traffic, average check for comparable Dixy stores, 2017/2016 95

Schedule 33. Income, expenses and net profit for the project 173

Schedule 34. Cumulative net profit for the project 173

Chart 35. Cash flow and NPV on a cumulative basis (excluding interest payments on the loan) 175

Schedule 36. Dependence of NPV (excluding payment of% on the loan) on the volume of sales 177

Schedule 37. Dependence of net profit on the volume of sales of services 177

List of figures

Figure 1. Concentration of stores of modern formats by constituent entities of the Russian Federation 52

Figure 2. Schedule of implementation of the investment stage of the project 132