Calculate giving over time based on consistent growth pattern

[thatbradguy]

I am trying to project giving for a new church start. I have the following variables.

Beginning Attendance (Week 1)
Attendance at End of Year 1 (Week 52)
Giving Per Person Per Week

Assuming a consistent attendance growth pattern between Week 1 and Week 52 (end of year 1), how can I calculate total giving for Year 1?

[Nisha Dhawan]

Can you please upload the attachment for better understanding?

Also, what do you mean by "Giving Per Person Per Week" and what is the placement of your data and what your data is covering?

[shg]

Row\Col	A	B	C
1	Week	Attendance
2	1	10	A2:B3: Input
3	52	500
4	Ratio	107.97%	B4: =(B3/B2) ^ (1 / (A3-A2))
5
6	Per Person	$ 20.00
7	Total	$ 132,922.62	B7: =B6 * B2 * (1 - B4^A3)/(1 - B4)

[thatbradguy]

File is below.

Giving per person per week is how many dollars each person in attendance gives to the church per week. It's an average based on statistics gathered in the area the church is going to be started. So if the average is $15 and 100 people show up, the church could expect to be given $1500.

Thanks!

giving.xlsx

[Nisha Dhawan]

Please refer to the attach file. It seems as you just want to do the multiplication. So in C4 type =C2*C3 and then drag it to right.

Please confirm if this help you.

[thatbradguy]

That did it. Thanks!

Row\Col	A	B	C
1	Week	Attendance
2	1	10	A2:B3: Input
3	52	500
4	Ratio	107.97%	B4: =(B3/B2) ^ (1 / (A3-A2))
5
6	Per Person	$ 20.00
7	Total	$ 132,922.62	B7: =B6 * B2 * (1 - B4^A3)/(1 - B4)

[shg]

You're welcome.

[Nisha Dhawan]

If you have got your answer, kindly take few seconds to mark this thread SOLVED.