Branch Break-Even & New Store Feasibility – Free Excel Template for Retail Stores
How much must you sell every day just to cover the rent? Enter each branch's (or planned store's) fixed monthly costs – rent, salaries, generator & electricity, other – and its gross margin %. The...
How much must you sell every day just to cover the rent? Enter each branch’s (or planned store’s) fixed monthly costs – rent, salaries, generator & electricity, other – and its gross margin %. The sheet calculates the monthly and DAILY sales needed to break even, compares it with actual sales and shows your safety margin.
Table Of Content

Why it matters
In a clothing, perfume or grocery store, profit is decided by small numbers: a few thousand dinars missing from the drawer every day, a supplier invoice paid twice, a discount that eats the whole margin. Stores that write these numbers down every day see problems weeks earlier and make calmer decisions.
What’s inside the template
You fill in: Branch / Location, Store Type, Rent / month, Salaries / month, Generator & Power, Other Fixed Costs, Gross Margin %, Open Days / month, Actual Sales / month.
Calculated automatically:
- Total Fixed Costs
- Break-even Sales / month
- Break-even Sales / day
- Monthly Profit
- Safety Margin %
- Result
How to use it, step by step
- One row per branch – or per location you are studying before signing a lease.
- Gross margin % = (sales – cost of goods) ÷ sales, e.g. 45% clothing, 15% grocery.
- Daily break-even uses the number of open days you enter (e.g. 30).
- Safety margin under 10% = Near break-even; negative = Losing money.
The dashboard: numbers to watch
- Total fixed costs / month
- Total break-even sales / month
- Total actual sales / month
- Total monthly profit
- Branches losing money
Summary tables: Branches by result.
Example from the template
| Branch / Location | Store Type | Monthly Profit | Safety Margin % | Result |
|---|---|---|---|---|
| Baghdad Mall | Clothing | 8,900,000 | 24.1% | Profitable |
| Karbala | Perfume | 250,000 | 2.6% | Near break-even |
| New: Iraq Mall (study) | Clothing | -1,000,000 | -3.2% | Losing money |
Download the template free
Free, no registration. Two versions: English and Arabic (right-to-left). Works in Excel, Google Sheets and WPS.
Browse all 60 templates in the ProSite Library
Related templates
Need help running your store?
ProSite fits out, opens and runs retail stores in Baghdad and Erbil – store fit-out, visual merchandising, operations teams, IT setup and manager training. Call or WhatsApp us on +964 780 930 9998.




No Comment! Be the first one.