Employees: 11 (2023.0)Legal category: Société à responsabilité limitée (sans autre indication)Size: PMECreation date: 2010-03-03 (16 years)Status: ActiveBusiness sector: SupermarchésLocation: STRASBOURG (67100), Bas-Rhin
QUEMALLYS CITY : revenue, balance sheet and financial ratios
QUEMALLYS CITY is a French company
founded 16 years ago,
specialized in the sector Supermarchés.
Based in STRASBOURG (67100),
this company of category PME
shows in 2018 a revenue of 3.4 M€.
Find below the complete financial statements, solvency ratios, working capital requirements and sector comparison.
Financial history - QUEMALLYS CITY (SIREN 521050724)
Indicator
2018
2017
2016
2015
2014
Revenue
3 440 859 €
3 341 516 €
3 262 658 €
3 312 510 €
3 274 595 €
Net income
76 620 €
76 338 €
29 294 €
-84 387 €
-35 648 €
EBITDA
191 186 €
161 769 €
95 963 €
5 172 €
-12 410 €
Net margin
2.2%
2.3%
0.9%
-2.5%
-1.1%
Revenue and income statement
In 2018, QUEMALLYS CITY achieves revenue of 3.4 M€. Revenue is growing positively over 5 years (CAGR: +1.2%). Vs 2017: +3%. After deducting consumption (2.6 M€), gross margin stands at 801 k€, i.e. a rate of 23%. This ratio measures the ability to generate value from commercial activity. EBITDA (= Gross margin - Personnel expenses - Taxes) reaches 191 k€, representing 5.6% of revenue. The operating margin remains fragile, requiring cost vigilance. Ultimately, net income (= EBIT +/- financial result +/- exceptional - corporate tax) amounts to 77 k€, i.e. 2.2% of revenue. This profit can be retained or distributed to shareholders.
Revenue (2018)
?
Revenue
Definition
Total amount of sales of goods and services made by the company.
Formula
Sales of goods + Sold production
3 440 859 €
Gross margin (2018)
?
Gross margin
Definition
Difference between revenue and cost of goods sold.
Formula
Revenue - Cost of goods consumed
800 666 €
EBITDA (2018)
?
Gross Operating Surplus (EBITDA)
Definition
Resources generated by current operations, before depreciation and financial expenses.
Formula
Value added - Personnel expenses - Taxes
Interpretation
Positive = profitable activity
191 186 €
EBIT (2018)
?
EBIT (Operating Income)
Definition
Operating income, including depreciation and provisions.
Formula
EBITDA - Depreciation and provisions + Reversals
120 912 €
Net income (2018)
?
Net income
Definition
Profit or loss after all expenses, including taxes and exceptional items.
Formula
Current income + Exceptional income - Income tax
76 620 €
EBITDA margin (2018)
?
EBITDA margin
Definition
Measures the company's operating profitability.
Formula
(EBE / CA) x 100
Interpretation
> 10% : Good profitability 5-10% : Average < 5% : Low
5.6%
Loading income statement...
Income statement
Item
Amount
% Revenue
Change
The detailed income statement is not available for this company (simplified accounts or confidential data).
Chart evolution
Show :
Visualization created via numbers.finance Sources : INPI & BCE - Adjustments : Ministry of Economy
Assets
Loading data...
Item
Gross
Deprec.
Net
%
Change
Assets balance sheet data not available for this company
Liabilities
Loading data...
Item
Year
%
Change
Liabilities balance sheet data not available for this company
Solvency and debt ratios
The debt ratio (= Financial debt / Equity x 100) stands at 152%. Critical situation: debt significantly exceeds equity, severely limiting borrowing capacity and exposing the company to default risk. Financial autonomy (= Equity / Total assets x 100) reaches 25%. The balance between equity and debt is satisfactory. Debt repayment capacity (= Financial debt / Cash flow) indicates it would take 3.0 years of cash flow to repay all financial debt. This ratio remains within usual banking standards. Cash flow represents 4.0% of revenue. Cash flow measures resources generated by operations, available for investment and debt repayment.
Debt ratio (2018)
?
Debt ratio
Definition
Measures the proportion of debt to equity.
Formula
(Financial debt / Equity) x 100
Interpretation
< 50% : Low 50-100% : Moderate > 100% : High
151.636%
Financial autonomy (2018)
?
Financial autonomy
Definition
Share of equity in the company's total financing.
Formula
(Equity / Total assets) x 100
Interpretation
> 30% : Good autonomy 20-30% : Average < 20% : Low
25.441%
Cash flow / Revenue (2018)
?
Cash flow / Revenue
Definition
Self-financing capacity relative to revenue.
Formula
(CAF / CA) x 100
Interpretation
The higher the ratio, the more cash the company generates
3.968%
Repayment capacity (2018)
?
Repayment capacity
Definition
Number of years needed to repay debts with cash flow.
Formula
Financial debt / Cash flow
Interpretation
< 3 years : Excellent 3-5 years : Fair > 5 years : Warning
3.033
Asset age ratio (2018)
?
Asset age ratio
Definition
Measures the degree of wear of tangible assets.
Formula
Accumulated depreciation / Gross fixed assets x 100
Visualization created via numbers.finance Sources : INPI & BCE - Adjustments : Ministry of Economy
Indicator
2014
2015
2016
2017
2018
Debt ratio
456.866
787.91
469.03
228.26
151.636
Financial autonomy
14.137
7.452
10.264
16.975
25.441
Repayment capacity
-74.876
-28.797
6.032
3.151
3.033
Cash flow / Revenue
-0.312%
-0.686%
2.79%
4.119%
3.968%
Sector positioning
Debt ratio
151.642018
2016
2017
2018
Q1: 0.01
Med: 32.2
Q3: 115.73
Average
In 2018, the debt ratio of QUEMALLYS CITY (151.64) ranks above the median of the sector. This ratio measures the weight of debt relative to equity. A reduction effort could improve financial strength.
Financial autonomy
25.44%2018
2016
2017
2018
Q1: 5.98%
Med: 25.9%
Q3: 44.05%
Average+15 pts over 3 years
In 2018, the financial autonomy of QUEMALLYS CITY (25.4%) ranks below the median of the sector. This ratio represents the share of equity in total financing. An improvement would strengthen the competitive position.
Repayment capacity
3.03 years2018
2016
2017
2018
Q1: 0.0 years
Med: 0.66 years
Q3: 2.9 years
Average
In 2018, the repayment capacity of QUEMALLYS CITY (3.03) ranks above the median of the sector. This ratio indicates the number of years needed to repay debt with cash flow. A reduction effort could improve financial strength.
Liquidity ratios
The liquidity ratio (= Current assets / Current liabilities) stands at 95.42. Concretely, the company has €2 of liquid assets for every €1 of short-term debt: no cash risk within 12 months. The interest coverage ratio (= EBIT / Interest expenses) is 8.5x. Operating income very largely covers interest expenses: high safety margin.
Liquidity ratio (2018)
?
Liquidity ratio
Definition
Ability to meet short-term debts with current assets.
Formula
Current assets / Current liabilities
Interpretation
> 1.5 : Very good 1-1.5 : Fair < 1 : Liquidity risk
95.418
Interest coverage (2018)
?
Interest coverage
Definition
Ability to cover interest charges with operating income.
Formula
EBIT / Interest expenses
Interpretation
> 3 : Comfortable 1.5-3 : Acceptable < 1.5 : Risk
8.509
Liquidity indicators evolution QUEMALLYS CITY
Visualisation créée via abddaf.fr Sources : INPI & BCE - Retraitements : Ministère de l'économie
Indicator
2014
2015
2016
2017
2018
Liquidity ratio
102.261
70.897
68.2
72.62
95.418
Interest coverage
-71.499
417.923
23.034
13.063
8.509
Sector positioning
Liquidity ratio
95.422018
2016
2017
2018
Q1: 97.0
Med: 129.52
Q3: 182.11
Watch+6 pts over 3 years
In 2018, the liquidity ratio of QUEMALLYS CITY (95.42) ranks in the bottom 25% of the sector. This ratio measures the ability to cover short-term debt with current assets. A ratio below 1 may signal potential cash flow tensions.
Interest coverage
8.51x2018
2016
2017
2018
Q1: -0.43x
Med: 0.91x
Q3: 4.99x
Excellent
In 2018, the interest coverage of QUEMALLYS CITY (8.5x) ranks in the top 25% of the sector. This ratio indicates how many times operating income covers interest expenses. High coverage means financial charges weigh little on profitability.
Working capital requirement (WCR) and payment terms
Working capital requirement (WCR) measures the cash timing gap between customer collections and supplier/inventory payments. Average customer payment term: 2 days (formula: Customer receivables / Revenue incl. VAT x 360). Supplier term: 34 days. Excellent situation: suppliers finance 32 days of the operating cycle (retail model). Inventory turnover is 23 days (= Average inventory / Cost of goods x 360). Fast turnover, sign of good inventory management. Overall, WCR represents 24 days of revenue, i.e. 227 k€ to permanently finance.
Operating WCR (2018)
?
Operating WCR
Definition
Financing requirement generated by the operating cycle (inventory + receivables - trade payables).
Formula
Inventory + Customer receivables - Trade payables
Interpretation
Negative = cash released Positive = financing needed
227 028 €
Customer credit (2018)
?
Customer credit (days)
Definition
Average payment term granted to customers.
Formula
(Customer receivables / Revenue incl. VAT) x 360
Interpretation
< 45j : Good 45-60j : Average > 60j : Long
2 j
Supplier credit (2018)
?
Supplier credit (days)
Definition
Average payment term obtained from suppliers.
Formula
(Trade payables / Purchases incl. VAT) x 360
Interpretation
The longer the term, the better for cash flow
34 j
Inventory turnover (2018)
?
Inventory turnover (days)
Definition
Average storage duration for goods or materials.
Formula
(Inventory / Cost of goods) x 360
Interpretation
The lower the ratio, the faster the turnover
23 j
WCR in days of revenue (2018)
?
WCR in days of revenue
Definition
Expresses working capital requirement in days of revenue.
Formula
(Operating WCR / Revenue) x 360
Interpretation
The fewer days, the better the working capital management
24 j
WCR and payment terms evolution QUEMALLYS CITY
Visualization created via numbers.finance Sources : INPI & BCE - Adjustments : Ministry of Economy
Indicator
2014
2015
2016
2017
2018
Operating WCR
191 924 €
206 999 €
222 448 €
231 166 €
227 028 €
Inventory turnover (days)
19
19
20
22
23
Customer payment term (days)
4
3
5
2
2
Supplier payment term (days)
22
40
49
49
34
Positioning of QUEMALLYS CITY in its sector
Comparison with sector Supermarchés
Valuation estimate
Based on 341 transactions of similar company sales
in 2018,
the value of QUEMALLYS CITY is estimated at
1 057 881 €
(range 574 316€ - 1 956 740€).
With an EBITDA of 191 186€, the sector multiple of 7.0x is applied.
The price/revenue ratio is 0.26x
(conservative valuation).
This multiples method compares the actual sale price of similar companies to their financial indicators (Revenue, EBITDA, Net Income). It provides a market-based indicative estimate.
Estimated enterprise value2018
341 transactions
574k€1057k€1956k€
1 057 881 €Range: 574 316€ - 1 956 740€
NAF 5 année 2018
Valuation detail by method
Ajustez les pondérations selon votre analyse
EBITDA Multiple50%
191 186 €×7.0x
Estimation1 336 685 €
725 927€ - 2 480 556€
Revenue Multiple30%
3 440 859 €×0.26x
Estimation884 010 €
547 154€ - 1 448 590€
Net Income Multiple20%
76 620 €×8.1x
Estimation621 679 €
236 031€ - 1 409 427€
Valuation evolution
Visualisation creee via abddaf.fr Sources : BODACC & INPI
How is this estimate calculated?
This estimate is based on the analysis of 341 actual transactions of similar company sales (same NAF code) registered with BODACC between 2016 and 2025.
EBITDA Multiple: Preferred method for profitable SMEs. EBITDA reflects the ability to generate cash.
Revenue Multiple: Used for growing companies or those with low profitability. Reflects commercial potential.
Net Income Multiple: Relevant for mature companies with stable results.
This estimate is provided for information purposes only. A precise valuation requires in-depth analysis (assets, liabilities, prospects, market...).
Similar companies (Supermarchés)
Compare QUEMALLYS CITY with other companies in the same sector:
Yes, QUEMALLYS CITY generated a net profit of 77 k€ in 2018.
Where is the headquarters of QUEMALLYS CITY ?
The headquarters of QUEMALLYS CITY is located in STRASBOURG (67100), in the department Bas-Rhin.
Where to find the tax return of QUEMALLYS CITY ?
The tax return of QUEMALLYS CITY is available on this page. Click on a year in the 'Data by year' section to view the account details (assets, liabilities, income statement). Data comes from INPI (National Institute of Industrial Property).
In which sector does QUEMALLYS CITY operate?
QUEMALLYS CITY operates in the sector Supermarchés (NAF code 47.11D). See the 'Sector positioning' section above to compare the company with its competitors.
Item evolution
Rotate your phone to landscape mode to view the chart