A museum is embarking on a five-year fundraising campaign.
As a nonprofit institution, the museum finds it challenging to acquire new donors, as many donors do not contribute every year.
Suppose that the museum has identified a pool of 8,000 potential donors.
The actual number of donors in the first year of the campaign is estimated to be 60% of this pool.
For each subsequent year, the museum expects that 30% of the current donors will discontinue their contributions.
In addition, the museum expects to attract some percentage of new donors. This is assumed to be 10% of the pool.
The average contribution in the first year is assumed to be $50 and will increase at a rate of 2.5%.
Develop a model to predict the total funds that will be raised over the five-year period.
Use data tables to investigate the impacts of first year percentage assumption used in the model on the cumulative funds raised by the fifth year.
Donor pool	8000
First year percentage	60%
Annual percentage leaving	30%
Annual percentage new	10%
Annual contribution increase	2.5%
Year	1	2	3	4	5
Number of donors	4800
Average contribution	$800
Total donation	$5,600
Cumulative funds raised	$3,840,000
		Cumulative $
		$0
First year percentage	60%
	61%
	62%
	63%
	64%
	65%
	66%
	67%
	68%
	69%
	70%