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.
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:
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:
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:
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: