How to actually use an opportunity analysis template without wasting everyone's time
Most templates I see in the wild are either three columns wide with nowhere to put nuance, or they're so detailed that nobody fills them out before the meeting starts. The version I use lives in Google Sheets and takes about twenty minutes to complete for a standard initiative. It has five sections: opportunity description, market signals, competitive displacement, revenue model assumptions, and risk register. That's it. I built this after watching a product team spend three weeks on a twenty-page document that nobody referenced again. The problem was structural. When you ask people to write paragraphs upfront, they stall. When you ask them to fill cells, they just do it.
How to fill out an Opportunity Analysis Template
Start with the opportunity description. One paragraph. Who is it for, what problem does it solve, and what does success look like in six months? Not a vision statement. A concrete outcome. I once had a senior engineer write "we want to become the platform for everything," which is not a description, it's a prayer. Cut it to one line and move on. The market signals section is where most people lose credibility. You need hard evidence, not feelings. Include three data points minimum. Customer interview count with dates. A churn rate trend. A competitor pricing page screenshot with a timestamp. Last quarter I was reviewing an opportunity where someone had cited a Statista report from 2019 as a current signal. The market had shifted significantly since then. I asked them to pull current data and resubmit. We lost two weeks on that one. Competitive displacement is the section nobody likes. You have to answer a question most people don't want to face: what happens to the people who currently solve this problem? List the alternatives, both direct and indirect. The indirect ones matter more. If you're building a scheduling tool, your real competition isn't other scheduling tools. It's calendar reminders and "I'll just remember to do it." I learned that the hard way on a project that assumed a 40 percent market capture from existing solutions within eighteen months. We captured six percent. The assumptions were plausible on paper but ignored human behavior patterns.
Revenue model assumptions need numbers, not hopes. Pick a pricing model. State your assumed conversion rate from free to paid. Show your math. If you say you'll charge forty dollars per seat and convert at five percent, I need to know where the five percent comes from. Industry average? Your own beta data? A guess? Label it. I usually flag anything marked "estimate" and ask for a sensitivity analysis showing best case and worst case. This takes twelve minutes and saves hours of debate later. The risk register is the section that separates the people from the rest. List at least five risks. Not one. Not two. Five. Rank them by likelihood and impact. Include a mitigation plan for each. The risks should cover technical, market, and execution categories. I had a team list weather patterns as a risk for a B2B SaaS product last year. We spent twenty minutes discussing it before I pointed out that their customers were office workers with poor WiFi, not farmers. They moved on quickly after that.
Get the Full Details
Where this breaks down
Templates like this assume you have access to real data. If you're in the pre-research phase with no customer contacts and no market reports, you're going to fill this with guesses. The template doesn't stop that. It just gives your guesses a nice format. I've seen it used as a way to make thin ideas look substantial. That's not a template problem. That's a people problem. Another limitation is scope. This works well for medium-complexity opportunities with a 3-12 month horizon. It falls apart for enterprise deals that take eighteen months to close, or for speculative product research where you're exploring rather than committing. In those cases, a lighter framework or even a whiteboard session works better. Don't force a square tool into a round situation. If you're looking for something to download, the version I referenced above is available through our shared drive. It's set to view-only so you can make a copy and customize it. The cells have data validation built in, dropdown menus for risk categories, and automatic calculations for the revenue projection section. It saved me about fifteen minutes per opportunity review compared to the previous version we used.
The template won't make bad opportunities look good. But it will surface problems faster than a free-form document usually does. That's the real value. Speed of clarity, not accuracy of prediction. Nobody at this level is going to predict the market correctly on the first try. The point is to get wrong as fast as possible and adjust.
