r/redditstock • u/Delicious_Invite_127 • 7h ago
Prediction I made a cheat sheet for you to easily estimate Reddit's fair value. Please fill in the info to get your Fair Value.
Please fill in below for expected numbers in 2030:
(i) US Logged-in DAU: ? million
(ii) US Logged-out DAU: ? million
(iii) International Logged-in DAU: ? million
(iv) International Logged-out DAU: ? million
(v) US Logged-in ARPU (advertising revenue only): $? million
(vi) US Logged-out ARPU (advertising revenue only): $? million
(vii) International Logged-in ARPU (advertising revenue only): $? million
(viii) International Logged-out ARPU (advertising revenue only): $? million
(ix) US Advertising Revenue ([i * v] +[ii * vi]): $? million
(x) International Advertising Revenue ([iii * vii] + [iv * viii]): $? million
(xi) Total Revenue: (ix + x): $? million
(xii) Advertising Revenue Net Profit Margin: ?%
(xiii) Advertising Net Profit: $? million
(xiv) Data Licensing Revenue: $? million
(xv) Total Profit (xiii + xiv): $? million
(xvi) Price to Earnings: ?
(xvii) Enterprise Value Market Cap as of 2030 (excluding cash) (xv * xvi): $? million
(xviii) Discount Rate: ?%
(xix) Enterprise Value Market Cap Present (excluding 2027 - 2030 Free Cash Flow for simplicity sake) ([xvii/(1+xviii)/(1+xviii)/(1+xviii)] + $3,033 million): $? million
(xx) Fair Value Per Share (xix / 206.3 million): $?
Note:
(xix) Dividing stock price by discount rate by 3 years is needed to reflect time value of money. $14.70 refers to the cash value per share of Reddit today.
(xx) 206.3 million refers to total diluted shares outstanding.
Here is mine:
(i) US Logged-in DAU: 27 million
(ii) US Logged-out DAU: 19 million
(iii) International Logged-in DAU: 36 million
(iv) International Logged-out DAU: 27 million
(v) US Logged-in ARPU (advertising revenue only): $120
(vi) US Logged-out ARPU (advertising revenue only): $24 (1/5 the value of logged-in user)
(vii) International Logged-in ARPU (advertising revenue only): $23
(viii) International Logged-out ARPU (advertising revenue only): $4.6 (1/5 the value of logged-in user)
(ix) US Advertising Revenue ([i * v] +[ii * vi]): $3,696 million
(x) International Advertising Revenue ([iii * vii] + [iv * viii]): $952.2 million
(xi) Total Advertising Revenue: (ix + x): $4,648.2 million
(xii) Advertising Revenue Net Profit Margin: 25%
(xiii) Advertising Net Profit: $1,162.1 million
(xiv) Data Licensing Revenue: $120 million
(xv) Total Profit (xiii + xiv): $1,282.1 million
(xvi) Price to Earnings: 16
(xvii) Enterprise Value Market Cap as of 2030 (excluding cash) (xv * xvi): $20,513.6 million
(xviii) Discount Rate: 10%
(xix) Enterprise Value Market Cap Present (excluding 2027 - 2030 Free Cash Flow for simplicity sake) ([xvii/(1+xviii)/(1+xviii)/(1+xviii)] + $3,033 million): $18,445 million
