Alphabet Inc
NASDAQ:GOOGL

Watchlist Manager
Alphabet Inc Logo
Alphabet Inc
NASDAQ:GOOGL
Watchlist
Price: 167.63 USD -4.74% Market Closed
Market Cap: 2.1T USD
Have any thoughts about
Alphabet Inc?
Write Note

DCF Value

This DCF valuation model was created by Thijs Nijenhuis (View User Profile) and was last updated on Jul 10, 2023.

Estimated DCF Value of one GOOGL stock is 132.26 USD. Compared to the current market price of 167.63 USD, the stock is Overvalued by 21%.

GOOGL DCF Value
Base Case
132.26 USD
Overvaluation 21%
DCF Value
Price
132.26
DCF Value
Hide
DCF Value: 132.26 USD

Present Value Calculation

This block is the starting point of the DCF valuation process. It calculates the present value of a company's forecasted cash flows based on selected operating model. Adjust key parameters like discount rate and terminal growth, and alter inputs such as revenue growth and margins to see their impact on valuation.

DCF Model
Base Case Scenario

The present value of cash flows over the next 5 years amounts to 315.4B USD. The present value of the terminal value is 1.2T USD. The total present value equals 1.5T USD.
Forecast Period
Years
Discount Rate
%
Show All DCF Settings
Terminal Growth
%
Hide DCF Settings
Save

DCF Value Calculation

This stage translates the present value into DCF value per share. For firm valuation models, it adjusts present value for debt and assets to derive equity value (skipped if using equity valuation model). Finally, this equity value is divided by the number of shares to determine the DCF value per share.

Present Value to DCF Value
Capital Structure

Present Value 1.5T USD
+ Cash & Equivalents 25.9B USD
+ Investments 120.4B USD
Firm Value 1.6T USD
- Debt 13.7B USD
Equity Value 1.6T USD
/ Shares Outstanding 12.3B
GOOGL DCF Value 132.26 USD
Overvalued by 21%

Valuation Analysis

Sensitivity Analysis
DCF Value Sensitivity Analysis

Sensitivity Analysis assesses how changes in key factors like revenue growth, margin, and discount rate affect a stock's DCF value. By visualizing various scenarios, from significant downturns to optimistic growth, this tool helps you understand potential valuation shifts, aiding in risk assessment and strategic decision-making.

DCF Financials
Financials used in DCF Calculation

Revenue
319B 562B
Operating Income
76.6B 134.9B
FCFF
65.6B 114.9B

See Also

Discover More

DCF Model Author

Thijs Nijenhuis
Member since: Feb, 2022

My goal is to buy phenomenal businesses at phenomenal prices. I try to identify strong companies and buy them at depressed valuations. Once I buy a company I stick with it for as long as possible.

//