How to Calculate Warren Buffett’s Margin of Safety: Formula + Excel

Our Simple & Powerful Guide Helps You Transform Your Investments By Truly Understanding Buffett's "Margin of Safety", The Core of Value Investing.

To calculate the margin of safety, estimate the next 10 years of discounted cash flow (DCF) and divide it by the number of shares outstanding to get the intrinsic value. The difference between the intrinsic value and the stock price is the margin of safety percentage.

Calculating Buffett’s margin of safety formula requires understanding cash flow, discounting, and intrinsic value. Learn exactly how to calculate the margin of safety with this valuable lesson.

Margin Of Safely Calculation Infographic

How to Calculate the Margin of Safety Percentage
How to Calculate the Margin of Safety Percentage (Infographic)

Buffett, one of the wealthiest people in the world, has told us everything we need to know for profitable long-term investing. With multiple books and countless letters to investors, Berkshire Hathaway’s co-founder has communicated his investing philosophy repeatedly. His core investing principle is the Margin of Safety.

What is the Margin of Safety?

The margin of safety is the difference between a company’s intrinsic value (its estimated 10-year cash flow minus inflation) and the current stock price. If the intrinsic value is $100 and the stock price is $80, the margin of safety is 25%.

The intrinsic value is calculated based on the 10-year discounted cash flow (DCF).

The margin of safety is a value investing principle popularised by Seth Klarman and Warren Buffett.

In other words, if a company’s stock price is below the actual cash flow value (income) and assets, the percentage difference is the Margin of Safety. This is the discounted price at which you buy a share in the company.

If a company is worth $5 per share on the stock market exchange, but the value of its earnings, property, and brand is worth $10, then you have a discount of 50%.

If you buy the stock at $5, the price should rise 100% to $10 per share.

If a stock price is significantly below the actual fair value of a company, that percentage difference is known as the Margin of Safety. Essentially the percentage that the stock market undervalues a company.

In other words, the Margin of Safety is the percentage difference between a company’s Fair Value per share and its actual stock price. If a company has profits and assets that outweigh a company’s stock market valuation, this represents a Margin of Safety for the investor. The higher the margin of safety, the better.

In classic value-investing theory, the margin of safety is the level of risk an investor can live with. The margin of safety estimates the risk a stock buyer takes.

Warren Buffett’s Business Valuation Formula

If you understood a business perfectly and the future of the business, you would need very little in the way of a margin of safety. So, the more vulnerable the business is, assuming you still want to invest in it, the larger the margin of safety you’d need. If you’re driving a truck across a bridge that says it holds 10,000 pounds and you’ve got a 9,800 pound vehicle, if the bridge is 6 inches above the crevice it covers, you may feel okay; but if it’s over the Grand Canyon, you may feel you want a little larger margin of safety. Warren Buffett

Margin of Safety Formula

Margin of Safety = (Intrinsic Value Per Share – Stock Price) / Intrinsic Value Per Share.

How to Calculate the Margin of Safety Ratio: Small Business

If you are interested in buying shares of a company, or even an entire business, you will want to estimate the value of the cash it generates in the future. Let’s guess that a business you want to buy will make $10,000 per year for ten years, and after ten years, the business will be worthless. This means the value of the company might be worth today $100,000 minus the yearly inflation rate; for example, 2% per year.

This means the value of the income, or intrinsic value, in real terms today is $89,826 (Intrinsic Value)

The business owner wants to sell 100% of the company to you for $60,000 (Stock Price)

Margin of Safety = 33% = ($89,826 – $60,000) / $89,826

Calculating the Margin of Safety for Stocks

Firstly estimate the free cash flow for the next 10 years and discount it by the inflation rate. Divide this by the number of outstanding shares; you now have the intrinsic value per share. The difference between intrinsic value and the current stock price is the margin of safety.

Margin of Safety Formula Percentage

The margin of safety formula is simple: if the current stock price is $10, and a company’s fair value is $5, you have a 50% margin of safety.

The margin of safety formula percentage is the difference between the current stock price and the net present value of 10 years of future cash flow dividend by the number of shares.

Download Our Free Magin of Safely Calculator in Excel

Calculating the company’s intrinsic value and, therefore, the margin of safety for stocks means using many variables and calculations. Using a Margin of Safety Calculator, a simple excel spreadsheet would be best.

Intrinsic Value & Margin of Safety Calculator Excel
The margin of Safety Calculator Excel – Click To Download

Download Our Margin of Safety Calculator in Excel

Calculating Intrinsic Value in Excel

Essentially, Warren Buffett estimates the current and predicted earnings from a company from now for the next ten years. He then discounts the cash flow against inflation to get the current value of that cash. This is the Intrinsic Value of the business.

Additionally, Warren Buffett bases his Intrinsic Value calculations on future free cash flows. He believes cash is a company’s most valuable asset, so he projects how much future cash a business will generate.

The formula for estimating future Free Cash Flows is the Discounted Cash Flow Method. Here is an example of a simple Discounted Cash flow Method

8 Steps to Calculate the Margin of Safety

  1. Take the free cash flow of the first year and multiply it by the expected growth rate.
  2. Then calculate the NPV of these cash flows by dividing it by the discount rate.
  3. Project the cash flows ten years into the future, and repeat steps one and two for all those years.
  4. Add up all the NPVs of the free cash flows.
  5. Multiply the 10th year with 12 to get the sell-off value.
  6. Add up the values from steps and cash and & short-term investments to arrive at the intrinsic value for the entire company.
  7. Divide this number by the number of shares outstanding to arrive at the intrinsic value per share.
  8. The percentage difference between the intrinsic value per share and the stock price is the margin of safety. 

Note: NPV refers to the Net Present Value or the present value of money. You calculate the Net Present Value by subtracting the discount rate from the future value of the money and multiplying it by the number of years you are measuring.

The advantage of the Discounted Cash Flow Method is that it is simple. The problem with this method is that Free Cash Flow can vary dramatically from year to year. Thus, the final figure from this method can be inaccurate.

 

You want to be a successful stock investor but don’t know where to start.

Learning stock market investing on your own can be overwhelming. There’s so much information out there, and it’s hard to know what’s true and what’s not. Stock Market Investing Training - Liberated Stock Trader Pro

Liberated Stock Trader Pro Investing Course
Our pro investing classes are the perfect way to learn stock investing. You will learn everything you need to know about financial analysis, charts, stock screening, and portfolio building so you can start building wealth today.
★ 16 Hours of Video Lessons + eBook ★
★ Complete Financial Analysis Lessons ★
★ 6 Proven Investing Strategies ★
★ Professional Grade Stock Chart Analysis Classes ★

Find Out More


 

The Margin of Safety. What You Should Pay for A Stock

Now that you know the intrinsic value per share, you can compare that to the actual share price. If the intrinsic value exceeds the actual share price, that will constitute a value investment.

Warren Buffett likes a margin of safety of over 30%, meaning the stock price could drop by 30%, and he would still not lose money.

All value investors need to understand that the margin of safety is only an estimate of a stock’s risk and profit potential. There are many risks that fundamental analysis cannot estimate, including politics, regulatory actions, technological developments, natural disasters, popular opinion, and market moves.

The margin of safety you use is the level of risk you are comfortable with.

If you are risk-averse, you will want a high margin of safety. A risk-taker, however, could prefer a low margin of safety.

How to Use Margin of Safety Ratio for Better Investment Returns?

The margin of safety ratio is an important tool used by investors to ensure they are making wise investments and getting the best possible returns. It is calculated by first determining the intrinsic value of a stock or other security, which is based on a combination of both quantitative and qualitative factors.

Next, the investor will subtract the current market price from this intrinsic value to obtain the margin of safety ratio. This ratio helps investors determine how much of a discount they would be getting if they purchased the security at its current market price.

Knowing how to leverage this ratio can help you maximize returns and minimize losses. When investing in stocks or other securities, investors should strive for maximum upside potential with minimal downside risk. The margin of safety ratio can help them identify situations where there is less downside risk than upside potential – these may be ideal opportunities for investment.

Additionally, when analyzing a company’s financial statements, investors should look for strong balance sheets and healthy cash flows as a sign that there may be more upside potential than downside risk – leading to greater investment returns over time.

Understanding how the margin of safety works in tandem with other analytical techniques such as fundamental analysis and technical analysis, can also help investors make better decisions when it comes to buying or selling securities.

By combining all available data points into one coherent picture, investors can get a clearer sense of what investments have higher risk/reward profiles versus those with more stable long-term prospects for growth. This can enable them to make better decisions about when (and why) to enter or exit positions in order to maximize return on their investments over time.

The Margin of Safety Measures Market Irrationality

The larger the margin of safety, the more irrational the market has become. Imagine a business with $5 billion worth of assets, property, and future cash flow from operations, but the stock market values all the shares on the market (Market Capitalization) at $2.5 billion. This means you could buy the entire company for a 50% discount and potentially break to company up and realize a 100% profit on your investment.

If the market values a company accurately, it is behaving rationally. Therefore the larger the Margin of Safety, the more irrational the market is behaving.

 

Buffett thinks that popular opinion and the media create market irrationality. Buffett watches the news and looks for bad news about good companies. The idea behind this strategy is that news reporting is usually shallow, superficial, and concentrated on one aspect of a company’s business. Buffett will sometimes buy companies after a well-publicized scandal.

Value investors believe people pay more for attractive, fashionable, or “sexy” stocks. Therefore, many value investors look closely at unattractive, boring, and unfashionable stocks. These people seek good stocks that the market does not appreciate.

For instance, a value investor could buy an oil company instead of a tech stock. The oil company is old-fashioned, boring, and offensive to some people, but it makes money. The tech company is attractive and flash but could make no money. Despite a scandal at that company,

Berkshire Hathaway (NYSE: BRK.B) kept significant holdings of the banking giant Bank of America (NYSE: BACy. The public turned on Bank of America after news reports alleged some employees were writing fraudulent loans to get commissions.

Buffett kept Bank of America because the bad loans came from one small piece of Bank of America’s business. Buffett hoped the bad news about Bank of America would fade, but the company could keep making money.

Another key idea in Buffett’s market irrationality strategy is that the media does a lousy job of reporting on companies. Buffett bets that most news about companies will be inaccurate, limited, short-sighted, biased, and incomplete.

Buffett tries to capitalize on that lack of information by having more information than the rest of the market. Buffett reads financial reports; instead of newspapers and blogs because he thinks financial data gives him an edge over other investors. Buffett assumes that most investors value companies poorly because they rely upon inaccurate media reports. His strategy is to find more accurate information and base his decisions on that information.

A High Margin of Safety

Most value investors believe that the higher the margin of safety, the better. In reality, a margin of safety between 20% and 55% is reasonable. If the margin of safety is too high, you must investigate more in-depth into the company, as it could be that the business has some serious fundamental problems. These problems could range from industry disruption to a catastrophic scandal or inevitable bankruptcy.

In the next section, we highlight TD Ameritrade, a very profitable company with a high cash flow currently selling at a discount of 55%, e.g., a margin of safety of 55%.

A Margin of Safety Stock Screener

The best margin of safety stock screener is Stock Rover because it calculates three critical ratios, the margin of safety, the margin of safety with enterprise value to sales, and fair value standard and academic.

As you can see, the Margin of Safety depends entirely on how you calculate a company’s fair or intrinsic value. The image below shows three ways that fair value can be calculated. This scan was done using our recommended stock screener Stock Rover. The red boxes highlight that although there are differences in the fair value calculation, they are, in many cases, similar outcomes.

You could use the three ways of calculating the Margin of Safety to confirm that the company is undervalued.

There are at least 3 ways to calculate the Fair Value & Margin of Safety
There are at least three ways to calculate the Fair Value & Margin of Safety – Image Courtesy of Stock Rover.

6 Ways to Calculate Margin of Safety

The 6 Ways of Calculating Margin of Safety Used By Stock Rover.

Fair Value – We compute the company’s Fair Value using a discounted cash flow analysis to determine the Intrinsic Value. We then rank firms in each Sector by their Intrinsic Value to find a value well suited to current market multiples. Over the long term, our Fair Values will imply a 30% drop in price for the worst stocks and a 45% gain for the best stocks. This is the calculation used by Warren Buffett.

Margin of Safety – The percentage difference between a company’s Fair Value and price. This metric is the single most significant valuation metric as it is the final output of a detailed discounted cash flow analysis. This is the calculation used by Warren Buffett.

Fair Value (EV / Sales) – This fair value is determined by ranking stocks in a sector by their EV / Sales ratios. It is a fallback for when discounted cash flow analysis cannot be calculated. Over the long term, this value will imply a 30% drop in price for the worst stocks and a 45% gain for the best stocks.

Margin of Safety (EV to Sales) – The percentage difference between a firm’s fair value (as determined by the EV / Sales ratio) and its current price. A higher margin of safety is better, but this valuation method is imprecise as it uses very generalized criteria.

Fair Value (Academic) – We compute a company’s Fair Value (Academic) using a discounted cash flow analysis with the academic formula for Intrinsic Value that forecasts cash flows into perpetuity. We then rank firms in each Sector by their Intrinsic Value to find a value well suited to current market multiples. Over the long term, our Fair Values will imply a 30% drop in price for the worst stocks and a 45% gain for the best stocks.

Margin of Safety (Academic) – The percentage difference between a company’s Fair Value (Academic) and its price. When this value is close to the non-academic Margin of Safety value, it provides higher confidence in the result.

So to reiterate, in the example above, you can use the three different ways of calculating the Margin of Safety to confirm that the company is undervalued.

Frequently Asked Questions

How to find margin of safety?

You can use a stock screener like Stock Rover to easily find the margin of safety. Or calculate it manually using the difference between the current market price of an asset and its intrinsic value. By calculating this difference, you can determine whether or not a stock is overvalued or undervalued.

How to calculate the margin of safety in dollars?

The margin of safety can be calculated in dollars by subtracting the current market price of an asset from its intrinsic value. The intrinsic value is determined by factors such as company fundamentals, industry performance, economic conditions, and investor sentiment. For example, if a stock has an intrinsic value of $50 per share based on these factors but is trading at $40 per share, the margin of safety is calculated as $10 per share.

How to calculate the margin of safety as a percentage?

The margin of safety can also be calculated as a percentage by taking the difference between the intrinsic value and the current market price of the asset and then dividing it by the intrinsic value. In the above example, the margin of safety is 20%, calculated as follows: ($50 - $40) / $50 = 0.20, or 20%.

Is a higher margin of safety good?

A higher margin of safety means that a stock is potentially undervalued and may provide a good investment opportunity. On the other hand, a lower margin of safety signals that a stock may be overvalued and prone to greater risk. Investors should keep an eye on changes in the margin of safety to ensure they are making sound decisions when investing.

How to calculate the margin of safety ratio?

The margin of safety ratio is a measure of how much the current market price of an asset deviates from its intrinsic value. It can be calculated by dividing the margin of safety in dollars by the intrinsic value. For example, if a stock has an intrinsic value of $50 per share and is trading at $40 per share, then the margin of safety ratio is calculated as follows: ($50 - $40) / $50 = 0.20 or 20%.

Can the margin of safety be negative?

Yes, the margin of safety can be negative. This occurs when an asset's current market price is greater than its intrinsic value. A negative margin of safety indicates that a stock may be overvalued and poses a greater risk to investors.

What are the main factors that affect the margin of safety?

The main factors that affect margin of safety are company fundamentals, industry performance, economic conditions, and investor sentiment. Company fundamentals include sales and earnings, while industry performance encompasses the overall performance of its sector or niche. Economic conditions include macroeconomic factors such as GDP growth, inflation, and interest rates. Investor sentiment measures the overall attitude of investors towards a given asset or market.

How can investors use the margin of safety to assess risk?

Investors can use the margin of safety to assess the risk associated with a given investment by comparing the intrinsic value of the security to its current market price. This ratio helps investors identify situations where there is less downside risk than upside potential. By subtracting the current market price from the intrinsic value, they can determine how much of a discount they would be getting if they purchased the security at its current market price.

Are there any potential drawbacks when using margin of safety?

One potential drawback to using the margin of safety as an investing tool is that it does not take into account other factors, such as macroeconomic trends and geopolitical risks. When determining the intrinsic value of a stock or other security, investors should consider both quantitative and qualitative factors such as company fundamentals, industry dynamics, and macro-level economic variables.

Margin of Safety Summary.

Calculating Fair Value and Margin of Safety is critical to the value investing strategy. If you want to make good profits long-term, you need to minimize your risk by purchasing companies selling at a significant discount due to market irrationality.

We have included an excel spreadsheet to help you manually calculate fair value and margin of safety. Stilt, you will need a great stock screener with a built-in calculation to be effective and efficient. Stock Rover offers a full 14-day trial and a free service; try Stock Rover.

Get Stock Rover Free

[Related Article: 4 Easy Steps to Build The Perfect Warren Buffett Stock Screener]


Are You Looking For Stock Investing & Trading Software? Here Are My Favorites.

My favorite software for trading is TradingView because it does everything well. It has backtesting, great charts, stock screening, and an active community of over 3 million people sharing ideas, plus a free plan available globally.

My favorite software for investing is Stock Rover, as it specializes in deep fundamental financial screening, research, and portfolio management. It is the ideal platform for dividend, value, and growth investing.

My favorite software for stock market news is Benzinga Pro, with its super-fast real-time news engine, squawk box, and news impact ratings.

My favorite AI trading software is TrendSpider which enables automatic pattern recognition for Trendlines, Candlesticks, and Fibonacci levels. Trade Ideas uses AI to generate high probability daily trading signals for auto-trading.

My favorite stock-picking service is Motley Fool Stock Advisor, which has a proven track record of beating the market with excellent stock research reports.

Read the Full Top 10 Stock Market Software Testing & Review