FINANCIAL PRODUCTS
Collateral
Project funding through the institutional channel begins with bankable collateral. The page below states the floor, the cap per project, the acceptable forms of collateral, and the path for sponsors who do not yet have collateral in hand.
The institutional minimum: $150 million
A minimum of $150 million in bankable collateral is required for project funding through the institutional channel Magister Operis works with. Below that floor, the institutional cost stack cannot be efficiently structured.
Per-project capacity: up to $4 billion initially
For qualifying projects, the Institution can fundraise up to $4 billion initially per project. Particulars — structure, sequencing, and terms — are documented in the SPV operating agreement and negotiated bilaterally between the funder and the UBO of the collateral and/or their counsel.$20 billion projects can be funded simply by repeating the same program that raised $4 billion initially.
Smaller projects can be packaged within larger funding transactions
Projects of less than $150 million can be folded and packaged within funding transactions that have at least $150 million in collateral.
Acceptable forms of bankable collateral with at least 150M LTV
- Cash (Funder can securitize cash with top rated securies eliminating risk for the cash owner)
- Standby Letters of Credit (SBLCs)/Bank Guarantees (BGs) issued by A-rated in investment bank in USA, Canada, EU, Singapore, South Korea, or Japan.
- Listed securities including Medium Term Notes (MTNs), treasuries, and petro bonds
- Gold and other precious metals, assayed, and under bank or Swiss Safe Keeping Receipt (SKR)
- Gemstones, GIA-grade certified, and under SKR in Switzerland
- Audited real estate equity in jurisdictions with strong municipal property controls (Africa is unacceptable)
- Audited business equity
- Corporate Medium Term Notes (MTNs) backed by strong collateral
- Sovereign guarantees issued by a government central bank
If you do not yet have collateral
Some project owners arrive with a sound project and a host nation that welcomes the investment, but without $150M+ of bankable collateral in hand. Two paths are available.
Do-it-yourself. Project owners can approach national and/or multinational corporations operating in the host nation.
SAMPLE IRON ORE FUNDING REQUEST
A) SELLER BRINGS COLLATERAL
Machinery manufacturers wants to sell millions of dollars worth of machinery to mining operations.
Machinery manufacturer brings the collateral.
The machinery manufacturer sells millions of dollars' worth of machinery to the project and receives a healthy amount of equity in the project for bringing the collateral to a project that has value far in excess that of the collateral amount. .
Machinery manufacturer receives collateral back free, clear, and unencumbered, meaning ultimately nothing invested, yet holds significant equity in the operation. Everyone wins.
AND/OR
B) BUYER BRINGS COLLATERAL
Steel manufacturer wants to purchase millions of dollars worth of iron ore from the mining operation.
Steel manufacturer brings the collateral.
The steel manufacturer buys millions of dollars' worth of iron ore from the project and receives a healthy amount of equity in the project for bringing the collateral to a project that has value far in excess of the collateral amount.
Steel manufacturer receives collateral back free, clear, and unencumbered, meaning ultimately nothing invested, yet holds significant equity in the operation. Everyone wins.
Retain Magister Operis. Magister Operis can be engaged, on retainer, to lead the search for and qualification of $150M+ of bankable collateral on behalf of a sponsor. Magister Operis will use its research, communication, professional document production skills, social media accounts, and industry relationships to present the opportunity to the potential collateral provider in a manner that outlines the project and the benefits to these corporations in bringing forth their collateral into a highly managed funding mechanism that is run by former bankers and accountants that are supported pro bono by some of the most elite global accounting and law firms.
These transactions can be very beneficial to multi-national corporations that have a "social contract" promising to give back or invest back into a nation and/or the nations communities. The collateral can used to raise significant funds for a variety of projects that benefit all parties involved without any funds from the collateral provider being spent on the projects.
Initiate a conversation
To open a discussion about collateral, project qualification, or a retained engagement, write to This email address is being protected from spambots. You need JavaScript enabled to view it..
Government Engagements & Public-Private Partnerships
Government-tier engagements and Public-Private Partnerships run on the same pre-compliance discipline as any other bankable project funding — with one additional, non-negotiable layer: every government relationship, official, and intermediary in the chain must be precisely named, role-defined, and authorization-documented.
The collateral provider leads
In project funding at institutional scale, the collateral provider sits at the center of the conversation. Without collateral, the project — however well-conceived — almost does not matter. The collateral is what the bank, the foundation, and the funding syndicate are actually underwriting. The project is what the collateral is being deployed against.
The implication for project owners is direct. When the project owner is also the collateral owner, the project owner leads. When the project owner is not the collateral owner, the collateral provider leads — and the project owner is in effect a counterparty to the collateral provider's decision to deploy. That distinction is foundational to how every funding conversation proceeds, including PPP conversations where sovereign instrumentalities, foundation capital, or private syndicates bring the collateral and the operating partner brings the project.
Bankable collateral requires a bankable use of funds. Every requirement listed in the pre-compliance file below exists for one reason: the collateral provider needs to know that when the collateral is deployed against this project, the project is capable of returning the deployment with the predictable margin the collateral provider requires. EPC competence, executive management track record, off-take agreements, legal representation, banking relationships, intermediary background — each is a line item in the answer to that single question. Pre-compliance is the documentation that lets the collateral provider answer it.
The same pre-compliance applies
A Public-Private Partnership is a project. Before any funding moves — sovereign budget, foreign aid, multilateral facility, project bond, or foundation capital — the same criteria that govern large-scale project funding govern the PPP. The pre-compliance documentation, the off-take diligence, the legal framework, and the banking-relationship architecture are identical. What differs is the additional government-relationship layer described below.
- Corporate Profile
- Client Information Sheet (CIS) outlining the critical information of the principals and corporate entity.
- Executive Summary, Letter of Intent, or Letter of Request.
- Background of the company.
- Copies of professional, corporate, and tax licenses and registrations.
- Corporate resolutions where applicable.
- Professional / owned-domain email addresses only.
- Background of Principals
- Bios, resumes, and CVs of the principals — the documented answer to why these specific people are able to perform when the funding is on the table.
- Credible Business Plan
- Collection of executive summary, principal details, and financial details including pro forma that support the funding request.
- Professional / owned-domain email addresses only.
- Websites tied to professional / owned-domain email addresses only.
- Credible Feasibility
- The foundation, the funding banks, and investors only release funds to projects with obvious market demand for the output, with documented purchasers able to pay for what the project produces.
- A sister financial-modeling company serves as the fundraising and administrative arm of the foundation, providing capital-alignment forecasts for investment durations of up to thirty years — methodology in a globally leading position for the last decade.
- A team of PhDs and proprietary award-winning predictive-modeling software runs scenarios covering risk, opportunity, crisis management, and investment assessment, with stress-testing for feasibility and resilience. Reports allow investors, shareholders, and banks to make precise decisions on investments exceeding $100M globally.
- While the foundation does not need to produce the feasibility study itself, the report must be certified by top international banks, accounting firms, and law firms.
- Collateral (as needed)
- Two purposes: (i) makes the project more attractive to the foundation and the funding banks; (ii) serves as security where the project's standalone financial feasibility is doubtful.
- Forms of collateral: cash; bank instrument; government treasury bond; government sovereign guarantee; precious metals or stones; or comparable instrument.
- Sources of collateral: the project owner; a private or institutional investor; a buyer of the project's output; a supplier to the project.
- Credible EPC Contractor
- Engineering, Procurement, and Construction firm in the professional and skills league of the project, the foundation, and the funding banks.
- Professional / owned-domain email addresses only.
- Credible Operator
- The party that runs the project on an ongoing basis after construction is complete.
- In the professional and skills league of the project, the foundation, and the funding banks.
- May be the same firm as the EPC contractor.
- Professional / owned-domain email addresses only.
- Off-Take Agreements
- To make a project bankable, there must be a credible market, off-take agreements, or (where energy is involved) power purchase agreements.
- The foundation does not work from market or repayment speculation alone.
- Competent Legal & Representation
- Preferably a law firm with five or more partners, prepared to engage with major international banks, accounting firms, and corporate-law firms.
- Professional / owned-domain email addresses only.
- Banking Relationships
- Details of the bank or banks to be used within the transaction.
- Background of Intermediaries
- List of intermediaries in the transaction.
- The role of each intermediary.
- The background of each intermediary.
- The financial expectation of each intermediary.
The list is not paperwork to be assembled defensively. It is the test that determines whether the project can carry serious capital. Why is it that you are able to perform when the money is on the table? The pre-compliance file answers that question with documentation, on letterhead, in writing, before anyone is asked to commit.
The funding flowchart
Funding flows through a structured pre-compliance → introduction → SPV → disbursement sequence. The flowchart applies to PPPs the same way it applies to private-only project funding. What changes inside a PPP is who sits in which seat at each step — not how the money moves.
Magister Operis project funding flowchart — identical structure for PPPs.
What is specific to PPPs — the relationship map
In addition to the eleven pre-compliance categories, PPP engagements require every government-side relationship to be defined to the same documentation standard. A claim of "a relationship with the government" is not a relationship until each of the following is named:
Government entity
The specific ministry, agency, department, state-owned enterprise, or sovereign instrumentality engaging on the deal — by legal name, with empowering legislation or charter cited.
Named officials
Decision-authority individuals within the entity. By name, by title, by tenure. Their authority to commit the entity documented in advance.
Private entity
The commercial party contributing capital, technology, operating capacity, or off-take commitment. Beneficial ownership, audited financials, and KYC/AML standing at international banking grade.
Intermediaries
Mandates, attorneys, advisors, facilitator brokers, and project agents in the coordination chain. Role, authorization, and fee basis defined for each.
Funding mechanism
Sovereign budget line, multilateral facility, foundation grant, PPP capital stack, or hybrid. The legal vehicle that will hold and disburse the funds named explicitly.
Legal framework
Host-nation legislation governing the partnership, applicable treaties or trade agreements, and dispute-resolution venue agreed in advance.
Everyone knows the names of presidents and prime ministers. The relevant question is whether those presidents and prime ministers know the introducer. Whether, when the introducer's name is spoken inside a ministry, anyone present recognizes it. The substitution of generic claims for documented access does not survive professional diligence and does not survive bank compliance.
League of The Foundation — operating at the level you are asking to access
To partner with The Foundation, parties must operate within the league of The Foundation. That is not a slogan; it is a working standard, visible at line-item level. The simplest example is professional infrastructure. A government office or private operator that conducts billion-euro project correspondence from a personal Gmail, Hotmail, or AOL address is not operating at the level it is asking to access. The pre-compliance file calls for professional, owned-domain email addresses specifically because the absence of that single line item is a reliable signal of the absence of every other line item.
The same pattern shows up on government-entity websites — pages that have not been updated in years, broken links, placeholder content, missing contact information, and unfinished sections. None of those tell a foundation, a bank, or an investor that the entity is ready to receive and deploy serious capital. They tell the opposite story. Magister Operis has reviewed government portals in Africa where, given a fraction of the existing ministry budget and authorized access to the content management system, a working website could be in place within hours rather than years.
This is not criticism for its own sake. It is the accountability gap that every PPP engagement must close before funding can move. The Foundation's discipline, the banks' compliance, the auditors' verification, and the legal counsel's review all proceed from the same standard. Parties asking Magister Operis to bring substantive capital to a government engagement must close that gap on the government side as well as on the private side.
Magister Operis is here to help. We can lead the horses' mouths to water. We are not their mother. Aggressive socio-economic transformation runs on accountability that the partner nation, partner ministry, and partner private entity all enforce on themselves — the foundation's role is to fund and to discipline, not to substitute its own diligence for the partner's preparation.
What this looks like to each stakeholder
A well-structured PPP engagement is recognizable to every participant. Each stakeholder reads the same documentation set and sees their own role clearly defined within it.
Head of state
Sees the alignment of the project with the national agenda. Sees sovereign exposure quantified and capped. Sees the parties at the table and their bona fides. Has the briefing materials needed to make an informed national-interest decision without doing the diligence personally.
Ministry
Has the deliverables, budget, and timeline defined. Has the procurement procedure documented. Has the audit trail required by national-treasury or comptroller oversight. Can answer parliamentary or cabinet questions about every line in the deal.
Government entity / SOE
Has clear authority to enter the partnership under its charter. Has necessary internal approvals captured. Has legal-counsel sign-off on the partnership instrument. Has the procurement and signing officers identified.
Private entity
Has commercial terms that justify capital deployment. Has the risk-adjusted return defined, with the risk-sharing instrument from the public side identified. Has its own compliance officers satisfied that the engagement meets international standards on both ends.
Intermediary
Has a defined role, defined fee, and defined authorization from the principals on each side. Does not present unauthorized material to a principal on either side. Does not substitute proximity to a name for genuine access to authority.
Aggressive socio-economic transformation by design
Magister Operis is serious about aggressive socio-economic transformation, and equally serious that "by design" is what makes it possible. The pre-compliance discipline, the relationship-map discipline, the professional-infrastructure discipline, and the bankability discipline are not gates erected to slow projects down. They are the design that makes large-scale, cross-border, government-engaging, sovereign-anchored capital actually deployable in the real world.
Partner nations and partner entities that bring the necessary preparation forward are met by an institutional capability prepared to move quickly. Partner nations and partner entities that ask Magister Operis to substitute its own diligence for their preparation are politely directed back to the pre-compliance list above. The work that follows the list is engineered to move fast. The work that precedes the list is not work the foundation, the banks, or Magister Operis can do for a partner.
Ready to engage
Government entities preparing a project for international financing, private entities exploring a PPP with a sovereign or sub-sovereign partner, and authorized intermediaries coordinating such engagements are invited to use the qualification path at Begin Qualification. See also the Method page for the standard seven-step workflow and the Engagement Structure page for the published rate card and retainer model.
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 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 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.