I confess. I send out a lot of emails and I am sure that you don't read some of them. Since they sometimes contain important information as well as clues to my thinking (deranged though it might be), I will try to put all of the emails into this file. They are in chronological order, starting with the earliest one. They are in chronological order, starting with the earliest one. So, scroll down to your desired email and read on, or if the scrolling will take you too long, click on the link below to go the emails, by month.
Happy new year!. This is the first of many, many emails that you will get for me. You can view that either as a promise or a threat. I am delighted that you have decided to take the corporate finance class this spring with me and especially so if you are not a finance major and have never worked in finance. I am an evangelist when it comes to the centrality of corporate finance and I will try very hard to convert you to my faith. I also know that some of you may be worried about the class and the tool set that you will bring to it. I cannot alleviate all your fears now, but here are a few things that you can do to get an early jump:
1. Pre-work for class
2. Class Details/Logistics
As things stand now, and this could quickly change, we will meet in Paulson Auditorium, a cavernous amphitheater with all of the charm of Madison Square Garden on a bad day (which would be any day that the Knicks actually play there) every Monday and Wednesday, starting on January 31, going through May 9, from 10.30 am to 11.50 am. I will not take attendance, but I would really, really, really like to see you in class. I do know that some of you are appehensive about showing up in person, and I understand. The sessions will be live zoomed and recorded and will be available in three places:
1. My website at: http://www.stern.nyu.edu/~adamodar/New_Home_Page/webcastcfspr22.htm
2. On YouTube as a playlist: https://www.youtube.com/playlist?list=PLUkh9m2BorqkKMOj0LkU8JCeDlk4k8P-A
3. On Brightspace (NYU’s new learning platform): Link to come
You can find out all you need to know about the class (for the moment) by going to the web page for the class:
This page has everything connected to the class, including webcast links, lecture notes and project links. The syllabus has been updated:
If you click on the calendar link, you will be taken to a Google calendar of everything related to this class.
3. Class Material
Now for the material for the class. The lecture notes for the class are available as a pdf file that you can download and print. I have both a standard version (one slide per page) and an environmentally friendly version (two slides per page) to download. You can also save paper entirely and download the file to your iPad or Kindle. The first packed can be found at the link below
There is a book for the class, Applied Corporate Finance, but please make sure that you get the fourth edition. It is exorbitantly over priced but you can buy, rent or download it at Amazon.com or the NYU bookstore
While I have no qualms about wasting your money, I know that some of you are budget constrained (a nice way of saying "poor") . If you really, really cannot afford the book, you should be able to live without it.
4. Final Thoughts
I know that the last few years have led you to question the reach of finance (and your own career paths) and COVID’s disparate effects on individuals and businesses has probably made you doubt yourself even more. I must confess that I have gone through my own share of soul searching, trying to make sense of what is going on. I will try to incorporate what I think the lessons learned, unlearned and relearned over this period are for corporate finance. There are assumptions that we have made for decades that need to be challenged and foundations that have to be reinforced. In other words, the time for cookbook and me-too finance (which is what too many firms, investment banks and consultants have indulged in) is over. To close, I will leave you with a YouTube video that introduces you (in about 2 minutes) to the class.
I hope you enjoy it. That is about it. I am looking forward to this class. It has always been my favorite class to teach (though I love teaching valuation) and I have a singular objective. I would like to make it the best class you have ever taken, period. I know that this is going to be tough to pull off but I will really try. I hope to see you on January 31st, in class. Until next time!
I hope that you have had a good week since my last email, and if your response is what last email, you may want to check this link:
Next week, at the first class, I will spend time laying out what the class is about, what I hope that we will accomplish during the semester, as well as establish the key themes that underlie corporate finance. You can download the syllabus ahead of time:
As you read the syllabus, you will notice mention of a project and in case you are curious, here is the link to the project resources:
Once we are through the syllabus in the first session, we will turn our attention to the lecture note packets, and every slide you see in class after this will be in that packet. The lecture notes are in two parts, and the first part can be obtained at this link (which I sent you last week as well):
It is also available in powerpoint form (though the file size is bloated), if you go to the lecture note page or webcast page of the class..
Now that I have drowned you in stuff, just a little aside. I don’t much care for academic research and almost everything that I write is for practitioners, and my blog (sounds new age, doesn’t it?) has become the first repository for my writing. I spend the first few weeks of each year, talking about the data that I update on my website:
The first two updates are on my blog. Please browse through them, because they are relevant for class:
I will see you in class next week (Monday. January 31, at 10.30 m, NY time on in Paulson Auditorium. I know that with COVID a real and present danger, some of you may not be able to make it to class. It will be carried as a live zoom session, and the zoom link for all of the sessions is below:
As we head into the last weekend before class, I am sending this as a last pre-class email. When I start class on Monday, it will be my 38th year teaching and I am thankful that I still look forward to the day. There is no other profession where you can start with a clean slate every few months, even though you may screw it up in the subsequent days and weeks. We will meet in Paulson from 10.30 am - 11.50 am for our first class, and it will be glorious (I have got to hype it up as much as I can). I do realize that some of you will not be able to make it in class for a variety of reasons, and worry not, since the class will be carried live on Zoom. The zoom link for the class is below:
This link will hold for all 26 sessions, and I would recommend that you paste the following into your calendar, even if you plan to be in class, in person:
Please download and import the following iCalendar (.ics) files to your calendar system.
During the first class, it would have been standard practice for me to hand out the syllabus and project description, but the pandemic is making that process tricky. So, please download them and bring either a digital or physical copy to class on Monday.
Project Description: https://pages.stern.nyu.edu/adamodar/pdfiles/cfovhds/cfproj.pdf
At the risk of repeating myself, the lecture note packets for the class are also ready and you can find the links at the top of the webpage for the class sessions:
I last emailed you a week ago, and for those of you are wondering how much can happen in a week, the evidence is in front of you. The market has gone through contortions, and if you are thinking about places to hide from risk, you may want to start by reading my third data post for 2022:
If you did not get a chance to look at the first two, they are on my blog as well. Until next time!
I promised you with a ton of emails and I always deliver on my promises... Here is the first of many, many missives that you will receive for me….. First, a quick review of what we did in today's class. I laid out the structure for the class and an agenda of what I hope to accomplish during the next 15 weeks. In addition to describing the logistical details, I presented my view that corporate finance is the ultimate big picture class because everything falls under its purview. The “big picture” of corporate finance covers the three basic decisions that every business has to make: how to allocate scarce funds across competing uses (the investment decision), how to raise funds to finance these investments (the financing decision) and how much cash to take out of the business (the dividend decision). The singular objective in corporate finance is to maximize the value of the business to its owners. This big picture was then used to emphasize five themes: that corporate finance is common sense, that it is focused, that the focus shifts over the life cycle and that you cannot break first principles with immunity.
On to housekeeping details.
That is about it, for this email. Until next time!
In the first puzzle for this semester, I am going to focus on the objective in corporate finance, In class, I said that the end game is to maximize the value of the business and that objective has given corporate finance its focus, but has also given rise to criticism that it comes at the expense of other claimholders. That is a legitimate point, and even the Business Roundtable seemed to come around to a stakeholder point of view in this missive:
In a post shortly thereafter, I took issue with the Business Roundtable, and argued that it was the wrong message and that the messenger, Jamie Dimon, was singularly ill equipped to talk about shareholder interests, given how cavalierly he has ignored them over his tenure.
I know that many of you will disagree with me on my conclusions, but I think that this will be a great start for tomorrow’s class. So, please read both and try to answer these questions:
No pressure and completely optional, but I think it is worth your time.
In today's class, we started on what the objective in running a business should be. While corporate finance states it to be maximizing firm value, it is often practiced as maximizing stock price. To make the world safe for stock price maximization, we do have to make key assumptions: that managers act in the best interests of stockholders, that lenders are fully protected, that information flows to rational investors and that there are no social costs. We started on why one of these assumptions, that stockholders have power over managers, fails and we will continue ripping the Utopian world apart next class.
1. Other People's Money: Just a few added notes relating to the class that I want to bring to your attention. The first is the movie Other People's Money, which is one of my favorites for illustrating the straw men that people like to set up and knock down. You can find out more about the movie here:
But I found the best part on YouTube. It is Danny DeVito's "Larry the Liquidator" speech:
Watch it when you get a chance. Not only is it entertaining but it is a learning experience (though I am not sure what you learn). Incidentally, it is much, much better than Michael Douglas's "Greed is good" speech in the first "Wall Street " which was a blatant rip-off of Ivan Boesky's graduation address to the UC Berkeley MBAs in 1986 (which I happened to be at, since I was teaching there that year).
2. DisneyWar: In next week’s session, I will be talking about the dysfunctional state of Disney in the 1990s. If you want to review these on your own, try this book written by James Stewart. It is in paperback, on Amazon:
If you are budget-constrained, you can borrow my copy and return in when you are done. (I have only one copy. First come, first served). If you want a more contemporary version of how Disney’s corporate governance is playing out, and want an insider’s perspective, Bob Iger’s autobiography is a solid bet:
3. Company Choice: On the question of picking companies for your group, some (unsolicited) advice:
As a final reminder. Please pick your company soon... As you can see from today's class, we are getting started on assessing your company…
4. If you want to print off the financial statements for your company, I would recommend that you start with the annual report for the most recent year. You should be able to pull it off the website for the company, under investor relations. If you want to keep going, and it is a US company, go to o the SEC site (http://www.sec.gov). If it is a non-US company, you will have to find the equivalent regulatory body in your country. For some of your companies, you will find less data than on others. Don’t fret. It is what it is. Finally, I am attaching the post class test and solution for today’s session.
It is never too early to start nagging you about the project. So, let me get started with a checklist (which is short for this week but will get longer each week. Here is the list of things that would be nice to get behind you:
In doing all of this, you will need data and Stern subscribes to one of the two industry standards: S&P Capital IQ (the other is Factset). It is truly a remarkable dataset with hundreds of items on tens of thousands of public companies listed globally, including corporate governance measures. To get access to Capital IQ, you need to ask for it, and the attached document leads you through the process. As with all things IT related, I am sure that there are glitches and if you find them, let me know.
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
Lianda and Dylan surveyed you to find the best times for office hours and review sessions. They will be having a review session from 10 am - 11 am, on Fridays, and office hours, right after. They will be setting up zoom sessions on Brightspace soon. Until next time!
As promised, here is the first of the weekly in-practice webcasts. These are 10-15 minute webcasts designed to work on practical issues in corporate finance. This week’s issue is a timely one, if you are working on picking companies for your project (as you should be..). It is about the process of collecting data for companies, the first step in understanding and analyzing them. The webcast link is below:
It is a little dated (but I have been too lazy to update it), but I don’t think it is too painful to watch, and you may even find it useful. I have also put the link up on the webcast page for the class:
The webcasts for the first two classes should be on there, if you missed (physically, metaphysically or mentally) and the links to the project and syllabus that I handed out in the class. You can stream or YouTube the sessions, or download videos/audios. Also, if you joined the class late, you can get all emails sent up till today here:
Finally, have you had a chance to look at the weekly puzzle? If not, give it a shot by going here:
At the risk of nagging, please do get the lecture note packet 1 downloaded before Monday’s class. It is now available (or was at least yesterday) in the bookstore.
Before I start on the newsletter part, a quick note about the TAs for this class, Lianda Luo (firstname.lastname@example.org) and Dylan Murphy(email@example.com). The times and zoom links are available on Brightspace. They will be holding office hours every week, and having a zoom session to go through applications of the material from the week, using past quizzes. As you start the weekend, I decided to butt in with the first of my newsletters. As you browse through it (and I hope you do), you will realize that this is not really news or even fake news. It is more akin to a GPS for the class telling you where we’ve been and where we plan to go. It is a good way to get a sense of whether you are falling behind on either the class or the project, especially as we get deeper into the class. So, enjoy your weekend and I will see you on Monday!
Attachments: Issue 1 (February 5)
|2/6/22|| This week, we will complete our discussion of the objective function in corporate finance, continuing with stock price maximization tomorrow and alternatives to that objective thereafter. Along the way, we will look at shareholder wealth maximization and corporate sustainability and I may kill a few sacred cows along the way. I would strongly recommend that if you have not tried the weekly puzzle for this week, you should. It is not only relevant to the classes to come but is at the foundation of the big debates we are having in business, politics and society. If you have no idea what I am talking about, here is the link to the weekly puzzle:
If you are wondering why I am not posting a solution, take a look at the puzzle again, and the answer should be fairly obvious. In the meantime, please do pick a company, and if you have picked a company, take a look at the board of directors and corporate governance.
In today’s session, we spent almost of all time on the assessment of where the power lies in a company. In the utopian world, the power lies entirely with shareholders, but in the real world, that is not often the case. It can lie with managers, if shareholdings are diffuse and shareholders are passive. It can lie with a subset of inside shareholders, who have large holdings and/or are part of incumbent management. In some cases, that power can come from having voting and non-voting shares. It can lie with governments, lenders or employees. The first step in understanding why a company does what it does is to assess the power structure, and I suggested that you look at the largest shareholders in the company. One source for this is Bloomberg, where once you find your company’s listing (and that can be a search), typing in HDS can bring you the list of top 17 shareholders, but you can get the same information from public sources like Yahoo! Finance. In particular, look at the institutional investors on that list, and check to see if any may be activist. If you can get on Bloomberg Anywhere or a Bloomberg terminal, try this:
1. Press the EQUITY button
2. Choose FIND YOUR SECURITY
3. Type the name of your company
4. You might get multiple listings for your company, especially if it is a large company with multiple listings and securities. Try to find your local listing. For a US company, this will usually be the one with your stock symbol followed by US. For a non-US company, it will have the exchange symbol for your country (GR: Germany, FP: France, LN: UK etc...) It may take some trial and error to find the listing....
5. Type in HDS
6. Print off the first page of the HDS (it should have the top 17 investors in your company).
I told that I would sent you a list of activist investors to check for and you can try this list:
Finally, I did mention Petrobras, as an example of how who you answer to as management can driven decision making in the company. Here is the post that I mentioned:
In this week’s puzzle, I want to take a look at activist investing, warts and all. To get a perspective on activist investing, start with this old (but still relevant) post on activist investing:
Then, follow up with this more recent post on Softbank’s problem, after the WeWork disaster
Top it all off with this news story about Elliott Management, a leading activist investor, targeting Softbank:
Finally, consider these questions:
1. Why did Softbank get targeted by Elliott Management now?
2. What do you think of Elliott’s proposals for Softbank?
3. Assuming Softbank decides to fight Elliott Management, what would you advise Softbank to do?
4. More generally, what are the pluses and minuses of having activist investors in a market?
Just to be clear, you don’t have to show me your answers. These puzzles are more about you getting comfortable with your assessment of different aspects of corporate finance. If you do want to comment on the forum that I have created on activist investing in the Brightspace version of this class, please do so. Until next time!
The objective function matters, and there are no perfect objectives. That is the message of the last two classes. Once you have absorbed that, I am willing to accept the fact that you still don't quite buy into the "maximize value" objective. That is fine and I would like you to keep thinking about a better alternative with three caveats. First, you cannot cop out and give me multiple objectives - I too would like to maximize stockholder wealth, maximize customer satisfaction, maximize social welfare and employee benefits at the same time but it is just not doable. Second, your objective function has to be measurable. In other words, if you define your objective as maximizing the social good, how would you measure social good? Third, take your objective (and the measurement device you have developed) and ask yourself a cynical question: How might managers game this system for maximum benefit, while hurting you as an owner? In the long term, you may almost guarantee that this will happen.
Building on the theme of social good and stockholder wealth a little more, there are a number of fascinating moral and ethical issues that arise when you are the manager in a publicly traded firm. Is your first duty to society (to which we all belong) or to the stockholders (who are your ultimate employers)? If you have to pick between the two and you choose the former, do you have an obligation to be honest and let the latter know? What if you believed that the market was overvaluing your stock? Should you sit back and let it happen, since it is good for your stockholders, or should you try to talk the stock price down? On the question of socially responsibility, there are groups out there that rank companies based upon social responsibility. I have listed a few below, but they are a few of many:
JUST Capital: https://justcapital.com/rankings/
Calvert Social Index: https://www.calvert.com
Dow Jones Sustainability Index: https://www.spglobal.com/spdji/en/indices/esg/sp-500-sustainability-screened-index/#overview
And this is just the tip of the iceberg. Environmental organizations, labor unions and other groups all have their own corporate rankings. In other words, whatever your key social issue is, there is a way to stay true (as a consumer and investor). Notice how the rankings vary even across the ethics sphere. No surprise that no one has a monopoly on virtue. In the last few years, though, you have the ESG movement push for composite scores for companies, and that has created an eco system that I am cynical about, in terms of what will be ultimately accomplished. If you are interested in my perspective on ESG, please try these two posts that I have on the topic:
While it may seem like we are paying far too much attention to these minor issues, I think that understanding who has the power to make decisions in a company will have significant consequences for how the company approaches every aspect of corporate finance - which projects it takes, how it funds them and how much it pays in dividends. So, give it your best shot.. On a different note, we will be continue with our discussion of risk on Wednesday (no class on Monday). As part of that discussion, we will confront the question of who the marginal investor in your company is. If you have already printed off the list of the top stockholders in your company (HDS page in Bloomberg or the Major Holders page from Yahoo! Finance), bring it with you again. If you have not, please do so before the next class. Also, watch for the in-practice webcast day after tomorrow, because I will go through how to break down the HDS page. I am also attaching the post-class test & solution for this session. Until next time!
As for the project & class, time sure does fly, when you are having fun... We are exactly 15.38% (4 sessions out of 26) through the class (in terms of class time) and we will kick into high gear in the next two weeks. I am going to assume for the moment that my nagging has worked and that you have picked a company to analyze. Here is what you can be doing (or better still, have done already):
I will be putting up a webcast tomorrow on how to analyze the "top shareholder" list, using a range of companies. Hope you to get a chance to watch it. I also hope that you have had a chance to register for Capital IQ and if you have not, I am reattaching the directions on how to do so. Until next time!
Ahead of Super Bowl weekend (and this time I have the dates rights), I thought I would get in two in-practice webcasts this week and nag you about your project (yet again). Since these webcasts are directly connected to what you will or should be doing on the project, the best way to use them is to pick a company and use the webcasts to get the relevant parts of the project done.
1. Assessing Corporate Governance: This webcast looks at ways to assess the corporate governance at your company, using HP from 2013 as an example. I use HP's annual report, its filings with the SEC and other public information to make my assessment of the company.
HP Annual Report: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/corpgovHP/HPAnnual.pdf
You can find these links in all three forums (my webcast page, iTunes U) and it looks at what information to use and how to use it to assess the corporate governance structure of a company. (Sorry about the striped sweater… Should have known better).
2. Stockholder Holding Assessment: This webcast is on assessing who the top stockholders in your company are and thinking through the potential conflicts of interest you will face as a result. The webcast went a little longer than I wanted it to (it is about 24 minutes) but if you do have the list of the top stockholders in your company (the HDS page from Bloomberg, Capital IQ, Morningstar or some other source), I think you will find it useful.
Webcast link: http://youtu.be/x_H_4KTeOkc
Presentation link: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/holders.ppt
I hope that you get a chance to not only watch these webcasts but also try them out on your company. Until next time!
1. First things, first. Your newsletter is attached for the week.
Attachment: Issue 2 (February 12)
2. Company choice & groups: I was checking the corporate finance master sheet:
3. FANGAM Stocks; I am sure that some of you are thinking about or have already decided to analyze one of the FANGAM (Facebook, Amazon, Netflix, Google, Apple and Microsoft) companies. I just put up a post on my views on the company:
Please feel free to disagree with them.. Thank you!
I hope that you watching the Super Bowl, not prepping for corporate finance. Tomorrow, we will complete our discussion of corporate governance and start with a discussion of risk and how it plays out in hurdle rates. In the process, we will talk about the model that started the ball rolling, the capital asset pricing model (CAPM, how it is mystified by some and vilified for others, often in advancement of their agendas, and about alternatives to i5. We will move through this discussion in hyper speed for two reasons. One is that I have zero interest in reinventing modern portfolio theory and showing the mechanics of correlation and covariance. The second is that while I use the CAPM as a tool to estimate hurdle rates, I am not wedded to it and accept all kinds of alternatives (some of which we will talk about in class). If you are still shaky about even the assumptions that underlie the model, my suggestion is that you read chapter 3 from the applied corporate finance book before the class. If you don’t have the book, or not in the mood to read an entire chapter, please read my data post on hurdle rates from a couple of weeks ago:
That post will prepare you for what’s coming on Wednesday, we will start on the fun stuff of applying the model, starting with what should be a slam dunk (risk free rates) which is increasingly not and then turning to the equity risk premium, a number that analysts often turn towards services to look up but really has deep implications for both valuation and corporate finance. So, much to do and I hope that you come along for the ride. Until next time!
We started the class by wrapping up the question of at the end game in business, and why I (and you don’t have have to) still trust markets, over managers and expert panels. Markets have no ego, and if allowed to play out, will devise corrections to almost every over reach in business, whether it be managers taking advantage of shareholders, borrowers ripping off lenders, companies lying to markets or creating large social costs. My view is that companies should run to maximize value, even if the market does not recognize it right away, and that managers need to consider the messages in stock prices.
We then moved on to risk and some of you may be regretting the shift from the soft stuff , but trust me that it is still fun.. If it is not, keep telling yourself that it will become fun. Anyway, here are a few thoughts about today's class.
1. The Essence of Risk: There has been risk in investments as long as there have been investments. If you have the time, pick up a copy of Against the Gods by Peter Bernstein, John Wiley and Sons. It is a great book and an easy read. If you want more, you should also pick up a copy of Capital Ideas by Peter as well... That traces out the development of the CAPM....
2. More on Models: If you want to read more about the CAPM, you can begin with chapter 3 in the book. It provides an extended discussion of what we talked about in class today....
3. Diversifiable versus non-diversifiable risk: The best way to understand diversifiable and non-diversifiable risk is to take your company and consider all of the risks that it is exposed to and then categorize these risks into whether they are likely to affect just your company, your company and a few competitors, the entire sector or the overall market.
If you can, try to make your assessment of whether the marginal investors in your companies are likely to be diversified. Look at both the percent of stock held in your company and the top 17 investors to make this judgment. If your assessment leads you to conclude that the marginal investor is an institution or a diversified investor, you are home free in the sense that you can now feel comfortable using traditional risk and return models in finance. If, on the other hand, you decide that the marginal investor is not diversified, we will come back in a few sessions and talk about some adjustments you may want to make to your beta calculations. Until next time!
In yesterday’s class, we went through the intuitive derivation of the CAPM. I thought that this week’s puzzle should be built around the central themes of portfolio theory, which is that diversification is the best weapon against risk, since it eliminates firm specific risk. That view, though, gets push back from some big name investors, including some value investing legends and Mark Cuban (who is also a legend, at least in his own mind). You can start the puzzle by reading the arguments for and against diversification:
The evidence, from looking at investor behavior, is that most individual investors side with the latter than the former (though that does not mean that it is right):
I am going to surprise you with my view. While I am more inclined to diversify than not, I can also see scenarios where not diversifying makes sense. In fact, I have a blog post on the question of how much diversification is good for you (and the answer will vary across individuals):
This is a topic that is important not just for your finance class, but for your personal portfolios, as you accumulate wealth (I am assuming that this Stern MBA, which you are paying a hefty price for, will pay off). Until next time!
We started today’s class by tying up the last loose ends with risk and return models, talking about how assuming that there are no transactions costs and private information can lead us all to hold the market portfolio, and how risk can be then measured as risk added to that portfolio. We did damn the CAPM with faint praise, arguing that it does not do very well at explaining differences in returns across companies, but that it does at least as well as the alternatives. We then started on the mechanics of the model, taking about risk free rates: how to estimate the risk free rate in a currency where there is no default free entity issuing bonds in that currency and why risk free rates vary across currencies. The key lesson is that much as we would like to believe that riskfree rates are set by banks, they come from fundamentals - growth and inflation. I have a post on risk free rates that you might find of use:
In fact, risk free rates turned negative in a few currencies, upending what we know about risk free rates in. Here is my post on negative risk free rates.
In the final few minutes of the session, we turned to equity risk premiums and how they are related to risk aversion. More on that in the next class. By the way, we have no class next Monday and next week’s class will be an entirely zoom class. I will send you the zoom links, in case you have never used them yet for this class, but the links are on Brightspace as well. Until next time!
If my nagging is paying off, you should have picked a company by now and if you have, you can move on to look at the marginal investors in you company, with the objective of assessing whether they are diversified, since it will let you know whether you are on safe ground using the CAPM or any other risk and return model. This will require a degree of judgment, but remember that you are not trying to identify a particular investor (Blackrock, Vanguard etc.) but a type of investor (institutional, insider, individual etc.). In making this assessment, having access to a Bloomberg terminal can speed the process, and if you get a chance, look at the YouTube video that I sent to you about using Bloomberg. If you don’t have access to a terminal, never fear, since much of the data is public. You can get both the breakdown of investors into insider and institutional, as well as the top holders of your stock. Here for instance is the page for PlugPower, a US company listed on the NASDAQ (under Holders): https://finance.yahoo.com/quote/PLUG/holders?p=PLUG
The assessment of who the marginal investor in PlugPower is easy to make. It is a large institutional investor, and very diversified. You can see that 55% of PlugPower’s shares (and 61% of the float, i.e., shares that are being traded at not locked away) are held by institutions, and if you are wondering whether that is high or low, I have data on insider and institutional holdings, by sector, for US, Global, European, Emerging (with China and India as separate date sets), Japan and Australia/NZ/Canada. You can find them here:
Scroll down to insider/institutional holdings and download the excel spreadsheets. If you have fallen behind in this class, there is nothing to fear. You have a whole week to catch up, and if it looks overwhelming, you should start with the entry page for the class:
Everything that we have done so far (from the class sessions, to weekly puzzles to even past emails) should be here.
Until next time!
In the sessions we had this week, we covered some ground, moving well into our discussion of risk and return models and starting on the first of the three inputs into your cost of equity, the risk free rate. If you want to get ahead of the curve, you can watch the webcast for this week, which looks at how to estimate risk free rates in different currencies, and how sovereign default spreads can be useful in getting there:
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 right now), 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 four Bloomberg pages for your company as soon as you can:
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!
Last week, we put the objective function to rest and turned our attention to risk models. Next week, is a shortened week, since we will not have class on Monday and the Wednesday class will be a zoom class. We will start our discussion of risk free rates, and how best to estimate risk premiums and convert them into hurdle rates. If you have had a chance to pick a company for your project, this is a good week to catch up on the corporate governance part, and perhaps even get a risk free rate in the currency of your choice. This week’s newsletter is attached. On a different note, if any of you are in a group that needs an extra person, please let me know. There are a couple of students still looking for groups, and they are acquiring a forlorn look. Thank you, and until next time!
Attachments: Issue 3 (February 19)
This week, we will complete our discussion of risk and return models before moving on to riskfree rates, and answering the question of why riskfree rates vary across currencies. We will then look at estimating equity risk premiums & continue on our build up to hurdle rates. Since the material will get denser and the topics will build on each other, you may find it useful to read chapter 4 in the book ahead of class. In the meantime, if you have not picked a company, please do so, and if you don’t have a group still, please reach out. Again, remember that there is no class tomorrow... Until next time!
Since we have no class today, I will keep this short. If you have not picked a company, please do. If you have picked a company, start the corporate governance and marginal investor assessments. If you have completed those already, you can even start by making a list of risks that you can think of that your company faces. In doing all of this, you will need raw data and you can find them in
1. Annual reports: Best source is usually the company’s own website, in the investor relations section.
2. Filings: Every publicly traded company has to file its financials, and you can get those filings by going to the regulatory group’s website. For US companies, the filings are on the SEC website (sec.gov)
3. Capital IQ: I know that you have nagged you before, but I won’t be stopping on this one. This is about as complete and easy to use as data sites get. It is insanely expensive, if you try to get it for yourself, but it is your lucky day. You have free access, as a Stern student. Just follow the instructions.
4. Bloomberg: Use the Bloomberg Anywhere app to get on Bloomberg remotely, or find a Bloomberg terminal on campus
5. FRED: This is absolutely my favorite macro data source, and it is one of the best things the Fed has ever done: https://fred.stlouisfed.org
First things first. Tomorrow’s class will be a zoom class, and the zoom link is below. Please join this link at the regular class time:
See you there.
As we are lurch into another market crisis, it is a good time to think about our views on risk and how it plays out in how we react to the crisis. Both economics and finance are built on risk aversion, i.e., that investors need to be paid extra (over and above an expected value) to take risks. That notion of risk aversion has been challenged and modified over time, but it still is at the heart of how we measure risk and come up with expected returns. Economists agree that not only does risk aversion vary across individuals but it also varies, for the same individual, across time. In this puzzle, which has no right answer, I would like you to wrestle with the question of how risk averse you, explanations that you can offer for that risk aversion and the consequences for your business and investment decision making. You can find the full details of the puzzle here:
One of the side products of the growth of robo advisors is a proliferation of tools that investors can use to assess how risk averse they are. This article in the New York Times nicely sets the table. In the article, though the links to free risk assessment services are no longer free. There are, however, plenty of risk aversion tests online. Here’re a couple that you can try at no cost (though the second one is longer):
University of Georgia: https://pfp.missouri.edu/research/investment-risk-tolerance-assessment/
Take the tests, both to get a measure of how risk aversion gets measured and how risk averse you are as an individual. Then, try to answer the following questions:
Until next time!
oday's class was spent talking mostly about equity risk premiums. The key theme to take away is that equity risk premiums don't come from models or history but from our guts. When we (as investors) feel scared or hopeful about everything that is going on around us, the equity risk premium is the receptacle for those fears and hopes. Thus, a good measure of equity risk premium should be dynamic and forward looking. We looked at three different ways of estimating the equity risk premium.
1. Survey Premiums: I had mentioned survey premiums in class and two in particular - one by Merrill of institutional investors and one of CFOs. You can find the Merrill survey on its research link (but you may be asked for a password). You can get the other surveys at the links below:
2. Historical Premiums: We also talked about historical risk premiums. To see the raw data on historical premiums on my site (and save yourself the price you would pay for Ibbotson's data...) go to updated data on my website:
On the same page, you can pull up my estimates of country risk premiums for about 150 countries from January 2020
The approach that I use for computing country risk premiums at the start of 2020 is described more fully in this post:
3. Implied equity premium: Finally, we computed an implied equity risk premium for the S&P 500, using the level of the index. If you want to try your hand at it, here is my February 2022 update:
Play with the spreadsheet. In fact, try it with today’s index level and T.Bond rate and see what the ERP is right now.
4. Company revenue exposure: As a final step, see if you can find the geographic revenue distribution for your company. You can then use my latest ERP update to get the ERP for your company.
Beta reminder: Pease do try to find a Bloomberg terminal or get on Bloomberg Anywhere. Click on Equities, find your stock (pinpoint the local listing; there can be dozens of listings....) and once you are on your stock's page of choices, type in BETA. A beta page should magically appear, with a two-year regression beta for your company. Print if off. If no one is waiting for the terminal, try these variations:
1. Time period: Change the default to make it about 5 years and the interval from weekly (W) to monthly (M). Print that page off
2. Index: The default index that Bloomberg uses is the local index (a topic for discussion next session). You can change the index. Type in NFT (Bloomberg's symbol for the MSCI Global Equity index) in the index box and rerun the regression.
Bring the beta page (s) with you to the next class. Let's get the project done in real time, in class.
As part of the weekly project nag, I am going to start by assuming that you have picked a company to analyze and that if you have not entered its name in the Google shared spreadsheet, it is an oversight that you will fix soon.
Here are some things to consider doing to catch up:
It is Friday and time for the in-Practice Webcasts. I have two for this week. The first is on estimating implied equity risk premiums:
The supporting materials are below:
Implied ERP spreadsheet (from February 2013): http://www.stern.nyu.edu/~adamodar/pc/implprem/ERPFeb13.xls
S&P on buybacks (from earlier this year): http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/ERP/SP500buyback.pdf
S&P 500 Earnings: http://www.stern.nyu.edu/~adamodar/pdfiles/eqnotes/webcasts/ERP/SP500eps.xls
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. More importantly, I talk about where to get the inputs for future earnings on the index and the data has become richer since. If you download the latest version of my ERP spreadsheet, and look under the growth worksheet, you can see where the raw data comes from.
The second webcast is on company equity risk premiums, using operating exposure:
Webcast on company ERP calculation: https://youtu.be/D3IGn6tH03c?list=PLUkh9m2BorqkNIdjpZY2kI0qzRbEv5F5L
Slides for webcast: https://pages.stern.nyu.edu/adamodar/pdfiles/blog/ERPforCompany.pdf
Worksheet for webcast: http://www.stern.nyu.edu/~adamodar/pc/datasets/ERP&GDP.xlx
This spreadsheet is an old one. You can get the updated values for GDP and ERP by going to my website:
Updated ERP spreadsheet: http://www.stern.nyu.edu/~adamodar/pc/datasets/ctryprem.xlsx
First, it is the weekend and the newsletter is attached. Second, and perhaps more important, your quiz is a week from Monday (on March 7) and for those of you who have time on your hands this weekend, you may want to start the work on the quiz. We have not quite completed the material in class yet, but here is a preview:
Attached: Issue 4 (February 26)
|2/27/22||I hope that you have had a productive (and fun) weekend. Three quick notes. First, this week, we will first look at where betas really come from (not from a regression) and devise a way of estimating betas for companies that will free us from the tyranny of regression betas. Second, as the quiz is a week from tomorrow, I will check in on you, to make sure that you have access to everything you need to get prepared for the quiz (both in terms of material and logistics). Third, the solution link that I sent you for the past quizzes had a typo in it. Here is the corrected link:|
First, I am truly sorry for those of you who were planning to take this class on Zoom. There was an IT problem that prevented access to my zoom page (the phone option was disabled). It was fixed about 30 minutes too late for me (about a third of the way through the class). However, I do have a consolation prize. The class was still recorded and you can find it at this link. (I will convert this file to a YouTube file by tonight and put up the downloadable versions then… )
In this class, we first covered the estimation choices: how far back in time to go (depends on how much your company has changed), what return interval to use (weekly or monthly are better than daily), what to include in returns (dividends and price appreciation) and the market index to use (broader and wider is better). We also looked at the three key pieces of output from the regression:
1. The intercept: This is a measure of how good or bad an investment your stock was during the period of your regression. To compute the measure correctly, you net out Rf(1-Beta) from the Intercept:
Jensen's alpha = Intercept - Riskfree rate (1- Beta)
If this number is a positive (negative) number, your stock did better (worse) than expected, after adjusting for risk and market performance.
2. The slope: is the beta, albeit with standard error
3. The R squared: measures the proportion of the risk in your stock that is market risk, with the balance being firm specific/diversifiable risk.
Finally, we used the beta to come up with an expected return for stock investors/cost of equity for the company.
If you can get your hands on the beta page for your company, you should be able to make these assessments for your company. You can also get a guide to reading the Bloomberg pages for your company by clicking below:
Please try to strike while the iron is hot and get this section done for your company.
This week’s challenge is on betas and I have used GameStop as my lab experiment. First, check out the description of the puzzle (with the beta pages for both companies):
Once you have browsed through it, here are the questions that I would like you to consider
Just a reminder again that the first quiz is on March 8 (next Monday). The TAs, Lianda and Dylan,, are both incredibly knowledgeable and helpful and I will add office hours this weekend for questions that you may have. Until next time!
In today’s class, we looked past regression betas at how the choices companies make about the businesses they enter can determine their betas.. Summarizing the class, here is what we listed as the three determinants of betas:
I know that today's class was a grind with numbers building on top of numbers. In specific, we looked at how to estimate the beta for not only a company but its individual businesses by building up to a beta, rather than trusting a single regression. With Disney, we estimated a beta for each of the five businesses it was in, a collective beta for Disney's operating businesses and a beta for Disney as a company (including its cash). If you got lost at some stage in the class, here are some of the ways you can get unlost:
1. Review the slides that we covered today.
2. Try the post-class test and solution. I think it will really help bring together some of the mechanical issues involved in estimating betas.
3. Read this short Q&A on bottom up betas which highlights the estimation process and some of its pitfalls:
Since the class built on Monday’s online session, please watch it when you get a chance. In fact, the post class test and solution I am attaching relate to that class.
Catching up with past promises, if you remember, we looked at the beta for Disney after its acquisition of Cap Cities in the class. The first step was assessing the beta for Disney after the merger. That value is obtained by taking a weighted average of the unlevered betas of the two firms using firm values (not equity) as the weights. The resulting number was 1.026. The second step is looking at how the acquisition is funded. We looked at an all equity and a $10 billion debt issue in class and I left you with the question of what would happen if the acquisition were entirely funded with debt. (If you have not tried it yet, you should perhaps hold off on reading the rest of this email right now)
Debt after the merger = 615+3186 + 18500 = $22,301 million ( Disney has to borrow $18.5 billion to buy Cap Cities Equity and it assumes the debt that Cap Cities used to have before the acquisition)
Equity after the merger = $31,100 (Disney's equity does not change)
D/E Ratio = 22,301/31,100= 0.7171
Levered beta = 1.026 (1+ (1-.36) (0.7171)) = 1.497
Note that I used a marginal tax rate of 36% for both companies, which was the case in 1996.
|3/3/22||Today is usually the project update day. If you really have the time for it, this is a good week to get a bottom up beta for your company and estimates costs of equity for each business line it operates in. I You can get betas by business going to my website:
If you scroll down, you will set betas (levered and unlettered), by business and while the html file includes only US companies, you can download the averages for the rest of the world in the next column. (Do not use the total beta dataset. It is for a different purpose, that we will talk about next week) If you prefer to compute your bottom up betas yourself, you can use other databases, but the one that is easiest and most comprehensive is the S&P Capital IQ database. Early this semester, I had sent you instructions on how to get access that database, and if you have not, try to do so now. (See attached instructions.. I know… I know.. I’ve sent it four times already, but just in case...). It provides you incredibly powerful screening tools with 45000+ publicly traded companies, and very simple ways of picking the data you need and downloading that data into a spreadsheet.
The quiz is on Monday, and please take advantage of the TAs for the class, Lianda Luo and Dylan Murphy. I have a faculty meeting tomorrow, but will have office hours on Sunday from 10 am - 11 am. The zoom link is below:
If you want to take time away from preparing for the quiz, in this week’s webcast, I take a look at Disney's 2-year weekly regression (from February 2011- February 2013). I have the Bloomberg page attached. I am also attaching the spreadsheet that I used to analyze this regression, which you are welcome to use on your company. The webcast is available at the link below:
Disney’s Regression Bloomberg beta page: https://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/Regression/Disneyregression.pdf
The best way to make this stick is to try this on your company quickly. I also 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:
United Technologies 10K: https://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/Bottomupbeta/UT10K.pdf
Spreadsheet to help compute bottom up beta: https://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 2020 here:
I will let you get back to the grind now, but just in case, you have not even started on the quiz preparation and don’t have the energy to check old emails, here are the key links:
Review session webcast: https://www.youtube.com/watch?v=jH8L7cW6Yns&feature=youtu.be
All past quiz 1s: https://www.stern.nyu.edu/~adamodar/pdfiles/cfexams/prqz1.pdf
All past quiz 1 solutions: https://www.stern.nyu.edu/~adamodar/pdfiles/cfexams/prqz1sol.xlsx
First, it is the weekend and the newsletter is attached. Second, and perhaps more important, your quiz is a week from Monday (on March 9) and for those of you who have time on your hands this weekend, you may want to start the work on the quiz. We have not quite completed the material in class yet, but here is a preview:
Until next time!
Attachment: Issue 5 (March 5)
As I get emails about the quiz, I thought it would be a good idea to pull together a list of the top emailed questions that I have received so far.
1. Why do we use past T.Bill rates for Jensen's alpha and the current treasury bond rate for the expected return/cost of equity calculation?
The Jensen's alpha is the excess return you made on a weekly/monthly basis over a past time period (2 years or 5 years, depending on the regression). Since you are looking backwards and computing short-term (monthly or weekly) returns, you need to use a past, short-term rate; hence, the use of past T.Bill rates. The cost of equity is your expected return on an annual basis for the long term future. Hence, we use today's treasury bond or long term government bond rate as the riskfree rate.
2. How do you decide whether to use a historical or an implied equity risk premium?
In a market like the US, with a long and uninterrupted history, the choice depends on whether you believe that things will revert back to the way they were (in which case you may decide to go with the historical premium) or that the world is a dynamic, ever-shifting place, in which case you should go with the implied premium. In most other markets, where you don't have a long history, it is not really a choice, since the historical premium is too noisy (big standard error) to even be in contention. Thus, I use a short cut. If it is a AAA rated country like Germany or Australia or Singapore, I use the US equity risk premium, arguing that mature markets need to share a common premium. If it is not a AAA rated country, see the answer to (4).
3. How do you estimate a riskfree rate for a currency in an emerging market?
If you are doing your analysis in US dollars or Euros, you would use the riskfree rates in those currencies: the US treasury bond rate for US dollars and the German Euro bond for the Euro. In the local currency, you should start with the government bond rate in the local currency and take out of that number any default spread that the market may be charging (see the Mexico example in the review packet). The default spread can be obtained in one of three ways: (a) The difference between the rate on a dollar (Euro) denominated bond issued by the country and the US treasury bond rate (German Euro bond rate), (b) CDS spread for the country or (c) typical default spread given the local currency rating for the country.
4. How do you adjust for the additional country risk in companies that have operations in emerging markets?
If the country you are analyzing is not AAA, you should adjust for the risk by adding an "extra" premium to your cost of equity. The simplest way to do this is to add the default spread for the country bond to the US risk premium. This will increase your equity risk premium and when multiplied by your beta will increase the cost of equity. A slightly more sophisticated approach is to adjust the default spread for the relative risk of equities versus bonds (look at the Mexico example in the review) and adding this amount to the US premium. This will give you a higher cost of equity. If you are given enough information to do the latter, do it (rather than use just the default spread). When assessing the equity risk premium for a company, look past where the company is incorporated at where it does business. The equity risk premium that you use should be a weighted average of the equity risk premiums of the countries in which the company operates.
5. Why do you use revenues (rather than EBIT or EBITDA) as the basis for your weighting?
Note that what you would really like to know is the value of a company's different businesses/geographies, but since you don't have value, you look for proxies. While you may have a choice of different measures (revenues, EBITDA, EBIT etc), I prefer revenues for three reasons. First, it is always a positive number, which is good since I want weights that are greater than zero. Second, it is less susceptible to accounting allocation judgments than numbers lower down on the accounting statement. Third, I can convert it into a value by using an EV/Sales multiple, which I can get from the sector.
6. Why do you use the average debt to equity ratio in the past to unlever a regression beta?
The regression beta is based upon returns over the regression time period. Hence, the debt to equity ratio that is built into the regression beta is the average debt to equity ratio over the period.
7. What is the link between Debt to capital and debt to equity ratios?
If you have one, you can always get the other. For instance, the Fall 2006 quiz gives you the average debt to capital ratio over the last 5 years of 20%. The easiest way to convert this into a debt to equity is to set capital to 100. That would give you debt of 20 and equity of 80, based upon the debt to capital ratio of 20%. Divide 20 by 80 and you will get the debt to equity ratio of 25%.
8. How do you annualize non-annual numbers?
The most accurate thing to do is to compound. Thus, if 1% is your monthly rate, the annual rate is (1.01)^12-1.... if 15% is your annual rate, the monthly rate is (1.15)^(1/12) -1... When the number is low, as is usually teh case with riskfree rates, you can use the approximation of dividing by 12 (to get monthly) or 52 (to get weekly). But try to always compound the Jensen's alpha numbers, since they can be much bigger.
9. What is the cash effect on beta? Why does it sometimes get taken out and sometimes get put back in?
I know that dealing with cash is on of the more confusing aspects of beta and cost of equity. Let's start with some basics. If a company has cash on its balance sheet, that cash is an asset with a zero beta (or at least a very low one) and it will affect the beta for the company and the beta that you observe for its equity (say, from a regression). What you do with cash will therefore depend upon what beta you are starting with and what beta you want to end up with.
For the pure play or unlevered beta by business: You start with the average (or median) regression beta across the comparable companies in the business. To get to a pure play beta for the business, here are the steps:
Step 1: Unlever the regression beta, using the gross debt to equity ratio for the sector
Unlevered beta for median company in sector = Regression beta/ (1+ (1- tax rate) (Debt/Equity Ratio for the sector))
Step 2: Clean up for the cash held by the typical company in the sector, using the median cash/ firm value for the sector (see below for firm value)
Unlevered beta for the business = Unlevered beta for median company/ (1 - Cash/Firm value for the sector)
Note that you use sector averages all the way through this process, for regression betas, debt to equity ratios and cash/firm value
Alternatively, you can use the net debt to equity ratio and cut it down to one step
Net Debt to Equity = (Debt - Cash)/ Market value of equity
Unlevered beta for the business = Levered Beta for median company /(1+ (1-tax rate) (Net Debt to Equity))
To get to the bottom up equity beta for a company: You start with the unlevered betas with the businesses and work up to the equity beta in the following steps:
Step 1: Compute a weighted average of the operating business betas, using the values of the operating businesses in the company:
Unlevered beta for operating assets of the company = Pure play betas weighted by values of the operating businesses
Step 2: Compute a weighted average of all of the assets of the company, with the company's cash included (since cash has a beta of zero)
Unlevered beta for entire company = Unlevered beta for operating assets (Value of operating assets/(Cash + Value of operating assets))
Step 3: Compute a levered beta for just the operating assets of the company, using the debt to equity ratio of the company
Levered beta for operating assets of the company = Unlevered beta for operating assets (1+ (1- tax rate) Company's D/E ratio)
Step 4: Compute a levered beta for all of the assets of the company, with cash included
Levered beta for all assets of the company = Unlevered beta for entire company (1+ (1- tax rate) Company's D/E ratio)
It is the beta in step 4 that is directly comparable to your regression beta. Note that all the numbers in this part are the company's numbers - for values for the businesses, cash holdings and debt/equity.
10. Why do you weight unlevered betas by enterprise value (as you did in the Disney/Cap Cities acquisition) and in computing Disney's bottom up beta?
The unlevered beta is a beta fo the asset side of the balance sheet, right? So, when weighting these unlevered betas, you want to weight them by how much the businesses are worth (and not how much the equity is worth). That is why I used enterprise value weights in the Disney bottom up beta computation. I cheated on the Cap Cities acquisition by ignoring cash for both Disney and Cap Cities, but if cash had been provided, I would have used enterprise value. In case you are a little confused about the different values, here they are:
Sorry about the long email…
|3/6/22||I have taken enough of your time already this weekend and won’t push my luck. I will see you in class at 10.30 am tomorrow for the quiz. Just a reminder that it is open book, open notes and you can even use your tablets/iPads, but only to access your lecture notes. And you can use calculators, real or virtual (on your phone). Until next time!|
I know that it is tough to sit in on a class, after you have taken a quiz and I appreciate it that so many of you did come to class. We started class today by looking at the process of estimating betas for the remaining public companies in the mix, with financial service companies being treated a little differently, because debt is impossible to nail down, and levering and unlevering betas is tough to do. We also examined how to estimate the cost of equity of a private company, and why it may be higher than an otherwise equivalent public company. I have attached the post class test & solution. In the last part of the class, we started on the questions of what to include in debt, and how to estimate the cost of debt. More in the next class! As soon as I am done grading your quizzes, I will let you know, with directions on how to pick up your quiz. One final note. If you have checked your Google calendar, you will notice that there is a group case due on March 30 just before class (at 10.30 am). That cases available for download now, and I will send you another email clarifying what the case is all about.
Your quizzes are done and can be picked you. I am sorry for sending you the notification late in the evening, and I don’t expect you to do much about it right now.
Until next time!
Attachment: Quiz 1 and solution
I know that today is your puzzle day, but rather than give you a puzzle, I am posting the case with one of the exhibits as an excel spreadsheet:
It is a case built around an investment analysis and it is a group project. The project is due by March 30, 2022, before the start of class. I know that you have three weeks, but I would suggest reading it right away and doing it in bit size pieces. For instance, one of the things you will need to estimate is a discount rate for the project, and much of what we have done in class in the last few sessions should help.
In today’s class, we started by looking at estimating a cost of debt, specifying that it is the cost of borrowing money long term, today. Finally, w explained our preferences for market value weights on debt and equity in a cost of capital calculation, arguing that market value weights trump book value weights every single time. For the market value of debt, we argued for including both interest bearing debt converted to market value and the present value of lease commitments. To get a cost of debt, you need a bond rating (actual or synthetic) as well as default spreads that go with these ratings. The former should be available for your company, if it is rated. If not, use the following spreadsheet to rate your company:
It comes with a lease converter, if you want to use it. The default spreads used to be accessible online for free at bondsonline.com, but it seems to be defunct. You can get default spreads for key ratings classes (AAA, AA, A, BBB, BB, B and CCC & below) from the Federal Reserve website in St. Louis.
Look for the effective yield and then subtract out the risk free rate from it. While you may have to extrapolate from these numbers for intermediate ratings, it is eminently doable. Alternatively, you can get updated spreads for every ratings class from a Bloomberg terminal by typing in FIW, and resetting a couple of inputs. Assuming you can get access to a Bloomberg terminal, I put together a quick guide on how to get updated default spreads (for companies and countries):
We are heading into break week, and I hope that you have a fun and relaxing break. I will send you emails tomorrow and day after, but I will leave you alone for exactly a week.
File this away under “There is no rest for the wicked”, as I bring you back to the your project. Assuming that you have been working along with me, by now, you should have a risk free rate in the currency of your choice, an unlettered beta reflecting the business or businesses that your company is in and the equity risk premium that you have for your company. To get the unlevered beta to a levered beta, you need market values for equity and debt. With a publicly traded company, the former should be easy (market capitalization of all classes of shares) but the debt can be tricky. You should at least be able to get a book value of debt from the balance sheet (remember to count both short term and long term interest bearing debt), and if your company has leases and is following either GAAP or IFRS, the lease debt should also be there. If you don’t trust accountants, and want to do this right, you can covert book debt to market debt and capitalize leases for your company, but you will need a cost of debt for your company to be able to do this, and you can get that using either an actual rating or a synthetic rating for your company. I have a ratings spreadsheet that will do both (compute a synthetic rating for a company and capitalize leases. This is the link that I sent out yesterday:
Once you have all these numbers, you can compute a cost of capital. I know that you may be several steps behind, but if you do get to this number, please remember to go to the Google shared spreadsheet and enter your numbers for your company:
If you get to this point and want to compare your company’s cost of capital to others in the industry, at the start of 2022, you can find industry averages on my website, under current data.
I know that you are heading for a break this coming week, and sending you emails every week during the break would qualify as harassment. So, you won’t hear from me until next Friday. Have fun!
|3/18/22||I know that your break is not quite done, but as promised, I gave you a week off from email, but that week is over. If you are back already, we are through the cost of capital in class, and if you can compute a cost of capital for your company (or multiple costs, if it is many businesses), you will be all caught up. You are welcome to use my data and spreadsheets and the in-practice webcasts as crutches in doing this. I have added a webcast on estimating cost of debt and debt ratios, using the Home Depot as an example.
In the near term, I also want to remind you that the case is now live, and that it is due a week from next Wednesday (on March 30) before class. You can find the case at the link below:
Please do read it, even if you don’t plan to or have time to work on it right away. It is a group project. So, at some point you will need to get together (physically or virtually) to talk about it.
The newsletter for this week is attached, and as you can see, we are approaching the investment analysis section of corporate finance. There are two issues that I will nag you on:
1. Project: On your project, you have everything you need to compute the cost of capital for your company, and its divisions. Please do so, while you still remember, and at the risk of nagging you for the hundredth time, please input your numbers into the master Google sheet:
2. Case: I sent you the link for the case yesterday. There is one minor typo on the case. On point 5, the inflation rate is misstated as 2%. It should be 1.5% for all aspects of the case. Sorry!
Attachment: Issue 6(March 19)
In this week's classes, we will start on measuring investment returns, looking at four projects, including a hypothetical Rio Disney theme park. We will start with accounting earnings before making the transition from returns to cash flows to incremental cash flows. Since our discussion is particularly relevant for the case, it would help greatly if you read the case before tomorrow’s class.
You will find yourself getting questions answered, as we go through the session. By the way, I am sure that you are following the war in Ukraine, and I did put a post up on it yesterday:
I know that it seems callous to be looking at economic and market implications, when people are dying, but I have little that is original to add to the political and humanitarian discussions.
In this session, we started on measuring investment returns, drawing on the theme from Jerry Macguire (Show me the money). After making an argument for the primacy of cash flows, we looked at how a good measure of return is time weighted and incremental and how every investment is a project (small or large). We spent the bulk of the class describing the Rio Disney investment, and then computing the return on capital on that investment, based upon expected revenues and operating income. We also looked at what the hurdle rate for the investment should be, drawing on the notion that the discount rate for a project should reflect the risk of that project (business, geography etc.). We ended the class extending the return on capital concept to entire companies to judge the quality of existing investments.
|3/22/22||We talked about sunk costs in class this week, and how difficult it is to ignore them, when making decisions. You can start your exploration of the sunk cost fallacy with this well-done, non-technical discourse on it:
You can then follow up by reading a tortured Yankee fan's (my) blog post on the Yankee's A Rod problem and the broader lessons for organizations that have made bad decisions in the past and feel the need to stick with them.
Finally, I know that you are probably busy working on your case (spare me my illusions) but in case you have some time, I would like to pose a hypothetical, just to see how you deal with sunk costs. Before you read the hypothetical, please recognize that I am sure that the facts in this particular puzzle do not apply to you, but act like they do, at least for purposes of this exercise:
I hope you get a chance to give it a shot. It will take only a few minutes of your time (though it may take a few years off your life).
In today's class, we started the move from cash flows to incremental cash flows by asking two questions: (1) What will happen if you take the project and (2) What will happen if you do not? If the answer is the same to both questions, the item is not incremental. That is why "sunk" costs, i.e., money already spent, should not affect investment decision making. It is also the reason that we add back the portion of allocated G&A that is fixed and thus has nothing to do with this project. Finally, we looked at two time-weighted, incremental cash flow approaches to calculating returns, NPV and IRR, and used them to analyze the Rio Disney theme part.
In the second half of the class, I talked about why currency choices should not affect investment decisions (but sometimes do) as well as ways of dealing with uncertainty, ranging from payback to simulations. If, like me, you find yourself fascinated by simulations, but your statistics is a little rusty, you can try this paper I have on statistical distributions.
You don’t have to read the whole paper, just the appendix. I have attached the post class test for today, with the solution. In the final part of the class, we looked at time weighting cash flows, why and how we do it.
Today is also usually the day that I write to you about your project, but if you are budgeting your time to immediate priorities, you should be working on the case. In case your fascination with corporate finance leads you to work on the case, here are a few suggestions on dealing with the issues.
Finally, I will have be available on Zoom tomorrow (Friday, March 23) from 12 pm - 1 pm, just for questions related to the case.
I have to warn you in advance that there are parts of the case where I have deliberately not given specific assumptions, because I want you to make your own, and check for consistency.
|3/25/22||I am still in the virtual office, but it looks like most of you are comfortable with the case (since I am not getting much business during office hours). I will not risk confusing you by adding to the points I made yesterday about the case, but I do have an in practice webcast for this week. It covers the question of whether your company's existing investments pass muster. Are they good investments? Do they generate or destroy value? To answer that question, we looked at estimating accounting returns - return on invested capital for the overall quality of an investment and the return on equity, for just the equity component. By comparing the first to the cost o capital and the second to the cost of equity, we argued that you can get a snapshot (at least for the year in question) of whether existing investments are value adding. The peril with accounting returns is that you are dependent upon accounting numbers: accounting earnings and accounting book value. In the webcast, I look at estimating accounting returns for Walmart in March 2013. Along the way, I talk about what to do about goodwill, cash and minority interests when computing return on capital and how leases can alter your perspective on a company. Here are the links:
Walmart: https://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmart10K.pdf (10K for 2012) and https://pages.stern.nyu.edu/adamodar/pdfiles/cfovhds/webcasts/ROIC/walmart10Klast%20year.pdf(10K for 2011)
Spreadsheet for ROIC: https://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/ROIC/walmartreturncalculator.xls
The updated version of this calculator is attached to this email. I hope you get a chance to watch the webcast. It is about 20 minutes long.
I have a guess as to what you are working on this weekend and I hope you get to wrap it up soon. In case you are interested, this week’s newsletter is attached.
Attachments: Issue 7 (March 26)
|3/27/22||I won’t take up too much of your time, but a quick heads up, about the week to come. We will continue our discussion of investment analysis tomorrow, starting with a look at how an equity-focused capital budgeting will look like, followed by assessing a project with Bookscape and the Tata Motors acquisition of Harman. On Wednesday, we will spend much of the class using the Lowe’s Furniture case to come up with general rules that govern not just investment analysis but also valuation. In the meantime, if you get done with your case early, you don’t have to wait until Wednesday to submit it. If you do submit, remember to use the subject “Lowe and behold”. While I will not send graded projects back until after class on Wednesday, it will be one item of your to-do list.|
We started by looking at to how taking an equity perspective can alter how you measure returns and cash flows, and alter the hurdle rate you use, using an iron ore project for Vale as illustration. Finally, we looked at an acquisition as a really big project, and argued that the same rules should apply to acquisitions as to regular projects. The cash flows should include any side benefits and costs and the cost of capital you use should reflect the risk of the project (target company), not the entity looking at the project (acquiring firm). We moved on to comparing NPV versus IRR as decision rules, and why they might yield different answers for mutually exclusive projects, of both same and different lives.
The case is due before class on Wednesday. We will spend much of the class using the analysis to draw general lessons. Please remember to send me your analysis as a pdf file, with the rest of your group ccd not email, with “Lowe and Behold”, as the subject, and the summary numbers on the cover page (NPV, IRR, ROIC, Accept/Reject). I notice 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):
I usually send this email out after class, but since you will need the presentation for today’s class, I am sending it ahead of class. The bulk of today's class will be spent on the Lowe’s Case. While the case itself will soon be forgotten (as it should), I hope that some of the issues that we talked about today stay fresh. In particular, here were some of the central themes (most of which are not original):
Theme 1: The discount rate for a project should reflect the risk of the project, not the risk of the company looking at the project. Hence, it is the beta for furniture companies that drives the cost of capital for Lowe’s Furniture, rather than the cost of capital for Lowe's as a company. That principle gets revisited when we talk about acquisition valuation... or in any context, where risk is a consideration.
Theme 2: To get a measure of incremental cash flows, you cannot just ask the question, "What will happen if I take this investment?". You have to follow up and ask the next question: "What will happen if I don't take the investment? It is the incremental effect that you should count. That was the rationale we used for counting the savings from the distribution system not made in year 12.
Theme 3: If you decide to extend the life on an investment or to make earnings grow at a higher rate, you have to reinvest more to make this possible. In the context of the case, that is the rationale for investing more in capital maintenance in the longer life scenario than in the finite life scenario. Thus, I am not looking for you to make the same capital maintenance assumptions that I did but I am looking for you to differentiate between the two scenarios.
I have put the presentation and excel spreadsheet with my numbers online (with corrections made to the after-tax cost of debt and the finite life length):
Please download them. Not only will they be useful to do a comparison of why your numbers may be different from mine but also to get ready for the next quiz, which is on Monday (Sorry… No rest for the wicked). I will send you another email later today providing more information on the quiz. The post class test and solution test you on just the material on the case but also the rest of the stuff we will cover in the last segment of the class.
I am sorry to hit you with this right after you turned in your case analysis, but your second quiz is on Monday, April 4, and it will be in the first 30 minutes of classes, followed by class for the rest of the session.. The quiz will cover everything we have done since quiz 1, which includes cost of debt/capital and project analysis. In particular, focus on the investment analysis section of the notes, where we talk about how to assess cash flows for project, and NPV. I have put the review session for quiz 2 up online (on the webcast page for the class) with the presentation. The links are below:
You can also find all past quizzes with the solutions in the following links:
All past quiz 2s: http://www.stern.nyu.edu/~adamodar/pdfiles/cfexams/prqz2.pdf
Quiz 2 solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/cfexams/prqz2sol.xlsx
I just began grading the cases and you should be getting yours back soon, with a FIFO method applying (I am grading the cases in the sequence that they were turned in and sending it to everyone in the group who is ccd). As you look at the case and my grading, I will make a confession that some of the grading is subjective, but I have tried my best to keep an even hand. I have put together a grading template with the ten issues that I am looking for in the case.
http://www.stern.nyu.edu/~adamodar/pdfiles/cfexams/LoweCaseGrading,pdf (Also attachment)
When you get your case, you will find your grade on the cover page. You will see a line item that says issues, with a code next to it. To see what the code stands for look at the grading template. In the last column, you will see an index number of possible errors (1a, 2b etc...) with a measure of how much that particular error/omission should have cost the group. I have tried to embed the comment relevant to your case into your final grade. So, if you made a mistake on sunk cost (4, costing 1/2 a point) and allocated G&A (5, costing 1/2 a point) in your analysis. On the front page of your case, you will see something like this in your grade for the class (Overall grade; 9/10; Issues: 3b,5) I hope that helps clarify matters. It is entirely possible that I may have missed something that you did or misunderstood it. You can always bring your case in and I will reassess it. I have also allowed leeway on the revenue forecasts (unless they are egregiously off), and I have not taken points off for minor math errors. Finally, on how to read the scores, the case is out of 10 and the scoring is done accordingly. I hate to give letter grades on small pieces of the class, but I know that I will be hounded by some until I do so. So, here is a rough breakdown:
<5.5: Hopefully no group will plumb these depths
Thank you for whoever pointed out my mistake on the regression beta, where I had used the actual regression beta (1.53) instead of the adjusted beta (1.35) for Lowe’s existing building retail business. I have fixed in the Excel solution to the case that is available online.
First, my thanks for the time and sweat that went into the case reports. I appreciate it and if you are disappointed with your grade, I am truly sorry. think all the cases are done and you should have got them already. It is entirely possible that a couple slipped through my fingers, if you used the wrong subject head. If so, please email me with your case attachment again (with no changes of course), and make sure you put “Lowe and Behold” in the subject.. I will go back and find your original submission in mailbox and get it graded. I am attaching that grading code that I had sent you before, so that you can make some sense of your grade. If you feel that i have missed something in your analysis, please make your argument. I am always willing to listen. Here are some thoughts:
1. Beta and cost of equity: The only absolute I had on this part of the case was that you could not under any conditions justify using Lowe's beta to analyze a project in a different business. However, I was pretty flexible on different approaches to estimating betas from the list of furniture companies. Also, if you used that cost of capital to discount the synergy benefits to Lowe's. I did not make an issue of it in this case, since the differences were so small, but something to think about.
2. Cost of debt and debt ratio: If there was one number that most groups agreed on, it was that the cost of debt for Lowe's was 2.63% (the riskfree rate + default spread). I also yielded on multiple measures of debt, and even if you decided to use the accounting measure of lease debt (which is dramatically lower than what you get if you do the present value yourself). One calculation note. If you did exactly did what I did for leases but ended up with a debt value about $2.1 billion higher, it is because you counted the lease payment in the most recent year, In finance, the most recent year is viewed as ending a few minutes before you start your analysis, and since it is already done, it does not matter any more. No points taken off.
3. Cash flows in the finite life case: I won't rehash the arguments about why we need to look at the difference between investing in year 6 and year 12 for computing the cost of the expansion of distribution. Some of you either ignored the savings in year 12 or attempted to allocate a portion of the investment in year 6, a practice that is fine for accounting returns but not for cash flows. But here were some other items that did throw off your operating cash flows:
4. Cash flows in the longer life case: The key in this scenario is that you need more capital maintenance, starting right now. (Here is a simple test: If your after tax cash flows from years 1-15 are identical for the 15-year life and longer life scenarios, you have a problem...) Though some groups did realize this, they often started the capital maintenance in year 16, by which point in time you are maintaining depleted assets. Those groups that did not include capital maintenance at all argued that they felt uncomfortable making estimates without information. But ignoring something is the equivalent of estimating a value of zero, which is an estimate in itself. A few of you used the defense that I had asked you not to go out of the case, but you don’t have to, since your depreciation is the key indicator of how much maintenance cap ex you need. Also, you cannot keep depreciation in your cash flows (in perpetuity) and not have capital maintenance that matches the depreciation, since you will run out of assets to depreciate, sooner rather than later. The basis for capital maintenance estimates should always be depreciation and your book capital; tying capital maintenance to revenues or earnings can be dangerous.
Finally, and this is a pet peeve of mine. So, just humor me. Please do not use the word "net income" when you really mean after-tax operating income. Not only is it not right, but it will create problems for you in valuation and corporate finance. Also, try to restrain your inner accountant when it comes to capital budgeting. As a general rule, projects don't have balance sheets, retained earnings or cash balances. Also, if a project loses money, don't create deferred tax assets or loss carryforwards but use the losses to offset against earnings right now and move on. Now that the case is behind us, time to get ready for a busy week coming up.
Today is the day that I would send you a In practice webcast, but I will leave you alone to first recover from the case and get ready for the quiz on Monday (April 4). Here are some details:
1. Quiz time and logistics: The quiz will be in the first 30 minutes of class on Monday (April 4). I would like you to take it in person, but if you cannot, you can take it online at exactly the same time. If you plan to take the quiz online, please sign up in the Google shared sheet that I sent you earlier: https://docs.google.com/spreadsheets/d/1a2--DjcS7OsTiGV6_MbKBABEfpgHA-iOIya4JjWgDGk/edit?usp=sharing
2. Content: It will cover the sections of cost of capital that we did not cover on quiz 1 and go all the way through investment analysis, including the parts that you covered on the case. (Slides 175-328).
3. Rules: it is open book, open notes, but no laptops or excel. You can use your tablet or computer to review slides, if that is where they reside.
4. Review for the quiz: The links to the review for the quiz and the past quizzes are below:
You can also find all past quizzes with the solutions in the following links:
Finally, the case is a more complicated version of almost anything you will run into on the quiz. So, please review both your analysis and mine, as review for the quiz.
5. Office hours: I will be available for questions on Sunday, from 10 am - 11 am. The link to the office hour is: https://nyu.zoom.us/j/98552690265
I won’t take too much of your time, given how much of it I already have. The newsletter for the week is attached. I know that you are probably preparing for your quiz, and if you have questions, I will have office hours tomorrow and on Monday from 9 am - 10 am, before class. The zoom links are below:
Office hour on Sunday, April 3, from 10 am - 11 am: https://nyu.zoom.us/j/98552690265
Office hour on Monday, April 4, from 9 am - 10 am: https://nyu.zoom.us/j/92119670806
Have a good weekend (and I hope I have not ruined it).
Attachments: Issue 8 (April 2)
|4/3/22||This week brings quiz 2 tomorrow, in the first 30 minutes of class. For those of you who signed up to take it virtually, there will be instructions on access in a different email, but the window for signing up is now closed, since it creates chaos for me, and for you, to keep adding people to that list at the last minute. After the quiz, we will complete the first packet, i.e., we will be done with investment analysis. Since we will be talking about capital structure on Wednesday, and that will require the second packet, please download it, when you get a chance.|
In today’s shortened session, after the quiz, we looked at the final pieces on investment analysis, starting with side benefits from projects (from small pluses to synergy in acquisitions). We also looked at optionality in projects, i.e., times when you can legitimately override conventional investment metrics to take a project, because you may have the option to delay, expand or abandon the project. Next session, we will be starting on capital structure, and you will need the second lecture note packet for the class. You can get them here:
Powerpoint version: https://www.stern.nyu.edu/~adamodar/pptfiles/acf4E/cfpacket2spr22.pptx
I know that you probably are relaxing after the case and the quiz, but your quizzes are graded and your grades are recoded on Brightspace. If you took the quiz in person, the quizzes can be picked up on the ninth floor of the Finance department just in front of the door leading to the department (look to the right and they should be on the top shelf. I have attached the solutions to the quiz to this email, with a grading template, if you want to check the grading.
Attachments: Quiz 2 and solution
I know that you probably are relaxing after the case and the quiz, but your quizzes are graded and your grades are recoded on Brightspace. If you took the quiz in person, the quizzes can be picked up on the ninth floor of the Finance department just in front of the door leading to the department (look to the right and they should be on the top shelf. I have attached the solutions to the quiz to this email, with a grading template, if you want to check the grading.
Attachments: Quiz 2 and solution
No corporate finance puzzle for this week. You deserve a break. Please do print off or download packet 2 for class tomorrow. You can find the pdf and powerpoint versions on the webcast page for the class:
And if you do get a chance, please also pick you up your graded quiz from yesterday.
In today's class, we started our discussion of the financing question by drawing the line between debt and equity: fixed versus residual claims, no control versus control, and then used a life cycle view of a company to talk about how much it should borrow. We then started on the discussion of debt versus equity by looking at the pluses of debt (tax benefits, added discipline) and its minuses (expected bankruptcy costs, agency cost and loss of financial flexibility). Even with the general discussion, we were able to look at why firms in some countries borrow more than others, why having more stable earnings can make a difference in how much you can borrow and why having intangible assets can affect your borrowing capacity.
|4/7/22||The clock is ticking down to the end of the semester, and since we are in capital structure/financing this week, I will focus on that component. The first thing you can do (if you remember what company you are analyzing) is to take it through the qualitative analysis, i.e., the trade off items on capital structure:
I will be posting an in-practice webcast, where I take you through this process for a company, so that you have a sense of what I am looking for. In the meantime, if you have the cost of capital and return on invested capital worked out for your company, please enter that information into the corporate finance mastersheet:
In the last class, we talked about the trade off between debt and equity and today's in-practice webcast takes you through the process of assessing this trade off, with suggestions on variables/proxies you can use to measure each of the above factors. If you are interested, here are the links:
I am also attaching two sets of spreadsheets: one contains the updated marginal tax rates by country and the other has the 2022 version of average effective tax rates by sector for US as well as for Global companies.
Marginal tax rates by country: https://www.stern.nyu.edu/~adamodar/pc/datasets/countrytaxrates.xlsx
Effective tax rates by industry
I hope that your weekend is going well. Newsletter for the week is attached.
Attachment: Issue 9 (April 9)
This week, we will continue on the financing question, moving from the fuzzy trade off to approaches that actually deliver a more specific optimal debt ratio. One of these will be an extension of the cost of capital, a number that has already been part of our discussion as the hurdle rate in investment analysis, and will now become an optimizing tool. In fact, later in the class, it will come back in another guise, as a divining rod in dividend policy, before becoming the discount rate in valuation. That is why I call it the Swiss Army knife of corporate finance.
I want to remind you again to download the second packet. I know that some of you have had trouble with the PowerPoint version, and I am sorry. I have tried everything, but it is not a server or upload problem, but a PowerPoint problem. I have created a version using the old PowerPoint that I think works, if you still prefer PowerPoint to pdf.
I am truly sorry about the technical glitches during class today, but I have learned that what technology gives, it can take away, and I hope that the distractions did not impede the lessons from the class. Since I could not get the slides to work, you will have to listen to the audio and connect with the slides, and forgive any numerical misstatements along the way, as I was desperately trying to remember numbers on slides.I looked at the Miller Modigliani theorem through the prism of the debt tradeoff and followed up by using the financing hierarchy that companies seem to move down, when they think about raising fresh financing. I then moved on to looking at how the cost of capital can be used to optimize the right mix of debt and equity. In effect, you estimate the costs of debt and equity at different debt ratios, and try to find the mix of debt and equity that minimizes your cost of capital. If you want to try your hand at using the spreadsheet to optimize debt ratio, try the following:
We will continue with this discussion next week. looking at limits to the approach, and variants.
I know what you are thinking… Right? He wants me to do a case, follow up with a quiz and then ask me to do a corporate finance puzzle.! Not happening! I understand but nevertheless, just in case you feel the urge, this week’s puzzle is up and running. It revolves around the tax benefit of debt and in particular, how perverse the US tax code was prior to 2018. I know that there is a lot of heated debate about the tax reform act that happened at the end of 2017, and while there is much to dislike about the reform (especially if you live in a high tax state like New York or California), I believe that the corporate tax reform it included, especially on foreign income, was vastly overdue. To give you a sense of how bad things used to be, I pulled up a write up and puzzle from almost six years ago as the puzzle for this week.
While the facts are dated and Pfizer never went through with its tax inversion plan, put yourself back in time and try to address the questions.
One final note. I know that the scheduled date for the final exam in this class is May 16, and since many of you are making your travel reservations now, you would like to know whether that date stands. It does, since I don’t have the freedom to move final exam dates, but I will be offering an early final exam on May 12 (Time TBA) for those who want to be done earlier, and I will also be offering the online version of the final exam, though I would prefer that you use that option only if you physically cannot make the exam.
n today’s class, we started by tying up loose ends on the cost of capital approach, starting with why moving to the optimal changes the value of a business (hint: it is all in the tax code) and then looking at how sensitive the optimal debt ratio is to changes in operating income or rating constraints. We also looked at enhancements to the approach, where we incorporated indirect bankruptcy costs in the analysis. Finally, we examined the determinants of the optimal. In particular, it was differences in tax rates, cash flows (as a percent of value) and risk that determined why some companies have high optimal debt ratios and why some have low or no debt capacity. Next session, we will wind up the analysis of the optimal debt ratio and then move on to whether to move to that optimal, and if yes, how quickly. In the meantime, you can catch up on the project by taking your company and putting the numbers into the spreadsheet at the link below:
Remember to check the iteration box in Excel calculation preferences to make sure that it is checked.
This week, you get to optimize capital structure for your company, and as I noted in class, it will also give you a chance to get caught up on stuff you should have been doing but have been putting off in class. The spreadsheet that you will use to figure out your company’s optimal debt ratio is:
I know that I have been sending you serial emails on the project over the whole semester and that some of you are way behind. Since it may be overwhelming to go back and review every email that I have sent out over time, I thought it would make sense to pull all the resources that I have referenced for the project into one page, which you can use as a launching pad for starting (or continuing) your work on the project.
1. Resource page: I put the link up to the corporate finance resource page, where I will collect the data, spreadsheets and webcasts that go with each section of the project in one place to save you some trouble:
2. Main project page: I had mentioned the main page for the project at the very start of the class, but I am sure that it got lost in the mix. So, just to remind you, there is an entry page for the project which describes the project tasks and provides other links for the project:
3. Project formatting: I guess some of you must be starting on writing the project report or some sections thereof. While there is no specific formatting template that I will push you towards, I do have some general advice on formatting and what I would like to see in the reports:
It also has sample projects from prior years that you can browse through. If you look at the projects, you will see that the formats vary. Some use Word and one is in Powerpoint. They all emphasize comparative analysis and go beyond the numbers. So, be creative, put it in the format that best fits how you want to deliver your narrative and have fun with it. Note, in particular, to put muscle behind my plea for brevity. I have put a page limit of 20 pages on your entire written report (You can add appendices to this, but use discretion), if you have five companies or less. If you have more than five companies, you can add 3 pages for every additional company.
The in-practice webcast for the week is on using the spreadsheet, , using Dell as my example. You can find the webcast and the related information below:
Dell optimal capital structure spreadsheet: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/optdebt/dellcapstru.xls
You will notice that the Dell capital structure spreadsheet which is from a few years ago has a few minor tweaks that make it different from this year's version (which is attached), but it is fundamentally similar. In particular, take note of the fact that the spreadsheet will not work unless you have the iteration box checked under calculation options.
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, there seems to some confusion about how your quiz scores, final exam score, the case 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 vexing some of 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 and final exam, 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 on this 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 22/25, with a low of 16 (for one group) and a high of 25. 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 10(April 16)
In the week to come, we will complete our discussion of capital structure, starting tomorrow with a discussion of other approaches (other than cost of capital minimization) to finding the right debt mix for a company. The Adjusted Present Value approach, a favorite of University of Chicago grads and many LBO players will be discussed, with an emphasis on how it is misused in practice. After we have measures of the optimal, we will address the follow up question of what to do (if anything at all), if the optimal debt ratio is different from the actual debt ratio. In Wednesday’s class, we will look at debt design, following through with details on matching debt up to assets, and what to do, if a company has mismatched debt. That’s about it. See you in class tomorrow!
We started this class with the adjusted present value approach, where we begin with the unlevered firm value, and then add the tax benefits of debt and net out expected bankruptcy costs. While you can download the APV spreadsheet that I have online, I don’t really see a need to do the APV analysis of your company’s capital structure, since the expected bankruptcy cost is a black box. We then looked at peer group analysis, where companies decide how much to borrow by looking at what other companies in the sector do. You can check out the debt ratios for other companies in your sector by going to my website:
US industry averages: http://www.stern.nyu.edu/~adamodar/pc/datasets/dbtfund.xls
Global industry averages: http://www.stern.nyu.edu/~adamodar/pc/datasets/dbtfundGlobal.xls
n this week’s puzzle I decided to use Valeant in 2015 to illustrate both the good side and the bad side of debt. Valeant was an obscure Canadian pharmaceutical company in 2009 but grew explosively between 2009 and 2015 to get to a market capitalization of $100 billion, primarily using debt-fueled acquisitions to deliver that growth. You can read the weekly puzzle here:
In 2015, Valeant’s fortunes took a turn for the worse. Not only has its business model crumbled, but it had had both managerial problems and information disclosure issues that have added to the troubles. It’s biggest booster and investor, Bill Ackman,took his losses on the stock and apologized to investors in his fund for the “mistake” he made investing in the company. In November 2015, the stock price, which was close to $200 IN 2014, dropped below $10 and the company was clearly seeing the dark side of debt. Here are my questions:
On an entirely different note, I think that there is still some confusion about due dates and exam schedules. To be clear, here are the dates:
April 27; Quiz 3
May 9: Final Project due (by the end of the day)
May 12: Early Final Exam option
May 16: Scheduled Final Exam
In today's class, we looked at the design principles for debt. We started by completing a five step process for designing the perfect debt before looking at both intuitive and quantitative ways of debt design. In particular, we looked at a macro economic regression of firm value/operating income against interest rates, GDP, inflation and exchange rates. Keeping in mind the objective of matching debt to assets, think about the typical investments that your firm makes and try to design the right debt for the project. If your firm has multiple businesses, design the right kind of debt for each business. In making these judgments, you should try to think about
- whether you would use short term or long term debt
- what currency your debt should be in
- whether the debt should be fixed or floating rate debt
- whether you should use straight or convertible debt
- what special features you would add to your debt to insulate the company from default
Your objective is to get the tax advantages without exposing yourself to default risk. If you want to carry this forward and do a quantitative analysis of your debt, I will send you a spreadsheet tomorrow that will help in the macro economic regressions. I also mentioned that the individual company regressions against the macro variables are so noisy that it is probably not worth the effort. If you are just curious and want to try this out on your company, I do have the macro data collected in a spreadsheet that you can use to run this regression for your company:
It has annual and quarterly data through 2021. Just a warning that it is extremely noisy and may spit out output that does not make sense. The post class test & solution for today is attached.
|4/20/22||The third and final quiz is a week from today, on April 27. The review session for the quiz is available at the link below
Webcast link: https://www.youtube.com/watch?v=5UNYKC8rYiU
You can check out past quizzes and solutions at the links below:
Past quiz 3 solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/cfexams/prqz3sol.xlsx
I will add extra office hours for next Tuesday, if you have questions.
On the project, the place to start your debt design is with intuition. In fact, if you have done a prior step in the project (where I asked you to describe a typical project for your company), you are well in place to complete your intuitive analysis. In my view, this is the more critical part of debt design (more important that the quantitative analysis that I will describe in the rest of this email). If you plan to do a quantitative analysis of your debt. I have attached the spreadsheet that has the macroeconomic data on interest rates, inflation, GDP growth and the weighted dollar from 1986 to the present (I updated it to include 2021 data. The best place to find the macro economic data, if you want to do it yourself, is to go to the Federal Reserve site in St. Louis:
Give it a shot and download the FRED app on your iPad and iPhone. You can dazzle (or bore) your acquaintances with financial trivia. You can enter the data for your firm and the spreadsheet will compute the regression coefficients against each. You can use annual data (if your firm has been around 5 years or more). If it has been listed a shorter period, you may need to use quarterly data on your firm. The data you will need on your firm are:
- Operating income each period (this is the EBIT)
- Firm or Enterprise value each period (Market value of equity + Total or Net Debt); you can use book value of debt because it will be difficult to estimate market value of debt for each period. You can also enterprise value (which is market value of equity + net debt), if you are so inclined. I know that you should be including the present value of lease commitments each period, but that would require doing it each year for the last ten. The easiest way to get this data is to use the FA function in Bloomberg or from S&P Capital IQ.
I have to warn you in advance that these regressions are exceedingly noisy and the spreadsheet also includes bottom-up estimates by industry. There is one catch. When I constructed this spreadsheet, I was able to get the data broken down by SIC codes. SIC codes are four digit numbers, which correspond to different industries. The spreadsheet lists the industries that go with the SIC code, but it is a grind finding your business or businesses. I am sorry but I will try to create a bridge that makes it easier, but I have not figured it out yet. My suggestion on this spreadsheet. I think it should come in low on your priority list. In fact, focus on the intuitive analysis primarily and use this spreadsheet only if you have to the time and the inclination. My webcast for tomorrow will go through how best to use the spreadsheet.
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:
WMT financial summary: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/debtdesign/WMTFAsummary.pdf
WMT macrodur.xls spreadsheet: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/debtdesign/WMTmacrodur.xls
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.
Bad news: Another weekly newsletter for you. Good news: It is the second to last one, which is my not-so-subtle way of telling you that the end of the semester is fast approaching. On a different note, the third quiz is on Wednesday and if you want to try your hand at prior year’s quizzes, you can find them here:
Past Quiz 3s solutions: http://www.stern.nyu.edu/~adamodar/pdfiles/cfexams/prqz3sol.xls
If you want to watch the review session for the quiz, it is here:
Webcast link: https://www.youtube.com/watch?v=5UNYKC8rYiU
As you can see, it will be focused on the capital structure section (which is lecture note packet 2, until page 148). I will have office hours on Tuesday and Wednesday morning. Zoom links and times to follow.
In the week to come, we will move on to dividend policy. In tomorrow’s class, we will lay the bulk of the background work, looking at the history of dividends in equity markets, and characteristics of dividend policy. We will look at the growth of buybacks and much of the mythology about buybacks. In Wednesday’s class, we will continue with a way of assessing the potential dividends that a company can pay, and what the failure to do so means for the company. At the start of Wednesday’s class, we will have quiz 3 in the first 30 minutes. Having sent you the links for quiz 3 multiple times, I won’t bore you by sending them out again. There will be office hours on Tuesday and Wednesday for the quiz:
Tuesday 9 am - 10 am: https://nyu.zoom.us/j/92306742263
Wednesday 9 am - 10 am: https://nyu.zoom.us/j/92119670806
If you have any questions, please drop by. See you in class tomorrow!
We spent today's session first talking about the characteristics of dividends, i.e., that they are sticky and follow earnings as well as reasons for the shift towards buybacks in recent decades, We ended the class by looking at two bad reasons for paying dividends (that they are more certain, that you had a good year). As you wrap your head around buybacks and what they can and cannot do to companies, you may find the following post that I have on the topic useful (or not):
In the next class, we will talk about three good reasons for paying dividends as well as a way of measuring how much cash can be returned (FCFE). Of course, quiz 3 is also scheduled for Wednesday, and I wish you the best on that front.
I briefly considered giving you a weekly puzzle (since today is Tuesday) and abandoned the idea, since you have other fish to fry. As you work through the past quizzes, here are a few things you may want to keep in mind:
For those of you who were in class today, thank you. I know that having al class following a quiz is tough and I appreciate your being there. In today’s session, we started by looking at one good reason for paying dividends, including having an investor base that likes dividends, one iffy reason (dividends as a signal) and one borderline reason (that you can rip of lenders). We then looked at three questions that need to be asked in assessing dividend policy, starting with how much a company can afford to return to stockholders (FCFE), then looking at how much is actually returned in dividends and buybacks and finally assessing whether you trust management enough to give them the freedom to set dividend policy. Next session, we will put this framework into practice by asking and answering these questions with the companies that we are examining in this class: Vale, Tata Motors and Baidu.
The quizzes are graded and if you did it in class, they should be available in the usual place (outside the entrance to the finance department (9th floor of KMEC), on the top shelf to the right, just before you enter). If you took your quiz online, you should be able to check your responses against the answers. The solution sheet is attached with a grading template. Have a good night and I will see you next week.
Attachment: Quiz 3 and solution
|4/28/22||In this email, I would like to focus on the project. As you look at the calendar, there is some bad news and some good news. The bad news is that you have three class sessions and two weekends left in the class. I know that you may be in a bit of a panic, but here is what needs to get done on the project. (I am going to start off from the end of section 5, since I have nagged you sufficiently about the steps through that one).
1. Optimal capital structure: You need to compute the optimal debt ratio for your company
1.1: Estimate the cost of capital at different debt ratios.
1.2: If you want to augment the analysis by using the APV approach (apv.xls), do so. Clearly, these approaches will add value only if you have a sense of how operating income will change as the ratings change for your company or the bankruptcy cost as a percent of firm value.
1.3: Assess how your firm's debt ratio compares to the sector. You can just compare the debt ratio for your firm to the average for the sector. If you feel up to it, you can try running a regression of debt ratios of firms in your sector against the fundamentals that drive debt ratio (Look at the entertainment sector regression I ran for Disney in the notes).
2. Debt design: As you work your way through or towards the debt design part, here are a few sundry thoughts to take away for the analysis:
2.1. The heart of debt design should be the intuitive analysis, where you look at what a typical project/investment is for your firm (perhaps in each business it is in) and design the most flexible debt you can, given the risk exposure.
2.2. The quantitative tools (the regression of firm value/ operating income versus macro variables) may or may not yield useful data. The bottom-up approach (using sector averages) offer more promise. If you have a non-US company, a US company with little history or get strange results, stick with just the intuitive approach. Use the spreadsheet at this link to do both:
Try it, but if your numbers look weird, just stick with the intuitive analysis and move on.
2.3: Compare the actual debt to your perfect debt (either from the intuitive approach or from the quantitative approach) and make a judgment on what your company should do.
3. Dividend analysis: We developed a framework for analyzing whether your company pays out too much or too little in dividends in class yesterday. You can read ahead to chapter 11, if you want, and use the spreadsheet at the link below to examine your company.
3.1: Examine whether your company has returned cash to its stockholders over the last few years (5-10 or whatever time your firm has been in existence) and if yes, in what form (dividends or stock buybacks). The information should be in your statement of cash flows.
You can watch the webcast I will be posting tomorrow, if you run into questions.
3.3: Make a judgment on whether your company should return more or less cash to its stockholders.
The next section has not been covered yet in class, but you can get a jump on it now, if you want.
4. Valuation: This is a corporate finance class, with valuation at the tail end. We will look at the basics of valuation next week and you will be valuing your company. Since we will not have done much on valuation, I will cut you some slack on the valuation. It provides a capstone to your project but I promise not to look to deeply into it. Knowing how nervous some of you are about doing a valuation, I have a process to ease the valuation: Download the fspreadsheet on my website. It is a one-spreadsheet-does-all and does everything but your laundry.
You will notice that the spreadsheet has some default assumptions built in (to prevent you from creating inconsistent assumptions). I let you change the defaults and feel free to do so, if you feel comfortable with the valuation process. If not, my suggestion is that you leave the inputs alone. You will notice that I ask you for a cost of capital in the input page. Since you already should have this number (see the output in the optimal capital structure on section 1), you can enter it. If you want to start from scratch, there is a cost of capital worksheet embedded in the valuation spreadsheet. There is a diagnostic section that points to some inputs that may be getting you into trouble. I also ask you for information on options outstanding to employees/managers. That information is usually available for US companies in the 10K. If you cannot find it, your company may not have an option issue. Move on. The industry averages for most inputs and the latest equity risk premiums are already in this spreadsheet. If you find yourself stuck or just want to watch a bad homemade movie, try this YouTube guide that I have to using the spreadsheet:
Hope it helps.
5. Google shared spreadsheet: As you get the numbers for your company, please enter them into the shared spreadsheet. In fact, to provide some inducement to do this, I will assign 5 points out of the 30 points on the final project to getting your numbers into the spreadsheet.
Please, please do this by Sunday, May 8, since I will need the numbers for the final session.
6. Project write-up and formatting: If you are thinking of the write-up for the project and formatting choices, you can look at some past group reports on my site (under the website for the class and project). Repeating a link that I gave you a couple of weeks ago:
I prefer brevity and I want to emphasize the page limit of 20 pages on the report (plus 3 pages for each additional company over 5), if you are doing it as a group. If you are doing this individually, you should be able to do your write up in 5 pages or less. As a general rule, steer away from explaining mechanics - how you unlevered or levered betas -and spend more time analyzing your output (why should your company have a high beta? And what do you make of their really high or low return on capital?).
Ah, where is the good news? You will be done with the project exactly 11 days from today. It is due by 5 pm on May 9.
As we work through the analysis of dividend policy, you have to look at the trade off on traditional dividends (and whether your company is a good candidate for paying dividends or increasing them). You have to follow up by assessing potential dividends and whether your company is returning more, less or just about the same amount as that potential dividends.
The first webcast looks at the trade off on dividends
The second webcast looks at the question, again using Intel:
Annual Report: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/dividends/IntelAnnualReport.pdf
Historical data: http://www.stern.nyu.edu/~adamodar/pdfiles/cfovhds/webcasts/dividends/IntelBloomberg.pdf
The spreadsheet that goes with these webcasts is an old one. So, use the updated version that I sent you yesterday which has data through 2020:
I hope you get a chance to take a look at the webcast.
If any of you had trouble accessing or downloading stuff off my website yesterday, it was a NYU IT problem, and I think it has been fixed. If you do run into trouble, let me know.
The good news is that this is the last newsletter. The bad news is that this means the end is near. If you are working on your project this weekend, I hope that it is a productive one and at the risk of reminding you one times too many, please enter your numbers in the Google shared spreadsheet, when you have a chance.
Looking to the final exam, I know it is early, but here are a few reminders. The final exam will be on May 16 (with the option to take the early exam on May 12, from 10 am - 12 pm). It is cumulative and will be open book, open notes. If you are ready to reviewing past finals:
You can try past final exams and check the solutions here:
Attached: Issue 12 (April 30)
|5/1/22||I won’t risk asking you what you are doing this weekend because I may hit a nerve. This week, we will approach closure on the class, finishing the dividend section tomorrow and starting valuation right after. In parallel, I hope that you will be tying up loose ends on your project.|
In today's class, we started by using the dividend assessment process of looking at FCFE/cash return and then gauging trust in management, using the companies that we have used as lab experiments in the class (Vale in 2013, Tata Motors in 2013) and peer group analysis. In the process, we looked at why it is so difficult to get out of a dysfunctional dividend policy, as control trumps sanity and worries about the short term and peer group comparable delay action. We then started on valuation as the place where all of the pieces of corporate finance come together - the end game for your investment, financing and dividend decisions. We then looked at how these numbers can be different depending on whether you take an equity or firm perspective to valuation and what causes these numbers to change. Ultimately, though, the best way to learn valuation is by playing with the numbers and seeing how value changes. Finally, I have a spreadsheet that is versatile enough to cover every company in this class. Please use it for your valuation:
If you need some guidance on using this spreadsheet, try this YouTube video that I put together for the Motley Fool earlier this year:
Many of the inputs that you need for this spreadsheet should have already have been estimated or looked up for other parts of the project. Also, as you enter the key numbers for revenue growth, target operating margin and sales/invested capital, think of the story that drives these numbers. I know that you may find this to be a bit of a black box at the moment, but given that time is of the essence, I thought it would not make sense for you to be building up your excel skills at the moment.
As your project winds down (or up), I am sure that there are loose ends from earlier sections that may bother you, I have listed a few of the questions that seem to be showing up repeatedly in emails:
1a. Do I need to update my accounting numbers to reflect first quarter earnings reports?
The answer is complicated. I would like them to be, and it is easy to do, if you have kept your input numbers in a separate sheet. If you have hard coded numbers into spreadsheet, it will be really messy, and my advice is don’t do it. Pick a date for your macro numbers (risk free rate, equity risk premium etc.) and do your analysis as of that date. Move on!
1b. I just discovered that my company lists revenues from "other businesses". How should I treat these in bottom-up beta computations?
If your company tells you what the other businesses are, you can try to incorporate their betas into your bottom up beta. If all you have is a nebulous 'other businesses', I would ignore it in beta computations.
1c. I just discovered that my US company has revenues from other countries (including emerging markets) and in other currencies. How does this affect my cost of equity/debt/capital?
First, if you have chosen to do your analysis in a currency (say US dollars), your riskfree rate will be the riskfree rate in that currency (US treasury bond rate), even if the company has revenues in multiple currencies. Second, your cost of debt will still be that of a domestic company. Coca Cola will not have to pay an Indian country default spread when it borrows money in rupees. If it had to, it would just borrow in the US and use currency derivatives to manage risk. Third, and this is the only place it may make a difference, it may change the equity risk premium you use. Instead of using the mature market premium, you may decide to incorporate the additional risk of some of the countries that you operate in. Note that this is likely only if you know your revenue exposure in some detail and you get significant revenues from emerging market countries (with less than AAA ratings).
1d. What should I be doing with the cash balance that my company has when computing the unlevered beta?
Adjusting betas for cash creates more headaches and confusion than perhaps any other aspect of discount rates. Back up, though. To get the unlevered betas of the businesses that your company is in, you should always start with the average regression beta for the companies in the sector, unlever the betas using the average gross D/E ratio and then adjust for the average cash balance at these companies. (That will yield the unlevered betas corrected for cash for each of the businesses that your company is in).
Now, comes the tricky part. You can compute an unlevered beta for just the operating businesses that your company is in, by taking the weighted average of the unlevered betas of the businesses. You can also compute an unlevered beta for the entire company, with cash treated as an asset/business with a beta of zero. The latter will always be lower than the former. My suggestion is that you compute both.
If you are now computing a cost of equity as an input into the cost of capital, you want to use the unlevered beta of just the operating assets of the business as your starting point for levered beta and cost of equity. That is because the cost of capital is a discount rate that we apply to operating cash flows (and to value the operating assets). In fact, we add the current cash balance to this value, because cash has been kept separated from operating assets. (If you use the lower unlevered beta that you get with cash incorporated into the calculations to get to a cost of capital, you will end up at least partially double counting cash, once by lowering the beta and the cost of capital, and again when you add cash at the end).
When would you use the beta for the company (with the cash beta of zero incorporated into your calculation)? Rarely. Here is one scenario. Let's assume that you are looking at a discounting the dividends of a company or an overall cash flow that is estimated from net income. These cash flows reflect cash flows from all of the company's assets (not just its operating assets) and it is appropriate to use the lower company beta with the cash effect built in.
(If you find this too abstract, go back to lecture note packet 1 and check out pages 177 & 178, where I estimated Disney's beta and cost of capital)
2. My company already reports leases as debt. Should I capitalize leases?
No. You don’t have to, if you generally trust accountants. If you don’t, you can use the capitalization spreadsheet (assuming you have commitments for the future) and do it yourself, but don’t double count.
3. I have a negative book value of equity. How do I compute ROE and ROC?
First the book equity you should use for ROE and ROC should be the total shareholders equity, which can be a negative number. With a negative book value of equity, you cannot compute ROE. You should still be able to compute return on capital, since adding the book value of debt to negative book equity should still lead to a positive book capital. If book capital is negative, though, you cannot estimate return on capital either.
3a. I am getting absurdly high values for return on invested capital for my company. What do I do?
A return on invested capital is ultimately an accounting number, and accounting inconsistencies (about what expenses get capitalized and what expenses does) and choices (about write offs) can create havoc on the number. Rather than try to finesse the number to make it look palatable, just report the number, absurdly high though it is, qualify that when you discuss the quality of the company’s projects, and hold on to the memory to use on someone who acts like the ROIC is a magic bullet, the answer to every question.
4. My ROE > Cost of equity and my ROC < Cost of capital (or vice versa). How is this possible and how do I explain it?
There are two reasons why the two measures may yield different conclusions:
1. The net income includes income/losses from non-operating assets including cross holdings in other companies. If you have cross holdings that are making you a lot of money, you can end up with a high ROE, even though ROC looks anemic. If you have cross holdings that are losing you money, the reverse can happen. Net income is also affected by other charges (restructuring, impairment etc.) and other income... I trust the ROC measure more when it comes to answering the question of whether the company takes good investments.
2. The ROE reflects the actual interest expense on debt. To the extent that you are borrowing money at rates lower than what you should be paying (given your default risk and pre-tax cost of debt), you are exploiting lenders and making equity investors better off. Thus, you can take bad projects with "cheap" debt and emerge successful as an equity investor. (Think of the LBOs done earlier this year.)
5. My Jensen's alpha is positive (negative) and my excess return is negative (positive). How do I reconcile these findings?
Market prices are based on expectations of how well or badly you will do in the future. To the extent that you beat or fail to meet these expectations, stock prices will rise or fall. Thus, if you are a company that is expected to earn a 30% ROC and you earn a 25% ROC, you will see your stock price go down (negative Jensen's alpha) even though you have a healthy positive EVA. Conversely, if you are a company that is expected to make only a 2% ROC and you make a 3% ROC, you will see your stock price go up (positive Jensen's alpha) while your EVA will be negative.
6. How do I come up with the cash flows and characteristics of a typical project?
I really do not expect you to come up with cash flows. Just describe in very general, intuitive terms what a typical project will look like for your company. For Boeing, for instance, you would describe a typical project in the aerospace business as being very long term, with a long initial period of negative cash flows (when you do R&D and set up manufacturing facilities) followed by an extended period of positive cash flows in multiple currencies.
7a. My optimal debt ratio is coming out to be zero. What am I doing wrong? The most common input error that can lead to an optimal debt ratio of zero is that you mismatched units (it is usually the share count that is in different units than the rest of your numbers). If there are no input errors, it is entirely possible that your optimal debt ratio is really zero. That can happen in three scenarios. The first is if your operating income is a low percentage of your enterprise value; for high growth firms, the market cap can be high relative to operating income, because of growth potential being priced in. Zoom, for instance, is a vibrant, fast growing company but its optimal debt ratio is zero percent. The second is if you have a very low unlevered beta, which can happen either because you are in a very safe business or because you are using a regression beta that does not reflect your current debt to equity ratio.
7b. The cost of capital is higher at my optimal debt ratio than at my current debt ratio. Why does that happen and what do I do?
Try the "FAQ" worksheet in the capital structure spreadsheet.
8. If my firm is already at its optimal debt ratio, do I still need to go through the debt design part?
Yes. You still have to determine whether the debt the company already has on it's books is of the right type. The only scenario where you can skip this is if both your actual and optimal debt ratios are zero percent.
9. I cannot do the macro regression (because my company has been listed only a short period or is non-US company). What do I do about debt design?
Skip the macro regression. You can still use the bottom up estimates for the sector in which your firm operates. To do this, you need an SIC code which your non-US company will not have. Look up a US competitor to your company and look up its SIC code. You can also still do the intuitive debt design. (I would do the same if you are getting absurd or meaningless results from your macro regression...)
10. My macro regression is giving me strange look output. What should I do?
Take a deep breath. The macro regression is run with 10 or 11 observations and you can get "weird" output because of outliers. That is why you should look at the bottom up estimates and bring in your views on what a typical project for a company looks like.
11. My company pays no dividends. Should I bother with dividend analysis section?
Yes. Paying no dividends is a dividend policy. You will have to estimate the FCFE to check to see if this policy makes sense. (If the FCFE <0, it does...)
12. I have a non-US company. How do I get market returns and riskfree rates for the dividend analysis section?
On this one, I am afraid that the fault is mine for not giving you a way to pull up the data on other markets. To compensate, I will be okay with you using the US data for non-US companies.
13. I am getting strange looking FCFE for my company... What's going on?
Check the signs of the numbers you are inputting into the spreadsheet. If you are entering cap ex as a negative number, for instance, I will flip the sign around and add cap ex instead of subtracting it out...
14. My value is very different from the price. What's wrong?
First, very different is in the eye of the beholder. i have valued companies and obtained values that are less than one fifth of the price and five times more than the price. The reason is sometimes in my inputs but it can also be a massively under or over priced stock. So. check your numbers and if you feel comfortable with them, let it go.
15. What do I have to do, when I feel comfortable with the numbers that I have?
Please enter the numbers you have for your company in the Google shared spreadsheet:
When you are entering the numbers, please follow the number format that I have used for Disney. For instance, for R squared, I list 73%, not 0.73 or 73, and if you can also enter your R squared the way I did, it would make my work on Sunday a lot easier, if you follow my formatting, since this Google shared spreadsheet becomes the raw data with which I work.
16. What should the final project report look like?
Please turn in one report for the whole group and save it as a pdf file (less chance of bad things happening to formatting than with Word or Powerpoint files). As you do this, remember the page limit (20 pages for a five-company group, with 3 extra pages for every additional company) On the front page, please list all group members in alphabetical order (last name). Please do not attach or include any excel spreadsheets. In addition, make sure that you list all the group members alphabetically on the first page and use “The Torture Ends” in the subject line.
17. When will this torture end?
Six days from today (5 pm on May 9)... but the memories will last forever…
Until next time!
In today’s session, we continued on the question of how best to value a company by first looking at the four key components of value - cash flows from existing investments, growth in the future, discount rates and the terminal value. With cash flows, we noted the contrast between cash flows to equity and cash flows to the firm, with the former being after debt payments and the latter before. With discount rates, we argued that the same discount rates that we computed for investment hurdle rates can be used in valuation, with the caveat that these discount rates will change over time, as a company changes. While you can adjust betas, costs of debt and debt ratios, a simpler way to target a cost of capital in stable growth is to look at the median cost of capital for companies, in this graph.
These numbers are from January 2022 and collectively have increased by about 1.50% since, as the riskfree rate has risen and the equity risk premium has gone up. The median cost of capital for a global company now is about 7.5%, in US dollar terms. With growth, the key is recognition that growth comes from what companies do in terms on how much they reinvest and how well, rather than from outside sources. Finally, for terminal value, I argued that the growth rate in perpetuity has to be less than or equal to the risk free rate.
Since you will be valuing companies in different stages in the life cycle, I would like you to use the spreadsheet linked below:
I know that you feel uncomfortable with the valuation part, as it is towards the end of this class and requires story telling, but do the best you can. And if you feel you like this process, or are curious, come back next spring for the valuation class.
I hope that your project numbers are getting nailed down. From the looks of the Google shared spreadsheet, we are taxiing towards takeoff and I thank you. I don’t plan to download the numbers (to prepare for the last class until Sunday. Please enter your numbers, if you have not already, by then. If you have entered the numbers and change your mind, you can go in and change your numbers before then.
As you work on the final pieces of the project (dividends and valuation), cut yourself some slack. This is a process that requires both sides of your brain (left and right) stay engaged, and it can be exhausting as well as stressful. One constant question that you may have, as you do your analysis, is “how do I know this is right?”. While there is an answer, when the question is purely mechanical (like computing last year’s FCFE), there is none, when you are making you are analyzing your company’s capacity to carry debt, pay dividends and be valued right. All you can do is use the information you have, make your best judgments about the company, develop your story for your company and then let the chips fall where they might. While I will contest you, when I think your story has internal inconsistencies, I am very accepting of stories that diverge from my own. None of us has a monopoly on the truth. If you have questions about mechanics or sanity checks, I will be having office hours tomorrow (Friday), from 11 am - 1 pm, and the link is below:
On a different note, the early final will be on May 12, from 10 am - 12 pm, in KMEC 1-70. That room fits up to 120 people, and I don’t think that there will be a room capacity issue, but I have created a Google shared spreadsheet for that:
There will be no online option for the May 12th class, but there will be one for the May 16th exam, if you need to use it.
1. Please give the valuation of your company a try, if you are done with the capital structure and dividend sections. As I mentioned in my email earlier this week, I understand that we have not spent much time on valuation and the spreadsheet that I sent you may seem like a black box, but if you look past the complexities, it is simply an attempt to convert what you know about your company into growth, profitability and reinvestment assumptions. The rest is just mechanics.
2. When you have the numbers, please enter them in the Google shared spreadsheet. I would like those numbers by Sunday, even though your project is not due until Monday at 5 pm, NY time. And I will keep my promise and add 5 points to your overall score, when you do submit.
3. The final project is due on Monday, by the end of the day. Please submit as a pdf file and enter “The Torture Ends” in the subject.
|5/8/22||I have deliberately held back from emailing you this last weekend, since I was concerned that I would do more damage than help. I am glad to see the spreadsheet filling up with your numbers. Thank you if you have the numbers already entered, and please do try to get them in by midnight tonight.|
Thank you for getting your numbers into the summary sheet. I have the closing presentation for today at the link below:
It is part project summary, part review of the class and a closure to the class. I know that some of you have been almost entirely online for this semester, but if you can make it to class physically, please do. Either way, in person or on zoom, I will see you.
Again, thank you for sending me your summaries and helping me put together the presentation for today's class. If you were not able to make it to class, here is the link to the presentation:
In class today, we looked at the big picture of the class, using the project findings to illuminate each part from corporate governance to risk to investment analysis to capital structure, dividend policy and valuation. If you want to see the summary numbers for the entire class online, try this link:
Since the final exam covers the entire class, preparing for it can be intimidating, but here is the saving grace. The material is interlinked. Thus, preparing for the valuation part, requires you to review how you compute cash flows and cost of capital, which is from an earlier part of the class. I have a review we
You can try past final exams and check the solutions here:
I will also have an hour and a half of office hours tomorrow, for both the valuation class and those who are taking the corporate finance final exam early on Thursday.
It must feel good to have the final project done, and thank you for the work that you put into it. It is project grading week for me, and I will start with the valuation projects first, since their regularly scheduled exam is tomorrow, and most in that class are graduating this semester, before starting on grading your project. So, if you find yourself waiting, it is not because I have forgotten you. On a different note, please do finish your CFE (course evaluations), when you get a chance. It should take only a few minutes to do, and the instructions are below:
Student Instructions for Completing Online Course Evaluations
As I mentioned, I have a purely selfish reason for nagging you. If you do not finish the evaluation, you will not be able to see your grade online, and if you cannot see your grade online, there is extended pain for all of us.
As you have probably noticed, I have not sent you any emails for a few days. One reason is that I have been grading exams and projects for my valuation classes. The other is that the time for talking and nagging is done. I hope that you are getting ready for your final exam and I will have office hours tomorrow for any last minute questions:
You will also start to see your projects being returned tomorrow, in the sequence that I got them. I will return the graded project to the person who sent it to me, ccing everyone in the group.
The final exams are ready to be picked up, in two piles (early and today’s exam takers0 and I have attached the solution to today’s exam. The grades are officially in and you should be able to check them online soon. If you want to see how your scores translated into grades, put your scores into the attached excel spreadsheet (the scores in it already are for a hypothetical student, not you) and see how the grades were tabulated.
On a more general note, I want to thank you for the incredible amount of work you put into this class. I know how difficult this semester was for many of you, and that you did not sign up for a masked class, when you enrolled in the Stern MBA program. I too would have vastly preferred to teach without a mask. I appreciate how many of you managed to join me in class or on Zoom, and you made it easier for me to teach. I know that I buried you under emails (this is the 127th of the class), assignments, projects and weekly puzzles and I also know that most of you were unable to keep up. However, the material for the class will stay online and on YouTube for the foreseeable future. If you want to review parts of the class, please do go back and review the lecture, look through the notes and even try that week's puzzle. If you really, really want to master corporate finance, don't waste too much time reading books & papers or listening to lectures. Pick another company (preferably as different as you can get from your project company) and take it through the project analysis. Each time you repeat this process, it will not only get easier and more intuitive, but you will always learn something new. I still do!
I also want to thank Lianda Luo and Dylan Murphy, who were the teaching fellows for this class. I know that those of you who reached out to them for help found them to be constantly on call, and I could not have taught this class without them. In fact, if you had issues with this class, the fault is entirely mine, and they bear no responsibility for those issues. Finally, in return for reading all (many, most, some) of my emails this semester, I have something to offer in return. If you have a question in corporate finance, valuation or investments, where you think I can be of use, you are welcome to always reach out to me. Perhaps, you will come back to be tortured again next year in valuation! For the last time (at least for this class)!