Wauvel
← All tools

Unit Economics Calculator (by business model)

Reasoning

What one order, subscription, hour, or cover really earns. Switch between D2C, SaaS, services, and restaurant models and watch the gross → contribution → net ladder resolve.

The unit is one order. Physical goods: the contribution waterfall on a single order.Set your numbers and the ladder resolves live — then download a branded Excel where every result is a formula off your inputs. The math the P&L (and QuickBooks) won't break out for you.

CM1 · gross margin

$42.00

70% — price less product cost

CM2 · contribution

$22.02

37% — after fulfilment

CM3 · after CAC

-$5.98

first order underwater — wins on repeat

Best filled in on a bigger screen

This calculator has a lot of inputs — open it on a laptop or desktop to work through them comfortably. You can still switch presets above, read the ladder, and download the Excel below.

Break-even CAC

$22.02

the most you can pay and still clear CM2

CAC payback

1.3 orders

orders of contribution to earn CAC back

Want the full walk-through? Read the series: D2C, SaaS, services, restaurants, and contractors.

Want this on your real numbers? Wauvel builds it straight from your QuickBooks.

Meet your AI CFO →

More free tools

ForecastingExcel · .xlsx

Annual Operating Plan (AOP) Builder

The plan you set the year by: revenue built up stream by stream, cost of sales, and operating expenses by category — twelve months across, with gross profit and operating income falling out for you.

Open the tool →
ForecastingExcel · .xlsx

Recurring Revenue Model (SaaS / Subscriptions)

Build a subscription revenue forecast the way investors read it: new customers, ARPA, churn, and expansion drive a monthly MRR/ARR build, with the new → expansion → churn bridge tying out automatically. Industry presets for SaaS, memberships, subscription boxes, and retainers.

Open the tool →
ForecastingExcel · .xlsx

Capacity & Utilization Revenue Model

Forecast revenue for a capacity business: units × sellable slots × utilization × price, plus ancillary revenue. Industry presets for salons, restaurants, hotels, clinics, trucking/fleet, and professional services — tune capacity, occupancy, and rate and watch revenue (and RevPAR-style yield) build month by month.

Open the tool →
ForecastingExcel · .xlsx

Funnel / Transaction Revenue Model

Forecast a paid-acquisition business: spend → sessions → orders → revenue, with returns, repeat purchases, CAC, and contribution. Industry presets for ecommerce/DTC, marketplaces (take rate), and lead generation — see how spend and conversion translate into revenue month by month.

Open the tool →
ForecastingExcel · .xlsx

3-Statement Financial Model

Set a handful of assumptions — growth, margins, working-capital days, capex, financing — and project a fully linked income statement, balance sheet, and cash flow three years out, monthly. The balance sheet balances and cash ties, automatically.

Open the tool →
ForecastingExcel · .xlsx

13-Week Cash Flow Forecast

The rolling weekly forecast every CFO keeps: beginning balance, money in, money out, and the projected low point that tells you exactly when cash gets tight.

Open the tool →
ForecastingExcel · .xlsx

Cash Runway Calculator

How many months of cash you have — counted the way a CFO would. Set your cash on hand, what you collect, and your monthly burn, and it solves runway both ways: the flat-burn number, and the honest one that grows burn and collections forward to the month cash actually hits zero — or shows you're default alive. Then it prices the levers: trim burn, collect faster, and watch the runway move.

Open the tool →
ReportingExcel · .xlsx

Budget vs. Actual (Monthly P&L)

A month's P&L with plan set beside reality and the variance computed for you — so every number turns into feedback instead of weather.

Open the tool →
ReasoningExcel · .xlsx

CAC & LTV Calculator (Ecommerce Unit Economics)

The number every ecommerce founder needs and the books can't give you: how much you can afford to pay for a customer. Set your order value, margin, and repeat rate against your ad spend, and it solves CAC, a contribution-based LTV, the LTV:CAC ratio, payback period, break-even ROAS, and your maximum profitable CAC — with a sensitivity table showing how the ratio and payback move as CAC changes. Built for DTC and online stores.

Open the tool →
ReasoningExcel · .xlsx

Break-Even & Contribution Margin Calculator

The number every owner should know: how much you have to sell to cover your costs. Set price, variable cost, and your fixed costs, and it solves break-even in units and revenue — then shows your margin of safety, the volume to hit a profit target, and how break-even moves when you change price.

Open the tool →
ReasoningExcel · .xlsx

Price / Volume / Mix Bridge

Revenue or margin moved — but why? Enter what you sold in two periods, line by line, and it splits the change into the three things that actually cause it: price (you charged more or less), volume (you sold more or fewer units), and mix (you sold a different blend of products). Add unit costs and it does the same for gross profit, isolating a cost effect too. New and dropped lines are handled cleanly, the bridge always ties out to the penny, and the download recomputes every effect as a live Excel formula. The decomposition QuickBooks won't do for you.

Open the tool →
ReasoningExcel · .xlsx

Financial Health KPI Tracker

The vital signs on one page — margins, current ratio, days-to-get-paid, the cash conversion cycle, runway — tracked month over month with the formulas already in.

Open the tool →