Skip to main content

Methodology

Customer Onboarding Payback Planner methodology

Find when retained monthly contribution recovers onboarding labour, implementation and acquisition cost.
Duc Nguyen X.By Duc Nguyen X.· Founder, Margin101Last reviewed: View update historyMethodology

Educational only: Business decision support, not accounting, tax or legal advice.

Privacy: Calculations run locally; Margin101 does not receive your commercial inputs.

Update policy: Reviewed when formulas or official dependencies change.

Scope: Market-neutral small-business planning using your own assumptions.

1. Formulas and units

Total upfront cost
totalUpfrontCost = onboarding hours × loaded rate + implementation cost + acquisition cost

Where

implementationCost
Implementation cost (currency units on one consistent basis)Source: Business record
acquisitionCost
Acquisition cost (currency units on one consistent basis)Source: Business record
totalUpfrontCost
Total upfront cost (money)Source: Calculated output
Cumulative contribution at horizon
cumulativeAtHorizon = sum of monthly contribution × retained share through the selected horizon

Where

cumulativeAtHorizon
Cumulative contribution at horizon (money)Source: Calculated output
Payback month
paybackMonth = exact fractional month where cumulative contribution crosses upfront cost

Where

monthlyContribution1
Month 1 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution2
Month 2 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution3
Month 3 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution4
Month 4 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution5
Month 5 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution6
Month 6 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution7
Month 7 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution8
Month 8 contribution (currency units on one consistent basis)Source: User assumption
monthlyContribution9
Month 9 contribution (currency units on one consistent basis)Source: User assumption
totalUpfrontCost
Total upfront cost (money)Source: Calculated output
paybackMonth
Payback month (units)Source: Calculated output

Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.

2. Worked example

Input assumptions

Worked values below come from the same registered engine and visible default assumptions.

Calculation and outputs

Example

Worked values below come from the same registered engine and visible default assumptions.

Total upfront cost
1,000.00 currency units
Cumulative contribution at horizon
1,000.00 currency units
Payback month
3

The exact engine-derived outputs are shown in the labelled rows below.

Interpretation

Use the exact crossing to test whether the entered contribution horizon can recover onboarding cost; it is not a retention forecast.

3. Validation and boundary checks

  • Monthly contribution and retention arrays must be aligned, finite and contain 1 to 36 months.
  • Retention shares remain between 0% and 100%.
  • The crossing uses raw cumulative contribution and may be fractional.
  • Zero upfront cost returns month zero; unrecovered cost remains explicit.

4. Assumptions and source classification

  • The selected 1-to-36-month horizon forms one cohort recovery window.
  • Contribution is entered before its matching retained share is applied.

This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.

5. Limitations

  • The result does not forecast retention, contribution or behaviour beyond the entered horizon.
  • It does not replace financial, accounting, tax or legal advice.

This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.

6. Update and evidence policy

Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.

Change history

  1. : Initial public release of the Customer Onboarding Payback planner and methodology.

Related reading

Guides to interpret the decision and its assumptions.

Return to the planner