Profit Margin Calculator

You are a financial analyst specializing in profitability analysis across industries. You understand that profit margin works on three levels, gross, operating, and net, and each one reveals a different layer of how efficiently a business converts revenue into profit. Your role is to compute each margin, compare results against industry benchmarks, and deliver actionable recommendations that improve the bottom line.

I need a complete profit margin analysis for [BUSINESS_NAME], which operates in the [INDUSTRY:select:Retail,E-commerce,Manufacturing,Food and Beverage,Professional Services,Healthcare,Technology,SaaS,Construction,Hospitality,Transportation,Education,Agriculture,Other] sector. Present all figures in [CURRENCY:select:USD,EUR,GBP,CAD,AUD].

The analysis covers the [ANALYSIS_PERIOD:select:monthly,quarterly,annual] period. Total revenue is [REVENUE]. Cost of goods sold, including raw materials, direct labor, and production costs, totals [COST_OF_GOODS_SOLD]. Total operating expenses, covering rent, salaries, marketing, insurance, utilities, and administrative overhead, amount to [OPERATING_EXPENSES].

Start with the gross profit margin. Subtract cost of goods sold from revenue to get gross profit, divide gross profit by revenue, and multiply by 100. Explain what the result means in plain terms. State whether it falls within a healthy range for the selected industry, using benchmarks such as 50 to 70% for SaaS, 30 to 50% for professional services, 20 to 40% for retail, and 10 to 25% for manufacturing and food service.

Next, calculate operating profit margin. Subtract operating expenses from gross profit to get operating income, then divide by revenue and multiply by 100. If operating margin is significantly lower than gross margin, flag the gap and show a breakdown of each major operating expense as a percentage of revenue so the business owner can see exactly where money is going.

Then compute net profit margin. Subtract interest, taxes, and any non-operating costs from operating income to find net profit, then divide by revenue and multiply by 100. Position the result against general benchmarks: below 5% is thin, 5 to 10% is average, 10 to 20% is strong, and above 20% is exceptional. Also compare against norms for the specific industry.

If data is available for [PRODUCT_LINES?], break down gross margin for each line separately. Rank them from highest to lowest so the business can identify which offerings generate the most profit per revenue dollar and which may be pulling overall margins down.

If competitor or industry average margins are available at [COMPETITOR_MARGINS?], create a comparison table showing the business alongside each competitor for all three margin types. Note whether performance sits above or below the competitive set.

Include a margin trend section. If prior period data is available, show how each margin has changed and calculate the percentage point shift. A gross margin dropping from 42% to 38% over two quarters deserves immediate attention, while a net margin rising from 8% to 11% signals that cost control is working.

Close with a targeted improvement plan. If gross margin trails the industry average, explore supplier renegotiation, production efficiency, or pricing adjustments. If operating margin is the weak point, target the largest expense categories for reductions. If net margin lags despite healthy operating margins, investigate interest expense and tax planning opportunities. Provide two to four prioritized recommendations with estimated margin impact so the business owner can move from analysis to action immediately.