Episode Details

Back to Episodes
How To Analyse A Stock (Using My Free Spreadsheet)

How To Analyse A Stock (Using My Free Spreadsheet)

Published 20 hours ago
Description

STOCK ANALYSIS SPREADSHEET (its free)
▶︎ https://www.hamishhodder.com/spreadsheet

In this video I walkthrough exactly how to use my stock analysis spreadsheet to analyse companies as long-term investments. The spreadsheet is a free resource (link above) that helps value investors analyse businesses as investments.

I breakdown where to find the data, how to enter it in and how to interpret it using Warren Buffett and Charlie Munger's investing principles.

★JOIN OUR INVESTOR COMMUNITY★
The PLUS tier of the community ($9.99/m) includes my Valuation Crash Course and a bunch of other resources.
▶︎ https://www.hamishhodder.com/community

EXTRA RESOURCES MENTIONED:

TIKR - 10 YEARS OF FINANCIAL DATA
▶︎ https://www.hamishhodder.com/tikr
MAINTENANCE CAPEX
▶︎ https://www.youtube.com/watch?v=g-WQ5NvRJYw&t=19s
RETURN ON INVESTED CAPITAL
▶︎ https://www.youtube.com/watch?v=8tgAUO4oqc4
ECONOMIC MOATS - COMPETITIVE ADVANTAGES
▶︎ https://www.youtube.com/watch?v=bLq17MUD1Uo&t=257s
VALUATION
▶︎ https://www.youtube.com/watch?v=bhCUK06O31Q&t=374s
WHOLE ANALYSIS PLAYLIST
▶︎ https://www.youtube.com/playlist?list=PLQoIU6cn85OBqatzma_9ixt2JT4rXboxM

===========

STOCK ANALYSIS SPREADSHEET
▶︎ https://www.hamishhodder.com/spreadsheet
-------
STOCK ANALYSIS CHECKLIST
▶︎ https://www.hamishhodder.com/checklist
-------
SHARESIGHT - Track Your Portfolio (4 Months FREE)
▶︎ https://www.hamishhodder.com/sharesight
-------
SEEKING ALPHA - News & Analysis (58% OFF)
▶︎ https://www.hamishhodder.com/seekingalpha
-------
TIKR - Financial Data (save 25%)
▶︎ https://www.hamishhodder.com/tikr
-------
YOUNG INVESTORS PODCAST
▶︎ Apple Music http://bit.ly/YIPitunes
▶︎ Spotify http://bit.ly/YIPspotify
▶︎ YouTube http://bit.ly/YIPYouT
-------
★PRIVATE INVESTOR COMMUNITY★
▶︎ https://www.hamishhodder.com/community
-------
MY YOUTUBE GEAR
▶︎https://kit.co/hamishwhodder
-------
FOLLOW ME ON TWITTER
▶︎ https://twitter.com/hamish_hodder

BUSINESS ENQUIRES
▶︎ hamish@hamishhodder.com
-------
Disclaimer:
The information in this video is general information only and should not be taken as constituting professional advice from Hamish Hodder.
Hamish Hodder is not a financial adviser. You should consider seeking independent legal, financial, taxation or other advice to check how the information relates to your unique circumstances.
Hamish Hodder is not liable for any loss caused, whether due to negligence or otherwise arising from the use of, or reliance on, the information provided directly or indirectly, by use of this video.

TIMESTAMPS
INTRO 0:00
GET THE SHEET 0:48
GET THE DATA 1:52
DATA INPUT 2:32
CAPEX 2:57
ROIC 3:22
INTERPRETATION 3:30
VALUATION (BUY PRICE) 5:50

Learn more about your ad choices. Visit mega

Listen Now