Sales Funnel Investment Calculator for Startups

The Sales Funnel Calculator for startups is used as a complementary tool to the Sales Funnel template, available on the ONE Platform. Before working with this tool, it is necessary to have completed the Sales Funnel template using real data.

Once that first step has been completed, the tool automatically analyzes the monthly evolution of the sales funnel and provides a deeper economic analysis of the customer acquisition and conversion process.

In the pre-seed and seed stages, one of the biggest challenges for entrepreneurs is understanding whether their sales effort translates into sustainable economic results. Often, leads, meetings, or demos are analyzed without connecting this data to the real acquisition costs or the revenue generated by each customer.

The Sales Funnel Calculator for startups was created to meet this need. It provides a clear structure to analyze the funnel from a dual perspective: acquisition costs and revenue obtained per customer, allowing you to:

• Understand how much it costs to move through each stage of the funnel.
• Analyze the revenue generated per customer over time.
• Assess the profitability of the acquisition process.
• Compare customers and identify differences in value.
• Make decisions based on real economic data.
• Clearly communicate the commercial and financial status of the project to investors, incubators, and accelerators.

Sections of the template explained in detail

The calculator is structured in two complementary sheets. The first corresponds to the Sales Funnel, which must be completed beforehand and is available on the website. The second sheet, Sales Funnel Calculator, uses part of that information and combines it with new economic data to perform a deeper analysis of funnel performance.

Sales activity inputs

This block defines the starting point of the funnel and its evolution over time:

• Leads generated/month (initial month): volume of interested people entering the funnel in the first month, following the first marketing action.
• Monthly growth in leads (%): expected month-by-month growth rate of leads (depending on the startup’s objectives). This value is relative and defined by each user according to their own acquisition goals.

Based on this data, the tool automatically calculates the estimated number of leads for each month of the period.

Funnel conversion rates

In this section, the conversion percentages between stages are entered. Each rate includes a strategic interpretation, a recommended value, and a recommended action when the value is outside the optimal range. The rates included in the tool are as follows:

• Lead → MQL (Marketing Qualified Lead) conversion. Measures what proportion of the initial leads actually have a pain point or need that your solution can solve. It answers the question: am I attracting the right audience? The recommended value is between 30% and 50%. A low percentage at this stage usually indicates that the acquisition channels are not well segmented or that the message does not connect with the target profile.
• MQL → SQL (Sales Qualified Lead) conversion. Indicates whether the sales team considers the marketing-qualified lead sufficiently ready to begin direct commercial interaction. It answers the question: does the sales team consider the lead qualified? The recommended value is between 40% and 60%. A mismatch at this point may reflect a lack of alignment between marketing and sales criteria.
• SQL → Validation interview / Demo conversion. Measures the team’s ability to get a sales-qualified lead to move forward to a meeting, presentation, or product demonstration. It answers the question: can I get the SQL to move forward to a meeting or demo? The recommended value is between 40% and 70%. A low rate at this stage may indicate that the value proposition is not generating enough interest or that the contact process needs to be reviewed.
• Demo → MVP user conversion. Reflects how many people who have seen a product demonstration decide to try it actively. It is a direct sign of problem-solution fit: it indicates whether the user perceives that the product truly addresses their need. The recommended value is between 40% and 60%. A value below this range may suggest that the product does not meet the expectations generated during the demo or that the onboarding experience presents friction.
• MVP → Active customer / sale conversion. Measures the proportion of people who, after trying the product, become paying customers or recurring users. It is a sign of product-market fit: it reflects whether the product generates enough value for the user to commit economically. The recommended value is between 20% and 40%. A low percentage at this final stage indicates that, although the product sparks interest, it does not fully generate the perception of value needed for final conversion.
• Total funnel conversion. It is calculated automatically as the cumulative result of all the previous rates and reflects the overall maturity of the sales process. The recommended value is between 1% and 5%. When total conversion falls below this range, the tool automatically generates an alert with a specific recommended action: "There is a mismatch between the target customer, product, and message. Rethink your positioning strategy." This indicator is especially useful because it allows the performance of the funnel as a system to be evaluated, beyond stage-by-stage analysis.

These rates allow you to model the behavior of the funnel and explore improvement scenarios.

Monthly evolution of the funnel

Based on the previous data, the tool automatically calculates, month by month:

• Leads: people who have shown initial interest (website, social media, inbound).
• Marketing Qualified Leads (MQL): leads who have a real pain point that your solution solves.
• Sales Qualified Leads (SQL): sales-qualified leads (the cumulative total is also shown).
• Validation interviews / Demos: meetings where you explain the product (very important in the early stage).
• Users trying the MVP: people who use the prototype.
• Active customers / Sales: people who pay or use the service on a recurring basis.

This block makes it possible to clearly visualize how the funnel evolves over time, how many conversions occur at each stage, and where the greatest loss of opportunities is concentrated, making it easier to identify bottlenecks.

Acquisition costs and costs per stage

Instead of entering costs per stage manually, the user enters aggregated monthly costs associated with acquisition and conversion:

• Monthly marketing cost: expenses associated with demand generation (campaigns, content, advertising, etc.).
• Monthly sales/commercial cost: expenses of the sales team (salaries, CRM tools, travel, etc.).

With these costs and the funnel volumes, the tool automatically calculates:

• Cost per lead (marketing-based)
• Cost per MQL (marketing-based)
• Cost per SQL (sales-based)
• Cost per interview or demo (sales-based)
• Cost per MVP user (sales-based)
• Cost per active customer / CAC (sales-based)

In addition, the tool calculates the number of customers needed to cover expenses each month, providing a break-even reference point, as well as the total funnel conversion month by month. This makes it possible to understand how costs accumulate as you move through the funnel and what the real acquisition cost is.

Mini customer portfolio (revenue and LTV)

This block allows you to enter the revenue generated by each customer month by month (from January to December). Customers can be incorporated in different months of the year, thus reflecting the actual acquisition timing of each one.
Based on this, the tool automatically calculates:

• Total monthly and annual revenue, as the sum of the revenue from all customers in the portfolio.
• Revenue obtained (annual total).
• Total costs (annual total).
• Gross profit, as the difference between revenue obtained and total costs.

This analysis helps you understand whether the customers being acquired generate enough value to sustain and grow the business.

Key economic KPIs

Based on cost data and the mini customer portfolio, the tool automatically calculates the main economic indicators:

• Average CAC, as the average acquisition cost.
• Average LTV, as customer lifetime value.
• LTV/CAC ratio, an indicator of model sustainability.
• Payback, which shows the time needed to recover CAC.
• Margin per customer, as the difference between the value generated and the acquisition cost.

These KPIs make it possible to assess the economic viability of the funnel and prioritize improvement actions with the greatest impact.

How to interpret the results

Once the data has been completed, the tool automatically generates a set of results that, when read together, make it possible to assess the commercial and economic health of the project. Below is an explanation of how to interpret each results block and which signals should trigger improvement decisions.

Each conversion rate between stages includes a recommended value and an automatic suggested action. If an individual rate is below the recommended range, it indicates a specific bottleneck. For example, a Lead → MQL conversion below 30% suggests that the acquisition channels are not attracting the right profile. In this case, the tool automatically alerts: "There is a mismatch between the target customer, product, and message. Rethink your positioning strategy."

A low total conversion, even when individual rates appear acceptable, may indicate that small losses at each stage accumulate and significantly erode the final result.

On the other hand, the monthly evolution of unit costs by stage makes it possible to identify whether the acquisition model is gaining or losing efficiency over time:

• Downward trend in cost per active customer / CAC. This indicates that the funnel is maturing: as the volume of leads grows and cumulative conversion improves, the cost of acquiring each customer decreases. In the sample data in the template, the cost per active customer drops from €9,722 in January to €885 in December, reflecting an acquisition process that is gaining scale.
• Occasional spikes in cost per lead or per MQL. If in a given month marketing spending increases without a proportional increase in generated leads, the cost per lead will spike. This is not necessarily negative if it responds to a planned investment (for example, the launch of a campaign), but it is worth monitoring whether the impact translates into results in the following months.
• Customers needed to cover expenses. This monthly figure works as an operational break-even indicator. If the number of customers needed grows faster than actual active customers, the model is losing sustainability. In the sample data, this indicator evolves from 3 customers in January to 26 in December, which should be interpreted in the context of the evolution of the actual customer portfolio.

Likewise, the tool calculates economic KPIs individually for each customer in the mini portfolio, allowing not only the model as a whole to be assessed, but also performance to be compared across customers:

• CAC (Average acquisition cost). It is the same for all customers, since it is calculated as total cost divided by the number of customers in the portfolio. It represents the average investment needed to bring each customer into the business.
• LTV (Customer lifetime value). It varies significantly across customers. In the sample data, LTV ranges from €13,800 (customer 5) to €61,400 (customer 8). This difference reveals that not all customers contribute the same value and that it is essential to identify which customer profiles generate the highest return.
• LTV/CAC ratio. It is the most relevant indicator for assessing model sustainability. As a general reference:
  • LTV/CAC > 3: the model is healthy and sustainable. Every euro invested in acquisition generates a significant return.
  • LTV/CAC between 1 and 3: the model works, but the margin is tight. It is advisable to work on improving retention or reducing acquisition costs.
  • LTV/CAC < 1: the model is not viable in its current state. Money is lost with every customer acquired.

In the sample data, all customers show ratios well above 3 (from 11.8 to 52.6), which indicates a highly profitable acquisition model. However, in very early stages these figures should be interpreted with caution, since LTV may be overestimated if the customer relationship has not yet had enough time to develop.

• Payback period. This indicates how long it takes to recover the acquisition investment for each customer. The lower it is, the faster cash is freed up to reinvest in growth. In the sample data, payback ranges from 0.02 to 0.08 years, that is, between approximately one and four weeks. A payback period of less than 12 months is usually considered positive for early-stage startups.
• Margin per customer. This represents the net profit left by each customer after deducting the acquisition cost. It makes it possible to prioritize customer segments or profiles that generate the greatest contribution to the business. In the sample data, margin ranges from €12,632 to €60,232, making it possible to clearly identify which customers are most valuable and direct commercial efforts accordingly.

How to interpret the indicators

The greatest value of this tool lies in the possibility of reading the results in a cross-cutting way, connecting sales activity with its economic impact:

• If conversion rates are good but CAC is high, the problem may lie in operating costs (oversized sales team, inefficient marketing campaigns) rather than in the sales process itself.
• If total conversion is low but LTV per customer is high, it may be worth investing in improving the strategies of the funnel stages with the greatest drop-off, since each customer retained will have a high economic impact.
• If the number of customers needed to cover expenses grows faster than active customers, the model may not be sustainable in the medium term, even if individual KPIs appear positive.
• If some customers show an LTV/CAC much higher than the rest, it is advisable to analyze what those profiles have in common (sector, size, use case) in order to focus future acquisition on similar segments.

This integrated reading is especially useful when preparing meetings with investors, mentors, or accelerators, since it allows you to communicate not only the status of the funnel, but also the economic logic behind each commercial decision.

How is it used?

1. Define your commercial starting point. Enter the number of leads generated in the first month and the expected monthly growth. This data allows the tool to project the evolution of the volume of opportunities over time.
2. Set the conversion rates of your funnel. Indicate the conversion percentages between the different stages (lead, MQL, SQL, interview/demo, MVP user, and customer). Even if they are initial estimates, they will help you model the behavior of your sales process.
3. Add the monthly costs associated with acquisition and conversion. Enter marketing, sales, and, if applicable, product or support costs. There is no need to break down costs by stage: the tool automatically allocates them throughout the funnel.
4. Enter data for a small customer portfolio. Add representative information about some customers (monthly revenue, estimated gross margin, and expected relationship duration). Based on this, the tool calculates customer lifetime value (LTV) and expected revenue.
5. Review the results and key indicators. Analyze the costs by stage, average acquisition cost (CAC), LTV, the LTV/CAC ratio, and the payback period. These indicators will allow you to assess whether your sales model is sustainable.
6. Interpret the results and make decisions. Use the information obtained to identify bottlenecks in the funnel, adjust your marketing and sales actions, prioritize improvements with the greatest economic impact, and clearly and professionally communicate the status of the project to external stakeholders.

Download the template and start using it to understand how your commercial traction is progressing, identify opportunities for improvement, and communicate your progress clearly and professionally.