GURUFOCUS.COM » STOCK LIST » Technology » Software » Qlik Technologies Inc (NAS:QLIK) » Definitions » Earnings Power Value (EPV)

Qlik Technologies (Qlik Technologies) Earnings Power Value (EPV) : $27.53 (As of Jun16)


View and export this data going back to 2010. Start your Free Trial

What is Qlik Technologies Earnings Power Value (EPV)?

As of Jun16, Qlik Technologies's earnings power value is $27.53. *

* GuruFocus does not store EPV value into our database if Average Maintenance CAPEX is 0.

Margin of Safety is N/A.

The basic concept of EPV is that one should value a stock based on the current free cash flow of a company and not on future projections which may, or may not, come true. It is arguably a better way to analyze stocks than Discounted Cash Flow analysis that relies on highly speculative growth assumptions many years into the future. Assumption: Current profitability is sustainable.


Qlik Technologies Earnings Power Value (EPV) Historical Data

The historical data trend for Qlik Technologies's Earnings Power Value (EPV) can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Qlik Technologies Earnings Power Value (EPV) Chart

Qlik Technologies Annual Data
Trend Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15
Earnings Power Value (EPV)
Get a 7-Day Free Trial - - 7.51 9.17 10.04

Qlik Technologies Quarterly Data
Sep11 Dec11 Mar12 Jun12 Sep12 Dec12 Mar13 Jun13 Sep13 Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16
Earnings Power Value (EPV) Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 9.86 9.69 10.04 10.62 27.53

Competitive Comparison of Qlik Technologies's Earnings Power Value (EPV)

For the Software - Infrastructure subindustry, Qlik Technologies's Earnings Power Value (EPV), along with its competitors' market caps and Earnings Power Value (EPV) data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


Qlik Technologies's Earnings Power Value (EPV) Distribution in the Software Industry

For the Software industry and Technology sector, Qlik Technologies's Earnings Power Value (EPV) distribution charts can be found below:

* The bar in red indicates where Qlik Technologies's Earnings Power Value (EPV) falls into.



Qlik Technologies Earnings Power Value (EPV) Calculation

Earnings Power Value also known as just Earnings Power is a valuation technique popularised by Bruce Greenwald, an authority on value investing at Columbia University. It is arguably a better way to analyze stocks than Discounted Cash Flow analysis that relies on highly speculative growth assumptions many years into the future.

The basic concept of EPV is that one should value a stock based on the current free cash flow of a company and not on future projections which may, or may not, come true. This valuation tool excludes the potential growth that a company may have so that needs to be looked at separately. Since future growth is excluded from the analysis, only the maintenance capital expenditures are subtracted from after-tax EBIT (earnings before interest and taxes) and growth capex is ignored.

Qlik Technologies's "Earning Power" Calculation:

Average of Last 20 Quarters Last Quarter
Revenue 506.1
DDA 10.2
Operating Margin % -1.51
SGA * 25% 94.3
Tax Rate % -148.47
Maintenance Capex 8.7
Cash and Cash Equivalents 381.9
Short-Term Debt 0.0
Long-Term Debt 0.0
Shares Outstanding (Diluted) 94.2

1. Start with "Earnings" not including accounting adjustments (one-time charges not excluded unless policy has changed). "Earnings" are "Operating Income.

2. Look at average margins over a business/Industry cycle: Average Operating Margin = -1.51%

To normalize margins and eliminate the effects on profitability of valuing the firm at different points in the business cycle, it is usually best to take a long-term average of operating margins. Ideally this would be as long as 10 years and include at least one economic downturn. However, since most of companies do not have as long as 10-year history, here GuruFocus uses the latest 5 years data to do the calculation. To smooth out unusual years but reflect recent developments, we take an average of the 5 year margin.

3. Multiply average margins by sustainable revenues and then adjust for maintenance SGA. This yields "normalized" EBIT:

To be conservative, GuruFocus uses an average of the 5 year revenues as the sustainable revenue.
EPV analysis recognises that part of SG&A expenditure is made to maintain and replace the existing assets, while part is made to grow sales. Since EPV is only interested in what it costs a going concern to maintain its existing asset base, it adds back a percentage of SG&A (between 15% and 50% - this is a matter of judgment and industry knowledge) to make up for the fact that some of this expenditure went to fund growth and shouldn't be accounted for. To start off, we assume 25% for the sake of prudence.
Sustainable Revenue = $506.1 Mil, Average Operating Margin = -1.51%, Average Adjusted SGA = 94.3,
therefore "Normalized" EBIT = Sustainable Revenue * Average Operating Margin + Average Adjusted SGA = 506.1 * -1.51% +94.3 = $86.704817772 Mil.

4. Multiply by one minus Average Tax Rate (NOPAT):

Same as average operating margin calculation, GuruFocus takes an average of the 5 years tax rates.
Average Tax Rate = -148.47%, and "Normalized" EBIT = $86.704817772 Mil,
therefore After-tax "Normalized" EBIT = "Normalized" EBIT * ( 1 - Average Tax Rate ) = 86.704817772 * ( 1 - -148.47% ) = $215.43719481444 Mil.

5. Add back Excess Depreciation (after tax at 1/2 average tax rate). This yields "normalized" Earnings:

Excess Depreciation = Average DDA * % of Excess Depreciation (after tax at 1/2 average tax rate) = 10.2 * 0.5 * -148.47% = $-7.568805616 Mil.
"Normalized" Earnings = After-tax "Normalized" EBIT + Excess Depreciation = 215.43719481444 + -7.568805616 = $207.86838919844 Mil.

6. Adjusted for Maintenance Capital Expenditure:

First, calculate the revenue change regarding to the previous year. If the revenue decreased from the previous year, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
Second, if the revenue increased from the previous year, then calculate the percentage of Net PPE as of corresponding Revenue.
Third, calculate Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was negative, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was positive, then the Maintenance Capital Expenditure = Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
Fourth, GuruFocus uses an average of the 5 year maintenance capital expenditures as maintenance CAPEX.
Qlik Technologies's Average Maintenance CAPEX = $8.7 Mil *.
* GuruFocus does not store EPV value into our database if Average Maintenance CAPEX is 0.

7. Investors require a return of "WACC" for the risk they are taking: WACC = 9%

8. Qlik Technologies's current cash and cash equivalent = $381.9 Mil.
Qlik Technologies's current interest bearing debt = Long-Term Debt & Capital Lease Obligation + Short-Term Debt & Capital Lease Obligation = 0.0 + 0.0 = $0 Mil.
Qlik Technologies's current Shares Outstanding (Diluted Average) = 94.2 Mil.

Qlik Technologies's Earnings Power Value (EPV) for Jun16 is calculated as:

EPV = ( ( Norm. Earnings-Maint. CAPEX *) / WACC + CashandEquiv - Int. Bearing Debt ) / Shares Outstanding (Diluted Average)
= ( ( 207.86838919844 - 8.7)/ 9%+381.9-0 )/94.2
=27.53

Margin of Safety (EPV)=( Earnings Power Value (EPV)-Current Price )/Earnings Power Value (EPV)
=( 27.52746820949-30.50 )/27.52746820949
= -10.8%

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* GuruFocus does not store EPV value into our database if Average Maintenance CAPEX is 0.


Qlik Technologies  (NAS:QLIK) Earnings Power Value (EPV) Explanation

Assumption: Current profitability is sustainable.

Earnings power value (EPV) uses a very basic equation which assumes no growth, although it does rely on an assumption about the cost of capital as well as the fact that current earnings are sustainable. It also involves several adjustments to clean up the underlying Earnings figures.


Be Aware

Though using today's earnings in calculating Earnings Power Value, GuruFocus is normalizing these earnings to the business cycle. This eliminates the effects on profitability of valuing the firm at different points in the business cycle. This means that we are considering the average earnings over 5 years.


Qlik Technologies Earnings Power Value (EPV) Related Terms

Thank you for viewing the detailed overview of Qlik Technologies's Earnings Power Value (EPV) provided by GuruFocus.com. Please click on the following links to see related term pages.


Qlik Technologies (Qlik Technologies) Business Description

Traded in Other Exchanges
N/A
Address
Qlik Technologies Inc was founded in Sweden in 1993. It solves problems for organizations of all sizes, including the enterprises. The Company is a user-driven Business Intelligence solution that enables its customers to make robust and faster business decisions. The Qlikview Business Discovery platform, or QlikView, helps people create and share insights and analysis in groups and across organizations. Business users can explore data, ask and answer their own stream of questions and follow their own path to insight on their own and in teams and groups. The QlikView is powered by its in-memory engine which maintains associations in data and calculates aggregations as needed. The Company operates in one business segment, namely, the development, commercialization and implementation of software products and related services. It offers solution from middle market customers to large enterprises such as Autodesk, The Dannon Company, Inc., Heidelberger Druckmaschinen AG, Hertz, ING, Kraft Foods, L'Oreal, Lifetime Brands, Lockton Insurance, National Health Service (NHS), Panasonic, Qualcomm, Sony Europe, Symantec, U.S. Department of Veterans Affairs and Volvo Car UK Limited. Its products include: QlikView, QlikView Expressor and QlikView.Next. Its customers can renew, and generally have renewed, their maintenance agreements for a fee that is based upon a percentage of the initial license fee paid. Company market and sell its products and services through its direct sales force and an indirect sales channel comprised of partner network. The Company competes with large software corporations, including suppliers of enterprise resource planning software, that provide one or more capabilities competitive with its products, such as IBM, Microsoft, Oracle and SAP AG.
Executives
Timothy J Maccarrick officer: CFO C/O QLIK TECHNOLOGIES INC.,, 150 N. RADNOR CHESTER ROAD, RADNOR PA 19087
Deborah C Hopkins director 1007 MARKET ST, WILMINGTON DE 19898
Bruce Golden director 428 UNIVERSITY AVE, PALO ALTO CA 94301
Diane Adams officer: Chief People Officer 222 MERCHANDISE MART PLAZA, SUITE 2024, CHICAGO IL 60654
Steffan Tomlinson director PALO ALTO NETWORKS, INC., 3300 OLCOTT STREET, SANTA CLARA CA 95054
Gavin John J Jr director
John C Burris director 851 WEST CYPRESS CREEK ROAD, FORT LAUDERDALE FL 33309
Erel N Margalit director 41 MADISON AVENUE 25TH FLOOR, NEW YORK NY 10010
Jerusalem Partners Iv Lp 10 percent owner C/O JVP CONSULTING INC, 41 MADISON AVE 25TH FL, NEW YORK NY 10010
Jerusalem Venture Partners Iv A Lp 10 percent owner C/O JVP CONSULTING INC, 41 MADISON AVE 25TH FL, NEW YORK NY 10010
Jerusalem Venture Partners Iv Israel Lp 10 percent owner JERUSALEM TECHNOLOGY PARK, BUILDING 1, MALHA, JERUSALEM L3 91487
Jerusalem Partners Iv - Venture Capital Lp 10 percent owner JERUSALEM TECHNOLOGY PARK, BUILDING 1, MALHA, JERUSALEM L3 91487
Jerusalem Venture Partners Entrepreneurs Fund Iv Lp 10 percent owner C/O JVP CONSULTING INC, 41 MADISON AVE 25TH FL, NEW YORK NY 10010
Jvp Corp Iv 10 percent owner C/O ALEXANDRIA BANCORP LTD, P.O. BOX 2428 GT, GRAND CAYMAN E9 00000
Jerusalem Venture Partners Iv Lp 10 percent owner C/O JVP CONSULTING INC, 41 MADISON AVE 25TH FLOOR, NEW YORK NY 10010

Qlik Technologies (Qlik Technologies) Headlines

From GuruFocus

Paul Singer Purchases Stake in Qlik Technologies

By Kyle Ferguson Kyle Ferguson 06-03-2016

Big Data Firms Struggle as They Trade on Fundamentals

By Ryan Foster Ryan Foster 02-12-2016