FINANCIAL OFFERS
MERCATUS Crypto Direct — Discount Model
Crypto OTC transaction-cost model for deals priced as a discount off market reference using the gross/net convention. Defaults to BTC at $65,000 with 100-coin sample volume. Models buyer pay-per-coin, seller receive-per-coin, broker spread, and the crypto-specific cost stack.
Free updates to all future v2.x releases included
Buy NowDelivered by email within 1–24 hours.
Most within 1–2 hours (US Eastern Time).
The workbook structure
The MERCATUS workbook is organized into a consistent set of tabs. Every tab carries forward the discipline and data that the next tab depends on.
License — proof of ownership
License tab. Confirms your purchase, terms of use, version number, and free-updates entitlement. Also controls tier visibility for distributed copies.
Summary — deal-at-a-glance
Summary tab. All key positions visible on a single page. Updates automatically as you enter values on the working tabs — gross deal value, total expenses, all-in cost, P&L, intermediary chain status, settlement architecture.
Read Me — five-minute orientation
Read Me tab. Walks you through what each tab is for, the terminology and glossary, and how the pricing model is applied. Read this first; saves hours on every deal you model afterwards.
Simple — fastest deal modeling
Simple tab. Minimal entry for fast modeling. Enter the values that matter, see the result. The Simple tab gives you the headline numbers without forcing you through the full Buyer/Seller granularity.
Buyer — full cost stack
Buyer tab. Full buyer-side cost stack: deal terms, the eleven common-backbone cost items (refining, custody, paymaster fees, regulatory costs, and more), user-defined cost rows for deal-specific items, intermediary chain with one mandate per side and facilitator brokers below.
Chain View — settlement visualization
Chain View tab. Full settlement-flow visualization from buyer through the intermediary chain to seller. Every party in the chain visible. Useful for sanity-checking that fees coordinate correctly across SPA, IMFPA, and sub-fee agreements before any bank diligence review.
Also included: Seller tab (mirror of Buyer for the sell side), Intermediaries tab (broker-chain detail with one mandate per side), Reference tab (glossary, standards, and cross-references).
How the pricing model works
In the Discount Model for crypto OTC, deal pricing uses the gross/net convention applied against a market reference (typically spot or a published index). Gross discount is what the seller absorbs. Net discount is what the buyer realizes. The spread funds the intermediary chain. The Discount Model is built for the dominant pricing pattern in broker-mediated crypto OTC.
From input to output
Enter your gross/net quote and the reference price (defaults to BTC at $65,000) on the Simple tab. The model computes buyer pay-per-coin, seller receive-per-coin, broker-pool spread, and applies the crypto-specific cost stack (gas, on/off-ramp, custody, KYC/Travel Rule, source-of-funds analytics, sanctions screening). Glossary covers NCNDA + fee-agreement architecture for crypto OTC.
The common-backbone cost items
Every transaction has eleven common cost categories the workbook computes automatically: refining and quality verification, custody and storage, paymaster fees, legal counsel fees, regulatory compliance, settlement venue fees, FX conversion, escrow, and three more. You add deal-specific costs as user-defined rows. The model rolls everything into the all-in cost per unit and net P&L.
Free updates to v2.x
Every purchase includes free updates to all future v2.x releases. When a new version of this worksheet is published, you receive the updated file at the email address you provided at checkout.
Sample output
The screenshots above show the workbook populated with the default sample deal. The Summary tab synthesizes everything that the Buyer, Seller, Intermediaries, and Chain View tabs compute — gross deal value, total expenses, all-in cost, P&L, and the settlement architecture.
When you enter your own deal values on the Simple, Buyer, or Seller tabs, the Summary updates in real time. The architecture is encoded once; the math runs automatically. You spend your time on the deal, not on rebuilding the model for each transaction.
Frequently asked questions
What format is the worksheet?
Microsoft Excel (.xlsx) file. Opens in Excel 2016 or later, LibreOffice Calc 7+, or Google Sheets (some formula behavior may differ in Sheets).
When is the worksheet delivered after purchase?
Within 1–24 hours of payment, by email from This email address is being protected from spambots. You need JavaScript enabled to view it.. Most purchases are delivered within 1–2 hours during business hours (US Eastern Time).
Does it contain macros?
The workbook uses Excel formulas extensively but no macros that require enabling. No security risk. Open and use.
Can I customize the cost items for my specific deal?
Yes. The eleven common-backbone cost rows are pre-built; user-defined rows let you add deal-specific items. The Summary tab rolls everything together automatically.
What if my deal does not match the default pricing model?
Each variant comes in both Discount Model (gross/net) and Fixed Price Model (unit-price) versions. Pick the variant that matches your deal's pricing convention. The variants share the same underlying architecture so once you know one, you know both.
Are updates included?
Yes. Free updates to all future v2.x releases are included with every purchase. You receive each new version at the email address you provided at checkout.
What if I have technical questions or problems with the file?
Email This email address is being protected from spambots. You need JavaScript enabled to view it.. We respond within one business day.
All sales final?
Due to the digital nature of MERCATUS Worksheets — once delivered, the file cannot be returned — all sales are final and non-refundable. For technical issues with your file we will work to resolve them.
MERCATUS Crypto Direct — Fixed Price Model
Crypto OTC transaction-cost model for deals priced at a fixed unit rate ($X per BTC, $Y per ETH). Defaults to BTC at $65,000 institutional reference. Includes the crypto-specific cost stack: gas fees, on-ramp/off-ramp, custody, KYC and Travel Rule compliance, source-of-funds analytics, sanctions screening.
Free updates to all future v2.x releases included
Buy NowDelivered by email within 1–24 hours.
Most within 1–2 hours (US Eastern Time).
The workbook structure
The MERCATUS workbook is organized into a consistent set of tabs. Every tab carries forward the discipline and data that the next tab depends on.
License — proof of ownership
License tab. Confirms your purchase, terms of use, version number, and free-updates entitlement. Also controls tier visibility for distributed copies.
Summary — deal-at-a-glance
Summary tab. All key positions visible on a single page. Updates automatically as you enter values on the working tabs — gross deal value, total expenses, all-in cost, P&L, intermediary chain status, settlement architecture.
Read Me — five-minute orientation
Read Me tab. Walks you through what each tab is for, the terminology and glossary, and how the pricing model is applied. Read this first; saves hours on every deal you model afterwards.
Simple — fastest deal modeling
Simple tab. Minimal entry for fast modeling. Enter the values that matter, see the result. The Simple tab gives you the headline numbers without forcing you through the full Buyer/Seller granularity.
Buyer — full cost stack
Buyer tab. Full buyer-side cost stack: deal terms, the eleven common-backbone cost items (refining, custody, paymaster fees, regulatory costs, and more), user-defined cost rows for deal-specific items, intermediary chain with one mandate per side and facilitator brokers below.
Chain View — settlement visualization
Chain View tab. Full settlement-flow visualization from buyer through the intermediary chain to seller. Every party in the chain visible. Useful for sanity-checking that fees coordinate correctly across SPA, IMFPA, and sub-fee agreements before any bank diligence review.
Also included: Seller tab (mirror of Buyer for the sell side), Intermediaries tab (broker-chain detail with one mandate per side), Reference tab (glossary, standards, and cross-references).
How the pricing model works
In the Fixed Price Model for crypto OTC, deal pricing is $X per coin × quantity. The model computes gross deal value, applies the full crypto-specific cost stack, routes commissions through the intermediary chain with one mandate per side, and reports effective all-in cost per coin.
From input to output
Enter coin quantity and unit price on the Simple tab. The model computes gross deal value, applies crypto-specific cost items (gas, on/off-ramp, custody, KYC/Travel Rule, source-of-funds, sanctions screening, plus the common-backbone items), routes broker commissions, and reports effective all-in cost per coin. Defaults to 1 BTC at $65,000 — adjust for ETH or any other digital asset at any institutional reference price.
The common-backbone cost items
Every transaction has eleven common cost categories the workbook computes automatically: refining and quality verification, custody and storage, paymaster fees, legal counsel fees, regulatory compliance, settlement venue fees, FX conversion, escrow, and three more. You add deal-specific costs as user-defined rows. The model rolls everything into the all-in cost per unit and net P&L.
Free updates to v2.x
Every purchase includes free updates to all future v2.x releases. When a new version of this worksheet is published, you receive the updated file at the email address you provided at checkout.
Sample output
The screenshots above show the workbook populated with the default sample deal. The Summary tab synthesizes everything that the Buyer, Seller, Intermediaries, and Chain View tabs compute — gross deal value, total expenses, all-in cost, P&L, and the settlement architecture.
When you enter your own deal values on the Simple, Buyer, or Seller tabs, the Summary updates in real time. The architecture is encoded once; the math runs automatically. You spend your time on the deal, not on rebuilding the model for each transaction.
Frequently asked questions
What format is the worksheet?
Microsoft Excel (.xlsx) file. Opens in Excel 2016 or later, LibreOffice Calc 7+, or Google Sheets (some formula behavior may differ in Sheets).
When is the worksheet delivered after purchase?
Within 1–24 hours of payment, by email from This email address is being protected from spambots. You need JavaScript enabled to view it.. Most purchases are delivered within 1–2 hours during business hours (US Eastern Time).
Does it contain macros?
The workbook uses Excel formulas extensively but no macros that require enabling. No security risk. Open and use.
Can I customize the cost items for my specific deal?
Yes. The eleven common-backbone cost rows are pre-built; user-defined rows let you add deal-specific items. The Summary tab rolls everything together automatically.
What if my deal does not match the default pricing model?
Each variant comes in both Discount Model (gross/net) and Fixed Price Model (unit-price) versions. Pick the variant that matches your deal's pricing convention. The variants share the same underlying architecture so once you know one, you know both.
Are updates included?
Yes. Free updates to all future v2.x releases are included with every purchase. You receive each new version at the email address you provided at checkout.
What if I have technical questions or problems with the file?
Email This email address is being protected from spambots. You need JavaScript enabled to view it.. We respond within one business day.
All sales final?
Due to the digital nature of MERCATUS Worksheets — once delivered, the file cannot be returned — all sales are final and non-refundable. For technical issues with your file we will work to resolve them.
MERCATUS Generic Worksheet — Fixed Price Model
Asset-agnostic transaction-cost model for international deals priced at a fixed unit rate. Buyer enters quantity and unit price; the model derives gross deal value, full cost stack, intermediary chain with one mandate per side, and effective all-in cost per unit.
Free updates to all future v2.x releases included
Buy NowDelivered by email within 1–24 hours.
Most within 1–2 hours (US Eastern Time).
The workbook structure
The MERCATUS workbook is organized into a consistent set of tabs. Every tab carries forward the discipline and data that the next tab depends on.
License — proof of ownership
License tab. Confirms your purchase, terms of use, version number, and free-updates entitlement. Also controls tier visibility for distributed copies.
Summary — deal-at-a-glance
Summary tab. All key positions visible on a single page. Updates automatically as you enter values on the working tabs — gross deal value, total expenses, all-in cost, P&L, intermediary chain status, settlement architecture.
Read Me — five-minute orientation
Read Me tab. Walks you through what each tab is for, the terminology and glossary, and how the pricing model is applied. Read this first; saves hours on every deal you model afterwards.
Simple — fastest deal modeling
Simple tab. Minimal entry for fast modeling. Enter the values that matter, see the result. The Simple tab gives you the headline numbers without forcing you through the full Buyer/Seller granularity.
Buyer — full cost stack
Buyer tab. Full buyer-side cost stack: deal terms, the eleven common-backbone cost items (refining, custody, paymaster fees, regulatory costs, and more), user-defined cost rows for deal-specific items, intermediary chain with one mandate per side and facilitator brokers below.
Chain View — settlement visualization
Chain View tab. Full settlement-flow visualization from buyer through the intermediary chain to seller. Every party in the chain visible. Useful for sanity-checking that fees coordinate correctly across SPA, IMFPA, and sub-fee agreements before any bank diligence review.
Also included: Seller tab (mirror of Buyer for the sell side), Intermediaries tab (broker-chain detail with one mandate per side), Reference tab (glossary, standards, and cross-references).
How the pricing model works
In the Fixed Price Model, deal pricing is direct: quantity multiplied by unit price gives gross deal value. The Generic Worksheet applies this discipline to any commodity or instrument class — precious metals, structured paper, bulk goods, anything quoted at $X per unit.
From input to output
Enter your quantity and unit price on the Simple tab for the fastest path. The model computes gross deal value, applies the common-backbone cost items (refining, custody, paymaster fees, regulatory costs, and seven others), routes commissions through the intermediary chain with one mandate per side, and reports effective all-in cost per unit and net P&L. Switch to Buyer / Seller tabs for full granularity.
The common-backbone cost items
Every transaction has eleven common cost categories the workbook computes automatically: refining and quality verification, custody and storage, paymaster fees, legal counsel fees, regulatory compliance, settlement venue fees, FX conversion, escrow, and three more. You add deal-specific costs as user-defined rows. The model rolls everything into the all-in cost per unit and net P&L.
Free updates to v2.x
Every purchase includes free updates to all future v2.x releases. When a new version of this worksheet is published, you receive the updated file at the email address you provided at checkout.
Sample output
The screenshots above show the workbook populated with the default sample deal. The Summary tab synthesizes everything that the Buyer, Seller, Intermediaries, and Chain View tabs compute — gross deal value, total expenses, all-in cost, P&L, and the settlement architecture.
When you enter your own deal values on the Simple, Buyer, or Seller tabs, the Summary updates in real time. The architecture is encoded once; the math runs automatically; you spend your time on the deal, not on rebuilding the model for each transaction.
Frequently asked questions
What format is the worksheet?
Microsoft Excel (.xlsx) file. Opens in Excel 2016 or later, LibreOffice Calc 7+, or Google Sheets (some formula behavior may differ in Sheets).
When is the worksheet delivered after purchase?
Within 1–24 hours of payment, by email from This email address is being protected from spambots. You need JavaScript enabled to view it.. Most purchases are delivered within 1–2 hours during business hours (US Eastern Time).
Does it contain macros?
The workbook uses Excel formulas extensively but no macros that require enabling. No security risk. Open and use.
Can I customize the cost items for my specific deal?
Yes. The eleven common-backbone cost rows are pre-built; user-defined rows let you add deal-specific items. The Summary tab rolls everything together automatically.
What if my deal does not match the default pricing model?
Each variant comes in both Discount Model (gross/net) and Fixed Price Model (unit-price) versions. Pick the variant that matches your deal's pricing convention. The variants share the same underlying architecture so once you know one, you know both.
Are updates included?
Yes. Free updates to all future v2.x releases are included with every purchase. You receive each new version at the email address you provided at checkout.
What if I have technical questions or problems with the file?
Email This email address is being protected from spambots. You need JavaScript enabled to view it.. We respond within one business day.
All sales final?
Due to the digital nature of MERCATUS Worksheets — once delivered, the file cannot be returned — all sales are final and non-refundable. For technical issues with your file we will work to resolve them.
MERCATUS Generic Worksheet — Discount Model
Asset-agnostic transaction-cost model for broker-mediated deals priced as a discount off a benchmark (gold spot, market reference, structured-paper face value) using the gross/net convention. Models seller-receives, buyer-pays, and the broker-pool spread that funds the intermediary chain.
Free updates to all future v2.x releases included
Buy NowDelivered by email within 1–24 hours.
Most within 1–2 hours (US Eastern Time).
The workbook structure
The MERCATUS workbook is organized into a consistent set of tabs. Every tab carries forward the discipline and data that the next tab depends on.
License — proof of ownership
License tab. Confirms your purchase, terms of use, version number, and free-updates entitlement. Also controls tier visibility for distributed copies.
Summary — deal-at-a-glance
Summary tab. All key positions visible on a single page. Updates automatically as you enter values on the working tabs — gross deal value, total expenses, all-in cost, P&L, intermediary chain status, settlement architecture.
Read Me — five-minute orientation
Read Me tab. Walks you through what each tab is for, the terminology and glossary, and how the pricing model is applied. Read this first; saves hours on every deal you model afterwards.
Simple — fastest deal modeling
Simple tab. Minimal entry for fast modeling. Enter the values that matter, see the result. The Simple tab gives you the headline numbers without forcing you through the full Buyer/Seller granularity.
Buyer — full cost stack
Buyer tab. Full buyer-side cost stack: deal terms, the eleven common-backbone cost items (refining, custody, paymaster fees, regulatory costs, and more), user-defined cost rows for deal-specific items, intermediary chain with one mandate per side and facilitator brokers below.
Chain View — settlement visualization
Chain View tab. Full settlement-flow visualization from buyer through the intermediary chain to seller. Every party in the chain visible. Useful for sanity-checking that fees coordinate correctly across SPA, IMFPA, and sub-fee agreements before any bank diligence review.
Also included: Seller tab (mirror of Buyer for the sell side), Intermediaries tab (broker-chain detail with one mandate per side), Reference tab (glossary, standards, and cross-references).
How the pricing model works
In the Discount Model, deal pricing uses the gross/net convention common to broker-mediated commodity and structured-paper transactions. Gross discount is what the seller absorbs (deeper). Net discount is what the buyer realizes (shallower). The spread between gross and net funds the intermediary chain — that is the math we encode honestly.
From input to output
Enter your gross/net quote (e.g., "8/6", "10/6") on the Simple tab. The model computes seller-receives, buyer-pays, broker-pool spread, and routes commissions through the intermediary chain. Glossary covers FPA/MFPA/IMFPA architecture, NCNDA, and the gross/net convention. The Discount Model is built for the dominant pricing pattern in broker-mediated international transactions.
The common-backbone cost items
Every transaction has eleven common cost categories the workbook computes automatically: refining and quality verification, custody and storage, paymaster fees, legal counsel fees, regulatory compliance, settlement venue fees, FX conversion, escrow, and three more. You add deal-specific costs as user-defined rows. The model rolls everything into the all-in cost per unit and net P&L.
Free updates to v2.x
Every purchase includes free updates to all future v2.x releases. When a new version of this worksheet is published, you receive the updated file at the email address you provided at checkout.
Sample output
The screenshots above show the workbook populated with the default sample deal. The Summary tab synthesizes everything that the Buyer, Seller, Intermediaries, and Chain View tabs compute — gross deal value, total expenses, all-in cost, P&L, and the settlement architecture.
When you enter your own deal values on the Simple, Buyer, or Seller tabs, the Summary updates in real time. The architecture is encoded once; the math runs automatically. You spend your time on the deal, not on rebuilding the model for each transaction.
Frequently asked questions
What format is the worksheet?
Microsoft Excel (.xlsx) file. Opens in Excel 2016 or later, LibreOffice Calc 7+, or Google Sheets (some formula behavior may differ in Sheets).
When is the worksheet delivered after purchase?
Within 1–24 hours of payment, by email from This email address is being protected from spambots. You need JavaScript enabled to view it.. Most purchases are delivered within 1–2 hours during business hours (US Eastern Time).
Does it contain macros?
The workbook uses Excel formulas extensively but no macros that require enabling. No security risk. Open and use.
Can I customize the cost items for my specific deal?
Yes. The eleven common-backbone cost rows are pre-built; user-defined rows let you add deal-specific items. The Summary tab rolls everything together automatically.
What if my deal does not match the default pricing model?
Each variant comes in both Discount Model (gross/net) and Fixed Price Model (unit-price) versions. Pick the variant that matches your deal's pricing convention. The variants share the same underlying architecture so once you know one, you know both.
Are updates included?
Yes. Free updates to all future v2.x releases are included with every purchase. You receive each new version at the email address you provided at checkout.
What if I have technical questions or problems with the file?
Email This email address is being protected from spambots. You need JavaScript enabled to view it.. We respond within one business day.
All sales final?
Due to the digital nature of MERCATUS Worksheets — once delivered, the file cannot be returned — all sales are final and non-refundable. For technical issues with your file we will work to resolve them.
Thank you. Your MERCATUS Worksheet is on the way.
Your purchase is complete. Your worksheet will be delivered via email within 1–24 hours. Most purchases are delivered within 1–2 hours during business hours (Eastern Time).
Your order has been received
Your payment has been processed successfully. A receipt has been sent to the email address you provided at checkout.
What you purchased
One of the MERCATUS Worksheets — an Excel-based transaction-cost model built to protect all parties’ reputations, interest, and sanity in international broker-mediated deals. Free updates to all future v2.x releases are included with every purchase.
What happens next
Within 1–24 hours, you’ll receive a second email from This email address is being protected from spambots. You need JavaScript enabled to view it. containing your worksheet as an attachment. Click the Delivery tab above for full details on timing and what to expect.
How your worksheet is delivered
When
Within 1–24 hours of payment. Most purchases are delivered within 1–2 hours during business hours (US Eastern Time).
From
This email address is being protected from spambots. You need JavaScript enabled to view it.
Format
Microsoft Excel (.xlsx) file attached to the delivery email.
What you need
Microsoft Excel 2016 or later. LibreOffice Calc 7+ also works. Google Sheets can open the file but some formulas may behave differently.
Whitelist our address
Some inboxes route first-time senders to spam or to a clutter folder. To make sure your worksheet lands in your primary inbox, add This email address is being protected from spambots. You need JavaScript enabled to view it. to your contacts or safe-sender list now.
Free updates included
Every purchase includes free updates to all future v2.x releases. When a new version of your worksheet is published, you’ll be notified at the same email address and receive the updated file.
Getting started once your worksheet arrives
Open the file in Excel
The worksheet opens directly in Microsoft Excel. If a yellow security bar appears at the top asking to enable editing, click Enable Editing. The workbook contains formulas but no macros — no security risk.
Visit the tabs in order
Each MERCATUS workbook is organized into a consistent set of tabs:
- License — confirms your purchase, terms of use, version number, and free-updates entitlement.
- Summary — the deal-at-a-glance view that updates automatically as you enter values on the other tabs.
- Read Me — five-minute orientation: what this workbook does, what each tab is for, terminology and glossary.
- Simple — minimal entry tab for fastest deal modeling.
- Buyer — full buyer-side cost stack, fees, intermediary chain.
- Seller — mirror of Buyer for the seller side.
- Intermediaries — broker chain detail; one mandate per side, facilitator brokers below.
- Chain View — full settlement-flow visualization from buyer through chain to seller.
- Reference — glossary, standards, and cross-references.
Choose your pricing model
If your deal is priced as a discount off a benchmark (gold spot, market reference for crypto), use the gross/net convention on the Simple or Buyer tabs. If your deal is priced at a fixed unit rate ($X per unit), use unit-price entry. The workbook tells you which path to take based on what you fill in.
Support & contact
Technical issues with your file
If your worksheet won’t open, shows formula errors, or you have questions about how to use a specific feature, email This email address is being protected from spambots. You need JavaScript enabled to view it. with a clear description of what you’re seeing. We’ll respond within one business day.
Delayed delivery
If 24 hours have passed since payment and you haven’t received your worksheet (after checking spam, promotions, and clutter folders), email This email address is being protected from spambots. You need JavaScript enabled to view it. with your receipt or order reference. We will resolve it.
Other channels
Phone
+1 404.557.6049
US Eastern Time
All sales final
Due to the digital nature of MERCATUS Worksheets — once delivered, the file cannot be returned — all sales are final and non-refundable. For technical issues with your file we will work to resolve them.