Finance & Business , 9 calculators

Pricing & Profitability Calculators

Test volume tiers, bundles, quotes, promotions and subscription plans, and see which products, customers, channels and orders earn their costs. Every calculator here runs live on a reviewed spreadsheet model, and shows its equations and the sources it cites.

Start from your question

What are you working out?

The calculators

All 9 pricing & profitability calculators

Price structure

Bundle Pricing & Product Mix Optimizer

Prices up to 3 bundles of up to 10 products jointly. Customer groups enter their size and the most they will pay, buy the bundle that leaves them the most money, and bundles draw stock in a fixed priority order before products sell on their own. One Calculate compares no bundles, your plan and the best of up to 125 combinations, with a what-if table of bundle cost against bundle demand. A different split of stock could earn more; estimates for planning, not advice.

Profitability analysis

Channel & Marketplace Profitability Calculator

Shows what is left from each sale across up to 3 channels, for up to 10 products over 1 to 12 months: fee rules with minimums, caps, month windows and refunds on returns, fulfilment, return shipping, ads, storage and cash timing. One Calculate fills the plan, a fee audit, the break-even and target prices, 100 simulated return levels and a what-if table of price against returns. Every value is your assumption; estimates for planning, not advice.

Profitability analysis

Cost-to-Serve & Minimum Profitable Order Calculator

Finds what each order costs to serve and what it earns, by customer segment and order size: product cost, order activities, carrier bands per shipment, payment fees and returns against the net price, the shipping charge and any small-order surcharge. One Calculate posts the period ledger, finds the break-even and minimum profitable order size, every profitable size range and an optional target size, compares up to three order policies on the same orders, and tabulates contribution across product and delivery cost. Every value is your assumption; estimates for planning, not advice.

Price structure

Price Volume Profit Scenario Simulator

Projects revenue, costs and profit for up to five products sharing one capacity over up to 12 months, with fixed, linear or constant-elasticity demand you set. One Calculate also finds the best candidate price for one product, the price that reaches a target profit when you enter one, and the range of 100 seeded demand scenarios, and tabulates profit across price changes and demand responses. Demand is your assumption, not a forecast; estimates for planning, not advice.

Profitability analysis

Product & Customer Profitability Analyzer

Builds net revenue, product cost, contribution and profit for up to 50 sales summary rows by product, customer and channel, spreads up to five shared cost pools over the rows by revenue, units or activity to the cent, and shows one focus customer with a what-if table of price and direct cost multipliers. Allocated profit is not the profit a customer adds; estimates for planning, not advice.

Promotions and incentives

Promotion & Discount Profitability Calculator

Compares up to 3 promotions for up to 5 products over 1 to 6 periods, on the same baseline and stock: percent off, fixed amount off or multibuy, with lift, cannibalization, halo, pull-forward, stock limits and returns. One Calculate fills the plan, a profit bridge, the lift needed to reach a target, 100 simulated lifts and a what-if table of offer depth against lift. Every value is your assumption; estimates for planning, not advice.

Deals & contracts

Quote Pricing & Deal Margin Optimizer

Prices a quote of up to 20 goods, labor, fee and recurring lines: net revenue after each line discount, direct cost (labor from role rates), a sales commission on marginal tiers, contribution and margin, and the deal cash dated by month with its present value. One Calculate also finds the largest common discount a margin floor or a minimum net revenue allows, the price multiplier that reaches a target margin, and tabulates contribution across labor hours and discount changes. Estimates for planning, not advice.

Recurring revenue

Subscription Pricing & Unit Economics Simulator

Projects a subscription business with up to 3 monthly or annual plans over 1 to 24 months: renewals, moves and churn, revenue against cash and the deferred balance, usage cost, acquisition spend and fixed cost. One Calculate fills the plan, CAC, finite-horizon LTV and payback by cohort, 100 simulated scenarios of new subscribers and churn, and a what-if table of operating result by price and churn. Price and churn are not linked and no optimal price is claimed; estimates for planning, not advice.

Price structure

Tiered Pricing & Volume Discount Optimizer

Prices up to five products sold in volume tiers, all-units (every unit at the price of the tier the order reaches) or incremental (each unit at the price of its own tier), with a charge and a cost per order and purchase-cost breaks. One Calculate posts every order to the cent, finds the dead zones where a bigger all-units order pays less, checks one order in detail, tries every combination of up to five prices per tier for one product within your margin floor and average price cap, and tabulates the contribution of one order across order sizes and unit-cost changes. Demand is fixed; estimates for planning, not advice.

Results are informational and not professional advice. See our Terms of Use. Calculations powered by SpreadsheetWeb.
About · Privacy · Terms