Switch to:
GuruFocus has detected 4 Warning Signs with Capella Education Co \$CPLA.
More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.
Capella Education Co (NAS:CPLA)
Intrinsic Value: Projected FCF
\$52.91 (As of Today)

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value: DCF (FCF Based), or Discounted Earnings Intrinsic Value: DCF (Earnings Based) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Free Cash Flow and Book Value of the company. The details of how we calculate the intrinsic value of stocks are described in detail here.

As of today, Capella Education Co's projected FCF intrinsic value is \$52.91. The stock price of Capella Education Co is \$97.00. Therefore, Capella Education Co's Price to Intrinsic Value: Projected FCF Ratio of today is 0.0.

During the past 13 years, the highest Price to Intrinsic Value: Projected FCF Ratio of Capella Education Co was 4.23. The lowest was 0.00. And the median was 0.98.

Definition

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value: DCF (FCF Based), or Discounted Earnings Intrinsic Value: DCF (Earnings Based) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Free Cash Flow and Book Value of the company.

The details of how we calculate the intrinsic value of stocks are described in detail here.

This method smooths out the free cash flow over the past 6-7 years, multiplies the results by a growth multiple, and adds a portion of total equity.

Value = ((Growth Multiple)*Free Cash Flow(6 year avg) + 0.8*Total Equity(most recent))/Shares Outstanding

In the case of negative total equity, the following formula is used (see the Total Equity section for the reason):

Value = ((Growth Multiple)*Free Cash Flow(6 year avg) + Total Equity(most recent)/0.8)/Shares Outstanding

Here Capella Education Co's FCF(6 year avg) is calculate as

Capella Education Co Quarterly Data

 201412 201503 201506 201509 201512 201603 201606 201609 201612 201703 total_freecashflow 13.2 12.5 16.3 6.6 4.5 16.7 15.7 26.9 2.1 10.5 201206 201209 201212 201303 201306 201309 201312 201403 201406 201409 total_freecashflow 9.7 6.8 10.8 12.5 18.7 7.1 12.2 9.6 13.4 8.7 201106 201109 201112 201203 total_freecashflow 13.5 3.6 15 14.3

Add all the Free Cash Flow together and divide 6 will get Capella Education Co's FCF(6 year avg) = \$46.83.

Capella Education Co's Intrinsic Value: Projected FCF for today is calculated as

 Intrinsic Value = (Growth Multiple * Free Cash Flow(6 year avg) + Total Equity(Mar17) * 0.8) / Shares Outstanding = (9.78491808671 * 46.8328333333 + 216.568 * 0.8) / 11.936 = 52.91

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Explanation

The growth multiple is capped between 8.35 and 17.74.

Total equity weighting is more art than science and it should always be revisited in more detail when researching a company. Weightings from 0% to 100% to more than 100% are possible. 80% was chosen as a happy medium after taking the above ideas into consideration. Learn more here.

Capella Education Co's Price to Intrinsic Value: Projected FCF Ratio for today is calculated as

 Price to Intrinsic Value: Projected FCF = Share Price / Intrinsic Value: Projected FCF = 97.00 / 52.9079958056 = 1.83

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Related Terms

Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Capella Education Co Annual Data

 Dec07 Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15 Dec16 Projected FCF 0.00 0.00 23.89 32.52 43.25 57.81 68.54 64.35 53.02 53.81

Capella Education Co Quarterly Data

 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Projected FCF 64.35 60.09 59.31 55.30 53.02 52.72 53.95 56.75 53.81 52.91
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to \$400 per referral. ( Learn More)