logo about writing tools
teaching data blog





The emails for this class will be collected on this page, arranged chronologically. Since I send quite a few, you can target it on a specific month by going here:

Have fun with them!

Email content
I am sure that you are finding that break is passing by way too fast, but the semester will soon be 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 sell Tesla? Was WeWork worth any money ever or was Softbank delusional, and if the latter, what does that make Oyo? Is Cathie Woods a genius or just bonkers? How much does a Super Bowl add to an NFL team’s value? You will find the answers to these and other questions on my blog:

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… Seriously, all I need of you is a familiarity with basic finance, accounting and statistics.  If you feel shaky, you may want to check out the online classes that I have on accounting and financing basics:
1. Accounting class (I am not an accountant, don’t care much for how accountants think about companies and view accounting as a raw material provider.. This class reflects that view): https://pages.stern.nyu.edu/adamodar/New_Home_Page/webcastacctg.htm 
2. Basics of finance (present value, a dash of this and that….): https://pages.stern.nyu.edu/adamodar/New_Home_Page/webcastfoundationsonline.htm 

2. For this class: If you want to get a jump on the class, you can go to the class web page:
As the schedule stands right now, we will meet on Mondays and Wednesdays from 3.3p pm - 4.45 pm  in Paulson Auditorium, starting on January 24, but with COVID still wreaking havoc on our lives, who knows what will play out? I have had quite a few frantic emails from some of you, but you know as much as I do at the moment. If the classes get moved online, never fear. Zoom will come to the rescue. If you have to miss a class or two, because the classes will be recorded and available on three platforms:
a. My website: The recordings of the sessions, with all of the material (slides, links, other) that I use during the session will be available on the webcast page for the class: 
b. YouTube Channel: There is a second 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.

  When you get a chance, check it out.

3. If you are going to be away or are worried about COVID exposure: Even if we do meet in class, I know that some of you are wary about coming to class, either because you have been exposed to COVID or are worried about exposure. Obviously, I would like you to come to class, if you can, but if you cannot, for any reason, the classes will be recorded and you can watch the recordings the same day as the class. At the moment, the quizzes and exams are in person, but again, there is much that is out of our hands.

4. Syllabus & Calendar: The syllabus for the class is available on the website for the class and is also linked here:
and there is a google calendar for the class that you can get to by clicking on

For those of you already setting up your calendars, it lists when the quizzes will be held and when projects come due. 

5. 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
Please download and print only this 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... 

6. 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. 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 
You will find the webpages for all of the books at http://www.stern.nyu.edu/~adamodar/New_Home_Page/public.htm. If you want a comparison of the books, try this link: https://pages.stern.nyu.edu/adamodar/New_Home_Page/valbookcomp.html 

7. 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…  

I am looking forward to seeing you in two weeks in class, or if God has other plans, online.  Let’s hope that the world holds together until then! Until next time!

It’s been a week since my last email, and while not a whole lot has happened, I thought I should check in ahead of next week’s class. First, if this is the first email you are reading, then you should catch up with the earlier one, which are available at the link below:
If you are wondering about the logistics (exams, projects etc.), we will start the first class with the syllabus, which will also lay out the themes for the class:
As you go through the syllabus, you will notice mention of a project and you can find the details of that project here:
Once we are through the syllabus in session 1, we will turn to an introductory packet (of about 20 pages). The link to that package is below:
Please have this ready for the first session. The rest of the class will be covered in the lecture note packets, and I sent you the link to the first one last week (but here it is again):

Having drowned you with all of that stuff, let me hit with you some pre-class reading (and I don’t think it is too painful). I don’t do much academic research and am supremely uninterested in writing for an echo chamber. Much of what I have written that is original or different has be initially (at least) on my blog.  I spend the first few weeks of each year, talking about the data that I update on my website:
The first update is on my blog and the second one will be up in the next day or two. Please browse through them, because they are relevant for class:
  1. https://aswathdamodaran.blogspot.com/2022/01/data-update-1-for-2022-it-is-moneyball.html
The first class will be six days from today (Monday, January 24, from 3.30 pm - 4.45 pm, NY time) in Paulson Auditorium. Please do come, if you can. If you are unable to, either because of logistical or health reason, the class will be carried on Zoom. The Zoom link for all of the classes (all 28 sessions) is below:
Please download and import the following iCalendar (.ics) files to your calendar system.
Weekly: https://nyu.zoom.us/meeting/tJYpdeisqD8vE9DLYxVHPONbgVhF60CCYL54/ics?icsToken=98tyKuCqqjkrHtKRtRCDRowQBojod-jwpilYj_p5sCb9NQhjTS30MdRKFOQvM_vp

Join Zoom Meeting
I am looking forward to seeing you next week. Until next time!
The first day of class is almost upon us, and I thought I would remind you of a  few things.
1. Syllabus and Project Description: In a normal year, I would make physical copies of the syllabus and the description of your project and bring it to class with me, but this is not a normal year. The pdf versions of both are available at the links below:
Please download both, and you can print them if you want to, or leave them in digital form.
2. Lecture notes: The lecture note packets are also digital and the links to both the introductory packet, which covers the first couple of sessions, and the bigger packet for the first half of the class are below. 
Introductory Packet: https://pages.stern.nyu.edu/adamodar/pdfiles/eqnotes/ValIntroSpr22.pdf
As with the syllabus/project, you can download them and keep them as digital files, or take it to a print shop and print it. Please don’t use Stern School printers to print off these packets, since with 350 people in the class, you will break the printers...
3. Attendance: Obviously, I would like to see you in class, and it will be from 3.30-4.45 tomorrow, in Paulson Auditorium, but I do know that we are in unusual times. Some of you are still stuck in distant destinations and will not be back in time. Some of you are in New York, but are physically unable to come to class. In either case, the class will be both live zoomed and recorded. The Zoom link for all of the classes (all 28 sessions) is below:
Please download and import the following iCalendar (.ics) files to your calendar system.

Join Zoom Meeting
I am looking forward to seeing you soon. Until next time!

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: https://pages.stern.nyu.edu/adamodar/New_Home_Page/eqUGemail.html
This chronicle will be updated at the end of each week to include all emails sent up until then. 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 laid out the philosophical foundations for valuation, by noting that it is a bridge between story and numbers and that it is different from pricing. Next session, we will spend a little time talking about the project that will run through the entire semester, but you can get a jump by trying to find a group and a company (each of you will be doing a company). Here is the project description:
You can get a jump on it by doing the following.
  1. Group: Please do find a group to nurture your valuation creativity, and a company to value soon. 
  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 2020) 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. You can access it by going to: https://pages.stern.nyu.edu/adamodar/New_Home_Page/webcasteqUGspr22.htm. The links to the downloadable files (video and audio) and the YouTube version are also up.
  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. 
  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.
I had also mentioned my blog as the venue that I post my most recent ruminations on markets, and I just posted the second of the data updates that I do at the start of each year. Given the turmoil in the market, you may want to revisit my second data post for 2022, on valuing the S&P 500 index:

Attachments: Post-class test and solution.

As promised, the first valuation of the week is up, and  it is GameStop. Given the trading frenzy on the company, it has become part of a group of stocks called meme stocks, where the pricing is driven almost entirely by trading momentum. To get a picture of what I think about the frenzy, you can start with my blog post from two years ago, at the start of the frenzy
In the post, I valued GameStop and came up with a value per share of $47.14, even making generous assumptions about the future. In the link below, I have an updated base case valuation of the company that is more reflective of the troubles in its business model and the difficult it will have in pivoting to becoming an online retailer primarily or a gaming platform:
If you are wondering where the base year numbers in my valuation are coming from, you can click on the link below to get historical data on the company going back to 2001:
Here is what I would like you to do. Download the spreadsheet that I have for valuing the company. There are four primary drivers of value
a. Revenue growth rate (in 2022 and a growth rate beyond); I used 5% for 2022, 3% for the next four years, before moving to a stable growth rate.
b. Target operating margin, measuring the profitability part of your story (I used 6%, about the industry average for online retail (5.99%), but much higher than the negative margins posted by GME in the last three years)
c. Sales to Invested capital, measuring the capital intensity that will be needed for them to deliver growth. A primarily online retail story will need less, and a gaming platform or growth in stores will require more. (I assume that any growth that happens will be online, and I use the average sales to capital of 1.80 ratio of online retail firms)
d. Failure probability: reflecting the likelihood that the company does not make it as a going concern. I used the bond rating to estimate the chance of failure to be 15%, based on its B- bond rating from S&P.
Change what you want, leave all else alone and come up with your own value. Then, please go to the Google shared spreadsheet and enter your inputs. Let the games begin:
Let’s get a crowd valuation of GameStop going, and see if we can get some sense of what the consensus value might be. 

Today's class started with a test on whether you can detect the direction bias will take, based on who or why a valuation is done. The solutions are posted online on the webcast page for the class. We then moved on to talk about the three basic approaches to valuation: discounted cash flow valuation, where you estimate the intrinsic value of an asset, relative valuation, where you value an asset based on the pricing of similar assets and option pricing valuation, where you apply option pricing to value businesses. With each approach, we talked about the types of assets that are best priced with that approach and what you need to bring as an analyst/investor to the table. For instance, in our discussion of DCF valuation and how to make it work for you, I suggested that there were two requirements:  a long time horizon and the capacity to act as the catalyst for market correction. Since I mentioned Carl Icahn and Bill Ackman as hostile acquirers (catalysts), you may want to look at Herbalife, the company that Ackman has targeted as being over valued and Icahn did for being under valued. See if you can get a list going of how each is trying to be the catalyst for the correction... and think about the dark side of this process. We will be starting on the first lecture note packet on Monday. So, please print off the packet or download it to your digital device and bring it to class. 

Attachments: Post-class test and solution.

First things first. The links to yesterday’s class are now fully up and running. If you were not at the class, or mentally absent, please do watch the class. Each week, I will use the Thursday email to prod, nag and bug you about the project. So, without further ado, here is where you should be this first week:
  1. 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 protection).  If you are being ostracized and no one wants you,  you can add your name to the orphan list for the class: https://docs.google.com/spreadsheets/d/10e7v7gCwcMNA7olNJQaLZshiacUjf4BKkp6dUah1pXk/edit?usp=sharing. Once you put your name down on the list, keep checking the list to see if there are other orphans you can team up with. If you are a group of three or four and would like to adopt an orphan, please check out the group as well
  2. 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. Once you have picked a company, please enter your company name in the Google class master spreadsheet. Don’t worry about what other people are picking as their companies, since more than one person can value the same company. (If you cannot find your name on the master sheet, you re not shown as enrolled in the class. That could be a registration problem or a delay, if you joined the class late). https://docs.google.com/spreadsheets/d/1G7EaCGnp7MGxCc5o8hHAKr8nUCzqgouclVwlULZz2N4/edit?usp=sharing
  3. 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).
  4. 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). As Stern students, you should have access to Capital IQ on the Stern Dashboard, but you need to ask for access, I have attached a pdf file that shows you how. 

Attachment: https://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/CapIQAccess.pdf

A few 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:
It is a very old webcast,and I need to do a newer version, but I am way too lazy.

Second, for those of you who have already valued GameStop (the first valuation of the week), thank you! For those of you who have been putting it off, there is still time to add your input to the crowd:
If you scroll to the right, and towards the top, you will see the average and median values that the crowd has estimated. 

Finally, for those of you who are late to this party, we have run out of beer and chips, but you can read all of the emails that I have sent so far in the class:
If you read them all, it is the equivalent of drinking a six-pack. So, please don’t drive or operate heavy machinery!

I know that it is still early in the class and office hours are not on your mind, but they will be soon. Let me start with my office hours, which are scheduled as you know for most weeks from 5 pm - 6 pm, NY time, on Mondays and  from 12 pm - 1 pm, NY time, every  Wednesday. This coming Monday, though, my office hours will be from 12 pm - 1pm. Since NYU classes is finicky about how zoom sessions show up in classes, I had to create the session in my general account and share it across all three classes that I will be teaching. Consequently, I am sharing the details of the zoom session for my office hours (since the meeting ID is the same for all of the sessions, all you have to do is incorporate this into your calendar and it should show up every Monday and Wednesday):

Please download and import the following iCalendar (.ics) files to your calendar system.

Join Zoom Meeting

Meeting ID: 921 1967 0806

TA Office hours and review sessions
You have two TAs for the class:
Shriram Chandra, sc7077@stern.nyu.edu, Office hours: MW: 5 pm - 6pm
Nick Fabbroni, nicholas.fabbroni@stern.nyu.edu, Office hours: Tues & Thurs: 1 pm - 2 pm

I have listed their office hours each week, and they will be on Zoom as well.  They will also offer a weekly review session, where they will cover problems from past quizzes and exams, related to the material of the week. As soon as they have the zoom links, ready for both the office hours and the review session, they will be forwarded to you.

Until next time!

Nothing earth shattering to report after the first week. I hope that you have a fun weekend planned, because I have nefarious plans to ruin your next 15 weekends. If you have a group, enjoy it with them. If you don’t, find one. If you are ostracized and feel abandoned, join the orphan list that I sent out earlier this week. Until next time!

Attachment: Issue 1 (January 29)


My Sunday email usually includes a solution to the weekly challenge, but since we did not have one last week, I will keep this short. 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, during tomorrow's class, we will look at 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. Until next time!

Attachment: Cash flow consistency: A test (Congoleum)

We started class by completing the discussion of pricing and real options, at least in a big picture sense. We then began our intrinsic value discussion by talking about the weapons of mass distraction. If you want to read the blog post I have on the topic, try this link:
We then spent some time setting up the process of discounted cash flow valuation, arguing for consistency in discounting. If the cash flows that you are discounting are cash flows to equity, estimated either as dividends or as potential dividends, the discount rate should be the cost of equity. If the cash flows that you are discounting are pre-debt cash flows, i.e,, cash flows to the firm, the discount rate has to be the cost of capital. Done right, the value of equity should be equivalent with both approaches. Try the weekly challenge that I will send out on Wednesday, if you do not believe me. Next session, we will start with a discussion of risk free rate, a foundational number that will drive the rest of our calculations. I have attached a post class test for today, with the solution, but I think that four of the questions relate to risk free rates, which we have not covered yet. So, if you want to wait until Wednesday’s class, you might have an easier time.

Attachments: Post-class test and solution

The second valuation of the week is upon you, and it is of a company that evokes strong views in both directions, Tesla. I valued Tesla for the first time in 2013, and have valued it every year since, and it still surprises me how much disagreement there is among investors on its future. There are some who believe that Tesla is destined to be the greatest company ever, a beacon of hope that will be worth trillions of dollars. There are others who seem to think of the entire company as a scam, with nothing. Not surprisingly, what you think about Tesla is tied to how you feel about Elon Musk as a person. I have always tried to navigate a middle ground, conceding to the optimists that Tesla is a unique companies that has changed the automobile business and to the pessimists that it is personality-driven and sometime oddly behaved (for a company…I have called it my corporate teenager). To get a sense of my history with Tesla, and where I stand at the moment, take a look at this blog post:
Once you have read the post, open up this spreadsheet, and you will notice that the master input page, which is the only page that you have to touch, does not require any knowledge of valuation details, but just a sense of your Tesla story:
Make your judgments on each of the key dimensions, from the end game for Tesla (in terms of revenues), to the margins you expect it to earn to its risk, and come up with your valuation of the company. Once you are done, please go to this shared Google spreadsheet and enter your numbers:
Note that when I valued the company in early November, I estimated a value close to $680 billion, and that is very optimistic assumptions, but the market cap was more than $1.2 trillion, making the stock over valued by about 78%. The market cap has dropped by about a third, since this valuation and in your assessment, you may very well find it to be under valued. 
We started the class by completing a big picture perspective on discounted cash flow models, noting that while the way we get  cash flows, growth rates and discount rates will vary, they are not only tied together with the same principles but require internal consistency. We started then with a discussion of risk and how it plays out in discount rates, before embarking on an assessment of riskfree rates, and why they 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:
If you want to see my updated perspective on risk free rates, try my blog post from last week:
Some of this post covers what we will do next week in class, but it is still a good big picture perspective.  One last note. It is Wednesday and time for the first weekly challenge, and it relates to the consistency of equity versus firm valuation. Rather than give you a new post class test, please try the post class test from last session.

Attachments: Weekly challenge #1

By now, you should have a company picked, and if so, you can start thinking about at least the first piece of your discount rate calculation, a risk free rate. Currency is a choice and you can choose to value your company in any currency, though the currency in which your financials are reported is a good place to start. Of course, if that currency happens to have a 100% inflation rate, you may rethink your choice. Once you have the currency, follow the template for computing a risk free rate. If your currency does not have a default free entity issuing it, you may need sovereign default spreads for ratings classes, and you can find them on my website. Here are some useful links:
    1. Government Bond Rates (in local currency): https://tradingeconomics.com/bonds 
    2. Sovereign Ratings: https://www.moodys.com/login?ReturnUrl=https%3a%2f%2fwww.moodys.com%2fviewresearchdoc.aspx%3fdocid%3dPBC_186519%26lang%3den%26cy%3dglobal (You will be asked to register, but it is free… And worth the giving up of your privacy. If you are worried about your privacy, that train has left the station anyway…)
    3. Sovereign CDS spreads: Try typing in SOVR into a Bloomberg terminal, if you can find one.
On a completely unrelated note, it may be a little early to be talking to me or the TAs, but here are the logistical details on office hours (for all of us) and the TA review sessions that will occur every week:
My office hours: On Zoom, since NYU is not allowing in-person yet, will be at: https://nyu.zoom.us/j/92119670806
For most weeks, my office hours will be from 5 pm - 6 pm on Mondays and 12 pm - 1 pm on Wednesdays. I will add on more hours as we get closer to quizzes and exams and project due dates.
TA office hours
AS we tiptoe into the weekend, I have the second tools webcast ready to go. It goes through the process of estimating the risk free rate in a currency, where the issuing government has default risk.
Additional material:
I have attached the updated versions of the both the ratings and the CDS spreads sheets from the start of 2022.  I hope that you get a chance to watch it! 

Second, for those of you who have already valued Tesla (the first valuation of the week), thank you! For those of you who have been putting it off, there is still time to add your input to the crowd:
If you scroll to the right, and towards the top, you will see the average and median values that the crowd has estimated. 
1. First things, first. Your newsletter is attached for the week.

2. Company choice & groups: I was checking the valuation master sheet:
I notice that a lot of you have not picked a company yet. If you have already and have just not entered the company name (not symbol), please do so. 

3. Orphans up for adoption: If any of you are in groups that would like an extra person, please check this list:

Until next time!

Attachment: Issue 2(February 5)


I hope that you had a good weekend. Two quick loose ends to tie up. First, I hope that you had a chance to watch the in-practice webcast on the risk free rate  (I know you probably were busy doing more fun stuff, but no harm asking). Second, I sent you a weekly challenge last Wednesday. I don’t know whether you had a chance to try, but it is still not too late. I have attached the solution to that weekly challenge (and the weekly challenge, in case you have no idea what I am talking about).  This week, we will turn our attention to equity risk premiums and perhaps take first steps on measuring relative risk (beta), talking about forward-looking estimates and we will then move on to the cost of debt and capital. So, if you are shaky about any of those concepts, I hope that you are rock solid, by the end of the week.  Until next time!

Attachment: Weekly Challenge #1 Solution

We started the class by completing the last loose ends on risk free rates, before turning our attention to equity risk premiums and what they purport to measures. We looked at historical risk premiums and their limits and then extended the discussion to estimate equity risk premiums for countries without much historical data. If you are interested in seeing what the equity risk premiums look like, by country, take a look at the attached spreadsheet.On the riskfree rate front, I promised you links to two posts that I have on the topic, one to negative risk free rates and other to the Fed’s power (or lack of it) to set rates. Here are the links to those:
1. https://aswathdamodaran.blogspot.com/2016/03/negative-interest-rates-unreal.html?m=0 
2. https://aswathdamodaran.blogspot.com/2013/06/the-fed-and-interest-rates-lessons-from.html 
Attached are the post class test and solution for today. Until next time!

Attached: Post class test and solution

For this week, I thought I would switch gears and value a very different company from last week’s hot mess which was Tesla. This week, I look at Aramco, a company that became the most valuable public company (in terms of market cap) over night, when it had its IPO in 2019. The place to start this valuation is with the Aramco IPO, a document written by bankers for bankers, and hence thoroughly boring:
You can follow up with two posts that I wrote at the time of the IPO:
1. http://aswathdamodaran.blogspot.com/2019/11/a-coming-out-party-for-worlds-most.html
2. http://aswathdamodaran.blogspot.com/2019/11/regime-change-and-value-follow-up-post.html 
The excel spreadsheets containing my valuation of Aramco is here:
Clearly, much water has passed under this bridge in the last two years, and I have the updated numbers for Aramco through 2021 at the link below;
Finally, if you feel up to it, please do go enter your updated valuations for Aramco, with the updated market cap of just over two trillion into the Google shared spreadsheet:
Good luck and have fun!
In the session today, we started by doing a brief test on the relationship between prices and risk premiums. We spent the rest of the session talking how companies get exposed to country risk, with the foundational principle that it where you do business that determines your risk, not where you are located. If you are interested in the old paper that I have on estimating lambda, and it is definitely not a barn burner, try this link:
We spent the rest of the class 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 2022. Play with it when you get a chance. Post class test and solution attached. I have also attached the weekly challenge for this week, which is built around implied equity risk premiums. If you get a chance, try it. Until next time!

Attachments: Post class test and solution, Implied premium challenge & data

By now, you should have a company picked, and if so, you can start thinking about at least the first two pieces of your discount rate calculation, a risk free rate and an equity risk premium. 
  1. Riskfree Rate: Currency is a choice and you can choose to value your company in any currency, though the currency in which your financials are reported is a good place to start. Of course, if that currency happens to have a 100% inflation rate, you may rethink your choice. Once you have the currency, follow the template for computing a risk free rate. If your currency does not have a default free entity issuing it, you may need sovereign default spreads for ratings classes, and you can find them on my website. Here are some useful links:
    1. Government Bond Rates (in local currency): https://tradingeconomics.com/bonds 
    2. Sovereign Ratings: https://www.moodys.com/login?ReturnUrl=https%3a%2f%2fwww.moodys.com%2fviewresearchdoc.aspx%3fdocid%3dPBC_186519%26lang%3den%26cy%3dglobal (You will be asked to register, but it is free… And worth the giving up of your privacy. If you are worried about your privacy, that train has left the station anyway…)
    3. Sovereign CDS spreads: Try typing in SOVR into a Bloomberg terminal or from S&P Capital IQ, if you signed up for access (instructions attached again)
  2. Equity Risk Premiums: I went through my calculation of country risk premiums in class and we will return to this calculation net week, with implied equity risk premiums. In case, you are truly bored over this long weekend, you can read an annual update paper that I write on equity risk premiums every year. I am still working on this year’s version, but you can download the 2020 version by going to the link below: https://papers.ssrn.com/sol3/papers.cfm?abstract_id=3825823 
  3. Company ERP: If you get the breakdown of revenues for your company by country or region, you can complete the process of computing the ERP for your company. You are welcome to use my country ERP estimates ( https://www.stern.nyu.edu/~adamodar/pc/datasets/ctryprem.xlsx), as long as you understand the mechanics. 

That’s about it for the moment. Enjoy the long weekend, and until next time!
2/11/22 It is Friday, and time for your weekly valuation tools webcast, and I have not one, but two webcasts for you. The first is a webcast on implied equity risk premiums and the second one is on estimating company risk exposure to country risk.

Implied Equity Risk Premiums

Company Exposure to Country Risk

The webcast uses the February 2013 spreadsheet, but I have tweaked the spreadsheet a little bit and the cell numbers have changed in the updated version, but the process remain the same. I have attached the February 2022 version to this email. I hope that you get a chance to watch one or both! Until next time!

Attachment: February 2022 Implied ERP

1. First things, first. Your newsletter is attached for the week
Atttachment: Issue 3 (February 12) .

2. Company choice & groups: I was checking the valuation master sheet:
I notice that a lot of you have not picked a company yet. If you have already and have just not entered the company name (not symbol), please do so. 

3. FANGAM Stocks: If you are valuing one of the FANGAM stocks. I just put up a post on my views on these companies. Don’t do anything crazy, like changing companies just because I have a valuation on what you picked. Your story will be different from mine. That’s why we do valuation
Until next time!

How’s the Super Bowl Party? While you will be otherwise occupied for the next few hours,I hope you had a chance to try the weekly challenge. If you did, the solution is at the link below.
Give it a glance, if you have the time! If nothing else, it will test you on whether you have used the statistical tools built into Excel. 

This week, we will turn our attention tomorrow to betas, and it would help if you are able to find a beta estimate for your company (from a service like Yahoo! Finance or a Bloomberg terminal, if you can find one) and bring it to class with you and then move on to debt, cost of debt and capital. On Wednesday, we will start on our discussion of cash flows, and getting current cash flows right, before we get ambitious and forecast future cash flows. 

Attachment: Weekly Challenge #2 solution

2/14/22 In today’s class, we started by reviewing the pitfalls of regression betas. They are backward-looking, noisy and subject to game playing. We 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.
In the next session, we will talk about cost of debt. Until next time!

Attachments: Post class test and solution

Moving right along, it is time for the valuation of the week, and this week’s company bears no resemblance to your first two. It is Heineken, the Dutch brewer, with a worldwide brand name. The reason that I am focusing on the company is not because I like its product, but because this is a valuation that I first did in September 2019, in Euros, when the risk free rate was negative in that currency. Begin by reading this post on negative interest rates from 2016:
You can continue by reading this piece that provides the background for the company and my valuation:
You can download the historical data on the company through 2021 here:
You can download my valuation from February 2021 here;
You are welcome to update the valuation to include the additional quarter of information that has come out, but not much has changed. Try playing with the risk free rate/stable growth rate combination, and I use the word “play” deliberately, since you are messing with first principles when you do so. If nothing else, this will give you bragging rights, since 99% of people who do valuation for a living have not only never valued a company with negative risk free rates, but many in this group will claim it cannot be done. You can say it can and will be done. Until next time!
In today’s class, we started with the cost of debt and 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:
These are spreads on indices created by rating, updated daily. Neat, right? Next session, we will move on from discount rates to earnings and cash flows, starting with how to update earnings and then looking at how 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. I know that we have not covered lease or R&D capitalization fully in class, but I think you can still try it, bu this week’s challenge will cover the next two weeks, and you can either do it ahead of next Wednesday’s class or ahead of it.  Post class test and solution attached as is the weekly challenge.  

One final and important note. There is no class next Monday (because of President’s Day) and next week’s class (on Wednesday) will be entirely a zoom class, i.e., no in-person class. Until next time!

Attachments: Post class test and solution
First things first. By now, I hope that you are in a group and have picked a company. If so, please complete the process by going to the master spreadsheet for the class and input your company name:
At this stage in the class, you should be able to complete three basic tasks related to discount rates, estimating risk free rates, equity risk premiums and betas. Along the way, you have to get comfortable with how to A bottom up beta, and to further you on that path, I will be posting a valuation tools webcast on estimating betas tomorrow.  If you get a chance, and want to see betas estimated by sector, you can get them on my website by going to:
Click down on levered and unlevered betas (not total betas), and the unlevered beta adjusted for cash is as close to a pure unlevered beta as I can get.

One note on yesterday’s class. As a couple of you noticed, my original post class test and solution reflected questions about earnings and cash flows, which we will not cover until next week. So, I wrote a new post class test about costs of debt and capital and it should be accessible now on the webcast page for the class. 

I know that I drown you sometimes in stuff related to the class, from weekly challenges to valuations of the week, and it can be overwhelming. If you are feeling lost in the class, and don’t even know where to begin, my advice is that you go to the entry page for the class:
Everything to do with this class, from the recorded sessions (in case you missed any of them) to the weekly challenges to all emails sent out should be accessible from there. The webcast page for the class has the slides that go with each session, and post class tests and solutions. Until next time!
This week, I have a webcast on the mechanics of estimating bottom up betas. I use United Technologies to illustrate the process and I go through how to pull up companies from Capital IQ. Even if you don't get a chance to watch it after the quiz, it may perhaps be useful later on. Here are the links:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/BottomupBeta.mp4 
United Technologies 10K: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/Bottomupbeta/UT10K.pdf
Spreadsheet to help compute bottom up beta:  http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/Bottomupbeta/bottomupbeta.xls
The last spreadsheet has built into it the industry averages that I have computed for different sectors in the US in 2015. You can get the updated version from 2022 here:

On a different note, I have a YouTube video on how to use Bloomberg to get basic data on your company.
For those of you wondering how I got a Bloomberg terminal installed in my home (I am in sunny San Diego), I did not. What I used instead is a really neat interface called Bloomberg Anywhere that you can use to make your terminal mimic a Bloomberg. If you are in New York, and can access a terminal at Stern (I sent you the locations), you should, but I have learned  that you too have access to Bloomberg Anywhere, as a Stern student. I have attached the instructions on how to use it in the document below, but keep in mind that there are only a handful of connections that Bloomberg allows at any one time. (Read the document to the end to see why). Given that constraint, you should plan your Bloomberg expedition with purpose, and be ready to get the stuff you need quickly. For the moment, I would like you to get on, if you can, and print off three Bloomberg pages for your company as soon as you can:
  • BETA: Just print the default page (which will be a 2-year weekly beta against the local index)
  • CRPR: which will give you the bond ratings for your company, if it is rated
  • DDIS: which will give you the maturity distribution for your company, if it has debt, with an average maturity
If you play this right, it will take only a few minutes, and if you don’t have a printer, just take pictures of each of these pages. Until next time!
I hope that you are enjoying the long weekend. It is a good time to catch up. If you have picked a company, it is time to start digging and estimating numbers (risk free rate, equity risk premium, beta etc.). In the meantime, the newsletter for this week is attached.  Until next time!

Attachments: Issue 4 (February 19)
2/20/22 The weekly challenge that I sent you on Wednesday covers two weeks, and I will mail out the solution a week from today. If you have no idea what weekly challenge I am talking about, just move on. On a different note, this week, we have no class tomorrow and Wednesday’s class will be a zoom class. During that class, we will complete our discussion of earnings/cash flows and perhaps even start on estimating growth. Hope to see you there. Until next time!
2/21/22 No class today, but a preview of what’s coming next week. The first quiz is on March 2nd and I wanted to cover some logistical details.
1. Quiz location and timing: The quiz will be on Wednesday, March 2. It will been in class in the first 30 minutes of class (3.30 - 4 pm, NY time), in Paulson Auditorium, for most of you, and another classroom for some of you (with details to come later this week), and there will be class after the quiz. It is open-book, open-notes, but you cannot use your laptop. The quiz is 10% of your grade. If you are unable to be in the room physically, because you are trapped in another location or have entered the witness protection program, you can take the class online, but only during the same time window. (I know that this is a pain in the neck, if you are in Asia, but I cannot think of a fair and equitable way to do this, which will not render it unfair to others.). To use this option, you need to sign up in the Google shared spread sheet that I have created for those using this option. 
2. Quiz coverage: The quiz will cover everything through the end of cash flows (though page 162), which we will get to, in the next two sessions; growth is not on this quiz. It will therefore include the big picture sessions on valuation, discount rates and cash flows.
3. Past quizzes: I am posting 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.
As you work through these quizzes, please do remember that while the new quiz will resemble past quizzes, it will not be replica. 
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)… 
5. Quiz office hours: I have added an extra two hours of office hours next Tuesday (March 1), from 9 am - 11 am, New York time. if you have questions. 
See you online for Wednesday’s zoom class. The link to that class is on Brightspace, but I will send it tomorrow as well. Until next time!
Before I dive into the valuation of the week for this week, a reminder again that tomorrow’s class will be on zoom and the zoom link is below:
See you in class at the regular time (3.30 - 4.45 pm)

My valuations of the week are usually on individual companies, and this semester, we have already looked at Airbnb, Heineken and GameStop. This week, I am doing something different, but one where every investor has a stake in the outcome. I want to value the S&P 500 index, using the same principles that allow me to value a company. You can start with a blog post at the start of this year, where I valued the S&P 500:
Read to the end of the post for the valuation, but it is a simple one based upon expected earnings and cash flows on the index. My valuation of 3360, at the start of the year, was about 12% below the index level, but that reflects my assumptions. They are in this spreadsheet:
Please download the spreadsheet, and change the assumptions that you feel comfortable changing, valuing the index as of today. Note that, if nothing else, you can update the riskfree rate to what it is today and the index level. Once you are done, you can enter the numbers in a shared Google spreadsheet:
Not only is this an extremely useful exercise in regaining investment serenity, but it is the antidote to the nonsense you will hear from CNBC market gurus this week. Give it a shot, and you too can be a market guru! Until next time!

2/23/22 In this session, we began by looking at broad definitions of cash flows, before embarking on updating, normalizing and cleaning up accounting earnings. In particular, we talked about why we capitalize lease commitments and R&D expenses, and how they affect valuation inputs. We continued our discussion of cash flows, by first putting to rest some final issues on earnings, including the tax rate to use in computing after-tax cash flows and dealing with money losing companies. In the process, we did look at what to do about accounting fraud, and while the answer is not much, there may be a role for forensic accounting. To be honest, most forensic accounting books are designed for valuation morticians, but here are a couple that you may find useful:
  1. http://www.amazon.com/Financial-Shenanigans-Accounting-Gimmicks-Reports/dp/0071703071/ref=pd_sim_b_8
  2. http://www.amazon.com/Creative-Cash-Flow-Reporting-Sustainable/dp/0471469181/ref=pd_sim_b_2
A reminder again that we will be back in class on Monday and that your quiz is next Wednesday. No new weekly challenge this week, but please work on the one that I sent you last week. Until next time!

Attachments: Post class test and solution

I was going to remind you of the project and working on it, but if you are turning your attention to the quiz, you may be checking out the links I sent yesterday for the past quizzes and solutions. Since the link I sent yesterday included only a subset of the quizzes and stopped in 2016. If you want more quizzes to practice on, try these for all the quizzes through 2019, and remember to work backwards, since the earlier quizzes may have slightly different coverage:
Past quizzes: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz1.pdf 
Past quiz solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz1sol.xlsx
I hope that you find some time to not just review the lecture notes, but work through the practice problems. In fact, it is the working through problems, using the lecture notes as a guide, that will provide the deepest learning. Until next time!
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: 
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).
3. Converting R&D to capital expenditures: We have net covered how to capitalizet R&D expenses in class yet, but you can get a jump on the process with this webcast. I use Microsoft from a year gone by to illustrate this concept:
Incidentally, to add to your stress, I just want to remind you that the first quiz will on Wednesday (March 2).  Until next time!

I know that you are busy and I have a guess about what you are working on. I have attached the newsletter, on the odd chance that you may want to take a look at it. I As you prepare for the quiz, try not to  drive yourself into a frenzy. It is just a quiz, just 10% and if you do badly, you can make it go away. That said, it is better to do well than badly. So, good luck and see you in class on Monday. Until next time!

Attachment: Issue 5 (February 26)

In tomorrow’s session, we will continue on the path of estimating earnings and getting to cash flows. Along the way, we will have to deal with leases, R&D, one-time charges, accounting malfeasance and other potential pitfalls. Nothing that we do is particularly difficult or hard to understand, but the details will pile on top of each other. Just to get you ready, you may find my latest data update post for 2022 relevant:
It looks at the profitability of companies around the world in 2021, and tries to draw lessons. On Wednesday, your will be taking the quiz in the first 30 minutes of class, and a reminder that if you are taking the quiz online (at exactly the same time), you need to put your name down in the Google shared spreadsheet:

Also, the quiz is open book, open notes and you can use your iPad/Tablet/laptop to access the lecture note slides. If you want all quizzes that I have given from 1997 to 2019, you can get them at the links below:
Quizzes: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz1.pdf
Solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/quiz1sol.xlsx
I think it is over kill, but whatever makes you happy.

Finally, I will have two extra office hours on Tuesday, and I have scheduled it for 9 am - 11 am, New York timef. The link to Zoom is here, and I will see you there:
Time: Mar 1, 2022 09:00 AM Eastern Time (US and Canada)
Join Zoom Meeting
See you tomorrow in class! Until next time!

In this session, We examined  broad questions about what to include in capital expenditures and working capital, before putting the cash flow topic to rest by working out debt cash flows and cash flows to equity. Next session, we will continue with a discussion of growth rates.  For Wednesday’s quiz, here are some final details. The quiz will be in the first 30 minutes of class in two rooms, Paulson and KMEC 1-70, with the following seating;
If your last name begins with Go to
A - G KMEC 1-70
H - Z Paulson Auditorum

Please do not swap rooms, since we will run into capacity constraints. Also, I will be having office hours tomorrow from 9 am - 11 am, and the zoom link is in yesterday’s email. Until next time!

Attachments: Post class test and solution

First things first! The quiz is tomorrow from 3.30 -4.00, and there will be class afterwards. 
1. In person exam takers: You will be taking the exam in Paulson Auditorium and in KMEC 1-70, based upon the letter that your last name begins with:
If your last name begins with Go to
A - G KMEC 1-70
H - Z Paulson Auditorum
2. Extra time/accommodations: If you signed up with the Moses Center for extra time and/or accommodations, you will be taking your exam at the Moses Center. They have the exam already, and you should be all set.
3. Online exam takers; If you are signed up to take the class online, I have decided that the best way to make this work smoothly is to put the exam on Brightspace, and you will be able to access it by 1.25 pim tomorrow, and you have 30 minutes to take it, and submit it back on Brightspace. You will entering your answers directly into Birghtspace. So, no need for printers or copies. This is the first time that I have given an exam on Brightspace (since we transitioned from NYU Classes) and I hope it works smoothly. Note that access to the Brightspace quiz is available only to those people who signed up on the Google sheet for online exams. (The exam on Brightspace is not a multiple choice exam. You will be working through problems and showing your work in Brightspace).

On a different note, today is the day that you get the valuation of the week. Rather than hit with you another company valuation, I thought I would try something lighter.So, 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;
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:
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 crossed the $1 billion threshold.
Updated box office for Force Awakens: http://www.boxofficemojo.com/movies/?id=starwars7.htm 
In addition, the eighth Star Wars movie has come and gone, with the Last Jedi, as has the next add on movie on Hans Solo:
Updated box office for The Last Jedi: https://www.boxofficemojo.com/movies/?id=starwars8.htm 
The final movie in this trilogy, The Rise of Skywalker came out in 2019. You can get the updated box office numbers for all of these movies here:

In addition, it looks like Star Wars is going to be central to Disney Plus making inroads into the streaming business. The Mandalorian was the most-watched series last year, and those Baby Yodas sold out for Christmas (merchandising again) and Wandavision looks like it is going to be a hit as well. That adds a value stream that did not exist a few years ago. 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:
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 from Yoda: Have fun, you must!

I hope that you have put the quiz behind you, good or bad. I will let you know when the quizzes are ready to pick up, and send the solutions and the grading template. In the session, which occurred after the quiz i, we started on our assessment of growth rates, starting with historical growth rates, before looking at analysts estimates of growth and why they do not carry more predictive power (given that analysts often are immersed in company-specific knowledge and have access to management). We then looked at tying growth to two fundamental questions: (1) how much companies reinvest and (2) how well. The way we measure these can vary depending on whether you look at earnings per share, net income or operating income. The weekly challenge for this week, if you feel up for it, centers on fundamental growth. Try it, if you get a chance. Until next time!
Want them or not, your quizzes are done. Before I tell you more, I have to start with a mea culpa. I screwed up on question 3 of your quiz (both versions). The original script that I wrote had the words “convertible bond” in the description of the bond, but somewhere between the script and the final version, the word “convertible” disappeared. Without it, the problem becomes not just unsolvable, but also meaningless. A convertible bond cannot trade at a price higher than the face value, unless it has a negative interest rate, and since I gave you a rate of 5% for the bond, it will not work. I am sorry for the mistake, and to make amends, I gave everyone who took the test the 2 points on the problem, no matter where you went with your solution.  Here are the details on how you can pick them up and check your score:
  1. 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 second shelf. (The quizzes for the MBA class are on the top shelf.) 
  2. How? They are in alphabetical order, based upon last names, 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!
  3. Moses or Online tests: If you took your test online, your score should already be on Brightspace, though I don’t have a physical copy of your solution. If you took it at the Moses Center, I will grade it and record your scores, as soon as I access your quizzes (very soon).
  4. 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 are two solutions. The first one (EquQuiz1asol) has Turkish Lira in the first problem and the second one (EqQuiz1bsol) has Polish zloty 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. (I have also put hard copies of the solutions with your quiz. Look on the shelf below your quizzes). (The solution to problem 3 reflects the correct wording for the quiz)
  5. Distribution: It is too early to attach grades to scores, but the average score was around 8, and the median was similar. If your score was substantially lower, remember that one of your quizzes will not count towards your grade, and you can make it this one.
If you are unable to pick up your quiz, your score should soon be accessible on Brightspace. Needless to say, if you have issues with the grading, I will be glad to talk with you. Since physical office hours still seem to be a no-no, I will set up a zoom link for those with grading questions to come in. Until next time!

3/4/22 I am testing your patience at this point, but I am going to go on anyway. In the session after the quiz (yes, there was class after the quiz), we looked at the link between fundamentals and growth, and in particular, at how much of a role accounting returns (ROE and ROIC) have on assessing both growth rates and the value of growth. The scariest aspect of these numbers is that they are entirely driven by accounting choices, which can create biases.  In this webcast, I look at the process of estimating accounting returns, using Walmart as my example:
Webcast: https://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/ROIC.mp4 
Walmart 10K (2013): https://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmart10K.pdf
Walmart 10K (2012): https://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmart10Klastyear.pdf
Spreadsheet: https://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmartreturncalculator.xls
An updated version of the return calculator is attached. In case, you are interested in learning more about returns on capital, you should first seek out a psychiatric evaluation, and if you pass, try reading this awesomely boring paper of mine on the topic:
If nothing else, I can guarantee you that if you have sleep problems, this paper will get rid of them. Until next time!

Attachment: Accountiing Return Calculator


This may be your weekend to forget valuation, but I am afraid that I have to intrude. The most recent newsletter is attached. By the way, your quizzes are on the ninth floor of KMEC, ready for pick up. Also, if you did your class online and have been unable to see your answers, you should be able to do so now. 

Attachment: Issue 6 (March 5)


In the coming week, we will complete the last pieces of intrinsic value, talking about growth in all of its forms tomorrow and the terminal value on Wednesday. This is hard to believe but we are close to half way through the semester. So, if you have not picked a company, you should. If you have, you should have the financials. If you have the financials, you should be working on the valuation. I think you get the picture. I have also attached the solution to the weekly challenge. If your reaction is what weekly challenge, I don’t blame you. Until next time! 

Attachment: Weekly Challenge Solution

In today’s session, we started by looking at fundamental growth in all its variants. With EPS, net income and operating income, we argued that the long term or sustainable growth rate for a firm is a function of how much it reinvests and how well it reinvests, with the measurement of each varying depending upon the earnings metric. We then looked at the possibility of efficiency growth in the short term, as ROE or ROIC change, and finally at the most general way of estimating cash flows, where we start with revenues, then forecast margins and tie up loose ends with reinvestment, tied to sales. In the final part of the session, we looked ways to keep the terminal value from running away with your valuation by capping growth, limiting the growth period and reinvesting enough to sustain growth.  I have two reading suggestions if you are interested. First, I mentioned my incredibly boring paper on accounting returns. You can find it here:
Consider yourself forewarned. The blog posts that I have on terminal value may be more up your alley:
  1. If you don't believe in forever, you cannot do a DCF
  2. As g->r, to infinity and beyond
  3. Growth is good, more growth is better
  4. Negative Growth Rates Forever? Impossible?
  5. The Terminal Value ate my DCF
They capture everything we talked about in class today. 

Attachments: Post class test and solution

Airbnb was one of the highest profile IPOs of 2020, and as the IPO approached, and before the bankers priced it, I posted my valuation for Airbnb, with my story:
You will notice that for an IPO valuation, there is an added input for IPO proceeds and IPO share count, but the bottom line is that I valued the equity of Airbnb at about $35-40 billion. As with any IPO, the numbers all come from a prospectus and I have a link to the final prospectus that Airbnb filed on December 2:
Now that Airbnb has been public for a while, I first obtained the updated financials for the company:
I updated my valuation to March 2022 to reflect its public status and its filings since going public.
Note that the value per share that I estimate has increased, as the company came back much more strongly than expected in 2021, and is about $61 billion. In the meantime, the stock has lost a chunk of value over the last year and now trades at about $100 billion. There are five drivers of value for Airbnb:
a. Gross Billings growth rate (in 2022 and a growth rate beyond): Rather than focus on growth rates, focus on the gross billings ten years out. My estimate is $180 billion. To give you perspective, that would make it almost twice as big as Booking.com and about a quarter of the size of the entire global hotel business.
b. Revenue as a share of gross billings: This is the percentage of the gross billings that Airbnb gets to keep. It is currently around 12.5% but I expect it to rise to 14%.
c. Target operating margin, measuring the profitability part of your story (I use 25%, reflecting my expectation that Airbnb is going to evolve to look more like Booking.com, an intermediary, than a hotel company)
d. Sales to Invested capital, measuring the capital intensity that will be needed for them to deliver growth. I use the company’s current sales to invested capital ratio of 2.65.
2. Failure probability: reflecting the likelihood that the company does not make it as a going concern. I assess a failure risk of 10%, reflecting their money losing status, but also factoring in their evolving business model and low debt.
Change what you want, leave all else alone and come up with your own value. Then, please go to the Google shared spreadsheet and enter your inputs. Let the games begin:

In today’s class, we started by looking at building a DCF model, and then talked about the loose ends in valuation, i.e., all the things you do after you have discounted cash flows back at the discount rate and why they matter. We started with cash, the simplest and most direct of all assets to value, and talked about why investors may attach a premium or discount to the cash balance of a company, arguing that discounts reflect a lack of trust in management. I mentioned a paper that looks at how the market discriminates across companies, when it comes to valuing cash balances. We then moved on to cross holdings, and why they are difficult to incorporate into value, and to other assets that you may consider adding on, because we have not considering them yet. On the latter, the key component to remember is not to double count an asset, by first counting its cash flow and then the value of the asset itself.  Finally, I attach a weekly challenge for this week, built around terminal value. Please try it when you get a chance. It is simple but it will reinforce some key components of what we did in class. Next week is spring break, and I hope that you have fun, and I promise not to send you emails for seven days, starting this Saturday.

Attachments: Post class test and solution, Weekly challenge

I know that you are looking forward the the break, and I wish you the best. That said, I hope that you are also moving forward on your project. As I mentioned at the start of the class, I will be glad to give you feedback (without a grade) on the intrinsic (DCF) value for your company, if you can get your DCF spreadsheet to me by April 1. While I will not be able to tell you whether your valuation is right or wrong, I can at least tell you whether there are inconsistencies. If you are just starting, I thought I would give you a boost. First, I will not be giving any credit for excel spreadsheet building skills. In fact, I would rather than you focus on valuation and less on spreadsheet building. If you are valuing a non financial service company, the only spreadsheet you will nee is the following;
The spreadsheet comes with add-ons that you may or may not need. Thus, there is a lease conversion worksheet, but if your company follows IFRS or GAAP can capitalizes leases, you can turn it off. There is an option worksheet that converts employee options into a value and recomputes value per share. Use what you want, turn off whatever you do not. To help you in using the spreadsheet, you may want to use this video guide that I recorded this morning for the Motley Fool, on how to use that spreadsheet. 
The presentation is long (about 2 hours) but the first hour is a quick review of the class, and if you have lost perspective as we delve into the details of discount rates, cash flows and growth, it is worth watching. The second hour takes you through the spreadsheet, using the Tesla November 2021 valuation as the exhibit, on how to estimate key inputs and how to read the output. If you really, really want to build your own spreadsheet, you can do so, but remember my admonition about less is more and please do not (under any conditions) use a spreadsheet you picked up at an investment bank, since fundamental flaws are baked into it. Until next time!
3/18/22 f you are back from break, welcome back! If not, enjoy the weekend and hope to see you back on Monday. That said, my week of not sending emails is now officially over, and in case you have the time, I hope that you are starting work or are continuing to work on your company valuation (which is due for informal feedback on Friday, April 1). As you well know, or will find out soon enough, much of your value per share for your company will come from the terminal value, and I have a webcast on checking terminal value that I hope that you get a chance to look at. 
I have built these checks into the spreadsheet that I sent you just before break ( https://www.stern.nyu.edu/~adamodar/pc/fcffsimpleginzu.xlsx), though I also let you change the defaults and get yourself into trouble. I also sent you a link to a YouTube video of a session I did for Motley Fool analysts on how to use the spreadsheet, and just in case you have lost that link, here it is:
he newsletter for this week is attached. In case you have time on your hands, I also just posted my thoughts on the market/economic implications of the war in the Ukraine. 
It may seem callous to talk about markets, when people are dying, but I don’t have a solution to the war (though I wish I did), and I am sure that you are not interested in what I think on humanitarian grounds. 

Attachment: Issue 7 (March 19)

The break is definitely over and I hope to see you back in class this week. We will complete our discussion of loose ends tomorrow, by talking about to deal with complexity, debt and stock compensation tomorrow. We will then turn to how story telling is at the heart of valuation, and how to connect stories to numbers. If you want to get a jump on this discussion, without spending the $20 it would cost you to buy the book, please read this post that I wrote on story telling and valuation in 2014:
The book was born out of this post, and the slides you will see in class came from it as well. It was a good return on time invested, for me, and I hope that you enjoy it too.
During today's session we finished the last loose ends in valuation and started on connecting stories to numbers. The way in which companies and equity research analysts treat stock based compensation is criminally negligent and I hope that you fin this post on the topic useful:
 If you want a longer version of my stories to numbers session, you may prefer this Google talk version that I did a few years ago on the same topic:
It is longer and a little more detail.

The DCF is due by a week from this Friday (April 1) (try to get it in by 5 pm, but if not, 6 pm or 7pm..). If you can get it in earlier, all the better. 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. As I mentioned in my emails from last week, you are welcome to use the spreadsheet that I have already built (or adapt it to your needs, so that you are not starting from scratch).The most versatile one for non-financial service firms is:
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. (Please don’t deviate from the script. It is to make sure that it gets into the right smart mailbox, and computers have no sense of humor)
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. 

 To put a bow on this part of the class, I have a blog post that you may find enjoyable about dysfunctional DCFs. 

Attachment: Post class test and solution

3/22/22 In this week’s valuation of the week, I look back at a valuation I did fouryears ago, when Brexit was still up in the air in the UK and people were unsure about how it would play our, with as many as seven different options on Brexit, ranging from a No-deal Brexit to no Brexit at all. I tookeasyJet, a UK company that is particularly exposed to Brexit, because it gets so much of its revenues from the EU, which has stringent rules on who can or cannot fly between EU countries, and tried to value it under different scenarios. You can read my valuation thesis here:
If nothing else, you will see how scenarios can be used to deal with uncertainty. The valuations themselves are at the links below:
  1. No Deal Brexit: http://www.stern.nyu.edu/~adamodar/pc/blog/easyJetNoDeal.xlsx
  2. Messy/Delayed Deal Brexit: http://www.stern.nyu.edu/~adamodar/pc/blog/easyJetMessyDeal.xlsx
  3. Smooth or No Brexit: http://www.stern.nyu.edu/~adamodar/pc/blog/easyJetSmoothDeal.xlsx
Brexit may now be settled, and you may not care about easyJet, but review the write up and valuation anyway, since this approach may help you in valuing your company, especially if you feel that there are discrete risks (an election coming up, a potential nationalization, regulatory change) that your firm is exposed to, where value can vary depending on the outcome.
In today’s class, we continued our discussion of stories, and how critical it is to keep the feedback loop open, so that you can make your stories better. We also talked about how story breaks, shifts and changes. Since I talked about 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 a conventional valuation of Con Ed in class, but we will move to more interesting storylines and valuations next class. If you are still wrestling with the question of management options, I have a weekly challenge that may help you work through your doubts:
Of course, the stories on these companies has evolved since, but it should give you a taste of how narratives change.

Attachments: Post class test and solution

 I know that your project DCFs are not due until a week from tomorrow, but if you decide to work on your DCF and even turn it in early, here is some general guidance.
  1. You will be turning in a spreadsheet, not a report.
  2. Your submission will be individual, not as a group.
  3. You will be submitting to me, with your excel file as an email attachment. Please include the words “My Perfect DCF” in the subject.
  4. You are welcome to use any of my spreadsheets. The most forgiving and versatile of my spreadsheets is http://www.stern.nyu.edu/~adamodar/pc/fcffsimpleginzu.xlsx. It has updated equity risk premiums,  for both the US and other countries and both US and global industry averages.
  5. Each of your valuations tells a story. Try to make it explicit and built it into your spreadsheet. In my spreadsheet, I have set up a worksheet to allow you to do this. Take advantage of that worksheet.
Don’t put too much pressure on yourself. This is only for feedback. Try your best. One final note. I will have office hours specifically for the project tomorrow (Friday, March 25) from 11 am-12 pm. The zoom link for the office hour is below:

I hope that you are able to spend some time this weekend working on your valuations, and they are due next Friday (April 1, and not the week after). As you work through them, there will be occasions where you will get a value that is very different from the price, and you will be inclined to believe that you (a) must have done something wrong or (b) that my spreadsheet has done something to screw up your valuation. While the latter will make you feel better, the truth is that the spreadsheet is designed to faithfully convert your inputs into a valuation. Thus, if you are getting too  low a value, it is coming from your inputs on growth rates, margins and reinvestment (through your sales to capital ratio for the next ten years and the ROIC after year 10). Changing those inputs will change your value, but if your end game becomes getting the value closer to the price, you have to ask yourself what the point of doing valuation is, in the first place. There is a diagnostic worksheet built into the spreadsheet that points to your big assumptions and how they connect to your valuation. Use it, if you are concerned about your value. Here is a simple table that illustrates how your assumption in the spreadsheet change value:

Put simply, this table illustrates what happens to your value per share, when you change these inputs in your valuation. Some of the effects are obvious; higher target operating margins will always increase value and higher costs of capital will reduce value. Some are tricky. If your value looks low, and you increase the revenue growth rate, it will mostly increase value, but it can sometimes lead to lower value, if you have a low sales to capital ratio (and higher revenues cause reinvestment to increase). The default assumptions at the bottom can also affect your value per share, and if misused, can cause your valuations to blow. In particular, be very, very careful with the default assumption where I let you set a growth rate that is different from the risk free rate in perpetuity. If you over ride that default and set the growth rate well above the risk free rate, I will have to disavow any responsibility for what may happen to your value.

On a different note, if you are confused about employee options and how they affect value, 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: https://youtu.be/-sGw4oLPTsM 
Cisco 10K: https://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/EmployeeOptions/cisco10K.pdf
Spreadsheet for options: https://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. 

I hope that you are approaching cloture on your DCF valuation. In case you are interested, the newsletter for this week is attached.

Attached: Issue 8 (March 26)

3/27/22 As you work your way through your valuations, a quick preview of what is coming this week. We will spend both tomorrow and Wednesday’s class working through valuations. While we will spend only a few minutes on each company’s valuation, I will focus on one or two aspects in each company to highlight. (Otherwise, going through every valuation in full detail will be drudgery.) If you do get done with your valuation before then, you don’t have to wait until Friday. Go ahead and send it to me, when you are ready, using “My Perfect DCF” as your subject.
In today’s class,  we started by looking at 3M, and how a market crisis can affect value, even if nothing about the company has changed. We then adapted the model to value an index (the S&P 500). If you are interested in an updated version, where you can change the numbers try this link:
Finally, we looked at how best to adapt valuation models to value companies on the dark side. Specifically, we examined how best to value young companies with limited information. If you are interested, try this paper on valuing young companies:
I also have a blog post that you may find relevant for today’s discussion on how dilution in future years is already incorporated into value:

I have noticed that some of you are having trouble with the zoom link for office hours. Since it is shared with the other two classes, it might not be showing up on Brightspace, but the link is below (for both today, from 5 pm - 6 pm) and all subsequent office hours):

Next Monday, we will move on to the second quiz for the class. In case you are nervous about it, here are some specifics:
1. Quiz time and logistics: The quiz will be on Monday, April 4, in the first 30 minutes of class (1.30-2 pm) and there will be class after the quiz.
2. Content: It will cover the mechanics of DCF, starting with growth rates and terminal value and extended into the loose ends of valuation and the versions of the DCF we have used on the dark side. 
3. Review for the quiz: The links to the review for the quiz and the past quizzes are below:

Attachments: Post class test and solution


In today’s session, we continued on the dark side of valuation with a look at mature companies on the verge of transitions, and how you have to value the status quo company and the restructured one to make a judgment on investing in it. Finally, we looked at declining companies, where your forecasts may have to show declining revenues and margins, and added a twist with distressed companies, where you have to follow up your DCF.

Attachments: Post class test and solution

I hope that you have had a good week. I know that some of you have turned your attention to the quiz, which is on Monday, and that is perfectly understandable. In case, you have lost the links to quiz, I have attached them below:
Presentation: https://pages.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.xlsx 
I had also promised office hours this weekend. They will be from 11 am - 12 pm on Sunday, and the zoom link is below. If there are lots of people, I will stay on as long as needed to answer your questions:
For those of you who still have the time to work on your DCF, if you can get me your DCF to me tomorrow, great, but I will leave the submit window open for a week, for feedback, but only if you want it. When you do submit it, a reminder to enter “My Perfect DCF” in the subject. 
Three quick notes. First, the newsletter for the week is attached. Next, if you are preparing for the quiz, I will have office hours tomorrow and day after and the links are below:
Office hour on Sunday, April 3, from 11 am - 12 pm:  https://nyu.zoom.us/j/91979690185 
Office hour on Monday, April 4, from 9 am - 10 am: https://nyu.zoom.us/j/92119670806

Finally, we will be done with packet 1 this coming week and moving on to packet 2. Please download both packets 2 & 3 when you get a chance. The  links are on the webcast page, but I have the attached the pdf links below:

Atachments: Issue 9 (April 2)

By now, almost all of you should have got your DCFs back, with my minimalist feedback. If you have not received feedback, could you please resend your DCF with “My Perfect DCF” in the subject. If you were expecting feedback on details (like beta or revenue growth rates), you were probably disappointed, but I thought that it might make sense to take you through my template for reviewing my spreadsheet, so that you can do it yourself on a future valuation.
1. Start by looking at your historical financials: The first place to start is by checking the inputs that you have for the most recent year and the year before. I took two company valuations from last year’s class (so that I would not be exposing the valuations of someone in this class), Live Nation and Nio, very different companies and will use them to illustrate the process. 

Obviously, Live Nation  and Nio diverged in 2020, with the former having a horrifically bad year and the latter a really good one (at least in terms of growth). Note that Nio is incorporated in the US, but it is a Chinese company. 
Advice on units: Everything in your valuation has to be in the same units (hundreds, thousands, millions etc.). While you can use any units, stay away from having too many digits in your inputs (pick millions over thousands, for instance).

2. Check out the riskfree rate and cost of capital: The riskfree rate will reflect your currency choice for your valuation and your cost of capital will (or should be) in the same currency. I do have a worksheet that computes your cost of capital, but if you plan to use, rather than directly input a cost of capital, please make sure that you have picked the businesses and geographies for your company in that sheet.
Live Nation
Live Nation is being valued in US dollars, while Nio is being valued in Yuan. (See riskfree rates). The costs of capital are consistent, lower for Live Nation than for Nio. To check to see if your cost of capital is within bounds of reasonableness, remember that the median cost of capital in US dollar terms for a global company is 6-6.5%, and if you have a different currency, you can add inflation to it. If your cost of capital is more than 4% off the median in either direction, check your numbers to see if there is a mistake.

3. Check through the key inputs on growth, margins and reinvestment: The key inputs that drive your valuation are in the input sheet, and while they might be linked to a cell in default, you preserve and should use the power to change them to what you think best fits your story (see step 5):
Live Nation
You may need to revisit your numbers after you go through step 4, but you are not bound by historical data, industry averages or any other variable. These are your inputs.

4. Do a quick scan of the valuation output: Go to the valuation output page, and check out the following:
a. Revenues in your terminal year: One of the problems with growth rates in percent is that it is very difficult to figure out how the compounding plays out over time. To illustrate, take a look at the revenue forecasts for Live Nation over time:
The growth rates look high, but the revenue you have in year 10 is $8.5 billion, well below the revenues of $11.5 billion they had in 2019. That is a pessimistic story, albeit a plausible one, for the future, and if that is what you intended, you should leave it as is. If not, you should go back and change your revenue growth rate from years 2-5. 
For Nio, revenues are up, up and away, which makes sense given that it represents the convergence of two potentially big markets (China and electric cars)
Here the revenues increase to 340 billion Yuan in year 10. (In dollar terms, this would be about $50 billion). Again if that strikes you as too low (high) a number, go back and revisit your revenue growth rate. To get a sense of whether it is too high or too low, you should look at large companies in the sector and see what they generate as revenues.
b. Evolution of margins/operating income over time: In the table above, you also see margins changing for your two companies towards your target margin. How quickly it happens depends on the year of convergence that you pick. A lower number (as is the case with Live Nation) will cause a speedier convergence.
c. Imputed return on capital: If you go to the bottom of the valuation spreadsheet, you will notice an item that you probably overlooked when you did your valuation, but it will give you a snapshot of how your assumptions about growth, margins and reinvestment have played out in the company. For Live Nation, here is what you see:
The fact that your return on capital has trouble getting off the floor and even approach your cost of capital is troublesome, and it does look like you are reinvesting way too much, but more on that in step 5.
With Nio, the return on capital rises rapidly over time, but given its status as a first mover in China and presumed competitive advantages in that market, you may be okay with the 24.85%, but if you feel it is too high, you may need to work on your reinvestment, by lowering your sales to capital ratio.

5. Go to your stories to numbers worksheet: The most critical sheet on diagnosing your own DCF is your stories to numbers sheet. If you never even got to this sheet, clearly, you would not have been able to use it, since it will carry the default stories for GameStop or Boeing in there. For Live Nation, here is what you will see:
As you can see, the valuation yields a negative value per share and the culprit is also clear. It is your negative FCFF for the next 8 years. While each individual item has a storyline that makes sense, there is a fundamental contradiction in these forecasts. Since you are assuming that the company will not even make it back to 2019 levels, why do you need to be reinvesting such huge amounts in the future. Put simply, the sales to capital ratio is way too high, given your revenue story, and the easiest way to fix it is to go raise the sales to capital ratio to a really high number (I would use 100, in this case, since your revenues never make it back to pre-COVID levels). In more moderate cases, where you make it back to pre-COVID levels over the next three or four years, you can use a high sales to capital ratio for those three years and then lower it to historic norms or industry averages. 

Finally, I know that a few of you built your own spreadsheets and I applaud you for doing so. If you found yourself pushed into using my spreadsheet, it is not because I am better at building spreadsheets than you are. I am not an Excel ninja, but I do know that spreadsheet building is a lot more work than you initially think it will be. In my experience, any spreadsheet you build takes about ten runs before you fix any remaining errors, and I wanted your focus to be on valuation, not Excel. So, feel free to abandon my spreadsheet and build your own, when you have the time. If you do so, my only advice to you is to forget everything you learned about building spreadsheets at an investment bank, where you have hundreds of line items, three statement forecasts and exit multiples. That is the roadway to hell.
4/3/22 Needless to say, but I will say it anyway, the second quiz is tomorrow in class, in the first 30 minutes of class. If you signed up to take it virtually, you will be getting instructions in the next few minutes on access, but the window for the online version is now closed, since it creates chaos to be adding people at the last moment. Tomorrow, we will complete the residue of intrinsic valuation, by talking about valuing emerging  market, commodity and financial service companies. On Wednesday, we will start on pricing, and that will require the second packet of lecture notes which are accessible on the webcast page for the class. Please download them when you get a chance. See you tomorrow, and until next time!
In today’s session, after the second quiz, we wrapped up our discussion of intrinsic valuation. For decades, we have valued banks using the dividend discount model, simply because getting cash flows is so difficult, but that approach is built on trusting management at banks to behave sensibly (paying out what they can afford to in dividends) and regulators to do the same. For me, that trust was breached in 2008, and I present a way of estimating FCFE for a bank, using investment in regulatory capital as my stand in for reinvestment. Next session, we will wrap up the valuation section and start on pricing. If you are interested in reading more about valuing financial service companies, try this link:
The Deutsche Bank post is here:
We also looked at valuing commodity and cyclical companies, and why capitalizing R&D can change the value of a pharmaceutical company. The last part of the class was our first foray into pricing, why price can be different from value and why pricing is so much more common than intrinsic value. 

Attachments: Post class test and solution


The quizzes are done and you can pick them outside the entry door to the finance department. Before you open the door, look to the right and you should see your quizzes on the second shelf of the book shelf. They are in two piles and in alphabetical order. If you cannot make it to school, your grades should show up on Brightspace (and this should be true if you took your class online, or at the Moses Center). I have attached the solution to the quiz. Note that on question 4a (the first multiple choice question), I had given you a choice of revenue growth being high or low, and my wording was ambiguous, since high or low is in the eye of the beholder (I should have used higher or lower). I gave credit for both answers. If you have any concerns about your grading, take a picture of the page where you see my grading error and send it to me. 

Attached: Quiz and solutions


We started the class by looking at valuing commodity and cyclical companies, and why capitalizing R&D can change the value of a pharmaceutical company. The rest of the class was our first foray into pricing, why price can be different from value and why pricing is so much more common than intrinsic value. Wwe also started on the first steps in deconstructing pricing, with the definitional and descriptional tests.

Attachments: Post class test and solution

4/7/22 I know that you have other things on your plate, but I will nag you about your final project nevertheless. If you have your DCF done, you should have got it back by now, if you have sent them to me for feedback), it is time to think about pricing your company. For the moment, that may just involve computing every conceivable multiple for your company, both equity and enterprise value. Here are a few standards - PE and PBV, for equity and EV/Sales, EV/Invested Capital and EV/EBITDA. You may consider this a waste of time, since many services including Yahoo! Finance compute them for you, but as we noted in class, there are choices that these services make on what to include and exclude in their computations that you may not find palatable.  If you want to get creative, you can also compute pricing multiple specific to your sector. With an oil company, this could be EV/Barrels of Oil in Reserves, with ride sharing companies like Uber and Lyft, EV/Rider and with subscription company, EV/subscriber. Next week, we will take tangible steps to finding comparable companies and comparing these pricing multiples across companies. 
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 week’s tools webcast, I look at what the differences are between these different numbers and how our assessments of leases & R&D can change these numbers. Start with this blog post:
Then watch the webcast:
You can download the presentation:
And the spreadsheet that goes through the calculations:
Nothing deep, but if you have ever been confused about the difference between market cap and enterprise value, and why we use one as opposed to the other, I hope that this clarifies things.

I am working through the straggler DCFs that are still coming through, for feedback. If you have not sent yours already, and you still would like me to take a look at it, the window is still open. The newsletter for the week is attached.

Attachments: Issue 10 (April 9)

This week, we will expand on our discussion of pricing by diving into specifics, starting with the analytics, on how to use intrinsic value basics to extract the variables that determine each multiple. We will them move on to how to pick comparable and then move through a series of examples, were you will use the tools to assess how to control for differences, when pricing companies. Along the way, don’t forget that pricing is a pragmatic game. If it works, use it. To give you a sense of pricing, I 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. (Really?)
No. This is not a parody but a real technique. If you don’t believe me, read the whole thing:
You may find it laughably simplistic, but in pricing, if it works, don’t fight it. 
In this session, we continued with our discussion of pricing, starting with the analytics that drive PEG, PBV, EV/EBITDA and revenue multiples. During the session, I played the role of a naive equity research analyst, using sloppy pricing to push buy recommendations on stocks in a number of sectors, based purely on the level of multiples (low PE, low PBV etc.) and asking for pushback. In some cases, we just noted qualitatively the forces that may explain the stock’s cheapness (the beverage sector, for example) and in others, we used regressions. The bottom line, though, is that most companies that look cheap deserve to be cheap. The key to pricing is finding a mismatch between the pricing and the fundamentals (low PE & high growth, low PBB and high ROE, low EV to Sales and high margins). It is the basis for much of equity research, and takes the form of screens. If you are interested, I have a post that expands on the notion of screening.
Since you have access to S&P Cap IQ, you can try this out in any sector. 

Attachments: Post class test and solution

In keeping with the shift from valuation to pricing in class, starting this week, rather than give you valuations of the week, I will be doing a pricing each week. I decided to go back in time to 2017 for this week’s pricing is of a Russian steel company, Severstal, because it helps illustrate the process of pricing and contrasts it with the intrinsic valuation, and may be helpful as you price your companies.  You can get the story of the pricing at this link:
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:
I used this raw data to estimate median values and compared Severstal to those values in this link:
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 busy, but I have put up the webcast up on debt design, using Walmart as my example (on the webcast page as well as on the project resource page).  Here are the details on the webcast:
Webcast: https://youtu.be/ozpSk80ZNC0 
The updated macroduration spreadsheet with data through 2021 was attached to yesterday’s email! Hope you find it useful. One final point. If you find this in-practice webcast useful and want to review the whole series, the playlist is on YouTube and you can find it at this link:

Also, I am sorry to harp on the Google shared spreadsheet but please enter your numbers there for your company, as you have them. 

You can use my Disney numbers as guidance, and the page numbers on the lecture notes will tell you where the numbers come from. I don’t know whether it will make you feel more in control, but it will make me feel better.

Attachment: Post class test and solution

I know that you have other things on your plate, but I will nag you about your final project nevertheless. Please go through the process that we went through in class of choosing comparable firms, finding a multiple that works and then controlling for differences (statistically or otherwise). Along the way, don’t forget that pricing is a pragmatic game. If it works, use it. If you have no idea what this process involves, take a look at my pricing of Severstal from this week’s valuation/pricing of the week and keep an eye open for the the valuation tools webcast that I will upload tomorrow. For the part of your project where I ask you to value your company relative to the market, feel free to use my market regressions from the start of 2022:
On a different note, if you are struggling with the statistics in pricing, I would suggest watching at least the regression part of my online statistics class. Here is the link to my statistics class:
The sessions in question are 5, 5A and 5B, since I don’t think you will have the time to watch the entire class. 
4/15/22 If you have trying your hand at the pricing part of your 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  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:
Download the slides:
Here is the raw data:
And the descriptive statistics:

By the way, I forgot to send you the weekly challenge for this week. It is a quick one, and it is worth doing simply to solidify your understanding of the definitional test for multiples (are they consistently defined), 
I am attaching the newsletter for the week. As we approach the last few weeks of the semester, and you take stock of where you are in the class, some of you may be wondering how your quizzes, final exam and the project will play out in a numerical final grade. In particular, the question of what happens to the worst of your three quizzes, if you take all three, may be confusing you. I don’t know whether this will help but I have create a scoresheet where you can enter your actual scores for the first two quizzes and the case and prospective scores for the remaining quiz, the final exam and the final project, and see the total score you will have in the class. At the moment, I cannot give you a look up table that will convert that total score into a letter grade, because that will depend on how the entire class performs on the remaining quiz, final and project. 

Remember that the scores you see on the spreadsheet are not your scores, and as you enter your own scores, you will notice that the bulk of the class grade is still ahead of you, and that is good news for some of you and cautionary news for others. For those of you who have done badly on both of the first two quizzes, it is good news, since a good third quiz and final will rescue your total score. For those who have done really well on the first two quizzes, it is cautionary news, since letting your guard down too soon can still cost you. It also operates as a reminder of why getting your final project done is so critical. Just to give you perspective, the median score on the final project last year was 31/35, with a low of 25 (for one group) and a high of 35. (If you are wondering what the 5 points for number submission is for, it is really for entering the numbers that you find on your company into the master spreadsheet by Sunday, May 8 (and it should be a gimme for almost all of you): 
So, if you have been lagging on your project, you may want to catch up. 

Attachment: Issue 11 (April 16)

In the week to come, we will start tomorrow on asset based valuation. In particular, we will focus on liquidation valuation and sum-of-the-parts valuation and pricing, and why it is so difficult to pull off successfully. We will then start on, and continue in Wednesday’s class, on a discussion of how to value private businesses for curiosity, transactions and initial public offerings. By the end of the class on Wednesday, we will be close to or done with packet 2 for the class, necessitating a download of packet 3 for the following week:
In this session, we looked at 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. If you are interested in a more extensive assessment of companies like United Technologies, you may find this reading useful:
We then started our discussion of the valuation of private companies by noting how the lack of a market price for a business can affect your valuation in implicit and explicit ways, and then arguing that the value you attach to a private business can depend on why/for whom you are doing the valuation. 

As the end of the semester approaches, the pace will continue to pick up, and next week will bring quiz 3, which will cover all of pricing, asset based valuation and private company valuation (packet 2), scheduled for next Monday. The links are below:

Attachments: Post class test and solution

I know that today is the day that I send the valuation/pricing of the week, in case you were keeping tabs, but I wanted to clear up any questions about timing and due dates for what’s left of the class. 
April 25, 3.30- 4 pm: Quiz 3 (Preview and past quizzes below)
May 9 (Last day of class); Final Project due by the end of the day
May 11, 4 pm - 5.50 pm: Final Exam
As with the quizzes, I will have an online option for quiz 3 and the final exam, but with both, I would prefer that you take the exams in-person, if you can. Until next time!

For quiz 3, we will cover all of packet 2, which if you are keeping tabs, covers pricing, asset based valuation and private company valuation.
We started today’s class by looking at IPOs, and how to incorporate both the proceeds and the pricing considerations of bankers (who guarantee an offering price) as well as how VCs and PEs may look at firms during their transitions.  Along the way, we had a discussion of direct listings as a challenge to the IPO process and 
We then started on the real options discussion with an analysis of the two driving forces behind their value: learning and adaptive behavior, and then moved on to the three questions that need to be asked and answered before buying into the real options argument:
1. Is there an option embedded in an asset? (Look at the cash flow payoffs)
2. Does that option have value? (Is there exclusivity?)
3. Can you use an option pricing model to value that option? (Are the underlying asset and option traded)
The third quiz will not include real options. 

Attachments: Post class test and solution

4/21/22 his email may freak you out, since there is still time left on the project, but since time is scarce, I thought it would make sense to send you this list today. (Section 3 covers what we will do in class next week, and will not apply for most of your companies.. ) Therefore, 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, at least for revenues and operating income.
1.4. Review your final valuation for consistency
What you should include in your final report: A picture that shows your valuation (with the story embedded). That should include your key inputs, a summary of your projected cashflows, your key output (including value per share and price per share). If I were turning in a valuation of Boeing, for instance, here is what it would look like (If you are using my spreadsheet, this is already a worksheet in the spreadsheet that you can use to fill in your story.

2. Relative valuation/ Pricing
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:
What you should include in your final report: Tell me what multiple you used in pricing (and why), the comparable firms you used (with sample size), how you controlled for differences (if you used a regression, give me a summary of what you found with statistical significance - t stats and R squared) and your pricing judgment. For example, if I were presenting a pricing for Boeing, this is what it may look like:
Multiple used: EV to Sales, because earnings are negative and EV to Sales has the highest R squared among the different EV multiples
Comparable firms: Global aerospace and defense firms (Sample size = 28 firms)
Control tool: I ran a regression of EV to Sales against operating margins across the 28 firms 
EV/ Sales =  0.83 +  6.51 (Pre-tax Operating Margin) R squared = 38.33%
(1.35) (4.56**)
(Numbers in brackets are t statistics with the two stars indicating significance at the 99% confidence interval)
Boeing’s pricing = 0.83 + 6.51 (.096) = 1.46 (I used expected future margins, since 2020 margins will be negative)
Boeing EV = 1.46 * $76,559 = $111,390
Boeing Pricing per share = $164.11 (I added cash and subtract out debt to get to equity value, before dividing by number of shares)

3. Option valuation (Next week’s classes...)
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.
What you should include in your final report: Boeing is losing money, but its debt is only $28.5 billion (about 25% of its value). So, the option to liquidate is not worth computing.
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 2019  (the date will depend on when you get done)
4.3: Make your recommendation (buy, sell or hold)
What you should include in your final report: My DCF value ($160/share) and pricing ($164/share) are both higher than the current price. I am buying Boeing.

5. Numbers to me!!!!
Fill in the Google shared spreadsheet when you have the numbers for your company.
To provide some motivation beyond my pathetic begging, I will assign 5 points out of the 40 points on the project to just getting the numbers into the spreadsheet. (Please don’t enter random numbers)

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 9, 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 15 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 19 pages. If you are doing your valuation individually, a page limit of 4 pages applies. Please do not attach excel spreadsheet. And no.. you don't have to do everything that these groups did. 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.
Since you are preparing for the quiz on Monday, I thought that this would be a good week to skip the valuation tools webcast. If you feel the urge to work on the project, the twelve valuation tools webcasts can be found on this YouTube playlist:
If you have been watching Elon Musk’s Twitter play, you already know some of my thoughts, from class, but I did get around to writing a post with my updated Twitter valuation yesterday. You can find it at this link:
Finally, I will have office hours this Sunday, from 10 am - 11.00 am, staying on longer if there are people still waiting to ask questions, about the quiz, and on Monday morning from 9 am - 10 am, if you have any final questions. The zoom links are below:
Sunday, 10 am - 11.30 am: https://nyu.zoom.us/j/92262620793 
Monday, 9 am - 10 am:  https://nyu.zoom.us/j/96703739486 

The newsletter for the week is attached. As the clock winds down, deadlines are approaching. The third quiz will be on Monday (April 25). It will cover packet 2 (pricing, private company valuation and asset based valuation). So, keep that in mind as you review past quizzes.  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. I will have office hours tomorrow from 10-11 and on Monday from 9 am - 10 am, if you have questions.

Attachment: Issue 12 (April 23)

We will start tomorrow’s class with quiz 3, and I won’t bore you by sending you all the links again. I will have office hours tomorrow morning from 9 am - 10 am, if you still have questions:
Again, a reminder of seating plans for tomorrow’s quiz:
If your last name begins with Go to
H-M KMEC 1-70
A-G, N -Z Paulson Auditorium
After the session, we will continue discussing real options and that discussion will spill over into Wednesday, starting with treating patents and undeveloped natural resource reserves as options and continuing with an argument for why equity in a distressed firm takes on the characteristics of an option. Until next time!

We started today’s class with quiz 3, but after the quiz, we looked at the basic option pricing models. After that, we moved on with an examination of option pricing models, and used real options to examine why the rights to non-viable technology can be valuable and why the values of natural resource companies are affected by both the level and variability of commodity prices . As a cautionary note, you are pushing option pricing models to breaking point when using them to value these options, but the key takeaway is that even if you do not value the options explicitly, understanding that they exist can alter how you behave as a business. It is also true that the information that you will need to value many real options will be accessible only if you work at the pharmaceutical or natural resource company, and consequently, you cannot apply it to your company (project), since you will not have that access. During the course of the class, there were a couple of places where I was guilty of not being as clear as I should have been. One was when we discussed why I used Merck’s pre-tax cost of debt in my present value calculation for Biogen’s license fee. Let me break down my rationale into multiple parts:
  • I use Merck’s cost of debt, since Merck is the one that has contractually agreed to pay the license fee and the risk is that they will not (if they default).
  • I use the pre-tax cost of debt, since there is no tax advantage that Biogen gets from Merck using debt. Using an after-tax cost of debt would have inflated the value of the license fee for a tax benefit that Biogen would not be getting.
The other issue is the cost of delay, where I use different approaches for different options (1/n for the patent, the CF as a percent of value for the undeveloped reserves). That reflects judgment choices, but ultimately, the question you are trying to answer is what you, as a company, will lose by not exercising an option (patent or undeveloped reserve) once it becomes viable. There is one potential application of options in valuation and that is valuing equity in troubled companies with lots of debt as options that you can try on your company, and it will be relevant if you are valuing a money losing company with a lot of debt. 

Attachments: Post class test and solution


The quizzes are done and can be picked up on the 9th floor of KMEC, in front of the door to the finance department. They are on the second shelf, in two piles. The top shelf has the MBA class. The grades are also on Brightspace, if you want to just check your score. The solution with the grading template is attached.

Attachment: Quiz 3 and solution


I hope that you get a chance to pick up your quiz, or at least check your grade on Brightspace. In fact, since all three quiz scores should be in, please make sure that the scores are correctly entered. I am leery of providing distributions on quizzes, but I understand the need to find out what the rest of the class did, at least to get a sense of relative performance. In fact, it is entirely in keeping with what we do in pricing, when we attach numbers to companies. The distribution is below, but rather than providing just the average and the median, I thought a fuller distribution would be more useful:


In today’s class, we continued with our discussion of real options, starting with an analysis of undeveloped natural resources are options and why the option to abandon and financial flexibility can be viewed as options, and how to value them. We then turned our attention to distressed equity, and why stock in a highly levered, money losing firm can become an option, and why it matters for investors. Since the value of distressed equity as an option rests on having a lot of debt, you will not find much use for it on your project, unless you happening to be valuing a company where there is negative earnings or the threat of negative earnings and a lot of debt. If you do, you may find this spreadsheet useful in getting that option value:
If you are have trouble with figuring out where to get the inputs, I am sending you a preview of the very last valuation tools webcast, where I use Jet India (a company that I think has been put out of its misery) a few years ago, with the model:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/equityoption.mp4
Jet DCF: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/DistressedEquity/jetindiaDCF.xls
Jet Equity as option: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/DistressedEquity/jetindiaoption.xls 
As I said, don’t force your company through this, if it does not fit. Finally, I have attached a weekly challenge about patents that may help cement what we talked about in class.

Attachments: Post class test and solution

As you review what we did with real options this week, you will quickly realize that it will have little direct effect on your project, since your company is unlikely to lend itself (easily) to real options applications. Here are the possible exceptions:
1. If you are valuing a money losing company, with a lot of debt (look for a debt to capital, in market terms, of 50% or higher), you can use the distressed equity option approach. This is unlikely to be the case, if you are valuing a growth or technology company, but it could be applicable if you are valuing an airline. If you decide to try the option approach, watch the practice webcast on applying option pricing to distressed equity (I sent the links yesterday and will add them to the webcast page). The spreadsheet is https://www.stern.nyu.edu/~adamodar/pc/equity.xlsx

2. If you are valuing a pharmaceutical company that has multiple drugs in production and many patents, don’t try to value each patent. You will drive yourself to distraction. If you have a small Pharma company with one or two blockbuster patents, you can try, but more in a qualitative sense, than in actually valuing the patent. Put simply, if you are valuing Moderna and finding it close to fairly valued with a DCF model, you can argue that the MRNA patent that they have adds value (without specifying a number), justifying buying the company.

3. If you are valuing a natural resource company, you can see if you can find information on undeveloped reserves and give it a shot, but here again, don’t over reach.

Since real options work in only one if seven or eight companies, don’t be surprised or worried if no one in your group can find a way to use them. One final point. Stern IT did a security patch this morning that seems to have screwed up links and even getting into my website. I am trying to get a straight answer from them on what they did, and how I can counteract it. I have been able to restore access to my website, but if you find a link not working, click on the reload and it seems to work. No idea why!
4/29/22 This is the last of the valuation tools webcasts emails. I just added webcasts on how to value patents as an option as well as valuing distressed equity, using option pricing models.For the patent valuation, here are the links:
Webcast: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/optiontodelay.mp4
Presentation: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/optiontodelay/optiontodelay.pdf
Spreadsheet: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/optiontodelay/productoption.xls
To value equity in troubled companies as options, I am going to send you the same links that I sent after class on Wednesday: I use Jet India (a company that I think has been put out of its misery) a few years ago, with the model:
As I said, don’t force your company through this, if it does not fit (money-losing, with a lot of debt). Until next time!

The countdown has begun. We have three sessions left in the class, nine days until the project is due and eleven days until the final exam (but who’s keeping count, right?) The last newsletter is attached and while it contains no real news, it is a ritual that I go through each week. As you work on your project, please do enter your final numbers in the Google shared spreadsheet:

If you get ambitious and want to work on getting ready for the final exam, here are the links
Webcast: https://youtu.be/_8HYZ-BaBSA
Slides: http://www.stern.nyu.edu/~adamodar/podcasts/Webcasts/valfinalreview.mp4 
You can also find past final exams and solutions at this link:
Past finals: http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/finals.pdf 

Past solutions; http://www.stern.nyu.edu/~adamodar/pdfiles/eqexams/finals.xlsx

Attachments:Issue 13 (April 30)

Tomorrow, we will turn our attention to the many sins in acquisition valuation and as a precursor, I have attached a series of questions that cut to the heart of acquisition valuation and will form the backbone for tomorrow’s class. It is a great way to review the entire class while also getting ready for tomorrow’s class. So, please give it your best shot. On Wednesday, in the second to last session, we will turn our attention to the last part of this class, where we will go inside companies and look at the levers to increase value. For those of you who will be in consulting, strategy or running your own businesses, you will get to see what drives value up (or down).  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. I know that some of you have had new quarterly reports coming out, but you also face a realistic time constraint. I will not require that you update the inputs into valuation to reflect the new report, and for the most part, it will not make much of a difference to value, if it does not change your story. I did update the equity risk premium for May 1, to 5.14%, reflect the carnage that we have seen in stocks in the last two weeks. You can update the equity risk premiums worksheet in the fcffsimpleginzu spreadsheet, by just updating the US premium from 4.24% to the May 1, number. All the numbers will get updated as well.
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. If the option pricing applies to your company, try it.
4. Make your recommendation and I will accept your judgment. When you make your recommendation, remember that while you may have chosen to finish your valuation as of April 15 or April 22 or some other day, your recommendation will be as of close of trading on May 6 (Friday, before your last weekend). That effectively means that the price you will be using will be as of that day (please enter that price into the Google shared spreadsheet). I know that you cannot be updating your DCF and pricing through that day, but making a recommendation from some day in the past is pointless, unless you have a time machine. Recognize that this will mean that given how much prices are moving, your over valued stock from two weeks ago may be under valued now. A pain in the neck, I know, but reality bites.
5. Go into the Google shared spreadsheet and enter the numbers for your company.  Under date of the valuation, I notice some of you are entering dates like December 2021, which is implausible and perhaps even impossible. You may have used financial statements ending as of December 31, 2021, but you certainly did not value your company on December 31, 2021. The date of your recommendation is May 6, and while your DCF valuation may precede that date, you are using it as your estimate of value on May 6.

Finally, no matter how many mixed messages I have sent (and I am sorry), the final exam is on May 11. See you soon!
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 briefly mentioned 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.
I go through the process of valuing control and synergy in a merger, and even if you don’t agree with my assumptions, the framework can still be useful. 

Attachments: Post class test and solution

I hope that you are moving towards completion on your project. I am tracking your numbers on the Google shared spreadsheet, and if you have not entered them in already, please try to get your numbers in by Sunday (the earlier in the day, the better). If you already have your numbers in there, and want to change them, you have until Sunday to do it, before I download to prepare for the last class:
As you put the wrap on your projects, here are some final points to consider:
1. You cannot fight the data. Put simply, if no matter what you try, you cannot get any of the regressions to work, the message is that the pricing in the sector cannot be explained by the fundamentals on the ground today. That does not make pricing pointless but it can give you a pricing for your stock that is very different from your intrinsic value.
2. If your company is a young, money-losing company, plugging your company current revenues (tiny) and operating margins (negative) into a sector regression will give you absurd predictions for pricing (negative or very low EV to sales ratios). The reason is not mechanics, but perspective. Investors buying Palantir or DoorDash are not buying these companies for how much money they made last year, but based on how much they will make in the future. If you want to price these companies, you have to follow these breadcrumbs, and use your expected revenues and margins from a future year (remember that you have made these forecasts already in your DCF) in the regression to get a predicted pricing for the company. Remember to bring this back to today. As an example, assume that a regression you have for EV/Sales against operating margins yields the following:
EV/Sales = 0.80  + 15.00 (Pre-tax Operating Margin)
If you company current has a 10% margin, plugging that value into the ratio will yield an expected EV/Sales of -0.70, but if you expect your company to have $10 billion in revenues in year 10 and an operating margin of 20% (and a cost of capital of 9%), here is what you will get:
EV/Sales in year 10 = 0.80 + 15.00 (.20) = 3.80
Expected EV in year 10 = $10 billion (3.80) = $38 billion
Value today = $38 billion/ (1.09)^10 ; I am discounting back at the cost of capital, because it is enterprise value. If this were equity value, I would discount back at the cost of equity.
3. With the market regression, and you can use mine, you are still making a pricing judgment, but against the entire market (not your sector). Here again, with a young company, you can get odd numbers if you plug in current values for margins and returns on equity or capital and you will be better off using forward estimates for pricing. Also, you can get a very different pricing for your company, because the comparison you are running is different. You still get to pick which pricing you want to use in your final judgment, and you can override both, and use the intrinsic valuation.
4. If your pricing and intrinsic value are very different, you have to choose which one you want to use for your final recommendation. DO NOT average the two. Bankers may do it, but it is very bad practice. When choosing, recognize that there is no right choice. It depends on faith (do you have faith in your DCF) and philosophy (are you a trader or an investor?). I will not second guess your recommendation. 
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).   Final project nag. When you have the numbers for your company, please enter them in the Google shared spreadsheet:

Attachments: Post class test and solution

I know that you are working on the project, and that your numbers are taking form. And the market is not making your life any easier, since it seems to be melting down today, making some of your over valued stocks into undervalued ones. Nothing that you can do about it, since it is a moving target. As you get your final numbers, please go into the Google master sheet and enter your numbers:
In case you are having issues with mechanics or a conceptual stumbling block on the project, I will have office hours tomorrow (Friday from 11 am - 1 pm), and the zoom link is below:
It is the final weekend of the class, and I wanted to remind you again to enter the numbers for your company, when you have them, into the Google shared spreadsheet:
Your final project is due on Monday, by the end of the day. Please turn in your report as a pdf file (no excel spreadsheets needed) and enter The Fat Lady is singing in the subject of the email
5/8/22 I stayed off the airwaves this weekend, since any email that I sent you had the potential to create more harm than good. I am glad to see the spreadsheet filling up, and if you have done so already, thank you. If not, there is still time. Until next time!
Thank you for getting your numbers into the master spreadsheet. I have used your numbers to put together the presentation for today’s class:
I know that many of you have been using the zoom option to sit in on classes, and while I don’t mind, I would really like to see you in class, if you can make it. 
Thank you for coming to class today, after I subjected you to a brutal weekend on the project. If you were not able to make it, the slides for the session are here:
We started with using Dante’s Inferno to illustrate layers of valuation hell, with different valuation sins putting you deeper and deeper in that space. We then used your findings on the project to review the basics of intrinsic valuation, pricing and real options. If you want to see the entire list of valuations of everyone in the class, please try the link below:
Your final exam is less than 48 hours away. I have sent the review session links before, but just in case you have lost them, here you go:
You can also find past final exams and solutions at this link:
If you want to take the remote version of the exam, please sign up on the Google shared spreadsheet, by midday tomorrow:
One final point. I will have office hours tomorrow from 9.30 am - 11 am, New York time. The zoom link is below:
First things first, I have been remiss in not reminding you about finishing your evaluations for the class. Since today is the last day to do this, and I will be harassed if enough of you do not do it, please do your evaluations. If you are unsure of how to do this, here are the instructions:
Student Instructions for Completing Course Evaluations
To access your evaluation, sign into Albert and scroll down to the Enrolled Courses section. Click the Eval icon for the course you would like to evaluate.
The evaluation will open in a new tab. Please ensure your pop-up blocker is disabled, otherwise you will not be able to access your evaluation. Instructions on how to disable your pop-up blocker can be found here.

I know that you are in the midst of getting ready for the final exam, and I am sorry to interrupt. There are three questions seems to be coming up on the real options problems and I am afraid that 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) and the option value?
It is not impossible, but it is very difficult, to estimate N(d) without a computer and Excel. Since that choice is not available, I will give you a normal distribution table that you can use. (You will see this on past exams). You will have to find the closest d1 you can, and use the N(d1) that goes with it, but it should work. Also the option pricing problems will all have partial credit for getting the inputs to the model right. So, please do fill in the inputs, so that you will still get credit if you make a mechanical error  in computing option value.

Sorry about a second email, just minutes after your first one, but I forgot the seating for the final exam. The exam will be an hour and fifty minutes long, and you have two rooms (as with the quizzes):
If your last name begins with Go to
A - G KMEC 1-70
H - Z Paulson Auditorum
5/11/22 The exam is open book and open notes, and since many of you have your slides on devices and laptops, you are allowed to use them, but only for accessing the notes. In case the message has been lost, you cannot and should not be using Excel or any other programs on your laptop or device to do the solutions on the exam. That is true, whether you are in class or online. Please follow the honor code.

If you took your final exam in person, you can pick it up on the ninth floor of KMEC just in front of the entrance to the finance department. Look on the second shelf and you will see two piles, in alphabetical order. If you took it online, I have a few dozen left to go, but should be done by later today. The solutions are attached. 

Attachment: Valuation Final Exam with solution

I hope you are done, and are celebrating. However, just in case you still care about grades, yours just went online. If you are interested in finding out how you got the grade that you did, you can put in your scores into the attached spreadsheet, and work out your grade. (The numbers in the spreadsheet already are a hypothetical student’s numbers, not yours…_) I know that this semester was a challenge. None of us signed up for a masked class, and I am sure that you are all exhausted. And valuing a company in the middle of a full-blown market crisis is never easy. The good news is that if you can value a company in this environment, you can value it any setting. I appreciate your showing up for the online classes and  the work you put into the class, and the patience you showed as I drowned you in emails, valuations of the week, weekly challenges and other torture devices.  I know that some of you are graduating and I that  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. 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").  If you are not graduating, I will see you around school next spring. While I will not be teaching in the fall, I will be back teaching next spring, and you can watch another class endure the duress of unending emails, non-stop nagging and everything else that goes with this class. I could tell you that I hated doing it, but I would be lying. And just in case, you need a valuation fix... here are some links:
Twitter feed: @AswathDamodaran 
My kids tell me that TikTok is the social media platform of the day. Perhaps, I should be Tiktoking soon…. So, have a great summer and an even better rest of whatever life has in store for you!