Gross Margin Calculation Tool by Business Line

The purpose of this tool is to help you understand the real contribution of each business line, beyond total revenue, allowing you to calculate the gross margin per line. Its value lies in providing structural clarity, identifying cost pressures and enabling comparisons that support informed decision-making.

Template sections explained in detail

The template is structured into two blocks that represent the full analysis flow: model and dashboard. Each sheet has a clear purpose and complements the other to offer an accurate view of the gross margin by business line.

1.    Model. Revenue, direct costs and gross margin calculation per line

This block brings together all the economic information required to calculate gross margin.

In the revenue section you enter units, unit price or direct revenue as applicable, and the model automatically calculates totals.

Next, the direct variable cost section includes those expenses that depend directly on the level of activity, disappear if the line stops operating and are necessary to deliver the product or service. They are considered direct because they can be assigned unambiguously to a specific business line: they are tied to the volume produced or sold and vary proportionally with activity.

Common examples include: production, per-unit logistics, payment commissions, variable support, proportional tech infrastructure or freelancers linked to specific projects.

Finally, the results provide a consolidated view of the financial performance of each business line. For each line, revenue and direct costs are presented.

Using this information, the tool automatically calculates the gross margin in euros and as a percentage, allowing you to see how the contribution of each line varies and how the different model assumptions affect the results.

In addition to individual details, a global view with aggregated business totals is included, helping compare overall efficiency and identify trends in an integrated way. 

2.    Dashboard. Visual and comparative interpretation

The dashboard offers a synthetic visual representation of how the model works. You can check the total gross margin and its percentage, as well as quickly compare each business line through the evolution of its percentage gross margin. This visualization makes it easier to identify which lines drive performance, which are under pressure and how dynamics change when you modify the simulator assumptions.

How to interpret gross margin

Gross margin is calculated as: Revenue – Direct variable costs

A high gross margin indicates greater capacity to cover structural costs and generate profit, while a low or negative margin may signal pricing issues, operational inefficiencies or inadequate cost allocation.

It is important to remember that gross margin does not include structural costs such as central team, rent, administration or corporate marketing. These must be analysed later when evaluating operating margin.

Particularities in software companies

The strategic relevance of gross margin varies depending on the business model. In physical product companies, gross margin is especially critical, as production, materials or logistics costs represent a significant weight and scale directly with volume.

In software companies, especially SaaS models, the marginal cost of an additional customer is usually low. This generally leads to higher gross margins.

As a guideline, typical ranges in software companies are:

• Consolidated B2B SaaS: between 70% and 85%.
• Software with high dependence on cloud infrastructure: between 60% and 75%.
• Technological marketplaces: between 50% and 70%, depending on the model.

In these cases, although gross margin remains a relevant indicator, metrics such as customer acquisition cost (CAC), retention, churn rate or lifetime value (LTV) become especially important. Therefore, the analysis must be integrated within a broader view of the economic model.

Download the template and start using it to precisely understand how each business line contributes to the sustainability of your project, identify margin improvement opportunities and make decisions based on real data, not intuition. 

This resource is part of the set of tools that Plataforma ONE makes available to the innovative entrepreneurial ecosystem in Spain. You can access this and many other templates through the “Tools and templates” section of our website.