Compute Value per user (Ad Revenue) to compare Facebook, Twitter, and Pandora

Facebook Number of Monthly Active END VALUE CAGR = Users in USA Canada (Millions INITIAL VALUE - 1 Note that n corresponds to the number of time periods, which equals 40 in the Facebook time serie MAUS Ad F =((B46/B6)^(1/40)-1) 1.68% Q1 '10 130 209 Q2 '10 137 243 Q3 '10 144 260 Q4 '10 154 359 Q1 '11 163 332 Q2 11 169 394 Q3 '11 176 395 Q4 '11 179 462 Q1 '12 183 419 Q2 '12 186 479 Q3 '12 189 538 Q4 '12 193 631 Q1 '13 195 552 Q2 '13 198 721 Q3 '13 199 832 Q4 '13 201 1,068 Annual Ad revenues Q1 14 202 ,039 Q2 '14 204 1,175 Q3 14 206 1,362 Q4 '14 208 1,709 2014 5,285 =SUM(C22:C25) Q1 '15 210 1,592 Q2 15 213 1,826 Q3 '15 217 2, 120 Q4 '15 219 2.847 2015 8,385 Q1 16 222 2,615 Q2 16 226 3,077 Q3 16 229 3,431 Q4 16 231 4,435 2016 13,558 Q1'17 234 3,851 Q2 '17 236 4,450 Q3 '17 239 4,912 Q4 '17 239 6,271 2017 19,484 Q1 '18 241 5,559 Q2 '18 241 6,137 Q3 '18 242 6.547 Q4 '18 242 8,246 2018 26,489 Q1 19 243 7,203 Q2 '19 244 7,952 Q3 '19 247 8,317 Q4 '19 248 10,021 2019 33,493 Q1 '20 253 8,379 Value per u =SUM(C42:C45)/(AVERAGE(B42:B45)) = $ 136.43 Advertising Revenues Value per user = Number of Active Users\fTwitter: number of monthly active U.S. users 2010-2019 (millions) Year Ad Revenues (in million US Period MAUs Q1 '10 10 2012 270 12 2013 590 Q2 '10 Q3 '10 14 2014 1250 2015 1990 Q4 '10 15 2016 2250 Q1 '11 19 2110 Q2 '11 23 2017 Q3 '11 27 2018 2620 30 2019 2990 Q4 '11 Q1 '12 34 Q2 '12 Q3 '12 40 Q4 '12 45 Q1 '13 48 Q2 '13 Q3 '13 Q4 '13 Q1 '14 Q2 '14 Q3 '14 63 Q4 '14 63 Q1 '15 65 Q2 '15 65 Q3 '15 66 Q4 '15 65 Q1 '16 65 Q2 '16 66 Q3 '16 67 Q4 '16 67 Q1 '17 69 Q2 '17 68 Q3 '17 69 Q4 '17 68 Q1 '18 69 Q2 '18 68 Q3 '18 67 Q4 '18 66 68 Q1 '19The value of a user on a digital platform (in terms of ad revenue potential) is a metric that seeks to capture the revenue generated by the average user from ads served by the platform to its user base. More formally, this may be defined as Advertising Revenues Value per user = Number of Active Users For Facebook in 2019, the metric is computed by summing the revenues for 2019 and dividing by the average number of users in 2019. The result has been embedded in cell C48 in Value per user.xIsx. You will need to compute the value per user for the years 2014-2018 for Facebook (since I have already computed Facebook 2019 for you) and years 2014 to 2019 for Twitter and Pandora. Note that the value per user computed using the above formula will be lower than the value per user generated by using the market capitalization in the numerator (as financial analysts often do). However, value per user (Ad revenue) is a more robust metric for digital marketers as it provides a direct measure of a marketing related outcome that can be used to benchmark the platform's marketing efficacy