Results 1 to 8 of 8

Help calculating leads needed in a year by month

Threaded View

3rdgenbruin Help calculating leads needed... 11-28-2023, 01:14 PM
DCatboone Re: Help calculating leads... 11-28-2023, 04:09 PM
3rdgenbruin Re: Help calculating leads... 11-28-2023, 04:18 PM
DCatboone Re: Help calculating leads... 11-29-2023, 11:45 AM
DCatboone Re: Help calculating leads... 11-30-2023, 08:57 AM
AliGW Re: Help calculating leads... 11-30-2023, 09:24 AM
DCatboone Re: Help calculating leads... 11-30-2023, 10:13 AM
DCatboone Re: Help calculating leads... 11-30-2023, 12:34 PM
  1. #1
    Registered User
    Join Date
    11-28-2023
    Location
    Scottsdale, AZ
    MS-Off Ver
    16.79 for Mac
    Posts
    2

    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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Counting and calculating days, month, year
    By jilaba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2023, 07:23 AM
  2. Replies: 4
    Last Post: 10-06-2021, 10:02 PM
  3. Formula needed to sumif by e0month using only month and year
    By jp16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2019, 01:28 AM
  4. Replies: 8
    Last Post: 05-18-2018, 02:35 PM
  5. Calculating the number of times a value appears based on Month and Year
    By achimbos in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2015, 06:58 PM
  6. [SOLVED] Month/ Year Formula Needed
    By neelpatel in forum Excel General
    Replies: 6
    Last Post: 07-31-2012, 03:55 PM
  7. Replies: 2
    Last Post: 03-05-2012, 03:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1