5-Year Store Opening Plan Summary Excel Model
Originally published: 05/08/2020 17:03
Publication number: ELQ-12230-1
View all versions & Certificate

5-Year Store Opening Plan Summary Excel Model

5-Year Store Opening Plan Template in Microsoft Excel.

You need an income-expense guide for a store that you open abroad or in your own country. In other words, a business plan is required at store openings. With the help of this template, you will know how/what to spend on new stores.

You will also have access to the planned sales information of the stores.

In this template you can show the following information:
- the number of stores planned to be opened by years,
- planned capital expenditures,
- store areas,
- information on rental expenses to be paid per square meter.

Information like Sales Revenues, COGS, Margin, EBITDA, different kinds of Expenses, Profit, Ratios, etc. can be shown in template.

When the fields in the template are filled, a series of financial analyzes like sales, cost and other comparisons by year will be done.

Costs, sales revenues, profits, office expenses, and so on can be written numerically as well as calculated as interest.

In the template, it is seen that percentages of office expenses over total sales revenues are calculated.

These types of calculations can be done based upon other expenses like consumables, packaging materials, utilities, etc.

The most important feature of the template is that it is plain and easy to understand.

The figures are written as an example in this template.

Good luck.

This Best Practice includes
1 Microsoft Excel File

Ilgar Zarbaliyev offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

The goal of this template is to give the other party a brief overview of what you will do in the next 5 years, while obtaining franchising rights from a company abroad.

New Store Openings

Production Establishments Opening

4.7 / 5 (9 votes)

please wait...