Net margin and markup comparison
Several net-of-tax items with cost, price and quantity. Margin is based on revenue and markup on cost. A zero denominator is undefined, not zero.
- Runs in your browser
- No upload
- Check before download
Several net-of-tax items with cost, price and quantity. Margin is based on revenue and markup on cost. A zero denominator is undefined, not zero.
Calculations run locally and inputs are not saved automatically. Download an input backup before closing the tab. Input data, formulas and filenames are never sent. Only with your optional consent, Refentra sends aggregate counts of actions and outcomes, without input content.
What are the limits?
Maximum amount 1 trillion units; total 100 trillion cents. Up to 100 rows, 50 people, 20 tiers, 100 depreciation years, 1,200 schedule periods, 61 cash flows. IRR range −99% to 1,000% per interval, numerical candidates only. Rates: up to eight decimals. Backup: 1 MiB. CSV formula-leading text gets an apostrophe. Use decimal points, no thousands separators.
Amounts use two decimals in your stated unit. Exact decimal inputs; cent rounding half away from zero. Table sums balance. Largest fractional remainders receive shared cents; equal remainders use row order. No tax, fees, legal entitlement or current prices are inferred.
Non-monetary values are shown with up to ten significant digits. CAGR, fractional-year inflation and IRR use numerical approximations; IRR candidates are not a symbolic proof. CSV keeps the numeric values before display rounding.
π = R−C; m = 100π/R; u = 100π/C
Calculate with your own assumptions
- Enter the inputs
Confirm that your amounts are net, then enter each item’s cost, sale price and whole-number quantity. Use the same currency and the same net basis throughout. Enter decimals with a point and without thousands separators.
- Check a worked example
Cost 60, price 100, quantity 2: cost 120, revenue 200, profit 80. Margin=80/200×100=40%; markup=80/120×100≈66.6667%.
- Interpret and save the result
Margin divides by revenue, and markup divides by cost. The total uses the summed costs and revenue, not an average of the row percentages. Save the row and total figures as CSV.
Method, errors and limits
Can I reopen editable inputs from the CSV?
The CSV is a report of the results, not a backup of your inputs. Download the separate JSON input backup before you close the page, then import it into this same tool to edit your assumptions again. Import accepts files up to 1 MiB and checks that the file belongs to this tool. Inputs are not saved automatically.
Which input mistakes should I check?
You have to confirm that the amounts are net; the tool doesn't strip out tax. Quantity must be a whole number from 1 to 1 e 9. With zero revenue, margin is undefined, and with zero cost, markup is undefined, not 0%.
What are this model’s limits?
Up to 100 items. This compares the unit costs and prices you enter. Overhead, returns, tax and fees are left out unless you have already included them consistently in your inputs. The tool doesn't recommend a selling price.