Stock Analysis Worksheet V2.0.5

Introduction – Video
  • UPI Price : Rs.513/- (OFFER: 10% OFF for UPI only)
  • Make payment using Unified Payment Interface (UPI)
  • What is UPI? How to make payment using UPI?
  • Pay to: getmoneyrich@hdfcbank
  • Kindly pay, and then fill the below payment form (only for UPI)
  • In payment form, provide your email id & transaction reference
  • Once you fill the payment form, worksheet will be emailed to you
  • Alternatively, pay using the below BUY button (Price: Rs.570/-)

  • We read books to learn things.
  • Reading is good, but what about application of knowledge?
  • Guess, why less stocks stock investing tools are availably?
  • This worksheet attempts to bridge this gap.
  • It converts the learnings into a meaningful tool.
  • This worksheet is both practical and useful.
  • It is a ready to use tool.
Fill Payment Form (only for U.P.I)
Why to buy?
  • This worksheet answers following important questions:
  • Stock is currently undervalued or overvalued?
  • In terms of Future Growth, stocks is good?
  • Company is being Managed well or not?
  • How good is the companies profitability?
  • How healthy is the company Financially?
Who can buy?
  • Person with basic knowledge about stocks.
  • People who want experience stock analysis.
  • People who want to check if company is strong or weak?
  • People who want to estimate intrinsic value of a stock.
  • People like to check intrinsic value using several methods.
  • People who want to invest in stocks but do not know where to start
  • Buy if you want to experience fundamental analysis.
Why you will love it...
  • It gives true value of stocks.
  • It tells, where lies the strength of the stock.
  • It tells, where stock is weak.
  • It rates stock as per its overall performance.
  • It gives results in just 10-15 minutes.
  • This worksheet is one of its kind available on internet.
  • Companies must be listed in BSE/NSE for 10 years or more.
  • Its a simple Microsoft Excel Worksheet. Its not a software
  • It can be used on Windows PC.
  • It can be used on Macbook with MS Excel installed.
  • The worksheet is password protected to prevent copyright.
  • It is not an investment advice tool.
  • People can use this worksheet only to experience stock analysis.
  • The worksheet can be used only for non-banking stocks.
  • Beginners will take some time before fully utilizing this worksheet.
  • Users - 1150+
  • Twitter followers - 350+
  • Email Subscribers - 26,000+
  • Facebook followers - 2,110+
  • Youtube subscribers - Building
Quick Tips
  • Must watch the "Video Guide".
  • The Video guide will tell more about this product.
  • Read the "Help Sheet" once the sheet is purchased.
  • All data required by this worksheet is available in Economic Times.
  • All data required by this worksheet is available in moneycontrol.
  • It will take 10-15 min to enter data for each stock research.
  • New users may take more time.
  • Watch Video guide to know how to enter data into the worksheet
Video Guide – For Data Entry
Must Read

86 Comments on "Stock Analysis Worksheet V2.0.5"

  1. I always wanted a tool which could help me differentiate between two stocks. This worksheet is good in this front.

  2. Thanks Mani for the clarification. You may want to mention the limitation in the help section of the file or read this file.

  3. Hi Mani,

    I bought the stock analysis worksheet last week and entered data for SBI – State Bank of India and the cover sheet does not populate the data for low price, future growth, profitability and Bankruptcy threat. Intrinsic value using all the models listed in your file is not available as well. I see a Div/0 error.

    Is there a email address I can send this file to for you to review and suggest what could have caused this?

  4. Does it works on Android phones. I’m using Mi4 I want to purchase if it works

  5. Ankit Juneja | March 1, 2018 at 10:08 pm | Reply

    Hi Mani,

    I bought you stock Analysis sheet today and want to know how to capture effective tax rate for Himadri Speciality Chemicals . Not able to find information on equitymaster. Please advise.

    • Hello, for stocks whose effective tax rate is not available on, assume it to be 30%. The same is also mentioned as a note in worksheet itself. Thanks.

  6. MANI Sir,

    I have one question. What is the basis of scoring for future growth in your sheet? For quite a few companies which seem to be good, Future Growth score is very less, sometimes 0 as well. Even for shares you yourself suggested like Grauer and Weils Future Growth Score is 0.

  7. Sir, Today I bought your worksheet and started working with it. Nice one.Thanks

  8. Chintamani Chhatre | February 19, 2018 at 10:22 pm | Reply

    I just downloaded sheet today. But I’m not getting the results after entering the data. For most of the calculated data, I’m getting #DIV/0!. Don’t know where I’m doing some mistake while entering the data. I’m also getting market cap as 0 in General sheet. and p/B Ratio as #DIV/0! as well.
    Pls suggest

    • #DIV/0! error can appear when data entry is not proper. Please watch the “Video Guide” (on how to enter data into worksheet). Please refer the “help sheet“.”

    • Chintamani Chhatre | February 20, 2018 at 12:00 pm | Reply

      I did watch Video guide and did go through the Video guide as well. Still no luck. Tried for atleast two stocks. L&T and Maithan Alloys. Should I send my sheet over email so that you can figure out where exactly is the problem?

      • This worksheet has already been used to evaluate L&T and Maithan alloys. It works well.
        I will request you to see the video guide again.
        Follow every step (one by one).
        You will figure out the issue.

        P.N: Make sure to use “Paste Special > Text” commend to copy/paste data from web.

        • Chintamani Chhatre | February 20, 2018 at 1:05 pm | Reply

          Ok Sir. Will try it again and get back to you. Eager to use the sheet as it looks very useful

          • Chintamani Chhatre | February 20, 2018 at 10:45 pm |

            Ok I found the problem. When I’m copying data from MoneyControl using Firefox, its not getting copied properly but when I’m using Chrome it’s working. I’m on Mac. Pls update your help guide if it does not already cover this.

          • Thanks a lot for this very valuable piece of information.
            I really appreciate your feedback.

          • Gautam Dhume | March 3, 2018 at 9:25 pm |

            hi. I also encountered the same problem while copying data in Firefox browser.I also found the solution by accident ,and the solution is to press Ctrl key while copying the data from Moneycontrol site in Firefox browser.

  9. Hello Maniji. I read your blogs regularly and indeed our pleasure to gain knowledge . Language is very simple to understand. I have purchased your excel sheet. My query is While entering data from financial statements from money control user should add Standalone sheet or Consolidated sheet for PL, CAshflow etc ?


  10. Thank you for creating such a useful worksheet. I have recently bought this sheet and would like to know whether this sheet works for banking sector stocks as well?

  11. Hi

    I plan to buy this worksheet but just wanted to understand if it is just a one time cost. Can I do analysis of any number of companies by buying this worksheet once. Would I be able to save this worksheet and see how the worksheet works like all the formula etc.

    There was no mention of future data here. What about the expected revenue growth rate and further expected event related adjustments that we can do like payment of debt, new order, new line of business.

  12. I was skeptical to buy initially but the sheet is value for money as it can save your time from manual labor. Thank you.

    You can further automate this excel sheet to make it better. One suggestion is about ‘Effective tax rate’. We are asked to fetch it manually from This information is not available in this site for some companies. We an easily calculate this number from annual profit & losses statement.

    There is a number known as ‘EBT’ in P &L statement. This is earnings before tax. As an example, for Avanti feeds in March, 2017, it is 312.27. Next line in P&L statement is ‘Taxes’ which is 98.31. So, effective tax rate for this company is (98.31 / 312.27) * 100 which is 31.48 %

    Please see:

  13. Hi How can I change on the General sheet the P/B ratio and P/E ratio ? Can you tell me the procedure?

  14. Excellent analysis. I had the desire to have all the information about a stock in a single place. This is the one and I am using it extensively for my investment judgement.
    I want to unprotect a sheet and it is asking me for a password
    Can you please share it with me ?

    • Thanks for your comments.
      Some cells are protected for copyright issues. But it will never interfere with the usability of the worksheet.

  15. Hi
    I have purchased the stock screen and in the data entry page section 4 is different compared to one you shown in the vidoe
    Was it deliberate to decrease data or any mistake in screen i downloaded
    I appreciate your response

  16. Hi, I am planning to buy worksheet. But I am wondering whether your sheet is years specific and whether supports 2018? Do I have to wait end of this year

    • Yes it is years specific. But as it is meant to do fundamental analysis of stock (long term trends), quarterly results do not matter so much.

  17. Hi Mani,
    Thanks for the different topic and blog described in understandable manner.
    I have one query. The latest version of the sheet is -1.2.5CS4. In future, if the updated version will
    release, is it free or old subscriber has to pay extra?


  18. Ashis Kumar Das | July 25, 2017 at 2:16 pm | Reply

    Your stock analysis is excellent but that video is not download from you tube, please give some download link for which I can download the video which will be better for understanding the stock analysis.

  19. Pankaja Mundhra | July 21, 2017 at 9:06 pm | Reply

    This worksheet has been designed by a person who knows what is stock analysis. Though, for a person like me, it can be a bit overwhelming, but I must say, “Hats Off to the effort” put by the creator in compiling almost everything about stock analysis in a simple Excel Sheet.

  20. Baliram Kharche | July 21, 2017 at 9:05 pm | Reply

    Very good to select stock

  21. Mostly no stock is getting even close to 80%, but the criteria is to go beyond 94%. If we keep checking all stocks one by one then to complete at least 200 stocks take 100 days time if we give 2 hours a day, then when to buy stock. No stock is getting beyond 60%.

    • Dear Ali, you are right. These days you will hardly find stocks which will pass the screening criteria of this worksheet. The reason being, SENSEX trading at 32,000 levels. At such Sensex levels, almost all GOOD stocks are overvalued.

      Just to explain the concept in short.
      This worksheet scores stocks based on the following 3 broad criterias:
      (1.0) Price Valuation
      (2.0) Business Fundamentals
      (2.1) Profitability of Business
      (3.0) Price History

      I recently did an analysis of Cummins India. This is one stock which scored high in terms of Business Fundamentals, Profitability & Last 10 years price history. CUMMINS INDIA earned all THUMBS-UP for these criteria.

      But in terms of Price valuation, CUMMINS INDIA scored just 50%. This brought down the overall rating for this stock.

      See, in term of investors, even if the stock is fundamentally a power house, but if it is not available at right price, its will NOT be a good buy.

      Based on your comments, I could understand that probably, 94% was a bit too stringent criteria. Hence I have released an update (1.2.1) today wherein the scoring criteria has been explained in more detail for its user. This was, if your stock earns poor grades, you will exactly know “why & where” it is scoring low.

      I hope people will like the new updated version (1.2.1)

  22. Nirmal Gupte | July 10, 2017 at 3:01 pm | Reply

    Hello Mr. Mani,

    Bought your Excel Sheet on stock analysis / valuation few days ago. Watched the video on demonstration on the use of this sheet and at the outset I must say that this sheet is very useful. I had been attempting to do the valuation on my own using excel sheet. Since I am not from finance background, i started with DCF method and had been reading books by Prof Ashwath Damodoran on valuation. In that respect this sheet was a welcome thing, since it does a lot of things on its own and adopts holistic approach to stock valuation.

    I wish to have a doubt cleared in this regard. In the AS work sheet, under Business Fundamentals where we rate the stock basis its market capitalisation, would it not be prudent to rate a stock basis Market cap of the sector versus Market cap guidance that we use now basis on the guidelines in help sheet. Please explain why not. I am sure lot of thought has gone into it, so you must have thought about this, just that its not readily evident to me.

    • Dear Mr. Nirmal, thanks a lot for your compliments on the worksheet. It means a lot. Such feedback are precious as it speak’s out loud that the purpose of the worksheet is ultimately being achieved.

      Your idea about market capitalization is really good. Comparing stocks of same sector is always better. But this exercise will take slightly more time than than what it taken now.

      Frankly speaking, when I was building this worksheet, focus was on developing a product which is as simple as possible. Though further deep-drilling is possible in this worksheet (like your excellent suggestion), but keeping a balance between “detailing” and “easy of us” is also essential.

      Let me try. I will try to improve the ‘impact of market cap’ of stocks on this worksheet without compromising the ease of use. I will surely use your suggestion.

      Thanks a lot.

  23. Hi Mani ji,

    how to include the column in CS sheet, in the excel it’s given till 2016, now if i want include 2017 what should i do? i already bought the sheet

    • You cannot include new columns. Just edit the tabs from 2016 to 2017, 2015 to 2016, 2014 to 2015…etc
      This worksheet works only with 10 years data. Adding new column will not help anyways.

  24. I was in search of such a tool since long time which will help in understanding whether the share is good or bad. This is one tool which logically arrives at a definite conclusion about the shares inherent strengths and weaknesses. It feels great to see myself working over shares data and arriving at a conclusion. I will give a full thumbs up to this worksheet. Though the procedure could be less lengthy but I can live with it. Thank you for developing this ‘one of its kind’ tool.

    • Thanks Vivek for your kind words. Keep analyzing more stocks using this worksheet. I will also request you to kindly share more of your experience with us.

  25. Nizarali Mahesania | June 28, 2017 at 7:57 pm | Reply

    feeding data time consuming, make it easy and user friendly

    • Dear Nizarali, You are right, feeding data initially may take more time. But eventually the time consumed reduces with practice. But the end-result of this effort can give you huge insights about your stocks. Do not worry about time consumed. Pro investors like Warren Buffett studies a company/stocks for years before its purchase. Give 1 hour time to each stock. Its worth an exercise.

  26. kishore madhana | June 28, 2017 at 7:56 pm | Reply

    I am getting error while filling some cells that cell is protected and couldn’t update the cell . it is asking password to un-protect it.

    • Dear Kishore, you must be trying to edit those cells which are protected. You do not need to edit the cells which are protected. The worksheet has been designed in this way. In case you have any doubts, please read the help sheet or watch the video guide.

  27. Aninda Sharma | June 19, 2017 at 7:10 am | Reply

    those are not 10 years old. there r no obsion to judge that perticular stock .like skipper ltd. kindly see the matter.

    • Hello Aninda, You are right. Skipper Ltd has been listed in NSE & BSE for less then 10 years. Investing in companies has established track record (in stock market) of more than 10 years is advisable. Imagine, it would have been lot easier for me to develop a worksheet which deals with only 5 years data. But I have chosen to go for 10 years. I have read and observed champion investors of this world. Their suggestion is to compute and analyze companies based on atleast 10 years data.

  28. anil biyani | May 29, 2017 at 9:50 pm | Reply

    Very good application. When every one is concentrating only on Technical Analysis, it was very helpful to use this excel sheet. Money is earned the hard way but you need to have a logical approach and have patience. If you follow the instructions given with the excel application, it will change your outlook and perspective for trading in the markets and reward you many times over.

  29. Hi,
    Your stock analysis worksheet is not applicable to banks (private or public), especially when considering various parameters in the balance sheet, profit loss and intrinsic valuation. Is there going to be an update in that regards? Please clarify.
    Thank you

    • Hello, Yes this worksheet is meant for non banking stocks. I am planning to develop a worksheet that works for banks as well. Update will take some time. Thanks for asking.

  30. Great work! The concept of manual entries is a very clever one as it informs you what is exactly required for anaylsis.

    • 1) It seems very difficult to find the Rf & Rp. Can you give me a link where I can find this.?
      2) For some stocks I get the IV as –ve. Ex. For Ashok Leyland see the pic. Do you think I am making some input errors?

      • Dear Anirudha,

        Rf & Rp are automatically calculated by the worksheet. These values will not be available on internet.

        It is possible to get a negative IV for some companies in this worksheet. It is a sign that the company is not generating enough “free cash flow” to fund its future growth. I will suggest that do not bother too much about the negative value. Try to develop an “overall impression” about the company from the “Analysis Sheet”. The analysis sheet takes care of the effect of intrinsic value of the stock on the overall rating.

  31. Does your program work on Apple (Mac) computers?

    • Hello Prakaash, Thanks for your query. This worksheet can work on Macbook but MS Office (Excel) must be installed in it.
      Just to clarify, what we offer is not a program. It is a simple MS Excel worksheet with few formulas embedded in it. Please see our video for more details.

  32. A Senthil Kumar | May 13, 2017 at 5:53 pm | Reply

    Grading can also be automated based on the calculations

    • Hello Senthil, I can fully understand your point. In fact the beta version of this worksheet was built on this line. It is easy and it can be implemented withing minutes. But I have intentionally not automated this step. When users puts “grades by self”, they are forced to think and become more “aware” of the stock they are dealing with. The purpose of this worksheet is to make people “learn” the process of stock analysis. Self grading of each and every parameter of a stock is a great learning experience. I hope you will agree.

  33. Gives great help to find multibagger stocks for investment.

  34. PATRIC ROZARIO | May 11, 2017 at 7:20 pm | Reply

    we expect all the required data regarding a company in your sight itself instead of making us search for it elsewhere.

    • Hello Patric, providing all stock data in my blog will be impossible. But the new updated version has been tailor made such that all stock data will be available in single location (moneycontrol). You can also see the video guide for a detailed idea of how to use this worksheet to learn stock analysis.

  35. Gurudatta Kamath | May 11, 2017 at 1:12 pm | Reply

    Four Star

  36. Good

  37. Please Reduce some Manual Entry

    • I know that manual entry can be time taking and boring. But this is an essential process that must be followed to ‘learn’ effective stocks analysis. Too much automation will not help the idea of “learning”.


    • Sorry, but the email id you have provided in the form while making the payment was wrong. May be there was a typo error. But not problem, I will email you the worksheet on your correct email id. Please confirm.

      • Kaustubh Kapdoskar | May 11, 2017 at 7:05 am | Reply

        Thanks for your prompt and positive response.
        Looking ahead for such delightful experience in future.
        Kindly email the worksheet on my correct email id.

  39. Ram Prakash Agarwal | May 4, 2017 at 11:05 pm | Reply

    Great tool for stock analysis

  40. Great Worksheet, I earned more money because of your accurate analysis and before purchase any stock I checked what price should I buy or sell the stocks.Once again thanks for your great job and looking forward more sheets from you.

  41. Quite Insightful and informarmative

  42. Brilliant worksheet which makes stock Picking easier


  44. Really useful

  45. Captain Kenjle | May 4, 2017 at 11:01 pm | Reply

    The analysis procedure and thought process that has gone into compiling this worksheet is very commendable. It is very useful for all equity investors.

  46. Stock Analyis worksheet is really good. Ever since I bought the worksheet, I am analysing 2 to 3 companies per week. I am saving all those worksheets, so whenever I see if there is any correction in the market, I am checking my worksheets of my favourite stocks and if they come near the intrinsic value, I am buying it. This way I am buying quality companies at fair values. It helps me keep disciplined. Thanks sir for the worksheet.

  47. Ritesh Kaul | May 4, 2017 at 11:00 pm | Reply

    Good tool to understand the fundamental health of a company. Given 4 star as the 3rd sheet which is a grading sheet uses assumptions which can impact the overall scoring of the stock.

  48. Ganesh bhadke | May 4, 2017 at 10:59 pm | Reply

    Found good but complicate and not understood properly

  49. S.Lakshmi Narayanan | May 4, 2017 at 10:58 pm | Reply

    Though at first it is complicated to understand, it becomes easier with practice. It gives a good and strict frame work for evaluating a stock

  50. Satish S Varma | May 4, 2017 at 10:57 pm | Reply

    Excellent Excel sheet to work one for precision analysis

  51. Arun Bhaskar v | May 4, 2017 at 10:57 pm | Reply

    Its useful. Its easy to use also

Please post your comments here. It fuel us to write better...