Referral Group Worksheet
| Cost Assessment Worksheet |
|
|
|
|
What percentage of the leads obtained from referrals actually become
customers? (decimals allowed) |
|
The average monthly customer bill is: |
|
For any group of leads, a certain percentage of the resulting customers actually refers (Referral Group).
That percentage is: (decimals allowed) |
|
The monthly commission rate for customers in the Referral Group is: |
% |
The Referral Group consists of 3 smaller groups: Groups 1, 2, and 3.
Group 1 consists of a percentage of people in the Referral Group who only make a few referrals
in the first month and never refer again.
Group 2 consists of a percentage of people in the Referral Group who make a certain constant
number of referrals every month.
Group 3 consists of a percentage of people in the Referral Group who also make a certain constant
number of referrals every month (but a different number from the people in Group 2). |
The imputed rate of interest is:
This amount is compounded on a (weekly, monthly, annual) basis: |
%
|
Group 1 constitutes what percentage of the Referral Group? (decimals allowed) |
|
The average lifetime of a customer (in months) is: |
|
How many people does a person in Group 1 refer within the first month? (decimals allowed) |
|
The percentage of the Referral Group that eventually earns $100 or more in commissions is
(this value is not being factored in at this time): |
% |
Group 2 constitutes what percentage of the Referral Group? (decimals allowed) |
|
The average amount earned (but not paid) by those referrers who never earn more than $100 is:
(this value is not being factored in at this time): |
|
How many people does a person in Group 2 refer each month? (decimals allowed) |
|
For most referrers, commission checks do not go out every month because the amount has to accumulate to
$100 before payment is made. What is the average gap between paychecks (for monthly checks, the gap is 0) ( not
factored in at this time): |
|
Group 3 constitutes what percentage of the Referral Group? (decimals allowed) |
|
|
How many people does a person in Group 3 refer each month? (decimals allowed) |
|
On the average, for how many months does a referrer either in Group 2
or Group 3, continue referring, from the time he first becomes a customer? |
|