IMPORTANT: The steps below introduce a practical forecasting approach that combines top-down analysis to understand scale with bottom-up analysis to explore feasibility. While neither method is shown in full, this structure offers a solid starting point for evaluating whether an idea is worth pursuing.
Over the years of my teaching, I have met with many first-time student entrepreneurs who come into my office just before our semester business competition. They usually all have the same frustration. They are stuck on the financial projections section and do not know where to begin.
When they Google it, they mostly find advice to use customer data they do not yet have. They are asked to forecast revenue, yet nothing has been sold. At this stage, they are just trying to decide whether an idea deserves to become one.
You probably can predict what happens next. Numbers magically are pulled from the air, and spreadsheets get filled with guesses that sound confident on the surface but fall apart under scrutiny. When these students enter the competition, the financial projections become their archilles heel. Most judges are not expecting students to be certain with their numbers. However, they do expect them to be able to show realistic logic in those numbers.
This article is written for students who are still unsure whether their idea is strong enough to pursue. It explains how to use data-backed revenue projections as a tool for evaluation.
When I guide students at the idea stage, I often begin with a blend of top-down and bottom-up forecasting. This approach works because it is simple and does not rely on having customer data. It draws insight from real-world data and then applies realistic numbers to the offering.
I learned this lesson the hard way with my first company, Eclectic, LLC. My model was simple: I sold shirts to fans attending local concerts. At the time, I believed I could make good money with the idea.
What I did not do was step back and ask how large the reachable market really was and what a realistic slice of it might look like. I trusted my gut instincts rather than market math. The company failed, and while many things contributed to that outcome, a lack of financial insight did not help.
For all my entrepreneurship students and all future entrepreneurs who stumble across this page, here is a step-by-step approach on how I could have developed projections for Eclectic’s possible business opportunity.
Step 1: Figure out who this matters to and back it up with a believable number
Before designing anything for Eclectic or investing time and money, the first question should have been simple: “Who actually cares enough to buy this?”
I relied on a general sense that local concertgoers were the audience. That label was true, but it was too vague. It did not answer how many people in the local area attend live shows each year. It did not show how large the reachable market really was.
Public data could have made that clearer. Census population data can show how many people fall into age groups who attend concerts most often. Regional data can narrow the focus to cities or counties where live music events are common. Attendance reports from venues or industry sources can add another layer. By combining population counts with likely participation rates, I could have estimated a realistic number of potential customers.
The lesson here is that market size should be considered in observable data. Using census figures and attendance patterns would have improved clarity. That foundation would have led to a more defensible outcome.
Resources
- U.S. Census Bureau – Population counts by age, geography, and household characteristics.
- American Community Survey (ACS) – Detailed annual demographic estimates by region.
- Bureau of Labor Statistics – Shows how Americans spend time, including leisure and entertainment.
Step 2: Turn that population into a rough market ceiling
This step shifts the focus from people to dollars. After estimating how many likely concertgoers exist in a defined area, I would translate that number into a simple revenue estimate for Eclectic using one shirt per person per year at a typical merchandise price. The goal is to get a sense of scale through basic math.
To keep pricing realistic, consumer spending data offers useful context.The Consumer Expenditure tables published by the Bureau of Labor Statistics provide a view into what households already allocate to apparel and entertainment. When projected spending per person stretches well beyond those numbers, it’s a good sign that the estimate assumption deserves reexamination.
By multiplying the number of potential buyers by a reasonable price, I arrive at a rough revenue ceiling. This is a boundary that helps show whether the idea sits within a market that is large enough to scale.
- Consumer Expenditure Surveys – Household spending on apparel and entertainment.
- U.S. Bureau of Economic Analysis – National spending by category.
- PwC Global Entertainment & Media Outlook – Industry revenue projections for live events and merchandise.
Step 3: Cut the market down to what I can actually serve
At this point, I would start removing people from the market instead of adding them. Eclectic does not sell online at the start. It sells at physical venues in specific cities. That means most concertgoers should no longer count. I would limit my thinking to cities I can reach and events where fans arrive early enough to browse.
This narrowing step matters more than the first two. If the number collapses here, that is information I need now, not later. That means only the cities I can reach count. Only certain venues matter. Only events that allow outside vendors belong in the calculation. Even within those events, timing affects access. If fans arrive just before the show and head straight inside, the chance to sell shrinks.
Instead of expanding the market, this step removes most of it. The broad category of “concertgoers” becomes a much smaller group defined by geography, venue policy, and real behavior. The total may drop sharply. That drop is useful. It brings better understanding that supports better judgment.
Guidance from the Small Business Administration will help with this kind of narrowing. Their market research framework emphasizes reachable customers, realistic distribution limits, and observable constraints. By applying those limits early, I can see whether Eclectic remains as a viable opportunity within real-world boundaries rather than theoretical demand.
- U.S. Small Business Administration – Market Research Guide: A Framework for Identifying Reachable Customers.
- Score.org – Market Analysis Templates and Guidance
- Economic Census – Provides statistics on businesses at the national, state, and local levels.
Step 4: Choose a small, believable share of that market
After narrowing the market to people who can actually be reached, the question becomes personal. How many sales can one person handle in a year with limited time, inventory, and stamina?
The focus turns to physical limits. Each show allows only so many conversations. A bag or table holds only so many shirts. A line moves at a certain pace. A single evening has a fixed number of minutes. When those constraints are counted honestly, the possible sales volume becomes concrete.
This number does not describe how many people might want the product. It describes how much I can actually execute. It captures what can happen in real conditions rather than what could happen in theory.
Online search behavior provides useful background information. Google Trends reveals how frequently concert merchandise appears in searches within target cities. While it does not represent direct demand, it helps provide realistic expectations about the market’s interest.
By choosing a modest and believable share of the reachable audience, I protect against inflated projections. The goal is not to prove that the market is huge. The goal is to see whether a small, realistic slice can support steady revenue.
- Google Trends – Search interest by geography and time.
- Google Keyword Planner – Search volume estimates for relevant terms.
- Similarweb – Traffic estimates for comparable companies.
Step 5: Translate that small share into simple revenue math
At this stage, revenue is calculated in a simple way that stays tied to real decisions. You work with a small number of reachable buyers and a clear price so every part of the calculation can be explained plainly.
Right beside the calculation, you capture your assumptions in everyday language. You explain what your show schedule looks like, what foot traffic feels like in the moments you can actually sell, and how that turns into a small number of purchases. This is what early investors want to see with new ideas. They want to see that your thinking follows a clear chain, and that your numbers come from reasoning you can explain without hiding behind buzzwords.
- SCORE Financial Projection Worksheet – Beginner-friendly revenue modeling template.
- Velocity 1 – Clear guidance on revenue logic.
- SEC EDGAR Database – Public company filings for pricing and revenue comparisons.
Step 6: Stress the idea by lowering one assumption
Before relying on any projection, I would stress test it. I would take one core assumption and reduce it on purpose. I might assume fewer events, a lower price, or a smaller share of buyers. Then I would recalculate revenue under that tighter condition.
The goal is not to defend the idea. It is about locating the breaking point and understanding the risk that comes with it. A good entrepreneur doesn’t take risks; they manage them.
- SBA Risk Management Guide – Framework for identifying and managing business risk.
- Federal Reserve Small Business Credit Survey – Insight into financial vulnerability and performance ranges.
- FRED (Federal Reserve Economic Data) – Test assumptions against economic downturn trends.
Final Thoughts
If I had done this process when I first imagined Eclectic, I probably still would have moved forward. However, it’s possible that the data would have been convincing enough that I might have walked away sooner. We will never know. Yet, either outcome would have been better than guessing.