Alphabet Inc
NASDAQ:GOOGL
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
129.2
USD.
Compared to the current market price of 156 USD, the stock is
Overvalued by 17%.
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
Switching the operating model will discard any changes made to the current valuation.
You already have a valuation model for Alphabet Inc.
Do you want to replace it with the current valuation model?
Do you really want to delete your valuation model? This operation cannot be undone.
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.6B |
| GOOGL DCF Value | 129.2 USD |
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
DCF Model Author
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.
You don't have any saved screeners yet
