Musharik

How a listing is analysed

Every number on a Musharik listing is one of two things: a figure the company reported, which Musharik's staff checked against its documents, or the result of a formula published on this page. Nothing is estimated by hand, sampled or generated, so the same figures always give the same analysis. Where a number would need data Musharik does not have, the listing says so instead of inventing one.

Analysis engine version 1.0.0. Each published analysis records the engine version and the parameter set it used, so it can be reproduced exactly.

From figures to a listing

  1. The company reports its figures: the round it is raising, two to four years of income statements, its latest balance sheet and cash flow, and answers to twelve governance questions.
  2. The engine computes every ratio, score, risk and estimate from those figures and the reference parameters in use.
  3. Musharik's staff review the submission beside the company's documents, with every automatic check listed, then publish it or send it back. A later change to the figures goes through review again, and the live listing stays as it was until the change is approved.

Figures derived from what is reported

  • Gross profit = revenue − cost of sales
  • EBITDA = operating profit + depreciation and amortisation
  • Net debt = interest-bearing debt − cash
  • Invested capital = owners' equity + interest-bearing debt − cash
  • Free cash flow = operating cash flow + investing cash flow
  • Closing cash = opening cash + operating + investing + financing cash flow
  • Revenue CAGR = (last year's revenue ÷ first year's) ^ (1 ÷ years between them) − 1
  • Growth after inflation = (1 + growth) ÷ (1 + inflation) − 1

Growth is measured across full fiscal years. A trailing-twelve-month period overlaps the last fiscal year, so it is compared with that year, setting the months since against the same months a year earlier, but never turned into an annual rate. A ratio with nothing to divide by, such as a margin on no revenue, is shown as unavailable rather than as zero.

Scores

Each score runs from 0 to 5 and is read off a published table of anchor points. Between two anchors the score moves in a straight line; below the first anchor it takes the first score, and above the last it takes the last. Scores are rounded to one decimal.

A score whose input cannot be computed (a margin with no revenue, a valuation with no sector multiples) is left out rather than counted as zero, and the weights of the scores that remain are scaled up to fill its place.

ScoreWeight
Growth20%
Financial health25%
Business quality25%
Valuation15%
Risk profile15%

Growth

Revenue CAGR across the fiscal years, with inflation taken out using the parameter set in use. Without a parameter set there is no growth score.

Revenue growth a year, after inflation
Value−10%0%10%25%50%80%
Score0.01.52.53.54.55.0

Financial health

The mean of four scores. When EBITDA is zero or negative, net debt over EBITDA means nothing, so the company is scored on what it holds instead: 3 with net cash, 0.5 with net debt. A company with no current liabilities scores 5 on the current ratio.

Net debt / EBITDA
Value0×1×2×3×4×5×
Score5.04.03.02.01.00.0
Current ratio (current assets / current liabilities)
Value0.50.811.21.52
Score0.01.02.03.04.05.0
Owners' equity / total assets
Value0%5%15%25%40%60%
Score0.01.02.03.04.05.0
Operating cash flow / revenue
Value−25%−10%0%5%15%
Score0.01.02.54.05.0

Business quality

The mean of four scores. The spread of EBITDA margins needs at least three periods; a steadier business scores higher.

Gross margin
Value0%5%15%25%40%60%
Score0.01.02.03.04.05.0
EBITDA margin
Value−40%−15%0%8%15%25%
Score0.01.02.03.04.05.0
Spread of EBITDA margins across periods, in percentage points
Value2510152540
Score5.04.03.02.01.00.0
Years operating
Value0123510
Score0.51.02.03.04.05.0

Valuation

The enterprise value this round implies, as a multiple of revenue and of EBITDA, set against the sector's multiples in the parameter set. 1 means the round prices the company exactly at its sector's multiple; below 1 is cheaper. Without multiples for the sector there is no valuation score.

EV / revenue, against the sector's multiple · EV / EBITDA, against the sector's multiple
Value0.50.7511.523
Score5.04.03.02.01.00.0

Risk profile

5 less the severities of the key risks raised, never below 0.

Key risks

Each risk is a fact about the figures with a fixed severity. A risk that applies is listed on the listing with the number that raised it.

RiskSeverity
Revenue fell in the latest period1
EBITDA was negative in the latest period1
Operating cash flow is negative1
Net debt is more than 3× EBITDA1
Net debt while EBITDA is negative1.5
Current ratio below 11
Owners' equity is negative1.5
Cash lasts less than 12 months at the current burn1
Fewer than 2 years operating0.5
Financial statements not audited (self-declared)0.5

Valuation

The round sets a price. Post-money value = amount raised ÷ equity offered. Pre-money value = post-money value − amount raised. Enterprise value = pre-money value + net debt.

Comparable companies: revenue × the sector's EV / revenue, averaged with EBITDA × the sector's EV / EBITDA when EBITDA is positive. Net debt is taken off and the amount raised added, so the estimate is a post-money value like the round's.

Discounted cash flow, only when free cash flow is positive: 5 years of free cash flow, growing in the first year at the company's revenue CAGR (capped at 40%) and slowing in a straight line to the long-run growth rate by the last, discounted at the parameter set's discount rate, plus a terminal value that grows at the long-run rate from then on.

When both apply they are weighted 60% comparable companies and 40% discounted cash flow; when only one applies, it carries the whole weight. The blended value is shown against the post-money value the round implies.

Precedent transactions are not used. There is no reliable source of what Egyptian private companies have sold for, and a made-up multiple is exactly what this method exists to avoid.

Peers

A listing is compared with other published Musharik listings in the same sector on their latest revenue growth, EBITDA margin, net margin and return on equity. They are labelled Peer 1, Peer 2 and so on. The comparison appears only once there are at least 3; until then the listing says there are not yet enough comparable companies. Every figure in it is already public, anonymously, on the peer's own listing.

Governance and practices

Twelve yes / no / not-applicable questions, four for each pillar. A pillar's score is the share of its applicable answers that are yes, out of 100; a question that does not apply counts for neither side. The answers are the company's own and are shown as self-declared.

Environment

  • Has a written environmental or waste policy
  • Tracks its energy or water use
  • Holds the environmental permits its activity requires
  • Uses renewable energy or efficiency measures

Social

  • All staff are on written contracts
  • All staff are registered for social insurance
  • Offers health cover
  • Has women in management

Governance

  • Financial statements audited by a licensed auditor
  • Has a written shareholders' agreement
  • Company and personal finances are fully separated
  • Has at least one independent board member or adviser

Checks before a listing is published

The company has to fix these before it can submit:

  • The fiscal years follow on from one another, each once, oldest first
  • A trailing-twelve-month period ends after the last fiscal year and before the next
  • The company was founded by its first reported year
  • Revenue, cost of sales, depreciation, assets, liabilities and opening cash are not negative
  • The balance sheet balances, to within EGP 1,000 or 0.5% of total assets, whichever is larger
  • The use of funds adds up to 100%
  • The equity offered is between 1% and 100%
  • The amount being raised is above zero
  • Every governance question is answered
  • The summary, 3 to 5 highlights and each team role are written in at least one language

These go to Musharik's reviewer, who checks them against the documents. They do not stop a submission:

  • Closing cash in the cash flow statement matches cash on the balance sheet
  • Net profit is no more than 25% above operating profit; more means sizeable income from outside the business
  • The story names neither the company nor its contact, and has no email address, phone number or web address
  • No figure moved by more than 50% since the last approved version

Reference parameters

Inflation, the discount rate, long-run growth and each sector's multiples come from a parameter set that Musharik's staff publish, every value with its source and the date it was true on. A new set never changes a listing already published; staff recompute a listing deliberately.

No parameter set has been published yet, so listings show no growth score, no valuation score and no comparable-company or discounted-cash-flow estimate. Everything else is computed as normal.

What this cannot tell you

  • The figures are the company's own. Musharik checks them against the documents submitted; it does not audit them.
  • Governance answers are self-declared.
  • The margin tables are the same for every sector, although what counts as a healthy margin differs between them.
  • A score describes the figures behind it. It is not a forecast and not a recommendation to invest.
Back to home