logo about writing tools
teaching data blog

 

 

The Valuation Email Chronicles: Spring 2017

 


The emails for this class will be collected on this page, arranged chronologically. Have fun with them!

Date
Email content
1/9/17

For those of you who were in my corporate finance class, the torture begins again (http://www.youtube.com/watch?v=7edeOEuXdMU). For those of you who are new to this experience, you will soon find out. I am sure that you are finding that break is passing by way too fast, but the semester is almost upon us and I want to welcome you to the Valuation class. One of the best things about teaching this class is that valuation is always timely (and always fun...) Just as examples: Is it time to buy or sell Twitter? Is Uber worth $70 billion? Is there a market bubble? What is the value added or destroyed by the Kardashians? Are the Dallas Cowboys really worth more than the New York Yankees? Is there a Trump effect on markets and if so what is it? If you have not visited my blog, I put my thoughts down on these issues (though I am still working on the Kardashian valuation):
http://aswathdamodaran.blogspot.com/

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 page:
http://www.stern.nyu.edu/~adamodar/New_Home_Page/equity.html

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
http://bit.ly/2ihM2Z0
For those of you already setting up your calendars, it lists when the quizzes will be held and when projects come due.

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
http://www.stern.nyu.edu/~adamodar/New_Home_Page/eqlect.htm
Please download and print only the first packet on discounted cashflow valuation. If you want to save paper, you can download the pdf file on you iPad, Android or Kindle and follow along...

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:
a. iTunes U: I will also be posting the material for the class on iTunes U. If you have never used iTunes U, you need an Apple device (iPad or iPhone) and have to download the iTunes U app (free). Then use the enroll code: FHS-KWW-FPK.
Alternatively, type in or click on the link for the class.
https://itunes.apple.com/us/course/id1191852024
I really like the set up and I think you may enjoy it too. If you have an android, it is a little more involved, but try downloading Tunesviewer, an Android app that lets you use iTunes U.
b. YouTube Channel: There is a final option, if your broadband connection is not that great and you are watching on a Tablet/smartphone. There is a YouTube playlist for this class, where all class sessions will be loaded.
https://www.youtube.com/playlist?list=PLUkh9m2BorqkNzSSPrCDkO2jlufVCinVw
When you get a chance, check it out.

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". Finally, if you really want to take a leap, try my newest book, Narrative and Numbers at
https://www.amazon.com/Narrative-Numbers-Business-Columbia-Publishing/dp/0231180489
You will find the webpages for all of the books at 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
It comes with a money back guarantee... Sorry, no Android version yet... As for Blackberry, fuggedaboutit... Dead technology walking!!! I am looking forward to seeing you in a few days (The first day of class is January 23, 2017 in Paulson Auditorium. I think we are going to have a lot of fun (at least, I am... ).

1/18/17

One of the themes of this class will be that while your valuation looks like a collection of numbers, the story that holds these numbers together is the glue. Consequently, to get a handle on valuation, you have to learn to navigate that space between stories and numbers and your skills have to be broad. I know that you are still on break and that the last thing you want to do is reading, but if you do get a chance, please read this post that I have on my blog:
http://aswathdamodaran.blogspot.com/2016/08/investing-and-valuation-lessons-from.html

The post was triggered by the awe I felt, looking up at Brunelleschi’s Duomo in Firenze this summer, but the thoughts are all investing/valuation thoughts. In fact, I just finished a book on connecting stories to numbers and here is the post introducing the book (which became available a couple of weeks ago).
http://aswathdamodaran.blogspot.in/2017/01/narrative-and-numbers-how-number.html

Just a few quick notes leading into class on Monday:
1. 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
http://www.stern.nyu.edu/~adamodar/New_Home_Page/eqemail.html
2. Visit the website for the class and check out the Google calendar to make sure that you don't have any quiz conflicts:
http://www.stern.nyu.edu/~adamodar/New_Home_Page/equity.html
3. If you have an Apple device, please download iTunes U (a free app from the app store). Once you have it installed,click to plus to add a class and when prompted, enter the enroll code FHS-KWW-FPK. The Spring 2017 version of the valuation class should pop up. All of the lectures will then show up on your iPhone or iPad as webcasts that you can watch. If you have an Android, you will need another app to watch iTunes U. One app that seems to work is Tunesviewer. (http://tunesviewer.sourceforge.net)
4. If the previous step exhausts you technologically, you can try a different route. You can use YouTube, where I have started playlist for this class:
https://www.youtube.com/playlist?list=PLUkh9m2BorqkNzSSPrCDkO2jlufVCinVw
The lectures will show up on this playlist as well. See you in class on Monday!

1/23/17

We are officially rolling. If you enrolled in the class in the last couple of days, you did miss the first two emails but they are already in the email chronicle, in case you are interested:
Email chronicles: http://www.stern.nyu.edu/~adamodar/New_Home_Page/eqemail.html
This chronicle will be updated at the end of each week to include all emails sent up until then. There were three handouts in class today. If you were unable to get one or more, here are the links:
Syllabus: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/eqUGsyllspr17.pdf
Project: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/eqUGsyllspr17.pdf
Introduction to Valuation (Slides for Wednesday’s class): http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/ValIntrospr17.pdf
A quick note about today's class. During the session, I told you that 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 suggested that you start thinking about forming a group and picking companies. To get the process rolling, here is what I have done
1. Group: Please do find a group to nurture your valuation creativity, and a company to value soon. If you are ostracized, or feel alone, I have created a Google shared spreadsheet (an Orphan list, so to speak) that you use to find others like you in the class:
https://docs.google.com/spreadsheets/d/1LlXOU4co21Y7Ft9tIqdvAPmcMO1HJGUBITtSyLz0s7c/edit?usp=sharing
2. Company Choice: 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 2014) and then visit the SEC website (http://www.sec.gov) (for US listings) and download 10Q filings. (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.)
3. Webcast of today’s class: The web cast for the first class are up and running (or at least the streaming version). You can access it by going to:
http://www.stern.nyu.edu/~adamodar/New_Home_Page/webcasteqUGspr17.htm
The links to iTunes U and YouTube will also be up shortly.
4. Lecture Note Packets: You can wait for the bookstore to get its act together and get the packets ready or you can get a jump by downloading the lecture note packet online. It is available at the top of the webcast page (see link above) in either pdf or ppt format. (I was told by someone that the lecture note packet link is not working, but it seems to be (at least for me). Am I missing something?
5. 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 this site. I will also be sending out a post class test and solution after each session that should take you no more than 5-10 minutes to do. It is a good way to review the class and I hope that you find it useful. Sorry about the length of this email, but there will be more to come (I promise!).

Attachments: Post-class test and solution.

1/24/17 If you are going to do a valuation of Star Wars, I think it makes complete sense to start with Yoda talk. So, for your first valuation of the week, let’s have some fun. I have always been a Star Wars fan, and like other fans, I was a little worried when Disney bought Lucas Films (and with it the rights to the Star Wars franchise) for $4 billion a few years ago. Disney was explicit about its plans at the time, and said that it planned to produce three major Star Wars movies, continuing the story, and three side stories (like Rogue One) filling in history. I went to see Force One in December 2015 and wrote this post on my blog about what I thought the value of Star Wars was at the time;
http://aswathdamodaran.blogspot.com/2015/12/intergalactic-finance-valuing-star-wars.html
I assigned a value of almost $10 billion to the franchise, with a big chunk coming from the side products (toys, software, apps) coming from the franchise. You can download the spreadsheet that contains the valuation here:
http://www.stern.nyu.edu/~adamodar/pc/blog/StarWars2015.xls
When I wrote the post, Force Awakens had been out in theaters only a few days and I estimated box office revenue of $2 billion for the movie. Rogue One, of course, had not been released yet and I estimated revenues of $1 billion. Force Awakens is now one for the history books, with global revenues of just over $2 billion and Rogue One just crossed the $1 billion threshold.
Updated box office for Force Awakens: http://www.boxofficemojo.com/movies/?id=starwars7.htm
Updated box office for Rogue One: http://www.the-numbers.com/movie/Rogue-One-A-Star-Wars-Story#tab=summary
Armed with this additional information, here is what I would like you to do. Go into the spreadsheet and reestimate the value of the Star Wars franchise. It may be only tweaks but give it your best shot. Once you have a value, go into this shared Google spreadsheet:
https://docs.google.com/spreadsheets/d/1CYFpddJLp32CzrahlSxVC_PRQpYblQYa0hl3y0mVrgM/edit?usp=sharing
Enter your numbers and lets see how the distribution of values evolves over time. And since this is a Star Wars post, might as well end with some good advice:
https://youtu.be/eExL1VLkQYk
1/25/17

did not mention this in the opening session but at the start of every class for most of the semester (other than the three quiz days), there will be a start of the class test, where we will look at questions that preview the material that is coming in the rest of the class. (I know… I know.. This sounds backward, but trust me on this one).We will start class today with a series of scenarios, where you have to decide whether you will be biased to push your values up or push them down. To give you chance to look at the scenarios before you get hit with them, I am attaching the start of the class test for tomorrow. With each one, think of the direction of the bias and also think about the mechanism that you will use to bring that bias into your numbers. (As an owner, you may inflate the market potential for your product..)

Attachments: Valuation bias: A test, Post-class test and solution.

1/26/17

It is never too early to start nagging you about the project. So, let me get started with a checklist (which is short for this week but will get longer each week. Here is the list of things that would be nice to get behind you:
Find a group: The groups are yours to create and you should try to have at least 4 people in a group and not more than 8 (that limit is for your own projection). If you have trouble finding one, try the orphan spreadsheet for the class. (https://docs.google.com/spreadsheets/d/1LlXOU4co21Y7Ft9tIqdvAPmcMO1HJGUBITtSyLz0s7c/edit?usp=sharing )
Pick a company: This will require some coordination across the group to make sure that you meet the minimum criteria (at least one money loser, high growth, emerging market, service company). In making this choice, remember that you can value any business you want, public or private, small or large, listed in any market. There are at least a couple of entrepreneurs in the class who are valuing their own businesses and quite a few valuing privately owned family businesses.
Annual Report: Find the most recent annual report for your company. If you are valuing a private business, just ask for income statements and balance sheets for as long as you can get them (I will assume that you know the owner or better still, you are the owner).
Public filings: If your company has quarterly reports or filings pull them up as well.
In doing all of this, you will need data and Stern subscribes to one of the two industry standards: S&P Capital IQ (the other is Factset). It is truly a remarkable dataset with hundreds of items on tens of thousands of public companies listed globally, including corporate governance measures. I am working on getting you okayed to use this dataset and I will let you know when it is accessible.

On a different note, I told you that I would be experimenting with some neat online technologies through the class. If this is not your think, that’s fine but the platform that I am trying out is called Acadly. You can learn about it by going to:
https://www.acadly.com
As you can see, it is a forum that I will be using to share blog posts with you, run short poll questions on valuation and have a discussion board. If you are intrigued, download the app from the App store on your smartphone and we may play with it over the course of the semester. Then again, we might not.

1/27/17

Three quick notes.
1. Valuation Tools Webcast #1: The first is that I did put up the first valuation tools webcast on the basics of data collection. 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.
http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/gettingdata.mp4
It is about 15 minutes long & not very professionally produced. So, ignore the bad light and bobbing head and focus on the content!

2. There are three TAs for the class, all of whom have gone through this class in prior semesters. Their names, email addresses and office hours are listed below:
Javier Cuellar, jwc479@stern.nyu.edu, Office hours: Friday 12-1.30
Lawrence Duff, lawrence.duff@stern.nyu.edu, Office hours: Tuesday 12-1.30
Shaneil Mehta, sm4948@stern.nyu.edu, Office hours: Tuesday 4-5.30
My office is always open, if I am in. So, use the fair game principle to your advantage. The TAs will also be running a one-hour review session each week, where they will be covering the material from that week’s class sessions. The review sessions will be in KMEC 2-70 from 4.30-5.30 pm on Wednesdays. Since the room fits 60, you should sign up for the review sessions that you are interested in attending, in the Google shared spreadsheet below.
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/1ADgs4uTcJKrDKuaNbz7EeYkFn5b1QWanF83x_DIADCk/edit?usp=sharing
Note that these sessions are not required and if you feel comfortable with the material in class, you can skip them.

3. As should have been obvious, this is a big class with more than 300 people in it. That makes it a great venue for announcements that you may want to make about club activities or events. I will open each class session by allowing one announcement. If you want to make an announcement, please sign up for it as well in the Google shared sheet below:
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/1ZKa_4w-Q3XlVZEh3kH6fM03UIdbtwnsqmmBE5rsTHtM/edit?usp=sharing

1/28/17

I hope that you are enjoying your first weekend back at school. I will intrude with a couple of notes. First, the first newsletter for the class is attached. As I said, there is usually not much news in these newsletters. Think of it more as a GPS for the class, telling you where we went last week and laying out our plans for the week ahead. If you get a chance, take a look at it. Second, we will be starting with the first lecture note packet in class on Monday. Please have it with you for class. Have a great weekend!

Attachment: Issue 1 (January 28)

1/29/17

First things first. This week, we will be delving into the mechanics of discount rates, starting with the risk free rate and then moving on to the equity risk premium. They are both central to valuation and we live in unusual times, where the former, in particular, is doing strange things.

Second, 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. The question is at the bottom of the page.

Third, I was checking out the Google shared spreadsheet on my first valuation of the week. Well done! I see 81 of you have tried to value the franchise. You can still do it, if you have not done it already. If you have already forgotten about it, you can find the details on the webcast page for the class.
http://www.stern.nyu.edu/~adamodar/New_Home_Page/webcasteqUGspr17.htm

Attachment: Cash Flow Test (for class on 1/30)

1/30/17 Today's class started with a look at a major investment banking valuation of a target company in an acquisition and why having a big name on a valuation does not always 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 hope that the discussion of riskfree rates a left you fairly clear about what to do next. In case, you are still confused, this is the next step in the process:
1. Pick a company (in case you have not already).
2. Determine a currency that you will value the company in. Once you have decided on the currency, find a riskfree rate in that currency. If your company is a US or European company, you just got lucky. Either take the easy way out and use the US T.Bond rate as the dollar riskfree rate and the German 10-year bond rate as the Euro riskfree rate, or adjust them for the default risk you see in each sovereign.
If you are valuing a company in an emerging market in the local currency (be brave), your job is a little more complicated.
2a. Get the longest term government bond rate you can get in the local currency. You can check out the Economist (look at the tables towards the end of the publication and at the long term interest rate). You can also try this site for long term local currency government bond rates:
http://www.tradingeconomics.com/bonds
2b. Get the local currency rating for the country by going to the moody's web site: http://www.moodys.com (Look under sovereign ratings). Estimate the default spread given the rating by downloading the country default spread spreadsheet that you can find at the link below
http://www.stern.nyu.edu/~adamodar/pc/datasets/ctryprem.xls
On Wednesday, we will go through the mechanics of converting a government bond rate into a risk free rate.
I have a blog post on risk free rates that may help clarify things better:
http://aswathdamodaran.blogspot.com/2017/01/january-2017-data-update-3-cracking.html
The post class test and solution are also attached
1/31/17 Since we are still not into the nuts and bolts of valuation, I decided that we should spend this week too on a “fun” valuation”, tied to Super Bowl weekend. This is a throwback in time, but it is a valuation and pricing that I did of the Los Angeles Clippers, when Steve Ballmer paid $2 billion for the team. I explain how I value the Clippers and how I would value any sports franchise in this post:
http://aswathdamodaran.blogspot.com/2014/06/ballmers-bid-for-clippers-investment.html
You can find my valuation of the Clippers in this link:
http://www.stern.nyu.edu/~adamodar/pc/blog/Clippervaluation.xlsx
You can do one of the two things in this week’s valuation challenge.
1. You can take my Clipper valuation and make your own assumptions (there are relatively few) and value the Clippers as of June 2014.
2. The other is more challenging but could be more fun. I have raw data on sports franchises below:
For MLB, NFL, NBA and NHL: http://www.stern.nyu.edu/~adamodar/pc/blog/SportsTeamData.xlsx
For European soccer teams: http://www.stern.nyu.edu/~adamodar/pc/blog/eurosoccerrawdata.xls
For IPL (Indian cricket) teams: http://www.stern.nyu.edu/~adamodar/pc/blog/IPLrawdata.xls
The IPL and Euro soccer data is a little outdated and you are welcome to update them, if you want. If you are a fan, you can pick your favorite team and using the raw data in these spreadsheets, try to value and price your franchise. Once you have that number, please do share what you find on the Google shared spreadsheet:
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/1S8Wy6oXKqiEC23iiEcQ9toTrb1EytiMHgv3BF48MmUo/edit?usp=sharing
In the last column, I ask you how much you would pay to own the team. For the Clippers, I have set that equal to my value. But if I were valuing the Yankees, I might pay a premium because I love the Yankees. They are not just an investment and I will pay an ego or fan premium.
2/1/17

We started the class by completing the discussion of risk free rates, exploring why risk free rates vary across currencies and what to do about really low or negative risk free rates. The blog post below captures my thoughts on negative risk free rates:
http://aswathdamodaran.blogspot.com/2016/03/negative-interest-rates-unreal.html
We are about halfway through the discussion of equity risk premiums but the contours of the discussion should be clear.
a. Historical equity risk premiums are not only backward looking but are noisy (have high standard errors). You can the historical return data for the US on my website by going to
http://www.stern.nyu.edu/~adamodar/New_Home_Page/data.html
Click on current data, and look to the top of the table of downloadable data items.
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.23 to get a rough measure of the country risk premium. If you want my estimates of country risk premiums, check under updated data on my website. The direct link is below:
http://www.stern.nyu.edu/~adamodar/pc/datasets/ctryprem.xls
You can also see my latest blog post on country risk here:
http://aswathdamodaran.blogspot.com/2017/01/january-2017-data-update-4-country-risk.html
Finally, The post class test and solution are attached.

Attachments: Post-class test and solution.

2/2/17 In class on Monday, we started with the claimholder consistency principle, arguing that there are two ways to value equity: discount cash flows to equity at the cost of equity or discount cash flows to the firm at the cost of capital and then subtracting out debt. Done right, I argued that you should get the same answer. I hope that you had a chance to try the first weekly challenge. It starts simple but it will test you on your implicit assumptions about valuation. It does not have to be turned in to me and it will not be graded. I will post the solution on Sunday and you can check your answer out. Just another prod on the project. Please pick a company and find a group soon. If you are on the orphan list and are still having trouble finding a group, let me know.
2/3/17 Just two quick notes. The first is that I did put up an in-practice webcast today. It is a very basic webcast on how to read a 10K, using P&G as my example. The links are below:
Downloadable video: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/Reading10Knew.mp4
YouTube Video: https://youtu.be/UzUJzdn7c2w?list=PLUkh9m2BorqmRAGzJb5OIvTAKZZu9HWF-
P&G 10K: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/PG/Reading10KPG.pdf
P&G Valuation (excel spreadsheet): http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/PG/P&Gvaluationfixed.xls
The second is that I am still working on getting you access to S&P Capital IQ and should be able to give you an update later. It will make your data collection a lot easier.
2/4/17

As you get ready for Super Bowl weekend, I thought I would get my dibs in early. I have attached the second newsletter to this email. Also, if you do get a chance, please try the weekly challenge that I sent you a couple of days ago. (Since for many of you, that seems like decades ago, I have attached it again). And please do nail down a group and a company to value!

Attachment: Issue 2 (February 4)

2/5/17 I am sure that you are not checking your emails in the middle of a Super Bowl party, while Lady Gaga is performing , or are you? In case you are, the solution to the weekly challenge is attached and if the Patriots don’t score soon after the second half starts, it may be more interesting than the game. Please take a look at it, and in case you gave it your best shot, compare it to your answer. This week, we will continue our discussion of equity risk premiums by introducing the notion of an implied equity risk premium in class tomorrow. Since the concept takes a little getting used to, you may want to read ahead by looking at this blog post on equity risk premiums:
http://aswathdamodaran.blogspot.in/2017/01/january-2017-data-update-2-resilience.html
On Wednesdays, we will turn to measures of relative risk (including betas) and move on to computing costs of equity.
2/6/17

In the session today, we started by doing a brief test on risk premiums. After a brief foray into lambda, a more composite way of measuring country risk, we spent the rest of the session talking about the dynamics of implied equity risk premiums and what makes them go up, down or stay unchanged. We then moved to cross market comparisons, first by comparing the ERP to bond default spreads, then bringing in real estate risk premiums and then extending the concept to comparing ERPs across countries. Finally, I made the argument that you should not stray too far from the current implied premium, when valuing individual companies, because doing so will make your end valuation a function of what you think about the market and the company. If you have strong views on the market being over valued or under valued, it is best to separate it from your company valuation. I am attaching the excel spreadsheet that I used to compute the implied ERP at the start of February 2017. Play with it when you get a chance. Post class test and solution attached.

Attachment: Post class test and solution

2/7/17 Sorry it took me so long but the valuation of the week is up and this time, we have a real company, Apple. I have gathered the facts in this page:
http://people.stern.nyu.edu/adamodar/New_Home_Page/Valuationofweek/AppleValuation2017.htm
This valuation has a little bit of everything that we have talked about in the class - the need for a story, connecting story to numbers and why value can be different from price. It also has enough of the details that we talked about - risk free rate, equity risk premiums and a preview of betas. Please give it a shot and after you have, download the spreadsheet with my latest valuation of Apple:
http://www.stern.nyu.edu/~adamodar/pc/blog/AppleFeb2017.xls
Feel free to disagree with my story and make it yours. Change the inputs in the spreadsheet and see what happens to the value.
https://docs.google.com/spreadsheets/d/1T8Sj37Y2uBwjT6REYMsVtlneO-Q416dKlBB13rhLijM/edit?usp=sharing
I hope that we can get a couple of hundred of you valuing Apple before next week.
2/8/17

In today’s class, we started by reviewing the pitfalls of regression betas and went on to talk about 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.
http://www.stern.nyu.edu/~adamodar/New_Home_Page/TenQs/TenQsBottomupBetas.htm
We then started on the cost of debt, starting with a definition of the cost of debt as a long term, current cost of borrowing and laying out a procedure for estimating this cost. Next session, we will complete the cost of capital discussion and move on to cash flows. I am attaching the post class test and solution for today's class.

For this week’s weekly challenge, you will be looking at equity risk premiums. There is a lot of mythology about equity risk premiums and the best way to separate the truth from fiction is to look at the data. That is what we do in this week’s challenge. The attached dataset contains my estimates of implied ERP each year, with the T.Bond rate, the T.Bill and the Baa bond default spread each year. Your mission, if you accept it, is to play Moneyball with the data and to try and answer a few questions:
1. What, if any, relationship is there between the ERP and interest rates (T.Bond and T.Bill)?
2. What, if any, relationship is there between the ERP and bond default spreads?
3. Given interest rates today and the default spread today, what would you expect the ERP to be today?
4. Given the actual ERP, what does this tell you about stocks being cheap or expensive?
Have fun with the numbers. Pull out your statistical tools, rusty though they might be, and use them.

Attachments: Post-class test and solution

2/9/17

I want to check to see where you are on the project. Assuming that you have picked a company, joined a group and downloaded the financials, I hope that you have estimated a risk free rate in the currency of your choice. Once you have that, please try the following:
1. Get a geographical breakdown of the countries/regions of the world that your company operates in. It should be in your annual report or financial disclosure forms somewhere. If you cannot, them's the breaks...
2. Get the total equity risk premium and country risk premium for the countries/regions: If you want to do this yourself, the weekly challenge will give you a template. If you want to take a short cut and use my estimates of country risk premiums, that is fine too.
3. Get a weighted average of the country risk premiums: You can use revenue weights of the country/region to compute the weighted average.
I will be posting two valuation tools webcasts tomorrow, one on the risk free rate and one on estimating equity risk premiums that you may (or may not) find useful.

Speaking of valuation (and that is always all I am speaking about), I don’t know whether you have had a chance to see the valuation of the week yet, but if you have not, please take a look. In fact, you can supplement it with this blog post that I put up on Apple a few minutes ago (fresh off the press):
http://aswathdamodaran.blogspot.com/2017/02/apple-greatest-cash-machine-in-history.html
Read it, if you get a chance.

I am not sure whether this will help you keep on track or freak you out, but I have opened a Google shared spreadsheet with everyone in the clas on it for the project. You can go in and input the data on your company as you get deeper and deeper into the project.
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/17A20IuBTPnBeupA0iHIS4yqSAqjSSOyFaYHOq5tpCyo/edit?usp=sharing
I won’t use the Google spreadsheet in my grading. It is just so that you can see where you are on the project, relative to the rest of the class.

2/10/17 First things first. I have been told that you should be able to access S&P Cap IQ data now. Since I take everything that I am told with a grain of salt, could you check and make sure that this is true. (It should be a live link under Sternlife.) Two tools webcasts are up this week. The first one is on risk free rates and the second on implied equity risk premiums.
Risk free Rates
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/riskfree.mp4
Slides: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/riskfree/riskfree.ppt
Additional material:
Moody’s ratings (3/13): http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/riskfree/Moodys.pdf
Sovereign CDS spreads (3/13): http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/riskfree/CDSfeb13.pdf
Implied Equity Risk Premiums
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/ImpliedERP.mp4
The supporting materials are below:
Presentation: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/ERP/ImpliedERP.ppt
Implied ERP spreadsheet (from February 2013): http://www.stern.nyu.edu/~adamodar/pc/implprem/ERPFeb13.xls
S&P on buybacks (from earlier this year): http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/ERP/SP500buyback.pdf
S&P 500 Earnings: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/ERP/SP500eps.xls
I hope that you get a chance to watch one or both!
2/11/17

The third newsletter is attached and I hope that you get a chance to browse through it. Also, I am going to nag you to go into the Google shared spreadsheet and start entering details of the company you have chosen:
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/17A20IuBTPnBeupA0iHIS4yqSAqjSSOyFaYHOq5tpCyo/edit?usp=sharing
It will let me see what you are doing and you keep tabs of where you are in class. I would like to see this spreadsheet filled up by next week. If you have not tried the weekly challenge (look under the webcast page for the class: http://www.stern.nyu.edu/~adamodar/New_Home_Page/webcasteqspr17.htm) or valuation (also on the same page), given them a shot.

Attachments: Issue 3 (February 11)

2/12/17

I hope that your weekend went well, bad weather notwithstanding. I also hope that you got a chance to try out the weekly challenge that I sent you. If you did, you got to test out your rusty excel statistics tools or perhaps Minitab. I am attaching both the weekly challenge and the solution. Give it a look, when you get a chance.
This week, we will continue our DCF discussion by putting to rest discount rates tomorrow and then moving on to earnings and cash flows. If you want to start applying what we talk about in class quickly to your company, I would suggest printing off your company’s most recent income statement and looking at the footnotes to see if the company has operating lease commitments. In tomorrow’s class, I will argue that accounting makes a hash of both operating leases and R&D and how and why we have to fix the accounting mistake before we do valuation. On Wednesday, we will keep going on cash flows, bringing in questions about accounting fraud and how to estimate free cash flows to equity.

Attachments: Weekly Challenge #2a solution

2/13/17

In today’s class, we started with computing debt ratios for companies and how to deal with hybrid securities.. If you are interested in getting updated default spreads (on the cheap or free), try the Federal Reserve site in St. Louis:
https://fred.stlouisfed.org/categories/32297
These are spreads on indices created by rating, updated daily. Neat, right?

We then moved on to getting the base year's earnings right and explored several issues:
1. To get updated numbers, you should be using either trailing 12 month numbers or complete the current year with forecasted numbers. In either case, your objective should be to get the most updated numbers you can for each input rather than be consistent about timing.
2. To clean up earnings, you have to correct accounting two biggest problems: the treatment of operating leases as operating (instead of financial) expenses and the categorization of R&D as operating (instead of capital) expenses. The biggest reason for making these corrections is to get a better sense of how much capital has been invested in the business and how much return this capital is generating.
Finally, I have one unattached person whose group came apart. Would you have space for one more person in your group? If so, please let me know!
Post class test and solution attached. (I know a couple of the questions are about tax rates and normalizing income).

Attachments: Post class test and solution

2/14/17 This week, I will be valuing a company that most of you probably have not heard off. In fact, I had never heard of the company until last Thursday, when I decided to pick a company to value for my Nigerian trip (coming up in two weeks). The good news that comes out of this ignorance is that I had absolutely no preconceptions about the company, unlike my valuation of Apple last week, where my connections to the company run deep and sometimes get in my way. The bad news is that I know nothing about the company’s management and its products and very little about the Nigerian economy. Keep that in mind as you read the narrative that I have set up for this week’s valuation:
http://www.stern.nyu.edu/~adamodar/New_Home_Page/Valuationofweek/PZ Cussons.html
After you have read the narrative, you can download the spreadsheet that contains the valuation here:
http://www.stern.nyu.edu/~adamodar/pc/country/PZCussons.xls
Even if you are as ignorant as I am about the company, I would encourage you to play with the numbers just to get a feel for what growth rates and costs of capital look like in a high inflation currency (Nigerian Naira). Look at the story that I am telling about the company and see if your story is different and if so, how it will play out in your valuation inputs. Once you have a valuation, please do put your two cents in the Google shared spreadsheet:
https://docs.google.com/spreadsheets/d/14ARr-6hPgvEkTAcmn7x57jhGuTJIObC35Q4XXXzQ8J8/edit?usp=sharing
2/15/17

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.

I also mentioned forensic accounting in the context of accounting game playing. While truly extraordinary items are easy to deal with, accounting ploys to move expenses into the extraordinary column may require some detective work. For those interested in forensic accounting, here are a couple of references:
http://www.amazon.com/Financial-Shenanigans-Accounting-Gimmicks-Reports/dp/0071703071/ref=pd_sim_b_8 <http://www.amazon.com/Financial-Shenanigans-Accounting-Gimmicks-Reports/dp/0071703071/ref=pd_sim_b_8>
http://www.amazon.com/Creative-Cash-Flow-Reporting-Sustainable/dp/0471469181/ref=pd_sim_b_2 <http://www.amazon.com/Creative-Cash-Flow-Reporting-Sustainable/dp/0471469181/ref=pd_sim_b_2>
In the final part of the class, we turned to historical growth and how even this simple number can be affected by choices you make about starting points, scale and averaging approaches.

Attachments: Post class test and solution

2/15/17

This week’s challenge will help you nail down the concepts of adjusting earnings for leases and R&D and how to compute synthetic ratings. It is good preparation for the quiz. So, give it your best shot and I will send you the solution on Sunday.

Attachments: Weekly challenge #3

2/16/17

We are done with the cost of capital portion of the class and while I know that this is probably unrealistic, it is a good time for you to compute the cost of capital for your firm. If you have not started and are intimidated, try this paper that I have on estimating and using cost of capital
http://www.stern.nyu.edu/~adamodar/pdfiles/papers/costofcapital.pdf
Once you have finished with that, if you want to see what the costs of capital look like across different sectors in the US, try this link.
http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/wacc.html
If you want to see the global or emerging market numbers, try the data portion of my website:
http://www.stern.nyu.edu/~adamodar/New_Home_Page/data.html

Two more quick notes. First, there is no class on Monday (2/20). So, have a long weekend, enjoy yourself and start on your work for the first quiz, which will be a week later on February 27, 2017. The past quizzes for this class are at the link below.
http://people.stern.nyu.edu/adamodar/New_Home_Page/eqexam.htm
Stick with quiz 1 and use the most recent quizzes (perhaps the last 5-6 years) as indicators, since some of the earlier quiz 1s covered more material. The quiz will not cover what we do next Wednesday but it will cover everything through cash flows (page 152 in lecture note packet 1). Thus, if you see a growth rate problem on a prior quiz, just ignore it. Second, the TAs have been having review sessions and have one planned for next week. If you want to sign up for it, here is the link:
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/1ADgs4uTcJKrDKuaNbz7EeYkFn5b1QWanF83x_DIADCk/edit?usp=sharing
Until next time!

2/17/17 I know that you have big and fun plans for the weekend and it is my job to ruin them. If you feel the urge to catch up on your project, I am going to give you the capacity to do so by posting not one, not two but three in-practice webcasts:
1. Trailing 12-month numbers: In the webcast for this week, I look at how to compute trailing 12 month earnings from a 10K and a 10Q:
http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/Trailing12month.mp4 (Uses Apple from late 2012)
The most productive use of the webcast is to print off the most recent annual and quarterly report for your company and work with your company’s numbers.
2. Converting leases to debt: I have also posted a second webcast on converting leases to debt which takes you through the process of which numbers to use in this conversion and how to deal with loose ends (like the lump sum that is often given for past 5 years).
http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/Leases.mp4
3. Converting R&D to capital expenditures: We also talked about converting R&D from operating to capital expenses. I use Microsoft from a year gone by to illustrate this concept:
How to capitalize R&D: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/R&D.mp4
Microsoft 10K 2011: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/R&D/Microsoftlastyear10K.docx
Microsoft 10K 2012: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/R&D/Microsoft10K.docx
You may be wondering whether to spend your time on these or on preparing for the quiz but sometimes doing the project work is the best preparation for the quiz.
2/19/17

I hope that you are enjoying this long weekend and the great weather. That said, I hope that you are also catching up on your project. If you had a chance to work through the third weekly challenge, the solution is attached. If you did not, I would suggest working through it, at least as review for the first quiz. You will notice a synthetic ratings spreadsheet attached, where I estimate a rating and a cost of debt for the company.
Looking ahead to the coming week, we have only one class on Wednesday and we will dive into growth. After tying up the last loose ends on historical growth, we will look at the pluses and minuses (mostly the latter) of using analyst estimates of growth and then turn to growth estimates based upon fundamentals. The good news, if you are exam focused, is that this material will not be part of quiz 1 but it will not only be part of quiz 2 but will be integral to the DCF that you are doing on your company. (By the way, have you entered your company into the Google shared spreadsheet.
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/17A20IuBTPnBeupA0iHIS4yqSAqjSSOyFaYHOq5tpCyo/edit?usp=sharing
You will start hearing from me, if you do not.

Attachments: Weekly challenge #3, Solution & Synthetic rating

2/21/17 I know that most of you have Snap on your phone and your own reasons for liking it more or less than Instagram. In fact, you have an advantage over me, since I have neither and had to put my seventeen-year old son through a strenuous questioning to find out the pluses and minuses of each (and I am still a little fuzzy about how these filters make things better). Since the Snap IPO is coming up and has been priced, this is as good a time as any for us, as a class, to value Snap.You can check out the prospectus for teh IPO (if you have never gone through a prospectus, this is a nice start):
https://www.sec.gov/Archives/edgar/data/1564408/000119312517029199/d270216ds1.htm
You can read my post on the Snap IPO and valuation:
http://aswathdamodaran.blogspot.com/2017/02/a-snap-story-valuing-snap-ahead-of-its.html
You can follow up by downloading my spreadsheet with the valuation:
http://www.stern.nyu.edu/~adamodar/pc/blog/SnapIPOFeb2017.xls
You can them disagree with me on my story and numbers, change the inputs and come up with your own value. Enter them into the shared Google spreadsheet.
https://docs.google.com/spreadsheets/d/1zEVbpRWtDlGbpy2eBOras7KD-V7OjC74h7AEo8_VTQs/edit?usp=sharing
I know that this week is quiz week and that you have other things on your plate, but let’s make this a crowd valuation of the company and see how it goes.
2/22/17

We continued our discussion of growth by first looking at the limitations of analyst estimates of growth and then examining 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 two 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? In the next session, we will continue this discussion after the quiz.

Attachments: Post class test and solution

2/22/17 The first quiz is coming up and I wanted to cover some logistical details.
1. Quiz location and timing: The quiz will be from 2-2.30 on Monday, February 27. There will be an extra room to take the quiz. Please see below for where you should go for the quiz:
If your last name begins with Go to
A - I KMEC 1-70
J - Z Paulson
There will be class after the quiz. So, please come to Paulson, when you are done with your quiz.
2. Quiz coverage: The quiz will cover everything through midway through last Wednesday’s class (about slide 152). It will therefore include the big picture sessions on valuation, discount rates and cash flows.
3. Past quizzes: I am reposting the links to the quizzes from just the past few years. While there are older quizzes you can cover, these are much more relevant for the quiz at hand.. If you do run into a growth question, skip it.
Practice quizzes: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/shortquiz1.pdf
Practice quiz solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/shortquiz1sol.xls
As you work through these quizzes, please do remember that I will be grading the quizzes, not a computer or a TA. I grade on process. Please show your work, with your solution and I am perfectly open to alternate solutions to problems, if I feel that you have been logical and consistent and used all of the information in the problem.
4. Quiz review webcast: I have a webcast that I have put together where I take you through the material that will be covered on the quiz. It is about 35 minutes long and it may help you get ready for the quiz (or not)…
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/valquiz1review.mp4
Slides: http://www.stern.nyu.edu/~adamodar/pptfiles/val3E/valquiz1review.pptx
I hope that you find it useful.
2/24/17 I know that the project is not even on your mind this week, as you get ready for the first quiz. However, they are not mutually exclusive. To the extent that your firm has operating leases or R&D, you should try capitalizing them and view it as prep for the final. If you can estimate the free cash flow to the firm and free cash flow to equity last year, you are well on your way.
Now that we are on to growth, you can try a couple of exercises with your company:
1. Compute historical growth, across different time periods, in different measures, and using arithmetic and geometric averages.
2. See if you can find analyst estimates of growth for your company and whether you can decipher what measure (revenues, operating income, net income or earning per share) the estimate is for.
Next week, we turn to the fundamentals that drive growth.
2/25/17 Accounting returns can be messy and misleading but they are a key input into estimating growth and the value of growth. In this webcast, I look at the process of estimating accounting returns, using Walmart as my example:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/ROIC.mp4
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
Spreadsheet: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmartreturncalculator.xls
2/25/17

Just a quick note. The weekly newsletter is attached. I would wish you a great weekend, with the uncommonly warm weather, but I may risking blowback, since I might have ruined it for you. I live to inflict pain, though!

Attachment: Issue 5 (February 25)

2/26/17

I’ll keep this brief since you are probably busy preparing (if you say, “for what”, I think that you are in big trouble). A reminder again about tomorrow’s quiz and quiz seating. The quiz is in the first 30 minutes of class (from 2-2.30) and it is open-book, open-notes but no laptops or connectivity. The seating is as follows:
If your last name begins with Go to
A - I KMEC 1-70
J - Z Paulson
There will be class after the quiz. Finally, in case you tried the weekly challenge this week, the solution is attached.

Attachment: Weekly challenge #4 solution

2/27/17

The good news is that the first quiz is over and I will let you know as soon as it is ready to be picked up. If you were able to hang in there mentally and physically, we continued our discussion of growth by the fundamentals that drive growth. In particular, we looked at how much efficiency can add to growth and how to estimate growth in companies with negative earnings. I have shortened the post-class test and solution for this session, since it was a short session.

Attachments: Post class test and solution

2/28/17

Your quizzes are done and are ready to be picked up.
Where? The quizzes are on the ninth floor of KMEC. As you come off the elevator and before you get to the door leading into the offices, look to your right and you will see a table. The quizzes are on the top shelf.
How? They are in alphabetical order, face down and sorted neatly into three piles. Please just take your quiz, don’t browse and do not mess with the sorted stacks. I have cameras installed that are watching you at all times and drones ready to attack, if you try!
Score check: Once you get the quiz, please take a look at the attached solution. It includes my grading template. You will notice that there two solutions. The first one (EquQuiz1asol) has Savoy/Zuma as the company names for the first problem and the second one (EqQuiz1bsol) had Logue/Henzel as the company names for the first problem. If you feel that I have been unfair to you, you can either come into my office or take a picture of the section of the quiz with which you have a grading issue and send it to me.
Grade check. You can also check your quiz score against the distribution that I have attached. Remember that not only is this quiz only 10% of your grade but that your worst quiz grade, if you take all the quizzes, will be replaced by your average score on the other exams. So, if you did badly, relax! And if you did really well, chill!

Attachments: Solution (a or b) as well as the distribution of grades

2/28/17

In this week’s valuation of the week, I take a look at Tesla, a fascinating company that I have called the ultimate story stock. To understand why, start with this blog post:

http://aswathdamodaran.blogspot.com/2016/07/tesla-story-meets-numbers-promise-meets.html

In the post, I value Tesla at about $152 (it was trading at $224) and you can find the valuation at this link:
http://www.stern.nyu.edu/~adamodar/pc/blog/TeslaJuly2016X.xlsx
The valuation is from July and Tesla has since reported earnings a couple more times, including its most recent report last week. In my view, not much has changed at the company other than the fact that the Solar City acquisition is now complete and that there is even more confusion about what type of company Tesla is. You can read the most recent earnings release here:
http://files.shareholder.com/downloads/ABEA-4CW8X0/2425538600x0x929284/22C29259-6C19-41AC-9CAB-899D148F323D/TSLA_Update_Letter_2016_4Q.pdf
The full 10K has not been filed yet and I will do a full valuation update until it is, but that should stop you from trying. If you do and want to partake, please enter your story and numbers for Tesla in this shared spreadsheet:
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/15BauiYIeG2SJ6jNHDSDRvXV6FhJxtelnDq1T_pKiMUA/edit?usp=sharing
Have fun with it!

3/1/17

In today’s class we began by looking at the four rules that keep terminal value in check. We then looked at which model to use in valuing a company and then moved on to 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 March 24 but only for feedback, not grading. So, don't feel the pressure to get it right. Just get it done. I have also attached weekly challenge for this week, if you feel the urge to try them. If not...

Attachments: Post class test and solution, Weekly challenge #4a

3/2/17 In yesterday’s class we started with a discussion of which model to use in valuing a company and then moved on to 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. Now that the quiz is behind you, it is time to turn your attention to your project, recognizing that the DCF for feedback (not a grade) is due on March 24, the Friday of the week that you get back from break. We have covered everything you need to do this in class from estimating the inputs to picking the right model. So, no reason to put it off any more. Incidentally, I am in Lagos, Nigeria, until Saturday. So, if you have questions about your quiz, and you want to see me, you’ll have to wait until Monday.
3/3/17 In this week’s webcast, I look at the terminal value and how to run diagnostic checks on it to make sure that you have been internally consistent and grounded while estimating this number.
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/terminalvalue.mp4
Sample DCF: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/TermValueCheck/termvalueDCF.xls
Diagnostic Spreadsheet: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/TermValueCheck/termvaluecheck.xls
Hope you get a chance to check it out.
3/4/17

Just a quick note. The newsletter is attached. I hope that you are getting a chance to work on your DCF as well.

Attachment: Issue 6 (March 4)

3/5/17

This week, we will close out the loose ends part of DCF tomorrow and then talk about how to connect stories to numbers on Wednesday. Since the week after is Spring break and your DCF is due for feedback on the Friday of the week you get back, please do start on your DCFs. I am attaching the solution to the last weekly challenge.

Attachment: Solution

3/6/17

Today we put the last loose ends to rest. First, we completed the discussion of cross holdings and why they are so difficult to deal with in valuation. Second, well looked at complex businesses and how to incorporate our concerns into value. Then, 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. Next, 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. If you are still a little shaky on why stock-based compensation should not be added back as a non-cash expense, please read this post:
http://aswathdamodaran.blogspot.com/2014/02/stock-based-employee-compensation-value.html
Again, I plead (beg, cajole) that you keep moving on your DCF. It is daunting if you just keep thinking about doing it. It is actually much easier to just do it.

Attachments: Post class test and solution

3/7/17 I decided to use a bank as this week’s valuation of the week, partly because I felt like doing it and partly to help those of you valuing financial service companies. The bank that I valued was Deutsche Bank in October 2016, when it was the throes of a crisis. You can get the back ground and my narrative at this blog post:
http://aswathdamodaran.blogspot.com/2016/10/deutsche-bank-greek-tragedy-at-german.html
You can follow up by downloading my valuation of Deutsche Bank here:
http://www.stern.nyu.edu/~adamodar/pc/blog/DeutscheBank2016.xls
Finally, the stock is up to about $18, but that is after a disastrous couple of days where it dropped almost 10% after it announced new plans
https://www.bloomberg.com/news/articles/2017-03-05/deutsche-bank-board-said-to-meet-on-8-5-billion-capital-raise
If you get a chance, please take my valuation and make it yours, changing what you don’t agree with and leaving alone what you do. Once you are done, you can put your numbers into the shared Google spreadsheet at this link:
https://docs.google.com/spreadsheets/d/1E6mPJYeWECpl4s26ADza3RuaOerFV_PjcJCeRd1aXYc/edit?usp=sharing
3/8/17

As you slip into spring break mode, today’s class was about connecting stories to numbers. Using Uber as an example, I went through the process of telling a story about a company and then converting that number into a valuation. Ultimately, valuation is as much about story telling as it is about modeling. The post class test and solution are attached.

Attachments: Post class test and solution

3/10/17

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 that you may find useful to keep yourself moving forward. 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:
a. fcffginzu.xls: For a firm with stable operating income and return on capital: http://www.stern.nyu.edu/~adamodar/pc/fcffginzu2017.xls
b. fcffsimpleginzu.xls: For a money losing firm or a high growth firm or want to allow your margins to change over time (This is the most general model and you can use it for almost any non-financial service firm): http://www.stern.nyu.edu/~adamodar/pc/fcffsimpleginzu2017.xls
c. fcfeginzu.xls: For valuing a firm using the FCFE approach: http://www.stern.nyu.edu/~adamodar/pc/fcfeginzu2017.xls
d. divginzu.xls: for financial service firms and perhaps REITs/MLPs: http://www.stern.nyu.edu/~adamodar/pc/divginzu2017.xls
The valuations are due for feedback by March 24 and I want to reemphasize it is not for a grade. You are not obligated to make changes based on my feedback and view them just as suggestions. When you do turn in your DCF for feedback, please use “My Perfect DCF” in the subject so that I can put it into the right mailbox. I don’t expect you to be working on your DCF on your spring break. So, go some place sunny, have fun and come back refreshed and ready to go. Of course, if you insist on working on your valuation while sitting on a beach somewhere, who am I to stop you?

Attachments: Valuation Checklist

318/17

You must admit that I was remarkably self-restrained during the break and fought the urge to send you more and more messages. That time is now over and I am baaaaaaaack!
1. Class: If you have completely lost track of where we are in the class, I would start with the newsletter, where I mention where we are on the class and where we are going.

2. The Project: As you know (or should know), your DCF is due this Friday for review. It is true that there is no grade attached to it but it you chance to get some feedback on the session. To advance you on the valuation, I have a tools webcast on dealing with equity options in a company,. Let’s face it. 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 last week's weekly challenge was 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:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/Employeeoptions.mp4
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.

3. Lecture Note packet 2: Finally, we are approaching the end of the first lecture note packet for the class. When you get a chance, please print off or download or buy the second packet:
http://www.stern.nyu.edu/~adamodar/pptfiles/val3E/valpacket2spr17,pptx
If you buy the packet in the bookstore, it should include both packets 1 & 2.

Attachments: Issue 7 (March 18)

3/20/17

In today's class, we started with a quick review of narrative changes, shifts and breaks and how earnings reports, in particular, can alter your narrative for a company. Since many of you will be dealing with new earnings reports, I thought you may find these two posts of interest in how narratives shift, and with them, values:
Reacting to Earnings Reports: http://aswathdamodaran.blogspot.com/2014/08/reacting-to-earnings-reports-lets-get.html
Narrative Resets: http://aswathdamodaran.blogspot.com/2015/08/narrative-resets-revisiting-tech-trio.html
We started with three conventional valuations, one of Con Ed, another of 3M and the third of the S&P 500. We then started on the dark side of valuation and we will continue on that path on Wednesday.

I hate to be a nag but your DCF is due for feedback on Friday. Again, I will emphasize that I will not be grading your DCF. Here are some more details about this submission:
1. All you will be doing is sending me your spreadsheet for your company (it could be one of my spreadsheets that you have adapted to your company). I have made a big deal about story telling but you can put your story into the spreadsheet, generally on your input page. I like to connect my story to individual assumptions. I have attached my Snap example.
2. I will take a look and provide feedback which can range from “This looks good. Nothing more to do” to “These numbers are at war with each other”, with specific comments on inputs that worry me. You are welcome to modify your valuation to reflect my feedback or to ignore it.
3. If you are already done, you can send it to me any time you feel ready to do so. Just one request. Given that I have two classes of 300 and emails can get lost, please make sure that you include “MY PERFECT DCF” in the subject line. Please don’t try to be clever and modify this title since it is a computer algorithm that does not get either nuance or irony.

Attachments: Post class test and solution

3/21/17 Remember that we were talking about the connection between story telling and numbers. I noted at the end that while it is critical that you tell a story about your company, it will not always be a happy story. This week’s valuation of the week is not a happy story. It is a story of Valeant, a once high flying company that shifted to being a cash cow to a dog to damaged goods in the blink of any eye. The place to start this story is with my first post on Valeant in November 2015, right after its fall from grace when many value investors were convinced that the market had unfairly sold off the stock:
http://aswathdamodaran.blogspot.com/2015/11/checkmate-or-stalemate-valeants-fall.html
You can follow this up with this post in May 2016, when many people had given up on the stock:
http://aswathdamodaran.blogspot.com/2016/04/valeant-information-vacuums-management.html
In November 2016, even more people had abandoned the stock and here is what I posted:
http://aswathdamodaran.blogspot.com/2016/11/faith-feedback-and-fear-returning-to.html
It is now March 2016 and it is tough to find anyone who likes the stock. You can read my latest take here:
http://people.stern.nyu.edu/adamodar/New_Home_Page/Valuationofweek/ValeantMarch2017.html
My valuation of Valeant is in the attached spreadsheet:
http://www.stern.nyu.edu/~adamodar/pc/blog/ValeantMarch2017.xls
I know that you are busy with your own company but if you want to play with the numbers and enter your Valeant value in the Google shared spreadsheet below, you can be my guest:
https://docs.google.com/spreadsheets/d/1BlPY4Z5RAyJPYxRhTRoYkpBBRlosrws7H5MvHV1pY7E/edit?usp=sharing
3/22/17

In today’s class, we started on the dark side of valuation, where we value difficult-to-value companies. We started 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. I argued that to to value a young company, you have to visualize what you see as success for it and work backwards to get the numbers by year, and adjust this valuation for the likelihood that the company will not make it. We then moved on to companies in transition and how you can arrive at two values for these companies: a status quo value and a changed-management value and how you have to take an expected value. We closed off by looking at declining and distressed companies, arguing that you need to adjust your expected value for the likelihood of truncation risk or failure. On an unrelated note, NYU has finally picked a day for the final exam for this class. Since you have to make travel plans, I thought I should let you know that the final exam is scheduled for May 15 (Monday of the final week). More on that as we get closer.

Attachments: Post class test and solution

3/23/17 The DCF is due by late Friday (try to get it in by 5 pm, but if not, 6 pm or 7pm..). A few notes on the submission:
1. Individual, not group: This portion of the submission can be done individually and should be done individually rather than as a group, The feedback is specifically for you.
2. Submission content: An Excel spreadsheet will do, with notes embedded on your story and any specific assumptions
3. Submission subject: Use “My Perfect DCF” in your subject
Remember that this DCF is for feedback, not a grade, but work on it as if were your final valuation. That way, the feedback will be more focused and perhaps more useful. About a fifth of the class has sent their DCFs to me and I will try to get those back by the end of today. To put a bow on this part of the class, I have a blog post that you may find enjoyable about dysfunctional DCFs.
http://aswathdamodaran.blogspot.com/2015/02/dcf-myth-1-if-you-have-ddiscount-rate.html
I hope that none of your DCFs fall on this list.
3/25/17

I have attached the latest newsletter for the week. Thank you again for all of your DCF valuations. I got through about 150 of them yesterday but I have another 150 that I have not got to and I will try my best to work through them, but I also have a quiz to grade this week. So, don’t be surprised if you don’t hear back until Tuesday. I apologize for the tardiness but I am hopeless at multitasking, especially when that requires to me grade a quiz and look at a DCF at the same time. Just a reminder that we will be starting on the second packet in class this coming week. Packets 2 & 3 should be available as one packet in the bookstore. Alternatively, you can download packet 2 at the link below:
http://www.stern.nyu.edu/~adamodar/pptfiles/val3E/valpacket2spr17.pptx
I will see you in class on Monday and if I seem abrupt in your DCF feedback, it is not because I have any antipathy towards you but in the interests of brevity.

Attachments: Issue 8 (March 25)

3/26/17

By now, many of you (about 200, by my count, out of a class close to 300) should have received back your DCF valuation back. If you have not received yours back, you should be getting it in the next day or two. 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.

Narrative checks
In class, I have made a fetish about connecting stories to numbers and I am going to stick with that fetish. As I looked at your valuations, I always stopped and asked what the underlying story you were telling about your company. You did a really good job, collectively, and I would classify the submissions into three groups:
1. Story-driven valuations: Many of you sent in valuations that not only had a story but tied inputs to that story and you are well on your way to understanding valuation as a craft.
2. Stories that don’t quite hang together: Some of you told stories that were at war with themselves (with different parts pulling in different directions) because you told individualized stories for each input.
3. Valuations with implicit stories: While some of you may have no specific story in mind, your numbers told a story that you may or may not agree with. Thus, if you were valuing Amazon and your revenues in year 10 are 500 billion and your operating margin is 4%, the story that you are telling about Amazon is that it is going to continue to go for more revenue growth, sacrificing margins and that it will pulverize the rest of the retail business. In some of your valuations, the story seems at war with itself. Thus, if you have your company’s revenues tripling in a mature market and your margins also going to well above industry averages, your story is quickly becoming implausible. I would strongly encourage you to take a look at your valuation (look at your year 10 numbers specifically) and think about the story that you are telling. Otherwise, it is just a spreadsheet with a bunch of numbers.

Input page checks
Step 1: Currency check: What currency is this company being valued in and is the riskfree rate consistent with that currency?
Right now, if you are valuing a company in US dollars, I would expect to see a riskfree rate of about 2.5% here.. though some of you used 30-year bonds rates which would give you a slightly higher value). if you are valuing your company in pesos or rubles, I would expect to see a higher riskfree rate, (Watch out for the tricky ones.. a Mexican company being valued in US dollars or a Russian company in Euros.. Your riskfree rates should revert back to the Euro riskfree rate, if this is the case)
Step 2: ERP check: Is the equity risk premium being used consistent with where the market is right now and where this company has its operations?
If you are analyzing a company with operations only in developed markets, I would expect to see a number of about 5-6% here... That is because the current implied premium in the US is about 5.39% (March 2017). If you are using a premium of 4%, you will over value your company. If your company is exposed to emerging market risk, I would expect to see something added to the mature market premium. While I begin with the presumption that where your company is incorporated is a significant factor in this decision, it should not be the only one in this decision. Coca Cola and Nestle should have some emerging market risk built into them.
Step 3: Units check: Are the inputs in consistent units?
Scan the input page. All inputs should be in the same units - thousands, millions, billions whatever... What you are looking are units with far too many digits to make sense. (Check the number of shares. It is the input that is most often at variance with the rest, usually because you use a different source for it than the financial statements)
Step 4: Normalization check: If earnings are being normalized, what is the normalized value relative to the current value? If reinvestment numbers are off, should they have been normalized as well?
In some cases, we normalize earnings by looking at historical average earnings or industry average margins. While this is perfectly defensible, you want to make sure that the normalization is working properly. Thus, if earnings of $ 3 million are being replaced with earnings of $ 3 billion, you want to make sure that this company has generated earnings like these in the past. You may also want to consider an alternative which is to allow margins to change gradually over time rather than replace current with normalized earnings.
Step 5: Operating lease inputs
If you capitalize operating leases, make sure that you get the current year’s lease or rental expense in addition to the lease commitments. If you cannot find the former, enter a number equal to your first year’s lease commitment.
As a follow up, check the reinvestment rate for the firm. If it a weird number (900%, -100% etc.), it may be because something strange happened in the base year (a huge acquisition, a dramatic drop in working capital). A better choice may be to average over time.

Output page checks:
a. High Growth Period.
Start by checking the length of the growth period and the cash flows during the growth period. In particular,
- Compare the FCFF (or FCFE) to the EBIT (1-t) (or Net Income). Especially if you are forecasting cap ex, working capital and depreciation independently, compute an implied reinvestment rate
Implied Reinvestment Rate = 1 - FCFF/ (EBIT (1-t) or 1 - FCFE/ Net Income
Thus, if you have after-tax operating income of 100 and FCFF of 95, your implied reinvestment rate is 5%.
- Look at the expected growth rate over the period. Does it jive with your reinvestment rate? (If you see a high growth rate with a low reinvestment rate, the only way you can justify it is by calling on efficiency growth. For that argument to make sense, your current return on capital has to be a low number... See the attached excel spreadsheet that computes efficiency growth.

- If you are forecasting operating income, cap ex, depreciation and working capital as individual line items, back out your imputed return on capital:
Imputed Return on Capital = Expected EBIT (1-t)/ (Base Year Capital Invested + Sum of all reinvestment through year t-1)
If you see this number taking off through the roof or dropping towards zero by the time you get to year 10, your reinvestment assumptions are unreasonable.
b. Terminal value
Start by checking to make sure your growth rate forever does not exceed your riskfree rate. Then follow up by
- Examining your reinvestment rate in your terminal year, using the same formula we used in high growth
- Backing out your implied return on capital (ROC = g/ Reinvestment Rate)
- Checking against your cost of capital in stable growth (you don't want to get more than 5% higher than the cost of capital and you do not want to set it lower than the cost of capital forever)
I have a spreadsheet that can help in this diagnostic (and there is a webcast that you can use as well from a few weeks ago)

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.
c. Cost of capital
As a general rule, your cost of capital should be consistent with your growth assumptions. Thus, you should expect to see betas move towards the stable range (0.8-1.2) and your debt ratios to rise towards industry average. Thus, your cost of capital in stable growth should be different from the cost of capital in high growth.
d. Final value of equity
Check for danger signs, including
- Cash and cross holdings becoming a huge percentage of value
- Options either being ignored or being a huge number

Market Price
As a final sanity check, look at the current market price. If your value is not even in the ballpark, go back and repeat all of the earlier steps...

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 have also attached a full set of diagnostic questions that you can consider in the context of valuation to this email.

3/27/17

In today’s session, we continued our travels on the dark side, starting by valuing financial service companies (where loss of trust has driven us from dividend discount models), moving on to emerging market companies (with corporate governance, cross holdings and country risk all playing starring roles) and then looking at companies with intangible assets (where capitalizing R&D-like expenses can increase or decrease value) and to commodity and cyclical companies. I suggested that you use Monte Carlo simulations to bring in uncertainty into your valuations. We ended the class by drawing a contrast between value and pricing processes, a set up for the next phase of the class. Please print off or buy packet 2 to bring to class on Wednesday.

Attachments: Post class test and solution

3/28/17

I have put the review session for quiz 2 (scheduled for April 3) up online (on the webcast page for the class) with the presentation. The links are below:
Presentation: http://people.stern.nyu.edu/adamodar/pdfiles/eqnotes/valquiz2review.pdf
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/valquiz2review.mp4
You can also find all past quizzes with the solutions in the following links:
All past quiz 2s: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz2.pdf
Quiz 2 solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz2sol.xls

You will see relative valuation/pricing problems (multiples) popping up in the pre-2008 quizzes. You can ignore them! As for the quiz seating, here are the seating plans:
If your last name begins with Go to
A -I, S-Z Paulson
J - R KMEC 1-70

On a different note, I was planning to put up a pricing of the week for this week, but think I will skip it. I have asked enough of you already in the last two weeks.

3/29/17

In today’s class, we started by looking at why the value and pricing processes can diverge and the difference between investing and trading. Value is driven by cash flows, growth and risk and price is driven by momentum, liquidity and herd behavior. A trader makes money playing the pricing game (buy low and sell high) and an investor from playing the value game (buy something when its price is less than your assessed value and then wait for the gap to close). Each side has its own weaknesses, but it is important that you decide which game you are playing and choose the right tools for that game. We then looked at the process of relative valuation (pricing) by examining what goes into a multiple. Starting on the process of deconstructing the multiple, starting by defining the multiple and checking to see if it is consistently defined and uniformly estimated. We have a quiz on Monday and it will cover lecture note packet 1, through page 340 and will cover the rest of DCF not covered by the first quiz (everything from growth on). The quiz will be in the first 30 minutes of class and there will be class afterwards. Finally, if you are going to be missing the quiz, please let me know before 2 pm on Monday. On a completely unrelated note, I am returning to the practice of posting weekly challenges (on management options).

Attachment: Post class test and solution

3/31/17

I am piling on now, and I am sorry. However, the clock is running and we do have stuff to get done. Two quick notes. First, next week, we will be starting on pricing and using multiples. 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:
http://aswathdamodaran.blogspot.com/2013/06/a-tangled-web-of-values-enterprise.html
Then watch the webcast:
http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/multiplecalc.mp4
You can download the presentation:
http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/multiplecalc.mp4
And the spreadsheet that goes through the calculations:
http://www.stern.nyu.edu/~adamodar/pc/multiplecalculator.xls

Now, on to the other important note. As promised (or threatened), I will be getting your mystery project to you on Monday. It is a group project, due on April 14. I know that I am asking a great deal of you, with the DCF due last week, the quiz next week and the mystery project a week and half after that. I thank you, in advance, for the work that you will be putting into it.

4/1/17

I know that you are probably busy preparing for the quiz and I will keep this short. The newsletter is attached.

Attachments: Issue 9 (April 1)

4/2/17

A few last-minute notes about the quiz tomorrow.
Seating: As for the quiz seating, here are the seating plans:
If your last name begins with Go to
A -I, S-Z Paulson
J - R KMEC 1-70
Missing quiz? If you will be missing the quiz, please let me know before 2 pm tomorrow.
Material: The quiz will cover the rest of DCF, starting with growth, going through terminal value, the loose ends of valuation (cash, cross holdings and other assets) and ending with DCF mechanics.
In case any of you tried the weekly challenge for this week, here is the solution.

Attachments: Solution & Option value

4/3/17

Let me start off with a quick review of what we did after the quiz. We continued our discussion of PE ratios by looking at the distributional characteristics of PE ratios as well as the drivers of PE, arguing that its determinants are growth, risk and payout/ROE. A cheap stock is one with a low PE, high growth, low risk and a high ROE and that becomes the foundation for screening for cheap stocks. If you want to read up more on screening, try this blog post:
http://aswathdamodaran.blogspot.com/2012/06/passive-value-investing-screening-for.html

I am piling on but I cannot help myself. I know that you are recovering from the quiz but I had promised you a mystery project and I am delivering. The mystery project is a pricing project, not a valuation one. If you don’t get the distinction, rewatch yesterday’s lecture. The description of the project and the dataset that you will need to do it are both attached. This is a group project and the project report is due on April 19, 2017 by 5 pm.

4/4/17

The quizzes are ready to be picked up in the usual spot (KMEC, 9th floor, to the right just as you come off the elevator). They are in alphabetical order, face down, in two stacks. Please leave them in order and don’t browse. The solutions and the grading template are attached (with quiz a going with Cravath and quiz b with Swingell in problem 1). As always, if you feel that I have missed something or have been unfair in my grading, come in and talk to me.

Attachments: Solution (a or b) as well as the distribution of grades

4/4/17 I hope that you have had a chance to pick up your quiz. I know that you have a mystery project to do this week and won’t have time to add more to the list. So, I decided to make this week’s valuation exercise a pricing exercise and revisit two assets that people talk about all the time and can only be priced. One is gold and the other is bitcoin. I have tried to price both assets in blog posts, and while the posts are dated, the approach that I used can easily be updated:
My blog post on gold: http://aswathdamodaran.blogspot.com/2013/04/the-golden-rule-thoughts-on-gold-as.html
My blog post on bitcoin: http://aswathdamodaran.blogspot.com/2014/03/bitcoin-q-bubble-or-breakthrough-both.html
4/5/17

 

In this session, we extended the discussion of the analysis of multiples by looking at PEG ratios, EV multiples and book value multiples. Each multiple, we argued, has a driver and companion variable.We then moved on to application and how best to find comparable firms and control for differences. At this point, you have the tools you need to price just about any stock (or asset). Remember that you are paying to heed to the market, controlling for differences as much as you can and hoping that pricing divergences disappear over time. I am also attaching the weekly challenge for this week (on pricing).

Attachment: Post class test and solution

4/6/17 I know that you just got your quiz back and have a mystery project to work on. So, I would not blame you for putting the big project on the back burner. Assuming that you have done your DCF, and perhaps even sent it to me and received feedback, you can, if you have time, complete the pricing section of the project. This will require you to get on S&P Capital IQ and downloading raw data on your company and the peer group (and you will have to make judgments on what to include in this peer group). You can then go through the pricing exercise, standardizing prices (with multiples), controlling for differences in risk, growth or whatever else the market seems to be pricing in and makinga pricing judgment on your company. Don’t be surprised if you get a pricing judgment (that your company is cheap or expensive) that contradicts your DCF conclusion. You will have to pick but there is no better illustration of the difference between value and price than doing both a DCF and relative valuation.
4/7/17 If you have opened up the mystery project, you probably also are recognizing that this is an exercise in working with data sets. I have 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.
Start with the webcast:
http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/multipleanalysis.mp4
Download the slides:
http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/multipleanalysis/multipleanalysis.pdf
Here is the raw data:
http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/multipleanalysis/multipleanalysis.pdf
And the descriptive statistics:
http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/multipleanalysis/bankdescriptives.xls
4/9/17

 

The weeks are ticking by and I am reminded of this as I see that this is the ninth newsletter (and there are only twelve all together). I hope that you have had a chance to take a look at the mystery project and at the data that goes with it. Since it is due a week from Monday, I think it would be a good idea. Just in case your response is “what mystery project?”,  I have attached both the project and the data again to this email. Attachment: Issue 10 (April 8)

4/10/17
In today’s class, we extended our discussion of pricing by looking at how to use pricing to analyze young companies, where multiples are often difficult to apply. We then extended the analysis of pricing by looking at entire markets. In the process, we looked at how multiple regressions can be used and misused to make pricing judgments. If you are interested in seeing the updated numbers for January 2017, you can get them here:
http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/MReg17.html
 In the next session, we will complete our discussion of pricing and move on to asset based valuation and valuing private businesses.

Attachments: Post class test and solution

4/11/17
I know that you are busy doing your mystery project. So, this week’s pricing/valuation of the week is both simple and focused on a company in the news, Tesla. As many of you have probably read, Tesla last week saw its market cap exceed that of Ford and GM, two firms with long histories that sell far more cars than Tesla does. There is the usual hand wringing about the craziness of investors and I won’t join in. As someone who has watched and valued Tesla for a long time, I find myself disagreeing with both extremes. I don’t agree with those who view Tesla as a fad and Elon Musk as a fraud and view any investor in Tesla as deluded. Tesla is a company that has substance and has a special pull to it that manifested itself when it announced the Tesla 3 a year ago and say 400,000 people put money down for a car whose prototype had not been built and where assembly lines were still in peoples’ imaginations. At the same time, I am uncomfortable in the Tesla fan club where Musk is a ruling deity and any critique of the company is viewed as a unpardonable sin. In fact, a few weeks ago I valued Tesla as the valuation of the week. Let’s turn our attention to pricing Tesla today. I downloaded the raw data on all auto companies on S&P Capital IQ today and computed every multiple and metric that I could think of in the data set below:
http://www.stern.nyu.edu/~adamodar/pc/blog/autocompanies.xlsx
I then computed the median values for each multiple and metric for all auto firms, broken down my market cap class into four quartiles, and looked at where Tesla fell relative to these firms in this link:
http://www.stern.nyu.edu/~adamodar/pc/blog/autoaverages.xlsx
No surprises here. Tesla trades at a hefty premium against other large auto companies but has higher growth (while losing money). Even if you allow for the higher growth in Tesla and forecast a multiple of sales (for instance), controlling for growth, Tesla is massively overpriced relative to auto stocks today.

But here is a quirk to consider. Investors don’t always compare a company to what you or I may view as its chosen sector. What if Tesla is being priced as a tech company. In that case, you should be comparing the numbers for Tesla against tech company averages. On that comparison, Tesla’s pricing still looks high, though perhaps not as high as it did against tech companies. 
http://www.stern.nyu.edu/~adamodar/pc/blog/techcompanies.xlsx 
http://www.stern.nyu.edu/~adamodar/pc/blog/techaverages.xlsx 
So, what does this all mean? If you are an intrinsic value person, you probably will have a tough time stretching your story to cover its current price. If you are a traded, you may very well be a buyer of the stock if you view it as more young tech than auto company and a seller, if you view it as auto rather than tech.
4/12/17
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 link recently on rules of thumb in valuation. Take a look at it.... especially the multiples mentioned
I have two weekly challenges for this week, both simple and both on relative valuation. 

We then moved on to asset based valuation: liquidation valuation, accounting valuation and sum of the parts valuation. Specifically, we focused on when it makes sense to value a company by valuing its assets and what pitfalls to avoid. We ended the class by starting on a discussion of what makes private company valuation tricky, i.e., the absence of a market price, the opacity and unevenness of financial statements and how motive can affect valuation and we will continue with this discussion on Monday. 

Attachments: Post class test and solution

4/13/17
I know that you are working on your mystery project right now and that you don’t want to be distracted. However, if you feel the urge to be distracted, I suggest that you read this excerpt that I found in a guide for appraisers trying to value a hotel on how to do it.
Another valuation rule-of-thumb used in the lodging industry is that each room of a hotel is worth 100,000 times the price of a Coke™
in the on-floor vending machine or in-room mini-bar. More formally:
Value = Coke™ price x Number of Rooms x 100,000
The Edgemore Hotel sells cans of soda for $1.50 in the room mini-bars. Thus, the value of the Edgemore by this "precise"
valuation method is:
$1.50 x 300 x 100,000 = $37,500,000
We urge market participants to use this technique judiciously, as some properties seriously "misprice" soda in relation to property
No. This is not a parody but a real technique. You may find it laughably simplistic, but in pricing, if it works, don’t fight it. 
4/15/17
First things first. I know that you have been working on the mystery project (I get the emails that testify to it). I know that some of you have asked me questions about whether you “should” do something or the other and that you have been frustrated with my answer which always that there is no “should” on this project. If you feel that doing something will advance you towards your final mission of finding the cheapest and most expensive stocks, do it. If not, don’t.  The newsletter for the week is attached, in case any one is still reading it. Just a reminder that we will be starting on packet 3 next week. If you bought the second packet at the bookstore, you should already have packet 3. If not, you can print it by going to:
http://www.stern.nyu.edu/~adamodar/pptfiles/val3E/valpacket3spr17.pptx 

I know that the final exam seems like it is way down the road but it is not and I thought I would bring you up to speed on it. The official date of the final exam is May 15 from  2 pm - 3.50 pm. It is a comprehensive, open book, open notes exam. I do know that some of you need to be done earlier. I am offering an early final exam on May 11 from 1 pm to 2.50 pm in KMEC 2-70. Since there are only 60 seats in the room, i am setting up a Google sign up sheet for anyone who may want to take the exam early. Please go to the link below and sign up:
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/1WDhYkz8lHk9Zl2Oso5lOOh9go1663WgImROEH2p4_v8/edit?usp=sharing 
4/17/17

 

I hope that you are moving along with your mystery project. It is due Wednesday at 5 pm but you can submit any time you feel ready before that time.  When you are ready to send it it, please put “No mystery here” and cc everyone in your group. It will help me keep things in order and send back my graded version to all of you at the same time. I have also, on the very, very tiny chance that you have tried the weekly challenges for this week, attached the solutions to the two challenges. In the week to come, we will put the closing touches on valuing private companies and start on the basics of real options. If you have not printed off packet 3 already, please do.

 

 

4/17/17
In today’s session, we completed our discussion of private company valuation, starting with how to deal with illiquidity when valuing private businesses. We then looked at why the value of a private business will be higher to a public company or in an IPO and the special issues that arise from IPOs, including dealing with the IPO offer proceeds and the investment banking price guarantee. We closed the session byy looking at how to deal with expected transitions as a private company moves from a sole ownership to VC financing to a public offering. If you are interested in total betas and how different they are from market betas, by sector, you can get my estimates at the link below:
http://www.stern.nyu.edu/~adamodar/pc/datasets/totalbeta.xls 
Also, I have added the review session webcast and slides to the webcast page. You can get them at the links below:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/valquiz3review.mp4 
Review slides: http://www.stern.nyu.edu/~adamodar/pptfiles/val3E/valquiz3review.pdf

Attachments: Post class test and solution

4/18/17
I know that you are working on your mystery project right now, but this week’s pricing is of a Russian steel company, Severstal. You can get the story of the pricing at this link:
http://www.stern.nyu.edu/~adamodar/New_Home_Page/Valuationofweek/SeverstalPricing.html
You can see the  raw data for steel companies in this link, with an added worksheet for just the top 25 steel companies in market cap terms:
http://www.stern.nyu.edu/~adamodar/pc/blog/steel2017.xlsx 
I used this raw data to estimate median values and compared Severstal to those values in this link:
http://www.stern.nyu.edu/~adamodar/pc/blog/steelmultiples.xlsx 
Finally, I looked at the 25 largest steel companies and ran scatter plots and a regression. Even though you may not have the time to do this now, come back and take a look at it when you are working on your final project, if you get stuck on the pricing section. 
I know that you are working on your mystery project right now, but this week’s pricing is of a Russian steel company, Severstal. You can get the story of the pricing at this link:
http://www.stern.nyu.edu/~adamodar/New_Home_Page/Valuationofweek/SeverstalPricing.html
You can see the  raw data for steel companies in this link, with an added worksheet for just the top 25 steel companies in market cap terms:
http://www.stern.nyu.edu/~adamodar/pc/blog/steel2017.xlsx 
I used this raw data to estimate median values and compared Severstal to those values in this link:
http://www.stern.nyu.edu/~adamodar/pc/blog/steelmultiples.xlsx 
Finally, I looked at the 25 largest steel companies and ran scatter plots and a regression. Even though you may not have the time to do this now, come back and take a look at it when you are working on your final project, if you get stuck on the pricing section. 
4/19/17
In today's class, I did a quick introduction to real options, setting up the intuitive rationale for real options.  We covered the basics of options, starting with why real options are so attractive to analysts and investors: they allow you to add a premium to your DCF value. The two building blocks for real option value are learning (from what is going on around you or ongoing events) and adapting your behavior. There are three questions that underlie the use of real options. The first is recognizing when you are dealing with an option, with a payoff diagram being the give away. The second is looking for exclusivity which is what gives options value. The third is using an option pricing model, which is built on replication and arbitrage.  We then turned our attention to the option to delay, an option that can make the rights to bad project/technology valuable. We used it as a lever to talk about valuing patents and natural resource reserves as options, with significant caveats on both. After the quiz on Monday, we will continue with this discussion of real options. 

Speaking of the quiz, here is the seating arrangement for Monday’s quiz:
If your last name begins with Go to
A -R Paulson
S- Z KMEC 1-70
If you are going to be missing the quiz, please let me know before 2 pm on Monday. 

Attachments: Post class test and solution

4/20/17
By now, you should have your mystery projects back. If you have not, please send it to me again with the subject head “No mystery here”.  It may be because you got the subject wrong on your email. 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/EBITDA, with a smattering of other choices thrown in. While some of you starting by asserting that you would be using a multiple (with no reason given), there were two sets of rationale used for the choice of multiple. The first were intuitive, with the primary argument for EV/EBITDA being that it was unaffected (or less affected) by leverage. The second were statistical, with high R-squared dominating the statistics.  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 a few groups 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. If you followed this path, though, remember that your sample sizes drop off and you are perhaps altering you mission of finding the five cheapest and most expensive stocks. One point to note, though. For those of you who chose a multiple first and plowed through with it, no matter what, you ran into a conundrum of regressions with low R-squareds and poor predictive power. In pricing, it is better to be pragmatic than pure. When something does not work, move on.
  2. Data Dark Side: With data, there is always a dark side lurking, if you don’t watch out for it. This is was most visible in those of you who chose to use price to book ratios and ran the regressions against ROE, getting R-squareds of close to 100%. That, though, was the result of a few companies with negative book equity (which leads to negative price to book and negative ROE) remaining in your sample. As with PE ratios, when the book equity becomes negative, both the price to book ratio and ROE become not meaningful and you need to remove the companies from your sample.
  3. Regressions: Almost everyone followed the script and ran the regressions, though the project did not actually require it.  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 (when the t statistics suggest low or no significance) rather than leave it in is the better choice.  A few 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.)
  4. 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. Also, if you mixed EV multiples and PE in making your choices, the two are not directly comparable; a company that trades at an EV ratio 20% below its predicted value is more under valued than one that trades at a PE ratio 20% below its predicted (and I will et you figure out why).  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. There were a few companies that showed up on many lists, with auto companies showing up most frequently on the under valued list and tech companies on the over valued list.
  5. 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 chosen. The two most widely targeted were Taiwan Semiconductor and Japan Tobacco.  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. 
I hope that you were able to get something of value out of the project. Screening is the name of the game in portfolio management and this project is just a small step towards how big data and big analytics are coming together (with mixed payoffs) in investing. I know that a few of you have emailed back asking about grade distributions and while I will not get letter grades on projects like these, the scores ranged from 6 to 10 on the project with a median grade between 8 and 8.5. 
4/21/17
I know that options are not on the quiz. So, don’t panic. However, if you feel like exploring valuing a patent as an option after the quiz, I have a webcast on how to do it and here are the links:

Attachments: Weekly Challenge #9

4/22/17
The newsletter for the week is attached. As the clock winds down, deadlines are approaching. The third quiz will be on Monday. It will cover packet 2 (pricing, private company valuation and asset based valuation). So, keep that in mind as you review past quizzes. You can find them here:
Past quizzes: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz3.pdf 
Past quiz solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz3sol.xls 
My suggestion, if you have limited time, is that you start with the most recent quizzes and work back since they will be more closely tied to the material for this quiz.

The review session for the quiz is at the links below:

Here is the seating arrangement for Monday’s quiz:
If your last name begins with Go to
A -R Paulson
S- Z KMEC 1-70

Attachments: Issue 12 (April 22)

4/24/17

I know that the sessions after quizzes are a let down, since you are tired and have had your fill of valuation for the time being. That said, I have no choice but to plough on and today we did. We started by looked at undeveloped natural resource reserves as options, with the premium a function of the volatility in oil prices. We then moved on to the option to expand and how it can add to the value of some companies with exclusive assets (like Facebook’s user base) and ended with the option to abandon, the option to walk away from your mistakes. All three have value and we will continue our real option discussion (and conclude it) on Wednesday.

 

 

4/25/17 I know… I know.. The quizzes should have been done by now and put outside for you to pick up. The good news is that you are right but the bad news is that I am stuck at home today and cannot come into school. So, I will put them out right after I come in tomorrow morning at about 9.15 am. I won’t attach the solutions or grading template because that will only put your anxieties into high drive. Suffice to say that the average score on this quiz was similar the ones on prior quizzes and I will fill you in tomorrow.
4/26/17
The quizzes are ready to be picked up in the usual spot. The solutions and grade distribution are attached. While I don’t want to pick at fresh wounds, here are a few notes on the most common “issues” that you had with the quiz:
Problem 1: This problem was a simple one, if you recognized that you can extract the ROE from the growth rate and payout ratio. ROE = g/ (1- Payout ratio). All you had to do was back out the cost of equity in the median bank and use it to compute the P/BV ratio for the bank sub (using its cost of equity and growth rate). I did give full credit if you used a (1+g) all the way through your solution.
Problem 2: On this problem, there were two parts. 
  • In the first part, you had to compute ROC and reinvestment rate to use in the regression. While you were given after-tax operating income, to get to invested capital you had to = Book Equity + Book Debt - Cash - Book value of investments in other companies. The reason you net out the book value of investments in other companies is because the income from these investments is not part of your operating income and you need to be consistent. For the reinvestment rate, a few of you got too focused on getting it from the growth rate (RIR = g/ROC) but since the growth rate is not given, you have to do it the old fashioned way which is RIR = (Cap ex - Depreciation + Change in WC)/ EBIT (1-t) or more simply RIR = 1 - FCFF/ EBIT (1-t). 
  • Once you plugged in these values into your equation to get a expected EV/IC, you have to convert the expected EV to an expected equity value. (Expected equity value = Expected EV - Debt + Cash + Market value of Investments in other companies). That expected equity value has to be compare to the actual market value of equity to get a percent difference. Some of you tried to compare the predicted EV (either in its multiple form or in dollar values) to the actual EV, but that percent difference will be different from the equity value percent difference. 
Here is how the grading went. You lost a point each for getting either ROC or reinvestment rate wrong. If your comparison was on an EV basis instead of an equity value, you lost an extra point.
Problem 3: This was the “gimme” problem of the three. You had to value the two businesses (and you were already given FCFF, cost of capital and growth rate) and value the G&A (with its own cost of capital and growth rate). Your break up value of equity = Value of two businesses - Value of G&A - Net debt. You compare this to equity value. (Again, if you did use (1+g) in this problem, you should have full credit)
Now that the last quiz is behind us, the end game has begun.

Attachments: Solution (a or b) as well as the distribution of grades

4/26/17 We started this session, by valuing financial flexibility as an option, and arguing that it was worth more to capital-constrained companies with unpredictable and high-value-added investments. We continued with our examination of equity in trouble, debt-laden companies. Given that the equity in these companies takes on the characteristics of an option, we teased out three implications:
  • The equity in these companies will be valued as out-of-the-money options are and not as conventional stocks. Thus, they will retain their value, even in the face of daunting debt, and will become more valuable as the risk in the business increases and with longer term debt.
  • Letting equity investors in deeply distressed companies make investment decision can lead to perverse consequences: risky, negative NPV projects may be attractive to these investors, because the transfer of wealth from lenders overcomes the drop in value from the negative NPV.
  • Acquisitions of companies in other businesses, if not funded with additional debt or accompanied by a renegotiation of interest rates on existing debt, can make equity investors in the acquiring company worse, even if the acquisition is at fair value.

The bottom line on options: they are everywhere, most of them are worth nothing or very little and only a few can be valued with option pricing models. I have attached the post class test and solution, for you to try out, if you are so inclined. (I forgot the start of the class test today.. I’ve included it with the post class test and solution).

Attachments: Post class test and solution

4/27/17
If you have not started the project yet, please do. If you have already completed, kudos. If you are in the middle, here is the to-do list , just to keep you organized.

1. DCF Valuation
1.1. Consider feedback you got on your original DCF valuation and respond, but only if you want to.
1.2. Update macro numbers - riskfree rate to today's rate and equity risk premium
1.3. Update company financials. If a new quarterly report has come out, compute new trailing 12-month numbers
1.4. Review your final valuation for consistency

2. Relative valuation
2.1. Collect a list of comparable firms (stick with the sector and don't be too selective. You will get a chance to control for differences later) and raw data on firms (market cap, EV, earnings, revenues, risk measures, expected growth)
(You can this data from Bloomberg or Cap IQ. The latter is a little more user friendly)
2.2. Pick a multiple to use. There may be an interative process, where you use the regression results from 2.4 to make a better choice here)
2.3. Compare your company's pricing (based on a multiple) to the average and median for the sector. Make a relative valuation judgment based upon entirely subjective analysis.
2.4. Run a regression across the sector companies. (Be careful with how many independent variables you use. As a rule of thumb, you can add one more independent variable for every 10 observations. Thus, if you have only 22 firms in your list, stick with only two.)
2.5. Use the regression to make a judgment on your company and whether it is under or over valued. (If you are using an EV multiple, estimate the relative value per share. This will require adding cash and subtracting out debt from EV to get to equity value and then dividing by the number of shares)
2.6. Use the market regression on my website to estimate the value per share for your firm. You can find the regressions here:

3. Option valuation (tomorrow’s class)
3.1. Check to see if your company qualifies for an option pricing model. It will have to be a money losing company with significant debt obligations (a market debt to capital ratio that exceeds 50%).
3.2. If yes, do the following:
3.2.1: Use your DCF value for the operating assets of the firm (not the equity value) as the S in the option pricing model
3.2.2: Use the book value of debt (not the market value) as the K in the option pricing model
3.2.3: Check your 10K for a footnote that specifies when your debt comes due. Use a weighted-maturity, with the weights reflecting the debt due each year. (You don't have to worry about duration)
3.2.4: Estimate the variance in firm value, using your own estimates or the industry averages that I have estimated and are built into the linked spreadsheet.
3.2.5: The value of equity that you get from this model is your option pricing estimate of value for equity.
I have attached an excel spreadsheet that should help in this effort.

4. Bringing it all together
4.1: Line up your intrinsic value per share (from the DCF model), the relative value per share (from the sector), the relative value per share (from the market regression) and the option based value per share (if it applies)
4.2: Compare to the market price in May 2017  (the date will depend on when you get done)
4.3: Make your recommendation (buy, sell or hold(

5. Numbers to me!!!!
Fill in the attached excel spreadsheet when you have all the numbers for all of the people in your group and please get it to me by the evening of May 7, 2017 (If you have someone who is holding up the group, just send me the rest of the numbers). Please do not modify the spreadsheet in any way.


6. Final Project write up
Write up your findings in a group report and submit as a pdf file. The report should be brief and need not include the gory details of your DCF valuation. Just provide the basic conclusions, perhaps the key assumptions that you used in each phase of valuation. There should be relatively little group work. So, you may not really need to get together for much more than basic organization of the report. The group report is due electronically by Monday, May 8, at 5 pm. A pdf format works best. You do not need to attach the raw data and excel spreadsheets). I am not a stickler for format but here are good examples of reports from previous semesters online.
Just to keep the over zealous from going over board, I am going to put a page limit of 20 pages for each report (for up to five companies). You can add two extra pages for each additional company to the limit; with 7 companies, the page limit is 24 pages. And no.. you don't have to do everything that these groups did (So, don't spend the next five days converting your DCF valuations into pictures). I just like the fact that the valuations were organized, presented in much the same format and were to the point. Of course, content matters.

7. Celebrate, but remember that your final exam is a week later.
4/28/17 This is the last of the valuation tools webcasts. If your company is the one that meets the equity-as-option test (losing money, lots of debt), you are probably not happy. However, it is really not an involved exercise. To assist you, I did put up my latest valuation tools webcast, on valuing distressed equity as an option. I used Jet India, an Indian airline with a history of losses and a mega debt load to illustrate the process. You can start with the webcast below:
http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/equityoption.mp4
The financials for Jet India are contained in this sheet:
http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/DistressedEquity/jetindiaFA.pdf
The DCF valuation that you need to get your option model started is here:
http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/DistressedEquity/jetindiaDCF.xls
The value of Jet India's equity as an option is contained in this spreadsheet:
http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/DistressedEquity/jetindiaoption.xls
It is pretty straight forward and may be useful. 
4/29/17 I hope that your weekend is going well, though I have probably ruined much of it. As you work through the relative valuation section, a few questions that seem to be recurring:
1. Sample size: There is a trade off between sample size and finding companies that look more like yours. If you are doing a subjective comparison - comparing your company's PE with the PE ratio of comparables, controlling for differences with a story, you want a small sample of companies that look like yours. If you are doing a regression, you should try to get a larger sample, even if it means bringing in firms that may not look like yours. You can control for differences in the regression. If you can get your sample size up to 20-25, you should be okay. And one more thing. Don't fight the data. If a regression does not work, it does not. Remember that you get to make the ultimate judgment and you can decide that given your company and its peers, the best estimate of relative value is just the average PE for the sector.
2. Market regressions: The updated market regressions from the start of 2017 are on my website under updated data. Look to the bottom of the page (and at the first link in the first column, not the archives). Here is the direct link 
http://www.stern.nyu.edu/~adamodar/New_Home_Page/datafile/MReg17.html
3. Young or money losing companies: Running these regressions with young companies is always tricky. The first is that if you use current data, the only multiple that you have any shot at using is a revenue multiple. Nothing that you can do about that. You can try to use forward numbers to do relative valuation. What does that mean? You can go into your DCF, find your revenues or earnings in year 10, and use the fundamentals at that point to get a multiple for your company. Remember, though, that this a value in the future and you still have to discount it back and deal with survival risk.

Finally, if you have been reading my newsletters, the last one is attached for you to read. If you have not been reading them, the last one is still attached to ignore.

Attachments: Issue 13 (April 29)

4/30/17 In tomorrow’s class, we will look at acquisition valuation with all of its pitfalls. I have attached a pre-class quiz (to replace the start of the class quiz that we usually start with) and  it will run through the entire class. If you can spend about 15 minutes answering the questions, it will make tomorrow’s class more productive (and fun).
5/1/17
I am sorry if you found today's session to be a downer. Don't get me wrong. Acquisitions are exciting and fun to be part of but they are not great value creators and in today's sessions, I tried to look at some of the reasons. While the mechanical reasons, using the wrong discount rate or valuing synergy & control right, are relatively easy to fix, the underlying problems of hubris, ego and over confidence are much more difficult to navigate. There are ways to succeed, though, and that is to go where the odds are best: small targets, preferably privately held or subsidiaries of public companies, with cost cutting as your primary synergy benefit. If you get a chance, take a look at a big M&A deal and see if you can break it down into its components.  I did get briefly into the InBev/SABMiller merger in class but if you want something more extensive, I am going to offer you the blog post that I did on it when it happened:
If you look towards the bottom on the post, you will see a YouTube video on the merger.

Attachments: Post class test and solution

5/2/17
I know that you have lots of stuff coming at you this week and I hate to add to the clutter but a few quick notes:
1. Early final exam: As I noted in class, there will be an early final exam for this class on May 11 from 1-2.50 in KMEC 2-70. The sign up sheet is here, if you want to still sign up. 
https://docs.google.com/a/stern.nyu.edu/spreadsheets/d/1WDhYkz8lHk9Zl2Oso5lOOh9go1663WgImROEH2p4_v8/edit?usp=sharing
2. Regular final exam: The regular final exam is on May 15 from 1 pm to 2.50 pm. It will be in Paulson. There may be a second room, but if 50 people take the early final, there may be no need for a second room.
3. Project: As you work on the finishing touches on the project, please stay focused on the end game, where you will make a recommendation of whether to buy, sell or hold the stock. If you have the numbers ready for the companies in your group, please fill them into the attached spreadsheet and send them back to me before Sunday (May 7). 
5/3/17

In today's class, we started by drawing a contrast between price and value enhancement. With value enhancement, we broke down value change into its component parts: changing cash flows from existing assets, changing growth rates by either reinvesting more or better, lengthening your growth period by creating or augmenting competitive advantages and lowering your cost of capital. We then used this framework to compute an expected value of control as a the product of  the probability of changing the way a company is run and the value increase from that change (optimal - status quo value). This expected value of control allows us to explain why market prices for stocks rise when corporate governance improves, why voting shares usually trade at a premium over non-voting shares (and why they sometimes don’t).

Attachment: Post class test and solution

5/4/17
As you embark on the closing touches of the project, here are a few things to keep in mind:
1. Tweak your DCF, if you need to, estimate a value and let it go. This is an ongoing story and this your take, as of right now.
2. Do the pricing of your company, recognizing that your final pricing conclusions are going to be a function of the multiple you use, the companies you use as comparable firms and how you control for differences. If your R-squared is low, try alternatives, but at some point, adopt the karmic pose. It is what it is.
3. Make your recommendation and I will accept your judgment.

I know that this is shaping up as the weekend from hell for some of you and I share some (or all) of the blame. Anyway, it is too late for me to be offering you "substantive" help on the project, at least on a collective basis, but here is a list of "to dos" for you and me over the weekend:
For you:
1. Finish the number crunching for the project. 
2. Fill in the attached summary sheet with the numbers and get them in to me in an email. In the subject heading, please list “The End is Near”.
3. Work on writing up the project report. Don't get fixated on format or on small details. 
4. On Monday morning, around 1 pm, check your email. You should find a presentation (see my tasks below) for the class attached to the email.
5. Come to class on Monday. I know that some of you have not been in class the last couple of weeks and I understand that there are finals and projects due in other classes. However, Monday's class is special. If this were a play, it would be when the fat lady sings. While I may not be fat, a lady or hold a tune, I will do my best impersonation.
6. Turn in your project report by email by 5 pm, as an attachment (pdf preferably, though I can take MS Word). In the subject, please list "The Grand Finale".

For me:
1. Send nagging emails every few hours asking for your summaries and providing updates.
2. Pull your summaries together in a master spreadsheet.
3. On Sunday night, do assorted magic on the summaries
4. Put into a final presentation (see above) and send to you by Monday morning at 10 am
5. Show up in class and do the "fat lady song"
6. Wait for your final project reports
7. Start grading…
5/6/17
I know exactly what you are working on and won’t intrude. But here is the update:
Company updates received: 15
Companies yet to come: 238
So, if you have not sent in your summaries yet, you have lots of company. But if you have the numbers for your company, please send them in with “The end is near” in the subject.
5/7/17
Thank you for the summaries. 
Company updates received: 168
Companies yet to come: 85
The window will stay open until tomorrow morning. So, please do get your numbers in by then. I will be putting the slides together by midday and will email them to you by 1.15. Please do come to class tomorrow. It will be the grand finale, the show to end all shows, the icing on the cake..
5/8/17
1. Closing Class: Thank you for being at the closing class. I have attached links to both the closing presentation and the summaries of your valuation findings (for the entire class). 
Closing Presentation: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/valclosefall17.pdf 
Summaries of class valuations: http://www.stern.nyu.edu/~adamodar/pc/eqrec/spr2017.xls
 If you are on the list of the  most undervalued companies and are buying your recommended stock, please let me know. I may very well join in.  

2. Final Exam: The final exam is scheduled for next Monday in Paulson from 1-2.50 pm. The early exam is on Thursday in KMEC 2-70 from 1-2.50 pm. It is a comprehensive, open-book, open-notes exam. 

3. Final Exam Reviews:If you are ready to turn your attention to the final exam, the webcast review for the final exam is now accessible:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/valfinalreview.mp4 
Slides: http://www.stern.nyu.edu/~adamodar/pptfiles/val3E/valfinalreview.pptx 
Past finals: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/finals.pdf 
Past final solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/finals.xls 
Hope this helps. 

4. CFEs: Finally, please remember to do your CFE (right now). If you absolutely hated the class, this is your chance to let the rest of NYU know that they should never take a class like this one. If you liked the class, you can wax eloquent, if that is wont.  The instructions for the CFE are attached. You have only until tomorrow to do these CFEs. I am sorry for not letting you know earlier but I was operating on the graduate school CFE schedule which starts after the last class. In fact, go do the CFEs now, before you forget. 

5/9/17
I mentioned yesterday that you have only until tonight to get your CFE done. So please, please get it done. Instructions are below:

NYU Stern students:


  1. Login to https://sternlife.stern.nyu.edu/academics-undergraduate.  Use the same login and password that you use for accessing your NYU Stern email.  If you have not activated your NYU Stern account yet, please visit http://start.stern.nyu.edu.
  2. Click on the link for the pending CFE you want to submit.

Non-NYU Stern students:


  1. If you have already activated your NYU Stern account:
    1. Login to http://www.stern.nyu.edu/cfe.  Use the same login and password that you use for accessing email.
    2. Click on the link for the CFE you want to submit.

  2. If you have NOT activated your NYU Stern account:
    1. Activate your NYU Stern account at https://w3.stern.nyu.edu/start.  You will need to provide your NYU Stern NetID (example: abc2), University ID, and birth date.
    2. Once activated, click on the link for the CFE you want to submit.  You will need to verify your password before submitting your response(s).
5/9/17
There are three questions seems to be coming up on the real options problems and m afraid I have contributed to the confusion. So, here is some clarification:

1. What is the probability that S>K?   
As stated in class, it is N(d2) which is the risk neutral probability that S>K. In some of the problems, though, I have used a range from N(d1) and N(d2) as the range of probabilities. Let me explain why. N(d1), in addition to being an option delta, is also a probability that the option will be in the money. In fact, the only reason d1 is different from d2 is because you are uncertain about S
d2 = d1 - square root of the standard deviation
If you had a standard deviation of zero, N(d1) = N(d2). As the uncertainty increases, the gap between these two numbers will widen. Thus, you go from being certain about the probability to having a range. Having said all of this, N(d2) should be the point estimate on the probability that S>K. You can use the range to indicate that there is uncertainty about this probability.

2, What is the cost of delay?
        This is a tough one. Sometimes, I use 1/n and sometimes I use  the cashflow next year/ S and sometimes I use no cost of delay at all. Lets look at the conceptual basis. The cost of delay is a measure of how much you will lose in the next period if you don't exercise the option now as a fraction of the current value of the underlyign asset (It parallels the dividend yield. On a listed option on a stock, if you exercise, you will have the stock and get the dividends in the next period) . Thus, if you have a viable oil reserve, the cost of delay is the cashflow you would have made on the developed reserve next period divided by the value of the reserve today.
        Here is the overall rule you should adopt. If you have a decent estimate of the cashflows you will receive each period from exercising the option, it is better to use that cashflow/ PV of the asset as the dividend yield. If your cashflows are uneven or if you do not know what the cashflow will be each period, you should use 1/n as your cost of delay. If you will lose nothing in terms of cashflows by waiting, you should have no cost of delay.
        Let me take three examples. The first is the bidding for rights to televise the Olympics in an earlier quiz. There were two years left to the Olympics and you were trying to price the option. In this case, there is no cost of delay since you really cannot exercise the option early even if it is deep in the money. (You cannot televise the Olympics a year before they happen...) The second is the oil reserve option. Since the cashflows from the reserve tend to be fairly uniform over time (based upon the barrels of oil you would produce and the current price per barrel, it is easy to estimate the cashflows you would generate each year on the reserve. In most of the oil reserve problems, therefore, you would go with the cashflow/ PV of oil in the reserve as your cost of delay. The third is the patent examples. While you may be able to estimate the expected cashflow each year from commercialising the patent, these cashflows are more difficult to obtain and are less likely to be uniform over time. That is why many of the patent problems use the less preferred option of 1/n as the cost of delay, where n is the number of years left in the patent.

3. How am I going to estimate N(d1) and N(d2)?
I will give you the cumulative normal distribution. You still should be able to estimate d1 and d2 on your calculator. While the distribution may not give you a precise N(d), I will accept the nearest number. Thus, if d =0.48, I will take N(.50) as your estimate.
5/13/17
I am working through your projects and am about 75% of the way through. I am sorry for taking so long but I had other things on my plate (but they are eaten now). The last order of business, for this class, is the final exam tomorrow and in case you did not get the memo, it is from 2-3.50 in Paulson tomorrow. It is comprehensive and will contain 8 questions that span the spectrum of this class. (I have changed the format slightly from the 5 questions with multiple parts where mistakes from one part seep into the other parts). In case you went through the review session links online, you probably have realized that the link is to the corporate finance class (still relevant but not quite right for this class). I have the right links below:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/valfinalreview.mp4 
Slides: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/valfinalreview.mp4 
5/16/17

The finals are done and can be picked up in the usual spot. I have attached the solution and a distribution of scores for the final exam. You will notice that there are no grades on the distribution. That is because the final grades should be up shortly. I will let you know as soon as they are done. Until next time!

Attachments: Solution


5/16/17
I hope you are done and are out celebrating. However, just in case you still care about grades, I submitted yours and they should be online soon. I want to to wish you the very best with whatever you plan to do with your lives. I hope your "job" brings you as much joy as mine has to me. If you enjoy what you are doing, you will never have to work a day in your life. Well, at least, I have not. I mean it when I say that you have my email address for life and you can bounce off any questions, queries or issues that you have with corporate finance, valuation or the most valuable sports franchises in the world (the answer to the last is always the "Yankees").  And just in case, you need a valuation fix... here are some links:
Twitter feed: @AswathDamodaran (Do your part to advance me to Lady Gaga or at least Kanye West status…)
If you have any questions about your grade, use the attached spreadsheet to see where you ended up. You do need to know your final exam grade to be able to use it. 

Attachment: Grade checker