Help calculating leads needed in a year by month

For the life of me, I can figure this out! Any help is much appreciated.

I know two variables:
- Monthly growth rate: 8%
- End of year target: 50

I need to calculate how many leads I need each month to hit that year end total. I know by figuring it out manually that the month one number is 2.635. It then grows by 8% per month and finishes in month 12 at 6.144. The sum of all 12 months ends up being 50, which is my target. But how can I calculate this so that if my growth rate or target change, the months are automatically recalculated?

I'm not exactly sure what you're trying to do, the initial # of leads is needed to make any projections. This will show you the projected # of leads based on the goal growth % as well as show you growth per month. Hopefully this helps you in some way

If I know I need a total of 50 leads by the end of the year and I'm trying to demonstrate an 8% month over month growth rate, how many leads do I need to start with in January?

I've manually calculated the necessary January leads as 2.635, but I'd to be able to calculate it automatically. If I need 70 leads, what are the January leads? What if the growth rate is 6% instead of 8%?

I guess another way to put it, what is the monthly distribution of leads that shows 8% (or whatever I change it to) month over month growth and adds up to 50 (or whatever I change it to)?

The problem I'm having with this is if these are like sales leads, you're going to be dealing with whole numbers. I can make a projection which totals the sum total of leads based on the growth rate, and a simple tracker that tells you the current growth rate you're at. But I'm having trouble how you'd have X.XX leads instead of X leads. Finding the initial value of an exponential growth formula while matching a sum total is more complicated math than I can figure out. I also don't have their calculus add in installed. I think it'd be far simpler for what I think you're trying to do is have the % be a variable you can change, use SUM(PRODUCT(C6,$B$2),C6) (c6 is january, B2 is %) and then have a sum total at the end, and then change the value of January until you get the sum total you desire.

This is solved, attached is the sample for your use. This took a bit longer than I thought, sorry for the delay.

ok, so for this to work, i needed a counter, and powers row for the math formula to work. The counter counting the months 0-11 (Jan-Dec). The powers = (1+GrowthRate)^Counter, and then to calculate the leads per month = ((LeadsGoal*(1+GrowthRate)^Counter))/SumTotalofPowers

I thought I did attach the workbook which has this all laid out. Most likely you'd want to hide the counter and powers rows to make it look tidier. So LeadsGoal = the desired # summed leads for the year, GrowthRate = the desired growth rate per month.

the goal values (Leads and Growth %) are variables in C3 and C4 respectively. The counter is B10-M10. $N$11 is the sum total of the powers row.

Leads (Jan-Dec)

Formula:

Please Login or Register  to view this content.

counters Jan-Dec are just numerical 0, 1, 2, 3... etc.
powers formula

Formula:

Please Login or Register  to view this content.

not sure if this is what you wanted