“Why would I use MarginGuides if I can calculate this in Excel?”
It is a fair question, and a good one to ask before adding any new tool to your business.
Excel is one of the most capable and widely used business tools ever made. Many sellers, importers and distributors already price their products in a spreadsheet, and many of them do it well.
So this article does not argue that Excel is the wrong tool. In many situations, it is exactly the right one.
The more useful question is:
“At what point does a margin calculation become a decision that deserves more structure?”
When Excel is enough
If your situation is simple, a spreadsheet is often all you need.
For example:
- you sell a small number of products
- your costs and fees rarely change
- you buy and sell in one currency
- there are no import duties or customs costs to consider
- you calculate margins occasionally, not for every deal
In that case, a few cells do the job:
Profit = Selling price − Costs
Profit margin % = Profit ÷ Selling price × 100
If you sell a product for $100 and your costs total $70, your margin is 30%. You do not need specialist software to work that out.
If this describes your business, keep using Excel. A tool should earn its place.
Where spreadsheets become harder to manage
The difficulty rarely comes from the arithmetic. It comes from the number of moving parts and how they interact.
A realistic deal-level calculation may need to include:
- purchase cost in a supplier's currency
- an exchange rate into your selling currency
- inbound and outbound shipping
- packaging and warehousing
- marketplace fees
- payment processing fees
- sales commissions
- customs duty, calculated on a customs value
- taxes such as VAT, GST or sales tax
- expected returns and the cost of handling them
- the target margin you want the deal to reach
Each of these can be modelled in a spreadsheet. But as the model grows, so does the work of keeping it right.
Some common challenges:
Formulas drift. A sheet copied for a new product or market can carry an old assumption, a broken reference or a range that no longer covers every row.
Blank cells can count as zero. If an exchange rate or a fee is missing, a formula may still produce a confident-looking result.
Rules are applied inconsistently. Is duty calculated on the purchase cost alone, or on a value that includes freight and insurance? Is a fee charged on the price before or after tax? Different sheets can answer differently.
Context gets mixed up with cost. An Incoterm such as FOB or DDP describes who is responsible for what. It does not, by itself, tell you what the freight or the duty will cost. Those still have to be entered as real numbers.
What-if questions multiply the work. Testing a higher freight cost, a weaker currency or a higher marketplace fee often means copying sheets, adding scenarios or building data tables, and then keeping all of them in sync.
None of this makes Excel a bad tool. It means the person maintaining the spreadsheet is also its designer, tester and auditor.
Margin calculations vs decision-making
A margin calculation answers one question:
“What margin does this deal produce with these numbers?”
A decision usually needs several more:
- Does the deal meet my target margin, and by how much does it miss or beat it?
- What is the break-even price?
- What selling price would reach my target?
- What happens if freight, fees or the exchange rate move against me?
- Which of those changes would hurt the most?
- How far could a cost rise, or how far would it need to fall, before the deal meets or misses my target?
That last kind of question is about a switching point: the value at which a deal moves from acceptable to unacceptable, or the other way round.
Excel can answer all of these. Goal Seek, data tables and scenario sheets exist for exactly this purpose. But each answer is something you build and maintain yourself, and the effort grows with every question you add.
That is the real difference this article is about:
Excel helps you calculate. MarginGuides helps you decide.
How MarginGuides approaches the problem
MarginGuides is built around one question: should you go ahead with this deal, given what it will really cost you?
It is designed to help you evaluate a deal before you commit capital to it: before the purchase order, the shipment or the listing.
Every tool below uses the same underlying calculation, so a stress test or a required value is consistent with the analysis it starts from.
Analyze
You enter the deal: purchase cost and its currency, selling price and currency, shipping and other operating costs, marketplace, payment and commission fees, customs duty and customs value, tax, and expected returns.
MarginGuides returns the real profit and margin, the break-even price and, if you set a target margin, the selling price needed to reach it, together with a plain-language decision based on profit and the gap to your target.
Nothing is assumed on your behalf. If the purchase cost is in a different currency from the selling price, you supply the exchange rate; MarginGuides does not invent one. The Incoterm you select is recorded as context and never adds freight, insurance or duty by itself. The components of your landed cost are entered explicitly.
Stress Test
Stress Test applies an explicit change to the scenario you analyzed, such as a higher purchase cost, a higher marketplace fee or a different exchange rate, and compares the result with the baseline, including whether the decision changes.
Resilience
Resilience runs several adverse changes against the same baseline and shows which one would cost the most profit. It compares only the changes you choose. It is not a forecast, and it does not estimate how likely any of them is.
Improve My Margin
Improve My Margin works backwards from your target. Choose one cost or fee, and it solves for the value that would bring the deal exactly to your target margin.
If the deal is below target, that is the reduction required. If it is already above target, it shows how much headroom you have before that cost or fee would take you below it. It is a practical way to find a switching point for one variable at a time, with every other input held constant.
Saved analyses
Analyses can be saved to your account, so you can come back to a deal and see the inputs and results it was based on.
Excel vs MarginGuides: a fair comparison
| Excel | MarginGuides | |
|---|---|---|
| Simple, occasional margin calculations | Fast and perfectly adequate | Works, but may be more than you need |
| Flexibility | Almost unlimited: you can model anything you can build | Focused on product and deal margin decisions |
| Setup | You design the layout, formulas and checks | Structured inputs for costs, fees, customs, tax, FX and returns |
| Consistency across deals | Depends on how each sheet was built and maintained | The same calculation method for every analysis |
| Missing inputs | A blank cell may count as zero unless you add checks | Inputs are validated; a cross-currency deal needs an explicit exchange rate |
| Break-even and target price | Possible with formulas or Goal Seek | Calculated as part of each analysis |
| What-if scenarios | Possible with copied sheets, data tables or scenario tools | Stress Test and Resilience compare changes against the same baseline |
| Solving for one cost or fee | Goal Seek, set up one question at a time | Improve My Margin solves the required value for a chosen cost or fee |
| Data sources | Can connect to other data if you set it up | Values are entered by you; no live data feeds |
| Wider business use | Budgets, forecasts, inventory, reporting and much more | Margin decisions only |
Neither column wins every row. They are designed for different jobs.
Who should keep using Excel
Excel is probably the right choice if:
- your products, costs and fees are stable
- you buy and sell in one currency
- you rarely need to test what-if scenarios
- you already have a well-built, well-maintained pricing model that you trust
- you need a model that covers far more than margin, such as inventory or cash-flow planning
There is no reason to replace something that works.
Who may benefit from MarginGuides
MarginGuides may be useful if:
- you evaluate new deals, suppliers or markets regularly
- your deals involve imports, customs duty or more than one currency
- you sell through marketplaces or channels with several layers of fees
- you want to know your break-even and target price before you quote or list
- you want to test a deal against higher costs, higher fees or exchange-rate moves before committing
- you would rather not rebuild and re-check a spreadsheet model for every new deal
Many businesses will use both: Excel for wider planning, and MarginGuides for the decision on a specific deal.
Conclusion
Excel is a powerful, flexible tool, and for simple margin calculations it is often all you need.
The challenge appears when a margin stops being a single calculation and becomes a decision with many inputs, more than one currency and real uncertainty. At that point, the useful question is not only “What is my margin?” but “Should I do this deal, and how much could change before it stops working?”
No tool removes the need to enter accurate numbers or to use judgement. But a structured approach can make it easier to see the full picture before money is committed.
Excel helps you calculate. MarginGuides helps you decide.