DQYDJ

  • About Us
    • Contact Us
    • Resources
    • Disclosures
  • Tools & Research
    • Stocks and Investments
    • Personal Finance
    • Economics
  • Blog
    • Investing
    • Economics
    • Personal Finance
      • Debt
    • Politics
    • Real Estate
    • Offbeat
      • Weekender

Discounted Cash Flow Calculator for Stock Valuation

Investing     April 23, 2018 by PK

This page contains a discounted cash flow calculator to help you estimate the net present value of an investment. You can vary every aspect of the analysis, including the growth rate, discount rate, type of simulation, and the number of cycles of DCF to perform. It additionally includes a financial lookup for over 2,000 American publicly listed stocks to make company or stock valuation very easy.

Discounted Cash Flow Calculator for Investment Valuation

Data from Sharadar.

Note:  Valuations produced by this calculator are for informational use only and should not be taken as advice to trade or hold any individual securities. Do your own due diligence on inputs and valuations.

Using the Automatic Discounted Cash Flow Calculator

The discounted cash flow stock valuation calculator is relatively straightforward but allows customization with a few advanced options. By default, it uses Earnings per Share to run valuations; expanding the Advanced Options tab allows you to use Free Cash Flow instead. Enter a trailing 12 month earnings per share (or free cash flow) amount and we apply growth from the first year.

Stock DCF Base Parameters

  • Current Stock Price – The most recent trading price for the stock. This may be up to a week out of date if you populate it with us. (see the methodology on the Stock DCF Calculator).
  • Discount Rate (%) – Return you could earn on another security, sometimes called the ‘guaranteed return’ (even if not guaranteed!).
  • TTM Earnings Per Share ($) – The trailing 12 month, or annual, dollars earned in profit per share of stock. The growth rate is applied in the very first year of simulation.
  • Earnings Growth (%) – The annual rate of growth you expect for earnings per share, in the near term.

Advanced Options (Optional)

  • TTM Free Cash Flow Per Share ($) – The trailing 12 month, or annual, dollars of free cash flow per share of stock. The growth rate is applied in the very first year of simulation. Optional – used if DCF Type you choose Free Cash Flow.
  • Free Cash Flow Growth (%) – The annual rate of growth you expect for free cash flow, in the near term. Optional – used if DCF Type you choose Free Cash Flow.
  • Years of Above Growth – The number of years to use near term growth numbers.  We conservatively suggest 5 or fewer.
  • Perpetual Growth (%) – The perpetual growth in EPS or FCFPS after the near term growth ends. ‘Perpetual’ Growth is a misnomer, though – we’ll only apply the simulation for the number of years you state in ‘Years to Simulate‘.
  • DCF Type – Use either earnings per share or free cash flow per share to value a stock.
  • Years to Simulate – The total number of years for the tool to carry out the DCF simulations. All companies (and earnings trends) must end so vary this value based on how conservative you’d like your analysis to be.

Stock Lookup for Financial Analysis

  • Ticker Symbol – Ticker symbol for the publicly traded stock to look up.  The tool includes over 2,000 companies; you can find more information with Sharadar.  Note that fundamentals come from the last annual report filed by a company, so may be nearly a year old.  Change whatever fields you feel necessary to create a proper valuation.
Discounted cash flow analysis for stock valuation
DCF suggests a way to value future cash flows by projecting forward flows using a few simple rules.

Discounted Cash Flow Valuation Output

  • Discounted Cash Flow (DCF) / Calculated Fair Value – Estimated fair value per share using the input assumptions.
  • Over / Under Value Percentage – Shows the percentage a stock is over or underpriced after computing a valuation.

How to Use a Discounted Cash Flow Analysis

Discounted cash flow analysis is a common technique to determine the contribution to present value of future cash flows. While used often in many aspects of business to set strategy, it’s also a useful analysis for evaluating investment choices.

The key to a good analysis – like in most types of analysis (!) – is to pick good projections going forward. While you can often get very good estimates of current conditions, setting the discount rate and earnings growth rate are as much art as science.  Those numbers are also quite exploitable; by moving the levers on them you can justify almost any current stock evaluation. Mmake sure you can defend your assumptions.

Discount rate is the so-called “price in a vacuum”, or price you could achieve executing your default investment strategy. If you would fall-back to an index fund, you would enter your expected return on that fund – perhaps 10% annually ignoring the effects of inflation. To set a good number, our S&P 500 Historical Return Calculator might give you some good hints.

Earnings growth is the annual rate at which earnings (or free cash flow) increase. In theory, future earnings belong to the shareholder. In that vein, earnings growth adds to the present valuation as it predicts future earnings. By default, the tool computes 5 years of high-growth earnings before falling back to a lower ‘perpetual number’ for a total of ‘Years to Simulate’ cycles. Set your own assumptions by expanding the ‘Advanced Options’ tab.

DCF: One Aspect of Your Stock Valuation Due Diligence

A discounted cash flow analysis is one of the methods I use when evaluating stocks for my own portfolio. You should always approach your investment decisions holistically – a good DCF reading shouldn’t be the only signal that you should own a stock. Many reasons exist that might cause a disconnect – regulatory and legal burdens, bad news, new competition, and a myriad of other reasons might cloud (or pump) a stock’s price.

Still, it’s good practice to run a DCF analysis on your portfolio (and when looking to add to the portfolio!). Who knows; maybe some stocks you’re evaluating are cheaper than others? There’s only one way to find out – use this tool in good health! Also, feel free to try our dividend discount model valuation calculator, or see stock returns in our dividend reinvested stock return calculator.

Related Posts:

  1.   Dividend Discount Model Calculator for Stock Valuation
  2.   Stock Return Calculator with Dividend Reinvestment (DRIP) for EVERY Stock
  3.   Stock Picks for 2016!
  4.   Is the Stock Market Overvalued? The Finale.
  • Twitter Transparent PNG
  • Facebook Transparent PNG
  • LinkedIn Transparent PNG
  • Reddit Transparent PNG
  • twitter
  • facebook
  • linkedin
  • google+
  • reddit

Filed Under: Investing Tagged: dcf, discounted cash flow, perpetuity, stock valuation

Join Our Mailing List Today

ABOUT PK  1000 Posts

I turn caffeine into useful tools and interesting posts. I also designed (and started) Don't Quit Your Day Job...

Contact PK
Follow PK on Twitter

TRENDING

  • +287%   Should You Include Your Primary Home in Net Worth?
  • +140%   A Calculator: Income Distribution by Age for 2015 in the United States
  • +79%   Income by Age: How Income Changes and Increases Over a Career
  • +69%   Full-Time Individual Income Percentile Calculator for the United States in 2017
  • +56%   Nikkei Return Calculator, with Dividend Reinvestment
  • +47%   Correlation of Income and Net Worth for Age Groups in America in 2016

Featured Articles

  • Average Drawdowns of Wealth for American Retirees
  • The Four Pillars of Personal Finance
  • The Fundamental Problem With Financial Models
  • Bond Yield to Maturity Calculator
  • Can You Grow Wealth with Stocks? The Story of Ronald Read.
  • S&P 500 Historical Return CalculatorS&P 500 Historical Return Calculator

POPULAR  IN THE LAST WEEK

  • Income Percentile Calculator for 2017 US Data
    Economics
  • S&P 500 Return Calculator, with Dividend Reinvestment
    Investing
  • United States Net Worth Brackets, Percentiles, and Top One Percent in 2017
    Economics
  • Net Worth by Age Calculator for the United States
    Economics
  • Net Worth Percentile Calculator for the United States in 2017
    Economics

Recent Comments

  • Clint on Inflation Expectations as of 4/12/2018
  • PK on Inflation Expectations as of 4/12/2018
  • PK on American Retirement Savings by Age: Averages, Medians and Percentiles
  • Clint on Inflation Expectations as of 4/12/2018
  • David @ Zero Day Finance on American Retirement Savings by Age: Averages, Medians and Percentiles
  • PK on Average American Retirement Savings, Medians and Percentiles
  • Clint on Average American Retirement Savings, Medians and Percentiles
  • jim on Average American Retirement Savings, Medians and Percentiles

About DQYDJ

        

We're a finance blog with a twist: we write articles, but we also create calculators and visualizations to help you understand your finances and take control of your investments.

[ Read More About Us ]

Quick Links

  • Contact Us
  • Advertise on DQYDJ
  • Disclosures
  • Recent Posts
                 

Search DQYDJ

DQYDJ Categories

© Copyright 2018 DQYDJ.com