The emails for this class will be collected in this file. Have fun with them!
|Date||Email sent out|
1. Preclass work: I know that some of you are worried about the class but relax! If you can add, subtract, divide and multiply, you are pretty much home free... If you want to get a jump on the class, you can go to the class web site
2. Syllabus & Calendar: The syllabus for the class is available on the website for the class and there is a google calendar for the class that you can get to by clicking on
3. Lecture notes: The first set of lecture notes for the class should be available in the bookstore by the start of next week. If you want to save some money, they can also be printed off online (if you want to save some paper, you can print two slides per page and double sided). To get to the lecture notes, you can try
4. Delivery choices: I hope to see you all in class for every session, but there are two supporting delivery mechanisms that I would like you to take advantage of:
5. Books for the class: The best book for the class is the Investment Valuation book - the third edition. (If you already have the second edition, don't waste your money. It should work...) You can get it at Amazon or wait and get it at the book store... If you are the law-abiding type, you can buy "Damodaran on Valuation" - make sure that you are getting the second edition. If you can get the Asian edition, even better. It is exactly the same book and costs about a third. Or, as a third choice, you can try The Dark Side of Valuation, again the second edition, if you are interested in hard to value companies.. Or if you are budget and time constrained, try "The Little Book of Valuation". http://www.stern.nyu.edu/~adamodar/New_Home_Page/public.htm
6. Valuation apps: One final note. I worked with Anant Sundaram (at Dartmouth) isn developing a valuation app for the iPad or iPhone that you can download on the iTunes store: http://itunes.apple.com/us/app/uvalue/id440046276?mt=8
|1/31/14||Just a couple of quick notes leading into next week's class. First, please make sure that you got my email from last week. If you joined the class this week or just don't read class related emails during your break, you can find the entire email by going to
Second, please do accept the invite to the class on Lore that I sent you on Sunday. If you have no idea what I am talking about, just email me and I will send you a private invitation.
Third, visit the website for the class and check out the Google calendar to make sure that you don't have any quiz conflicts:
Finally, we don't have to wait until next week to start talking about valuation, right? So, what do you think about the market meltdown in the last couple of weeks. Is this just a long-overdue mild correction or the beginning of something bigger? How can you tell? Big questions, but well worth answering! Until next time!
First, a quick note about today's class. During the session, I made clear that this was a class about valuation in all of its many forms – different approaches (intrinsic, relative & contingent claim), different forums (for acquisitions, value enhancement, investing) and across different types of businesses (private & public, small and large, developed & emerging market). After spending some time laying out the script for the class (quizzes, exams, weekly tortures), I started on the first packet (intro to valuation) by giving you my reasons for doing valuation (to fight looming lemingitis) and starting on the discussion of widely held misconceptions about valuations.
With that out of the way, have you classified yourself yet? Are you a proud lemming, a "Yogi bear" lemming or a lemming with a life-vest? While you are pondering that life-changing question, I do have some points to make:
2. Once you pick a company, collect information on the company. I would start off on the company's own website and download the annual report for the most recent year (probably 2012) and then visit the SEC website (http://www.sec.gov) (for US listings) and download 10Q filings...
3. The web cast for the first class will be up in all three forums (website, iTunes U and Lore), when I get the links (should be in a couple of hours). You can access it by going to:
4. Post class test: To review what we did in class today, I prepared a very simple post-class test. I have attached it, with the solution. Give it your best shot!
If you did not get the syllabus, project description and the valuation intro in class this morning, they are all available to print off from the webcast page.
Just to restate what I said in class today, you can pick any publicly traded company anywhere in the world to value. The non-US company that you value can have ADRs (but does not have to have ADRs) listed in the US but you still have to value it in the local currency and local market. You can even analyze a private company, if you can take responsibility for collecting the information. Until next time!
I am still waiting on the webcasts of yesterday's classes as technology rears its ugly side. I do have the valuation of the week ready to go. It is of Vale, the Brazil-based mining company. It is best to start with the background and financials, which you can find here:
I know that this is close to class time, but we will start today's class with this test. If you get a chance, browse through the page and form your conclusions. We will talk about it at the start of class. Still no webcasts links from Monday (and I am sorry), but I will see you in a little while. Until next time!
Attachment: Valuation bias: A test
Thank you for braving the elements and coming to class. Today's class started with a test on whether you can detect the direction bias will take, based on who or why a valuation is done. The solutions are posted online. We then moved on to talk about the three basic approaches to valuation: discounted cash flow valuation, where you estimate the intrinsic value of an asset, relative valuation, where you value an asset based on the pricing of similar assets and option pricing valuation, where you apply option pricing to value businesses. With each approach, we talked about the types of assets that are best priced with that approach and what you need to bring as an analyst/investor to the table. For instance, in our discussion of DCF valuation and how to make it work for you, I suggested that there were two requirements: a long time horizon and the capacity to act as the catalyst for market correction. Since I mentioned Carl Icahn and Bill Ackman as hostile acquirers (catalysts), you may want to look at Herbalife, the company that Ackman has targeted as being over valued and Icahn did for being under valued. See if you can get a list going of how he is trying to be the catalyst for the correction... and think about the dark side of this process.
As I mentioned in class on opening day (I like baseball analogies), Thursday is the project update day. Since this is the first week, there is really not much to update, but here is where you should be by the end of the week:
Finally, on the webcasts, this week has been a disaster so far and I am really sorry. I am still waiting for the reprocessed videos. If you are looking to catch up (especially yesterday's class), you can try the first two webcasts from last semester:
I know! I know! Friday is supposed to be your day of rest, but I decided to break that rule. (If you make the rules, you can change them). I know that many of you still pondering your company choices and group dynamics, but if and when you pick a company, the first step is to get the raw material you need for your valuation. These include data on the company (annual reports, regulatory filings like the 10K/10Q), sector wide data (numbers for other companies in your sector) and macro economic data. I know that many of you already know exactly how to do this. However, if you feel uncertain, you can try this webcast out.
On a different note, a couple of reminders of notes that I have already sent out. First, the valuation of the week (Vale) and the shared google spreadsheet await you. You can find the full details on the webcast page for the class:
I will keep this email short, but the newsletter for the week is attached. If you get a chance, please browse through it. There really is not much news there, but the format will stay the same and it will give you a roadmap for the class (both of where we have been already and where we plan to go). One more additional news item. The second session's webcast has finally been posted (on the webcast page for the class (http://www.stern.nyu.edu/~adamodar/New_Home_Page/webcasteqspr14.htm), iTunes U and Lore). If you missed the class, please watch the webcast before Monday's class. Until next time!
Attachment: Newsletter #1
|2/9/14||If you have not tried out the weekly challenge yet, it is still open:
Once you have a solution, you can post it on Lore (http://www.lore.com). Check for the weekly challenge #1 under calendar.
I will post my solution later today. Until next time!
I hope that you had a chance to try the first weekly challenge. If you did, you can check your solution against mine. Even if you did not, you can try the challenge now (or in the near future) and check out the solution. In fact, we will be starting off tomorrow's class with the question of firm versus equity valuation. I am attaching the cash flow table that we will be using for the start-of-the-class test as well. If you get a chance, please take a look at it before you come into class. Until next time!
Attachments: Weekly challenge solution
mean that a valuation follows first principles. After setting the table for the key inputs that drive value - cash flows, growth, risk, we looked at the process for estimating the cost of equity in a valuation. The key concept is that of a "marginal" investor, who is diversified and looking at risk through that investor's eyes. We spent the rest of the session talking about what should be (but no longer is) the simplest input into the process: the risk free rate.
I have a paper on riskfree rates that elaborates on the discussion in class today. It is really not a painful read, if you can spare the time. You can get to it by going to:
The topic seems to have acquired some followers among appraisers/analysts. This article provides a reasonable synopsis of where they stand:
If you have been following markets for the last few weeks (and you should be), you probably read about Twitter's earnings report last week, where the company beat expectations (on revenues and income) but saw its stock price collapse by 25% because its user base did not grow fast enough. Given the price drop, is it time to buy Twitter now? Well, that is the question that I am trying to answer (hopefully with your help) this week. Start with the blog post I just put up on my valuation:
Please don't be intimidated. You can value Twitter and you should feel free to disagree with me. Go through the spreadsheet and make the changes that you feel are necessary and then post your valuation on the Google shared spreadsheet:
I got this email from OCD about Capital IQ. For those of you who are wondering, Capital ?, this is an insanely good database of global companies with data on everything from accounting to market to corporate governance data. If you have never used it, you should try it and you will probably find it helps a great deal in your projects. To be able to use it, though, it looks like you have to jump through a few hoops. Please try to do so, because the payoff is big.
Begin forwarded message:
From: Kathi To <email@example.com>
If you are planning to have your MBA students use Capital IQ this semester, please be advised that the enrollment period for the spring semester is from February 3rd to February 28th. They can enroll by filling out the Capital IQ form on their Career Account www.stern.nyu.edu/careeraccount. Please note that if students will need Capital IQ for projects later on in the semester, they will need to request access during this official enrollment period at the beginning of the semester. Also, if they had an account last semester, they will still need to request an account for this semester if they need one because last semester's accounts will expire this month.
For non-MBA Stern students, there are 10 Capital IQ terminals on campus that don’t require a Capital IQ account. They are located in the undergrad lab (L-100) and on the fifth floor graduate student computers near the Office of Career Development.
If you have any questions about the process or Capital IQ access in general, please feel free to contact Amanda Hower (firstname.lastname@example.org) or Kathi To (email@example.com) in the Office of Career Development.
Leonard N. Stern School of Business
We are little more than halfway through the discussion of equity risk premiums but the contours of the discussion should be clear.
b. Country risk premium: The last few months should be a reminder of why country risk is not diversifiable. As you see markets are volatile around the world, I think you have a rationale for a country risk premium. You can get default spreads for country bonds on my site under updated data. If you are interested in assessing and measuring country risk, to get from default spreads to equity risk premiums, you need two more numbers. The first is the standard deviation for the equity market in the country that you are trying to estimate the premium for. Try the Bloomberg terminal. Find the equity index for the country in question (Bovespa for Brazil, Merval for Argentina etc.) and type in HVT. This should give you the annualized standard deviation in the index - change the default to weekly and use the 100-week standard deviation. Do the same for the country bond in question. The two standard deviations should yield the relative volatility. If you have trouble finding either number, just multiply the default spread by 1.5 to get a rough measure of the country risk premium.
c. Company risk exposure to country risk: My concept of lambdas for countries is a work in progress. I have a paper on the topic that you can read, if you are so inclined:
d. Implied equity risk premiums: I know that we barely touched this concept in class today, but its is not rocket science and I am sure that you can work with it. I am attaching the excel spreadsheet that will allow you to compute implied equity risk premiums. I am using the numbers that I used at the start of February to come up with an equity risk premium of 5.17%.
Please try to update the implied premium, using today's numbers for the S&P 500 (easy) and the 10-year T.Bond rate (easy). Leave everything else untouched including growth rate in earnings for next five years & updated dividends and buybacks from the spreadsheet (since these were updated a month ago). Follow the instructions to get the updated equity risk premium. We will explore it further in class a week from today (since there is no class on Monday).
The post class test and solution are attached. Until next time!
Once you have a risk free rate, here are your next few steps:
Finally, I hope you have had a chance of updating the implied equity risk premium spreadsheet that I sent you with Wednesday's email. All you have to do is update the S&P 500 and the US treasury bond rate and use the goal seek (instructions on spreadsheet). Until next time!
As you get ready for the long weekend, a couple of quick notes:
2. Implied ERP: In case you have a chance to try out the implied ERP spreadsheet (attached again to this email), I put together a short webcast (20 minutes) on both the mechanics of the implied ERP (using the February 2013 version of the spreadsheet) and how I get the numbers for the spreadsheet. I hope you get a chance to look at the webcast (and any feedback on making these webcasts more useful will be appreciated):
If you are reading the news (not just the sports news), I am sure that you have seen the Comcast/TWC story. Since it involves everything that we talk about in this class (valuation, bias, pricing, synergy etc.), it will be worth following as it unfolds. Until next time!
Attachments: Implied ERP for February 2014
Last week, we put the basics of valuation behind us and started on the nuts and bolts. In particular, we spent Monday talking about how to estimate risk free rates in different currencies and why they may be different. On Wednesday, we looked at equity risk premiums, talked about why historical risk premiums may be flawed and how to estimate equity risk premiums in other markets. Next week, we will have only one session and will examine a different way of thinking about equity risk premiums and also talk about alternatives to measuring the relative risk in a stock. I know that this is a long weekend and I hope you have fun. However, please do find a group, pick a company, estimate a risk free rate in the currency of your choice and start thinking about the ERP for your company. ( What a fun sucker? I know.. I know.. That is what my kids call me to...) Until next time!
Attachment: Newsletter #2
I will keep this short. The solution to the second weekly challenge is attached, with the challenge. If you did not get a chance to do it, you can still try it. Next week is going to be a short one, since we have no class tomorrow. On Tuesday, I will still put up my valuation of the week and on Wednesday, we will look at how to estimate implied equity risk premiums and estimating the relative risk of a company. If you have picked a company, try to find a beta for your company from a service and bring it to class with you. Other than that, not much more to do. Have a wonderful rest of the weekend. Until next time!
I hope that you had a productive weekend (or at least a fun one). Well, it is time to get back to work and to celebrate, I just posted my assessment of the Comcast/TWC deal. You can begin by reading the news story of the deal:
Attachments: TMC/Comcast Synergy valuation
By now, you are probably tired of equity risk premiums and I don't blame you. Today's session, though, was all about implied equity risk premiums and what causes them to change over time. Other things remaining equal, higher stock prices, higher cash flows and higher expected growth all push up the ERP, whereas a higher riskfree rate pushed the ERP down. If you get a chance, please play with the equity risk premium spreadsheet to check for yourself.
If after all of this, you still want to read more about equity risk premiums, here is the link to my magnum opus (or something opus), the annual update I do on equity risk premiums:
|2/20/14||In the meantime, though, I thought it would make sense to do stop and look back, even though it has been only two weeks in the class. Here is what we have done:
Lectures: We are four sessions into the class, about 15% of the overall class. I know that most of you have been in class, but just in case, you have missed a session, please do try to watch the webcast of the session. You can get them in one of three places: (a) the webcast page for the class ( http://www.stern.nyu.edu/~adamodar/New_Home_Page/webcasteqspr14.htm), (b) the Lore page for the class, if you are enrolled in the class and (c) iTunes U (if you have the app and added the class). We have covered the Introduction to valuation lecture note packet and Lecture note packet 1 (Pages 1-84).
Pre-class and Post-class tests: As you probably know by now (unless you habitually come in five minutes after each class starts), we spend the first 5 minutes of each class on a start of the class test. At the end of each class, I also put up a post-class test and solution (which should take only a few minutes to work through) and relate back to the topics covered during class. If you have not tried these or were unaware that they existed, you can find them by going to:
Post class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session1test.pdf
Post class test solution: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session1soln.pdf
Start of the class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/tests/biastests.ppt
Post class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session2test.pdf
Post class test solution: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session2soln.pdf
Start of the class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/tests/kennecott.ppt
Post class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session3test.pdf
Post class test solution: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session3soln.pdf
Start of the class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/tests/risktest.ppt
Post class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session4test.pdf
Post class test solution: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session4soln.pdf
Start of the class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/tests/ERPtestspr14.xls
Post class test: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session5test.pdf
Post class solution: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/postclass/session5soln.pdf
Weekly Challenges: These are weekly exercises, ungraded and optional, designed to stretch what was learned during the week to the next level (sometimes, I succeed, sometimes, I do not). We have had two weekly challenges so far:
Weekly Challenge 1:
Weekly Challenge 2:
Weekly Challenge 3 (attached to this email, since I forgot to send it to you yesterday)
Data for challenge: http://www.stern.nyu.edu/~adamodar/pc/wkch/wkchdata.xls
Solution: Will be posted on Sunday
Valuation of the week: In keeping with my belief that you learn valuation by doing, not talking or reading, I will be putting up a valuation every week of the class. This too is optional and you are welcome to take my spreadsheet, change it to reflect your different assumptions and post it on a shared Google spreadsheet. We have had two so far:
Vale: Valuing a global mining company: http://www.stern.nyu.edu/~adamodar/pc/blog/Vale2014/ValeValuation2014.xls
Shared Google spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0Alt0SdORYnWadGVHOUlwWi03aUpvZEpNcFhnYXY2eGc&usp=sharing
Twitter: A post-earnings valuation: http://www.stern.nyu.edu/~adamodar/pc/blog/TwitterFeb2014.xls
Shared Google spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0Alt0SdORYnWadFZwWldiZVliRVZhNFVWWFNYMXo0S1E&usp=sharing
TSC/Comcast valuation: http://www.stern.nyu.edu/~adamodar/pc/blog/TWCComcast.xls
Shared Google spreadsheet: http://www.stern.nyu.edu/~adamodar/pc/blog/TWCComcast.xls
Group project: By now, you should be in a group and have picked a company. (If not, please let me know). Assuming that you have picked a company, you should also have pulled up the financials for the company. In fact, if you are really on top of things, you should also have a risk free rate in the local currency and an equity risk premium. One approach that we started on Wednesday was the implied ERP and I did post a webcast on how the model is constructed and can be used:
Valuation tools webcast #1: Getting Data for Valuation
Valuation tools webcast #2: Estimating an implied ERP
Readings: With all this stuff to do, who has time to read? If you do, and have one of my books, you should be looking at the introductory chapters (on the philosophy and big picture of valuation) and on the mechanics of estimating the risk free rate and equity risk premium (chapters 7 &8 in investment valuation, for instance).
As you can see, it has been a busy three weeks, but if you can still catch up. Each week that you put if off will be a harder climb. Good news... you have a weekend ahead of you... Bad news... there will be a valuation tools webcast .
Until next time!
If you have picked a company and collected the basic data (see last week's webcast), you probably more data in front of you then you want. In particular, those of you who have picked US companies have a 10K to read, in all of its bulk. Today's valuation tools webcast is about reading a 10K, with the intent of valuing a company. You can get the webcast by going to:
If you get done with this, the next step is to get a riskfree rate in whichever currency you are working in. I have a webcast (that you may or may not remember from Corporate Finance) on how to do this:
Two final quick notes. First, if you are having troubles with this class, please do come in and see me. If you are too intimidated to do so (Why? Am I that scary?), you should draw on Tomer Raved, who is the TA for this class. His contact details are below:
It is sunny and it is warm! I know that the latter is a relative statement, but then again life is full of relative judgments. Whatsapp is cheap at $42/user, relative to Facebook at $130/user. We know how much danger there is in going down that road, but it is so much fun to stroll down. Just in case you don't get enough of me in class and from the emails, here is the post that I had on the topic earlier this week:
Attachment: Newsletter #3
I hope you had a chance to try the weekly challenge. If you did, you probably found it more an exercise in statistics than valuation and that is good. Statistics is a vastly under used tool in valuation. On a different note, we will complete our discussion of bottom up betas and discount rates this week. If you can find a beta page for your company (on Bloomberg or elsewhere) and the business breakdown for your company, you can see the contrast between the regression and bottom up betas for yourself. Until next time!
Attachment: Weekly Challenge solution
Today's class represented the final pieces of the discount rate puzzle. We began with a continued discussion of bottom up betas, focusing on defining comparable firms and expanding the sample. I did make a big deal about bottom up betas, but may have still not convinced you or left you hazy about some of the details. If so, I thought it might be simpler to just send you a document that I put together on the top ten questions that you may have or get asked about bottom up betas. I think it covers pretty much all of the mechanics of the estimation process, but I am sure that I have missed a few things.
I am attaching the post class test and solution for today's class.
Tomorrow, we start on our discussion of earnings, with two adjustments for consistency, one for operating leases (converted them from operating to financial expenses) and the other for R&D (converting from operating to capital expenses). This week's valuation is of Starbucks, where leases play a key role. I have two valuations of Starbucks, one with leases treated conventionally (as operating expenses) and one with leases treated as debt.
You will notice that I get wildly different values per share, using the two views of leases (about $42 with leases treated as debt and >$60 with conventional lease treatment). The stock price is higher than both at $71. I have summarized the differences in inputs/outputs in the two valuations in the link below:
If you have no idea what I am talking about, when I mention capitalizing leases, you may want to read the following paper I have on the topic:
Once you get a chance to dip into the spreadsheets and change the numbers, please do go into the shared Google spreadsheet and post your answers:
Today's class looked at the getting the base year's earnings right and explored several issues:
With the quiz coming up next week, you have probably put the project on the back burner. But just in case you are working on it (and it is great preparation for your quiz), here is where you should be. You should obviously have a company picked and been able to estimate the different pieces that go into the cost of equity: a risk free rate in the currency of your choice, an equity risk premium reflecting where the company operates and a beta, reflecting the businesses it is in. For your debt, you should have a pre-tax cost of debt, based upon an actual or synthetic rating and converted this pre-tax cost of debt into an after-tax cost with a marginal tax rate. Finally, you should be able to use this pre-tax cost of debt, in conjunction with the book value of debt, interest expenses and the "weighted" maturity of the debt to convert the interest bearing debt into a market value.
I also promised you some readings on forensic accounting and I always deliver. Here are the Amazon links for forensic accounting:
I know you are busy doing other stuff, but as the discussion shifts from discount rates to cash flows, the details start mounting and it is easy to get lost in abstractions. If you are interested in getting past abstractions, I have put together three webcasts for this week:
They are all about 10-15 minutes each... and you can download the spreadsheets and supporting material by going to
Last week, we completed our discussion of discount rates and moved on to talking about cash flows. Lots of little details to trip you up, but if you are methodical and remember first principles, you will be okay. I am attaching this week's newsletter. And dont't forget to try the weekly challenge!
Attachment: Newsletter # 4 (March 1
Next week brings the quiz, with all the angst and stress that quizzes usually bring. Note that the quiz will be in the first 30 minutes (1.30-2) of Wednesday's class and will cover everything through cashflows (about page 145 in the packet). We will not cover growth on this quiz. So ignore them on the past quizzes. What past quizzes, you ask? Here are the links:
We will spend tomorrow finishing the discussion of cash flows and then start on growth rates, by first looking at the usefulness (or lack thereof) of historical (past) growth. We will then move to both analyst estimates and what I like to term intrinsic or fundamental estimates of growth, which we probably will turn to after the quiz on Wednesday. Yes, there is class after the quiz.
Finally, the weekly challenge #3, which I have been nagging you to do, has a solution. I have attached it (with the rating spreadsheet that I needed to get the solution).
Today's class covered a lot of topics, some related to cash flows and some related to growth. Let's start with the cash flow part first. I argued that capital expenditures should be defined broadly to include R&D and acquisitions, for consistency reasons. If you want to count the good stuff (growth) that comes from these investments, you have to also count the cost. To get from cash flow to the firm to cash flow to equity requires us to bring in cash flows to and from debt. While borrowing more can make your cash flows to equity higher, they also make your equity riskier, raising the cost of equity. The net effect of leverage on the value of equity can be positive, negative or neutral, depending on the firm and where it is in its borrowing cycle. On growth, we started with historic growth and quickly dispensed with the notion that it is a fact. Depending on how it is estimated (arithmetic vs geometric) and over what period, you can get different numbers. It is also thrown off when a company's earnings go from negative to positive and generally becomes lower as companies get larger. While you can use analyst forecasts of growth, they have historically not done much better than time series forecasts, perhaps because analysts wear multiple hats.
As for the quiz, it is in the first 30 minutes of Wednesday's class. There will be class after the quiz. So, please hang around, if you finish early. IF YOU WILL NOT BE MAKING THE QUIZ, I NEED TO KNOW BEFORE 1.30 ON WEDNESDAY AFTERNOON. If you are, it is open-book, open-notes but no laptops. You can use your iPads but no connectivity... I have attached the post-class test and solution.
|3/4/14||For those of you who were in my corporate finance class, you may remember that I did a review before each quiz. Unfortunately, with room and time constraints, I have never been able to do that for the Valuation class. However, a couple of semesters ago, I decided to use technology to do an end run around these constraints and did a webcast review session for the quiz. You can get the webcast by going to this link:
The supporting presentation for the quiz is at the link listed below:
In case you still have not been able to find the past quizzes and solutions, here are the links to those:
Past quizzes: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz1.pdf
Solutions to past quizzes: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz1sol.xls
Finally, if you were not in class yesterday, you probably have been looking for the webcast links. They just showed up this morning and I have posted them on the webcast page for the class. See you at the quiz tomorrow!
I know that you are busy preparing for the quiz but if you do get a chance later in the week, take a look at the valuation of Merck. I have assume that the company is in stable growth, growing 2% a year in perpetuity. I value the company twice, once with R&D capitalized and one with the conventional treatment of R&D. That allows me to isolate the effect of R&D. I will give away the punch line. The valuations suggest that Merck is over valued at its existing price and that Merck's R&D over the last decade has generated a return on capital of only 4% (which is less than the cost of capital of 7.60%). If you feel the urge to change numbers in the spreadsheets and make your own judgments, please do enter whatever you find in the shared spreadsheet:
I told you it would be quick and the quizzes are ready to pick on the 9th floor of KMEC. The exams are face down, in alphabetical order, on the table just outside the front door to the finance department. The solution and distribution are next to it. Please take your exam and do not mess with the order. Since I graded the quizzes, if you have any issues, please do come and see me. I do make mistakes and if I do, I fix them.
I won't ask you how the first quiz went because that may evoke the wrong response. The good news is that it is over.
If you were able to hang in there mentally and physically, we did complete our discussion of growth by looking at the fundamentals that drive growth. Starting with a very simple algebraic proof that growth in earnings has to come either from new investments or improved efficiency, we looked at how best to estimate growth in three measures of earnings: earnings per share, net income and operating income. With each measure of earnings, the estimation of growth boiled down to answering three questions: (1) How much is this company reinvesting to generating for future growth? (2) How well is it reinvesting? (3) How much growth is added or lost by changes in returns on existing investments? The weekly challenge for this week revolves around fundamental growth. Try it, if you get a chance. I have also attached the post class test and solution for today's class. Hope you get a chance!
I hope that most of you have picked up your quizzes. I will leave them out until Monday but please do pick them up, if you have not already. You are probably in no mood for more valuation, but if you are, I would spend some time estimating the "secret number" in valuation: the return on invested capital and/or return on equity. Here are the steps:
2. Go to the balance sheet for the prior year (if you are doing trailing 12 months, go to the same quarter of the previous year)
3. Adjust for leases & R&D
4. Compute your ROE, non-cash ROE and ROIC
You may get strange looking numbers. For instance, for some firms with large cash balances, your ROIC can be astronomical or negative. For young, growth firms, the ROIC and ROE can be negative. Don't freak out. You still have the power to override these numbers, when you make your forecasts for the future. In other words, what you really care about is ROE and ROIC on future new investments and you are not bound to use last year's numbers. If you are looking at industry averages for these numbers, they are on my website under updated data.
We also talked about items like goodwill and restructuring charges that can throw you off. If you are interested, here is the sleep-provoking paper of mine on ROE and ROIC that you will find absolutely engrossing (NOT!!!):
|3/7/14||This week, we focused on estimating growth from fundamentals and built growth rates from accounting returns - return on equity and return on invested capital. Accounting returns can be messy and misleading. In this webcast (that some of you may remember from the corporate finance class), I look at the process of estimating accounting returns, using Walmart as my example:
Walmart 10K (2013): http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmart10K.pdf
Walmart 10K (2012): http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmart10Klastyear.pdf
I hope you get a chance to take a look at it.
Two very quick notes. First, the newsletter for the week is attached. Second, the second and third packets are ready to download online.
Attachment: Newsletter #5 (March 8)
I hope that you had a chance to try the weekly challenge (I know.. I know.. No chance.. but no harm trying).... I have attached thes solution to this email. Just a heads up that this week, we will turn our attention to that big number in every DCF valuation, the terminal value, as well as how best to pick the right DCF model to value your company. If you want to get started on the DCF valuation for your company, it is a good week to get started or moving.
Attachment: Weekly Challenge #4 solution
The heart of today's class was the discussion of terminal value. We began by ruling out using multiples to get terminal values, at least in the context of intrinsic value. To keep terminal values in check, you have to follow four basic rules/principles:
|3/11/14||Given that you just got your quiz back and probably want to get to work on your DCF valuation. So, I decided to go off on a tangent and do a fun assessment. Like me, you have probably been watching Bitcoin go from $13 to $1000 and back down to $640 and wondered not only what was driving the price but what exactly it was. I tried last weekend to make sense for myself in this blog post:
I must confess that I am still working on understanding bitcoin but do take a look at the post and try to make your own judgments on four issues:
1. Do you think Bitcoin is a currency?
2. If no, what is it? (An equity instrument, a credit card, a scam)
3. Would you buy Bitcoin for a transaction? (I have a list of vendors who accept Bitcoin, in my post, and lay out the process for acquiring Bitcoin)
4. Would you trade in Bitcoin at today's price?
Finally, I looked at five currencies: the US $, the Chinese Yuan, the Argentine Peso, Gold and Bitcoin as competing currencies and given my priors, I ranked them as follows from best to worst as a currency that I would like to be paid in or in my pocket in any part of the world: US dollar, Gold, Chinese Yuan, Bitcoin, Argentine Peso. Please make your own rankings. Once you have them, go to this shared google spreadsheet and give me your views:
Today's class was about the loose ends in valuation, items we often pay little heed to or attach arbitrary premiums/discounts for. We began by looking at cash and whether it should command a premium at some companies (if they have a good track record and have restrictions on raising capital) and a discount at others (if investors don't trust you with the cash). We then looked at cross holdings in other companies and the numerous barriers to valuing them. Third, we looked at other assets and argued that you should never double count assets. I have attached the post class test and solution.
On a different note, please do get a jump on the DCF valuation of your firm. The valuation is due on April 4 but only for feedback, not grading. So, don't feel the pressure to get it right. Just get it done. I have also attached the weekly challenge for this week, though this is little chance that you will be able to do it, on spring break. I will give a longer window than usual for submissions, and not send you the solution until March 24. Just one more email later today with the to do list for the valuation and I will then leave you to your own devices (I promise).
As you take for different parts of the world, I know that the last thing you want to think about is your DCF valuation. Anyway, I thought I would lend a helping hand:
Let me clarify, though, what I would like to get from you when you turn it in:
Finally, if you are one of those people who likes checklists, I have attached one of those as well. Hope you find it useful.
I hope that your spring break was great but the bad news is that it is almost over. I don't mean to be the skunk at your party, but it is my duty to remind you that your DCF valuation is due for feedback by April 4. If you are working on it or plan to work on it, you will undoubtedly find that errors you make on your terminal value can drown out all of the good work that you do in estimating your inputs. I have a webcast that you may find useful in checking your terminal value (or someone else's estimate of terminal value). I hope you get a chance to check it out.
Finally, if you want to see how this works in practice, take a look at the attached equity research report on Tesla from Morgan Stanley. Skip through the first 40 pages (they are impressive but a distraction) and go to page 41 to the DCF valuation. Put the terminal value to the test (using both the EBITDA multiple and the perpetual growth model used by the analyst).
I hope that you had a great break and have made it back home to enjoy a picture perfect day in New York city. The newsletter covering the last two weeks is attached. While nothing happened last week, it may help remind you of where we are in the class and where we are going next.
Attachment: Newsletter #6
Hope you are back and raring to go (Right... But no harm hoping...)! Anyway, ready or not, we are back to work tomorrow. After tying up a couple more loose ends (complexity, debt to net out of firm value to get to equity value and employee options/restricted stock), we will start on a series of valuations. We will begin easy, using a stable growth dividend discount model to value Con Ed, move up the difficulty ladder to value 3M with a FCFF model before and just after the 2008 market crisis and follow up with a valuation of the S&P 500 at the start of 2013. We will then move into what I call the dark side of valuation, looking at difficult to value companies across the life cycle (from start up to decline), across sectors (financial service, cyclical, commodity) and across markets. If you are having trouble with your DCF valuation, odds are that we will address that issue in the context of valuing some other company in the next few sessions. I am also attaching the solution to the weekly challenge for this week. While you probably did not get a chance to work through the challenge, please do take a look at it since it relates to DCF's biggest number, the terminal value.
Attachments: Solution to weekly challenge
Today, we put the three final loose ends to rest. First, we examined whether and if yes, how to punish complex companies in valuations. Second, we went back and looked at defining debt. While we used a narrow definition of debt, when computing cost of capital, we argued for using a broader definition of debt, when subtracting from firm value to get to equity value. Third, we talked about how best to deal with both currently outstanding employee options and potential options grants in the future. With the former, we argued for using an option pricing model to value the options and netting that value out of equity value, before dividing by the number of shares outstanding. With the latter, we suggested incorporating the expected cost into the operating expenses, thus lowering future earnings and cash flows.
As promised, the valuation of the week is up and it is of Tesla. The place to start is with the blog post that I put up this morning on the valuation:
Attachments: Tesla valuation
In today's class, we started with two conventional valuations, one of 3M and the other of the S&P 500. We then talked about the valuaton of young, growth companies by emphasizing that you will be wrong 100% of the time and that it was okay, because the market is usually even more wrong. We then moved on to valuing mature companies, arguing that you need to value many of them twice: once with existing management in place (status quo) and once with new and revamped management. Overall, we are approaching the end of the DCF section of this class. If you have not printed off packet 2 of the lecture notes, please do so or buy the packet at the bookstore (you will get packets 2 & 3 consolidated). We will be getting to it next week. I have also attached the weekly challenge for this week and the post class test and solution. I will be in Brazil for the next couple of days doing a valuation seminar but rest assured that I will find ways to harass your from there as well, over the next few days.
am sorry for sending you two emails in a day, but I did not attach the weekly challenge to the last email. This week's challenge revolves around management options and how to value them. Please give it a shot and you can use the employee option spreadsheet that I have attached. Until next time!
Attachments: Weekly challenge on employee options
So, where are you in the DCF process? I hope that you have picked a company, collected the financials and actually tried to do a base case. A piece of advice. Get a base case valuation going with just minimal information (last annual report or 10K) and come back to it with more details. I have reattached the valuation checklist I sent you a couple of weeks ago, since you may find it more useful now. In case, you have forgotten which spreadsheets work best if you want to start with one of mine, you should stick with the ginzu versions:
Attached: Valuation Checklist
|3/28/14||As you work on your perfect DCF valuations, employee options that your company has granted and continues to grant may be a source of imperfection. I know that we went through the mechanics in class. First, value the outstanding options, using an option pricing model. Second, subtract the value of the options from the equity value that you estimated in a DCF. Third, divide the remaining value by the number of shares outstanding (the actual number, not the diluted number). The mechanics of doing this can be tricky and that is why this week's weekly challenge is built around options. After you have tried the challenge, you may also want to watch this webcast that I put together on doing this in practice. I used Cisco, a monster option granter, to illustrate the mechanics. You can find the links below:
Cisco 10K: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/EmployeeOptions/cisco10K.pdf
Spreadsheet for options: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/EmployeeOptions/ciscooptions.xls
I hope you get a chance to watch the webcast and that you find it useful.
News on two fronts. The first is that the solution to the option weekly challenge is attached. If you are at all confused about valuing employee options, I would check it out. The second is an update on the week to come. We will start tomorrow by looking at other companies on the dark side of valuation, including distressed companies, cyclical companies and emerging market companies. On Wednesday, we will (hopefully) finish our discussion of packet 1. If you can, please download, print or buy packets 2/3. They are both ready to download online:
In today's session, we started with the depressing job of valuing declining and distressed companies, moved on to emerging market companies and ended with financial service companies. We are almost to the end of the DCF process now. Next session, we will look at the difference between value and price, what it tells u and what it does not. The post class test and solution are attached.
On a different note, please do work on your DCF valuations this week and try to get them to me by Friday. I could draw lines in the sand (by 5 pm Friday, or else) but I will not. So, do your best and I will do mine.
You may have read the story about Citigroup failing its stress test last week (and its stock price dropping 5%):
If you want access to the raw data, I have links to the most recent 10K and to a sheet breaking down Citi by geography (useful in estimating equity risk premiums)
Once you have done the valuation, you can enter your numbers in the shared Google spreadsheet:
Finally, remember that we used Citi to illustrate the problems of complexity. (The 10K has been slimmed down to 324 pages). I found this news story about Citi interesting, because it shows you how the creators of complexity often refuse to take responsibility for doing so:
Attachment: Citigroup stable growth dividend discount model
In today's class, we finally put to rest DCF by having a discussion of the difference between value and price, why they might be different and when the gap will close. Before entering into that discussion by talking about the values of intangible asset companies and commodity/cyclical companies. With the latter, we noted the importance of keeping separate our macro views (about the economy or commodity) from our micro views, and the use of Monte Carlo simulations to deal with uncertainty. During that discussion, I talked about a paper that I have on statistical distributions and the link is below:
We ended the class by starting the discussion of multiples and comparable firms. We will continue that discussion after the second quiz. I have put the review session up online (on the webcast page for the class) with the presentation. The links are below:
You can also find all past quizzes with the solutions in the following links:
|4/3/14||I know that it seems like I am piling on, with your DCF due tomorrow and your quiz on Monday and I am sorry. However, I will not harass you too much today.
1. DCF: Please remember to put "My Perfect DCF" in the subject, when you send your DCF to me. All you have to send is your spreadsheet, with questions and comments embedded in it (if you have any)
2. Quiz: The quiz review, presentation and links to past quizzes were in yesterday's email. In case you did not get it, you can also get them by going to
|4/3/14||Sorry for second email today. When you submit your DCFs, please remember to list the current price and your estimated value per share in your email. It gives me a sense of what I am looking for or at.|
|4/4/14||As I check my mailbox, I see that most of you have turned in your DCF valuations. I appreciate the effort and will get them back to you as soon as I can. There is no valuation tools webcast this week, as we take a break to get ready for the quiz. But I will see you Monday at 1.30. Please don't be late and if you are going to miss the quiz, let me know ahead of 1.30.|
I will keep this brief. I have attached the newsletter to this email. In addition, I have gone back to the past quizzes and added finals from 2012 and 2013 to them, just in case you don't have enough problems to work through.
By now, you should have received back your DCF valuation back. If you have not, please send it again to me. Rather than make myself into an all-knowing oracle (which I am not), t thought I would take you through the process I used to diagnose your DCF valuations.
Input page checks
Output page checks:
One common error to watch out for is estimates of terminal value that use the cash flow in the final year, grow it out at the stable growth rate. That locks in your reinvestment rate from your last high growth year forever.
Try it out with your own DCF valuation and then offer to do it for a friend... Then, take your toolkit on the road. Pick up a valuation done by an investment bank or equity research analyst and see if you can diagnose any problems in them. You are well on your way to being a valuation guru.
I am sorry that I was not able to get the quizzes done before I left today but I had a meeting at 3.30 that took up too much of my time. I am done and will put them out tomorrow morning at about 9.30 am. I will post the solution and score distribution at that time. In today's class, we continued our discussion of multiples by looking at the distributional characteristics of multiples (skewed, shifting over time but lots of commonalities across markets). We also looked at how to back out the variables that determine multiples by going back to DCF fundamentals, and used these fundamentals that drive PE ratios. More on that in the next class!
|4/8/14||If the last problem on the quiz is still giving you nightmares, you may not want to take a look at this week's valuation of the week, but it is a fuller valuation of Yahoo! (though the quiz question came surprisingly close). The best place to start this valuation is with this summary page:
In the page, you will see links to three intrinsic valuations: Yahoo (parent), Yahoo Japan and Alibaba.
Valuation of Yahoo (S): http://www.stern.nyu.edu/~adamodar/pc/blog/YahooParent.xls
Valuation of Yahoo Japan: http://www.stern.nyu.edu/~adamodar/pc/blog/YahooJapan.xls
Valuation of Alibaba: http://www.stern.nyu.edu/~adamodar/pc/blog/AlibabaApr14.xls
The last one is based on very primitive data and will be revisited when the prospectus comes out. I also have a master page, where I compute a value per share for Yahoo! (and let you play around with different ways of estimating the values of Yahoo Japan and Alibaba).
Master valuation of Yahoo!: http://www.stern.nyu.edu/~adamodar/pc/blog/YahooMaster.xls
Bottom line: My estimate of value per share for Yahoo! yields an estimate of about $50/share, well above the $34 it is trading at today. I may be missing something, but take a look and if you see a missing piece, let me know.
As promised (or threatened), the mystery project is ready for you. It is a group project, due a week from today (Friday, April 26 at 5 pm). The assignment is a pretty straightforward one, and the write up should be brief and to the point. Be creative, use statistics as a tool and don't be afraid to be different.... I have attached the project description and the data that you will need (it is also online on the webcast page for the class and under the main menu for the class... will also be posted on Lore and iTunes U).
In today's class, we extended our analysis of multiples by first looking at PE and PEG ratios, then moving on to PBV ratios and finally examining enterprise value multiples: EV/Invested Capital, EV/EBITDA and EV/Sales. In particular, we noted that the drivers for EV multiples are analogs of the equity multiples: growth in operating income replacing growth in net income, reinvestment rates replacing payout ratios, ROC replacing ROE and cost of capital replacing cost of equity. There is a simple way to find the companion variable (the key driver) for a multiple. With an equity multiple, you can get this variable by dividing the net income by the denominator of the multiple. With an enterprise value, you divide after-tax operating income by the denominator of the multiple. With the EV/Sales ratio, this yields the after-tax operating margin as the determining variable. We used that measure to evaluate the value of a brand name, by comparing the pricing of Coca Cola with its current operating margin with its value with a generic margin.
One final point. I seem to have completely mangled the due dates on the Mystery project. So, let me resolve the confusion. The project is due on April 25, 2014 by 5 pm. That should give you little more than two weeks to work on it.
|4/10/14||I know. I know. No rest for the wicked! You can take a little break from your project, since you should have your DCF back by now. (Incidentally, I went through the perfect DCF folder and it looks like I have returned your DCF). If you sent your DCF and did not get it back, please send it again. I am sorry if you have sent it already and I did not respond but last week was a monster one for emails and anything more than three days old is buried behind hundreds of other emails.|
|4/11/14||One of the most confusing aspects of multiples is dealing with the variants of value out there: firm value, enterprise value and equity value. In this webcast, I look at what the differences are between these different numbers and how our assessments of leases & R&D can change these numbers. Start with this blog post:
Then watch the webcast:
You can download the presentation:
And the spreadsheet that goes through the calculations:
Hope you find it useful!
Just a quick note. Last week, we continued to explore the determinants of multiples, looking at PE ratios, PEG ratios and EV multiples. In the process, we uncovered the unsurprising reality that the determinants of multiples are cash flows, growth and risk, the same variables that determine intrinsic value. Next week, we will finish our discussion of relative valuation. In fact, you have all the tools you need to do your mystery project, if you are so inclined. The newsletter for the week is attached.
Attachment: Newsletter # 9 (April 12)
In the week to come, we will continue and complete our discussion of multiples, by looking at extending the comparable list to the entire market. On Wednesday, we may be able to look at asset based valuation, including liquidation and sum of the parts valuation. I have attached the solution to this week's weekly challenge (that you may or may not have looked at). Until next time!
Attachment: Weekly challenge #7a Solution
In a change of pace, I thought I would do a relative valuation this week and I picked a high profile company (Amazon) to do it. Given its large market cap and low operating income, the conventional wisdom is that Amazon must be over valued. Well, as you will see in the link below, that is not the case:
In today's class, we closed the book on relative valuation by looking at how to pick the "right" multiple for a valuation, with the answers ranging from cynically picking one that best fits your agenda to picking one that reflects what managers in that business care about. It is amazing how widespread relative valuation is. I found this site recently on rules of thumb in valuation. Take a look at it.... especially the multiples mentioned
For the moment, I expect that you are working on the mystery project. I don't have much specific advice for you on the project, but remember that your mission is to do a relative valuation (not an intrinsic value). That gives you a lot more leeway in how you deal with items. For instance, if your were doing DCF valuations, you would have to value the employee options, using option pricing models, and subtract from the value of equity to get to value of common stock. With multiples, you may adjust for options much more casually (adjusting the number of shares for options outstanding, for instance). It will also mean that if you do not have the data to do something correctly, you may have to settle for an approximation. In case, the confusion about the due date is still persisting, the mystery project is due on April 25 at 5 pm.
I have also put up a webcast that is more statistics than finance about how to look at data and try to evaluate relationships between variables. I use the banking sector to illustrate my case but I hope that you find it useful for both your mystery project as well as for your overall project. If you are solid on your statistics, you can skip this webcast, since you already know everything that I am saying. If you need a quick review of the process, I think it will be useful.
I hope that you are getting a chance to enjoy the weather today, even if it means lugging your laptop to the park. Anyway, the newsletter for the week is attached. And keep plugging away at the mystery project.
Attachment: Newsletter 10 (April 19)
|4/20/14||If you did try the weekly challenge, the solution is attached. Even if you did not, you can take a quick look at it. Tomorrow, we will continue our discussion of valuing private businesses by looking at illiquidity and key person discounts in a private-to-private transaction, how value changes when the buyer is a public company and close this section with a discussion of how valuation for an initial public offering and to a venture capitalist. We will be beginning on lecture note packet 3. If you have not downloaded it yet, please do so.
If you did buy packet 2 from the bookstore, it is a combinations of packets 2 and 3. So, you are all set.
In today's class, we put the finishing touches on private company valuation by looking at valuing IPOs. In particular, the question of what happens to the proceeds from an offering can affect value per share, and the offering price itself is subject to the dynamics of the issuance process, with investment bankers more likely to under price than over price offerings. We then started on real options, arguing that they add "premiums" on to intrinsic value and the reason for those premiums. We will continue this discussion on Wednesday!
|4/22/14||I had promised you the IPO valuation of Alibaba but the prospectus seems to be on hold. Perhaps, this evening. I will wait until it is out to make the final valuation.|
In today's session, we started with a quick overview of option pricing and tests for the viability of real options. We then tried applying (with mixed results) option pricing to value a patent. With a patent, we argued that the fact that a patent is not viable today does not imply that the patent is not valuable. Valued as an option, patents have values in excess of their discounted cash flow value, though the magnitude of the premium can be a function of how competitive the market place is. I have attached a simple option pricing model that I use to value patents. I also have attached the post class test & solution.
I know that you have neither the time nor the inclination to deal with a weekly challenge. However, when you get done with your mystery project, you may find this weekly challenge that deals with the issues that you face when valuing private businesses to be useful in preparing for the next quiz. I know that we have not dealt with the voting right and non-voting right shares in class yet (and it will not be on the quiz) but give it a shot. The solution will be posted on Sunday.
Attachment: Weekly challenge #9
The review session for quiz 3 is up and running! You can get it on the webcast page for the class. The link to the webcast is below:
On a different note, I hope that your mystery project is progressing. The deadline remains tomorrow at 5 pm. When you do submit your project, though, please follow these guidelines:
I know that you have absolutely no time for this, but just in case, I have a webcast on valuing patents as options:
Thank you for getting your mystery projects in on time. You should be getting them back soon (or may already have them back). The weekly newsletter is attached and the third and final quiz approaches.
Attachment: Newsletter # 11 (April 26)
By now, you should have your mystery projects back. If you have not, please send it to me again. Looking over your analyses, here are some of the overall impressions I have:
1. Multiple used: The two most widely used multiples were PE and EV/Sales. EV/EBITDA was close behind. In making your choices, the following factors seemed to come into play: (a) the regression R-squared (higher R-squared) (b) differences in accounting standards across markets (led people to choose Revenue or EBITDA over EPS) (c) Number of firms that you would lose in the sample (steered away from multiples that cost you too many firms). I think that these are all legitimate factors. A few groups mentioned that they were using equity multiples because they were equity investors. I don't think that is necessarily the case. Equity investors can use EV multiples and back into a value for equity... There were twogroups that used combinations of multiples and figured out creative ways to reconcile their choices. There were also a few groups that ran the regression within each sector and picked under and over valued companies on that basis.
2. Regressions: Almost everyone followed the script and ran the regressions... One thing I did notice is that some of you chose to stick with all of the variables in the regression, even when there was no statistical significance. Sometimes, taking a variable out rather than leave it is the better choice. About 20% of the groups reported regressions with dummy variables for emerging markets. Four groups ran the regressions by sector or used sector dummies. While this makes sense, you have to be careful to make sure that you have enough data within each sector to sustain the regression. (The simple rule of thumb is that you can have one independent variable for every 15 observations. Thus, if your sample size is 35, you can have at the most 2 independent variables.)
3. Recommendations: When picking under and over valued companies, what matters is the percentage and not the absolute difference. In other words, a company that trades at a PE of 10 with a predicted PE of 15, is more undervalued that a company that trades at a PE of 40 with a predicted PE of 50. As I checked through the lists, I was struck by how little commonality there was across the lists. Each of you had your own idiosyncratic list, which tells me that there are no clearly under or over valued companies that stick out, across all approaches and multiples. Good to know, but perhaps not surprising. However, there were some companies that showed up more frequently than others.
Company % of groups that found it undervalued
Most over valued firms
Amazon took quite a fall on Friday. So, you were remarkably prescient.
4. LBO candidate: A good target for a leveraged buyout will be under valued, under levered, easy to takeover and badly managed. Almost all of you focused on finding an under valued company (which is good), an under levered company (makes sense) and a company easy to takeover (low takeover defenses), but the search on the fourth dimension (bad management) was all over the place. Some of you were looking for companies with high margins and others with stable cash flows. There was a scattering of companies that were choses. Only two were picked by more than one group: Canon and McKesson. As a general rule, control requires inputs that you can change and that indicates a firm with below-average margins. There was almost no overlap between the groups with no company being picked more that twice. I have a paper on LBOs that fleshes out what you may want to look for in a LBO candidate. If you get a chance, please browse through it.