Exhibition Stand ROI Calculator: Formula and Worksheet

Use this exhibition stand ROI calculator worksheet to compare attributable contribution with the complete event cost. Enter your costs, attributed sales, contribution margin and qualified contacts, then calculate financial return and cost per qualified lead separately. Agree the reporting period and attribution method first, and label forecast opportunities clearly so they are not mistaken for realised sales.

Exhibition stand ROI calculator: copy this worksheet

Copy the following rows into a spreadsheet or planning document and replace the illustrative figures with your own data. The €25,000 cost, €75,000 sales, 40% margin and 50 contacts below are hypothetical inputs, not benchmarks or customer results.

Symbol	Input or calculation	Illustrative value
C	Complete event cost under the agreed cost boundary.	€25,000
R	Realised sales attributed to the event within the reporting period.	€75,000
m	Contribution margin before event cost, expressed as a fraction.	40% = 0.40
G = R × m	Attributable contribution before event cost.	€30,000
N = G − C	Contribution after event cost.	€5,000
ROI = N ÷ C × 100	Event return under this contribution-based model.	20%
L	Contacts meeting the agreed qualification definition.	50
CPL = C ÷ L	Cost per qualified lead using this complete cost boundary.	€500

The financial calculation is therefore (75,000 × 0.40 − 25,000) ÷ 25,000 × 100 = 20%. Sales of three times the event cost do not establish 200% profit ROI because the associated delivery costs still matter. If C is zero, ROI is undefined; if L is zero, CPL is undefined.

Agree the contribution and cost definitions

Corporate Finance Institute explains ROI as net income or gain relative to an investment base. The worksheet above is a practical event contribution model. Have your finance team confirm the margin, overhead treatment and cost boundary; it is not automatically the same as company net-profit accounting.

Deduct the associated product or service delivery costs when determining contribution, then deduct the event cost once. When actual sales have different margins, sum their attributed contributions instead of applying an unrepresentative single average. Use the same currency and treatment of taxes throughout.

Build a complete exhibition cost baseline

Collect actual invoices and agreed allocations, flag estimates and reconcile outstanding charges. Include the resources needed to deliver the event, rather than treating the stand supplier’s invoice as the entire investment.

• Space rental, registration and other applicable organiser charges.
• Stand design, components, graphics, hired items and audiovisual equipment.
• Venue connections, consumption, handling and other ordered services.
• Transport, installation, handover, support, dismantling and return.
• Staff preparation and time, travel, accommodation and follow-up resources.
• Invitations, demonstrations, marketing materials and related campaigns.
• Storage, inspection, repair and adaptation of retained components.

Document how shared purchases or storage are allocated between events. Avoid both charging the entire purchase to every show and leaving reused assets out of every comparison. Our European exhibition budget guide helps review the headings.

Separate forecasts from realised results

For planning, a simplified forecast contribution can be estimated as qualified opportunities × assumed close probability × assumed contribution per won contract. State the evidence for each assumption and test less favourable cases. That expected amount is a forecast, not profit already earned.

At break-even in this worksheet, attributable contribution equals event cost. If a hypothetical won contract contributes €5,000 and the event costs €25,000, five such additional attributed contracts would cover the event under those assumptions. Five contacts would not establish the same result.

A useful sensitivity check holds the €25,000 event cost fixed and changes contribution: €0 gives −100% ROI; €25,000 gives 0%; €30,000 gives 20%; €50,000 gives 100%. These are arithmetic scenarios, not a suggested range of normal exhibition performance.

Track the right information before, during and after

Stage	Record	Decision it supports
Before the show	Objectives, cost boundary, qualification, attribution rule, reporting dates and scenario assumptions.	Whether the proposed participation is feasible and which result would justify it.
During the show	Relevant conversations, completed demonstrations, meetings, visitor needs and agreed actions.	How to prioritise staff work and fulfil commitments.
After the show	Reconciled costs, completed follow-up, opportunities, realised sales and contribution.	What happened, what remains a forecast and what to change.

Use an approved recording process, remove duplicates and connect conversations to the commercial record. Define qualification consistently across staff and events. Badge scanning technology is a tool; it does not guarantee completeness, permission for every subsequent use or a higher conversion rate.

Choose attribution and review periods deliberately

Agree how the event receives credit for new opportunities and for progress in existing ones. Avoid giving the same full sale to several events or claiming every subsequent purchase by an existing customer. Record the relationship between the event conversation, follow-up and result.

Choose reporting dates appropriate to your sales cycle, and show the cutoff date in every report. Keep pending opportunities visible without treating them as completed sales. If the attribution method or cost boundary changes, explain it before comparing the new percentage with earlier events.

Compare stand options over a defined programme

For custom, modular, rented or organiser-equipped stands, list the actual events and suitable configurations first. Then compare initial expenditure, per-show delivery, graphics, storage, repairs, adaptation and end-of-programme arrangements. Divide the defined programme cost by the number of appearances only when that number is positive and realistic.

Mark each assumption and check that the options support equivalent activities. A lower programme cost does not prove equal lead quality or an improved financial return. A fixed three-year comparison or a guaranteed saving after two events cannot replace your own calendar and quotations.

Use design and staffing evidence to improve the next show

Review whether visitors could understand the offer, reach demonstrations, meet the right colleague and agree a useful next action. Record layout constraints, equipment problems and staffing gaps. Prioritise a specific improvement and its complete incremental cost, then decide how you will observe its effect.

AUMA’s monitoring guidance also considers contact evaluation, research and the event portfolio. Its Trade Fair Benefit Check supports broader benefit evaluation; keep qualitative findings and such comparisons separate from the realised contribution calculation.

Frequently asked questions

What is a good exhibition stand ROI?

Set a target using your margins, complete costs, reporting period, attribution and alternatives. There is no universal 150–300% benchmark or standard cost per lead that proves your event was successful.

Does a low CPL guarantee profit?

No. Check qualification, subsequent sales, contribution and all relevant costs. Two channels with different contact definitions cannot be compared fairly using their headline CPL alone.

Can I calculate a forecast before the show?

Yes, using documented assumptions and sensitivity checks. Label the result as forecast ROI and update it separately from the realised outcome.

Connect the worksheet to your stand brief

Send Adam Expo Stand your programme, plots, products, visitor activities and budget scope through our project contact form. Request a proposal with clear costs, responsibilities and configurations so it can be assessed in your event model.