Forum Discussion
I need help with a formula :(
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 | $ - |
2 Replies
- Perhaps you could explain the relationship between your words and the data in that table you show.
It would actually be helpful if you attached a mockup spreadsheet--presumably what you used to create that table. That way we could test the answer with your data rather than asking us to replicate it.- ok! I will do that
