A leader in a non-profit organization recently challenged us to realize the potential outcome of setting regular new support goals. His query to us was to determine how much money you could raise at the end of one year, if every three days you gained a new $25 per month supporter.
Is there a formula for this that could be used to demonstrate $50 or $100 as well?
Each new supporter is a monthly contributor, so the first ten or so would obviously equate to $300 at the end of a year, correct? ($25*12)
However, as you gain a new supporter every 3 days, the last new supporter would only bring $25 in for that year.
What formula could demonstrate how to express this math, in the simplest format, as well as the most versatile- meaning where the period of days (3) could be set to once a week (7), for instance. The goal period will remain one year for this exercise.
Thank you for any help you can give. I tried to chart this on Excel and got very overwhelmed!
rcaseytx
Is there a formula for this that could be used to demonstrate $50 or $100 as well?
Each new supporter is a monthly contributor, so the first ten or so would obviously equate to $300 at the end of a year, correct? ($25*12)
However, as you gain a new supporter every 3 days, the last new supporter would only bring $25 in for that year.
What formula could demonstrate how to express this math, in the simplest format, as well as the most versatile- meaning where the period of days (3) could be set to once a week (7), for instance. The goal period will remain one year for this exercise.
Thank you for any help you can give. I tried to chart this on Excel and got very overwhelmed!
rcaseytx