Bruce Greenwald Earnings Power Value EPV lecture slides article about the methods discussed in his book Value Investing: From Graham to. You will also learn how to calculate EPV in Excel. A Columbia University Professor Bruce Greenwald developed this approach. In this article. Columbia business school. Bruce Greenwald’s lecture slides on EPV. by Old_School_Value in Types > Business/Law > Finance, epv, and greenwald.

Author: Kat Samutaur
Country: Dominica
Language: English (Spanish)
Genre: Travel
Published (Last): 27 February 2014
Pages: 135
PDF File Size: 1.87 Mb
ePub File Size: 1.99 Mb
ISBN: 900-6-94544-164-2
Downloads: 46371
Price: Free* [*Free Regsitration Required]
Uploader: Neramar

At the mid-point, the model use the median over last five years. I didn’t see anything unusual in Apple’s earnings so I used the numbers as reported.

Earnings Power Value Spreadsheet Using MarketXLS

Second, if the revenue increased from the previous year, then calculate the percentage of Net PPE as of greenwald Revenue. The model then applied the margin assumptions I selected in previous steps and computed the following schedule for Adjusted Earnings:. Old School Value is a suite of value investing tools designed to fatten your portfolio by identifying what stocks to buy and sell.

Value E;v Pro bruxe September 21, at 9: Its moat, which, in the end, is still a subjective topic and one that I know you are well aware of. The company will need to continue paying a portion of it’s profits to the governments in the countries it operates.

The EPV assumes that all the capital is equity capital; it ignores both interest paid on debt and interest received on cash.

To greenald second point. Remember that with reproduction value, you are not necessarily adding the full value. To smooth out unusual years but reflect recent developments, we take an average of the 5 year margins.


Subtract Maintenance Capital Expenditure The next step is to deduct the maintenance capex which reflects the economic depreciation.

Earnings Power Value (EPV) Spreadsheet Using MarketXLS (Template Included)

Non interest bearing debt is really spontaneous liabilities. To estimate the portion of income the company will need to forfeit in taxes, historical effective tax rates can be useful for guidance: Note that there are no hard brue for arriving at the EPV or reproduction value.

While there are many methods to arrive at the intrinsic value of the stock for value investing, one approach is the Grwenwald Power Value, or EPV. Taking into account the business cycle and other transient effects.

Just different numbers maybe. As a company operates, it’s gresnwald, office space, and property start to wear down. I would argue that Greenwald doesnt like DCF because it requires forward looking assumptions while his assumptions on reproducing book value and goodwill are present based. I reviewed your new spreadsheets.

Earnings Power Value is a specific formula: When you do all those steps, you finally come up with an Income as Adjusted number.

February 26, at 7: Ideally this geeenwald be as long as 10 years and include at least one economic downturn. March 18, at September 19, at 9: The models on finbox. The information on this site, and in its related application software, spreadsheets, blog, email and newsletters, is not intended to be, nor does it greenald, investment advice or recommendations. As you can see in spreadsheet, the EPV per share of Microsoft stock is much lower than its market value.

New Feature Announcement: Earnings Power Value –

What I do, along with all of the other valuation techniques, I smooth out the e;v by taking multiple year snapshots and then taking the median of these timeframes. February 27, at 5: Though it provoked me a cognitive dissonance. Each analyst will come up with a different valuation based on their understanding of the financial statements and the business. Something else to remember is that although off balance sheet liabilities are liabilities, a significant part of that will also have to be reproduced by a new entrant in order to start business.


Wal-Mart Stores Inc’s current as of Oct. Under no circumstances does any information posted on OldSchoolValue. Maintenance capex is calculated completely separately. March 4, at greenwxld When looking at step 1: To account for this normal wear and tear, we need to bruuce how much the company will need to spend on capital expenditures CapEx to maintain it’s current level of earnings going forward.

Bruce Greenwald’s Earnings Power Value EPV lecture slides

This valuation tool excludes the potential growth that a company may have so that needs ggeenwald be looked at separately. However, it may undervalue the growth companies. Some companies will spend very little for both aspects and it can be ignored but to ignore for MSFT would be a mistake. September 22, at Since capital expenditures CapEx reduce company value, finbox.

Buce me crazy, but our dream is to one day sponsor 1, children around the world. Finding the adjusted earnings can be difficult.