Lyn Alden

Investment Strategy

  • Start Here
  • Free Newsletter
  • StockDelver
  • OptionWeaver
  • Top Resources
  • Premium
  • Members Area
  • Log In

Discounted Cash Flow Calculator: The StockDelver Model

Here is the valuation tool I use to calculate the fair value of a stock.

It’s a streamlined spreadsheet model that keeps things fast and simple, and can be used on a variety of platforms.

StockDelver Discounted Cash Flow Calculator

It’s fast to use, and has three different calculators:

#1) Detailed One-Stage Model

This is elegant in its simplicity, yet powerful and flexible in its approach.

The hardest part about applying discounted cash flow analysis, or using any stock valuation method, is figuring out what growth rates to use. An output is only as good as your inputs are accurate, so if your forecast is off and you put bad numbers in, you’ll get bad numbers out.

This framework makes it easy to segment the growth estimate into individual parts, so that you can approach them individually and come up with an accurate estimate.

Here’s an example of what it looks like:

Discounted Cash Flow Calculator Example

You start with top line growth, and work your way down from there, variable by variable, using recent company history, investor presentations regarding management plans and goals, or any other data you have available, to determine how the performance might play out over the coming years.

The output area automatically calculates a result for you, based on your inputs.

I like to use this tool for sensitivity analysis as well. Once you have a valuation estimate, you can see how negative impacts to pricing or growth or anything else can affect how your investment will turn out.

This helps you identify risks ahead of time.

It works on just about any type of publicly-traded company, whether they pay a dividend or not.

#2) Simple Two-Stage Model

The simple two-stage model cuts right to the chase and lets you calculate the fair value of a stock based on changing growth rates:

Fair Value Calculator Example

This is great for fast-growing companies that will necessarily be slowing down in a few years.

#3) Dividend Discount Model

Lastly, the spreadsheet has a dividend discount model sheet for high-yield companies:

Dividend Discount Model Example

I cut the output picture short because it’s a long image.

This model is great for REITs, MLPs, or any high-yielding dividend stock.  You don’t need to use a 10-year sale multiple like the others; it calculates the sum of perpetual discounted dividends for you.

Platform-Independent and 100% Unlocked

Although this is an Excel (.xlsx) file, it can be opened and used on most spreadsheet programs, including free ones like Open Office.

You can even upload it to Google Drive and use it on the cloud like a web application.

I chose not to lock or hide any of the cells. You can see all the formulas if you want, and you can customize the spreadsheet file to suit your needs.

Download the StockDelver Spreadsheet

This Excel spreadsheet (.xlsx) is available as an instant download for $9.95, and comes with a 16-page detailed PDF tutorial on how to use it.

You can also get this as part of OptionWeaver.

I use one of the most trusted digital delivery platforms for secure payment, and this entire site is SSL-encrypted for additional safety.

Download StockDelver below:

Loading…
Tweet
Share
Share

This site provides equity research and investment strategies to give you the insight and data you need for managing your money through all market conditions.

Click here to join the free investing newsletter.

Featured On:

Investment Strategy Press

Let’s Connect:


Stock Ideas & Market Info:

  • The Shiller PE (CAPE) Ratio: Current Market Valuations
  • Contrarian Investing: Smart Moves for 2023 and Beyond
  • 4 Economic Bubbles Growing In the United States
  • Safe High Dividend Stocks: 20+ Strong Picks For 2023
  • 5 Rock-Solid Blue Chip Dividend Stocks That I’m Bullish On Now
  • 7 Top Stocks to Buy and Hold for the Next Decade and Beyond

Build Wealth:

  • How to Build Wealth Fast- This Chart Shows What it Takes
  • How to Increase Your Credit Score to 800 and Above
  • The 5 Most Impactful Tactics to Save Money I’ve Ever Found
  • 12 In-Depth Tactics to Seriously Boost your Energy

Investing Basics:

  • How to Invest Money Intelligently: The Starter’s Guide
  • How to Invest in Stocks and the Stock Market
  • Roth IRAs: How to Optimize Yours
  • Federal Thrift Savings Plan (TSP): The Ultimate Guide for 2019
  • How to Survive a Stock Market Crash or Bear Market

Experienced Investors:

  • Covered Calls: A Step-by-Step Guide with Examples
  • Selling Put Options: How to Get Paid for Being Patient
  • Equal Weighted Index Funds: The Pros and Cons and Which to Pick
  • Discounted Cash Flow Analysis: Complete Tutorial With Examples

Disclaimer

This site is for informational and entertainment purposes, and should not be construed as personal investment advice.

Please seek out a certified financial planner if you need advice tailored to your unique situation.

Instead of running ads on this site, I receive affiliate commissions for recommending certain products or services. See my disclosure for more info.

Get The Book

This digital book describes my process for finding great stocks, and comes with streamlined calculators to determine fair value.

StockDelver Investing Book

Check it out here.

Premium Membership

Premium Research Service

Join the new premium research service for timely deep-dive analysis of high-conviction investment opportunities.

Learn more here.

  • Privacy Policy
  • Legal Information
  • Article Archives
  • Newsletter Archives
  • Support
  • Contact

Copyright © 2023 · Generate Pro On Genesis Framework · WordPress · Log in