Twitter simulation
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, 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, 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.
