Hey Guys whats up, this is my first analysis. I would like to get some feedback on it so give me your thoughts.

Googleโ€™s operations are divided in three categories: Google Services, Google Cloud and so called โ€œOther Betsโ€ consisting of several ventures including A.I., robotics, autonomous driving and pharmacy. As Google Services and Google Cloud generate >99% of Googleโ€™s revenue I wonโ€™t go into much detail on the โ€œOther Betsโ€ Category.

Through itโ€™s acquisition activity google amassed around 250 acquisitions, expanding their research capabilities in fields like A.I., quantum computing and robotics. Below the most important ones are summarized.

Youtube

The most famous one of all Google acquisitions. Purchased in 2006 for 1.65 billion dollars Youtube has risen to world wide success and an unchallenged standing almost as relevant as itโ€™s parent company. With revenues as high as 28,8 billion dollars (2021), it generates over 10% of Googleโ€™s revenue. It has proven to further expand their earnings-power besides ads with itโ€™s Youtube Premium and Music subscription, which according to Alphabet was the major contributer to an increase of $6.3 billion in Googleโ€™s โ€œOther Revenuesโ€ (1).

DoubleClick

DoubleClick was an ad service provider, who worked with advertising agencies and served major brands like Coca-Cola, GM and Microsoft. After itโ€™s acquisition in 2008 for $3.1 billion lots of customer relations and technology was integrated into Googles ad business. In 2018 Google announced itโ€™s plan to rebrand all ad platforms and merged DoubleClick with Googles own ad platform into the new Google Marketing Platform (2).

Motorola Mobility

When Google acquired Motorola in 2011, the company was struggling to gain a foothold in the smartphone business and reported the fifth straight quarter of losses. The company cost $12.5 billion dollar, Googleโ€™s largest acquisition, and was motivated as a strategic move to increase Googleโ€™s patent ownership and defend the Android operating system. After closing the deal Google sold parts of the business to Arris Group for $2.35 billion and led the smartphone division to success through a focus on high-quality entry-level smartphones. In 2014 Google sold Motorola for $2.91 billion, while keeping a major part of the patents. (3)

Mandiant

Google announced that Mandiant would be acquired in March 2022, to get integrated into the Google Cloud division.

Fitbit

Fitbit, a producer of wearable technology was acquired by Google in January 2021 and integrated into itโ€™s hardware division.

Nest Labs

To expand itโ€™s home automation business Google acquired Nest labs in 2014 for ยง3.2 billion and merged it with the Google Home brand in 2018 to create Google Nest.

Advertising

Through itโ€™s search engine and Youtube, Google generates significant revenue with advertisment campaigns for itโ€™s customers. It is unchallenged with a market share of 92% for itโ€™s search engine and Google Chrome leading the browser market with 65% (4). Competition in itโ€™s most relevant business is almost irrelevant for itโ€™s earnings power and market position as most major players (Microsoft with Bing, Yahoo) have failed to attack it.

Google Cloud

In the highly competitive cloud computing industry Google competes with giants like Microsoft, Alibaba and Amazon. It isnโ€™t in a leading position, but increased itโ€™s market share from 5% (2017) to 10% (2021) with only AWS and Microsoft Azure above. (5) (6)

Googleโ€™s revenue has increased by an average of 21% annually in the last 10 years. With Growth accelerating in the past 5 years (23,3%), the question should be if similar growth can be expected in the future.

Googleโ€™s main business of advertising stands as strong as we have discussed above and with more digitilization and e-commerce growth not slowing down the market for itโ€™s search engine and itโ€™s ads will continue to grow. Growth projections in that business reach from 11% to 15%. (8) (9)

As Google Cloud has gained more market share in the last years and has grown itโ€™s revenue by more than 40% on average, itโ€™s safe to say that it will grow at least as much as the overall cloud computing industry if not more. In a recent market research report a Compound Annual Growth Rate (CAGR) of over 16% was forecasted until 2026. We will take that at face value for our worst case scenario and will add to it as in a best case scenario, Google will gain more market share. (10)

Costs as a Percentage of Revenue (Table 1)

Cost Development as a Percentage of Revenue (Table 2)

Cost Development in general (Table 3)

In recent history Google was able to decrease different parts of itโ€™s costs effectively, thus increasing profitablility. Cost of revenue is made up of ****traffic acquisition costs (TAC) and other revenue costs. TAC consists of payments made to traffic distributors, giving Google the platform and audience to advertise for itโ€™s clients.

Other revenue costs consist of licensing fees for acquired content sold on YouTube and Google Play, expenses in itโ€™s data centers and costs related to Googleโ€™s hardware business.

Composition of cost of revenue (COR) (Table 4)

With past cost development itโ€™s important to use the studied data to make forecasts into the future regarding revenue, cost and profit development to feed our DCF model. We will look for patterns in which relation costs follow growing revenue. With the following table I will try to point that out.

The cost of revenue has trailed revenue quite close and I expect it to continue to be around 40-43% of all revenue. R&D expenses have risen with revenue but have slown down in recent years. Itโ€™s not attached to revenue growth directly, but we will assume a small average growth of 10% for the upcoming years as the R&D expenses are already high enough to guarantee Google to be a potential player in all upcoming high-tech industries. Further reductions in the SGA expenses relative to revenue is possible with revenue outpacing those costs, as it has been seen in the past. Still we will assume it too be just stable to have a more conservative approach.

Googleโ€™s long term debt is almost non-existing with $15 billion. Itโ€™s earnings were >$70 billion in 2021 so itโ€™s debt could have been paid off with just 20% of that. The company also holdโ€™s $21 billion in cash, which makes debt for the valuation almost irrelevant.

As Googleโ€™s business needs large amounts of land, offices and server infrastructure. Aside from large marketable securities positions, most capital is tied up in purchased land, offices and information technology assets like server farms. The company is determined to expand itโ€™s position in that area, which will result in rising capital expenditures for both new offices and new IT assets. (1)

To calculate the Tangible Book Value I will use the most recent book value and exclude all assets I think are intangible. TBV calculation in $billion:

Note: I didnโ€™t exclude smaller positions as it would make the formular unnecessarilly large with no real effect. Itโ€™s also quite reasonable as normally the Property and Equipment of Google of cause could be sold for at least a fraction of the audited value.

Google has a TBV per share of: $120998 million / 673.22 million shares = $179,73 per share

IT assets generally have a high turnover frequence which results in short depreciating periods (4-5 years). The replacement makes up a large portion of the $24.6 billion of capital expenditures, which are needed for the business operation.

Still Google has great liquidity through itโ€™s short-term marketable securities and itโ€™s large cash reserves.

With almost over $60 billion dollar of free cashflow, Google used most of it ($50 billion) to make stock repurchases. Still the company has only really started to do repurchases in the last 4-5 years and because of itโ€™s high valuation the amount of shares outstanding has only decreased by 5% in 3 years, which is quite a disappointment (11). $15 billion were paid in stock compensation and to account for that we wonโ€™t add it back into the DCF-valuation even though itโ€™s a non-cash expense.

Insider Trading has no significance for Google as high management only sold insignificant portions of their ownership. (12)

The founders Larry Page and Sergey Brin still have small stakes in the company of around 3% each, even though they slowly continue to sell them off. There is also no insider with a significant stake in the company. (12)

• Lower advertising spending by customers

• Googleโ€™s value for itโ€™s customers could decline

• Competition disrupting the occupied markets

Summary of the Assumptions made:

• The revenue of Google Services will increase with the projected growth of the overall market of 11%-15%, which is conservative as parts like Youtube are growing at much higher rates

• Google Cloudโ€™s revenue has increased at an annual growth rate of over 40%. In a worst case scenario it will grow at a CAGR of 16% in line with itโ€™s industry projection, but there is a real possibility of it to accelerate at the current rate until it has gained enough size. Our worst, base and best case projection will still stay conservative at 16%-24$

• As COR is staying volatile around 45% of revenue we will assume it to stay at that level

• R&D will rise around 10% every year unrelated to revenues

• SGA (sales, general, administration) expenses will stay at the current level of 14% relative to revenues and wonโ€™t decrease any further

• capital expenses have remained quite stable at around $24 billion dollars. We will still assume an increase of 10% per year as in the most recent 10-Q report the capex has risen by over 40%.

• Depreciation rises at CapEx rate

• 2021 is not an outlier

• Share repurchases will range between 2-5% per year, as those are highly dependent on the share price

We will use a projection of the next 15 years to determine Googleโ€™s fair value in 3 scenarios at a discount rate of 8%

I would consider te base case to be highly plausible as past growth has indicated much higher growth rates. Of course itโ€™s up to you to choose your margin of safety, but I will consider to pick up some shares if Google falls below $2000.