Question

In: Finance

An online marathon fund raiser continues as long as donations keep coming in. The first hour...

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.?

Solutions

Expert Solution

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


Related Solutions

An online marathon fund raiser continues as long as donations keep coming in. The first hour...
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 4% every hour. Suppose the fundraiser lasts for 121 hours. A) How much will be raised in the last hour? Enter your answer rounded to two decimal places. B)How much will be raised in total? Enter your answer rounded to two decimal places.
first unit of a product took 900 hour to build and learning curve 90%. how long...
first unit of a product took 900 hour to build and learning curve 90%. how long will it take to make the first 3 units
You are considering investing in three different assets. The first is a stock, the second is a long-term government bond and the third is a T-bill money market fund that yields a sure rate of 5%.
You are considering investing in three different assets. The first is a stock, the second is a long-term government bond and the third is a T-bill money market fund that yields a sure rate of 5%. The probability distributions of both the risky assets: Expected Return Standard Deviation Stock (S) er=15% sd=32% Bond (B) er=9% st=23 The correlation between the stock and bond returns is 0.10. A. Compute the expected return and standard deviation of the optimal risky portfolio (aka...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT