Profitability Analysis Guide: Methods, Levels, and a Worked Example

Quick Takeaways: Profitability Analysis

• Margin Expansion Is Raising the Stakes: S&P 500 net margins climbed from a 5.85% historical average to 9.75% in 2024, and quarterly blended margins have run higher still since.
• Pricing Outperforms Volume for Profit Growth: A 5% price increase delivers 33% operating income growth versus only 20% from a 5% volume increase, making pricing strategy the stronger profit lever.
• Technology Gives Finance Teams a More Current View of Profitability: Half of CFOs named finance digital transformation as their top priority for 2026, while 49% pointed to automation as their top finance-talent priority. Finance teams need current margin data and the ability to test scenarios as conditions change.
• Industry Benchmarks Put Margins in Perspective: Average gross margins sit at 36.56% and net margins at 8.54%, but those figures vary widely between industries. Comparing a company against businesses in its own sector gives its profitability metrics much more useful context.
• Company-Wide Numbers Hide the Real Story: A healthy company-level margin can mask unprofitable products, customers, or channels. Activity-based costing and contribution margin analysis are what make product profitability analysis and customer profitability analysis possible in the first place.

The primary purpose for establishing and maintaining any business is to generate profit. From the moment of conception onward, all activities of the business are focused on creating, growing, and maximizing profit. The organization’s key leaders use a variety of tools to help them identify ways to grow and maximize the bottom line. Profitability analysis is one such tool, and it works best when it’s run at more than one level of the business, not just the company as a whole.

Across all industries, the average gross profit margin is 36.56%, while the average net margin is 8.54%, according to industry benchmark data. For example, the S&P 500 finished 2024 with a net margin of 9.75%, well above its 5.85% average from 1989 to 2015. Quarterly figures have run higher since: FactSet put the blended net profit margin at 13.2% for Q4 2025 and 16.9% for Q2 2026, though the Q2 figure falls to 15% excluding Alphabet and Amazon, whose results carried large one-off gains. Much of that increase has come from the growing weight of high-margin technology companies.

In turn, finance leaders are putting more emphasis on technology and operational improvements that can protect margins and get more from existing resources.

What Is Profitability Analysis?

Profitability analysis is an analytical process that seeks to reveal information about the various revenue streams of the organization. It helps leaders identify ways to optimize profitability and is used to assist in Enterprise Resource Planning (ERP).

Advancements in ERP solutions have enabled analysts to gather more transparent and insightful information. This information is used in various ways to analyze profitability as it relates to customers, vendors, locations, and product lines.

One common misconception of profitability analysis is that it’s purely quantitative. Analyzing profitability requires a combination of both quantitative and qualitative analytics. This helps provide leaders with a more robust view of the various profit drivers in the business and how to maximize them.

For a closer look at how the underlying systems differ, see CPM vs ERP next.

Profit vs Profitability: What Is the Difference?

Profit and profitability sound like the same thing, but they answer different questions. Profit is a dollar amount: revenue minus expenses, the money left over after the bills are paid. Profitability is a ratio. It measures how well a business turned its revenue, assets, or equity into that profit.

A business can make more profit every year without becoming more profitable. If costs rise right alongside sales, margins can get thinner even as the total profit number goes up.

Profitability analysis puts that number in context. It shows how much revenue or capital the business needed to produce its profit, which is why two companies with the same profit can have very different levels of profitability.

Levels of Profitability Analysis: Company, Product, Customer, and Channel

Profitability analysis works at more than one altitude. The same profit-and-loss statement that shows how the whole company performed can be broken down again, by product, by customer, and by channel, until it shows exactly where the money is actually coming from.

Company-Level (Aggregate P&L)

→

Product-Level (Margin by SKU)

→

Customer-Level (Margin by account)

→

Channel-Level (Margin by channel/region)

 Company-Level Profitability Analysis

This is the broadest version of profitability analysis and probably the one your finance team already uses. It looks at company-wide margins, one overall break-even point, and how the business stacks up against industry benchmarks.

That makes it useful for board reports and high-level planning, but there’s a downside to looking at the business as one big number. Strong overall margins can make it easy to miss products or customers that are losing money behind the scenes.

Product Profitability Analysis

A product that brings in the most revenue is not automatically the product making the most money. Product profitability analysis accounts for the full cost of each SKU, including its share of overhead, storage, support, and other shared expenses.

Once those costs are assigned properly, the picture can change quickly. A high-volume product may turn out to have razor-thin margins or even lose money. Activity-based costing, which we cover below, provides one way to allocate those shared costs more accurately.

Customer Profitability Analysis

Customer profitability analysis looks at what each customer contributes after accounting for the cost of serving them. This ties closely to the 80/20 rule discussed later: your biggest customers by revenue are not always your most profitable.

A customer that places frequent small orders or requires a lot of support can bring in substantial revenue while contributing very little profit or even losing the business money. Pairing profitability with a retention metric like GRR vs NRR can help finance teams see which customer relationships are most valuable to keep.

Channel- and Location-Level Profitability Analysis

The same logic applies to how and where a business sells. A retailer might find its e-commerce channel is more profitable than its physical stores once real estate and staffing costs are allocated in, even though the stores bring in more revenue.

A multi-location business can run this same analysis by region to see which locations are carrying the company, and which are being carried by it.

Profitability Analysis Methods

There are various methods used to analyze profit. Each method utilizes a different approach to provide some insight into profitability. While each business might differ slightly in how it personally conducts its profit analysis, these methods are commonly used in the regular course of business.

Ratio analysis and break-even analysis, covered first, work at the company level. Activity-based costing and contribution margin analysis, covered next, are what make product profitability analysis and customer profitability analysis possible in the first place.

Profitability Ratio Analysis

Ratio analysis is a method that combines the use of margin ratios and returns ratios. The ratios are analyzed both individually and comparatively with the broader industry standards. Margin ratios are concerned with a profit margin at various levels, while return ratios focus on how effective the business is at using its resources to generate income. Generally speaking, the higher the ratio, the better.

Gross Profit Margin (%) = Gross Profit ($) / Sales ($)

Gross profit margin is the percentage of sales revenue remaining after deducting the cost of goods sold. Both COGS and total sales can be located on the income statement. The ratio examines how effectively a business is managing its cost of inventory and the manufacturing of its products. It’s also used as a way to measure the ability of the business to pass its COGS on to its customers.

Operating Profit Margin (%) = EBIT ($) / Sales ($)

Operating Profit Margin is another margin ratio that is used as a way to understand how efficient a business is at managing its operations. Operating margin is a company’s earnings before interest and taxes (EBIT). It builds on gross profit margin as it layers in the impact of ordinary operating expenses, or overhead.

Net Profit Margin (%) = Net Income ($) / Sales ($)

Net Profit Margin is the most commonly used margin ratio and is the percentage of net income to sales. This ratio considers net income after accounting for all expenses of the business.

Cash Flow Margin (%) = Cash Flow From Operating Activities ($) / Sales ($)

Cash Flow Margin is the final margin ratio. It illustrates the relationship between cash generated during the normal course of operations and sales. The ratio is used to understand how effective the business is at converting sales to cash. It relies on information from both the income statement and statement of cash flows.

ROA (%) = Net Income ($) / Total Assets ($)

Return on Assets (ROA) is a return ratio that demonstrates the business’s ability to generate profits using its assets. It measures profitability as it relates to the investments that have been made into the organization’s total assets. It compares net income from the income statement to total assets on the balance sheet.

ROE (%) = Net Income ($) / Total Shareholders’ Equity ($)

Return on Equity (ROE) is a return ratio that reveals the return that the business has generated for its investors. It compares shareholders’ equity on the balance sheet to net income.

Cash Return on Assets (%) = Cash Flow From Operations ($) / Total Assets ($)

Cash Return on Assets is a return ratio used to eliminate the potential noise created by accounting policies by comparing cash generated from operations to total assets. It measures how effective the business is at generating cash with its assets.

Break-Even Analysis

Break-even analysis is used to identify how much revenue is needed to cover all fixed and variable expenses. It’s the point at which net income is zero and expenses equal revenue exactly. It’s one of the most common business metrics, since it’s a safety calculation that shows how much in sales has to be achieved to remain operating.

Activity-Based Costing (ABC)

Traditional overhead allocation spreads shared costs (rent, admin, support, IT) evenly across products or customers, usually based on something simple like headcount or revenue share. The problem is, an even split rarely reflects reality. A low-revenue customer who calls support every week can cost more to serve than a high-revenue one who never does.

Activity-based costing solves this by tying overhead to the activities that create the cost in the first place. Rather than dividing a $150,000 support budget evenly across every customer, ABC looks at factors such as order volume or service hours and assigns each account its share based on what it actually uses.

The result is a far more accurate picture of who is actually profitable. It takes more setup than a flat allocation, but it’s what makes product profitability analysis and customer profitability analysis defensible rather than a guess.

Contribution Margin Analysis

Contribution margin analysis gives finance teams a quick way to compare products or customers before getting into the details of activity-based costing. It focuses on revenue minus variable costs, leaving fixed and shared overhead out of the calculation.

Contribution Margin (%) = (Revenue – Variable Costs) / Revenue

This makes the analysis much easier to run than a full ABC model. It’s useful for spotting which products or customers appear strongest or weakest first, so teams can save the more detailed cost allocation work for the areas that warrant it.

Method Comparison

Method	What It Answers	Data Required	Best For
Ratio Analysis	How margins and returns compare over time and to industry benchmarks	Income statement, balance sheet, cash flow statement	Company-wide performance tracking
Break-Even Analysis	How much revenue is needed to cover all costs	Fixed costs, variable costs, sales price	Setting sales targets and pricing floors
Activity-Based Costing	Which products or customers are profitable once true cost to serve is allocated	Activity data (orders, tickets, hours) plus overhead pool	Product profitability analysis and customer profitability analysis
Contribution Margin Analysis	Which product or customer contributes more after variable costs	Revenue and variable costs only	A fast first pass before full ABC

 Example: Profitability Analysis in Action

Here’s a simplified profitability analysis example comparing two customers of the same manufacturing business.

Customer A has higher revenue, but it also generates more orders and more support work. Customer B buys in larger batches, which means fewer orders to process and fewer support requests.

Since their variable costs are the same relative to revenue, that difference is easy to miss at first. Once the roughly $300 in shared cost per order is applied across their 500 combined orders, their profitability starts to look very different.

	Customer A	Customer B
Revenue	$500,000	$400,000
Variable Costs (COGS)	$300,000	$240,000
Contribution Margin	$200,000 (40%)	$160,000 (40%)
Orders Processed	400	100
Allocated Overhead (ABC)	$120,000	$30,000
Net Profit	$80,000	$130,000
Net Profitability Margin	16%	32.5%

Customer B generates 20% less revenue than Customer A, but its net profit is 62.5% higher and its profitability margin is more than double. Judged on revenue alone, Customer A looks like the better account. Judged on profitability, Customer B is the one worth protecting, and Customer A is the one that needs a conversation about pricing, order minimums, or service costs.

That’s the entire case for profitability analysis in one example: revenue tells you who is bigger, and profitability tells you who is actually worth it.

One Critical Assumption When Conducting Profitability Analysis

One broad observation across most organizations is that 80% of a business’s revenue is generated by just 20% of its customers. It’s sometimes referred to as the 80/20 rule. Oftentimes, this is misconstrued to mean that the 20% of customers driving the majority of the revenue are the most valuable.

The basic premise of conducting profitability analysis is to separate revenue from profit. While some customers may generate large amounts of revenue, they may not be as profitable as other customers.

In some cases, they may even be unprofitable. Steer clear of making broad assumptions about the quality of a customer until sufficient profit analysis has been completed.

How to Conduct a Profitability Analysis: A Step-by-Step Framework

To analyze profit sufficiently, it’s important to have a full set of financial statements, or financial reports: a balance sheet, an income statement, and a statement of cash flows.

Even more important is access to historical information and industry standards. At a minimum, profitability should be viewed over time, and trends should be identified in the resulting analysis.

Step 1: Calculate Break-Even

Break-even analysis should be performed first. This helps establish how many units need to be sold to break even. Taking it further, perform a break-even analysis on customers to identify how many units must be sold to each customer to break even.

Finally, it’s important to subject the break-even analysis to “what-if” planning or scenario-based plans. This helps in understanding the points at which your break-even becomes unsustainable, and it can illuminate ways to reduce it.

Step 2: Ratio Analysis

Using the ratios identified above, begin generating current profit ratios and return ratios for the period. If you haven’t already, compute the same ratios for prior periods. Graph the results to see how they trend over time and by customer. Look out for important trends, such as growing customer orders paired with decreasing profit.

Step 3: Compare To Industry Standards

Finally, take all of the information gathered from your break-even analysis and your ratio analysis and compare it to industry standards. Doing this well provides context for how well the organization is doing.

For example, ROE might seem low, but when compared to other similar firms operating in the same industry, it could be the opposite. Without the context of how the organization is performing within its industry, it’s impossible to correctly benchmark any of the metrics created during the analysis.

Step 4: Break Down Results by Product, Customer, or Channel

Company-wide profitability tells you how the business is doing overall. It doesn’t necessarily tell you why. To answer that question, take the same break-even and ratio analysis down to the product, customer, or channel level. Contribution margin analysis   offers a quick way to spot differences, while activity-based costing gives you a more complete cost picture.

This is often the point where the useful insights appear. Products that looked successful based on revenue can turn out to be losing money, while certain customers or channels may be generating far more profit than expected. Without that breakdown, you can calculate profitability without learning much about where the business should focus next.

3 Common Challenges in Profitability Analysis

Although profitability analysis might sound straightforward on paper, most finance teams run into the same three obstacles when they actually put it into practice:

1. Data Fragmented Across Disconnected Systems

Revenue lives in the ERP, cost data lives in accounting, and customer activity lives in a CRM. Pulling all three into one model by hand, every period, is where a lot of profitability analysis efforts quietly stall out.

Learning how to consolidate financial data from multiple ERPs into one governed model is usually the real prerequisite to product- or customer-level analysis.

2. Disputes Over Indirect Cost Allocation

Even with good data, teams often disagree on how shared costs should be allocated. Should support cost be split by ticket count, revenue, or headcount? These disputes are exactly why activity-based costing exists, but the method still needs to be agreed on and applied consistently, or the numbers stop being comparable period to period.

3. Limited Time and Skills for Ongoing Analysis

Company-level ratio analysis is quick. Product-, customer-, and channel-level analysis is not, at least not by hand in a spreadsheet. Most teams have neither the analyst hours nor the skill set to rebuild an allocation model every month, which is why this level of analysis tends to happen once a year, if at all, instead of becoming part of the regular month-end close.

Best Profitability Analysis Tools and Software

Deloitte’s Q4 2025 CFO Signals survey found that 50% of CFOs cite digital transformation of finance as their top priority heading into 2026, and 49% point to automating processes as their leading finance-talent priority. A related finding from the same survey: 87% of CFOs expected AI to be extremely or very important to their finance department’s operations in 2026.

That gap between intent and execution is exactly where profitability analysis by product, customer, and channel tends to fall through the cracks. It’s detail-heavy, ongoing work, and manual spreadsheets handle it badly. Finance teams generally have a few options for best financial planning and analysis software when it comes to profitability work.

Datarails

Datarails FinanceOS is the AI Finance Operating System that sits under the margin model — a governed data layer connected to 600+ ERPs, CRMs, HRIS platforms, billing systems, and banks.

It consolidates and maps everything first, across multiple entities, currencies, and charts of accounts, so a customer profitability analysis or product profitability analysis runs against finance-adjusted numbers rather than raw system output. Activity data lands in the same structure as revenue, which is what turns cost allocation into something you configure once instead of rebuilding every month.

Because the layer is governed rather than tool-specific, the same numbers feed whichever interface the team prefers: Datarails’ own agents or a general-purpose AI engine:

• Reporting Agent — surfaces variance analysis and driver-level detail on actuals, with dashboards that double as financial dashboard software for tracking margin between cycles
• Planning Agent — ad hoc scenario work, like a price increase or a customer mix shift, without rebuilding the model; the financial forecasting guide covers the approach in more depth
• Strategy Agent — turns margin data into trade-offs and recommendations ahead of a pricing or account decision
• Insights and Storyboards — scheduled summaries and board-ready narrative built from the approved figures
• Third-party AI engines — Claude, ChatGPT, and Microsoft Copilot, connected via Model Context Protocol, for teams that would rather work in the AI tool they already use

All of it sits on top of Excel, where the models and years of institutional formulas stay intact. That’s the practical difference for a team of FP&A analysts running segment-level margin monthly rather than annually, and it’s the pattern this guide to AI in FP&A describes.

Other Tools Worth Knowing

Datarails isn’t the only option, and it’s worth talking about some of the other options to consider.

ERP-native profitability reporting, like SAP’s CO-PA module, is strong on transaction-level detail but tends to be slower and less flexible for an ad hoc cut, like a one-off customer profitability analysis ahead of a renewal conversation.

Dedicated BI and reporting tools (like insightsoftware and Jedox) do well at pulling data across systems into one report, but typically need more setup and IT involvement than an Excel-native FP&A layer. Spend and expense platforms, including Ramp, surface cost-side savings that feed a profitability model. That said, they aren’t a substitute for full margin analysis on their own.

Conclusion

Profitability analysis works best when it operates at more than one level. Company-wide ratios show whether the business overall is healthy. Product, customer, and channel analysis show why, and where the next dollar of margin improvement is actually going to come from.

The approaches covered in this guide, ratio analysis, break-even analysis, activity-based costing, and contribution margin analysis, give you the method. Running them consistently, every period, at every level, is what turns profitability analysis from a once-a-year spreadsheet exercise into a real management tool.

If manually allocating costs across products, customers, and channels every month sounds like more time than your team has, that’s exactly the kind of work Datarails takes off your plate.

Profitability Analysis FAQs