Calculation guide
For business owners exploring costs, cash flow or valuation scenarios.
Keep revenue, cost and time periods consistent. Profit margin divides by revenue; markup divides by cost. Discounted cash flows are scenario assumptions, and terminal growth must be below the discount rate. Payback uses linear interpolation within the recovery period. Customer lifetime value uses the entered finite horizon, retention, margin and discount assumptions. No valuation or business outcome is guaranteed.
Inputs
Customers
Number of new customers gained from the entered acquisition spending.
Amount
Amount for this calculation or dated cash flow. Where negative amounts are allowed, negative means paid out and positive means received.
Worked example
| Input | Value |
|---|---|
| Customers | 50 |
Acquisition costs
| Amount |
|---|
| 10,000 |
| 5,000 |
Formula:
(10000 + 5000) / 50
Cost per customer = 300.000000000000
| Result | Value |
|---|---|
| Cost per customer | 300 |
| Total acquisition cost | 15,000 |
Interpreting the result
Total entered acquisition spending divided by new customers.
Sum of acquisition spending across the entered rows.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Customers | 50 | 55 | Cost per customer | 300 | 272.727273 |
| Amount (row 1) | 10,000 | 11,000 | Cost per customer | 300 | 320 |
