I need help with a formula :(

%3CLINGO-SUB%20id%3D%22lingo-sub-2595437%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20a%20formula%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595437%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sales%20funnel%20that%20I'm%20creating%20and%20I%20need%20a%20formula%20that%20will%20extrapolate%20and%20compound%20revenue%20over%20a%2012%20month%20period%20and%20I%20can't%20figure%20out%20how%20to%20do%20it.%20Here's%20an%20example%3A%26nbsp%3B%3C%2FP%3E%3CP%3EDaisy%20wins%201.5%20new%20clients%20every%20month%2C%20each%20client%20stays%20for%209%20mos.%20What%20formula%20can%20I%20use%20that%20will%20account%20for%20the%209%20mos%20of%20revenue%20per%20client%2C%20plus%20each%20month%20add%20new%20client%20revenue%3F%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%221939%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22206%22%3EYour%20Target's%20Company%20Name%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3EPotential%20Client%20Candidates%3C%2FTD%3E%3CTD%20width%3D%2293%22%3EYour%20monthly%20Referral%20Goal%3C%2FTD%3E%3CTD%20width%3D%2278%22%3EMonthly%20new%26nbsp%3B%20Clients%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3BMonthly%20Revenue%20by%20Referrer%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3EAnnual%20New%20Clients%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22106%22%3E%26nbsp%3BAnnual%20Rev%20by%20Referrer%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%201%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%202%3C%2FTD%3E%3CTD%20width%3D%2293%22%3EMon%203%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%204%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%205%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%206%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%207%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%208%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%209%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%2010%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%2011%3C%2FTD%3E%3CTD%20width%3D%2291%22%3EMon%2012%3C%2FTD%3E%3CTD%20width%3D%2285%22%3ETotal%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Erehab%201%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E30%3C%2FTD%3E%3CTD%20width%3D%2293%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2278%22%3E1.5%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%203%2C897.00%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E18.00%3C%2FTD%3E%3CTD%20width%3D%22106%22%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20280%2C584.00%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2595437%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595451%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20a%20formula%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595451%22%20slang%3D%22en-US%22%3Eok!%20I%20will%20do%20that%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595449%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20a%20formula%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595449%22%20slang%3D%22en-US%22%3EPerhaps%20you%20could%20explain%20the%20relationship%20between%20your%20words%20and%20the%20data%20in%20that%20table%20you%20show.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20would%20actually%20be%20helpful%20if%20you%20attached%20a%20mockup%20spreadsheet--presumably%20what%20you%20used%20to%20create%20that%20table.%20That%20way%20we%20could%20test%20the%20answer%20with%20your%20data%20rather%20than%20asking%20us%20to%20replicate%20it.%3C%2FLINGO-BODY%3E
New Contributor

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 CandidatesYour monthly Referral GoalMonthly new  Clients  Monthly Revenue by Referrer Annual New Clients  Annual Rev by Referrer Mon 1Mon 2Mon 3Mon 4Mon 5Mon 6Mon 7Mon 8Mon 9Mon 10Mon 11Mon 12Total
                    
rehab 13031.5 $     3,897.0018.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