How to Find Intrinsic Value of a Stock | Excel Calculator | Calculate Intrinsic Value of Infosys
Shankar Nath
View ChannelAbout
Shankar Nath is a SEBI-registered Individual Research Analyst (registration no.: INH000022093, validity: Jul 28, 2025 - Perpetual) I share investing and personal finance advice, strategies and tools to help you grow your wealth. I've been an active investor for 20 years and have worked in banking, lending, insurance and with fintech companies including ICICI Bank, GE Money, Chubb Insurance, Bharti AXA General Insurance, HDFC Life Insurance and ET Money All content presented/published is purely for knowledge purpose and should not be treated as an advice or opinion of any kind. In that context, Shankar Nath shall not be held liable/responsible in any manner whatsoever for any losses the viewers may incur due to acting upon this content Investment in securities market is subject to market risks. Read all the related documents carefully before investing. Thanks for watching!
Latest Posts
Video Description
🤝 Download the PowerUp Money app https://app.powerup.money/xDsX/shankarnathn ► Join 60,000+ investors reading my newsletter Subscribe at https://shankarnath.substack.com/ Use my referral code SKN20 for 20% Fee Discount on Quantitative Investing Strategy course by Kirubakaran Rajendran on Fisdom Academy. This course is for BEGINNERS. 👉 https://fisdom.academy/courses/Quantitative-Investing-Strategy--64e39d49e4b01624e0a9286b?utm_source=youtube&utm_medium=video&utm_campaign=ShankarNath If you're tired of the guesswork and want solid techniques to determine a stock's true worth, this video is a must-watch as I unveil three proven methods to calculate the intrinsic value of a stock. 1. The Relative Value Model compares a company's financials to its peers, using metrics like the Price-Earnings (PE) ratio. I'll show how you can find the intrinsic value of Wipro Limited using this approach 2. Discounted Cash Flow (DCF) method is a very popular way of calculating the intrinsic value and I'll be breaking down the complex DCF method into five simple steps. Using Infosys as an example, we'll learn how to project cash flows, apply discount rates and compute the present value of future earnings 3. Dividend Discount model values companies that pay dividends and it requires just three key inputs – current dividend per share, discount rate, and dividend growth rate 👉 I have also put everything discussed in this video in an excel worksheet. You can find it at https://docs.google.com/spreadsheets/d/1KFYENaFH5051r9YNMyootX0BiodQfspVJPc7UCOSkNo/edit#gid=883369840 .. the sheet is downloadable so please feel free to modify per your convenience 👉 Video Chapters: 00:00 Finding Intrinsic Value of a Share 01:02 What is Intrinsic Value? 02:44 1. Relative Value Method 04:54 2. Discounted Cash Flow Analysis 11:05 3. Dividend Discount Model 15:31 Shankar's Viewpoint 👉 Download the Fisdom app: https://fisdom.onelink.me/VCH6/ShankarnathYT 🙌 Join my community on: ‣ Youtube: https://www.youtube.com/@shankarnath ‣ Instagram: https://www.instagram.com/shankarnathofficial/ ‣ LinkedIn: https://www.linkedin.com/in/shankarnath/ ‣ Twitter: https://twitter.com/shankarnath #intrinsicvalue #discountedcashflow #shareprice Disclaimer: I am not a SEBI registered investment advisor or research analyst. I am not registered with PFRDA or IRDA either. The content posted on this platform is purely for educational purposes and none of it constitutes investing or trading advice. Viewers should do their own research and diligence before investing or acting on the information presented. Some of the links I have posted in the video, the description, the comments and other related resources might be affiliate links
Excel Stock Analysis Essentials
AI-recommended products based on this video

Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

Lenovo IdeaPad Duet 3i 10.3" Touchscreen Intel Celeron N4020, 2-in-1 Laptop, Windows 11 Home S Mode + Includes 1-Year Microsoft 365 Personal - 82AT00KJCC

tomtoc 360 Protective Laptop Sleeve for 15.6 Inch Acer Aspire 1/3/5 15 Slim Laptop, 15.6-16 Inch ASUS Strix G16/G15, HP Pavilion 15, Lenovo Ideapad 3 Laptop, 15.6 Inch Dell Samsung Notebook Ultrabook

ASUS Zenbook A14; Copilot+ PC, Ultrathin Laptop, 14” WUXGA OLED, Snapdragon® X Processor, 32 GB Memory, 1TB SSD, Wi-Fi 6E, Iceland Gray, UX3407QA-DS51-CB

Dell UltraSharp 24 Monitor - U2424H

Dell UltraSharp U2723QE 27" 4K UHD WLED LCD Monitor - 16:9 - Black, Silver EPEAT

Dell UltraSharp U2725QE 27' 4K Thunderbolt-Hub-Monitor mit Bildwiederholfrequenz Von 120Hz

Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

GIGABYTE - AORUS Elite 16 Gaming Laptop - 165Hz 2560x1600 WQXGA - NVIDIA GeForce RTX 5070 - Intel Core Ultra 9 275HX - 1TB SSD with 32GB DDR5 RAM - Windows 11 Home AD (AORUS Elite 16 BWHC3USC64SH)

Motherboard Fit for Gigabyte Z490 AORUS Master LGA 1200 ATX Gaming Motherboard Support I9-10900K I7-10700K I5-10600K DDR4 3×M.2 1×PCI-E X16

Fit for GIGABYTE B365M AORUS Elite Micro ATX Intel B365 M.2 SSD 64G Double Channel Support 8 9 Gen LGA 1151 CPU Motherboard Gaming Motherboard

Pc Motherboard Fit for Gigabyte B560M AORUS Elite LGA 1200 Micro ATX Intel B560 DDR4 128G SATA M.2

Dell UltraSharp 24 Monitor - U2424H

Dell UltraSharp U2723QE 27" 4K UHD WLED LCD Monitor - 16:9 - Black, Silver EPEAT

Dell UltraSharp U2725QE 27' 4K Thunderbolt-Hub-Monitor mit Bildwiederholfrequenz Von 120Hz











