Introduction
A consumer modeling test looks familiar on the surface: a three-statement build, a DCF or an LBO, completed against the clock or over a few days at home. The difference lies in the operating build. A retailer's revenue comes from stores, a restaurant chain's from units and a brand's from volume and price, and graders can tell within minutes whether a candidate has modeled those drivers or simply grown last year's revenue by a percentage.
The general mechanics of timed tests and take-home cases are covered in the Valuation guide's article on modeling test format, preparation and execution. This article covers what is specific to consumer and retail: the formats you may face, the operating builds, lease adjustments and the LBO case, and the traps graders look for.
Formats You May Face
Consumer tests come in the same three broad forms as other groups, each with its own consumer twist. The case packet usually contains a short description of the company, a few years of historical financials, an assumptions sheet and a prompt, often ending with a question such as whether a buyer should proceed at a given price. Read the prompt first: it tells you which outputs matter and whether a recommendation is expected.
| Format | What it tests | Consumer twist |
|---|---|---|
| Timed test (about one to three hours) | Speed and accuracy on a defined case | A store or brand revenue build from given assumptions |
| Take-home case (several days) | Judgment, research and presentation | Justifying assumptions with comps, unit economics and peer data |
| Paper LBO (minutes, no computer) | Mental math and LBO logic | Lease-adjusted leverage and stable versus seasonal cash flows |
In a take-home case, the assumptions matter as much as the mechanics. A candidate who backs a comparable sales assumption with the company's recent history, or a new-unit assumption with its stated opening plans, shows the judgment that a timed test cannot. For the paper LBO, the Valuation guide's paper LBO framework covers the mental math.
The Operating Build
The revenue build is where a consumer test is won or lost, because it is where the sector's drivers live. Set it up so each driver sits on its own row, with inputs separated from calculations, so a grader can follow the logic and change an assumption without breaking the model.
Stores and comparable sales
For a retailer or restaurant chain, build revenue from the store base. Start with the prior year's revenue from existing units, remove closures, grow the rest at the comparable sales rate, then add new units at their expected productivity and timing. Comparable sales themselves split into transactions and average ticket: Walmart's US comparable sales excluding fuel rose 2.6% in the quarter to 31 July 2026, made up of transactions up 1.5% and average ticket up 1.1%, according to Walmart's results release.
How unit growth is planned and tested against the available whitespace is explained in store rollout models and whitespace analysis.
Brands: volume, price and mix
For a packaged goods brand, build revenue from volume and price and mix, often by category or channel. Tests may also give gross sales and trade spend, the promotional payments to retailers that turn gross sales into net sales, so watch which revenue line the margins are calculated on. The splits are explained in organic growth: price, mix and volume and trade spend and gross-to-net in consumer products.
Margins and working capital
Below revenue, model gross margin, occupancy and selling costs separately where the case allows, because operating leverage comes from fixed costs spread over higher sales. Retailers also carry large inventory, which builds before peak seasons and ties up cash, so working capital assumptions should follow inventory days rather than a flat percentage of revenue. If the case gives quarterly data, the inventory build before the holiday season and its release afterwards can swing cash flow by more than a quarter's profit, which matters for how much revolver a retailer needs.
Lease Adjustments and the LBO Case
Leases affect both the valuation and the financing in a consumer test, so decide early how you will treat them and apply that choice consistently across the multiple, the enterprise value bridge and the debt capacity analysis.
- Lease-Adjusted Leverage
A company's debt plus its lease obligations, divided by EBITDAR, its earnings before rent. Lenders and rating agencies use it to compare retailers and restaurant chains that lease their locations with those that own them, because rent is a fixed obligation that behaves much like interest.
Sizing the debt
In an LBO case, the amount of debt a business can carry depends on its fixed charges: interest and rent together. A retailer with heavy rent can support less new debt than its EBITDA alone suggests. A business with $300 million of EBITDAR, $100 million of rent and $60 million of interest has fixed charge coverage of about 1.9x (300 divided by 160), and every extra dollar of debt lowers it further. Some tests give a lease liability; others ask you to capitalize rent at a stated multiple. Either way, check lease-adjusted leverage and fixed charge coverage at entry, as explained in lease-adjusted leverage and fixed charge coverage.
- Fixed Charge Coverage Ratio
A measure of a company's ability to pay its fixed obligations, usually calculated as EBITDAR divided by rent plus interest. Definitions in loan agreements vary and may deduct capital spending or taxes from the numerator, so in a test use the definition the case provides.
Brands, retailers and franchisors
The type of business changes the LBO case.
| Business | Debt capacity driver | Working capital | Typical financing feature |
|---|---|---|---|
| Staples brand | Stable cash flow and brand durability | Modest, predictable | Term loans and bonds |
| Retailer | EBITDAR after rent, seasonality | Large inventory swings | Asset-based revolver secured on inventory |
| Franchisor | Contracted royalties | Minimal | Whole-business securitization in larger systems |
Sponsors do buy large consumer companies: 3G Capital agreed in May 2025 to take Skechers private at $63 per share, about $9 billion, according to the Associated Press report carried by CP24, and completed the deal in September 2025. In a test, the question is whether the cash flows support the debt in a downturn case, not just in the base case. For a retailer, that means running negative comparable sales and margin pressure through the model and checking that the business still covers its rent and interest, with the asset-based revolver providing liquidity against inventory. Which consumer businesses suit leverage is covered in consumer LBOs: which brands and retailers fit.
Common Traps
Graders see the same errors repeatedly:
- Growing revenue by a single rate instead of building it from stores, units or volume and price.
- Ignoring opening dates, so new stores contribute a full year of sales in their first year.
- Mixing lease bases between EBITDA, EBITDAR and enterprise value.
- Flat working capital for a business whose inventory swings with the seasons.
- No sanity checks, such as revenue per store far above the chain's history or margins that expand every year without explanation.
What graders reward across all groups is covered in what interviewers look for in Excel modeling tests. In consumer, the short version is a revenue build that follows the business's real drivers, a lease treatment applied consistently and outputs that would survive a senior banker's first look.
