In: Finance
An online marathon fund raiser continues as long as donations keep coming in. The first hour costs $1.00, and then the cost per hour goes up by 8% every hour. Suppose the fundraiser lasts for 126 hours.
How much will be raised in the last hour? Enter your answer rounded to two decimal places.?
How much will be raised in total? Enter your answer rounded to two decimal places.?
Hi
Pls see below excel formula and values:
growth rate | 0.08 | |
hour | Amount | |
1 | 1 | |
2 | =C4*(1+$B$1) | |
3 | =C5*(1+$B$1) | |
4 | =C6*(1+$B$1) | |
5 | =C7*(1+$B$1) | |
6 | =C8*(1+$B$1) | |
7 | =C9*(1+$B$1) | |
8 | =C10*(1+$B$1) | |
9 | =C11*(1+$B$1) | |
10 | =C12*(1+$B$1) | |
11 | =C13*(1+$B$1) | |
12 | =C14*(1+$B$1) | |
13 | =C15*(1+$B$1) | |
14 | =C16*(1+$B$1) | |
15 | =C17*(1+$B$1) | |
16 | =C18*(1+$B$1) | |
17 | =C19*(1+$B$1) | |
18 | =C20*(1+$B$1) | |
19 | =C21*(1+$B$1) | |
20 | =C22*(1+$B$1) | |
21 | =C23*(1+$B$1) | |
22 | =C24*(1+$B$1) | |
23 | =C25*(1+$B$1) | |
24 | =C26*(1+$B$1) | |
25 | =C27*(1+$B$1) | |
26 | =C28*(1+$B$1) | |
27 | =C29*(1+$B$1) | |
28 | =C30*(1+$B$1) | |
29 | =C31*(1+$B$1) | |
30 | =C32*(1+$B$1) | |
31 | =C33*(1+$B$1) | |
32 | =C34*(1+$B$1) | |
33 | =C35*(1+$B$1) | |
34 | =C36*(1+$B$1) | |
35 | =C37*(1+$B$1) | |
36 | =C38*(1+$B$1) | |
37 | =C39*(1+$B$1) | |
38 | =C40*(1+$B$1) | |
39 | =C41*(1+$B$1) | |
40 | =C42*(1+$B$1) | |
41 | =C43*(1+$B$1) | |
42 | =C44*(1+$B$1) | |
43 | =C45*(1+$B$1) | |
44 | =C46*(1+$B$1) | |
45 | =C47*(1+$B$1) | |
46 | =C48*(1+$B$1) | |
47 | =C49*(1+$B$1) | |
48 | =C50*(1+$B$1) | |
49 | =C51*(1+$B$1) | |
50 | =C52*(1+$B$1) | |
51 | =C53*(1+$B$1) | |
52 | =C54*(1+$B$1) | |
53 | =C55*(1+$B$1) | |
54 | =C56*(1+$B$1) | |
55 | =C57*(1+$B$1) | |
56 | =C58*(1+$B$1) | |
57 | =C59*(1+$B$1) | |
58 | =C60*(1+$B$1) | |
59 | =C61*(1+$B$1) | |
60 | =C62*(1+$B$1) | |
61 | =C63*(1+$B$1) | |
62 | =C64*(1+$B$1) | |
63 | =C65*(1+$B$1) | |
64 | =C66*(1+$B$1) | |
65 | =C67*(1+$B$1) | |
66 | =C68*(1+$B$1) | |
67 | =C69*(1+$B$1) | |
68 | =C70*(1+$B$1) | |
69 | =C71*(1+$B$1) | |
70 | =C72*(1+$B$1) | |
71 | =C73*(1+$B$1) | |
72 | =C74*(1+$B$1) | |
73 | =C75*(1+$B$1) | |
74 | =C76*(1+$B$1) | |
75 | =C77*(1+$B$1) | |
76 | =C78*(1+$B$1) | |
77 | =C79*(1+$B$1) | |
78 | =C80*(1+$B$1) | |
79 | =C81*(1+$B$1) | |
80 | =C82*(1+$B$1) | |
81 | =C83*(1+$B$1) | |
82 | =C84*(1+$B$1) | |
83 | =C85*(1+$B$1) | |
84 | =C86*(1+$B$1) | |
85 | =C87*(1+$B$1) | |
86 | =C88*(1+$B$1) | |
87 | =C89*(1+$B$1) | |
88 | =C90*(1+$B$1) | |
89 | =C91*(1+$B$1) | |
90 | =C92*(1+$B$1) | |
91 | =C93*(1+$B$1) | |
92 | =C94*(1+$B$1) | |
93 | =C95*(1+$B$1) | |
94 | =C96*(1+$B$1) | |
95 | =C97*(1+$B$1) | |
96 | =C98*(1+$B$1) | |
97 | =C99*(1+$B$1) | |
98 | =C100*(1+$B$1) | |
99 | =C101*(1+$B$1) | |
100 | =C102*(1+$B$1) | |
101 | =C103*(1+$B$1) | |
102 | =C104*(1+$B$1) | |
103 | =C105*(1+$B$1) | |
104 | =C106*(1+$B$1) | |
105 | =C107*(1+$B$1) | |
106 | =C108*(1+$B$1) | |
107 | =C109*(1+$B$1) | |
108 | =C110*(1+$B$1) | |
109 | =C111*(1+$B$1) | |
110 | =C112*(1+$B$1) | |
111 | =C113*(1+$B$1) | |
112 | =C114*(1+$B$1) | |
113 | =C115*(1+$B$1) | |
114 | =C116*(1+$B$1) | |
115 | =C117*(1+$B$1) | |
116 | =C118*(1+$B$1) | |
117 | =C119*(1+$B$1) | |
118 | =C120*(1+$B$1) | |
119 | =C121*(1+$B$1) | |
120 | =C122*(1+$B$1) | |
121 | =C123*(1+$B$1) | |
122 | =C124*(1+$B$1) | |
123 | =C125*(1+$B$1) | |
124 | =C126*(1+$B$1) | |
125 | =C127*(1+$B$1) | |
126 | =C128*(1+$B$1) | |
Raised in last hour | =C129 | |
Total raise | =SUM(C4:C129) |
Values are below:
Hence Raised in last hour = $15,065.01
Total raise = $203,365.14
Thanks