Discounted Cash Flow (DCF) Calculator for Alphabet Inc. (GOOG)

DCF Analysis that automates a lot of the process and allows for real time sensitivity changes.


A discounted cash flow analysis (DCF) is one of the most widely used methods of calculating the intrinsic value of a business. This often involves spreadsheets that aren't the easiest to use, having to look at multiple places to find the data, or online calculators that over simplify the process by simply adding a multiplier to previous free cash flows.

That is why I created this calculutor, which shows you the last 5 years of data (green section below, you can hide/show it by the click of a button) , allows you to quickly and easily change specific variables, and finally shows you the entire picture on what your chosen variables mean for the company. It calculates the intrinsic value per share (based on your inputs), as well as shows you a table (yellow section below) that show what your growth rates mean in terms of future revenue/earnings over the next 10 years for the company. This allows you to quickly do a sensitivity analysis, as well as make sure the numbers make sense for the sector your company is in.

We are working on a guide on how to do a discounted cash flow calculation with this calculator: DCF Guide. Alternatively you can check one of my many personal valuations, where I breakdown how I personally value companies using this calculator.

I have based this off Professor Aswath Damodaran's teachings, with some slight modifications. Aswath Damodaran is a professor at Stern School of Business at New York University. He is known as the 'dean of valuation'. I would highly recommend reading some of his books on valuation if you haven't yet. I have suggested a few of my favourites below.


Please enter the stock ticker. Add .to for Canadian stocks.



Alphabet Inc. - GOOG - $166.57


Reported Currency: USD
Sector: Internet Content & Information
Industry: Software (Entertainment)
Current Market Cap: $2,030,478,306,966
Industry Avg Sales To Capital: 0.80
Industry Avg Cost of Capital: 6.54%
Beta: 1.034
Industry Avg Operating Margin: 31.12%

Your Variables

To unlock all sliders START A FREE TRIAL.
Revenue Growth Year 1
Revenue Growth Year 2-5
Revenue Growth Perpetuity
Operating Margin Year 1
Operating Margin Target
Year of Convergence
Tax Rate Year 1
Marginal Tax Rate
Sales to Capital Year 1
Sales to Capital Years 2-5
Sales to Capital Years 6-10
Cost of Capital Year 1 / Discount Rate
Cost of Capital Year 10 / Discount Rate
Yes No

Output (Next 10 Years)


Terminal Cash Flow: $
Terminal Cost of Capital:
Terminal Value : $
Present Value (Terminal Value) : $
Present Value (CF of Next 10 Years): $
Sum of Present Values : $
Sum of Present Value - Debt + Cash: $
# of Shares: 12,169,478,937
Intrinsic Value Per Share: $
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Terminal Year
Revenue Growth
Revenue
Operating Margin
Operating Income
Tax Rate
EBIT (1-t)
Reinvestment
FCFF
Cost of Capital
Cumulated Discount Factor -
PV of FCFF -
This calculator is meant for informational/entertainmenet purposes only. All numbers should be independantely verfied. We are not responsible for any investment losses related to decisions made with the help of this website. We recommend getting professional advice before making any investment decisions. This calculator is meant for informational/entertainment purposes.

Book Recommendations