how to analyze stocks in excel in 2019.
How to do it? By using my excel based tool (I call it “Stock Analysis Worksheet“).
You may be wondering how an excel sheet can analyze stocks? Because I’ve hard coded it perform this task.
Today I will show you how I use this tool…
…and you too can use this excel sheet to analyze your stocks.
WHAT THIS WORKSHEET CAN DO?
My stock analysis worksheet is special for me. Why?
Because of its two main highlights…
Intrinsic Value: It can estimate true value (or intrinsic value) of stocks.
Overall Score: The worksheet can also rate stocks (give scores) based on their fundamentals.
How to analyze stocks in Excel - Overall Scrore & IV
Intrinsic value can be compared with the stock’s market price to know if it is overvalued or undervalued.
For stock investors, only undervalued stocks are interesting.
Overall score gives a general idea about the business fundamentals of the stock.
For stock investors, stocks with strong underlying business is interesting.
GOAL AND LIMITATION OF THE WORKSHEET
The main goal behind developing this worksheet was to make it capable of estimating “intrinsic value”.
Disclaimer: Estimating intrinsic value of stocks is such a special skill that people who can do it accurately have become Warren Buffett’s and Peter Lynch’s. I’m no Warren Buffett. :). Hence, this worksheet can’t give investment advice.
Though I was aware of the limitations of building such a worksheet, but I proceeded it anyways.
The logic was simple, “at least it will give some clarity about stocks, which will be better than blind belief “.
In last couple of years, there has been several updates of this worksheet.
Today it has reached a stage where its users are beginning to like it more. Check the testimonials.
read more here:
[ Ссылка ]
Data Entry Video Guide:
[ Ссылка ]
Product Page:
[ Ссылка ]
