I have a sales funnel that I'm creating and I need a formula that will extrapolate and compound revenue over a 12 month period and I can't figure out how to do it. Here's an example:
Daisy wins 1.5 new clients every month, each client stays for 9 mos. What formula can I use that will account for the 9 mos of revenue per client, plus each month add new client revenue?
| Your Target's Company Name | Potential Client Candidates | Your monthly Referral Goal | Monthly new Clients | Monthly Revenue by Referrer | Annual New Clients | Annual Rev by Referrer | Mon 1 | Mon 2 | Mon 3 | Mon 4 | Mon 5 | Mon 6 | Mon 7 | Mon 8 | Mon 9 | Mon 10 | Mon 11 | Mon 12 | Total |
| | | | | | | | | | | | | | | | | | | | |
| rehab 1 | 30 | 3 | 1.5 | $ 3,897.00 | 18.00 | $ 280,584.00 | | | | | | | | | | | | | $ - |
