Digging Into Buffett's Numbers

Discounted Cash Flow (DCF)
The concept of Discounted Cash Flow model valuation is straightforward: We discount all future cash flows the company will produce to the present day, add them up, and voila, we have our company valuation. With that, I present The Discounted Cash Flow Equation!

DCF = CF0 x SUM[(1 + g)/(1 + r)]n (for x = 0 to n)

OK, OK. That's not as pretty as my initial explanation. Here's the basic interpretation: DCF is Discounted Cash Flow, CF0 is today's cash flow, g is expected growth, and r is the expected rate of return. For the many of you who wish that math had ended in third grade, let that suffice -- we will look at how you can easily translate all that gibberish into a spreadsheet in a minute. For those of you who have to know exactly where that equation came from, my previous article is for you.

Buffett's DCF valuations
As you read that section, I expect some of you were Foolishly thinking, "What kind of cash flows? What kind of growth? What is the expected rate of return? Did I remember to turn off the stove?"

Don't worry, you turned off the stove. For the answer to the rest of these questions, we look to Warren Buffett.

Cash Flows and Growth: Buffett uses "owner earnings," which he defines as:

Owner Earnings = Net Income + Depreciation - Capital Expenditures

Sound familiar? It should. This is essentially our beloved free cash flow (FCF)!

Obviously, then, it makes sense that the "growth" refers to FCF growth. We estimate future FCF growth from historical FCF growth -- averaging over five or more years to smooth out yearly variations.

Expected rate of return: The expected rate of return is the opportunity cost of investing your money -- that is, what you could reasonably expect your money could earn in a risk-free investment.

To find this number, Buffett uses the yield on the 30-year U.S. Treasury Bond -- currently around 5%. Historically, however, the 30-year T-bond rate has been much higher (the 25-year average is around 8%). Since the expected rate controls the influence of future values on our DCF calculation (the higher the expected return, the less the future influences our calculation), we will be conservative and use the higher value (as Buffett does).

The expected return (r) is used to calculate our discount factor (DF):

DF = 1 / (1 + r)(n)

The present value (PV) of any future value (FV) received n years from now is just:

PV = FV x DF

Margin of safety: The "Margin of Safety" is Buffett's signature investment principle, borrowed from Benjamin Graham. Buffett considers only companies that are trading at a significant discount (40% or more) to their DCF value. This margin of safety helps ensure reasonable return potential even if some of our assumptions are off.

Future growth assumptions
There are too many variables to accurately estimate what a company's growth is going to be down the road. To help minimize errors, we make two conservative assumptions:

1. Growth will be steady for the next five years.

2. By year nine, the growth rate will decline to 3% (the rate of inflation).

Example: The Washington Post Company
Buffett has owned shares in Washington Post (NYSE: WPO  ) since 1973. The chart below shows the company's free cash flow (and related values) over the past five years:

2000 2001 2002 2003 2004
Net income 136 230 204 241 333
Depreciation 181 217 173 175 185
Capital exp. (172) (224) (153) (126) (205)
Free cash flow 145 223 224 290 313
Free cash flow growth - 44% 54% 0% 29% 8%


The variation in free cash flow growth is mostly due to fluctuations in capital expenditures -- net income and depreciation are relatively steady. Fluctuations in capital expenditures aren't unusual -- companies may acquire capital in one year that will provide benefits many years into the future (like a new factory). Still, this yearly fluctuation illustrates the need to use several years of historical data to calculate an average growth value.

For Washington Post, the average growth rate for the past five years is:

(-44 + 54 + 0 + 29 + 8) / 5 = 9.4 %

We now have all the information we need for our DCF calculation:

Estimated growth rate: 9.4%.

Expected return: 8%.

Assumption: During years six through eight, the growth rate will decline to 3% (the rate of inflation).

Creating our DCF calculation in a spreadsheet is simple.

1. Multiply the prior year's FCF by the appropriate growth factor to get the current year's FCF.

2. Multiply the current year's FCF by the discount factor (calculation shown above). This gives the discounted present value of free cash flow for the year (DPV of FCF).

Here's what the spreadsheet looks like (FCF values in $millions):

Year 1 2 3 4 5 6 7 8
FCF (last year) 313 342 375 410 448 490 528 561
Growth factor 1.094 1.094 1.094 1.094 1.094 1.078 1.062 1.046
FCF (this year) 342 375 410 448 490 529 562 587
Discount factor 0.926 0.857 0.794 0.735 0.681 0.630 0.583 0.540
DPV of FCF 317 321 325 330 334 333 328 317


We're almost done (so hang in there).

What if the company is still around 50 years from now? Do we have to calculate the discounted present value of free cash flow from now until 2055? Fortunately, no. Once we reach steady FCF growth, as our model does in year nine, we can use the power of calculus to simplify our problem.

Black magic (aka calculus)
Here's our basic DCF equation (again):

DCF = CF0 x ? [(1 + g)/(1 + r)]x (for x = 0 to n)

Assuming our growth rate (g) is constant and less than our expected return (r), we can simplify this equation to express the terminal (total) DCF value at year n as:

DCFn = CFn / (r - g)

All we have to do then is discount our DCF value back to the present day. Let's plug our DCFn value into the present value equation:

PV = DCFn x DF

DF is simply our discount factor: 1 / (1 + r)(n - 1). (If you are wondering why this exponent is n - 1 rather than n, it's because DCFn is the estimated value at the beginning of year n which is the same as the end of year n - 1).

So to calculate the present value of all cash flows from year nine and beyond, we have:

PV = [CF9 / (r - g)] x [1 / (1 + r)8]
= [(587 x 1.03) / (0.08 - 0.03)] x [1 / (1 + 0.08)8]
= 12092 x 0.5402
= 6533

Add this calculation in your DCF spreadsheet, and you are ready to roll!

Finally, our DCF valuation for Washington Post
All that's left to do now is add up our discounted future FCF values:

DCF = 317 + 321 + 325 + 330 + 334 + 333 + 328 + 317 + 6533 = $9,138 (million)

As of market close May 10, Washington Post's market cap is $7.93 billion, a 13% discount to our DCF value ($9.1 billion). With such a limited margin of safety, Buffett would not consider this a new investment opportunity.

Major flaw: Sensitivity to variations
The DCF model is very sensitive to inputs -- that's why we treat assumptions so conservatively. The following table shows you how variations affect the DCF valuation for Washington Post.

Expected return Growth rate DCF value Margin of safety**
8% 9.4% $9.14 B 13%
8% 12.7% $10.9 B 27%
5% 9.4% $23.4 B 66%
5% 12.7% $28.2 B 72%


More examples
The calculations below use the same expected return and future growth assumptions we used above (8% required return and growth declining to 3% by year nine). For simplicity, we use the analysts' five-year estimates for our expected growth value (from the Yahoo! Finance "Analyst Estimates" stock page):

Company Est. growth (5 years) FCF* (current) DCF value* Market Cap* Margin of safety**
Apple (Nasdaq: AAPL  ) 20% 250 12.7 30.01 -136%
Microsoft (Nasdaq: MSFT  ) 10% 8,245 249 269 -8%
Johnson & Johnson (NYSE: JNJ  ) 11% 8,458 269 201 25%
ITT Educational (NYSE: ESI  ) 20% 58.0 2.95 2.01 31%
Bed Bath & Beyond (Nasdaq: BBBY  ) 20% 372 18.9 11.1 41%
KSwiss (Nasdaq: KSWS  ) 13% 71.5 2.53 1.12 56%
*FCF in $millions. DCF and market cap values are in $billions. Market cap values are as of market close 5/10.
**All margin of safety numbers are calculated as a percentage of DCF values. In short, margin of safety calculations have DCF values in the denominator.


(Note: The DCF performed on Washington Post and those that follow are calculated according to the most recent annual figures available.)

A few key conclusions:

1. Generally, popular companies (like Apple) are too heavily followed to present compelling values.

2. Companies with inconsistent or incomplete operating histories often have extreme valuations when subjected to the DCF model and are sometimes not well-suited for this sort of valuation.

3. The most attractive opportunities are often established businesses with straightforward business principles.

For more:

Whisper rumors on Wall Street are that Inside Value newsletter writers studied under the watchful eye of Warren Buffett. OK, that might be a stretch, but if you're seeking value-oriented investments, take a free trial.

Fool contributor Jim Schoettler appreciates your feedback. Jim does not own any of the stocks discussed in this article.


Read/Post Comments (1) | Recommend This Article (25)

Comments from our Foolish Readers

Help us keep this a respectfully Foolish area! This is a place for our readers to discuss, debate, and learn more about the Foolish investing topic you read about above. Help us keep it clean and safe. If you believe a comment is abusive or otherwise violates our Fool's Rules, please report it via the Report this Comment Report this Comment icon found on every comment.

  • Report this Comment On February 23, 2010, at 4:58 PM, jhodges72 wrote:

    Your article misses one very important part to calculating owner earnings. Buffett made adjustments for items that did not require cash. For example: Impairment charges require no physical outlay of cash, yet they often times have a tremendous impact on reported earnings. Therefore, Buffett makes the necessary adjustment of these items so that they don't impact the transaction of cash that the business is experiencing.

    Revenue: $10 M

    Costs & Expenses: $5 M

    Impairment (non-cash) $5 M

    = Net Income: $0 M

    In this example, earnings equal $0 even though the impairment charge required no physical exchange of cash. Therefore, Buffett removes this item from the equation (found on the balance sheet) and the resulting Net Income would be $5 M.

    Without this knowledge, an investor could potentially make a very big mistake in his investment rationale. Therefore, your article isn't complete without the adjustment to non-cash items of the balance sheet.

    Furthermore, Non-Operating cash items are also dismissed when determining owner earnings but that is another argument for another time.

Add your comment.

Sponsored Links

Leaked: Apple's Next Smart Device
(Warning, it may shock you)
The secret is out... experts are predicting 458 million of these types of devices will be sold per year. 1 hyper-growth company stands to rake in maximum profit - and it's NOT Apple. Show me Apple's new smart gizmo!

DocumentId: 495530, ~/Articles/ArticleHandler.aspx, 12/18/2014 11:27:50 AM

Report This Comment

Use this area to report a comment that you believe is in violation of the community guidelines. Our team will review the entry and take any appropriate action.

Sending report...


Advertisement