Act on the result
Use the funding gap before delivery and final contribution to set the preorder deposit or arrange funding before launch.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Sellers testing whether preorder deposits cover supplier and launch cash commitments.
Outputs
Deposit cash, pre-delivery funding gap, order contribution and total preorder profit.
Start here
Place every receipt and payment in the period when cash actually moves.
Use a different tool when: Do not use this to forecast weekly closing cash, the first shortfall and the funding gap across a 13-week operating horizon; use 13-Week Cash Flow Forecast for that decision. Use this tool to test preorder funding gap and final contribution.
Commerce & operations
Preorder Cash & Profitability: deposit cash
Deposit cash, pre-delivery funding gap, order contribution and total preorder profit.
Amounts use the same currency as your inputs. No currency conversion is performed.
Preorder Cash & Profitability
Test whether preorder cash timing and fulfilment risk justify the offer.
Your numbers stay in this browser
Whole preorder units.
Final selling price per unit. Enter the amount on one consistent ex-tax market-currency basis.
Share collected before delivery.
Fee on customer payments.
Supplier deposit required per unit. Enter the amount on one consistent ex-tax market-currency basis.
Remaining supplier cost per unit. Enter the amount on one consistent ex-tax market-currency basis.
Fulfilment per delivered unit. Enter the amount on one consistent ex-tax market-currency basis.
Decision result
Each output is bound to its registered ecommerce engine formula.
- Customer Deposits
- 25,000.00
- Payment Fees
- 1,500.00
- Cash Before Delivery
- 24,250.00
- Cash Required Before Delivery
- 12,500.00
- Funding gap before delivery
- 0.00
- Final Contribution
- 22,000.00
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Current scenario0.00Baseline
Lower Customer deposit rate0.000.00
Higher Customer deposit rate0.000.00
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Customer Deposits
Customer Deposits
units × price × deposit rate25,000.00Result25,000.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Preorder Cash & Profitability Planner formulas →Inputs used by these formula steps
- Customer DepositsUnits
- 500
- Customer DepositsSelling Price
- 100
- Customer DepositsDeposit Rate
- 0.5
- Customer DepositsPayment Fee Rate
- 0.03
- Customer DepositsSupplier Deposit Per Unit
- 25
- Customer DepositsSupplier Balance Per Unit
- 20
- Customer DepositsFulfilment Per Unit
- 8
Payment Fees
Payment Fees
units × price × payment fee1,500.00Result1,500.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Preorder Cash & Profitability Planner formulas →Inputs used by these formula steps
- Payment FeesUnits
- 500
- Payment FeesSelling Price
- 100
- Payment FeesDeposit Rate
- 0.5
- Payment FeesPayment Fee Rate
- 0.03
- Payment FeesSupplier Deposit Per Unit
- 25
- Payment FeesSupplier Balance Per Unit
- 20
- Payment FeesFulfilment Per Unit
- 8
Cash Before Delivery
Cash Before Delivery
customer deposits − payment fees charged on the deposit24,250.00Result24,250.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Preorder Cash & Profitability Planner formulas →Inputs used by these formula steps
- Cash Before DeliveryUnits
- 500
- Cash Before DeliverySelling Price
- 100
- Cash Before DeliveryDeposit Rate
- 0.5
- Cash Before DeliveryPayment Fee Rate
- 0.03
- Cash Before DeliverySupplier Deposit Per Unit
- 25
- Cash Before DeliverySupplier Balance Per Unit
- 20
- Cash Before DeliveryFulfilment Per Unit
- 8
Cash Required Before Delivery
Cash Required Before Delivery
units × supplier deposit12,500.00Result12,500.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Preorder Cash & Profitability Planner formulas →Inputs used by these formula steps
- Cash Required Before DeliveryUnits
- 500
- Cash Required Before DeliverySelling Price
- 100
- Cash Required Before DeliveryDeposit Rate
- 0.5
- Cash Required Before DeliveryPayment Fee Rate
- 0.03
- Cash Required Before DeliverySupplier Deposit Per Unit
- 25
- Cash Required Before DeliverySupplier Balance Per Unit
- 20
- Cash Required Before DeliveryFulfilment Per Unit
- 8
Funding gap before delivery
Funding Gap Before Delivery
max(0, required cash − available cash)0.00Result0.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Preorder Cash & Profitability Planner formulas →Inputs used by these formula steps
- Funding Gap Before DeliveryUnits
- 500
- Funding Gap Before DeliverySelling Price
- 100
- Funding Gap Before DeliveryDeposit Rate
- 0.5
- Funding Gap Before DeliveryPayment Fee Rate
- 0.03
- Funding Gap Before DeliverySupplier Deposit Per Unit
- 25
- Funding Gap Before DeliverySupplier Balance Per Unit
- 20
- Funding Gap Before DeliveryFulfilment Per Unit
- 8
Final Contribution
Final Contribution
sales − supplier and fulfilment costs − fees22,000.00Result22,000.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Preorder Cash & Profitability Planner formulas →Inputs used by these formula steps
- Final ContributionUnits
- 500
- Final ContributionSelling Price
- 100
- Final ContributionDeposit Rate
- 0.5
- Final ContributionPayment Fee Rate
- 0.03
- Final ContributionSupplier Deposit Per Unit
- 25
- Final ContributionSupplier Balance Per Unit
- 20
- Final ContributionFulfilment Per Unit
- 8
Inputs used
- Preorder units
- 500
- Selling price
- 100.00
- Customer deposit rate
- 50%
- Payment fee rate
- 3%
- Supplier deposit
- 25.00
- Supplier balance
- 20.00
- Fulfilment cost
- 8.00
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| depositRate | Share collected before delivery. | proportion of preorder selling price collected as deposit | 0 to 1 | Required | 0.5 |
| fulfilmentPerUnit | Fulfilment per delivered unit. Enter the amount on one consistent ex-tax market-currency basis. | currency units/preorder unit, ex tax | 0 to 100000000 | Required | 8 |
| paymentFeeRate | Fee on customer payments. | proportion of order revenue charged as payment fee | 0 to 1 | Required | 0.03 |
| sellingPrice | Final selling price per unit. Enter the amount on one consistent ex-tax market-currency basis. | currency units/planning period, ex tax | 0 to 100000000 | Required | 100 |
| supplierBalancePerUnit | Remaining supplier cost per unit. Enter the amount on one consistent ex-tax market-currency basis. | currency units/event, ex tax | 0 to 100000000 | Required | 20 |
| supplierDepositPerUnit | Supplier deposit required per unit. Enter the amount on one consistent ex-tax market-currency basis. | currency units/event, ex tax | 0 to 100000000 | Required | 25 |
| units | Whole preorder units. | whole preorder units/planning period | 0 to 100000000 | Required | 500 |
Preorder Cash & Profitability: deposit cash
The funding gap before delivery shows whether customer deposits cover supplier deposits after payment fees.
Formula summary
- Primary formula
- funding gap = max(0, supplier deposit − customer deposits net of fees)
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest customer deposit rate as a percentage of selling price and supplier deposit in currency units per preorder unit.
When this estimate can be misleading
- All provider fees, exchange rates, returns, demand and operating rates are user-entered scenarios.
- Use one consistent ex-tax currency and planning period across compared inputs.
- This is educational business decision support, not accounting, tax, legal or financial advice.
- The funding gap before delivery shows whether customer deposits cover supplier deposits after payment fees.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- Why Inventory Growth Can Create a Cash Crisis
Map supplier payment, stock commitment, sell-through and customer receipt dates to expose the inventory funding gap.
Read guide
Frequently asked questions
How do I test preorder funding gap and final contribution?
Use the funding gap before delivery and final contribution to set the preorder deposit or arrange funding before launch.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.