Scenario presets
Income Statement Inputs
Multi-Tier Margin Results
Calculating profit margins...
- Gross profit ($)
- -
- Gross profit margin (%)
- -
- Operating profit (EBIT) ($)
- -
- Operating margin (%)
- -
- Net income ($)
- -
- Net profit margin (%)
- -
- Markup on direct cost (COGS)
- -
- Operating overhead burden (OpEx / Rev)
- -
Sensitivity Analysis 1: Revenue vs. COGS on Gross Margin %
Gross margin percentage across pricing power shifts and direct cost inflationary pressure.
| Revenue \ COGS | -20% | -10% | Base | +10% | +20% |
|---|
Sensitivity Analysis 2: Overhead SG&A vs. Revenue on Net Profit Margin %
Bottom-line net profit margin percentage as fixed operating expenses scale against top-line sales.
| OpEx \ Revenue | -20% | -10% | Base | +10% | +20% |
|---|
Income Statement Waterfall Breakdown
| Tier / Financial Item | Amount ($) | % of Revenue |
|---|
Formulas and worked example
- Gross Profit = Revenue - COGS
- Gross Margin % = (Gross Profit / Revenue) × 100
- Markup on COGS % = (Gross Profit / COGS) × 100
- Operating Profit (EBIT) = Gross Profit - Operating Expenses
- Operating Margin % = (EBIT / Revenue) × 100
- Net Profit Margin % = (Net Income / Revenue) × 100
A software company achieves $2,000,000 in revenue with $440,000 in hosting and customer success COGS, yielding a $1,560,000 gross profit (78.0% gross margin, 354.5% markup). Operating expenses of $1,000,000 leave $560,000 in EBIT (28.0% operating margin). After $20,000 in financing interest and $110,000 in taxes, net income is $430,000, or a 21.5% net profit margin.
Self-check quiz
1. Gross profit margin is calculated as:
2. If an item costs $40 to produce and is sold for $80, the gross margin is 50%, while the markup on cost is:
3. Operating margin measures:
4. A company with high gross margins and negative net income most likely has:
Frequently asked questions
What is the difference between gross margin, operating margin, and net margin?
Gross margin reflects revenue remaining after direct production costs (COGS). Operating margin subtracts operating expenses (SG&A, R&D, marketing) from gross profit to show core business profitability. Net profit margin subtracts non-operating expenses, interest, and taxes, representing the final bottom-line dollar return per hundred dollars of revenue.
How do you convert between markup percentage and gross profit margin?
Markup is calculated as gross profit divided by cost of goods sold (COGS), while gross margin is gross profit divided by sales revenue. For example, a 50% gross margin corresponds to a 100% markup on cost.
Why can a business have high gross margins but still lose money?
A company can generate impressive 80% gross margins on its products but still report a net operating loss if overhead expenses (salaries, headquarters rent, marketing campaigns, software infrastructure) exceed total gross profit dollars.
What are typical healthy profit margin benchmarks across industries?
Software and SaaS firms often boast 75-85% gross margins and 15-25% net margins. Traditional retail and grocery stores operate on much lower gross margins (20-35%) and slim net margins (2-5%), relying on high inventory turnover to generate return on capital.