Stock Analysis Worksheet [V3]

Stock Analysis Worksheet

The new version (V3) can automatically fetch stock data. This worksheet’s highlight is its ability to estimate intrinsic value, financial ratios, and 10 year’s snapshot (check its limitations). Along with V3, you will also get the Stock Comparison Tool for free.

Testimonials

"Someone like me who has no experience of the Stock market and does not know anything, its a great tool to understand nuances. Ofcourse I am also learning some jargons for stock market but this tool is very effective"

RAVI KUMAR

SEP 21, 2021 AT 10:27 AM

"Very good product of hard work of a guru with deep knowledge of the subject and heart to share the wisdom. No words to appreciate adequately and of course the charges are peanuts to the utility it provide a person seeking the intrinsic value of stocks. Heartfelt thanks and good wishes to GMR for continued success and support to the needy."

CINELS

MAY 18, 2021 AT 1:11 PM

How to Buy?

Pay using the buy button. You can also pay using UPI & get discount Once the payment is made, the download link will be emailed to your email id. Check your Inbox/Spam box after payment.

Why to Buy?

This worksheet is one of its kind. It converts the financial data into “intrinsic value“. This eventually helps the user to estimate if the stock is fairly priced or not. These are its features:

How to use

Limitations

List of Stocks

As of date, this worksheet can analyze 850+ nos stocks. Why? Because we very selectively add stocks to our list. One of the criteria is, the stock must have at least 10 years of financial data. We are working, and we’ll go on adding good new stocks to this list. The list is dynamic. Your worksheet will automatically get updated for the newly added stock. We will not charge you extra for the new stock list. In case you want us to add any specific stock, please fill this form. We will consider adding them to our list of stocks.

User video guide

Check this user guide vide to learn how to use this worksheet. Though this worksheet can fetch data on its from internet, but a new user must watch this video guide. It will help them to use the tool seamlessly.

Testimonials

"Thank you Mani for a great product, its indeed become one of the greatest weapon in my arsenal, All thanks to you and SAW, which I use regularly to analyse all my stocks, with all humility I am happy to say that after so many years of burning my fingers in the stock market today my portfolio has touched 81.39% in one year of investing using SAW, also through your articles, I have gained a lot of insight and knowledge about analysing and investing in good companies. Thank you once again for sharing your knowledge and a great set of tools and resources on GetMoneyRich.com"

Terrence D'souza

APR 28, 2021 AT 10:02 PM

I am using your product most .This recent update is a good one .Don't want to miss that...

Kamal Prasath P

APR 27, 2021 AT 1:14 AM

"Hi Mani, Thanks for all the good work you are doing, it has been a great help to me any many people like me. I am also a big fan of your blogs, they are very detail and up to point. I have one request to you. Can you please make one blog on "Electric Vehicles in India and it's beneficiary companies/stocks""

Sanjay

FEB 20, 2021 AT 11:16 AM

"Its easy to use and analyse. its been a year since i have been following your blogs and your worksheets. a new learning experience. thank you mani. Q) i am using stock analyser V3.0. Is worksheet V3.0 different from V3.01? "

RAKESH KIRAN

DEC 27, 2020 AT 07:04 PM

"Dear Mani! I had purchased Stocks Comparison Tool & Mutual Funds Comparison Tool this year during April-May month and while going through the mails i found out that an discount offer for the version 3.0 was available for 24 hours. Could you please let me avail the discount offer"

Pramod Manikpuri

DEC 17, 2020 AT 04:38 PM

"Dear sir, I had bought the version V2.1.5, the worksheet has been very useful for me till now and I get to learn a lot from the blog. Your products can actually transform lives. Sir I was one of most early people who showed confidence in your worksheet, however newer versions came in very quickly and mine was outdated soon. In a way it became redundant before it served its purpose and new version was at double its price. No updates were provided to the existing users. I tried to communicate to you through emails and twitter, but never got any response. My suggestion is that 1. All the previous existing users should be provided with free updates to the newer version. 2. Customer support system has to improve a lot. Thank you."

Subham Mandal

OCT 25, 2020 AT 08:16 AM

"Hope you are doing well. This V3.0 worksheet is awesome and enjoys analysing. Thank you for the wonderful creation. "

Prasanna

SEP 09, 2020 AT 10:01 PM

"I call it MM. Manis Magic Sheet. He made life so simple with his excellent work. You get everything under one sheet. Thank you Mr Mani "

Sonu Jha

AUG 25, 2020 AT 11:37 AM

"Point no 1. It is absolutely cool and easy to operate by loading the data in close to 5-6 minutes and I get the valuation of stock for me at a finger tip. Point no 2. Previously I use to do lot of calculation to arrive at the intrinsic value but now not any more..Apart from intrinsic value what I liked about the product is the management quality which you bring it as value add. This makes me comfortable considering the business as well as the management focus on the business to get more value add to the company and to it's share holders."

Rajesh Raghunathan

AUG 12, 2020 AT 8:33 PM

"Your sheet is terrific once you know how to insert value. Stock Analysis Worksheet is the best time-saver sheet I have ever invested in"

Archit Jain

JUN 17, 2020 AT 4:39 PM

"The stock analysis sheet+ product includes excellent tools which one can use for managing personnel finance without requiring any other support. The best of this package is a stock analysis worksheet which is very handy to analyze the stocks and one can make decisions based on underlying value. initially a bit tricky to enter data but after watching the help video all got resolved. thanks for providing these tools at a reasonable cost which is very useful for retail investors.i would definitely recommend these tools to my friends."

Amit Magadum

JUN 12, 2020 AT 9:41 PM

"The work sheet has been of great help for me could analyse quite a bit of stocks"

Suresh J.R

JUN 5, 2020 AT 11:22 PM

...I got benefited from this sheet a lot.. Thank you Mr.Mani.. keep up your good work.

Vaitheeshwaran Manickam (Youtube)

JUN 04, 2020 AT 08:15 PM

Brillant Excellent, I suggest and recommend , if anyone want to do value investment, i suggest buy his stock analysis worksheet, I have been using and have benefited a lot and made my investment safe good work Mr Mani, it is so simple

Kavish Shah (Youtube)

JUN 04, 2020 AT 5:21 PM

I purchased your sheet even without any commerce background, your excel sheet can be used and it works well, Thanks for your great work

Muhammed k veerankutty

MAY 31, 2020 AT 12:08 PM

I found Mani's Excel Stock Analysis Worksheet to be very useful in estimating the intrinsic value of companies. It is easy to use, and easy to understand even for someone from a non financial background. I especially appreciate the quick responses I received from Mr. Mani when I had some doubts regarding the usage of the worksheet. I wish him well and hope he continues to improve the worksheet in the future as well.

Arjun

FEB 02, 2020 AT 10:28 AM

FAQ's

Have made the payment, how to get the worksheet?

Check your Inbox/Spam box [Read: how to buy]. The download link is provided in the email. The downloadable file is zipped. Use the link to download the file into your laptop or desktop device. The worksheet works only on device which has MS OFFICE loaded on it. Read about limitations.

Why the download link in the email is not working?

The Download link will work only for the first 24 hours from the point of payment. This feature is necessary to limit the number of downloads, and unjust circulation. [Read: how to buy]

Why worksheet is indicating password protection?

Password protected helps to maintain the singularity of the worksheet. As the editing rights are protected, it helps to keep its internal algorithm intact. This way, the user can use the worksheet in a carefree way. The chances of worksheet getting corrupt during usage is minimal.

Does This Product Offer Investment Advice?

None of the articles or products of this Blog offers any investment advice. Please make sure to read the disclaimer before use.

How to add new stocks in the list?

We keep adding new stocks to the list regularly. When we first launched V3 in Aug'20, we had only 150 stocks. Now the number has more than doubled. You can also read about the list here.

How to use the worksheet?

Please check the user video guide for details.

Why worksheet is not fetching data (Macros)?

First step is, you must get the ‘Enable Marcros’ prompt when the file is opened? If not, then it means Macros is not enabled. Please change macros settings in the Trust Center.

Firewall settings may also block the MACROS. Easy solution is to try using the worksheet on another device. It should work. Else, reset the firewall settings. If you cannot do it on your own – please show it to a networking guy.

What is the Refund Policy?

Considering that Stock Analysis Worksheet is a "Digital Product", the paid money cannot be refunded.

Why there are no Banking Stocks listed in the Stock list?

This worksheet can be used only for non-banking stocks. In case you want to know about how to analyse banking stocks, you can read this article.

Bought the worksheet sometime back, how to get the updated version?

The worksheet gets updated with time. Buyers are eligible for ONE free update till the 6th month from the date of native purchase (without offers). Eligible buyers will have to contact me for the free update. I'm sorry, but updates cannot be delivered automatically to the eligible buyers. After the 6th month, buyers are not eligible for a free upgrade.

Is it possible to get the earlier update (revision released prior to the current update)?

No. The current version supersedes all prevision updates.

I do not know MS EXCEL, can I use the worksheet?

Yes. Just check the introduction video. It give give you a fair idea of how to use this worksheet. Though Use of this worksheet is easy and intuitive, nevertheless, this video can give an idea of how to use this worksheet.

Why my E-mails are not replied?

Generally I'try to answer all emails related to problems faced by users. But requests for resending worksheet, queries on sheet's algorithm, finding the cause of error, commercial emails, personalised queries, general queries etc may not get a reply.

Whom to contact in case of problem?

In case of problem, please contact me by sending me an email from your registered email ID.

Version Logs

(Read policy for free updates)

V.3.3 (Sep'21)

Intrinsic value algorithm update.

Intrinsic value dynamic scale added to the cover sheet.

Price trend for 14-D, 30-D, 90-D, 180-D, 5-Years added to the cover sheet.

V.3.2 (July'21)

Peer (Competitor) comparison on basis of 8 parameters has been added.

V.3.1.2 (Apr'21)

3.1.1 > The concept of ECONOMIC MOAT Rating Introduced in the Overall Rating of Stocks. 3.1.2> The algorithm of the Management’s Rating is also updated.

V.3.1.02 (Apr'21)

RoIC Formula tweaked. The concept of NOPAT and Invested Capital introduced.

V.3.1.01

Absolute PE method of intrinsic value estimation is introduced.

V.3.1 (31-Dec-2020)

Cover report updated. Intrinsic value algorithm changed.

V.3.0

Automatic data fetching is enabled. The Worksheet can now fetch 10 Year financial data of companies (balance sheet, profit & loss a/c, cash flow statement, quarterly report, and price data).

V.2.1.6.2

Financial ratios sheet updated. (link to V2.1.6.2]

V.2.1.6.1

It’s a minor update. A reporting format showing 10Y snapshot of Balance Sheet, Profit & Loss account, and Cash Flow Statement is introduced.

V.2.1.6

This is a major update where changes are made both in worksheet’s back-end and front end. Some mathematical models have been improved while couple of the old ones are also discontinued.

V.2.1.5.04

This update takes care of how how free cash flow and intrinsic value of stocks is estimated by the worksheet using Discounted Cash Flow (DCF) method. Know More about it here.

V.2.1.5

Management, profitability & financial health grading algorithm has been updated. It bring changes to the “overall score” given to stock in the “Cover” sheet (Oct-2019)

V.2.1.4

Effect of recent “Price trends & PE trends” has been considered to estimate intrinsic value (fair price) of stocks (Aug-2019)