Short answer: build a CRM cost-and-benefit model from your own inputs, and keep cash, internal time, released capacity, and realized gains on separate lines. A percentage called “ROI” is only as meaningful as those four definitions. This page gives you the formulas, a vendor-neutral worked example, and the boundary cases. It publishes no industry-average ROI, benchmark conversion rate, or return promise.

What to put on each line

Use four named categories. They answer different questions and must not be silently added into one undifferentiated “savings” number:

Category What it measures Where it belongs
Cash purchases Invoices paid to vendors or suppliers, plus applicable purchase tax Cash cost
Staff-time opportunity cost Internal migration and training hours valued at a chosen loaded rate Economic cost only
Released capacity Freed hours actually redeployed into useful work, valued at a chosen rate Economic benefit only
Realizable cash gain Verified spending removed, or incremental gross profit actually realized in the period Cash benefit and economic benefit

Subscription and one-time external purchases are cash costs. In this example, a 670.00 USD taxable purchase subtotal at an 8 percent rate produces 53.60 USD of tax and 723.60 USD of cash cost. Purchase tax applies only to purchases that are taxable in your jurisdiction; it is not applied to internal staff time, capacity estimates, or gains. Internal time cost is (migration hours + training hours) x internal hourly cost. Released capacity is hours freed x value per hour x realization rate; it is an economic valuation, not a cash receipt.

The formulas

  • subscription cash = current unit price x active users x months
  • cash cost = (subscription cash + external one-time purchases) x (1 + applicable purchase-tax rate)
  • internal time cost = (migration hours + training hours) x internal hourly cost
  • economic cost = cash cost + internal time cost
  • released capacity value = minutes saved per working day x users x benefit-period working days / 60 x value per released hour x realization rate
  • incremental gross profit = incremental revenue x gross margin - incremental costs of serving that revenue
  • realizable cash gain = (benefit-period verified avoided spending + benefit-period incremental gross profit) x cash realization rate
  • economic gain = realizable cash gain + released capacity value
  • economic ROI = (economic gain - economic cost) / economic cost
  • cash ROI = (cash gain - cash cost) / cash cost

Revenue is not profit. Enter incremental revenue only after converting it through your own gross margin and subtracting the extra costs required to serve it. If the same released hours are used to generate that revenue, set their separate capacity value to zero; otherwise the same hours are counted twice. When the economic-cost denominator is zero or negative, ROI is Not applicable, not an infinite percentage. A positive cost with zero gain can produce -100% ROI, but recovery is still Not applicable.

For vendor prices and dated terms, use our entry-level pricing checklist. Keep the price quote outside the benefit formula: a price is a cost input, while a future price is a separate assumption.

Worked example: all inputs are hypothetical

This example measures a single 12-month evaluation period. Benefits begin at the start of month 3, so the benefit period covers months 3 through 12. The 220 working days, the 180 USD of verified avoided cash, and the 1,200 USD replacement-scenario revenue are totals for that benefit period: they are hypothetical totals for those months, not full-year rates copied into a shorter window. The 5,500 USD released-capacity estimate uses the same benefit-period working-day total. Costs and the uniform payback assumption are stated separately below.

Every number below is synthetic. The 7.00 USD current unit price and 20.00 USD future unit price are arithmetic inputs only; neither is a vendor price, promotion, plan quote, or future billing commitment. The team supplies all benefit inputs. The model does not claim these values are typical or that the CRM caused a measured change.

Line Example value Calculation
Subscription cash before tax 420.00 USD 7 x 5 users x 12 months
One-time external cash before tax 250.00 USD hypothetical setup purchase
Purchase tax on 670.00 USD 53.60 USD 8 percent of taxable cash purchases
Cash cost 723.60 USD 670.00 + 53.60
Migration and training time 1250.00 USD (40 + 10) h x 25 USD/h; untaxed internal time
Economic cost 1973.60 USD cash cost + internal time opportunity cost
Released time 275.00 h 15 min x 5 users x 220 benefit-period days / 60
Released capacity value 5500.00 USD 275 h x 40 USD/h x 50 percent realization; economic value, not cash
Verified avoided cash 180.00 USD 180 USD benefit-period total x 100 percent realization; incremental revenue is zero
Economic gain 5680.00 USD cash gain + released capacity value
Economic ROI 187.80% (5680.00 – 1973.60) / 1973.60
Cash ROI -75.12% (180.00 – 723.60) / 723.60

A future unit price of 20 USD would produce 1296.00 USD of subscription cash under the same 8 percent tax assumption. That is one sensitivity input, not a prediction or a renewal quote. The CRM selection guide can help define the process being priced; our implementation planning guide helps estimate the staff-time and benefit-timing rows.

Recovery timing: economic and cash are different

The simple economic value payback in this example is 5.47 months from project start. It assumes all 1973.60 USD of economic cost occurs at month 0, benefits first appear at the beginning of month 3, and the 5680.00 USD economic gain accrues uniformly over the remaining 10.00 months. That is a planning simplification: it values staff time and released capacity alongside cash, and it gives no month-by-month cash-flow view. If costs are spread across the year or benefits are seasonal, replace this formula with a monthly schedule.

The cash payback uses only 723.60 USD of cash cost and 180.00 USD of realizable cash gain under the same timing assumption. Here it is Not applicable within the 12-month horizon. Calling the economic figure a cash payback would hide the difference between an internal valuation and money actually received.

Boundaries and sensitivity

  • Zero benefit: if time saved, capacity realization, cash realization, avoided cash, and incremental revenue are all zero, economic ROI is -100.00% and payback is Not applicable (not_applicable). There is no gain from which to recover cost.
  • Zero realization: with both realization rates at zero and no revenue, economic ROI is -100.00% and payback is Not applicable (not_applicable). Identified potential is not realized value.
  • Zero cost denominator: when all cash and time costs are zero, ROI returns Not applicable (not_applicable); payback returns Not applicable (not_applicable). The model returns these states without dividing by zero.
  • Revenue replacing freed capacity: a separate hypothetical scenario has 1,200 USD incremental revenue, 30 percent gross margin, and 60 USD extra service costs, all as totals for the same benefit period. Its incremental gross profit is 300.00 USD. Because those same freed hours produce the revenue, their separate capacity value is 0.00 USD, making total economic gain 480.00 USD. Adding the 5500.00 USD capacity valuation on top would double count the same hours.
  • Tax is nonzero here: raising or lowering the 8 percent rate changes cash purchases only. Internal time cost and released capacity value stay the same. This nonzero-tax case can be checked by applying the cash-cost formula above.
  • Before and after is not causation: a measured change in minutes, revenue, or errors may also reflect seasonality, staffing, pricing, or a different process. Record those conditions; do not attribute every improvement to the CRM.

Fill in the worksheet

The single downloadable CSV is a static reference file: it contains 22 example inputs and 30 results computed from those inputs. Keep the result IDs as a reference when you build your own sheet. Editing an input in the CSV does not recalculate the result rows; apply the formulas above, or an equivalent calculation you trust, to your edited inputs and compare the new results with the reference IDs. Only this one CSV is provided publicly; the internal recompute script and review evidence are not part of the download.

Download the worked example inputs and expected results

Our CRM integration planning guide helps define the work behind migration hours, and the data export and migration checklist covers one-time exits. Those are implementation inputs, not ROI evidence.

Sources and scope

This is a modeling method with synthetic arithmetic. It makes no vendor price, market-average ROI, adoption-rate, or customer-result claims. The downloadable CSV is a static worked example, not a calculator and not an external study; internal review files are not provided as reader downloads. The linked published guides are reader navigation, not evidence for a benefit forecast. Disclosure: this page contains no affiliate links; the worked example is illustrative arithmetic on stated hypothetical inputs, not a projection or a return promise.