The Excel stock analyzer now has two spreadsheets based on Warren Buffett’s approach to stock valuation.
The valuation sheets have been built from the ground up based on this article: Valuing Stocks the Warren Buffett Way
The article mentions that more details can be found at:
“Buffettology: The Previously Unexplained Techniques That Have Made Warren Buffett the World’s Most Famous Investor” (I have not read the book)
Please do not use this sheet unless you understand the above article. Since I have nothing new to add, I see little point in describing the valuation sheets. So let me limit myself to the following:
Some questions for the investor to ask:
- What is the earnings yield? How does it compare with long-term govt. bond yield?
- How do returns project with historical earnings growth fare?
- What is the sustainable growth rate of the company, based on ROE and dividend payout ratio?
- What is the return on investment based on book value growth rate and for different PE values?
The sheets provide different ways of answering these questions by suitable choice of inputs. Historical stock price from Yahoo Finance (auto-downloader included in the analyzer) are necessary to use valuation sheets 2 and 3.
I hope the version 2.0 of the Excel Stock analyzer will help the user answer these questions. Please use the sheet only after reading the sources listed in the sheet, understanding and verifying the formulae used in the sheet and when you are comfortable with them.
Here is a screenshot (click on it to enlarge)
(This is for Indian stocks). For a full list of features available, see this post.
For U.S. stocks use this free sheet: U.S. STOCK ANALYSIS SPREADSHEET
Connect with us on social media
- Twitter @freefincal
- Subscribe to our Youtube Videos
- Posts feed via: Feedburner
- We are also on Google Plus and Pinterest
Do check out my books
My first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now . The Kindle edition is only Rs. 199.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantMy second book is now only Rs 199 (Kindle Rs. 99) Get it or gift it to a young earner
The ultimate guide to travel by Pranav SuryaThis is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for ₹199 (instant download)
Free Apps for your Android PhoneAll calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)