Calculating a Stock's Intrinsic Value (Actual Value)

You've found a great company, possibly the best investment opportunity in your lifetime...

Not only that, you understand the Basic Principle of Investor Return which says, "the price you pay determines your rate of return."
So all you have to do is take advantage of your expert knowledge and buy a great company at a great price.
Well, almost.
You've still got one problem left...
How do know a company's selling for a great price?
You calculate its intrinsic value.

What's Intrinsic Value?

In his 1938 publication "The Theory of Investment Value," John Burr Williams first articulated the idea of calculating a stock's intrinsic value.
His idea essentially adds all of the expected future cash flows produced by a company and assigns them a present value. This present value represents the price you should pay.
So, in financial circles, "intrinsic value" is defined as the present value of all expected future net cash flows to the company.
Find that sentence a little hard to follow?
So do I.
That's why I prefer a definition that doesn't require a dictionary for interpretation.
Here it is...
Intrinsic value is the actual value of a company as opposed to its current market price.
That definition makes a lot more sense, doesn't it?
So why is intrinsic value important?
Because if you can calculate the actual value of a companythen...
You can compare it to the current market price.
If the current market price is higher, then you know the company is overvalued.
But if the current market price is lower, then you know the company is undervalued.
Knowing what's overvalued and what's undervalued is what separates successful stock market investors from the rest of the crowd.
Because if you know a company is undervalued, then...
You can buy low!
And buying low is the key to successful investing. Right?

How Do You Calculate Intrinsic Value?

Sounds great, doesn't it?
But we still haven't tackled the problem...
How do you calculate a company's intrinsic value?
Well, first you need current information regarding your company's...
  • Stock price
  • Average return on equity
  • Dividend payout ratio
  • Equity per share (also known as book value per share)
  • Earnings per share
  • Average P/E ratio
Does all that information look intimidating?
Don't worry. We'll address how to easily find each piece of information soon. Fortunately, it's all on the Internet!
Once you have all this information at your fingertips, you can easily calculate your company's intrinsic value by estimating its earnings for the next ten years.
The following chart uses The Coca-Cola Company as an example to illustrate how easy this is...

We'll address how to use this chart in moment.
But first, let's get those figures...

How to Find the Numbers You Need

Before you can calculate a stock's intrinsic value, you need to know several pieces of information about the company and its stock.
Here's how to find each piece of information...
Current Stock Price - This one's easy. Just go to Yahoo! Finance or Google Finance or dozens of other places on the web where you can get real-time stock quotes. Plug in your company's stock ticker, and you've got it.
Average Return on Equity - While most online services like Yahoo! Finance provide a figure for return-on-equity, it most likely represents the current year only. To get a more accurate number for your intrinsic value calculation, go to Google Finance, type in your company's ticker symbol, and find the text link titled "More ratios from Thomson Reuters."
Follow that link, and you'll find a category titled "Management Effectiveness." Find the figure for "Return on Equity -5 yr. Avg."
It's best to use a company's five- or ten-year average return on equity as opposed to a single year when calculating intrinsic value.
Because a dramatically higher or lower one-year return on equity can throw off your entire calculation. So if you want the most accurate calculation possible, use a long-term average return on equity.
In my opinion, The Value Line Investment Survey offers the best return on equity figures. Visit your local library, and you can find a company's return on equity every year for the last ten years as well as Value Line's projections for the company's ROE over the next five years.
For best results, use Value Line figures for your intrinsic value calculations.
Current Dividend Payout Ratio - Again, go to Google Finance, type in your company's ticker symbol, and find the text link titled "More ratios from Thomson Reuters."
Follow that link, and you'll find a category titled "Dividends." Find the figure for "Payout Ratio (TTM)." That's the percentage of earnings your company pays out in dividends.
Current Equity Per Share - Go to Yahoo! Finance, type in your company's ticker symbol, and find the text link titled "Key Statistics." Find the category titled "Balance Sheet," and find the figure for "Book Value per Share." This is the current equity per share, also known as book value.
Current Earnings Per Share - Go to Yahoo! Finance, type in your company's ticker symbol, and find the figure for EPS. This is the earnings per share.
However, keep in mind that Yahoo! Finance and most online services report a company's last four quarterly earnings figures as the EPS, so this figure might be distorted by a one-time expense or charge-off due to otherwise favorable long-term investments by the company.
So make sure you perform due diligence when searching for an accurate earnings per share figure for your intrinsic value calculation. Again, The Value Line Investment Surveyprovides the most accurate figures.
Average P/E Ratio - This isn't a ratio I?ve run across on Yahoo! Finance or Google Finance, so I performed a Google search to find a good site. A site called ADVFN popped up. If you follow this link to their site, and scroll down to the category "Valuation Ratios," you'll find a figure titled "5-Y Average P/E Ratio." This is the company's five-year average P/E ratio.
But again, you can find a far more accurate ten-year P/E ratio by visiting your local library and consulting The Value Line Investment Survey. The figure they provide is the one I personally use.

Using Excel to Calculate Intrinsic Value

Once you've gathered all the necessary information, you can use Excel to calculate a stock's intrinsic value.
The previous image, using The Coca-Cola Company (KO), is a good example of this...
Do all those spreadsheet formulas and calculations look confusing?
Fortunately, I've already set them up for you!
All you have to do is plug in the customized numbers for your company...
And you can use the exact same Excel spreadsheet I use for calculating a company's intrinsic value.
Download Britt's Intrinsic Value Spreadsheet >>>
Just replace the numbers in the yellow-highlighted cells with your company's numbers, and the spreadsheet will calculate a value titled "Multiple" on line 29.
Line 29 is the calculation you're looking for.
If your great company has a number above 5.00, it's currently undervalued.
If it's below 5.00, then the stock is currently overvalued...
Why 5.00?
Because a multiple of 5.00 means you'll make a 5-fold return on your investment in the next ten years if you buy the company at its current price.
A 5-fold return in ten years is a 17.46% annual compounding rate of return.
Also, five is a nice round number, and I like nice round numbers.
No kidding...
Think that's a silly reason for picking 5.00?
It's really not.
Always keep in mind, calculating intrinsic value is an art, not an exact science.
The spreadsheet's calculations act as a guide, not a precise road map.
As Warren Buffett says...
"It's better to be approximately right than precisely wrong."
So a figure above 5.00 means you're approximately right.
But there's another reason you want a 5-fold investment return and not a 4-fold or a 6-fold return...
Remember, if achieved, a 5-fold return is a 17.46% annual compounding rate of return.
This beats the S&P 500's fifty year track record of 10.85% by more than six points.
Now, in order to make all your time and effort researching stocks a worthwhile endeavor, you need to beat the market by at least a couple of points per year.
Over time, those couple of points will add up to a lot.
And while achieving a 4-fold return over ten years (a 15% annual compounding rate of return) achieves your goal of beating the market by more than a few points...
You need to remember, calculating a stock's intrinsic value is an estimating tool. It's more art than exact science.
So as a precaution, give yourself a little room for error.
Force your potential investment to live up to a higher standard...
Tack an extra 25% onto that 4-fold return, and give yourself a new goal of a 5-fold return.
That way, if you fall short of your goal, you still have a good shot at beating the market averages.
"It's better to be approximately right than precisely wrong."
So give yourself a little bit of leeway in case something goes wrong.
In investment circles, this idea is known as the margin of safety.

Providing a Margin of Safety

Benjamin Graham first put forth the idea of a margin of safety in his groundbreaking bookSecurity Analysis (1934), which he co-authored with colleague David Dodd.
According to Graham, margin of safety is the secret to a sound investment philosophy...
"Confronted with a like challenge to distill the secret of sound investment into three words, we venture the following motto, Margin of Safety."
So what's a margin of safety?
It's nothing more than giving yourself a little room for error.
Just ask yourself, "If things fail to go perfectly, will my investment still work out?"
If not, there's no margin of safety.
However, if your company's earnings fall well short of your projections and you can still achieve your desired investment returns...
Then, you have a margin of safety.
By purchasing only those stocks which offer a significant margin of safety, you limit your downside risk and significantly increase your odds of success.


Learn how to calculate a stock's intrinsic value. It's a skill that will prove invaluable over the course of your investing lifetime.
Use the spreadsheet located in the middle of this page. Look for companies with a multiple in excess of 5.00 at the current price.
However, remain mindful of other variables. Some companies look like they're dirt cheap, and they are. These companies will make you a fortune if you're prudent enough to buy them.
But other companies also look like they're dirt cheap, while in reality, they're grossly overvalued...
So how do you tell the difference?
By following all the rules previously outlined for finding a great company...
Also, I can't emphasize this enough - ask question after question about your company's future business prospects and apply your own common sense and good judgment. This will go a long way toward determining your investment success...
After all, if numbers told the entire story, no one would think about their investment decisions at all. We'd all just let computer programs "run the numbers" on our investments. Right?