computer120
New Member
- Joined
- Nov 12, 2018
- Messages
- 2
Hi, I'm having trouble with this problem
Construct a forecasting worksheet to calculate:
1. the number of new clients each month, and
2. the total client base (cumulative number of clients signed up) each month.
In your model, make projections for 60 months (Periods) for the two scenarios below:
Scenario 1: Constant Market - Total market potential is 1,000,000 customers. Each month you sign up2% of customers in the market that have not yet signed up.
Scenario 2: Growing Market - Total market potential is initially 1,000,000 customers but grows at 1%per month. Each month you sign up 2% of customers in the market that have not yet signedup.
What functions am I suppose to use
Thank you
Construct a forecasting worksheet to calculate:
1. the number of new clients each month, and
2. the total client base (cumulative number of clients signed up) each month.
In your model, make projections for 60 months (Periods) for the two scenarios below:
Scenario 1: Constant Market - Total market potential is 1,000,000 customers. Each month you sign up2% of customers in the market that have not yet signed up.
Scenario 2: Growing Market - Total market potential is initially 1,000,000 customers but grows at 1%per month. Each month you sign up 2% of customers in the market that have not yet signedup.
What functions am I suppose to use
Thank you