0:00 The markets have been
0:00 falling from its highs
0:02 from December 2021,
0:03 and we are looking at
0:05 a recessionary environment
0:06 where there are so many good companies
0:08 at extremely cheap prices.
0:10 Today we are going to discuss
0:11 how to find the fair value of the stock
0:13 in the same way that Warren Buffett does.
0:15 Well, intrinsic
0:16 value is what is the number
0:20 that if you
0:20 are all knowing about the future
0:23 and could predict all the cash
0:25 that a business would give you between
0:27 now and Judgment Day
0:29 discounted at the proper discount rate,
0:32 that number is what
0:33 the intrinsic value of a business it.
0:35 So what Warren Buffett does
0:37 is he uses a discounted cash flow model.
0:39 So what I'm going to do
0:40 is start with an example.
0:42 So this is a simple Excel
0:44 spreadsheet template that I have created.
0:46 Don't be worried about the numbers
0:48 as of now.
0:49 I'll explain to it
0:51 in very simple English
0:52 so you guys can understand
0:53 it as easy as possible.
0:56 You can download this template
0:58 from the description box
0:59 so you guys can play around with it
1:01 and put in any numbers,
1:03 put in any stock data
1:04 and get the intrinsic value calculator.
1:07 Okay.
1:07 So let's start
1:08 with these For discount rate
1:10 growth rate,
1:10 we're going to ignore all these things.
1:12 As of now,
1:12 just we're just going to do the ticker,
1:13 which is basically Apple.
1:15 We're going to focus on
1:15 Apple stock as of now,
1:17 the share price
1:18 and the outstanding shares
1:19 can be gotten from any data feed.
1:21 I'll use QuickFS and also gurufocus.
1:24 There's also Google Finance and Yahoo!
1:27 Finance and many other information.
1:28 So if you can go to Gurufocus
1:30 and go to ownership,
1:32 you will get the number
1:34 of shares outstanding,
1:35 which is what I have plugged in here.
1:38 And obviously the share price is what?
1:40 And so you can go into the cash
1:42 flow statement.
1:42 You've seen the cash flow
1:43 from operations.
1:45 So if I can go to the quick FS,
1:47 then go to cash flow statement, so
1:50 QuickFS is free
1:52 so you can get all these data for free.
1:53 So I'm taking the past five years
1:55 data of cash from
1:56 operations that's right here
1:59 and paste data here.
2:02 And then is CapEx,
2:03 which is short form
2:04 for capital expenditure,
2:05 which is basically expense
2:07 of the property plan and equipment.
2:09 I've taken that one
2:10 and I have pasted here,
2:11 which is an expense.
2:13 And then free cash flow
2:14 is basically the difference of this one
2:16 and this one since already it's negative.
2:18 Ali, I just have to put in some here.
2:20 So 77
2:21 -13 and gives you a 64
2:23 and that is basically our free cash flow.
2:26 So this is a free cash flow
2:27 slash discount cash flow model.
2:30 The growth rate of the free cash flow
2:32 is basically the final value divided
2:35 by the first value to the power.
2:37 The number of years, of this one,
2:38 we have taken five years
2:40 minus one,
2:41 and that gives you the growth rates.
2:44 So we've also got the earnings,
2:45 which is a net income,
2:46 which again, I'm copied
2:47 from the income statement.
2:51 You can just
2:52 go down in the net income statement,
2:53 you can get the values here.
2:55 So we're not going to use much
2:56 about the earnings or the net income.
2:58 But I'll come back to why
2:59 we have copy paste of this
3:01 so you guys can use it later.
3:03 So what's the difference
3:05 between a cash flow and earnings?
3:07 So basically
3:08 cash flow
3:08 is like the actual cash
3:09 that comes in goes through you.
3:11 So let's say your boss pays you £10,000
3:14 this month.
3:15 A On paper he might have paid £10,000.
3:17 So that would be reflecting the earnings
3:19 or on theory, I mean, practically,
3:22 he probably might not have paid it,
3:24 like he might have just given you £8,000
3:26 and told you, Hey, man,
3:26 I'm going to pay you back
3:29 next week or something like that.
3:30 The rest are £2,000, so
3:32 the cash flow will show
3:34 £8,000 is coming into your wallet
3:35 and £2,000 is yet to come.
3:37 So that is why people, including Warren
3:40 Buffett and value
3:41 investors like Bill
3:42 Ackman and Charlie Munger
3:43 and everybody focus on the cash flow
3:45 because that shows the actual amount
3:47 that has come and gone.
3:49 So cash flow from operations
3:50 is like if you're running a restaurant,
3:52 whatever money
3:52 you made from the restaurant,
3:54 from the sales of the restaurant,
3:55 that is the cash flow from operations,
3:57 cash flow from financing activities
3:59 will be
3:59 whatever came from like banking or,
4:03 you know, loans and debts
4:04 and all those things
4:05 that comes from the cash, from financing
4:08 and then cash from
4:09 investing is basically,
4:10 you know, the capital expenditure
4:11 or acquisitions and investments
4:13 and all those things.
4:14 So we will just be focusing on cash
4:16 from operations and CapEx
4:18 and the growth rate.
4:19 So now I'm going to put in the final
4:22 free cash flow here, 11443 equals.
4:25 So this one here.
4:27 Okay.
4:28 So we've got that values at year
4:29 one free cash flow.
4:31 So what is the present
4:32 value of it after one year?
4:34 So what happens
4:35 is that every year
4:36 the purchasing power of your $100
4:39 or whatever you have goes down.
4:40 So let's say you have $100
4:42 today, that's $100.
4:43 Ten years from now, it's not worth $100.
4:45 It might be worth
4:46 just one third of that value.
4:47 And that's
4:48 where the discount rate
4:49 comes into perspective.
4:50 So that is basically you take this one
4:53 and you divide it by that discount rate
4:55 to one plus 10%
5:00 to the power.
5:00 It's just one year.
5:02 So after year one,
5:03 the free cash flow is going to be that.
5:05 So 101.
5:06 So you can see
5:06 the number has reduced
5:07 from 111 to 101 311 for me too.
5:11 So I'm going to do a small
5:12 tip for you guys.
5:13 I'm just going to put in a dollar here.
5:14 So because that discount
5:16 rate is a constant,
5:17 so we've got the free cash flow here
5:19 and you've got the present value,
5:21 which is the discounted
5:22 value of the free cash flow.
5:23 So what happens in year two
5:25 is that every company
5:26 goes to a growth rate
5:27 and that's what we've calculated here.
5:28 We've got roughly 0.7,
5:30 only just basically 2%.
5:32 So putting growth rate of 12%
5:34 for the first
5:34 five years and growth
5:35 rate of 12% for the rest
5:37 five years as well.
5:38 So what happens is that this free cash
5:40 flow will grow next year.
5:42 So all I need to do is one plus
5:44 dollar, one plus this one here
5:49 and that's it.
5:50 I'm just going to give it a dollar sign.
5:53 Just put that a constant for
5:54 the first five years,
5:55 the growth rate is pretty much
5:58 I forgot to put the asterisk
6:02 here.
6:03 So next
6:03 year, the year free cash
6:05 flow will be 124,000.
6:07 I'm just going to do this
6:08 for the next five years,
6:10 so let's see if it has gone through.
6:11 Well, yeah.
6:13 139 156 175
6:15 So from year six
6:16 we're going to use another value.
6:18 So I'm just going to put this one here
6:20 and instead of be seven,
6:22 eight is going to be B eight,
6:27 drag all this thing down
6:30 and basically you have got
6:32 the free cash flow for the next year.
6:34 So obviously the present value
6:35 has to be reflecting as well.
6:37 So I'm going to drag this down as well
6:42 today
6:42 because you've got the present value.
6:44 So you can see that 300,000
6:46 which we are going to receive
6:47 ten years from now, is
6:48 basically just 119,000.
6:50 When you factor in the discount rate,
6:54 then what we need to do is
6:55 we can keep on doing this
6:56 the next ten years, 11
6:57 years, 15 years, 20 years.
6:59 So there's no point doing it
7:00 continuously for a substantial long time.
7:01 So what we do is we take the final value
7:04 and we multiply it
7:06 with the terminal value
7:08 that is number ten.
7:10 So this can be 15,
7:11 20 or five or eight up to you.
7:13 Universities have done a lot of research.
7:15 We just going to take
7:16 a rough measure of ten.
7:18 As of now,
7:19 it depends on your risk metric,
7:22 which we'll discuss in a bit.
7:23 We also need the present value
7:24 of that one as well.
7:25 So I'm going to drag
7:26 that one into the value.
7:28 So we've got this one value here
7:30 and all we need to do
7:31 is we just need to sum all these things
7:35 and we will get
7:37 the intrinsic value of the company.
7:40 So that's the intrinsic
7:41 value of the company.
7:42 So interesting
7:43 share price will be this
7:45 divided by outstanding shares.
7:48 So there
7:49 you go with the
7:49 intrinsic share price
7:50 that we have calculated is $144.
7:53 So what's the current price?
7:54 Current price is
7:55 basically the share price.
7:56 Now it's no difference.
7:58 So what's the 50% margin of safety?
8:00 That is the intrinsic share price
8:02 divided by two.
8:04 Okay.
8:06 So we've actually done
8:07 with our valuation,
8:08 you can see how simple the valuation is.
8:10 It's just putting in numbers in there
8:12 and just calculating the values.
8:14 So now comes the other thing
8:16 about conservative methodology
8:18 and more of a progressive or growth
8:20 kind of mentality kind of thing.
8:22 So if you can see this terminal value,
8:23 if I increase this number,
8:25 then the intrinsic value
8:26 calculation goes higher.
8:28 So if I keep it lower, then
8:29 the intrinsic value goes lower.
8:30 So you need to have like a smooth
8:31 kind of a measure
8:32 So I like to keep it at ten,
8:33 but again, it's up to you.
8:34 So if it's a company, it's
8:35 kind of like a risky
8:36 company is better off.
8:37 You become more conservative.
8:39 If it's not so risky company,
8:41 then you can go more higher numbers
8:43 as well.
8:43 It's the same thing goes for growth rate.
8:45 You can see the growth rate is 12%.
8:47 So that's our rough estimate calculation.
8:49 So I can change these values as well.
8:51 So we've calculated 2% growth
8:53 rate from the past five years.
8:55 So you can do it for the past ten years
8:57 or you can also get
8:58 some kind of subjective
8:59 kind of an assessment,
9:00 because in the past 12 years
9:02 we've been past five years,
9:03 we've been through quite a lot.
9:05 We've been through the coronavirus,
9:07 and that has affected the economy
9:08 and all those things.
9:09 The economy has been
9:11 in a difficult situation, so
9:12 we can assume that this 12%
9:14 might be a bit
9:16 underestimating the growth.
9:17 If I put in like 20%,
9:18 you can see
9:19 the intrinsic
9:20 share price suddenly goes to $185,
9:23 you know,
9:24 so you can play around with these growth
9:26 rate numbers,
9:26 but that is up to you really.
9:29 I would like to put it at 12%
9:32 right now,
9:32 but you can change it
9:33 to whatever you want.
9:35 So roughly,
9:35 our intrinsic share price is $144.
9:37 So according to Warren Buffett,
9:39 he likes investing in good companies.
9:41 Note the word good companies
9:43 at fair value.
9:44 So at the present moment,
9:45 with our valuation,
9:47 Apple is kind of in a fair value.
9:49 So buying this company
9:51 could be a good idea.
9:53 So on the other hand,
9:55 if you are investing in a company
9:57 which is young, like a growth company,
9:59 then I wouldn't recommend
10:01 investing at a fair value.
10:02 I would say
10:03 you might as well invest
10:04 in a 50% margin of safety.
10:06 So you have that
10:08 room for
10:09 error, that margin for error, so that
10:13 all these calculations can be wrong
10:15 and still
10:16 there is room for you guys to improve.
10:18 For example, Mohnish Pobrai
10:20 a huge,
10:21 huge advocate
10:22 for like a massive margin of safety.
10:24 So lots of myths out there
10:25 who really, really prefer
10:26 the margin safety
10:27 but in order to find margin of safety,
10:29 you need to know how to calculate
10:30 intrinsic value.
10:30 And that's what this video is all about,
10:32 to calculate the intrinsic value.
10:34 Now, coming back to the earnings.
10:36 So why have I put in the earnings
10:39 as well?
10:39 So sometimes, especially young companies,
10:42 their cash flow from operations
10:44 might be negative
10:45 because they are spending lots of money.
10:48 And so, for example,
10:49 I have a restaurant
10:50 and I'm
10:50 expanding the restaurant
10:51 to whatever money I'm
10:52 getting from the cash from operations.
10:54 I would be spending it
10:55 on more property and plants,
10:56 and I'll be expanding the restaurant
10:57 in one city to another city
10:59 so my free cash flow can be negative.
11:01 So in that case,
11:02 calculate the free cash flow model
11:04 will be a difficult thing to do
11:06 because we have all got
11:06 negative values in here.
11:07 So in that case, using
11:09 the net income will be far more ideal.
11:12 So for instance,
11:13 if you go to Netflix
11:14 and Netflix had a negative cash
11:16 flow a few years back,
11:17 So if I can go Netflix,
11:20 you can look at cash
11:20 flow from operations,
11:21 you can see there's
11:22 a bit of a negative value here.
11:23 So during that time it's better off
11:26 buying.
11:27 I mean, assessing your statements
11:30 by using the earnings
11:32 and putting the earnings
11:33 final number here.
11:34 You also don't need
11:35 to put the final values
11:36 in the free cash flow or the net income.
11:38 You can actually take an average of this.
11:39 Again,
11:40 that'll be like a conservative
11:41 way of doing it.
11:42 Or you can subtract,
11:44 you know, 20, 30% of the final value.
11:46 These are all subjective.
11:48 You can change around,
11:49 you can play around
11:50 with all these things,
11:51 but this is just the
11:52 theoretical form
11:53 of calculating the discounted
11:55 cash flow model.
11:55 It's all about adjusting your numbers
11:58 based on your risk profile.
12:00 He's now just alone.
12:01 Doing this is not enough.
12:03 You need to calculate.
12:04 You need to find out
12:04 the return on invested capital.
12:06 You need to assess a debt to equity.
12:08 You need to understand
12:08 the retained earnings growth rate.
12:11 You need to know whether the company
12:13 has got a depreciation asset
12:15 like, for example,
12:15 any of the manufacturing companies.
12:17 They tend to have higher CapEx.
12:19 So every year
12:19 they will have to spend
12:20 a huge, considerable amount of money
12:22 on expanding their factories
12:24 and maintaining their factories.
12:26 But some companies, they don't need to.
12:27 For example,
12:28 the reason why Warren Buffett likes
12:29 Moody's is simply
12:31 because they barely have any CapEx.
12:34 So you need to assess
12:35 not just the intrinsic value,
12:36 but everything from the debt,
12:37 from the ownership, from the increase
12:39 in the growth
12:39 rate of the sales, the revenue,
12:41 all these things
12:43 factoring in when choosing a company.
12:44 But this is just a simple template
12:46 for you guys
12:46 to calculate the intrinsic value.
12:48 So I have made a pretty decent amount
12:50 in the value based
12:51 investing the past few months
12:53 in this month alone, I made 24% return.
12:57 That's for this year
12:58 and that's been one month.
12:59 So I was able to buy
13:00 a lot of cheap stock,
13:01 especially made
13:02 some great returns in Netflix and in
13:07 I think Adobe as well.
13:08 So these two are
13:09 the big ones that I perform well.
13:11 So it
13:12 you can see a blurred out
13:13 some of the things that total value
13:15 we can see this is a real account
13:18 the number is here.
13:20 I also got a quantity based fund as well.
13:22 So either way,
13:24 if you do value based investing
13:25 or quant based investing,
13:26 it involves lots of work.
13:28 It's just not
13:29 you know, it's not that easy.
13:31 If quant based trading involves
13:33 lots of coding
13:34 and lots of mathematical analysis,
13:36 value based investing involves a lot
13:38 a lot of readings.
13:39 You have to read
13:40 a considerable amount of books
13:41 and financial statements.
13:43 And our report
13:44 try to find out small things
13:45 like contingent liabilities
13:47 and things like that,
13:47 because those kind of
13:49 factors play a huge factor
13:51 in choosing a company.
13:52 You need to understand
13:52 the management is management
13:53 have any fraudulent behavior
13:55 and all those things will factor
13:57 in while doing a value based investing.
13:58 So having a great portfolio,
14:00 both value based
14:01 investing and quant
14:02 based investing would be a great idea
14:04 that a lot of data available out there,
14:06 lots of information available out there,
14:07 and I hope
14:08 this video will give you the foundations
14:10 on how to calculate the intrinsic value.
14:12 So what I'm going to do in
14:13 the future is I'll
14:14 I'll do a balance sheet and also
14:17 income statement
14:18 and cash flow statement analysis
14:19 so you guys can understand how
14:22 how to read these statements
14:23 much effectively.
14:24 So because enjoy this video.
14:25 Have a great, great day.