Here I am reproducing the mentioned Formula shown in 8:13 of the video replacing most of the constants followed by my analysis. All variable names are camel cased for easier reading....
Code:
(EarningPerShareOfAStock * (assumedFairPriceByEarningRatio + 2 * assumedFutureSalesGrowthFor7to10Years) * InterestRateOf_TripleA_USA_CorporateBonds)
Divided by InterestRateOf_TripleA_India_CorporateBonds
Key Points from the Video
1) The vlogger demonstrated google search to show that InterestRateOf_TripleA_India_CorporateBonds value is 6.1
2) The vlogger suggested using screener.in to look up for EarningPerShareOfAStock and for assumedFutureSalesGrowthFor7to10Years
3) The vlogger declared that InterestRateOf_TripleA_USA_CorporateBonds value is 4.4
4) The vlogger provided hard-coded value of assumedFairPriceByEarningRatio is 8.5
My conclusion
Points numbered 1 and 2 of the vlogger are correct....
InterestRateOf_TripleA_India_CorporateBonds is indeed 6.1 as per google,com (screen shot attached)
EarningPerShareOfAStock and assumedFutureSalesGrowthFor7to10Years for SBIN is 13.54 and 8.06 respectively as per screener.in (screen shot attached)
Point 3 of the vlogger is grossly incorrect....
InterestRateOf_TripleA_USA_CorporateBonds is 0.560 declining as per investing,com (screen shot attached). The vlogger sets this value to 4.4 and uses it as a constant in formula
Point 4 is grossly incorrect....... Again the vlogger is using a constant like 8.5 for assumedFairPriceByEarningRatio. It is better to use ROCE value as shown in screener.in. ROCE stands for Return on Capital Employed.
Finally, plucking all of the values and placing them for SBIN reduces intrinsic value formula to
(13.54 * (4.66 + 2 * 8.06) * 0.560) / 6.1
Upon evaluation, this gets result of 25.8 as intrinsic value of SBIN....