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?
Application by Paul Corazza
Telegroup, IN
version 3.0
Jan 4 98
New: Dynamic tables;
user interface design.