Revenue and Calc
Enter executed customer legs, fee-route allocations and retained prices. Calc builds monthly revenue across five routes without duplicating executions.
Cryptocurrency Exchange Financial Model
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
This Cryptocurrency Exchange Financial Model is an Excel template for building 2026–2030 financial projections for a US centralized spot exchange. It calculates fee revenue from executed customer trading legs, then links transaction costs, overhead, staffing and startup funding to management reports.
The illustrative case covers retail and high-volume maker/taker execution plus instant conversion, with a remote US team and small Texas office. It assumes necessary permissions before launch in approved states excluding New York; it does not model derivatives, lending, leverage, standalone custody charges or interest income.
- Forecast years
- 52026 through 2030
- Fee routes
- 5one execution pool
- Scenario cases
- 3Low, Base and High
WORKBOOK CONTENTS
What the Excel Financial Model Includes
The workbook connects editable exchange assumptions with monthly calculations, projected financial statements and management decision reports.
COGS & OPEX and Payroll
Adjust processing, liquidity, acquisition and screening rates, fixed expenses, staff FTE and salaries. Separate schedules total operating and personnel spending.
CAPEX, CapTable and Debt
Plan asset purchases, equity and optional debt. Dashboard controls drive repayments; CAPEX separates investment spending and depreciation from EBITDA.
Financial Statements and Checks
Review financial statements, scenarios and Dashboard reports. Checks identify reconciliation, input and potential cash issues.
REVENUE BUILD
How Customer Executions Generate Fee Revenue
Revenue is driven by one monthly pool of executed customer legs, allocated across five mutually exclusive fee routes.
Monthly demand grows from 100,000 executed legs in 2026 to 800,000 in 2030. Each earns one retained fee or spread; matched maker and taker legs are separate paying executions.
Allocate 25% to retail maker, 40% to retail taker, 12% to high-volume maker, 8% to high-volume taker and the remaining 15% to instant conversion. Their respective retained prices are $1.65, $2.85, $6, $22.50 and $3 per execution.
Revenue Forecast
The Revenue Forecast connects monthly execution demand, the five route shares and each retained fee or conversion spread. It rolls annual assumptions into monthly executed legs and fee revenue, with the January 31, 2026 launch treated as an active month.
Illustrative 2026 Base-case revenue
100,000 legs/month × 12 months × $4.5225 blended retained fee per leg = $5,427,000 annual revenue.
OPERATING EXPENSES
How Trading Costs and Staffing Affect EBITDA
The operating forecast separates revenue-linked direct costs, variable spending, monthly fixed coverage and fixed-salary payroll.
Direct costs total 16% of revenue: bank/payment processing 8%, external execution and liquidity 4%, incremental cloud/data 2%, and blockchain/wallet usage 2%. Variable expenses total 15%: acquisition 12%, transaction losses 2%, and usage-based identity screening 1%.
Fixed expenses cover cloud infrastructure, surveillance, counsel, insurance, offices, assurance and settlement minimums. Baseline cloud spending grows from $30,000/month in 2026 to $90,000/month in 2030, with 12 paid months.
COGS and Operating Expenses
The COGS and Operating Expenses report separates processing and liquidity charges from variable acquisition, fraud costs and fixed security or compliance coverage. Those distinct schedules help test contribution margins and EBITDA sensitivity as trading demand increases.
Payroll is separate from all other expense categories. Software engineering grows from 8 to 16 annual-average FTE, alongside reliability, security, compliance and support roles.
Eight 2026 engineers at $155,000 each cost $1,240,000 in annual base salary. Employer taxes, benefits and personal taxes are excluded from this case.
Payroll Forecast by Staff Role
The Payroll Forecast organizes roles, annual-average staffing, salary assumptions and monthly personnel costs. Its staffing schedules help compare a 2026 payroll budget of $4,175,000 with $7,920,000 in 2030 and examine the cost of planned operational coverage.
OPENING INVESTMENT
How Startup Assets and Funding Are Treated
Startup capital purchases, preopening cash and owner contributions are recorded separately from annual exchange operating earnings.
Opening assets include $100,000 for workstations, $75,000 for security and recovery hardware and $25,000 for office fixtures. Separate preopening cash covers platform work, legal applications, assurance, promotion, deposits and restricted bank or regulatory collateral.
Capital Expenditure Plan
The Capital Expenditure Plan records startup asset purchases and the timing of investment cash outflows. Its depreciation schedule supports financial reporting while keeping equipment purchases separate from recurring trading costs and EBITDA.
Estimated owner funding is approximately $6,903,843, including preopening requirements, restricted collateral and a three-month operating reserve. No outside financing is committed; neither regulatory capital adequacy nor full-ramp cash sufficiency is established.
Sources and Uses of Funds
The Sources and Uses of Funds report links owner equity and any entered debt to operating payments, investment and cash retained. It helps assess where launch capital is assigned, without implying the exchange already has a committed loan or approved capitalization.
ILLUSTRATIVE RESULTS
Five-Year Revenue, Expense and EBITDA Forecast
The selected Base-case operating forecast moves from a 2026 EBITDA loss to positive EBITDA in the following forecast years.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $5,427,000 | $8,215,370 | −$2,788,370 |
| 2027 | $13,567,500 | $12,409,925 | $1,157,575 |
| 2028 | $21,708,000 | $16,328,480 | $5,379,520 |
| 2029 | $32,562,000 | $21,214,220 | $11,347,780 |
| 2030 | $43,416,000 | $26,274,960 | $17,141,040 |
Illustrative assumptions, not historical exchange results or industry averages; USD amounts are presented as whole dollars.
In 2026, $8,215,370 of expenses exceeds $5,427,000 revenue by $2,788,370. In 2030, $43,416,000 of revenue less $26,274,960 of expenses yields $17,141,040 EBITDA.
EBITDA excludes depreciation, interest, taxes and amortization; it is neither net profit nor cash. The broader statements have no documented net income or closing cash result in this illustrative brief.
Projected Income Statement
The Projected Income Statement links trading revenue, direct costs, operating expenses and payroll to margins and accounting results. It makes the difference between the documented operating EBITDA forecast and later accounting lines visible without treating EBITDA as net profit.
The Cash Flow Statement separates operations from investment and financing. Review it with the Balance Sheet for cash deficits; an initial reserve does not establish sufficient capital for subsequent expansion.
Cash Flow Forecast
The Cash Flow Forecast tracks monthly operating, investing and financing movements with a cash reconciliation. It helps evaluate funding pressure during the initial EBITDA-loss period and separates cash availability from the fee-based revenue and EBITDA projections.
SCENARIOS AND RETURNS
How to Evaluate Break-Even and Funding Decisions
The Returns and scenario reports turn the operating forecast into distinct questions about coverage, cash recovery and sensitivity.
Returns separates sales break-even, cash break-even, cash-based investment payback and annual ROIC. None can be determined from EBITDA alone.
Dashboard Low/Base/High multipliers change revenue, COGS, variable expenses, fixed costs and payroll to test execution demand and operating-cost sensitivity.
Break-Even, Payback and ROIC
The Returns analysis combines sales break-even, cash break-even, investment payback and annual ROIC. It supports reviewing the exchange’s operating coverage and capital recovery, but the provided case does not establish a specific payback date or ROIC percentage.
Valuation tests discount and terminal assumptions; Benchmarks compares KPIs against user-entered references. Neither verifies an exchange valuation or industry average.
Financial Scenario Analysis
The Financial Scenario Analysis compares Low, Base and High revenue, margins and EBITDA for the exchange. It helps connect changes in executed trading legs and the operating cost structure to the profitability outcomes being tested.
PLANNING APPLICATIONS
Who This Cryptocurrency Exchange Model Suits
Use the template to test the economics of a US cash spot exchange before relying on a planned expansion or financing decision.
For founders and financial planners, the model traces execution fees through overhead, staffing, investments and statements. It fits spot exchanges without lending, derivatives or custody revenue.
Inputs are editable planning estimates, not observed results. The workbook assumes required permissions and does not substitute for regulatory, capital adequacy or liquidity diligence.
QUESTIONS ANSWERED
Frequently Asked Questions About the Model
These answers cover the calculation basis, customization, outputs and limits of the cryptocurrency exchange financial model.
How does the exchange financial model calculate revenue?
It multiplies monthly executed customer legs by each fee-route share and its retained fee or spread, then totals the five routes without counting any execution leg twice.
Can I change trading volumes and fee tiers?
Yes. Adjust monthly execution demand, retail and high-volume maker/taker allocations, and instant conversion share and pricing in the Revenue inputs.
Are customer balances or trade notional counted as revenue?
No. Only retained platform execution fees and conversion spreads are revenue; safeguarded balances and customer trade notional are excluded.
Does the model include salaries and security expenses?
Yes. Payroll budgets FTE and base salaries separately from direct processing costs, variable acquisition and screening expenses, and fixed security, regulatory and infrastructure coverage.
What financial statements and scenario tools are included?
The workbook declares Income Statement, Cash Flow Statement and Balance Sheet reports, plus Dashboard controls, Low/Base/High scenarios, valuation, benchmark comparisons and return analysis.
Is the 2027 EBITDA figure a guaranteed profit?
No. The $1,157,575 EBITDA is an illustrative operating forecast, not a guarantee, net income estimate or statement of future cash availability.
Can the model establish regulatory capital sufficiency?
No. Its owner funding and reserve policy are planning inputs, and the workbook does not verify licensing, regulatory approval or the adequacy of capital through the full ramp.
What Does the Cryptocurrency Exchange Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Cleaner Reporting In One Place
This template pulled our statements and charts into one file, so I stopped hunting through tabs and old exports. It saved me about 6 hours a week and made investor updates much easier to pull together.
Fewer Formula Surprises
I liked having a model where the logic was already set up, because one bad cell used to throw off my whole forecast. With this template, I caught issues faster and cut review time before our finance meeting by half.
Simple Scenario Planning
Comparing low, base, and high cases was finally easy instead of a full afternoon of copy and paste. I got clearer assumptions in one pass and booked a follow-up with our advisor the same day.