Need an Excel Spreadsheet that will produce a profit projection for an affiliate program that pays on (2) Levels.
The Spreadsheet should allow us to enter:
1. A starting number of Affiliates
2. The number of new affiliates we think each existing Affiliate can recruit into the program on a monthly basis.
3. The amount of profit made by the company for each Product One sold
4. The amount of profit made by the company for Product Two sold.
5. Number of sales for Product One per month per affiliate.
6. Number of sales for Product Two per month per affiliate.
The Spreadsheet should calculate and show:
1. The increase in new Affiliate signups on a monthly basis for 1 year based on our input in item (1) above.
2. The profit earned by the company on a monthly and annual basis based on overall affiliate sales produced by a combination of (1) (2) (3) (4) (5) (6)