All tools
COHORTS / MARGIN / ATTRIBUTION / PAYBACK

Model the lift.
Price the work.

Compare a SaaS baseline with an email-influenced cohort model, then subtract platform, labor, and setup cost before calling the result ROI.

  • Monthly cash flow
  • Break-even solver
  • Local calculation
24-MONTH ATTRIBUTED CONTRIBUTION

Credited gross profit exceeds full modeled cost.

$154,713 credited gross profit − $49,650 full program cost across 24 months.

$105,063net contribution+211.6% ROI
Modeled lift is not causal evidence.

The credited-share input discounts the modeled difference, but it does not replace a holdout, randomized rollout, predeclared attribution rule, or reconciliation with billing data.

Credited gross profit$154,713

82.0% margin · 70.0% credited

Full program cost$49,650

$6,450 setup included

PaybackMonth 8

Within the 24-month horizon

Ending customer delta+237

$19,795 month-end MRR delta

MONTH-END MRR TRAJECTORY

Baseline and email-influenced run rate.

$35.3K$70.5K$105.8K$141.1KM0M12M24
Baseline MRR Email scenario MRR
SENSITIVITY, NOT PROBABILITY

See how lift magnitude changes the decision.

Conservative50% of entered effects
$26,501

+53.4% ROI · payback M16

PlanningEntered effects
$105,063

+211.6% ROI · payback M8

Upside125% of entered effects
$145,272

+292.6% ROI · payback M7

BREAK-EVEN SOLVERS

Price the program and isolate the conversion requirement.

MAXIMUM RECURRING BUDGET$6,178

Monthly program cost supported after the entered setup cost, using credited gross profit across the horizon.

CONVERSION LIFT NEEDED0.00 pp

Additional absolute trial-to-paid lift needed for net contribution to reach zero while retaining the entered churn and expansion effects.

CURRENT RECURRING COST$1,800

Platform, loaded monthly labor, and other recurring expense.

VALUE WATERFALL

Do not confuse revenue, gross profit, and net contribution.

RAW INCREMENTAL REVENUE$269,534

Scenario revenue minus baseline before margin or attribution.

× 82.0% margin
GROSS PROFIT BEFORE CREDIT$221,018

Revenue effect after the entered gross-margin assumption.

× 70.0% credit
CREDITED GROSS PROFIT$154,713

The share assigned to the email program.

$49,650 cost
NET CONTRIBUTION$105,063

The numerator used in the reported ROI.

MONTHLY LEDGER

Cohort flow, run rate, cost, and cumulative return.

MONTHBASE CUSTOMERSEMAIL CUSTOMERSBASE MRREMAIL MRRCREDITED GPCOSTCUMULATIVE NET
M11,2121,225$95,748$97,550$735$8,250-$7,515
M21,2241,249$96,666$99,485$1,326$1,800-$7,989
M31,2351,273$97,554$101,366$1,903$1,800-$7,886
M41,2461,296$98,414$103,194$2,466$1,800-$7,220
M51,2561,318$99,246$104,970$3,015$1,800-$6,005
M61,2661,340$100,052$106,697$3,550$1,800-$4,255
M71,2761,361$100,832$108,375$4,072$1,800-$1,983
M81,2861,381$101,587$110,005$4,581$1,800$798
M91,2951,401$102,318$111,590$5,077$1,800$4,075
M101,3041,421$103,025$113,130$5,561$1,800$7,836
M111,3131,439$103,710$114,626$6,033$1,800$12,069
M121,3211,458$104,373$116,081$6,493$1,800$16,762
M131,3291,475$105,014$117,494$6,942$1,800$21,904
M141,3371,493$105,636$118,868$7,379$1,800$27,483
M151,3451,509$106,237$120,203$7,806$1,800$33,489
M161,3521,526$106,819$121,501$8,222$1,800$39,911
M171,3591,542$107,382$122,761$8,627$1,800$46,739
M181,3661,557$107,928$123,987$9,023$1,800$53,962
M191,3731,572$108,456$125,178$9,408$1,800$61,570
M201,3791,586$108,967$126,335$9,784$1,800$69,554
M211,3861,601$109,461$127,460$10,150$1,800$77,904
M221,3921,614$109,940$128,553$10,507$1,800$86,612
M231,3981,628$110,404$129,615$10,856$1,800$95,668
M241,4031,641$110,852$130,648$11,195$1,800$105,063
MODEL REVIEW

Inputs are internally consistent.

Retention and expansion effects must be distinct

Do not credit the same customer or billing change to both lower churn and higher ARPA.

Entered effects cover full modeled cost

$105,063 remains after gross margin, attribution credit, recurring expense, and setup investment.

Scenario bands are sensitivity cases, not confidence bounds

The conservative and upside cases scale entered effects mechanically and do not describe statistical probability.

FINANCE HANDOFF

Export assumptions, cohort flows, scenario sensitivity, cost, attribution, payback, and model boundaries.

ROI requires a baseline that would exist without the proposed change.

The model runs identical monthly customer flows twice. The baseline uses current conversion, churn, and ARPA. The email scenario changes only the entered effects. Incremental value is the difference, not all revenue touched by email.

EMAIL ROIcredited incremental gross profitfull program cost÷full program cost

Opening customers churn, new paid customers enter, and the closing cohort becomes next month’s opening.

Conversion lift is entered in percentage points. Churn reduction is relative to baseline churn. Expansion lift changes scenario ARPA. Because all three effects live in the same recurrence, retained and newly converted customers are not added again as separate lifetime-value windfalls.

Apply gross margin, then subtract labor, platform, operating, and setup cost.

The model uses an average-customer convention within each month and reports month-end MRR separately. It does not treat future recurring revenue as cash received immediately, and it does not label incremental revenue as profit.

The attribution share is an explicit planning discount, not a causal certificate.

Use 100% only when the chosen design supports that claim. Holdouts, randomized rollouts, matched cohorts, billing reconciliation, and predeclared rules can strengthen the estimate. Opens and clicks alone do not establish incremental revenue.

Why use gross profit instead of revenue?+

Revenue ignores the cost of serving additional customers. Gross margin converts modeled revenue into contribution before the email program's own operating cost.

Is conversion lift relative or absolute?+

It is entered as absolute percentage points. Moving from 12% to 14% is a 2-point lift, not a 2% relative lift.

Does churn reduction include dunning?+

It can, but then do not add the same recovered customers elsewhere. Define the entered churn effect as a mutually exclusive net change versus baseline.

Why not multiply new customers by simple LTV?+

Doing that while also projecting monthly cohorts can count the same future revenue twice. The ledger recognizes the modeled customer population month by month.

Is the conservative scenario a confidence interval?+

No. It mechanically applies half the entered effect sizes. It is sensitivity analysis, not a probability statement.