Latest / The Investor With Joel Palathinkal / Vanessa Cheung: Impact Investor at Accys
Transcript
- 0:00So typically we will use two methodologies.
- 0:04The first one is multiple approach and the second one is DCF approach.
- 0:09So for multiple approach, can see here some of the metrics that we typically see and some of
- 0:14you are familiar with.
- 0:16So you can compare these metrics against a company owned history or you can compare them
- 0:22against different peer group within a different company within the same peer group.
- 0:28So I guess one of the questions that you might ask is which metrics should we use?
- 0:35Welcome to The Investor, a podcast where I, Joel Palofinkle, your host, dives deep into the
- 0:41minds of the world's most influential institutional investors.
- 0:46In each episode, we sit down with an investor to hear about their journeys and how global
- 0:51markets are driving capital allocation.
- 0:54So join us on this journey as we explore these insights.
- 1:02OneWebShow here with Vanessa Chung and, excited to have her here.
- 1:07She's a venture capitalist and impact investor, and is currently at Axis.
- 1:13So and she's gonna actually walk us through discounted cash flow and talk about how to look
- 1:21at ESG investment.
- 1:22She's a, you know, impact ESG expert, and she's gonna actually teach us stuff and go through
- 1:29financial model that she's built.
- 1:32Excited to learn from you.
- 1:34She, you know, was able to kind of, you know, run through this a couple months ago and then I
- 1:39bring her on to kind of share this with the community.
- 1:41Vanessa, thanks for being kind enough to share this with us.
- 1:45Maybe you can just spend a couple minutes just walking us through your career, your education
- 1:51and how you got to where you are now and then we'll jump into it.
- 1:54Yeah, sure, definitely, Jo, and thanks for inviting me to the show and it's definitely my
- 1:59great pleasure to be here and share my learning, especially in the public investing
- 2:03space.
- 2:04So yeah, thanks for the introduction and just a little bit about myself.
- 2:09So after university, I spent two years in equity research.
- 2:13So I was at Credit Suisse covering paper and packaging and building materials.
- 2:17So it was certainly a very great learning experience and I learned a lot from it, from
- 2:23talking to different investors, to senior management and also during a couple of site
- 2:28visits.
- 2:29So during that period, as soon as I was learning more about the pavement packaging
- 2:35industry and also the cement industry, I got really interested in sustainability because
- 2:40those industry, they emit a lot of carbons and a lot of, they use a lot of energy.
- 2:46And so there was a lot of talks amongst the investment community to to analyze which
- 2:52packaging materials is actually the most sustainable and how can they invest in more
- 2:57sustainable companies.
- 2:58So that was how I got really interested in the idea.
- 3:01And then partly because of that interest and also wanting to gain more experience working
- 3:06for corporates, I joined Access Technologies over a year ago.
- 3:10So they are a wood science technology company, very eco friendly and also fast growing as
- 3:15well.
- 3:15So I'm helping them as my role in business development, helping them to form partnerships
- 3:20and also expand to the rest of the world.
- 3:23And then as you mentioned, on top of that, I'm an investment team in Southern Capital.
- 3:29So I'm focused mainly on impact and also in clean tech, which is a fast and growing area
- 3:34and certainly very, very interesting and see a lot of different business, different
- 3:38technologies emerging currently.
- 3:40So very exciting space to be.
- 3:42No, absolutely.
- 3:43Yeah.
- 3:44Well, hey, what are your thoughts just based on the last couple months of learning?
- 3:49What are some takeaways that you would take away from just impact and clean tech?
- 3:54Yeah, sure.
- 3:55Certainly see a lot of different companies and very interesting to talk to founders.
- 3:59They all have very great vision how their products can change the world really.
- 4:05And certainly I think as you know, and the trend recently is there seems to be more talk
- 4:12about the Cleantech two point zero, which is very different from the Cleantech one point
- 4:17zero, which was in the early two thousand period.
- 4:19So it seems that investors are more focusing on companies that can generate profits as well as
- 4:25the social impacts at the same time.
- 4:27Whereas in the past, it might be more on the profit side or yeah, it's more difficult on
- 4:33that side.
- 4:34And then one trend that I'm particularly focused on is the circular economy trend for
- 4:40those that you're less familiar with it.
- 4:43Basically at the moment we are kind of consuming on a linear model where we make
- 4:49things, we consume them and then we just dispose them at the end of life.
- 4:53But actually in a circular model, it will be everything.
- 4:56The material will be in use in kind of a circular fashion where maybe after we're using
- 5:03the products, we can recycle it, we can remanufacture it, or the waste of that product
- 5:07can actually be raw material for another industry.
- 5:11For example, some companies that I've looked at, they use chicken feather to make packaging
- 5:15materials, or they can use other waste materials like plastic, ocean waste plastic to
- 5:21make other materials as well.
- 5:22So I think that's certainly something that I'm very interested in and great to see a lot of
- 5:26these innovative products coming on.
- 5:29That's great, cool.
- 5:30Well, anybody have any questions about Vanessa's career and how she transitioned
- 5:37before we jump in.
- 5:43All right, I guess we'll just go ahead and jump in and feel free to message some questions in
- 5:47the chat and I'll go ahead and try to call them out as we go, but I'll let you do your thing.
- 5:54Oh yeah, any question just please shout at any point and if I not explain it clearly as well.
- 6:00So hopefully you can now see the screen.
- 6:05Yeah, we can see it.
- 6:06Yep, that's great.
- 6:08So yeah, today I just wanted to talk about a bit about equity research, what it is, and then
- 6:14about valuation in the public stock market as well.
- 6:18So I'll walk through different methodologies and also do a case study to value Apple, the
- 6:23stock.
- 6:25And then I guess one thing to emphasize is valuation.
- 6:28As some of you might heard the phrase, it's more about, it's more of an art than a science
- 6:33in some sense because it relies on your assumptions and your judgment and what your
- 6:38view are on the company.
- 6:40So although today I'm going to show you all the tools and the resources you need, ultimately as
- 6:46an investor, you need to make that judgment yourself whether you think that company is good
- 6:50to invest, as I'm sure, Joe, you agree.
- 6:53In the VC world as well, it depends a lot of your judgment and how do you see the world in
- 6:58ten, fifteen years time.
- 6:59Yeah, absolutely.
- 7:02So yeah, firstly, just on a bit about equity research, what it is.
- 7:06So basically it's a fundamental analysis on stocks to provide investment ideas.
- 7:12So we tend to look a lot in-depth into the company's financials, the industry they operate
- 7:18in and also some of the risk involved and the valuation as well.
- 7:23So in equity research, we can split into sell side and buy side.
- 7:27So the sell side will be all the investment bank, for example, like JP Morgan or Goldman
- 7:32Sachs.
- 7:33So they will provide research reports or ideas to investors.
- 7:38And then these institutional investors who are they?
- 7:40They are the buy side clients.
- 7:42So they are the pension funds or funds in the likes of Fidelity or BlackRock for example.
- 7:48So these are the investors.
- 7:50They have actually got the capital to allocate and to invest.
- 7:54So they typically invest according to their fund mandates.
- 7:57So their fund mandates could be geographical.
- 8:00They invest in US for example, or they invest in particular sector like the tech sector.
- 8:06So teams, are usually structured by sector.
- 8:09And one thing to stress is in the sell side analyst world, they tend to focus on the
- 8:15smaller sets of stocks, for example, like 15 to 20, because the ultimate goal is to be the
- 8:19expert in your sector and in those 15 to 20 stocks and when the buy side clients they want
- 8:25some opinion advice, they will think of you and come to you for your advice and opinion.
- 8:33Just to show you what a typical equity research report looks like, So they range widely from
- 8:40very short kind of two, three pages to quite long forty, fifty, or even 60 pages depending
- 8:46on what you want to write.
- 8:47And if you want to write a really thematic industrial piece with a lot of data then you
- 8:52can write a lot about it to showcase all your analysis.
- 8:56So a typical one based on company would be something that looks like this.
- 9:01On the left here we will have the company name and the body of the tax here will mostly
- 9:08surround, will be mostly about your investment thesis.
- 9:12Why do you think that company is something good to invest in?
- 9:16And then we will have the rating here.
- 9:19So you have buy, hold or sell.
- 9:22Sometimes it depends on the company terminologies as well.
- 9:25So in this instance, it's overweight, which means buy and certainly this analyst thinks
- 9:30that twenty first Century Fox is a good stock to buy.
- 9:36And then you have your price targets which we will come on to later on how we derive that.
- 9:42And then you will also have a risk sessions and some of the valuation methodology and you will
- 9:47also include a catalyst as well.
- 9:49So this could be an event where you think, where you believe your investment thesis will
- 9:54materialize.
- 9:55So example could be if there's some new regulation coming in, then the catalyst will be
- 10:01new when regulation is launched.
- 10:03This is when your investment thesis will be materialized.
- 10:07So I'll just move on.
- 10:09Sure, I thought it'd be kind of interesting to show what a day is like as an equity research
- 10:15analyst.
- 10:16So I'll focus on the sell side first because this is mostly because this is what I'm
- 10:21familiar with.
- 10:22So usually it's quite, usually you can divide your year into two period, you will have your
- 10:27normal period and you also have your earning season.
- 10:31So during normal period is actually very, very early in the morning, we go to work, we arrive
- 10:36at our desk at 7AM to catch up all the news and this is when all the big announcement will be
- 10:42released.
- 10:42So you need to be ready if in case anything happens in the stocks that you cover.
- 10:48If you publish your research overnight, then you'll spend your morning meeting with your
- 10:52sales and you also call clients afterwards.
- 10:55And then the rest of the day, it really varies.
- 10:58It can be, you can continue your research work whether they are big industry reports or
- 11:03company updates or you can meet with clients or you can speak to a company or industry
- 11:08consultants in order to get a more updated view or the recent view on some of the trends that
- 11:13is happening in your sector.
- 11:16So this is the normal period.
- 11:17And then during earnings season which public companies they usually announce their results
- 11:22four times a year to update their investors.
- 11:26So it can be quite hectic sometime.
- 11:28So at 7AM they will release their earnings to show this is the revenue or this is the
- 11:33financial they achieved in the past quarter.
- 11:36So your goal is to quickly digest the news if there is anything, any surprise or if they
- 11:41perform according to your expectation.
- 11:43And then you will quickly update clients sales on your view.
- 11:47And then at 9AM is usually when the company will present.
- 11:50So you will have the CEO, the CFO and the senior management of a company present their
- 11:55quarterly results.
- 11:57And then there will be also a Q and A session for the analysts to ask questions as well.
- 12:02And then for the rest of the day, you'll spend your time digesting the news, thinking about
- 12:08updating your company model if the news today affects your forecast of the company and
- 12:14publish a new view.
- 12:15So this is kind of a overview of the job nature and also a day in the life of an analyst.
- 12:24And then something that I just wanted to touch on quickly is about sustainable and ESG
- 12:28investing which is fast and growing.
- 12:31Recently in recent years, I'm sure a lot of you have heard the phrase ESG which stands for
- 12:37environmental, social and governance.
- 12:39And certainly it's a big area and there are different strategies within the ESG investing
- 12:44space.
- 12:45So I just wanted to quickly introduce some of these ideas.
- 12:49Certainly there are more resources and I can spend kind of the next hour talking about it
- 12:53but this is just more of a high level summary.
- 12:57So on the right here, you can see there is a spectrum different strategies.
- 13:06You can go from financial only to impact only.
- 13:10So this will be just kind of normal traditional investing where you consider all the financial
- 13:14results.
- 13:15And then here you gradually incorporate more and more different kind of ESG factors into
- 13:23your investment consideration.
- 13:25And then on the right here, it'll be kind of like a charity or you give out donation or
- 13:31grants where you only focus on the impact and then you don't really care about the financial
- 13:36return it generates.
- 13:38So kind of the ESG investing is sit within these areas where we want to do good for the
- 13:44society but then we also want to generate a financial return.
- 13:47And there are various strategy within the ESG investing space.
- 13:52And nowadays we see more data providers starting to provide these type of information.
- 13:58So we've got MSCI and also Sustainalytics which I think recently got acquired by FactSet.
- 14:07So they are companies that provide a lot of the sustainable data.
- 14:11For example, it's a bit like a credit scoring.
- 14:13So for example, I know that MSCI, they're a great company from CCC to AAA according to
- 14:20their scores on ESG.
- 14:22So if the company scored AAA then they will be doing very great on all the ESG different
- 14:26metrics.
- 14:28So how investors use these data?
- 14:31They can use it by negative screening or they can by kind of screening the bottom by
- 14:37screening out the bottom 10% of the company or they can do positive screening by screening in
- 14:43the top 10% of the company that performed well under these metrics.
- 14:49And then we also have other strategy like thematic investing where investor only invest
- 14:54in renewable energy for example, or they only invest in electric vehicle.
- 14:59And then at the far end we also have impact investing.
- 15:02So this is a strategy that mostly more commonly seen in private equities or financial capital.
- 15:10So it is about investing in companies that generate positive impact in social terms of and
- 15:17environmental footprint.
- 15:20So here you'll be actively seeking companies that do good for society whereas ESG sometimes
- 15:26it can be a bit of a screening exercise.
- 15:30So yeah, certainly an emerging area and there are lots of new funds that are launching and
- 15:35also different strategies as people are starting to incorporate a lot of these
- 15:40consideration into their investment strategies.
- 15:44Any question from now?
- 15:47Or I'll move on to the main topic for today which is about valuation.
- 15:56So yeah, typically I'll mostly focus on valuation within the public investing space.
- 16:02So typically we will use two methodologies.
- 16:06The first one is multiple approach and the second one is DCF approach.
- 16:12So for multiple approach, you can see here some of the metrics that we typically see and some
- 16:17of you are familiar with.
- 16:19So you can compare these metrics against a company owned history or you can compare them
- 16:25against different peer group within a different company within the same peer group.
- 16:31So I guess one of the questions that you might ask is which metrics should we use?
- 16:36And a lot of the time it depends on the company and the type of investor you are.
- 16:40For example, if you invest in technology company and maybe they are very early stage and
- 16:46they don't even have earnings.
- 16:47Yeah, for example, like Uber or Lyft, they generate that income yet.
- 16:52So you can't really use price to earnings ratio.
- 16:56Investor would typically use divided by sales as a metrics to evaluate those companies.
- 17:04And for example, if you are a income investor, you care a lot about dividend, then you will
- 17:10use dividend yield as your analysis.
- 17:12But in reality, we look at all of them and then we just kind of see what is most appropriate
- 17:22according to the company or the sector that you look at.
- 17:25So this is kind of a, on the right here is a typical comparative table that you will see in
- 17:31a lot of the research reports.
- 17:34So firstly, for example, if you want to analyze the beverage sector and you will have a peer
- 17:42group, so the first step will be to identify all the relevant peer groups.
- 17:46So you've got like Coca Cola here, PepsiCo, and Monster Beverage here, for example.
- 17:52And then you will compute all of this data so you can find them on either Bloomberg FactSet
- 17:58or Yahoo Finance, for example.
- 18:01And then you will compute the multiples.
- 18:04And then you will think about, oh, why is Coca Cola trading at a premium compared to PepsiCo?
- 18:10Is this fair?
- 18:12And if this is not fair, then is there any reason that can justify that?
- 18:16Or that, I guess that kind of thinking process can inform your investment thesis.
- 18:23For example, if you think that PepsiCo, that seems to be able to grow much quicker or they
- 18:30have a new strategy that you believe they can execute on it, that maybe PepsiCo should be
- 18:36trading kind of closer to Coca Cola.
- 18:40And then that will kind of, that thinking process will kind of inform your view on the
- 18:44company whether that valuation is fair or not.
- 18:47So yeah, I think this is a quite good approach very quickly that you can see if there is any
- 18:54kind of mispricing in the market or if you can justify these gap between the companies.
- 19:01But yeah, I'll come back to this again when we go through the Apple case study.
- 19:09And then the next valuation method is DCF which I'm sure a lot of you have heard of before.
- 19:17So what a DCF is to calculate the valuation of a company and what is a valuation of a company
- 19:24is essentially you add up all the future free cash flow a company generates and then you sum
- 19:30it all up and then discount it back to today's price.
- 19:33So it's a bit like the graph here.
- 19:36So firstly you project all the free cash flow in each year and then because you can't really
- 19:42project it infinitely so at the end of the period you kind of have a terminal value and
- 19:46then you sum it all up, discount it back to today's price.
- 19:50So this will give you an enterprise value which is the total value of a company.
- 19:55And obviously there are different owners for a company.
- 19:57You've got the debt or the debt provider, you've got the equity provider and other
- 20:02minority interests as well.
- 20:03So as an equity investor, you are most interested in the equity portion.
- 20:08So you minus debts, you minus the monetary interest and you'll get to your equity value.
- 20:14And then if you divide that equity value by the number of shares, you will get your share
- 20:18price.
- 20:19So fundamentally this is kind of the concept of it but I'll show you the calculation step by
- 20:24step in our case study later.
- 20:29So yeah, these are just some of the formulas in order to derive exactly what these things are.
- 20:35But yeah, I'll show you in our Excel model go through later on.
- 20:44And then just some kind of thinking about the pros and cons for each method.
- 20:48In real life, we will use both the multiple approach and DCF approach.
- 20:53Usually some analysts, they would take an average of these two approach because each of
- 20:59these approach, they have their pros and cons.
- 21:02For example, the multiple approach, you can see that it's really easy to get all the datas.
- 21:08It relies on fewer assumption, but then sometimes it's really hard to find the
- 21:12comparable companies.
- 21:14For example, for Apple that I'll come on to later on, it's kind of hard to think of another
- 21:18company like Apple.
- 21:20I mean, you've got other software internet company like Microsoft or Google, but they are
- 21:25more of an internet company and they don't really produce a physical product like Apple.
- 21:29So finding a comparable group is sometimes it can be tricky.
- 21:35And now on the DCF side is very flexible.
- 21:38You can model a lot of things into it.
- 21:41You can even split it out into multi stage growth for the company.
- 21:47So you can incorporate a lot of the assumptions, but then the cons will be based on
- 21:52a lot of assumptions and the sensitivity of the share price will be based on the assumption and
- 22:01also on the terminal value as well.
- 22:03I think DCF will work particularly well for very stable company.
- 22:07For example, like Unilever or Coca Cola perhaps because they are the companies that generates
- 22:14certain amounts of cash each year.
- 22:15So it's very easy to forecast.
- 22:17But then if it is a highly cyclical company, it's very difficult to forecast the kind of
- 22:23company performance throughout the business cycle.
- 22:26And then in a startup world it's even more difficult because it's very difficult to
- 22:32forecast the company in kind of a five to ten years horizon.
- 22:36So these are kind of the pros and cons for the two approach.
- 22:41And now if there is no question at this point, I'll move on to our case study on Apple.
- 22:51Yep, so I choose Apple as an example because all of us know what they do and that we can
- 22:59quickly see use the method that we learned so far and apply it to calculate the share price
- 23:05of Apple.
- 23:07One thing is to stress is this is more of a kind of an exercise rather than any investment
- 23:12advice.
- 23:13So it's more about going through the methodology that we learned in order to
- 23:17calculate the share price for Apple.
- 23:21So yeah, some background news recently.
- 23:24I guess, yeah, you can see from this chart although it's PE ratio rather than the share
- 23:28price but the share price kind of correspond quite nicely to that as well.
- 23:33You can see from January 2020 they have a very good run or year to date the share price goes
- 23:39up by 40% which is a very, very good return.
- 23:43And recently as most of you know, they announced some product release including the
- 23:49new iPhone, the five gs version, which kind of contributed some of the spike here.
- 23:56And then last week they announced they had an earning release which after that the share
- 24:01price kind of drops.
- 24:03So it could perhaps be, yeah, it kind of reset investor expectation or they have some other
- 24:09concern regarding the company future performance.
- 24:12Some of them could be due to COVID or some of them could be due to because they decided to
- 24:17delay their five gs phone launch by a few months.
- 24:22So that could impact on their company performance.
- 24:26So yeah, firstly just using the technique that we've learned so far, the first one will be the
- 24:31multiple approach.
- 24:32So you can use multiple approach to compare the company with its own history.
- 24:39So this is exactly what I did here.
- 24:41So you can see on a PE ratio perspective, the company they have been historically trading at
- 24:47about 10 times to 12 times PE ratio.
- 24:50But then recently it seems that they have gone up really, really massively and they have now,
- 24:54I know it's a bit small here, but they are now trading on a 28 times earning next year.
- 25:00So I guess as an analyst, need to think about, what's behind the driver of this increase?
- 25:10Is it fair or are we overvaluing the company?
- 25:13Has there been some fundamental changes to the business itself?
- 25:17And then we can see a similar trend for EVEBITDA ratio as well.
- 25:21It has gone up massively last year.
- 25:25And that another approach will be to compare the different ratio against some of the peer
- 25:33group for Apple.
- 25:35So in here I've chosen Microsoft, Google and Facebook.
- 25:38Although I guess some people would argue they are not a true representative of peer group,
- 25:44but I just show it as an illustrative example.
- 25:48So we look at, so Apple is the blue color here, whereas think it might be quite interesting to
- 25:55compare against Microsoft which is the red color here.
- 25:59So you can see that Apple has traditionally been trading as a discount to Microsoft And
- 26:06some of the reason could be because Microsoft as a more software company, they typically have
- 26:11high margins.
- 26:13They can also scale quicker rather than compared to Apple which they produce a tangible
- 26:18product.
- 26:19So this is kind of the reason why there has been a valuation gap between a company.
- 26:24So this valuation gap kind of lasts until 2020.
- 26:29And then this is kind of the COVID period.
- 26:31And then after that it seems the gap has shrunken.
- 26:34So now Apple has been trading very in line with Microsoft as well.
- 26:40So a question to think about will be, again, is this justifiable?
- 26:45Do we think the market is overvaluing Apple or has there been some fundamental changes to the
- 26:52company itself that investors seems to be placing a higher valuation on the stock at the
- 26:57moment?
- 26:58So again, a similar story for EVEBITDA as well.
- 27:03Oh, and then I think I can now show you on the DCF model, how do we actually calculate the
- 27:12share price?
- 27:15So if I just switch to model.
- 27:27Yeah, if I make it slightly larger.
- 27:33Okay, so just to recap the formula, DCF we want to forecast all the free cash flow for the
- 27:43company.
- 27:44We want to sum them up and we also want to include a terminal value and then we discount
- 27:49it by a discount factor called WACC.
- 27:51So we will go through these all step by step.
- 27:56So firstly, will want to forecast the free cash flow firstly, which is this is the formula for
- 28:02it.
- 28:02Essentially, you just want to add up all the cash item that a company generate per year.
- 28:08So for example, why do we want to add back depreciation and amortization because they are
- 28:13not a cash item.
- 28:15Why do we want to minus CapEx?
- 28:17Because CapEx is the actual capital expenditure you spend per year.
- 28:21So we want to minus that.
- 28:23So it is a cash outflow and that's definitely we want to minus that.
- 28:27So in here I did exactly that in this calculation here.
- 28:33So I'll have my EBIT here which is just revenue minus the operating cost.
- 28:38So I base it all on twenty twenty actuals.
- 28:42So my starting point is this year and then I'll forecast it what will the business be like from
- 28:48year one to year five, for example.
- 28:52So just on the formatting, you can change all the cell in yellow.
- 28:57So you can change all of them here and then all of these should just calculate automatically.
- 29:03So if you want, you can change it to another company and you should be able to populate
- 29:07their share price quite quickly as well.
- 29:11So yeah, just on the forecasting.
- 29:12So firstly we wanted forecasted revenue item.
- 29:15So these are the assumptions that I choose.
- 29:18It's kind of arbitrary at this point because if you want to form a informed view, would need to
- 29:24go through the company financials and also do a lot of in-depth industry and company research.
- 29:31So at the moment I just assume the company will grow by 15% next year just because of the new
- 29:36iPhone launch and then assume a 5% growth afterwards.
- 29:41For EBIT margin, I assume they will gain by 1% next year and then kind of just grow at a slow
- 29:48rate in future period.
- 29:51For the items, I just keep them flat for now so that we can focus more on the calculation
- 29:57rather than the assumption at this point.
- 29:59So this is exactly how I calculate the unlevered free cash flow as I was showing in a
- 30:04formula by summing all these items together.
- 30:09And then you want to discount this free cash flow back to today's value and that this form
- 30:15the first part of our calculation which is summing the cash flow from year one to five.
- 30:22And then for a terminal period, we have two methods that we can use.
- 30:28So going back to the formula here, we can either use the exit multiple or the perpetual
- 30:36method.
- 30:37So the exit multiple, just say, imagine Apple get acquired in five years time, what would the
- 30:45multiple be and what is the value of the company at that point?
- 30:49Another perpetual method is just rather than summing it all these up individually, it is a
- 30:56mathematical neat way of saying summing from period three at this point to period end, and
- 31:04then this is a mathematical equivalent to that, which is you have the end period free cash flow
- 31:12for the end year period, you do one plus the growth rate and then you divide up by the WACC
- 31:18minus growth rate.
- 31:20So going back to the DCF, this is exactly what I did.
- 31:25So go through the multiple exit multiple method first.
- 31:29So I take the end year period and the EBITDA for year five, And then I assume an 18 times
- 31:37exit multiple.
- 31:39I mean, can change it to other multiple, but I think this is kind of appropriate just by
- 31:46looking at historical trend and kind of comparing it with peer group.
- 31:51So, I choose 18 times in this calculation here.
- 31:56And then for the perpetual growth, so this is the calculation that I was showing earlier.
- 32:03So, you do the free cash flow for the n year period, multiply it by the growth rate which I
- 32:08assume is 3% terminal growth rate and then you do the WACC minus the terminal growth rate.
- 32:17We have been through this calculation and then the final session will be how do we come up
- 32:25with the discount rate.
- 32:27So what the discount rate is, so it's called the weighted average cost of capital.
- 32:31It is kind of showing yeah, it's kind of showing the capital structure of a company
- 32:38because usually for a company they will require some equity and also some debts and this is
- 32:42just the cost of that capital, how expensive or how cheap it is in order for them to access
- 32:48that capital.
- 32:50So it's kind of a weighted average calculation.
- 32:53So I can go through the calculation here at the end, which you can see on this session here,
- 33:00the WACC calculation.
- 33:01So firstly, on the cost of equity, this is the calculation we typically use.
- 33:09So we will use the risk free rate and then we plus the beta times the equity risk premium.
- 33:14So that's our cost of equity.
- 33:16And then on the cost of debt side, this will be the interest rate the company paid minus the
- 33:23tax rate.
- 33:25All of this information you can get either from Yahoo Finance or the company financials itself.
- 33:32And then on the proportion of debts and equity, so this is the debt Apple has last year and
- 33:39then this is the market cap at the moment which is part of the equity.
- 33:43And then throughout this calculation, I calculate a WACC of 7.9%, kind of like 8%.
- 33:51So we are going back to here.
- 33:53We now talk through how do we calculate the terminal value and the free cash flow for the
- 34:02initial period.
- 34:03So this will be our enterprise value.
- 34:06And then now, as I was showing earlier, we need to minus the debts because as an equity
- 34:11investor, we are only interested in the equity portion.
- 34:14And we also add that cash, which is the cash that we can access to as an equity investor.
- 34:20And then we divide it by the number of shares Apple has.
- 34:24And then based on these assumption, I calculate that Apple should The kind of the equity value
- 34:31for Apple is $98 per share.
- 34:36So yesterday when I was looking up, they were trading at 109 yesterday.
- 34:41So this is just that based on these assumptions, it would suggest a 10% downside.
- 34:46But obviously you can change these assumptions really quickly.
- 34:48For example, if you think Apple next year will be growing by 20%, you can quickly change that
- 34:55and then you can see the valuation going up.
- 34:58I mean, if you're not positive about the iPhone launch then you can change it to 3% that will
- 35:06show you some more downside to the current share price.
- 35:10So all of this, you can quickly see how as an investor you can calculate based on DCF the
- 35:16valuation of company really quickly.
- 35:19Any question at this point?
- 35:23Yeah Vanessa, the blue cells, the ones with just the blue text, are those just cells that
- 35:29are referencing another cell or can you adjust those too?
- 35:33Yes, that's right.
- 35:34So yeah, it's just referencing another cell.
- 35:37So these are the calculation that was done.
- 35:39So all of the yellow ones you can change and other ones, it just automatically calculated.
- 35:45Cool.
- 35:47So hopefully it will be, this is a very step by step walkthrough of this calculation here.
- 35:56But I guess just to emphasize the concept is just to add order of cashflow for a company and
- 36:00then discount it backwards.
- 36:02That's the high level of what this is trying to do.
- 36:07And then here you can see the sensitivity because I was talking earlier about how the DCF
- 36:13methodology depends a lot of the assumptions.
- 36:16So this is just a sensitivity table that I thought we useful to show.
- 36:20For example, at the moment we assume about an 8% WACC and also a 3% terminal growth rate,
- 36:27which makes our price at about a 100 at the moment.
- 36:31But then if we increase our terminal growth rates and if we decrease our WACC, we can
- 36:37arrive at this price kind of based on these two assumptions.
- 36:41So I think this is just a good way, especially if you are an investor, want to have that
- 36:46sensitivity analysis and to make sure you're comfortable with the evaluation that would
- 36:51gives you a potential upside.
- 36:57So this is the DCF method and then back to the multiples method I was talking about earlier.
- 37:05This is again, you can play around with it based on the assumption that you choose.
- 37:10For example, if we use a EVEBITDA method, so this will be the Apple's EBITDA for next year
- 37:18and that if we believe they can trade, they will trade at an 18 times multiple, then I can
- 37:24type in 18 times here.
- 37:26And then you can see based on these assumptions, it will suggest a 12% downside to
- 37:29the current share price.
- 37:31But then if I believe that Apple's, they can sustain a high multiple, for example, two, then
- 37:37it will show you the upside that you can generate.
- 37:41And I think this is particularly useful sometime when I evaluate some of the startup
- 37:46deals as well, because ultimately this will give you a valuation when you want to exit and
- 37:53then you can work backwards to see how much valuation upside you can gain as an early stage
- 37:58investor.
- 37:58And as the company progress, what is the valuation they are likely to achieve And then
- 38:05what is the potential there are for foreign investors?
- 38:13So yeah, this is just a quick walkthrough of the model.
- 38:20Something that I was thinking about showing as well unless there is other question at this
- 38:25point.
- 38:28Any questions guys?
- 38:37So yeah, some of these information I got from KoiFem which is a free platform for people to
- 38:43use.
- 38:43It's bit like Yahoo Finance but I think it's more, it has got more data and also the user
- 38:50interface, quite like it as well.
- 38:52Because earlier I was talking about the com table and how does Apple compare to other
- 38:57comparison, for example.
- 38:59And then in this table here, select all the peer group.
- 39:03And then you can see that, for example, if I go to the margins, Apple, they have been Their
- 39:10EBITDA margin was about 30% last year.
- 39:13But now for Microsoft, which is a software company, they are a 45%.
- 39:19So maybe part of the valuation gap can be justified by just the fact that Microsoft has a
- 39:23higher margins, for example.
- 39:26So this is quite a neat way to show some of the differences in valuation and whether you think
- 39:34is justified.
- 39:36But yeah, I thought that would be interesting to show.
- 39:38For example, Microsoft, they pay a high dividend, which sometimes investors like as
- 39:43well.
- 39:43And that will certainly be factoring into the high valuation.
- 39:53That's great.
- 39:54Cool.
- 39:55What are some of the pros and cons with Koyfin versus some of the other tools?
- 40:02I think maybe what would be helpful if we got a few minutes is what tools you can use, whatever
- 40:08you're allowed to share when you do research.
- 40:10Because we got Koyfin, got Bloomberg, we got Thompson.
- 40:15Coyfin, I think they're a startup, but obviously they haven't been around as long as
- 40:22some of these older companies.
- 40:24So what are some of benefits?
- 40:26Then maybe a couple of workflows that you do when you're researching maybe a new public
- 40:31company.
- 40:32Yeah, sure.
- 40:34I think maybe what should we, we can do a test one for example.
- 40:42So yeah, I really like the Khoefan platform because it gives me a lot of data points.
- 40:48So for example, I think that the platform, it looks a bit like Bloomberg or Reuters, but I
- 40:55think for a retail investor like myself and some people in the audience, we don't have the
- 41:00access for Reuters or Bloomberg because they are typically for institutional investors.
- 41:05So I think Koinfen is a very good alternative for retail investors like ours.
- 41:10So it has all the essential information you need.
- 41:14One session that I really like as well is the estimate session because in here you can see
- 41:19what do analysts and people in the investment banking world, they forecast in terms of the
- 41:29revenue, EBITDA or EPS.
- 41:31So you can know that what been for, what been, what is the expectation of this company?
- 41:37Because usually when company, when they underperform the expectation that share price
- 41:45would come down.
- 41:46If they over perform, they over deliver then share price would go up.
- 41:50So this is a very quick way for you just to see what is the expectation embedded in the share
- 41:56price at the moment and then whether you think it's justified or not.
- 42:01Also like the chart sessions because here you can input other security as well.
- 42:09So some of the charts I was showing I generated on Poison.
- 42:14What is a good stock to choose?
- 42:22Maybe I'll show some packaging company that I'm more familiar with.
- 42:27So for example Crown, they are a metal beverage can company.
- 42:34So you can quickly see their price movement here.
- 42:37And then if I want that valuation then I can quickly select the valuations and go into kind
- 42:44of the EVEBITDA multiple.
- 42:46I can compare it very quickly with another metal beverage company and see the valuation
- 42:51gap, for example.
- 42:53So again, this is very easy to show.
- 42:57And I guess the major benefit of Kotlin is free to use, or at least for now, not sure if they
- 43:03are going to charge in the future.
- 43:06And then just some workflow or other resources that I use, I typically go on to, so if I'm
- 43:12researching a new company, would typically go to the investor relations page, I'll download
- 43:17their annual report and see the latest earnings because through that you will see the latest
- 43:23trends that the company is going through, how are they performing against expectations and if
- 43:31they have any new strategy and things like that.
- 43:33And usually in annual reports you can find lots of detailed information on the industry
- 43:38structure, some of the trends, some of the driver as well.
- 43:41So it's very useful information.
- 43:43And then other than that, I'll just go onto this platform and then quickly look at the
- 43:48valuation side.
- 43:49If I think the valuation potential, then I'll do more in-depth research.
- 43:54If I think the company is kind of fairly valued, then I'll just put it on one side and
- 43:58then focus on other companies.
- 44:01And I think sometime maybe for our cohorts and the startup invest VC investors as well.
- 44:09Some of the things that might be useful is just to, because sometimes you ask us what is the
- 44:16potential upside or potential exit that our company can have.
- 44:20So you can quickly go to the platform that I was showing earlier.
- 44:26You can get a list of companies.
- 44:28You can see that exit multiples, which could inform you what are the multiples that the
- 44:36company in the sector are trading at the moment.
- 44:38And from there you can work on your potential exit opportunity for a startup.
- 44:47So yeah, this is poison.
- 44:52Great.
- 44:53Yeah, that was helpful.
- 44:55All right.
- 44:55Any other questions from the audience?
- 45:04Okay, I guess it was so informative that that you answered everybody's questions already.
- 45:10Yeah.
- 45:11I'm just thinking of exiting.
- 45:15Oh, stop sharing.
- 45:16There you go.
- 45:17Okay.
- 45:17I can now see you.
- 45:18Yeah.
- 45:19There we go.
- 45:19Well, good job.
- 45:20Thanks so much for sharing that info.
- 45:21That was really helpful.
- 45:24I think it's a good overview of just kind of playing with the models.
- 45:27And I uploaded the links to the deck and the models so people can play with it, know, make
- 45:33your I guess for your recommendation, somebody should make a copy of the Excel and possibly
- 45:39look up a different company and plug in the numbers and then make some assumptions on how
- 45:44much the company is going to grow.
- 45:46Yeah, that would definitely be my recommendation.
- 45:49You can also choose your favorite company, a company that you're familiar with, and then
- 45:54just see if the valuation is what is expecting, the company is currently trading at the moment,
- 46:00just to see what the assumption is like and get a feel of it.
- 46:06That's great, cool, awesome.
- 46:07High
- 46:10level, but then if people are interested, there are certainly more advanced models that we use.
- 46:16Typically for DCF model, we will we will break down the revenue by segment, for example.
- 46:22So for example, in the case of Apple, then we will break down the revenue for iPhone, for the
- 46:29iWatch and different components of it.
- 46:31We will also forecast the profit by segment as well because that way you get a more detailed
- 46:39analysis and detailed forecast which ultimately drives the valuation.
- 46:44You all want to have those details in if you are doing it in real life or as career or
- 46:51profession.
- 46:52In the private markets, look at comps.
- 46:55Do you guys also do that as well?
- 46:57Maybe other consumer electronic companies, if you're looking at Apple, as far as their EV to
- 47:06equity multiple?
- 47:07Is that kind of a common practice?
- 47:09What's the best way to do that?
- 47:10Do you just take the average of the comps of what their multiple is and then just kind of
- 47:14use that as a benchmark?
- 47:17Yeah, yeah, we will certainly do that as well.
- 47:19And it depends on how closely comparable how comparable those peers are.
- 47:28Some people just use an average or some people will choose some particular company as
- 47:33benchmark and average.
- 47:35I think that certainly works well for some industry but less so for others.
- 47:39Yeah, I mean in a commodity company like metal packaging, for example, essentially every
- 47:47producer, they are producing the same amount, same type of products.
- 47:51So you can argue they should be trading on a similar multiple because essentially the
- 47:56business are the same.
- 47:57But then I guess there are other nuances like different company strategy, different
- 48:00geographical region that they are exposed to.
- 48:03So a lot of these factors can be, you can incorporate as well.
- 48:08So definitely a very fun exercise and yeah and I guess I've seen some stats saying that people
- 48:15nowadays because guess everyone kind of in the lockdown period there's been some spike in
- 48:22either like Robinhood in US or in The UK we use Free Trade or other apps like that.
- 48:29So there has been a spike in retail investor investing or have the time to at least explore
- 48:34the opportunity.
- 48:35So that's quite interesting.
- 48:36Good news for Robinhood, right?
- 48:39Yeah.
- 48:41Cool.
- 48:41All right.
- 48:42Well, anybody else have any final questions before we close out?
- 48:48Cool.
- 48:48I guess not.
- 48:50Well, thanks for your time and catch up with you guys soon.
- 48:54Cool, sure.
- 48:56And thanks for everyone here and looking forward to speaking to you all and get
- 49:01connected.
- 49:03All right.
- 49:03Bye guys.