Difference between revisions of "Twitter simulation"
| (12 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
==Method== | ==Method== | ||
The simulation was done using Monte Carlo simulation in Microsoft Excel. | The simulation was done using Monte Carlo simulation in Microsoft Excel. | ||
| − | |||
==Simulation== | ==Simulation== | ||
| Line 16: | Line 15: | ||
The goal was to see whether the Twitter Inc. acquisition was a smart view from a financial point of view and whether the money would have been better invested elsewhere (in this case the S&P500 index). The goal was to see the potential financial outcome in 10 years. | The goal was to see whether the Twitter Inc. acquisition was a smart view from a financial point of view and whether the money would have been better invested elsewhere (in this case the S&P500 index). The goal was to see the potential financial outcome in 10 years. | ||
| + | |||
| + | Although the data doesn't precisely follow one specific distribution (there are some outliers), based on the plotted graphs the normal distribution was chosen for the simulations as it's probably the distribution the data follows the closest. | ||
| + | |||
| + | In the first picture below there is a distribution of Twitter's historical annual market cap changes data. | ||
| + | |||
| + | [[File:Distmc.png|Distribution of Twitter's historical annual market cap changes data|center|500px|]] | ||
| + | |||
| + | |||
| + | |||
| + | In the second picture below there is a distribution of S&P500 historical annual return changes data. | ||
| + | |||
| + | [[File:Distsap500.png|Distribution of S&P500 historical annual return changes data|center|500px|]] | ||
| + | |||
| + | |||
| + | In the third picture below there is a distribution of Twitter's historical quarterly (which were later converted to annual) net income changes data. | ||
| + | |||
| + | [[File:Distnet.png|Distribution of Twitter's historical quarterly net income changes data|center|500px|]] | ||
==Results== | ==Results== | ||
| − | The results for | + | The predicted results after 1 000 simulations for an initial investment of 44 billion USD (=44 000 million USD) – average expected value in 10 years, probability of loss and minimum and maximum amounts in the simulations are listed in the table below: |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | {| class="wikitable" style="margin: auto;" | |
| − | + | |+Simulation results in millions of USD | |
| + | |- | ||
| + | | | ||
| + | |'''Average expected value in 10 years''' | ||
| + | |'''Probability of loss''' | ||
| + | |'''Minimum''' | ||
| + | |'''Maximum''' | ||
| + | |- | ||
| + | |'''Market cap average:''' | ||
| + | |86 923.06 | ||
| + | |49 % | ||
| + | | -12 700.8 | ||
| + | |1 281 106.151 | ||
| + | |- | ||
| + | |'''Market cap optimistic:''' | ||
| + | |169 577.94 | ||
| + | |24 % | ||
| + | | -36 321.44 | ||
| + | |1 496 161.85 | ||
| + | |- | ||
| + | |'''Market cap pessimistic:''' | ||
| + | |73 604.68 | ||
| + | |55 % | ||
| + | | -17 152.81 | ||
| + | |1 366 368.4 | ||
| + | |- | ||
| + | |'''S&P500 average:''' | ||
| + | |137 769.6 | ||
| + | |6 % | ||
| + | |13 397.54 | ||
| + | |696 587.11 | ||
| + | |} | ||
| + | |||
| Line 39: | Line 82: | ||
S&P500 has a low probability of loss (being worse off than the initial investment) and the expected profits are better than in case of Twitter Inc. The new owner would have to basically double the market cap change up to now to outperform S&P500 but on the other hand there is a higher chance of loss since the company simply has not been around long enough to have enough historical data to make assumptions from. | S&P500 has a low probability of loss (being worse off than the initial investment) and the expected profits are better than in case of Twitter Inc. The new owner would have to basically double the market cap change up to now to outperform S&P500 but on the other hand there is a higher chance of loss since the company simply has not been around long enough to have enough historical data to make assumptions from. | ||
| + | |||
| + | Even if we look at the simulation of a predicted net income (starting at 0 USD) in 10 years based on 2 000 simulations: | ||
| + | {| class="wikitable" style="margin: auto;" | ||
| + | |+Simulation results in millions of USD | ||
| + | |- | ||
| + | | | ||
| + | |'''Average expected value in 10 years''' | ||
| + | |'''Probability of loss''' | ||
| + | |'''Minimum''' | ||
| + | |'''Maximum''' | ||
| + | |- | ||
| + | |'''Net income average:''' | ||
| + | | -934.94 | ||
| + | |65 % | ||
| + | | -9 342.42 | ||
| + | |7 224.95 | ||
| + | |} | ||
| + | |||
| + | We can see that there is a high chance that Twitter will suffer a net loss in 10 years (as it has been pretty much consistently since its inception). | ||
Looking at recent information about new changes in the company like laying off a lot of employees, new Twitter subscription possibilities etc., it's obvious that the new owner is trying hard to end this trend and make the company start earning money. | Looking at recent information about new changes in the company like laying off a lot of employees, new Twitter subscription possibilities etc., it's obvious that the new owner is trying hard to end this trend and make the company start earning money. | ||
| − | == | + | |
| + | ==Bibliography== | ||
| + | BRANDOM, Russell, 2022. Why Elon Musk is so desperate for Twitter to make money. The Verge [online] [seen 2023-01-19]. Available from: https://www.theverge.com/2022/11/2/23437120/elon-musk-twitter-product-subscription-verification-revenue-debt-finance | ||
| + | |||
| + | COMPANIESMARKETCAP, 2023. Twitter (TWTR) - Market capitalization [online] [seen 2023-01-16]. Available from: https://companiesmarketcap.com/twitter/marketcap/ | ||
| + | |||
| + | SLICKCHARTS, 2023. S&P 500 Total Returns by Year Since 1926 [online] [seen 2023-01-18]. Available from: https://www.slickcharts.com/sp500/returns | ||
| + | |||
| + | STATISTA, 2022a. Twitter: quarterly net income 2022. Statista [online] [seen 2023-01-17]. Available from: https://www.statista.com/statistics/299119/twitter-net-income-quarterly/ | ||
| + | |||
| + | STATISTA, 2022b. Twitter quarterly revenue 2022. Statista [online] [seen 2023-01-17]. Available from: https://www.statista.com/statistics/274568/quarterly-revenue-of-twitter/ | ||
| + | |||
| + | TWITTER INC., 2023. Twitter, Inc. - Financial information [online] [seen 2022-12-15]. Available from: https://investor.twitterinc.com/financial-information/default.aspx | ||
| + | |||
==Code== | ==Code== | ||
| + | The Excel file: [[File:TwitterMonteCarlo.xlsx]] | ||
Latest revision as of 09:10, 23 January 2023
Introduction
Twitter Inc. has been recently sold for $44 billion. There has been information going around which says that the new owner basically had to buy the company due to potential legal issues which raises question whether the company is profitable enough.
The goal of this simulation was to determine whether the purchase of this company has been wise from the financial point of view.
Method
The simulation was done using Monte Carlo simulation in Microsoft Excel.
Simulation
Input data from the simulation were obtained from Twitter's official earning results and other popular websites. After the data were obtained, necessary information was calculated (distribution, average annual return/net income/net loss, standard deviation). Since Twitter was founded in 2006 and the earliest verifiable data were from 2012, there is obviously a bigger uncertainty compared to S&P500 (mentioned later) which has been around for more than a century.
Twitter's historical market cap changes have been used as according to sources market cap is commonly used to determine a company's worth. There are 3 possible market cap changes simulated – average (based on historical data), optimistic (double the average annual return to see a possible outcome in case the company is able to miraculously perform way better) and pessimistic (a little less than average annual return in case the company is doing even worse). Historical quarterly net income and loss have also been simulated just to see in more detail how the company is doing.
The expected profits were compared to S&P500 which is a popular stock market index tracking performance of 500 publicly traded large US companies and a popular investment option. Just like with Twitter Inc., average annual return and standard deviation were calculated based on historical data.
The goal was to see whether the Twitter Inc. acquisition was a smart view from a financial point of view and whether the money would have been better invested elsewhere (in this case the S&P500 index). The goal was to see the potential financial outcome in 10 years.
Although the data doesn't precisely follow one specific distribution (there are some outliers), based on the plotted graphs the normal distribution was chosen for the simulations as it's probably the distribution the data follows the closest.
In the first picture below there is a distribution of Twitter's historical annual market cap changes data.
In the second picture below there is a distribution of S&P500 historical annual return changes data.
In the third picture below there is a distribution of Twitter's historical quarterly (which were later converted to annual) net income changes data.
Results
The predicted results after 1 000 simulations for an initial investment of 44 billion USD (=44 000 million USD) – average expected value in 10 years, probability of loss and minimum and maximum amounts in the simulations are listed in the table below:
| Average expected value in 10 years | Probability of loss | Minimum | Maximum | |
| Market cap average: | 86 923.06 | 49 % | -12 700.8 | 1 281 106.151 |
| Market cap optimistic: | 169 577.94 | 24 % | -36 321.44 | 1 496 161.85 |
| Market cap pessimistic: | 73 604.68 | 55 % | -17 152.81 | 1 366 368.4 |
| S&P500 average: | 137 769.6 | 6 % | 13 397.54 | 696 587.11 |
Conclusion
At least from a financial point of view it seems that Twitter has not been a very smart investment. Based on historical data, Twitter Inc. has hardly ever been profitable and even looking at the simulations, it seems very likely that the company will not be making money unless changes are made and compared to the S&P500 stock market index, the changes would have to be very positive to outperform the index.
Even in the optimistic case, there is a pretty high probability being worse off than keeping the money (predicted value below the initial investment). The average and pessimistic cases are essentially a coin toss when it comes to being worse or better off + they perform noticeably worse than S&P500.
S&P500 has a low probability of loss (being worse off than the initial investment) and the expected profits are better than in case of Twitter Inc. The new owner would have to basically double the market cap change up to now to outperform S&P500 but on the other hand there is a higher chance of loss since the company simply has not been around long enough to have enough historical data to make assumptions from.
Even if we look at the simulation of a predicted net income (starting at 0 USD) in 10 years based on 2 000 simulations:
| Average expected value in 10 years | Probability of loss | Minimum | Maximum | |
| Net income average: | -934.94 | 65 % | -9 342.42 | 7 224.95 |
We can see that there is a high chance that Twitter will suffer a net loss in 10 years (as it has been pretty much consistently since its inception).
Looking at recent information about new changes in the company like laying off a lot of employees, new Twitter subscription possibilities etc., it's obvious that the new owner is trying hard to end this trend and make the company start earning money.
Bibliography
BRANDOM, Russell, 2022. Why Elon Musk is so desperate for Twitter to make money. The Verge [online] [seen 2023-01-19]. Available from: https://www.theverge.com/2022/11/2/23437120/elon-musk-twitter-product-subscription-verification-revenue-debt-finance
COMPANIESMARKETCAP, 2023. Twitter (TWTR) - Market capitalization [online] [seen 2023-01-16]. Available from: https://companiesmarketcap.com/twitter/marketcap/
SLICKCHARTS, 2023. S&P 500 Total Returns by Year Since 1926 [online] [seen 2023-01-18]. Available from: https://www.slickcharts.com/sp500/returns
STATISTA, 2022a. Twitter: quarterly net income 2022. Statista [online] [seen 2023-01-17]. Available from: https://www.statista.com/statistics/299119/twitter-net-income-quarterly/
STATISTA, 2022b. Twitter quarterly revenue 2022. Statista [online] [seen 2023-01-17]. Available from: https://www.statista.com/statistics/274568/quarterly-revenue-of-twitter/
TWITTER INC., 2023. Twitter, Inc. - Financial information [online] [seen 2022-12-15]. Available from: https://investor.twitterinc.com/financial-information/default.aspx
Code
The Excel file: File:TwitterMonteCarlo.xlsx
